Bug #39590 main.fulltext2 crashes sporadically on debx86
Submitted: 22 Sep 2008 16:07 Modified: 9 Jun 15:11
Reporter: Alexander Nozdrin
Status: Won't fix
Category:Tools: Pushbuild Severity:S3 (Non-critical)
Version:1 OS:Linux (debx86-b)
Assigned to: Target Version:
Tags: sporadic, test failure, pushbuild, pb1, hw
Triage: Triaged: D1 (Critical)

[22 Sep 2008 16:07] Alexander Nozdrin
Description:
main.fulltext2 sporadically crashes on debx86 box.

Symptoms:
--------------------------------------------------------------------
myisam_ftdump: dl-open.c:438: dl_open_worker: Assertion `imap->l_type == lt_loaded'
failed.
mysqltest: At line 53: command "$MYISAM_FTDUMP -d $MYSQLTEST_VARDIR/master-data/test/t1
1" failed

The result from queries just before the failure was:
< snip >
            aaayyy
            aaayyy
            aaayyy
            aaayyy
            aaayyy
            aaayyy
            aaayyy
            aaayyy
            aaayyy
            aaayyy
            aaayyy
            aaayyy
            aaayyy
            aaayyy
            aaayyy
            aaayyy
            aaayyy
            aaayyy
 =>                99 aaazzz
exec of
'/data0/pushbuild/pb2/pb/bzr_mysql-6.0/66/mysql-6.0.8-alpha-pb66/storage/myisam/myisam_ftdump
-d /dev/shm/var-ps_row-111/master-data/test/t1 1' failed, error: 6, status: 0, errno: 0

More results from queries before failure can be found in
/dev/shm/var-ps_row-111/log/fulltext2.log
--------------------------------------------------------------------

Reported after a failure on Sep-20 in mysql-6.0:
http://tinyurl.com/4ywzpy

As discussed with Sergey Vojtovich Bug#36200 is a different one,
i.e. has nothing to do with this failure.

How to repeat:
http://tinyurl.com/3kol49
[20 Oct 2008 8:16] Sergey Vojtovich
BUG#40159 was marked as duplicate.
[20 Oct 2008 8:34] Sergey Vojtovich
Seems to be pushbuild issue. Please upgrade libc on this host.
[20 Oct 2008 8:39] Daniel Fischer
This is very likely a libc problem.

There is a Debian bug report: http://bugs.debian.org/cgi-bin/bugreport.cgi?bug=355510

I updated libc to 2.3.6.ds1-13etch7, if it keeps happening we'll have to try downgrading
it to some earlier 2.3 version.
[13 Nov 2008 17:38] Sven Sandberg
This happened again on 2008-11-12:

falcon.falcon_bug_28042
https://intranet.mysql.com/secure/pushbuild/showpush.pl?dir=bzr_mysql-6.0-rpl&order=98
debx86-b/falcon
[9 Jun 15:11] Daniel Fischer
The bug is still present in glibc 2.3. We can't upgrade glibc to 2.4 or higher without
upgrading to a newer release of the operating system. I'm closing this bug as won't fix
because we will not be able to do that before pb1 shutdown in July.