Bug 135387 – mysql 5.0.19-r1/5.0.21 won't startup ( mysqld got signal 4)

• Product: Gentoo Linux
• Status: RESOLVED DUPLICATE

[Description Bob Holcomb 2006-06-03 06:46:03 UTC]

+++ This bug was initially created as a clone of Bug #135324 +++
output of mysqld.err log:

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 = 76399 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=0xb6954000, backtrace may not be correct.
Bogus stack limit or frame pointer, fp=0xb6954000, stack_bottom=0xbf980000, thread_stack=196608, aborting backtrace.
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.


if I change in /etc/mysql/my.cnf the value of tmpdir to something other than /tmp, it will start up, but I get the following errors:

[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=tiny-bin' to avoid this problem.
^G/usr/sbin/mysqld: Can't create/write to file '/home/bob/tmp/ibJLLMRd' (Errcode: 13)
060603  9:43:01  InnoDB: Error: unable to create temporary file; errno: 13
060603  9:43:01 [Note] /usr/sbin/mysqld: ready for connections.
Version: '5.0.19-log'  socket: '/var/run/mysqld/mysqld.sock'  port: 3306  Gentoo Linux mysql-5.0.19-r1

my emerge --info

Portage 2.1_rc3-r3 (default-linux/x86/2005.1, gcc-4.1.1, glibc-2.4-r3, 2.6.16.19 i686)
=================================================================
System uname: 2.6.16.19 i686 VIA Nehemiah
Gentoo Base System version 1.12.0
dev-lang/python:     2.4.3-r1
dev-python/pycrypto: 2.0.1-r5
dev-util/ccache:     [Not Present]
dev-util/confcache:  [Not Present]
sys-apps/sandbox:    1.2.18.1
sys-devel/autoconf:  2.13, 2.59-r7
sys-devel/automake:  1.4_p6, 1.5, 1.6.3, 1.7.9-r1, 1.8.5-r3, 1.9.6-r2
sys-devel/binutils:  2.16.1-r2
sys-devel/libtool:   1.5.22
virtual/os-headers:  2.6.11-r5
ACCEPT_KEYWORDS="x86 ~x86"
AUTOCLEAN="yes"
CBUILD="i686-pc-linux-gnu"
CFLAGS="-Os -march=c3-2 -mmmx -msse -m3dnow -mfpmath=sse -fomit-frame-pointer -ftree-vectorize -pipe"
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/gconf /etc/revdep-rebuild /etc/terminfo /etc/env.d"
CXXFLAGS="-Os -march=c3-2 -mmmx -msse -m3dnow -mfpmath=sse -fomit-frame-pointer -ftree-vectorize -pipe"
DISTDIR="/usr/portage/distfiles"
FEATURES="autoconfig distlocks metadata-transfer sandbox sfperms strict"
GENTOO_MIRRORS="http://distfiles.gentoo.org http://distro.ibiblio.org/pub/linux/distributions/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'"
PORTAGE_TMPDIR="/var/tmp"
PORTDIR="/usr/portage"
PORTDIR_OVERLAY="/usr/local/portage"
SYNC="rsync://rsync.gentoo.org/gentoo-portage"
USE="x86 2 3dnow X a52 aac aalib acpi alsa apache apm avi berkdb bitmap-fonts bzip2 cle266 cli crypt cups divx4linux dri dts dvd dvdread eds emboss encode ffmpeg fftw flac flash foomaticdb gdbm gif gpm gstreamer gtk2 ieee1394 imlib isdnlog joystick jpeg libg++ libwww lirc mad mikmod mmx mp3 mpeg mpeg2 mpeg4 mysql mythtv ncurses nls nptl nptlonly ogg oggvorbis opengl oss pam pcre pdflib perl png pppd python qt quicktime readline reflection sdl session spl sse ssl tcpd theora threads truetype truetype-fonts type1-fonts unichrome usb v4l v4l2 vorbis xine xml2 xmms xorg xv xvid xvmc zlib elibc_glibc input_devices_keyboard input_devices_mouse kernel_linux userland_GNU video_cards_via"
Unset:  CTARGET, EMERGE_DEFAULT_OPTS, INSTALL_MASK, LANG, LC_ALL, LDFLAGS, LINGUAS, MAKEOPTS, PORTAGE_RSYNC_EXTRA_OPTS

[Comment 1 Jakub Moc (RETIRED) 2006-06-03 07:35:29 UTC]

Don't file needless duplicate bugs, please.


*** This bug has been marked as a duplicate of 135324 ***