[dev.icinga.com #2571] tactical overview - charts/groups/customvars with postgresql query error

[icinga-migration]

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

Created by mfriedrich on 2012-04-30 17:48:57 +00:00

Assignee: jmosshammer
Status: Resolved (closed on 2012-05-02 10:50:32 +00:00)
Target Version: 1.7
Last Update: 2012-05-09 08:17:20 +00:00 (in Redmine)

---

debian 6.0.4 x64
icinga-web git master
backend postgresql 9.1
idoutils 1.7.0-dev

commit 5af32a3843d8168bfc17e32c9dfc6009df09e8a4
Author: Jannis Mosshammer 
Date:   Fri Apr 27 15:28:21 2012 +0200

    Applied sgronewold's patch for removing min/max/avg latencies
    fixes #2439

TO: Overall status with charts

SQLSTATE[42803]: Grouping error: 7 ERROR: column "i2.has_been_checked" must appear in the GROUP BY clause or be used in an aggregate function LINE 1: ...t_object_id) AS i__1, i2.current_state AS i2__2, (i2.has_bee... ^

TO: By host- and servicegroups

Hostgroups  Servicegroups   Misc
SQLSTATE[42803]: Grouping error: 7 ERROR: column "i2.has_been_checked" must appear in the GROUP BY clause or be used in an aggregate function LINE 1: ...t_object_id) AS i__1, i2.current_state AS i2__2, (i2.has_bee... ^

TO: Howto organize by customvariables

SQLSTATE[42803]: Grouping error: 7 ERROR: column "i2.has_been_checked" must appear in the GROUP BY clause or be used in an aggregate function LINE 1: ...t_object_id) AS i__1, i2.current_state AS i2__2, (i2.has_bee... ^

Changesets

2012-05-02 07:25:12 +00:00 by jmosshammer 5d83134

Fixed issues in TO views and  strict legacyview (fixes #2571, refs #2439)

[icinga-migration]

Updated by jmosshammer on 2012-05-02 06:37:37 +00:00

• Assigned to set to jmosshammer

[icinga-migration]

Updated by jmosshammer on 2012-05-02 10:50:32 +00:00

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

Applied in changeset 5d83134.

[icinga-migration]

Updated by viaLAN on 2012-05-08 07:46:24 +00:00

Nach Einspielen des Diffs auf icinga-web 1.6.2 lautet die Fehlermeldung wie folgt:

TO: Overall status with charts

SQLSTATE[42803]: Grouping error: 7 FEHLER: Spalte »i.has_been_checked« muss in der GROUP-BY-Klausel erscheinen oder in einer Aggregatfunktion verwendet werden LINE 1: ...ce_object_id) AS i2__1, i.current_state AS i__2, (i.has_been... ^

[icinga-migration]

Updated by mfriedrich on 2012-05-08 08:22:33 +00:00

viaLAN wrote:

Nach Einspielen des Diffs auf icinga-web 1.6.2 lautet die Fehlermeldung wie folgt:

TO: Overall status with charts

SQLSTATE[42803]: Grouping error: 7 FEHLER: Spalte »i.has_been_checked« muss in der GROUP-BY-Klausel erscheinen oder in einer Aggregatfunktion verwendet werden LINE 1: ...ce_object_id) AS i2__1, i.current_state AS i__2, (i.has_been... ^

invalid. diffs do not match against 1.6.x tree.

my tests work fine, no more query issues on current git master.

$ git log -1
commit 8cdb2a1c7eaab3b60c598aaac7b9b1c282e57df6
Author: Marius Hein 
Date:   Tue May 8 09:00:00 2012 +0200

    Layout fix for booleanImage renderer

    Centered positioning and qtip fix, refs #1558

[icinga-migration]

Updated by viaLAN on 2012-05-09 08:17:20 +00:00

got the git version from today and it works without error