Bug #43129 failed assertion `bitmap_is_set_all(&table->s->all_set)' with concurrent inserts

Submitted: 24 Feb 2009 7:45 Modified: 8 Apr 2009 10:52
Reporter: Sveta Smirnova Email Updates:
Status: Duplicate Impact on me:
None 
Category:MySQL Server Severity:S1 (Critical)
Version:5.1 bzr OS:MacOS (Tiger)
Assigned to: Assigned Account CPU Architecture:Any

[24 Feb 2009 7:45] Sveta Smirnova
Description:
While running concurrent inserts mysqld crashes with:

handler.cc:4554: failed assertion `bitmap_is_set_all(&table->s->all_set)'
InnoDB: Log scan progressed past the checkpoint lsn 0 334970986
090224 10:38:26  InnoDB: Database was not shut down normally!
InnoDB: Starting crash recovery.
InnoDB: Reading tablespace information from the .ibd files...
InnoDB: Restoring possible half-written data pages from the doublewrite
InnoDB: buffer...
090224 10:38:27  InnoDB: Starting an apply batch of log records to the database...
InnoDB: Progress in percents: 0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 
InnoDB: Apply batch completed
090224 10:38:27  InnoDB: Starting an apply batch of log records to the database...
InnoDB: Progress in percents: 0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 
InnoDB: Apply batch completed
090224 10:38:29  InnoDB: Starting an apply batch of log records to the database...
InnoDB: Progress in percents: 0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 
InnoDB: Apply batch completed
090224 10:38:31  InnoDB: Starting an apply batch of log records to the database...
InnoDB: Progress in percents: 0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99
InnoDB: Apply batch completed
090224 10:38:32  InnoDB: Starting an apply batch of log records to the database...
InnoDB: Progress in percents: 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99
InnoDB: Apply batch completed
InnoDB: Doing recovery: scanned up to log sequence number 0 339796748
090224 10:38:33  InnoDB: Starting an apply batch of log records to the database...
InnoDB: Progress in percents: 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99
InnoDB: Apply batch completed
090224 10:38:34  InnoDB: Started; log sequence number 0 339796748
090224 10:38:34 [Note] Event Scheduler: Loaded 0 events
090224 10:38:34 [Note] /Users/apple/Applications/mysql-5.1/libexec/mysqld: ready for connections.
Version: '5.1.33-debug'  socket: '/tmp/mysql51.sock'  port: 3351  Source distribution

Found when tried to repeat bug #42644

How to repeat:
Test case will be attached.
[24 Feb 2009 7:46] Sveta Smirnova
test case

Attachment: bug42644.c (text/plain), 6.06 KiB.

[24 Feb 2009 7:47] Sveta Smirnova
To repeat one should run test case several times
[24 Feb 2009 17:27] Sveta Smirnova
Gypsy query file:

i|1|drop table if exists a|
i|1|create table a( i int, n int, primary key(i)) engine=innodb|
i|1|set global sql_mode='strict_trans_tables'|
n|100|insert into a set i = 1, n = 1 on duplicate key update n = n + 1|
[27 Feb 2009 14:50] Peter Gulutzan
I saw the same assertion with mysql-6.1-fk when running a stored procedure
on 8 connections, repeatedly inserting/updating/deleting on Falcon tables
with foreign keys.
[2 Apr 2009 12:07] Kristofer Pettersson
Can't repeat on Linux. Mac is probably needed.
[6 Apr 2009 14:06] Kristofer Pettersson
PeterG: I saw an assertion on linux in February.
[8 Apr 2009 10:52] Georgi Kodinov
Duplicate of bug #37936.
I have tried running the test 10 times in a row with the current 5.1-bugteam tree with no success.
[30 Oct 2009 15:01] Peter Thairu
I see same assertion on 5.1.39 on Centos 5.3 and can reliably repeat using your test case.
[4 Aug 2011 17:55] Mark Callaghan
Is this a duplicate of http://bugs.mysql.com/bug.php?id=43152

Portions of this website are copyright © 2001, 2002 The PHP Group

Page generated in 0.061 sec. using MySQL 8.4.7-u6-cloud

Timestamp references displayed by the system are UTC.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.