There's new version of squeezeboxserver - 7.4.2, hope it'll solve problems with perl 5.10.1 Reproducible: Always
changelog at http://svn.slimdevices.com/repos/slim/7.4/tags/7.4.2/server/Changelog7.html
I've just submitted the ebuild of squeezeboxserver-7.4.2 to Joe for checking and, hopefully, inclusion in Portage soon. When that's committed it should resolve this bug.
[10-03-31 16:29:30.8939] main::init (320) Starting Squeezebox Server (v7.4.2, r30215, Fri Feb 19 16:24:40 MST 2010) perl 5.010001 [10-03-31 16:29:32.2509] Plugins::SqueezeScrobbler::Plugin::BEGIN (74) Added Scrobbler logger [10-03-31 16:29:32.3551] Plugins::NPRRadio::Metadata::init (21) Register NPR meta provider, default icon= [10-03-31 16:29:32.3561] Plugins::SqueezeScrobbler::Scrobbler::initDatabase (713) Checking if slimscrobbler_tracks database table exists [10-03-31 16:29:32.3564] Slim::Utils::PluginManager::load (325) Warning: Couldn't call Plugins::SqueezeScrobbler::Plugin->initPlugin: Can't call method "dbh"$ [10-03-31 16:29:32.3574] Plugins::SugarCube::Plugin::initPlugin (184) SugarCube: Setting execute callback [10-03-31 16:30:56.2850] Slim::Schema::Storage::throw_exception (82) Error: DBI Connection failed: DBI connect('database=squeezeboxserver;mysql_socket=/var/r$ [10-03-31 16:30:56.2855] Slim::Schema::Storage::throw_exception (82) Backtrace: frame 0: Slim::Utils::Log::logBacktrace (/usr/lib64/perl5/vendor_perl/5.10.1/Slim/Schema/Storage.pm line 82) frame 1: Slim::Schema::Storage::throw_exception (/usr/lib64/perl5/vendor_perl/5.10.1/DBIx/Class/Storage/DBI.pm line 1076) frame 2: DBIx::Class::Storage::DBI::_connect (/usr/lib64/perl5/vendor_perl/5.10.1/DBIx/Class/Storage/DBI.pm line 906) frame 3: DBIx::Class::Storage::DBI::_populate_dbh (/usr/lib64/perl5/vendor_perl/5.10.1/DBIx/Class/Storage/DBI.pm line 842) frame 4: DBIx::Class::Storage::DBI::ensure_connected (/usr/lib64/perl5/vendor_perl/5.10.1/Slim/Schema/Storage.pm line 41) frame 5: (eval) (/usr/lib64/perl5/vendor_perl/5.10.1/Slim/Schema/Storage.pm line 41) frame 6: Slim::Schema::Storage::dbh (/usr/lib64/perl5/vendor_perl/5.10.1/Slim/Schema.pm line 291) frame 7: Slim::Schema::_connect (/usr/lib64/perl5/vendor_perl/5.10.1/Slim/Schema.pm line 127) frame 8: Slim::Schema::init (/usr/lib64/perl5/vendor_perl/5.10.1/Slim/Music/Import.pm line 745) frame 9: Slim::Music::Import::_checkLibraryStatus (/usr/lib64/perl5/vendor_perl/5.10.1/Slim/Music/Import.pm line 678) frame 10: Slim::Music::Import::useImporter (/usr/lib64/perl5/vendor_perl/5.10.1/Slim/Music/MusicFolderScan.pm line 48) frame 11: Slim::Music::MusicFolderScan::init (/usr/lib64/perl5/vendor_perl/5.10.1/Slim/Utils/Prefs.pm line 732) frame 12: Slim::Utils::Prefs::__ANON__ (/usr/lib64/perl5/vendor_perl/5.10.1/Slim/Utils/Prefs/Base.pm line 307) frame 13: Slim::Utils::Prefs::Base::set (/usr/lib64/perl5/vendor_perl/5.10.1/Slim/Web/Settings.pm line 157) frame 14: Slim::Web::Settings::handler (/usr/lib64/perl5/vendor_perl/5.10.1/Slim/Web/Settings/Server/Basic.pm line 101) frame 15: Slim::Web::Settings::Server::Basic::handler (/usr/lib64/perl5/vendor_perl/5.10.1/Slim/Web/HTTP.pm line 1107) frame 16: Slim::Web::HTTP::generateHTTPResponse (/usr/lib64/perl5/vendor_perl/5.10.1/Slim/Web/HTTP.pm line 913) frame 17: Slim::Web::HTTP::processURL (/usr/lib64/perl5/vendor_perl/5.10.1/Slim/Web/HTTP.pm line 724) frame 18: Slim::Web::HTTP::processHTTP (/usr/lib64/perl5/vendor_perl/5.10.1/Slim/Networking/IO/Select.pm line 139) frame 19: (eval) (/usr/lib64/perl5/vendor_perl/5.10.1/Slim/Networking/IO/Select.pm line 123) frame 20: Slim::Networking::IO::Select::__ANON__ (/usr/lib64/perl5/vendor_perl/5.10.1/Slim/Networking/IO/Select.pm line 183) frame 21: (eval) (/usr/lib64/perl5/vendor_perl/5.10.1/Slim/Networking/IO/Select.pm line 183) frame 22: Slim::Networking::IO::Select::loop (/usr/sbin/squeezeboxserver line 621) frame 23: main::idle (/usr/sbin/squeezeboxserver line 575) frame 24: main::main (/usr/sbin/squeezeboxserver line 1066) [10-03-31 16:30:56.2859] Slim::Schema::init (130) Error: Couldn't connect to database! Fatal error: [] Exiting! [10-03-31 16:30:56.2862] Slim::Schema::init (130) Backtrace: frame 0: Slim::Utils::Log::logBacktrace (/usr/lib64/perl5/vendor_perl/5.10.1/Slim/Schema.pm line 130) frame 1: Slim::Schema::init (/usr/lib64/perl5/vendor_perl/5.10.1/Slim/Music/Import.pm line 745) frame 2: Slim::Music::Import::_checkLibraryStatus (/usr/lib64/perl5/vendor_perl/5.10.1/Slim/Music/Import.pm line 678) frame 3: Slim::Music::Import::useImporter (/usr/lib64/perl5/vendor_perl/5.10.1/Slim/Music/MusicFolderScan.pm line 48) frame 4: Slim::Music::MusicFolderScan::init (/usr/lib64/perl5/vendor_perl/5.10.1/Slim/Utils/Prefs.pm line 732) frame 5: Slim::Utils::Prefs::__ANON__ (/usr/lib64/perl5/vendor_perl/5.10.1/Slim/Utils/Prefs/Base.pm line 307) frame 6: Slim::Utils::Prefs::Base::set (/usr/lib64/perl5/vendor_perl/5.10.1/Slim/Web/Settings.pm line 157) frame 7: Slim::Web::Settings::handler (/usr/lib64/perl5/vendor_perl/5.10.1/Slim/Web/Settings/Server/Basic.pm line 101) frame 8: Slim::Web::Settings::Server::Basic::handler (/usr/lib64/perl5/vendor_perl/5.10.1/Slim/Web/HTTP.pm line 1107) frame 9: Slim::Web::HTTP::generateHTTPResponse (/usr/lib64/perl5/vendor_perl/5.10.1/Slim/Web/HTTP.pm line 913) frame 10: Slim::Web::HTTP::processURL (/usr/lib64/perl5/vendor_perl/5.10.1/Slim/Web/HTTP.pm line 724) frame 11: Slim::Web::HTTP::processHTTP (/usr/lib64/perl5/vendor_perl/5.10.1/Slim/Networking/IO/Select.pm line 139) frame 12: (eval) (/usr/lib64/perl5/vendor_perl/5.10.1/Slim/Networking/IO/Select.pm line 123) frame 13: Slim::Networking::IO::Select::__ANON__ (/usr/lib64/perl5/vendor_perl/5.10.1/Slim/Networking/IO/Select.pm line 183) frame 14: (eval) (/usr/lib64/perl5/vendor_perl/5.10.1/Slim/Networking/IO/Select.pm line 183) frame 15: Slim::Networking::IO::Select::loop (/usr/sbin/squeezeboxserver line 621) frame 16: main::idle (/usr/sbin/squeezeboxserver line 575) frame 17: main::main (/usr/sbin/squeezeboxserver line 1066)
I have errors above during collection scan - shortly after collection scanning squeezeboxserver dies. I thinks problem is somewhere in 7.4.2 ebuild or one of perl modules (those to connect with mysql). I'm using ~x86_64 and 7.4.1 works here with no problems.
This has also been reported in bug#307119, specifically with Perl 5.10.1. I notice that the problems here are also with Perl 5.10.1. I've tested it OK (at least I can scan and play music) with my test virtual machine and Perl 5.10.1, so it's not as simple as that. I've a couple of questions: 1. Does anyone not running Perl 5.10.1 get these problems? 2. Does anyone else have this 7.4.2 test ebuild working at all (is it only me?!) Finally, I wonder whether you could post your package.keywords and "emerge --info" output so that I could see whether it is some kind of package incompatibility. I've tested it on a stable x86 with a lot of ~x86 exceptions for required Perl dependencies, but I wonder whether you're running an entire ~x86 system (ACCEPT_KEYWORDS="~x86" in make.conf, which I've not tested) or whether you've keyworded other Perl packages or MySQL that are causing this problem.
By the way, I am also under ~amd64 : Portage 2.2_rc67 (default/linux/amd64/10.0, gcc-4.4.3, glibc-2.11-r1, 2.6.33-gentoo x86_64) ================================================================= System uname: Linux-2.6.33-gentoo-x86_64-Intel-R-_Core-TM-2_CPU_6600_@_2.40GHz-with-gentoo-2.0.1 Timestamp of tree: Thu, 01 Apr 2010 05:45:02 +0000 app-shells/bash: 4.1_p2-r1 dev-java/java-config: 2.1.10 dev-lang/python: 2.5.4-r2, 2.6.5-r1, 3.1.2-r1 dev-python/pycrypto: 2.0.1-r8 dev-util/cmake: 2.8.1 sys-apps/baselayout: 2.0.1 sys-apps/openrc: 0.6.1-r1 sys-apps/sandbox: 2.2 sys-devel/autoconf: 2.13, 2.65 sys-devel/automake: 1.4_p6-r1, 1.5, 1.7.9-r1, 1.8.5-r3, 1.9.6-r2, 1.10.3, 1.11.1 sys-devel/binutils: 2.20.1 sys-devel/gcc: 4.2.4-r1, 4.4.3 sys-devel/gcc-config: 1.4.1 sys-devel/libtool: 2.2.6b virtual/os-headers: 2.6.33 ACCEPT_KEYWORDS="amd64 ~amd64" ACCEPT_LICENSE="* @FSF-APPROVED @OSI-APPROVED PUEL @EULA" CBUILD="x86_64-pc-linux-gnu" CFLAGS="-O2 -march=native -pipe" CHOST="x86_64-pc-linux-gnu" CONFIG_PROTECT="/etc /usr/share/X11/xkb /var/lib/hsqldb" CONFIG_PROTECT_MASK="/etc/ca-certificates.conf /etc/env.d /etc/env.d/java/ /etc/fonts/fonts.conf /etc/gconf /etc/gentoo-release /etc/revdep-rebuild /etc/sandbox.d /etc/terminfo /etc/texmf/language.dat.d /etc/texmf/language.def.d /etc/texmf/updmap.d /etc/texmf/web2c" CXXFLAGS="-O2 -march=native -pipe" DISTDIR="/usr/portage/distfiles" FEATURES="assume-digests distlocks fixpackages news parallel-fetch preserve-libs protect-owned sandbox sfperms strict unmerge-logs unmerge-orphans userfetch" GENTOO_MIRRORS="http://mirror.switch.ch/mirror/gentoo/ ftp://mirror.switch.ch/mirror/gentoo/ ftp://ftp.free.fr/mirrors/ftp.gentoo.org/" LANG="en_GB.UTF-8" LC_ALL="en_GB.UTF-8" LDFLAGS="-Wl,-O1 -Wl,--as-needed" LINGUAS="en en_GB" MAKEOPTS="-j3" PKGDIR="/usr/portage/packages" PORTAGE_CONFIGROOT="/" PORTAGE_RSYNC_OPTS="--recursive --links --safe-links --perms --times --compress --force --whole-file --delete --stats --timeout=180 --exclude=/distfiles --exclude=/local --exclude=/packages" PORTAGE_TMPDIR="/var/tmp" PORTDIR="/usr/portage" PORTDIR_OVERLAY="/usr/portage/local/maintainer /usr/portage/local/layman/gechi /usr/portage/local/layman/sunrise /usr/portage/local/layman/sajinet /usr/portage/local/layman/thelinux /usr/portage/local/layman/multimedia /usr/portage/local/layman/qting-edge /usr/portage/local/layman/wirelay /usr/portage/local/layman/jokey /usr/local/portage" SYNC="rsync://rsync.ch.gentoo.org/gentoo-portage" USE="3dnowext 64bit 7zip X Xaw3d a52 aac aalib accessibility acl acpi additions aften aim aio alsa amd amd64 amr amrnb amrwb animation-rtl ansi aotuv ass async atm auctex audacious audiofile bash-completion berkdb bidi binary-drivers bl blas buffysize buttons bzip2 bzlib cairo caps cdda cddb cdio cdparanoia cdr chm chroot cli clisp console context cracklib crypt cryptoworks cscope css csv ctype cups curl curlwrappers cxx daap dar64 dga dhcp dhcpcd dirac divx djbfft djvu dri dts dv dvb dvd dvdnav dvdr dvdread dvi ecc emerald encode escreen exif expat extensions extra fam fame fasttrack fat fbcon ffmpeg fftw firefox firefox3 flac fltk fontconfig foomaticdb fortran fping fpx freetext ftp fts3 g15 gadu games gcj gd gdal gdbm general ggi gif gimp gimpprint ginac glibc-omitfp glitz glsa glut glx gmedia gmp gmtfull gmthigh gmtsuppl gmttria gnutella gnutls gopher gpg gpgme gpm grammar graphics graphite graphviz grass gs gtalk gtk gtk2 guile h323 hardcoded-tables hdf5 howl-compat httpd humanities iconv icq id3 id3tag idn ieee1394 imagemagick imlib inquisitio ipv6 irc ithreads jabber jack jack-tmpfs java java5 java6 javascript jbig jikes jpeg jpeg2k kerberos kig-scripting kpathsea kvm lame laptop latex lcd lcms libcaca libedit libnotify libsamplerate libtommath libvisual libwww live lj lm_sensors lnbsharing logitech-mouse logrotate lzo lzw mad matroska mbox md5sum mikmod mime mimencode mjpeg mmx mmxext mng mod modules mono motif moznocompose moznoirc moznomail moznoroaming mozsvg mozxmlterm mp140 mp160 mp2 mp3 mp4 mp4live mpeg mpeg2 mplayer msn msnextras mudflap multilib musepack music mysql nautilus ncurses nethack netpbm network networking nfs nls nntp normalizemime nptl nptlonly nsplugin nvidia nvtv offensive ogg oggvorbis ole omega on-the-fly-crypt openexr opengl openmp openssl oscar otr pam pcre pdf perl player plotutils png pnm posix pppd preview-latex pstricks psyrdo psytrellis publishers python python3 pyzor qa qhull qt3support quicktime rar readline realmedia recode reflection regex reiser4 reiserfs rss rtc rtsp sasl schroedinger science screen sdl session shl shout sid silc slang slp smime sms sndfile soundtouch sox speex spell spl sqlite srt sse sse-filters sse2 ssl ssse3 stream subtitles svg svgz sysfs szip tcl tcltk tcpd tetex theora thesaurus threads threadsafe tiff tk tomsfastmath tools transcode truetype tv_check tv_combiner twolame type1 uk_bleb uk_rt unicode usb userlocales utf8 uudeview v4l v4l2 vamp vcd vcdimager vde vdpau vdr vim vim-pager vim-syntax vim-with-x visibility vlm vorbis wavpack webdav wma wma123 wmf wmp wordperfect wv wxgtk1 wxwindows x264 xanim xattr xcb xetex xext xforms xfs xine xinerama xinetd xml xml2 xmlrpc xorg xpm xv xvid xvmc yahoo zlib" ALSA_CARDS="ali5451 als4000 atiixp atiixp-modem bt87x ca0106 cmipci emu10k1x ens1370 ens1371 es1938 es1968 fm801 hda-intel intel8x0 intel8x0m maestro3 trident usb-audio via82xx via82xx-modem ymfpci" ALSA_PCM_PLUGINS="adpcm alaw asym copy dmix dshare dsnoop empty extplug file hooks iec958 ioplug ladspa lfloat linear meter mulaw multi null plug rate route share shm softvol" APACHE2_MODULES="actions alias apache2_modules_proxy apache2_modules_proxy_ajp apache2_modules_proxy_balancer apache2_modules_proxy_connect apache2_modules_proxy_ftp apache2_modules_proxy_http auth_basic authn_alias authn_anon authn_dbm authn_default authn_file authz_dbm authz_default authz_groupfile authz_host authz_owner authz_user autoindex cache dav dav_fs dav_lock deflate dir disk_cache env expires ext_filter file_cache filter headers include info log_config logio mem_cache mime mime_magic negotiation rewrite setenvif speling status unique_id userdir usertrack vhost_alias" CAMERAS="canon" ELIBC="glibc" INPUT_DEVICES="keyboard mouse evdev" KERNEL="linux" LCD_DEVICES="g15" LINGUAS="en en_GB" QEMU_SOFTMMU_TARGETS="i386 x86_64" QEMU_USER_TARGETS="i386 x86_64" RUBY_TARGETS="ruby18" SANE_BACKENDS="pixma" USERLAND="GNU" VIDEO_CARDS="nvidia" Unset: CPPFLAGS, CTARGET, EMERGE_DEFAULT_OPTS, FFLAGS, INSTALL_MASK, PORTAGE_COMPRESS, PORTAGE_COMPRESS_FLAGS, PORTAGE_RSYNC_EXTRA_OPTS
(In reply to comment #6) > By the way, I am also under ~amd64 : > ...snip Thanks - I'll try setting up an ~x86 image for me to test (it'll be quicker to set up than an ~amd64 one), to see if I can reproduce that over the Easter break. There are so many Perl dependencies now that I wouldn't be surprised to find it's one of those ~-keyworded ones, but actually *finding* which one will be 'fun'!
I've got my ~x86 virtual machine running (Perl 5.10.1, MySQL 5.1.45). This appears to work OK for me - it starts, scans and plays, and the web interface seems to work OK. I wonder if it's an amd64 problem? I'll see if I can set up a VM for that and see how that goes - that might take me a little while, though. Meantime, if anyone could report they've got some success with this on x86 that would be helpful. At the moment we're waiting before putting this ebuild into Portage to get some feedback. Thanks.
Hey Stuart, I am on amd64, and I could try after the weekend.
I've set up an ~amd64 virtual machine and emerged this 7.4.2 ebuild and it appears to work for me, which seems strange. I can scan, browse music and play, though the web interface to a Squeezebox Receiver. Did you have any joy with it, Joe?
OK for me it's working now - I get this errors in logs but now sbs don't dies. Here's what I've done: emerge -C squeezeboxserver rm -rf /var/lib/squeezeboxserver rm -rf /etc/squeezeboxserver emerge squeezeboxserver (7.4.2 ebuild from Stuart git hub) Scanning works now - and when it'll finish scanning I'll report everything's OK. I think bug can be closed now and ebuild may be added to repo. Grégoire: please check if it works for you too I hope further updates will be easier and painless :-) Thanks Stuart for your hard work - I really appreciate it!
No change at all for me after removing it and deleting/remerging...
:-) Great new : if I don't enter my squeezecenter email and password at first setup page it works here !!! Thanks you very much for all !!
(In reply to comment #13) > :-) Great new : if I don't enter my squeezecenter email and password at first > setup page it works here !!! > > Thanks you very much for all !! > That's very good information - that's something I can look into. I admit that not being a MySqueezebox.com user that's not been very well tested. I'll look into it. Thanks for reporting that.
(In reply to comment #14) > (In reply to comment #13) > > :-) Great new : if I don't enter my squeezecenter email and password at first > > setup page it works here !!! > > > > Thanks you very much for all !! > > > > That's very good information - that's something I can look into. I admit that > not being a MySqueezebox.com user that's not been very well tested. I'll look > into it. > > Thanks for reporting that. > Odd - I've tried configuring for MySqueezebox.com on my test ~amd64 installation and it works for me, so maybe it's not as simple as that.
Stuart, all, I had the same issue with the DB access upon upgrading to this version on amd64. As suggested above, I unmerged the package and removed /var/lib/squeezeboxserver and /etc/squeezeboxserver, then re-emerged it. This seemed to get me past the issue. So there must be some problem with lingering files in these directories. I'm going to commit this new version, but I've put a warning in the install about this. We should continue to investigate, as removing all previous config is not a great workaround.
Even I am hit by this little irritating bug and I'm starting to miss playing music through my SB. :) Today I noticed some of the perl packages got updated but still no go. If I leave EVERYTHING blank during the setup it goes through. As soon as I want to do a scan of my music library it borks.As far as I can tell it says something about not being able to connect to the DB but: it's active (mysql)
OK, forget it. It seems to be fixed now. What I did was update those packages, removed the NEW database that was made by the SB server and started fresh again. Now it seems to be purring away again.
Ok, scratch that remark too. Here is the log for scanning the directory. It seems to be scanning one song and than stops again: [10-04-15 11:39:35.9132] Slim::Schema::Storage::throw_exception (82) Backtrace: frame 0: Slim::Utils::Log::logBacktrace (/usr/lib/perl5/vendor_perl/5.8.8/Slim/Schema/Storage.pm line 82) frame 1: Slim::Schema::Storage::throw_exception (/usr/lib/perl5/vendor_perl/5.8.8/DBIx/Class/Storage/DBI.pm line 1111) frame 2: DBIx::Class::Storage::DBI::__ANON__ (/usr/lib/perl5/vendor_perl/5.8.8/DBIx/Class/Storage/DBI.pm line 1250) frame 3: DBIx::Class::Storage::DBI::__ANON__ (/usr/lib/perl5/vendor_perl/5.8.8/DBIx/Class/Storage/DBI.pm line 648) frame 4: (eval) (/usr/lib/perl5/vendor_perl/5.8.8/DBIx/Class/Storage/DBI.pm line 639) frame 5: DBIx::Class::Storage::DBI::dbh_do (/usr/lib/perl5/vendor_perl/5.8.8/DBIx/Class/Storage/DBI.pm line 1250) frame 6: DBIx::Class::Storage::DBI::_dbh_begin_work (/usr/lib/perl5/vendor_perl/5.8.8/DBIx/Class/Storage/DBI.pm line 1231) frame 7: DBIx::Class::Storage::DBI::txn_begin (/usr/lib/perl5/vendor_perl/5.8.8/DBIx/Class/Storage/TxnScopeGuard.pm line 10) frame 8: DBIx::Class::Storage::TxnScopeGuard::new (/usr/lib/perl5/vendor_perl/5.8.8/DBIx/Class/Storage.pm line 333) frame 9: DBIx::Class::Storage::txn_scope_guard (/usr/lib/perl5/vendor_perl/5.8.8/DBIx/Class/Schema.pm line 665) frame 10: DBIx::Class::Schema::txn_scope_guard (/usr/lib/perl5/vendor_perl/5.8.8/DBIx/Class/Relationship/CascadeActions.pm line 49) frame 11: DBIx::Class::Relationship::CascadeActions::update (/usr/lib/perl5/vendor_perl/5.8.8/Slim/Schema/DBI.pm line 39) frame 12: Slim::Schema::DBI::update (/usr/lib/perl5/vendor_perl/5.8.8/Slim/Schema.pm line 2743) frame 13: Slim::Schema::_postCheckAttributes (/usr/lib/perl5/vendor_perl/5.8.8/Slim/Schema.pm line 1059) frame 14: Slim::Schema::newTrack (/usr/lib/perl5/vendor_perl/5.8.8/Slim/Utils/Scanner.pm line 347) frame 15: Slim::Utils::Scanner::scanDirectory (/usr/lib/perl5/vendor_perl/5.8.8/Slim/Music/MusicFolderScan.pm line 79) frame 16: Slim::Music::MusicFolderScan::startScan (/usr/lib/perl5/vendor_perl/5.8.8/Slim/Music/Import.pm line 569) frame 17: Slim::Music::Import::runImporter (/usr/lib/perl5/vendor_perl/5.8.8/Slim/Music/Import.pm line 374) frame 18: Slim::Music::Import::runScan (/usr/sbin/squeezeboxserver-scanner line 294) frame 19: (eval) (/usr/sbin/squeezeboxserver-scanner line 288) frame 20: main::main (/usr/sbin/squeezeboxserver-scanner line 439) [10-04-15 11:39:35.9136] Slim::Schema::Storage::throw_exception (82) Error: Carp::Clan::__ANON__(): DBI Exception: DBD::mysql::db begin_work failed: Already in a transaction at /usr/lib/perl5/vendor_perl/5.8.8/Slim/Schema/Storage.pm line 86 [10-04-15 11:39:35.9139] Slim::Schema::Storage::throw_exception (82) Backtrace: frame 0: Slim::Utils::Log::logBacktrace (/usr/lib/perl5/vendor_perl/5.8.8/Slim/Schema/Storage.pm line 82) frame 1: Slim::Schema::Storage::throw_exception (/usr/lib/perl5/vendor_perl/5.8.8/DBIx/Class/Storage/DBI.pm line 656) frame 2: DBIx::Class::Storage::DBI::dbh_do (/usr/lib/perl5/vendor_perl/5.8.8/DBIx/Class/Storage/DBI.pm line 1250) frame 3: DBIx::Class::Storage::DBI::_dbh_begin_work (/usr/lib/perl5/vendor_perl/5.8.8/DBIx/Class/Storage/DBI.pm line 1231) frame 4: DBIx::Class::Storage::DBI::txn_begin (/usr/lib/perl5/vendor_perl/5.8.8/DBIx/Class/Storage/TxnScopeGuard.pm line 10) frame 5: DBIx::Class::Storage::TxnScopeGuard::new (/usr/lib/perl5/vendor_perl/5.8.8/DBIx/Class/Storage.pm line 333) frame 6: DBIx::Class::Storage::txn_scope_guard (/usr/lib/perl5/vendor_perl/5.8.8/DBIx/Class/Schema.pm line 665) frame 7: DBIx::Class::Schema::txn_scope_guard (/usr/lib/perl5/vendor_perl/5.8.8/DBIx/Class/Relationship/CascadeActions.pm line 49) frame 8: DBIx::Class::Relationship::CascadeActions::update (/usr/lib/perl5/vendor_perl/5.8.8/Slim/Schema/DBI.pm line 39) frame 9: Slim::Schema::DBI::update (/usr/lib/perl5/vendor_perl/5.8.8/Slim/Schema.pm line 2743) frame 10: Slim::Schema::_postCheckAttributes (/usr/lib/perl5/vendor_perl/5.8.8/Slim/Schema.pm line 1059) frame 11: Slim::Schema::newTrack (/usr/lib/perl5/vendor_perl/5.8.8/Slim/Utils/Scanner.pm line 347) frame 12: Slim::Utils::Scanner::scanDirectory (/usr/lib/perl5/vendor_perl/5.8.8/Slim/Music/MusicFolderScan.pm line 79) frame 13: Slim::Music::MusicFolderScan::startScan (/usr/lib/perl5/vendor_perl/5.8.8/Slim/Music/Import.pm line 569) frame 14: Slim::Music::Import::runImporter (/usr/lib/perl5/vendor_perl/5.8.8/Slim/Music/Import.pm line 374) frame 15: Slim::Music::Import::runScan (/usr/sbin/squeezeboxserver-scanner line 294) frame 16: (eval) (/usr/sbin/squeezeboxserver-scanner line 288) frame 17: main::main (/usr/sbin/squeezeboxserver-scanner line 439) [10-04-15 11:39:35.9147] main::main (300) Error: Failed when running main scan: [Carp::Clan::__ANON__(): DBI Exception: DBD::mysql::db begin_work failed: Already in a transaction at /usr/lib/perl5/vendor_perl/5.8.8/Slim/Schema/Storage.pm line 86 ] [10-04-15 11:39:35.9149] main::main (301) Error: Skipping post-process & Not updating lastRescanTime!
(In reply to comment #19) > Ok, scratch that remark too. Here is the log for scanning the directory. It > seems to be scanning one song and than stops again: > ...snip... Sorry you're having trouble. It's possible that there is a specific music file that is causing the scan to fall over, rather than it necessarily being a SBS problem itself (although arguably it wouldn't be handling it very well if it just bombed out like that) - I've heard a similar story on the unix SBS forum. Would it be possible for you to enable import info logging and seeing it it's a particular file it fails on. Setting "scan.scanner" to "Info" on the server advanced logging settings would do it. If it gets through several files before falling over it may indicate that it's a problem with the format or tags on that one file specifically. Experimenting with pointing the server to a specific album's directly (maybe in a different file format), may help to test that. That's not to say it's not a SBS/ebuild bug, but it'll help to try to narrow it down. It's possible that one of the packages we depend on needs to be updated to overcome this.
I have done what you asked. This is from the scanner log now. Haven't cleared out my MP3 dir on the server. Still same behaviour, seemingly scanning 1 file and then spewing things about db server being in a transaction. [10-04-16 17:59:59.5956] main::main (184) Starting Squeezebox Server scanner (v7.4.2, r30215, Fri Feb 19 16:24:40 MST 2010) perl 5.008008 [10-04-16 17:59:59.6413] Carp::Clan::__ANON__ (227) Warning: Class::C3::Componentised::load_components(): Use of DBIx::Class::UTF8Columns is strongly discouraged. See documentationm of DBIx::Class::UTF8Columns for more info [10-04-16 17:59:59.6910] Slim::Music::Import::addImporter (547) Adding Slim::Music::PlaylistFolderScan Scan [10-04-16 17:59:59.6913] Slim::Music::Import::addImporter (547) Adding Slim::Music::MusicFolderScan Scan [10-04-16 17:59:59.6915] Slim::Music::Import::countImporters (616) Found importer: Slim::Music::MusicFolderScan [10-04-16 17:59:59.8022] Slim::Schema::wipeCaches (1573) Wiped all in-memory caches. [10-04-16 17:59:59.8024] Slim::Schema::wipeDB (396) Start schema_clear [10-04-16 17:59:59.8050] Slim::Schema::wipeDB (412) End schema_clear [10-04-16 17:59:59.8052] Slim::Schema::wipeAllData (1588) Wiped the database. [10-04-16 17:59:59.8054] main::main (260) Removing artwork cache... [10-04-16 17:59:59.8071] Slim::Music::Import::runImporter (567) Starting Slim::Music::MusicFolderScan scan [10-04-16 17:59:59.8073] Slim::Music::MusicFolderScan::startScan (77) Starting music folder scan in /home/herald/mp3 [10-04-16 17:59:59.8077] Slim::Utils::Scanner::scanDirectory (289) About to look for files in /home/herald/mp3 [10-04-16 17:59:59.8090] Slim::Utils::Scanner::scanDirectory (290) For files with extensions in: pcmapewmawvm4am4bmp4aacwavwavemp3mp2flcflacflamovmp+mpcoggogaaifaiffcue [10-04-16 18:00:00.3882] Slim::Utils::Scanner::scanDirectory (320) Found 2035 files in /home/herald/mp3 [10-04-16 18:00:00.3892] Slim::Utils::Scanner::scanDirectory (333) Scanning: /home/herald/mp3/01 Devour.mp3 [10-04-16 18:00:00.3958] Slim::Formats::MP3::doTagMapping (398) Warning: Use of uninitialized value in concatenation (.) or string at /usr/lib/perl5/vendor_perl/5.8.8/Slim/Formats/MP3.pm line 400. [10-04-16 18:00:00.3961] Slim::Formats::MP3::doTagMapping (398) Warning: Use of uninitialized value in concatenation (.) or string at /usr/lib/perl5/vendor_perl/5.8.8/Slim/Formats/MP3.pm line 400. [10-04-16 18:00:00.3963] Slim::Formats::MP3::doTagMapping (398) Warning: Use of uninitialized value in concatenation (.) or string at /usr/lib/perl5/vendor_perl/5.8.8/Slim/Formats/MP3.pm line 400. [10-04-16 18:00:00.3966] Slim::Formats::readTags (262) Warning: Use of uninitialized value in substitution (s///) at /usr/lib/perl5/vendor_perl/5.8.8/Slim/Formats.pm line 262. [10-04-16 18:00:00.3968] Slim::Formats::readTags (263) Warning: Use of uninitialized value in substitution (s///) at /usr/lib/perl5/vendor_perl/5.8.8/Slim/Formats.pm line 263. [10-04-16 18:00:00.4148] Slim::Schema::Storage::throw_exception (82) Error: DBI Exception: DBD::mysql::db begin_work failed: Already in a transaction [10-04-16 18:00:00.4152] Slim::Schema::Storage::throw_exception (82) Backtrace: frame 0: Slim::Utils::Log::logBacktrace (/usr/lib/perl5/vendor_perl/5.8.8/Slim/Schema/Storage.pm line 82) frame 1: Slim::Schema::Storage::throw_exception (/usr/lib/perl5/vendor_perl/5.8.8/DBIx/Class/Storage/DBI.pm line 1111) frame 2: DBIx::Class::Storage::DBI::__ANON__ (/usr/lib/perl5/vendor_perl/5.8.8/DBIx/Class/Storage/DBI.pm line 1250) frame 3: DBIx::Class::Storage::DBI::__ANON__ (/usr/lib/perl5/vendor_perl/5.8.8/DBIx/Class/Storage/DBI.pm line 648) frame 4: (eval) (/usr/lib/perl5/vendor_perl/5.8.8/DBIx/Class/Storage/DBI.pm line 639) frame 5: DBIx::Class::Storage::DBI::dbh_do (/usr/lib/perl5/vendor_perl/5.8.8/DBIx/Class/Storage/DBI.pm line 1250) frame 6: DBIx::Class::Storage::DBI::_dbh_begin_work (/usr/lib/perl5/vendor_perl/5.8.8/DBIx/Class/Storage/DBI.pm line 1231) frame 7: DBIx::Class::Storage::DBI::txn_begin (/usr/lib/perl5/vendor_perl/5.8.8/DBIx/Class/Storage/TxnScopeGuard.pm line 10) frame 8: DBIx::Class::Storage::TxnScopeGuard::new (/usr/lib/perl5/vendor_perl/5.8.8/DBIx/Class/Storage.pm line 333) frame 9: DBIx::Class::Storage::txn_scope_guard (/usr/lib/perl5/vendor_perl/5.8.8/DBIx/Class/Schema.pm line 665) frame 10: DBIx::Class::Schema::txn_scope_guard (/usr/lib/perl5/vendor_perl/5.8.8/DBIx/Class/Relationship/CascadeActions.pm line 49) frame 11: DBIx::Class::Relationship::CascadeActions::update (/usr/lib/perl5/vendor_perl/5.8.8/Slim/Schema/DBI.pm line 39) frame 12: Slim::Schema::DBI::update (/usr/lib/perl5/vendor_perl/5.8.8/Slim/Schema.pm line 2743) frame 13: Slim::Schema::_postCheckAttributes (/usr/lib/perl5/vendor_perl/5.8.8/Slim/Schema.pm line 1059) frame 14: Slim::Schema::newTrack (/usr/lib/perl5/vendor_perl/5.8.8/Slim/Utils/Scanner.pm line 347) frame 15: Slim::Utils::Scanner::scanDirectory (/usr/lib/perl5/vendor_perl/5.8.8/Slim/Music/MusicFolderScan.pm line 79) frame 16: Slim::Music::MusicFolderScan::startScan (/usr/lib/perl5/vendor_perl/5.8.8/Slim/Music/Import.pm line 569) frame 17: Slim::Music::Import::runImporter (/usr/lib/perl5/vendor_perl/5.8.8/Slim/Music/Import.pm line 374) frame 18: Slim::Music::Import::runScan (/usr/sbin/squeezeboxserver-scanner line 294) frame 19: (eval) (/usr/sbin/squeezeboxserver-scanner line 288) frame 20: main::main (/usr/sbin/squeezeboxserver-scanner line 439) [10-04-16 18:00:00.4155] Slim::Schema::Storage::throw_exception (82) Error: Carp::Clan::__ANON__(): DBI Exception: DBD::mysql::db begin_work failed: Already in a transaction at /usr/lib/perl5/vendor_perl/5.8.8/Slim/Schema/Storage.pm line 86 [10-04-16 18:00:00.4158] Slim::Schema::Storage::throw_exception (82) Backtrace: frame 0: Slim::Utils::Log::logBacktrace (/usr/lib/perl5/vendor_perl/5.8.8/Slim/Schema/Storage.pm line 82) frame 1: Slim::Schema::Storage::throw_exception (/usr/lib/perl5/vendor_perl/5.8.8/DBIx/Class/Storage/DBI.pm line 656) frame 2: DBIx::Class::Storage::DBI::dbh_do (/usr/lib/perl5/vendor_perl/5.8.8/DBIx/Class/Storage/DBI.pm line 1250) frame 3: DBIx::Class::Storage::DBI::_dbh_begin_work (/usr/lib/perl5/vendor_perl/5.8.8/DBIx/Class/Storage/DBI.pm line 1231) frame 4: DBIx::Class::Storage::DBI::txn_begin (/usr/lib/perl5/vendor_perl/5.8.8/DBIx/Class/Storage/TxnScopeGuard.pm line 10) frame 5: DBIx::Class::Storage::TxnScopeGuard::new (/usr/lib/perl5/vendor_perl/5.8.8/DBIx/Class/Storage.pm line 333) frame 6: DBIx::Class::Storage::txn_scope_guard (/usr/lib/perl5/vendor_perl/5.8.8/DBIx/Class/Schema.pm line 665) frame 7: DBIx::Class::Schema::txn_scope_guard (/usr/lib/perl5/vendor_perl/5.8.8/DBIx/Class/Relationship/CascadeActions.pm line 49) frame 8: DBIx::Class::Relationship::CascadeActions::update (/usr/lib/perl5/vendor_perl/5.8.8/Slim/Schema/DBI.pm line 39) frame 9: Slim::Schema::DBI::update (/usr/lib/perl5/vendor_perl/5.8.8/Slim/Schema.pm line 2743) frame 10: Slim::Schema::_postCheckAttributes (/usr/lib/perl5/vendor_perl/5.8.8/Slim/Schema.pm line 1059) frame 11: Slim::Schema::newTrack (/usr/lib/perl5/vendor_perl/5.8.8/Slim/Utils/Scanner.pm line 347) frame 12: Slim::Utils::Scanner::scanDirectory (/usr/lib/perl5/vendor_perl/5.8.8/Slim/Music/MusicFolderScan.pm line 79) frame 13: Slim::Music::MusicFolderScan::startScan (/usr/lib/perl5/vendor_perl/5.8.8/Slim/Music/Import.pm line 569) frame 14: Slim::Music::Import::runImporter (/usr/lib/perl5/vendor_perl/5.8.8/Slim/Music/Import.pm line 374) frame 15: Slim::Music::Import::runScan (/usr/sbin/squeezeboxserver-scanner line 294) frame 16: (eval) (/usr/sbin/squeezeboxserver-scanner line 288) frame 17: main::main (/usr/sbin/squeezeboxserver-scanner line 439) [10-04-16 18:00:00.4167] main::main (300) Error: Failed when running main scan: [Carp::Clan::__ANON__(): DBI Exception: DBD::mysql::db begin_work failed: Already in a transaction at /usr/lib/perl5/vendor_perl/5.8.8/Slim/Schema/Storage.pm line 86 ] [10-04-16 18:00:00.4169] main::main (301) Error: Skipping post-process & Not updating lastRescanTime!
(In reply to comment #21) I had exactly the same problem after upgrading to 7.4.2 - I couldn't scan my library and got the same errors about DB transaction. After a bit of digging and guesswork, I've downgraded some of my perl packages that I had ~x86'd for the 7.4.2 upgrade. My approach with applying ~x86 was to just ~x86 the latest version of the package rather than the specific version that it asks for (mainly because this is easier!) But it seems this causes this problem. I've backed out the versions of: =dev-perl/Audio-Scan-0.59 ~x86 - latest version is about 0.77 dev-perl/DBI - now running the latest stable "x86" dev-perl/Class-DBI - now running the latest stable "x86" =dev-perl/DBIx-Class-0.08120 ~x86 - note latest version if 0.08121 I did the Audio-Scan downgrade first (was using latest version 0.77?) and that seemed to fix one issue about a bug with concatenating an initialized value, but the DB transaction issue was still there. So I did the others. I'm not sure which actually fixed the issue, but my scan has now completed and I have my library back. I did find that to downgrade I had to "emerge -C" to remove the packages I wanted to downgrade and then emerge --upgrade to pull them back in at the older version. Hope this helps someone! And thanks to Stuart for your work on the ebuilds :-)
(In reply to comment #22) Thanks Stuart for you ebuild work. I can confirm that, after some pain upgrading 7.4.1 to 7.4.2 1) dev-perl/DBIx-Class-0.08121 gives the transaction related error 2) dev-perl/DBIx-Class-0.08120 works fine
(In reply to comment #23) > (In reply to comment #22) > > Thanks Stuart for you ebuild work. > > I can confirm that, after some pain upgrading 7.4.1 to 7.4.2 > 1) dev-perl/DBIx-Class-0.08121 gives the transaction related error > 2) dev-perl/DBIx-Class-0.08120 works fine > Thanks for the report - I'll see if I can reproduce that and I can add a version dependency to bar that newer version if necessary. Are you on x86 or amd64, by the way?
(In reply to comment #24) > (In reply to comment #23) > > (In reply to comment #22) > > > > Thanks Stuart for you ebuild work. > > > > I can confirm that, after some pain upgrading 7.4.1 to 7.4.2 > > 1) dev-perl/DBIx-Class-0.08121 gives the transaction related error > > 2) dev-perl/DBIx-Class-0.08120 works fine > > > > Thanks for the report - I'll see if I can reproduce that and I can add a > version dependency to bar that newer version if necessary. Are you on x86 or > amd64, by the way? x86 here. I guess that was my problem as well.
Yes, on mostly x86 (and for squeezboxserver and a few others on ~x86) downgrading the DBIx-Class removed the scan stopper. Just makes you wonder what is different between those version. But at least I can use my Squeebox again the way it was intended to. :)
(In reply to comment #26) > Yes, on mostly x86 (and for squeezboxserver and a few others on ~x86) > downgrading the DBIx-Class removed the scan stopper. Just makes you wonder what > is different between those version. But at least I can use my Squeebox again > the way it was intended to. :) > Great news. I'll see if I can get the ebuild tweaked to specify that version as the dependency. Thanks everyone for helping to track it down and test.
Added Stuart's patched squeezeboxserver-7.4.2-r1 that requires the correct version.
(In reply to comment #28) > Added Stuart's patched squeezeboxserver-7.4.2-r1 that requires the correct > version. > Thank you, that also fixed it on amd64. Great work guys ! :)
