Magento 2.2 SQL Rollback Failed
Problem:
I took a SQL backup of my Magento 2.2 dev site before I did some testing. The testing didn’t go as planned so I tried the rollback feature from inside the Magento admin panel. The rollback process started, but then the page just went blank.
When I did a refresh the page said I was in maintenance mode. I decided to SSH into the AWS instance and see what was going on. The server seemed okay, but it was stuck in maintenance mode. I disable maintenance mode and decided to run the rollback from the terminal.
php bin/magento setup:rollback -d db_sqldump11282018.sql
DB rollback is starting…
Segmentation fault
So, there’s my problem, the rollback must have run into a “Segmentation fault“. I found this is an issue that Magento is aware of and are they are working on a fix.
Workaround:
The workaround is pretty easy all you need to do run this command with your magento system user before you do your rollback command.
ulimit -s 65536
Results of rerunning my rollback command.
[SUCCESS]: DB rollback completed successfully.
Please set file permission of bin/magento to executable
Disabling maintenance mode
Make sure you clear you cache after a rollback.