[MDEV-4346] Assertion `0' fails in net_end_statement(THD*) on concurrent DML and KILL with InnoDB and PBXT Created: 2013-04-01  Updated: 2013-12-28  Resolved: 2013-12-28

Status: Closed
Project: MariaDB Server
Component/s: None
Affects Version/s: 5.1.67, 5.2.14
Fix Version/s: 5.1.73, 5.2.15

Type: Bug Priority: Minor
Reporter: Elena Stepanova Assignee: Unassigned
Resolution: Won't Fix Votes: 0
Labels: pbxt

Issue Links:
Relates

 Description   

mysqld: protocol.cc:527: void net_end_statement(THD*): Assertion `0' failed.
130401 18:36:18 [ERROR] mysqld got signal 6 ;

#5  0x00007fb5acc7eb8b in __GI_abort () at abort.c:91
#6  0x00007fb5acc740ee in __assert_fail_base (fmt=<optimized out>, assertion=0x117677e "0", file=0x1176612 "protocol.cc", line=<optimized out>, function=<optimized out>) at assert.c:94
#7  0x00007fb5acc74192 in __GI___assert_fail (assertion=0x117677e "0", file=0x1176612 "protocol.cc", line=527, function=0x11771f0 "void net_end_statement(THD*)") at assert.c:103
#8  0x000000000070be72 in net_end_statement (thd=0x48ecd08) at protocol.cc:527
#9  0x00000000007417de in dispatch_command (command=COM_QUERY, thd=0x48ecd08, packet=0x496a869 "DELETE LOW_PRIORITY QUICK IGNORE FROM `table10_innodb_int_autoinc` WHERE `col_int_key` IN ( 60 , 'h' , 'j' , 2236153856 , 7 ) ORDER BY `col_date`,`col_date_key`,`col_datetime`,`col_datetime_key`,`col_"..., packet_length=289) at sql_parse.cc:1743
#10 0x000000000073dd17 in do_command (thd=0x48ecd08) at sql_parse.cc:906
#11 0x0000000000738667 in handle_one_connection (arg=0x48ecd08) at sql_connect.cc:1238
#12 0x00007fb5ad00be9a in start_thread (arg=0x7fb5add33700) at pthread_create.c:308
#13 0x00007fb5acd38cbd in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:112

bzr version-info
revision-id: sergii@pisem.net-20130320202051-m8qdk6zvcci9vr5s
revno: 3194
branch-nick: 5.1

Tried BUILD/compile-pentium-debug-max-no-ndb and BUILD/compile-pentium-gcov.
Also reproducible on 5.2 (make sure to build PBXT there).
Could not reproduce on 5.3, 5.5, 10.0.

My server command line:

/data/bzr/5.1/sql/mysqld --no-defaults --basedir=/data/bzr/5.1 --datadir=/data/bzr/5.1/data --language=/data/bzr/5.1/sql/share/english --character-sets-dir=/data/bzr/5.1/sql/share/charsets --core-file  --socket=/data/bzr/5.1/data/test.sock --pid-file=/data/bzr/5.1/data/mysql.pid

RQG gendata file (assertion-0.zz):

$tables = {
	engines => [ 'InnoDB', 'PBXT' ]
};

RQG command line (assuming the server is running on port 3306):

 perl ./gentest.pl --duration=600 --queries=100M --threads=10 --grammar=conf/engines/engine_stress.yy --gendata=assertion-0.zz --dsn=dbi:mysql:host=127.0.0.1:port=3306:user=root:database=test --reporter=QueryTimeout --querytimeout=2

RQG version (sometimes can be important):

revision-id: roel.vandepaar@percona.com-20130316061535-rkxjl6xkn7bfu0zv
revno: 829
branch-nick: randgen



 Comments   
Comment by Elena Stepanova [ 2013-04-01 ]

Since it's only an assertion on 5.1 and 5.2, and besides it seems to require PBXT, I don't seriously expect it to be fixed, but I need it filed as a bug report so it could be found next time without spending time on investigating a failure.

Generated at Thu Feb 08 06:55:43 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.