TV29.db not preserving Channel Groups between boots

Help and Support Raspberry Pi
1

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.

2

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!

3

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

4

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.

Sam

5

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!