Often, if your scheduled back is failing, a reboot will fix it. If it is not possible to reboot the OCI DWH server, these commands might help.
1) If you can schedule a reboot of the OCI DWH server, do so. Does the backup work now?
2) Connect to the DWH Server. Make sure nobody else is accessing the server at backup time. Release the locks with
MYSQL> unlock tables;
Have a look if you have locked tables,
MYSQL> show open tables where in_use>0;
See a list of the current processes (one of them might lock tables.)
MYSQL> show processlist;
If nothing special is running, it looks like:
| Id | User | Host | Command | Time | Info |
-------------------------------------------------
| 5 | event_scheduler | localhost | Daemon | 100 | NULL |
| 9 | root | localhost | Query | 0 | show processlist |
Kill the processes which are locking the tables (nobody but you is supposed to do something right now.)
MYSQL> kill [process_id];
Does the backup work now?
3) Log a NetApp Support call.
Comments
Post a Comment