i installed mysql today, but i can't really work with it. i emerged also phpmyadmin, at the end i issued the commands which are shown and i get: mysql -u root -p < /usr/share/webapps/phpmyadmin/2.7.0_p1/sqlscripts/mysql/2.7.0_p1_create.sql Enter password: ERROR 2013 (HY000) at line 15: Lost connection to MySQL server during query the mysql error file has this: 051208 18:35:15 [Note] /usr/sbin/mysqld: ready for connections. Version: '5.0.16-log' socket: '/var/run/mysqld/mysqld.sock' port: 0 Gentoo Linux mysql-5.0.16-r3 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=258048 max_used_connections=9 max_connections=100 threads_connected=2 It is possible that mysqld could use up to key_buffer_size + (read_buffer_size + sort_buffer_size)*max_connections = 92783 K bytes of memory Hope that's ok; if not, decrease some variables in the equation. thd=0x8adaaf8 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=0x856e05e, backtrace may not be correct. Bogus stack limit or frame pointer, fp=0x856e05e, stack_bottom=0xb3e00000, thread_stack=196608, aborting backtrace. Trying to get some variables. Some pointers may be invalid and cause the dump to abort... thd->query at 0x8ac6318 = CREATE DATABASE IF NOT EXISTS pmadb thd->thread_id=31 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. USE-Flags are: These are the packages that I would merge, in order: Calculating dependencies ...done! [ebuild R ] dev-db/mysql-5.0.16-r3 +berkdb +big-tables -cluster -debug +extraengine -minimal +perl (-selinux) +ssl -static +utf8 0 kB Reproducible: Always Steps to Reproduce: 1. install mysql-5.0.16-r3 2. call mysql 3. execute "CREATE DATABASE IF NOT EXISTS test" Actual Results: server crashes Expected Results: should not crash Portage 2.0.53 (default-linux/x86/2005.1, gcc-3.4.4, glibc-2.3.5-r3, 2.6.14-gentoo-r4-2005.1 i686) ================================================================= System uname: 2.6.14-gentoo-r4-2005.1 i686 Pentium III (Coppermine) Gentoo Base System version 1.12.0_pre11 dev-lang/python: 2.4.2 sys-apps/sandbox: 1.2.17 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-r1 sys-devel/libtool: 1.5.20-r1 virtual/os-headers: 2.6.11-r3 ACCEPT_KEYWORDS="x86 ~x86" AUTOCLEAN="yes" CBUILD="i686-pc-linux-gnu" CFLAGS="-march=pentium3 -pipe -Os -fomit-frame-pointer -fno-ident -fforce-addr -ftracer -fweb -falign-functions=4" CHOST="i686-pc-linux-gnu" CONFIG_PROTECT="/etc /usr/kde/2/share/config /usr/kde/3.5/env /usr/kde/3.5/share/config /usr/kde/3.5/shutdown /usr/kde/3/share/config /usr/lib/X11/xkb /usr/lib/fax /usr/share/config /var/qmail/control /var/spool/fax/etc" CONFIG_PROTECT_MASK="/etc/gconf /etc/terminfo /etc/texmf/web2c /etc/env.d" CXXFLAGS="-march=pentium3 -pipe -Os -fomit-frame-pointer -fno-ident -fforce-addr -ftracer -fweb -falign-functions=4 -fvisibility-inlines-hidden" DISTDIR="/usr/portage/distfiles" FEATURES="autoconfig distlocks sandbox sfperms strict" GENTOO_MIRRORS="http://distfiles.gentoo.org http://distro.ibiblio.org/pub/linux/distributions/gentoo" LANG="de_DE.utf8" LC_ALL="de_DE.utf8" LDFLAGS="-Wl,-O1 -Wl,--sort-common" LINGUAS="de" MAKEOPTS="-j3" PKGDIR="/usr/portage/packages" PORTAGE_TMPDIR="/var/tmp" PORTDIR="/usr/portage" PORTDIR_OVERLAY="/usr/local/portage" SYNC="rsync://rsync.gentoo.org/gentoo-portage" USE="x86 7zip X Xaw3d a52 aac aalib accessibility acl acpi alsa amuled apache2 apm ares arts artswrappersuid artworkextra asterisk async audiofile authfile automount avi bash-completion bcmath berkdb big-tables bitmap-fonts brltty bzip2 cairo calender canvas caps cdb cdr cjk clamav cli crypt ctype cups curl curlwrappers cvsgraph dba dbus dga directfb djbfft dlloader dmx doc dts dvd dvdr dvi dynagraph eds elf emacs emboss encode enscript esd examples exif expat extraengine fam fbcon ffmpeg firefox flac flatfile font-server fontconfig foomaticdb fortran fpx freetds freetts ftp gcj gd gdbm ggi gif glep glibc-omitfp glitz glut gmp gnome gnutls gpm graphviz gs gstreamer gtk gtk2 gtkhtml guile hal hesiod howl iconv idled idn ieee1394 imagemagick imap imlib immqt inifile insecure-drivers ipv6 ithreads jack jack-tmpfs java java-external javascript jbig jce jikes jpeg justify kde kdeenablefinal kerberos lcms ldap ldapsam leim libcaca libclamav libg++ libwww lm_sensors logrotate mad mbrola memlimit mgetty mhash mikmod ming mmap mmx mng mod_python mono motif mozcalendar mozdevelop mp3 mpeg mpm-prefork mssql mysql mysqli nas nautilus ncurses neXt netpbm network nfs nis nls nntp nptl nptlonly nsplugin numeric oav objc odbc ogg oggvorbis on-the-fly-crypt opengl oss pam pam_chroot pam_console pam_timestamp pcntl pcre pda pdflib pdo-external pear perl perlsuid pg-hier pg-intdatetime php physfs pic png portaudio posix postgres ppds pwdb python qt quicktime quotas readline remote rewrite rle rpm ruby samba sample sasl sdk sdl sendfile sensord session shaper sharedmem silc simplexml sitemisc skey slang slp smartcard smux sndfile snmp soap sockets socks5 softquota source speex spell spf spl sqlite srp sse ssl stats svg svga swat symlink sysfs syslog sysvipc t1lib tcltk tcpd tetex theora threads tidy tiff tokenizer toolbar tools truetype truetype-fonts type1-fonts ucs2 udev unicode urandom usb utf8 v4l vda vorbis wddx winbind wmf xinerama xinetd xml2 xmlrpc xpm xprint xsl xv xvid yaz zip zlib video_cards_ati128 linguas_de userland_GNU kernel_linux elibc_glibc" Unset: ASFLAGS, CTARGET
Please try stripping C*FLAGS, mysql by default compile with -O3 otherwise recompile with "debug" use flag, uncomment in my.cnf the section ------------------ log = /tmp/mysqld.sql gdb debug = d:t:i:o,/tmp/mysqld.trace one-thread ------------------ and try to look at what happen
ok testet some CFLAGS combinations, the only one which for me works is CFLAGS="-march=pentium3 -pipe -O3 -fomit-frame-pointer", but Os is really causes these crashesin many cases
Considered also Bug #110149 . Now "-O" "-Os" "-O1" are filtered, so falling to the default "-O3" , "-O2" is kept since it's tested here and work just fine. Thanks for the report.
