Gentoo Websites Logo
Go to: Gentoo Home Documentation Forums Lists Bugs Planet Store Wiki Get Gentoo!
Bug 177128 - dev-db/mysql-5.0.40 server fails to start a second time
Summary: dev-db/mysql-5.0.40 server fails to start a second time
Status: RESOLVED FIXED
Alias: None
Product: Gentoo Linux
Classification: Unclassified
Component: Current packages (show other bugs)
Hardware: Other Linux
: High major (vote)
Assignee: Gentoo Linux MySQL bugs team
URL:
Whiteboard:
Keywords:
: 178088 (view as bug list)
Depends on:
Blocks:
 
Reported: 2007-05-05 06:56 UTC by matthew kelcey
Modified: 2010-02-01 01:41 UTC (History)
3 users (show)

See Also:
Package list:
Runtime testing required: ---


Attachments

Note You need to log in before you can comment on or make changes to this bug.
Description matthew kelcey 2007-05-05 06:56:38 UTC
can start mysql once but after stopping it wont restart until database is deleted and reinstalled

Reproducible: Always

Steps to Reproduce:
1. rm -r /var/lib/mysql
2. emerge --config =dev-db/mysql-5.0.38 
3. /etc/init.d/mysql start
4. /etc/init.d/mysql stop
5. /etc/init.d/mysql start

alternatively can do mysql_install_db for step 2 with same results

Actual Results:  
first start is ok

newt linux # /etc/init.d/mysql start
 * Starting mysql ...  
 * Starting mysql (/etc/mysql/my.cnf) [ ok ]

but second start fails

newt linux # /etc/init.d/mysql stop
 * Stopping mysql ...
 * Stopping mysqld (0) [ ok ]
newt linux # /etc/init.d/mysql start
 * Starting mysql ...
 * Starting mysql (/etc/mysql/my.cnf)
 * MySQL NOT started (0) [ !! ]



Expected Results:  
expect that mysql should be able to be stopped and started multiple times


is this a problem for gentoo or mysql?

for this bug report emerging dev-db/mysql-5.0.38
but tried to emerge mysql-5.0.26-r2 with same problem

after second start error log generated is...

070505 15:21:50 [Warning] No argument was provided to --log-bin, and --log-bin-index was not used; so replication may break when this MySQL
server acts as a master and has his hostname changed!! Please use '--log-bin=/var/run/mysqld/mysqld-bin' to avoid this problem.
070505 15:21:51 - mysqld got signal 4;
This could be because you hit a bug. It is also possible that this binary
or one of the libraries it was linked against is corrupt, improperly built,
or misconfigured. This error can also be caused by malfunctioning hardware.
We will try our best to scrape up some info that will hopefully help diagnose
the problem, but since we have already crashed, something is definitely wrong
and this may fail.

key_buffer_size=0
read_buffer_size=258048
max_used_connections=0
max_connections=100
threads_connected=0
It is possible that mysqld could use up to
key_buffer_size + (read_buffer_size + sort_buffer_size)*max_connections = 76396 K
bytes of memory
Hope that's ok; if not, decrease some variables in the equation.

thd=(nil)
Attempting backtrace. You can use the following information to find out
where mysqld died. If you see no messages after this, something went
terribly wrong...
Cannot determine thread, fp=0xbf922368, backtrace may not be correct.
Stack range sanity check OK, backtrace follows:
0x81b4cae
0x83e0092
0x84243f1
0x83e2721
0x83d3c31
0x82b0f4f
0x8296ed8
0x81b734f
0x81b7dec
0xb7bef880
0x810df41
New value of fp=(nil) failed sanity check, terminating stack trace!
Please read http://dev.mysql.com/doc/mysql/en/using-stack-trace.html and follow instructions on how to resolve the stack trace. Resolved
stack trace is much more helpful in diagnosing the problem, so please do
resolve it
The manual page at http://www.mysql.com/doc/en/Crashing.html contains
information that should help you find out what is causing the crash.
070505 15:23:03 [Warning] No argument was provided to --log-bin, and --log-bin-index was not used; so replication may break when this MySQL
server acts as a master and has his hostname changed!! Please use '--log-bin=/var/run/mysqld/mysqld-bin' to avoid this problem.
070505 15:23:07 [Warning] No argument was provided to --log-bin, and --log-bin-index was not used; so replication may break when this MySQL
server acts as a master and has his hostname changed!! Please use '--log-bin=/var/run/mysqld/mysqld-bin' to avoid this problem.
070505 15:23:18 [Warning] No argument was provided to --log-bin, and --log-bin-index was not used; so replication may break when this MySQL
server acts as a master and has his hostname changed!! Please use '--log-bin=/var/run/mysqld/mysqld-bin' to avoid this problem.
InnoDB: The first specified data file ./ibdata1 did not exist:





newt mysql # emerge --info
Portage 2.1.2.2 (default-linux/x86/2006.1, gcc-4.1.1, glibc-2.4-r3, 2.6.19-gentoo-r5-matpalm20070505a i686)
=================================================================
System uname: 2.6.19-gentoo-r5-matpalm20070505a i686 VIA Nehemiah
Gentoo Base System release 1.12.9
Timestamp of tree: Thu, 03 May 2007 08:50:01 +0000
dev-lang/python:     2.4.3-r1
dev-python/pycrypto: 2.0.1-r5
sys-apps/sandbox:    1.2.17
sys-devel/autoconf:  2.13, 2.61
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
sys-devel/binutils:  2.16.1-r3
sys-devel/gcc-config: 1.3.13-r3
sys-devel/libtool:   1.5.22
virtual/os-headers:  2.6.17-r2
ACCEPT_KEYWORDS="x86"
AUTOCLEAN="yes"
CBUILD="i586-pc-linux-gnu"
CFLAGS="-Os -march=c3 -m3dnow -pipe -fomit-frame-pointer"
CHOST="i586-pc-linux-gnu"
CONFIG_PROTECT="/etc /usr/share/X11/xkb"
CONFIG_PROTECT_MASK="/etc/env.d /etc/gconf /etc/terminfo"
CXXFLAGS="-Os -march=c3 -m3dnow -pipe -fomit-frame-pointer"
DISTDIR="/usr/portage/distfiles"
FEATURES="distlocks metadata-transfer sandbox sfperms strict"
GENTOO_MIRRORS="http://public.planetmirror.com/pub/gentoo http://mirror.pacific.net.au/linux/Gentoo "
PKGDIR="/usr/portage/packages"
PORTAGE_RSYNC_OPTS="--recursive --links --safe-links --perms --times --compress --force --whole-file --delete --delete-after --stats --timeout=180 --exclude=/distfiles --exclude=/local --exclude=/packages --filter=H_**/files/digest-*"
PORTAGE_TMPDIR="/var/tmp"
PORTDIR="/usr/portage"
SYNC="rsync://rsync.au.gentoo.org/gentoo-portage"
USE="aac acpi alsa berkdb bitmap-fonts cli cracklib crypt cups directfb dri dvb dvd encode ffmpeg flac fortran gdbm gpm iconv ipod ipv6 isdnlog ivtv libg++ lirc midi mmx mmx2 mp3 mpeg mplayer mysql ncurses nls nptl nptlonly ogg pam pcre perl ppds pppd python readline reflection session spl sse ssl svga tcpd truetype-fonts type1-fonts unicode via vidix vorbis x86 xorg xvmc 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 mulaw multi null plug rate route share shm softvol" ELIBC="glibc" INPUT_DEVICES="keyboard" KERNEL="linux" LCD_DEVICES="bayrad cfontz cfontz633 glk hd44780 lb216 lcdm001 mtxorb ncurses text" LIRC_DEVICES="hauppauge" USERLAND="GNU" VIDEO_CARDS="via"
Unset:  CTARGET, EMERGE_DEFAULT_OPTS, INSTALL_MASK, LANG, LC_ALL, LDFLAGS, LINGUAS, MAKEOPTS, PORTAGE_COMPRESS, PORTAGE_COMPRESS_FLAGS, PORTAGE_RSYNC_EXTRA_OPTS, PORTDIR_OVERLAY
Comment 1 Ferris McCormick (RETIRED) gentoo-dev 2007-05-11 12:31:14 UTC
This appears to be fixed with mysql-5.0.40.  At least for me on sparc, this problem and the hang in bug #174790 seemed to act as a pair.  Now, with -5.0.40 on the system for which this was failing, I can do this as often as I please:
==============================
lacewing init.d # !!
./mysql restart
 * Stopping mysql ...
 * Stopping mysqld (0)                                                                                            [ ok ]
 * Starting mysql ...
 * Starting mysql (/etc/mysql/my.cnf)                                                                             [ ok ]
=================================

And mysql works as well.  (Trust me on this, I guess.  The following is a remote connect to mysql on this system.)
==================================
fmccor@polylepis Snakes [71]% ./SnakeDriver --create=Snake.log \
>   --engines=MySql \
>   --host=lacewing       \
> --report=raw.tex
Trying a connect <dbi:MySql:Snakes:lacewing,ferris, >.........[ok]
Creating Inventory...
Creating Shed...
Creating Feed...
Creating Weight...
Creating Events...
Preloading Inventory...
===========================
Comment 2 Robin Johnson archtester Gentoo Infrastructure gentoo-dev Security 2007-05-12 23:18:44 UTC
Thanks, 5.0.40 should be in stable soon.
Comment 3 Robin Johnson archtester Gentoo Infrastructure gentoo-dev Security 2007-05-12 23:19:39 UTC
*** Bug 178088 has been marked as a duplicate of this bug. ***
Comment 4 matthew kelcey 2007-05-27 05:39:26 UTC
(In reply to comment #1)
> This appears to be fixed with mysql-5.0.40.  At least for me on sparc, this
> problem and the hang in bug #174790 seemed to act as a pair.  Now, with -5.0.40
> on the system for which this was failing, I can do this as often as I please:
> ==============================
> lacewing init.d # !!
> ./mysql restart
>  * Stopping mysql ...
>  * Stopping mysqld (0)                                                         
>                                   [ ok ]
>  * Starting mysql ...
>  * Starting mysql (/etc/mysql/my.cnf)                                          
>                                   [ ok ]
> =================================




updated portage tree and updated to mysql 5.0.40 but continue to see the problem

newt ~ # mysql --version
mysql  Ver 14.12 Distrib 5.0.40, for pc-linux-gnu (i586) using readline 5.1
newt ~ # rm -r /var/lib/mysql/
newt ~ # emerge --config =dev-db/mysql-5.0.40

Configuring pkg...

 * MySQL MY_DATADIR is /var/lib/mysql
 * Creating the mysql database and setting proper
 * permissions on it ...
 * Insert a password for the mysql 'root' user
 * Avoid ["'\_%] characters in the password
    >
 * Retype the password
    >
. * Loading "zoneinfo", this step may require a few seconds ...
 * Stopping the server ...
 * Done

newt ~ # /etc/init.d/mysql start
 * Starting mysql ...
 * Starting mysql (/etc/mysql/my.cnf)                                     [ ok ]
newt ~ # /etc/init.d/mysql stop
 * Stopping mysql ...
 * Stopping mysqld (0)                                                    [ ok ]
newt ~ # /etc/init.d/mysql start
 * Starting mysql ...
 * Starting mysql (/etc/mysql/my.cnf)
 * MySQL NOT started (0)                                                  [ !! ]




newt ~ # emerge --info
Portage 2.1.2.7 (default-linux/x86/2006.1, gcc-4.1.1, glibc-2.4-r3, 2.6.19-gentoo-r5-matpalm20070428c i686)
=================================================================
System uname: 2.6.19-gentoo-r5-matpalm20070428c i686 VIA Nehemiah
Gentoo Base System release 1.12.9
Timestamp of tree: Sat, 26 May 2007 12:50:01 +0000
dev-lang/python:     2.4.3-r1
dev-python/pycrypto: 2.0.1-r5
sys-apps/sandbox:    1.2.17
sys-devel/autoconf:  2.13, 2.61
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
sys-devel/binutils:  2.16.1-r3
sys-devel/gcc-config: 1.3.13-r3
sys-devel/libtool:   1.5.22
virtual/os-headers:  2.6.17-r2
ACCEPT_KEYWORDS="x86"
AUTOCLEAN="yes"
CBUILD="i586-pc-linux-gnu"
CFLAGS="-Os -march=c3 -m3dnow -pipe -fomit-frame-pointer"
CHOST="i586-pc-linux-gnu"
CONFIG_PROTECT="/etc /usr/share/X11/xkb"
CONFIG_PROTECT_MASK="/etc/env.d /etc/gconf /etc/terminfo"
CXXFLAGS="-Os -march=c3 -m3dnow -pipe -fomit-frame-pointer"
DISTDIR="/usr/portage/distfiles"
FEATURES="distlocks metadata-transfer sandbox sfperms strict"
GENTOO_MIRRORS="http://public.planetmirror.com/pub/gentoo http://mirror.pacific.net.au/linux/Gentoo "
PKGDIR="/usr/portage/packages"
PORTAGE_RSYNC_OPTS="--recursive --links --safe-links --perms --times --compress --force --whole-file --delete --delete-after --stats --timeout=180 --exclude=/distfiles --exclude=/local --exclude=/packages --filter=H_**/files/digest-*"
PORTAGE_TMPDIR="/var/tmp"
PORTDIR="/usr/portage"
SYNC="rsync://rsync.au.gentoo.org/gentoo-portage"
USE="aac acpi alsa berkdb bitmap-fonts cdr cli cracklib crypt cups directfb dri dvb dvd encode ffmpeg flac fortran gdbm gpm iconv ipod ipv6 isdnlog ivtv libg++ lirc midi mmx mmx2 mp3 mpeg mplayer mudflap mysql ncurses nls nptl nptlonly ogg openmp pam pcre perl ppds pppd python readline reflection session spl sse ssl svga tcpd truetype-fonts type1-fonts unicode via vidix vorbis x86 xorg xvmc 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 mulaw multi null plug rate route share shm softvol" ELIBC="glibc" INPUT_DEVICES="keyboard mouse" KERNEL="linux" LCD_DEVICES="bayrad cfontz cfontz633 glk hd44780 lb216 lcdm001 mtxorb ncurses text" LIRC_DEVICES="hauppauge" USERLAND="GNU" VIDEO_CARDS="via"
Unset:  CTARGET, EMERGE_DEFAULT_OPTS, INSTALL_MASK, LANG, LC_ALL, LDFLAGS, LINGUAS, MAKEOPTS, PORTAGE_COMPRESS, PORTAGE_COMPRESS_FLAGS, PORTAGE_RSYNC_EXTRA_OPTS, PORTDIR_OVERLAY



mysql error log slightly different than original logged on

070527 15:07:22 [Warning] No argument was provided to --log-bin, and --log-bin-index was not used; so replication may break when this MySQL server acts as a master and has his hostname changed!! Please use '--log-bin=/var/run/mysqld/mysqld-bin' to avoid this problem.
070527 15:07:22 - mysqld got signal 4;
This could be because you hit a bug. It is also possible that this binary
or one of the libraries it was linked against is corrupt, improperly built,
or misconfigured. This error can also be caused by malfunctioning hardware.
We will try our best to scrape up some info that will hopefully help diagnose
the problem, but since we have already crashed, something is definitely wrong
and this may fail.

key_buffer_size=0
read_buffer_size=258048
max_used_connections=0
max_connections=100
threads_connected=0
It is possible that mysqld could use up to
key_buffer_size + (read_buffer_size + sort_buffer_size)*max_connections = 76396 K
bytes of memory
Hope that's ok; if not, decrease some variables in the equation.

thd=(nil)
Attempting backtrace. You can use the following information to find out
where mysqld died. If you see no messages after this, something went
terribly wrong...
Cannot determine thread, fp=0xbf874cb0, backtrace may not be correct.
Stack range sanity check OK, backtrace follows:
0x4
New value of fp=0x82c8981 failed sanity check, terminating stack trace!
Please read http://dev.mysql.com/doc/mysql/en/using-stack-trace.html and follow instructions on how to resolve the stack trace. Resolved
stack trace is much more helpful in diagnosing the problem, so please do
resolve it
The manual page at http://www.mysql.com/doc/en/Crashing.html contains
information that should help you find out what is causing the crash.



current workaround is to dump entire db at stop time and delete /var/lib/mysql and reimport before starting



happy to recompile with debug flags / install other diag tools / dump other logs / whatever else; just not sure what to do 

Comment 5 Eric Chatellier 2007-06-17 11:07:24 UTC
still present in 5.0.42

emerge -pv mysql
[ebuild   R   ] dev-db/mysql-5.0.42  USE="ssl -berkdb -big-tables -cluster -debug -embedded -extraengine -latin1 -max-idx-128 -minimal -perl (-selinux) -static" 0 kB

emerge --info
Portage 2.1.2.7 (default-linux/x86/2007.0, gcc-4.1.2, glibc-2.5-r3, 2.6.20-gentoo-r8 i686)
=================================================================
System uname: 2.6.20-gentoo-r8 i686 AMD Athlon(TM) XP 2500+
Gentoo Base System release 1.12.9
Timestamp of tree: Sat, 16 Jun 2007 14:20:02 +0000
dev-java/java-config: 1.3.7, 2.0.32
dev-lang/python:     2.4.4-r4
dev-python/pycrypto: 2.0.1-r5
sys-apps/sandbox:    1.2.17
sys-devel/autoconf:  2.13, 2.61
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
sys-devel/binutils:  2.16.1-r3
sys-devel/gcc-config: 1.3.16
sys-devel/libtool:   1.5.22
virtual/os-headers:  2.6.17-r2
ACCEPT_KEYWORDS="x86"
AUTOCLEAN="yes"
CBUILD="i686-pc-linux-gnu"
CFLAGS="-O3 -march=athlon-xp -pipe -fomit-frame-pointer"
CHOST="i686-pc-linux-gnu"
CONFIG_PROTECT="/etc /usr/kde/3.5/env /usr/kde/3.5/share/config /usr/kde/3.5/shutdown /usr/share/X11/xkb /usr/share/config"
CONFIG_PROTECT_MASK="/etc/env.d /etc/env.d/java/ /etc/gconf /etc/php/apache2-php5/ext-active/ /etc/php/cgi-php5/ext-active/ /etc/php/cli-php5/ext-active/ /etc/revdep-rebuild /etc/splash /etc/terminfo /etc/texmf/web2c"
CXXFLAGS="-O3 -march=athlon-xp -pipe -fomit-frame-pointer -fvisibility-inlines-hidden"
DISTDIR="/usr/local/distfiles"
FEATURES="distlocks metadata-transfer parallel-fetch sandbox sfperms strict"
GENTOO_MIRRORS="http://distfiles.gentoo.org http://distro.ibiblio.org/pub/linux/distributions/gentoo"
LANG="fr_FR.UTF-8"
LC_ALL="fr_FR.UTF-8"
LDFLAGS="-Wl,-O1 -Wl,--sort-common -s"
LINGUAS="fr fr_FR"
MAKEOPTS="-j2"
PKGDIR="/usr/portage/packages"
PORTAGE_RSYNC_OPTS="--recursive --links --safe-links --perms --times --compress --force --whole-file --delete --delete-after --stats --timeout=180 --exclude=/distfiles --exclude=/local --exclude=/packages --filter=H_**/files/digest-*"
PORTAGE_TMPDIR="/var/tmp"
PORTDIR="/usr/portage"
SYNC="rsync://rsync.europe.gentoo.org/gentoo-portage"
USE="3dnow X alsa bash-completion bzip2 cdr dri dvd gnome gtk ipv6 jpeg kde mmx mp3 nls nptl opengl pam png qt3 readline sse ssl truetype unicode v4l vhosts x86 xml zlib" ALSA_CARDS="via82xx" 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" ELIBC="glibc" INPUT_DEVICES="keyboard mouse" KERNEL="linux" LCD_DEVICES="bayrad cfontz cfontz633 glk hd44780 lb216 lcdm001 mtxorb ncurses text" LINGUAS="fr fr_FR" USERLAND="GNU" VIDEO_CARDS="radeon"
Unset:  CTARGET, EMERGE_DEFAULT_OPTS, INSTALL_MASK, PORTAGE_COMPRESS, PORTAGE_COMPRESS_FLAGS, PORTAGE_RSYNC_EXTRA_OPTS, PORTDIR_OVERLAY
Comment 6 Patrick ALLAERT 2007-08-29 18:03:38 UTC
seems not resolved in 5.0.44

emerge -pv dev-db/mysql

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


emerge --info

Portage 2.1.2.12 (default-linux/x86/2007.0/desktop, gcc-4.1.2, glibc-2.5-r4, 2.6.22-gentoo-r5 i686)
=================================================================
System uname: 2.6.22-gentoo-r5 i686 Genuine Intel(R) CPU T2400 @ 1.83GHz
Gentoo Base System release 1.12.9
Timestamp of tree: Wed, 29 Aug 2007 16:50:01 +0000
ccache version 2.4 [enabled]
app-shells/bash:     3.2_p17
dev-java/java-config: 1.3.7, 2.0.33-r1
dev-lang/python:     2.4.4-r4
dev-python/pycrypto: 2.0.1-r6
dev-util/ccache:     2.4-r7
sys-apps/baselayout: 1.12.9-r2
sys-apps/sandbox:    1.2.17
sys-devel/autoconf:  2.13, 2.61-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
sys-devel/binutils:  2.17
sys-devel/gcc-config: 1.3.16
sys-devel/libtool:   1.5.24
virtual/os-headers:  2.6.21
ACCEPT_KEYWORDS="x86"
CBUILD="i686-pc-linux-gnu"
CFLAGS="-march=prescott -O2 -pipe -fomit-frame-pointer"
CHOST="i686-pc-linux-gnu"
CONFIG_PROTECT="/etc /usr/kde/3.5/env /usr/kde/3.5/share/config /usr/kde/3.5/shutdown /usr/share/X11/xkb /usr/share/config"
CONFIG_PROTECT_MASK="/etc/env.d /etc/env.d/java/ /etc/gconf /etc/php/apache2-php4/ext-active/ /etc/php/apache2-php5/ext-active/ /etc/php/cgi-php4/ext-active/ /etc/php/cgi-php5/ext-active/ /etc/php/cli-php4/ext-active/ /etc/php/cli-php5/ext-active/ /etc/revdep-rebuild /etc/splash /etc/terminfo"
CXXFLAGS="-march=prescott -O2 -pipe -fomit-frame-pointer"
DISTDIR="/usr/portage/distfiles"
FEATURES="ccache distlocks metadata-transfer parallel-fetch sandbox sfperms strict"
GENTOO_MIRRORS="http://ftp.belnet.be/mirror/rsync.gentoo.org/gentoo/ ftp://ftp.belnet.be/mirror/rsync.gentoo.org/gentoo/"
LC_ALL="fr_BE.UTF-8"
LINGUAS="fr nl"
MAKEOPTS="-j3"
PKGDIR="/usr/portage/packages"
PORTAGE_RSYNC_OPTS="--recursive --links --safe-links --perms --times --compress --force --whole-file --delete --delete-after --stats --timeout=180 --exclude=/distfiles --exclude=/local --exclude=/packages --filter=H_**/files/digest-*"
PORTAGE_TMPDIR="/var/tmp"
PORTDIR="/usr/portage"
PORTDIR_OVERLAY="/usr/portage/local/layman/xeffects"
SYNC="rsync://rsync.europe.gentoo.org/gentoo-portage"
USE="X acl acpi akode alsa apache2 arts avi bash-completion berkdb bitmap-fonts browserplugin cairo cdr cli cracklib crypt cups curl dbus directfb divx4linux dri dvd dvdr dvdread emboss encode enscript evo fam firefox flac gdbm gif glibc-omitfp gpm gstreamer gtk gtk2 hal howl iconv isdnlog java javascript jpeg kde kdeenablefinal kerberos ldap mad matroska midi mikmod mmx motif mozilla mp3 mpeg mplayer msn mudflap musicbrainz mysql ncurses newspr nls nptl nptlonly nsplugin offensive ogg opengl openmp oss pam pcre pdf php pic png pppd python qt qt3 qt3support qt4 quicktime readline reflection samba sasl sdl session simplexml soap spell spl sqlite ssl svg tcpd tidy tiff tokenizer truetype truetype-fonts type1-fonts unicode usb utf8 vhosts vim-with-x vorbis win32codecs x86 xinerama xml xml2 xorg xsl xv xvid zeroconf 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 mulaw multi null plug rate route share shm softvol" ELIBC="glibc" INPUT_DEVICES="keyboard mouse" KERNEL="linux" LCD_DEVICES="bayrad cfontz cfontz633 glk hd44780 lb216 lcdm001 mtxorb ncurses text" LINGUAS="fr nl" USERLAND="GNU" VIDEO_CARDS="fglrx"
Unset:  CTARGET, EMERGE_DEFAULT_OPTS, INSTALL_MASK, LANG, LDFLAGS, PORTAGE_COMPRESS, PORTAGE_COMPRESS_FLAGS, PORTAGE_RSYNC_EXTRA_OPTS
Comment 7 Patrick ALLAERT 2007-09-03 07:55:41 UTC
BUMP
Comment 8 Stephan Menzel 2009-11-18 08:18:39 UTC
I have the same problem here with both 

dev-db/mysql-5.0.84 5.0.84-r1
and 
dev-db/mysql-community-5.0.77-r1

I have tried a lot of workarounds with all sorts of USE flags, including build opf both versions with and without the following:

berkdb innodb community embedded 

All to no effect.
It's a amd64 fresh install here, no data were imported.

This is quite a major issue for me because it renders both akonadi and amarok unuseable. Both try to start an embedded mysql server which shows the exact same behaviour, causing the app to crash along with it.

Since this one has been open for more than 2 years now, is it sensible to wait for a solution any longer?

Cheers,
Stephan
Comment 9 Stephan Menzel 2009-11-18 10:07:09 UTC
uncommenting the line

skip-innodb

in /etc/mysql/my.cnf makes the server start. That doesn't actually solve much but it may be a workaround for some.

Cheers,
Stephan
Comment 10 Stephan Menzel 2009-11-18 11:08:31 UTC
Also, I've updated an existing mysql bug:
http://bugs.mysql.com/bug.php?id=47113
Comment 11 Stephan Menzel 2009-11-30 10:57:53 UTC
is anyone actually interested in that one?

S.
Comment 12 Stephan Menzel 2010-01-04 10:07:07 UTC
This hase been fixed in mysql. I just tried it with 5.1.42.

So can you please offer this version in portage ~ ?

I would give it a try then.

Cheers,
Stephan
Comment 13 Robin Johnson archtester Gentoo Infrastructure gentoo-dev Security 2010-02-01 01:41:07 UTC
5.1.4[123] available in the tree now.