How to fix mysqld_safe WSREP: Failed to recover position: '
How to fix mysqld_safe WSREP: Failed to recover position: '
190809 01:45:06 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
190809 01:45:06 mysqld_safe WSREP: Running position recovery with --log_error='/var/lib/mysql/wsrep_recovery.347tZ8' --pid-file='/var/lib/mysql/galera92.dephub.go.id-recover.pid'
190809 1:45:06 [Note] /usr/sbin/mysqld (mysqld 10.0.35-MariaDB-wsrep) starting as process 6204 ...
190809 01:45:06 mysqld_safe WSREP: Failed to recover position: '190809 1:45:06 [Note] InnoDB: Using mutexes to ref count buffer pool pages
190809 1:45:06 [Note] InnoDB: The InnoDB memory heap is disabled
190809 1:45:06 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
190809 1:45:06 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier
190809 1:45:06 [Note] InnoDB: Compressed tables use zlib 1.2.7
190809 1:45:06 [Note] InnoDB: Using Linux native AIO
190809 1:45:06 [Note] InnoDB: Using CPU crc32 instructions
190809 1:45:06 [Note] InnoDB: Initializing buffer pool, size = 4.9G
190809 1:45:06 [Note] InnoDB: Completed initialization of buffer pool
190809 1:45:06 [Note] InnoDB: Highest supported file format is Barracuda.
190809 1:45:06 [Note] InnoDB: Starting crash recovery from checkpoint LSN=110759403544
Change working directory to mysql lib
[user@galera92 mysql]$ ls
aria_log.00000001 GRA_1_20868760.log GRA_2_64730161.log GRA_2_64730621.log mysql.sock wsrep_recovery.I8FMYd
aria_log_control GRA_1_20869248.log GRA_2_64730236.log grastate.dat performance_schema wsrep_recovery.mEM4p9
coba GRA_1_20869836.log GRA_2_64730386.log ibdata1 sample1_db wsrep_recovery.MV0LQ7
db_ticketing GRA_1_20870026.log GRA_2_64730399.log ib_logfile0 wsrep_recovery.347tZ8 wsrep_recovery.qwd9Wk
galera92.dephub.go.id.err GRA_1_6454701.log GRA_2_64730426.log ib_logfile1 wsrep_recovery.7Cdfct wsrep_recovery.vicLWO
galera.cache GRA_1_6454712.log GRA_2_64730488.log ipn_baru wsrep_recovery.acUKSM wsrep_recovery.y6t1Pu
GRA_1_20868365.log GRA_1_7096577.log GRA_2_64730508.log multi-master.info wsrep_recovery.bHvANe
GRA_1_20868526.log GRA_2_64729891.log GRA_2_64730516.log mysql wsrep_recovery.HYWqCL
[ecpa@galera92 mysql]$
Remove the cache file
[user@galera92 mysql]$ sudo rm -f /var/lib/mysql/galera.cache ib_*
[sudo] password for user:
[user@galera92 mysql]$
How to fix mysqld_safe WSREP: Failed to recover position: '
[user@galera92 mysql]$ sudo service mysql restart
ERROR! MariaDB server PID file could not be found!
Starting MariaDB.190809 01:52:32 mysqld_safe Logging to '/var/lib/mysql/galera92.dephub.go.id.err'.
190809 01:52:32 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
....SST in progress, setting sleep higher..........................................
Tidak ada komentar :
Posting Komentar