Details
Minor
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
Gliffy Diagrams
Attachments
Activity
- All
- Comments
- Work Log
- History
- Activity
- Transitions
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.