Problem
InnoDB: Failing assertion: purge_sys->purge_trx_no <= purge_sys->rseg->last_trx_no
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
| ## Enter MySQL
cd /root
## Stop MySQL
service mysql stop
## Add configuration
vim /etc/mysql/my.cnf
[mysqld]
innodb_force_recovery = 4
## Restart MySQL
service mysql restart
## Dump MySQL Data
mysqldump -u root -p -A > dump.sql
## Check which table is InnoDB
mysql -uroot -p
SELECT table_schema, table_name
FROM INFORMATION_SCHEMA.TABLES
WHERE engine = 'innodb';
## Stop the MySQL again
service mysql stop
## Backup MySQL lib
cp -Rf /var/lib/mysql /var/lib/mysql.bak
## Drop the ib file
rm /var/lib/mysql/ib*
## Remove configuration
vim /etc/mysql/my.cnf
[mysqld]
# innodb_force_recovery = 4
## Restart MySQL again
service mysql restart
## Restore the MySQL Data
mysql -uroot -p < dump.sql
## Try to restart MySQL ensure it is ok
service mysql restart
|
Reference
