Uploaded image for project: 'Percona XtraDB Cluster'
  1. Percona XtraDB Cluster
  2. PXC-792

InnoDB: Failing assertion: trx->lock.trx_locks.count > 0 in trx0trx.cc line 2157

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: On Hold
    • Priority: Medium
    • Resolution: Unresolved
    • Affects Version/s: None
    • Fix Version/s: None
    • Component/s: None

      Description

      GDB info

      #0  0x00007f2e3221d771 in pthread_kill () from /lib64/libpthread.so.0
      #1  0x0000000000af7cec in my_write_core (sig=6) at /mnt/workspace/qa.pxc56.build/BUILD_TYPE/debug/label_exp/centos7-64/mysys/stacktrace.c:424
      #2  0x000000000075bcbe in handle_fatal_signal (sig=6) at /mnt/workspace/qa.pxc56.build/BUILD_TYPE/debug/label_exp/centos7-64/sql/signal_handler.cc:248
      #3  <signal handler called>
      #4  0x00007f2e303a55d7 in raise () from /lib64/libc.so.6
      #5  0x00007f2e303a6cc8 in abort () from /lib64/libc.so.6
      #6  0x0000000000d4ecae in wsrep_trx_print_locking (f=0x7f2e3072b1c0 <_IO_2_1_stderr_>, trx=0x7f2e0109bb78, max_query_len=3000) at /mnt/workspace/qa.pxc56.build/BUILD_TYPE/debug/label_exp/centos7-64/storage/innobase/trx/trx0trx.cc:2157
      #7  0x0000000000c237f0 in wsrep_kill_victim (trx=0x7f2e0109bb78, lock=0x7f2e018d21f8) at /mnt/workspace/qa.pxc56.build/BUILD_TYPE/debug/label_exp/centos7-64/storage/innobase/lock/lock0lock.cc:1672
      #8  0x0000000000c2a536 in lock_table_other_has_incompatible (trx=0x7f2e0109bb78, wait=256, table=0x7f2e01891c78, mode=LOCK_X) at /mnt/workspace/qa.pxc56.build/BUILD_TYPE/debug/label_exp/centos7-64/storage/innobase/lock/lock0lock.cc:4808
      #9  0x0000000000c2a690 in lock_table (flags=0, table=0x7f2e01891c78, mode=LOCK_X, thr=0x7f2e010ade78) at /mnt/workspace/qa.pxc56.build/BUILD_TYPE/debug/label_exp/centos7-64/storage/innobase/lock/lock0lock.cc:4870
      #10 0x0000000000cc11a8 in row_merge_lock_table (trx=0x7f2e0109bb78, table=0x7f2e01891c78, mode=LOCK_X) at /mnt/workspace/qa.pxc56.build/BUILD_TYPE/debug/label_exp/centos7-64/storage/innobase/row/row0merge.cc:2704
      #11 0x0000000000bf3f70 in ha_innobase::commit_inplace_alter_table (this=0x7f2e0101f110, altered_table=0x7f2e01069a00, ha_alter_info=0x7f2e3277cc30, commit=true) at /mnt/workspace/qa.pxc56.build/BUILD_TYPE/debug/label_exp/centos7-64/storage/innobase/handler/handler0alter.cc:5585
      #12 0x000000000066e7e8 in handler::ha_commit_inplace_alter_table (this=0x7f2e0101f110, altered_table=0x7f2e01069a00, ha_alter_info=0x7f2e3277cc30, commit=true) at /mnt/workspace/qa.pxc56.build/BUILD_TYPE/debug/label_exp/centos7-64/sql/handler.cc:4843
      #13 0x000000000088ddb8 in mysql_inplace_alter_table (thd=0x7f2e01012000, table_list=0x7f2e01045080, table=0x7f2e010ddc00, altered_table=0x7f2e01069a00, ha_alter_info=0x7f2e3277cc30, inplace_supported=HA_ALTER_INPLACE_NO_LOCK_AFTER_PREPARE, target_mdl_request=0x7f2e3277c680, alter_ctx=0x7f2e3277d190) at /mnt/workspace/qa.pxc56.build/BUILD_TYPE/debug/label_exp/centos7-64/sql/sql_table.cc:7002
      #14 0x0000000000892ca8 in mysql_alter_table (thd=0x7f2e01012000, new_db=0x7f2e010455e0 "test", new_name=0x0, create_info=0x7f2e3277e050, table_list=0x7f2e01045080, alter_info=0x7f2e3277df90, order_num=0, order=0x0, ignore=false) at /mnt/workspace/qa.pxc56.build/BUILD_TYPE/debug/label_exp/centos7-64/sql/sql_table.cc:9052
      #15 0x00000000009e0333 in Sql_cmd_alter_table::execute (this=0x7f2e010455f0, thd=0x7f2e01012000) at /mnt/workspace/qa.pxc56.build/BUILD_TYPE/debug/label_exp/centos7-64/sql/sql_alter.cc:331
      #16 0x000000000081d163 in mysql_execute_command (thd=0x7f2e01012000) at /mnt/workspace/qa.pxc56.build/BUILD_TYPE/debug/label_exp/centos7-64/sql/sql_parse.cc:6264
      #17 0x0000000000821527 in mysql_parse (thd=0x7f2e01012000, rawbuf=0x7f2e01122209 "alter table t1 auto_increment = 50", length=34, parser_state=0x7f2e3277f8c0) at /mnt/workspace/qa.pxc56.build/BUILD_TYPE/debug/label_exp/centos7-64/sql/sql_parse.cc:7925
      #18 0x0000000000a555ef in Query_log_event::do_apply_event (this=0x7f2e01067e00, rli=0x7f2e0104a000, query_arg=0x7f2e01122209 "alter table t1 auto_increment = 50", q_len_arg=34) at /mnt/workspace/qa.pxc56.build/BUILD_TYPE/debug/label_exp/centos7-64/sql/log_event.cc:4865
      #19 0x0000000000a548d1 in Query_log_event::do_apply_event (this=0x7f2e01067e00, rli=0x7f2e0104a000) at /mnt/workspace/qa.pxc56.build/BUILD_TYPE/debug/label_exp/centos7-64/sql/log_event.cc:4589
      #20 0x0000000000a5058b in Log_event::apply_event (this=0x7f2e01067e00, rli=0x7f2e0104a000) at /mnt/workspace/qa.pxc56.build/BUILD_TYPE/debug/label_exp/centos7-64/sql/log_event.cc:3130
      #21 0x000000000065a9f5 in wsrep_apply_events (thd=0x7f2e01012000, events_buf=0x7f2e1f4ecd7e, buf_len=0) at /mnt/workspace/qa.pxc56.build/BUILD_TYPE/debug/label_exp/centos7-64/sql/wsrep_applier.cc:147
      #22 0x000000000065b0ce in wsrep_apply_cb (ctx=0x7f2e01012000, buf=0x7f2e1f4ecd7e, buf_len=97, flags=5, meta=0x7f2e32781020) at /mnt/workspace/qa.pxc56.build/BUILD_TYPE/debug/label_exp/centos7-64/sql/wsrep_applier.cc:250
      #23 0x00007f2e278a75a3 in galera::TrxHandle::apply (this=0x7f2e0105a500, recv_ctx=0x7f2e01012000, apply_cb=0x65ae2c <wsrep_apply_cb(void*, void const*, unsigned long, unsigned int, wsrep_trx_meta const*)>, meta=...) at galera/src/trx_handle.cpp:315
      #24 0x00007f2e278e2a41 in apply_trx_ws (recv_ctx=0x7f2e01012000, apply_cb=0x65ae2c <wsrep_apply_cb(void*, void const*, unsigned long, unsigned int, wsrep_trx_meta const*)>, commit_cb=0x65b4db <wsrep_commit_cb(void*, unsigned int, wsrep_trx_meta const*, bool*, bool)>, trx=..., meta=...) at galera/src/replicator_smm.cpp:39
      #25 0x00007f2e278e5aca in galera::ReplicatorSMM::apply_trx (this=0x7f2e2a7f1000, recv_ctx=0x7f2e01012000, trx=0x7f2e0105a500) at galera/src/replicator_smm.cpp:472
      #26 0x00007f2e278e9d17 in galera::ReplicatorSMM::process_trx (this=0x7f2e2a7f1000, recv_ctx=0x7f2e01012000, trx=0x7f2e0105a500) at galera/src/replicator_smm.cpp:1276
      #27 0x00007f2e278c780a in galera::GcsActionSource::dispatch (this=0x7f2e2a7f16d0, recv_ctx=0x7f2e01012000, act=..., exit_loop=@0x7f2e32781cff: false) at galera/src/gcs_action_source.cpp:116
      #28 0x00007f2e278c7f50 in galera::GcsActionSource::process (this=0x7f2e2a7f16d0, recv_ctx=0x7f2e01012000, exit_loop=@0x7f2e32781cff: false) at galera/src/gcs_action_source.cpp:181
      #29 0x00007f2e278e52ff in galera::ReplicatorSMM::async_recv (this=0x7f2e2a7f1000, recv_ctx=0x7f2e01012000) at galera/src/replicator_smm.cpp:394
      #30 0x00007f2e279026d4 in galera_recv (gh=0x7f2e2e418140, recv_ctx=0x7f2e01012000) at galera/src/wsrep_provider.cpp:244
      #31 0x000000000065ce74 in wsrep_replication_process (thd=0x7f2e01012000) at /mnt/workspace/qa.pxc56.build/BUILD_TYPE/debug/label_exp/centos7-64/sql/wsrep_thd.cc:314
      #32 0x0000000000638993 in start_wsrep_THD (arg=0x65cdbc <wsrep_replication_process(THD*)>) at /mnt/workspace/qa.pxc56.build/BUILD_TYPE/debug/label_exp/centos7-64/sql/mysqld.cc:5856
      #33 0x00007f2e32218df5 in start_thread () from /lib64/libpthread.so.0
      #34 0x00007f2e304661ad in clone () from /lib64/libc.so.6
      

        Smart Checklist

          Attachments

            Activity

              People

              • Assignee:
                krunal.bauskar Krunal Bauskar
                Reporter:
                ramesh.sivaraman Ramesh Sivaraman
              • Votes:
                0 Vote for this issue
                Watchers:
                1 Start watching this issue

                Dates

                • Created:
                  Updated: