Kodi Community Forum
Solved Shared database setup/dropped some tables now clients cannot connect - Printable Version

+- Kodi Community Forum (https://forum.kodi.tv)
+-- Forum: Support (https://forum.kodi.tv/forumdisplay.php?fid=33)
+--- Forum: General Support (https://forum.kodi.tv/forumdisplay.php?fid=111)
+---- Forum: Linux (https://forum.kodi.tv/forumdisplay.php?fid=52)
+---- Thread: Solved Shared database setup/dropped some tables now clients cannot connect (/showthread.php?tid=375554)



Shared database setup/dropped some tables now clients cannot connect - graysky - 2023-12-27

I recently dropped some older versions of tables in mysqld.  Now, one of the RPi boxes just hangs on the Omega splash screen and I see the following in the log.  Shouldn't it rebuilding what it needs upon connecting?  My x86-64 box connects just fine.  Here is a complete debug log from the affected box which cannot connect.
 
Code:
2023-12-27 16:25:07.980 T:523      info <general>: MYSQL: Connected to version 11.2.2-MariaDB
2023-12-27 16:25:07.986 T:523      info <general>: Running database version MyMusic83
2023-12-27 16:25:08.010 T:523     error <general>: SQL: [MyVideos125] The table does not exist
                                                   Query: SELECT idVersion FROM version
                                                   
                                                   
2023-12-27 16:25:08.072 T:523     error <general>: Process error processing job 

EDIT: I rebuild from the HEAD as well as ran mysqlcheck --all-databases -u root -p -o and everything is fine.