[MDEV-15593] [Draft] Assertion `m_prebuilt->magic_n == 78540783' failed in ha_innobase::reset_template Created: 2018-03-17  Updated: 2018-04-07

Status: Open
Project: MariaDB Server
Component/s: Sequences, Storage Engine - InnoDB
Affects Version/s: 10.3
Fix Version/s: None

Type: Bug Priority: Major
Reporter: Elena Stepanova Assignee: Elena Stepanova
Resolution: Unresolved Votes: 0
Labels: None

Attachments: HTML File threads    

 Description   

https://api.travis-ci.org/v3/job/354370292/log.txt

10.3 c231a228ca4bec214dde86ab8335473bc0db7a08

 
mysqld: /home/travis/src/storage/innobase/handler/ha_innodb.cc:3440: void ha_innobase::reset_template(): Assertion `m_prebuilt->magic_n == 78540783' failed.
 
180316 23:23:28 [ERROR] mysqld got signal 6 ;
 
 
 
Query (0x7f89bc01fac8): CREATE TABLE t10 LIKE `A` /* QNO 1643 CON_ID 20 */
 
Connection ID (thread ID): 20
 
Status: NOT_KILLED


#6  0x00007f8a120f5bf6 in __assert_fail_base (fmt=0x7f8a1224a058 "%s%s%s:%u: %s%sAssertion `%s' failed.\n%n", assertion=assertion@entry=0x5596457ede28 "m_prebuilt->magic_n == 78540783", file=file@entry=0x5596457ec210 "/home/travis/src/storage/innobase/handler/ha_innodb.cc", line=line@entry=3440, function=function@entry=0x5596457fa240 <ha_innobase::reset_template()::__PRETTY_FUNCTION__> "void ha_innobase::reset_template()") at assert.c:92
 
#7  0x00007f8a120f5ca2 in __GI___assert_fail (assertion=0x5596457ede28 "m_prebuilt->magic_n == 78540783", file=0x5596457ec210 "/home/travis/src/storage/innobase/handler/ha_innodb.cc", line=3440, function=0x5596457fa240 <ha_innobase::reset_template()::__PRETTY_FUNCTION__> "void ha_innobase::reset_template()") at assert.c:101
 
#8  0x0000559644fceedc in ha_innobase::reset_template (this=0x7f89bc08b6a8) at /home/travis/src/storage/innobase/handler/ha_innodb.cc:3440
 
#9  0x0000559644feabe9 in ha_innobase::external_lock (this=0x7f89bc08b6a8, thd=0x7f89bc00b380, lock_type=0) at /home/travis/src/storage/innobase/handler/ha_innodb.cc:15892
 
#10 0x000055964554bcb7 in ha_sequence::external_lock (this=0x7f89bc08bea8, thd=0x7f89bc00b380, lock_type=0) at /home/travis/src/sql/ha_sequence.cc:317
 
#11 0x0000559644dcd691 in handler::ha_external_lock (this=0x7f89bc08bea8, thd=0x7f89bc00b380, lock_type=0) at /home/travis/src/sql/handler.cc:6113
 
#12 0x0000559644ee5ade in lock_external (thd=0x7f89bc00b380, tables=0x7f89bc0222a8, count=2) at /home/travis/src/sql/lock.cc:396
 
#13 0x0000559644ee57d0 in mysql_lock_tables (thd=0x7f89bc00b380, sql_lock=0x7f89bc022260, flags=2080) at /home/travis/src/sql/lock.cc:342
 
#14 0x0000559644ee568c in mysql_lock_tables (thd=0x7f89bc00b380, tables=0x7f89bc022250, count=2, flags=2080) at /home/travis/src/sql/lock.cc:304
 
#15 0x0000559644a539b5 in lock_tables (thd=0x7f89bc00b380, tables=0x7f89bc01fbe0, count=2, flags=2080) at /home/travis/src/sql/sql_base.cc:5172
 
#16 0x0000559644a53041 in open_and_lock_tables (thd=0x7f89bc00b380, options=..., tables=0x7f89bc01fbe0, derived=false, flags=2080, prelocking_strategy=0x7f89fc63aaa0) at /home/travis/src/sql/sql_base.cc:4916
 
#17 0x0000559644a14351 in open_and_lock_tables (thd=0x7f89bc00b380, tables=0x7f89bc01fbe0, derived=false, flags=2080) at /home/travis/src/sql/sql_base.h:489
 
#18 0x0000559644cd6b13 in sequence_insert (thd=0x7f89bc00b380, lex=0x7f89bc00f0f0, table_list=0x7f89bc01fbe0) at /home/travis/src/sql/sql_sequence.cc:311
 
#19 0x0000559644ba1e71 in mysql_create_table_no_lock (thd=0x7f89bc00b380, db=0x7f89bc01fbf8, table_name=0x7f89bc01fc08, create_info=0x7f89fc63afd0, alter_info=0x7f89fc63af20, is_trans=0x7f89fc63ae74, create_table_mode=0, table_list=0x7f89bc01fbe0) at /home/travis/src/sql/sql_table.cc:5136
 
#20 0x0000559644ba3b39 in mysql_create_like_table (thd=0x7f89bc00b380, table=0x7f89bc01fbe0, src_table=0x7f89bc020278, create_info=0x7f89fc63c770) at /home/travis/src/sql/sql_table.cc:5720
 
#21 0x0000559644ad2cff in mysql_execute_command (thd=0x7f89bc00b380) at /home/travis/src/sql/sql_parse.cc:4250
 
#22 0x0000559644adece0 in mysql_parse (thd=0x7f89bc00b380, rawbuf=0x7f89bc01fac8 "CREATE TABLE t10 LIKE `A` /* QNO 1643 CON_ID 20 */", length=50, parser_state=0x7f89fc63d5e0, is_com_multi=false, is_next_command=false) at /home/travis/src/sql/sql_parse.cc:8009
 
#23 0x0000559644acc3d9 in dispatch_command (command=COM_QUERY, thd=0x7f89bc00b380, packet=0x7f89bc017711 "CREATE TABLE t10 LIKE `A` /* QNO 1643 CON_ID 20 */ ", packet_length=51, is_com_multi=false, is_next_command=false) at /home/travis/src/sql/sql_parse.cc:1838
 
#24 0x0000559644acae25 in do_command (thd=0x7f89bc00b380) at /home/travis/src/sql/sql_parse.cc:1383
 
#25 0x0000559644c300ab in do_handle_one_connection (connect=0x559648818790) at /home/travis/src/sql/sql_connect.cc:1402
 
#26 0x0000559644c2fe38 in handle_one_connection (arg=0x559648818790) at /home/travis/src/sql/sql_connect.cc:1308
 
#27 0x00007f8a12cb7184 in start_thread (arg=0x7f89fc63e700) at pthread_create.c:312
 
#28 0x00007f8a121c403d in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:111

experimental 69312423111b0cf4cb265a01b0950234901e8764

 
perl /home/travis/rqg/runall-new.pl --duration=350 --threads=6 --redefine=conf/mariadb/alter_table.yy --reporters=Backtrace,ErrorLog,Deadlock --engine=InnoDB --seed=1521242585 --basedir=/home/travis/server --mysqld=--max-statement-time=30 --mysqld=--loose-debug_assert_on_not_freed_memory=0 --grammar=conf/optimizer/updateable_views.yy --mysqld=--init-file=$RQG_HOME/conf/optimizer/updateable_views.init --vardir=/home/travis/logs/vardir1_1

Not reproducible right away, possibly because I keep hitting other bugs instead.

 Comments   
Comment by Marko Mäkelä [ 2018-04-07 ]

Maybe CREATE TABLE LIKE should return an error when trying to clone a CREATE SEQUENCE?

Generated at Thu Feb 08 08:22:34 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.