| Summary: | dev-db/mysql 5.1.44 with max-idx-128 crash on startup | ||
|---|---|---|---|
| Product: | Gentoo Linux | Reporter: | Thomas Phipps <gentoobugs> |
| Component: | Current packages | Assignee: | Gentoo Linux MySQL bugs team <mysql-bugs> |
| Status: | RESOLVED NEEDINFO | ||
| Severity: | normal | CC: | dirk, invisibunny, mortals, stsander |
| Priority: | High | ||
| Version: | unspecified | ||
| Hardware: | x86 | ||
| OS: | Linux | ||
| Whiteboard: | |||
| Package list: | Runtime testing required: | --- | |
|
Description
Thomas Phipps
2010-02-23 17:12:44 UTC
I saw this exact same behavior on AMD64 when I tried to use this version of mysql, so the scope of problem is wider than just x86. Why are you using max-idx-128? If you move your databases out the way, and run the "emerge --config dev-db/mysql" does it start up after that? I have same problem. If i have remove dir /var/lib/mysql than "emerge --config dev-db/mysql" has failed: ERROR: dev-db/mysql-5.1.44 failed: * Failed to run mysql_install_db. Please review /var/log/mysql/mysqld.err AND /var/tmp/portage/dev-db/mysql-5.1.44/temp/mysql_install_db.log in mysqld.err is: ERROR: 1146 Table 'mysql.tmp_db' doesn't exist 100301 10:27:53 [ERROR] Aborting 100301 10:27:53 [Note] /usr/sbin/mysqld: Shutdown complete in mysql_install_db.log: Installation of system tables failed! Examine the logs in /var/lib/mysql for more information. No logs are in /var/lib/mysql, databases test and mysql seems well, there are *.frm *.MYI and *.MYD files, but start of mysql is crashing with same error as above. /usr/sbin/mysqld --skip-grant doesnt work too. I have reproduce this on source code from upstream without gentoo patches with similiar configure command as portage using: ./configure '--prefix=/usr/local/mysql51' '--build=x86_64-pc-linux-gnu' '--host=x86_64-pc-linux-gnu' '--sysconfdir=/etc' '--sysconfdir=/etc/mysql' '--with-low-memory' '--with-client-ldflags=-lstdc++' '--enable-thread-safe-client' '--with-comment=Gentoo Linux mysql-5.1.44' '--without-docs' '--with-big-tables' '--enable-local-infile' '--with-extra-charsets=all' '--with-mysqld-user=mysql' '--with-server' '--with-unix-socket-path=/var/run/mysqld/mysqld.sock' '--without-libwrap' '--enable-shared' '--enable-static' '--without-debug' '--with-charset=utf8' '--with-collation=utf8_general_ci' '--without-embedded-privilege-control' '--without-embedded-server' '--with-ssl' '--enable-assembler' '--with-geometry' '--with-readline' '--with-zlib-dir=/usr/' '--without-pstack' '--with-max-indexes=128' '--with-plugins=csv,myisam,myisammrg,heap,archive,blackhole,federated,partition,innobase,innodb_plugin' 'build_alias=x86_64-pc-linux-gnu' 'host_alias=x86_64-pc-linux-gnu' 'CFLAGS=-mtune=nocona -O2 -pipe -fomit-frame-pointer -DHAVE_ERRNO_AS_DEFINE=1 -fno-strict-aliasing' 'LDFLAGS=-Wl,-O1' 'CPPFLAGS=' 'CXXFLAGS=-mtune=nocona -O2 -pipe -fomit-frame-pointer -DHAVE_ERRNO_AS_DEFINE=1 -fno-exceptions -fno-strict-aliasing -felide-constructors -fno-rtti -fno-implicit-templates -fno-strict-aliasing' Without "--with-max-indexes=128" mysql works, but if I compiled mysql only with "-with-max-indexes=128" and without other options, cant reproduce. (In reply to comment #2) > Why are you using max-idx-128? > > If you move your databases out the way, and run the "emerge --config > dev-db/mysql" does it start up after that? > honestly usage amounts to testing. no practical use here. as for moving the mysql directory out of the way and running config, it also failed. see Martin Korous's reply for error. Same issue here. Renaming /var/lib/mysql and running the emerge --config as asked in comment #2 still results in the same segfault and crash. emerging without the max-idx-128 use flag results in a working install. I'm running ~amd64 no multilib here. What testing are you doing that needs max-idx-128? You're going to need to fire up GDB and produce a backtrace, possibly take it upstream too. Please reopen with backtrace. |
