Bug 236647 – dev-db/mysql-5.0.60-r1: Crashing on x86_64 on any Select Query

• Product: Gentoo Linux
• Status: RESOLVED FIXED

[Description Thorsten Hallwas 2008-09-04 04:33:24 UTC]

Upgraded from dev-db/mysql-5.0.54 to dev-db/mysql-5.0.60-r1 resulted in instant crashes as soon as i send a select query. Repairing all tables didn't fix it. Downgrading to dev-db/mysql-5.0.54 solved the issue instantly.



Reproducible: Always

Steps to Reproduce:
1.Install 5.0.60r1
2.Send a Select Query




Uname:
2.6.20-1.3002.fc6xen #1 SMP Mon Aug 13 14:21:21 EDT 2007 x86_64 Dual Core AMD Opteron(tm) Processor 270 AuthenticAMD GNU/Linux

Section from /var/log/mysql/mysqld.err


080903 13:53:55 - mysqld got signal 11 ;
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=2147483648
read_buffer_size=8384512
max_used_connections=4
max_connections=1200
threads_connected=4
It is possible that mysqld could use up to
key_buffer_size + (read_buffer_size + sort_buffer_size)*max_connections
= 21753114 K
bytes of memory
Hope that's ok; if not, decrease some variables in the equation.

thd=0x17b0640
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=0x450890e0, backtrace may not be correct.
Stack range sanity check OK, backtrace follows:
(nil)
New value of fp=0x17b0640 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
Trying to get some variables.
Some pointers may be invalid and cause the dump to abort...
thd->query at 0x17b7240 = SELECT         user.userID as wcfUserID,
user_option.userID as optionUserID,  wbb_user.*, wbb_user.userID AS
wbbUserID,
                                        GROUP_CONCAT(DISTINCT
whitelist.whiteUserID ORDER BY whitelist.whiteUserID ASC SEPARATOR ',')
AS buddies,
                                        GROUP_CONCAT(DISTINCT
blacklist.blackUserID ORDER BY blacklist.blackUserID ASC SEPARATOR ',')
AS ignoredUser,   GROUP_CONCAT(DISTINCT groups.groupID ORDER BY
groups.groupID ASC SEPARATOR ',') AS groupIDs,
                                        GROUP_CONCAT(DISTINCT
languages.languageID ORDER BY languages.languageID ASC SEPARATOR ',') AS
languageIDs,user_option.*,
                                        user.*
                                FROM    wcf1_user user
                                                LEFT JOIN wbb1_1_user
wbb_user ON (wbb_user.userID = user.userID)
                                        LEFT JOIN wcf1_user_whitelist
whitelist ON (whitelist.userID = user.userID)
                                        LEFT JOIN wcf1_user_blacklist
blacklist ON (blacklist.userID = user.userID)     LEFT JOIN
wcf1_user_to_groups groups ON (groups.userID = user.userID)
                                        LEFT JOIN wcf1_user_to_languages
languages ON (languages.userID = user.userID) LEFT JOIN
wcf1_user_option_value use
thd->thread_id=21
The manual page at http://dev.mysql.com/doc/mysql/en/crashing.html contains
information that should help you find out what is causing the crash.


Configuration in /etc/mysql/my.cnf

[mysqld]
character-set-server            = utf8
default-character-set           = utf8
user                                            = mysql
port                                            = 3306
socket                                          = /var/run/mysqld/mysqld.sock
pid-file                                        = /var/run/mysqld/mysqld.pid
log-error                                       = /var/log/mysql/mysqld.err
basedir                                         = /usr
datadir                                         = /var/lib/mysql
#skip-locking

#key_buffer                     = 16M
key_buffer_size                 = 1G
max_allowed_packet              = 10M

#table_cache                    = 64
table_cache                     = 4048

#sort_buffer_size               = 512K
sort_buffer_size                = 8388576

net_buffer_length               = 8K

#read_buffer_size               = 256K
read_buffer_size                = 8388576

#read_rnd_buffer_size           = 512K
read_rnd_buffer_size            = 16777152

#myisam_sort_buffer_size        = 8M
myisam_sort_buffer_size         = 128M
thread_cache_size               = 8
query_cache_size                = 67108864
max_heap_table_size             = 512M
#thread_concurrency = 8
max_connections                 = 1200

tmp_table_size                  = 1G

[Comment 1 Jeroen Roovers (RETIRED) 2008-09-04 05:20:33 UTC]

Please post your `emerge --info' too.

[Comment 2 Thorsten Hallwas 2008-09-04 06:09:00 UTC]

Portage 2.1.4.4 (default-linux/amd64/2007.0, gcc-4.1.2, glibc-2.6.1-r0, 2.6.20-1.3002.fc6xen x86_64)
=================================================================
System uname: 2.6.20-1.3002.fc6xen x86_64 Dual Core AMD Opteron(tm) Processor 270
Timestamp of tree: Wed, 03 Sep 2008 11:04:01 +0000
ccache version 2.4 [disabled]
app-shells/bash:     3.2_p33
dev-java/java-config: 1.3.7, 2.1.6
dev-lang/python:     2.4.4-r13, 2.5.2-r6
dev-python/pycrypto: 2.0.1-r6
dev-util/ccache:     2.4-r7
sys-apps/baselayout: 1.12.11.1
sys-apps/sandbox:    1.2.18.1-r2
sys-devel/autoconf:  2.61-r2
sys-devel/automake:  1.9.6-r2, 1.10.1
sys-devel/binutils:  2.18-r3
sys-devel/gcc-config: 1.4.0-r4
sys-devel/libtool:   1.5.26
virtual/os-headers:  2.6.23-r3
ACCEPT_KEYWORDS="amd64"
CBUILD="x86_64-pc-linux-gnu"
CFLAGS="-O2 -march=opteron -pipe"
CHOST="x86_64-pc-linux-gnu"
CONFIG_PROTECT="/etc"
CONFIG_PROTECT_MASK="/etc/ca-certificates.conf /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/terminfo /etc/udev/rules.d"
CXXFLAGS="-O2 -march=opteron -pipe"
DISTDIR="/usr/portage/distfiles"
FEATURES="distlocks metadata-transfer sandbox sfperms strict unmerge-orphans userfetch"
GENTOO_MIRRORS="http://distfiles.gentoo.org http://distro.ibiblio.org/pub/linux/distributions/gentoo"
MAKEOPTS="-j9"
PKGDIR="/usr/portage/packages"
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"
SYNC="rsync://rsync.gentoo.org/gentoo-portage"
USE="acl amd64 apache2 berkdb cli cracklib crypt ctype cups dri fortran gd gdbm gpm iconv ipv6 isdnlog jpeg lvm2 midi mmx mudflap mysql mysqli ncurses nfs nls nptl nptlonly openmp pam pcre perl png pppd python readline reflection session spl sse sse2 ssl tcpd unicode xorg 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 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="keyboard mouse evdev" KERNEL="linux" LCD_DEVICES="bayrad cfontz cfontz633 glk hd44780 lb216 lcdm001 mtxorb ncurses text" USERLAND="GNU" VIDEO_CARDS="apm ark chips cirrus cyrix dummy fbdev glint i128 i810 mach64 mga neomagic nv r128 radeon rendition s3 s3virge savage siliconmotion sis sisusb tdfx tga trident tseng v4l vesa vga via vmware voodoo"
Unset:  CPPFLAGS, CTARGET, EMERGE_DEFAULT_OPTS, FFLAGS, INSTALL_MASK, LANG, LC_ALL, LDFLAGS, LINGUAS, PORTAGE_COMPRESS, PORTAGE_COMPRESS_FLAGS, PORTAGE_RSYNC_EXTRA_OPTS, PORTDIR_OVERLAY

[Comment 3 Ulf Theobald 2008-09-24 15:44:02 UTC]

Hi Thorsten,

same issue here. Did you resolv this? I'm also using XEN on x86_64

[Comment 4 Thorsten Hallwas 2008-09-25 08:25:09 UTC]

Hello Ulf,
I just emerged the Version 5.0.54 again and all problems were gone.

Thorsten

[Comment 5 Conrad Kostecki 2008-10-16 10:46:19 UTC]

MySQL 5.0.62 and higher will fix this.

I am right, that you are using software from Woltlab? So MySQL >= 5.0.62 fix this. This should be commited to Portage...

[Comment 6 Thorsten Hallwas 2008-10-16 11:41:22 UTC]

(In reply to comment #5)
> MySQL 5.0.62 and higher will fix this.
> 
> I am right, that you are using software from Woltlab? So MySQL >= 5.0.62 fix
> this. This should be commited to Portage...
> 

I tried Queries from the console on mysql.* too, still was crashing. It is not related to the Woltlab software.

[Comment 7 Robin Johnson 2008-11-14 21:22:06 UTC]

.70 is in the tree already