Hi, newbie wrote: > My ido2db had error meeage every hour with some like: > > ido2db: Error: database query failed for 'DELETE FROM > icinga_systemcommands WHERE instance_id=1 AND > start_time<FROM_UNIXTIME' - '2006: MySQL server has gone away' > > I already put my max_allow_packet more than 128M, but problem still... > > Where is the point and how should I do?
I'm seeing the same errors: -------------------------------------------------------------------------------------------------------------------------------------------------- ido2db: Error: database query failed for 'DELETE FROM icinga_systemcommands WHERE instance_id=1 AND start_time<FROM_UNIXTIME(1397559094)' - '2006: MySQL server has gone away' ido2db: Error: database query failed for 'DELETE FROM icinga_servicechecks WHERE instance_id=1 AND start_time<FROM_UNIXTIME(1397559094)' - '2006: MySQL server has gone away' ido2db: Error: database query failed for 'DELETE FROM icinga_hostchecks WHERE instance_id=1 AND start_time<FROM_UNIXTIME(1397559094)' - '2006: MySQL server has gone away' ido2db: Error: database query failed for 'DELETE FROM icinga_eventhandlers WHERE instance_id=1 AND start_time<FROM_UNIXTIME(1397040694)' - '2006: MySQL server has gone away' ido2db: Error: database query failed for 'DELETE FROM icinga_externalcommands WHERE instance_id=1 AND entry_time<FROM_UNIXTIME(1397040694)' - '2006: MySQL server has gone away' ido2db: Error: database query failed for 'DELETE FROM icinga_logentries WHERE instance_id=1 AND logentry_time<FROM_UNIXTIME(1394967094)' - '2006: MySQL server has gone away' ido2db: Error: database query failed for 'DELETE FROM icinga_acknowledgements WHERE instance_id=1 AND entry_time<FROM_UNIXTIME(1394967094)' - '2006: MySQL server has gone away' ido2db: Error: database query failed for 'DELETE FROM icinga_notifications WHERE instance_id=1 AND start_time<FROM_UNIXTIME(1394967094)' - '2006: MySQL server has gone away' ido2db: Error: database query failed for 'DELETE FROM icinga_contactnotifications WHERE instance_id=1 AND start_time<FROM_UNIXTIME(1394967094)' - '2006: MySQL server has gone away' ido2db: Error: database query failed for 'DELETE FROM icinga_contactnotificationmethods WHERE instance_id=1 AND start_time<FROM_UNIXTIME(1394967094)' - '2006: MySQL server has gone away' ido2db: Error: database query failed for 'DELETE FROM icinga_downtimehistory WHERE instance_id=1 AND entry_time<FROM_UNIXTIME(1394967094)' - '2006: MySQL server has gone away' -------------------------------------------------------------------------------------------------------------------------------------------------- in my /var/log/syslog running icinga/icinga-idoutils 1.11.1-1~debmon70+1 on a Debian Wheezy. If i'm logging directly into the database with the icinga-idoutils MySQL user and run that commands they are successfully executed. Are there any differences or timeouts in place between the direct calls of the commands and the commands executed by the icinga-idoutils? _______________________________________________ icinga-users mailing list icinga-users@lists.icinga.org https://lists.icinga.org/mailman/listinfo/icinga-users
