[dnalloheoj]

Currently have two other OpenELEC machines (RPi and HTPC) running off MythTV just fine, and cleaning the EPG DB on those pulls in an EPG that only shows 1 of each channel.

The OpenELEC RPi2 runs MythTV just fine (Thanks to the updated addon that's been posted around here these past couple days) but the EPG and Channel list shows 2-3 of each channel. As far as I can tell, only one of the 2-3 works for each channel.

I'm not seeing a lot in the logs regarding why this is happening, just that it is happening. Maybe someone can help me make sense of this?

Settings on the machines are pretty much identical, though I noticed the RPi2 MythTV frontend didn't seem to ask me for a DBUsername/Password anywhere.

I've tried clearing the DB in Kodi via the PVR settings, as well as manually deleting the epg8.db files to try to clear things out, but it always comes back with a guide full of duplicate channels.

OpenELEC 5.0.3 (ARMv7)
HDHomeRun Prime (3 Tuners)
Raspberry Pi 2
MythTV Backend 0.27.0+fixes.20140324.8ee257c-0ubuntu3
MythTV Frontend ARM7-rpi2-1.12.6-helix
Kodi 14.1

Code:

16:35:17 T:1970110464  NOTICE: DVDPlayer: Opening: pvr://channels/tv/All channels/966.pvr
16:35:17 T:1970110464 WARNING: CDVDMessageQueue(player)::Put MSGQ_NOT_INITIALIZED
16:35:17 T:1545598016  NOTICE: Thread DVDPlayer start, auto delete: false
16:35:17 T:1545598016  NOTICE: Creating InputStream
16:35:17 T:1545598016   ERROR: AddOnLog: MythTV PVR Client: OpenLiveStream: Failed to open live stream
16:35:17 T:1545598016   ERROR: CDVDPlayer::OpenInputStream - error opening [pvr://channels/tv/All channels/966.pvr]


16:45:31 T:1970110464  NOTICE: PVRManager - ResetDatabase - clearing the PVR database
16:45:33 T:1970110464  NOTICE: PVRManager - stopping
16:45:34 T:1970110464   ERROR: SQL: The database disk image is malformed
                                            Query: DELETE FROM epgtags
16:45:34 T:1970110464   ERROR: ExecuteQuery - failed to execute query 'DELETE FROM epgtags '
16:45:35 T:1970110464  NOTICE: PVRManager - ResetDatabase - EPG database cleared
16:45:35 T:1970110464  NOTICE: PVRManager - ResetDatabase - restarting the PVRManager
16:45:35 T:1970110464  NOTICE: PVRManager - starting up
16:45:35 T:1758458944  NOTICE: Thread PVRManager start, auto delete: false
16:45:35 T:1712821312  NOTICE: Thread PVRClient start, auto delete: false
16:45:47 T:1804502080  NOTICE: Thread PVRGUIInfo start, auto delete: false
16:45:47 T:1766847552  NOTICE: Thread EPGUpdater start, auto delete: false
16:45:47 T:1758458944  NOTICE: Start - EPG thread started
16:46:08 T:1970110464   ERROR: Control 20 in window 10606 has been asked to focus, but it can't

The above issues seem to happen when I'm actually messing around with the box, reseting database, trying to view channels, etc.

The below issues seem to arise 5-10 minutes after I've stopped doing anything (Came upstairs to look around online/look at logs and this stuff showed up):

Code:

16:51:39 T:1766847552   ERROR: SQL: Attempt to write a readonly database
                                            Query: REPLACE INTO epg (idEpg, sName, sScraperName) VALUES (119, 'Home & Garden Television', 'client');
16:51:39 T:1766847552   ERROR: CommitInsertQueries - failed to execute queries
16:51:39 T:1766847552   ERROR: SQL: Attempt to write a readonly database
                                            Query: REPLACE INTO epg (idEpg, sName, sScraperName) VALUES (119, 'Home & Garden Television', 'client');
16:51:39 T:1766847552   ERROR: CommitInsertQueries - failed to execute queries
16:51:39 T:1766847552   ERROR: SQL: Attempt to write a readonly database

17:05:16 T:1737987136   ERROR: EpgContainer - UpdateEPG - could not open the database
17:06:16 T:1737987136   ERROR: Previous line repeats 59 times.
17:06:16 T:1737987136   ERROR: EPG - Persist - could not open the database
17:06:17 T:1737987136   ERROR: Previous line repeats 1086 times.
17:06:17 T:1737987136   ERROR: EpgContainer - UpdateEPG - could not open the database
17:07:17 T:1737987136   ERROR: Previous line repeats 59 times.
17:07:17 T:1737987136   ERROR: EPG - Persist - could not open the database
17:07:18 T:1737987136   ERROR: Previous line repeats 1086 times.

Here's a pastebin of the full log: http://pastebin.com/YpLRJCpA


Edit: Possibly related to what this guy is mentioning?: http://forum.kodi.tv/showthread.php?tid=...pid1868811

[nickr]

The pvr.mythtv addon does not require a login/password because it does not access the mythconverg database directly (unlike the pvr,.cmyth.mythtv addon used in gotham and earlier).

All it needs is your backend set with a PIN of 0000.

I don't think it should be referencing that other thread as you only have one type of tuner, and (presumably) only one source in mythbackend's setup. (Which in itself assumes all three tuners are plugged into the same antenna and getting the same lineup).

[janbar]

Your log show lot of error due probably a bad xbmc installation. You have to launch xbmc with an user account which can write files in its home directory. Here seems no ! xbmc use sqlite database to store metadata like epg, tv channel list, video titles ... So you have to fix that before.

[dnalloheoj]

and (presumably) only one source in mythbackend's setup

You nailed it with this part. I had EIT, QAM, and SD sources all setup. Removed the two unneeded ones and I'm good to go.

I'm not sure what the difference is between my two setups that made the older RPi only use one source where my RPi2 was using three.

Also reinstalled onto a brand-new MicroSD card yesterday which helped with speed a bit, but was still pulling in duplicate channels.

Anyway, all good. Thanks for the replies!

[janbar]

@dnalloheoj , the new addon 1.12.7 re-enables channel merging. You can download the binary from my cloud https://www.canneasucre.org/owncloud/pub...4750925043

EDIT: think to get the right binary for RPi2: the architecture is arm7

[dnalloheoj]

Awesome. Thanks for the timely update, Janbar.

Appreciate your work on the addon.