You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
{{ message }}
This repository has been archived by the owner on Jan 15, 2019. It is now read-only.
Created by mfriedrich on 2013-10-31 12:58:43 +00:00
Assignee: mfriedrich
Status: Resolved (closed on 2014-01-03 21:10:53 +00:00)
Target Version: 1.11
Last Update: 2014-12-08 14:38:17 +00:00 (in Redmine)
Icinga Version: 1.10.0
OS Version: any
due to the changes from #4544 the unique constraint and therefore index was changed and the delete_comments() retention.dat read triggering commenthistory updates (deletion_time) were using full table scans due to the missing index.
thanks to tom for debugging and testing.
CREATE INDEX commenthistory_delete_idx ON icinga_commenthistory (instance_id, comment_time, internal_comment_id);
This issue has been migrated from Redmine: https://dev.icinga.com/issues/4985
Created by mfriedrich on 2013-10-31 12:58:43 +00:00
Assignee: mfriedrich
Status: Resolved (closed on 2014-01-03 21:10:53 +00:00)
Target Version: 1.11
Last Update: 2014-12-08 14:38:17 +00:00 (in Redmine)
due to the changes from #4544 the unique constraint and therefore index was changed and the delete_comments() retention.dat read triggering commenthistory updates (deletion_time) were using full table scans due to the missing index.
thanks to tom for debugging and testing.
Changesets
2014-01-03 20:10:39 +00:00 by (unknown) 48213c7
2014-01-03 20:10:59 +00:00 by (unknown) 185e1be
Relations:
The text was updated successfully, but these errors were encountered: