I recently did a portupgrade on my FreeBSD 7.2 server which has successfully run as my SBS machine for several years now. After these upgrades (including SBS v7.4 -> 7.5), I'm getting this dreaded "Already in a transaction" error from scanner.pl and am unable to scan my library.
I have been trying to get this working all weekend to no avail. On the forums I read some suggestions as to an incompatibility between DBI and the MySQL version/libraries. To try and deal with this, I rebuilt perl and all its libraries from the ground up including DBI, DBD, and SBS. I'm still having the same issue. I dropped and recreated a brand new SBS database and same issue. Some system specs are as follows: - FreeBSD 7.2-STABLE - mysql-server-5.0.90 - p5-DBD-mysql-4.013 - p5-DBI-1.61.1 - p5-DBIx-Class-0.08122_1 I'm an experienced FreeBSD sysadmin and I've had everything working perfectly up until this latest upgrade. Because I upgraded several things together (MySQL maintenance upgrade, SBS to 7.5, DBD maintenance upgrade) I am not sure where the issue lies. Below is the error output from scanner.pl -- PLEASE HELP! [...@lion net]$ /usr/local/squeezeboxserver/scanner.pl --logconfig=/var/db/squeezeboxserver/prefs/log.conf --priority=0 --prefsdir=/var/db/squeezeboxserver/prefs --wipe [10-06-14 12:07:01.4380] main::main (180) Starting Squeezebox Server scanner (v7.5.0, r30464, Thu Apr 1 06:30:44 MDT 2010) perl 5.008009 [10-06-14 12:07:01.7479] Carp::Clan::__ANON__ (227) Warning: Class::C3::Componentised::load_components(): Use of DBIx::Class::UTF8Columns is strongly discouraged. See documentation of DBIx::Class::UTF8Columns for more info [10-06-14 12:07:02.2638] main::main (271) Removing artwork cache... [10-06-14 12:07:02.2742] Slim::Music::Import::runImporter (566) Starting Slim::Music::MusicFolderScan scan [10-06-14 12:07:19.3695] Slim::Utils::Scanner::scanDirectory (320) Found 14610 files in /u1/shared/music [10-06-14 12:07:19.3713] Slim::Utils::Scanner::scanDirectory (333) Scanning: /u1/shared/music/10,000 Maniacs/Our Time in Eden/01 Noah's Dove.flac [10-06-14 12:07:19.6254] Slim::Schema::Storage::throw_exception (82) Error: DBI Exception: DBD::mysql::db begin_work failed: Already in a transaction [10-06-14 12:07:19.6262] Slim::Schema::Storage::throw_exception (82) Backtrace: frame 0: Slim::Utils::Log::logBacktrace (/usr/local/squeezeboxserver/Slim/Schema/Storage.pm line 82) frame 1: Slim::Schema::Storage::throw_exception (/usr/local/lib/perl5/site_perl/5.8.9/DBIx/Class/Storage/DBI.pm line 1185) frame 2: DBIx::Class::Storage::DBI::__ANON__ (/usr/local/lib/perl5/site_perl/5.8.9/DBIx/Class/Storage/DBI.pm line 1324) frame 3: DBIx::Class::Storage::DBI::__ANON__ (/usr/local/lib/perl5/site_perl/5.8.9/DBIx/Class/Storage/DBI.pm line 738) frame 4: DBIx::Class::Storage::DBI::__ANON__ (/usr/local/lib/perl5/site_perl/5.8.9/Try/Tiny.pm line 76) frame 5: (eval) (/usr/local/lib/perl5/site_perl/5.8.9/Try/Tiny.pm line 67) frame 6: Try::Tiny::try (/usr/local/lib/perl5/site_perl/5.8.9/DBIx/Class/Storage/DBI.pm line 749) frame 7: DBIx::Class::Storage::DBI::dbh_do (/usr/local/lib/perl5/site_perl/5.8.9/DBIx/Class/Storage/DBI.pm line 1324) frame 8: DBIx::Class::Storage::DBI::_dbh_begin_work (/usr/local/lib/perl5/site_perl/5.8.9/DBIx/Class/Storage/DBI.pm line 1305) frame 9: DBIx::Class::Storage::DBI::txn_begin (/usr/local/lib/perl5/site_perl/5.8.9/DBIx/Class/Storage/TxnScopeGuard.pm line 12) frame 10: DBIx::Class::Storage::TxnScopeGuard::new (/usr/local/lib/perl5/site_perl/5.8.9/DBIx/Class/Storage.pm line 333) frame 11: DBIx::Class::Storage::txn_scope_guard (/usr/local/lib/perl5/site_perl/5.8.9/DBIx/Class/Schema.pm line 672) frame 12: DBIx::Class::Schema::txn_scope_guard (/usr/local/lib/perl5/site_perl/5.8.9/DBIx/Class/Relationship/CascadeActions.pm line 49) frame 13: DBIx::Class::Relationship::CascadeActions::update (/usr/local/squeezeboxserver/Slim/Schema/DBI.pm line 39) frame 14: Slim::Schema::DBI::update (/usr/local/squeezeboxserver/Slim/Schema.pm line 2766) frame 15: Slim::Schema::_postCheckAttributes (/usr/local/squeezeboxserver/Slim/Schema.pm line 1079) frame 16: Slim::Schema::newTrack (/usr/local/squeezeboxserver/Slim/Utils/Scanner.pm line 347) frame 17: Slim::Utils::Scanner::scanDirectory (/usr/local/squeezeboxserver/Slim/Music/MusicFolderScan.pm line 79) frame 18: Slim::Music::MusicFolderScan::startScan (/usr/local/squeezeboxserver/Slim/Music/Import.pm line 568) frame 19: Slim::Music::Import::runImporter (/usr/local/squeezeboxserver/Slim/Music/Import.pm line 373) frame 20: Slim::Music::Import::runScan (/usr/local/squeezeboxserver/scanner.pl line 305) frame 21: (eval) (/usr/local/squeezeboxserver/scanner.pl line 299) frame 22: main::main (/usr/local/squeezeboxserver/scanner.pl line 454) [10-06-14 12:07:19.6275] Slim::Schema::Storage::throw_exception (82) Error: Carp::Clan::__ANON__(): DBI Exception: DBD::mysql::db begin_work failed: Already in a transaction at /usr/local/squeezeboxserver/Slim/Schema/Storage.pm line 86 [10-06-14 12:07:19.6282] Slim::Schema::Storage::throw_exception (82) Backtrace: frame 0: Slim::Utils::Log::logBacktrace (/usr/local/squeezeboxserver/Slim/Schema/Storage.pm line 82) frame 1: Slim::Schema::Storage::throw_exception (/usr/local/lib/perl5/site_perl/5.8.9/DBIx/Class/Storage/DBI.pm line 740) frame 2: DBIx::Class::Storage::DBI::__ANON__ (/usr/local/lib/perl5/site_perl/5.8.9/Try/Tiny.pm line 98) frame 3: Try::Tiny::try (/usr/local/lib/perl5/site_perl/5.8.9/DBIx/Class/Storage/DBI.pm line 749) frame 4: DBIx::Class::Storage::DBI::dbh_do (/usr/local/lib/perl5/site_perl/5.8.9/DBIx/Class/Storage/DBI.pm line 1324) frame 5: DBIx::Class::Storage::DBI::_dbh_begin_work (/usr/local/lib/perl5/site_perl/5.8.9/DBIx/Class/Storage/DBI.pm line 1305) frame 6: DBIx::Class::Storage::DBI::txn_begin (/usr/local/lib/perl5/site_perl/5.8.9/DBIx/Class/Storage/TxnScopeGuard.pm line 12) frame 7: DBIx::Class::Storage::TxnScopeGuard::new (/usr/local/lib/perl5/site_perl/5.8.9/DBIx/Class/Storage.pm line 333) frame 8: DBIx::Class::Storage::txn_scope_guard (/usr/local/lib/perl5/site_perl/5.8.9/DBIx/Class/Schema.pm line 672) frame 9: DBIx::Class::Schema::txn_scope_guard (/usr/local/lib/perl5/site_perl/5.8.9/DBIx/Class/Relationship/CascadeActions.pm line 49) frame 10: DBIx::Class::Relationship::CascadeActions::update (/usr/local/squeezeboxserver/Slim/Schema/DBI.pm line 39) frame 11: Slim::Schema::DBI::update (/usr/local/squeezeboxserver/Slim/Schema.pm line 2766) frame 12: Slim::Schema::_postCheckAttributes (/usr/local/squeezeboxserver/Slim/Schema.pm line 1079) frame 13: Slim::Schema::newTrack (/usr/local/squeezeboxserver/Slim/Utils/Scanner.pm line 347) frame 14: Slim::Utils::Scanner::scanDirectory (/usr/local/squeezeboxserver/Slim/Music/MusicFolderScan.pm line 79) frame 15: Slim::Music::MusicFolderScan::startScan (/usr/local/squeezeboxserver/Slim/Music/Import.pm line 568) frame 16: Slim::Music::Import::runImporter (/usr/local/squeezeboxserver/Slim/Music/Import.pm line 373) frame 17: Slim::Music::Import::runScan (/usr/local/squeezeboxserver/scanner.pl line 305) frame 18: (eval) (/usr/local/squeezeboxserver/scanner.pl line 299) frame 19: main::main (/usr/local/squeezeboxserver/scanner.pl line 454) [10-06-14 12:07:19.6318] main::main (311) Error: Failed when running main scan: [Carp::Clan::__ANON__(): DBI Exception: DBD::mysql::db begin_work failed: Already in a transaction at /usr/local/squeezeboxserver/Slim/Schema/Storage.pm line 86 ] [10-06-14 12:07:19.6324] main::main (312) Error: Skipping post-process & Not updating lastRescanTime! -- emeraldcityeg ------------------------------------------------------------------------ emeraldcityeg's Profile: http://forums.slimdevices.com/member.php?userid=4782 View this thread: http://forums.slimdevices.com/showthread.php?t=79669 _______________________________________________ unix mailing list [email protected] http://lists.slimdevices.com/mailman/listinfo/unix
