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

SIGABRT in trx_start_if_not_started_xa_low | row_insert_for_mysql

    XMLWordPrintable

Details

    Description

      Replay using CLI

      SET sql_mode='';
      SET @@enforce_storage_engine=InnoDB;
      ALTER TABLE mysql.slow_log ENGINE=MyISAM;
      XA START 'a';
      XA END 'a';
      SET GLOBAL slow_query_log=ON;
      SET slow_query_log=ON;
      SET GLOBAL long_query_time=0;
      XA PREPARE 'a';
      SET @@long_query_time=DEFAULT;
      SET GLOBAL log_output='TABLE';
      

      Leads to:

      10.6.18 6bf2b64a97ec5a8c46018f9ceaf4acbd28d1e922 (Debug)

      Core was generated by `/test/MD130524-mariadb-10.6.18-linux-x86_64-dbg/bin/mariadbd --no-defaults --ma'.
      Program terminated with signal SIGABRT, Aborted.
      #0  __GI_raise (sig=sig@entry=6) at ../sysdeps/unix/sysv/linux/raise.c:50
      [Current thread is 1 (Thread 0x14a734ceb700 (LWP 4103178))]
      (gdb) bt
      #0  __GI_raise (sig=sig@entry=6) at ../sysdeps/unix/sysv/linux/raise.c:50
      #1  0x000014a73794b859 in __GI_abort () at abort.c:79
      #2  0x0000562619e3dcb3 in ut_dbg_assertion_failed (expr=expr@entry=0x0, file=file@entry=0x56261a4e1550 "/test/10.6_dbg/storage/innobase/trx/trx0trx.cc", line=line@entry=2217) at /test/10.6_dbg/storage/innobase/ut/ut0dbg.cc:60
      #3  0x0000562619e26cdf in trx_start_if_not_started_xa_low (trx=trx@entry=0x14a734fa4b80, read_write=read_write@entry=true) at /test/10.6_dbg/storage/innobase/trx/trx0trx.cc:2217
      #4  0x0000562619d7a334 in row_insert_for_mysql (mysql_rec=mysql_rec@entry=0x14a6ec020320 "fg\336X\005\a\254\031", prebuilt=0x14a6ec024428, ins_mode=ROW_INS_NORMAL) at /test/10.6_dbg/storage/innobase/row/row0mysql.cc:1282
      #5  0x0000562619bff2cc in ha_innobase::write_row (this=0x14a6ec02c340, record=0x14a6ec020320 "fg\336X\005\a\254\031") at /test/10.6_dbg/storage/innobase/handler/ha_innodb.cc:7878
      #6  0x0000562619845b32 in handler::ha_write_row (this=0x14a6ec02c340, buf=0x14a6ec020320 "fg\336X\005\a\254\031") at /test/10.6_dbg/sql/handler.cc:7729
      #7  0x00005626199891e2 in Log_to_csv_event_handler::log_slow (this=<optimized out>, thd=0x14a6ec000d48, current_time=<optimized out>, user_host=0x14a734ce9f70 "root[root] @ localhost []", user_host_len=25, query_utime=<optimized out>, lock_utime=0, is_command=false, sql_text=0x14a6ec013360 "SET GLOBAL log_output='TABLE'", sql_text_len=29) at /test/10.6_dbg/sql/log.cc:983
      #8  0x00005626199821f2 in LOGGER::slow_log_print (this=this@entry=0x56261abc8920 <logger>, thd=thd@entry=0x14a6ec000d48, query=0x14a6ec013360 "SET GLOBAL log_output='TABLE'", query_length=29, current_utime=<optimized out>) at /test/10.6_dbg/sql/log.cc:1350
      #9  0x000056261998a7ac in slow_log_print (thd=thd@entry=0x14a6ec000d48, query=<optimized out>, query_length=<optimized out>, current_utime=<optimized out>) at /test/10.6_dbg/sql/log.cc:6950
      #10 0x0000562619552cbf in log_slow_statement (thd=thd@entry=0x14a6ec000d48) at /test/10.6_dbg/sql/sql_class.h:1416
      #11 0x000056261955c4e1 in dispatch_command (command=command@entry=COM_QUERY, thd=thd@entry=0x14a6ec000d48, packet=<optimized out>, packet@entry=0x14a6ec00afb9 "", packet_length=packet_length@entry=29, blocking=blocking@entry=true) at /test/10.6_dbg/sql/sql_parse.cc:2453
      #12 0x000056261955ca12 in do_command (thd=0x14a6ec000d48, blocking=blocking@entry=true) at /test/10.6_dbg/sql/sql_parse.cc:1409
      #13 0x00005626196b628d in do_handle_one_connection (connect=<optimized out>, connect@entry=0x56261d74aaa8, put_in_cache=put_in_cache@entry=true) at /test/10.6_dbg/sql/sql_connect.cc:1415
      #14 0x00005626196b6842 in handle_one_connection (arg=arg@entry=0x56261d74aaa8) at /test/10.6_dbg/sql/sql_connect.cc:1317
      #15 0x0000562619b32984 in pfs_spawn_thread (arg=0x56261d709338) at /test/10.6_dbg/storage/perfschema/pfs.cc:2201
      #16 0x000014a737e5c609 in start_thread (arg=<optimized out>) at pthread_create.c:477
      #17 0x000014a737a48133 in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:95
      

      Bug confirmed present in:
      MariaDB: 10.4.34 (dbg), 10.4.34 (opt), 10.5.26 (dbg), 10.5.26 (opt), 10.6.18 (dbg), 10.6.18 (opt), 10.11.8 (dbg), 10.11.8 (opt), 11.0.6 (dbg), 11.0.6 (opt), 11.1.5 (dbg), 11.1.5 (opt), 11.2.4 (dbg), 11.2.4 (opt), 11.3.3 (dbg), 11.3.3 (opt), 11.4.2 (dbg), 11.4.2 (opt), 11.5.1 (dbg), 11.5.1 (opt)

      Attachments

        Activity

          People

            sanja Oleksandr Byelkin
            ramesh Ramesh Sivaraman
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

            Dates

              Created:
              Updated:

              Git Integration

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