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

Galera crash in rpl_sql_thread_info/cached_charset_compare

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Blocker
    • Resolution: Fixed
    • 10.0.13-galera
    • 10.0.14-galera
    • Galera
    • None
    • RHEL 6.5 x86-64

    Description

      I'm doing INSERT on one node and UPDATE on another. It often leads to a crash on the node where I'm executing UPDATE.

      Thread pointer: 0x0x7f711aff3008
      Attempting backtrace. You can use the following information to find out
      where mysqld died. If you see no messages after this, something went
      terribly wrong...
      stack_bottom = 0x7f710b5b4ce0 thread_stack 0x48000
      /usr/sbin/mysqld(my_print_stacktrace+0x2b)[0xb9541b]
      /usr/sbin/mysqld(handle_fatal_signal+0x398)[0x744b48]
      /lib64/libpthread.so.0[0x3166e0f710]
      /lib64/libc.so.6[0x3166b3f3c0]
      /usr/sbin/mysqld(_ZNK19rpl_sql_thread_info22cached_charset_compareEPc+0x20)[0x69b460]
      /usr/sbin/mysqld(_ZN15Query_log_event14do_apply_eventEP14rpl_group_infoPKcj+0x86f)[0x802bdf]
      /usr/sbin/mysqld(_Z14wsrep_apply_cbPvPKvmjPK14wsrep_trx_meta+0x525)[0x6f1c05]
      /usr/lib64/galera/libgalera_smm.so(ZNK6galera9TrxHandle5applyEPvPF15wsrep_cb_statusS1_PKvmjPK14wsrep_trx_metaERS6+0xb1)[0x7f71409542c1]
      /usr/lib64/galera/libgalera_smm.so(+0x1aaf95)[0x7f714098bf95]
      /usr/lib64/galera/libgalera_smm.so(_ZN6galera13ReplicatorSMM10replay_trxEPNS_9TrxHandleEPv+0x12e)[0x7f714098c85e]
      /usr/lib64/galera/libgalera_smm.so(galera_replay_trx+0x5c)[0x7f71409a045c]
      /usr/sbin/mysqld(_Z24wsrep_replay_transactionP3THD+0x2de)[0x6f379e]
      /usr/sbin/mysqld[0x5e24b0]
      /usr/sbin/mysqld(_Z16dispatch_command19enum_server_commandP3THDPcj+0x16d0)[0x5e3c30]
      /usr/sbin/mysqld(_Z10do_commandP3THD+0x132)[0x5e4402]
      /usr/sbin/mysqld(_Z24do_handle_one_connectionP3THD+0x54b)[0x6a31cb]
      /usr/sbin/mysqld(handle_one_connection+0x42)[0x6a32c2]
      /lib64/libpthread.so.0[0x3166e079d1]
      /lib64/libc.so.6(clone+0x6d)[0x3166ae886d]

      Trying to get some variables.
      Some pointers may be invalid and cause the dump to abort.
      Query (0x7f711b19f351): UPDATE t1 SET v=v+1 WHERE k=30
      Connection ID (thread ID): 5
      Status: NOT_KILLED

      Optimizer switch: index_merge=on,index_merge_union=on,index_merge_sort_union=on,index_merge_intersection=on,index_merge_sort_intersection=off,engine_condition_pushdown=off,index_condition_pushdown=on,derived_merge=on,derived_with_keys=on,firstmatch=on,loosescan=on,materialization=on,in_to_exists=on,semijoin=on,partial_match_rowid_merge=on,partial_match_table_scan=on,subquery_cache=on,mrr=off,mrr_cost_based=off,mrr_sort_keys=off,outer_join_with_cache=on,semijoin_with_cache=on,join_cache_incremental=on,join_cache_hashed=on,join_cache_bka=on,optimize_join_buffer_size=off,table_elimination=on,extended_keys=on,exists_to_in=on

      Tail of general log:

      140912 17:02:44 1 Query INSERT INTO t1 (k,j) VALUES (29,11)
      1 Query INSERT INTO t1 (k,j) VALUES (29,12)
      1 Query INSERT INTO t1 (k,j) VALUES (29,13)
      1 Query INSERT INTO t1 (k,j) VALUES (29,14)
      1 Query INSERT INTO t1 (k,j) VALUES (29,15)
      1 Query INSERT INTO t1 (k,j) VALUES (29,16)
      1 Query INSERT INTO t1 (k,j) VALUES (29,17)
      1 Query INSERT INTO t1 (k,j) VALUES (29,18)
      1 Query INSERT INTO t1 (k,j) VALUES (29,19)
      5 Query UPDATE t1 SET v=v+1 WHERE k=29
      1 Query INSERT INTO t1 (k,j) VALUES (30,0)
      1 Query INSERT INTO t1 (k,j) VALUES (30,1)
      1 Query INSERT INTO t1 (k,j) VALUES (30,2)
      1 Query INSERT INTO t1 (k,j) VALUES (30,3)
      1 Query INSERT INTO t1 (k,j) VALUES (30,4)
      1 Query INSERT INTO t1 (k,j) VALUES (30,5)
      1 Query INSERT INTO t1 (k,j) VALUES (30,6)
      1 Query INSERT INTO t1 (k,j) VALUES (30,7)
      1 Query INSERT INTO t1 (k,j) VALUES (30,8)
      1 Query INSERT INTO t1 (k,j) VALUES (30,9)
      1 Query INSERT INTO t1 (k,j) VALUES (30,10)
      1 Query INSERT INTO t1 (k,j) VALUES (30,11)
      1 Query INSERT INTO t1 (k,j) VALUES (30,12)
      1 Query INSERT INTO t1 (k,j) VALUES (30,13)
      1 Query INSERT INTO t1 (k,j) VALUES (30,14)
      1 Query INSERT INTO t1 (k,j) VALUES (30,15)
      1 Query INSERT INTO t1 (k,j) VALUES (30,16)
      1 Query INSERT INTO t1 (k,j) VALUES (30,17)
      5 Query UPDATE t1 SET v=v+1 WHERE k=30
      1 Query INSERT INTO t1 (k,j) VALUES (30,18)
      1 Query INSERT INTO t1 (k,j) VALUES (30,19)

      Attachments

        1. mdev_6740.sh
          0.6 kB
          Nirbhay Choubey
        2. test_galera_sync.py
          1 kB
          Kolbe Kegel

        Activity

          People

            nirbhay_c Nirbhay Choubey (Inactive)
            kolbe Kolbe Kegel (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Git Integration

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