MySQL keeps updating movies
#16
(2023-02-08, 20:03)axlt2002 Wrote: I'm sorry, but I can just tell that such SQL commands are not related to Light IMDb Ratings Update...it looks they are setting movie titles, plots, posters, etc., definitely something that my add-on does not. Just to know, do you already used in the past the add-on or is this the first time?
I used to use it something like 1 or 2 months but this issue I have detected just after I did a fresh CoreELEC with Kodi 20 installation. It wasn't hitting me when I was on CoreELEC with Kodi 19.5.
So you are saying these SQL commands are not related to Light IMDb Ratings Update addon... that is something what I don't understand at all. These lines start appearing just after I right-click on one series episode and invoke ratings update for it...so... what else it might doing this? Skin itself? I will check if it is happening also with default Kodi's skin... one sec...

yes... seems to be no issue with Estuary Kodi's skin... switching to Xonfluence skin...invoking contxt-based update on episode and... there are no "movie updates" what the heck is happening here!!!??
Reply
#17
(2023-02-08, 20:12)rafikW Wrote:
(2023-02-08, 20:03)axlt2002 Wrote: I'm sorry, but I can just tell that such SQL commands are not related to Light IMDb Ratings Update...it looks they are setting movie titles, plots, posters, etc., definitely something that my add-on does not. Just to know, do you already used in the past the add-on or is this the first time?
I used to use it something like 1 or 2 months but this issue I have detected just after I did a fresh CoreELEC with Kodi 20 installation. It wasn't hitting me when I was on CoreELEC with Kodi 19.5.
So you are saying these SQL commands are not related to Light IMDb Ratings Update addon... that is something what I don't understand at all. These lines start appearing just after I right-click on one series episode and invoke ratings update for it...so... what else it might doing this? Skin itself? I will check if it is happening also with default Kodi's skin... one sec...

yes... seems to be no issue with Estuary Kodi's skin... switching to Xonfluence skin...invoking contxt-based update on episode and... there are no "movie updates" what the heck is happening here!!!??
Thanks for further checking...it looks like a mess...and I'm sorry I can not be of help at the moment...I think you have to further investigate what is going on...
Light IMDb Ratings Update - Keep updated the IMDb ratings for your movies and TV shows.
In case you found useful my work, feel free to offer me a cappuccino!
Reply
#18
It might be corrupted video database: https://forum.kodi.tv/showthread.php?tid=365816
I have 14 backups of my database taken everyday... I will restore and check...

No... the same with database restored from the backup :-(
And no issue when using Estuary skin so my conclusion is that it is caused by Xonfluence skin on Kodi 20 and is kicked on by using Light IMDb Ratings Update 5.1.1 add-on context action.
Solution: unfortunately Xonfluence is not developed anymore so I have to stop using Xonfluence skin or to not use Light IMDb Ratings Update 5.1.1 add-on.
My decision is to not use Light IMDb Ratings Update 5.1.1 add-on as I'm heavily "linked" to Xonfluence skin.
End of my story.
Reply
#19
Shit!!!!!!!
Now it is even happening on Estury skin without Light IMDb Rating Update add-on installed!!!
I'm going back to Kodi 19.5. Fortunately I have a backup.
Apparently some of the add-ons I'm using and Xonfluence skin together are not compatible with CoreELEC / Kodi Nexus 20.
Reply
#20
Ok, so this demonstrates that there was no correlation between THIS add-on and the mess on the Kodi database...hope you are convinced now! Nod
Light IMDb Ratings Update - Keep updated the IMDb ratings for your movies and TV shows.
In case you found useful my work, feel free to offer me a cappuccino!
Reply
#21
Ok, few days of struggling with this issue and I think I have a final conclusion what was causing the issue of sudden appearing lines:
xml:

2023-02-07 21:28:01.541 T:14405    info <general>: UpdateDetailsForMovie: Starting updates for movie 2811
2023-02-07 21:28:01.549 T:14405    info <general>: UpdateDetailsForMovie: Finished updates for movie 2811
2023-02-07 21:28:05.949 T:14405    info <general>: UpdateDetailsForMovie: Starting updates for movie 2841
2023-02-07 21:28:05.956 T:14405    info <general>: UpdateDetailsForMovie: Finished updates for movie 2841
2023-02-07 21:28:10.384 T:14405    info <general>: UpdateDetailsForMovie: Starting updates for movie 2798
2023-02-07 21:28:10.395 T:14405    info <general>: UpdateDetailsForMovie: Finished updates for movie 2798
2023-02-07 21:28:27.941 T:14405    info <general>: UpdateDetailsForMovie: Starting updates for movie 2853
2023-02-07 21:28:27.948 T:14405    info <general>: UpdateDetailsForMovie: Finished updates for movie 2853

in kodi.log which eventually was leading to memory exhausting and Kodi freeze...

On Kodi 19.5 I used to use "The TVDB (new)" scraper and then later on I have started using "The TVDB v4" TV scraper. Together with "Light IMDb Ratings Update" add-on it used to work correctly.
When I did a fresh install of CoreELEC with Kodi 20 I have also installed "TVDB v4 TV" scraper. Apparently this is the root cause of the issue.
This time I installed CoreELEC with Kodi 20 but did not installed "TVDB v4 TV" leaving default Kodi's "TMDb TV Shows" scraper and setting it as information provider on the folder with my TV series.
When using "TMDb TV Shows" "Light IMDb Ratings Update" add-on is not needed as "TMDb TV Shows" scraper read ratings by default.
So far no more issues with hundreds of lines with UpdateDetailsForMovie: Finished updates for movie
Reply
#22
(2023-02-11, 16:48)rafikW Wrote: Ok, few days of struggling with this issue and I think I have a final conclusion what was causing the issue of sudden appearing lines:
xml:

2023-02-07 21:28:01.541 T:14405    info <general>: UpdateDetailsForMovie: Starting updates for movie 2811
2023-02-07 21:28:01.549 T:14405    info <general>: UpdateDetailsForMovie: Finished updates for movie 2811
2023-02-07 21:28:05.949 T:14405    info <general>: UpdateDetailsForMovie: Starting updates for movie 2841
2023-02-07 21:28:05.956 T:14405    info <general>: UpdateDetailsForMovie: Finished updates for movie 2841
2023-02-07 21:28:10.384 T:14405    info <general>: UpdateDetailsForMovie: Starting updates for movie 2798
2023-02-07 21:28:10.395 T:14405    info <general>: UpdateDetailsForMovie: Finished updates for movie 2798
2023-02-07 21:28:27.941 T:14405    info <general>: UpdateDetailsForMovie: Starting updates for movie 2853
2023-02-07 21:28:27.948 T:14405    info <general>: UpdateDetailsForMovie: Finished updates for movie 2853

in kodi.log which eventually was leading to memory exhausting and Kodi freeze...

On Kodi 19.5 I used to use "The TVDB (new)" scraper and then later on I have started using "The TVDB v4" TV scraper. Together with "Light IMDb Ratings Update" add-on it used to work correctly.
When I did a fresh install of CoreELEC with Kodi 20 I have also installed "TVDB v4 TV" scraper. Apparently this is the root cause of the issue.
This time I installed CoreELEC with Kodi 20 but did not installed "TVDB v4 TV" leaving default Kodi's "TMDb TV Shows" scraper and setting it as information provider on the folder with my TV series.
When using "TMDb TV Shows" "Light IMDb Ratings Update" add-on is not needed as "TMDb TV Shows" scraper read ratings by default.
So far no more issues with hundreds of lines with UpdateDetailsForMovie: Finished updates for movie
Thanks for the update. It is anyway strange to me how a scraper related to TV shows can trigger a DB update for the movies...I would suggest to post the issue in the related thread and see if there is anyone else with this issue.

In addition, I want just to highlight that even if "TMDb TV Shows" scraper retrieves the IMDb ratings, it does just when it adds a new content to the database. If you would like to keep the ratings updated, so "Light IMDb Ratings Update" is the way to do that.

Have a great weekend!
Light IMDb Ratings Update - Keep updated the IMDb ratings for your movies and TV shows.
In case you found useful my work, feel free to offer me a cappuccino!
Reply
#23
I can't see how a scraper is updating the library. It just can't, it does not work that way.
Scrapers are just an interface between Kodi and the web. All it does is download data.
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
#24
Yes, to me it looks weird too but this is what I was able to conclude making enormous tests with different scenarios with different add-ons installed and removed.
Maybe someone can reproduce this issue in the following way:
1. Install and use "TVDB v4 TV" as the information provider for the folder with TV shows in Kodi 19.5. MariaDB database with library on external NAS.
2. Copy advancedsettings.xml and sources.xml
3. Install fresh Kodi 20.
4. Restore advancedsettings.xml and sources.xml
5. Reboot. At the boot up "Database migration in progress - please wait..." information on the screen should appear.
6. Install "TVDB v4 TV" add-on.
7. Verify "TVDB v4 TV" is still information provider for your TV shows folder.
8. Potentially UpdateDetailsForMovie: Finished updates for movie lines will start appearing in kodi.log, maybe when some actions on DB are invoked like scan for new content, read IMDb rating using "Light IMDb Ratings Update" add-on...

@Karellen what can be a trigger for updating the library? As I confirmed library db migration is initiated at device restart / Kodi start - see point 5. So what else might trigger this?
PS. Of course asking for what else I mean something else than typical Update library action...
Reply
#25
@rafikW

I can't replicate your setup as I don't use a shared library.

Can you provide another log that captures the issue and enable the following Components...
The libcURL library
JSON-RPC requests
The libCEC library
The Database component
Announce Logging
https://kodi.wiki/view/Log_file/Easy#Ena...ic_logging

Hopefully something in those libraries captures the call to update the library.

I have split off your threads and moved them into the Linux forum as, at this stage, I can't see it being a LightIMDB issue.

Maybe @Klojum or @black_eagle might have a clue?
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
#26
(2023-02-11, 22:24)Karellen Wrote: might have a clue?

Let's await the new debug kodi.log first..?
Reply
#27
@Karellen Sorry I can't share more debug logs right now as I have wiped/removed all SD cards with Kodi not working but left one CoreELEC tar backup file with Kodi 19.5 so maybe tomorrow I'll have time to reproduce the problem by following my steps what i did at first which led me to this problem...
Reply
#28
Well, I'd like to see a fresh debug log (wiki) with that extra logging enabled to make a final determination, but what I can say from the original debug log is that it is not the lightimdb ratings update addon that keeps updating the db, but something to do with Kodi core.  I can say this with certainty because the addon is running in a different thread to the thread doing the updates.

In the debug log, the thread ID for the addon doing it's stuff is 4243.  You can see it starting up in the snippet below.
xml:
2023-02-08 17:51:35.943 T:4243 debug <general>: Thread LanguageInvoker start, auto delete: false
2023-02-08 17:51:35.945 T:4243 debug <general>: initializing python engine.
2023-02-08 17:51:35.946 T:4243 debug <general>: CPythonInvoker(7, /storage/.kodi/addons/script.light.imdb.ratings.update/context.py): start processing
2023-02-08 17:51:37.237 T:4217 debug <general>: connect replacing configured host 192.168.1.119 with resolved host 192.168.1.119
2023-02-08 17:51:37.247 T:4243 debug <general>: -->Python Interpreter Initialized<--
2023-02-08 17:51:37.247 T:4243 debug <general>:
2023-02-08 17:51:37.247 T:4243 debug <general>: CPythonInvoker(7, /storage/.kodi/addons/script.light.imdb.ratings.update/context.py): the source file to load is "/storage/.kodi/addons/script.light.imdb.ratings.update/context.py"
2023-02-08 17:51:37.247 T:4243 debug <general>: CPythonInvoker(7): default python path:

Notice that also in that snippet, Kodi prints a message regarding replacing the configured host with the resolved host. This is a core operation and the thread ID is 4217.

Later on part of the log looks like this
xml:
2023-02-08 17:51:45.971 T:4217 debug <general>: connect replacing configured host 192.168.1.119 with resolved host 192.168.1.119
2023-02-08 17:51:59.264 T:4217 info <general>: Skipped 5 duplicate messages..
2023-02-08 17:51:59.264 T:4217 debug <general>: connect replacing configured host 192.168.1.119 with resolved host 192.168.1.119
2023-02-08 17:51:59.784 T:4217 info <general>: Skipped 3 duplicate messages..
2023-02-08 17:51:59.784 T:4217 info <general>: UpdateDetailsForMovie: Starting updates for movie 2612
2023-02-08 17:51:59.785 T:4217 debug <general>: Mysql Start transaction
2023-02-08 17:51:59.785 T:4217 debug <general>: Mysql execute: UPDATE movie SET c00='12 Angry Men',c01='The defense and the prosecution have rested and the jury is filing into the jury room to decide if a young Spanish-American is guilty or innocent of murdering his father. What begins as an open and shut case soon becomes a mini-drama of each of the jurors\' prejudices and preconceptions about the trial, the accused, and each other.',c02='',c03='Life is in their hands. Death is on their minds.',c05='64435',c06='Reginald Rose',c08='<thumb spoof=\"\" cache=\"\" aspect=\"poster\" preview=\"\">https://assets.fanart.tv/fanart/movies/389/movieposter/12-angry-men-60180a6532efb.jpg</thumb><thumb spoof=\"\" , userrating = NULL, premiered = '1957-04-10' where idMovie=2612
2023-02-08 17:51:59.788 T:4217 debug <general>: Mysql commit transaction
2023-02-08 17:51:59.791 T:4217 info <general>: UpdateDetailsForMovie: Finished updates for movie 2612

Looking again at the thread ID, it is 4217 which is clearly a core thread not an addon thread.  From the log I can't say what is triggering the updates, but its most definitely not an addon.
@Klojum , @Karellen FYI.
Learning Linux the hard way !!
Reply
#29
I tried to reproduce the issue following steps I made in #24 but result is that the "info <general>: UpdateDetailsForMovie: Starting updates for movie 2811" is not initiating...
I spend enormous hours on not having impacting my Kodi device with this issue finally achieving ny goal so I will abandon further investigation.
Sorry, maybe I made an alarm too fast but as you can see in the whole thread and seeing the logs I pasted, you could understand I was in desperate mode :-)
Reply

Logout Mark Read Team Forum Stats Members Help
MySQL keeps updating movies0