Bug 3643 – scanning of WMA files fails

Bug 3643 - scanning of WMA files fails

Summary:

scanning of WMA files fails

Status:	RESOLVED FIXED

Product:	Logitech Media Server
Classification:	Unclassified
Component:	Scanner
Version:	6.5b1
Platform:	PC Windows XP

Importance:	P2 major (vote)
Target Milestone:	---
Assigned To:	Dan Sully

URL:
Keywords:

Depends on:
Blocks:
	Show dependency tree / graph

Reported:	2006-06-27 01:52 UTC by Philip Meyer
Modified:	2008-09-15 14:39 UTC (History)
CC List:	0 users

See Also:
Category:	---

Attachments
A WMA file that is not scanned. (3.69 MB, audio/x-ms-wma) 2006-06-27 13:00 UTC, Philip Meyer	Details
Another wma file that won't scan (3.50 MB, audio/x-ms-wma) 2006-06-27 16:48 UTC, Philip Meyer	Details
View All Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this bug.

Description Philip Meyer 2006-06-27 01:52:17 UTC

DBD::mysql::st execute failed: called with 20 bind variables when 19 are needed at P:\Music\SlimServer\trunk\server\CPAN/DBIx/Class/Storage/DBI.pm line 525.
2006-06-27 09:28:46.2812 Backtrace:

   frame 0: Slim::Schema::newTrack (P:/Music/SlimServer/trunk/server/Slim/Utils/Scanner.pm line 187)
   frame 1: Slim::Utils::Scanner::scanDirectory (P:/Music/SlimServer/trunk/server/Slim/Utils/Scanner.pm line 170)
   frame 2: Slim::Utils::Scanner::scanDirectory (P:\Music\SlimServer\trunk\server/Slim/Music/MusicFolderScan.pm line 64)
   frame 3: Slim::Music::MusicFolderScan::startScan (P:/Music/SlimServer/trunk/server/Slim/Music/Import.pm line 171)
   frame 4: Slim::Music::Import::runImporter (P:/Music/SlimServer/trunk/server/Slim/Music/Import.pm line 93)
   frame 5: Slim::Music::Import::startScan (P:/Music/SlimServer/trunk/server/scanner.pl line 144)
   frame 6: (eval) (P:/Music/SlimServer/trunk/server/scanner.pl line 122)
   frame 7: main::main (P:/Music/SlimServer/trunk/server/scanner.pl line 259)

2006-06-27 09:28:46.2812 ERROR: newTrack: Couldn't create Track for file:///M:/Music/Phil%27s%20Music/Dashboard%20Confessional/The%20Places%20You%20Have%20Come%20To%20Fear%20The%20Most/01%20-%20The%20Brilliant%20Dance.wma : DBIx::Class::ResultSet::create(): Error executing 'INSERT INTO tracks (audio, audio_size, bitrate, channels, content_type, drm, filesize, lossless, rating, remote, samplerate, secs, timestamp, title, titlesearch, titlesort, tracknum, url, vbr_scale, year) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, 0, ?)' (`1', `3674586', `160016', `2', `wma', `0', `3674586', `0', `', `0', `44100', `182.639', `1134926631', `The Brilliant Dance', `BRILLIANT DANCE', `BRILLIANT DANCE', `1', `file:///M:/Music/Phil%27s%20Music/Dashboard%20Confessional/The%20Places%20You%20Have%20Come%20To%20Fear%20The%20Most/01%20-%20The%20Brilliant%20Dance.wma', `0', `2001'): DBD::mysql::st execute failed: called with 20 bind variables when 19 are needed at P:\Music\SlimServer\trunk\server\CPAN/DBIx/Class/Storage/DBI.pm line 525.

Comment 1 Dan Sully 2006-06-27 10:47:57 UTC

Can you please attach the WMA file to the bug?

Thanks

Comment 2 Philip Meyer 2006-06-27 12:37:39 UTC

Sorry, I should have emphasised the problem in the description (I assumed the 
summary to be clear).

ALL wma files are rejected with the error "newTrack: Couldn't create Track ..."

I have looked in my track table, and there's no rows with content_type='wma'.

Previously I believe these were being scanned, so I don't think there's anything
wrong with the tags as such.

Comment 3 Dan Sully 2006-06-27 12:38:40 UTC

Ok. could you still upload a file? As all my WMA files here are working fine.

Thanks

Comment 4 Philip Meyer 2006-06-27 13:00:39 UTC

Created attachment 1289 [details]
A WMA file that is not scanned.

Comment 5 Dan Sully 2006-06-27 14:30:58 UTC

Fixed in change 8161

Comment 6 Philip Meyer 2006-06-27 16:01:07 UTC

Still not working for me, I'm afraid.  I'm getting different errors in the log now:


2006-06-27 23:42:30.6562 Found 6384 files in M:\Music\Phil's Music
DBD::mysql::st execute failed: Incorrect integer value: '' for column 'rating' at row 1 at P:\Music\SlimServer\trunk\server\CPAN/DBIx/Class/Storage/DBI.pm line 525.
2006-06-27 23:46:05.7500 ERROR: Error executing 'INSERT INTO tracks (audio, audio_size, bitrate, channels, content_type, drm, filesize, lossless, rating, remote, samplerate, secs, timestamp, title, titlesearch, titlesort, tracknum, url, vbr_scale, year) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)' (`1', `3674586', `160016', `2', `wma', `0', `3674586', `0', `', `0', `44100', `182.639', `1134926631', `The Brilliant Dance', `BRILLIANT DANCE', `BRILLIANT DANCE', `1', `file:///M:/Music/Phil%27s%20Music/Dashboard%20Confessional/The%20Places%20You%20Have%20Come%20To%20Fear%20The%20Most/01%20-%20The%20Brilliant%20Dance.wma', `0', `2001'): DBD::mysql::st execute failed: Incorrect integer value: '' for column 'rating' at row 1 at P:\Music\SlimServer\trunk\server\CPAN/DBIx/Class/Storage/DBI.pm line 525.

2006-06-27 23:46:05.7501 ERROR: Backtrace follows:

2006-06-27 23:46:05.7505 Backtrace:

   frame 0: Slim::Schema::Storage::throw_exception (P:\Music\SlimServer\trunk\server\CPAN/DBIx/Class/Storage/DBI.pm line 530)
   frame 1: DBIx::Class::Storage::DBI::_execute (P:\Music\SlimServer\trunk\server\CPAN/DBIx/Class/Storage/DBI.pm line 539)
   frame 2: DBIx::Class::Storage::DBI::insert (P:\Music\SlimServer\trunk\server\CPAN/DBIx/Class/Row.pm line 69)
   frame 3: DBIx::Class::Row::insert (P:\Music\SlimServer\trunk\server\CPAN/DBIx/Class/PK/Auto.pm line 43)
   frame 4: DBIx::Class::PK::Auto::insert (P:\Music\SlimServer\trunk\server\CPAN/DBIx/Class/ResultSet.pm line 1054)
   frame 5: DBIx::Class::ResultSet::create (P:\Music\SlimServer\trunk\server/Slim/Schema.pm line 458)
   frame 6: (eval) (P:\Music\SlimServer\trunk\server/Slim/Schema.pm line 458)
   frame 7: Slim::Schema::newTrack (P:/Music/SlimServer/trunk/server/Slim/Utils/Scanner.pm line 187)
   frame 8: Slim::Utils::Scanner::scanDirectory (P:/Music/SlimServer/trunk/server/Slim/Utils/Scanner.pm line 170)
   frame 9: Slim::Utils::Scanner::scanDirectory (P:\Music\SlimServer\trunk\server/Slim/Music/MusicFolderScan.pm line 64)
   frame 10: Slim::Music::MusicFolderScan::startScan (P:/Music/SlimServer/trunk/server/Slim/Music/Import.pm line 171)
   frame 11: Slim::Music::Import::runImporter (P:/Music/SlimServer/trunk/server/Slim/Music/Import.pm line 93)
   frame 12: Slim::Music::Import::startScan (P:/Music/SlimServer/trunk/server/scanner.pl line 144)
   frame 13: (eval) (P:/Music/SlimServer/trunk/server/scanner.pl line 122)
   frame 14: main::main (P:/Music/SlimServer/trunk/server/scanner.pl line 259)

2006-06-27 23:46:05.7509 ERROR: Couldn't insert bitrate => 160016, drm => 0, audio_size => 3674586, vbr_scale => 0, rating => , remote => 0, titlesort => BRILLIANT DANCE, audio => 1, timestamp => 1134926631, url => file:///M:/Music/Phil%27s%20Music/Dashboard%20Confessional/The%20Places%20You%20Have%20Come%20To%20Fear%20The%20Most/01%20-%20The%20Brilliant%20Dance.wma, lossless => 0, channels => 2, samplerate => 44100, secs => 182.639, filesize => 3674586, content_type => wma, tracknum => 1, titlesearch => BRILLIANT DANCE, title => The Brilliant Dance, year => 2001 into tracks
2006-06-27 23:46:05.7509 ERROR: Backtrace follows:

2006-06-27 23:46:05.7512 Backtrace:

   frame 0: Slim::Schema::Storage::throw_exception (P:\Music\SlimServer\trunk\server\CPAN/DBIx/Class/Storage/DBI.pm line 539)
   frame 1: DBIx::Class::Storage::DBI::insert (P:\Music\SlimServer\trunk\server\CPAN/DBIx/Class/Row.pm line 69)
   frame 2: DBIx::Class::Row::insert (P:\Music\SlimServer\trunk\server\CPAN/DBIx/Class/PK/Auto.pm line 43)
   frame 3: DBIx::Class::PK::Auto::insert (P:\Music\SlimServer\trunk\server\CPAN/DBIx/Class/ResultSet.pm line 1054)
   frame 4: DBIx::Class::ResultSet::create (P:\Music\SlimServer\trunk\server/Slim/Schema.pm line 458)
   frame 5: (eval) (P:\Music\SlimServer\trunk\server/Slim/Schema.pm line 458)
   frame 6: Slim::Schema::newTrack (P:/Music/SlimServer/trunk/server/Slim/Utils/Scanner.pm line 187)
   frame 7: Slim::Utils::Scanner::scanDirectory (P:/Music/SlimServer/trunk/server/Slim/Utils/Scanner.pm line 170)
   frame 8: Slim::Utils::Scanner::scanDirectory (P:\Music\SlimServer\trunk\server/Slim/Music/MusicFolderScan.pm line 64)
   frame 9: Slim::Music::MusicFolderScan::startScan (P:/Music/SlimServer/trunk/server/Slim/Music/Import.pm line 171)
   frame 10: Slim::Music::Import::runImporter (P:/Music/SlimServer/trunk/server/Slim/Music/Import.pm line 93)
   frame 11: Slim::Music::Import::startScan (P:/Music/SlimServer/trunk/server/scanner.pl line 144)
   frame 12: (eval) (P:/Music/SlimServer/trunk/server/scanner.pl line 122)
   frame 13: main::main (P:/Music/SlimServer/trunk/server/scanner.pl line 259)

2006-06-27 23:46:05.7524 Backtrace:

   frame 0: Slim::Schema::newTrack (P:/Music/SlimServer/trunk/server/Slim/Utils/Scanner.pm line 187)
   frame 1: Slim::Utils::Scanner::scanDirectory (P:/Music/SlimServer/trunk/server/Slim/Utils/Scanner.pm line 170)
   frame 2: Slim::Utils::Scanner::scanDirectory (P:\Music\SlimServer\trunk\server/Slim/Music/MusicFolderScan.pm line 64)
   frame 3: Slim::Music::MusicFolderScan::startScan (P:/Music/SlimServer/trunk/server/Slim/Music/Import.pm line 171)
   frame 4: Slim::Music::Import::runImporter (P:/Music/SlimServer/trunk/server/Slim/Music/Import.pm line 93)
   frame 5: Slim::Music::Import::startScan (P:/Music/SlimServer/trunk/server/scanner.pl line 144)
   frame 6: (eval) (P:/Music/SlimServer/trunk/server/scanner.pl line 122)
   frame 7: main::main (P:/Music/SlimServer/trunk/server/scanner.pl line 259)

2006-06-27 23:46:05.7526 ERROR: newTrack: Couldn't create Track for file:///M:/Music/Phil%27s%20Music/Dashboard%20Confessional/The%20Places%20You%20Have%20Come%20To%20Fear%20The%20Most/01%20-%20The%20Brilliant%20Dance.wma : DBIx::Class::ResultSet::create(): Can't get last insert id at P:\Music\SlimServer\trunk\server/Slim/Schema.pm line 458

Comment 7 Dan Sully 2006-06-27 16:07:40 UTC

Can you please upload that exact track?

Thanks

Comment 8 Philip Meyer 2006-06-27 16:48:14 UTC

Created attachment 1291 [details]
Another wma file that won't scan

All WMA files are still failing to be scanned.  Here's the exact track that was referenced in the error message.

Comment 9 Dan Sully 2006-06-27 16:53:22 UTC

Are you sure you've svn up'd properly?

What does line 269 of lib/Audio/WMA.pm read?

Thanks

Comment 10 Philip Meyer 2006-06-28 00:28:28 UTC

I updated to latest SVN and did a full rescan.

I checked my SVN version - it was correct.  I checked the specific file - it is the latest.

Line 269 is:
			if (exists $self->{'TAGS'}->{$name} && $name ne 'VBR') {

Comment 11 Dan Sully 2006-06-28 13:51:55 UTC

Ok - that's the correct line. I'm going to try something else.

Can you update to at least change 8177 and try again?

Thanks

Comment 12 Dan Sully 2006-06-29 17:25:03 UTC

Phil - have you gotten a chance to try with the most recent changes?

Thanks

Comment 13 Philip Meyer 2006-06-29 21:58:48 UTC

No - I can't get the scanner to load anything at the moment (bug 3661).

Comment 14 Dan Sully 2006-06-30 10:42:57 UTC

Phil - now that 3661 is fixed, how does this look?

Thanks

Comment 15 Philip Meyer 2006-06-30 11:16:46 UTC

I've been waiting for my rescan to finish ;)

I think there's a slight improvement, in that I now can see an artist
"Dashboard Confessional", having one album "The Places You Have Come to Fear the Most".

However, when I browse the artist, slimserver reports "1 album with 0 songs by 3 artists.".
When I browse artist->album, slimserver reports "0 albums with 0 songs by 0 artists.".

I have run "SELECT * FROM tracks where content_type='wma'" which reports 0 rows.


2006-06-30 17:56:23.0380 Found 6384 files in M:\Music\Phil's Music
DBD::mysql::st execute failed: Incorrect integer value: '' for column 'rating' at row 1 at P:\Music\SlimServer\trunk\server\CPAN/DBIx/Class/Storage/DBI.pm line 525.
2006-06-30 17:58:14.0536 ERROR: Error executing 'INSERT INTO tracks (audio, audio_size, bitrate, channels, content_type, drm, filesize, lossless, rating, remote, samplerate, secs, timestamp, title, titlesearch, titlesort, tracknum, url, vbr_scale, year) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)' (`1', `3674586', `160016', `2', `wma', `0', `3674586', `0', `', `0', `44100', `182.639', `1134926631', `The Brilliant Dance', `BRILLIANT DANCE', `BRILLIANT DANCE', `1', `file:///M:/Music/Phil%27s%20Music/Dashboard%20Confessional/The%20Places%20You%20Have%20Come%20To%20Fear%20The%20Most/01%20-%20The%20Brilliant%20Dance.wma', `0', `2001'): DBD::mysql::st execute failed: Incorrect integer value: '' for column 'rating' at row 1 at P:\Music\SlimServer\trunk\server\CPAN/DBIx/Class/Storage/DBI.pm line 525.

2006-06-30 17:58:14.0536 ERROR: Backtrace follows:

2006-06-30 17:58:14.0541 Backtrace:

   frame 0: Slim::Schema::Storage::throw_exception (P:\Music\SlimServer\trunk\server\CPAN/DBIx/Class/Storage/DBI.pm line 530)
   frame 1: DBIx::Class::Storage::DBI::_execute (P:\Music\SlimServer\trunk\server\CPAN/DBIx/Class/Storage/DBI.pm line 539)
   frame 2: DBIx::Class::Storage::DBI::insert (P:\Music\SlimServer\trunk\server\CPAN/DBIx/Class/Row.pm line 69)
   frame 3: DBIx::Class::Row::insert (P:\Music\SlimServer\trunk\server\CPAN/DBIx/Class/PK/Auto.pm line 43)
   frame 4: DBIx::Class::PK::Auto::insert (P:\Music\SlimServer\trunk\server\CPAN/DBIx/Class/ResultSet.pm line 1054)
   frame 5: DBIx::Class::ResultSet::create (P:\Music\SlimServer\trunk\server/Slim/Schema.pm line 464)
   frame 6: (eval) (P:\Music\SlimServer\trunk\server/Slim/Schema.pm line 464)
   frame 7: Slim::Schema::newTrack (P:\Music\SlimServer\trunk\server/Slim/Utils/Scanner.pm line 189)
   frame 8: Slim::Utils::Scanner::scanDirectory (P:\Music\SlimServer\trunk\server/Slim/Utils/Scanner.pm line 173)
   frame 9: Slim::Utils::Scanner::scanDirectory (P:\Music\SlimServer\trunk\server/Slim/Music/MusicFolderScan.pm line 64)
   frame 10: Slim::Music::MusicFolderScan::startScan (P:/Music/SlimServer/trunk/server/Slim/Music/Import.pm line 171)
   frame 11: Slim::Music::Import::runImporter (P:/Music/SlimServer/trunk/server/Slim/Music/Import.pm line 93)
   frame 12: Slim::Music::Import::startScan (P:/Music/SlimServer/trunk/server/scanner.pl line 143)
   frame 13: main::__ANON__ (P:\Music\SlimServer\trunk\server\CPAN/DBIx/Class/Schema.pm line 588)
   frame 14: (eval) (P:\Music\SlimServer\trunk\server\CPAN/DBIx/Class/Schema.pm line 576)
   frame 15: DBIx::Class::Schema::txn_do (P:/Music/SlimServer/trunk/server/scanner.pl line 154)
   frame 16: main::main (P:/Music/SlimServer/trunk/server/scanner.pl line 248)

2006-06-30 17:58:14.0543 ERROR: Couldn't insert bitrate => 160016, drm => 0, audio_size => 3674586, vbr_scale => 0, rating => , remote => 0, titlesort => BRILLIANT DANCE, audio => 1, timestamp => 1134926631, url => file:///M:/Music/Phil%27s%20Music/Dashboard%20Confessional/The%20Places%20You%20Have%20Come%20To%20Fear%20The%20Most/01%20-%20The%20Brilliant%20Dance.wma, lossless => 0, channels => 2, samplerate => 44100, secs => 182.639, filesize => 3674586, content_type => wma, tracknum => 1, titlesearch => BRILLIANT DANCE, title => The Brilliant Dance, year => 2001 into tracks
2006-06-30 17:58:14.0544 ERROR: Backtrace follows:

2006-06-30 17:58:14.0548 Backtrace:

   frame 0: Slim::Schema::Storage::throw_exception (P:\Music\SlimServer\trunk\server\CPAN/DBIx/Class/Storage/DBI.pm line 539)
   frame 1: DBIx::Class::Storage::DBI::insert (P:\Music\SlimServer\trunk\server\CPAN/DBIx/Class/Row.pm line 69)
   frame 2: DBIx::Class::Row::insert (P:\Music\SlimServer\trunk\server\CPAN/DBIx/Class/PK/Auto.pm line 43)
   frame 3: DBIx::Class::PK::Auto::insert (P:\Music\SlimServer\trunk\server\CPAN/DBIx/Class/ResultSet.pm line 1054)
   frame 4: DBIx::Class::ResultSet::create (P:\Music\SlimServer\trunk\server/Slim/Schema.pm line 464)
   frame 5: (eval) (P:\Music\SlimServer\trunk\server/Slim/Schema.pm line 464)
   frame 6: Slim::Schema::newTrack (P:\Music\SlimServer\trunk\server/Slim/Utils/Scanner.pm line 189)
   frame 7: Slim::Utils::Scanner::scanDirectory (P:\Music\SlimServer\trunk\server/Slim/Utils/Scanner.pm line 173)
   frame 8: Slim::Utils::Scanner::scanDirectory (P:\Music\SlimServer\trunk\server/Slim/Music/MusicFolderScan.pm line 64)
   frame 9: Slim::Music::MusicFolderScan::startScan (P:/Music/SlimServer/trunk/server/Slim/Music/Import.pm line 171)
   frame 10: Slim::Music::Import::runImporter (P:/Music/SlimServer/trunk/server/Slim/Music/Import.pm line 93)
   frame 11: Slim::Music::Import::startScan (P:/Music/SlimServer/trunk/server/scanner.pl line 143)
   frame 12: main::__ANON__ (P:\Music\SlimServer\trunk\server\CPAN/DBIx/Class/Schema.pm line 588)
   frame 13: (eval) (P:\Music\SlimServer\trunk\server\CPAN/DBIx/Class/Schema.pm line 576)
   frame 14: DBIx::Class::Schema::txn_do (P:/Music/SlimServer/trunk/server/scanner.pl line 154)
   frame 15: main::main (P:/Music/SlimServer/trunk/server/scanner.pl line 248)

2006-06-30 17:58:14.0561 ERROR: Can't get last insert id
2006-06-30 17:58:14.0562 ERROR: Backtrace follows:

2006-06-30 17:58:14.0565 Backtrace:

   frame 0: Slim::Schema::throw_exception (P:\Music\SlimServer\trunk\server\CPAN/DBIx/Class/Row.pm line 408)
   frame 1: DBIx::Class::Row::throw_exception (P:\Music\SlimServer\trunk\server\CPAN/DBIx/Class/PK/Auto.pm line 53)
   frame 2: DBIx::Class::PK::Auto::insert (P:\Music\SlimServer\trunk\server\CPAN/DBIx/Class/ResultSet.pm line 1054)
   frame 3: DBIx::Class::ResultSet::create (P:\Music\SlimServer\trunk\server/Slim/Schema.pm line 464)
   frame 4: (eval) (P:\Music\SlimServer\trunk\server/Slim/Schema.pm line 464)
   frame 5: Slim::Schema::newTrack (P:\Music\SlimServer\trunk\server/Slim/Utils/Scanner.pm line 189)
   frame 6: Slim::Utils::Scanner::scanDirectory (P:\Music\SlimServer\trunk\server/Slim/Utils/Scanner.pm line 173)
   frame 7: Slim::Utils::Scanner::scanDirectory (P:\Music\SlimServer\trunk\server/Slim/Music/MusicFolderScan.pm line 64)
   frame 8: Slim::Music::MusicFolderScan::startScan (P:/Music/SlimServer/trunk/server/Slim/Music/Import.pm line 171)
   frame 9: Slim::Music::Import::runImporter (P:/Music/SlimServer/trunk/server/Slim/Music/Import.pm line 93)
   frame 10: Slim::Music::Import::startScan (P:/Music/SlimServer/trunk/server/scanner.pl line 143)
   frame 11: main::__ANON__ (P:\Music\SlimServer\trunk\server\CPAN/DBIx/Class/Schema.pm line 588)
   frame 12: (eval) (P:\Music\SlimServer\trunk\server\CPAN/DBIx/Class/Schema.pm line 576)
   frame 13: DBIx::Class::Schema::txn_do (P:/Music/SlimServer/trunk/server/scanner.pl line 154)
   frame 14: main::main (P:/Music/SlimServer/trunk/server/scanner.pl line 248)

DBD::mysql::st execute failed: Cannot add or update a child row: a foreign key constraint fails (`slimserver/genre_track`, CONSTRAINT `genre_track_ibfk_1` FOREIGN KEY (`track`) REFERENCES `tracks` (`id`) ON DELETE CASCADE) at P:\Music\SlimServer\trunk\server\CPAN/DBIx/Class/Storage/DBI.pm line 525.
2006-06-30 17:58:14.0972 ERROR: Error executing 'INSERT INTO genre_track (genre, track) VALUES (?, ?)' (`9', `0'): DBD::mysql::st execute failed: Cannot add or update a child row: a foreign key constraint fails (`slimserver/genre_track`, CONSTRAINT `genre_track_ibfk_1` FOREIGN KEY (`track`) REFERENCES `tracks` (`id`) ON DELETE CASCADE) at P:\Music\SlimServer\trunk\server\CPAN/DBIx/Class/Storage/DBI.pm line 525.

2006-06-30 17:58:14.0973 ERROR: Backtrace follows:

2006-06-30 17:58:14.0978 Backtrace:

   frame 0: Slim::Schema::Storage::throw_exception (P:\Music\SlimServer\trunk\server\CPAN/DBIx/Class/Storage/DBI.pm line 530)
   frame 1: DBIx::Class::Storage::DBI::_execute (P:\Music\SlimServer\trunk\server\CPAN/DBIx/Class/Storage/DBI.pm line 539)
   frame 2: DBIx::Class::Storage::DBI::insert (P:\Music\SlimServer\trunk\server\CPAN/DBIx/Class/Row.pm line 69)
   frame 3: DBIx::Class::Row::insert (P:\Music\SlimServer\trunk\server\CPAN/DBIx/Class/PK/Auto.pm line 43)
   frame 4: DBIx::Class::PK::Auto::insert (P:\Music\SlimServer\trunk\server\CPAN/DBIx/Class/ResultSet.pm line 1054)
   frame 5: DBIx::Class::ResultSet::create (P:\Music\SlimServer\trunk\server\CPAN/DBIx/Class/ResultSet.pm line 1099)
   frame 6: DBIx::Class::ResultSet::find_or_create (P:\Music\SlimServer\trunk\server/Slim/Schema/Genre.pm line 75)
   frame 7: Slim::Schema::Genre::add (P:\Music\SlimServer\trunk\server/Slim/Schema.pm line 1329)
   frame 8: Slim::Schema::_postCheckAttributes (P:\Music\SlimServer\trunk\server/Slim/Schema.pm line 476)
   frame 9: Slim::Schema::newTrack (P:\Music\SlimServer\trunk\server/Slim/Utils/Scanner.pm line 189)
   frame 10: Slim::Utils::Scanner::scanDirectory (P:\Music\SlimServer\trunk\server/Slim/Utils/Scanner.pm line 173)
   frame 11: Slim::Utils::Scanner::scanDirectory (P:\Music\SlimServer\trunk\server/Slim/Music/MusicFolderScan.pm line 64)
   frame 12: Slim::Music::MusicFolderScan::startScan (P:/Music/SlimServer/trunk/server/Slim/Music/Import.pm line 171)
   frame 13: Slim::Music::Import::runImporter (P:/Music/SlimServer/trunk/server/Slim/Music/Import.pm line 93)
   frame 14: Slim::Music::Import::startScan (P:/Music/SlimServer/trunk/server/scanner.pl line 143)
   frame 15: main::__ANON__ (P:\Music\SlimServer\trunk\server\CPAN/DBIx/Class/Schema.pm line 588)
   frame 16: (eval) (P:\Music\SlimServer\trunk\server\CPAN/DBIx/Class/Schema.pm line 576)
   frame 17: DBIx::Class::Schema::txn_do (P:/Music/SlimServer/trunk/server/scanner.pl line 154)
   frame 18: main::main (P:/Music/SlimServer/trunk/server/scanner.pl line 248)

2006-06-30 17:58:14.0980 ERROR: Couldn't insert track => 0, genre => 9 into genre_track
2006-06-30 17:58:14.0980 ERROR: Backtrace follows:

2006-06-30 17:58:14.0984 Backtrace:

   frame 0: Slim::Schema::Storage::throw_exception (P:\Music\SlimServer\trunk\server\CPAN/DBIx/Class/Storage/DBI.pm line 539)
   frame 1: DBIx::Class::Storage::DBI::insert (P:\Music\SlimServer\trunk\server\CPAN/DBIx/Class/Row.pm line 69)
   frame 2: DBIx::Class::Row::insert (P:\Music\SlimServer\trunk\server\CPAN/DBIx/Class/PK/Auto.pm line 43)
   frame 3: DBIx::Class::PK::Auto::insert (P:\Music\SlimServer\trunk\server\CPAN/DBIx/Class/ResultSet.pm line 1054)
   frame 4: DBIx::Class::ResultSet::create (P:\Music\SlimServer\trunk\server\CPAN/DBIx/Class/ResultSet.pm line 1099)
   frame 5: DBIx::Class::ResultSet::find_or_create (P:\Music\SlimServer\trunk\server/Slim/Schema/Genre.pm line 75)
   frame 6: Slim::Schema::Genre::add (P:\Music\SlimServer\trunk\server/Slim/Schema.pm line 1329)
   frame 7: Slim::Schema::_postCheckAttributes (P:\Music\SlimServer\trunk\server/Slim/Schema.pm line 476)
   frame 8: Slim::Schema::newTrack (P:\Music\SlimServer\trunk\server/Slim/Utils/Scanner.pm line 189)
   frame 9: Slim::Utils::Scanner::scanDirectory (P:\Music\SlimServer\trunk\server/Slim/Utils/Scanner.pm line 173)
   frame 10: Slim::Utils::Scanner::scanDirectory (P:\Music\SlimServer\trunk\server/Slim/Music/MusicFolderScan.pm line 64)
   frame 11: Slim::Music::MusicFolderScan::startScan (P:/Music/SlimServer/trunk/server/Slim/Music/Import.pm line 171)
   frame 12: Slim::Music::Import::runImporter (P:/Music/SlimServer/trunk/server/Slim/Music/Import.pm line 93)
   frame 13: Slim::Music::Import::startScan (P:/Music/SlimServer/trunk/server/scanner.pl line 143)
   frame 14: main::__ANON__ (P:\Music\SlimServer\trunk\server\CPAN/DBIx/Class/Schema.pm line 588)
   frame 15: (eval) (P:\Music\SlimServer\trunk\server\CPAN/DBIx/Class/Schema.pm line 576)
   frame 16: DBIx::Class::Schema::txn_do (P:/Music/SlimServer/trunk/server/scanner.pl line 154)
   frame 17: main::main (P:/Music/SlimServer/trunk/server/scanner.pl line 248)

DBD::mysql::st execute failed: Cannot add or update a child row: a foreign key constraint fails (`slimserver/contributor_track`, CONSTRAINT `contributor_track_ibfk_1` FOREIGN KEY (`track`) REFERENCES `tracks` (`id`) ON DELETE CASCADE) at P:\Music\SlimServer\trunk\server\CPAN/DBIx/Class/Storage/DBI.pm line 525.
2006-06-30 17:58:14.1215 ERROR: Error executing 'INSERT INTO contributor_track (contributor, role, track) VALUES (?, ?, ?)' (`264', `1', `0'): DBD::mysql::st execute failed: Cannot add or update a child row: a foreign key constraint fails (`slimserver/contributor_track`, CONSTRAINT `contributor_track_ibfk_1` FOREIGN KEY (`track`) REFERENCES `tracks` (`id`) ON DELETE CASCADE) at P:\Music\SlimServer\trunk\server\CPAN/DBIx/Class/Storage/DBI.pm line 525.

2006-06-30 17:58:14.1217 ERROR: Backtrace follows:

2006-06-30 17:58:14.1222 Backtrace:

   frame 0: Slim::Schema::Storage::throw_exception (P:\Music\SlimServer\trunk\server\CPAN/DBIx/Class/Storage/DBI.pm line 530)
   frame 1: DBIx::Class::Storage::DBI::_execute (P:\Music\SlimServer\trunk\server\CPAN/DBIx/Class/Storage/DBI.pm line 539)
   frame 2: DBIx::Class::Storage::DBI::insert (P:\Music\SlimServer\trunk\server\CPAN/DBIx/Class/Row.pm line 69)
   frame 3: DBIx::Class::Row::insert (P:\Music\SlimServer\trunk\server\CPAN/DBIx/Class/PK/Auto.pm line 43)
   frame 4: DBIx::Class::PK::Auto::insert (P:\Music\SlimServer\trunk\server\CPAN/DBIx/Class/ResultSet.pm line 1054)
   frame 5: DBIx::Class::ResultSet::create (P:\Music\SlimServer\trunk\server\CPAN/DBIx/Class/ResultSet.pm line 1099)
   frame 6: DBIx::Class::ResultSet::find_or_create (P:\Music\SlimServer\trunk\server/Slim/Schema/Contributor.pm line 134)
   frame 7: Slim::Schema::Contributor::add (P:\Music\SlimServer\trunk\server/Slim/Schema.pm line 1717)
   frame 8: Slim::Schema::_mergeAndCreateContributors (P:\Music\SlimServer\trunk\server/Slim/Schema.pm line 1357)
   frame 9: Slim::Schema::_postCheckAttributes (P:\Music\SlimServer\trunk\server/Slim/Schema.pm line 476)
   frame 10: Slim::Schema::newTrack (P:\Music\SlimServer\trunk\server/Slim/Utils/Scanner.pm line 189)
   frame 11: Slim::Utils::Scanner::scanDirectory (P:\Music\SlimServer\trunk\server/Slim/Utils/Scanner.pm line 173)
   frame 12: Slim::Utils::Scanner::scanDirectory (P:\Music\SlimServer\trunk\server/Slim/Music/MusicFolderScan.pm line 64)
   frame 13: Slim::Music::MusicFolderScan::startScan (P:/Music/SlimServer/trunk/server/Slim/Music/Import.pm line 171)
   frame 14: Slim::Music::Import::runImporter (P:/Music/SlimServer/trunk/server/Slim/Music/Import.pm line 93)
   frame 15: Slim::Music::Import::startScan (P:/Music/SlimServer/trunk/server/scanner.pl line 143)
   frame 16: main::__ANON__ (P:\Music\SlimServer\trunk\server\CPAN/DBIx/Class/Schema.pm line 588)
   frame 17: (eval) (P:\Music\SlimServer\trunk\server\CPAN/DBIx/Class/Schema.pm line 576)
   frame 18: DBIx::Class::Schema::txn_do (P:/Music/SlimServer/trunk/server/scanner.pl line 154)
   frame 19: main::main (P:/Music/SlimServer/trunk/server/scanner.pl line 248)

2006-06-30 17:58:14.1223 ERROR: Couldn't insert track => 0, role => 1, contributor => 264 into contributor_track
2006-06-30 17:58:14.1224 ERROR: Backtrace follows:

2006-06-30 17:58:14.1228 Backtrace:

   frame 0: Slim::Schema::Storage::throw_exception (P:\Music\SlimServer\trunk\server\CPAN/DBIx/Class/Storage/DBI.pm line 539)
   frame 1: DBIx::Class::Storage::DBI::insert (P:\Music\SlimServer\trunk\server\CPAN/DBIx/Class/Row.pm line 69)
   frame 2: DBIx::Class::Row::insert (P:\Music\SlimServer\trunk\server\CPAN/DBIx/Class/PK/Auto.pm line 43)
   frame 3: DBIx::Class::PK::Auto::insert (P:\Music\SlimServer\trunk\server\CPAN/DBIx/Class/ResultSet.pm line 1054)
   frame 4: DBIx::Class::ResultSet::create (P:\Music\SlimServer\trunk\server\CPAN/DBIx/Class/ResultSet.pm line 1099)
   frame 5: DBIx::Class::ResultSet::find_or_create (P:\Music\SlimServer\trunk\server/Slim/Schema/Contributor.pm line 134)
   frame 6: Slim::Schema::Contributor::add (P:\Music\SlimServer\trunk\server/Slim/Schema.pm line 1717)
   frame 7: Slim::Schema::_mergeAndCreateContributors (P:\Music\SlimServer\trunk\server/Slim/Schema.pm line 1357)
   frame 8: Slim::Schema::_postCheckAttributes (P:\Music\SlimServer\trunk\server/Slim/Schema.pm line 476)
   frame 9: Slim::Schema::newTrack (P:\Music\SlimServer\trunk\server/Slim/Utils/Scanner.pm line 189)
   frame 10: Slim::Utils::Scanner::scanDirectory (P:\Music\SlimServer\trunk\server/Slim/Utils/Scanner.pm line 173)
   frame 11: Slim::Utils::Scanner::scanDirectory (P:\Music\SlimServer\trunk\server/Slim/Music/MusicFolderScan.pm line 64)
   frame 12: Slim::Music::MusicFolderScan::startScan (P:/Music/SlimServer/trunk/server/Slim/Music/Import.pm line 171)
   frame 13: Slim::Music::Import::runImporter (P:/Music/SlimServer/trunk/server/Slim/Music/Import.pm line 93)
   frame 14: Slim::Music::Import::startScan (P:/Music/SlimServer/trunk/server/scanner.pl line 143)
   frame 15: main::__ANON__ (P:\Music\SlimServer\trunk\server\CPAN/DBIx/Class/Schema.pm line 588)
   frame 16: (eval) (P:\Music\SlimServer\trunk\server\CPAN/DBIx/Class/Schema.pm line 576)
   frame 17: DBIx::Class::Schema::txn_do (P:/Music/SlimServer/trunk/server/scanner.pl line 154)
   frame 18: main::main (P:/Music/SlimServer/trunk/server/scanner.pl line 248)

DBD::mysql::st execute failed: Cannot add or update a child row: a foreign key constraint fails (`slimserver/contributor_track`, CONSTRAINT `contributor_track_ibfk_1` FOREIGN KEY (`track`) REFERENCES `tracks` (`id`) ON DELETE CASCADE) at P:\Music\SlimServer\trunk\server\CPAN/DBIx/Class/Storage/DBI.pm line 525.
2006-06-30 17:58:14.1429 ERROR: Error executing 'INSERT INTO contributor_track (contributor, role, track) VALUES (?, ?, ?)' (`265', `2', `0'): DBD::mysql::st execute failed: Cannot add or update a child row: a foreign key constraint fails (`slimserver/contributor_track`, CONSTRAINT `contributor_track_ibfk_1` FOREIGN KEY (`track`) REFERENCES `tracks` (`id`) ON DELETE CASCADE) at P:\Music\SlimServer\trunk\server\CPAN/DBIx/Class/Storage/DBI.pm line 525.

2006-06-30 17:58:14.1430 ERROR: Backtrace follows:

2006-06-30 17:58:14.1435 Backtrace:

   frame 0: Slim::Schema::Storage::throw_exception (P:\Music\SlimServer\trunk\server\CPAN/DBIx/Class/Storage/DBI.pm line 530)
   frame 1: DBIx::Class::Storage::DBI::_execute (P:\Music\SlimServer\trunk\server\CPAN/DBIx/Class/Storage/DBI.pm line 539)
   frame 2: DBIx::Class::Storage::DBI::insert (P:\Music\SlimServer\trunk\server\CPAN/DBIx/Class/Row.pm line 69)
   frame 3: DBIx::Class::Row::insert (P:\Music\SlimServer\trunk\server\CPAN/DBIx/Class/PK/Auto.pm line 43)
   frame 4: DBIx::Class::PK::Auto::insert (P:\Music\SlimServer\trunk\server\CPAN/DBIx/Class/ResultSet.pm line 1054)
   frame 5: DBIx::Class::ResultSet::create (P:\Music\SlimServer\trunk\server\CPAN/DBIx/Class/ResultSet.pm line 1099)
   frame 6: DBIx::Class::ResultSet::find_or_create (P:\Music\SlimServer\trunk\server/Slim/Schema/Contributor.pm line 134)
   frame 7: Slim::Schema::Contributor::add (P:\Music\SlimServer\trunk\server/Slim/Schema.pm line 1717)
   frame 8: Slim::Schema::_mergeAndCreateContributors (P:\Music\SlimServer\trunk\server/Slim/Schema.pm line 1357)
   frame 9: Slim::Schema::_postCheckAttributes (P:\Music\SlimServer\trunk\server/Slim/Schema.pm line 476)
   frame 10: Slim::Schema::newTrack (P:\Music\SlimServer\trunk\server/Slim/Utils/Scanner.pm line 189)
   frame 11: Slim::Utils::Scanner::scanDirectory (P:\Music\SlimServer\trunk\server/Slim/Utils/Scanner.pm line 173)
   frame 12: Slim::Utils::Scanner::scanDirectory (P:\Music\SlimServer\trunk\server/Slim/Music/MusicFolderScan.pm line 64)
   frame 13: Slim::Music::MusicFolderScan::startScan (P:/Music/SlimServer/trunk/server/Slim/Music/Import.pm line 171)
   frame 14: Slim::Music::Import::runImporter (P:/Music/SlimServer/trunk/server/Slim/Music/Import.pm line 93)
   frame 15: Slim::Music::Import::startScan (P:/Music/SlimServer/trunk/server/scanner.pl line 143)
   frame 16: main::__ANON__ (P:\Music\SlimServer\trunk\server\CPAN/DBIx/Class/Schema.pm line 588)
   frame 17: (eval) (P:\Music\SlimServer\trunk\server\CPAN/DBIx/Class/Schema.pm line 576)
   frame 18: DBIx::Class::Schema::txn_do (P:/Music/SlimServer/trunk/server/scanner.pl line 154)
   frame 19: main::main (P:/Music/SlimServer/trunk/server/scanner.pl line 248)

2006-06-30 17:58:14.1437 ERROR: Couldn't insert track => 0, role => 2, contributor => 265 into contributor_track
2006-06-30 17:58:14.1437 ERROR: Backtrace follows:

2006-06-30 17:58:14.1441 Backtrace:

   frame 0: Slim::Schema::Storage::throw_exception (P:\Music\SlimServer\trunk\server\CPAN/DBIx/Class/Storage/DBI.pm line 539)
   frame 1: DBIx::Class::Storage::DBI::insert (P:\Music\SlimServer\trunk\server\CPAN/DBIx/Class/Row.pm line 69)
   frame 2: DBIx::Class::Row::insert (P:\Music\SlimServer\trunk\server\CPAN/DBIx/Class/PK/Auto.pm line 43)
   frame 3: DBIx::Class::PK::Auto::insert (P:\Music\SlimServer\trunk\server\CPAN/DBIx/Class/ResultSet.pm line 1054)
   frame 4: DBIx::Class::ResultSet::create (P:\Music\SlimServer\trunk\server\CPAN/DBIx/Class/ResultSet.pm line 1099)
   frame 5: DBIx::Class::ResultSet::find_or_create (P:\Music\SlimServer\trunk\server/Slim/Schema/Contributor.pm line 134)
   frame 6: Slim::Schema::Contributor::add (P:\Music\SlimServer\trunk\server/Slim/Schema.pm line 1717)
   frame 7: Slim::Schema::_mergeAndCreateContributors (P:\Music\SlimServer\trunk\server/Slim/Schema.pm line 1357)
   frame 8: Slim::Schema::_postCheckAttributes (P:\Music\SlimServer\trunk\server/Slim/Schema.pm line 476)
   frame 9: Slim::Schema::newTrack (P:\Music\SlimServer\trunk\server/Slim/Utils/Scanner.pm line 189)
   frame 10: Slim::Utils::Scanner::scanDirectory (P:\Music\SlimServer\trunk\server/Slim/Utils/Scanner.pm line 173)
   frame 11: Slim::Utils::Scanner::scanDirectory (P:\Music\SlimServer\trunk\server/Slim/Music/MusicFolderScan.pm line 64)
   frame 12: Slim::Music::MusicFolderScan::startScan (P:/Music/SlimServer/trunk/server/Slim/Music/Import.pm line 171)
   frame 13: Slim::Music::Import::runImporter (P:/Music/SlimServer/trunk/server/Slim/Music/Import.pm line 93)
   frame 14: Slim::Music::Import::startScan (P:/Music/SlimServer/trunk/server/scanner.pl line 143)
   frame 15: main::__ANON__ (P:\Music\SlimServer\trunk\server\CPAN/DBIx/Class/Schema.pm line 588)
   frame 16: (eval) (P:\Music\SlimServer\trunk\server\CPAN/DBIx/Class/Schema.pm line 576)
   frame 17: DBIx::Class::Schema::txn_do (P:/Music/SlimServer/trunk/server/scanner.pl line 154)
   frame 18: main::main (P:/Music/SlimServer/trunk/server/scanner.pl line 248)

2006-06-30 17:58:14.1868 ERROR: Can't update Slim::Schema::Track=HASH(0x42a391c): row not found
2006-06-30 17:58:14.1869 ERROR: Backtrace follows:

2006-06-30 17:58:14.1874 Backtrace:

   frame 0: Slim::Schema::throw_exception (P:\Music\SlimServer\trunk\server\CPAN/DBIx/Class/Row.pm line 408)
   frame 1: DBIx::Class::Row::throw_exception (P:\Music\SlimServer\trunk\server\CPAN/DBIx/Class/Row.pm line 111)
   frame 2: DBIx::Class::Row::update (P:\Music\SlimServer\trunk\server\CPAN/DBIx/Class/Relationship/CascadeActions.pm line 30)
   frame 3: DBIx::Class::Relationship::CascadeActions::update (P:\Music\SlimServer\trunk\server\CPAN/DBIx/Class/InflateColumn.pm line 146)
   frame 4: DBIx::Class::InflateColumn::update (P:\Music\SlimServer\trunk\server/Slim/Schema/DBI.pm line 35)
   frame 5: Slim::Schema::DBI::update (P:\Music\SlimServer\trunk\server/Slim/Schema.pm line 1661)
   frame 6: Slim::Schema::_postCheckAttributes (P:\Music\SlimServer\trunk\server/Slim/Schema.pm line 476)
   frame 7: Slim::Schema::newTrack (P:\Music\SlimServer\trunk\server/Slim/Utils/Scanner.pm line 189)
   frame 8: Slim::Utils::Scanner::scanDirectory (P:\Music\SlimServer\trunk\server/Slim/Utils/Scanner.pm line 173)
   frame 9: Slim::Utils::Scanner::scanDirectory (P:\Music\SlimServer\trunk\server/Slim/Music/MusicFolderScan.pm line 64)
   frame 10: Slim::Music::MusicFolderScan::startScan (P:/Music/SlimServer/trunk/server/Slim/Music/Import.pm line 171)
   frame 11: Slim::Music::Import::runImporter (P:/Music/SlimServer/trunk/server/Slim/Music/Import.pm line 93)
   frame 12: Slim::Music::Import::startScan (P:/Music/SlimServer/trunk/server/scanner.pl line 143)
   frame 13: main::__ANON__ (P:\Music\SlimServer\trunk\server\CPAN/DBIx/Class/Schema.pm line 588)
   frame 14: (eval) (P:\Music\SlimServer\trunk\server\CPAN/DBIx/Class/Schema.pm line 576)
   frame 15: DBIx::Class::Schema::txn_do (P:/Music/SlimServer/trunk/server/scanner.pl line 154)
   frame 16: main::main (P:/Music/SlimServer/trunk/server/scanner.pl line 248)

Comment 16 Dan Sully 2006-07-14 13:42:27 UTC

Phil, I assume this is still broken for you?

Comment 17 Philip Meyer 2006-07-15 13:21:23 UTC

Just tried again - full rescan with SVN8455.
Yes, Still broken.

Comment 18 Dan Sully 2006-07-19 13:18:33 UTC

Fixed in change 8519