https://drive.google.com/open?id=1AhQ1Kf...e3hyncP9SZ
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/1IOiO...3W9092O46c
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 ?
@
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
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...
xml:
2019-07-12 08:58:47.099 T:19370 ERROR: Unable to open database: Animevideo116 [2004](Can't create TCP/IP socket (24))
2019-07-12 08:58:47.107 T:19370 ERROR: Unable to open database: Animevideo116 [2005](Unknown MySQL server host 'aio' (7))
2019-07-12 08:58:47.312 T:19370 ERROR: Previous line repeats 39 times.
2019-07-12 08:58:47.312 T:19370 ERROR: eglSwapBuffers failed (EGL_BAD_SURFACE)
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.
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.
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
(2019-07-20, 06:12)MasterCATZ Wrote: [ -> ]unable to do "separate file" it always spits out permission errors even with the network share as RW
Sorry, 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?
@
ianpb
What are you trying to accomplish?