2020-04-01 6:21:35 0 [Note] WSREP: Loading provider /usr/lib64/galera/libgalera_smm.so initial position: 00000000-0000-0000-0000-000000000000:-1
|
wsrep loader: [INFO] wsrep_load(): loading provider library '/usr/lib64/galera/libgalera_smm.so'
|
wsrep loader: [INFO] wsrep_load(): Galera 26.4.4(r4599) by Codership Oy <info@codership.com> loaded successfully.
|
2020-04-01 6:21:35 0 [Note] WSREP: CRC-32C: using hardware acceleration.
|
2020-04-01 6:21:35 0 [Note] WSREP: Found saved state: 312fcda7-73de-11ea-9c54-ee110f5fad29:2, safe_to_bootstrap: 1
|
2020-04-01 6:21:35 0 [Note] WSREP: GCache DEBUG: opened preamble:
|
Version: 2
|
UUID: 312fcda7-73de-11ea-9c54-ee110f5fad29
|
Seqno: 2 - 2
|
Offset: 1280
|
Synced: 1
|
2020-04-01 6:21:35 0 [Note] WSREP: Recovering GCache ring buffer: version: 2, UUID: 312fcda7-73de-11ea-9c54-ee110f5fad29, offset: 1280
|
2020-04-01 6:21:35 0 [Note] WSREP: GCache::RingBuffer initial scan... 0.0% ( 0/134217752 bytes) complete.
|
2020-04-01 6:21:35 0 [Note] WSREP: GCache::RingBuffer initial scan...100.0% (134217752/134217752 bytes) complete.
|
2020-04-01 6:21:35 0 [Note] WSREP: Recovering GCache ring buffer: found gapless sequence 2-2
|
2020-04-01 6:21:35 0 [Note] WSREP: GCache::RingBuffer unused buffers scan... 0.0% ( 0/176 bytes) complete.
|
2020-04-01 6:21:35 0 [Note] WSREP: GCache::RingBuffer unused buffers scan...100.0% (176/176 bytes) complete.
|
2020-04-01 6:21:35 0 [Note] WSREP: GCache DEBUG: RingBuffer::recover(): found 0/1 locked buffers
|
2020-04-01 6:21:35 0 [Note] WSREP: GCache DEBUG: RingBuffer::recover(): used space: 176/134217728
|
2020-04-01 6:21:35 0 [Note] WSREP: Passing config to GCS: base_dir = /var/lib/mysql/; base_host = 1.1.1.1; base_port = 4567; cert.log_conflicts = no; cert.optimistic_pa = yes; debug = no; evs.auto_evict = 0; evs.delay_margin = PT1S; evs.delayed_keep_period = PT30S; evs.inactive_check_period = PT0.5S; evs.inactive_timeout = PT15S; evs.join_retrans_period = PT1S; evs.max_install_timeouts = 3; evs.send_window = 4; evs.stats_report_period = PT1M; evs.suspect_timeout = PT5S; evs.user_send_window = 2; evs.view_forget_timeout = PT24H; gcache.dir = /var/lib/mysql/; gcache.keep_pages_size = 0; gcache.mem_size = 0; gcache.name = galera.cache; gcache.page_size = 128M; gcache.recover = yes; gcache.size = 128M; gcomm.thread_prio = ; gcs.fc_debug = 0; gcs.fc_factor = 1.0; gcs.fc_limit = 16; gcs.fc_master_slave = no; gcs.max_packet_size = 64500; gcs.max_throttle = 0.25; gcs.recv_q_hard_limit = 9223372036854775807; gcs.recv_q_soft_limit = 0.25; gcs.sync_donor = no; gmcast.segment = 0; gmcast.version = 0; pc.announce_timeout = PT3S; pc.checksum
|
2020-04-01 6:21:35 0 [Note] WSREP: Service thread queue flushed.
|
2020-04-01 6:21:35 0 [Note] WSREP: ####### Assign initial position for certification: 312fcda7-73de-11ea-9c54-ee110f5fad29:2, protocol version: -1
|
2020-04-01 6:21:35 0 [Note] WSREP: Start replication
|
2020-04-01 6:21:35 0 [Note] WSREP: Connecting with bootstrap option: 1
|
2020-04-01 6:21:35 0 [Note] WSREP: Setting GCS initial position to 312fcda7-73de-11ea-9c54-ee110f5fad29:2
|
2020-04-01 6:21:35 0 [Note] WSREP: protonet asio version 0
|
2020-04-01 6:21:35 0 [Note] WSREP: Using CRC-32C for message checksums.
|
2020-04-01 6:21:35 0 [Note] WSREP: backend: asio
|
2020-04-01 6:21:35 0 [Note] WSREP: gcomm thread scheduling priority set to other:0
|
2020-04-01 6:21:35 0 [Warning] WSREP: access file(/var/lib/mysql//gvwstate.dat) failed(No such file or directory)
|
2020-04-01 6:21:35 0 [Note] WSREP: restore pc from disk failed
|
2020-04-01 6:21:35 0 [Note] WSREP: GMCast version 0
|
2020-04-01 6:21:35 0 [Note] WSREP: (09858f60-bf8d, 'tcp://0.0.0.0:4567') listening at tcp://0.0.0.0:4567
|
2020-04-01 6:21:35 0 [Note] WSREP: (09858f60-bf8d, 'tcp://0.0.0.0:4567') multicast: , ttl: 1
|
2020-04-01 6:21:35 0 [Note] WSREP: EVS version 1
|
2020-04-01 6:21:35 0 [Note] WSREP: gcomm: bootstrapping new group 'Pro'
|
2020-04-01 6:21:35 0 [Note] WSREP: start_prim is enabled, turn off pc_recovery
|
2020-04-01 6:21:35 0 [Note] WSREP: EVS version upgrade 0 -> 1
|
2020-04-01 6:21:35 0 [Note] WSREP: PC protocol upgrade 0 -> 1
|
2020-04-01 6:21:35 0 [Note] WSREP: Node 09858f60-bf8d state prim
|
2020-04-01 6:21:35 0 [Note] WSREP: view(view_id(PRIM,09858f60-bf8d,1) memb {
|
09858f60-bf8d,0
|
} joined {
|
} left {
|
} partitioned {
|
})
|
2020-04-01 6:21:35 0 [Note] WSREP: save pc into disk
|
2020-04-01 6:21:35 0 [Note] WSREP: discarding pending addr without UUID: tcp://1.1.1.1:4567
|
2020-04-01 6:21:35 0 [Note] WSREP: discarding pending addr proto entry 0x55c70572d900
|
2020-04-01 6:21:35 0 [Note] WSREP: discarding pending addr without UUID: tcp://2.2.2.2:4567
|
2020-04-01 6:21:35 0 [Note] WSREP: discarding pending addr proto entry 0x55c705735e00
|
2020-04-01 6:21:35 0 [Note] WSREP: discarding pending addr without UUID: tcp://3.3.3.3:4567
|
2020-04-01 6:21:35 0 [Note] WSREP: discarding pending addr proto entry 0x55c70573e370
|
2020-04-01 6:21:35 0 [Note] WSREP: gcomm: connected
|
2020-04-01 6:21:35 0 [Note] WSREP: Changing maximum packet size to 64500, resulting msg size: 32636
|
2020-04-01 6:21:35 0 [Note] WSREP: Shifting CLOSED -> OPEN (TO: 0)
|
2020-04-01 6:21:35 0 [Note] WSREP: Opened channel 'Pro'
|
2020-04-01 6:21:35 0 [Note] WSREP: New COMPONENT: primary = yes, bootstrap = no, my_idx = 0, memb_num = 1
|
2020-04-01 6:21:35 0 [Note] WSREP: STATE_EXCHANGE: sent state UUID: 0985f60b-73e1-11ea-8c36-3773663e5842
|
2020-04-01 6:21:35 0 [Note] WSREP: STATE EXCHANGE: sent state msg: 0985f60b-73e1-11ea-8c36-3773663e5842
|
2020-04-01 6:21:35 0 [Note] WSREP: STATE EXCHANGE: got state msg: 0985f60b-73e1-11ea-8c36-3773663e5842 from 0 (vm1-cluster-litespeed-pro)
|
2020-04-01 6:21:35 2 [Note] WSREP: Starting rollbacker thread 2
|
2020-04-01 6:21:35 0 [Note] WSREP: Quorum results:
|
version = 6,
|
component = PRIMARY,
|
conf_id = 0,
|
members = 1/1 (joined/total),
|
act_id = 2,
|
last_appl. = 2,
|
protocols = 2/10/4 (gcs/repl/appl),
|
vote policy= 0,
|
group UUID = 312fcda7-73de-11ea-9c54-ee110f5fad29
|
2020-04-01 6:21:35 1 [Note] WSREP: Starting applier thread 1
|
2020-04-01 6:21:35 0 [Note] WSREP: Flow-control interval: [16, 16]
|
2020-04-01 6:21:35 0 [Note] WSREP: Restored state OPEN -> JOINED (3)
|
2020-04-01 6:21:35 0 [Note] WSREP: Member 0.0 (vm1-cluster-litespeed-pro) synced with group.
|
2020-04-01 6:21:35 0 [Note] WSREP: Shifting JOINED -> SYNCED (TO: 3)
|
2020-04-01 6:21:35 1 [Note] WSREP: ####### processing CC 3, local, ordered
|
2020-04-01 6:21:35 1 [Note] WSREP: Process first view: 312fcda7-73de-11ea-9c54-ee110f5fad29 my uuid: 09858f60-73e1-11ea-bf8d-63939b145668
|
2020-04-01 6:21:35 1 [Note] WSREP: Server vm1-cluster-litespeed-pro connected to cluster at position 312fcda7-73de-11ea-9c54-ee110f5fad29:3 with ID 09858f60-73e1-11ea-bf8d-63939b145668
|
2020-04-01 6:21:35 1 [Note] WSREP: Server status change disconnected -> connected
|
2020-04-01 6:21:35 1 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification.
|
2020-04-01 6:21:35 1 [Note] WSREP: ####### My UUID: 09858f60-73e1-11ea-bf8d-63939b145668
|
2020-04-01 6:21:35 1 [Note] WSREP: Cert index reset to 00000000-0000-0000-0000-000000000000:-1 (proto: 10), state transfer needed: no
|
2020-04-01 6:21:35 0 [Note] WSREP: Service thread queue flushed.
|
2020-04-01 6:21:35 1 [Note] WSREP: ####### Assign initial position for certification: 00000000-0000-0000-0000-000000000000:-1, protocol version: -1
|
2020-04-01 6:21:35 1 [Note] WSREP: REPL Protocols: 10 (5)
|
2020-04-01 6:21:35 1 [Note] WSREP: ####### Adjusting cert position: -1 -> 3
|
2020-04-01 6:21:35 0 [Note] WSREP: Service thread queue flushed.
|
2020-04-01 6:21:35 1 [Note] WSREP: ================================================
|
View:
|
id: 312fcda7-73de-11ea-9c54-ee110f5fad29: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(1):
|
0: 09858f60-73e1-11ea-bf8d-63939b145668, vm1-cluster-litespeed-pro
|
=================================================
|
2020-04-01 6:21:35 1 [Note] WSREP: Server status change connected -> joiner
|
2020-04-01 6:21:35 1 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification.
|
2020-04-01 6:21:35 1 [Note] WSREP: Server status change joiner -> initializing
|
2020-04-01 6:21:35 1 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification.
|
2020-04-01 6:21:35 0 [Note] InnoDB: Using Linux native AIO
|
2020-04-01 6:21:35 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
|
2020-04-01 6:21:35 0 [Note] InnoDB: Uses event mutexes
|
2020-04-01 6:21:35 0 [Note] InnoDB: Compressed tables use zlib 1.2.7
|
2020-04-01 6:21:35 0 [Note] InnoDB: Number of pools: 1
|
2020-04-01 6:21:35 0 [Note] InnoDB: Using SSE2 crc32 instructions
|
2020-04-01 6:21:35 0 [Note] mysqld: O_TMPFILE is not supported on /var/tmpfs/mysql (disabling future attempts)
|
2020-04-01 6:21:35 0 [Note] InnoDB: Initializing buffer pool, total size = 240G, instances = 16, chunk size = 128M
|
2020-04-01 6:21:47 0 [Note] InnoDB: Completed initialization of buffer pool
|
2020-04-01 6:21:50 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority().
|
2020-04-01 6:21:57 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
|
2020-04-01 6:21:57 0 [Note] InnoDB: Creating shared tablespace for temporary tables
|
2020-04-01 6:21:57 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
|
2020-04-01 6:21:57 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB.
|
2020-04-01 6:21:57 0 [Note] InnoDB: Waiting for purge to start
|
2020-04-01 6:21:57 0 [Note] InnoDB: 10.4.13 started; log sequence number 80877; transaction id 63
|
2020-04-01 6:21:57 0 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool
|
2020-04-01 6:21:57 0 [Note] Plugin 'FEEDBACK' is disabled.
|
2020-04-01 6:21:57 0 [Note] InnoDB: Buffer pool(s) load completed at 200401 6:21:57
|
2020-04-01 6:21:57 0 [Note] Server socket created on IP: '0.0.0.0'.
|
2020-04-01 6:21:57 0 [Warning] 'user' entry '@vm1-cluster-litespeed-pro' ignored in --skip-name-resolve mode.
|
2020-04-01 6:21:57 0 [Warning] 'proxies_priv' entry '@% root@vm1-cluster-litespeed-pro' ignored in --skip-name-resolve mode.
|
2020-04-01 6:21:57 0 [Note] WSREP: wsrep_init_schema_and_SR (nil)
|
2020-04-01 6:21:57 0 [Note] WSREP: Server initialized
|
2020-04-01 6:21:57 0 [Note] WSREP: Server status change initializing -> initialized
|
2020-04-01 6:21:57 0 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification.
|
2020-04-01 6:21:57 1 [Note] WSREP: Bootstrapping a new cluster, setting initial position to 00000000-0000-0000-0000-000000000000:-1
|
2020-04-01 6:21:57 0 [Note] Reading of all Master_info entries succeeded
|
2020-04-01 6:21:57 0 [Note] Added new Master_info '' to hash table
|
2020-04-01 6:21:57 0 [Note] /usr/sbin/mysqld: ready for connections.
|
Version: '10.4.13-MariaDB-log' socket: '/var/lib/mysql/mysql.sock' port: 3306 Source distribution
|
2020-04-01 6:21:57 10 [Note] WSREP: Recovered cluster id 312fcda7-73de-11ea-9c54-ee110f5fad29
|
2020-04-01 6:21:57 1 [Note] WSREP: Server status change initialized -> joined
|
2020-04-01 6:21:57 1 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification.
|
2020-04-01 6:21:57 1 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification.
|
2020-04-01 6:21:57 1 [Note] WSREP: Lowest cert indnex boundary for CC from group: 3
|
2020-04-01 6:21:57 1 [Note] WSREP: Min available from gcache for CC from group: 2
|
2020-04-01 6:21:57 1 [Note] WSREP: Server vm1-cluster-litespeed-pro synced with group
|
2020-04-01 6:21:57 1 [Note] WSREP: Server status change joined -> synced
|
2020-04-01 6:21:57 1 [Note] WSREP: Synchronized with group, ready for connections
|
2020-04-01 6:21:57 1 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification.
|
2020-04-01 6:23:05 0 [Note] /usr/sbin/mysqld (initiated by: unknown): Normal shutdown
|
2020-04-01 6:23:05 0 [Note] WSREP: Shutdown replication
|
2020-04-01 6:23:05 0 [Note] WSREP: Server status change synced -> disconnecting
|
2020-04-01 6:23:05 0 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification.
|
2020-04-01 6:23:05 0 [Note] WSREP: Closing send monitor...
|
2020-04-01 6:23:05 0 [Note] WSREP: Closed send monitor.
|
2020-04-01 6:23:05 0 [Note] WSREP: gcomm: terminating thread
|
2020-04-01 6:23:05 0 [Note] WSREP: gcomm: joining thread
|
2020-04-01 6:23:05 0 [Note] WSREP: gcomm: closing backend
|
2020-04-01 6:23:05 0 [Note] WSREP: PC protocol downgrade 1 -> 0
|
2020-04-01 6:23:05 0 [Note] WSREP: view((empty))
|
2020-04-01 6:23:05 0 [Note] WSREP: gcomm: closed
|
2020-04-01 6:23:05 0 [Note] WSREP: New SELF-LEAVE.
|
2020-04-01 6:23:05 0 [Note] WSREP: Flow-control interval: [0, 0]
|
2020-04-01 6:23:05 0 [Note] WSREP: Received SELF-LEAVE. Closing connection.
|
2020-04-01 6:23:05 0 [Note] WSREP: Shifting SYNCED -> CLOSED (TO: 3)
|
2020-04-01 6:23:05 0 [Note] WSREP: RECV thread exiting 0: Success
|
2020-04-01 6:23:05 0 [Note] WSREP: recv_thread() joined.
|
2020-04-01 6:23:05 0 [Note] WSREP: Closing replication queue.
|
2020-04-01 6:23:05 0 [Note] WSREP: Closing slave action queue.
|
2020-04-01 6:23:05 1 [Note] WSREP: ================================================
|
View:
|
id: 312fcda7-73de-11ea-9c54-ee110f5fad29:-1
|
status: non-primary
|
protocol_version: 4
|
capabilities: MULTI-MASTER, CERTIFICATION, PARALLEL_APPLYING, REPLAY, ISOLATION, PAUSE, CAUSAL_READ, INCREMENTAL_WS, UNORDERED, PREORDERED, STREAMING, NBO
|
final: yes
|
own_index: -1
|
members(0):
|
=================================================
|
2020-04-01 6:23:05 1 [Note] WSREP: Non-primary view
|
2020-04-01 6:23:05 1 [Note] WSREP: Server status change disconnecting -> disconnected
|
2020-04-01 6:23:05 1 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification.
|
2020-04-01 6:23:05 1 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification.
|
2020-04-01 6:23:05 1 [Note] WSREP: Applier thread exiting ret: 0 thd: 1
|
2020-04-01 6:23:05 1 [Warning] Aborted connection 1 to db: 'unconnected' user: 'unauthenticated' host: '' (This connection closed normally without authentication)
|
2020-04-01 6:23:05 2 [Note] WSREP: rollbacker thread exiting 2
|
2020-04-01 6:23:05 2 [Warning] Aborted connection 2 to db: 'unconnected' user: 'unauthenticated' host: '' (This connection closed normally without authentication)
|
2020-04-01 6:23:05 0 [Note] Event Scheduler: Purging the queue. 0 events
|
2020-04-01 6:23:05 0 [Note] InnoDB: FTS optimize thread exiting.
|
2020-04-01 6:23:05 0 [Note] WSREP: dtor state: CLOSED
|
2020-04-01 6:23:05 0 [Note] WSREP: MemPool(TrxHandleSlave): hit ratio: 0, misses: 0, in use: 0, in pool: 0
|
2020-04-01 6:23:05 0 [Note] WSREP: apply mon: entered 0
|
2020-04-01 6:23:05 0 [Note] WSREP: apply mon: entered 0
|
2020-04-01 6:23:05 0 [Note] WSREP: mon: entered 3 oooe fraction 0 oool fraction 0
|
2020-04-01 6:23:05 0 [Note] WSREP: cert index usage at exit 0
|
2020-04-01 6:23:05 0 [Note] WSREP: cert trx map usage at exit 0
|
2020-04-01 6:23:05 0 [Note] WSREP: deps set usage at exit 0
|
2020-04-01 6:23:05 0 [Note] WSREP: avg deps dist 0
|
2020-04-01 6:23:05 0 [Note] WSREP: avg cert interval 0
|
2020-04-01 6:23:05 0 [Note] WSREP: cert index size 0
|
2020-04-01 6:23:05 0 [Note] WSREP: Service thread queue flushed.
|
2020-04-01 6:23:05 0 [Note] WSREP: wsdb trx map usage 0 conn query map usage 0
|
2020-04-01 6:23:05 0 [Note] WSREP: MemPool(LocalTrxHandle): hit ratio: 0, misses: 0, in use: 0, in pool: 0
|
2020-04-01 6:23:05 0 [Note] WSREP: Shifting CLOSED -> DESTROYED (TO: 3)
|
2020-04-01 6:23:05 0 [Note] WSREP: Flushing memory map to disk...
|
2020-04-01 6:23:05 0 [Note] InnoDB: Starting shutdown...
|
2020-04-01 6:23:05 0 [Note] InnoDB: Dumping buffer pool(s) to /var/lib/mysql/ib_buffer_pool
|
2020-04-01 6:23:05 0 [Note] InnoDB: Buffer pool(s) dump completed at 200401 6:23:05
|
2020-04-01 6:23:13 0 [Note] InnoDB: Shutdown completed; log sequence number 86882; transaction id 78
|
2020-04-01 6:23:13 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
|
2020-04-01 6:23:13 0 [Note] /usr/sbin/mysqld: Shutdown complete
|
|