38823:20131107:133153.360 [Z3005] query failed: [1205] Lock wait timeout exceeded; try restarting transaction [update items set lastlogsize=6096908,mtime=0 where itemid=23640;
update host_inventory set hardware='poweredOn (1)' where hostid=12455;
update host_inventory set hardware='poweredOn (1)' where hostid=12470;
update host_inventory set hardware='poweredOn (1)' where hostid=12485;
update host_inventory set hardware='poweredOn (1)' where hostid=12500;
update host_inventory set hardware='poweredOn (1)' where hostid=12515;
update host_inventory set hardware='poweredOn (1)' where hostid=12530;
update host_inventory set hardware='poweredOn (1)' where hostid=12545;
update host_inventory set hardware='poweredOn (1)' where hostid=12560;
update host_inventory set hardware='poweredOn (1)' where hostid=12575;
update host_inventory set hardware='poweredOn (1)' where hostid=12590;
update host_inventory set hardware='poweredOn (1)' where hostid=12605;
update host_inventory set hardware='poweredOn (1)' where hostid=12620;
update host_inventory set hardware='poweredOn (1)' where hostid=12635;
update host_inventory set hardware='poweredOn (1)' where hostid=12650;
update host_inventory set hardware='poweredOn (1)' where hostid=12665;
update host_inventory set hardware='poweredOn (1)' where hostid=12680;
update host_inventory set hardware='poweredOn (1)' where hostid=12695;
update host_inventory set hardware='poweredOn (1)' where hostid=12710;
update host_inventory set hardware='poweredOn (1)' where hostid=12725;
update host_inventory set hardware='poweredOn (1)' where hostid=12740;
update host_inventory set hardware='poweredOn (1)' where hostid=12755;
update host_inventory set hardware='poweredOn (1)' where hostid=12770;
update host_inventory set hardware='poweredOn (1)' where hostid=12785;
update host_inventory set hardware='poweredOn (1)' where hostid=12800;
update host_inventory set hardware='poweredOn (1)' where hostid=12815;
update host_inventory set hardware='poweredOn (1)' where hostid=12830;
update host_inventory set hardware='poweredOn (1)' where hostid=12845;
update host_inventory set hardware='poweredOn (1)' where hostid=12860;
update host_inventory set hardware='poweredOff (0)' where hostid=12875;
update host_inventory set hardware='poweredOn (1)' where hostid=12890;
update host_inventory set hardware='poweredOn (1)' where hostid=12905;
update host_inventory set hardware='poweredOn (1)' where hostid=12920;
update host_inventory set hardware='poweredOn (1)' where hostid=12935;
update host_inventory set hardware='poweredOn (1)' where hostid=12950;
update host_inventory set hardware='poweredOn (1)' where hostid=12965;
update host_inventory set hardware='poweredOn (1)' where hostid=12980;
update host_inventory set hardware='poweredOn (1)' where hostid=12995;
]
 38800:20131107:133159.363 [Z3005] query failed: [1205] Lock wait timeout exceeded; try restarting transaction [insert into items (itemid,name,key_,hostid,type,value_type,data_type,delay,delay_flex,history,trends,status,trapper_hosts,units,multiplier,delta,formula,logtimefmt,valuemapid,params,ipmi_sensor,snmp_community,snmp_oid,port,snmpv3_securityname,snmpv3_securitylevel,snmpv3_authprotocol,snmpv3_authpassphrase,snmpv3_privprotocol,snmpv3_privpassphrase,authtype,username,password,publickey,privatekey,description,interfaceid,flags,snmpv3_contextname) values (141812,'Average number of kilobytes read from the disk $3','vmware.vm.vfs.dev.read[{$URL},{HOST.HOST},scsi0:2,bps]',12817,3,3,0,60,'',90,365,0,'','Bps',0,0,'1','',null,'','','','','','',0,0,'',0,'',0,'{$USERNAME}','{$PASSWORD}','','','',2722,4,''),(141813,'Average number of kilobytes read from the disk $3','vmware.vm.vfs.dev.read[{$URL},{HOST.HOST},scsi0:1,bps]',12817,3,3,0,60,'',90,365,0,'','Bps',0,0,'1','',null,'','','','','','',0,0,'',0,'',0,'{$USERNAME}','{$PASSWORD}','','','',2722,4,''),(141814,'Average number of kilobytes read from the disk $3','vmware.vm.vfs.dev.read[{$URL},{HOST.HOST},scsi0:0,bps]',12817,3,3,0,60,'',90,365,0,'','Bps',0,0,'1','',null,'','','','','','',0,0,'',0,'',0,'{$USERNAME}','{$PASSWORD}','','','',2722,4,'');
]
 38822:20131107:133208.367 [Z3005] query failed: [1205] Lock wait timeout exceeded; try restarting transaction [update items set lastlogsize=82539392,mtime=0 where itemid=24074;
]
 38799:20131107:133215.370 [Z3005] query failed: [1205] Lock wait timeout exceeded; try restarting transaction [update ids set nextid=nextid+4 where nodeid=0 and table_name='items' and field_name='itemid']
zabbix_server [38799]: ERROR [file:db.c,line:1239] Something impossible has just happened.
 38801:20131107:133231.377 [Z3005] query failed: [1205] Lock wait timeout exceeded; try restarting transaction [update ids set nextid=nextid+2 where nodeid=0 and table_name='items' and field_name='itemid']
zabbix_server [38801]: ERROR [file:db.c,line:1239] Something impossible has just happened.
 38825:20131107:133248.385 [Z3005] query failed: [1205] Lock wait timeout exceeded; try restarting transaction [update items set lastlogsize=6096909,mtime=0 where itemid=23640;
]
 38800:20131107:133250.386 [Z3005] query failed: [1205] Lock wait timeout exceeded; try restarting transaction [update ids set nextid=nextid+3 where nodeid=0 and table_name='items' and field_name='itemid']
zabbix_server [38800]: ERROR [file:db.c,line:1239] Something impossible has just happened.
 38802:20131107:133250.386 [Z3005] query failed: [1205] Lock wait timeout exceeded; try restarting transaction [insert into items (itemid,name,key_,hostid,type,value_type,data_type,delay,delay_flex,history,trends,status,trapper_hosts,units,multiplier,delta,formula,logtimefmt,valuemapid,params,ipmi_sensor,snmp_community,snmp_oid,port,snmpv3_securityname,snmpv3_securitylevel,snmpv3_authprotocol,snmpv3_authpassphrase,snmpv3_privprotocol,snmpv3_privpassphrase,authtype,username,password,publickey,privatekey,description,interfaceid,flags,snmpv3_contextname) values (141847,'Average number of kilobytes read from the disk $3','vmware.vm.vfs.dev.read[{$URL},{HOST.HOST},scsi0:2,bps]',12705,3,3,0,60,'',90,365,0,'','Bps',0,0,'1','',null,'','','','','','',0,0,'',0,'',0,'{$USERNAME}','{$PASSWORD}','','','',2610,4,''),(141848,'Average number of kilobytes read from the disk $3','vmware.vm.vfs.dev.read[{$URL},{HOST.HOST},scsi0:1,bps]',12705,3,3,0,60,'',90,365,0,'','Bps',0,0,'1','',null,'','','','','','',0,0,'',0,'',0,'{$USERNAME}','{$PASSWORD}','','','',2610,4,''),(141849,'Average number of kilobytes read from the disk $3','vmware.vm.vfs.dev.read[{$URL},{HOST.HOST},scsi0:0,bps]',12705,3,3,0,60,'',90,365,0,'','Bps',0,0,'1','',null,'','','','','','',0,0,'',0,'',0,'{$USERNAME}','{$PASSWORD}','','','',2610,4,'');
]
 38798:20131107:133250.386 [Z3005] query failed: [1205] Lock wait timeout exceeded; try restarting transaction [insert into items (itemid,name,key_,hostid,type,value_type,data_type,delay,delay_flex,history,trends,status,trapper_hosts,units,multiplier,delta,formula,logtimefmt,valuemapid,params,ipmi_sensor,snmp_community,snmp_oid,snmpv3_securityname,snmpv3_securitylevel,snmpv3_authprotocol,snmpv3_authpassphrase,snmpv3_privprotocol,snmpv3_privpassphrase,authtype,username,password,publickey,privatekey,templateid,flags,filter,description,inventory_link,interfaceid,lifetime,snmpv3_contextname) values (141812,'Cluster name','vmware.vm.cluster.name[{$URL},{HOST.HOST}]',13005,3,1,0,3600,'',90,365,1,'','',0,0,'1','',null,'','','','','',0,0,'',0,'',0,'{$USERNAME}','{$PASSWORD}','','',23597,0,'','Cluster name of the guest VM.',0,2910,'30',''),(141813,'Number of virtual CPUs','vmware.vm.cpu.num[{$URL},{HOST.HOST}]',13005,3,3,0,60,'',90,365,1,'','',0,0,'1','',null,'','','','','',0,0,'',0,'',0,'{$USERNAME}','{$PASSWORD}','','',23551,0,'','Number of virtual CPUs assigned to the guest.',0,2910,'30',''),(141814,'CPU usage','vmware.vm.cpu.usage[{$URL},{HOST.HOST}]',13005,3,3,0,60,'',90,365,1,'','Hz',0,0,'1','',null,'','','','','',0,0,'',0,'',0,'{$USERNAME}','{$PASSWORD}','','',23550,0,'','Current upper-bound on CPU usage. The upper-bound is based on the host the virtual machine is current running on, as well as limits configured on the virtual machine itself or any parent resource pool. Valid while the virtual machine is running.',0,2910,'30',''),(141815,'Hypervisor name','vmware.vm.hv.name[{$URL},{HOST.HOST}]',13005,3,1,0,3600,'',90,365,0,'','',0,0,'1','',null,'','','','','',0,0,'',0,'',0,'{$USERNAME}','{$PASSWORD}','','',23573,0,'','Hypervisor name of the guest VM.',0,2910,'30',''),(141816,'Ballooned memory','vmware.vm.memory.size.ballooned[{$URL},{HOST.HOST}]',13005,3,3,0,60,'',90,365,1,'','B',0,0,'1','',null,'','','','','',0,0,'',0,'',0,'{$USERNAME}','{$PASSWORD}','','',23543,0,'','The amount of guest physical memory that is currently reclaimed through the balloon driver.',0,2910,'30',''),(141817,'Compressed memory','vmware.vm.memory.size.compressed[{$URL},{HOST.HOST}]',13005,3,3,0,60,'',90,365,1,'','B',0,0,'1','',null,'','','','','',0,0,'',0,'',0,'{$USERNAME}','{$PASSWORD}','','',23544,0,'','The amount of memory currently in the compression cache for this VM.',0,2910,'30',''),(141818,'Private memory','vmware.vm.memory.size.private[{$URL},{HOST.HOST}]',13005,3,3,0,60,'',90,365,1,'','B',0,0,'1','',null,'','','','','',0,0,'',0,'',0,'{$USERNAME}','{$PASSWORD}','','',23587,0,'','Amount of memory backed by host memory and not being shared.',0,2910,'30',''),(141819,'Shared memory','vmware.vm.memory.size.shared[{$URL},{HOST.HOST}]',13005,3,3,0,60,'',90,365,1,'','B',0,0,'1','',null,'','','','','',0,0,'',0,'',0,'{$USERNAME}','{$PASSWORD}','','',23588,0,'','The amount of guest physical memory shared through transparent page sharing.',0,2910,'30',''),(141820,'Swapped memory','vmware.vm.memory.size.swapped[{$URL},{HOST.HOST}]',13005,3,3,0,60,'',90,365,1,'','B',0,0,'1','',null,'','','','','',0,0,'',0,'',0,'{$USERNAME}','{$PASSWORD}','','',23546,0,'','The amount of guest physical memory swapped out to the VM\'s swap device by ESX.',0,2910,'30',''),(141821,'Guest memory usage','vmware.vm.memory.size.usage.guest[{$URL},{HOST.HOST}]',13005,3,3,0,60,'',90,365,1,'','B',0,0,'1','',null,'','','','','',0,0,'',0,'',0,'{$USERNAME}','{$PASSWORD}','','',23585,0,'','The amount of guest physical memory that is being used by the VM.',0,2910,'30',''),(141822,'Host memory usage','vmware.vm.memory.size.usage.host[{$URL},{HOST.HOST}]',13005,3,3,0,60,'',90,365,1,'','B',0,0,'1','',null,'','','','','',0,0,'',0,'',0,'{$USERNAME}','{$PASSWORD}','','',23586,0,'','The amount of host physical memory allocated to the VM, accounting for saving from memory sharing with other VMs.',0,2910,'30',''),(141823,'Memory size','vmware.vm.memory.size[{$URL},{HOST.HOST}]',13005,3,3,0,60,'',90,365,1,'','B',0,0,'1','',null,'','','','','',0,0,'',0,'',0,'{$USERNAME}','{$PASSWORD}','','',23545,0,'','Total size of configured memory.',0,2910,'30',''),(141824,'Network device discovery','vmware.vm.net.if.discovery[{$URL},{HOST.HOST}]',13005,3,4,0,3600,'',90,365,1,'','',0,0,'1','',null,'','','','','',0,0,'',0,'',0,'{$USERNAME}','{$PASSWORD}','','',23600,1,':','Discovery of all network devices.',0,2910,'30',''),(141825,'Number of bytes received on interface $3','vmware.vm.net.if.in[{$URL},{HOST.HOST},{#IFNAME},bps]',13005,3,3,0,60,'',90,365,0,'','Bps',0,0,'1','',null,'','','','','',0,0,'',0,'',0,'{$USERNAME}','{$PASSWORD}','','',23607,2,'','',0,2910,'30',''),(141826,'Number of packets received on interface $3','vmware.vm.net.if.in[{$URL},{HOST.HOST},{#IFNAME},pps]',13005,3,3,0,60,'',90,365,0,'','',0,0,'1','',null,'','','','','',0,0,'',0,'',0,'{$USERNAME}','{$PASSWORD}','','',23605,2,'','',0,2910,'30',''),(141827,'Number of bytes transmitted on interface $3','vmware.vm.net.if.out[{$URL},{HOST.HOST},{#IFNAME},bps]',13005,3,3,0,60,'',90,365,0,'','Bps',0,0,'1','',null,'','','','','',0,0,'',0,'',0,'{$USERNAME}','{$PASSWORD}','','',23608,2,'','',0,2910,'30',''),(141828,'Number of packets transmitted on interface $3','vmware.vm.net.if.out[{$URL},{HOST.HOST},{#IFNAME},pps]',13005,3,3,0,60,'',90,365,0,'','',0,0,'1','',null,'','','','','',0,0,'',0,'',0,'{$USERNAME}','{$PASSWORD}','','',23606,2,'','',0,2910,'30',''),(141829,'Power state','vmware.vm.powerstate[{$URL},{HOST.HOST}]',13005,3,3,0,60,'',90,365,0,'','',0,0,'1','',12,'','','','','',0,0,'',0,'',0,'{$USERNAME}','{$PASSWORD}','','',23552,0,'','The current power state of the virtual machine.',14,2910,'30',''),(141830,'Committed storage space','vmware.vm.storage.committed[{$URL},{HOST.HOST}]',13005,3,3,0,60,'',90,365,1,'','B',0,0,'1','',null,'','','','','',0,0,'',0,'',0,'{$USERNAME}','{$PASSWORD}','','',23547,0,'','Total storage space, in bytes, committed to this virtual machine across all datastores.',0,2910,'30',''),(141831,'Uncommitted storage space','vmware.vm.storage.uncommitted[{$URL},{HOST.HOST}]',13005,3,3,0,60,'',90,365,1,'','B',0,0,'1','',null,'','','','','',0,0,'',0,'',0,'{$USERNAME}','{$PASSWORD}','','',23548,0,'','Additional storage space, in bytes, potentially used by this virtual machine on all datastores.',0,2910,'30',''),(141832,'Unshared storage space','vmware.vm.storage.unshared[{$URL},{HOST.HOST}]',13005,3,3,0,60,'',90,365,1,'','B',0,0,'1','',null,'','','','','',0,0,'',0,'',0,'{$USERNAME}','{$PASSWORD}','','',23549,0,'','Total storage space, in bytes, occupied by the virtual machine across all datastores, that is not shared with any other virtual machine.',0,2910,'30',''),(141833,'Uptime','vmware.vm.uptime[{$URL},{HOST.HOST}]',13005,3,3,0,60,'',90,365,1,'','uptime',0,0,'1','',null,'','','','','',0,0,'',0,'',0,'{$USERNAME}','{$PASSWORD}','','',23553,0,'','System uptime.',0,2910,'30',''),(141834,'Disk device discovery','vmware.vm.vfs.dev.discovery[{$URL},{HOST.HOST}]',13005,3,4,0,3600,'',90,365,0,'','',0,0,'1','',null,'','','','','',0,0,'',0,'',0,'{$USERNAME}','{$PASSWORD}','','',23599,1,':','Discovery of all disk devices.',0,2910,'30',''),(141835,'Average number of kilobytes read from the disk $3','vmware.vm.vfs.dev.read[{$URL},{HOST.HOST},{#DISKNAME},bps]',13005,3,3,0,60,'',90,365,0,'','Bps',0,0,'1','',null,'','','','','',0,0,'',0,'',0,'{$USERNAME}','{$PASSWORD}','','',23601,2,'','',0,2910,'30',''),(141836,'Average number of reads from the disk $3','vmware.vm.vfs.dev.read[{$URL},{HOST.HOST},{#DISKNAME},ops]',13005,3,3,0,60,'',90,365,0,'','',0,0,'1','',null,'','','','','',0,0,'',0,'',0,'{$USERNAME}','{$PASSWORD}','','',23603,2,'','',0,2910,'30',''),(141837,'Average number of kilobytes written to the disk $3','vmware.vm.vfs.dev.write[{$URL},{HOST.HOST},{#DISKNAME},bps]',13005,3,3,0,60,'',90,365,0,'','Bps',0,0,'1','',null,'','','','','',0,0,'',0,'',0,'{$USERNAME}','{$PASSWORD}','','',23602,2,'','',0,2910,'30',''),(141838,'Average number of writes to the disk $3','vmware.vm.vfs.dev.write[{$URL},{HOST.HOST},{#DISKNAME},ops]',13005,3,3,0,60,'',90,365,0,'','',0,0,'1','',null,'','','','','',0,0,'',0,'',0,'{$USERNAME}','{$PASSWORD}','','',23604,2,'','',0,2910,'30',''),(141839,'Mounted filesystem discovery','vmware.vm.vfs.fs.discovery[{$URL},{HOST.HOST}]',13005,3,4,0,3600,'',90,365,1,'','',0,0,'1','',null,'','','','','',0,0,'',0,'',0,'{$USERNAME}','{$PASSWORD}','','',23575,1,':','Discovery of all guest file systems.',0,2910,'30',''),(141840,'Free disk space on {#FSNAME}','vmware.vm.vfs.fs.size[{$URL},{HOST.HOST},{#FSNAME},free]',13005,3,3,0,60,'',90,365,0,'','B',0,0,'1','',null,'','','','','',0,0,'',0,'',0,'{$USERNAME}','{$PASSWORD}','','',23576,2,'','',0,2910,'30',''),(141841,'Free disk space on {#FSNAME} (percentage)','vmware.vm.vfs.fs.size[{$URL},{HOST.HOST},{#FSNAME},pfree]',13005,3,3,0,60,'',90,365,0,'','B',0,0,'1','',null,'','','','','',0,0,'',0,'',0,'{$USERNAME}','{$PASSWORD}','','',23577,2,'','',0,2910,'30',''),(141842,'Total disk space on {#FSNAME}','vmware.vm.vfs.fs.size[{$URL},{HOST.HOST},{#FSNAME},total]',13005,3,3,0,3600,'',90,365,0,'','B',0,0,'1','',null,'','','','','',0,0,'',0,'',0,'{$USERNAME}','{$PASSWORD}','','',23578,2,'','',0,2910,'30',''),(141843,'Used disk space on {#FSNAME}','vmware.vm.vfs.fs.size[{$URL},{HOST.HOST},{#FSNAME},used]',13005,3,3,0,60,'',90,365,0,'','B',0,0,'1','',null,'','','','','',0,0,'',0,'',0,'{$USERNAME}','{$PASSWORD}','','',23579,2,'','',0,2910,'30','');
]
 38822:20131107:133259.390 [Z3005] query failed: [1205] Lock wait timeout exceeded; try restarting transaction [update items set lastlogsize=82539393,mtime=0 where itemid=24074;
]
 38801:20131107:133322.401 [Z3005] query failed: [1205] Lock wait timeout exceeded; try restarting transaction [update ids set nextid=nextid+2 where nodeid=0 and table_name='items' and field_name='itemid']
zabbix_server [38801]: ERROR [file:db.c,line:1239] Something impossible has just happened.
 38825:20131107:133339.410 [Z3005] query failed: [1205] Lock wait timeout exceeded; try restarting transaction [update items set lastlogsize=6096910,mtime=0 where itemid=23640;
]
 38802:20131107:133341.411 [Z3005] query failed: [1205] Lock wait timeout exceeded; try restarting transaction [update ids set nextid=nextid+3 where nodeid=0 and table_name='items' and field_name='itemid']
 38800:20131107:133341.411 [Z3005] query failed: [1205] Lock wait timeout exceeded; try restarting transaction [update ids set nextid=nextid+3 where nodeid=0 and table_name='items' and field_name='itemid']
zabbix_server [38802]: ERROR [file:db.c,line:1239] Something impossible has just happened. 38798:20131107:133341.411 [Z3005] query failed: [1205] Lock wait timeout exceeded; try restarting transaction [update ids set nextid=nextid+32 where nodeid=0 and table_name='items' and field_name='itemid']
zabbix_server [38800]:  38799:20131107:133341.411 [Z3005] query failed: [1205] Lock wait timeout exceeded; try restarting transaction [insert into items (itemid,name,key_,hostid,type,value_type,data_type,delay,delay_flex,history,trends,status,trapper_hosts,units,multiplier,delta,formula,logtimefmt,valuemapid,params,ipmi_sensor,snmp_community,snmp_oid,port,snmpv3_securityname,snmpv3_securitylevel,snmpv3_authprotocol,snmpv3_authpassphrase,snmpv3_privprotocol,snmpv3_privpassphrase,authtype,username,password,publickey,privatekey,description,interfaceid,flags,snmpv3_contextname) values (141844,'Average number of reads from the disk $3','vmware.vm.vfs.dev.read[{$URL},{HOST.HOST},scsi0:2,ops]',12480,3,3,0,60,'',90,365,0,'','',0,0,'1','',null,'','','','','','',0,0,'',0,'',0,'{$USERNAME}','{$PASSWORD}','','','',2385,4,''),(141845,'Average number of reads from the disk $3','vmware.vm.vfs.dev.read[{$URL},{HOST.HOST},scsi0:1,ops]',12480,3,3,0,60,'',90,365,0,'','',0,0,'1','',null,'','','','','','',0,0,'',0,'',0,'{$USERNAME}','{$PASSWORD}','','','',2385,4,''),(141846,'Average number of reads from the disk $3','vmware.vm.vfs.dev.read[{$URL},{HOST.HOST},scsi0:3,ops]',12480,3,3,0,60,'',90,365,0,'','',0,0,'1','',null,'','','','','','',0,0,'',0,'',0,'{$USERNAME}','{$PASSWORD}','','','',2385,4,''),(141847,'Average number of reads from the disk $3','vmware.vm.vfs.dev.read[{$URL},{HOST.HOST},scsi0:0,ops]',12480,3,3,0,60,'',90,365,0,'','',0,0,'1','',null,'','','','','','',0,0,'',0,'',0,'{$USERNAME}','{$PASSWORD}','','','',2385,4,'');
]

ERROR [file:db.c,line:1239] Something impossible has just happened.
 38822:20131107:133350.415 [Z3005] query failed: [1205] Lock wait timeout exceeded; try restarting transaction [update items set lastlogsize=82539394,mtime=0 where itemid=24074;
]
 38825:20131107:133430.435 [Z3005] query failed: [1205] Lock wait timeout exceeded; try restarting transaction [update items set lastlogsize=6096911,mtime=0 where itemid=23640;
]
 38798:20131107:133432.436 [Z3005] query failed: [1205] Lock wait timeout exceeded; try restarting transaction [update ids set nextid=nextid+32 where nodeid=0 and table_name='items' and field_name='itemid']
 38802:20131107:133432.436 [Z3005] query failed: [1205] Lock wait timeout exceeded; try restarting transaction [update ids set nextid=nextid+3 where nodeid=0 and table_name='items' and field_name='itemid']
 38800:20131107:133432.436 [Z3005] query failed: [1205] Lock wait timeout exceeded; try restarting transaction [update ids set nextid=nextid+3 where nodeid=0 and table_name='items' and field_name='itemid']
zabbix_server [38802]: ERROR [file:db.c,line:1239] Something impossible has just happened.zabbix_server [38800]:
ERROR [file:db.c,line:1239] Something impossible has just happened.
 38799:20131107:133432.436 [Z3005] query failed: [1205] Lock wait timeout exceeded; try restarting transaction [update ids set nextid=nextid+4 where nodeid=0 and table_name='items' and field_name='itemid']
zabbix_server [38799]: ERROR [file:db.c,line:1239] Something impossible has just happened.
 38801:20131107:133432.436 [Z3005] query failed: [1205] Lock wait timeout exceeded; try restarting transaction [insert into items (itemid,name,key_,hostid,type,value_type,data_type,delay,delay_flex,history,trends,status,trapper_hosts,units,multiplier,delta,formula,logtimefmt,valuemapid,params,ipmi_sensor,snmp_community,snmp_oid,port,snmpv3_securityname,snmpv3_securitylevel,snmpv3_authprotocol,snmpv3_authpassphrase,snmpv3_privprotocol,snmpv3_privpassphrase,authtype,username,password,publickey,privatekey,description,interfaceid,flags,snmpv3_contextname) values (141844,'Average number of kilobytes written to the disk $3','vmware.vm.vfs.dev.write[{$URL},{HOST.HOST},scsi0:1,bps]',12818,3,3,0,60,'',90,365,0,'','Bps',0,0,'1','',null,'','','','','','',0,0,'',0,'',0,'{$USERNAME}','{$PASSWORD}','','','',2723,4,''),(141845,'Average number of kilobytes written to the disk $3','vmware.vm.vfs.dev.write[{$URL},{HOST.HOST},scsi0:0,bps]',12818,3,3,0,60,'',90,365,0,'','Bps',0,0,'1','',null,'','','','','','',0,0,'',0,'',0,'{$USERNAME}','{$PASSWORD}','','','',2723,4,'');
]
 38822:20131107:133441.440 [Z3005] query failed: [1205] Lock wait timeout exceeded; try restarting transaction [update items set lastlogsize=82539395,mtime=0 where itemid=24074;
]
 38802:20131107:133516.702 [Z3005] query failed: [1452] Cannot add or update a child row: a foreign key constraint fails (`zabbix`.`items`, CONSTRAINT `c_items_1` FOREIGN KEY (`hostid`) REFERENCES `hosts` (`hostid`) ON DELETE CASCADE) [insert into items (itemid,name,key_,hostid,type,value_type,data_type,delay,delay_flex,history,trends,status,trapper_hosts,units,multiplier,delta,formula,logtimefmt,valuemapid,params,ipmi_sensor,snmp_community,snmp_oid,port,snmpv3_securityname,snmpv3_securitylevel,snmpv3_authprotocol,snmpv3_authpassphrase,snmpv3_privprotocol,snmpv3_privpassphrase,authtype,username,password,publickey,privatekey,description,interfaceid,flags,snmpv3_contextname) values (141876,'Average number of writes to the disk $3','vmware.vm.vfs.dev.write[{$URL},{HOST.HOST},scsi0:2,ops]',12705,3,3,0,60,'',90,365,0,'','',0,0,'1','',null,'','','','','','',0,0,'',0,'',0,'{$USERNAME}','{$PASSWORD}','','','',2610,4,''),(141877,'Average number of writes to the disk $3','vmware.vm.vfs.dev.write[{$URL},{HOST.HOST},scsi0:1,ops]',12705,3,3,0,60,'',90,365,0,'','',0,0,'1','',null,'','','','','','',0,0,'',0,'',0,'{$USERNAME}','{$PASSWORD}','','','',2610,4,''),(141878,'Average number of writes to the disk $3','vmware.vm.vfs.dev.write[{$URL},{HOST.HOST},scsi0:0,ops]',12705,3,3,0,60,'',90,365,0,'','',0,0,'1','',null,'','','','','','',0,0,'',0,'',0,'{$USERNAME}','{$PASSWORD}','','','',2610,4,'');
]
 38799:20131107:133516.704 [Z3005] query failed: [1452] Cannot add or update a child row: a foreign key constraint fails (`zabbix`.`items`, CONSTRAINT `c_items_1` FOREIGN KEY (`hostid`) REFERENCES `hosts` (`hostid`) ON DELETE CASCADE) [insert into items (itemid,name,key_,hostid,type,value_type,data_type,delay,delay_flex,history,trends,status,trapper_hosts,units,multiplier,delta,formula,logtimefmt,valuemapid,params,ipmi_sensor,snmp_community,snmp_oid,port,snmpv3_securityname,snmpv3_securitylevel,snmpv3_authprotocol,snmpv3_authpassphrase,snmpv3_privprotocol,snmpv3_privpassphrase,authtype,username,password,publickey,privatekey,description,interfaceid,flags,snmpv3_contextname) values (141876,'Average number of writes to the disk $3','vmware.vm.vfs.dev.write[{$URL},{HOST.HOST},scsi0:2,ops]',12480,3,3,0,60,'',90,365,0,'','',0,0,'1','',null,'','','','','','',0,0,'',0,'',0,'{$USERNAME}','{$PASSWORD}','','','',2385,4,''),(141877,'Average number of writes to the disk $3','vmware.vm.vfs.dev.write[{$URL},{HOST.HOST},scsi0:1,ops]',12480,3,3,0,60,'',90,365,0,'','',0,0,'1','',null,'','','','','','',0,0,'',0,'',0,'{$USERNAME}','{$PASSWORD}','','','',2385,4,''),(141878,'Average number of writes to the disk $3','vmware.vm.vfs.dev.write[{$URL},{HOST.HOST},scsi0:3,ops]',12480,3,3,0,60,'',90,365,0,'','',0,0,'1','',null,'','','','','','',0,0,'',0,'',0,'{$USERNAME}','{$PASSWORD}','','','',2385,4,''),(141879,'Average number of writes to the disk $3','vmware.vm.vfs.dev.write[{$URL},{HOST.HOST},scsi0:0,ops]',12480,3,3,0,60,'',90,365,0,'','',0,0,'1','',null,'','','','','','',0,0,'',0,'',0,'{$USERNAME}','{$PASSWORD}','','','',2385,4,'');
]
 38801:20131107:133516.705 [Z3005] query failed: [1452] Cannot add or update a child row: a foreign key constraint fails (`zabbix`.`items`, CONSTRAINT `c_items_1` FOREIGN KEY (`hostid`) REFERENCES `hosts` (`hostid`) ON DELETE CASCADE) [insert into items (itemid,name,key_,hostid,type,value_type,data_type,delay,delay_flex,history,trends,status,trapper_hosts,units,multiplier,delta,formula,logtimefmt,valuemapid,params,ipmi_sensor,snmp_community,snmp_oid,port,snmpv3_securityname,snmpv3_securitylevel,snmpv3_authprotocol,snmpv3_authpassphrase,snmpv3_privprotocol,snmpv3_privpassphrase,authtype,username,password,publickey,privatekey,description,interfaceid,flags,snmpv3_contextname) values (141876,'Average number of writes to the disk $3','vmware.vm.vfs.dev.write[{$URL},{HOST.HOST},scsi0:1,ops]',12818,3,3,0,60,'',90,365,0,'','',0,0,'1','',null,'','','','','','',0,0,'',0,'',0,'{$USERNAME}','{$PASSWORD}','','','',2723,4,''),(141877,'Average number of writes to the disk $3','vmware.vm.vfs.dev.write[{$URL},{HOST.HOST},scsi0:0,ops]',12818,3,3,0,60,'',90,365,0,'','',0,0,'1','',null,'','','','','','',0,0,'',0,'',0,'{$USERNAME}','{$PASSWORD}','','','',2723,4,'');
]
 38800:20131107:133516.707 [Z3005] query failed: [1452] Cannot add or update a child row: a foreign key constraint fails (`zabbix`.`items`, CONSTRAINT `c_items_1` FOREIGN KEY (`hostid`) REFERENCES `hosts` (`hostid`) ON DELETE CASCADE) [insert into items (itemid,name,key_,hostid,type,value_type,data_type,delay,delay_flex,history,trends,status,trapper_hosts,units,multiplier,delta,formula,logtimefmt,valuemapid,params,ipmi_sensor,snmp_community,snmp_oid,port,snmpv3_securityname,snmpv3_securitylevel,snmpv3_authprotocol,snmpv3_authpassphrase,snmpv3_privprotocol,snmpv3_privpassphrase,authtype,username,password,publickey,privatekey,description,interfaceid,flags,snmpv3_contextname) values (141876,'Average number of kilobytes read from the disk $3','vmware.vm.vfs.dev.read[{$URL},{HOST.HOST},scsi0:1,bps]',12593,3,3,0,60,'',90,365,0,'','Bps',0,0,'1','',null,'','','','','','',0,0,'',0,'',0,'{$USERNAME}','{$PASSWORD}','','','',2498,4,''),(141877,'Average number of kilobytes read from the disk $3','vmware.vm.vfs.dev.read[{$URL},{HOST.HOST},scsi0:0,bps]',12593,3,3,0,60,'',90,365,0,'','Bps',0,0,'1','',null,'','','','','','',0,0,'',0,'',0,'{$USERNAME}','{$PASSWORD}','','','',2498,4,'');
]
 38800:20131107:133516.709 [Z3005] query failed: [1452] Cannot add or update a child row: a foreign key constraint fails (`zabbix`.`items`, CONSTRAINT `c_items_1` FOREIGN KEY (`hostid`) REFERENCES `hosts` (`hostid`) ON DELETE CASCADE) [insert into items (itemid,name,key_,hostid,type,value_type,data_type,delay,delay_flex,history,trends,status,trapper_hosts,units,multiplier,delta,formula,logtimefmt,valuemapid,params,ipmi_sensor,snmp_community,snmp_oid,port,snmpv3_securityname,snmpv3_securitylevel,snmpv3_authprotocol,snmpv3_authpassphrase,snmpv3_privprotocol,snmpv3_privpassphrase,authtype,username,password,publickey,privatekey,description,interfaceid,flags,snmpv3_contextname) values (141876,'Average number of reads from the disk $3','vmware.vm.vfs.dev.read[{$URL},{HOST.HOST},scsi0:1,ops]',12593,3,3,0,60,'',90,365,0,'','',0,0,'1','',null,'','','','','','',0,0,'',0,'',0,'{$USERNAME}','{$PASSWORD}','','','',2498,4,''),(141877,'Average number of reads from the disk $3','vmware.vm.vfs.dev.read[{$URL},{HOST.HOST},scsi0:0,ops]',12593,3,3,0,60,'',90,365,0,'','',0,0,'1','',null,'','','','','','',0,0,'',0,'',0,'{$USERNAME}','{$PASSWORD}','','','',2498,4,'');
]
 38800:20131107:133516.711 [Z3005] query failed: [1452] Cannot add or update a child row: a foreign key constraint fails (`zabbix`.`items`, CONSTRAINT `c_items_1` FOREIGN KEY (`hostid`) REFERENCES `hosts` (`hostid`) ON DELETE CASCADE) [insert into items (itemid,name,key_,hostid,type,value_type,data_type,delay,delay_flex,history,trends,status,trapper_hosts,units,multiplier,delta,formula,logtimefmt,valuemapid,params,ipmi_sensor,snmp_community,snmp_oid,port,snmpv3_securityname,snmpv3_securitylevel,snmpv3_authprotocol,snmpv3_authpassphrase,snmpv3_privprotocol,snmpv3_privpassphrase,authtype,username,password,publickey,privatekey,description,interfaceid,flags,snmpv3_contextname) values (141876,'Average number of kilobytes written to the disk $3','vmware.vm.vfs.dev.write[{$URL},{HOST.HOST},scsi0:1,bps]',12593,3,3,0,60,'',90,365,0,'','Bps',0,0,'1','',null,'','','','','','',0,0,'',0,'',0,'{$USERNAME}','{$PASSWORD}','','','',2498,4,''),(141877,'Average number of kilobytes written to the disk $3','vmware.vm.vfs.dev.write[{$URL},{HOST.HOST},scsi0:0,bps]',12593,3,3,0,60,'',90,365,0,'','Bps',0,0,'1','',null,'','','','','','',0,0,'',0,'',0,'{$USERNAME}','{$PASSWORD}','','','',2498,4,'');
]
 38800:20131107:133516.713 [Z3005] query failed: [1452] Cannot add or update a child row: a foreign key constraint fails (`zabbix`.`items`, CONSTRAINT `c_items_1` FOREIGN KEY (`hostid`) REFERENCES `hosts` (`hostid`) ON DELETE CASCADE) [insert into items (itemid,name,key_,hostid,type,value_type,data_type,delay,delay_flex,history,trends,status,trapper_hosts,units,multiplier,delta,formula,logtimefmt,valuemapid,params,ipmi_sensor,snmp_community,snmp_oid,port,snmpv3_securityname,snmpv3_securitylevel,snmpv3_authprotocol,snmpv3_authpassphrase,snmpv3_privprotocol,snmpv3_privpassphrase,authtype,username,password,publickey,privatekey,description,interfaceid,flags,snmpv3_contextname) values (141876,'Average number of writes to the disk $3','vmware.vm.vfs.dev.write[{$URL},{HOST.HOST},scsi0:1,ops]',12593,3,3,0,60,'',90,365,0,'','',0,0,'1','',null,'','','','','','',0,0,'',0,'',0,'{$USERNAME}','{$PASSWORD}','','','',2498,4,''),(141877,'Average number of writes to the disk $3','vmware.vm.vfs.dev.write[{$URL},{HOST.HOST},scsi0:0,ops]',12593,3,3,0,60,'',90,365,0,'','',0,0,'1','',null,'','','','','','',0,0,'',0,'',0,'{$USERNAME}','{$PASSWORD}','','','',2498,4,'');
]
 38801:20131107:133517.617 invalid discovery rule ID [131516]
 38799:20131107:133517.622 invalid discovery rule ID [138716]
 38802:20131107:133517.622 invalid discovery rule ID [124316]
 38800:20131107:133518.555 invalid discovery rule ID [135132]
 38800:20131107:133518.566 invalid discovery rule ID [127932]
 38802:20131107:133519.690 invalid discovery rule ID [124348]
 38800:20131107:133519.691 invalid discovery rule ID [131548]
 38802:20131107:133519.700 invalid discovery rule ID [138748]
 38802:20131107:133520.430 invalid discovery rule ID [135164]
 38800:20131107:133520.431 invalid discovery rule ID [127964]
 38800:20131107:133520.440 invalid discovery rule ID [131580]
 38802:20131107:133520.440 invalid discovery rule ID [138780]
 38799:20131107:133520.440 invalid discovery rule ID [124380]
 38800:20131107:133520.456 invalid discovery rule ID [127996]
 38801:20131107:133520.457 invalid discovery rule ID [135196]
 38802:20131107:133520.467 invalid discovery rule ID [131612]
 38800:20131107:133520.467 invalid discovery rule ID [124412]
 38799:20131107:133520.467 invalid discovery rule ID [138812]
 38800:20131107:133520.485 invalid discovery rule ID [135228]
 38799:20131107:133520.486 invalid discovery rule ID [128028]
 38801:20131107:133523.755 invalid discovery rule ID [124444]
 38799:20131107:133523.755 invalid discovery rule ID [131644]
 38802:20131107:133523.756 invalid discovery rule ID [138844]
 38801:20131107:133523.812 invalid discovery rule ID [128060]
 38799:20131107:133523.813 invalid discovery rule ID [135260]
 38801:20131107:133523.858 invalid discovery rule ID [131676]
 38802:20131107:133523.859 invalid discovery rule ID [124476]
 38799:20131107:133523.859 invalid discovery rule ID [138876]
 38802:20131107:133524.048 invalid discovery rule ID [135292]
 38802:20131107:133524.052 invalid discovery rule ID [128092]
 38802:20131107:133524.108 invalid discovery rule ID [131708]
 38801:20131107:133524.108 invalid discovery rule ID [124508]
 38799:20131107:133524.109 invalid discovery rule ID [138908]
 38802:20131107:133524.416 invalid discovery rule ID [135324]
 38799:20131107:133524.533 invalid discovery rule ID [128124]