maria-developers team mailing list archive

[Michael Widenius <monty@xxxxxxxxxxxx>]

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

Hi!

>>>>> "Kristian" == Kristian Nielsen <knielsen@xxxxxxxxxxxxxxx> 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/logs/stdio

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