MySQL query failed: Can't open file: 'misc.ibd' (errno: 1)

[wegngis]

I tried to do some updates to 8.0.1, and while I can find similar issues people are having, my specific issue isn't solved anywhere that I can find. Please help if you can!

ERROR: PleskMainDBException
MySQL query failed: Can't open file: 'misc.ibd' (errno: 1)

0: /usr/local/psa/admin/plib/common_func.php3:234
db_query(string 'select param, val from misc')
1: /usr/local/psa/admin/plib/common_func.php3:471
get_param(string 'mysql41_compatible')
2: /usr/local/psa/admin/plib/common_func.php3:368
db_set_names()
3: /usr/local/psa/admin/plib/common_func.php3:347
db_connect_real(string 'localhost', string 'admin', string '********', string 'psa')
4: /usr/local/psa/admin/plib/common_func.php3:327
db_connect()
5: /usr/local/psa/admin/auto_prepend/auth.php3:85

:

 

[scansterz]

MySQL query failed: Can't open file: 'misc.ibd'

Same error. What's up with that? Have you solved this? This trows down the whole email system, other things like Plesk (which is not that big a loss since it is so full of bugs) and some online mail tools.

Any help will be appreciated.

My history: PLESK them selves updated this machine to 8.1 and now it is broke, so you know if they update things and it breaks you know there is a problem!

thanks for any help.

-scan

 

[wegngis]

Re-imaged the box. BUT, I did a backup using command line (putty ssh), re-imaged the server, then restored my backup. All my Plesk related data was there, and the error was gone.

Hope this gives you some ideas.

 

[scansterz]

Thanks. I am not sure what you mean by re-image.
I can back up everything, but there are live sites on this thing.
BTW it is just the Plesk innoDB databases that this is a prob for, so esentially it is Plesk that is the prob.
Any DB that is created with the type innoDB will not open, copy, backup or anything.

What I have tried:
Writing Plesk: no response.
Copy some files out, ad to the my.cnf file a command to rebuild innoDB tables, per plesk help (somewhere) don't have that right now. Restarting the server etc...
Nothing seems to be the cure.

Thanks.
-scan

 

[wegngis]

By re-image I mean formatting and reinstalling the operating system. It was an extreme measure, but I couldn't figure out a better solution. I had to take the box down for about 2 hours to complete the process.

 

[scansterz]

Here is something that may help...
Plesk came up with this:

database "psa" look like broken, that is causes the error:

[root@ns ~]# hostname
ns.OURfakeDOMAIN.net
[root@ns ~]# mysql -uadmin -p`cat /etc/psa/.psa.shadow`
mysql> select * from domains;
ERROR 1016 (HY000): Can't open file: 'domains.ibd' (errno: 1)

Most likely several table files doesn't exist in "psa" database on source server, we probably need to restore old database from one of old dump files. Mysql dumps are localed in directory /var/lib/psa/dumps and as far as I see dump made on 'Jan 18 05:14' is ok, so we plan to restore this dump file on the server. Then re-do the migration.

dunno if that helps. I have not tried to see if they have done that yet.