maria-developers team mailing list archive

[Kristian Nielsen <knielsen@xxxxxxxxxxxxxxx>]

Hi,

There is a query cache related failure seen in Buildbot:

    https://askmonty.org/buildbot/builders/hardy-amd64-dbg/builds/35/steps/test/logs/stdio

main.query_cache_28249                   [ fail ]
        Test ended at 2009-05-21 09:13:10

CURRENT_TEST: main.query_cache_28249
--- /home/archivist/archivist-amd64/archivist-amd64/build/mysql-test/r/query_cache_28249.result	2009-05-21 09:30:15.000000000 +0300
+++ /home/archivist/archivist-amd64/archivist-amd64/build/mysql-test/r/query_cache_28249.reject	2009-05-21 11:13:10.000000000 +0300
@@ -46,7 +46,6 @@
 1	0
 2	0
 3	0
-4	0
 RESET QUERY CACHE;
 SELECT *, (SELECT COUNT(*) FROM t2) FROM t1;
 a	(SELECT COUNT(*) FROM t2)

mysqltest: Result length mismatch

 - saving '/home/archivist/archivist-amd64/archivist-amd64/build/mysql-test/var/1/log/main.query_cache_28249/' to '/home/archivist/archivist-amd64/archivist-amd64/build/mysql-test/var/log/main.query_cache_28249/'

Retrying test, attempt(2/3)...

main.query_cache_28249                   [ retry-pass ]    509

Retrying test, attempt(3/3)...

main.query_cache_28249                   [ retry-pass ]    404

I checked the bug:

    http://bugs.mysql.com/bug.php?id=28249

It is about a race condition in query cache and MyISAM (and re-test in
Buildbot shows that it is not 100% reproducible).

I am thinking that perhaps the bug was re-introduced with Maria, or in any
case that someone more familiar with the MyISAM or Maria code would be better
at looking into it.

Any takers?

 - Kristian.