MySQL Forums
Forum List  »  Newbie

Need help to recover a db thats crashing both in operation and recovery
Posted by: SpiderUnder UrBed
Date: March 22, 2025 12:16AM

my website was running fine.. until it crashed with this error, looked into the mysql docs into recovery, i need a dump, and uhh, unfortunately my dump is crashing too
```
bash-5.1# mysqld --defaults-file=mysqld.cnf -u root --all-databases > all_databases.sql
2025-03-21T00:37:58.748306Z 0 [System] [MY-015015] [Server] MySQL Server - start.
2025-03-21T00:37:59.272062Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 9.2.0) starting as process 81
2025-03-21T00:37:59.291029Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.
2025-03-21T00:38:05.625657Z 1 [System] [MY-013577] [InnoDB] InnoDB initialization has ended.
2025-03-21T00:38:06.171141Z 1 [ERROR] [MY-013178] [Server] Execution of server-side SQL statement 'DROP SCHEMA IF EXISTS dd_upgrade_targets_90200' failed with error code = 1836, error message = 'Running in read-only mode'.
2025-03-21T00:38:06.173126Z 0 [ERROR] [MY-010020] [Server] Data Dictionary initialization failed.
2025-03-21T00:38:06.173265Z 0 [ERROR] [MY-010119] [Server] Aborting
2025-03-21T00:38:07.638325Z 0 [System] [MY-010910] [Server] /usr/sbin/mysqld: Shutdown complete (mysqld 9.2.0) MySQL Community Server - GPL.
2025-03-21T00:38:07.638426Z 0 [System] [MY-015016] [Server] MySQL Server - end.
bash-5.1#
```
SQL statement 'DROP SCHEMA IF EXISTS dd_upgrade_targets_90200' is what bricked my db, and is whats bricking my recovery. I know what to do after I get the dump, i did the research and know a recovery tool, but i dont see anything on if mysql is crashing during the dump (i am in innodb recovery mode set to 1)```
Here is my k8s config but i doubt its relevent:
https://pastebin.com/Hs9hZiBg
Here is the raw error from when i start the server:
https://pastebin.com/Hj2fcWix
and i am using the default CNF file.

Options: ReplyQuote


Subject
Written By
Posted
Need help to recover a db thats crashing both in operation and recovery
March 22, 2025 12:16AM


Sorry, only registered users may post in this forum.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.