| Bug #28285 | Test "events_bugs" has instable results of "select /*1*/ ... from processlist" | ||
|---|---|---|---|
| Submitted: | 7 May 2007 17:22 | Modified: | 7 Sep 2007 13:01 |
| Reporter: | Joerg Bruehe | Email Updates: | |
| Status: | Closed | Impact on me: | |
| Category: | MySQL Server: Tests | Severity: | S3 (Non-critical) |
| Version: | 5.1.18 | OS: | Any |
| Assigned to: | Kristofer Pettersson | CPU Architecture: | Any |
[26 May 2007 15:51]
Andrey Hristov
Queued in 5.1-runtime
[26 May 2007 16:05]
Konstantin Osipov
Test suite change, pushed without review.
[1 Jun 2007 19:22]
Bugs System
Pushed into 5.1.20-beta
[1 Jun 2007 20:28]
Paul DuBois
Test suite change. No changelog entry needed.
[22 Aug 2007 11:00]
Joerg Bruehe
Sorry, I have to reopen this bug - see these results from the 5.1.21 build:
-------------------------------------------------------
*** /PATH/mysql-test/r/events_bugs.result
--- /PATH/mysql-test/r/events_bugs.reject
***************
*** 57,62
--- 57,63
"Now if everything is fine the event has compiled and is locked"
select /*1*/ user, host, db, info from information_schema.processlist where command!='Daemon' and (info is null or info n
ot like '%processlist%') order by info;
user host db info
+ root localhost events_test select get_lock("test_lock2_1", 20)
root localhost events_test select get_lock('test_bug16407', 60)
select release_lock('test_bug16407');
release_lock('test_bug16407')
-------------------------------------------------------
(RHAS 3, x86)
-------------------------------------------------------
*** /PATH/mysql-test/r/events_bugs.result
--- /PATH/mysql-test/r/events_bugs.reject
***************
*** 57,62
--- 57,64
"Now if everything is fine the event has compiled and is locked"
select /*1*/ user, host, db, info from information_schema.processlist where command!='Daemon' and (info is null or info n
ot like '%processlist%') order by info;
user host db info
+ root localhost NULL NULL
+ root localhost events_test select get_lock("test_lock2_1", 20)
root localhost events_test select get_lock('test_bug16407', 60)
select release_lock('test_bug16407');
release_lock('test_bug16407')
-------------------------------------------------------
(HP-UX 11.00, HP-PA, 64 bit, "debug" build)
[23 Aug 2007 13:38]
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/32954 ChangeSet@1.2569, 2007-08-23 15:37:55+02:00, thek@adventure.(none) +2 -0 Bug#28285 Test "events_bugs" has instable results of "select /*1*/ ... from processlist" Test case contains possible race conditions. This patch fixes these race conditions and also adjust the test to execute according to its documentation.
[7 Sep 2007 8:09]
Bugs System
Pushed into 5.1.23-beta
[7 Sep 2007 13:01]
Paul DuBois
Test suite change. No changelog entry needed.
Description: Test shows instability, with varying differences. I see no pattern in them: ------------------------------------------------------- *** r/events_bugs.result --- r/events_bugs.reject *************** *** 58,63 --- 58,64 "Now if everything is fine the event has compiled and is locked" select /*1*/ user, host, db, info from information_schema.processlist where command!='Daemon' and (info is null or info n ot like '%processlist%') order by info; user host db info + root localhost NULL NULL root localhost events_test select get_lock('test_bug16407', 60) select release_lock('test_bug16407'); release_lock('test_bug16407') ------------------------------------------------------- hp3750-64bit-5.1-community.log debug ------------------------------------------------------- *** r/events_bugs.result --- r/events_bugs.reject *************** *** 58,63 --- 58,64 "Now if everything is fine the event has compiled and is locked" select /*1*/ user, host, db, info from information_schema.processlist where command!='Daemon' and (info is null or info n ot like '%processlist%') order by info; user host db info + root localhost events_test select get_lock("test_lock2_1", 20) root localhost events_test select get_lock('test_bug16407', 60) select release_lock('test_bug16407'); release_lock('test_bug16407') ------------------------------------------------------- hammer-glibc23-5.1-community.log normal ------------------------------------------------------- *** r/events_bugs.result --- r/events_bugs.reject *************** *** 58,63 --- 58,65 "Now if everything is fine the event has compiled and is locked" select /*1*/ user, host, db, info from information_schema.processlist where command!='Daemon' and (info is null or info n ot like '%processlist%') order by info; user host db info + root localhost NULL NULL + root localhost events_test select get_lock("test_lock2_1", 20) root localhost events_test select get_lock('test_bug16407', 60) select release_lock('test_bug16407'); release_lock('test_bug16407') ------------------------------------------------------- Do-rpm-hammer-5.1-standard.log normal+rowrepl hp3750-64bit-5.1-community.log normal ------------------------------------------------------- *** r/events_bugs.result --- r/events_bugs.reject *************** *** 58,63 --- 58,64 "Now if everything is fine the event has compiled and is locked" select /*1*/ user, host, db, info from information_schema.processlist where command!='Daemon' and (info is null or info n ot like '%processlist%') order by info; user host db info + root localhost events_test CREATE PROCEDURE `???????21`() SQL SECURITY INVOKER select get_lock("test_lock2_1", 20) root localhost events_test select get_lock('test_bug16407', 60) select release_lock('test_bug16407'); release_lock('test_bug16407') ------------------------------------------------------- hpita2-64bit-5.1-community.log debug How to repeat: Run the test suite on a sufficient number of hosts.