I am running Zabbix in containers except for PostgreSQL which is running on the host. After upgrading the host PostgreSQL from 16 to 17, the Zabbix server no longer connects to the database:
I can get a shell on the Zabbix container and view tables on the database:
This is what I see in the PostgresSQL logs...this error does repeat with the Zabbix server error:
Is PostgresSQL 17 expeced to work? Other things in my system might have changed and I cannot easily go back to PostgresSQL 16 so want to make sure before I debug further. I have looked for turning on increased debug logging on the Zabbix server container but haven't yet seen how to do do that.
Thanks,
John
Code:
docker compose up [+] Running 3/0 ✔ Container zabbix-docker-db-data-pgsql-1 Created 0.0s ✔ Container zabbix-docker-zabbix-web-nginx-pgsql-1 Created 0.0s ✔ Container zabbix-docker-zabbix-server-1 Created 0.0s Attaching to zabbix-server-1 zabbix-server-1 | ** Preparing Zabbix server zabbix-server-1 | ** Preparing database zabbix-server-1 | ** Using POSTGRES_USER variable from secret file zabbix-server-1 | ** Using POSTGRES_PASSWORD variable from secret file zabbix-server-1 | ******************** zabbix-server-1 | * DB_SERVER_HOST: myhost.mynetwork.prv zabbix-server-1 | * DB_SERVER_PORT: 5432 zabbix-server-1 | * DB_SERVER_DBNAME: zabbix zabbix-server-1 | * DB_SERVER_SCHEMA: public zabbix-server-1 | ******************** zabbix-server-1 | **** PostgreSQL server is not available. Waiting 5 seconds... zabbix-server-1 | **** PostgreSQL server is not available. Waiting 5 seconds... [snip repeating message]
Code:
docker exec -u root -t -i zabbix-docker-zabbix-server-1 /bin/bash
c6ff8c0d9643:/var/lib/zabbix# psql -U zabbix --host myhost.mynetwork.prv
psql (16.3, server 17.0 (Debian 17.0-1.pgdg120+1))
WARNING: psql major version 16, server major version 17.
Some psql features might not work.
Type "help" for help.
zabbix=> \c zabbix
psql (16.3, server 17.0 (Debian 17.0-1.pgdg120+1))
WARNING: psql major version 16, server major version 17.
Some psql features might not work.
You are now connected to database "zabbix" as user "zabbix".
zabbix=> \d
List of relations
Schema | Name | Type | Owner
--------+----------------------------+----------+--------
public | acknowledges | table | zabbix
public | actions | table | zabbix
public | alerts | table | zabbix
public | auditlog | table | zabbix[list of tables snipped]
Code:
2024-10-15 12:35:02.365 CDT [3325870] zabbix@zabbix ERROR: column d.daticulocale does not exist at character 289
2024-10-15 12:35:02.365 CDT [3325870] zabbix@zabbix HINT: Perhaps you meant to reference the column "d.datlocale".
2024-10-15 12:35:02.365 CDT [3325870] zabbix@zabbix STATEMENT: SELECT
d.datname as "Name",
pg_catalog.pg_get_userbyid(d.datdba) as "Owner",
pg_catalog.pg_encoding_to_char(d.encoding) as "Encoding",
CASE d.datlocprovider WHEN 'c' THEN 'libc' WHEN 'i' THEN 'icu' END AS "Locale Provider",
d.datcollate as "Collate",
d.datctype as "Ctype",
d.daticulocale as "ICU Locale",
d.daticurules as "ICU Rules",
pg_catalog.array_to_string(d.datacl, E'\n') AS "Access privileges"
FROM pg_catalog.pg_database d
ORDER BY 1;
Is PostgresSQL 17 expeced to work? Other things in my system might have changed and I cannot easily go back to PostgresSQL 16 so want to make sure before I debug further. I have looked for turning on increased debug logging on the Zabbix server container but haven't yet seen how to do do that.
Thanks,
John
Comment