Skip to content

Instantly share code, notes, and snippets.

@ayurchen
Created January 13, 2020 18:33
Show Gist options
  • Save ayurchen/6601de9d7c073742067b59ee0dd2447b to your computer and use it in GitHub Desktop.
Save ayurchen/6601de9d7c073742067b59ee0dd2447b to your computer and use it in GitHub Desktop.
2020-01-13T17:27:14.796440Z 3 [Note] [MY-000000] [Server] WSREP: Recovered position from storage: ec1be53e-3629-11ea-a3d1-e32eda2a3fe6:3
2020-01-13T17:27:14.798088Z 3 [Note] [MY-000000] [Server] WSREP: Recovered view from SST:
id: ec1be53e-3629-11ea-a3d1-e32eda2a3fe6:3
status: primary
protocol_version: 4
capabilities: MULTI-MASTER, CERTIFICATION, PARALLEL_APPLYING, REPLAY, ISOLATION, PAUSE, CAUSAL_READ, INCREMENTAL_WS, UNORDERED, PREORDERED, STREAMING, NBO
final: no
own_index: 0
members(3):
0: ec1770c1-3629-11ea-aae6-af217c2f7564, void
1: ec1774ef-3629-11ea-adbe-4e56d4322d7c, void
2: ec180727-3629-11ea-a4c8-16aca228ed82, void
2020-01-13T17:27:14.798113Z 3 [Note] [MY-000000] [WSREP] wsrep_notify_cmd is not defined, skipping notification.
2020-01-13T17:27:14.798117Z 0 [System] [MY-010931] [Server] /home/ayurchen/codership/mysql-git/bugs/build_debug/runtime_output_directory/mysqld: ready for connections. Version: '8.0.18-debug' socket: '/tmp/mtr/tmp/3/mysqld.2.sock' port: 10405 Source distribution.
2020-01-13T17:27:14.798618Z 0 [Note] [MY-000000] [WSREP] Recovered cluster id ec1be53e-3629-11ea-a3d1-e32eda2a3fe6
2020-01-13T17:27:14.799161Z 3 [Note] [MY-000000] [Server] WSREP: SST received: ec1be53e-3629-11ea-a3d1-e32eda2a3fe6:3
2020-01-13T17:27:14.799237Z 2 [Note] [MY-000000] [Server] WSREP: Installed new state from SST: ec1be53e-3629-11ea-a3d1-e32eda2a3fe6:3
2020-01-13T17:27:14.802927Z 2 [Note] [MY-000000] [Server] WSREP: Cert. index preload up to 3
2020-01-13T17:27:14.803009Z 0 [Note] [MY-000000] [Server] WSREP: ####### IST applying starts with 4
2020-01-13T17:27:14.803082Z 0 [Note] [MY-000000] [Server] WSREP: ####### IST current seqno initialized to 2
2020-01-13T17:27:14.803143Z 0 [Note] [MY-000000] [Server] WSREP: Receiving IST... 0.0% (0/1 events) complete.
2020-01-13T17:27:14.803152Z 0 [Note] [MY-000000] [Server] WSREP: IST preload starting at 2
2020-01-13T17:27:14.803174Z 0 [Note] [MY-000000] [Server] WSREP: REPL Protocols: 10 (5)
2020-01-13T17:27:14.803201Z 0 [Note] [MY-000000] [Server] WSREP: Service thread queue flushed.
2020-01-13T17:27:14.803278Z 0 [Note] [MY-000000] [Server] WSREP: ####### Assign initial position for certification: ec1be53e-3629-11ea-a3d1-e32eda2a3fe6:1, protocol version: 5
2020-01-13T17:27:14.803301Z 0 [Note] [MY-000000] [Server] WSREP: REPL Protocols: 10 (5)
2020-01-13T17:27:14.803314Z 0 [Note] [MY-000000] [Server] WSREP: ####### Adjusting cert position: 1 -> 2
2020-01-13T17:27:14.803333Z 0 [Note] [MY-000000] [Server] WSREP: Service thread queue flushed.
2020-01-13T17:27:14.803399Z 0 [Note] [MY-000000] [Server] WSREP: Lowest cert indnex boundary for CC from preload: 2
2020-01-13T17:27:14.803416Z 0 [Note] [MY-000000] [Server] WSREP: Min available from gcache for CC from preload: 2
2020-01-13T17:27:14.803437Z 0 [Note] [MY-000000] [Server] WSREP: Receiving IST...100.0% (1/1 events) complete.
2020-01-13T17:27:14.803624Z 2 [Note] [MY-000000] [Server] WSREP: Cert. index preloaded up to 2
2020-01-13T17:27:14.803683Z 2 [Note] [MY-000000] [Server] WSREP: Lowest cert indnex boundary for CC from sst: 2
2020-01-13T17:27:14.803695Z 2 [Note] [MY-000000] [Server] WSREP: Min available from gcache for CC from sst: 2
2020-01-13T17:27:14.803726Z 2 [Note] [MY-000000] [Server] WSREP: ####### skipping CC 3, local
2020-01-13T17:27:14.803996Z 0 [Note] [MY-000000] [Server] WSREP: 0.0 (void): State transfer from 2.0 (void) complete.
2020-01-13T17:27:14.804017Z 0 [Note] [MY-000000] [Server] WSREP: Shifting JOINER -> JOINED (TO: 3)
2020-01-13T17:27:14.804074Z 2 [Warning] [MY-000000] [Server] WSREP: last left 3 greater than drain seqno 2
2020-01-13T17:27:14.804086Z 2 [Note] [MY-000000] [Server] WSREP: applier 2 in state 0
2020-01-13T17:27:14.804093Z 2 [Note] [MY-000000] [Server] WSREP: applier 3 in state 0
2020-01-13T17:27:14.804101Z 2 [Warning] [MY-000000] [Server] WSREP: last left 3 greater than drain seqno 2
2020-01-13T17:27:14.804108Z 2 [Note] [MY-000000] [Server] WSREP: applier 2 in state 0
2020-01-13T17:27:14.804114Z 2 [Note] [MY-000000] [Server] WSREP: applier 3 in state 0
2020-01-13T17:27:14.804355Z 0 [Note] [MY-000000] [Server] WSREP: Member 0.0 (void) synced with group.
2020-01-13T17:27:14.804367Z 0 [Note] [MY-000000] [Server] WSREP: Shifting JOINED -> SYNCED (TO: 3)
2020-01-13T17:27:14.804419Z 2 [Warning] [MY-000000] [Server] WSREP: last left 3 greater than drain seqno 2
2020-01-13T17:27:14.804437Z 2 [Note] [MY-000000] [Server] WSREP: applier 2 in state 0
2020-01-13T17:27:14.804445Z 2 [Note] [MY-000000] [Server] WSREP: applier 3 in state 0
2020-01-13T17:27:14.804453Z 2 [Warning] [MY-000000] [Server] WSREP: last left 3 greater than drain seqno 2
2020-01-13T17:27:14.804460Z 2 [Note] [MY-000000] [Server] WSREP: applier 2 in state 0
2020-01-13T17:27:14.804466Z 2 [Note] [MY-000000] [Server] WSREP: applier 3 in state 0
2020-01-13T17:27:14.804475Z 2 [Note] [MY-000000] [Server] WSREP: Server void synced with group
2020-01-13T17:27:14.804486Z 2 [Note] [MY-000000] [WSREP] Server status change joined -> synced
2020-01-13T17:27:14.804494Z 2 [Note] [MY-000000] [WSREP] Synchronized with group, ready for connections
2020-01-13T17:27:14.804501Z 2 [Note] [MY-000000] [WSREP] wsrep_notify_cmd is not defined, skipping notification.
2020-01-13T17:27:14.943719Z 0 [Note] [MY-011240] [Server] Plugin mysqlx reported: 'Using SSL configuration from MySQL Server'
2020-01-13T17:27:14.944219Z 0 [Note] [MY-011243] [Server] Plugin mysqlx reported: 'Using OpenSSL for TLS connections'
2020-01-13T17:27:14.944282Z 0 [Note] [MY-011332] [Server] Plugin mysqlx reported: 'IPv6 is available'
2020-01-13T17:27:14.949442Z 0 [Note] [MY-011323] [Server] Plugin mysqlx reported: 'X Plugin ready for connections. bind-address: '::' port: 10409'
2020-01-13T17:27:14.949476Z 0 [Note] [MY-011323] [Server] Plugin mysqlx reported: 'X Plugin ready for connections. socket: '/tmp/mtr/tmp/3/mysqlx.2.sock''
2020-01-13T17:27:14.949500Z 0 [System] [MY-011323] [Server] X Plugin ready for connections. Socket: '/tmp/mtr/tmp/3/mysqlx.2.sock' bind-address: '::' port: 10409
2020-01-13T17:27:17.286948Z 0 [Note] [MY-000000] [Server] WSREP: 2.0 (void): State transfer to 1.0 (void) complete.
2020-01-13T17:27:17.288635Z 0 [Note] [MY-000000] [Server] WSREP: Member 2.0 (void) synced with group.
2020-01-13T17:27:20.545484Z 0 [Note] [MY-000000] [Server] WSREP: 1.0 (void): State transfer from 2.0 (void) complete.
2020-01-13T17:27:20.546032Z 0 [Note] [MY-000000] [Server] WSREP: Member 1.0 (void) synced with group.
mysqld: galera/src/replicator_smm.cpp:3245: wsrep_status_t galera::ReplicatorSMM::finish_cert(galera::TrxHandleMaster*, const TrxHandleSlavePtr&): Assertion `ts->global_seqno() == cert_.position() + 1' failed.
17:27:21 UTC - mysqld got signal 6 ;
and
(gdb) p ts.px->global_seqno_
$1 = 4
(gdb) p cert_.position_
$2 = 2
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment