Hello 
I want to ask about weird situation with my Zabbix Server - today i checked logs and i observe the problem with (propably) my database, but first some information about my Zabbix Server environment.
Zabbix Server:
OS: Ubuntu 20.04
Zabbix Server version: 5.2.5, not in HA.
Database:
OS: Ubuntu 16.04
External database - PostgreSQL
psql (PostgreSQL) 11.6
This DB is replicated.
-----------------------------------
Problem - logs: 16010:20220130:000859.108 [Z3005] query failed: [0] result is NULL [begin;]
16010:20220130:142015.017 [Z3005] query failed: [0] result is NULL [rollback;]
16010:20220130:142345.135 [Z3005] query failed: [0] result is NULL [begin;]
16010:20220130:142345.135 [Z3005] query failed: [0] result is NULL [rollback;]
16010:20220130:144555.262 [Z3005] query failed: [0] result is NULL [begin;]
16010:20220130:144555.262 [Z3005] query failed: [0] result is NULL [rollback;]
16010:20220130:164345.387 [Z3005] query failed: [0] result is NULL [begin;]
16010:20220130:164345.387 [Z3005] query failed: [0] result is NULL [rollback;]
16010:20220130:164521.488 [Z3005] query failed: [0] result is NULL [begin;]
16010:20220130:164521.488 [Z3005] query failed: [0] result is NULL [rollback;]
16010:20220130:164521.512 [Z3005] query failed: [0] result is NULL [begin;]
16010:20220130:164521.512 [Z3005] query failed: [0] result is NULL [rollback;]
16010:20220130:165248.229 [Z3005] query failed: [0] result is NULL [begin;]
16010:20220130:165248.229 [Z3005] query failed: [0] result is NULL [rollback;]
16010:20220130:170248.300 [Z3005] query failed: [0] result is NULL [begin;]
16010:20220130:170248.300 [Z3005] query failed: [0] result is NULL [rollback;]
16010:20220130:180345.402 [Z3005] query failed: [0] result is NULL [begin;]
16010:20220130:180345.402 [Z3005] query failed: [0] result is NULL [rollback;]
16010:20220130:185017.030 [Z3005] query failed: [0] result is NULL [begin;]
16010:20220130:185017.030 [Z3005] query failed: [0] result is NULL [rollback;]
16010:20220130:190017.466 [Z3005] query failed: [0] result is NULL [begin;]
16010:20220130:190017.466 [Z3005] query failed: [0] result is NULL [rollback;]
I noticed this problem few days ago but i didn't found any fix. In Internet are many informations about Z3005 but in this problems people had other logs - information.
Some additional informations about my Zabbix Server:
In Database logs i didnt noticed any problems with that problem, there was some problems with other things but i fixed it recently.
Can you help me with fixing this problem? How can i verify what is a source of this logs and what is generating this rows in my Zabbix server logs?
I will be very appreciate for any help
I want to ask about weird situation with my Zabbix Server - today i checked logs and i observe the problem with (propably) my database, but first some information about my Zabbix Server environment.
Zabbix Server:
OS: Ubuntu 20.04
Zabbix Server version: 5.2.5, not in HA.
Database:
OS: Ubuntu 16.04
External database - PostgreSQL
psql (PostgreSQL) 11.6
This DB is replicated.
-----------------------------------
Problem - logs: 16010:20220130:000859.108 [Z3005] query failed: [0] result is NULL [begin;]
16010:20220130:142015.017 [Z3005] query failed: [0] result is NULL [rollback;]
16010:20220130:142345.135 [Z3005] query failed: [0] result is NULL [begin;]
16010:20220130:142345.135 [Z3005] query failed: [0] result is NULL [rollback;]
16010:20220130:144555.262 [Z3005] query failed: [0] result is NULL [begin;]
16010:20220130:144555.262 [Z3005] query failed: [0] result is NULL [rollback;]
16010:20220130:164345.387 [Z3005] query failed: [0] result is NULL [begin;]
16010:20220130:164345.387 [Z3005] query failed: [0] result is NULL [rollback;]
16010:20220130:164521.488 [Z3005] query failed: [0] result is NULL [begin;]
16010:20220130:164521.488 [Z3005] query failed: [0] result is NULL [rollback;]
16010:20220130:164521.512 [Z3005] query failed: [0] result is NULL [begin;]
16010:20220130:164521.512 [Z3005] query failed: [0] result is NULL [rollback;]
16010:20220130:165248.229 [Z3005] query failed: [0] result is NULL [begin;]
16010:20220130:165248.229 [Z3005] query failed: [0] result is NULL [rollback;]
16010:20220130:170248.300 [Z3005] query failed: [0] result is NULL [begin;]
16010:20220130:170248.300 [Z3005] query failed: [0] result is NULL [rollback;]
16010:20220130:180345.402 [Z3005] query failed: [0] result is NULL [begin;]
16010:20220130:180345.402 [Z3005] query failed: [0] result is NULL [rollback;]
16010:20220130:185017.030 [Z3005] query failed: [0] result is NULL [begin;]
16010:20220130:185017.030 [Z3005] query failed: [0] result is NULL [rollback;]
16010:20220130:190017.466 [Z3005] query failed: [0] result is NULL [begin;]
16010:20220130:190017.466 [Z3005] query failed: [0] result is NULL [rollback;]
I noticed this problem few days ago but i didn't found any fix. In Internet are many informations about Z3005 but in this problems people had other logs - information.
Some additional informations about my Zabbix Server:
In Database logs i didnt noticed any problems with that problem, there was some problems with other things but i fixed it recently.
Can you help me with fixing this problem? How can i verify what is a source of this logs and what is generating this rows in my Zabbix server logs?
I will be very appreciate for any help
Attached Files
Comment