7.3-23131 scan breaks: HASH(0x4665910): row not found

[hhenkel]

Hi,

the scanner doesn't work here anymore (debian-lenny, AMD64), see attachment. It tells:

[08-09-13 15:11:03.2912] Slim::Schema::throw_exception (236) Error: Can't update Slim::Schema::Progress=HASH(0x4ae17d8): row not found

and later:

[08-09-13 15:11:03.3447] Slim::Schema::newTrack (939) Warning: Use of uninitialized value in sprintf at /usr/share/perl5/Slim/Schema.pm line 940.
[08-09-13 15:11:03.3553] Slim::Schema::Storage::throw_exception (70) Error: Error executing 'INSERT INTO genre_track (genre, track) VALUES (?, ?)': DBD::mysql::st execute failed: Column 'genre' cannot be null at /usr/share/squeezecenter/CPAN/DBIx/Class/Storage/DBI.pm line 771.

It didn't run here recently also with 7.2-deb as from testing, due to same reason/scanner log, and i thought it would be solved in 7.3. Any hints welcome about what goes wrong.

Regards, Hartmut

[hhenkel]

...and here is the scanner log, forgot to click upload, sorry.

Regards, Hartmut

[gharris999]

I'm seeing this too on all my Fedora 9 boxes:

SqueezeCenter Version: 7.2.1 - 23177 @ Mon Sep 15 02:01:21 PDT 2008 - Red Hat - EN - utf8
Server IP address: 192.168.0.222
Perl Version: 5.10.0 i386-linux-thread-multi
MySQL Version: 5.0.67-community
Platform Architecture: i686-linux

The scaner dies right away. The info in the scanner log doesn't seem very illuminating. It seems to be describing the Slim::Utils::Progress:final routine croaking. It doesn't seem to describe why the scanner quits without successfully putting even a single track record into the db.

From scanner.log:

[08-09-15 23:00:38.4094] Slim::Schema::throw_exception (236) Error: Can't update Slim::Schema::Progress=HASH(0xadb4a5c): row not found
[08-09-15 23:00:38.4122] Slim::Schema::throw_exception (236) Backtrace:

   frame 0: Slim::Utils::Log::logBacktrace (/usr/lib/perl5/vendor_perl/Slim/Schema.pm line 236)
   frame 1: Slim::Schema::throw_exception (/usr/share/squeezecenter/CPAN/DBIx/Class/Row.pm line 461)
   frame 2: DBIx::Class::Row::throw_exception (/usr/share/squeezecenter/CPAN/DBIx/Class/Row.pm line 117)
   frame 3: DBIx::Class::Row::update (/usr/share/squeezecenter/CPAN/DBIx/Class/Relationship/CascadeActions.pm line 30)
   frame 4: DBIx::Class::Relationship::CascadeActions::update (/usr/share/squeezecenter/CPAN/DBIx/Class/InflateColumn.pm line 222)
   frame 5: DBIx::Class::InflateColumn::update (/usr/lib/perl5/vendor_perl/Slim/Schema/DBI.pm line 35)
   frame 6: Slim::Schema::DBI::update (/usr/lib/perl5/vendor_perl/Slim/Utils/Progress.pm line 195)
   frame 7: Slim::Utils::Progress::final (/usr/lib/perl5/vendor_perl/Slim/Schema.pm line 392)
   frame 8: Slim::Schema::optimizeDB (/usr/lib/perl5/vendor_perl/Slim/Schema.pm line 347)
   frame 9: Slim::Schema::__ANON__ (/usr/share/squeezecenter/CPAN/DBIx/Class/Schema.pm line 584)
   frame 10: (eval) (/usr/share/squeezecenter/CPAN/DBIx/Class/Schema.pm line 572)
   frame 11: DBIx::Class::Schema::txn_do (/usr/lib/perl5/vendor_perl/Slim/Schema.pm line 348)
   frame 12: (eval) (/usr/lib/perl5/vendor_perl/Slim/Schema.pm line 339)
   frame 13: Slim::Schema::wipeDB (/usr/lib/perl5/vendor_perl/Slim/Schema.pm line 1469)
   frame 14: Slim::Schema::wipeAllData (/usr/libexec/squeezecenter-scanner line 172)
   frame 15: main::__ANON__ (/usr/share/squeezecenter/CPAN/DBIx/Class/Schema.pm line 584)
   frame 16: (eval) (/usr/share/squeezecenter/CPAN/DBIx/Class/Schema.pm line 572)
   frame 17: DBIx::Class::Schema::txn_do (/usr/libexec/squeezecenter-scanner line 172)
   frame 18: (eval) (/usr/libexec/squeezecenter-scanner line 172)
   frame 19: main::main (/usr/libexec/squeezecenter-scanner line 353)

Because I've verified this on two different SC machines, I've filed bug http://bugs.slimdevices.com/show_bug.cgi?id=9504

[gharris999]

OK, it looks like rolling back to the 8/31 nightly gets me scanning again.

hhenkel: what version of MySQL are you running? (go to Settings->Status)

[hhenkel]

it's

MySQL Version: 5.0.51a-12
Perl Version: 5.10.0 x86_64-linux-gnu-thread-multi
Platform Architecture: x86_64-linux

Regards, Hartmut

[andyg]

http://bugs.slimdevices.com/show_bug.cgi?id=9434

[gharris999]

Thanks, Andy. Sorry about the dup bug filing.

I think I was on the wrong track here.

On my Fedora 8 box running the latest svn code:

svn 23204.
SqueezeCenter Version: 7.2.1 - TRUNK @ UNKNOWN - Red Hat - EN - utf8
Perl Version: 5.8.8 i386-linux-thread-multi
MySQL Version: 5.0.45-log
Platform Architecture: i686-linux
Server Port Number: 9000

..the scanning works just fine. I downgraded the Fedora 9 box's MySQL to 5.0.45 fully expecting that to fix the scanning problem. But, no, it didn't. So, what's the variable here...the Perl version? 5.8.8 on the Fedora 8 box vs. 5.10 on the Fedora 9 box?

The Fedora 9 box, running svn 23204.
SqueezeCenter Version: 7.2.1 - TRUNK @ UNKNOWN - Red Hat - EN - utf8
Perl Version: 5.10.0 i386-linux-thread-multi
MySQL Version: 5.0.45-community
Platform Architecture: i686-linux

Could this be a problem with C3 on Perl 5.10?

[andyg]

It only fails for you on 5.10? Please post this information to the bug, Brandon (one of the maintainers of C3) is going to look at it.

The MySQL version is not relevant, it's definitely related to Class::C3.

[gharris999]

Done. .