[Announce] Use Comment Tag Info

[mamema]

something isn't right.....
as i've activated this plugin without doing other changes, since weeks, i would say my problem seems to be this plugin.

i have this in the logs:


[21-11-15 06:53:16.6351] Slim::Plugin::Extensions::Plugin::_noResponse (476) error fetching https://www.nexus0.net/pub/sw/lmsannounce/repo.xml - Connect timed out: Transport endpoint is not connected

[21-11-15 06:53:38.1918] Slim::Networking::IO::Select::__ANON__ (130) Error: Select task failed calling Slim::Web::HTTP:rocessHTTP: DBIx::Class::Storage:BI::__ANON__(): DBI Exception: DBD::SQLite::db prepare_cached failed: attempt to fetch on inactive database handle at /lms/Slim/Music/Import.pm line 746

; fh=Slim::Web::HTTP::ClientConn=GLOB(0x55bd25d473d0 )

[21-11-15 06:53:45.3226] Slim::Control::Request::execute (1888) Error: While trying to run function coderef [Slim::Control::Queries::serverstatusQuery]: [DBIx::Class::Storage:BI::__ANON__(): DBI Exception: DBD::SQLite::db prepare_cached failed: attempt to fetch on inactive database handle at /lms/Slim/Music/Import.pm line 746


and LMS isn't responive at all.

i've get this every morning, so i guess it has something to do with the nightly update scan.
I must say, that i have a quite large library.... 85.000 files.....
After restarting LMS, a db scan is triggered and after the scan LMS is working again.

[AF1]

something isn't right.....
as i've activated this plugin without doing other changes, since weeks, i would say my problem seems to be this plugin.

i have this in the logs:


[21-11-15 06:53:16.6351] Slim::Plugin::Extensions::Plugin::_noResponse (476) error fetching https://www.nexus0.net/pub/sw/lmsannounce/repo.xml - Connect timed out: Transport endpoint is not connected

[21-11-15 06:53:38.1918] Slim::Networking::IO::Select::__ANON__ (130) Error: Select task failed calling Slim::Web::HTTP:rocessHTTP: DBIx::Class::Storage:BI::__ANON__(): DBI Exception: DBD::SQLite::db prepare_cached failed: attempt to fetch on inactive database handle at /lms/Slim/Music/Import.pm line 746

; fh=Slim::Web::HTTP::ClientConn=GLOB(0x55bd25d473d0 )

[21-11-15 06:53:45.3226] Slim::Control::Request::execute (1888) Error: While trying to run function coderef [Slim::Control::Queries::serverstatusQuery]: [DBIx::Class::Storage:BI::__ANON__(): DBI Exception: DBD::SQLite::db prepare_cached failed: attempt to fetch on inactive database handle at /lms/Slim/Music/Import.pm line 746


and LMS isn't responive at all.

i've get this every morning, so i guess it has something to do with the nightly update scan.
I must say, that i have a quite large library.... 85.000 files.....
After restarting LMS, a db scan is triggered and after the scan LMS is working again.

The most important question: if you uninstall this plugin (UCTI) does LMS behave normal and stop being unresponsive in the morning?

The first message seems to be a networking problem ("Connect timed out"...) which may be related to the unreponsiveness but probably not to UCTI.

The importer related messages are simply saying: some plugin like UCTI is asking the server if there's an active scanning process but the server can't get this information at the moment because the "database handle" is "inactive". That happens if you restart and immediately trigger a rescan (with the help of some plugin or script), and maybe did a database wipe before. UCTI only asks for this information (stillscanning) when it registers title formats or displays track information (song details page).

So please check the (timestamps of the) log messages before you restart LMS (with the auto-rescan).

And then do your restart/rescan and check the log messages and their timestamp again. Do the importer related messages only show up after the restart/rescan? Do you have a plugin/script enabled that triggers a rescan after every restart? (Plugin updates requires restarts as well.)

Considering that other UCTI users have enabled auto-updating too and haven't reported such a behavior (unresponsive) I'm not convinced that UCTI on its own should have such a terrible effect on your LMS. And I haven't been able to reproduce this so far either.

[mamema]

i've try to deliver better logs. I've disabled your plugin, and everything went back to normal. No problems as described above.
Perhaps it isn't your plugin alone, but a combination of my other running plugins. A wild guess: i've also plugins like custom scan, trackstat, db optimizer running.....
so, now i've reactivated your plugin, trying to get better logs

[AF1]

Do you have some plugin or script that automatically triggers a database rescan (clear/wipe or only looking for new media?) after every LMS restart? If so, why?

I only rescan my library (clear/wipe) after I've added new tracks or if the filename of the existing ones has changed. So in short: not very often at all.
When LMS restarts there are always some plugins that need to interact with the database when they're initializing and if the database is not available (rescan) there might be problems.
So I usually trigger the rescan manually and certainly never together with a LMS restart. Just take a look at everything automated/scheduled.

The usual way to get to the bottom of this would be to disable all plugins (or at least all those that interact with the database and might (b)lock it) and then reenable one by one. It seems that you certainy have a lot more plugins installed/enabled than I have.

BTW how many browse menus/virtual libraries, title formats and such do you have defined/enabled in UCTI?

[kidstypike]

Do you have some plugin or script that automatically triggers a database rescan (clear/wipe or only looking for new media?) after every LMS restart? If so, why?

I only rescan my library (clear/wipe) after I've added new tracks or if the filename of the existing ones has changed. So in short: not very often at all.
When LMS restarts there are always some plugins that need to interact with the database when they're initializing and if the database is not available (rescan) there might be problems.
So I usually trigger the rescan manually and certainly never together with a LMS restart. Just take a look at everything automated/scheduled.

The usual way to get to the bottom of this would be to disable all plugins (or at least all those that interact with the database and might (b)lock it) and then reenable one by one. It seems that you certainy have a lot more plugins installed/enabled than I have.

BTW how many browse menus/virtual libraries, title formats and such do you have defined/enabled in UCTI?

I think the plugin "Simple Library Views" rescans the library after an LMS restart, it used to do. I stopped using it years ago for that very reason.

[mamema]

I think the plugin "Simple Library Views" rescans the library after an LMS restart, it used to do. I stopped using it years ago for that very reason.

not using this plugin.

I have an automatically triggered nightly scan (no erase/full scan - changes only). Why? Because of ongoing changes. :-) running without problems until now.
I can also trigger this via web interface manually, without problems, when UCTI is enabled...... something in the night is happening, which "crashes" LMS. then and only then a database rescan is running after restarting LMS.
during the day, even with manual rescan, i can boot LMS without database rescan happening (UCTI enabled).
As i said: trying to get logs about this nightly problem.....

i have two browse menu searches enabled, which have either two submenus "all albums" and "album artists"

[mamema]

so.......

i have enabled the plugin again, dunno remember if i have made a delete db/full rescan, since first enabling of this plugin. Anyway, after disable/reenable the plugin, the environment is running since two days/nights without issues. So ..... self healing.....

[mamema]

so.......

i have enabled the plugin again, dunno remember if i have made a delete db/full rescan, since first enabling of this plugin. Anyway, after disable/reenable the plugin, the environment is running since two days/nights without issues. So ..... self healing.....

so, i have made more tests, the plugin is immune against library updates, without delete and complete rescan. But if i do a delete/full scan manually and an "nightly change update" automatically afterwards, LMS hangs up and need to be restarted, which then leads to a rescan at boot time.

solution is, and i dunno why, to let the rescan finish. Disable the plugin. Restart, enable the plugin.

Huh, weird...

[AF1]

so, i have made more tests, the plugin is immune against library updates, without delete and complete rescan. But if i do a delete/full scan manually and an "nightly change update" automatically afterwards, LMS hangs up and need to be restarted, which then leads to a rescan at boot time.

solution is, and i dunno why, to let the rescan finish. Disable the plugin. Restart, enable the plugin.

Huh, weird...

Don't know what's going on there. Just in case it should be related in any way to UCTI's (re)building virtual libraries after a restart I've included a check for missing library or active scanning process that should delay this until the rescan is done. Please try version 1.3.6 (not released, GitHub manual install only). Can't think of anything else right now that I can do on the plugin side.

[mamema]

several days without issues with ver. 1.36