[Roi Danton]

Hello,

I am running the latest LibreELEC 8.2.2 with Kodi 17.6 and the Kodi VNSI-Client. Unfortunally the log is filled with SQL errors. I turned on debug and got the following:

Code:

21:27:03.269 T:139680564528896    INFO: PVRChannelGroupInternal - AddAndUpdateChannels - updated TV channel 'Real Time HD'
21:27:03.278 T:139680564528896   DEBUG: CPVRChannelGroup - Persist - persisting channel group 'Alle Kanäle' with 2709 channels
21:27:03.278 T:139680564528896   DEBUG: Mysql execute: REPLACE INTO channelgroups (idGroup, bIsRadio, iGroupType, sName, iLastWatched, bIsHidden, iPosition) VALUES (21, 0, 1, 'Alle Kanäle', 1514495091, 0, 0)
21:27:03.310 T:139680564528896   DEBUG: Mysql Start transaction
21:27:03.311 T:139680564528896   ERROR: SQL: [TV29] Successful result
                                            Query: REPLACE INTO channelgroups (idGroup, bIsRadio, iGroupType, sName, iLastWatched, bIsHidden, iPosition) VALUES (21, 0, 1, 'Alle Kanäle', 1514495091, 0, 0)
21:27:03.313 T:139680564528896   DEBUG: Mysql rollback transaction
21:27:03.313 T:139680564528896   ERROR: CommitInsertQueries - failed to execute queries
21:27:03.317 T:139680564528896   DEBUG: CPVRChannelGroups - PersistAll - persisting all changes in channel groups

Before the first line quoted here all other 2709 channels are listed. I also see these errors with the radio channels. And these messages do repeat themselves at least every minute, most of the time a lot more often.

What I really don't understand is why I get an ERROR and a successful result behind. Also the query does work, I tested it in my MySQL console. Oh, by the way, I switched to MySQL for the TV29 database, but these errors are not new, they existed also before I switched from the default database system.

Any idea?

Cheers,
Roi

[FernetMenta]

Any idea?

Cheers,
Roi

 I would first try a v18 alpha version. There have been many fixes in DB code since 17.x.

[Roi Danton]

Hi,

hm, there does not seem to exist a usable version of LE and Kodi 18.x, unfortunally. Do you have any other ideas in the meantime?

Cheers,
Roi

[hoppel118]

Which hardware do you use with libreelec?

[Roi Danton]

Which hardware do you use with libreelec?

 It's a Mac Mini, so basically x86_64 hardware.

[hoppel118]

Do you use vdr server on your libreelec machine or do you have a separate server hardware?

Maybe you can check, if the error also exists with kodi (17 / 18) on a windows computer or another mac.

[Roi Danton]

Do you use vdr server on your libreelec machine or do you have a separate server hardware?

Maybe you can check, if the error also exists with kodi (17 / 18) on one of your windows computers?

 The VDR runs on a different hardware. It is a up to date yaVDR installation.

I do not have Kodi installed anywhere else. I could try it on a Windows machine and try to match the database configuration. But that is some work and takes time. Could do that tomorrow.

[hoppel118]

I do not have Kodi installed anywhere else. I could try it on a Windows machine and try to match the database configuration. But that is some work and takes time. Could do that tomorrow.

Great!

Which vdr server version provides your yavdr?

[Roi Danton]

It's vdr 2.2.0-13yavdr0~trusty and vdr-plugin-vnsiserver 2:1.5.2+git20171022-17-63d8151-0yavdr0~trusty.

[hoppel118]

Ok, i don‘t use yavdr. But it’s also v2.2.0 from e-tobis repo (debian jessie) and vnsiserver v1.5.2 from git. I do not have your errors on my nvidia shield (latest android nougat) or my win10 pc, nor with kodi 17 or kodi 18.

[FernetMenta]

Hi,

hm, there does not seem to exist a usable version of LE and Kodi 18.x, unfortunally. Do you have any other ideas in the meantime?

Cheers,
Roi

 Are Milhouse builds not working for you? https://forum.kodi.tv/showthread.php?tid=298462

[Roi Danton]

I already tried yesterday night. It works. As these builds are marked as experimental at first I did not want to put these on my live box. This box needs to work - somehow. Mostly because the wife acceptance factor depends on it. ;-)

I did not see any more TV SQL errors since the upgrade. What I will try next is re-enabling the TV groups in Kodi. This did not work at all in Kodi 17. I had to delete the database every day because of faulty SQL queries which happened at some time after (re)starting the box.