postgres | The files belonging to this database system will be owned by user "postgres". postgres | This user must also own the server process. postgres | postgres | The database cluster will be initialized with locale "en_US.utf8". postgres | The default database encoding has accordingly been set to "UTF8". postgres | The default text search configuration will be set to "english". postgres | postgres | Data page checksums are disabled. postgres | postgres | fixing permissions on existing directory /var/lib/postgresql/data ... ok postgres | creating subdirectories ... ok postgres | selecting dynamic shared memory implementation ... posix postgres | selecting default "max_connections" ... 100 postgres | selecting default "shared_buffers" ... 128MB postgres | selecting default time zone ... Etc/UTC postgres | creating configuration files ... ok postgres | running bootstrap script ... ok postgres | performing post-bootstrap initialization ... ok postgres | initdb: warning: enabling "trust" authentication for local connections postgres | initdb: hint: You can change this by editing pg_hba.conf or using the option -A, or --auth-local and --auth-host, the next time you run initdb. postgres | syncing data to disk ... ok postgres | postgres | postgres | Success. You can now start the database server using: postgres | postgres | pg_ctl -D /var/lib/postgresql/data -l logfile start postgres | postgres | waiting for server to start....2026-06-18 13:32:31.161 UTC [48] LOG: starting PostgreSQL 17.7 (Debian 17.7-3.pgdg13+1) on x86_64-pc-linux-gnu, compiled by gcc (Debian 14.2.0-19) 14.2.0, 64-bit postgres | 2026-06-18 13:32:31.164 UTC [48] LOG: listening on Unix socket "/var/run/postgresql/.s.PGSQL.5432" postgres | 2026-06-18 13:32:31.180 UTC [51] LOG: database system was shut down at 2026-06-18 13:32:30 UTC postgres | 2026-06-18 13:32:31.190 UTC [48] LOG: database system is ready to accept connections postgres | done postgres | server started postgres | postgres | /usr/local/bin/docker-entrypoint.sh: ignoring /docker-entrypoint-initdb.d/db-pg.conf postgres | postgres | /usr/local/bin/docker-entrypoint.sh: running /docker-entrypoint-initdb.d/db-pg.sh postgres | #!/bin/bash -xv postgres | # Copyright (C) 2022,2024,2026 OpenInfra Foundation Europe. All rights reserved. postgres | # postgres | # Licensed under the Apache License, Version 2.0 (the "License"); postgres | # you may not use this file except in compliance with the License. postgres | # You may obtain a copy of the License at postgres | # postgres | # http://www.apache.org/licenses/LICENSE-2.0 postgres | # postgres | # Unless required by applicable law or agreed to in writing, software postgres | # distributed under the License is distributed on an "AS IS" BASIS, postgres | # WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. postgres | # See the License for the specific language governing permissions and postgres | # limitations under the License. postgres | postgres | psql -U postgres -d postgres --command "CREATE USER ${PGSQL_USER} WITH PASSWORD '${PGSQL_PASSWORD}';" postgres | + psql -U postgres -d postgres --command 'CREATE USER policy_user WITH PASSWORD '\''policy_user'\'';' postgres | CREATE ROLE postgres | psql -U postgres -d postgres --command "CREATE DATABASE clampacm;" postgres | + psql -U postgres -d postgres --command 'CREATE DATABASE clampacm;' postgres | CREATE DATABASE postgres | psql -U postgres -d postgres --command "ALTER DATABASE clampacm OWNER TO ${PGSQL_USER} ;" postgres | + psql -U postgres -d postgres --command 'ALTER DATABASE clampacm OWNER TO policy_user ;' postgres | psql -U postgres -d postgres --command "GRANT ALL PRIVILEGES ON DATABASE clampacm TO ${PGSQL_USER} ;" postgres | + psql -U postgres -d postgres --command 'GRANT ALL PRIVILEGES ON DATABASE clampacm TO policy_user ;' postgres | ALTER DATABASE postgres | GRANT postgres | postgres | waiting for server to shut down....2026-06-18 13:32:31.626 UTC [48] LOG: received fast shutdown request postgres | 2026-06-18 13:32:31.627 UTC [48] LOG: aborting any active transactions postgres | 2026-06-18 13:32:31.629 UTC [48] LOG: background worker "logical replication launcher" (PID 54) exited with exit code 1 postgres | 2026-06-18 13:32:31.630 UTC [49] LOG: shutting down postgres | 2026-06-18 13:32:31.631 UTC [49] LOG: checkpoint starting: shutdown immediate postgres | 2026-06-18 13:32:31.755 UTC [49] LOG: checkpoint complete: wrote 934 buffers (5.7%); 0 WAL file(s) added, 0 removed, 0 recycled; write=0.074 s, sync=0.041 s, total=0.125 s; sync files=308, longest=0.010 s, average=0.001 s; distance=4260 kB, estimate=4260 kB; lsn=0/1916A78, redo lsn=0/1916A78 postgres | 2026-06-18 13:32:31.761 UTC [48] LOG: database system is shut down postgres | done postgres | server stopped postgres | postgres | PostgreSQL init process complete; ready for start up. postgres | postgres | 2026-06-18 13:32:31.849 UTC [1] LOG: starting PostgreSQL 17.7 (Debian 17.7-3.pgdg13+1) on x86_64-pc-linux-gnu, compiled by gcc (Debian 14.2.0-19) 14.2.0, 64-bit postgres | 2026-06-18 13:32:31.849 UTC [1] LOG: listening on IPv4 address "0.0.0.0", port 5432 postgres | 2026-06-18 13:32:31.849 UTC [1] LOG: listening on IPv6 address "::", port 5432 postgres | 2026-06-18 13:32:31.854 UTC [1] LOG: listening on Unix socket "/var/run/postgresql/.s.PGSQL.5432" postgres | 2026-06-18 13:32:31.862 UTC [71] LOG: database system was shut down at 2026-06-18 13:32:31 UTC postgres | 2026-06-18 13:32:31.868 UTC [1] LOG: database system is ready to accept connections postgres | 2026-06-18 13:32:51.528 UTC [98] ERROR: relation "databasechangelog" already exists postgres | 2026-06-18 13:32:51.528 UTC [98] STATEMENT: CREATE TABLE public.databasechangelog (ID VARCHAR(255) NOT NULL, AUTHOR VARCHAR(255) NOT NULL, FILENAME VARCHAR(255) NOT NULL, DATEEXECUTED TIMESTAMP WITHOUT TIME ZONE NOT NULL, ORDEREXECUTED INTEGER NOT NULL, EXECTYPE VARCHAR(10) NOT NULL, MD5SUM VARCHAR(35), DESCRIPTION VARCHAR(255), COMMENTS VARCHAR(255), TAG VARCHAR(255), LIQUIBASE VARCHAR(20), CONTEXTS VARCHAR(255), LABELS VARCHAR(255), DEPLOYMENT_ID VARCHAR(10)) postgres | 2026-06-18 13:34:29.385 UTC [97] ERROR: duplicate key value violates unique constraint "messagejob_identificationid_index" postgres | 2026-06-18 13:34:29.385 UTC [97] DETAIL: Key (identificationid)=(dd36aaa4-580f-4193-a52b-37c3a955b11a) already exists. postgres | 2026-06-18 13:34:29.385 UTC [97] STATEMENT: insert into MessageJob (identificationId,jobStarted,jobId) values ($1,$2,$3) postgres | 2026-06-18 13:34:55.101 UTC [142] ERROR: duplicate key value violates unique constraint "messagejob_identificationid_index" postgres | 2026-06-18 13:34:55.101 UTC [142] DETAIL: Key (identificationid)=(6c1cf107-a2ca-4485-8129-02f9fae64d64) already exists. postgres | 2026-06-18 13:34:55.101 UTC [142] STATEMENT: insert into MessageJob (identificationId,jobStarted,jobId) values ($1,$2,$3) postgres | 2026-06-18 13:35:11.796 UTC [97] ERROR: duplicate key value violates unique constraint "messagejob_identificationid_index" postgres | 2026-06-18 13:35:11.796 UTC [97] DETAIL: Key (identificationid)=(d30b8017-4d64-4693-84d7-de9c4226b9f8) already exists. postgres | 2026-06-18 13:35:11.796 UTC [97] STATEMENT: insert into MessageJob (identificationId,jobStarted,jobId) values ($1,$2,$3) postgres | 2026-06-18 13:35:55.303 UTC [97] ERROR: duplicate key value violates unique constraint "messagejob_identificationid_index" postgres | 2026-06-18 13:35:55.303 UTC [97] DETAIL: Key (identificationid)=(241d4f7a-2717-4574-b4a3-73aa6551b20c) already exists. postgres | 2026-06-18 13:35:55.303 UTC [97] STATEMENT: insert into MessageJob (identificationId,jobStarted,jobId) values ($1,$2,$3) postgres | 2026-06-18 13:36:27.622 UTC [142] ERROR: duplicate key value violates unique constraint "messagejob_identificationid_index" postgres | 2026-06-18 13:36:27.622 UTC [142] DETAIL: Key (identificationid)=(241d4f7a-2717-4574-b4a3-73aa6551b20c) already exists. postgres | 2026-06-18 13:36:27.622 UTC [142] STATEMENT: insert into MessageJob (identificationId,jobStarted,jobId) values ($1,$2,$3) postgres | 2026-06-18 13:36:43.802 UTC [142] ERROR: duplicate key value violates unique constraint "messagejob_identificationid_index" postgres | 2026-06-18 13:36:43.802 UTC [142] DETAIL: Key (identificationid)=(a869b35e-4e42-41d8-a993-d24067aaf2ab) already exists. postgres | 2026-06-18 13:36:43.802 UTC [142] STATEMENT: insert into MessageJob (identificationId,jobStarted,jobId) values ($1,$2,$3) postgres | 2026-06-18 13:36:55.302 UTC [97] ERROR: duplicate key value violates unique constraint "messagejob_identificationid_index" postgres | 2026-06-18 13:36:55.302 UTC [97] DETAIL: Key (identificationid)=(e7fc5d7a-f7f5-424e-9fa2-01ac782a9914) already exists. postgres | 2026-06-18 13:36:55.302 UTC [97] STATEMENT: insert into MessageJob (identificationId,jobStarted,jobId) values ($1,$2,$3) postgres | 2026-06-18 13:37:22.723 UTC [142] ERROR: duplicate key value violates unique constraint "messagejob_identificationid_index" postgres | 2026-06-18 13:37:22.723 UTC [142] DETAIL: Key (identificationid)=(172ade9d-62be-47f7-b579-40a35ec58416) already exists. postgres | 2026-06-18 13:37:22.723 UTC [142] STATEMENT: insert into MessageJob (identificationId,jobStarted,jobId) values ($1,$2,$3) postgres | 2026-06-18 13:37:31.914 UTC [69] LOG: checkpoint starting: time postgres | 2026-06-18 13:37:39.740 UTC [142] ERROR: duplicate key value violates unique constraint "messagejob_identificationid_index" postgres | 2026-06-18 13:37:39.740 UTC [142] DETAIL: Key (identificationid)=(7741ba14-9e75-4282-8d1b-1b3324e6d466) already exists. postgres | 2026-06-18 13:37:39.740 UTC [142] STATEMENT: insert into MessageJob (identificationId,jobStarted,jobId) values ($1,$2,$3) postgres | 2026-06-18 13:37:41.270 UTC [97] ERROR: duplicate key value violates unique constraint "messagejob_identificationid_index" postgres | 2026-06-18 13:37:41.270 UTC [97] DETAIL: Key (identificationid)=(7741ba14-9e75-4282-8d1b-1b3324e6d466) already exists. postgres | 2026-06-18 13:37:41.270 UTC [97] STATEMENT: insert into MessageJob (identificationId,jobStarted,jobId) values ($1,$2,$3) postgres | 2026-06-18 13:37:44.157 UTC [142] ERROR: duplicate key value violates unique constraint "messagejob_identificationid_index" postgres | 2026-06-18 13:37:44.157 UTC [142] DETAIL: Key (identificationid)=(7741ba14-9e75-4282-8d1b-1b3324e6d466) already exists. postgres | 2026-06-18 13:37:44.157 UTC [142] STATEMENT: insert into MessageJob (identificationId,jobStarted,jobId) values ($1,$2,$3) postgres | 2026-06-18 13:37:45.436 UTC [142] ERROR: duplicate key value violates unique constraint "messagejob_identificationid_index" postgres | 2026-06-18 13:37:45.436 UTC [142] DETAIL: Key (identificationid)=(7741ba14-9e75-4282-8d1b-1b3324e6d466) already exists. postgres | 2026-06-18 13:37:45.436 UTC [142] STATEMENT: insert into MessageJob (identificationId,jobStarted,jobId) values ($1,$2,$3) postgres | 2026-06-18 13:37:46.736 UTC [142] ERROR: duplicate key value violates unique constraint "messagejob_identificationid_index" postgres | 2026-06-18 13:37:46.736 UTC [142] DETAIL: Key (identificationid)=(7741ba14-9e75-4282-8d1b-1b3324e6d466) already exists. postgres | 2026-06-18 13:37:46.736 UTC [142] STATEMENT: insert into MessageJob (identificationId,jobStarted,jobId) values ($1,$2,$3) postgres | 2026-06-18 13:37:56.348 UTC [142] ERROR: duplicate key value violates unique constraint "messagejob_identificationid_index" postgres | 2026-06-18 13:37:56.348 UTC [142] DETAIL: Key (identificationid)=(7741ba14-9e75-4282-8d1b-1b3324e6d466) already exists. postgres | 2026-06-18 13:37:56.348 UTC [142] STATEMENT: insert into MessageJob (identificationId,jobStarted,jobId) values ($1,$2,$3) postgres | 2026-06-18 13:37:57.415 UTC [69] LOG: checkpoint complete: wrote 237 buffers (1.4%); 0 WAL file(s) added, 0 removed, 0 recycled; write=24.585 s, sync=0.383 s, total=25.502 s; sync files=131, longest=0.121 s, average=0.003 s; distance=1342 kB, estimate=1342 kB; lsn=0/1A81368, redo lsn=0/1A66658 postgres | 2026-06-18 13:37:57.588 UTC [97] ERROR: duplicate key value violates unique constraint "messagejob_identificationid_index" postgres | 2026-06-18 13:37:57.588 UTC [97] DETAIL: Key (identificationid)=(7741ba14-9e75-4282-8d1b-1b3324e6d466) already exists. postgres | 2026-06-18 13:37:57.588 UTC [97] STATEMENT: insert into MessageJob (identificationId,jobStarted,jobId) values ($1,$2,$3) postgres | 2026-06-18 13:38:02.673 UTC [97] ERROR: duplicate key value violates unique constraint "messagejob_identificationid_index" postgres | 2026-06-18 13:38:02.673 UTC [97] DETAIL: Key (identificationid)=(7741ba14-9e75-4282-8d1b-1b3324e6d466) already exists. postgres | 2026-06-18 13:38:02.673 UTC [97] STATEMENT: insert into MessageJob (identificationId,jobStarted,jobId) values ($1,$2,$3) postgres | 2026-06-18 13:40:05.145 UTC [142] ERROR: duplicate key value violates unique constraint "messagejob_identificationid_index" postgres | 2026-06-18 13:40:05.145 UTC [142] DETAIL: Key (identificationid)=(7741ba14-9e75-4282-8d1b-1b3324e6d466) already exists. postgres | 2026-06-18 13:40:05.145 UTC [142] STATEMENT: insert into MessageJob (identificationId,jobStarted,jobId) values ($1,$2,$3) postgres | 2026-06-18 13:40:16.101 UTC [142] ERROR: duplicate key value violates unique constraint "messagejob_identificationid_index" postgres | 2026-06-18 13:40:16.101 UTC [142] DETAIL: Key (identificationid)=(7741ba14-9e75-4282-8d1b-1b3324e6d466) already exists. postgres | 2026-06-18 13:40:16.101 UTC [142] STATEMENT: insert into MessageJob (identificationId,jobStarted,jobId) values ($1,$2,$3) postgres | 2026-06-18 13:40:21.476 UTC [142] ERROR: duplicate key value violates unique constraint "messagejob_identificationid_index" postgres | 2026-06-18 13:40:21.476 UTC [142] DETAIL: Key (identificationid)=(7741ba14-9e75-4282-8d1b-1b3324e6d466) already exists. postgres | 2026-06-18 13:40:21.476 UTC [142] STATEMENT: insert into MessageJob (identificationId,jobStarted,jobId) values ($1,$2,$3) postgres | 2026-06-18 13:40:27.246 UTC [97] ERROR: duplicate key value violates unique constraint "messagejob_identificationid_index" postgres | 2026-06-18 13:40:27.246 UTC [97] DETAIL: Key (identificationid)=(7741ba14-9e75-4282-8d1b-1b3324e6d466) already exists. postgres | 2026-06-18 13:40:27.246 UTC [97] STATEMENT: insert into MessageJob (identificationId,jobStarted,jobId) values ($1,$2,$3) postgres | 2026-06-18 13:40:39.744 UTC [97] ERROR: duplicate key value violates unique constraint "messagejob_identificationid_index" postgres | 2026-06-18 13:40:39.744 UTC [97] DETAIL: Key (identificationid)=(7741ba14-9e75-4282-8d1b-1b3324e6d466) already exists. postgres | 2026-06-18 13:40:39.744 UTC [97] STATEMENT: insert into MessageJob (identificationId,jobStarted,jobId) values ($1,$2,$3) postgres | 2026-06-18 13:40:44.148 UTC [142] ERROR: duplicate key value violates unique constraint "messagejob_identificationid_index" postgres | 2026-06-18 13:40:44.148 UTC [142] DETAIL: Key (identificationid)=(7741ba14-9e75-4282-8d1b-1b3324e6d466) already exists. postgres | 2026-06-18 13:40:44.148 UTC [142] STATEMENT: insert into MessageJob (identificationId,jobStarted,jobId) values ($1,$2,$3) postgres | 2026-06-18 13:41:05.637 UTC [97] ERROR: duplicate key value violates unique constraint "messagejob_identificationid_index" postgres | 2026-06-18 13:41:05.637 UTC [97] DETAIL: Key (identificationid)=(7741ba14-9e75-4282-8d1b-1b3324e6d466) already exists. postgres | 2026-06-18 13:41:05.637 UTC [97] STATEMENT: insert into MessageJob (identificationId,jobStarted,jobId) values ($1,$2,$3) postgres | 2026-06-18 13:41:21.991 UTC [142] ERROR: duplicate key value violates unique constraint "messagejob_identificationid_index" postgres | 2026-06-18 13:41:21.991 UTC [142] DETAIL: Key (identificationid)=(8fb6154d-3c51-418e-9c01-c9cc13eb7fc5) already exists. postgres | 2026-06-18 13:41:21.991 UTC [142] STATEMENT: insert into MessageJob (identificationId,jobStarted,jobId) values ($1,$2,$3) postgres | 2026-06-18 13:41:38.571 UTC [142] ERROR: duplicate key value violates unique constraint "messagejob_identificationid_index" postgres | 2026-06-18 13:41:38.571 UTC [142] DETAIL: Key (identificationid)=(8fb6154d-3c51-418e-9c01-c9cc13eb7fc5) already exists. postgres | 2026-06-18 13:41:38.571 UTC [142] STATEMENT: insert into MessageJob (identificationId,jobStarted,jobId) values ($1,$2,$3) postgres | 2026-06-18 13:41:54.929 UTC [97] ERROR: duplicate key value violates unique constraint "messagejob_identificationid_index" postgres | 2026-06-18 13:41:54.929 UTC [97] DETAIL: Key (identificationid)=(78a063a8-b1d6-4b20-bb89-38ce84bf33d5) already exists. postgres | 2026-06-18 13:41:54.929 UTC [97] STATEMENT: insert into MessageJob (identificationId,jobStarted,jobId) values ($1,$2,$3) postgres | 2026-06-18 13:42:03.675 UTC [97] ERROR: duplicate key value violates unique constraint "messagejob_identificationid_index" postgres | 2026-06-18 13:42:03.675 UTC [97] DETAIL: Key (identificationid)=(78a063a8-b1d6-4b20-bb89-38ce84bf33d5) already exists. postgres | 2026-06-18 13:42:03.675 UTC [97] STATEMENT: insert into MessageJob (identificationId,jobStarted,jobId) values ($1,$2,$3) postgres | 2026-06-18 13:42:11.382 UTC [142] ERROR: duplicate key value violates unique constraint "messagejob_identificationid_index" postgres | 2026-06-18 13:42:11.382 UTC [142] DETAIL: Key (identificationid)=(78a063a8-b1d6-4b20-bb89-38ce84bf33d5) already exists. postgres | 2026-06-18 13:42:11.382 UTC [142] STATEMENT: insert into MessageJob (identificationId,jobStarted,jobId) values ($1,$2,$3) postgres | 2026-06-18 13:42:16.769 UTC [97] ERROR: duplicate key value violates unique constraint "messagejob_identificationid_index" postgres | 2026-06-18 13:42:16.769 UTC [97] DETAIL: Key (identificationid)=(78a063a8-b1d6-4b20-bb89-38ce84bf33d5) already exists. postgres | 2026-06-18 13:42:16.769 UTC [97] STATEMENT: insert into MessageJob (identificationId,jobStarted,jobId) values ($1,$2,$3) postgres | 2026-06-18 13:42:27.549 UTC [97] ERROR: duplicate key value violates unique constraint "messagejob_identificationid_index" postgres | 2026-06-18 13:42:27.549 UTC [97] DETAIL: Key (identificationid)=(e7fc5d7a-f7f5-424e-9fa2-01ac782a9914) already exists. postgres | 2026-06-18 13:42:27.549 UTC [97] STATEMENT: insert into MessageJob (identificationId,jobStarted,jobId) values ($1,$2,$3) postgres | 2026-06-18 13:42:31.514 UTC [69] LOG: checkpoint starting: time postgres | 2026-06-18 13:42:33.033 UTC [142] ERROR: duplicate key value violates unique constraint "messagejob_identificationid_index" postgres | 2026-06-18 13:42:33.033 UTC [142] DETAIL: Key (identificationid)=(e7fc5d7a-f7f5-424e-9fa2-01ac782a9914) already exists. postgres | 2026-06-18 13:42:33.033 UTC [142] STATEMENT: insert into MessageJob (identificationId,jobStarted,jobId) values ($1,$2,$3) postgres | 2026-06-18 13:42:36.313 UTC [69] LOG: checkpoint complete: wrote 48 buffers (0.3%); 0 WAL file(s) added, 0 removed, 0 recycled; write=4.683 s, sync=0.038 s, total=4.800 s; sync files=29, longest=0.012 s, average=0.002 s; distance=700 kB, estimate=1278 kB; lsn=0/1B22150, redo lsn=0/1B158A8 postgres | 2026-06-18 13:42:43.824 UTC [142] ERROR: duplicate key value violates unique constraint "messagejob_identificationid_index" postgres | 2026-06-18 13:42:43.824 UTC [142] DETAIL: Key (identificationid)=(b91aa3a8-48e3-4d57-812c-eaa594230101) already exists. postgres | 2026-06-18 13:42:43.824 UTC [142] STATEMENT: insert into MessageJob (identificationId,jobStarted,jobId) values ($1,$2,$3)