{"level":"info","ts":"2026-07-17T13:49:36.986645397Z","msg":"OS distribution is supported","logger":"instance-manager","logging_pod":"keycloak-db-1","entry":{"version":"13 (trixie)","deprecatedFrom":"2028-08-09T00:00:00Z","supportedUntil":"2030-06-30T00:00:00Z"}} {"level":"info","ts":"2026-07-17T13:49:36.98682179Z","msg":"Starting CloudNativePG Instance Manager","logger":"instance-manager","logging_pod":"keycloak-db-1","version":"1.28.4","build":{"Version":"1.28.4","Commit":"f74344b4d","Date":"2026-06-29"},"skipNameValidation":false} {"level":"info","ts":"2026-07-17T13:49:37.339519693Z","msg":"starting tablespace manager","logger":"instance-manager","logging_pod":"keycloak-db-1"} {"level":"info","ts":"2026-07-17T13:49:37.339603154Z","msg":"starting external server manager","logger":"instance-manager","logging_pod":"keycloak-db-1"} {"level":"info","ts":"2026-07-17T13:49:37.339631134Z","msg":"starting controller-runtime manager","logger":"instance-manager","logging_pod":"keycloak-db-1"} {"level":"info","ts":"2026-07-17T13:49:37.340041411Z","msg":"Starting EventSource","logger":"instance-manager","logging_pod":"keycloak-db-1","controller":"instance-cluster","controllerGroup":"postgresql.cnpg.io","controllerKind":"Cluster","source":"kind source: *v1.Cluster"} {"level":"info","ts":"2026-07-17T13:49:37.340098342Z","msg":"Starting EventSource","logger":"instance-manager","logging_pod":"keycloak-db-1","controller":"instance-database","controllerGroup":"postgresql.cnpg.io","controllerKind":"Database","source":"kind source: *v1.Cluster"} {"level":"info","ts":"2026-07-17T13:49:37.340290305Z","msg":"Starting EventSource","logger":"instance-manager","logging_pod":"keycloak-db-1","controller":"instance-database","controllerGroup":"postgresql.cnpg.io","controllerKind":"Database","source":"kind source: *v1.Database"} {"level":"info","ts":"2026-07-17T13:49:37.34061912Z","logger":"roles_reconciler","msg":"starting up the runnable","logger":"instance-manager","logging_pod":"keycloak-db-1"} {"level":"info","ts":"2026-07-17T13:49:37.34064337Z","logger":"roles_reconciler","msg":"setting up RoleSynchronizer loop","logger":"instance-manager","logging_pod":"keycloak-db-1"} {"level":"info","ts":"2026-07-17T13:49:37.3406493Z","msg":"Starting EventSource","logger":"instance-manager","logging_pod":"keycloak-db-1","controller":"instance-subscription","controllerGroup":"postgresql.cnpg.io","controllerKind":"Subscription","source":"kind source: *v1.Cluster"} {"level":"info","ts":"2026-07-17T13:49:37.343127819Z","msg":"Starting EventSource","logger":"instance-manager","logging_pod":"keycloak-db-1","controller":"instance-subscription","controllerGroup":"postgresql.cnpg.io","controllerKind":"Subscription","source":"kind source: *v1.Subscription"} {"level":"info","ts":"2026-07-17T13:49:37.34386206Z","msg":"Starting webserver","logger":"instance-manager","logging_pod":"keycloak-db-1","address":"localhost:8010","hasTLS":false} {"level":"info","ts":"2026-07-17T13:49:37.343960562Z","msg":"Starting webserver","logger":"instance-manager","logging_pod":"keycloak-db-1","address":":8000","hasTLS":true} {"level":"info","ts":"2026-07-17T13:49:37.343984842Z","msg":"Starting EventSource","logger":"instance-manager","logging_pod":"keycloak-db-1","controller":"instance-external-server","controllerGroup":"postgresql.cnpg.io","controllerKind":"Cluster","source":"kind source: *v1.Cluster"} {"level":"info","ts":"2026-07-17T13:49:37.344112114Z","msg":"Starting webserver","logger":"instance-manager","logging_pod":"keycloak-db-1","address":":9187","hasTLS":false} {"level":"info","ts":"2026-07-17T13:49:37.344129355Z","msg":"Installed configuration file","logger":"instance-manager","logging_pod":"keycloak-db-1","pgdata":"/var/lib/postgresql/data/pgdata","filename":"pg_ident.conf"} {"level":"info","ts":"2026-07-17T13:49:37.34440347Z","msg":"Starting EventSource","logger":"instance-manager","logging_pod":"keycloak-db-1","controller":"instance-publication","controllerGroup":"postgresql.cnpg.io","controllerKind":"Publication","source":"kind source: *v1.Cluster"} {"level":"info","ts":"2026-07-17T13:49:37.344522011Z","msg":"Starting EventSource","logger":"instance-manager","logging_pod":"keycloak-db-1","controller":"instance-publication","controllerGroup":"postgresql.cnpg.io","controllerKind":"Publication","source":"kind source: *v1.Publication"} {"level":"info","ts":"2026-07-17T13:49:37.34441673Z","msg":"Starting EventSource","logger":"instance-manager","logging_pod":"keycloak-db-1","controller":"instance-tablespaces","controllerGroup":"postgresql.cnpg.io","controllerKind":"Cluster","source":"kind source: *v1.Cluster"} {"level":"info","ts":"2026-07-17T13:49:37.541460514Z","msg":"Starting Controller","logger":"instance-manager","logging_pod":"keycloak-db-1","controller":"instance-cluster","controllerGroup":"postgresql.cnpg.io","controllerKind":"Cluster"} {"level":"info","ts":"2026-07-17T13:49:37.541497384Z","msg":"Starting workers","logger":"instance-manager","logging_pod":"keycloak-db-1","controller":"instance-cluster","controllerGroup":"postgresql.cnpg.io","controllerKind":"Cluster","worker count":1} {"level":"info","ts":"2026-07-17T13:49:37.541530785Z","msg":"Starting Controller","logger":"instance-manager","logging_pod":"keycloak-db-1","controller":"instance-database","controllerGroup":"postgresql.cnpg.io","controllerKind":"Database"} {"level":"info","ts":"2026-07-17T13:49:37.541558935Z","msg":"Starting workers","logger":"instance-manager","logging_pod":"keycloak-db-1","controller":"instance-database","controllerGroup":"postgresql.cnpg.io","controllerKind":"Database","worker count":1} {"level":"info","ts":"2026-07-17T13:49:37.546128907Z","msg":"Starting Controller","logger":"instance-manager","logging_pod":"keycloak-db-1","controller":"instance-subscription","controllerGroup":"postgresql.cnpg.io","controllerKind":"Subscription"} {"level":"info","ts":"2026-07-17T13:49:37.546159357Z","msg":"Starting workers","logger":"instance-manager","logging_pod":"keycloak-db-1","controller":"instance-subscription","controllerGroup":"postgresql.cnpg.io","controllerKind":"Subscription","worker count":1} {"level":"info","ts":"2026-07-17T13:49:37.546184008Z","msg":"Starting Controller","logger":"instance-manager","logging_pod":"keycloak-db-1","controller":"instance-tablespaces","controllerGroup":"postgresql.cnpg.io","controllerKind":"Cluster"} {"level":"info","ts":"2026-07-17T13:49:37.546187228Z","msg":"Starting workers","logger":"instance-manager","logging_pod":"keycloak-db-1","controller":"instance-tablespaces","controllerGroup":"postgresql.cnpg.io","controllerKind":"Cluster","worker count":1} {"level":"info","ts":"2026-07-17T13:49:37.546208158Z","msg":"Starting Controller","logger":"instance-manager","logging_pod":"keycloak-db-1","controller":"instance-external-server","controllerGroup":"postgresql.cnpg.io","controllerKind":"Cluster"} {"level":"info","ts":"2026-07-17T13:49:37.546221278Z","msg":"Starting Controller","logger":"instance-manager","logging_pod":"keycloak-db-1","controller":"instance-publication","controllerGroup":"postgresql.cnpg.io","controllerKind":"Publication"} {"level":"info","ts":"2026-07-17T13:49:37.546259169Z","msg":"Starting workers","logger":"instance-manager","logging_pod":"keycloak-db-1","controller":"instance-publication","controllerGroup":"postgresql.cnpg.io","controllerKind":"Publication","worker count":1} {"level":"info","ts":"2026-07-17T13:49:37.546249299Z","msg":"Starting workers","logger":"instance-manager","logging_pod":"keycloak-db-1","controller":"instance-external-server","controllerGroup":"postgresql.cnpg.io","controllerKind":"Cluster","worker count":1} {"level":"info","ts":"2026-07-17T13:49:37.557292522Z","msg":"Refreshed configuration file","logger":"instance-manager","logging_pod":"keycloak-db-1","controller":"instance-cluster","controllerGroup":"postgresql.cnpg.io","controllerKind":"Cluster","Cluster":{"name":"keycloak-db","namespace":"auth-system"},"namespace":"auth-system","name":"keycloak-db","reconcileID":"b338b0e8-2691-4ac4-80a6-d6938771826b","logging_pod":"keycloak-db-1","filename":"/controller/certificates/server.crt","secret":"keycloak-db-server"} {"level":"info","ts":"2026-07-17T13:49:37.560165517Z","msg":"Refreshed configuration file","logger":"instance-manager","logging_pod":"keycloak-db-1","controller":"instance-cluster","controllerGroup":"postgresql.cnpg.io","controllerKind":"Cluster","Cluster":{"name":"keycloak-db","namespace":"auth-system"},"namespace":"auth-system","name":"keycloak-db","reconcileID":"b338b0e8-2691-4ac4-80a6-d6938771826b","logging_pod":"keycloak-db-1","filename":"/controller/certificates/server.key","secret":"keycloak-db-server"} {"level":"info","ts":"2026-07-17T13:49:37.56678908Z","msg":"Refreshed configuration file","logger":"instance-manager","logging_pod":"keycloak-db-1","controller":"instance-cluster","controllerGroup":"postgresql.cnpg.io","controllerKind":"Cluster","Cluster":{"name":"keycloak-db","namespace":"auth-system"},"namespace":"auth-system","name":"keycloak-db","reconcileID":"b338b0e8-2691-4ac4-80a6-d6938771826b","logging_pod":"keycloak-db-1","filename":"/controller/certificates/streaming_replica.crt","secret":"keycloak-db-replication"} {"level":"info","ts":"2026-07-17T13:49:37.568294704Z","msg":"Refreshed configuration file","logger":"instance-manager","logging_pod":"keycloak-db-1","controller":"instance-cluster","controllerGroup":"postgresql.cnpg.io","controllerKind":"Cluster","Cluster":{"name":"keycloak-db","namespace":"auth-system"},"namespace":"auth-system","name":"keycloak-db","reconcileID":"b338b0e8-2691-4ac4-80a6-d6938771826b","logging_pod":"keycloak-db-1","filename":"/controller/certificates/streaming_replica.key","secret":"keycloak-db-replication"} {"level":"info","ts":"2026-07-17T13:49:37.572712053Z","msg":"Refreshed configuration file","logger":"instance-manager","logging_pod":"keycloak-db-1","controller":"instance-cluster","controllerGroup":"postgresql.cnpg.io","controllerKind":"Cluster","Cluster":{"name":"keycloak-db","namespace":"auth-system"},"namespace":"auth-system","name":"keycloak-db","reconcileID":"b338b0e8-2691-4ac4-80a6-d6938771826b","logging_pod":"keycloak-db-1","filename":"/controller/certificates/client-ca.crt","secret":"keycloak-db-ca"} {"level":"info","ts":"2026-07-17T13:49:37.575808371Z","msg":"Refreshed configuration file","logger":"instance-manager","logging_pod":"keycloak-db-1","controller":"instance-cluster","controllerGroup":"postgresql.cnpg.io","controllerKind":"Cluster","Cluster":{"name":"keycloak-db","namespace":"auth-system"},"namespace":"auth-system","name":"keycloak-db","reconcileID":"b338b0e8-2691-4ac4-80a6-d6938771826b","logging_pod":"keycloak-db-1","filename":"/controller/certificates/server-ca.crt","secret":"keycloak-db-ca"} {"level":"info","ts":"2026-07-17T13:49:37.577856063Z","msg":"Installed configuration file","logger":"instance-manager","logging_pod":"keycloak-db-1","controller":"instance-cluster","controllerGroup":"postgresql.cnpg.io","controllerKind":"Cluster","Cluster":{"name":"keycloak-db","namespace":"auth-system"},"namespace":"auth-system","name":"keycloak-db","reconcileID":"b338b0e8-2691-4ac4-80a6-d6938771826b","logging_pod":"keycloak-db-1","pgdata":"/var/lib/postgresql/data/pgdata","filename":"pg_hba.conf"} {"level":"info","ts":"2026-07-17T13:49:37.577972225Z","msg":"Detected running images","logger":"instance-manager","logging_pod":"keycloak-db-1","controller":"instance-cluster","controllerGroup":"postgresql.cnpg.io","controllerKind":"Cluster","Cluster":{"name":"keycloak-db","namespace":"auth-system"},"namespace":"auth-system","name":"keycloak-db","reconcileID":"b338b0e8-2691-4ac4-80a6-d6938771826b","logging_pod":"keycloak-db-1","runningImages":["harbor.atmosphere.dev/ghcr.io/cloudnative-pg/postgresql:18.4-202606221003-minimal-trixie@sha256:538f1b327b8dc7621a94aac79c9c3e5c50dfa29115a6c291e19372a5b876f415"]} {"level":"info","ts":"2026-07-17T13:49:37.583471441Z","msg":"Installed configuration file","logger":"instance-manager","logging_pod":"keycloak-db-1","controller":"instance-cluster","controllerGroup":"postgresql.cnpg.io","controllerKind":"Cluster","Cluster":{"name":"keycloak-db","namespace":"auth-system"},"namespace":"auth-system","name":"keycloak-db","reconcileID":"b338b0e8-2691-4ac4-80a6-d6938771826b","logging_pod":"keycloak-db-1","pgdata":"/var/lib/postgresql/data/pgdata","filename":"custom.conf"} {"level":"info","ts":"2026-07-17T13:49:37.583789616Z","msg":"Cluster status","logger":"instance-manager","logging_pod":"keycloak-db-1","controller":"instance-cluster","controllerGroup":"postgresql.cnpg.io","controllerKind":"Cluster","Cluster":{"name":"keycloak-db","namespace":"auth-system"},"namespace":"auth-system","name":"keycloak-db","reconcileID":"b338b0e8-2691-4ac4-80a6-d6938771826b","logging_pod":"keycloak-db-1","currentPrimary":"","targetPrimary":"keycloak-db-1","isReplicaCluster":false} {"level":"info","ts":"2026-07-17T13:49:37.583807466Z","msg":"First primary instance bootstrap, marking myself as primary","logger":"instance-manager","logging_pod":"keycloak-db-1","controller":"instance-cluster","controllerGroup":"postgresql.cnpg.io","controllerKind":"Cluster","Cluster":{"name":"keycloak-db","namespace":"auth-system"},"namespace":"auth-system","name":"keycloak-db","reconcileID":"b338b0e8-2691-4ac4-80a6-d6938771826b","logging_pod":"keycloak-db-1","currentPrimary":"","targetPrimary":"keycloak-db-1"} {"level":"info","ts":"2026-07-17T13:49:37.622525952Z","msg":"Extracting pg_controldata information","logger":"instance-manager","logging_pod":"keycloak-db-1","reason":"postmaster start up"} {"level":"info","ts":"2026-07-17T13:49:37.624487414Z","logger":"pg_controldata","msg":"pg_control version number: 1800\nCatalog version number: 202506291\nDatabase system identifier: 7663493690915561499\nDatabase cluster state: shut down\npg_control last modified: Fri Jul 17 13:49:30 2026\nLatest checkpoint location: 0/2000028\nLatest checkpoint's REDO location: 0/2000028\nLatest checkpoint's REDO WAL file: 000000010000000000000002\nLatest checkpoint's TimeLineID: 1\nLatest checkpoint's PrevTimeLineID: 1\nLatest checkpoint's full_page_writes: on\nLatest checkpoint's NextXID: 0:754\nLatest checkpoint's NextOID: 16386\nLatest checkpoint's NextMultiXactId: 1\nLatest checkpoint's NextMultiOffset: 0\nLatest checkpoint's oldestXID: 744\nLatest checkpoint's oldestXID's DB: 1\nLatest checkpoint's oldestActiveXID: 0\nLatest checkpoint's oldestMultiXid: 1\nLatest checkpoint's oldestMulti's DB: 1\nLatest checkpoint's oldestCommitTsXid:0\nLatest checkpoint's newestCommitTsXid:0\nTime of latest checkpoint: Fri Jul 17 13:49:29 2026\nFake LSN counter for unlogged rels: 0/3E8\nMinimum recovery ending location: 0/0\nMin recovery ending loc's timeline: 0\nBackup start location: 0/0\nBackup end location: 0/0\nEnd-of-backup record required: no\nwal_level setting: logical\nwal_log_hints setting: on\nmax_connections setting: 100\nmax_worker_processes setting: 60\nmax_wal_senders setting: 10\nmax_prepared_xacts setting: 0\nmax_locks_per_xact setting: 64\ntrack_commit_timestamp setting: off\nMaximum data alignment: 8\nDatabase block size: 8192\nBlocks per segment of large relation: 131072\nWAL block size: 8192\nBytes per WAL segment: 16777216\nMaximum length of identifiers: 64\nMaximum columns in an index: 32\nMaximum size of a TOAST chunk: 1996\nSize of a large-object chunk: 2048\nDate/time type storage: 64-bit integers\nFloat8 argument passing: by value\nData page checksum version: 1\nDefault char data signedness: signed\nMock authentication nonce: 286c158304626cec8d3c9b08a49680c2016e40257a7ebefd6ca28e66ccbb5cbc\n","pipe":"stdout","logging_pod":"keycloak-db-1"} {"level":"info","ts":"2026-07-17T13:49:37.624986471Z","msg":"postmaster started","logger":"instance-manager","logging_pod":"keycloak-db-1","postMasterPID":26} {"level":"info","ts":"2026-07-17T13:49:37.626652577Z","msg":"DB not available, will retry","logger":"instance-manager","logging_pod":"keycloak-db-1","err":"failed to connect to `user=postgres database=postgres`: /controller/run/.s.PGSQL.5432 (/controller/run): dial error: dial unix /controller/run/.s.PGSQL.5432: connect: no such file or directory"} {"level":"info","ts":"2026-07-17T13:49:37.631909019Z","msg":"Instance is still down, will retry in 1 second","logger":"instance-manager","logging_pod":"keycloak-db-1","controller":"instance-cluster","controllerGroup":"postgresql.cnpg.io","controllerKind":"Cluster","Cluster":{"name":"keycloak-db","namespace":"auth-system"},"namespace":"auth-system","name":"keycloak-db","reconcileID":"b338b0e8-2691-4ac4-80a6-d6938771826b","instance":"keycloak-db-1","cluster":"keycloak-db","namespace":"auth-system","logging_pod":"keycloak-db-1"} {"level":"info","ts":"2026-07-17T13:49:37.652739726Z","logger":"postgres","msg":"2026-07-17 13:49:37.652 UTC [26] LOG: redirecting log output to logging collector process","pipe":"stderr","logging_pod":"keycloak-db-1"} {"level":"info","ts":"2026-07-17T13:49:37.652782476Z","logger":"postgres","msg":"2026-07-17 13:49:37.652 UTC [26] HINT: Future log output will appear in directory \"/controller/log\".","pipe":"stderr","logging_pod":"keycloak-db-1"} {"level":"info","ts":"2026-07-17T13:49:37.653336385Z","logger":"postgres","msg":"record","logging_pod":"keycloak-db-1","record":{"log_time":"2026-07-17 13:49:37.652 UTC","process_id":"26","session_id":"6a5a32f1.1a","session_line_num":"1","session_start_time":"2026-07-17 13:49:37 UTC","transaction_id":"0","error_severity":"LOG","sql_state_code":"00000","message":"ending log output to stderr","hint":"Future log output will go to log destination \"csvlog\".","backend_type":"postmaster","query_id":"0"}} {"level":"info","ts":"2026-07-17T13:49:37.653527138Z","logger":"postgres","msg":"record","logging_pod":"keycloak-db-1","record":{"log_time":"2026-07-17 13:49:37.652 UTC","process_id":"26","session_id":"6a5a32f1.1a","session_line_num":"2","session_start_time":"2026-07-17 13:49:37 UTC","transaction_id":"0","error_severity":"LOG","sql_state_code":"00000","message":"starting PostgreSQL 18.4 (Debian 18.4-1.pgdg13+1) on x86_64-pc-linux-gnu, compiled by gcc (Debian 14.2.0-19) 14.2.0, 64-bit","backend_type":"postmaster","query_id":"0"}} {"level":"info","ts":"2026-07-17T13:49:37.653548388Z","logger":"postgres","msg":"record","logging_pod":"keycloak-db-1","record":{"log_time":"2026-07-17 13:49:37.652 UTC","process_id":"26","session_id":"6a5a32f1.1a","session_line_num":"3","session_start_time":"2026-07-17 13:49:37 UTC","transaction_id":"0","error_severity":"LOG","sql_state_code":"00000","message":"listening on IPv4 address \"0.0.0.0\", port 5432","backend_type":"postmaster","query_id":"0"}} {"level":"info","ts":"2026-07-17T13:49:37.653564898Z","logger":"postgres","msg":"record","logging_pod":"keycloak-db-1","record":{"log_time":"2026-07-17 13:49:37.652 UTC","process_id":"26","session_id":"6a5a32f1.1a","session_line_num":"4","session_start_time":"2026-07-17 13:49:37 UTC","transaction_id":"0","error_severity":"LOG","sql_state_code":"00000","message":"listening on IPv6 address \"::\", port 5432","backend_type":"postmaster","query_id":"0"}} {"level":"info","ts":"2026-07-17T13:49:37.653808202Z","logger":"postgres","msg":"2026-07-17 13:49:37.652 UTC [26] LOG: ending log output to stderr","source":"/controller/log/postgres","logging_pod":"keycloak-db-1"} {"level":"info","ts":"2026-07-17T13:49:37.653825672Z","logger":"postgres","msg":"2026-07-17 13:49:37.652 UTC [26] HINT: Future log output will go to log destination \"csvlog\".","source":"/controller/log/postgres","logging_pod":"keycloak-db-1"} {"level":"info","ts":"2026-07-17T13:49:37.657308617Z","logger":"postgres","msg":"record","logging_pod":"keycloak-db-1","record":{"log_time":"2026-07-17 13:49:37.657 UTC","process_id":"26","session_id":"6a5a32f1.1a","session_line_num":"5","session_start_time":"2026-07-17 13:49:37 UTC","transaction_id":"0","error_severity":"LOG","sql_state_code":"00000","message":"listening on Unix socket \"/controller/run/.s.PGSQL.5432\"","backend_type":"postmaster","query_id":"0"}} {"level":"info","ts":"2026-07-17T13:49:37.664859235Z","logger":"postgres","msg":"record","logging_pod":"keycloak-db-1","record":{"log_time":"2026-07-17 13:49:37.664 UTC","process_id":"34","session_id":"6a5a32f1.22","session_line_num":"1","session_start_time":"2026-07-17 13:49:37 UTC","transaction_id":"0","error_severity":"LOG","sql_state_code":"00000","message":"database system was shut down at 2026-07-17 13:49:30 UTC","backend_type":"startup","query_id":"0"}} {"level":"info","ts":"2026-07-17T13:49:37.670549154Z","logger":"postgres","msg":"record","logging_pod":"keycloak-db-1","record":{"log_time":"2026-07-17 13:49:37.670 UTC","process_id":"26","session_id":"6a5a32f1.1a","session_line_num":"6","session_start_time":"2026-07-17 13:49:37 UTC","transaction_id":"0","error_severity":"LOG","sql_state_code":"00000","message":"database system is ready to accept connections","backend_type":"postmaster","query_id":"0"}} {"level":"info","ts":"2026-07-17T13:49:37.720895772Z","msg":"Triggered a managed role reconciliation","logger":"instance-manager","logging_pod":"keycloak-db-1","controller":"instance-cluster","controllerGroup":"postgresql.cnpg.io","controllerKind":"Cluster","Cluster":{"name":"keycloak-db","namespace":"auth-system"},"namespace":"auth-system","name":"keycloak-db","reconcileID":"05a57083-9c4e-41f7-8d17-da159f2c130e","logging_pod":"keycloak-db-1","pending-roles":["keycloak"]} {"level":"info","ts":"2026-07-17T13:49:52.121188338Z","logger":"postgres","msg":"record","logging_pod":"keycloak-db-1","record":{"log_time":"2026-07-17 13:49:52.120 UTC","process_id":"32","session_id":"6a5a32f1.20","session_line_num":"1","session_start_time":"2026-07-17 13:49:37 UTC","transaction_id":"0","error_severity":"LOG","sql_state_code":"00000","message":"checkpoint starting: force wait","backend_type":"checkpointer","query_id":"0"}} {"level":"info","ts":"2026-07-17T13:49:54.250180794Z","logger":"postgres","msg":"record","logging_pod":"keycloak-db-1","record":{"log_time":"2026-07-17 13:49:54.249 UTC","process_id":"32","session_id":"6a5a32f1.20","session_line_num":"2","session_start_time":"2026-07-17 13:49:37 UTC","transaction_id":"0","error_severity":"LOG","sql_state_code":"00000","message":"checkpoint complete: wrote 21 buffers (0.1%), wrote 3 SLRU buffers; 0 WAL file(s) added, 0 removed, 0 recycled; write=2.112 s, sync=0.007 s, total=2.130 s; sync files=21, longest=0.004 s, average=0.001 s; distance=16384 kB, estimate=16384 kB; lsn=0/30000B8, redo lsn=0/3000028","backend_type":"checkpointer","query_id":"0"}} {"level":"info","ts":"2026-07-17T13:50:14.271864631Z","logger":"postgres","msg":"record","logging_pod":"keycloak-db-1","record":{"log_time":"2026-07-17 13:50:14.271 UTC","process_id":"32","session_id":"6a5a32f1.20","session_line_num":"3","session_start_time":"2026-07-17 13:49:37 UTC","transaction_id":"0","error_severity":"LOG","sql_state_code":"00000","message":"checkpoint starting: force wait","backend_type":"checkpointer","query_id":"0"}} {"level":"info","ts":"2026-07-17T13:50:14.336950316Z","logger":"postgres","msg":"record","logging_pod":"keycloak-db-1","record":{"log_time":"2026-07-17 13:50:14.336 UTC","process_id":"32","session_id":"6a5a32f1.20","session_line_num":"4","session_start_time":"2026-07-17 13:49:37 UTC","transaction_id":"0","error_severity":"LOG","sql_state_code":"00000","message":"checkpoint complete: wrote 0 buffers (0.0%), wrote 0 SLRU buffers; 0 WAL file(s) added, 0 removed, 0 recycled; write=0.001 s, sync=0.001 s, total=0.065 s; sync files=0, longest=0.000 s, average=0.000 s; distance=32768 kB, estimate=32768 kB; lsn=0/5000080, redo lsn=0/5000028","backend_type":"checkpointer","query_id":"0"}} {"level":"info","ts":"2026-07-17T13:50:30.398390294Z","logger":"database_reconciler","msg":"Reconciling database","logger":"instance-manager","logging_pod":"keycloak-db-1","controller":"instance-database","controllerGroup":"postgresql.cnpg.io","controllerKind":"Database","Database":{"name":"keycloak","namespace":"auth-system"},"namespace":"auth-system","name":"keycloak","reconcileID":"e939ca38-50a9-41c3-99f4-7812cac92ac4","databaseName":"keycloak","logging_pod":"keycloak-db-1"} {"level":"info","ts":"2026-07-17T13:50:30.481134625Z","logger":"database_reconciler","msg":"Reconciliation loop of database exited","logger":"instance-manager","logging_pod":"keycloak-db-1","controller":"instance-database","controllerGroup":"postgresql.cnpg.io","controllerKind":"Database","Database":{"name":"keycloak","namespace":"auth-system"},"namespace":"auth-system","name":"keycloak","reconcileID":"e939ca38-50a9-41c3-99f4-7812cac92ac4","databaseName":"keycloak","logging_pod":"keycloak-db-1"} {"level":"info","ts":"2026-07-17T13:51:29.185600746Z","logger":"postgres","msg":"record","logging_pod":"keycloak-db-1","record":{"log_time":"2026-07-17 13:51:29.185 UTC","user_name":"keycloak","database_name":"keycloak","process_id":"744","connection_from":"10.0.0.168:44002","session_id":"6a5a335d.2e8","session_line_num":"1","command_tag":"PARSE","session_start_time":"2026-07-17 13:51:25 UTC","virtual_transaction_id":"75/23","transaction_id":"0","error_severity":"ERROR","sql_state_code":"42P01","message":"relation \"public.migration_model\" does not exist","query":"SELECT ID, VERSION FROM public.MIGRATION_MODEL ORDER BY UPDATE_TIME DESC","query_pos":"25","application_name":"PostgreSQL JDBC Driver","backend_type":"client backend","query_id":"0"}} {"level":"info","ts":"2026-07-17T13:51:30.078448258Z","logger":"postgres","msg":"record","logging_pod":"keycloak-db-1","record":{"log_time":"2026-07-17 13:51:30.078 UTC","user_name":"keycloak","database_name":"keycloak","process_id":"744","connection_from":"10.0.0.168:44002","session_id":"6a5a335d.2e8","session_line_num":"2","command_tag":"PARSE","session_start_time":"2026-07-17 13:51:25 UTC","virtual_transaction_id":"75/24","transaction_id":"0","error_severity":"ERROR","sql_state_code":"42P01","message":"relation \"public.databasechangelog\" does not exist","query":"SELECT COUNT(*) FROM public.databasechangelog","query_pos":"22","application_name":"PostgreSQL JDBC Driver","backend_type":"client backend","query_id":"0"}} {"level":"info","ts":"2026-07-17T13:51:30.313337392Z","logger":"postgres","msg":"record","logging_pod":"keycloak-db-1","record":{"log_time":"2026-07-17 13:51:30.312 UTC","user_name":"keycloak","database_name":"keycloak","process_id":"745","connection_from":"10.0.0.168:44004","session_id":"6a5a3362.2e9","session_line_num":"1","command_tag":"PARSE","session_start_time":"2026-07-17 13:51:30 UTC","virtual_transaction_id":"78/20","transaction_id":"0","error_severity":"ERROR","sql_state_code":"42P01","message":"relation \"public.databasechangeloglock\" does not exist","query":"SELECT COUNT(*) FROM public.databasechangeloglock","query_pos":"22","application_name":"PostgreSQL JDBC Driver","backend_type":"client backend","query_id":"0"}} {"level":"info","ts":"2026-07-17T13:51:30.349465342Z","logger":"postgres","msg":"record","logging_pod":"keycloak-db-1","record":{"log_time":"2026-07-17 13:51:30.349 UTC","user_name":"keycloak","database_name":"keycloak","process_id":"744","connection_from":"10.0.0.168:44002","session_id":"6a5a335d.2e8","session_line_num":"3","command_tag":"PARSE","session_start_time":"2026-07-17 13:51:25 UTC","virtual_transaction_id":"75/26","transaction_id":"0","error_severity":"ERROR","sql_state_code":"42P01","message":"relation \"public.databasechangelog\" does not exist","query":"SELECT COUNT(*) FROM public.databasechangelog","query_pos":"22","application_name":"PostgreSQL JDBC Driver","backend_type":"client backend","query_id":"0"}} {"level":"info","ts":"2026-07-17T13:55:14.471981317Z","logger":"postgres","msg":"record","logging_pod":"keycloak-db-1","record":{"log_time":"2026-07-17 13:55:14.471 UTC","process_id":"32","session_id":"6a5a32f1.20","session_line_num":"5","session_start_time":"2026-07-17 13:49:37 UTC","transaction_id":"0","error_severity":"LOG","sql_state_code":"00000","message":"checkpoint starting: time","backend_type":"checkpointer","query_id":"0"}} {"level":"info","ts":"2026-07-17T13:57:40.422332289Z","logger":"postgres","msg":"record","logging_pod":"keycloak-db-1","record":{"log_time":"2026-07-17 13:57:40.422 UTC","process_id":"32","session_id":"6a5a32f1.20","session_line_num":"6","session_start_time":"2026-07-17 13:49:37 UTC","transaction_id":"0","error_severity":"LOG","sql_state_code":"00000","message":"checkpoint complete: wrote 1470 buffers (9.0%), wrote 2 SLRU buffers; 0 WAL file(s) added, 0 removed, 0 recycled; write=145.898 s, sync=0.038 s, total=145.952 s; sync files=878, longest=0.002 s, average=0.001 s; distance=26726 kB, estimate=32163 kB; lsn=0/704A328, redo lsn=0/6A198F8","backend_type":"checkpointer","query_id":"0"}}