PDA

View Full Version : Failed to add tracks to playlist - already in a transaction



lerouxt
2007-08-26, 09:58
I'm running the following:


SlimServer Version: 6.5.5 - 12728 - Debian - EN - iso-8859-1
Server IP address: 192.168.1.3
Perl Version: 5.8.8 i486-linux-gnu-thread-multi
MySQL Version: 5.0.45-Debian_1

And receive the following errors fairly regularly.. any ideas?


2007-08-26 10:40:35 slimserver_safe started.
2007-08-26 11:48:02.5353 ERROR: DBI Exception: DBD::mysql::db begin_work failed: Already in a transaction
2007-08-26 11:48:02.5354 ERROR: Backtrace follows:

2007-08-26 11:48:02.5356 Backtrace:

frame 0: Slim::Schema::Storage::throw_exception (/usr/share/perl5/DBIx/Class/Storage/DBI.pm line 772)
frame 1: DBIx::Class::Storage::DBI::__ANON__ (/usr/share/perl5/DBIx/Class/Storage/DBI.pm line 798)
frame 2: DBIx::Class::Storage::DBI::txn_begin (/usr/share/perl5/DBIx/Class/Storage/DBI.pm line 596)
frame 3: (eval) (/usr/share/perl5/DBIx/Class/Storage/DBI.pm line 592)
frame 4: DBIx::Class::Storage::DBI::txn_do (/usr/share/perl5/DBIx/Class/Schema.pm line 728)
frame 5: DBIx::Class::Schema::txn_do (/usr/share/perl5/Slim/Schema/Playlist.pm line 46)
frame 6: (eval) (/usr/share/perl5/Slim/Schema/Playlist.pm line 39)
frame 7: Slim::Schema::Playlist::setTracks (/usr/share/perl5/Slim/Player/Playlist.pm line 757)
frame 8: Slim::Player::Playlist::modifyPlaylistCallback (/usr/share/perl5/Slim/Control/Request.pm line 1645)
frame 9: (eval) (/usr/share/perl5/Slim/Control/Request.pm line 1645)
frame 10: Slim::Control::Request::notify (/usr/share/perl5/Slim/Control/Request.pm line 751)
frame 11: Slim::Control::Request::checkNotifications (/usr/sbin/slimserver line 476)
frame 12: main::idle (/usr/sbin/slimserver line 452)
frame 13: main::main (/usr/sbin/slimserver line 1076)

2007-08-26 11:48:02.5359 ERROR: Carp::Clan::__ANON__(): DBI Exception: DBD::mysql::db begin_work failed: Already in a transaction at /usr/share/perl5/Slim/Schema/Storage.pm line 74

2007-08-26 11:48:02.5359 ERROR: Backtrace follows:

2007-08-26 11:48:02.5360 Backtrace:

frame 0: Slim::Schema::Storage::throw_exception (/usr/share/perl5/DBIx/Class/Storage/DBI.pm line 625)
frame 1: DBIx::Class::Storage::DBI::txn_do (/usr/share/perl5/DBIx/Class/Schema.pm line 728)
frame 2: DBIx::Class::Schema::txn_do (/usr/share/perl5/Slim/Schema/Playlist.pm line 46)
frame 3: (eval) (/usr/share/perl5/Slim/Schema/Playlist.pm line 39)
frame 4: Slim::Schema::Playlist::setTracks (/usr/share/perl5/Slim/Player/Playlist.pm line 757)
frame 5: Slim::Player::Playlist::modifyPlaylistCallback (/usr/share/perl5/Slim/Control/Request.pm line 1645)
frame 6: (eval) (/usr/share/perl5/Slim/Control/Request.pm line 1645)
frame 7: Slim::Control::Request::notify (/usr/share/perl5/Slim/Control/Request.pm line 751)
frame 8: Slim::Control::Request::checkNotifications (/usr/sbin/slimserver line 476)
frame 9: main::idle (/usr/sbin/slimserver line 452)
frame 10: main::main (/usr/sbin/slimserver line 1076)

2007-08-26 11:48:02.5361 ERROR: setTracks: Failed to add tracks to playlist: [Carp::Clan::__ANON__(): Carp::Clan::__ANON__(): DBI Exception: DBD::mysql::db begin_work failed: Already in a transaction at /usr/share/perl5/Slim/Schema/Storage.pm line 74
]

2007-08-26 11:48:08.4054 ERROR: scanRemoteURL: Can't connect to remote server to retrieve playlist: Connect timed out.

MoeDee
2007-09-13, 13:51
I'm running the following:


SlimServer Version: 6.5.5 - 12728 - Debian - EN - iso-8859-1
Server IP address: 192.168.1.3
Perl Version: 5.8.8 i486-linux-gnu-thread-multi
MySQL Version: 5.0.45-Debian_1

..cut off the backtrace data..


I have the exact same problem.. with the exact same backtrace error and same setup:

SlimServer Version: 6.5.5 - 12987 - Debian - EN - utf8
Server IP address: 192.168.202.110
Perl Version: 5.8.8 i486-linux-gnu-thread-multi
MySQL Version: 5.0.45-Debian_1

Backtrace as in original post

However:

the MP3 coolection seems to be found and added to the sql table - I can also play tracks..
yet all my playlists do not work.

Any hint would be really nice..!!

seerdekens
2007-09-13, 14:40
I think I have the same problem, described at http://forums.slimdevices.com/showthread.php?t=38371 .

Also my playlist don't works any more and a rescan does nothing. (complete rescan fails, newly added music works)
And also albumart of new added albums are not showing up in the album list.
Already tried uninstalling, went from slimserver testing to stable with new database. Nothing seems to help.

SlimServer Version: 6.5.4 - 12568 - Debian - EN - iso-8859-1
Server IP address: 192.168.1.200
Perl Version: 5.8.8 i486-linux-gnu-thread-multi
MySQL Version: 5.0.32-Debian_7etch1

seerdekens
2007-09-14, 04:01
I got it working again. I was about to reinstall my complete system until I figured out that the problem started after doing an "apt-get upgrade" on my Debian testing machine, which updates all packages to the latest (etch) testing release.

Some perl dbi package was upgraded and caused the problem.
I'm not a perl expert, so don't ask me why ;)

Anyway, I fixed it by pinpointing some packages to the stable release instead of testing.
I did it this way:

- first make sure you have a line for Debian stable in your /etc/apt/sources.list file, like this for example:


deb http://ftp.debian.org/debian/ stable main contrib non-free

Then do an "apt-get update"

Create or edit the file "/etc/apt/preferences
and paste the following:


Package: libclass-dbi-abstractsearch-perl libclass-dbi-pager-perl libclass-dbi-perl libclass-dbi-plugin-perl libclass-dbi-plugin-retrieveall-perl libdbi-perl libdbix-class-perl libdbix-contextualfetch-perl libdbix-migration-perl libima-dbi-perl
Pin: release a=stable,c=main,o=Debian,l=Debian
Pin-Priority: 1001

Be sure to enter all packages on 1 line.

Now do an "apt-get upgrade" (or maybe in your case "apt-get dist-upgrade") and these packages will be "downgraded" to their Debian stable release.
I don't know which package exactly caused the problem, I just included all packages which have something to do with Perl and DBI.

To be sure, I restarted slimserver.

Now I have the following working again:
- rescan of complete library
- playlists
- coverart for newly scanned albums

The problem was clearly caused by Debian software, and not by Slimserver itself, but since a lot of people are running Debian testing I expect lots of users will have the same problem, at least when they update packages.

Please leave some feedback if this helped for you.

sverrehu
2007-10-31, 03:22
Anyway, I fixed it by pinpointing some packages to the stable release instead of testing.

Cool, dude! Alhough I think this should actually be fixed in the slimserver itself, it's nice to have a workaround. Thanks a lot!