CPVRChannelGroup - Persist: SQL constraint violation about pvr.hts HOT 15 CLOSED

Can you also provide a kodi debug log from when this happens? I'm facing the same problem from time to time, but I was not able to get a proper log file yet.
EDIT: please also turn on all pvr/database specific debugging

from pvr.hts.

Sure, no problem: http://gmeiner.xyz/kodi/kodi.debug.log
I had debug logging + pvr.hts extended logging enabled during the capture (is there a way to enable extended db logging?)
My apologies: the file holds all the crap of a fresh channel list (adding all fta channels...) so it's a bit lengthy.
EDIT: the DB at the time when the error occurred can be found here: http://gmeiner.xyz/kodi/TV29.debug.db

from pvr.hts.

Looking at the log file, I suspect that it has something to do with the channel groups, can you reproduce the database error with the "sync channel groups with backend" option in kodi off? (clear db after changing setting). Is it possible for you to run Jarvis if this wasn't a success, there were some database fixes there.

from pvr.hts.

@ksooo this is 100% reproducible, the problem is that in tvheadend a channel can be changed from tv to radio and the other way around. Kodi will not handle this and throw the sql error.

Found some more recent reports from this db error and in all cases the channel to be added is a radio channel, so it never appears for tv channels.
http://forum.kodi.tv/showthread.php?tid=235246
http://forum.kodi.tv/showthread.php?tid=189534&page=5
VDR also seems to trigger this issue.

The problem according my debugging:

1. a tv channel (channel without service is also a tv channel according pvr.hts) is loaded in the kodi database
2. after some time the user (or tvheadend itself) changes this channel into a radio channel. Kodi will interpret this as a new radio channel and try to add it to it's database. Of Course the old tv channel is still present there.

Steps to reproduce:

1. add a channel in tvh backend without an service assigned (= tv channel)
2. start kodi and clear db
3. close kodi
4. edit the channel in tvheadend and add a radio service to it
5. open kodi -> db error, pvr addon will not load!
   21:11:31 T:140465655490304 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 (1368899658, 1, 0, 0, 0, 0, '', '123test123', 0, 1, 'client', 0, 881, -1)

from pvr.hts.

@Bastig Not needed to test Jarvis anymore as I encountered the same problem with it now ;-)

from pvr.hts.

@Glenn-1990 so is this purely a Kodi bug or do we have to fix something in the addon as well? If not please go ahead and close this ticket.

from pvr.hts.

Well pvr.hts will assign undefined channels (channels without a service) as tv channels, this will increase the chance to trigger this issue. It's possible to hide these undefined channels, as the user will not be able to watch them anyway... But the kodi issue is the main problem of this.

from pvr.hts.

Should we ignore channels without a service? IMO we shouldn't since it may be confusing.

from pvr.hts.

Maybe we should notify the user why tuning such a channel fails (display "no service assigned to this channel" or such), but that's not related to this issue.

from pvr.hts.

@Jalle19 What do you think of the kodi fix for this?

from pvr.hts.

Perhaps it would be enough to just log it?

from pvr.hts.

Any update on this?

from pvr.hts.

PR to fix this is still open:
xbmc/xbmc#8953

Seems that multiple users are suffering from this issue, but on the forums they just get the explanation that their db got corrupted...
Mainly tvh and vdr reports, probably because of the way they define radio/tv channels.
(video PID present = tv channel in pvr.hts, radio otherwise; when the video PID disappears, pvr.hts will transfer it to a radio channel)

Try to google "ERROR: SQL: Abort due to constraint violation" almost every post with this error has the radio flag set, meaning that's it's most likely caused by the issue described above.

from pvr.hts.

Moin,

yes, it's an Issue for me too.

I am using vdr 2.2.0, vnsiserver 1.3.1, kodi 16.1 and vnsiclient 1.11.16.

Have some Windows-10-Clients with kodi and now an odroid c2 with libreelec affected from this. I have to delete the TV29.db to bring back live tv after some time, again and again.

I will try to deactivate the Channel Updates on the vdr server by setting: "UpdateChannels = 0" in the setup.conf and report back here, if this worked as workaround.

Please bring the fix to krypton.

Greetings Hoppel

from pvr.hts.

I will try to deactivate the Channel Updates on the vdr server by setting: "UpdateChannels = 0" in the setup.conf and report back here, if this worked as workaround.

Since deactivation of channel updates by vdr I didn't had this issue again. As a workaround it's fine.

from pvr.hts.