2013-02-22, 10:14
Hi,
i switched from a local db to a mysql db to usw the advantages of a central db but now i have the problem that it takes about 10 minutes to start xbmc on the clients.
My setup:
Normal PC running vdr and xbmc (Frodo)
Raspberry running XBIAn with Frodo
a QNAP TS-412 (NAS) running the MySQL (v 5.1.36) and holding the movies and tv shows
When starting the XMBC you can see a running process on the MySQL DB but in the Debug-Log you can only see this code when you start normal and wait
When you interrup the MySQL process you can see what xbmc was trying to do on the DB
Im not very familiar with SQL oder MySQL and dont know if its a SQL or an xbmc problem.
Maybe someone had this issue too or knows what to do.
Thanks for your help.
i switched from a local db to a mysql db to usw the advantages of a central db but now i have the problem that it takes about 10 minutes to start xbmc on the clients.
My setup:
Normal PC running vdr and xbmc (Frodo)
Raspberry running XBIAn with Frodo
a QNAP TS-412 (NAS) running the MySQL (v 5.1.36) and holding the movies and tv shows
When starting the XMBC you can see a running process on the MySQL DB but in the Debug-Log you can only see this code when you start normal and wait
Code:
08:59:16 T:140109510190976 DEBUG: ADDON: Starting service addons.
08:59:16 T:140109510190976 DEBUG: Activating window ID: 12999
08:59:16 T:140109510190976 DEBUG: ------ Window Init (Startup.xml) ------
08:59:16 T:140109510190976 INFO: Loading skin file: Startup.xml, load type: LOAD_EVERY_TIME
08:59:16 T:140109510190976 INFO: removing tempfiles 08:59:16 T:140109510190976 NOTICE: UpdateLibraries - Starting video library startup scan
09:09:14 T:140109510190976 DEBUG: ADDON: Starting service addons.
09:09:14 T:140109169760000 NOTICE: Thread CVideoInfoScanner start, auto delete: false
09:09:14 T:140109510190976 NOTICE: initialize done
09:09:14 T:140109510190976 NOTICE: Running the application...
When you interrup the MySQL process you can see what xbmc was trying to do on the DB
Code:
09:18:20 T:140052220356480 DEBUG: ADDON: Starting service addons.
09:18:20 T:140052220356480 DEBUG: Activating window ID: 12999
09:18:20 T:140052220356480 DEBUG: ------ Window Init (Startup.xml) ------
09:18:20 T:140052220356480 INFO: Loading skin file: Startup.xml, load type: LOAD_EVERY_TIME
09:18:20 T:140052220356480 INFO: removing tempfiles
09:18:20 T:140052220356480 NOTICE: UpdateLibraries - Starting video library startup scan
09:18:51 T:140052220356480 ERROR: SQL: Undefined MySQL error: Code (1053) Query: select strPath,noUpdate from path where idPath in (select idPath from files join movie on movie.idFile=files.idFile) and idPath NOT in (select idPath from tvshowlinkpath) and idPath NOT in (select idPath from files where strFileName like 'video_ts.ifo') and idPath NOT in (select idPath from files where strFileName like 'index.bdmv') and strPath NOT like 'multipath://%' and strContent NOT in ('movies', 'tvshows', 'None') order by strPath
09:18:51 T:140052220356480 ERROR: GetPaths failed
09:18:51 T:140052220356480 DEBUG: ADDON: Starting service addons.
09:18:51 T:140052220356480 NOTICE: initialize done
09:18:51 T:140051812747008 NOTICE: Thread CVideoInfoScanner start, auto delete: false
09:18:51 T:140052220356480 NOTICE: Running the application...
Im not very familiar with SQL oder MySQL and dont know if its a SQL or an xbmc problem.
Maybe someone had this issue too or knows what to do.
Thanks for your help.