1

I have a large mariadb instance running (400 gb or so).

Due to running out of storage space it crashed.

I went ahead and resized my volume (I am using AWS), and went to restart the service service mysql start

It did not however start. journalctl -xe returns the error "2017-07-25 14:19:33 140139278653632 [Note] InnoDB: Waiting for rollback of recovered transactionsto exit"

My assumption is that a transaction was executing, mariadb ran out of space and crashed. It is now trying to rollback that pending transaction and has yet to complete.

I am not particularly experienced with database administration, and I do not want to start messing around in a manner which could potentially corrupt my data.

I was wondering if anyone could share any insight on the appropriate way to discern if my assumption is correct, and how I can most appropriately resolve the situation?

Many thanks.

0

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.