I use OSMC on Raspberry Pi 2 to watch TV from my TVheadend server.
I am often getting OSCM/kodi crashed when trying to start any TV program.
The Kodi log file always says about TV29.db constraint violation - eg. here is recent crash:
18:09:50.505 T:1477878528 ERROR: SQL: [TV29.db] Abort due to constraint violation
Query: INSERT INTO channels (iUniqueId, bIsRadio, bIsHidden, bIsUserSetIcon, bIsUserSetName, bIsLocked, sIconPath, sChannelName, bIsVirtual, bEPGEnabled, sEPGScraper, iLastWatched, iClientId, idEpg) VALUES (1432878457, 1, 0, 0, 0, 0, ‘http://10.162.0.20:9981/imagecache/872’, ‘RMF Classic’, 0, 1, ‘client’, 0, 2146250725, -1)
18:09:50.506 T:1477878528 ERROR: CommitInsertQueries - failed to execute queries
Then I have to go to TV configuration, select option to clan all program and EPG data. Afterwards it works, but not for too long - after OSMC staying idle for some time I’m getting the crash again.
Any idea what’s wrong here, please? I’ve been trying to recreate TV29.db file, but that does not help.