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

[Draft] Assertion `!is_set() || (m_status == DA_OK_BULK && is_bulk_op())' failed on ALTER TABLE

    XMLWordPrintable

Details

    Description

      https://travis-ci.org/elenst/mariadb-tests/jobs/292308986
      and numerous other occurrences in instant alter tests

      10.3 b23a1096956c21df037bd851494f11509b5514dd

      mysqld: /home/travis/src/sql/sql_error.cc:335: void Diagnostics_area::set_ok_status(ulonglong, ulonglong, const char*): Assertion `!is_set() || (m_status == DA_OK_BULK && is_bulk_op())' failed.
      171025 4:49:04 [ERROR] mysqld got signal 6 ;
       
      Trying to get some variables.
      Some pointers may be invalid and cause the dump to abort.
      Query (0x7fc93401ec38): ALTER TABLE t1 ENGINE=InnoDB /* QNO 316 CON_ID 19 */
      Connection ID (thread ID): 19
      Status: NOT_KILLED
      

      # 2017-10-25T04:49:20 [24679] #6 0x00007fc988b4ebf6 in __assert_fail_base (fmt=0x7fc988ca3018 "%s%s%s:%u: %s%sAssertion `%s' failed.\n%n", assertion=assertion@entry=0x933c8014a0 "!is_set() || (m_status == DA_OK_BULK && is_bulk_op())", file=file@entry=0x933c8013e0 "/home/travis/src/sql/sql_error.cc", line=line@entry=335, function=function@entry=0x933c801840 <Diagnostics_area::set_ok_status(unsigned long long, unsigned long long, char const*)::__PRETTY_FUNCTION__> "void Diagnostics_area::set_ok_status(ulonglong, ulonglong, const char*)") at assert.c:92
      # 2017-10-25T04:49:20 [24679] #7 0x00007fc988b4eca2 in __GI___assert_fail (assertion=0x933c8014a0 "!is_set() || (m_status == DA_OK_BULK && is_bulk_op())", file=0x933c8013e0 "/home/travis/src/sql/sql_error.cc", line=335, function=0x933c801840 <Diagnostics_area::set_ok_status(unsigned long long, unsigned long long, char const*)::__PRETTY_FUNCTION__> "void Diagnostics_area::set_ok_status(ulonglong, ulonglong, const char*)") at assert.c:101
      # 2017-10-25T04:49:20 [24679] #8 0x000000933bc68af0 in Diagnostics_area::set_ok_status (this=0x7fc9340113a0, affected_rows=0, last_insert_id=0, message=0x7fc971285130 "Records: 0 Duplicates: 0 Warnings: 1") at /home/travis/src/sql/sql_error.cc:335
      # 2017-10-25T04:49:20 [24679] #9 0x000000933bc199cb in my_ok (thd=0x7fc93400c1c0, affected_rows_arg=0, id=0, message=0x7fc971285130 "Records: 0 Duplicates: 0 Warnings: 1") at /home/travis/src/sql/sql_class.h:4638
      # 2017-10-25T04:49:20 [24679] #10 0x000000933bd7922b in mysql_alter_table (thd=0x7fc93400c1c0, new_db=0x7fc93401f360 "test", new_name=0x0, create_info=0x7fc971285d00, table_list=0x7fc93401ed50, alter_info=0x7fc971285c50, order_num=0, order=0x0, ignore=false) at /home/travis/src/sql/sql_table.cc:9527
      # 2017-10-25T04:49:20 [24679] #11 0x000000933bdf8083 in Sql_cmd_alter_table::execute (this=0x7fc93401f370, thd=0x7fc93400c1c0) at /home/travis/src/sql/sql_alter.cc:331
      # 2017-10-25T04:49:20 [24679] #12 0x000000933bcaa8b8 in mysql_execute_command (thd=0x7fc93400c1c0) at /home/travis/src/sql/sql_parse.cc:6236
      # 2017-10-25T04:49:20 [24679] #13 0x000000933bcaf12b in mysql_parse (thd=0x7fc93400c1c0, rawbuf=0x7fc93401ec38 "ALTER TABLE t1 ENGINE=InnoDB /* QNO 316 CON_ID 19 */", length=52, parser_state=0x7fc971287620, is_com_multi=false, is_next_command=false) at /home/travis/src/sql/sql_parse.cc:7921
      # 2017-10-25T04:49:20 [24679] #14 0x000000933bc9c903 in dispatch_command (command=COM_QUERY, thd=0x7fc93400c1c0, packet=0x7fc934016471 "ALTER TABLE t1 ENGINE=InnoDB /* QNO 316 CON_ID 19 */ ", packet_length=53, is_com_multi=false, is_next_command=false) at /home/travis/src/sql/sql_parse.cc:1819
      # 2017-10-25T04:49:20 [24679] #15 0x000000933bc9b36d in do_command (thd=0x7fc93400c1c0) at /home/travis/src/sql/sql_parse.cc:1370
      # 2017-10-25T04:49:20 [24679] #16 0x000000933bdf2c52 in do_handle_one_connection (connect=0x933e7bf8e0) at /home/travis/src/sql/sql_connect.cc:1418
      # 2017-10-25T04:49:20 [24679] #17 0x000000933bdf29df in handle_one_connection (arg=0x933e7bf8e0) at /home/travis/src/sql/sql_connect.cc:1324
      # 2017-10-25T04:49:20 [24679] #18 0x00007fc989710184 in start_thread (arg=0x7fc971288700) at pthread_create.c:312
      # 2017-10-25T04:49:20 [24679] #19 0x00007fc988c1cffd in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:111
      

      experimental

      perl /home/travis/rqg/runall-new.pl --grammar=conf/runtime/WL5004_sql.yy --gendata=conf/runtime/WL5004_data.zz --duration=400 --threads=6 --queries=100M --redefine=conf/mariadb/instant_alter.yy --mysqld=--max-statement-time=30 --reporters=Backtrace,ErrorLog,Deadlock --engine=InnoDB --mysqld=--innodb-page-size=16K --seed=1508906932 --basedir=/home/travis/server --vardir=/home/travis/logs/vardir1_1
      

      Not reproducible right away.

      Attachments

        1. threads
          64 kB
          Elena Stepanova

        Issue Links

          Activity

            People

              elenst Elena Stepanova
              elenst Elena Stepanova
              Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:

                Git Integration

                  Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.