PDA

View Full Version : Upgraded to 6.5.2 and not all albums being found!



dweezil
2007-05-26, 01:52
Weird problem. Installed 6.5.2 and did a rescan of everything.

Some Tom Waits albums (that were listed with 6.5.1) are not listed under Tom Waits. If I search by album they are listed (as by Tom Waits).

So why are they not listed under Tom Waits?

They are in a sub folder, i.e. Tom Waits\<album name>

The tags are all ID3v2.3 and ALL correct according to Tag & Rename.

I have deleted the SlimServer cache and done a rescan but it's the same.

ANY IDEAS?

HELP!

chrisla
2007-05-26, 02:09
Your Tom Waits albums are hanging out with my missing Johny Cash and Garbage
albums...

I am seeing similar problems.

I've tried a complete re-install as well as a wipe and rescan. I even
restored all of my albums from a backup as a sanity check.

VERSION INFO

SlimServer Version: 6.5.2 - 12047 - RedHat - EN - utf8
Server IP address: 10.0.0.61
Perl Version: 5.8.6 i386-linux-thread-multi
MySQL Version: 5.0.21-standard

Lots of both of these in the log:

substr outside of string at /usr/local/slimserver/lib/MP3/Info.pm line 2017,
<$fh> line 1.
Use of uninitialized value in division (/) at
/usr/local/slimserver/lib/MP3/Info.pm line 693, <$fh> line 1.
Use of uninitialized value in substr at
/usr/local/slimserver/lib/MP3/Info.pm line 696, <$fh> line 1.
Use of uninitialized value in substr at
/usr/local/slimserver/lib/MP3/Info.pm line 696, <$fh> line 1.
Size mismatch on 1CEB
at /usr/local/slimserver/Slim/Formats/MP3.pm line 132
Size mismatch on 9F97
at /usr/local/slimserver/Slim/Formats/MP3.pm line 132
Size mismatch on C558
at /usr/local/slimserver/Slim/Formats/MP3.pm line 132
Size mismatch on 954E
at /usr/local/slimserver/Slim/Formats/MP3.pm line 132
Size mismatch on 61FA
at /usr/local/slimserver/Slim/Formats/MP3.pm line 132
Size mismatch on 1 00
at /usr/local/slimserver/Slim/Formats/MP3.pm line 132
My spouse is going to kill me if I don't get this figured soon, help indeed.

-Chris

On 5/26/07, dweezil <dweezil.2r6n5n1180169701 (AT) no-mx (DOT) forums.slimdevices.com>
wrote:
>
>
> Weird problem. Installed 6.5.2 and did a rescan of everything.
>
> Some Tom Waits albums (that were listed with 6.5.1) are not listed
> under Tom Waits. If I search by album they are listed (as by Tom
> Waits).
>
> So why are they not listed under Tom Waits?
>
> They are in a sub folder, i.e. Tom Waits\<album name>
>
> The tags are all ID3v2.3 and ALL correct according to Tag & Rename.
>
> I have deleted the SlimServer cache and done a rescan but it's the
> same.
>
> ANY IDEAS?
>
> HELP!
>
>
> --
> dweezil
> ------------------------------------------------------------------------
> dweezil's Profile: http://forums.slimdevices.com/member.php?userid=11732
> View this thread: http://forums.slimdevices.com/showthread.php?t=35604
>
>

dweezil
2007-05-26, 05:41
2007-05-26 10:33:59.2187 Import: Starting mergeVariousArtistsAlbums().
2007-05-26 10:33:59.9843 ERROR: Error executing 'SELECT me.id, me.url, me.content_type, me.title, me.titlesort, me.titlesearch, me.album, me.tracknum, me.timestamp, me.filesize, me.disc, me.thumb, me.remote, me.audio, me.audio_size, me.audio_offset, me.year, me.secs, me.cover, me.vbr_scale, me.bitrate, me.samplerate, me.samplesize, me.channels, me.block_alignment, me.endian, me.bpm, me.tagversion, me.drm, me.moodlogic_id, me.moodlogic_mixable, me.musicmagic_mixable, me.musicbrainz_id, me.playcount, me.lastplayed, me.lossless, me.lyrics, me.rating, me.replay_gain, me.replay_peak, contributorTracks.role, contributorTracks.contributor, contributorTracks.track FROM tracks me LEFT JOIN contributor_track contributorTracks ON ( contributorTracks.track = me.id ) WHERE ( ( ( contributorTracks.role = ? ) AND ( me.album = ? ) ) ) ORDER BY contributorTracks.track': DBD::mysql::st execute failed: Can't create/write to file 'C:\WINDOWS\TEMP\#sql_15f4_0.MYD' (Errcode: 13) at C:\program files\slimserver\server\CPAN/DBIx/Class/Storage/DBI.pm line 771.

2007-05-26 10:33:59.9849 ERROR: Backtrace follows:

2007-05-26 10:33:59.9854 Backtrace:

frame 0: Slim::Schema::Storage::throw_exception (C:\program files\slimserver\server\CPAN/DBIx/Class/Storage/DBI.pm line 773)
frame 1: DBIx::Class::Storage::DBI::_execute (C:\program files\slimserver\server\CPAN/DBIx/Class/Storage/DBI.pm line 826)
frame 2: DBIx::Class::Storage::DBI::_select (C:\program files\slimserver\server\CPAN/DBIx/Class/Storage/DBI/Cursor.pm line 79)
frame 3: DBIx::Class::Storage::DBI::Cursor::next (C:\program files\slimserver\server\CPAN/DBIx/Class/ResultSet.pm line 701)
frame 4: DBIx::Class::ResultSet::next (/PerlApp/Slim/Schema.pm line 1210)
frame 5: Slim::Schema::mergeVariousArtistsAlbums (/PerlApp/Slim/Music/Import.pm line 312)
frame 6: Slim::Music::Import::runScanPostProcessing (scanner.pl line 192)
frame 7: main::__ANON__ (/PerlApp/DBIx/Class/Schema.pm line 584)
frame 8: (eval) (/PerlApp/DBIx/Class/Schema.pm line 572)
frame 9: DBIx::Class::Schema::txn_do (scanner.pl line 192)
frame 10: (eval) (scanner.pl line 192)
frame 11: main::main (scanner.pl line 312)

2007-05-26 10:34:00.3614 ERROR: Carp::Clan::__ANON__(): Error executing 'SELECT me.id, me.url, me.content_type, me.title, me.titlesort, me.titlesearch, me.album, me.tracknum, me.timestamp, me.filesize, me.disc, me.thumb, me.remote, me.audio, me.audio_size, me.audio_offset, me.year, me.secs, me.cover, me.vbr_scale, me.bitrate, me.samplerate, me.samplesize, me.channels, me.block_alignment, me.endian, me.bpm, me.tagversion, me.drm, me.moodlogic_id, me.moodlogic_mixable, me.musicmagic_mixable, me.musicbrainz_id, me.playcount, me.lastplayed, me.lossless, me.lyrics, me.rating, me.replay_gain, me.replay_peak, contributorTracks.role, contributorTracks.contributor, contributorTracks.track FROM tracks me LEFT JOIN contributor_track contributorTracks ON ( contributorTracks.track = me.id ) WHERE ( ( ( contributorTracks.role = ? ) AND ( me.album = ? ) ) ) ORDER BY contributorTracks.track': DBD::mysql::st execute failed: Can't create/write to file 'C:\WINDOWS\TEMP\#sql_15f4_0.MYD' (Errcode: 13) at C:\program files\slimserver\server\CPAN/DBIx/Class/Storage/DBI.pm line 771.

2007-05-26 10:34:00.3620 ERROR: Backtrace follows:

2007-05-26 10:34:00.3624 Backtrace:

frame 0: Slim::Schema::throw_exception (/PerlApp/DBIx/Class/Schema.pm line 606)
frame 1: DBIx::Class::Schema::txn_do (scanner.pl line 192)
frame 2: (eval) (scanner.pl line 192)
frame 3: main::main (scanner.pl line 312)

WilCox
2007-05-26, 07:00
I had the same problem with lost artists and lost albums. Apparently, this is a known problem with the 6.5.2 release. I downloaded yesterday's nightly 6.5.3, installed and rescanned and there were all my missing artists/albums! My guess is that we will see an official 6.5.3 release fairly soon.

dweezil
2007-05-26, 08:45
Well not till at least Tuesday but at least the nightly build is good! Will try soon...Thanks for the info

dweezil
2007-05-26, 10:56
Tried last nights build and albums are back but still get an error...

2007-05-26 18:53:32.5781 Import: Starting mergeVariousArtistsAlbums().
2007-05-26 18:53:33.4218 ERROR: Error executing 'SELECT me.id, me.url, me.content_type, me.title, me.titlesort, me.titlesearch, me.album, me.tracknum, me.timestamp, me.filesize, me.disc, me.thumb, me.remote, me.audio, me.audio_size, me.audio_offset, me.year, me.secs, me.cover, me.vbr_scale, me.bitrate, me.samplerate, me.samplesize, me.channels, me.block_alignment, me.endian, me.bpm, me.tagversion, me.drm, me.musicmagic_mixable, me.musicbrainz_id, me.playcount, me.lastplayed, me.lossless, me.lyrics, me.rating, me.replay_gain, me.replay_peak, contributorTracks.role, contributorTracks.contributor, contributorTracks.track FROM tracks me LEFT JOIN contributor_track contributorTracks ON ( contributorTracks.track = me.id ) WHERE ( ( ( contributorTracks.role = ? ) AND ( me.album = ? ) ) ) ORDER BY contributorTracks.track': DBD::mysql::st execute failed: Can't create/write to file 'C:\WINDOWS\TEMP\#sql_bbc_0.MYD' (Errcode: 13) at C:\program files\slimserver\server\CPAN/DBIx/Class/Storage/DBI.pm line 771.

2007-05-26 18:53:33.4227 ERROR: Backtrace follows:

2007-05-26 18:53:33.4233 Backtrace:

frame 0: Slim::Schema::Storage::throw_exception (C:\program files\slimserver\server\CPAN/DBIx/Class/Storage/DBI.pm line 773)
frame 1: DBIx::Class::Storage::DBI::_execute (C:\program files\slimserver\server\CPAN/DBIx/Class/Storage/DBI.pm line 826)
frame 2: DBIx::Class::Storage::DBI::_select (C:\program files\slimserver\server\CPAN/DBIx/Class/Storage/DBI/Cursor.pm line 79)
frame 3: DBIx::Class::Storage::DBI::Cursor::next (C:\program files\slimserver\server\CPAN/DBIx/Class/ResultSet.pm line 701)
frame 4: DBIx::Class::ResultSet::next (/PerlApp/Slim/Schema.pm line 1212)
frame 5: Slim::Schema::mergeVariousArtistsAlbums (/PerlApp/Slim/Music/Import.pm line 312)
frame 6: Slim::Music::Import::runScanPostProcessing (scanner.pl line 186)
frame 7: main::__ANON__ (/PerlApp/DBIx/Class/Schema.pm line 584)
frame 8: (eval) (/PerlApp/DBIx/Class/Schema.pm line 572)
frame 9: DBIx::Class::Schema::txn_do (scanner.pl line 186)
frame 10: (eval) (scanner.pl line 186)
frame 11: main::main (scanner.pl line 304)

2007-05-26 18:53:33.8305 ERROR: Carp::Clan::__ANON__(): Error executing 'SELECT me.id, me.url, me.content_type, me.title, me.titlesort, me.titlesearch, me.album, me.tracknum, me.timestamp, me.filesize, me.disc, me.thumb, me.remote, me.audio, me.audio_size, me.audio_offset, me.year, me.secs, me.cover, me.vbr_scale, me.bitrate, me.samplerate, me.samplesize, me.channels, me.block_alignment, me.endian, me.bpm, me.tagversion, me.drm, me.musicmagic_mixable, me.musicbrainz_id, me.playcount, me.lastplayed, me.lossless, me.lyrics, me.rating, me.replay_gain, me.replay_peak, contributorTracks.role, contributorTracks.contributor, contributorTracks.track FROM tracks me LEFT JOIN contributor_track contributorTracks ON ( contributorTracks.track = me.id ) WHERE ( ( ( contributorTracks.role = ? ) AND ( me.album = ? ) ) ) ORDER BY contributorTracks.track': DBD::mysql::st execute failed: Can't create/write to file 'C:\WINDOWS\TEMP\#sql_bbc_0.MYD' (Errcode: 13) at C:\program files\slimserver\server\CPAN/DBIx/Class/Storage/DBI.pm line 771.

2007-05-26 18:53:33.8311 ERROR: Backtrace follows:

2007-05-26 18:53:33.8315 Backtrace:

frame 0: Slim::Schema::throw_exception (/PerlApp/DBIx/Class/Schema.pm line 606)
frame 1: DBIx::Class::Schema::txn_do (scanner.pl line 186)
frame 2: (eval) (scanner.pl line 186)
frame 3: main::main (scanner.pl line 304)

kdf
2007-05-26, 11:04
On 26-May-07, at 10:56 AM, dweezil wrote:

>
> Tried last nights build and albums are back but still get an error...
>
>
> contributorTracks.track': DBD::mysql::st execute failed: Can't
> create/write to file 'C:\WINDOWS\TEMP\#sql_bbc_0.MYD' (Errcode: 13) at
> C:\program files\slimserver\server\CPAN/DBIx/Class/Storage/DBI.pm line
> 7

check your virus scanner settings. ignore *.MYI and *.MYD files.

-kdf

dweezil
2007-05-26, 11:25
Thats well and good but what if there are viruses in those files :-(

dweezil
2007-05-26, 11:34
NOPE STILL NO GO!

2007-05-26 19:35:55.3906 Import: Starting mergeVariousArtistsAlbums().
2007-05-26 19:36:06.3593 ERROR: Error executing 'SELECT me.id, me.url, me.content_type, me.title, me.titlesort, me.titlesearch, me.album, me.tracknum, me.timestamp, me.filesize, me.disc, me.thumb, me.remote, me.audio, me.audio_size, me.audio_offset, me.year, me.secs, me.cover, me.vbr_scale, me.bitrate, me.samplerate, me.samplesize, me.channels, me.block_alignment, me.endian, me.bpm, me.tagversion, me.drm, me.musicmagic_mixable, me.musicbrainz_id, me.playcount, me.lastplayed, me.lossless, me.lyrics, me.rating, me.replay_gain, me.replay_peak, contributorTracks.role, contributorTracks.contributor, contributorTracks.track FROM tracks me LEFT JOIN contributor_track contributorTracks ON ( contributorTracks.track = me.id ) WHERE ( ( ( contributorTracks.role = ? ) AND ( me.album = ? ) ) ) ORDER BY contributorTracks.track': DBD::mysql::st execute failed: Can't create/write to file 'C:\WINDOWS\TEMP\#sql_bbc_0.MYI' (Errcode: 13) at C:\program files\slimserver\server\CPAN/DBIx/Class/Storage/DBI.pm line 771.

2007-05-26 19:36:06.3593 ERROR: Backtrace follows:

2007-05-26 19:36:06.3599 Backtrace:

frame 0: Slim::Schema::Storage::throw_exception (C:\program files\slimserver\server\CPAN/DBIx/Class/Storage/DBI.pm line 773)
frame 1: DBIx::Class::Storage::DBI::_execute (C:\program files\slimserver\server\CPAN/DBIx/Class/Storage/DBI.pm line 826)
frame 2: DBIx::Class::Storage::DBI::_select (C:\program files\slimserver\server\CPAN/DBIx/Class/Storage/DBI/Cursor.pm line 79)
frame 3: DBIx::Class::Storage::DBI::Cursor::next (C:\program files\slimserver\server\CPAN/DBIx/Class/ResultSet.pm line 701)
frame 4: DBIx::Class::ResultSet::next (/PerlApp/Slim/Schema.pm line 1212)
frame 5: Slim::Schema::mergeVariousArtistsAlbums (/PerlApp/Slim/Music/Import.pm line 312)
frame 6: Slim::Music::Import::runScanPostProcessing (scanner.pl line 186)
frame 7: main::__ANON__ (/PerlApp/DBIx/Class/Schema.pm line 584)
frame 8: (eval) (/PerlApp/DBIx/Class/Schema.pm line 572)
frame 9: DBIx::Class::Schema::txn_do (scanner.pl line 186)
frame 10: (eval) (scanner.pl line 186)
frame 11: main::main (scanner.pl line 304)

2007-05-26 19:36:06.7505 ERROR: Carp::Clan::__ANON__(): Error executing 'SELECT me.id, me.url, me.content_type, me.title, me.titlesort, me.titlesearch, me.album, me.tracknum, me.timestamp, me.filesize, me.disc, me.thumb, me.remote, me.audio, me.audio_size, me.audio_offset, me.year, me.secs, me.cover, me.vbr_scale, me.bitrate, me.samplerate, me.samplesize, me.channels, me.block_alignment, me.endian, me.bpm, me.tagversion, me.drm, me.musicmagic_mixable, me.musicbrainz_id, me.playcount, me.lastplayed, me.lossless, me.lyrics, me.rating, me.replay_gain, me.replay_peak, contributorTracks.role, contributorTracks.contributor, contributorTracks.track FROM tracks me LEFT JOIN contributor_track contributorTracks ON ( contributorTracks.track = me.id ) WHERE ( ( ( contributorTracks.role = ? ) AND ( me.album = ? ) ) ) ORDER BY contributorTracks.track': DBD::mysql::st execute failed: Can't create/write to file 'C:\WINDOWS\TEMP\#sql_bbc_0.MYI' (Errcode: 13) at C:\program files\slimserver\server\CPAN/DBIx/Class/Storage/DBI.pm line 771.

2007-05-26 19:36:06.7511 ERROR: Backtrace follows:

2007-05-26 19:36:06.7515 Backtrace:

frame 0: Slim::Schema::throw_exception (/PerlApp/DBIx/Class/Schema.pm line 606)
frame 1: DBIx::Class::Schema::txn_do (scanner.pl line 186)
frame 2: (eval) (scanner.pl line 186)
frame 3: main::main (scanner.pl line 304)

kdf
2007-05-26, 11:45
On 26-May-07, at 11:25 AM, dweezil wrote:

>
> Thats well and good but what if there are viruses in those files :-(
>
there wont be. they are not executable and they are only created by
the mysql process and then they go away.
they cannot, however, be locked by another process when mysql expects
to be using them. virusscanners or other "protection" software
does not play well. Usually excluding works, but if you have any other
system protection apps, turn them off until you find the one causing
the problems.
-kdf

LewisT
2007-05-27, 07:40
Happening to me too. All of my Peter Gabriel albums aren't showing up. I'll try a nightly and see if that fixes things.

dweezil
2007-05-27, 08:21
The previous nights build was better but the VA stuff is still patch

dweezil
2007-05-28, 05:51
Any news anyone? VA stuff still causing errors and not listing correctly :-(

mudbone
2007-05-28, 06:37
You may have missed this post:

http://forums.slimdevices.com/showpost.php?p=204707&postcount=17

in the other thread.

It's a holiday weekend.

Dave-

LewisT
2007-05-28, 09:04
Last nights build fixed the problem for me. Thanks.

dweezil
2007-05-28, 10:32
WOAH!

Last nights build fixed it for me too!

LOVE 'EM!