I have webmin and now an error: SQL show index from `bf_files_last` failed : Got error 194 "Tablespace is missing for a table" from storage engine In
Hi.
Have webmin for some montht - and works fine. But now I got the error:
SQL show index from bf_files_last failed : Got error 194 "Tablespace is missing for a table" from storage engine InnoDB
Webmin version: 10.11.8
Tried ewerything? nothing can change that.
The engine is not running ? - is that normal for InnoDB?
Why is webmin using InnoDB - and why is it using this, for what ?
Anyone…
3 Replies
hdiep
Linode Staff
This documentation mentions the "Got error 194 'Tablespace is missing for a table' from storage engine" error usually signifies that a table in your database is attempting to access an invalid tablespace, which means that your database system's storage location for the table data is either missing or improperly defined. It even goes further on how you can resolve this issue as it could be related to the following:
- Table files have the wrong ownership/permissions
- The table file is misplaced
- The data file is corrupted or deleted
I was also able to locate a few other forum posts where other users encountered the same issue as you have and were able to resolve it:
The engine is not running ? - is that normal for InnoDB?
InnoDB can refuse to start for various reasons. I recommend looking over your MySQL logs to see what could have caused this and go from there. This InnoDB Troubleshooting guide could also help assist you further with your troubleshooting.
Why is webmin using InnoDB - and why is it using this, for what ?
According to this documentation, for servers that resemble Unix, Webmin is a web-based system administration application. It can be used to change and manage open-source applications like MySQL, and many more. You can also use it to customize operating system internals like users, disk quotas, services, or configuration files.
Lastly, I recommend reaching out to MySQL forum's for any follow up questions, as there may be members may have further insight and provide assistance regarding this.
Hi there, thanks for answering, you saved my day.
Thank you. Balancing a full-time job with my MBA program made writing my dissertation almost impossible. I decided to use https://academized.com/dissertation-writing-service and their service was phenomenal. The writer crafted a detailed and cohesive dissertation that met all my university's requirements. They also kept me updated throughout the process, which eased my stress. Thanks to their assistance, I managed to submit on time and received great feedback!