OpenELEC Testbuilds for RaspberryPi Part 3 (Kodi 14.0)
(2014-08-08, 22:33)SenorLoco Wrote: Got some logs for you. Hopefully these help. I did notice right away that CleanDatabase failed on #0805

#0804 - http://sprunge.us/QRMi
#0805 - http://sprunge.us/BAeM

Let me know if you need anything else.


Yep, from #0805:

Code:
15:28:48 130.156281 T:3059638272  NOTICE: CleanDatabase: Starting videodatabase cleanup ..
15:28:48 130.156555 T:3059638272   DEBUG: CAnnouncementManager - Announcement: OnCleanStarted from xbmc
15:28:48 130.156937 T:3059638272   DEBUG: GOT ANNOUNCEMENT, type: 16, from xbmc, message OnCleanStarted
15:28:48 130.159225 T:3059638272   DEBUG: Mysql Start transaction
15:28:48 130.185150 T:3059638272   DEBUG: DialogProgress::StartModal called
15:28:48 130.185440 T:3059638272   DEBUG: ------ Window Init (DialogProgress.xml) ------
15:28:48 130.185715 T:3059638272    INFO: Loading skin file: DialogProgress.xml, load type: KEEP_IN_MEMORY
15:28:48 130.494720 T:3059638272   DEBUG: SECTION:LoadDLL(libnfs.so.4)
15:28:48 130.500076 T:3059638272   DEBUG: Loading: libnfs.so.4
15:28:49 130.849091 T:3059638272   DEBUG: NFS: Context for 192.168.1.100/home/adam/Media/Tv not open - get a new context.
15:28:49 131.099976 T:3059638272   DEBUG: NFS: Connected to server 192.168.1.100 and export /home/adam/Media/Tv
15:28:49 131.100296 T:3059638272   DEBUG: NFS: chunks: r/w 524288/524288
15:29:01 143.090210 T:3059638272   DEBUG: CleanDatabase: Cleaning files table
15:29:01 143.090561 T:3059638272   DEBUG: Mysql execute: DELETE FROM files WHERE idFile IN (244)
15:29:01 143.125290 T:3059638272   DEBUG: CleanDatabase: Cleaning streamdetails table
15:29:01 143.125595 T:3059638272   DEBUG: Mysql execute: DELETE FROM streamdetails WHERE idFile IN (244)
15:29:01 143.135330 T:3059638272   DEBUG: CleanDatabase: Cleaning bookmark table
15:29:01 143.135635 T:3059638272   DEBUG: Mysql execute: DELETE FROM bookmark WHERE idFile IN (244)
15:29:01 143.139740 T:3059638272   DEBUG: CleanDatabase: Cleaning settings table
15:29:01 143.140091 T:3059638272   DEBUG: Mysql execute: DELETE FROM settings WHERE idFile IN (244)
15:29:01 143.144043 T:3059638272   DEBUG: CleanDatabase: Cleaning stacktimes table
15:29:01 143.144302 T:3059638272   DEBUG: Mysql execute: DELETE FROM stacktimes WHERE idFile IN (244)
15:29:01 143.152908 T:3059638272   DEBUG: CleanDatabase: Cleaning episode table
15:29:01 143.153198 T:3059638272   DEBUG: Mysql execute: DELETE FROM episode WHERE idEpisode IN (244)
15:29:01 143.183716 T:3059638272   DEBUG: CleanDatabase: Cleaning paths that don't exist and have content set...
15:29:02 143.607147 T:3059638272   DEBUG: Mysql execute: DELETE FROM path WHERE idPath IN (45)
15:29:02 143.633835 T:3059638272   DEBUG: Mysql execute: DELETE FROM tvshowlinkpath WHERE NOT EXISTS (SELECT 1 FROM path WHERE path.idPath = tvshowlinkpath.idPath)
15:29:02 143.664871 T:3059638272   DEBUG: CleanDatabase: Cleaning tvshow table
15:29:02 143.665207 T:3059638272   DEBUG: Mysql execute: DELETE FROM tvshow WHERE NOT EXISTS (SELECT 1 FROM tvshowlinkpath WHERE tvshowlinkpath.idShow = tvshow.idShow)
15:29:02 143.700974 T:3059638272   ERROR: SQL: Undefined MySQL error: Code (1442)
                                            Query: DELETE FROM tvshow WHERE NOT EXISTS (SELECT 1 FROM tvshowlinkpath WHERE tvshowlinkpath.idShow = tvshow.idShow)
15:29:02 143.719299 T:3059638272   ERROR: CleanDatabase failed
15:29:02 143.727173 T:3059638272   DEBUG: Mysql rollback transaction
15:29:02 143.727570 T:3059638272   DEBUG: CAnnouncementManager - Announcement: OnCleanFinished from xbmc
15:29:02 143.727844 T:3059638272   DEBUG: GOT ANNOUNCEMENT, type: 16, from xbmc, message OnCleanFinished
So it looks like the clean is failing while deleting the tvshow.

The description for the error code is:
Quote:Error Code: 1442. Can't update table 'tvshowlinkpath' in stored function/trigger because it is already used by statement which invoked this stored function/trigger.

Doesn't look like an easy fix, and another nail in the MySQL coffin. Sad
Texture Cache Maintenance Utility: Preload your texture cache for optimal UI performance. Remotely manage media libraries. Purge unused artwork to free up space. Find missing media. Configurable QA check to highlight metadata issues. Aid in diagnosis of library and cache related problems.


Messages In This Thread
Re: RE: - by Mafarricos - 2014-06-04, 20:21
Live tv issues again - by pootler - 2014-06-04, 23:29
RE: OpenELEC Testbuilds for RaspberryPi Part 3, - by removed151214 - 2014-08-04, 23:38
RE: OpenELEC Testbuilds for RaspberryPi Part 3 - by Milhouse - 2014-08-09, 21:51
RE: OpenELEC Testbuilds for RaspberryPi Part 3 - by removed151214 - 2014-08-19, 00:11
RE: OpenELEC Testbuilds for RaspberryPi Part 3 - by removed151214 - 2014-08-21, 20:42
RE: OpenELEC Testbuilds for RaspberryPi Part 3 - by removed151214 - 2014-09-22, 22:20
RE: OpenELEC Testbuilds for RaspberryPi Part 3 - by removed151214 - 2014-09-22, 22:34
RE: OpenELEC Testbuilds for RaspberryPi Part 3 - by removed151214 - 2014-09-22, 22:44
RE: OpenELEC Testbuilds for RaspberryPi Part 3 - by removed151214 - 2014-09-23, 01:12
RE: OpenELEC Testbuilds for RaspberryPi Part 3 - by removed151214 - 2014-09-23, 23:24
RE: OpenELEC Testbuilds for RaspberryPi Part 3 - by removed151214 - 2014-09-25, 01:38
RE: OpenELEC Testbuilds for RaspberryPi Part 3 - by removed151214 - 2014-10-01, 18:12
RE: OpenELEC Testbuilds for RaspberryPi Part 3 - by removed151214 - 2014-10-01, 18:26
RE: OpenELEC Testbuilds for RaspberryPi Part 3 - by removed151214 - 2014-10-05, 01:07
RE: OpenELEC Testbuilds for RaspberryPi Part 3 - by removed151214 - 2014-10-11, 03:48
RE: OpenELEC Testbuilds for RaspberryPi Part 3 - by removed151214 - 2014-10-11, 04:06
RE: OpenELEC Testbuilds for RaspberryPi Part 3 - by removed151214 - 2014-10-11, 11:29
Logout Mark Read Team Forum Stats Members Help
OpenELEC Testbuilds for RaspberryPi Part 3 (Kodi 14.0)8