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

Failed to replicate CURRENT_USER() involved ALTER TABLE

    Details

    • Type: Bug
    • Status: Done
    • Priority: High
    • Resolution: Fixed
    • Affects Version/s: None
    • Fix Version/s: 5.6.44-28.34, 5.7.26-31.37
    • Component/s: None
    • Labels:
      None

      Description

      GDB Info

      #0  __pthread_kill (threadid=<optimized out>, signo=6) at ../sysdeps/unix/sysv/linux/pthread_kill.c:62
      #1  0x000000000475bbe7 in my_write_core (sig=6) at /mnt/workspace/qa.pxc80.build/BUILD_TYPE/debug/Host/min-xenial-x64/mysys/stacktrace.cc:278
      #2  0x000000000359ac0e in handle_fatal_signal (sig=6) at /mnt/workspace/qa.pxc80.build/BUILD_TYPE/debug/Host/min-xenial-x64/sql/signal_handler.cc:264
      #3  <signal handler called>
      #4  0x00007f6c5f080428 in __GI_raise (sig=sig@entry=6) at ../sysdeps/unix/sysv/linux/raise.c:54
      #5  0x00007f6c5f08202a in __GI_abort () at abort.c:89
      #6  0x00007f6c5f078bd7 in __assert_fail_base (fmt=<optimized out>, assertion=assertion@entry=0x599c687 "sctx->user().str", file=file@entry=0x599b3e0 "/mnt/workspace/qa.pxc80.build/BUILD_TYPE/debug/Host/min-xenial-x64/sql/sql_parse.cc", line=line@entry=5264, function=function@entry=0x599d9a0 <mysql_execute_command(THD*, bool)::__PRETTY_FUNCTION__> "int mysql_execute_command(THD*, bool)") at assert.c:92
      #7  0x00007f6c5f078c82 in __GI___assert_fail (assertion=0x599c687 "sctx->user().str", file=0x599b3e0 "/mnt/workspace/qa.pxc80.build/BUILD_TYPE/debug/Host/min-xenial-x64/sql/sql_parse.cc", line=5264, function=0x599d9a0 <mysql_execute_command(THD*, bool)::__PRETTY_FUNCTION__> "int mysql_execute_command(THD*, bool)") at assert.c:101
      #8  0x00000000033b9634 in mysql_execute_command (thd=0x7f6c3940f000, first_level=true) at /mnt/workspace/qa.pxc80.build/BUILD_TYPE/debug/Host/min-xenial-x64/sql/sql_parse.cc:5264
      #9  0x00000000033bc1e1 in mysql_parse (thd=0x7f6c3940f000, parser_state=0x7f6c613a0ca0, update_userstat=true, force_primary_storage_engine=true) at /mnt/workspace/qa.pxc80.build/BUILD_TYPE/debug/Host/min-xenial-x64/sql/sql_parse.cc:6076
      #10 0x00000000042f6216 in Query_log_event::do_apply_event (this=0x7f6c39508020, rli=0x7f6c39482000, query_arg=0x7f6bfed751d8 "ALTER USER USER() IDENTIFIED BY 'abc'", q_len_arg=37) at /mnt/workspace/qa.pxc80.build/BUILD_TYPE/debug/Host/min-xenial-x64/sql/log_event.cc:4669
      #11 0x00000000042f4a4d in Query_log_event::do_apply_event (this=0x7f6c39508020, rli=0x7f6c39482000) at /mnt/workspace/qa.pxc80.build/BUILD_TYPE/debug/Host/min-xenial-x64/sql/log_event.cc:4333
      #12 0x00000000042f077e in Log_event::apply_event (this=0x7f6c39508020, rli=0x7f6c39482000) at /mnt/workspace/qa.pxc80.build/BUILD_TYPE/debug/Host/min-xenial-x64/sql/log_event.cc:3172
      #13 0x00000000035d5906 in wsrep_apply_events (thd=0x7f6c3940f000, events_buf=0x7f6c414dad90, buf_len=0) at /mnt/workspace/qa.pxc80.build/BUILD_TYPE/debug/Host/min-xenial-x64/sql/wsrep_applier.cc:176
      #14 0x00000000035d64f0 in wsrep_apply_cb (ctx=0x7f6c3940f000, buf=0x7f6c414dad90, buf_len=122, flags=5, meta=0x7f6c613a3f80) at /mnt/workspace/qa.pxc80.build/BUILD_TYPE/debug/Host/min-xenial-x64/sql/wsrep_applier.cc:302
      #15 0x00007f6c4988d048 in galera::TrxHandle::apply (this=0x7f6bfec0b100, recv_ctx=0x7f6c3940f000, apply_cb=0x35d6045 <wsrep_apply_cb(void*, void const*, unsigned long, unsigned int, wsrep_trx_meta const*)>, meta=...) at galera/src/trx_handle.cpp:317
      #16 0x00007f6c498cf348 in apply_trx_ws (recv_ctx=0x7f6c3940f000, apply_cb=0x35d6045 <wsrep_apply_cb(void*, void const*, unsigned long, unsigned int, wsrep_trx_meta const*)>, commit_cb=0x35d747d <wsrep_commit_cb(void*, void const*, unsigned int, wsrep_trx_meta const*, bool*, bool)>, trx=..., meta=...) at galera/src/replicator_smm.cpp:34
      #17 0x00007f6c498d2659 in galera::ReplicatorSMM::apply_trx (this=0x7f6c517f6000, recv_ctx=0x7f6c3940f000, trx=0x7f6bfec0b100) at galera/src/replicator_smm.cpp:494
      #18 0x00007f6c498d786f in galera::ReplicatorSMM::process_trx (this=0x7f6c517f6000, recv_ctx=0x7f6c3940f000, trx=0x7f6bfec0b100) at galera/src/replicator_smm.cpp:1419
      #19 0x00007f6c498b15f1 in galera::GcsActionSource::dispatch (this=0x7f6c517f66a8, recv_ctx=0x7f6c3940f000, act=..., exit_loop=@0x7f6c613a4a0b: false) at galera/src/gcs_action_source.cpp:116
      #20 0x00007f6c498b1dc1 in galera::GcsActionSource::process (this=0x7f6c517f66a8, recv_ctx=0x7f6c3940f000, exit_loop=@0x7f6c613a4a0b: false) at galera/src/gcs_action_source.cpp:181
      #21 0x00007f6c498d1c72 in galera::ReplicatorSMM::async_recv (this=0x7f6c517f6000, recv_ctx=0x7f6c3940f000) at galera/src/replicator_smm.cpp:408
      #22 0x00007f6c498f4a26 in galera_recv (gh=0x7f6c5e858600, recv_ctx=0x7f6c3940f000) at galera/src/wsrep_provider.cpp:244
      #23 0x00000000035da8ee in wsrep_replication_process (thd=0x7f6c3940f000) at /mnt/workspace/qa.pxc80.build/BUILD_TYPE/debug/Host/min-xenial-x64/sql/wsrep_thd.cc:447
      #24 0x00000000031bc29c in start_wsrep_THD (arg=0x35da7f5 <wsrep_replication_process(THD*)>) at /mnt/workspace/qa.pxc80.build/BUILD_TYPE/debug/Host/min-xenial-x64/sql/mysqld.cc:8785
      #25 0x000000000485290a in pfs_spawn_thread (arg=0x7f6c517e4c20) at /mnt/workspace/qa.pxc80.build/BUILD_TYPE/debug/Host/min-xenial-x64/storage/perfschema/pfs.cc:2836
      #26 0x00007f6c60d9e6ba in start_thread (arg=0x7f6c613a7700) at pthread_create.c:333
      #27 0x00007f6c5f15241d 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:

                    Time Tracking

                    Estimated:
                    Original Estimate - Not Specified
                    Not Specified
                    Remaining:
                    Remaining Estimate - Not Specified
                    Not Specified
                    Logged:
                    Time Spent - 7 hours, 10 minutes
                    7h 10m