Re: [Maria-developers] Query cache test failure in Buildbot

In-Reply-To: <87hbzd5mfb.fsf@knielsen-hq.org> References: <87hbzd5mfb.fsf@knielsen-hq.org> X-Mailer: VM 7.17 under 21.5 (beta28) "fuki" (+CVS-20070806) XEmacs Lucid Reply-To: monty@askmonty.org FCC: ~/Mail/outbox --text follows this line-- Hi!

...

...

...

...

"Kristian" == Kristian Nielsen writes:

Kristian> Hi, Kristian> There is a query cache related failure seen in Buildbot: Kristian> https://askmonty.org/buildbot/builders/hardy-amd64-dbg/builds/35/steps/test/... Kristian> main.query_cache_28249 [ fail ] Kristian> Test ended at 2009-05-21 09:13:10 Kristian> CURRENT_TEST: main.query_cache_28249 Kristian> --- /home/archivist/archivist-amd64/archivist-amd64/build/mysql-test/r/query_cache_28249.result 2009-05-21 09:30:15.000000000 +0300 Kristian> +++ /home/archivist/archivist-amd64/archivist-amd64/build/mysql-test/r/query_cache_28249.reject 2009-05-21 11:13:10.000000000 +0300 Kristian> @@ -46,7 +46,6 @@ Kristian> 1 0 Kristian> 2 0 Kristian> 3 0 Kristian> -4 0 Kristian> RESET QUERY CACHE; Kristian> SELECT *, (SELECT COUNT(*) FROM t2) FROM t1; Kristian> a (SELECT COUNT(*) FROM t2) Kristian> mysqltest: Result length mismatch Kristian> - 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/' Kristian> Retrying test, attempt(2/3)... Kristian> main.query_cache_28249 [ retry-pass ] 509 Kristian> Retrying test, attempt(3/3)... Kristian> main.query_cache_28249 [ retry-pass ] 404 Kristian> I checked the bug: Kristian> http://bugs.mysql.com/bug.php?id=28249 Kristian> It is about a race condition in query cache and MyISAM (and re-test in Kristian> Buildbot shows that it is not 100% reproducible). Kristian> I am thinking that perhaps the bug was re-introduced with Maria, or in any Kristian> case that someone more familiar with the MyISAM or Maria code would be better Kristian> at looking into it. Sanja, can you create a bug report in launchpad or worklog item to get this fixed? Regards, Monty