MySQL not starting

[Vs Nu]

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

 

[cPRex]

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:

InnoDB Corruption Repair Guide

Please note that cPanel, LLC only supports the cPanel-provided software and does not provide general system-administration services. While this guide is designed to help, it is always suggested th...

support.cpanel.net

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

 

[Vs Nu]

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:

InnoDB Corruption Repair Guide

Please note that cPanel, LLC only supports the cPanel-provided software and does not provide general system-administration services. While this guide is designed to help, it is always suggested th...

support.cpanel.net

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)

 

[cPRex]

Is MySQL up and running at the time you tried that dump?

 

[Vs Nu]

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

 

[cPRex]

So you were able to do the dump after moving the files?

 

[Vs Nu]

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]

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]

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.