Description:
Observer during the build of 5.5.0-beta.
It has not been observed before, but that may well be due to the recent change in the test. From the effect I see (and from bug DB entries), this source contains the fix for bug#47808.
I'm not sure whether this is a bug in the server, specific in InnoDB, or in the test.
Symptom:
=====
innodb.innodb_information_schema [ retry-fail ]
Test ended at YYYY-MM-DD HH:MM:SS
CURRENT_TEST: innodb.innodb_information_schema
--- /PATH/mysql-test/suite/innodb/r/innodb_information_schema.result
+++ /PATH/mysql-test/suite/innodb/r/innodb_information_schema.reject
@@ -1,8 +1,7 @@
+Timeout in wait_condition.inc for select count(*) = 14 from INFORMATION_SCHEMA.INNODB_LOCKS
lock_mode lock_type lock_table lock_index lock_rec lock_data
X RECORD `test`.```t'\"_str` `PRIMARY` 2 '1', 'abc', '''abc', 'abc''', 'a''bc', 'a''bc'
'', '''abc'''''
X RECORD `test`.```t'\"_str` `PRIMARY` 2 '1', 'abc', '''abc', 'abc''', 'a''bc', 'a''bc'
'', '''abc'''''
-X RECORD `test`.```t'\"_str` `PRIMARY` 3 '2', 'abc', '"abc', 'abc"', 'a"bc', 'a"bc"', '
"abc""'
-X RECORD `test`.```t'\"_str` `PRIMARY` 3 '2', 'abc', '"abc', 'abc"', 'a"bc', 'a"bc"', '
"abc""'
X RECORD `test`.```t'\"_str` `PRIMARY` 4 '3', 'abc', '\\abc', 'abc\\', 'a\\bc', 'a\\bc\
\', '\\abc\\\\'
X RECORD `test`.```t'\"_str` `PRIMARY` 4 '3', 'abc', '\\abc', 'abc\\', 'a\\bc', 'a\\bc\
\', '\\abc\\\\'
X RECORD `test`.```t'\"_str` `PRIMARY` 5 '4', 'abc', '\0abc', 'abc\0', 'a\0bc', 'a\0bc\
0', 'a\0bc\0\0'
@@ -16,8 +15,8 @@
lock_table COUNT(*)
`test`.`t_max` 2
`test`.`t_min` 2
-`test`.```t'\"_str` 10
+`test`.```t'\"_str` 8
lock_table COUNT(*)
"test"."t_max" 2
"test"."t_min" 2
-"test"."`t'\""_str" 10
+"test"."`t'\""_str" 8
mysqltest: Result content mismatch
=====
RPM build for RHEL 3, x86, normal test mode.
May be stronger ("timeout" lines not pasted):
=====
...
@@ -16,8 +13,8 @@
lock_table COUNT(*)
`test`.`t_max` 2
`test`.`t_min` 2
-`test`.```t'\"_str` 10
+`test`.```t'\"_str` 6
lock_table COUNT(*)
"test"."t_max" 2
"test"."t_min" 2
-"test"."`t'\""_str" 10
+"test"."`t'\""_str" 6
=====
Generic RPM for x86, test run in PS mode.
Or even more (again, "timeout" lines not pasted):
=====
...
@@ -16,8 +11,8 @@
lock_table COUNT(*)
`test`.`t_max` 2
`test`.`t_min` 2
-`test`.```t'\"_str` 10
+`test`.```t'\"_str` 4
lock_table COUNT(*)
"test"."t_max" 2
"test"."t_min" 2
-"test"."`t'\""_str" 10
+"test"."`t'\""_str" 4
=====
RPM build for RHEL 3, x86_64, debug tests, and also
Generic RPM for x86, test run in normal mode.
I have no idea why it was observed only in RPM builds,
I am not aware of any significant difference with the machines or the way tests are run compared to a tar.gz build.
How to repeat:
Found while running the test suite.