Vs Nu

Well-Known Member
Jul 17, 2015
152
12
68
India
cPanel Access Level
Root Administrator
2022-05-06 16:25:11 0x7f728d7fa700 InnoDB: Assertion failure in file /builddir/build/BUILD/mariadb-10.3.34/storage/innobase/btr/btr0cur.cc line 313
InnoDB: Failing assertion: btr_page_get_next(latch_leaves.blocks[0]->frame) == page_get_page_no(page)
InnoDB: We intentionally generate a memory trap.
InnoDB: Submit a detailed bug report to System Dashboard - Jira
InnoDB: If you get repeated assertion failures or crashes, even
InnoDB: immediately after the mysqld startup, there may be
InnoDB: corruption in the InnoDB tablespace. Please refer to
InnoDB: InnoDB Recovery Modes
InnoDB: about forcing recovery.
220506 16:25:11 [ERROR] mysqld got signal 6 ;
This could be because you hit a bug. It is also possible that this binary
or one of the libraries it was linked against is corrupt, improperly built,
or misconfigured. This error can also be caused by malfunctioning hardware.

To report this bug, see MariaDB Community Bug Reporting

We will try our best to scrape up some info that will hopefully help
diagnose the problem, but since we have already crashed,
something is definitely wrong and this may fail.

When i try to use recovery mode 3 it was getting started

How to do the recovery ?

Even I'm unable to dump in recovery mode 6

mysqldump -AER > /root/recovery_dump.sql
mysqldump: Error 2013: Lost connection to MySQL server during query when dumping table `wpnm_options` at row: 374
 
Last edited by a moderator:

cPRex

Jurassic Moderator
Staff member
Oct 19, 2014
10,360
1,632
363
cPanel Access Level
Root Administrator
Hey there! I'm sorry to hear about this InnoDB issue. The best thing we can offer for that problem is our corruption repair guide here:


I'd recommend working through that as best you can, or restoring database backups to a previous point.
 

Vs Nu

Well-Known Member
Jul 17, 2015
152
12
68
India
cPanel Access Level
Root Administrator
Hey there! I'm sorry to hear about this InnoDB issue. The best thing we can offer for that problem is our corruption repair guide here:


I'd recommend working through that as best you can, or restoring database backups to a previous point.
I'm unable to dump

mysqldump --single-transaction -AER > dump.sql
mysqldump: Couldn't execute 'show create table `cost_content`': Table 'costethi_db.cost_content' doesn't exist in engine (1932)
 

Vs Nu

Well-Known Member
Jul 17, 2015
152
12
68
India
cPanel Access Level
Root Administrator
Is MySQL up and running at the time you tried that dump?
Yes running in Mode 4 Recovery,Dump created up to 4GB then it got stopped

I had moved that database data directory out of /var/lib/mysql and run the dump again it goes fine
 

Vs Nu

Well-Known Member
Jul 17, 2015
152
12
68
India
cPanel Access Level
Root Administrator
So you were able to do the dump after moving the files?
Yes but the same thing happen after dumping of 16GB and then it got stopped

due to this i need to start it again from first after moving the file

Is there anyway easier ?
 

cPRex

Jurassic Moderator
Staff member
Oct 19, 2014
10,360
1,632
363
cPanel Access Level
Root Administrator
cPanel isn't able to provide assistance with InnoDB corruption, as that often needs to be handled by MySQL administrators that are familiar with fixing those issues. If not, you run the risk of data loss.

If the steps in that guide I provided aren't working well, it's likely time to call in some outside help.
 

ffeingol

Well-Known Member
PartnerNOC
Nov 9, 2001
713
280
363
cPanel Access Level
DataCenter Provider
Try your mysqldump with -f. That should "force" it to continue even if there are errors. You're obviously going to be missing things, but better than having do the mysqldump over and over.