[shedrock]

I'm quite sure that in a past post I reported that the add-on does not use TheTVDB site anymore because the API access is no more for free.

You're absolutely right. I did indeed forget about that, but I blame it on my age.

About the 6-7% issue, I will investigate it after the weekend (I'm going at the mountain side for a short break next days).

That would be great. Thank you very much.

Regards,

Shedrock

[axlt2002]

About the 6-7% issue, I will investigate it after the weekend (I'm going at the mountain side for a short break next days).

That would be great. Thank you very much.

Hi @shedrock, I finally had the time to investigate a little bit your issue.

Well, it seems that it is really due to the very huge library you have (we are talking about 263 MB!!!) and, depending on "where" the data are stored inside the database, it can take even some seconds to update just the rating of a single episode. For example, try to update through the context menu both The Blacklist (152 episodes) and Elementary (154 episodes): even if they have almost the same number of episodes, the second takes a lot more time than the first (you can notice such difference even for a single episode update). And if in addition to this issue you consider the fact that you are running 16 parallel threads, this can also lead to some uncontrolled behaviour (I saw that some episodes gave even an error in the update, randomly). I'm quite sure that if you are going to set only 1 thread, the update will finish properly even if it will take quite a long time due to the huge library.

I'm sorry that I can not be of help in this case and hope you can coexist with it, may be just using the context update for the TV shows that you are interested in (even if also in this case it can take a lot...see Elementary).

All the best!

[shedrock]

Hi @shedrock, I finally had the time to investigate a little bit your issue.A

Awesome that you spent time investigating it. I really do appreciate that very much. I will reduce it to 1 thread and see what happens. I meant to post here after I installed Matrix on my Surface Pro 4. Anyway, I ran a library update, and after 3 days it reached 38%, so I just quit it after that. I'm actually going to run it with the 1 thread option and see what happens.

Thanks again for all your assistance,

Shedrock

[axlt2002]

Hi @shedrock, I finally had the time to investigate a little bit your issue.A

Awesome that you spent time investigating it. I really do appreciate that very much. I will reduce it to 1 thread and see what happens. I meant to post here after I installed Matrix on my Surface Pro 4. Anyway, I ran a library update, and after 3 days it reached 38%, so I just quit it after that. I'm actually going to run it with the 1 thread option and see what happens.

Thanks again for all your assistance,

Shedrock

I run my tests over an Intel i5 6th generation / 8 GB RAM laptop and the update reached 6% after 40 minutes...at that time it started to update Elementary and it slowed down. I guess that having 1 thread is going to be stable (i.e. no random errors) and may be it could speed up (I don't know how much) the update since there are no concurrent threads accessing the database. Please keep me updated on your test.

By the way, is the update of the enitre library the way you prefer to use the add-on? I don't think you are interested in updating all the ratings for such a huge library every time. The context update can be a valid alternative (you just update what you are interested in). 

Have a great day!

[zombi1101]

Hi everyone!

Just registered at Kodi to be able to post in this thread. 
I really like this addon, but recently I am having problems with it. I even completely uninstalled Kodi (also deleted Userdata folder), installed it, installed addons (backup addon, youtube and Light IMBb Ratings update 5.0.2) and I still get "Unable to connect to the Internet. Please check your internet connection". Internet is fine as it fills info for new movies I add in watched folder. I also ran debug logging, but can't see anything abnormal there (script.light.imdb.ratings.update). If you need any moew info please ask for it. Thank you.
P.S.: It was working fine when I first installed it, year ago or so, but several months ago it just stopped working.

[HeresJohnny]

Hi @shedrock, I finally had the time to investigate a little bit your issue.A

Awesome that you spent time investigating it. I really do appreciate that very much. I will reduce it to 1 thread and see what happens. I meant to post here after I installed Matrix on my Surface Pro 4. Anyway, I ran a library update, and after 3 days it reached 38%, so I just quit it after that. I'm actually going to run it with the 1 thread option and see what happens.

Thanks again for all your assistance,

Shedrock

I run my tests over an Intel i5 6th generation / 8 GB RAM laptop and the update reached 6% after 40 minutes...at that time it started to update Elementary and it slowed down. I guess that having 1 thread is going to be stable (i.e. no random errors) and may be it could speed up (I don't know how much) the update since there are no concurrent threads accessing the database. Please keep me updated on your test.

By the way, is the update of the enitre library the way you prefer to use the add-on? I don't think you are interested in updating all the ratings for such a huge library every time. The context update can be a valid alternative (you just update what you are interested in). 

Have a great day!

A setup with a dedicated central database like MariaDB should be much faster when it comes to concurrent database access. My video DB database in MariaDB is almost 200mb as well but the updater runs through it in under 15 minutes with 16 concurrent threads.

[axlt2002]

Hi everyone!

Just registered at Kodi to be able to post in this thread. 
I really like this addon, but recently I am having problems with it. I even completely uninstalled Kodi (also deleted Userdata folder), installed it, installed addons (backup addon, youtube and Light IMBb Ratings update 5.0.2) and I still get "Unable to connect to the Internet. Please check your internet connection". Internet is fine as it fills info for new movies I add in watched folder. I also ran debug logging, but can't see anything abnormal there (script.light.imdb.ratings.update). If you need any moew info please ask for it. Thank you.
P.S.: It was working fine when I first installed it, year ago or so, but several months ago it just stopped working.

Hi @zombi1101 , thanks for your post.

Well, this looks really strange to me. The add-on doesn't make any magic to check the internet connection, it just tries to reach 'https://www.google.com/'...there are also no variables which value might impact that check. I'm trying to think what could be the issue...does this happen when you turn or your computer and launch Kodi immediately? If you exit Kodi and relaunch it after some time, it still happen?

Let me know.

[axlt2002]

Awesome that you spent time investigating it. I really do appreciate that very much. I will reduce it to 1 thread and see what happens. I meant to post here after I installed Matrix on my Surface Pro 4. Anyway, I ran a library update, and after 3 days it reached 38%, so I just quit it after that. I'm actually going to run it with the 1 thread option and see what happens.

Thanks again for all your assistance,

Shedrock

I run my tests over an Intel i5 6th generation / 8 GB RAM laptop and the update reached 6% after 40 minutes...at that time it started to update Elementary and it slowed down. I guess that having 1 thread is going to be stable (i.e. no random errors) and may be it could speed up (I don't know how much) the update since there are no concurrent threads accessing the database. Please keep me updated on your test.

By the way, is the update of the enitre library the way you prefer to use the add-on? I don't think you are interested in updating all the ratings for such a huge library every time. The context update can be a valid alternative (you just update what you are interested in). 

Have a great day!

A setup with a dedicated central database like MariaDB should be much faster when it comes to concurrent database access. My video DB database in MariaDB is almost 200mb as well but the updater runs through it in under 15 minutes with 16 concurrent threads.

Thanks @HeresJohnny, that looks really interesting. Can you plese post some link that explains how to setup MariaDB in Kodi? I think this could really help @shedrock in case.

Cheers!

[shedrock]

By the way, is the update of the enitre library the way you prefer to use the add-on? I don't think you are interested in updating all the ratings for such a huge library every time. The context update can be a valid alternative (you just update what you are interested in). 

I usually update the entire library because the ratings will change over time. I never update the Movies though. I guess that's because we spend 98% of our time watching TV series. I did read this post earlier on this morning, but I decided to drop the setting to 1 thread, and then I ran an update at 6:45am. It is now 2:27pm and it has reached 44%, so that's a big improvement in my opinion. I probably won't reach 100% because if I leave it running in the background, it will just slow the system down and my wife gets annoyed.

Anyway, I do sometimes just update each series manually, but it becomes a bit tiresome when you have so many TV shows, and are always adding to the library. That's ok though. At least it works much better this way running 1 thread.

UPDATE: Finished at 5:17pm. So that was approx. 9-1/2 hrs.

Regards,

Shedrock

[HeresJohnny]

Thanks @HeresJohnny, that looks really interesting. Can you plese post some link that explains how to setup MariaDB in Kodi? I think this could really help @shedrock in case.

Cheers!

There are many posts about that here already but the official page should provide a good starting point: https://kodi.wiki/view/MySQL
Make sure to use MariaDB 10.6 or higher as that is much more speed optimized than previous versions.

[axlt2002]

Thanks @HeresJohnny, that looks really interesting. Can you plese post some link that explains how to setup MariaDB in Kodi? I think this could really help @shedrock in case.

Cheers!

There are many posts about that here already but the official page should provide a good starting point: https://kodi.wiki/view/MySQL
Make sure to use MariaDB 10.6 or higher as that is much more speed optimized than previous versions.

Thanks a lot! I think I will take a look as well...it is always interesting to learn something new!

Have a great weekend!

[axlt2002]

By the way, is the update of the enitre library the way you prefer to use the add-on? I don't think you are interested in updating all the ratings for such a huge library every time. The context update can be a valid alternative (you just update what you are interested in). 

I usually update the entire library because the ratings will change over time. I never update the Movies though. I guess that's because we spend 98% of our time watching TV series. I did read this post earlier on this morning, but I decided to drop the setting to 1 thread, and then I ran an update at 6:45am. It is now 2:27pm and it has reached 44%, so that's a big improvement in my opinion. I probably won't reach 100% because if I leave it running in the background, it will just slow the system down and my wife gets annoyed.

Anyway, I do sometimes just update each series manually, but it becomes a bit tiresome when you have so many TV shows, and are always adding to the library. That's ok though. At least it works much better this way running 1 thread.

UPDATE: Finished at 5:17pm. So that was approx. 9-1/2 hrs.

Regards,

Shedrock

Wow! That is definitely an improvment and...without changing the code of the add-on! 

I think that the use case you reported is very useful and permitted to understand that concurrent updates to the database might cause issues in certain conditions. I'm considering if adding a note in hte first post about this. Anyway I'm happy that you have now your entire TV shows library updated!

Thanks a lot for your costant presence on the thread!

[shedrock]

I'm considering if adding a note in hte first post about this.

I agree. That's a great idea.

Thanks a lot for your costant presence on the thread!

No problem. Thank you for all your hard work.

Regards,

Shedrock

[zombi1101]

Hi everyone!

Just registered at Kodi to be able to post in this thread. 
I really like this addon, but recently I am having problems with it. I even completely uninstalled Kodi (also deleted Userdata folder), installed it, installed addons (backup addon, youtube and Light IMBb Ratings update 5.0.2) and I still get "Unable to connect to the Internet. Please check your internet connection". Internet is fine as it fills info for new movies I add in watched folder. I also ran debug logging, but can't see anything abnormal there (script.light.imdb.ratings.update). If you need any moew info please ask for it. Thank you.
P.S.: It was working fine when I first installed it, year ago or so, but several months ago it just stopped working.

Hi @zombi1101 , thanks for your post.

Well, this looks really strange to me. The add-on doesn't make any magic to check the internet connection, it just tries to reach 'https://www.google.com/'...there are also no variables which value might impact that check. I'm trying to think what could be the issue...does this happen when you turn or your computer and launch Kodi immediately? If you exit Kodi and relaunch it after some time, it still happen?

Let me know.

Hi axlt2002, Thank you for your reply.  Sorry for my late reply, haven't subscribed for replies.

It happen always. I just restarted computer and launch Kodi and it happens. No matter how long I wait and relaunch again it happens.

[Karellen]

No matter how long I wait and relaunch again it happens.

What version of the addon are you using?
Provide a Debug Log and we might spot the problem.