Hi there,
I've run into quite a problem on my master server:
[root@XXX-zabmaster001 ~]# zabbix_server_mysql -n 10 -c /etc/zabbix/zabbix_server.conf
Converting tables .......................... ..zabbix_server_mysql [29712]: Error: [Z3005] Query failed: [3] Error writing file '/tmp/MY8Ur6fZ' (Errcode: 28) [update trends_uint set itemid=itemid+1001000000000000 where itemid>0]
.................................................. .......... done.
Zabbix server is up and running, but my logs tell me:
item for functionid: 2002000000048880
2506:20110907:113409.889 Expression [{1001000000048914}=0|(({2002000000048914}=1)&({100 1000000048915}<5))] cannot be evaluated: Could not obtain function and item for functionid: 2002000000048914
2506:20110907:113409.890 Expression [{1001000000050572}>5|(({2002000000050572}=1)&({100 1000000050573}>5))] cannot be evaluated: Could not obtain function and item for functionid: 2002000000050572
2506:20110907:113409.891 Expression [{1001000000050652}>5|(({2002000000050652}=1)&({100 1000000050653}>5))] cannot be evaluated: Could not obtain function and item for functionid: 2002000000050652
etc etc
While the server seems to be up and running, trying to ack something results in:
[ CEvent::acknowledge ] DB::reserveIds ID out of range for [acknowledges]
So, this can't be good. The only question I have now is if I have to put back my db backup? This takes a good 16hrs so will result in a loss of lot's of data…. but having an inconsistent database seems to be a much bigger problem…
Needless to say I still need to convert to DM....
(running 1.8.5. btw)
I've run into quite a problem on my master server:
[root@XXX-zabmaster001 ~]# zabbix_server_mysql -n 10 -c /etc/zabbix/zabbix_server.conf
Converting tables .......................... ..zabbix_server_mysql [29712]: Error: [Z3005] Query failed: [3] Error writing file '/tmp/MY8Ur6fZ' (Errcode: 28) [update trends_uint set itemid=itemid+1001000000000000 where itemid>0]
.................................................. .......... done.
Zabbix server is up and running, but my logs tell me:
item for functionid: 2002000000048880
2506:20110907:113409.889 Expression [{1001000000048914}=0|(({2002000000048914}=1)&({100 1000000048915}<5))] cannot be evaluated: Could not obtain function and item for functionid: 2002000000048914
2506:20110907:113409.890 Expression [{1001000000050572}>5|(({2002000000050572}=1)&({100 1000000050573}>5))] cannot be evaluated: Could not obtain function and item for functionid: 2002000000050572
2506:20110907:113409.891 Expression [{1001000000050652}>5|(({2002000000050652}=1)&({100 1000000050653}>5))] cannot be evaluated: Could not obtain function and item for functionid: 2002000000050652
etc etc
While the server seems to be up and running, trying to ack something results in:
[ CEvent::acknowledge ] DB::reserveIds ID out of range for [acknowledges]
So, this can't be good. The only question I have now is if I have to put back my db backup? This takes a good 16hrs so will result in a loss of lot's of data…. but having an inconsistent database seems to be a much bigger problem…
Needless to say I still need to convert to DM....
(running 1.8.5. btw)
Comment