Bench restore hangs without any activity. Debug possible?

1

Tried to restore a 7gb database.sql.tz and the bench restore hangs without any outcome

erpnext 13.0.0-beta.14
frappe 13.0.0-beta.12
bench --version = 5.0.0

Is there a way to debug what and where does bench stop?

2

I’m not exactly sure, but this is worth a try considering the size of the db -

1 Like
3

Thank you. @sahilk25 guided as well on the same and it worked.

The database was very large, then after clearing all the Lab Test workflow email queue, it reduced down to 4GB and then was possible to restore it using the source command.

However, it seems that once the bench restore stops due to large database size, it’s worthwhile to check the processes using below command in mariadb console
SHOW PROCESSLIST;

With @sahilk25 we found that there were hanging processes on that db that needed to be killed. Reboot would have done the same job.

It took a while but restored successfully.