7.9 Problems/Bugs

[JJZolx]

Here's a fairly significant new problem. I've updated to the latest rev of 7.9 and removed the tweak database plugin. I stopped the server, deleted everything in the cache, then restarted. The server fails to scan the library and scanner.log shows the following:

[14-05-10 02:44:33.7133] main::main (202) Starting Logitech Media Server scanner (v7.9.0, TRUNK, UNKNOWN) perl 5.014001
[14-05-10 02:44:34.4477] Slim::Schema::forceCommit (2109) Warning: Trying to commit transactions before DB is initialized!
[14-05-10 02:44:35.1040] Slim::Utils::DbCache::_init_db (275) Warning: DBD::SQLite::db do failed: SQL logic error or missing database
cannot VACUUM from within a transaction at C:/Program Files (x86)/Logitech Media Server 7.9/server/Slim/Utils/DbCache.pm line 243.
Delete the file C:\ProgramData\Squeeze\70\cache\artwork.db and start from scratch.
[14-05-10 02:45:08.0571] main::main (298) Warning: Issuing rollback() due to DESTROY without explicit disconnect() of DBD::SQLite::db handle dbname=C:\ProgramData\Squeeze\70\cache\artwork.db at C:/Program Files (x86)/Logitech Media Server 7.9/server/scanner.pl line 298.
[14-05-10 02:45:08.0574] main::main (298) Warning: Issuing rollback() due to DESTROY without explicit disconnect() of DBD::SQLite::db handle dbname=C:\ProgramData\Squeeze\70\cache\artwork.db at C:/Program Files (x86)/Logitech Media Server 7.9/server/scanner.pl line 298.
[14-05-10 02:45:08.0580] main::main (301) Error: Failed when calling Slim::Schema->wipeAllData: [Unable to read/create C:\ProgramData\Squeeze\70\cache\artwork.db]
[14-05-10 02:45:08.0583] main::main (302) Error: This is a fatal error. Exiting

I can manually run a full wipe and rescan after this and the library is scanned successfully, with scanner.log showing no errors.

[mherger]

Thanks a lot for that report! Hmm... might be the scanner is launched before the server is opening that file for the first time. Will fix this asap.

[mherger]

> Here's a fairly significant new problem. I've updated to the latest rev
> of 7.9 and removed the tweak database plugin. I stopped the server,
> deleted everything in the cache, then restarted. The server fails to
> scan the library and scanner.log shows the following:

I haven't been able to reproduce this issue. I removed all *.db files
from the cache folder, started LMS, scanned without any problem. I still
re-arranged the statements in that area a bit. Could you please try to
reproduce? Thanks!

--

Michael

[JJZolx]

I haven't updated yet. I'm trying it again with whatever version I had from yesterday.

Yep, same failure.

[14-05-12 06:55:40.9070] main::main (202) Starting Logitech Media Server scanner (v7.9.0, TRUNK, UNKNOWN) perl 5.014001
[14-05-12 06:55:41.5320] Slim::Schema::forceCommit (2109) Warning: Trying to commit transactions before DB is initialized!
[14-05-12 06:55:42.1570] Slim::Utils::DbCache::_init_db (275) Warning: DBD::SQLite::db do failed: SQL logic error or missing database cannot VACUUM from within a transaction at C:/Program Files (x86)/Logitech Media Server 7.9/server/Slim/Utils/DbCache.pm line 243.
Delete the file C:\ProgramData\Squeeze\70\cache\artwork.db and start from scratch.
[14-05-12 06:56:15.0788] main::main (298) Warning: Issuing rollback() due to DESTROY without explicit disconnect() of DBD::SQLite::db handle dbname=C:\ProgramData\Squeeze\70\cache\artwork.db at C:/Program Files (x86)/Logitech Media Server 7.9/server/scanner.pl line 298.
[14-05-12 06:56:15.0791] main::main (298) Warning: Issuing rollback() due to DESTROY without explicit disconnect() of DBD::SQLite::db handle dbname=C:\ProgramData\Squeeze\70\cache\artwork.db at C:/Program Files (x86)/Logitech Media Server 7.9/server/scanner.pl line 298.
[14-05-12 06:56:15.0798] main::main (301) Error: Failed when calling Slim::Schema->wipeAllData: [Unable to read/create C:\ProgramData\Squeeze\70\cache\artwork.db]
[14-05-12 06:56:15.0801] main::main (302) Error: This is a fatal error. Exiting

I'll let you know what happens after updating.

[JJZolx]

Same results after updating.

[mherger]

Do you see any related errors in server.log around the same time? And you are running from the source, aren't you?

[JJZolx]

Do you see any related errors in server.log around the same time? And you are running from the source, aren't you?

No, just the usual messages when started with no database.

[14-05-12 07:06:28.4696] main::init (368) Starting Logitech Media Server (v7.9.0, TRUNK, UNKNOWN) perl 5.014001
[14-05-12 07:06:29.7978] Slim::Utils::SQLiteHelper::postConnect (370) Optimizing DB because of missing or empty sqlite_stat1 table
[14-05-12 07:06:29.8043] Slim::Schema::forceCommit (2109) Warning: Trying to commit transactions before DB is initialized!
[14-05-12 07:06:29.8146] Slim::Schema::init (162) Warning: Creating new database - empty, outdated or invalid database found
[14-05-12 07:06:30.4065] main::checkDataSource (1092) Warning: Schema updated or no media found in the database, initiating scan.
[14-05-12 07:07:05.7912] Slim::Utils::SQLiteHelper::postConnect (370) Optimizing DB because of missing or empty sqlite_stat1 table
[14-05-12 07:07:05.7976] Slim::Schema::forceCommit (2109) Warning: Trying to commit transactions before DB is initialized!

Yes, I'm running from the source. Just to be sure it wasn't another oddball issue with running the Perl code as a Windows service, I tried it both as a service and a user process. Same results.

FWIW, the latest 7.8.1 has no problems starting and scanning with an empty cache.

[jarome]

Same results after updating.

It could be a problem with your C drive or its permissions

[Zebran]

Using the latest nightly 7.9.0-1402991900 if I choose an album from WiMP the tracks don't load. The music plays fine and you can skip between tracks but the tracks don't show up in the right hand pane of LMS. If I add a track to the end of an album the track list shows up. No problem with local library nor with Triodes spotify plugin.

Thank you for keeping the good work up.

/Z

[get.amped]

I'm not sure what I should be seeing in the browse list when "Album Artists", "Artists" and "All Artists" are checked in the Additional Browse settings. Does the "Artists" option actually do anything? I only see "Album Artists" and "All Artists" listed. If I uncheck "Album Artists" I only have "All Artists" listed. I don't actually have any ALBUMARTIST tags in any of the files.