Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- 2016-03-18 15:56:12 2904 [Note] /usr/sbin/mysqld: Normal shutdown
- 2016-03-18 15:56:12 2904 [Note] WSREP: Stop replication
- 2016-03-18 15:56:12 2904 [Note] WSREP: Closing send monitor...
- 2016-03-18 15:56:12 2904 [Note] WSREP: Closed send monitor.
- 2016-03-18 15:56:12 2904 [Note] WSREP: gcomm: terminating thread
- 2016-03-18 15:56:12 2904 [Note] WSREP: gcomm: joining thread
- 2016-03-18 15:56:12 2904 [Note] WSREP: gcomm: closing backend
- 2016-03-18 15:56:13 2904 [Note] WSREP: (503f2a17, 'tcp://0.0.0.0:4567') address 'tcp://10.1.0.7:4567' pointing to uuid 503f2a17 is blacklisted, skipping
- 2016-03-18 15:56:17 2904 [Note] WSREP: evs::proto(503f2a17, LEAVING, view_id(REG,000ecfeb,1148)) suspecting node: 43259ec8
- 2016-03-18 15:56:17 2904 [Note] WSREP: evs::proto(503f2a17, LEAVING, view_id(REG,000ecfeb,1148)) suspected node without join message, declaring inactive
- 2016-03-18 15:56:19 2904 [Note] WSREP: view(view_id(NON_PRIM,000ecfeb,1148) memb {
- 503f2a17,1
- } joined {
- } left {
- } partitioned {
- 000ecfeb,1
- 43259ec8,2
- 53db0fe7,2
- e148d044,1
- })
- 2016-03-18 15:56:19 2904 [Note] WSREP: view((empty))
- 2016-03-18 15:56:19 2904 [Note] WSREP: gcomm: closed
- 2016-03-18 15:56:19 2904 [Note] WSREP: New COMPONENT: primary = no, bootstrap = no, my_idx = 0, memb_num = 1
- 2016-03-18 15:56:19 2904 [Note] WSREP: Flow-control interval: [16, 16]
- 2016-03-18 15:56:19 2904 [Note] WSREP: Received NON-PRIMARY.
- 2016-03-18 15:56:19 2904 [Note] WSREP: Shifting SYNCED -> OPEN (TO: 81636269)
- 2016-03-18 15:56:19 2904 [Note] WSREP: Received self-leave message.
- 2016-03-18 15:56:19 2904 [Note] WSREP: Flow-control interval: [0, 0]
- 2016-03-18 15:56:19 2904 [Note] WSREP: Received SELF-LEAVE. Closing connection.
- 2016-03-18 15:56:19 2904 [Note] WSREP: Shifting OPEN -> CLOSED (TO: 81636269)
- 2016-03-18 15:56:19 2904 [Note] WSREP: New cluster view: global state: ee9fde7c-fe20-11e4-aa76-8beb5059c427:81636269, view# -1: non-Primary, number of nodes: 1, my index: 0, protocol version 3
- 2016-03-18 15:56:19 2904 [Note] WSREP: RECV thread exiting 0: Success
- 2016-03-18 15:56:19 2904 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification.
- 2016-03-18 15:56:19 2904 [Note] WSREP: New cluster view: global state: ee9fde7c-fe20-11e4-aa76-8beb5059c427:81636269, view# -1: non-Primary, number of nodes: 0, my index: -1, protocol version 3
- 2016-03-18 15:56:19 2904 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification.
- 2016-03-18 15:56:19 2904 [Note] WSREP: applier thread exiting (code:0)
- 2016-03-18 15:56:19 2904 [Note] WSREP: recv_thread() joined.
- 2016-03-18 15:56:19 2904 [Note] WSREP: Closing replication queue.
- 2016-03-18 15:56:19 2904 [Note] WSREP: Closing slave action queue.
- 2016-03-18 15:56:19 2904 [Note] WSREP: applier thread exiting (code:6)
- 2016-03-18 15:56:19 2904 [Note] WSREP: applier thread exiting (code:6)
- 2016-03-18 15:56:19 2904 [Note] WSREP: applier thread exiting (code:6)
- 2016-03-18 15:56:19 2904 [Note] WSREP: applier thread exiting (code:6)
- 2016-03-18 15:56:19 2904 [Note] WSREP: applier thread exiting (code:6)
- 2016-03-18 15:56:19 2904 [Note] WSREP: applier thread exiting (code:6)
- 2016-03-18 15:56:19 2904 [Note] WSREP: applier thread exiting (code:6)
- 2016-03-18 15:56:21 2904 [Note] WSREP: rollbacker thread exiting
- 2016-03-18 15:56:21 2904 [Note] Giving 0 client threads a chance to die gracefully
- 2016-03-18 15:56:21 2904 [Note] Event Scheduler: Purging the queue. 0 events
- 2016-03-18 15:56:21 2904 [Note] Shutting down slave threads
- 2016-03-18 15:56:21 2904 [Note] Forcefully disconnecting 0 remaining clients
- 2016-03-18 15:56:21 2904 [Note] WSREP: dtor state: CLOSED
- 2016-03-18 15:56:21 2904 [Note] WSREP: mon: entered 2759091 oooe fraction 0 oool fraction 0.000198979
- 2016-03-18 15:56:22 2904 [Note] WSREP: mon: entered 2759091 oooe fraction 0.21796 oool fraction 0.000198979
- 2016-03-18 15:56:22 2904 [Note] WSREP: mon: entered 2794859 oooe fraction 0 oool fraction 1.46698e-05
- 2016-03-18 15:56:22 2904 [Note] WSREP: cert index usage at exit 0
- 2016-03-18 15:56:22 2904 [Note] WSREP: cert trx map usage at exit 237
- 2016-03-18 15:56:22 2904 [Note] WSREP: deps set usage at exit 0
- 2016-03-18 15:56:22 2904 [Note] WSREP: avg deps dist 34.3691
- 2016-03-18 15:56:22 2904 [Note] WSREP: avg cert interval 1.83538
- 2016-03-18 15:56:22 2904 [Note] WSREP: cert index size 173
- 2016-03-18 15:56:22 2904 [Note] WSREP: Service thread queue flushed.
- 2016-03-18 15:56:22 2904 [Note] WSREP: wsdb trx map usage 0 conn query map usage 0
- 2016-03-18 15:56:22 2904 [Note] WSREP: MemPool(LocalTrxHandle): hit ratio: 0.99966, misses: 394, in use: 0, in pool: 394
- 2016-03-18 15:56:22 2904 [Note] WSREP: MemPool(SlaveTrxHandle): hit ratio: 0.999571, misses: 688, in use: 0, in pool: 688
- 2016-03-18 15:56:22 2904 [Note] WSREP: Shifting CLOSED -> DESTROYED (TO: 81636269)
- 2016-03-18 15:56:22 2904 [Note] WSREP: Flushing memory map to disk...
- 2016-03-18 15:56:22 2904 [Note] Binlog end
- 2016-03-18 15:56:22 2904 [Note] Shutting down plugin 'partition'
- 2016-03-18 15:56:22 2904 [Note] Shutting down plugin 'INNODB_CHANGED_PAGES'
- 2016-03-18 15:56:22 2904 [Note] Shutting down plugin 'INNODB_SYS_DATAFILES'
- 2016-03-18 15:56:22 2904 [Note] Shutting down plugin 'INNODB_SYS_TABLESPACES'
- 2016-03-18 15:56:22 2904 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN_COLS'
- 2016-03-18 15:56:22 2904 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN'
- 2016-03-18 15:56:22 2904 [Note] Shutting down plugin 'INNODB_SYS_FIELDS'
- 2016-03-18 15:56:22 2904 [Note] Shutting down plugin 'INNODB_SYS_COLUMNS'
- 2016-03-18 15:56:22 2904 [Note] Shutting down plugin 'INNODB_SYS_INDEXES'
- 2016-03-18 15:56:22 2904 [Note] Shutting down plugin 'INNODB_SYS_TABLESTATS'
- 2016-03-18 15:56:22 2904 [Note] Shutting down plugin 'INNODB_SYS_TABLES'
- 2016-03-18 15:56:22 2904 [Note] Shutting down plugin 'INNODB_FT_INDEX_TABLE'
- 2016-03-18 15:56:22 2904 [Note] Shutting down plugin 'INNODB_FT_INDEX_CACHE'
- 2016-03-18 15:56:22 2904 [Note] Shutting down plugin 'INNODB_FT_CONFIG'
- 2016-03-18 15:56:22 2904 [Note] Shutting down plugin 'INNODB_FT_BEING_DELETED'
- 2016-03-18 15:56:22 2904 [Note] Shutting down plugin 'INNODB_FT_DELETED'
- 2016-03-18 15:56:22 2904 [Note] Shutting down plugin 'INNODB_FT_DEFAULT_STOPWORD'
- 2016-03-18 15:56:22 2904 [Note] Shutting down plugin 'INNODB_METRICS'
- 2016-03-18 15:56:22 2904 [Note] Shutting down plugin 'INNODB_BUFFER_POOL_STATS'
- 2016-03-18 15:56:22 2904 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE_LRU'
- 2016-03-18 15:56:22 2904 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE'
- 2016-03-18 15:56:22 2904 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX_RESET'
- 2016-03-18 15:56:22 2904 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX'
- 2016-03-18 15:56:22 2904 [Note] Shutting down plugin 'INNODB_CMPMEM_RESET'
- 2016-03-18 15:56:22 2904 [Note] Shutting down plugin 'INNODB_CMPMEM'
- 2016-03-18 15:56:22 2904 [Note] Shutting down plugin 'INNODB_CMP_RESET'
- 2016-03-18 15:56:22 2904 [Note] Shutting down plugin 'INNODB_CMP'
- 2016-03-18 15:56:22 2904 [Note] Shutting down plugin 'INNODB_LOCK_WAITS'
- 2016-03-18 15:56:22 2904 [Note] Shutting down plugin 'INNODB_LOCKS'
- 2016-03-18 15:56:22 2904 [Note] Shutting down plugin 'INNODB_TRX'
- 2016-03-18 15:56:22 2904 [Note] Shutting down plugin 'XTRADB_RSEG'
- 2016-03-18 15:56:22 2904 [Note] Shutting down plugin 'XTRADB_INTERNAL_HASH_TABLES'
- 2016-03-18 15:56:22 2904 [Note] Shutting down plugin 'XTRADB_READ_VIEW'
- 2016-03-18 15:56:22 2904 [Note] Shutting down plugin 'InnoDB'
- 2016-03-18 15:56:22 2904 [Note] InnoDB: FTS optimize thread exiting.
- 2016-03-18 15:56:22 2904 [Note] InnoDB: Starting shutdown...
- 2016-03-18 15:56:23 2904 [Note] InnoDB: Shutdown completed; log sequence number 101002810118
- 2016-03-18 15:56:23 2904 [Note] Shutting down plugin 'BLACKHOLE'
- 2016-03-18 15:56:23 2904 [Note] Shutting down plugin 'ARCHIVE'
- 2016-03-18 15:56:23 2904 [Note] Shutting down plugin 'PERFORMANCE_SCHEMA'
- 2016-03-18 15:56:23 2904 [Note] Shutting down plugin 'MRG_MYISAM'
- 2016-03-18 15:56:23 2904 [Note] Shutting down plugin 'MyISAM'
- 2016-03-18 15:56:23 2904 [Note] Shutting down plugin 'MEMORY'
- 2016-03-18 15:56:23 2904 [Note] Shutting down plugin 'CSV'
- 2016-03-18 15:56:23 2904 [Note] Shutting down plugin 'sha256_password'
- 2016-03-18 15:56:23 2904 [Note] Shutting down plugin 'mysql_old_password'
- 2016-03-18 15:56:23 2904 [Note] Shutting down plugin 'mysql_native_password'
- 2016-03-18 15:56:23 2904 [Note] Shutting down plugin 'wsrep'
- 2016-03-18 15:56:23 2904 [Note] Shutting down plugin 'binlog'
- 2016-03-18 15:56:23 2904 [Note] /usr/sbin/mysqld: Shutdown complete
- 160318 15:56:24 mysqld_safe mysqld from pid file /run/mysqld/mysql.pid ended
- 160318 15:56:40 mysqld_safe Starting mysqld daemon with databases from /mnt/ssd/mysql
- 160318 15:56:40 mysqld_safe Skipping wsrep-recover for ee9fde7c-fe20-11e4-aa76-8beb5059c427:78871482 pair
- 160318 15:56:40 mysqld_safe Assigning ee9fde7c-fe20-11e4-aa76-8beb5059c427:78871482 to wsrep_start_position
- 2016-03-18 15:56:40 0 [Note] WSREP: wsrep_start_position var submitted: 'ee9fde7c-fe20-11e4-aa76-8beb5059c427:78871482'
- 2016-03-18 15:56:40 17547 [Note] WSREP: Read nil XID from storage engines, skipping position init
- 2016-03-18 15:56:40 17547 [Note] WSREP: wsrep_load(): loading provider library '/usr/lib64/libgalera_smm.so'
- 2016-03-18 15:56:40 17547 [Note] WSREP: wsrep_load(): Galera 3.9(r93aca2d) by Codership Oy <info@codership.com> loaded successfully.
- 2016-03-18 15:56:40 17547 [Note] WSREP: CRC-32C: using hardware acceleration.
- 2016-03-18 15:56:40 17547 [Note] WSREP: Found saved state: ee9fde7c-fe20-11e4-aa76-8beb5059c427:78871482
- 2016-03-18 15:56:41 17547 [Note] WSREP: Passing config to GCS: base_dir = /mnt/ssd/mysql/; base_host = 10.1.0.7; base_port = 4567; cert.log_conflicts = no; 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 = /mnt/ssd/mysql/; gcache.keep_pages_size = 0; gcache.mem_size = 0; gcache.name = /mnt/ssd/mysql//galera.cache; gcache.page_size = 128M; gcache.size = 128M; 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 = 1; gmcast.version = 0; pc.announce_timeout = PT3S; pc.checksum = false; pc.ignore_quorum = false; pc.ignore_sb = false; pc.
- 2016-03-18 15:56:41 17547 [Note] WSREP: Service thread queue flushed.
- 2016-03-18 15:56:41 17547 [Note] WSREP: Assign initial position for certification: 78871482, protocol version: -1
- 2016-03-18 15:56:41 17547 [Note] WSREP: wsrep_sst_grab()
- 2016-03-18 15:56:41 17547 [Note] WSREP: Start replication
- 2016-03-18 15:56:41 17547 [Note] WSREP: Setting initial position to ee9fde7c-fe20-11e4-aa76-8beb5059c427:78871482
- 2016-03-18 15:56:41 17547 [Note] WSREP: protonet asio version 0
- 2016-03-18 15:56:41 17547 [Note] WSREP: Using CRC-32C for message checksums.
- 2016-03-18 15:56:41 17547 [Note] WSREP: backend: asio
- 2016-03-18 15:56:41 17547 [Warning] WSREP: access file(/mnt/ssd/mysql//gvwstate.dat) failed(No such file or directory)
- 2016-03-18 15:56:41 17547 [Note] WSREP: restore pc from disk failed
- 2016-03-18 15:56:41 17547 [Note] WSREP: GMCast version 0
- 2016-03-18 15:56:41 17547 [Note] WSREP: (9f79f8cb, 'tcp://0.0.0.0:4567') listening at tcp://0.0.0.0:4567
- 2016-03-18 15:56:41 17547 [Note] WSREP: (9f79f8cb, 'tcp://0.0.0.0:4567') multicast: , ttl: 1
- 2016-03-18 15:56:41 17547 [Note] WSREP: EVS version 0
- 2016-03-18 15:56:41 17547 [Note] WSREP: gcomm: connecting to group 'pams-database', peer '10.1.0.5:,10.1.0.6:,10.1.0.7:,10.5.0.4:,10.5.0.5:'
- 2016-03-18 15:56:41 17547 [Warning] WSREP: (9f79f8cb, 'tcp://0.0.0.0:4567') address 'tcp://10.1.0.7:4567' points to own listening address, blacklisting
- 2016-03-18 15:56:41 17547 [Note] WSREP: (9f79f8cb, 'tcp://0.0.0.0:4567') address 'tcp://10.1.0.7:4567' pointing to uuid 9f79f8cb is blacklisted, skipping
- 2016-03-18 15:56:41 17547 [Note] WSREP: (9f79f8cb, 'tcp://0.0.0.0:4567') turning message relay requesting on, nonlive peers:
- 2016-03-18 15:56:41 17547 [Note] WSREP: (9f79f8cb, 'tcp://0.0.0.0:4567') address 'tcp://10.1.0.7:4567' pointing to uuid 9f79f8cb is blacklisted, skipping
- 2016-03-18 15:56:43 17547 [Note] WSREP: declaring 000ecfeb at tcp://10.1.0.6:4567 stable
- 2016-03-18 15:56:43 17547 [Note] WSREP: declaring 43259ec8 at tcp://10.5.0.5:4567 stable
- 2016-03-18 15:56:43 17547 [Note] WSREP: declaring 53db0fe7 at tcp://10.5.0.4:4567 stable
- 2016-03-18 15:56:43 17547 [Note] WSREP: declaring e148d044 at tcp://10.1.0.5:4567 stable
- 2016-03-18 15:56:44 17547 [Note] WSREP: view(view_id(NON_PRIM,000ecfeb,1152) memb {
- 000ecfeb,1
- 43259ec8,2
- 53db0fe7,2
- 9f79f8cb,1
- e148d044,1
- } joined {
- } left {
- } partitioned {
- 503f2a17,1
- })
- 2016-03-18 15:56:45 17547 [Note] WSREP: (9f79f8cb, 'tcp://0.0.0.0:4567') turning message relay requesting off
- 2016-03-18 15:57:11 17547 [ERROR] WSREP: failed to open gcomm backend connection: 110: failed to reach primary view: 110 (Connection timed out)
- at gcomm/src/pc.cpp:connect():162
- 2016-03-18 15:57:11 17547 [ERROR] WSREP: gcs/src/gcs_core.cpp:long int gcs_core_open(gcs_core_t*, const char*, const char*, bool)():206: Failed to open backend connection: -110 (Connection timed out)
- 2016-03-18 15:57:11 17547 [ERROR] WSREP: gcs/src/gcs.cpp:long int gcs_open(gcs_conn_t*, const char*, const char*, bool)():1379: Failed to open channel 'pams-database' at 'gcomm://10.1.0.5,10.1.0.6,10.1.0.7,10.5.0.4,10.5.0.5': -110 (Connection timed out)
- 2016-03-18 15:57:11 17547 [ERROR] WSREP: gcs connect failed: Connection timed out
- 2016-03-18 15:57:11 17547 [ERROR] WSREP: wsrep::connect() failed: 7
- 2016-03-18 15:57:11 17547 [ERROR] Aborting
- 2016-03-18 15:57:11 17547 [Note] WSREP: Service disconnected.
- 2016-03-18 15:57:12 17547 [Note] WSREP: Some threads may fail to exit.
- 2016-03-18 15:57:12 17547 [Note] Binlog end
- 2016-03-18 15:57:12 17547 [Note] /usr/sbin/mysqld: Shutdown complete
- 160318 15:57:12 mysqld_safe mysqld from pid file /run/mysqld/mysql.pid ended
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement