kodi 18.3 keeps dying when importing library
#1
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 ?
Reply
#2
@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
My Signature
Links to : Official:Forum rules (wiki) | Official:Forum rules/Banned add-ons (wiki) | Debug Log (wiki)
Links to : HOW-TO:Create Music Library (wiki) | HOW-TO:Create_Video_Library (wiki)  ||  Artwork (wiki) | Basic controls (wiki) | Import-export library (wiki) | Movie sets (wiki) | Movie universe (wiki) | NFO files (wiki) | Quick start guide (wiki)
Reply
#3
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/1mzOZgSw...sp=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/120PTl84...sp=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_63CKy...sp=sharing
Reply
#4
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.
My Signature
Links to : Official:Forum rules (wiki) | Official:Forum rules/Banned add-ons (wiki) | Debug Log (wiki)
Links to : HOW-TO:Create Music Library (wiki) | HOW-TO:Create_Video_Library (wiki)  ||  Artwork (wiki) | Basic controls (wiki) | Import-export library (wiki) | Movie sets (wiki) | Movie universe (wiki) | NFO files (wiki) | Quick start guide (wiki)
Reply
#5
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.
Reply
#6
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
Reply
#7
(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?
Reply
#8
(2019-07-11, 06:31)MasterCATZ Wrote: 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 ?
Reply
#9
@ianpb

What are you trying to accomplish?
Reply

Logout Mark Read Team Forum Stats Members Help
kodi 18.3 keeps dying when importing library0