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

[ERROR] WSREP: Certification exception: Unsupported key prefix: ^B: 71 (Protocol error) at galera/src/key_set.cpp:throw_bad_prefix():152

    XMLWordPrintable

    Details

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

      Description

      Issue: The following error while after completing IST.

       

      [ERROR] WSREP: Certification exception: Unsupported key prefix: ^B: 71 (Protocol error) at galera/src/key_set.cpp:throw_bad_prefix():152

      Tested this issue, the following is the reproduciable test case. 

       

      Setup :

      Node1 5.7.30

      Node2  5.7.22

      Node3  5.7.30

      Issue reproducible in the following scenario,

      IST to the lower version node(5.7.22) will fail with this error when the write load is running on the Donor node.
      Running sysbench read_write load on Donor node i.e node1(read_write running)  ---- node2 (IST in progress). 

      Node1: start sysbench.

      1. sysbench /usr/share/sysbench/oltp_read_write.lua --mysql_storage_engine=innodb --table-size=10 --tables=20 --mysql-db=test --mysql-user=root --mysql-password=Apwed --threads=5 --time=300 --report-interval=1 --events=0 --db-driver=mysql run

      Node2:  start mysqld .... after IST it fails with the following error,

      2020-07-30T10:09:54.987217Z 0 [Note] WSREP: Receiving IST...100.0% (964/964 events) complete.
      2020-07-30T10:09:54.988288Z 2 [Note] WSREP: IST received: 01cef28b-d24b-11ea-a802-3a176bffc7f4:1029
      2020-07-30T10:09:54.988600Z 2 [ERROR] WSREP: Certification exception: Unsupported key prefix: ^B: 71 (Protocol error)
       at galera/src/key_set.cpp:throw_bad_prefix():152
      2020-07-30T10:09:54.988627Z 2 [Note] WSREP: Closing send monitor...
      2020-07-30T10:09:54.988634Z 2 [Note] WSREP: Closed send monitor.
      2020-07-30T10:09:54.988645Z 2 [Note] WSREP: gcomm: terminating thread
      2020-07-30T10:09:54.988654Z 2 [Note] WSREP: gcomm: joining thread
      2020-07-30T10:09:54.988976Z 2 [Note] WSREP: gcomm: closing backend
      2020-07-30T10:09:54.991544Z 2 [Note] WSREP: Current view of cluster as seen by this node
      view (view_id(NON_PRIM,98f7384f,13)
      memb {
       c9a72f2e,0
       }
      joined {
       }
      left {
       }
      partitioned {
       98f7384f,0
       9bb1abf1,0
       }
      )
      2020-07-30T10:09:54.991702Z 2 [Note] WSREP: Current view of cluster as seen by this node
      view ((empty))
      2020-07-30T10:09:54.992457Z 2 [Note] WSREP: gcomm: closed
      2020-07-30T10:09:54.992512Z 0 [Note] WSREP: 2.0 (node2): State transfer from 0.0 (node1) complete.
      2020-07-30T10:09:54.992522Z 0 [Note] WSREP: SST leaving flow control
      2020-07-30T10:09:54.992529Z 0 [Note] WSREP: Shifting JOINER -> JOINED (TO: 1036)
      2020-07-30T10:09:54.992541Z 0 [Warning] WSREP: 0x3fec310 down context(s) not set
      2020-07-30T10:09:54.992555Z 0 [Warning] WSREP: Failed to send SYNC signal: -107 (Transport endpoint is not connected)
      2020-07-30T10:09:54.992574Z 0 [Note] WSREP: New COMPONENT: primary = no, bootstrap = no, my_idx = 0, memb_num = 1
      2020-07-30T10:09:54.992587Z 0 [Note] WSREP: Flow-control interval: [100, 100]
      2020-07-30T10:09:54.992593Z 0 [Note] WSREP: Trying to continue unpaused monitor
      2020-07-30T10:09:54.992598Z 0 [Note] WSREP: Received NON-PRIMARY.
      2020-07-30T10:09:54.992603Z 0 [Note] WSREP: Shifting JOINED -> OPEN (TO: 1036)
      2020-07-30T10:09:54.992611Z 0 [Note] WSREP: Received self-leave message.
      2020-07-30T10:09:54.992618Z 0 [Note] WSREP: Flow-control interval: [0, 0]
      2020-07-30T10:09:54.992622Z 0 [Note] WSREP: Trying to continue unpaused monitor
      2020-07-30T10:09:54.992627Z 0 [Note] WSREP: Received SELF-LEAVE. Closing connection.
      2020-07-30T10:09:54.992632Z 0 [Note] WSREP: Shifting OPEN -> CLOSED (TO: 1036)
      2020-07-30T10:09:54.992638Z 0 [Note] WSREP: RECV thread exiting 0: Success
      2020-07-30T10:09:54.993057Z 2 [Note] WSREP: recv_thread() joined.
      2020-07-30T10:09:54.993057Z 2 [Note] WSREP: recv_thread() joined.
      2020-07-30T10:09:54.993181Z 2 [Note] WSREP: Closing replication queue.
      2020-07-30T10:09:54.993197Z 2 [Note] WSREP: Closing slave action queue.
      2020-07-30T10:09:54.993213Z 2 [Note] WSREP: /usr/sbin/mysqld: Terminated.

       

        Smart Checklist

          Attachments

            Issue Links

              Activity

                People

                Assignee:
                Unassigned
                Reporter:
                lalit.choudhary Lalit Choudhary
                Votes:
                0 Vote for this issue
                Watchers:
                2 Start watching this issue

                  Dates

                  Created:
                  Updated: