Skip to content

Instantly share code, notes, and snippets.

@shawn-kb

shawn-kb/mysql.log

Created November 15, 2018 17:44
Show Gist options
  • Save shawn-kb/327da9abe150556e29e498dbb806b6e0 to your computer and use it in GitHub Desktop.
Save shawn-kb/327da9abe150556e29e498dbb806b6e0 to your computer and use it in GitHub Desktop.
Download ZIP

Revisions

  1. shawn-kb created this gist Nov 15, 2018.
    37 changes: 37 additions & 0 deletions mysql.log
    View file
    Original file line number Diff line number Diff line change
    @@ -0,0 +1,37 @@
    2018-11-15 11:42:22 140571112892160 [Note] WSREP: Quorum results:
    version = 4,
    component = PRIMARY,
    conf_id = 69,
    members = 1/2 (joined/total),
    act_id = 1,
    last_appl. = -1,
    protocols = 0/7/3 (gcs/repl/appl),
    group UUID = cdfe2f67-e8fb-11e8-82a2-fadac5e71171
    2018-11-15 11:42:22 140571112892160 [Note] WSREP: Flow-control interval: [23, 23]
    2018-11-15 11:42:22 140571112892160 [Note] WSREP: Shifting OPEN -> PRIMARY (TO: 1)
    2018-11-15 11:42:22 140571416934144 [Note] WSREP: State transfer required:
    Group state: cdfe2f67-e8fb-11e8-82a2-fadac5e71171:1
    Local state: 00000000-0000-0000-0000-000000000000:-1
    2018-11-15 11:42:22 140571416934144 [Note] WSREP: New cluster view: global state: cdfe2f67-e8fb-11e8-82a2-fadac5e71171:1, view# 70: Primary, number of nodes: 2, my index: 0, protocol version 3
    2018-11-15 11:42:22 140571416934144 [Warning] WSREP: Gap in state sequence. Need state transfer.
    2018-11-15 11:42:22 140571083536128 [Note] WSREP: Running: 'wsrep_sst_rsync --role 'joiner' --address '”192.168.1.198”' --datadir '/var/lib/mysql/' --parent '13450' '' '
    2018-11-15 11:42:22 140571416934144 [Note] WSREP: Prepared SST request: rsync|”192.168.1.198”:4444/rsync_sst
    2018-11-15 11:42:22 140571416934144 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification.
    2018-11-15 11:42:22 140571416934144 [Note] WSREP: REPL Protocols: 7 (3, 2)
    2018-11-15 11:42:22 140571416934144 [Note] WSREP: Assign initial position for certification: 1, protocol version: 3
    2018-11-15 11:42:22 140571170555648 [Note] WSREP: Service thread queue flushed.
    2018-11-15 11:42:22 140571416934144 [Warning] WSREP: Failed to prepare for incremental state transfer: Local state UUID (00000000-0000-0000-0000-000000000000) does not match group state UUID (cdfe2f67-e8fb-11e8-82a2-fadac5e71171): 1 (Operation not permitted)
    at galera/src/replicator_str.cpp:prepare_for_IST():482. IST will be unavailable.
    2018-11-15 11:42:22 140571112892160 [Note] WSREP: Member 0.0 (”dot198”) requested state transfer from '*any*'. Selected 1.0 (”dot197”)(SYNCED) as donor.
    2018-11-15 11:42:22 140571112892160 [Note] WSREP: Shifting PRIMARY -> JOINER (TO: 1)
    2018-11-15 11:42:22 140571416934144 [Note] WSREP: Requesting state transfer: success, donor: 1
    2018-11-15 11:42:22 140571416934144 [Note] WSREP: GCache history reset: old(00000000-0000-0000-0000-000000000000:0) -> new(cdfe2f67-e8fb-11e8-82a2-fadac5e71171:1)
    2018-11-15 11:42:23 140571112892160 [Warning] WSREP: 1.0 (”dot197”): State transfer to 0.0 (”dot198”) failed: -255 (Unknown error 255)
    2018-11-15 11:42:23 140571112892160 [ERROR] WSREP: gcs/src/gcs_group.cpp:gcs_group_handle_join_msg():736: Will never receive state. Need to abort.
    2018-11-15 11:42:23 140571112892160 [Note] WSREP: gcomm: terminating thread
    2018-11-15 11:42:23 140571112892160 [Note] WSREP: gcomm: joining thread
    2018-11-15 11:42:23 140571112892160 [Note] WSREP: gcomm: closing backend
    2018-11-15 11:42:24 140571112892160 [Note] WSREP: (cde77e2a, 'tcp://0.0.0.0:4567') connection to peer cde77e2a with addr tcp://192.168.1.198:4567 timed out, no messages seen in PT3S
    2018-11-15 11:42:24 140571112892160 [Note] WSREP: (cde77e2a, 'tcp://0.0.0.0:4567') turning message relay requesting off
    2018-11-15 11:42:26 140571112892160 [Note] WSREP: (cde77e2a, 'tcp://0.0.0.0:4567') connection to peer cdfdd186 with addr tcp://192.168.1.197:4567 timed out, no messages seen in PT3S
    2018-11-15 11:42:26 140571112892160 [Note] WSREP: (cde77e2a, 'tcp://0.0.0.0:4567') turning message relay requesting on, nonlive peers: tcp://192.168.1.197:4567