kodi 18.3 keeps dying when importing library - Printable Version +- Kodi Community Forum (https://forum.kodi.tv) +-- Forum: Support (https://forum.kodi.tv/forumdisplay.php?fid=33) +--- Forum: General Support (https://forum.kodi.tv/forumdisplay.php?fid=111) +---- Forum: Android (https://forum.kodi.tv/forumdisplay.php?fid=164) +---- Thread: kodi 18.3 keeps dying when importing library (/showthread.php?tid=345316) |
kodi 18.3 keeps dying when importing library - MasterCATZ - 2019-07-11 https://drive.google.com/open?id=1AhQ1KfZDy-Q72Kg-qHCV1We3hyncP9SZ Kodi 18.3 Git:20190619-89472b7d69 I use Percona MariaDB it would not migrate from 17 - 18 so tried manually exporting library from 17 then importing it into 18 , but it just keeps failing after a hr or so open_files_limit 1048576 it just seems to hit a sleep then falls over no sql errors in logs apart from errors from when kodi 18 was installed 20960 Kodi android-70bca313320d7897.fritz.box:40608 Animevideo116 Sleep 00:02:32 db variables https://docs.google.com/document/d/1IOiOcnbX3-2qaCi6VofCSwIppIluz7Ub33W9092O46c trying my movies as they should be smaller 224 Kodi android-70bca313320d7897.fritz.box:47594 Moviesvideo116 Sleep 00:37:50 kodi seems to be doing things but server recons nothing is happening ? RE: kodi 18.3 keeps dying when importing library - Karellen - 2019-07-11 @MasterCATZ I only got as far as checking your two loaded advancedsettings.xml files. They are overly complex and most of the tags are not used by Kodi as they are outdated, invented or used incorrectly. I would certainly start with very big cleanup of your advancedsettings.xml file. Confirm what is correct with this page... https://kodi.wiki/view/Advancedsettings.xml RE: kodi 18.3 keeps dying when importing library - MasterCATZ - 2019-07-12 not much in advancedsettings.xml accept for db and a few regexp old pathsubstitution should be disabled old setttings https://drive.google.com/file/d/1mzOZgSwwbPTUj_5-ZGEHpKIlX0YtbK7x/view?usp=sharing I will start a fresh one with just db added and see what happens this is the db I am trying to import exported db https://drive.google.com/file/d/120PTl84uAAj2ClM29BHgHf1Kl1pVx2o_/view?usp=sharing failed again with barebone settings <advancedsettings version="1"> <videodatabase> <type>mysql</type> <host>aio</host> <port>3306</port> <user>Kodi</user> <pass>Kodi</pass> <name>Animevideo</name> </videodatabase> <musicdatabase> <type>mysql</type> <host>aio</host> <port>3306</port> <user>Kodi</user> <pass>Kodi</pass> <name>Animemusic</name> </musicdatabase> </advancedsettings> kodi.log https://drive.google.com/file/d/1l_63CKySuzTuJx6grpODOL51dihrKT8K/view?usp=sharing RE: kodi 18.3 keeps dying when importing library - Karellen - 2019-07-12 You are importing from a Single File which you previously exported from Kodi. That is a massive file. Personally I would be using Separate File export to NFO Files as it is more flexible. Are you aware that if you change the filename or paths since the single file export, then those items you changed will be dead library entries. That aside, it seems there is a connection problem according to this error at line 45,400 which is when your scan starts failing...
My knowledge is limited with MySQL. @Klojum may be able to help, but I think you are hitting a limit with the number of transactions being processed. I imported your file into my vanilla Kodi and all imported fine in 24 minutes- 12 movies and 289 tv shows. Though I cannot play anything as I do not have the files. RE: kodi 18.3 keeps dying when importing library - Klojum - 2019-07-13 ERROR: Unable to open database: Animevideo116 [2004] (Can't create TCP/IP socket (24)) You may have too many open files. You need to increase the open_files_limit in your MySQL configuration file. By default, the variable is set to 1,024 open files. I never see this problem with MySQL or MariaDB servers. Perhaps Percona does something different. ERROR: Unable to open database: Animevideo116 [2005] (Unknown MySQL server host 'aio' (7)) Your client and/or server OS will have an incomplete hosts file. Usually servers are addressed only via IP addresses for a reason. RE: kodi 18.3 keeps dying when importing library - MasterCATZ - 2019-07-20 the current open_files_limit was 1048576 unable to do "separate file" it always spits out permission errors even with the network share as RW tho I mostly do not use it because it overwrites all my nfo files .. and why would it drop sql connection mid way when it had already connected via host name ? the only thing I was able to do was dump all of the old db's re-import using an older kodi version then load up the newer version and then it seemed to migrate to the new db from memory it would not migrate from db version 110 but it worked from 106 RE: kodi 18.3 keeps dying when importing library - Klojum - 2019-07-20 (2019-07-20, 06:12)MasterCATZ Wrote: unable to do "separate file" it always spits out permission errors even with the network share as RWSorry, but then you just have a crappy network setup. What are you using as a file server? (2019-07-20, 06:12)MasterCATZ Wrote: tho I mostly do not use it because it overwrites all my nfo files ..What's special about your own nfo files that they cannot be overwritten? RE: kodi 18.3 keeps dying when importing library - ianpb - 2019-07-21 (2019-07-11, 06:31)MasterCATZ Wrote: https://drive.google.com/open?id=1AhQ1KfZDy-Q72Kg-qHCV1We3hyncP9SZ RE: kodi 18.3 keeps dying when importing library - Klojum - 2019-07-21 @ianpb What are you trying to accomplish? |