Kodi Community Forum

Kodi Community Forum > Support > PVR & Live TV Support > VDR > ERROR: SQL: [TV29] Successful result
Full Version: ERROR: SQL: [TV29] Successful result
You're currently viewing a stripped down version of our content. View the full version with proper formatting.

Roi Danton

2017-12-28, 22:34
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

2017-12-28, 22:40
(2017-12-28, 22:34)Roi Danton Wrote: [ -> ]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

2017-12-28, 22:58
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

2017-12-28, 23:03
Which hardware do you use with libreelec?

Roi Danton

2017-12-28, 23:05
(2017-12-28, 23:03)hoppel118 Wrote: [ -> ]Which hardware do you use with libreelec?
 It's a Mac Mini, so basically x86_64 hardware.

hoppel118

2017-12-28, 23:09
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

2017-12-28, 23:11
(2017-12-28, 23:09)hoppel118 Wrote: [ -> ]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

2017-12-28, 23:13
(2017-12-28, 23:11)Roi Danton Wrote: [ -> ]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

2017-12-28, 23:29
It's vdr 2.2.0-13yavdr0~trusty and vdr-plugin-vnsiserver 2:1.5.2+git20171022-17-63d8151-0yavdr0~trusty.

hoppel118

2017-12-28, 23:47
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

2017-12-29, 06:30
(2017-12-28, 22:58)Roi Danton Wrote: [ -> ]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

2017-12-29, 12:33
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.
Kodi Community Forum > Support > PVR & Live TV Support > VDR > ERROR: SQL: [TV29] Successful result