Google Cloud (Bitnami), MySQL database has crashed and crash recovery says tablespace not found
$25-50 USD / hour
Κλειστή
Αναρτήθηκε πάνω από 6 χρόνια πριν
$25-50 USD / hour
First of all, Please be very specific about what you will be doing, as this needs to be done via teamviewer.
I have one of my website hosted on Google Cloud and used bitnami wordpress package. 2 days ago i rebooted server and it started giving error of Database connection. I have checked by SSH and i realized that MySQL is not running, i tried everything to stop, restart, reboot etc but it didn't fixed the issue.
I have seen [login to view URL] and i realized problem is with my database as it crashed and now table space is not found on specific files.
Below is log from [login to view URL]
[Note] InnoDB: Doing recovery: scanned up to log sequence number 5356268032
[Note] InnoDB: Doing recovery: scanned up to log sequence number 5356723385
[Note] InnoDB: Database was not shutdown normally!
[Note] InnoDB: Starting crash recovery.
[ERROR] InnoDB: Tablespace 158 was not found at ./bitnami_wordpress/wp_wfhits.ibd.
[ERROR] InnoDB: Set innodb_force_recovery=1 to ignore this and to permanently lose all changes to the tablespace.
[ERROR] InnoDB: Tablespace 54 was not found at ./bitnami_wordpress/wp_options.ibd.
[ERROR] InnoDB: Cannot continue operation.
Help will be much appreciated, Looking for someone having strong grip on Cloud services for long term relationship!