1.8 branch from monday

distributed monitoring synchronisation fails :
(sql errors visible both on child & master nodes)

4535:20100910:143019.424 [Z3005] Query failed: [1064] You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'all select curr.tablename,curr.recordid,prev.cksum,curr.cksum,curr.sync from nod' at line 1 [select curr.tablename,curr.recordid,prev.cksum,curr.cksum,prev.sync from node_cksum curr, node_cksum prev where curr.nodeid=194 and prev.nodeid=curr.nodeid and curr.tablename=prev.tablename and curr.recordid=prev.recordid and curr.cksumtype=1 and prev.cksumtype=0 and curr.cksum<>prev.cksumunion all select curr.tablename,curr.recordid,prev.cksum,curr.cksum,curr.sync from node_cksum curr left join node_cksum prev on prev.nodeid=curr.nodeid and prev.tablename=curr.tablename and prev.recordid=curr.recordid and prev.cksumtype=0 where curr.nodeid=194 and curr.cksumtype=1 and prev.tablename is null union all select prev.tablename,prev.recordid,prev.cksum,curr.cksum,prev.sync from node_cksum prev left join node_cksum curr on curr.nodeid=prev.nodeid and curr.tablename=prev.tablename and curr.recordid=prev.recordid and curr.cksumtype=1 where prev.nodeid=194 and prev.cksumtype=0 and curr.tablename is null]
4535:20100910:143019.424 NODE 225: Sending configuration changes to master node 212 for node 194 datalen 12
4535:20100910:143019.500 [Z3005] Query failed: [1064] You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'all select curr.tablename,curr.recordid,prev.cksum,curr.cksum,NULL from node_cks' at line 1 [select curr.tablename,curr.recordid,prev.cksum,curr.cksum,prev.sync from node_cksum curr, node_cksum prev where curr.nodeid=194 and prev.nodeid=curr.nodeid and curr.tablename=prev.tablename and curr.recordid=prev.recordid and curr.cksumtype=1 and prev.cksumtype=0 and curr.cksum<>prev.cksumunion all select curr.tablename,curr.recordid,prev.cksum,curr.cksum,NULL from node_cksum curr left join node_cksum prev on prev.nodeid=curr.nodeid and prev.tablename=curr.tablename and prev.recordid=curr.recordid and prev.cksumtype=0 where curr.nodeid=194 and curr.cksumtype=1 and prev.tablename is null union all select prev.tablename,prev.recordid,prev.cksum,curr.cksum,prev.sync from node_cksum prev left join node_cksum curr on curr.nodeid=prev.nodeid and curr.tablename=prev.tablename and curr.recordid=prev.recordid and curr.cksumtype=1 where prev.nodeid=194 and prev.cksumtype=0 and curr.tablename is null]
4535:20100910:143019.501 NODE 225: Received configuration changes from master node 212 for node 194 datalen 12
4535:20100910:143019.771 [Z3005] Query failed: [1064] You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'all select curr.tablename,curr.recordid,prev.cksum,curr.cksum,curr.sync from nod' at line 1 [select curr.tablename,curr.recordid,prev.cksum,curr.cksum,prev.sync from node_cksum curr, node_cksum prev where curr.nodeid=217 and prev.nodeid=curr.nodeid and curr.tablename=prev.tablename and curr.recordid=prev.recordid and curr.cksumtype=1 and prev.cksumtype=0 and curr.cksum<>prev.cksumunion all select curr.tablename,curr.recordid,prev.cksum,curr.cksum,curr.sync from node_cksum curr left join node_cksum prev on prev.nodeid=curr.nodeid and prev.tablename=curr.tablename and prev.recordid=curr.recordid and prev.cksumtype=0 where curr.nodeid=217 and curr.cksumtype=1 and prev.tablename is null union all select prev.tablename,prev.recordid,prev.cksum,curr.cksum,prev.sync from node_cksum prev left join node_cksum curr on curr.nodeid=prev.nodeid and curr.tablename=prev.tablename and curr.recordid=prev.recordid and curr.cksumtype=1 where prev.nodeid=217 and prev.cksumtype=0 and curr.tablename is null]
4535:20100910:143019.771 NODE 225: Sending configuration changes to master node 212 for node 217 datalen 12
4514:20100910:143019.773 server #4 started [Poller. SNMP:YES]
4512:20100910:143019.775 server #2 started [Poller. SNMP:YES]
4513:20100910:143019.795 server #3 started [Poller. SNMP:YES]
4535:20100910:143019.802 [Z3005] Query failed: [1064] You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'all select curr.tablename,curr.recordid,prev.cksum,curr.cksum,NULL from node_cks' at line 1 [select curr.tablename,curr.recordid,prev.cksum,curr.cksum,prev.sync from node_cksum curr, node_cksum prev where curr.nodeid=217 and prev.nodeid=curr.nodeid and curr.tablename=prev.tablename and curr.recordid=prev.recordid and curr.cksumtype=1 and prev.cksumtype=0 and curr.cksum<>prev.cksumunion all select curr.tablename,curr.recordid,prev.cksum,curr.cksum,NULL from node_cksum curr left join node_cksum prev on prev.nodeid=curr.nodeid and prev.tablename=curr.tablename and prev.recordid=curr.recordid and prev.cksumtype=0 where curr.nodeid=217 and curr.cksumtype=1 and prev.tablename is null union all select prev.tablename,prev.recordid,prev.cksum,curr.cksum,prev.sync from node_cksum prev left join node_cksum curr on curr.nodeid=prev.nodeid and curr.tablename=prev.tablename and curr.recordid=prev.recordid and curr.cksumtype=1 where prev.nodeid=217 and prev.cksumtype=0 and curr.tablename is null]
4535:20100910:143019.803 NODE 225: Received configuration changes from master node 212 for node 217 datalen 12
4515:20100910:143019.846 server #5 started [Poller. SNMP:YES]
4516:20100910:143019.863 server #6 started [Poller. SNMP:YES]
4537:20100910:143020.014 server #18 started [Discoverer. SNMP:YES]
4535:20100910:143021.831 [Z3005] Query failed: [1064] You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'all select curr.tablename,curr.recordid,prev.cksum,curr.cksum,curr.sync from nod' at line 1 [select curr.tablename,curr.recordid,prev.cksum,curr.cksum,prev.sync from node_cksum curr, node_cksum prev where curr.nodeid=225 and prev.nodeid=curr.nodeid and curr.tablename=prev.tablename and curr.recordid=prev.recordid and curr.cksumtype=1 and prev.cksumtype=0 and curr.cksum<>prev.cksumunion all select curr.tablename,curr.recordid,prev.cksum,curr.cksum,curr.sync from node_cksum curr left join node_cksum prev on prev.nodeid=curr.nodeid and prev.tablename=curr.tablename and prev.recordid=curr.recordid and prev.cksumtype=0 where curr.nodeid=225 and curr.cksumtype=1 and prev.tablename is null union all select prev.tablename,prev.recordid,prev.cksum,curr.cksum,prev.sync from node_cksum prev left join node_cksum curr on curr.nodeid=prev.nodeid and curr.tablename=prev.tablename and curr.recordid=prev.recordid and curr.cksumtype=1 where prev.nodeid=225 and prev.cksumtype=0 and curr.tablename is null]
4535:20100910:143021.831 NODE 225: Sending configuration changes to master node 212 for node 225 datalen 12
4535:20100910:143021.858 [Z3005] Query failed: [1064] You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'all select curr.tablename,curr.recordid,prev.cksum,curr.cksum,NULL from node_cks' at line 1 [select curr.tablename,curr.recordid,prev.cksum,curr.cksum,prev.sync from node_cksum curr, node_cksum prev where curr.nodeid=225 and prev.nodeid=curr.nodeid and curr.tablename=prev.tablename and curr.recordid=prev.recordid and curr.cksumtype=1 and prev.cksumtype=0 and curr.cksum<>prev.cksumunion all select curr.tablename,curr.recordid,prev.cksum,curr.cksum,NULL from node_cksum curr left join node_cksum prev on prev.nodeid=curr.nodeid and prev.tablename=curr.tablename and prev.recordid=curr.recordid and prev.cksumtype=0 where curr.nodeid=225 and curr.cksumtype=1 and prev.tablename is null union all select prev.tablename,prev.recordid,prev.cksum,curr.cksum,prev.sync from node_cksum prev left join node_cksum curr on curr.nodeid=prev.nodeid and curr.tablename=prev.tablename and curr.recordid=prev.recordid and curr.cksumtype=1 where prev.nodeid=225 and prev.cksumtype=0 and curr.tablename is null]
4535:20100910:143021.858 NODE 225: Received configuration changes from master node 212 for node 225 datalen 12
4535:20100910:143022.760 [Z3005] Query failed: [1064] You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'all select curr.tablename,curr.recordid,prev.cksum,curr.cksum,curr.sync from nod' at line 1 [select curr.tablename,curr.recordid,prev.cksum,curr.cksum,prev.sync from node_cksum curr, node_cksum prev where curr.nodeid=233 and prev.nodeid=curr.nodeid and curr.tablename=prev.tablename and curr.recordid=prev.recordid and curr.cksumtype=1 and prev.cksumtype=0 and curr.cksum<>prev.cksumunion all select curr.tablename,curr.recordid,prev.cksum,curr.cksum,curr.sync from node_cksum curr left join node_cksum prev on prev.nodeid=curr.nodeid and prev.tablename=curr.tablename and prev.recordid=curr.recordid and prev.cksumtype=0 where curr.nodeid=233 and curr.cksumtype=1 and prev.tablename is null union all select prev.tablename,prev.recordid,prev.cksum,curr.cksum,prev.sync from node_cksum prev left join node_cksum curr on curr.nodeid=prev.nodeid and curr.tablename=prev.tablename and curr.recordid=prev.recordid and curr.cksumtype=1 where prev.nodeid=233 and prev.cksumtype=0 and curr.tablename is null]
4535:20100910:143022.760 NODE 225: Sending configuration changes to master node 212 for node 233 datalen 12
4535:20100910:143022.786 [Z3005] Query failed: [1064] You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'all select curr.tablename,curr.recordid,prev.cksum,curr.cksum,NULL from node_cks' at line 1 [select curr.tablename,curr.recordid,prev.cksum,curr.cksum,prev.sync from node_cksum curr, node_cksum prev where curr.nodeid=233 and prev.nodeid=curr.nodeid and curr.tablename=prev.tablename and curr.recordid=prev.recordid and curr.cksumtype=1 and prev.cksumtype=0 and curr.cksum<>prev.cksumunion all select curr.tablename,curr.recordid,prev.cksum,curr.cksum,NULL from node_cksum curr left join node_cksum prev on prev.nodeid=curr.nodeid and prev.tablename=curr.tablename and prev.recordid=curr.recordid and prev.cksumtype=0 where curr.nodeid=233 and curr.cksumtype=1 and prev.tablename is null union all select prev.tablename,prev.recordid,prev.cksum,curr.cksum,prev.sync from node_cksum prev left join node_cksum curr on curr.nodeid=prev.nodeid and curr.tablename=prev.tablename and curr.recordid=prev.recordid and curr.cksumtype=1 where prev.nodeid=233 and prev.cksumtype=0 and curr.tablename is null]
4535:20100910:143022.787 NODE 225: Received configuration changes from master node 212 for node 233 datalen 12
4535:20100910:143022.858 [Z3005] Query failed: [1064] You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'all select curr.tablename,curr.recordid,prev.cksum,curr.cksum,curr.sync from nod' at line 1 [select curr.tablename,curr.recordid,prev.cksum,curr.cksum,prev.sync from node_cksum curr, node_cksum prev where curr.nodeid=238 and prev.nodeid=curr.nodeid and curr.tablename=prev.tablename and curr.recordid=prev.recordid and curr.cksumtype=1 and prev.cksumtype=0 and curr.cksum<>prev.cksumunion all select curr.tablename,curr.recordid,prev.cksum,curr.cksum,curr.sync from node_cksum curr left join node_cksum prev on prev.nodeid=curr.nodeid and prev.tablename=curr.tablename and prev.recordid=curr.recordid and prev.cksumtype=0 where curr.nodeid=238 and curr.cksumtype=1 and prev.tablename is null union all select prev.tablename,prev.recordid,prev.cksum,curr.cksum,prev.sync from node_cksum prev left join node_cksum curr on curr.nodeid=prev.nodeid and curr.tablename=prev.tablename and curr.recordid=prev.recordid and curr.cksumtype=1 where prev.nodeid=238 and prev.cksumtype=0 and curr.tablename is null]
4535:20100910:143022.858 NODE 225: Sending configuration changes to master node 212 for node 238 datalen 12
4535:20100910:143022.881 [Z3005] Query failed: [1064] You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'all select curr.tablename,curr.recordid,prev.cksum,curr.cksum,NULL from node_cks' at line 1 [select curr.tablename,curr.recordid,prev.cksum,curr.cksum,prev.sync from node_cksum curr, node_cksum prev where curr.nodeid=238 and prev.nodeid=curr.nodeid and curr.tablename=prev.tablename and curr.recordid=prev.recordid and curr.cksumtype=1 and prev.cksumtype=0 and curr.cksum<>prev.cksumunion all select curr.tablename,curr.recordid,prev.cksum,curr.cksum,NULL from node_cksum curr left join node_cksum prev on prev.nodeid=curr.nodeid and prev.tablename=curr.tablename and prev.recordid=curr.recordid and prev.cksumtype=0 where curr.nodeid=238 and curr.cksumtype=1 and prev.tablename is null union all select prev.tablename,prev.recordid,prev.cksum,curr.cksum,prev.sync from node_cksum prev left join node_cksum curr on curr.nodeid=prev.nodeid and curr.tablename=prev.tablename and curr.recordid=prev.recordid and curr.cksumtype=1 where prev.nodeid=238 and prev.cksumtype=0 and curr.tablename is null]