Percona Monitoring Plugins

sql query for idle_blocker_duraction check in pmp-check-mysql-innodb does not conform ONLY_FULL_GROUP_BY

Bug #1240417 reported by Roman Vynar on 2013-10-16

This bug affects 1 person

Affects		Status	Importance	Assigned to	Milestone
	Percona Monitoring Plugins	Fix Released	Medium	Unassigned	Percona Monitoring Plugins 1.1

SQL query for "idle_blocker_duraction" check in pmp-check-mysql-innodb does not conform sql_mode with the option ONLY_FULL_GROUP_BY:

ERROR 1140 (42000) at line 2: Mixing of GROUP columns (MIN(),MAX(),COUNT(),...) with no GROUP columns is illegal if there is no GROUP BY clause

Tags:

Roman Vynar (roman-vynar) on 2013-10-16

Changed in percona-monitoring-plugins:
importance:	Undecided → Medium
tags:	added: nagios

Roman Vynar (roman-vynar) on 2013-10-24

Changed in percona-monitoring-plugins:
status:	New → Confirmed

Roman Vynar (roman-vynar) on 2013-11-19

Changed in percona-monitoring-plugins:
milestone:	none → 1.1
status:	Confirmed → Fix Committed

Roman Vynar (roman-vynar) on 2013-12-18

Changed in percona-monitoring-plugins:
status:	Fix Committed → Fix Released

This report contains Public information

Everyone can see this information.

You are

Subscribing...

Bug watches keep track of this bug in other bug trackers.