MariaDB is not starting with InnoDB.


One of our server's MariaDB has crushed. It crashed due to innodb_buffer_pool_size. I have recovered the data from InnoDB recovery mode. After that, The MariaDB is not supporting to InnoDB. It's showing ERROR 1193 (HY000): Unknown system variable 'innodb_buffer_pool_size' . Can you please help me how to start MariaDB with InnoDB. Any help appreciated, Thanks in advance Sandeep Sharma

Answer Answered by Marko Mäkelä in this comment.

InnoDB can refuse to start for various reasons. If InnoDB does not start, the MariaDB Server can start up. In that case, no InnoDB options or tables will be recognized.

The reason for InnoDB not starting up should be in the server’s error log, which could be written to a file like 'mysqld.err'. If logs are managed by systemd, then you could find useful.

InnoDB should report a reason for it not starting up. Usually it also writes some messages to the log before crashing. Once you have read the error log, you can search for the error messages. Finally, you could post additional information to an existing open ticket (if you found one), file a new ticket, or upgrade to a newer version that might have addressed the problem.


Comments loading...
Content reproduced on this site is the property of its respective owners, and this content is not reviewed in advance by MariaDB. The views, information and opinions expressed by this content do not necessarily represent those of MariaDB or any other party.