[mrpg]

Dear All,

I have an issue where if for example i go into Movies, first no covers are displayed for any movies, then they slowly slowly start loading pictures. (30 seconds for 2-3 covers), if i then start moving around, i see the same cover for each movie, and if i stop for 30sec to 2 minutes it finally loads the covers for the movies.

It does not matter which skin i use, even happens under confluence.

I deleted all my sources and rescanned everything, but did unfortunately not help.

Please find attached a Debug Log incase this helps. http://paste.ubuntu.com/10748803/

I am using Helix 14,2 under Ubuntu 14.10, .kodi folder is on local ssd hdd.

I suspect this is because i have gone back and forth with testing kodi 15, but cannot get the pvr working, so went back to 14

Many thanks for any and all input!

[mkortstiege]

Looks like your textures database file is corrupt. Please try to repair it by dumping it into a new one. Stop kodi and run:

Code:

cd /home/mrpg/.kodi/userdata/Database/

Code:

mv Textures13.db Textures13.db.old

Code:

sqlite3 Textures13.db.old ".dump" | sqlite3 Textures13.db

In case that's non-working, move/delete Textures13.db out of /home/mrpg/.kodi/userdata/Database/. Kodi will re-create it.

[mrpg]

Hi,

Many thanks for the reply.

First tried the renaming and dumping out the data as you suggested, then rebooted my mediapc, then kodi would not start, just got to the login screen of ubuntu, and trying to login, briefly saw the kodi logo, then back at the login prompt.

Then deleted the file and rebooted, now i can get back into kodi again, but unfortuntely its still as slow.

Br
Patric

[un1versal]

try http://forum.kodi.tv/showthread.php?tid=158373 with

Code:

python ./texturecache.py C

That should force re caching of the testures13.db and help some of this. But only with time and navigating around, can make things a great deal faster.

[mrpg]

Many thanks uNiversal , trying this now, ETA 2 hours atm

[mrpg]

Just wanted to post and thank you both again.

running that python script to cache the fanart etc really sorted it out, its now instant again like it used to be!

Br
Patric

[mkortstiege]

Glad to hear it's working again.

[un1versal]

Just wanted to post and thank you both again.

running that python script to cache the fanart etc really sorted it out, its now instant again like it used to be!

Br
Patric

Yes, great news.

Please full edit main post and mark thread as solved. That should help those who come across similar issues.

[mkortstiege]

@mrpg, could you please share the broken textures db file (if it's not too late already)? I would like to see what exactly happens since Kodi should not crash in case of a db corruption.

[un1versal]

and if you have crashlogs, pastebin one also.

[mrpg]

Hello,

Sure, here is the db file (looking at the file size, its massive compared to my current one)

http://mr-pg.com/Textures13.db.old

It did not crash kodi, as far as i was aware, but i do have plenty of crashlogs from today :

http://paste.ubuntu.com/10751502/
http://paste.ubuntu.com/10751507/
http://paste.ubuntu.com/10751510/

Br
Patric

[un1versal]

mrpg

You can continue to use the texturecache.py to maintain the texture13.db in check and to remove excess crud from the kodi thumbnails folder etc.

I run it often with P, R and Xd and the first time I used it, removed 4GB of images that were no longer in use by Kodi. These days is all about maintenace and nothing like that large amount exists any more on a monthly basis.

The size of the database unfortunately does not decrease irrespective of it being more or less clean, Im not aware of any way to remove size from any database once you remove unnecessary data from it. That said doesnt mean you have to keep such crud about hence this tool is indeed the ebst and most effective of its kind when it comes to kodi garbage collection.

[wsnipex]

to compact a DB you can just dump and reimport it as shown by mkortstiege above.

[un1versal]

@wsnipex

Thx for that, worked a treat, 7.52MB to 5.25MB

Code:

stop kodi
mv ~/.kodi/userdata/Database/Textures13.db ~/.kodi/userdata/Database/Textures13.db-old
sqlite3 ~/.kodi/userdata/Database/Textures13.db-old ".dump" | sqlite3 ~/.kodi/userdata/Database/Textures13.db
start kodi

That's the second thing, learned today kodi wise. at this rate, lookout

[mkortstiege]

Spring cleaning?