Kamis, 08 Agustus 2019

How to fix mysqld_safe WSREP: Failed to recover position: '

  Tidak ada komentar
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