Zabbix 1.5.2 - Nodes - Slideshows

[Palmertree]

I am seeing the following error in the zabbix_server.log on a child_node for syncing slide shows:

2426:20080507:001534 Query failed: [insert into node_cksum (nodeid,tablename,recordid,cksumtype,cksum) select 2,'slideshows',slideshowid,1,concat_ws(',',md5(nam e),delay) from slideshows where 1=1 and slideshowid between 200000000000000 and 299999999999999

[Sasha]

What error gives the SQL server? Please send more complete log file.

[Palmertree]

Every time the child node receives an invalid query from the master node, the child node stops sending history back to the master. I have to restart the child node.

More of my log below:


2372:20080507:050502 NODE 2: Sending history_uint_sync of node 2 to node 1 datalen 18160
2372:20080507:050502 NODE 2: Sending history_str_sync of node 2 to node 1 datalen 726
2372:20080507:050525 Query failed: [insert into node_cksum (nodeid,tablename,recordid,cksumtype,cksum) select 2,'slideshows',slideshowid,1,concat_ws(',',md5(nam e),delay) from slideshows where 1=1 and slideshowid between 200000000000000 and 299999999999999
2372:20080507:050525 NODE 2: Sending history_sync of node 2 to node 1 datalen 64193
2372:20080507:050526 NODE 2: Sending history_uint_sync of node 2 to node 1 datalen 47172
2372:20080507:050527 NODE 2: Sending history_str_sync of node 2 to node 1 datalen 2824
2372:20080507:050527 NODE 2: Sending history_sync of node 2 to node 1 datalen 16128
2372:20080507:050527 NODE 2: Sending history_uint_sync of node 2 to node 1 datalen 10129
2372:20080507:050528 NODE 2: Sending history_str_sync of node 2 to node 1 datalen 168
2372:20080507:050537 NODE 2: Sending history_sync of node 2 to node 1 datalen 29431
2372:20080507:050537 NODE 2: Sending history_uint_sync of node 2 to node 1 datalen 28820
2372:20080507:050537 NODE 2: Sending history_str_sync of node 2 to node 1 datalen 798
2372:20080507:050547 NODE 2: Sending history_sync of node 2 to node 1 datalen 38199
2372:20080507:050548 NODE 2: Sending history_uint_sync of node 2 to node 1 datalen 44224
2372:20080507:050549 NODE 2: Sending history_str_sync of node 2 to node 1 datalen 1384
2372:20080507:050557 NODE 2: Sending history_sync of node 2 to node 1 datalen 28176
2372:20080507:050558 NODE 2: Sending history_uint_sync of node 2 to node 1 datalen 31636
2372:20080507:050558 NODE 2: Sending history_str_sync of node 2 to node 1 datalen 1302
2372:20080507:050607 NODE 2: Sending history_sync of node 2 to node 1 datalen 25614
2372:20080507:050608 NODE 2: Sending history_uint_sync of node 2 to node 1 datalen 23813
2372:20080507:050608 NODE 2: Sending history_str_sync of node 2 to node 1 datalen 652
2372:20080507:050617 NODE 2: Sending history_sync of node 2 to node 1 datalen 30601
2372:20080507:050618 NODE 2: Sending history_uint_sync of node 2 to node 1 datalen 28914
2372:20080507:050619 NODE 2: Sending history_str_sync of node 2 to node 1 datalen 1134
2372:20080507:050627 NODE 2: Sending history_sync of node 2 to node 1 datalen 23523
2372:20080507:050627 NODE 2: Sending history_uint_sync of node 2 to node 1 datalen 25685
2372:20080507:050628 NODE 2: Sending history_str_sync of node 2 to node 1 datalen 1324
2372:20080507:050637 NODE 2: Sending history_sync of node 2 to node 1 datalen 29641
2372:20080507:050637 NODE 2: Sending history_uint_sync of node 2 to node 1 datalen 29694
2372:20080507:050638 NODE 2: Sending history_str_sync of node 2 to node 1 datalen 1432
2372:20080507:050647 NODE 2: Sending history_sync of node 2 to node 1 datalen 30269
2372:20080507:050648 NODE 2: Sending history_uint_sync of node 2 to node 1 datalen 31062
2372:20080507:050648 NODE 2: Sending history_str_sync of node 2 to node 1 datalen 1944
2372:20080507:050657 NODE 2: Sending history_sync of node 2 to node 1 datalen 23443
2372:20080507:050657 NODE 2: Sending history_uint_sync of node 2 to node 1 datalen 23831
2372:20080507:050658 NODE 2: Sending history_str_sync of node 2 to node 1 datalen 692
2372:20080507:050707 NODE 2: Sending history_sync of node 2 to node 1 datalen 33151
2372:20080507:050707 NODE 2: Sending history_uint_sync of node 2 to node 1 datalen 24177
2372:20080507:050708 NODE 2: Sending history_str_sync of node 2 to node 1 datalen 1366
2372:20080507:050729 Query failed: [insert into node_cksum (nodeid,tablename,recordid,cksumtype,cksum) select 2,'slideshows',slideshowid,1,concat_ws(',',md5(nam e),delay) from slideshows where 1=1 and slideshowid between 200000000000000 and 299999999999999
2372:20080507:050729 NODE 2: Sending history_sync of node 2 to node 1 datalen 55814
2372:20080507:050730 NODE 2: Sending history_uint_sync of node 2 to node 1 datalen 46329
2372:20080507:050731 NODE 2: Sending history_str_sync of node 2 to node 1 datalen 2172
2372:20080507:050731 NODE 2: Sending history_sync of node 2 to node 1 datalen 14695
2372:20080507:050731 NODE 2: Sending history_uint_sync of node 2 to node 1 datalen 11341
2372:20080507:050731 NODE 2: Sending history_str_sync of node 2 to node 1 datalen 306
2372:20080507:050741 NODE 2: Sending history_sync of node 2 to node 1 datalen 36996
2372:20080507:050742 NODE 2: Sending history_uint_sync of node 2 to node 1 datalen 41840
2372:20080507:050743 NODE 2: Sending history_str_sync of node 2 to node 1 datalen 2114
2372:20080507:050751 NODE 2: Sending history_sync of node 2 to node 1 datalen 31332
2372:20080507:050752 NODE 2: Sending history_uint_sync of node 2 to node 1 datalen 31362
2372:20080507:050752 NODE 2: Sending history_str_sync of node 2 to node 1 datalen 986
2372:20080507:050801 NODE 2: Sending history_sync of node 2 to node 1 datalen 32178
2372:20080507:050802 NODE 2: Sending history_uint_sync of node 2 to node 1 datalen 32979
2372:20080507:050802 NODE 2: Sending history_str_sync of node 2 to node 1 datalen 1366
2372:20080507:050812 NODE 2: Sending history_sync of node 2 to node 1 datalen 30609
2372:20080507:050812 NODE 2: Sending history_uint_sync of node 2 to node 1 datalen 30988
2372:20080507:050813 NODE 2: Sending history_str_sync of node 2 to node 1 datalen 914
2372:20080507:050821 NODE 2: Sending history_sync of node 2 to node 1 datalen 18789
2372:20080507:050821 NODE 2: Sending history_uint_sync of node 2 to node 1 datalen 19093
2372:20080507:050822 NODE 2: Sending history_str_sync of node 2 to node 1 datalen 680
2372:20080507:050831 NODE 2: Sending history_sync of node 2 to node 1 datalen 29784
2372:20080507:050831 NODE 2: Sending history_uint_sync of node 2 to node 1 datalen 29491
2372:20080507:050832 NODE 2: Sending history_str_sync of node 2 to node 1 datalen 1172
2372:20080507:050841 NODE 2: Sending history_sync of node 2 to node 1 datalen 30199
2372:20080507:050841 NODE 2: Sending history_uint_sync of node 2 to node 1 datalen 34357
2372:20080507:050842 NODE 2: Sending history_str_sync of node 2 to node 1 datalen 1852
2372:20080507:050851 NODE 2: Sending history_sync of node 2 to node 1 datalen 31993
2372:20080507:050852 NODE 2: Sending history_uint_sync of node 2 to node 1 datalen 31272
2372:20080507:050854 NODE 2: Sending history_str_sync of node 2 to node 1 datalen 1878
2372:20080507:050901 NODE 2: Sending history_sync of node 2 to node 1 datalen 20949
2372:20080507:050903 NODE 2: Sending history_uint_sync of node 2 to node 1 datalen 22960
2372:20080507:050903 NODE 2: Sending history_str_sync of node 2 to node 1 datalen 782
2372:20080507:050912 NODE 2: Sending history_sync of node 2 to node 1 datalen 36759
2372:20080507:050912 NODE 2: Sending history_uint_sync of node 2 to node 1 datalen 23331
2372:20080507:050913 NODE 2: Sending history_str_sync of node 2 to node 1 datalen 990
2372:20080507:051154 NODE 2: Sending configuration changes to master node 1 for node 2 datalen 92664
2372:20080507:051818 NODE 2: Received data from master node 1 for node 2 datalen 94144522
2372:20080507:065622 Query failed: [insert into node_cksum (nodeid,tablename,recordid,cksumtype,cksum) select 2,'items_applications',itemappid,1,concat_ws(',',a pplicationid,itemid) from items_applications where 1=1 and itemappid between 200000000000000 and 299999999999999 and itemappid=200100000034248

[Palmertree]

It seems like when the Master node sends a huge update to the child node, the child node just stops processing or sending out historical data to the master node. I will see if I can increase the debug level to 4 on the child node and get more information in the logs.