Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- ocf ra log:
- May 4 10:11:35 n2 ocf-mysql-wss: INFO: p_mysql: mysql_start(): Starting MySQL
- mysql log:
- 160504 10:11:36 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
- 160504 10:11:39 [Note] WSREP: Waiting for SST to complete.
- 160504 10:12:04 [Note] WSREP: Requesting state transfer: success after 26 tries, donor: 0
- WSREP_SST: [INFO] NOTE: Joiner-Recv-gtid took 25 seconds (20160504 10:12:04.984)
- WSREP_SST: [INFO] Proceeding with SST (20160504 10:12:04.988)
- WSREP_SST: [INFO] Cleaning the existing datadir and innodb-data/log directories (20160504 10:12:04.989)
- removed '/var/lib/mysql/ib_logfile0'
- removed '/var/lib/mysql/ib_logfile1'
- removed '/var/lib/mysql/ibdata1'
- WSREP_SST: [INFO] Waiting for SST streaming to complete! (20160504 10:12:05.030)
- ocf ra log:
- May 4 10:12:05 n2 ocf-mysql-wss: INFO: p_mysql: check_if_sst(): SST is in progress
- May 4 10:12:05 n2 ocf-mysql-wss: INFO: p_mysql: mysql_start(): MySQL started
- May 4 10:12:06 n2 crmd[154]: notice: process_lrm_event: Operation p_mysql_start_0: ok (node=n2, call=15, rc=0, cib-update=26, confirmed=true)
- (a broken logic, it fails to detect an SST without a pidfile created, restarts mysql and races to the SST in progress)
- May 4 10:12:12 n2 ocf-mysql-wss: ERROR: p_mysql: mysql_status(): MySQL is not running
- May 4 10:12:12 n2 ocf-mysql-wss: INFO: p_mysql: check_if_sst(): SST is in progress
- May 4 10:12:12 n2 ocf-mysql-wss: WARNING: p_mysql: mysql_monitor(): found and purged a stale sst_in_progress file
- May 4 10:12:12 n2 crmd[154]: notice: process_lrm_event: Operation p_mysql_monitor_60000: not running (node=n2, call=16, rc=7, cib-update=27, confirmed=false)
- May 4 10:12:12 n2 ocf-mysql-wss: INFO: p_mysql: mysql_stop(): MySQL is not running
- May 4 10:12:12 n2 crmd[154]: notice: process_lrm_event: Operation p_mysql_stop_0: ok (node=n2, call=18, rc=0, cib-update=28, confirmed=true)
- May 4 10:12:29 n2 ocf-mysql-wss: INFO: p_mysql: mysql_start(): Starting MySQL
- mysql log (sst's in progress since 10:11:36):
- 160504 10:12:29 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
- 160504 10:12:31 [ERROR] WSREP: gcs connect failed: Address already in use
- 160504 10:12:31 [ERROR] Aborting
- 160504 10:12:32 [Note] /usr/sbin/mysqld: Shutdown complete
- (a racing one continues and fails as well)
- WSREP_SST: [INFO] Evaluating innobackupex --defaults-file=/etc/mysql/my.cnf --defaults-group=mysqld --no-version-check --move-back --force-non-empty-directories ${DATA} &>${DATA}/innobackup.move.log (20160504 10:12:37.446)
- WSREP_SST: [ERROR] Cleanup after exit with status:1 (20160504 10:12:37.450)
- 160504 10:12:37 [ERROR] WSREP: Process completed with error: wsrep_sst_xtrabackup-v2 --role 'joiner' --address '10.10.10.3' --datadir '/var/lib/mysql/' --defaults-file '/etc/mysql/my.cnf' --defaults-group-suffix '' --parent '2437' --binlog '/var/lib/mysql/mysql-bin' : 1 (Operation not permitted)
- 160504 10:12:37 [ERROR] WSREP: Failed to read uuid:seqno from joiner script.
- 160504 10:12:37 [ERROR] WSREP: SST failed: 1 (Operation not permitted)
- 160504 10:12:37 [ERROR] Aborting
- ...because of the /var/lib/mysql/.sst/innobackup.move.log:
- 160504 10:12:37 innobackupex: Starting the move-back operation
- IMPORTANT: Please check that the move-back run completes successfully.
- At the end of a successful move-back run innobackupex
- prints "completed OK!".
- innobackupex version 2.3.4 based on MySQL server 5.6.24 Linux (x86_64) (revision id: e80c779)
- Error: Move file ib_logfile0 to /var/lib/mysql/ib_logfile0 failed: Destination file exists
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement