[dev.icinga.com #1405] mysql: integer overflow for primary keys #335
Comments
Updated by mfriedrich on 2011-04-13 20:58:55 +00:00
that's a duplicate to #1173 which has been resolved by accident, but still needs a redo for mysql/pgsql. thanks for reporting though, please keep comments over there. |
Updated by mfriedrich on 2014-12-08 14:35:49 +00:00
|
Updated by Anonymous on 2014-12-08 14:36:01 +00:00 Delivery has failed to these recipients or groups: brian+icinga@attributor.com<mailto:brian%2Bicinga@attributor.com> Diagnostic information for administrators: Generating server: digimarc.com
Original message headers: Received: from PDX-XP-EX01.corp.digimarc.com (10.129.10.18) by |
Updated by Anonymous on 2014-12-08 14:36:14 +00:00 Delivery has failed to these recipients or groups: brian+icinga@attributor.com<mailto:brian%2Bicinga@attributor.com> Diagnostic information for administrators: Generating server: digimarc.com
Original message headers: Received: from PDX-XP-EX02.corp.digimarc.com (10.129.10.19) by |
Updated by Anonymous on 2014-12-08 14:36:25 +00:00 Delivery has failed to these recipients or groups: brian+icinga@attributor.com<mailto:brian%2Bicinga@attributor.com> Diagnostic information for administrators: Generating server: digimarc.com
Original message headers: Received: from PDX-XP-EX02.corp.digimarc.com (10.129.10.19) by |
Updated by Anonymous on 2014-12-08 14:36:38 +00:00 Delivery has failed to these recipients or groups: brian+icinga@attributor.com<mailto:brian%2Bicinga@attributor.com> Diagnostic information for administrators: Generating server: digimarc.com
Original message headers: Received: from PDX-XP-EX02.corp.digimarc.com (10.129.10.19) by |
Updated by Anonymous on 2014-12-08 14:41:21 +00:00 Delivery has failed to these recipients or groups: brian+icinga@attributor.com<mailto:brian%2Bicinga@attributor.com> Diagnostic information for administrators: Generating server: digimarc.com
Original message headers: Received: from PDX-XP-EX01.corp.digimarc.com (10.129.10.18) by |
Updated by Anonymous on 2014-12-08 14:41:41 +00:00 Delivery has failed to these recipients or groups: brian+icinga@attributor.com<mailto:brian%2Bicinga@attributor.com> Diagnostic information for administrators: Generating server: digimarc.com
Original message headers: Received: from PDX-XP-EX02.corp.digimarc.com (10.129.10.19) by |
Updated by Anonymous on 2014-12-08 14:41:55 +00:00 Delivery has failed to these recipients or groups: brian+icinga@attributor.com<mailto:brian%2Bicinga@attributor.com> Diagnostic information for administrators: Generating server: digimarc.com
Original message headers: Received: from PDX-XP-EX02.corp.digimarc.com (10.129.10.19) by |
Updated by Anonymous on 2014-12-08 14:42:09 +00:00 Delivery has failed to these recipients or groups: brian+icinga@attributor.com<mailto:brian%2Bicinga@attributor.com> Diagnostic information for administrators: Generating server: digimarc.com
Original message headers: Received: from PDX-XP-EX02.corp.digimarc.com (10.129.10.19) by |
Updated by Anonymous on 2014-12-08 14:47:20 +00:00 Delivery has failed to these recipients or groups: brian+icinga@attributor.com<mailto:brian%2Bicinga@attributor.com> Diagnostic information for administrators: Generating server: digimarc.com
Original message headers: Received: from PDX-XP-EX01.corp.digimarc.com (10.129.10.18) by |
Updated by Anonymous on 2014-12-08 14:47:38 +00:00 Delivery has failed to these recipients or groups: brian+icinga@attributor.com<mailto:brian%2Bicinga@attributor.com> Diagnostic information for administrators: Generating server: digimarc.com
Original message headers: Received: from PDX-XP-EX01.corp.digimarc.com (10.129.10.18) by |
Updated by Anonymous on 2014-12-08 14:47:52 +00:00 Delivery has failed to these recipients or groups: brian+icinga@attributor.com<mailto:brian%2Bicinga@attributor.com> Diagnostic information for administrators: Generating server: digimarc.com
Original message headers: Received: from PDX-XP-EX02.corp.digimarc.com (10.129.10.19) by |
Updated by Anonymous on 2014-12-08 14:48:03 +00:00 Delivery has failed to these recipients or groups: brian+icinga@attributor.com<mailto:brian%2Bicinga@attributor.com> Diagnostic information for administrators: Generating server: digimarc.com
Original message headers: Received: from PDX-XP-EX01.corp.digimarc.com (10.129.10.18) by |
Updated by Anonymous on 2014-12-08 14:48:13 +00:00 Delivery has failed to these recipients or groups: brian+icinga@attributor.com<mailto:brian%2Bicinga@attributor.com> Diagnostic information for administrators: Generating server: digimarc.com
Original message headers: Received: from PDX-XP-EX02.corp.digimarc.com (10.129.10.19) by |
Updated by postmaster@digimarc.com on 2014-12-08 14:53:37 +00:00 Delivery has failed to these recipients or groups: brian+icinga@attributor.com<mailto:brian%2Bicinga@attributor.com> Diagnostic information for administrators: Generating server: digimarc.com
Original message headers: Received: from PDX-XP-EX01.corp.digimarc.com (10.129.10.18) by |
Updated by postmaster@digimarc.com on 2014-12-08 14:53:52 +00:00 Delivery has failed to these recipients or groups: brian+icinga@attributor.com<mailto:brian%2Bicinga@attributor.com> Diagnostic information for administrators: Generating server: digimarc.com
Original message headers: Received: from PDX-XP-EX01.corp.digimarc.com (10.129.10.18) by |
Updated by postmaster@digimarc.com on 2014-12-08 14:54:03 +00:00 Delivery has failed to these recipients or groups: brian+icinga@attributor.com<mailto:brian%2Bicinga@attributor.com> Diagnostic information for administrators: Generating server: digimarc.com
Original message headers: Received: from PDX-XP-EX01.corp.digimarc.com (10.129.10.18) by |
Updated by postmaster@digimarc.com on 2014-12-08 14:54:14 +00:00 Delivery has failed to these recipients or groups: brian+icinga@attributor.com<mailto:brian%2Bicinga@attributor.com> Diagnostic information for administrators: Generating server: digimarc.com
Original message headers: Received: from PDX-XP-EX01.corp.digimarc.com (10.129.10.18) by |
Updated by postmaster@digimarc.com on 2014-12-08 14:54:24 +00:00 Delivery has failed to these recipients or groups: brian+icinga@attributor.com<mailto:brian%2Bicinga@attributor.com> Diagnostic information for administrators: Generating server: digimarc.com
Original message headers: Received: from PDX-XP-EX01.corp.digimarc.com (10.129.10.18) by |
Updated by postmaster@digimarc.com on 2014-12-08 14:54:36 +00:00 Delivery has failed to these recipients or groups: brian+icinga@attributor.com<mailto:brian%2Bicinga@attributor.com> Diagnostic information for administrators: Generating server: digimarc.com
Original message headers: Received: from PDX-XP-EX02.corp.digimarc.com (10.129.10.19) by |
Updated by postmaster@digimarc.com on 2014-12-08 14:59:29 +00:00 Delivery has failed to these recipients or groups: brian+icinga@attributor.com<mailto:brian%2Bicinga@attributor.com> Diagnostic information for administrators: Generating server: digimarc.com
Original message headers: Received: from PDX-XP-EX01.corp.digimarc.com (10.129.10.18) by |
Updated by postmaster@digimarc.com on 2014-12-08 14:59:44 +00:00 Delivery has failed to these recipients or groups: brian+icinga@attributor.com<mailto:brian%2Bicinga@attributor.com> Diagnostic information for administrators: Generating server: digimarc.com
Original message headers: Received: from PDX-XP-EX02.corp.digimarc.com (10.129.10.19) by |
Updated by postmaster@digimarc.com on 2014-12-08 14:59:56 +00:00 Delivery has failed to these recipients or groups: brian+icinga@attributor.com<mailto:brian%2Bicinga@attributor.com> Diagnostic information for administrators: Generating server: digimarc.com
Original message headers: Received: from PDX-XP-EX01.corp.digimarc.com (10.129.10.18) by |
Updated by postmaster@digimarc.com on 2014-12-08 15:00:09 +00:00 Delivery has failed to these recipients or groups: brian+icinga@attributor.com<mailto:brian%2Bicinga@attributor.com> Diagnostic information for administrators: Generating server: digimarc.com
Original message headers: Received: from PDX-XP-EX02.corp.digimarc.com (10.129.10.19) by |
Updated by postmaster@digimarc.com on 2014-12-08 15:00:24 +00:00 Delivery has failed to these recipients or groups: brian+icinga@attributor.com<mailto:brian%2Bicinga@attributor.com> Diagnostic information for administrators: Generating server: digimarc.com
Original message headers: Received: from PDX-XP-EX01.corp.digimarc.com (10.129.10.18) by |
Updated by postmaster@digimarc.com on 2014-12-08 15:00:36 +00:00 Delivery has failed to these recipients or groups: brian+icinga@attributor.com<mailto:brian%2Bicinga@attributor.com> Diagnostic information for administrators: Generating server: digimarc.com
Original message headers: Received: from PDX-XP-EX02.corp.digimarc.com (10.129.10.19) by |
Updated by postmaster@digimarc.com on 2014-12-08 15:04:11 +00:00 Delivery has failed to these recipients or groups: brian+icinga@attributor.com<mailto:brian%2Bicinga@attributor.com> Diagnostic information for administrators: Generating server: digimarc.com
Original message headers: Received: from PDX-XP-EX01.corp.digimarc.com (10.129.10.18) by |
Updated by postmaster@digimarc.com on 2014-12-08 15:05:34 +00:00 Delivery has failed to these recipients or groups: brian+icinga@attributor.com<mailto:brian%2Bicinga@attributor.com> Diagnostic information for administrators: Generating server: digimarc.com
Original message headers: Received: from PDX-XP-EX01.corp.digimarc.com (10.129.10.18) by |
Updated by postmaster@digimarc.com on 2014-12-08 15:05:47 +00:00 Delivery has failed to these recipients or groups: brian+icinga@attributor.com<mailto:brian%2Bicinga@attributor.com> Diagnostic information for administrators: Generating server: digimarc.com
Original message headers: Received: from PDX-XP-EX02.corp.digimarc.com (10.129.10.19) by |
Updated by postmaster@digimarc.com on 2014-12-08 15:05:58 +00:00 Delivery has failed to these recipients or groups: brian+icinga@attributor.com<mailto:brian%2Bicinga@attributor.com> Diagnostic information for administrators: Generating server: digimarc.com
Original message headers: Received: from PDX-XP-EX02.corp.digimarc.com (10.129.10.19) by |
Updated by postmaster@digimarc.com on 2014-12-08 15:06:11 +00:00 Delivery has failed to these recipients or groups: brian+icinga@attributor.com<mailto:brian%2Bicinga@attributor.com> Diagnostic information for administrators: Generating server: digimarc.com
Original message headers: Received: from PDX-XP-EX01.corp.digimarc.com (10.129.10.18) by |
Updated by postmaster@digimarc.com on 2014-12-08 15:06:26 +00:00 Delivery has failed to these recipients or groups: brian+icinga@attributor.com<mailto:brian%2Bicinga@attributor.com> Diagnostic information for administrators: Generating server: digimarc.com
Original message headers: Received: from PDX-XP-EX02.corp.digimarc.com (10.129.10.19) by |
Updated by postmaster@digimarc.com on 2014-12-08 15:06:38 +00:00 Delivery has failed to these recipients or groups: brian+icinga@attributor.com<mailto:brian%2Bicinga@attributor.com> Diagnostic information for administrators: Generating server: digimarc.com
Original message headers: Received: from PDX-XP-EX01.corp.digimarc.com (10.129.10.18) by |
Updated by postmaster@digimarc.com on 2014-12-08 15:11:47 +00:00 Delivery has failed to these recipients or groups: brian+icinga@attributor.com<mailto:brian%2Bicinga@attributor.com> Diagnostic information for administrators: Generating server: digimarc.com
Original message headers: Received: from PDX-XP-EX01.corp.digimarc.com (10.129.10.18) by |
Updated by postmaster@digimarc.com on 2014-12-08 15:12:04 +00:00 Delivery has failed to these recipients or groups: brian+icinga@attributor.com<mailto:brian%2Bicinga@attributor.com> Diagnostic information for administrators: Generating server: digimarc.com
Original message headers: Received: from PDX-XP-EX01.corp.digimarc.com (10.129.10.18) by |
Updated by postmaster@digimarc.com on 2014-12-08 15:12:16 +00:00 Delivery has failed to these recipients or groups: brian+icinga@attributor.com<mailto:brian%2Bicinga@attributor.com> Diagnostic information for administrators: Generating server: digimarc.com
Original message headers: Received: from PDX-XP-EX01.corp.digimarc.com (10.129.10.18) by |
Updated by postmaster@digimarc.com on 2014-12-08 15:12:27 +00:00 Delivery has failed to these recipients or groups: brian+icinga@attributor.com<mailto:brian%2Bicinga@attributor.com> Diagnostic information for administrators: Generating server: digimarc.com
Original message headers: Received: from PDX-XP-EX02.corp.digimarc.com (10.129.10.19) by |
Updated by postmaster@digimarc.com on 2014-12-08 15:12:40 +00:00 Delivery has failed to these recipients or groups: brian+icinga@attributor.com<mailto:brian%2Bicinga@attributor.com> Diagnostic information for administrators: Generating server: digimarc.com
Original message headers: Received: from PDX-XP-EX02.corp.digimarc.com (10.129.10.19) by |
Updated by postmaster@digimarc.com on 2014-12-08 15:17:43 +00:00 Delivery has failed to these recipients or groups: brian+icinga@attributor.com<mailto:brian%2Bicinga@attributor.com> Diagnostic information for administrators: Generating server: digimarc.com
Original message headers: Received: from PDX-XP-EX01.corp.digimarc.com (10.129.10.18) by |
Updated by postmaster@digimarc.com on 2014-12-08 15:18:10 +00:00 Delivery has failed to these recipients or groups: brian+icinga@attributor.com<mailto:brian%2Bicinga@attributor.com> Diagnostic information for administrators: Generating server: digimarc.com
Original message headers: Received: from PDX-XP-EX01.corp.digimarc.com (10.129.10.18) by |
Updated by postmaster@digimarc.com on 2014-12-08 15:18:24 +00:00 Delivery has failed to these recipients or groups: brian+icinga@attributor.com<mailto:brian%2Bicinga@attributor.com> Diagnostic information for administrators: Generating server: digimarc.com
Original message headers: Received: from PDX-XP-EX02.corp.digimarc.com (10.129.10.19) by |
Updated by postmaster@digimarc.com on 2014-12-08 15:18:35 +00:00 Delivery has failed to these recipients or groups: brian+icinga@attributor.com<mailto:brian%2Bicinga@attributor.com> Diagnostic information for administrators: Generating server: digimarc.com
Original message headers: Received: from PDX-XP-EX01.corp.digimarc.com (10.129.10.18) by |
This issue has been migrated from Redmine: https://dev.icinga.com/issues/1405
Created by brianatb on 2011-04-13 20:27:27 +00:00
Assignee: (none)
Status: Closed (closed on 2011-04-13 20:58:55 +00:00)
Target Version: (none)
Last Update: 2014-12-08 15:18:35 +00:00 (in Redmine)
I ran into a situation where the primary key of table icinga_servicestatus hit the maximum value allowed for INT. In mysql, INT means 32 bit. I've subsequently run into this for more tables.
I'd like to suggest changing all the INT keys in the mysql schema to BIGINT (64 bit). While you're in there, please also consider marking them as UNSIGNED.
A word of warning for any who run into this before it's fixed in your copy of icinga, when I simply went through and systematically changed all the INTs to BIGINTs I became quite miserable. Upon icinga reload, many tables such as icinga_services wound up with exactly one entry, with the object_id set to zero. Somewhere between the select object_id from icinga_objects and issuance of the insert or update to icinga_services, that object_id becomes zero. I haven't looked into it far enough to say for sure, but offhand I'd guess that the 32-bitness of INT is baked into ido somewhere.
Relations:
The text was updated successfully, but these errors were encountered: