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 #9586] DB IDO: endpoint* tables are cleared on reload causing constraint violations #3136
Comments
Updated by mfriedrich on 2015-07-08 11:57:35 +00:00
|
Updated by mfriedrich on 2015-07-08 11:57:50 +00:00
|
Updated by mfriedrich on 2015-07-08 11:58:00 +00:00
|
Updated by Anonymous on 2015-07-08 12:10:03 +00:00
Applied in changeset 3fe6b56. |
Updated by gbeutner on 2015-07-13 08:26:12 +00:00
|
Updated by dsargrad on 2015-07-17 18:56:52 +00:00 Anonymous wrote:
We have the following version installed:
We are seeing the same problem:
Oddly we are able to patch the database as follows:
Then the exception goes away, and everything is fine. The way the fix (https://dev.icinga.org/projects/i2/repository/revisions/3fe6b56628dfc359dd8cd02c41de766eb44f0204/diff/lib/db\_ido/dbconnection.cpp ) reads it seems that you dont want to truncate these tables... Whereas for us truncating these tables makes the problem go away. So im a bit confused. Why does truncating seem to fix the problem? What version is this fixed in, and when will that be available for download? We currently install icinga2 after performing the following commands:
|
Updated by mfriedrich on 2015-07-17 20:39:58 +00:00 This isn't the correct issue. The error you are seeing is described in #9634 |
Updated by mfriedrich on 2015-07-17 20:40:15 +00:00
|
This issue has been migrated from Redmine: https://dev.icinga.com/issues/9586
Created by smadmin on 2015-07-08 11:56:00 +00:00
Assignee: mfriedrich
Status: Resolved (closed on 2015-07-08 12:10:03 +00:00)
Target Version: 2.3.7
Last Update: 2015-07-17 20:39:58 +00:00 (in Redmine)
In the icinga.log we see the following error concerning IdoPgsqlConnection failing to insert in endpoints table.
Querying the table shows no entries. If the statement is executed directly in a psql shell it works, and the endpoint_id indicates that there were some entries before. But after a reload of icinga the table entries are removed and the error returns.
We had some trouble both nodes not writing in the database perhaps because of this.
Database is postgresql 9.2.10 from RHEL7.
Changesets
2015-07-08 11:58:12 +00:00 by (unknown) 3fe6b56
2015-07-13 08:26:01 +00:00 by (unknown) 8545c50
Relations:
The text was updated successfully, but these errors were encountered: