Bug #50436 perfschema.aggregate fails on HPUX in 6.0
Submitted: 19 Jan 2010 9:53 Modified: 6 Mar 2010 19:41
Reporter: Alexander Nozdrin Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Server: Performance Schema Severity:S1 (Critical)
Version:6.0, 5.5.99-m3 OS:HP/UX
Assigned to: Marc ALFF CPU Architecture:Any
Tags: experimental, pb2, test failure

[19 Jan 2010 9:53] Alexander Nozdrin
Description:
perfschema.aggregate fails on HPUX in 6.0:
perfschema.aggregate [ fail ]
        Test ended at 2010-01-18 21:26:18

CURRENT_TEST: perfschema.aggregate
*** /export/tmp/pb2/test/sb_1-1195634-1263843668.4/mysql-6.0.14-alpha-hpux11.31-ia64-test/mysql-test/suite/perfschema/r/aggregate.result Mon Jan 18 18:31:16 2010
--- /export/tmp/pb2/test/sb_1-1195634-1263843668.4/mysql-6.0.14-alpha-hpux11.31-ia64-test/mysql-test/suite/perfschema/r/aggregate.reject	Mon Jan 18 23:26:18 2010
*************** *** 54,59 ****
--- 54,60 ----
  HAVING (e.SUM_TIMER_WAIT <> SUM(i.SUM_TIMER_WAIT))
  OR @dump_all;
  EVENT_NAME	SUM_TIMER_WAIT	SUM(i.SUM_TIMER_WAIT)
+ wait/synch/mutex/mysys/st_my_file_info:mutex	470852000	280304000
  SELECT EVENT_NAME, e.MIN_TIMER_WAIT, MIN(i.MIN_TIMER_WAIT)
  FROM performance_schema.EVENTS_WAITS_SUMMARY_BY_EVENT_NAME AS e
  JOIN performance_schema.EVENTS_WAITS_SUMMARY_BY_INSTANCE AS i USING (EVENT_NAME)

mysqltest: Result content mismatch

How to repeat:
See PB2/XRef2.
[20 Jan 2010 15:42] Alexander Nozdrin
The test case has been marked experimental
in 6.0 on HPUX due to this bug.
[26 Jan 2010 4:56] Bugs System
A patch for this bug has been committed. After review, it may
be pushed to the relevant source trees for release in the next
version. You can access the patch from:

  http://lists.mysql.com/commits/98140

2975 Marc Alff	2010-01-25
      Bug#50436 perfschema.aggregate fails on HPUX in 6.0
      
      Relaxed the test conditions to account for objects destroyed,
      as was intended in the comments in mysql-test/suite/perfschema/t/aggregate.test
[27 Jan 2010 16:27] Marc ALFF
Patch queued in:
- mysql-next-mr-marc
- mysql-6.0-codebase-marc
[13 Feb 2010 8:37] Bugs System
Pushed into 6.0.14-alpha (revid:alik@sun.com-20100213083436-9pesg4h55w1mekxc) (version source revid:luis.soares@sun.com-20100211135109-t63avry9fqpgyh78) (merge vers: 6.0.14-alpha) (pib:16)
[13 Feb 2010 8:39] Bugs System
Pushed into mysql-next-mr (revid:alik@sun.com-20100213083327-cee4ao3jpg33eggv) (version source revid:luis.soares@sun.com-20100211135018-1f9dbghg0itszigo) (pib:16)
[13 Feb 2010 13:23] Marc ALFF
Doc team:
- bug present in mysql-next-mr (betony)
- fixed in mysql-next-mr (celosia)
- bug not present in any GA release
[13 Feb 2010 17:44] Paul DuBois
No changelog entry needed. Appears in no released version.

Setting report to Need Merge pending push of Celosia to release tree.
[6 Mar 2010 10:53] Bugs System
Pushed into 5.5.3-m3 (revid:alik@sun.com-20100306103849-hha31z2enhh7jwt3) (version source revid:vvaintroub@mysql.com-20100213160132-nx1vlocxuta76txh) (merge vers: 5.5.99-m3) (pib:16)
[6 Mar 2010 19:41] Paul DuBois
No changelog entry needed.