Zabbix proxy : surprising log file !

[Cray]

Hi all,

I have multiple proxies dispatched and running, and I was actually surprised seeing the log file of one of them :

3887:20090425:192157 [Z3005] Query failed: [0] columns hostid, key_ are not unique [update items set type=3,snmp_community='public',snmp_oid='interface s.ifTable.ifEntry.ifInOctets.1',snmp_port=161,host id=10126,key_='icmpping',delay=20,status=0,value_t ype=3,trapper_hosts='',units='',multiplier=0,delta =0,snmpv3_securityname='',snmpv3_securitylevel=0,s nmpv3_authpassphrase='',snmpv3_privpassphrase='',f ormula='1',logtimefmt='',templateid=23264,valuemap id=0,delay_flex='',params='DSN=<database source name>\nuser=<user name>\npassword=<password>\nsql=<query>',ipmi_sens or='' where itemid=25194;
update items set type=0,snmp_community='',snmp_oid='',snmp_port=161 ,hostid=10126,key_='perf_counter[\Processor(0)\% Processor Time]',delay=10,status=0,value_type=0,trapper_hosts='', units='',multiplier=0,delta=0,snmpv3_securityname= '',snmpv3_securitylevel=0,snmpv3_authpassphrase='' ,snmpv3_privpassphrase='',formula='1',logtimefmt=' ',templateid=25076,valuemapid=0,delay_flex='',para ms='',ipmi_sensor='' where itemid=25195;
update items set type=0,snmp_community='',snmp_oid='',snmp_port=161 ,hostid=10126,key_='perf_counter[\Processor(1)\% Processor Time]',delay=30,status=0,value_type=0,trapper_hosts='', units='',multiplier=0,delta=0,snmpv3_securityname= '',snmpv3_securitylevel=0,snmpv3_authpassphrase='' ,snmpv3_privpassphrase='',formula='1',logtimefmt=' ',templateid=25077,valuemapid=0,delay_flex='',para ms='',ipmi_sensor='' where itemid=25196;
update items set type=0,snmp_community='',snmp_oid='',snmp_port=161 ,hostid=10126,key_='agent.ping',delay=30,status=0, value_type=3,trapper_hosts='',units='',multiplier= 0,delta=0,snmpv3_securityname='',snmpv3_securityle vel=0,snmpv3_authpassphrase='',snmpv3_privpassphra se='',formula='0',logtimefmt='',templateid=23222,v aluemapid=1,delay_flex='',params='',ipmi_sensor='' where itemid=25197;
update items set type=0,snmp_community='',snmp_oid='',snmp_port=161 ,hostid=10126,key_='agent.version',delay=1800,stat us=0,value_type=1,trapper_hosts='',units='',multip lier=0,delta=0,snmpv3_securityname='',snmpv3_secur itylevel=0,snmpv3_authpassphrase='',snmpv3_privpas sphrase='',formula='0',logtimefmt='',templateid=23 229,valuemapid=0,delay_flex='',params='',ipmi_sens or='' where itemid=25198;
update items set type=0,snmp_community='',snmp_oid='',snmp_port=161 ,hostid=10126,key_='perf_counter[\PhysicalDisk(_Total)\Avg. Disk Write Queue Length]',delay=30,status=0,value_type=0,trapper_hosts='', units='',multiplier=0,delta=0,snmpv3_securityname= '',snmpv3_securitylevel=0,snmpv3_authpassphrase='' ,snmpv3_privpassphrase='',formula='1',logtimefmt=' ',templateid=23212,valuemapid=0,delay_flex='',para ms='',ipmi_sensor='' where itemid=25199;

The log file keeps filling up with all these SQL (lite) queries. I tried to restart the process, and even the whole server, without any changes

Can someone tells me what is this about ?
Thanks in advance

P.S : I'm running Zabbix 1.6.4 (agent / proxy / server) and the debug level is 2

[tekknokrat]

Hi Cray,

did you tried to recreate the sqlite database? IMO this helped in some proxy issues I had.
My proxy log looks clean, DebugLevel=3

Cheers

[Cray]

Hello tekknokrat

Indeed, deleting the .db (SQLite) file cleaned the log file but .... what is this issue related to ? (I mean, if it happens again, I would like to know why )

Is the SQLite DB engine too weak to sustain a heavy load or something like that ? (I started discussing that in an other thread regarding proxy issues).

Anyway thanks for your help, and if you have any clue related to this problem's trigger, let me know