Distributing Monitoring Query Failure

[ravinmiist]

Hello All,

Having problems with Zabbix 1.5 Build 5565 fresh install today.

On the master node no problems but on the child node getting query failed.

Both are setup according to the multiple examples with the master node running: zabbix_server -n 1 -c /etc/zabbix/zabbix_server.conf
and on the child: zabbix_server -n 2 -c /etc/zabbix/zabbix_server.conf

Setup the frontends with the child and master nodes according to the 1.6 manual and i get this error below:

On 2 messages:
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
union all select 2,'slides',slideid,1,concat_ws(',',slideshowid,scr eenid,step,delay) from slides where 1=1 and slideid between 200000000000000 and 299999999999999
union all select 2,'drules',druleid,1,concat_ws(',',proxy_hostid,md 5(name),md5(iprange),delay,nextcheck,status) from drules where 1=1 and druleid between 200000000000000 and 299999999999999
union all select 2,'dchecks',dcheckid,1,concat_ws(',',druleid,type, md5(key_),md5(snmp_community),md5(ports)) from dchecks where 1=1 and dcheckid between 200000000000000 and 299999999999999
union all select 2,'dhosts',dhostid,1,concat_ws(',',druleid,md5(ip) ,status,lastup,lastdown) from dhosts where 1=1 and dhostid between 200000000000000 and 299999999999999
union all select 2,'dservices',dserviceid,1,concat_ws(',',dhostid,t ype,md5(key_),md5(value),port,status,lastup,lastdo wn) from dservices where 1=1 and dserviceid between 200000000000000 and 299999999999999
union all select 2,'httptest',httptestid,1,concat_ws(',',md5(name), applicationid,lastcheck,nextcheck,curstate,curstep ,lastfailedstep,delay,status,md5(macros),md5(agent ),md5(time),md5(error)) from httptest where 1=1 and httptestid between 200000000000000 and 299999999999999
union all select 2,'httpstep',httpstepid,1,concat_ws(',',httptestid ,md5(name),no,md5(url),timeout,md5(posts),md5(requ ired),md5(status_codes)) from httpstep where 1=1 and httpstepid between 200000000000000 and 299999999999999
union all select 2,'httpstepitem',httpstepitemid,1,concat_ws(',',ht tpstepid,itemid,type) from httpstepitem where 1=1 and httpstepitemid between 200000000000000 and 299999999999999
union all select 2,'httptestitem',httptestitemid,1,concat_ws(',',ht tptestid,itemid,type) from httptestitem where 1=1 and httptestitemid between 200000000000000 and 299999999999999
union all select 2,'services_times',timeid,1,concat_ws(',',servicei d,type,ts_from,ts_to,md5(note)) from services_times where 1=1 and timeid between 200000000000000 and 299999999999999
union all select 2,'actions',actionid,1,concat_ws(',',md5(name),eve ntsource,evaltype,status) from actions where 1=1 and actionid between 200000000000000 and 299999999999999
union all select 2,'operations',operationid,1,concat_ws(',',actioni d,operationtype,object,objectid,md5(shortdata),md5 (longdata)) from operations where 1=1 and operationid between 200000000000000 and 299999999999999

[ravinmiist]

Rest of the error: Over 10000 lines so had to do 2 posts


union all select 2,'applications',applicationid,1,concat_ws(',',hos tid,md5(name),templateid) from applications where 1=1 and applicationid between 200000000000000 and 299999999999999
union all select 2,'conditions',conditionid,1,concat_ws(',',actioni d,conditiontype,operator,md5(value)) from conditions where 1=1 and conditionid between 200000000000000 and 299999999999999
union all select 2,'config',configid,1,concat_ws(',',alert_history, event_history,refresh_unsupported,md5(work_period) ,alert_usrgrpid,event_ack_enable,event_expire,even t_show_max,md5(default_theme)) from config where 1=1 and configid between 200000000000000 and 299999999999999
union all select 2,'functions',functionid,1,concat_ws(',',itemid,tr iggerid,md5(function),md5(parameter)) from functions where 1=1 and functionid between 200000000000000 and 299999999999999
union all select 2,'graphs',graphid,1,concat_ws(',',md5(name),width ,height,yaxistype,md5(yaxismin),md5(yaxismax),temp lateid,show_work_period,show_triggers,graphtype,sh ow_legend,show_3d) from graphs where 1=1 and graphid between 200000000000000 and 299999999999999
union all select 2,'graphs_items',gitemid,1,concat_ws(',',graphid,i temid,drawtype,sortorder,md5(color),yaxisside,calc _fnc,type,periods_cnt) from graphs_items where 1=1 and gitemid between 200000000000000 and 299999999999999
union all select 2,'groups',groupid,1,concat_ws(',',md5(name)) from groups where 1=1 and groupid between 200000000000000 and 299999999999999
union all select 2,'hosts',hostid,1,concat_ws(',',proxy_hostid,md5( host),md5(dns),useip,md5(ip),port,status,md5(error ),available,lastaccess,inbytes,outbytes) from hosts where 1=1 and hostid between 200000000000000 and 299999999999999
union all select 2,'hosts_groups',hostgroupid,1,concat_ws(',',hosti d,groupid) from hosts_groups where 1=1 and hostgroupid between 200000000000000 and 299999999999999
union all select 2,'hosts_profiles',hostid,1,concat_ws(',',md5(devi cetype),md5(name),md5(os),md5(serialno),md5(tag),m d5(macaddress),md5(hardware),md5(software),md5(con tact),md5(location),md5(notes)) from hosts_profiles where 1=1 and hostid between 200000000000000 and 299999999999999
union all select 2,'hosts_templates',hosttemplateid,1,concat_ws(',' ,hostid,templateid) from hosts_templates where 1=1 and hosttemplateid between 200000000000000 and 299999999999999
union all select 2,'images',imageid,1,concat_ws(',',imagetype,md5(n ame),md5(image)) from images where 1=1 and imageid between 200000000000000 and 299999999999999
union all select 2,'items',itemid,1,concat_ws(',',type,md5(snmp_com munity),md5(snmp_oid),snmp_port,hostid,md5(descrip tion),md5(key_),delay,history,trends,status,value_ type,md5(trapper_hosts),md5(units),multiplier,delt a,md5(snmpv3_securityname),snmpv3_securitylevel,md 5(snmpv3_authpassphrase),md5(snmpv3_privpassphrase ),md5(formula),md5(error),md5(logtimefmt),template id,valuemapid,md5(delay_flex),md5(params)) from items where 1=1 and itemid between 200000000000000 and 299999999999999
union all select 2,'items_applications',itemappid,1,concat_ws(',',a pplicationid,itemid) from items_applications where 1=1 and itemappid between 200000000000000 and 299999999999999
union all select 2,'mappings',mappingid,1,concat_ws(',',valuemapid, md5(value),md5(newvalue)) from mappings where 1=1 and mappingid between 200000000000000 and 299999999999999
union all select 2,'media',mediaid,1,concat_ws(',',userid,mediatype id,md5(sendto),active,severity,md5(period)) from media where 1=1 and mediaid between 200000000000000 and 299999999999999
union all select 2,'media_type',mediatypeid,1,concat_ws(',',type,md 5(description),md5(smtp_server),md5(smtp_helo),md5 (smtp_email),md5(exec_path),md5(gsm_modem),md5(use rname),md5(passwd)) from media_type where 1=1 and mediatypeid between 200000000000000 and 299999999999999
union all select 2,'profiles',profileid,1,concat_ws(',',userid,md5( idx),md5(value),valuetype) from profiles where 1=1 and profileid between 200000000000000 and 299999999999999
union all select 2,'rights',rightid,1,concat_ws(',',groupid,type,pe rmission,case when id is null then 'NULL' else id end) from rights where 1=1 and rightid between 200000000000000 and 299999999999999
union all select 2,'scripts',scriptid,1,concat_ws(',',md5(name),md5 (command),host_access) from scripts where 1=1 and scriptid between 200000000000000 and 299999999999999
union all select 2,'screens',screenid,1,concat_ws(',',md5(name),hsi ze,vsize) from screens where 1=1 and screenid between 200000000000000 and 299999999999999
union all select 2,'screens_items',screenitemid,1,concat_ws(',',scr eenid,resourcetype,resourceid,width,height,x,y,col span,rowspan,elements,valign,halign,style,md5(url) ,dynamic) from screens_items where 1=1 and screenitemid between 200000000000000 and 299999999999999
union all select 2,'services',serviceid,1,concat_ws(',',md5(name),s tatus,algorithm,case when triggerid is null then 'NULL' else triggerid end,showsla,md5(goodsla),sortorder) from services where 1=1 and serviceid between 200000000000000 and 299999999999999
union all select 2,'services_links',linkid,1,concat_ws(',',serviceu pid,servicedownid,soft) from services_links where 1=1 and linkid between 200000000000000 and 299999999999999
union all select 2,'sysmaps_links',linkid,1,concat_ws(',',sysmapid, selementid1,selementid2,drawtype,md5(color)) from sysmaps_links where 1=1 and linkid between 200000000000000 and 299999999999999
union all select 2,'sysmaps_link_triggers',linkid,triggerid,1,conca t_ws(',',linkid,case when triggerid is null then 'NULL' else triggerid end,drawtype,md5(color)) from sysmaps_link_triggers where 1=1 and linkid,triggerid between 200000000000000 and 299999999999999
union all select 2,'sysmaps_elements',selementid,1,concat_ws(',',sy smapid,elementid,elementtype,iconid_off,iconid_on, iconid_unknown,md5(label),case when label_location is null then 'NULL' else label_location end,x,y,md5(url)) from sysmaps_elements where 1=1 and selementid between 200000000000000 and 299999999999999
union all select 2,'sysmaps',sysmapid,1,concat_ws(',',md5(name),wid th,height,backgroundid,label_type,label_location) from sysmaps where 1=1 and sysmapid between 200000000000000 and 299999999999999
union all select 2,'triggers',triggerid,1,concat_ws(',',md5(express ion),md5(description),md5(url),status,value,priori ty,lastchange,dep_level,md5(comments),md5(error),t emplateid,type) from triggers where 1=1 and triggerid between 200000000000000 and 299999999999999
union all select 2,'trigger_depends',triggerdepid,1,concat_ws(',',t riggerid_down,triggerid_up) from trigger_depends where 1=1 and triggerdepid between 200000000000000 and 299999999999999
union all select 2,'users',userid,1,concat_ws(',',md5(alias),md5(na me),md5(surname),md5(passwd),md5(url),autologin,au tologout,md5(lang),refresh,type,md5(theme)) from users where 1=1 and userid between 200000000000000 and 299999999999999
union all select 2,'usrgrp',usrgrpid,1,concat_ws(',',md5(name),gui_ access,users_status) from usrgrp where 1=1 and usrgrpid between 200000000000000 and 299999999999999
union all select 2,'users_groups',id,1,concat_ws(',',usrgrpid,useri d) from users_groups where 1=1 and id between 200000000000000 and 299999999999999
union all select 2,'valuemaps',valuemapid,1,concat_ws(',',md5(name) ) from valuemaps where 1=1 and valuemapid between 200000000000000 and 299999999999999
] 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 'triggerid between 200000000000000 and 299999999999999
union all select 2,'sysmap' at line 39 [1064]

Any help would be appricated


ravinmiist