TV29.db not preserving Channel Groups between boots

Hi all!
I’m using the most recent version of OSMC on a Raspberry Pi 2 with all updates / patches applied. I use the Aeon Nox skin. I’m using the Stalker Middleware addon (pvr.stalker) to watch Live TV. To that end, I have configured a Channel Group called “B&I”, which basically contains any British and Irish channels. This is mainly to facilitate a more manageable set of channels to scroll through. This works well and I can set the default Channel Group to B&I with no issues.
The problem occurs when I reboot the Pi; The B&I group disappears and I am left with the default “All Channels” group. Interestingly, when I recreate the B&I group the Live TV option on the main menu will display the B&I group by default. I take it from this that the Live TV menu is looking for the B&I group, but reverts to All Channels if it cannot find the default group.
Things I have done to try to solve the problem;

  1. I’ve looked in the /home/osmc/.kodi/userdata/Database folder and looked at what’s in there osmc@osmc:~/.kodi/userdata/Database$ ls -alh
    total 12M
    drwxr-xr-x 3 osmc osmc 4.0K Oct 4 15:36 .
    drwxr-xr-x 9 osmc osmc 4.0K Sep 27 04:10 …
    -rw-r–r-- 1 osmc osmc 716K Oct 4 10:21 Addons19.db
    drwxr-xr-x 2 osmc osmc 4.0K Jan 1 1970 CDDB
    -rw-r–r-- 1 osmc osmc 9.5M Oct 4 15:36 Epg10.db
    -rw-r–r-- 1 osmc osmc 196K Sep 26 00:36 MyMusic52.db
    -rw-r–r-- 1 osmc osmc 344K Sep 26 01:29 MyVideos93.db
    -rw-r–r-- 1 osmc osmc 344K Oct 4 12:52 Textures13.db
    -rwxrwxrwx 1 osmc osmc 260K Oct 4 15:21 TV29.db
    -rw-r–r-- 1 osmc osmc 20K Sep 27 04:05 ViewModes6.db
  2. I’ve copied the databases across to my linux machine and browsed them with sqlite database browser; this indicates that in the ChannelGroups table my “B&I” group is never created, it’s just not there.

So my question to you fine people is, is there a ‘live’ temporary database that holds the channel groups and other TV info which is then meant to be stored in the TV29.db during reboots? Or have I found a bug?

Many thanks in advance for all your help.

I have just noticed that the permissions on the TV29.db listed above look a bit strange. Does anyone else think that 777 permissions are unusual? I didn’t manually set these permissions though!

Bump, anyone got any ideas or thoughts? I’ve reinstalled kodi from scratch, but still have the same problem.

I’d recommend a Kodi log to see if you can identify this. Have you installed any Kodi addons which may have changed the permissions on the DB? The 777 is indeed suspicious.


Thanks for the reply Sam, after the reinstall, the permissions look correct:

osmc@sitting:~/.kodi/userdata/Database$ ls -alh
total 11M
drwxr-xr-x 3 osmc osmc 4.0K Oct 13 11:35 .
drwxr-xr-x 9 osmc osmc 4.0K Oct 5 19:52 …
-rw-r–r-- 1 osmc osmc 716K Oct 13 08:34 Addons19.db
drwxr-xr-x 2 osmc osmc 4.0K Jan 1 1970 CDDB
-rw-r–r-- 1 osmc osmc 8.3M Oct 13 11:34 Epg10.db
-rw-r–r-- 1 osmc osmc 196K Oct 5 19:39 MyMusic52.db
-rw-r–r-- 1 osmc osmc 344K Oct 5 19:39 MyVideos93.db
-rw-r–r-- 1 osmc osmc 612K Oct 13 11:21 Textures13.db
-rw-r–r-- 1 osmc osmc 268K Oct 13 11:01 TV29.db
-rw-r–r-- 1 osmc osmc 20K Oct 5 19:39 ViewModes6.db

However, the TV groups are still not being preserved between boots. I have checked the settings on the TV settings page of OSMC via Settings → TV → General and unset ‘Synchronise channel groups with backend’. This has also made no difference. Other than that, the only thing I can think of is that in some way using MySQL db for Music, Movies and TV Shows is in some way interfering.

Current log: Kodi.log
Old log: Kodi.old.log

Any help will be much appreciated!