Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

[dev.icinga.com #5265] unique constraint violation in table icinga_contactnotifications #1010

Closed
icinga-migration opened this issue Dec 5, 2013 · 8 comments

Comments

Projects
None yet
1 participant
@icinga-migration
Copy link
Member

commented Dec 5, 2013

This issue has been migrated from Redmine: https://dev.icinga.com/issues/5265

Created by mfriedrich on 2013-12-05 09:59:05 +00:00

Assignee: mfriedrich
Status: Resolved (closed on 2014-01-28 16:57:48 +00:00)
Target Version: 0.0.7
Last Update: 2014-09-16 09:19:36 +00:00 (in Redmine)

Icinga Version: 0.0.6-dev

[2013-12-05 10:48:49 +0100]  debug/db_ido: add contact notification history for 'c1-exchange-1:win-nrpe-version'
[2013-12-05 10:48:49 +0100]  debug/db_ido: add contact notification history for 'c1-exchange-1:win-network sent'
[2013-12-05 10:48:49 +0100]  debug/db_ido: add contact notification history for 'c1-exchange-1:win-proc NSClient'
[2013-12-05 10:48:49 +0100]  debug/db_ido: add log entry history for 'c1-exchange-1:win-proc NSClient'
[2013-12-05 10:48:49 +0100]  information/icinga: Completed sending notification for service 'c1-exchange-1:win-proc NSClient'
[2013-12-05 10:48:49 +0100]  debug/db_ido_mysql: Query: INSERT INTO icinga_contactnotifications (contact_object_id, end_time, end_time_usec, instance_id, notification_id, start_time, start_time_usec) VALUE
S (27, FROM_UNIXTIME(1386236929), '71604', 1, 32186, FROM_UNIXTIME(1386236929), '71604')
[2013-12-05 10:48:49 +0100]  debug/db_ido: add log entry history for 'c1-exchange-1:win-nrpe-version'
[2013-12-05 10:48:49 +0100]  debug/db_ido: add log entry history for 'c1-exchange-1:win-network sent'
[2013-12-05 10:48:49 +0100]  information/icinga: Completed sending notification for service 'c1-exchange-1:win-network sent'
[2013-12-05 10:48:49 +0100]  information/icinga: Completed sending notification for service 'c1-exchange-1:win-nrpe-version'
[2013-12-05 10:48:49 +0100]  debug/db_ido_mysql: Query: INSERT INTO icinga_contactnotifications (contact_object_id, end_time, end_time_usec, instance_id, notification_id, start_time, start_time_usec) VALUE
S (27, FROM_UNIXTIME(1386236929), '71753', 1, 32186, FROM_UNIXTIME(1386236929), '71753')
[2013-12-05 10:48:49 +0100]  debug/db_ido_mysql: Query: INSERT INTO icinga_contactnotifications (contact_object_id, end_time, end_time_usec, instance_id, notification_id, start_time, start_time_usec) VALUE
S (27, FROM_UNIXTIME(1386236929), '71753', 1, 32186, FROM_UNIXTIME(1386236929), '71753')
[2013-12-05 10:48:49 +0100]  critical/db_ido_mysql: Exception during database operation: /usr/local/src/icinga2/components/db_ido_mysql/idomysqlconnection.cpp(281): Throw in function icinga::Array::Ptr ici
nga::IdoMysqlConnection::Query(const icinga::String&)
Dynamic exception type: boost::exception_detail::clone_impl
std::exception::what: std::exception
[icinga::StackTrace*] = 
        (0) /opt/i2/icinga2/lib/x86_64-linux-gnu/icinga2/libdb_ido_mysql.so: void boost::throw_exception(icinga::database_error const&) (+0x4a) [0x7f9a5073303a]
        (1) /opt/i2/icinga2/lib/x86_64-linux-gnu/icinga2/libdb_ido_mysql.so: void boost::exception_detail::throw_exception_(icinga::database_error const&, char const*, ch
ar const*, int) (+0x3c) [0x7f9a5073309c]
        (2) /opt/i2/icinga2/lib/x86_64-linux-gnu/icinga2/libdb_ido_mysql.so: icinga::IdoMysqlConnection::Query(icinga::String const&) (+0x564) [0x7f9a507255d4]
        (3) /opt/i2/icinga2/lib/x86_64-linux-gnu/icinga2/libdb_ido_mysql.so: icinga::IdoMysqlConnection::InternalExecuteQuery(icinga::DbQuery const&) (+0x308) [0x7f9a50727a68]
        (4) /opt/i2/icinga2/lib/x86_64-linux-gnu/icinga2/libbase.so: icinga::WorkQueue::ProcessItems(boost::unique_lock&, bool) (+0x14d) [0x7f9a54d5944d]
        (5) /opt/i2/icinga2/lib/x86_64-linux-gnu/icinga2/libbase.so: icinga::WorkQueue::WorkerThreadProc() (+0xf1) [0x7f9a54d597b1]
        (6) /usr/lib/libboost_thread.so.1.49.0:  (+0x10629) [0x7f9a553e3629]
        (7) /lib/x86_64-linux-gnu/libpthread.so.0:  (+0x6b50) [0x7f9a54fc8b50]
        (8) /lib/x86_64-linux-gnu/libc.so.6: clone (+0x6d) [0x7f9a530f8a7d]


[icinga::ContextTrace*] = 

[icinga::errinfo_message_*] = Duplicate entry '1-27-2013-12-05 09:48:49-71753' for key 'instance_id'
[icinga::errinfo_database_query_*] = INSERT INTO icinga_contactnotifications (contact_object_id, end_time, end_time_usec, instance_id, notification_id, start_time, start_time_usec) VALUES (27, FROM_UNIXTIME(13862
36929), '71753', 1, 32186, FROM_UNIXTIME(1386236929), '71753')

[2013-12-05 10:48:49 +0100]  debug/db_ido: add contact notification history for 'c1-exchange-1:win-mem physical'
[2013-12-05 10:48:49 +0100]  debug/db_ido: add log entry history for 'c1-exchange-1:win-mem physical'
[2013-12-05 10:48:49 +0100]  debug/db_ido: add contact notification history for 'c1-exchange-1:win-network received'
[2013-12-05 10:48:49 +0100]  debug/db_ido: add contact notification history for 'c1-exchange-1:win-mem virtual'

Changesets

2014-01-28 14:53:12 +00:00 by (unknown) f30eca5

DB IDO: Refactor notification signal handling.

Refs #5103
Fixes #5265

2014-01-28 16:53:40 +00:00 by (unknown) a3097ff

DB IDO: Fix the way notification_id is handled.

Fixes #5103
Fixes #5265

Relations:

@icinga-migration

This comment has been minimized.

Copy link
Member Author

commented Dec 5, 2013

Updated by mfriedrich on 2013-12-05 12:22:08 +00:00

  • Status changed from Assigned to Feedback
  • Assigned to deleted mfriedrich
  • Target Version deleted 0.0.6

notification_id shouldn't be the same. this is originally caused by #5103

@icinga-migration

This comment has been minimized.

Copy link
Member Author

commented Dec 9, 2013

Updated by gbeutner on 2013-12-09 08:56:16 +00:00

  • Assigned to set to mfriedrich
@icinga-migration

This comment has been minimized.

Copy link
Member Author

commented Jan 28, 2014

Updated by mfriedrich on 2014-01-28 14:54:29 +00:00

  • Status changed from Feedback to Assigned
  • Target Version set to 0.0.7
@icinga-migration

This comment has been minimized.

Copy link
Member Author

commented Jan 28, 2014

Updated by Anonymous on 2014-01-28 14:54:37 +00:00

  • Status changed from Assigned to Resolved
  • Done % changed from 0 to 100

Applied in changeset i2:f30eca5a7321f6c2d9be74fee1e7909d8b279027.

@icinga-migration

This comment has been minimized.

Copy link
Member Author

commented Jan 28, 2014

Updated by mfriedrich on 2014-01-28 16:49:52 +00:00

  • Status changed from Resolved to Assigned
  • Done % changed from 100 to 0

appears still broken using multiple contacts.

@icinga-migration

This comment has been minimized.

Copy link
Member Author

commented Jan 28, 2014

Updated by Anonymous on 2014-01-28 16:57:48 +00:00

  • Status changed from Assigned to Resolved
  • Done % changed from 0 to 100

Applied in changeset i2:a3097ff3c63abd7995bcee1d0e49aac7c655b74d.

@icinga-migration

This comment has been minimized.

Copy link
Member Author

commented Sep 16, 2014

Updated by mfriedrich on 2014-09-16 09:19:36 +00:00

  • Project changed from 32 to Icinga 2
  • Category changed from 162 to DB IDO
@icinga-migration

This comment has been minimized.

Copy link
Member Author

commented Mar 21, 2016

Updated by mfriedrich on 2016-03-21 09:57:31 +00:00

  • Relates set to 11387
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
You can’t perform that action at this time.