Bug #28296 events_grant fails in pushbuild
Submitted: 8 May 2007 7:36 Modified: 1 Aug 2007 18:24
Reporter: Mads Martin Joergensen Email Updates:
Status: Can't repeat Impact on me:
None 
Category:MySQL Server Severity:S1 (Critical)
Version:5.1, 5.2.5 OS:Any
Assigned to: Evgeny Potemkin CPU Architecture:Any

[8 May 2007 7:36] Mads Martin Joergensen
Description:
events_grant                   [ pass ]            895
Warning;  Aborted waiting on pid file: '/dev/shm/var-ps_row-121/run/master.pid' after 70 seconds

WARNING:  'mysqld: table.cc:220: void free_table_share(TABLE_SHARE*): Assertion `share->ref_count == 0' failed.'
    COUNT: 1
    FILES:    master.err
    TESTS:    events_grant

WARNING:  'Attempting backtrace. You can use the following information to find out'
    COUNT: 1
    FILES:    master.err
    TESTS:    events_grant

070502 21:03:13 [Note] /home/pushbuild/pb3/pb/mysql-5.1-new-maint/542/mysql-5.1.18-beta-pb542/sql/mysqld: Normal shutdown

070502 21:03:13 [Note] Event Scheduler: Purging the queue. 0 events
mysqld: table.cc:220: void free_table_share(TABLE_SHARE*): Assertion `share->ref_count == 0' failed.
070502 21:03:15 - mysqld got signal 6;

How to repeat:
Failure:

https://intranet.mysql.com/secure/pushbuild/getlog.pl?dir=mysql-5.1-new-maint&entry=igalar...

Assert fail:

https://intranet.mysql.com/secure/pushbuild/getlog.pl?dir=mysql-5.1-new-maint&entry=igalar...

According to master.err it happens during shutdown:

https://intranet.mysql.com/secure/pushbuild/getlog.pl?dir=mysql-5.1-new-maint&entry=igalar...
[23 Jul 2007 7:35] Ingo Strüwing
Happened again.

See push Mon Jul 23 03:25:10 2007, platform 'pb-valgrind-*', on https://intranet.mysql.com/secure/pushbuild/showdir.pl?dir=mysql-5.2-engines

Warnings file contains:

... (several lines about vg_replace_malloc.c skipped)
master.err: main.events_grant: ==26115==    at 0x4A20A56: malloc (vg_replace_malloc.c:149)
master.err: main.events_grant: Attempting backtrace. You can use the following information to find out
master.err: main.events_grant: mysqld: table.cc:342: void free_table_share(TABLE_SHARE*): Assertion `share->ref_count == 0' failed.

There are also four server logs like quoted in the initial bug report.
[1 Aug 2007 18:24] Evgeny Potemkin
Can't repeat.
Tested on my local machine under valgrind and 
on the PB valgrind host with the binaries that failed the test. I run test several times, the bug doesn't appear.