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

Statistics: Failing assertion: trx_is_registered_for_2pc(trx) in ha_innodb.cc on ANALYZE TABLE with row binary logging

    Details

    • Type: Bug
    • Status: Closed (View Workflow)
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: None
    • Fix Version/s: 10.0.0
    • Component/s: None
    • Labels:
      None

      Description

      InnoDB: Assertion failure in thread 2805345136 in file ha_innodb.cc line 10594
      InnoDB: Failing assertion: trx_is_registered_for_2pc(trx)
      InnoDB: We intentionally generate a memory trap.

       
      #7  0xb75190f0 in abort () from /lib/libc.so.6
      #8  0xad0d0454 in innobase_xa_prepare (hton=0x9674ae8, thd=0x9dd9610, all=false)
          at storage/innobase/handler/ha_innodb.cc:10594
      #9  0x083dade2 in ha_commit_trans (thd=0x9dd9610, all=false)
          at sql/handler.cc:1264
      #10 0x0833ed92 in trans_commit_stmt (thd=0x9dd9610)
          at sql/transaction.cc:299
      #11 0x0833d786 in mysql_admin_table (thd=0x9dd9610, tables=0x9daa1b0, check_opt=0x9ddb464,
          operator_name=0x8922f9d "analyze", lock_type=TL_READ_NO_INSERT, open_for_modify=true,
          repair_table_use_frm=false, extra_open_options=0, prepare_func=0, operator_func=
          (int (handler::*)(handler *, THD *, HA_CHECK_OPT *)) 0x83df758 <handler::ha_analyze(THD*, HA_CHECK_OPT*)>, view_operator_func=0) at sql/sql_admin.cc:952
      #12 0x0833dc7c in Analyze_table_statement::execute (this=0x9daa5c8, thd=0x9dd9610)
          at sql/sql_admin.cc:1075
      #13 0x08244d44 in mysql_execute_command (thd=0x9dd9610)
          at sql/sql_parse.cc:4459
      #14 0x08247b91 in mysql_parse (thd=0x9dd9610, rawbuf=0x9daa110 "ANALYZE TABLE t1", length=16,
          parser_state=0xa7361da4) at sql/sql_parse.cc:5736
      #15 0x0823bfdc in dispatch_command (command=COM_QUERY, thd=0x9dd9610, packet=0x9d917a1 "",
          packet_length=16) at sql/sql_parse.cc:1055
      #16 0x0823b4a1 in do_command (thd=0x9dd9610) at sql/sql_parse.cc:794
      #17 0x0832e271 in do_handle_one_connection (thd_arg=0x9dd9610)
          at sql/sql_connect.cc:1253
      #18 0x0832ddbc in handle_one_connection (arg=0x9dd9610)
          at sql/sql_connect.cc:1168
      #19 0x08558033 in pfs_spawn_thread (arg=0x9dc7df8)
          at storage/perfschema/pfs.cc:1015
      #20 0xb77efb25 in start_thread () from /lib/libpthread.so.0
       

      Trying to get some variables.
      Some pointers may be invalid and cause the dump to abort.
      Query (0x9daa110): ANALYZE TABLE t1
      Connection ID (thread ID): 3
      Status: NOT_KILLED

      bzr version-info:

      revision-id: igor@askmonty.org-20120814194214-bc5hme0t1qeewrmj
      date: 2012-08-14 12:42:14 -0700
      build-date: 2012-08-17 05:53:58 +0400
      revno: 3358

      Test case:

       
       
      --source include/have_binlog_format_row.inc
      --source include/have_innodb.inc
       
      SET GLOBAL use_stat_tables = PREFERABLY;
       
      --connect (con1,localhost,root,,)
      CREATE TABLE t1 (i INT) ENGINE=InnoDB;
      ANALYZE TABLE t1;
       
      # Cleanup
       
      DROP TABLE t1;
      SET GLOBAL use_stat_tables = DEFAULT;
      --disconnect con1
       

        Attachments

          Activity

            People

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

              Dates

              • Created:
                Updated:
                Resolved: