2014-08-09, 21:51
(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
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.