Bug #37769 main.error_simulation fails randomly
Submitted: 1 Jul 2008 15:05 Modified: 18 Jul 2008 16:21
Reporter: Alexander Nozdrin Email Updates:
Status: Closed Impact on me:
None 
Category:Tests Severity:S3 (Non-critical)
Version:6.0-BK OS:Any
Assigned to: Alexander Nozdrin CPU Architecture:Any
Tags: pushbuild, sporadic, test failure

[1 Jul 2008 15:05] Alexander Nozdrin
Description:
mysqltest: At line 26: query 'SELECT MAX(a) FROM t1 GROUP BY a,b' succeeded - should have failed with errno 1022...

The result from queries just before the failure was:
< snip >
('AAAAAAAAAA','AAAAAAAAAA'), ('AAAAAAAAAB','AAAAAAAAAB '),
('AAAAAAAAAB','AAAAAAAAAB'), ('AAAAAAAAAC','AAAAAAAAAC'),
('AAAAAAAAAD','AAAAAAAAAD'), ('AAAAAAAAAE','AAAAAAAAAE'),
('AAAAAAAAAF','AAAAAAAAAF'), ('AAAAAAAAAG','AAAAAAAAAG'),
('AAAAAAAAAH','AAAAAAAAAH'), ('AAAAAAAAAI','AAAAAAAAAI'),
('AAAAAAAAAJ','AAAAAAAAAJ'), ('AAAAAAAAAK','AAAAAAAAAK');
set tmp_table_size=1024;
SELECT MAX(a) FROM t1 GROUP BY a,b;
MAX(a)
AAAAAAAAAA
AAAAAAAAAB
AAAAAAAAAC
AAAAAAAAAD
AAAAAAAAAE
AAAAAAAAAF
AAAAAAAAAG
AAAAAAAAAH
AAAAAAAAAI
AAAAAAAAAJ
AAAAAAAAAK

More results from queries before failure can be found in /tmp/var-embedded-101/log/error_simulation.log

How to repeat:
https://intranet.mysql.com/secure/pushbuild/xref.pl?testname=main.error_simulation

Suggested fix:
http://lists.mysql.com/commits/48807
[1 Jul 2008 16:05] Alexander Nozdrin
Pushed into 6.0-maria.
[3 Jul 2008 6:54] 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/48921

2728 Alexander Nozdrin	2008-07-03 [merge]
      Merge 6.0-maria -> 6.0.
      Fix for Bug#37769: main.error_simulation fails randomly.
[3 Jul 2008 6:59] 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/48922

2728 Alexander Nozdrin	2008-07-03 [merge]
      Merge 6.0-maria -> 6.0.
      Fix for Bug#37769: main.error_simulation fails randomly.
[3 Jul 2008 7:00] Bugs System
Pushed into 6.0.6-alpha
[3 Jul 2008 7:00] 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/48923

2728 Alexander Nozdrin	2008-07-03 [merge]
      Merge 6.0-maria -> 6.0.
      Fix for Bug#37769: main.error_simulation fails randomly.
[18 Jul 2008 16:21] Paul DuBois
No changelog entry needed.