Bugzilla Bug 290662

~ $ amarok
Object::connect: No such signal BrowserCategoryList::leavingTree()
Object::connect:  (sender name:   'internet')
InnoDB: The InnoDB memory heap is disabled
InnoDB: use atomic builtins.
InnoDB: The log sequence number in ibdata files does not match
InnoDB: the log sequence number in the ib_logfiles!
091027  0:54:15  InnoDB: Database was not shut down normally!
InnoDB: Starting crash recovery.
InnoDB: Reading tablespace information from the .ibd files...
InnoDB: Restoring possible half-written data pages from the doublewrite
InnoDB: buffer...
<unknown program name>(20369)/: Communication problem with  "amarok" , it
probably crashed.
Error message was:  "org.freedesktop.DBus.Error.NoReply" : " "Message did not
receive a reply (timeout by message bus)" "


Reproducible: Always

Missing backtrace [1] and emerge --info.

[1] http://www.gentoo.org/proj/en/qa/backtraces.xml

Please reopen when you have the backtrace.

Created an attachment (id=208380) [details]
--info file

Placed --info file

I said missing backtrace.

Here is upstream bugs:
https://bugs.kde.org/show_bug.cgi?id=191644
https://bugs.kde.org/show_bug.cgi?id=190184

Created an attachment (id=208582) [details]
amarok crash

kcrash dump from amarok. The upstream bug comments seem relevant. Will check
downgrading mysql to a previous release.

Downgraded mysql to version dev-db/mysql-5.0.76-r1.
Downgraded amarok to version media-sound/amarok-2.1.1

Crash still occurs.

For each step downgrade, I performed either a reboot or a /etc/init.d/mysql
restart.

In each attempt to start amarok, I get this: 

     Executable: amarok PID: 8684 Signal: 11 (Segmentation fault)

And a simular kcrash output as I posted.

I'm not a programmer, so I don't know how to nor which other information to
garner in terms of assisting further to track this down.

I will point out that gentoo bug# 288255 might be relevant.

By default, amarok restarts where it last left off when shut down. If a dynamic
playlist was active at shutdown time, then such a playlist would be restarted
when amarok is restarted.

For now, I'm going to allow the latest version of mysql and amarok to be
emerged again on my system. At this time, I'll keep my eyes open for further
info in the hopes that someone else can successfully identify this issue.

Opened this bug report upstream: https://bugs.kde.org/show_bug.cgi?id=212324

Maybe this:'CMake Warning at /usr/share/apps/cmake/modules/KDE4Macros.cmake:626
(add_library):
  Cannot generate a safe linker search path for target
  amarok_collection-mysqlecollection because files in some directories may
  conflict with libraries in implicit directories:

    link library [libmysqlclient.so] in /usr/lib64 may be hidden by files in:
      /usr/lib64/mysql

  Some of these libraries may not be found correctly.' can help? Also, some
people saying about manual installations of amarok works (can it be ebuild
issue?).

Try removing (or moving) ~/.kde4/share/apps/amarok and see if amarok starts.
This may be caused by a bad script or version update.

Yes, after this amarok starts (and if I am moving mysqle directory only), but
after starting it shows collection update with result of 0 tracks. So it is not
working anyway.

Removing the indicated directory allows amarok to start and to play.

However, the music scan to build the database results in the following type of
error message for every entry it tries to process.

amarok:    [ERROR!] GREPME MySQL query failed! No database selected  on 
"INSERT INTO urls_temp(directory,deviceid,rpath,uniqueid) VALUES ( 0, -1,
'./pub03/Music/Artists-Bands/000-00A/Azucena - Maya [R&B]/2007 - Junkyard Jewel
(mp3)/09 - Wash Over.mp3',
'amarok-sqltrackuid://512a12c79dc2a89d9842897b8034d0aa' );"

Hope this helps.

The following information is provided in the hopes it will also be helpful:

# emerge -pv sqlite mysql

These are the packages that would be merged, in order:

Calculating dependencies... done!
[ebuild   R   ] dev-db/sqlite-3.6.20  USE="icu readline tcl threadsafe -debug
-doc -soundex" 0 kB
[ebuild   R   ] dev-db/mysql-5.0.84-r1  USE="berkdb community embedded perl ssl
-big-tables -cluster -debug -extraengine -latin1 -max-idx-128 -minimal
-profiling (-selinux) -static" 0 kB

# emerge -Cp sqlite

>>> These are the packages that would be unmerged:

 dev-db/sqlite
    selected: 2.8.16-r4 3.6.20
   protected: none
     omitted: none

Guy, please try removing the "community" patches from mysql (i.e. remove the
community USE flag) and see if that helps. Might be worth re-emerging Amarok
too.

Don't forget to run kbuildsycoca4 --noincremental after emerging Amarok; not
sure if the ebuild does it automatically.

Created an attachment (id=209858) [details]
Text showing testing steps and pertinent output

Jeff,

I disabled the "community" USE flag. I've attached a text file of all my
activities and testing results.

It looks from my "I am not a programmer" standpoint that amarok's internal
pointer/pointing method to "/var/lib/mysql/amarok" is borked on my system. If
you read through the text I've attached, you'll see why I think so.

BTW - thanks for your suggestions. I hope my testing helps.

Amarok has nothing internal pointing to such a location.

Please indicate what versions of gcc, glibc, and binutils you have. I can't
parse that paludis crap.

# emerge --info                                          
Portage 2.2_rc49 (default/linux/amd64/10.0, gcc-4.4.2, glibc-2.11-r0, 2.6.30.9
x86_64)
=================================================================               
System uname:
Linux-2.6.30.9-x86_64-AMD_Phenom-tm-_9600_Quad-Core_Processor-with-gentoo-2.0.1
Timestamp of tree: Tue, 10 Nov 2009 03:35:01 +0000                              
ccache version 2.4 [enabled]                                                    
app-shells/bash:     4.0_p35                                                    
dev-java/java-config: 2.1.9-r1                                                  
dev-lang/python:     2.5.4-r3, 2.6.4, 3.1.1-r1                                  
dev-python/pycrypto: 2.0.1-r8
dev-util/ccache:     2.4-r8
dev-util/cmake:      2.6.4-r3
sys-apps/baselayout: 2.0.1
sys-apps/openrc:     0.5.2-r2
sys-apps/sandbox:    2.2
sys-devel/autoconf:  2.13, 2.63-r1
sys-devel/automake:  1.4_p6, 1.5, 1.6.3, 1.7.9-r1, 1.8.5-r3, 1.9.6-r2, 1.10.2,
1.11
sys-devel/binutils:  2.20
sys-devel/gcc-config: 1.4.1
sys-devel/libtool:   2.2.6a
virtual/os-headers:  2.6.30-r1
ACCEPT_KEYWORDS="amd64 ~amd64"
CBUILD="x86_64-pc-linux-gnu"
CFLAGS="-march=opteron -O2 -pipe"
CHOST="x86_64-pc-linux-gnu"

Hi Jeff,

The last attachment I did is not from kcrash. It's cut and paste text I did
from the terminal window I used.

What I found odd was that /var/lib/mysql/amarok/ which had been created in Jan
this year. But starting amarok-2.2.0 fresh did not cause the directory to be
re-created. That was the last part of the my last attachment was supposed to
show.

My understanding of amarok was that it automatically created the internal
database if the external database preference wasn't set {first run}. i.e. For
whatever reason, amarok both no longer saw the previously existing db file and
is not now creating a new file.

Obviously I have no clue as to how this is actually supposed to work. i.e. I
really am not a programmer. I'm just guessing what seems logical to me.

I think this issue is also causing the problem with people whom try to save a
playlist and amarok crashes. I believe that details about the dynamic playlists
are retained in the mysql db. Therefore amarok crashes when it can't find the
db to write the playlist info to.

If there is any testing I can do for you or anything else you'd like me to try,
I'd be happy to do so.

And thanks again.

Hi,

The internal database is contained in ~/.kde4/share/apps/amarok/mysqle, not
/var/lib/mysql/amarok (that's where you'd find an external one). You can see if
it's set to use an external one in ~/.kde4/share/config/amarokrc -- in the
[MySQL] section, UseServer=X is what controls it.

Don't know much about the playlist crash; I'd need to see a backtrace.

I'm not sure if this specific issue is related to your exact problem (symptoms
are slightly different), but there is definitely some issue with people using
unstable toolchains -- that's the only correlation we can find so far. We've
had one user report success by downgrading binutils to 2.19.1-r1 -- please try
that if you can.

If that doesn't work I'd like to see the results by downgrading gcc and glibc
too, but that would require rebuilding half your system...

Thanks for explaining where the internal table resides. That will actually
help. This is what's currently in that directory:

pyrodyno ~ # ls -l ~/.kde4/share/apps/amarok/mysqle/
total 20480
-rw-rw---- 1 root root  5242880 Nov 10 18:24 ib_logfile0
-rw-rw---- 1 root root  5242880 Nov 10 18:24 ib_logfile1
-rw-rw---- 1 root root 10485760 Nov 10 18:24 ibdata1

Would there be any benefit to my zipping this directory and posting it here for
you?


It takes about 2 1/2 days to rebuild my entire system.

I don't mind downgrading. It's just time consuming. I do have other computers
available for internet access and such. I will try downgrading binutils. Once I
do, what packages should I re-compile? I'm assuming kdelibs, mysql and amarok
would be reasonable candidates for testing purposes. What other packages would
you like me to do for this?

As far as downgrading goes, I'll just add ">=sys-dev/binutils-2.20" to
/etc/portage/package.mask and see where that takes me first. After that, I can
re-emerge whatever packages you'd think best.


Finally, as a reminder, I think I should point out that I've moved beyond the
"amarok crashes at starting" which was the OPs original post.

I moved beyond it by removing the ~./kde4/share/apps/amarok directory. At the
time when I was getting the "amarok crashes on starting", I was getting the
same messages as the OP. kcrash was indicating activity with "innodb". I
suspect that amarok was trying to restore state information saved from when it
was previously shutdown. This would include song statistics for the then active
dynamic playlist. I'm guessing that clearing the amarok directory cleared the
prior state information hence no need for any db access.

At this time I'm still having problems in that 1) amarok won't build my
collections database and 2) amarok crashes on exit. In both these instances,
mysql appears to be involved.


I'll get started on downgrading binutils now and check back for suggestions on
packages to rebuild later. Wish me luck!

SUCCESS!!!!

I masked >=sys-devel/binutils-2.20 as indicated previously.

I re-emerged mysql and amarok.

I also ran revdep-rebuild -i -p which reported 100% consistency.

My collections database now builds and amarok no longer crashes when I exit it.
The state information from exiting is recovered when I restart amarok.

I probably will rebuild my entire system sooner rather than later. I was rather
distressed to see the number of packages listed when I ran the command "equery
d binutils".

However, I was especially intrigued to see xulrunner listed. I've been having
crashes in mozilla-firefox and seamonkey on a regular basis. I'm hoping
re-emerging them now will help with that issue as well.

If there is any further information you'd like me to collect for you, please
let me know.

I've done some tests locally and it seems amarok segfaults on start when built
with binutils-2.20.
A quick workaround for now is to do the following:
# emerge -1 =binutils-2.19.1-r1 amarok
# emerge -1 binutils

Guy,

Do please let us know if rebuilding xulrunner with <binutils-2.20 fixes your
crashes there (if they were reproducible). It would be good to know if this is
not just isolated to amarok and/or mysql.

Created an attachment (id=210184) [details]
Bt of amarok

cant say ive seen problems on my x86 or x86_64 systems as i use amarok
frequently.  are people only seeing this on x86_64 ?

also, i dont think anyone has shown `emerge amarok -pv` ...

[ebuild   R   ] media-sound/amarok-2.2.0  USE="mtp opengl (-aqua) -cdda -daap
-debug -ipod -lastfm -mp3tunes -semantic-desktop"

otherwise, my mysql/sqlite match Guy's

Mike,

I've hit this issue on x86_64. The following are my use flags for mysql and
amarok (I'll be bumping amarok in the tree in a few minutes, but the use flags
are the same I've used for 2.2.0 and it failed in the same way)

[ebuild   R   ] media-sound/amarok-utils-2.2.1  USE="-debug" 0 kB
[ebuild   R   ] dev-db/mysql-5.0.84-r1  USE="berkdb community embedded perl ssl
-big-tables -cluster -debug -extraengine -latin1 -max-idx-128 -minimal
-profiling (-selinux) -static" 0 kB
[ebuild   R   ] media-sound/amarok-2.2.1  USE="ipod mp3tunes opengl
semantic-desktop (-aqua) -cdda -daap -debug -lastfm -mtp" LINGUAS="-bg -ca -cs
-da -de -en_GB -es -et -eu -fi -fr -it -ja -km -nb -nds -nl -pa -pl -pt -pt_BR
-ru -sl -sr -sr@latin -sv -th -tr -uk -wa -zh_TW" 0 kB

I have an other workaround: dev-db/mysql-community-5.1.15_beta. It's the only
mysql 5.1 of portage that (nearly) compile =>
http://bugs.gentoo.org/show_bug.cgi?id=292720 

I'm using amarok-9999 with this mysql and binutils-2.20 since some weeks
without any problems. 

I think it's time to unmask mysql-5.1... 
=> http://forum.kde.org/viewtopic.php?f=115&t=83126#p134577

remove your 

.kde4/share/apps/amarok and .kde/share/config/amarok*

and all works again (for me)

but in this way, all your settings will be removed

Created an attachment (id=210463) [details]
amarok error dump

(In reply to comment #21)
> I've done some tests locally and it seems amarok segfaults on start when built
> with binutils-2.20.
> A quick workaround for now is to do the following:
> # emerge -1 =binutils-2.19.1-r1 amarok
> # emerge -1 binutils
> 

[ Got the order the wrong way round. This post should be before #28 ]

Downgrading binutils to 2.19.1-r1 from 2.20 fixed the "amarok:    [ERROR!]
GREPME MySQL query failed! No database selected  on  " errors for me, but then
causes a crash later (attached):


$ emerge -pv mysql amarok glibc binutils
[ebuild     U ] sys-devel/binutils-2.20 [2.19.1-r1] USE="-gold -multislot
-multitarget -nls -test -vanilla" 9 kB [0]
[ebuild   R   ] sys-libs/glibc-2.10.1  USE="gd glibc-omitfp (multilib) profile
-debug (-hardened) -nls (-selinux) -vanilla" 0 kB [1]
[ebuild   R   ] dev-db/mysql-5.0.84-r1  USE="berkdb embedded perl ssl
-big-tables -cluster -community -debug -extraengine -latin1 -max-idx-128
-minimal -profiling (-selinux) -static" 0 kB [0]
[ebuild   R   ] media-sound/amarok-2.2.0  USE="cdda ipod mp3tunes mtp opengl
semantic-desktop (-aqua) -daap -debug -lastfm" LINGUAS="en_GB -bg -ca -cs -da
-de -es -et -eu -fi -fr -it -ja -km -nb -nds -nl -pa -pl -pt -pt_BR -ru -sl -sr
-sr@latin -sv -th -tr -uk -wa -zh_TW" 0 kB [0]


$ emerge --info                                    
Portage 2.2_rc49 (default/linux/amd64/10.0/desktop, gcc-4.4.2, glibc-2.10.1-r0,
2.6.31-zen7 x86_64)
=================================================================               
System uname:
Linux-2.6.31-zen7-x86_64-Intel-R-_Core-TM-2_Duo_CPU_T9300_@_2.50GHz-with-gentoo-2.0.1
Timestamp of tree: Sun, 15 Nov 2009 22:45:01 +0000                              
app-shells/bash:     4.0_p35                                                    
dev-java/java-config: 2.1.9-r1                                                  
dev-lang/python:     2.6.4, 3.1.1-r1                                            
dev-util/cmake:      2.8.0                                                      
sys-apps/baselayout: 2.0.1                                                      
sys-apps/openrc:     0.5.2-r2                                                   
sys-apps/sandbox:    2.2                                                        
sys-devel/autoconf:  2.13, 2.63-r1                                              
sys-devel/automake:  1.8.5-r3, 1.9.6-r2, 1.10.2, 1.11                           
sys-devel/binutils:  2.19.1-r1                                                  
sys-devel/gcc-config: 1.4.1
sys-devel/libtool:   2.2.6a
virtual/os-headers:  2.6.30-r1
ACCEPT_KEYWORDS="amd64 ~amd64"
CBUILD="x86_64-pc-linux-gnu"
CFLAGS="-march=native -O2 -pipe"
CHOST="x86_64-pc-linux-gnu"
CONFIG_PROTECT="/etc /usr/share/X11/xkb /usr/share/config"
CONFIG_PROTECT_MASK="/etc/ca-certificates.conf /etc/env.d /etc/env.d/java/
/etc/eselect/postgresql /etc/fonts/fonts.conf /etc/gconf /etc/gentoo-release
/etc/php/apache2-php5/ext-active/ /etc/php/cgi-php5/ext-active/
/etc/php/cli-php5/ext-active/ /etc/revdep-rebuild /etc/sandbox.d /etc/terminfo
/etc/udev/rules.d"
CXXFLAGS="-march=native -O2 -pipe"
DISTDIR="/var/distfiles"
EMERGE_DEFAULT_OPTS="--with-bdeps=y"
FEATURES="assume-digests buildsyspkg collision-protect distlocks fixpackages
metadata-transfer news parallel-fetch preserve-libs protect-owned sandbox
sfperms strict unmerge-logs unmerge-orphans userfetch userpriv usersandbox
usersync"
GENTOO_MIRRORS="/mnt/distfiles/ ftp://ftp.is.co.za/mirror/gentoo.org/
http://distfiles.gentoo.org
http://www.ibiblio.org/pub/Linux/distributions/gentoo"
LANG="en_GB.UTF-8"
LDFLAGS="-Wl,-O1"
LINGUAS="en en_GB en_US en_ZA"
MAKEOPTS="-j3"
PKGDIR="/var/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="/var/portage"
PORTDIR_OVERLAY="/var/portage/local/layman/enlightenment
/var/portage/local/layman/sunrise /var/portage/local/layman/kde-testing
/var/portage/local/layman/qting-edge /var/portage/local/alan"
SYNC="rsync://ftp.is.co.za/gentoo-portage"
USE="X a52 aac aalib acl acpi aiglx akonadi alsa amd64 ao apache2 archive
audiofile avahi bash-completion bittorrent bluetooth bonjour branding bzip2
cairo cdda cdr cisco cli consolekit cracklib crypt cups curl curlwrappers
cviewer cvs dbus dbx dga dialup djvu dri dts dv dvb dvd dvdr dvdread encode etk
evo ewl exif expat fam fbcon ffmpeg flac fontconfig foomaticdb freetds ftp fuse
gd gdbm gif gimp glib glitz gnokii gnutls gpm graphviz gs gstreamer gtk hal
handbook iconv id3tag ieee1394 imagemagick imap imlib ipod iproute2 irda irmc
jabber java java6 javascript jbig jce jpeg jpeg2k kde keyring kig-scripting
kipi lame lcms ldap lesstif libc_glibc libcaca libg++ libnotify libsamplerate
libsndfile libwww lm_sensors lua lzma mad maildir matroska mbox mcal messenger
mikmod milter mime mmx mng modules mp3 mp3tunes mp4 mpeg mplayer mtp mudflap
multilib musepack musicbrainz mysql mysqli ncurses nepomuk netboot
networkmanager nfs nptl nsplugin ntp nvidia odbc offensive ogg openexr opengl
openmp openssl openvpn pam pango passwordsave pch pcre pdf perl phonon php
plasma plotutils pmu png policykit posix postgres ppds pppd pptp profile
qt-static qt3support qt4 quicktime readline reflection resolvconf samba sasl
scanner sdl semantic-desktop session slp sms solver speex spell spl sql sqlite
sqlite3 sse sse2 ssl ssse3 startup-notification subversion svg sysfs syslog
sysvipc tcl tcltk tcpd testbed tetex theora threads thumbnail thunar tidy tiff
tk truetype tunepimp udev unicode usb utempter v4l v4l2 vcd video vim-syntax
vnc vorbis wavpack webkit wifi wma wmf wxwindows x264 xattr xcomposite xine
xinerama xinetd xml xorg xosd xpm xrender xscreensaver xulrunner xv xvid xvmc
zeroconf zip zlib" ALSA_CARDS="hda-intel" ALSA_PCM_PLUGINS="adpcm alaw asym
copy dmix dshare dsnoop empty extplug file hooks iec958 ioplug ladspa lfloat
linear meter mmap_emul mulaw multi null plug rate route share shm softvol"
APACHE2_MODULES="actions alias auth_basic auth_digest authn_anon authn_dbd
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 dbd
deflate dir disk_cache env expires ext_filter file_cache filter headers ident
imagemap include info log_config logio mem_cache mime mime_magic negotiation
proxy proxy_ajp proxy_balancer proxy_connect proxy_http rewrite setenvif so
speling status unique_id userdir usertrack vhost_alias " ELIBC="glibc"
INPUT_DEVICES="keyboard mouse evdev synaptics" KERNEL="linux"
LCD_DEVICES="bayrad cfontz cfontz633 glk hd44780 lb216 lcdm001 mtxorb ncurses
text" LINGUAS="en en_GB en_US en_ZA" SANE_BACKENDS="epson epson2"
USERLAND="GNU" VIDEO_CARDS="nv nvidia vesa"
Unset:  CPPFLAGS, CTARGET, FFLAGS, INSTALL_MASK, LC_ALL, PORTAGE_COMPRESS,
PORTAGE_COMPRESS_FLAGS, PORTAGE_RSYNC_EXTRA_OPTS

(In reply to comment #24)
> cant say ive seen problems on my x86 or x86_64 systems as i use amarok
> frequently.  are people only seeing this on x86_64 ?
> 
> also, i dont think anyone has shown `emerge amarok -pv` ...
> 
> [ebuild   R   ] media-sound/amarok-2.2.0  USE="mtp opengl (-aqua) -cdda -daap
> -debug -ipod -lastfm -mp3tunes -semantic-desktop"
> 
> otherwise, my mysql/sqlite match Guy's

I had no problems until I've rebuilt it.  According to qlop, the last time I
emerged Amarok was before the binutils-2.20 update.  Now with 2.20, *any*
version of Amarok segfaults.  So I guess if you masked 2.2.1 because of this,
you will have to also mask all versions since they all segfault; the problem is
not specific to 2.2.1.  I guess the only sane thing to do is to place a blocker
on binutils-2.20 (most people care more about being able to use Amarok rather
than what version of binutils is installed, which to most is completely
irrelevant.)

emerge -pv mysql:

[ebuild   R   ] dev-db/mysql-5.0.84-r1  USE="community embedded ssl -berkdb
-big-tables -cluster -debug -extraengine -latin1 -max-idx-128 -minimal -perl
-profiling (-selinux) -static"

emerge -pv amarok:

[ebuild   R   ] media-sound/amarok-2.2.0  USE="opengl (-aqua) -cdda -daap
-debug -ipod -lastfm -mp3tunes -mtp -semantic-desktop" LINGUAS="-bg -ca -cs -da
-de -en_GB -es -et -eu -fi -fr -it -ja -km -nb -nds -nl -pa -pl -pt -pt_BR -ru
-sl -sr -sr@latin -sv -th -tr -uk -wa -zh_TW"

amarok 2.2.0 and 2.2.1 did worked fine for me after i removed the config
files/settings in ~/.kde4

vamp898@VampLap /home/vamp898 $ emerge --info
Portage 2.1.6.13 (default/linux/x86/10.0/desktop, gcc-4.4.2, glibc-2.11-r0,
2.6.31.6-Vamp898 i686)
=================================================================               
System uname:
Linux-2.6.31.6-Vamp898-i686-Pentium-R-_Dual-Core_CPU_T4200_@_2.00GHz-with-gentoo-2.0.1
Timestamp of tree: Tue, 17 Nov 2009 10:45:01 +0000                              
app-shells/bash:     4.0_p35                                                    
dev-java/java-config: 2.1.9-r1                                                  
dev-lang/python:     2.6.4, 3.1.1-r1                                            
dev-util/cmake:      2.8.0                                                      
sys-apps/baselayout: 2.0.1                                                      
sys-apps/openrc:     0.5.2-r2                                                   
sys-apps/sandbox:    2.2
sys-devel/autoconf:  2.13, 2.63-r1
sys-devel/automake:  1.8.5-r3, 1.9.6-r2, 1.10.2, 1.11
sys-devel/binutils:  2.20
sys-devel/gcc-config: 1.4.1
sys-devel/libtool:   2.2.6b
virtual/os-headers:  2.6.30-r1
ACCEPT_KEYWORDS="x86 ~x86"
CBUILD="i686-pc-linux-gnu"
CFLAGS="-O2 -march=i686 -pipe"
CHOST="i686-pc-linux-gnu"
CONFIG_PROTECT="/etc /usr/share/X11/xkb /usr/share/config"
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/udev/rules.d"
CXXFLAGS="-O2 -march=i686 -pipe"
DISTDIR="/usr/portage/distfiles"
FEATURES="distlocks fixpackages parallel-fetch protect-owned sandbox sfperms
strict unmerge-orphans userfetch"
GENTOO_MIRRORS="http://de-mirror.org/distro/gentoo"
LANG="de_DE.UTF-8"
LDFLAGS="-Wl,-O1"
LINGUAS="de"
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/local/portage/layman/pro-audio"
SYNC="rsync://rsync.europe.gentoo.org/gentoo-portage"
USE="X a52 aac acl acpi alsa berkdb bluetooth branding bzip2 cairo cdr cli
consolekit cracklib crypt cups dbus dri dts dvd dvdr eds emboss encode evo fam
firefox flac fortran gdbm gif gpm hal iconv ipv6 jack jpeg kde ldap libnotify
lzma mad mikmod mmx modules mp3 mp4 mpeg mudflap ncurses nls nptl nptlonly ogg
opengl openmp pam pcre pdf perl png ppds pppd python qt3support qt4 quicktime
readline reflection sdl session smp spell spl sse sse2 ssl startup-notification
svg sysfs tcpd threads thunar tiff truetype unicode usb v4l v4l2 vorbis
win32codecs x264 x86 xml xorg xulrunner xv xvid zlib" ALSA_CARDS="ali5451
als4000 atiixp atiixp-modem bt87x ca0106 cmipci emu10k1 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 mmap_emul mulaw multi null plug rate route share shm softvol"
APACHE2_MODULES="actions alias 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" ELIBC="glibc"
INPUT_DEVICES="evdev synaptics" KERNEL="linux" LCD_DEVICES="bayrad cfontz
cfontz633 glk hd44780 lb216 lcdm001 mtxorb ncurses text" LINGUAS="de"
USERLAND="GNU" VIDEO_CARDS="intel"
Unset:  CPPFLAGS, CTARGET, EMERGE_DEFAULT_OPTS, FFLAGS, INSTALL_MASK, LC_ALL,
PORTAGE_COMPRESS, PORTAGE_COMPRESS_FLAGS, PORTAGE_RSYNC_EXTRA_OPTS

I can confirm that amarok-2.2.0 + binutils-2.20 crash inside mysqld on startup.

and what about amarok 2.2.1?

2.2.1 currently have the same problem.

(In reply to comment #33)
> and what about amarok 2.2.1?
That one, too. amarok-2.2.1 + binutils-2.20 crashes at the same location.

(In reply to comment #35)
> (In reply to comment #33)
> > and what about amarok 2.2.1?
> That one, too. amarok-2.2.1 + binutils-2.20 crashes at the same location.
Reemerging mysql(dev-db/mysql-5.0.84-r1) and amarok(media-sound/amarok-2.2.1)
using sys-devel/binutils-2.20 does not solve the issue.

*** Bug 293809 has been marked as a duplicate of this bug. ***

Just upgraded to amarok-2.2.1-r1 from amarok-2.2.0, also amarok-utils-2.2.1,
WITH binutils-2.20.

My Amarok is not configured to use an external database, and works for me. When
I exit amarok, I must manually kill the amarok process, even when I use
amarok's Menu Item "Quit" to quit I must manually kill the amarok process, and
then I may start amarok fresh.

NOTE: When I installed amarok-2.2.0 I had to remove all references to amarok
under my .kde4 directory before it would work. I did not do this for the
2.2.1-r1 upgrade.


Here's the messages received when starting, then below that is when I quit:

InnoDB: The InnoDB memory heap is disabled
InnoDB: use atomic builtins.
InnoDB: The log sequence number in ibdata files does not match
InnoDB: the log sequence number in the ib_logfiles!
091120  4:19:12  InnoDB: Database was not shut down normally!
InnoDB: Starting crash recovery.
InnoDB: Reading tablespace information from the .ibd files...
InnoDB: Restoring possible half-written data pages from the doublewrite
InnoDB: buffer...

these messages when I select Quit from inside Amarok:
Object::disconnect: Unexpected null parameter
Object::disconnect: Unexpected null parameter
Object::disconnect: Unexpected null parameter
QCoreApplication::postEvent: Unexpected null receiver

I really appeal that this Bug is really existing.

It have nothing to do with MySQL or Binutils, it is 100% a problem with the
amarok config in ~/.kde4

with removing the amarok config all works fine so its no error that have to do
with binutils in any way.

It seems more like an error about amarok himself about handling the configs
after an update (amarok 2.x had always problems with the existing config files
after an update. Sometimes there are only the half of all songs and so on)

So please tell me if you can reproduce this bug with clean KDE or amarok
settings (maybe move .kde4 to .kde4.backup or create a new user)

(In reply to comment #39)
> I really appeal that this Bug is really existing.
> 
> It have nothing to do with MySQL or Binutils, it is 100% a problem with the
> amarok config in ~/.kde4
> 
> with removing the amarok config all works fine so its no error that have to do
> with binutils in any way.

We are talking about a segmentation fault here, not Amarok misbehavior with old
settings.

So how to reproduce this error? Since i have a clean .kde4 config the error
does not longer appears on my machine, same on my Virtual Machines.

(In reply to comment #39)
> It have nothing to do with MySQL or Binutils, it is 100% a problem with the
> amarok config in ~/.kde4
> [...]
> It seems more like an error about amarok himself about handling the configs
> after an update [...]
This may be doubted, since the issue also appears after a 2.2.0 reinstallation
(no update involved), as mentioned above.

Amarok 2.2.1-r1 crashes on startup, even when compiled with binutils-2.20. I
can confirm that this is fixed by removing .kde4/share/apps/amarok. I can also
confirm that the process needs to be manually killed on exit (killall amarok).

(In reply to comment #43)
> Amarok 2.2.1-r1 crashes on startup, even when compiled with binutils-2.20. I
> can confirm that this is fixed by removing .kde4/share/apps/amarok. I can also
> confirm that the process needs to be manually killed on exit (killall amarok).
> 

sorry to double post, but it seems as though even after fully scanning my
files, it shows 0 files in the local database. however, my ipod is displayed
properly with the correct amount of files.

(In reply to comment #44)
> (In reply to comment #43)
> > Amarok 2.2.1-r1 crashes on startup, even when compiled with binutils-2.20. I
> > can confirm that this is fixed by removing .kde4/share/apps/amarok. I can also
> > confirm that the process needs to be manually killed on exit (killall amarok).
> > 
> 
> sorry to double post, but it seems as though even after fully scanning my
> files, it shows 0 files in the local database. however, my ipod is displayed
> properly with the correct amount of files.
> 

so this is really embarrassing, but through some act of voodoo, everything
works fine now. i don't quite understand what changed, but after another full
rescan the database has all my music. sorry >.>

I can confirm that I do *NOT* have any problems running amarok with
binutils-2.20:

emerge -pqv amarok binutils:
[ebuild   R   ] sys-devel/binutils-2.20  USE="nls -gold -multislot -multitarget
-test -vanilla"
[ebuild   R   ] media-sound/amarok-2.2.1-r1  USE="cdda mtp opengl
semantic-desktop (-aqua) -daap -debug -ipod -lastfm -mp3tunes" LINGUAS="-bg -ca
-cs -da -de -en_GB -es -et -eu -fi -fr -it -ja -km -nb -nds -nl -pa -pl -pt
-pt_BR -ru -sl -sr -sr@latin -sv -th -tr -uk -wa -zh_TW"

emerge --info
Portage 2.2_rc50 (default/linux/amd64/10.0/no-multilib, gcc-4.4.2-asneeded,
glibc-2.10.1-r0, 2.6.31-gentoo-r6 x86_64)                  
=================================================================               
System uname:
Linux-2.6.31-gentoo-r6-x86_64-AMD_Athlon-tm-_64_X2_Dual_Core_Processor_4400+-with-gentoo-2.0.1 
Timestamp of tree: Sat, 21 Nov 2009 00:00:01 +0000                             
                                                       Portage 2.2_rc50
(default/linux/amd64/10.0/no-multilib, gcc-4.4.2-asneeded, glibc-2.10.1-r0,
2.6.31-gentoo-r6 x86_64)                  
=================================================================               
System uname:
Linux-2.6.31-gentoo-r6-x86_64-AMD_Athlon-tm-_64_X2_Dual_Core_Processor_4400+-with-gentoo-2.0.1 
Timestamp of tree: Sat, 21 Nov 2009 00:00:01 +0000                              
app-shells/bash:     4.0_p35
dev-java/java-config: 2.1.9-r1
dev-lang/python:     2.6.4, 3.1.1-r1
dev-util/cmake:      2.8.0
sys-apps/baselayout: 2.0.1
sys-apps/openrc:     0.5.2-r2
sys-apps/sandbox:    2.2
sys-devel/autoconf:  2.13, 2.63-r1
sys-devel/automake:  1.8.5-r3, 1.9.6-r2, 1.10.2, 1.11
sys-devel/binutils:  2.20
sys-devel/gcc-config: 1.4.1
sys-devel/libtool:   2.2.6b
virtual/os-headers:  2.6.30-r1
ACCEPT_KEYWORDS="amd64 ~amd64"
ACCEPT_LICENSE="*"
CBUILD="x86_64-pc-linux-gnu"
CFLAGS="-march=native -O2 -pipe -ftracer -ftree-vectorize -floop-block
-floop-interchange -floop-strip-mine"
CHOST="x86_64-pc-linux-gnu"
CONFIG_PROTECT="/etc /usr/share/X11/xkb /usr/share/config"
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/udev/rules.d"
CXXFLAGS="-march=native -O2 -pipe -ftracer -ftree-vectorize -floop-block
-floop-interchange -floop-strip-mine"
DISTDIR="/usr/portage/distfiles"
EMERGE_DEFAULT_OPTS="--with-bdeps y"
FEATURES="assume-digests distlocks fixpackages metadata-transfer news
parallel-fetch preserve-libs protect-owned sandbox sfperms strict unmerge-logs
unmerge-orphans userfetch"
GENTOO_MIRRORS="ftp://gentoo.mirrors.tds.net/gentoo
ftp://gentoo.netnitco.net/pub/mirrors/gentoo/source/
ftp://gentoo.cites.uiuc.edu/pub/gentoo/"
LANG="en_US.UTF-8"
LC_ALL="en_US.UTF-8"
LDFLAGS="-Wl,-O1 -Wl,--as-needed -Wl,--hash-style=gnu -Wl,--sort-common
-Wl,-z,combreloc"
LINGUAS="en en_US"
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/local/portage/layman/vmware
/usr/local/portage/layman/zugaina /usr/local/portage"
SYNC="rsync://rsync.gentoo.org/gentoo-portage"
USE="3dnow 3dnowext X a52 aac acpi akode alsa amd64 ao bash-completion branding
bzip2 cairo caps cdda cddb cdparanoia cli consolekit cracklib crypt css cups
curl dbus dga dri dv dvd dvdr encode exif expat faac faad fam fbcon ffmpeg fftw
flac fontconfig fortran geoip ggi gif glib gmp gnutls gphoto2 gpm gs gtk hal
iconv icu id3tag idn ieee1394 imagemagick imlib ipv6 ithreads java jfs joystick
jpeg jpeg2k kde kdehiddenvisibility kontact lame lcms libsamplerate lm_sensors
lzo mad matroska mbox mjpeg mmap mmx mmxext mng modplug modules motif mp3 mpeg
mplayer msn mtp mudflap musepack musicbrainz ncurses network network-cron nls
nptl nptlonly nsplugin ntfs offensive ogg openal opengl openmp openssl oscar
oss pam pcre pdf perl plasma plotutils png policykit pppd qt3support qt4
quicktime rar readline reflection rle ruby samba schroedinger sdl
semantic-desktop session smp sndfile speex spell spl sse sse2 sse3 ssl
startup-notification stats subversion suid svg sysfs syslog tcl tcpd theora
threads tiff truetype twolame udev unicode usb vcd vdpau vim-syntax vnc vorbis
wavpack wmf wxwidgets x264 xcb xcomposite xfs xft xine xml xorg xpm
xscreensaver xv xvid xvmc zlib" ALSA_CARDS="emu10k1 usb-audio"
ALSA_PCM_PLUGINS="adpcm alaw asym copy dmix dshare dsnoop empty extplug file
hooks iec958 ioplug ladspa lfloat linear meter mmap_emul mulaw multi null plug
rate route share shm softvol" APACHE2_MODULES="actions alias 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" ELIBC="glibc" INPUT_DEVICES="joystick evdev" KERNEL="linux"
LCD_DEVICES="bayrad cfontz cfontz633 glk hd44780 lb216 lcdm001 mtxorb ncurses
text" LINGUAS="en en_US" USERLAND="GNU" VIDEO_CARDS="nvidia"
Unset:  CPPFLAGS, CTARGET, FFLAGS, INSTALL_MASK, PORTAGE_COMPRESS,
PORTAGE_COMPRESS_FLAGS, PORTAGE_RSYNC_EXTRA_OPTS
app-shells/bash:     4.0_p35
dev-java/java-config: 2.1.9-r1
dev-lang/python:     2.6.4, 3.1.1-r1
dev-util/cmake:      2.8.0
sys-apps/baselayout: 2.0.1
sys-apps/openrc:     0.5.2-r2
sys-apps/sandbox:    2.2
sys-devel/autoconf:  2.13, 2.63-r1
sys-devel/automake:  1.8.5-r3, 1.9.6-r2, 1.10.2, 1.11
sys-devel/binutils:  2.20
sys-devel/gcc-config: 1.4.1
sys-devel/libtool:   2.2.6b
virtual/os-headers:  2.6.30-r1
ACCEPT_KEYWORDS="amd64 ~amd64"
ACCEPT_LICENSE="*"
CBUILD="x86_64-pc-linux-gnu"
CFLAGS="-march=native -O2 -pipe -ftracer -ftree-vectorize -floop-block
-floop-interchange -floop-strip-mine"
CHOST="x86_64-pc-linux-gnu"
CONFIG_PROTECT="/etc /usr/share/X11/xkb /usr/share/config"
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/udev/rules.d"
CXXFLAGS="-march=native -O2 -pipe -ftracer -ftree-vectorize -floop-block
-floop-interchange -floop-strip-mine"
DISTDIR="/usr/portage/distfiles"
EMERGE_DEFAULT_OPTS="--with-bdeps y"
FEATURES="assume-digests distlocks fixpackages metadata-transfer news
parallel-fetch preserve-libs protect-owned sandbox sfperms strict unmerge-logs
unmerge-orphans userfetch"
GENTOO_MIRRORS="ftp://gentoo.mirrors.tds.net/gentoo
ftp://gentoo.netnitco.net/pub/mirrors/gentoo/source/
ftp://gentoo.cites.uiuc.edu/pub/gentoo/"
LANG="en_US.UTF-8"
LC_ALL="en_US.UTF-8"
LDFLAGS="-Wl,-O1 -Wl,--as-needed -Wl,--hash-style=gnu -Wl,--sort-common
-Wl,-z,combreloc"
LINGUAS="en en_US"
MAKEOPTS="-j3"

Ok, I can confirm that the following made amarok startup again:
~ $ rm .kde4/share/apps/amarok/collection_scan.*
~ $ rm
.kde4/share/apps/amarok/amarokcollectionscanner_batchincrementalinput.data 
~ $ rm .kde4/share/apps/amarok/my.cnf 
~ $ rm -r .kde4/share/apps/amarok/mysqle/

Amarok would have an empty collection afterwards and not update it. That could
only be achieved by clicking "fully rescan collection" in the "collection"
settings. The collection will however be empty afterwards, and pressing "fully
rescan collection" a second time will not solve the problem. Restarting amarok
and running another full scan does not solve the issue, either.

Exiting amarok works fine. I tried with the initially empty collection, and
after the full rescan and never had a hanging amarok process. (ps aux | grep
amarok)



== console logs ==


= First run after deleting the mysqle directory =
InnoDB: The InnoDB memory heap is disabled               
InnoDB: use atomic builtins.                             
InnoDB: The first specified data file
/home/XXX/.kde4/share/apps/amarok/mysqle/ibdata1 did not exist:
InnoDB: a new database to be created!                                           
091121  8:16:01  InnoDB: Setting file
/home/XXX/.kde4/share/apps/amarok/mysqle/ibdata1 size to 10 MB 
InnoDB: Database physically writes the file full: wait...                       
091121  8:16:01  InnoDB: Log file
/home/XXX/.kde4/share/apps/amarok/mysqle/ib_logfile0 did not exist: new to be
created
InnoDB: Setting log file /home/XXX/.kde4/share/apps/amarok/mysqle/ib_logfile0
size to 5 MB                             
InnoDB: Database physically writes the file full: wait...                       
091121  8:16:01  InnoDB: Log file
/home/XXX/.kde4/share/apps/amarok/mysqle/ib_logfile1 did not exist: new to be
created
InnoDB: Setting log file /home/XXX/.kde4/share/apps/amarok/mysqle/ib_logfile1
size to 5 MB                             
InnoDB: Database physically writes the file full: wait...                       
InnoDB: Doublewrite buffer not found: creating new                              
InnoDB: Doublewrite buffer created                                              
InnoDB: Creating foreign key constraint system tables                           
InnoDB: Foreign key constraint system tables created                            
Object::connect: No such slot Dynamic::CustomBiasEntryWidget::reloadBiases()    
QObject::connect: Cannot connect
Dynamic::CustomBiasEntryWidget::weightChangedInt( int ) to (null)::setWeight(
int )         
amarok: 
********************************************************************************************** 
amarok:  ** AMAROK WAS STARTED IN NORMAL MODE. IF YOU WANT TO SEE DEBUGGING
INFORMATION, PLEASE USE: **                      
amarok:  ** amarok --debug                                                     
                     **                      
amarok: 
********************************************************************************************** 
HTTP GET  QUrl(
"http://post.audioscrobbler.com:80/?hs=true&p=1.2.1&c=ark&v=2.2.1&XXX" )        
"OK                                                                             
XXX                                                                             
http://post.audioscrobbler.com:80/np_1.2                                        
http://post2.audioscrobbler.com:80/protocol_1.2"                                
Object::disconnect: Unexpected null parameter                                   
Object::disconnect: Unexpected null parameter                                   
Object::disconnect: Unexpected null parameter                                   
QCoreApplication::postEvent: Unexpected null receiver 


= Restarting and running the full collection scan =
InnoDB: The InnoDB memory heap is disabled
InnoDB: use atomic builtins.
InnoDB: The log sequence number in ibdata files does not match
InnoDB: the log sequence number in the ib_logfiles!
091121  8:17:09  InnoDB: Database was not shut down normally!
InnoDB: Starting crash recovery.
InnoDB: Reading tablespace information from the .ibd files...
InnoDB: Restoring possible half-written data pages from the doublewrite
InnoDB: buffer...
Object::connect: No such slot Dynamic::CustomBiasEntryWidget::reloadBiases()
QObject::connect: Cannot connect
Dynamic::CustomBiasEntryWidget::weightChangedInt( int ) to (null)::setWeight(
int )
amarok: 
**********************************************************************************************
amarok:  ** AMAROK WAS STARTED IN NORMAL MODE. IF YOU WANT TO SEE DEBUGGING
INFORMATION, PLEASE USE: **
amarok:  ** amarok --debug                                                     
                     **
amarok: 
**********************************************************************************************
HTTP GET  QUrl(
"http://post.audioscrobbler.com:80/?hs=true&p=1.2.1&c=ark&v=2.2.1&u=XXX" )
"OK
XXX
http://post.audioscrobbler.com:80/np_1.2
http://post2.audioscrobbler.com:80/protocol_1.2"
Object::disconnect: Unexpected null parameter
Object::disconnect: Unexpected null parameter
Object::disconnect: Unexpected null parameter
QCoreApplication::postEvent: Unexpected null receiver


= Restarting and 2nd full rescan =
InnoDB: The InnoDB memory heap is disabled
InnoDB: use atomic builtins.
InnoDB: The log sequence number in ibdata files does not match
InnoDB: the log sequence number in the ib_logfiles!
091121  8:24:15  InnoDB: Database was not shut down normally!
InnoDB: Starting crash recovery.
InnoDB: Reading tablespace information from the .ibd files...
InnoDB: Restoring possible half-written data pages from the doublewrite
InnoDB: buffer...
Object::connect: No such slot Dynamic::CustomBiasEntryWidget::reloadBiases()
QObject::connect: Cannot connect
Dynamic::CustomBiasEntryWidget::weightChangedInt( int ) to (null)::setWeight(
int )
amarok: 
**********************************************************************************************
amarok:  ** AMAROK WAS STARTED IN NORMAL MODE. IF YOU WANT TO SEE DEBUGGING
INFORMATION, PLEASE USE: **
amarok:  ** amarok --debug                                                     
                     **
amarok: 
**********************************************************************************************
HTTP GET  QUrl(
"http://post.audioscrobbler.com:80/?hs=true&p=1.2.1&c=ark&v=2.2.1&u=XXX" )
"OK
XXX
http://post.audioscrobbler.com:80/np_1.2
http://post2.audioscrobbler.com:80/protocol_1.2"

Continuing the 0-item-collection issue mentioned e.g. in comment #47 as bug
#293934.

@maintainer

as you see in the comments this bug is not binutils related in any way!

plz remove the pkg_postinstall message from the portage tree beceause its a
amarok and his configuration related problem

everyguy which just tried removing the amarok configs in ~/.kde4 had a working
amarok and no problems anymore (as you can see in the comments)

plz stop making people masking the new binutils and mark this bug as fiexed
(maybe as "Fixed works for me")

To resolve the 0-collection problem you have two chances

Configure (emerge --config mysql) and start MySQL Daemon
set up amarok to use the external MySQL Database

or

compile MySQL 5.1 by yourself (it just works fine with 5.1 without doing
anything)

(In reply to comment #49)
> everyguy which just tried removing the amarok configs in ~/.kde4 had a working
> amarok and no problems anymore (as you can see in the comments)
This is not exactly correct. "Does not segfault" != "no problems".
It is still that after deleting the mysqle/ directory Amarok is basically
useless, since the collection will stay empty.
Hence I am using MPD now, which (with GMPC + plugins) also has dynamic playlist
support.

> [...] and mark this bug as fiexed (maybe as "Fixed works for me")
s.a.

I was experiencing this bug, rebuilding with previous binutils fixed it. 
Removing config made amarok start but left me with an empty collection. 
Keeping the config and downgrading binutils worked wonderfully.

(In reply to comment #49)
> @maintainer
> 
> as you see in the comments this bug is not binutils related in any way!

What I see here is many conflicting issues in the same bug report.

> plz remove the pkg_postinstall message from the portage tree beceause its a
> amarok and his configuration related problem

Not exactly. I hit this on 2 different machines and reproduced it with 2.2.0
and 2.2.1 and in all cases building amarok with binutils-2.19.1-r1 stopped it
from segfaulting on start.

> everyguy which just tried removing the amarok configs in ~/.kde4 had a working
> amarok and no problems anymore (as you can see in the comments)

You can read in the comment before this one that your statement isn't true.

> plz stop making people masking the new binutils and mark this bug as fiexed
> (maybe as "Fixed works for me")

I didn't ask or told anyone to mask the newer binutils, quite the opposite.
I've given a quick workaround until this is fixed that ensures users will have
the latest binutils installed.

(In reply to comment #53)
> (In reply to comment #49)
> > @maintainer
> > 
> > as you see in the comments this bug is not binutils related in any way!
> 
> What I see here is many conflicting issues in the same bug report.
> 
> > plz remove the pkg_postinstall message from the portage tree beceause its a
> > amarok and his configuration related problem
> 
> Not exactly. I hit this on 2 different machines and reproduced it with 2.2.0
> and 2.2.1 and in all cases building amarok with binutils-2.19.1-r1 stopped it
> from segfaulting on start.
> 
> > everyguy which just tried removing the amarok configs in ~/.kde4 had a working
> > amarok and no problems anymore (as you can see in the comments)
> 
> You can read in the comment before this one that your statement isn't true.
> 
> > plz stop making people masking the new binutils and mark this bug as fiexed
> > (maybe as "Fixed works for me")
> 
> I didn't ask or told anyone to mask the newer binutils, quite the opposite.
> I've given a quick workaround until this is fixed that ensures users will have
> the latest binutils installed.
> 

The workaround is.

On every upgrade of amarok compile old binutils first. compile amarok and
compile new binutils again.

amarok updates are really fast in the last time so this is no real workaround.

And about the bug with the clean collection

i dont know why this happens here in Gentoo and why this happens with Binutils
2.20

the fact is that it works without problems on every PC with MySQL 5.1

So even when everyone says its not MySQL related. Why does it work without
problems with MySQL 5.1 and with MySQL 5.0 there are a lot problems?

Maybe the error is not the old MySQL itself, more like an unhappy chain of
events.

But about 99% of all people which experience problems about a 0-collection can
be helped by using MySQL 5.1

so whereever the problem lies, it can be fixed by using MySQL 5.1 100%

The only way to get it with MySQL 5.0 working is to build it with old binutils.

But to say the truth, its quite no nice workaround to compile the old binutils,
compile amarok and the new binutils on every update!

//Edit:

This bug report is about that amarok does not start with new binutils

and thats what i said that is wrong. It starts very fine with new binutils

that it can handle MySQL 5.0 with the new binutils is a other problem.

In fact this bug here is not existing beceause its caused by amaroks handling
of configuration file.

as i said in the post before

i dont know why amarok does not work with MySQL 5.0 while Binutils 2.20 is
installed but it works with MySQL 5.1 and MySQL 5.1 is the recent stable
version.

So in my eyes there is still no bug existing right here

(In reply to comment #55)
> So in my eyes there is still no bug existing right here

The bug is described in the 1st post. Don't battle with semantics. You might
want to change the title of this bug, but you don't close it because there *is*
a bug.

Than the title should be changed to

>=media-sound/amarok-2.2.0 crashes on startup in case of handling his config files when built with >=binutils-2.20 + cant connect to MySQL 5.0 embedded

and all other bugs related to the MySQL 5.0 problem and so on should be marked
as a duplicate

(In reply to comment #57)
> Than the title should be changed to
> 
> >=media-sound/amarok-2.2.0 crashes on startup in case of handling his config files when built with >=binutils-2.20 + cant connect to MySQL 5.0 embedded
> 
> and all other bugs related to the MySQL 5.0 problem and so on should be marked
> as a duplicate
> 

or a bit better sounds

>=media-sound/amarok-2.2.0 cant connect to MySQL 5.0 embedded and does not startup with old/existing config files after build with >=binutils-2.20

(In reply to comment #58)
> (In reply to comment #57)
> > Than the title should be changed to
> > 
> > >=media-sound/amarok-2.2.0 crashes on startup in case of handling his config files when built with >=binutils-2.20 + cant connect to MySQL 5.0 embedded
> > 
> > and all other bugs related to the MySQL 5.0 problem and so on should be marked
> > as a duplicate
> > 
> 
> or a bit better sounds
> 
> >=media-sound/amarok-2.2.0 cant connect to MySQL 5.0 embedded and does not startup with old/existing config files after build with >=binutils-2.20
> 

Damm now i forget the final step

Workaround:

The best workaround in my opinion is to remove the old/existing config files in
~/.kde4/share/apps/amarok and ~/.kde4/share/config/amarok*
configure/start MySQL Daemon and set amarok to use an external database

maybe a bit much on first use, but on the long run seems to work fine

other workaround is

on every amarok update, build old binutils first, build amarok and then build
new binutils again

Your other workaround is EXACTLY what the message in the ebuild says.

Please stop writing 7 comments every time and concat them to just one.

(In reply to comment #60)
> Your other workaround is EXACTLY what the message in the ebuild says.
> 
> Please stop writing 7 comments every time and concat them to just one.
> 

yes but i think the other workaround should be said too in the ebuild beceuase
not everyone have the time to recompile a mass of packages on every small
upgrade of amarok

(In reply to comment #61)
> (In reply to comment #60)
> > Your other workaround is EXACTLY what the message in the ebuild says.
> > 
> > Please stop writing 7 comments every time and concat them to just one.
> > 
> 
> yes but i think the other workaround should be said too in the ebuild beceuase
> not everyone have the time to recompile a mass of packages on every small
> upgrade of amarok

Running an SQL server on your desktop just to be able to listen to music in
Amarok doesn't strike me as a particularly intelligent thing to do.

(In reply to comment #57)
> Than the title should be changed to
> >=media-sound/amarok-2.2.0 crashes on startup in case of handling his config files when built with >=binutils-2.20 + cant connect to MySQL 5.0 embedded
Except that the crash is not related to the config files, but to the mysqle/ db
files...
Your theory about config files makes especially no sense in that you will also
experience the abovementioned crash if you just rebuild amarok (as I did).
If you are experiencing an issue which is different from the one mentioned
here, please create a new bugreport about that (as I did).

Also: It sounds *a lot* better to rebuild binutils twice every 2 months, than
to delete everything amarok related every such time as you suggest.

Further: Please do not argue about the non-existance of this bug when several
people are running into it and are actually having issues. That the amarok
version bump, the binutils issue and other mysqle issues all happened at the
same time and are having different solutions does not make any one of them less
of a problem.

Look, amarok still crashed when built with the proper buildutils but mysql 5.0.
and you don't even have to delete EVERYTHING amarok related, all you have to
delete is ~/.kde4/share/apps/amarok/mysqle. I deleted that, which isn't even a
big deal because the new collection scanner is fast enough. So once I deleted
that, amarok started, but then gave me zero files in my collection. After
scanning, it still gave me zero files, but after closing amarok and reopening
it and rescanning everything works FINE. So... there is definitely a crash
related to the mysqle directory.

The problem IMHO is the gentoo patchset to mysql 5.0.x (more speciffically the
patch who makes libmysqld a shared library). The problem doesnt happen with
manually compiled mysql 5.1 because u dont applied the gentoo patches to it and
only created a static lib (btw a mysql 5.0.84 without patches works too). The
problem has nothing to do with the config and more with a problem of the
amarok_collection-mysqlecollection.so linked to libmysqld.so using
binutils-2.20. If you do a "amarok --nofork --debug" without the mysqld
directory you can see an error because cant create the db (origin of the 0-file
collection), or a crash if it can find the db (but cant open/select it anyway).
This bug is very weird because i cant reproduce the problem with a test app
linked to libmysqld.so (it success to always create the db). I agree with the
approach of make libmysqle.a a shared library but is causing more problem than
solutions :/.

Btw i can reproduce this bug with amarok from git so isnt tied with an specific
version.

Sorry for my english.

So maybe there should be provided a vanilla use-flag for MySQL and amarok
should depend on MySQL[+vanilla]

I can confirm this problem on my system. Amarok (both 2.2.1-r1 and 2.2.0) would
not start with my old config once I had built against binutils 2.20. If the old
config was erased, amarok would start but was unable to build the database (I
even opened the embeded database to confirm that there was not information, no
tracks, no tables, no "amarok" database). Downgrading binutils to 2.19 and
rebuilding amarok solved the problem. Mysql version 5.0.84-r1. I did not try
running stand alone mysql server.

FWIW, 2.20.51.0.3 seems to be working but this is a new install.

I've built binutils-2.20.51.0.3, rebuilt Amarok and MySqueal, but to no avail.
Removing the config still makes it scream for a non-existing database it
obviously fails to create correctly.

Downgrading binutils to 2.19 and re-emerging Amarok fixes the problem. The
database is created correctly and the collection scanner fills it with tracks.

I didn't rebuild mysql after downgrading binutils, so this looks more like a
problem with Amarok than with mysql.

I built Amarok with binutils 2.20 and have experienced no issues. I use the
external mysql database. I didn't even have to delete my config when upgrading
from Amarok 2.2.0 to 2.2.1-r1.

I'm pretty sure the problem only occurs with embedded MySQL

I'm using external MySQL and still had this issue.

*** Bug 293934 has been marked as a duplicate of this bug. ***

I have some interesting things that i found while finding the problem with
amarok:
First, a better "workaround" for make amarok works with >=binutils-2.20, is a
patch that removes the linking of libmysqlclient.so into
amarok_collection-mysqlecollection.so. Looks like if libmysqlclient.so AND
libmysqld.so are linked together the later dont work at all (cant create a db,
select, etc). Seeing this i can think that the gentoo-created libmysqld.so
conflicts with libmysqlclient.so, BUT why amarok works with binutils 2.19 and
not 2.20? 

Looks like that binutils 2.20 links libmysqlclient.so into
amarok_collection-mysqlecollection.so but 2.19 doesnt do that. I created a
little testcase to test it further and looks like that the -Wl,--as-needed flag
is ignored by binutils 2.20 (the testcase works with binutils 2.19 and fails
with 2.20 like amarok). You can test it by compiling my testcase with
binutils-2.19 and 2.20 then comparing the ldd outputs.

I hope that this helps to find if this bug is with mysql (conflicting libs),
amarok (pulling libmysqlclient.so in amarok_collection-mysqlecollection.so) or
binutils (--as-needed not working properly in 2.20)

Sorry for my english.

Created an attachment (id=211474) [details]
patch to remove the libmysqlclient.so link in
amarok_collection-mysqlecollection.so

Created an attachment (id=211476) [details]
Testcase to find why amarok work with binutils <2.20

Compile the testcase with make and run with ./mysql-test
The testcase tries to create the "amarok" database in ./data then tries to
select it, create a table and insert a value.
Works with binutils <2.20, fails with binutils >=2.20

To those of you who think this is an issue with config files, or the database
stored under ~/.kde4, removal of them had no effect. the only solution that
*worked for me* was downgrading to the stable version of binutils, and
recompiling amarok. 

Amarok now works, and my database now shows my local files as one would expect.

EOF.

(In reply to comment #77)
> To those of you who think this is an issue with config files, or the database
> stored under ~/.kde4, removal of them had no effect. the only solution that
> *worked for me* was downgrading to the stable version of binutils, and
> recompiling amarok. 
> 
> Amarok now works, and my database now shows my local files as one would expect.
> 
> EOF.
> 

look buddy, half of us here have stated that doing that didn't solve the
problem and we had to delete our configs too. you can't just say that your way
is the only way since if you paid any attention to the comments, you'd realize
that that didn't work for everyone.

kudos to Cesar for the test case

the change in as-needed behavior seems to have occurred between 2.19.51.0.1 and
2.19.51.0.2.  i can look into this aspect, but i'm not sure it's the right
answer here.

relying on as-needed here seems like a bad idea.  how do you expect this to
work on a system that lacks as-needed support ?  the same failure is observed
when using any version of binutils and omitting the as-needed flag.  if mysqld
and mysqlclient are both loaded, the failure occurs.  presumably some symbols
are clashing here and some calls are going to the former while others to the
latter.

Please test amarok-2.2.1-r2 as it should hopefully fix this issue.

Works fine here now.  Combinations tested:

Amarok built with binutils-2.20 and MySQL with 2.19.1-r1.
Both Amarok and MySQL built with binutils 2.20.

works fine here =)

(In reply to comment #80)
> Please test amarok-2.2.1-r2 as it should hopefully fix this issue.

Works fine here; amarok-2.2.1-r2 and mysql-5.0.84-r1 built with binutils-2.20

Given the last comments, I'm going to close this bug as fixed.
Please reopen if you hit this issue again.