Gentoo Websites Logo
Go to: Gentoo Home Documentation Forums Lists Bugs Planet Store Wiki Get Gentoo!

Bug 110560

Summary: Mysql 5.0.15 crash on phpmyadmin 2.6.4_p3 update table
Product: Gentoo Linux Reporter: phasma <phasma>
Component: [OLD] ServerAssignee: Gentoo Linux MySQL bugs team <mysql-bugs>
Status: RESOLVED INVALID    
Severity: critical CC: nysander
Priority: High    
Version: unspecified   
Hardware: x86   
OS: Linux   
Whiteboard:
Package list:
Runtime testing required: ---

Description phasma 2005-10-26 10:29:13 UTC
mysql 5.0.5 plus phpmyadmin 2.6.4_p3

mysql -u root -p <
/usr/share/webapps/phpmyadmin/2.6.4_p3/sqlscripts/mysql/2.6.4_p3_create.sql 
Enter password: 
ERROR 2013 (HY000) at line 3: Lost connection to MySQL server during query

mysql crashed

from mysqld.err:

Version: '5.0.15'  socket: '/var/run/mysqld/mysqld.sock'  port: 3306  Gentoo
Linux mysql-5.0.15
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=16777216
read_buffer_size=131072
max_used_connections=1
max_connections=100
threads_connected=1
It is possible that mysqld could use up to 
key_buffer_size + (read_buffer_size + sort_buffer_size)*max_connections = 233983 K
bytes of memory
Hope that's ok; if not, decrease some variables in the equation.

thd=0x807faa58
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=0x404c29fc, backtrace may not be correct.
Bogus stack limit or frame pointer, fp=0x404c29fc, stack_bottom=0x42350000,
thread_stack=262144, aborting backtrace.
Trying to get some variables.
Some pointers may be invalid and cause the dump to abort...
thd->query at 0x80824c38 = GRANT SELECT (Host, User, Select_priv, Insert_priv,
Update_priv, Delete_priv,
        Create_priv, Drop_priv, Reload_priv, Shutdown_priv, Process_priv,
        File_priv, Grant_priv, References_priv, Index_priv, Alter_priv)
        ON mysql.user TO 'pma'@'localhost'
thd->thread_id=1
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.

Number of processes running now: 0

Reproducible: Always
Steps to Reproduce:
1.
2.
3.
Comment 1 Francesco R. (RETIRED) gentoo-dev 2005-10-26 15:20:12 UTC
Sorry this will not be worked very soon, 
but your "emerge --info" and "/var/log/mysql/"* (cutted at the error)
may be very useful at the time this can be worked on.
Comment 2 phasma 2005-10-26 16:32:57 UTC
# emerge --info      
Portage 2.0.53_rc6 (default-linux/x86/2005.0, gcc-3.4.4, glibc-2.3.5-r2,
2.6.5-grsec i686)
=================================================================
System uname: 2.6.5-grsec i686 Intel(R) Pentium(R) 4 CPU 2.66GHz
Gentoo Base System version 1.12.0_pre9
dev-lang/python:     2.1.3-r1, 2.3.5-r2, 2.4.2
sys-apps/sandbox:    1.2.13
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-r1
sys-devel/binutils:  2.16.1
sys-devel/libtool:   1.5.20
virtual/os-headers:  2.6.11-r2
ACCEPT_KEYWORDS="x86 ~x86"
AUTOCLEAN="yes"
CBUILD="i686-pc-linux-gnu"
CFLAGS="-O3 -march=pentium4 -mtune=pentium4 -fforce-addr -pipe -fomit-frame-pointer"
CHOST="i686-pc-linux-gnu"
CONFIG_PROTECT="/etc /usr/kde/2/share/config /usr/kde/3/share/config
/usr/share/config /var/bind /var/qmail/control"
CONFIG_PROTECT_MASK="/etc/gconf /etc/terminfo /etc/texmf/web2c /etc/env.d"
CXXFLAGS="-O3 -march=pentium4 -mtune=pentium4 -fforce-addr -pipe
-fomit-frame-pointer -fvisibility-inlines-hidden"
DISTDIR="/usr/portage/distfiles"
FEATURES="autoconfig distlocks sandbox sfperms strict"
GENTOO_MIRRORS="http://mirror.switch.ch/ftp/mirror/gentoo/"
MAKEOPTS="-j3"
PKGDIR="/usr/portage/packages"
PORTAGE_TMPDIR="/var/tmp"
PORTDIR="/usr/portage"
SYNC="rsync://rsync.gentoo.org/gentoo-portage"
USE="x86 aalib apache2 authdaemond authfile bcmath berkdb big-tables
bitmap-fonts cli crypt ctype dba eds emboss extensions gb gd-external gif
hardened hardenedphp iconv imagemagick imagemagik imap imlib innodb jpeg libwww
maildir mhash mp3 mysql ncurses nls ogg pam pcre pdflib pear perl php plotutils
png postfix python readline sasl session spell ssl tetex tiff tokenizer truetype
truetype-fonts type1-fonts udev unicode userlocales vorbis xml2 zlib
userland_GNU kernel_linux elibc_glibc"
Unset:  ASFLAGS, CTARGET, LANG, LC_ALL, LDFLAGS, LINGUAS, PORTDIR_OVERLAY


mysqld.err was attached in the first post
Comment 3 phasma 2005-10-29 06:32:23 UTC
solved with upgrading to hardened-source 2.6.13-r3, gcc 3.3.6 and recompiling
entire system for new compiler

Comment 4 Pawel Madej aka Nysander 2005-12-27 17:15:38 UTC
request for closing this bug as it was resolved.
Comment 5 Francesco R. (RETIRED) gentoo-dev 2005-12-28 02:50:43 UTC
sure