Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-15593

[Draft] Assertion `m_prebuilt->magic_n == 78540783' failed in ha_innobase::reset_template

    XMLWordPrintable

    Details

      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.

        Attachments

          Activity

            People

            Assignee:
            elenst Elena Stepanova
            Reporter:
            elenst Elena Stepanova
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

              Dates

              Created:
              Updated: