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

Assertion `thd->debug_binlog_xid_last.is_null() || thd->debug_binlog_xid_last.get_my_xid() != xid' failed

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Pending Release
    • Priority: Medium
    • Resolution: Fixed
    • Affects Version/s: None
    • Fix Version/s: 8.0.NEXT
    • Component/s: None
    • Labels:

      Description

      Error info

      2019-01-31T15:15:55.618431Z 16 [Note] [MY-000000] [Server] WSREP: Assigned new trx id to retry auto-commit query: 1089
      mysqld: /qa/8pxc/PXC-8.0/sql/log_event.cc:3989: Query_log_event::Query_log_event(THD*, const char*, size_t, bool, bool, bool
      , int, bool): Assertion `thd->debug_binlog_xid_last.is_null() || thd->debug_binlog_xid_last.get_my_xid() != xid' failed.
      15:15:55 UTC - mysqld got signal 6 ;
      
      

      GDB info

      #0  __pthread_kill (threadid=<optimized out>, signo=6) at ../sysdeps/unix/sysv/linux/pthread_kill.c:62
      #1  0x0000000004617198 in my_write_core (sig=6) at /qa/8pxc/PXC-8.0/mysys/stacktrace.cc:278
      #2  0x00000000034784cd in handle_fatal_signal (sig=6) at /qa/8pxc/PXC-8.0/sql/signal_handler.cc:266
      #3  <signal handler called>
      #4  0x00007fe0d72c0428 in __GI_raise (sig=sig@entry=6) at ../sysdeps/unix/sysv/linux/raise.c:54
      #5  0x00007fe0d72c202a in __GI_abort () at abort.c:89
      #6  0x00007fe0d72b8bd7 in __assert_fail_base (fmt=<optimized out>, assertion=assertion@entry=0x5baaf40 "thd->debug_binlog_xid_last.is_null() || thd->debug_binlog_xid_last.get_my_xid() != xid", file=file@entry=0x5ba8f08 "/qa/8pxc/PXC-8.0/sql/log_event.cc", line=line@entry=3989, function=function@entry=0x5bb0280 <Query_log_event::Query_log_event(THD*, char const*, unsigned long, bool, bool, bool, int, bool)::__PRETTY_FUNCTION__> "Query_log_event::Query_log_event(THD*, const char*, size_t, bool, bool, bool, int, bool)") at assert.c:92
      #7  0x00007fe0d72b8c82 in __GI___assert_fail (assertion=0x5baaf40 "thd->debug_binlog_xid_last.is_null() || thd->debug_binlog_xid_last.get_my_xid() != xid", file=0x5ba8f08 "/qa/8pxc/PXC-8.0/sql/log_event.cc", line=3989, function=0x5bb0280 <Query_log_event::Query_log_event(THD*, char const*, unsigned long, bool, bool, bool, int, bool)::__PRETTY_FUNCTION__> "Query_log_event::Query_log_event(THD*, const char*, size_t, bool, bool, bool, int, bool)") at assert.c:101
      #8  0x00000000041be94b in Query_log_event::Query_log_event (this=0x7fe0c05f9cd0, thd_arg=0x7fe073432000, query_arg=0x7fe0744d2028 "DROP FUNCTION service_get_write_locks", query_length=37, using_trans=true, immediate=false, suppress_use=false, errcode=0, ignore_cmd_internals=false, __in_chrg=<optimized out>, __vtt_parm=<optimized out>) at /qa/8pxc/PXC-8.0/sql/log_event.cc:3988
      #9  0x000000000420cbfa in THD::binlog_query (this=0x7fe073432000, qtype=THD::STMT_QUERY_TYPE, query_arg=0x7fe0744d2028 "DROP FUNCTION service_get_write_locks", query_len=37, is_trans=true, direct=false, suppress_use=false, errcode=0) at /qa/8pxc/PXC-8.0/sql/binlog.cc:11764
      #10 0x000000000333cee9 in write_bin_log (thd=0x7fe073432000, clear_error=true, query=0x7fe0744d2028 "DROP FUNCTION service_get_write_locks", query_length=37, is_trans=true) at /qa/8pxc/PXC-8.0/sql/sql_table.cc:1065
      #11 0x00000000033a4839 in mysql_drop_function (thd=0x7fe073432000, udf_name=0x7fe0744d3848) at /qa/8pxc/PXC-8.0/sql/sql_udf.cc:787
      #12 0x000000000329e423 in mysql_execute_command (thd=0x7fe073432000, first_level=true) at /qa/8pxc/PXC-8.0/sql/sql_parse.cc:4903
      #13 0x00000000032a22a6 in mysql_parse (thd=0x7fe073432000, parser_state=0x7fe0c05fcea0, update_userstat=false, force_primary_storage_engine=false) at /qa/8pxc/PXC-8.0/sql/sql_parse.cc:6003
      #14 0x00000000032a5c97 in wsrep_mysql_parse (thd=0x7fe073432000, rawbuf=0x7fe0744d2028 "DROP FUNCTION service_get_write_locks", length=37, parser_state=0x7fe0c05fcea0, update_userstat=false, force_primary_storage_engine=false) at /qa/8pxc/PXC-8.0/sql/sql_parse.cc:7178
      #15 0x000000000329464c in dispatch_command (thd=0x7fe073432000, com_data=0x7fe0c05fdb70, command=COM_QUERY) at /qa/8pxc/PXC-8.0/sql/sql_parse.cc:2021
      #16 0x0000000003291f2f in do_command (thd=0x7fe073432000) at /qa/8pxc/PXC-8.0/sql/sql_parse.cc:1415
      #17 0x0000000003414272 in threadpool_process_request (thd=0x7fe073432000) at /qa/8pxc/PXC-8.0/sql/threadpool_common.cc:235
      #18 0x0000000003441572 in handle_event (connection=0x7fe0c73fcdf0) at /qa/8pxc/PXC-8.0/sql/threadpool_unix.cc:1398
      #19 0x0000000003441737 in worker_main (param=0x6ec0c00 <all_groups>) at /qa/8pxc/PXC-8.0/sql/threadpool_unix.cc:1442
      #20 0x000000000470dbec in pfs_spawn_thread (arg=0x7fe0af7f9720) at /qa/8pxc/PXC-8.0/storage/perfschema/pfs.cc:2836
      #21 0x00007fe0d8fde6ba in start_thread (arg=0x7fe0c05fe700) at pthread_create.c:333
      #22 0x00007fe0d739241d in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:109
      

        Smart Checklist

          Attachments

            Issue Links

              Activity

                People

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

                  Dates

                  • Created:
                    Updated:
                    Resolved: