Posts: 1,259
Joined: Apr 2010
Reputation:
92
CrystalP
Team-Kodi Developer
Posts: 1,259
2024-05-02, 16:30
(This post was last modified: 2024-05-02, 16:31 by CrystalP. Edited 1 time in total.)
May be related or not, you have database corruption, on both local sqlite and mysql.
There are lots of lines like this "DatabaseUtils::GetSortFieldList: unknown field 36" from the videodatabase (mysql)
On the local databases, there are many similar to that:
SQL: [ViewModes6.db] SQLite error SQLITE_CORRUPT (database disk image is malformed)
Query: select * from view where window = 10500 and path='?/'
You can try to salvage your current video database with an export library, delete the video databases (all versions), start Kodi and import library.
The ViewModes6.db should be recreated after you delete it while Kodi is not running.
Backups are important when messing with the data in case things don't go as planned.
Posts: 1,259
Joined: Apr 2010
Reputation:
92
CrystalP
Team-Kodi Developer
Posts: 1,259
I looked a bit more into it and the "unknown field 36" error is not data corruption, but an unsupported use of "SortTitle" as list sorting for the music library. It's valid only for movies and episodes.
Maybe you have it in a playlist, custom node, somehow set it on a view.
Can't tell from here which gaps may or may not be related to your issue just by looking at the log, you have to tell us the timestamps that correspond to problems.
Posts: 290
Joined: Mar 2009
Reputation:
3
Bagger
Senior Member
Posts: 290
MySQL is not used for music db only video, the music was left local.
But when I noticed the errors in the log regarding music, the music source was removed, database cleaned and music.db deleted and recreated a week or so ago
Just checked and there are no playlists of any description
Ive just tried unchecking " scan on start up " and so far with a handfull of restarts seems OK, maybe the update service hanging for whatever reason. But time will tell.
Just have to rely on the other box to do library updates, or I may install kodi on the server purely for updating the database, assuming kodi can be run without a screen. ( its only accessed normally by VNC)
As for time stamps I did sync my clock with windows time and screens become populated at the same time as the "scanning for update bar" appears around the 2024-04-30 13:16:25 mark
thanks again for taking the time to look
Posts: 1,259
Joined: Apr 2010
Reputation:
92
CrystalP
Team-Kodi Developer
Posts: 1,259
I don't know what's happening. Stating the obvious but there would be a delay if the server needs to spin up the drives.
You're also on a old version, it's possible that changes in the past few years took care of the issue.
Posts: 290
Joined: Mar 2009
Reputation:
3
Bagger
Senior Member
Posts: 290
Thanks for the thoughts.
The Hard disks never spin down, beside the upstairs machine doesnt have this issue.
But... yeah at some point I will need to update to the latest Kodi.
I'm begining to think this has nothing to do with MySQL db and more to do with how the machine wakes from sleep.
To start with, the way my machine turns on / off is....
When suspend in the menu or sleep button on the remote is pressed, a background progam catches the request and runs a script to fully close Kodi then sleeps the machine.
To wake the machine, the button on the remote or "wake" from the Kore app (WOL) wakes the machine, runs a script and starts kodi again.
Scenarios the "hang" does / doesnt happen
Using Exit in the menu and starting kodi by double clicking the icon, hang never happens
Wake from sleep by.....
pressing button on remote. Hang never happens
Selecting "wake up" from the Kore app (WOL) is when the hang at startup happens.... but not every time.
Theres a relation (I think) to whether the other machine has been on.
I have had enough of this for now and leave it alone for a while, see if any more common occurances happen.
Thanks again