Hi !
Last night something happened with my postgres database.
The macros not working, the graps are empty.
The zabbix log says:
2558:20130628:100535.815 [Z3005] query failed: [0] PGRES_FATAL_ERROR:ERROR: missing chunk number 0 for toast value 1013157 in pg_toast_
[select i.itemid,i.hostid,h.proxy_hostid,i.type,i.data_typ e,i.value_type,i.key_,i.snmp_community,i.snmp_oid, i.port,i.snmpv3_securityname,
I tried to reindex, vacuum the database. I realised, the zabbix/items table is corrupted.
SQL error:
ERROR: missing chunk number 0 for toast value 1013156 in pg_toast_2619
In statement:
SELECT * FROM (SELECT * FROM "public"."items") AS sub LIMIT 30 OFFSET 0
Do you have any ideas how to solve the database error ?
Thanks, Bob
Last night something happened with my postgres database.
The macros not working, the graps are empty.
The zabbix log says:
2558:20130628:100535.815 [Z3005] query failed: [0] PGRES_FATAL_ERROR:ERROR: missing chunk number 0 for toast value 1013157 in pg_toast_
[select i.itemid,i.hostid,h.proxy_hostid,i.type,i.data_typ e,i.value_type,i.key_,i.snmp_community,i.snmp_oid, i.port,i.snmpv3_securityname,
I tried to reindex, vacuum the database. I realised, the zabbix/items table is corrupted.
SQL error:
ERROR: missing chunk number 0 for toast value 1013156 in pg_toast_2619
In statement:
SELECT * FROM (SELECT * FROM "public"."items") AS sub LIMIT 30 OFFSET 0
Do you have any ideas how to solve the database error ?
Thanks, Bob
Comment