Using mysql 4.1.8(-r1), everything went right. I had subqueries (which is the reason why I need >=4.1.x) and the transition from 4.0.x was smooth following mysql.com manual pages (just required a user-table fixup for passwords, if I remember correctly). Some days ago I updated to 4.1.12, and discovered that I wasn't able to bring up the mysqld server. If I try to use the init.d script, and then "ps -A x", no mysqld process is found. It seems that it exits almost immediately. So I tried re-emerging mysql with FEATURES="maketest", and : Making check in tools make[1]: Entering directory `/var/tmp/portage/mysql-4.1.12/work/mysql/tools' make[1]: Nothing to be done for `check'. make[1]: Leaving directory `/var/tmp/portage/mysql-4.1.12/work/mysql/tools' [32;01m*[0m >>> Test phase [test]: dev-db/mysql-4.1.12 cd mysql-test; ./mysql-test-run && ./mysql-test-run --ps-protocol Installing Test Databases Removing Stale Files Installing Master Databases running ../sql/mysqld --no-defaults --bootstrap --skip-grant-tables --basedir=. --datadir=./var/master-data --skip-innodb --skip-ndbcluster --skip-bdb --language=../sql/share/english/ --character-sets-dir=../sql/share/charsets/ Installing Slave Databases running ../sql/mysqld --no-defaults --bootstrap --skip-grant-tables --basedir=. --datadir=./var/slave-data --skip-innodb --skip-ndbcluster --skip-bdb --language=../sql/share/english/ --character-sets-dir=../sql/share/charsets/ Manager disabled, skipping manager start. Loading Standard Test Databases Starting Tests TEST RESULT ------------------------------------------------------- alias [ pass ] alter_table [ pass ] analyse [ pass ] ansi [ pass ] archive [ skipped ] auto_increment [ pass ] backup [ pass ] bdb-alter-table-1 [ pass ] bdb-alter-table-2 [ pass ] bdb-crash [ pass ] bdb-deadlock [ pass ] bdb [ pass ] bdb_cache [ pass ] bench_count_distinct [ pass ] bigint [ pass ] binary [ pass ] blackhole [ skipped ] bool [ pass ] bulk_replace [ pass ] [... "c" to "o" tests passed or skipped ...] packet [ pass ] preload [ pass ] ps [ pass ] ps_10nestset [ pass ] ps_11bugs [ pass ] ps_1general [ pass ] ps_2myisam [ pass ] ps_3innodb [ pass ] ps_4heap [ pass ] ps_5merge [ pass ] ps_6bdb [ pass ] ps_7ndb [ skipped ] ps_grant [ pass ] query_cache [ pass ] query_cache_merge [ skipped ] raid [ pass ] range [ pass ] rename [ pass ] repair [ pass ] replace [ skipped ] rollback [ pass ] row [ pass ] rpl000001 [ pass ] rpl000002 [ pass ] rpl000004 [ pass ] rpl000005 [ pass ] rpl000006 [ pass ] rpl000008 [ pass ] rpl000009 [ pass ] rpl000010 [ fail ] Errors are (from /var/tmp/portage/mysql-4.1.12/work/mysql/mysql-test/var/log/mysqltest-time) : /var/tmp/portage/mysql-4.1.12/work/mysql/client/.libs/mysqltest: At line 9: query 'stop slave' failed: 2013: Lost connection to MySQL server during query (the last lines may be the most important ones) Aborting: rpl000010 failed in default mode. To continue, re-run with '--force'. Ending Tests Shutting-down MySQL daemon Master shutdown finished slave not cooperating with mysqladmin, will try manual kill ./mysql-test-run: line 1383: kill: (5414) - No such process slave refused to die. Sending SIGKILL ./mysql-test-run: line 1387: kill: (5414) - No such process Slave shutdown finished make: *** [test] Error 1 !!! ERROR: dev-db/mysql-4.1.12 failed. !!! Function src_test, Line 365, Exitcode 1 !!! make test failed !!! If you need support, post the topmost build error, NOT this status message. I'll also attach the output of "strace mysql". I'm not really good at interpreting it, but maybe you can guess something more than me. Thanks for the good work, Matteo Portage 2.0.51.22-r1 (default-linux/x86/2005.0, gcc-3.4.3-20050110, glibc-2.3.5-r0, 2.6.11-gentoo-r9 i686) ================================================================= System uname: 2.6.11-gentoo-r9 i686 Intel(R) Pentium(R) 4 CPU 2.40GHz Gentoo Base System version 1.6.12 distcc 2.18.3 i686-pc-linux-gnu (protocols 1 and 2) (default port 3632) [disabled] dev-lang/python: 2.2.3-r5, 2.3.5 sys-apps/sandbox: 1.2.1-r2 sys-devel/autoconf: 2.13, 2.59-r6 sys-devel/automake: 1.4_p6, 1.5, 1.6.3, 1.7.9-r1, 1.8.5-r3, 1.9.5 sys-devel/binutils: 2.16 sys-devel/libtool: 1.5.18 virtual/os-headers: 2.6.11 ACCEPT_KEYWORDS="x86 ~x86" AUTOCLEAN="yes" CBUILD="i686-pc-linux-gnu" CFLAGS="-O3 -march=pentium4 -pipe" CHOST="i686-pc-linux-gnu" CONFIG_PROTECT="/etc /usr/kde/2/share/config /usr/kde/3.4/env /usr/kde/3.4/share/config /usr/kde/3.4/shutdown /usr /kde/3/share/config /usr/lib/X11/xkb /usr/share/config /usr/share/texmf/dvipdfm/config/ /usr/share/texmf/dvips/con fig/ /usr/share/texmf/tex/generic/config/ /usr/share/texmf/tex/platex/config/ /usr/share/texmf/xdvi/ /var/bind /va r/qmail/control" CONFIG_PROTECT_MASK="/etc/gconf /etc/terminfo /etc/env.d" CXXFLAGS="-O3 -march=pentium4 -pipe" DISTDIR="/usr/portage/distfiles" FEATURES="autoconfig distlocks sandbox sfperms strict" GENTOO_MIRRORS="ftp://pandemonium.tiscali.de/pub/gentoo/ http://pandemonium.tiscali.de/pub/gentoo/ http://gentoo.e liteitminds.com" LANG="it_IT@euro" LC_ALL="it_IT@euro" LINGUAS="it" MAKEOPTS="-j2" 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 X aalib alsa apache2 apm arts avi bash-completion berkdb bitmap-fonts bonobo cdr crypt cups curl dga dire ctfb doc dvd eds emacs emboss encode fam fbcon flac foomaticdb fortran gd gdbm gif gnome gpm gtk gtk2 gtkhtml guil e imagemagick imap imlib ipv6 jack java jpeg junit kde ldap libg++ libwww mad maildir mbox mikmod mmx motif mp3 mp eg mysql nas ncurses nls nptl nptonly odbc ogg oggvorbis opengl oss pam pcmcia pdflib perl png python qt quicktime readline samba sasl sdl slang speex spell sse sse2 ssl svga tcltk tcpd tetex tiff truetype truetype-fonts type1-f onts vorbis xine xml xml2 xmms xv zlib video_cards_i915 linguas_it userland_GNU kernel_linux elibc_glibc" Unset: ASFLAGS, CTARGET, LDFLAGS
Created attachment 59576 [details] Strace for mysqld
thanks for your report, tentative troubleshooting follow part a, installed mysql troubleshoting first of all check your /var/log/mysql files, quite always there is valuable information there. If the error is still not clear you can try to put --skip-innodb --skip-ndbcluster in your "/etc/mysql/my.cnf" [mysqld] section part b, mysql emerge debugging Portage leave the sources of a broken emerge in place. Maybe interesting to have a look at tests log files in: /var/tmp/portage/mysql-4.1.12/work/mysql/mysql-test/var/log hint: Also run the failed test alone #cd /var/tmp/portage/mysql-4.1.12/work/mysql/mysql-test #./mysql-test-run rpl000010 maybe usefull
You're right, I checked the mysql error log: InnoDB: Error: log file ./ib_logfile0 is of different size 0 8388608 bytes InnoDB: than specified in the .cnf file 0 5242880 bytes! 050522 21:09:48 [ERROR] Can't init databases 050522 21:09:48 [ERROR] Aborting 050522 21:09:48 [Note] mysqld: Shutdown complete Deleting /var/lib/mysql/ib_logfile* fixed this bug. I'll close it as "invalid", but can you explain why did this happen in the first place? It has to be due to the "innodb_log_file_size = 5M" setting, and I guess it has to have changed its behaviour from 4.1.8 to 4.1.12 (at least, default my.cnf has changed). Maybe a small note in the ebuild? Anyway, thanks for the quick feedback.
Thanks will consider to (ask to robbat2 to) drop a note but don't expect it since 4.1.8 were marked "hidden" for users. A further note: If the data is valuable trust only a compiled mysql that pass *all* the tests. Try to recompile without other things running if possible (test are sometimes memory hungry and *will* fail with another ndbcluster running) . rpl test you mentioned regards specifically replication server. But should be ok in a sane environment.
