[dev.icinga.com #3921] Duplicates on services

[icinga-migration]

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

Created by mhein on 2013-04-04 09:39:19 +00:00

Assignee: mhein
Status: Resolved (closed on 2013-04-15 13:18:09 +00:00)
Target Version: (none)
Last Update: 2013-04-15 13:18:09 +00:00 (in Redmine)

Icinga Version: 1.9.0
Icinga Web Version: 1.9.0
IDO Version: 1.9.0
OS Version: Fedora 18
DB Type: MySQL
DB Version: 5.1.67
Browser Version: Chrome 26.0.1410.33

---

On some databases services query gets duplicated rows.

Changesets

2013-04-04 09:57:40 +00:00 by mhein f580758

Duplicates on services

Added DISTINCT to service querys. With various credentials
this will resolve double service entries in grid.

fixes #3921

---

Relations:

• relates #3855
• relates #3921

[icinga-migration]

Updated by mhein on 2013-04-04 10:12:30 +00:00

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

Applied in changeset f580758.

[icinga-migration]

Updated by mfriedrich on 2013-04-13 20:09:46 +00:00

• Status changed from Resolved to Assigned

can you please re-check the DISTINCT fixes with oracle? it seems that there are various bugs around mentioned in https://dev.icinga.org/issues/3855#note-13 where DISTINCT is not allowed in queries fetching clobs.

this not only affects services, but hosts as well. and i do remember that we have had that in the past already.

it might be better to drop the distinct on the complete query and only select distinct on the required keys first.

rsim/oracle-enhanced#112
http://www.dbforums.com/oracle/1683783-how-retrieve-clob-data-when-using-distinct-keyword-other-columns-sql.html

please check #3965 for details.

[icinga-migration]

Updated by mhein on 2013-04-15 13:18:09 +00:00

• Status changed from Assigned to Resolved

Resolved, see related issues