Please stabilise mysql-5. It is considered the current and recommended release for production use by upstream.
I do agree, as a secondary MySQL maintainer, the Upgrade documentation [1] should be revieved and maybe the "Straight upgrade, not supported, dangerous" path should be preferred. There are also some changes to the SQL parser that, in MySQL 5.0, return an error if the FROM ... JOIN section of a query is not properly nested with parenthesis "()", all the software we distribuite is now aware of that but should be noted in the docs for people that has theyr own code. I had promised to chtekk to do all the above, and not maintained the promise due to lack of time. In substance what still need to be tested is a flawless upgrade from 4.1 to 5.0. [1] http://www.gentoo.org/doc/en/mysql-upgrading.xml Regards
In testing 5.0 on the new gentoo bugzilla machines, there are a few minor blips that I ran into, and I produced this slightly modified mysql init.d script. http://dev.gentoo.org/~robbat2/init.d-mysql-parallel-services The mysqlmanager script probably needs similar modifications. All of them revolve around cases with multiple mysql instances. vivo: could you review that init.d script and see what you think of the changes?
(In reply to comment #2) > In testing 5.0 on the new gentoo bugzilla machines, there are a few minor blips > that I ran into, and I produced this slightly modified mysql init.d script. > http://dev.gentoo.org/~robbat2/init.d-mysql-parallel-services > The mysqlmanager script probably needs similar modifications. > All of them revolve around cases with multiple mysql instances. > vivo: could you review that init.d script and see what you think of the > changes? It's all ok for me, only a note: the "pidfile" option has been removed from the start-stop-daemon run because I was worried of some kind of race conditions, if it's ok with our stable baselayout then it's ok that too. Lately I've not used very much multiple mysql instances on a single box so I trust you ;-)
in x86 1) emerges fine 2) passes collission tests 3) works Portage 2.1-r2 (default-linux/x86/2005.1, gcc-3.4.6, glibc-2.3.6-r4, 2.6.17-gentoo-r4 i686) ================================================================= System uname: 2.6.17-gentoo-r4 i686 Intel(R) Celeron(R) M processor 1.50GHz Gentoo Base System version 1.12.4 app-admin/eselect-compiler: [Not Present] dev-lang/python: 2.4.3-r1 dev-python/pycrypto: 2.0.1-r5 dev-util/ccache: [Not Present] dev-util/confcache: [Not Present] 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-r2 sys-devel/binutils: 2.16.1-r3 sys-devel/gcc-config: 1.3.13-r3 sys-devel/libtool: 1.5.22 virtual/os-headers: 2.6.11-r2 ACCEPT_KEYWORDS="x86" AUTOCLEAN="yes" CBUILD="i686-pc-linux-gnu" CFLAGS="-Os -mcpu=i686 -pipe" CHOST="i686-pc-linux-gnu" CONFIG_PROTECT="/etc /usr/kde/3.4/env /usr/kde/3.4/share/config /usr/kde/3.4/shutdown /usr/kde/3.5/env /usr/kde/3.5/share/config /usr/kde/3.5/shutdown /usr/lib/mozilla/defaults/pref /usr/share/X11/xkb /usr/share/config /usr/share/texmf/dvipdfm/config/ /usr/share/texmf/dvips/config/ /usr/share/texmf/tex/generic/config/ /usr/share/texmf/tex/platex/config/ /usr/share/texmf/xdvi/ /var/bind" CONFIG_PROTECT_MASK="/etc/env.d /etc/gconf /etc/splash /etc/terminfo" CXXFLAGS="-Os -mcpu=i686 -pipe" DISTDIR="/usr/portage/distfiles" FEATURES="autoconfig ccache collision-protect distlocks metadata-transfer parallel-fetch sandbox sfperms strict test" GENTOO_MIRRORS="http://mirror.datapipe.net/gentoo ftp://ftp.gtlib.cc.gatech.edu/pub/gentoo http://mirror.datapipe.net/gentoo http://open-systems.ufl.edu/mirrors/gentoo" LINGUAS="es" PKGDIR="/usr/portage/packages" PORTAGE_RSYNC_OPTS="--recursive --links --safe-links --perms --times --compress --force --whole-file --delete --delete-after --stats --timeout=180 --exclude='/distfiles' --exclude='/local' --exclude='/packages'" PORTAGE_TMPDIR="/var/tmp" PORTDIR="/usr/portage" PORTDIR_OVERLAY="/usr/local/portage" SYNC="rsync://rsync.gentoo.org/gentoo-portage" USE="x86 X alsa apm arts avi berkdb bitmap-fonts cli crypt cups dlloader dri eds emboss encode foomaticdb fortran gdbm gif gnome gpm gstreamer gtk gtk2 imlib ipv6 isdnlog jpeg kde libg++ libwww mad mikmod motif mp3 mpeg ncurses nls ogg oggvorbis opengl oss pam pcre pdflib perl png pppd python qt3 qt4 quicktime readline reflection sdl session spell spl ssl tcpd truetype truetype-fonts type1-fonts vorbis xml xml2 xmms xorg xv zlib elibc_glibc input_devices_mouse input_devices_keyboard input_devices_synaptics kernel_linux linguas_es userland_GNU video_cards_i915 video_cards_i810 video_cards_i830 video_cards_vesa video_cards_fbdev" Unset: CTARGET, EMERGE_DEFAULT_OPTS, INSTALL_MASK, LANG, LC_ALL, LDFLAGS, MAKEOPTS, PORTAGE_RSYNC_EXTRA_OPTS
1.) compiles fine on x86 with USE="berkdb perl ssl" 2.) passes make check,test 3.) passes collision-test 4.) ebuild $EBUILD_PATH config 5.) can start/stop mysql daemmon (via run-script) 6.) can enter the mysql command (with the password from step 4) and enter SQL queries emerge --info Portage 2.1-r2 (default-linux/x86/2006.0, gcc-3.4.6, glibc-2.3.6-r4, 2.6.17.6 i686) ================================================================= System uname: 2.6.17.6 i686 AMD Athlon(TM) XP1800+ Gentoo Base System version 1.12.4 ccache version 2.3 [enabled] app-admin/eselect-compiler: [Not Present] dev-lang/python: 2.3.5-r2, 2.4.3-r1 dev-python/pycrypto: 2.0.1-r5 dev-util/ccache: 2.3 dev-util/confcache: [Not Present] 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-r2 sys-devel/binutils: 2.16.1-r3 sys-devel/gcc-config: 1.3.13-r3 sys-devel/libtool: 1.5.22 virtual/os-headers: 2.6.11-r2 ACCEPT_KEYWORDS="x86" AUTOCLEAN="yes" CBUILD="i686-pc-linux-gnu" CFLAGS="-O2 -march=i686 -fomit-frame-pointer -pipe" CHOST="i686-pc-linux-gnu" CONFIG_PROTECT="/etc /usr/kde/3.5/env /usr/kde/3.5/share/config /usr/kde/3.5/shutdown /usr/share/X11/xkb /usr/share/config" CONFIG_PROTECT_MASK="/etc/env.d /etc/gconf /etc/revdep-rebuild /etc/terminfo /etc/texmf/web2c" CXXFLAGS="-O2 -march=i686 -fomit-frame-pointer -pipe" DISTDIR="/usr/portage/distfiles" FEATURES="autoconfig ccache collision-protect distlocks fixpackages metadata-transfer parallel-fetch sandbox sfperms strict test userpriv usersandbox" GENTOO_MIRRORS="http://mirror.switch.ch/mirror/gentoo/ http://gentoo.inode.at/" LANG="en_GB.utf8" LINGUAS="en de en_GB" PKGDIR="/usr/portage/packages" PORTAGE_RSYNC_OPTS="--recursive --links --safe-links --perms --times --compress --force --whole-file --delete --delete-after --stats --timeout=180 --exclude='/distfiles' --exclude='/local' --exclude='/packages'" PORTAGE_TMPDIR="/var/tmp" PORTDIR="/usr/portage" PORTDIR_OVERLAY="/usr/local/portage/normal /usr/local/portage/testing" SYNC="rsync://192.168.2.1/gentoo-portage" USE="x86 3dnow 3dnowext X a52 aac acpi alsa apache2 apm avi bash-completion berkdb bitmap-fonts bzip2 cdr cli crypt css cups dbus divx4linux dlloader dri dts dvd dvdr dvdread emboss exif ffmpeg firefox font-server foomaticdb fortran gdbm gif gnome gphoto2 gpm gstreamer gtk gtk2 gtkhtml hal imlib ipv6 isdnlog java jpeg kde kdeenablefinal libclamav libg++ libwww logitech-mouse mad mikmod mmx mmxext mono mozcalendar mozdevelop mozsvg mp3 mpeg ncurses network nls nptl nvidia oav ogg opengl oss pam pcre pdflib perl png pppd python qt qt3 qt4 quicktime readline reflection samba sdl seamonkey session spell spl ssl tcltk tcpd test tetex tiff truetype truetype-fonts type1-fonts udev unicode usb vcd vorbis win32codecs xine xinerama xml xorg xorg-x11 xprint xv xvg xvid zlib elibc_glibc input_devices_mouse input_devices_keyboard kernel_linux linguas_en linguas_de linguas_en_GB userland_GNU video_cards_nv video_cards_none" Unset: CTARGET, EMERGE_DEFAULT_OPTS, INSTALL_MASK, LC_ALL, LDFLAGS, MAKEOPTS, PORTAGE_RSYNC_EXTRA_OPTS
(In reply to comment #2) in CVS at 2006-08-28T12:30 UTC
I think that this can become the suggested procedure to upgrade MySQL databases from 4.1 to 5.0 (and in the future to 5.1) If no-one object to this I'll push this to the documentation team. PLEASE: DO NOT MARK STABLE UNTIL THIS IS IN PLACE AND ANNOUNCED --- 8< --- 8< --- 8< --- 8< --- 8< --- 8< --- 8< --- 8< --- 8< --- 8< --- Code Listing X.Y: Straight upgrade # quickpkg dev-db/mysql # mysql --database=mysql --user=root --password='your_password' \ --execute="FLUSH TABLES WITH READ LOCK;" # DATADIR=$(mysql --user=root --password='your_password' \ --batch --raw --silent --skip-column-names \ --execute='SHOW variables LIKE "datadir";' \ | sed -e 's|datadir[ \t]||') # tar -cjpvf ~/mysql.$(date +%F"T"%H-%M).tar.bz2 \ /etc/mysql/conf.d/mysql /etc/mysql/my.cnf "${DATADIR}" # mysql --database=mysql --user=root --password='your_password' \ --execute="UNLOCK TABLES;" # tar -tjvf ~/mysql.*.tar.bz2 # emerge -av ">mysql-5.0" # dispatch-conf # revdep-rebuild # /etc/init.d/mysql restart # mysql_upgrade_shell --user=root --password='your_password' \ --protocol=tcp --datadir="${DATADIR}" # /etc/init.d/mysql restart In case the box has multiple instances of mysql repeat the backup, and the mysql_upgrade_shell for each one changing appropriately the DATADIR (add --socket or --port option to each mysql command is needed) --- 8< --- 8< --- 8< --- 8< --- 8< --- 8< --- 8< --- 8< --- 8< --- 8< ---
hem sorry for the mostly duplicated post, a preview of the doc may be seen here: http://dev.gentoo.org/~vivo/doc/mysql-upgrading.xml
I have upgraded from 4.1.21 to 5.0.24 only my AMD 64 system and it works very good. BTW: I first removed the old version and thereafter installed the new. Gentoo Base System version 1.6.15 Portage 2.1-r2 (default-linux/amd64/2006.0, gcc-3.4.6, glibc-2.3.6-r4, 2.6.17-gentoo-r4 x86_64) ================================================================= System uname: 2.6.17-gentoo-r4 x86_64 Intel(R) Pentium(R) D CPU 2.80GHz ccache version 2.3 [enabled] app-admin/eselect-compiler: [Not Present] dev-lang/python: 2.4.3-r1 dev-python/pycrypto: 2.0.1-r5 dev-util/ccache: 2.3 dev-util/confcache: [Not Present] 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-r2 sys-devel/binutils: 2.16.1-r3 sys-devel/gcc-config: 1.3.13-r3 sys-devel/libtool: 1.5.22 virtual/os-headers: 2.6.11-r2 ACCEPT_KEYWORDS="amd64" AUTOCLEAN="yes" CBUILD="x86_64-pc-linux-gnu" CFLAGS="-march=nocona -O2 -pipe" CHOST="x86_64-pc-linux-gnu" CONFIG_PROTECT="/etc /usr/share/X11/xkb /usr/share/texmf/dvipdfm/config/ /usr/share/texmf/dvips/config/ /usr/share/texmf/t ex/generic/config/ /usr/share/texmf/tex/platex/config/ /usr/share/texmf/xdvi/" CONFIG_PROTECT_MASK="/etc/env.d /etc/gconf /etc/revdep-rebuild /etc/terminfo" CXXFLAGS="-march=nocona -O2 -pipe" DISTDIR="/usr/portage/distfiles" FEATURES="autoconfig ccache distlocks fixpackages metadata-transfer parallel-fetch sandbox sfperms strict" GENTOO_MIRRORS="http://mirror.uni-c.dk/pub/gentoo/ ftp://ftp.tu-clausthal.de/pub/linux/gentoo/ ftp://sunsite.informatik.rw th-aachen.de/pub/Linux/gentoo ftp://ftp.du.se/pub/os/gentoo" LC_ALL="da_DK.utf8" MAKEOPTS="-j3" PKGDIR="/usr/portage/packages" PORTAGE_RSYNC_OPTS="--recursive --links --safe-links --perms --times --compress --force --whole-file --delete --delete-aft er --stats --timeout=180 --exclude='/distfiles' --exclude='/local' --exclude='/packages'" PORTAGE_TMPDIR="/var/tmp" PORTDIR="/usr/portage" SYNC="rsync://rsync.europe.gentoo.org/gentoo-portage" USE="amd64 X alsa avi berkdb bitmap-fonts bzip2 cdr cli crypt cups dlloader dri dvd eds emacs emboss encode foomaticdb for tran gif gpm gstreamer gtk gtk2 imlib ipv6 isdnlog jpeg lzw lzw-tiff mp3 mpeg ncurses nls nptl opengl pam pcre pdflib perl png pppd python qt3 qt4 quicktime readline reflection sdl session spell spl ssl tcpd tetex tiff truetype truetype-fonts t ype1-fonts unicode usb xorg xpm xv zlib elibc_glibc input_devices_mouse input_devices_keyboard kernel_linux userland_GNU v ideo_cards_vga video_cards_nvidia video_cards_nv video_cards_vesa video_cards_fbdev" Unset: CTARGET, EMERGE_DEFAULT_OPTS, INSTALL_MASK, LANG, LDFLAGS, LINGUAS, PORTAGE_RSYNC_EXTRA_OPTS, PORTDIR_OVERLAY
dev-db/mysql-5.0.24-r1 was just added to the tree (MySQL 5.0.24a), which fixes some ABI breakage introduced in 5.0.24. So, if we want to stable something, it will have to be 5.0.24-r1 _currently_. But please let's wait for 5.0.25 to be released and hit the tree, as that will fix a couple of security bugs, we can then stable 5.0.25. :) Best regards, CHTEKK.
Adding another older bug that suggests additional steps are needed during the process to revert to an old version. Go ahead and remove the block if it's not necessary, but the reporter seems to think the upgrade guide needs it.
Ok, since 5.0.25 is not in (or even out :) ) yet, I'm unCCing x86.
dev-db/mysql-5.0.24-r1 is stable on AMD64. I don't see any reason to wait for 5.0.25.
Maybe I have been too fast as the default emerge of mysql 5 yields this: mysql> SHOW ENGINES; +------------+----------+----------------------------------------------------------------+ | Engine | Support | Comment | +------------+----------+----------------------------------------------------------------+ | MyISAM | DEFAULT | Default engine as of MySQL 3.23 with great performance | | MEMORY | YES | Hash based, stored in memory, useful for temporary tables | | InnoDB | DISABLED | Supports transactions, row-level locking, and foreign keys | | BerkeleyDB | NO | Supports transactions and page-level locking | | BLACKHOLE | NO | /dev/null storage engine (anything you write to it disappears) | | EXAMPLE | NO | Example storage engine | | ARCHIVE | NO | Archive storage engine | | CSV | NO | CSV storage engine | | ndbcluster | NO | Clustered, fault-tolerant, memory-based tables | | FEDERATED | NO | Federated MySQL storage engine | | MRG_MYISAM | YES | Collection of identical MyISAM tables | | ISAM | NO | Obsolete storage engine | +------------+----------+----------------------------------------------------------------+ 12 rows in set (0.00 sec) mysql> quit Notice that InnoDB is not supported that is really, really bad (and yes I have configured my my.cnf correctly).
Created attachment 98609 [details] my.cnf (In reply to comment #14) > Maybe I have been too fast as the default emerge of mysql 5 yields this: > > > mysql> SHOW ENGINES; > +------------+----------+----------------------------------------------------------------+ > | Engine | Support | Comment > | ... > | InnoDB | DISABLED | Supports transactions, row-level locking, and foreign > keys | ... > > Notice that InnoDB is not supported that is really, really bad (and yes I have > configured my my.cnf correctly). > Unless it's explicitly disabled at configure time innodb is build by default: # mysql-5.0.24a 0 $ ./configure --help ... --without-innodb Do not include the InnoDB table handler ... In 5.0 it can only be disabled if mysql is build with the "minimal" use flag emerge -pv mysql These are the packages that would be merged, in order: Calculating dependencies... done! [ebuild R ] dev-db/mysql-5.0.24-r1 USE="berkdb cluster extraengine max-idx-128 perl ssl -big-tables -debug -embedded -latin1 -minimal (-selinux) -srvdir -static" 0 kB mysql> SHOW ENGINES; +------------+----------+----------------------------------------------------------------+ | Engine | Support | Comment ... | InnoDB | YES | Supports transactions, row-level locking, and foreign keys | ... please try to move temporary the my.cnf file away or use the one attached
Yes, sorry about that. In my arrogance I forgot that I had logged on to one of my selfcompiled instances of mysql. The one emerged works out of the box with innodb. Sorry.
Back on this I've run a test on almost all of the stable clients in the tree, on a stable x86 box. Results below. Archs please start to think to stabilize this one, it's still not the time, mysql-5.0.26-r1 is in the tree since 2006-10-21 21:06:53 but we hope to stabilize it around saturday 2005-11-08 if you agree. This ones has no problems: [R] app-admin/modlogan [0.8.13] "mysql nls" [R] app-admin/osiris [1.5.2] "mysql" [R] app-admin/prelude-manager [0.9.1-r1] "debug" [R] app-admin/rackview [0.09] [R] app-admin/ulogd [1.23] "mysql" [R] app-cdr/cdw [0.2.4] "mysql nls" [R] app-misc/lcd4linux [0.9.11] [R] app-misc/note [1.2.5-r1] "crypt mysql" [R] app-mobilephone/gammu [1.07.00] "debug mysql" [R] app-mobilephone/gnokii [0.6.12] "mysql nls" [R] app-mobilephone/kannel [1.4.0-r2] "debug mysql pam pcre ssl" [R] dev-db/gmyclient [0.3] "nls" [R] dev-db/hk_classes [0.7.4a] "mysql" [R] dev-db/libdbi-drivers [0.7.1-r1] "mysql" [R] dev-db/myodbc [3.51.12] "debug" [R] dev-db/mysql++ [1.7.26] [R] dev-db/mysql-super-smack [1.2] "mysql" [R] dev-db/mysqlnavigator [1.4.2] [R] dev-db/rekall [2.2.6] "debug mysql" [R] dev-lang/php [5.1.6-r4] "apache2 berkdb cgi cli crypt debug gdbm ipv6 mysql ncurses nls pcre readline reflection session spl ssl unicode zlib" [R] dev-lang/pike [7.6.86-r1] "debug gdbm mysql pcre ssl zlib" [R] dev-libs/cyrus-sasl [2.1.22] "berkdb crypt gdbm mysql pam ssl" [R] dev-libs/dvmysql [0.4.11-r1] "" [R] dev-libs/libpreludedb [0.9.2] "mysql perl python" [R] dev-libs/redland [1.0.4] "berkdb mysql ssl" [R] dev-lisp/cl-sql [3.2.1] "mysql" [R] dev-ml/ocaml-mysql [1.0.3-r1] [R] dev-perl/DBD-mysql [2.9007] [R] dev-php5/pecl-pdo-mysql [1.0.1] [R] dev-python/mysql-python [1.2.0-r1] [R] dev-ruby/mysql-ruby [2.7] [R] dev-tcltk/mysqltcl [2.40] [R] dev-util/gambas [1.0.14] "mysql zlib" [R] gnome-extra/libgda [1.2.3] "berkdb debug mysql" [R] mail-filter/anubis [3.9.95] "crypt mysql nls pam pcre ssl tcpd" [R] mail-filter/bmf [0.9.4] "berkdb mysql" [R] mail-filter/gld [1.6] [R] media-gfx/showimg [0.9.5] "debug mysql" [R] media-sound/amarok [1.4.3-r1] "debug mysql" [R] media-sound/mp3blaster [3.2.0] "mysql" [R] media-sound/prokyon3 [0.9.4-r1] [R] media-tv/mythtv [0.19_p10505] "debug" [R] net-analyzer/aimsniff [0.9-r1] "apache2 mysql" [R] net-analyzer/barnyard [0.2.0-r1] "mysql" [R] net-analyzer/cacti [0.8.6h_p20060108-r2] "apache2" [R] net-analyzer/flow-tools [0.68-r3] "debug mysql ssl" [R] net-analyzer/nagios-core [1.4.1] "apache2 debug mysql perl" [R] net-analyzer/nagios-plugins [1.4.2] "ipv6 mysql ssl" [R] net-analyzer/pmacct [0.9.5] "debug ipv6 mysql" [R] net-analyzer/rtg [0.7.4-r2] [R] net-analyzer/snort [2.4.5] "mysql ssl" [R] net-dns/mydns [1.1.0] "debug mysql nls ssl zlib" [R] net-fs/samba [3.0.22-r3] "cups mysql pam python readline" [R] net-ftp/proftpd [1.3.0-r2] "ipv6 mysql ncurses pam ssl tcpd" [R] net-ftp/pure-ftpd [1.0.20-r1] "mysql pam ssl" [R] net-im/jabberd [1.4.4-r3] "debug ipv6 mysql ssl" [R] net-irc/eggdrop [1.6.17-r2] "debug mysql ssl" [R] net-irc/oer-mysql [1.0.43] "debug" [R] net-libs/courier-authlib [0.58] "berkdb crypt debug gdbm mysql pam" [R] net-libs/cvm [0.76] "mysql" [R] net-libs/libwww [5.4.0-r7] "mysql ssl" [R] net-mail/courier-imap [4.0.4] "berkdb debug gdbm ipv6 nls" [R] net-mail/dovecot [1.0_rc7] "debug ipv6 mysql pam ssl" [R] net-mail/teapop [0.3.8] "ipv6 mysql tcpd" [R] net-mail/tpop3d [1.5.3] "debug mysql pam perl ssl tcpd" [R] net-misc/asterisk [1.2.13] "debug mysql ssl" [R] net-misc/ser [0.9.4] "ipv6 mysql ssl" [R] net-p2p/gnunet [0.7.0d-r1] "ipv6 mysql ncurses nls" [R] net-proxy/oops [1.5.24_pre20050503-r1] "mysql" [R] net-www/mod_auth_mysql [3.0.0] "apache2" [R] net-www/mod_log_sql [1.100] "apache2 ssl" [R] net-www/mod_vdbh [1.0.3-r1] [R] sci-geosciences/grass [6.0.1] "mysql nls readline" [R] sci-libs/gdal [1.3.1] "debug python" [R] sys-auth/libnss-mysql [1.2] [R] sys-auth/pam_mysql [0.7_rc1-r1] [R] www-servers/gorg [0.5] [R] www-servers/lighttpd [1.4.11] "bzip2 fam fastcgi gdbm ipv6 mysql pcre ssl" [R] x11-libs/qt [4.1.4] "cups debug mysql opengl zlib" [R] x11-libs/qt [3.3.6-r3] "cups debug ipv6 mysql opengl" - media-sound/digitaldj* had problem with gcc 4.1 fixed and working now [irc resolved] - sci-physics/root does not build at all with gcc-4.1 see [bug #148782] has a "working" solution - net-dns/mydns-1.1.0 has problem with gcc-4.1 had problem with gcc 4.1 fix proposed on [bug #152406] - app-admin/rackview had problems dot fixed stabling some perl packages [irc resolved] - dev-db/gmyclient had problem with gcc 4.1 [irc resolved] - net-mail/dovecot had problem with gcc 4.1 used =net-mail/dovecot-1.0_rc7 ~x86, compile fine - dev-ml/ocaml-mysql dev-lang/ocaml-3.08.3 dont build with gcc-4.1 used dev-lang/ocaml-3.09.3 ~x86 - dev-libs/redland-1.0.0 has probelm with gcc-4.1, used =dev-libs/redland-1.0.4 ~x86 Packages left out from compile test (need hardware/well know to work): www-apps/b2evolution www-apps/bugzilla www-apps/egroupware www-apps/gallery www-apps/mediawiki www-apps/phprojekt www-apps/phpwebsite www-apps/trac www-apps/viewcvs www-apps/wordpress x11-libs/qt-embedded x11-plugins/wmjsql kde-misc/krecipes games-server/hlstats games-server/pvpgn app-office/kexi dev-db/phpmyadmin net-dialup/linesrv net-dialup/xlc net-dns/pdns # use boost, it work for sure I use it with 5.1 ;) net-www/mod_mp3 # need apache 1
config used for the previous comment some packages have been compiled with FEATURES="-stricter -test" (mostly dependancies) cat /etc/portage/package.keywords # Last stable dev-lang/ocaml-3.08.3 fail on Modular xorg # using 3.09.3 solve the issue =dev-lang/ocaml-3.09.3 ~x86 # gcc4 =net-mail/dovecot-1.0_rc7 ~x86 # gcc4 #http://bugs.gentoo.org/show_bug.cgi?id=151935 =dev-libs/redland-1.0.4 ~x86 cat /etc/portage/package.use app-editors/vim -* dev-db/mysql berkdb perl ssl big-tables cluster debug embedded extraengine -max-idx-128 -minimal -srvdir -static dev-lang/php cgi sys-kernel/gentoo-sources symlink www-servers/lighttpd bzip2 fam fastcgi # x11-libs/gtk+-2.8.19 need cairo with X use flag, media-sound/digitaldj use it x11-libs/cairo X # nagios want it media-libs/gd jpeg -png -truetype -fontconfig -xpm # media-tv/mythtv require this: x11-libs/qt mysql opengl Portage 2.1.1 (default-linux/x86/2006.1, gcc-4.1.1, glibc-2.4-r3, 2.6.17 i686) ================================================================= System uname: 2.6.17 i686 AMD Athlon(tm) Gentoo Base System version 1.12.5 Last Sync: Unknown distcc 2.18.3 i686-pc-linux-gnu (protocols 1 and 2) (default port 3632) [enabled] app-admin/eselect-compiler: [Not Present] dev-java/java-config: [Not Present] dev-lang/python: 2.4.3-r4 dev-python/pycrypto: 2.0.1-r5 dev-util/ccache: [Not Present] dev-util/confcache: [Not Present] 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-r2 sys-devel/binutils: 2.16.1-r3 sys-devel/gcc-config: 1.3.13-r4 sys-devel/libtool: 1.5.22 virtual/os-headers: 2.6.17-r1 ACCEPT_KEYWORDS="x86" AUTOCLEAN="yes" CBUILD="i686-pc-linux-gnu" CFLAGS="-O2 -march=i686 -pipe -g2 -ggdb" CHOST="i686-pc-linux-gnu" CONFIG_PROTECT="/etc /usr/grass60/etc /usr/kde/3.5/env /usr/kde/3.5/share/config /usr/kde/3.5/shutdown /usr/share/config" CONFIG_PROTECT_MASK="/etc/env.d /etc/gconf /etc/revdep-rebuild /etc/terminfo" CXXFLAGS="-O2 -march=i686 -pipe -g2 -ggdb" DISTDIR="/usr/portage/distfiles" FEATURES="autoconfig cvs distcc distlocks keepwork noclean sandbox sfperms sign splitdebug strict stricter test userpriv usersandbox" GENTOO_MIRRORS="http://db.pnpitalia.it/ http://www.die.unipd.it/pub/Linux/distributions/gentoo-sources/ http://linux.rz.ruhr-uni-bochum.de/download/gentoo-m irror/" LINGUAS="" MAKEOPTS="-j8" PKGDIR="/usr/portage/packages" PORTAGE_RSYNC_OPTS="--recursive --links --safe-links --perms --times --compress --force --whole-file --delete --delete-after --stats --timeout=180 --exclude='/distfiles' --exclude='/local' --exclude='/packages'" PORTAGE_TMPDIR="/var/tmp" PORTDIR="/usr/portage" SYNC="rsync://rsync.gentoo.org/gentoo-portage" USE="x86 apache2 berkdb bitmap-fonts cli cracklib crypt cups debug dlloader dri elibc_glibc fortran gdbm gpm input_devices_evdev input_devices_keyboard input_devices_mouse ipv6 isdnlog kernel_linux libg++ mysql ncurses nls nptl nptlonly pam pcre perl ppds pppd python readline reflection session spl ssl tcpd truetype-fonts type1-fonts udev unicode userland_GNU video_cards_none xorg zlib" Unset: CTARGET, EMERGE_DEFAULT_OPTS, INSTALL_MASK, LANG, LC_ALL, LDFLAGS, PORTAGE_RSYNC_EXTRA_OPTS, PORTDIR_OVERLAY
Archs, I think you could start reading from c#17
I am using mysql-5.0.26-r1 on my PPC64 machine and haven't had any problems so far (mostly as amarok backend, but tested some other apps, too). So PPC64 is fine with stabilization on November 8.
on ppc, mysql test suite is failing here: ============================================= trigger-compat [ pass ] trigger-grant [ pass ] trigger-trans [ pass ] trigger [ fail ] Errors are (from /var/tmp/portage/dev-db/mysql-5.0.26-r1/work/mysql/mysql-test/var/log/mysqltest-time) : mysqltest: At line 1144: query 'rename table t1 to t2' succeeded - should have failed with errno 1... (the last lines may be the most important ones) =========================================== Let me know if that's a flawed test case or if I should file a separate bug.
trigger test fail regularly with gcc 4.1, we are working on it also USE=extraengine (federated) no matter which compiler, this last one will _not_ supported by the mysql-herd I'm right CHTEKK ?
(In reply to comment #21) > on ppc, mysql test suite is failing here: > trigger [ fail ] > > Let me know if that's a flawed test case or if I should file a separate bug. > Changelog: 25 Oct 2006; Francesco Riosa <vivo@gentoo.org> mysql-5.0.26-r1.ebuild: Fix "trigger" test Upstream references: http://bugs.mysql.com/bug.php?id=21883 Test "trigger" must fail in a RPM build on SuSE (x86, x86_64) http://bugs.mysql.com/bug.php?id=23125 [patch] trigger test fails when run as root http://bugs.mysql.com/file.php?id=4583 [patch] the problem was that src_test() is ran as user root, after some consideration I do prefere to patch the test instead of try to change user for that phase (su someuser -c mysqltest).
All tests pass now, I'll start looking at functionality testing.
1. emerges on x86 2. passes collision test 3. passes test suite 4. works here dev-db/mysql-5.0.26-r1 USE="berkdb perl ssl -big-tables -cluster -debug -embedded -extraengine -latin1 -max-idx-128 -minimal (-selinux) -srvdir -static" Portage 2.1.1 (default-linux/x86/2006.1/desktop, gcc-4.1.1, glibc-2.4-r3, 2.6.17.13 i686) ================================================================= System uname: 2.6.17.13 i686 AMD Athlon(TM) XP1800+ Gentoo Base System version 1.12.5 Last Sync: Wed, 25 Oct 2006 16:50:01 +0000 ccache version 2.3 [enabled] app-admin/eselect-compiler: [Not Present] dev-java/java-config: 1.3.7, 2.0.30 dev-lang/python: 2.3.5-r3, 2.4.3-r4 dev-python/pycrypto: 2.0.1-r5 dev-util/ccache: 2.3 dev-util/confcache: [Not Present] 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-r2 sys-devel/binutils: 2.16.1-r3 sys-devel/gcc-config: 1.3.13-r4 sys-devel/libtool: 1.5.22 virtual/os-headers: 2.6.17-r1 ACCEPT_KEYWORDS="x86" AUTOCLEAN="yes" CBUILD="i686-pc-linux-gnu" CFLAGS="-O2 -march=i686 -fomit-frame-pointer -pipe" CHOST="i686-pc-linux-gnu" CONFIG_PROTECT="/etc /usr/kde/3.5/env /usr/kde/3.5/share/config /usr/kde/3.5/shutdown /usr/share/X11/xkb /usr/share/config /usr/share/texmf/dvipdfm/config/ /usr/share/texmf/dvips/config/ /usr/share/texmf/tex/generic/config/ /usr/share/texmf/tex/platex/config/ /usr/share/texmf/xdvi/" CONFIG_PROTECT_MASK="/etc/env.d /etc/env.d/java/ /etc/gconf /etc/java-config/vms/ /etc/revdep-rebuild /etc/terminfo" CXXFLAGS="-O2 -march=i686 -fomit-frame-pointer -pipe" DISTDIR="/usr/portage/distfiles" EMERGE_DEFAULT_OPTS="--nospinner" FEATURES="autoconfig ccache collision-protect distlocks fixpackages metadata-transfer parallel-fetch sandbox sfperms strict test userfetch userpriv usersandbox" GENTOO_MIRRORS="http://mirror.switch.ch/mirror/gentoo/ http://gentoo.inode.at/" LANG="en_GB.utf8" LINGUAS="en de en_GB" PKGDIR="/usr/portage/packages" PORTAGE_RSYNC_OPTS="--recursive --links --safe-links --perms --times --compress --force --whole-file --delete --delete-after --stats --timeout=180 --exclude='/distfiles' --exclude='/local' --exclude='/packages'" PORTAGE_TMPDIR="/var/tmp" PORTDIR="/usr/portage" PORTDIR_OVERLAY="/usr/local/portage/normal" SYNC="rsync://192.168.2.1/gentoo-portage" USE="x86 3dnow 3dnowext X a52 aac acpi alsa apache2 bash-completion berkdb bitmap-fonts bzip2 cairo cdr cli cracklib crypt css cups dbus divx4linux dlloader dri dts dvd dvdr dvdread elibc_glibc emboss exif fam ffmpeg firefox font-server fortran gdbm gif gnome gphoto2 gpm gstreamer gtk gtk2 gtkhtml hal input_devices_keyboard input_devices_mouse ipv6 isdnlog java jpeg kde kernel_linux ldap libclamav libg++ linguas_de linguas_en linguas_en_GB logitech-mouse mad mikmod mmx mmxext mono mozcalendar mozdevelop mozsvg mp3 mpeg ncurses network nls nptl nptlonly nvidia oav ogg opengl oss pam pcre perl png ppds pppd python qt qt3 qt4 quicktime readline reflection samba sdl seamonkey session spell spl ssl tcltk tcpd test tetex tiff truetype truetype-fonts type1-fonts udev unicode usb userland_GNU vcd video_cards_none video_cards_nv vorbis win32codecs xine xinerama xml xorg xorg-x11 xprint xv xvg xvid zlib" Unset: CTARGET, INSTALL_MASK, LC_ALL, LDFLAGS, MAKEOPTS, PORTAGE_RSYNC_EXTRA_OPTS and Portage 2.1.1 (default-linux/x86/2006.1/desktop, gcc-4.1.1, glibc-2.4-r3, 2.6.18.1 i686) ================================================================= System uname: 2.6.18.1 i686 Genuine Intel(R) CPU T2300 @ 1.66GHz Gentoo Base System version 1.12.5 Last Sync: Wed, 25 Oct 2006 16:50:01 +0000 ccache version 2.3 [disabled] app-admin/eselect-compiler: [Not Present] dev-java/java-config: 1.3.7, 2.0.30 dev-lang/python: 2.3.5-r3, 2.4.3-r4 dev-python/pycrypto: 2.0.1-r5 dev-util/ccache: 2.3 dev-util/confcache: [Not Present] 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-r2 sys-devel/binutils: 2.16.1-r3 sys-devel/gcc-config: 1.3.13-r4 sys-devel/libtool: 1.5.22 virtual/os-headers: 2.6.17-r1 ACCEPT_KEYWORDS="x86" AUTOCLEAN="yes" CBUILD="i686-pc-linux-gnu" CFLAGS="-O2 -march=prescott -pipe -fomit-frame-pointer" CHOST="i686-pc-linux-gnu" CONFIG_PROTECT="/etc /usr/kde/3.5/env /usr/kde/3.5/share/config /usr/kde/3.5/shutdown /usr/share/X11/xkb /usr/share/config /usr/share/texmf/dvipdfm/config/ /usr/share/texmf/dvips/config/ /usr/share/texmf/tex/generic/config/ /usr/share/texmf/tex/platex/config/ /usr/share/texmf/xdvi/" CONFIG_PROTECT_MASK="/etc/env.d /etc/env.d/java/ /etc/gconf /etc/java-config/vms/ /etc/revdep-rebuild /etc/terminfo" CXXFLAGS="-O2 -march=prescott -pipe -fomit-frame-pointer" DISTDIR="/usr/portage/distfiles" EMERGE_DEFAULT_OPTS="--nospinner" FEATURES="autoconfig collision-protect distlocks metadata-transfer parallel-fetch sandbox sfperms strict test userfetch userpriv usersandbox" GENTOO_MIRRORS="http://distfiles.gentoo.org http://distro.ibiblio.org/pub/linux/distributions/gentoo" LINGUAS="en de en_GB de_CH" MAKEOPTS="-j3" PKGDIR="/usr/portage/packages" PORTAGE_RSYNC_OPTS="--recursive --links --safe-links --perms --times --compress --force --whole-file --delete --delete-after --stats --timeout=180 --exclude='/distfiles' --exclude='/local' --exclude='/packages'" PORTAGE_TMPDIR="/var/tmp" PORTDIR="/usr/portage" SYNC="rsync://rsync.europe.gentoo.org/gentoo-portage" USE="x86 X a52 aac acpi alsa apache2 asf berkdb bitmap-fonts cairo cdr cdrom cli cracklib crypt cups dbus divx dlloader dri dts dvd dvdr dvdread eds elibc_glibc emboss encode fam ffmpeg firefox flac fortran gdbm gif gnome gpm gstreamer gtk hal input_devices_keyboard input_devices_mouse ipv6 isdnlog java jpeg kde kernel_linux ldap libg++ linguas_de linguas_de_CH linguas_en linguas_en_GB mad mikmod mmx mono mp3 mpeg ncurses nls nptl nptlonly ogg opengl oss pam pcre perl png ppds pppd python qt3 qt4 quicktime readline reflection rtsp samba sdl session smp spell spl sse sse2 sse3 ssl svg tcpd test tetex theora threads truetype truetype-fonts type1-fonts udev unicode userland_GNU vcd video_cards_fbdev video_cards_i810 video_cards_vesa vorbis win32codecs wxwindows x264 xine xml xorg xprint xv xvid zlib" Unset: CTARGET, INSTALL_MASK, LANG, LC_ALL, LDFLAGS, PORTAGE_RSYNC_EXTRA_OPTS, PORTDIR_OVERLAY
[ebuild U ] dev-db/mysql-5.0.26-r1 [4.1.21] USE="berkdb perl ssl -big-tables -cluster -debug -embedded -extraengine -latin1 -max-idx-128% -minimal (-selinux) -srvdir -static (-raid%)" 1) emerges fine 2) passes collision test 3) passes test suite (impressive) 4) seems to work Maybe you can test passwords for strength? "test" shouldn't be allowed. Portage 2.1.1 (default-linux/x86/2006.1/desktop, gcc-4.1.1, glibc-2.4-r3, 2.6.17-gentoo-r8 i686) ================================================================= System uname: 2.6.17-gentoo-r8 i686 AMD Athlon(tm) XP 2500+ Gentoo Base System version 1.12.5 Last Sync: Thu, 26 Oct 2006 05:20:01 +0000 app-admin/eselect-compiler: [Not Present] dev-java/java-config: 1.3.7, 2.0.30 dev-lang/python: 2.4.3-r4 dev-python/pycrypto: 2.0.1-r5 dev-util/ccache: [Not Present] dev-util/confcache: [Not Present] 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-r2 sys-devel/binutils: 2.16.1-r3 sys-devel/gcc-config: 1.3.13-r4 sys-devel/libtool: 1.5.22 virtual/os-headers: 2.6.17-r1 ACCEPT_KEYWORDS="x86" AUTOCLEAN="yes" CBUILD="i686-pc-linux-gnu" CFLAGS="-O2" CHOST="i686-pc-linux-gnu" CONFIG_PROTECT="/etc /usr/kde/3.5/env /usr/kde/3.5/share/config /usr/kde/3.5/shutdown /usr/share/X11/xkb /usr/share/config /usr/share/texmf/dvipdfm/config/ /usr/share/texmf/dvips/config/ /usr/share/texmf/tex/generic/config/ /usr/share/texmf/tex/platex/config/ /usr/share/texmf/xdvi/" CONFIG_PROTECT_MASK="/etc/env.d /etc/env.d/java/ /etc/gconf /etc/java-config/vms/ /etc/revdep-rebuild /etc/terminfo" CXXFLAGS="-O2" DISTDIR="/usr/portage/distfiles" FEATURES="autoconfig ccache collision-protect distlocks metadata-transfer parallel-fetch sandbox sfperms strict test" GENTOO_MIRRORS="ftp://sunsite.informatik.rwth-aachen.de/pub/Linux/gentoo/" LANG="de_DE@euro" LC_ALL="de_DE@euro" LINGUAS="de" MAKEOPTS="-j2" PKGDIR="/usr/portage/packages" PORTAGE_RSYNC_OPTS="--recursive --links --safe-links --perms --times --compress --force --whole-file --delete --delete-after --stats --timeout=180 --exclude='/distfiles' --exclude='/local' --exclude='/packages'" PORTAGE_TMPDIR="/var/tmp" PORTDIR="/usr/portage" PORTDIR_OVERLAY="/usr/local/portage" SYNC="rsync://rsync.informatik.rwth-aachen.de/gentoo-portage" USE="x86 3dnow 3dnowext X Xaw3d a52 aiglx alsa artworkextra asf audiofile bash-completion beagle berkdb bidi bitmap-fonts bootsplash branding bzip2 cairo cdda cddb cdparanoia cdr cli cracklib crypt css cups curl custom-cflags dbus dga directfb divx4linux dlloader dri dts dvd dvdr dvdread dvi eds elibc_glibc emacs emboss encode esd evo exif expat fam fat fbcon ffmpeg firefox fortran ftp gb gcj gdbm gif gnome gpm gstreamer gtk gtk2 gtkhtml hal icq idn imagemagick imap input_devices_keyboard input_devices_mouse ipv6 isdnlog java javascript jikes jpeg jpeg2k kde kernel_linux ldap leim libg++ linguas_de lm_sensors mad maildir matroska mbox mhash mikmod mime mmx mmxext mng mono mp3 mpeg mpeg2 mule mysql nautilus ncurses nforce2 nls nocardbus nptl nptlonly nsplugin nvidia objc ogg opengl pam pcre pdf perl plotutils pmu png ppds pppd preview-latex print python qt3 qt4 quicktime readline reflection reiserfs samba sdk session slang spell spl sse ssl svg svga t1lib tcltk tcpd tetex theora thunderbird tiff truetype truetype-fonts type1-fonts udev usb userland_GNU vcd video_cards_fbdev video_cards_radeon video_cards_vesa videos vorbis win32codecs wmf wxwindows xine xml xorg xosd xv xvid zlib" Unset: CTARGET, EMERGE_DEFAULT_OPTS, INSTALL_MASK, LDFLAGS, PORTAGE_RSYNC_EXTRA_OPTS
(In reply to comment #17) > Archs please start to think to stabilize this one, it's still not the time, > mysql-5.0.26-r1 is in the tree since 2006-10-21 21:06:53 but we hope to > stabilize it around saturday 2005-11-08 if you agree. As the most of will have noticed "saturday 2005-11-08" is a bit strange date unless we do very big steps in time travel tecnology [TM] that atm is scheduled for gentoo 2008.2. Better stay whit sunday 2006-11-05 when CHTEKK will return from his driving week holiday.
emerges fine on amd64, but fails on tests: mysql_client_test [ fail ] Errors are (from /var/tmp/portage/mysql-5.0.26-r1/work/mysql/mysql-test/var/log/mysqltest-time) : sh: line 1: 30054 Aborted /var/tmp/portage/mysql-5.0.26-r1/work/mysql/tests/mysql_client_test --no-defaults --testcase --user=root --socket=/var/tmp/portage/mysql-5.0.26-r1/work/mysql/mysql-test/var/tmp/master.sock --port=3307 --silent --getopt-ll-test=25600M >>/var/tmp/portage/mysql-5.0.26-r1/work/mysql/mysql-test/var/log/mysql_client_test.log 2>&1 mysqltest: At line 12: command "$MYSQL_CLIENT_TEST --getopt-ll-test=25600M >> $MYSQLTEST_VARDIR/log/mysql_client_test.log 2>&1" failed (the last lines may be the most important ones) Aborting: mysql_client_test failed in default mode. To continue, re-run with '--force'. Ending Tests Shutting-down MySQL daemon Master shutdown finished Slave shutdown finished !!! ERROR: dev-db/mysql-5.0.26-r1 failed. Call stack: ebuild.sh, line 1546: Called dyn_test ebuild.sh, line 986: Called src_test mysql-5.0.26-r1.ebuild, line 32: Called die !!! make test failed !!! If you need support, post the topmost build error, and the call stack if relevant. With tests disabled it emerges and works fine. emerge --info Portage 2.1.1-r1 (default-linux/amd64/2006.1/desktop, gcc-4.1.1, glibc-2.4-r3, 2.6.18-suspend2-Dudebox-Edition x86_64) ================================================================= System uname: 2.6.18-suspend2-Dudebox-Edition x86_64 AMD Athlon(tm) 64 Processor 3200+ Gentoo Base System version 1.12.5 Last Sync: Tue, 31 Oct 2006 04:50:01 +0000 distcc 2.18.3 x86_64-pc-linux-gnu (protocols 1 and 2) (default port 3632) [enabled] ccache version 2.3 [enabled] app-admin/eselect-compiler: [Not Present] dev-java/java-config: [Not Present] dev-lang/python: 2.4.3-r4 dev-python/pycrypto: 2.0.1-r5 dev-util/ccache: 2.3 dev-util/confcache: [Not Present] sys-apps/sandbox: 1.2.17 sys-devel/autoconf: 2.13, 2.60 sys-devel/automake: 1.4_p6, 1.5, 1.6.3, 1.7.9-r1, 1.8.5-r3, 1.9.6-r2 sys-devel/binutils: 2.16.1-r3 sys-devel/gcc-config: 1.3.13-r3 sys-devel/libtool: 1.5.22 virtual/os-headers: 2.6.11-r2 ACCEPT_KEYWORDS="amd64" AUTOCLEAN="yes" CBUILD="x86_64-pc-linux-gnu" CFLAGS="-march=k8 -msse3 -Os -pipe" CHOST="x86_64-pc-linux-gnu" CONFIG_PROTECT="/etc /usr/kde/3.5/env /usr/kde/3.5/share/config /usr/kde/3.5/shutdown /usr/share/X11/xkb /usr/share/config /var/qmail/control" CONFIG_PROTECT_MASK="/etc/env.d /etc/gconf /etc/revdep-rebuild /etc/terminfo" CXXFLAGS="-march=k8 -msse3 -Os -pipe" DISTDIR="/usr/portage/distfiles" FEATURES="autoconfig buildpkg ccache collision-protect distcc distlocks metadata-transfer multilib-strict parallel-fetch sandbox sfperms strict test" GENTOO_MIRRORS="ftp://linux.rz.ruhr-uni-bochum.de/gentoo-mirror/ ftp:///ftp-stud.fht-esslingen.de/pub/Mirrors/gentoo/" LDFLAGS="-Wl,-O1" MAKEOPTS="-j4" PKGDIR="/usr/portage/packages" PORTAGE_RSYNC_OPTS="--recursive --links --safe-links --perms --times --compress --force --whole-file --delete --delete-after --stats --timeout=180 --exclude='/distfiles' --exclude='/local' --exclude='/packages'" PORTAGE_TMPDIR="/var/tmp" PORTDIR="/usr/portage" PORTDIR_OVERLAY="/usr/local/portage_overlay" SYNC="rsync://server/gentoo-portage" USE="amd64 X alsa apache2 berkdb bitmap-fonts cairo cdr cli cracklib crypt cups dbus dlloader dri dvd dvdr eds elibc_glibc emboss encode esd fam firefox fortran gcj gdbm gif gpm gstreamer gtk gtk2 hal iconv imap input_devices_keyboard input_devices_mouse isdnlog jpeg kde kdeenablefinal kdehiddenvisibility kernel_linux libg++ mad mikmod mp3 mpeg mysql ncurses nls nptl nptlonly objc objc++ ogg oss pam pcre perl png ppds pppd python qt3 qt4 quicktime readline reflection sdl session spell spl sqlite ssl tcpd test truetype truetype-fonts type1-fonts udev unicode userland_GNU video_cards_radeon vorbis xml xorg xv zlib" Unset: CTARGET, EMERGE_DEFAULT_OPTS, INSTALL_MASK, LANG, LC_ALL, LINGUAS, PORTAGE_RSYNC_EXTRA_OPTS
ppc is good to go.
Ok, we (me and vivo) agree that dev-db/mysql-5.0.26-r1 is ready for stabling, so: arch-teams, please stable that mysql version! Best regards, CHTEKK.
We got it...I checked it again, cannot test thoroughly, but it seems to work.
Stable on ppc
When merging with USE="debug cluster", I get the following error repeatably. I've got no experience debugging package collisions, so I'm not sure beyond what I see here.. those files are clearly a part of this package.. * checking 1517 files for package collisions 1000 files checked ... existing file /usr/lib64/libmysqlclient.so is not owned by this package existing file /usr/lib64/libmysqlclient_r.so is not owned by this package * spent 0.226099014282 seconds checking for file collisions * This package is blocked because it wants to overwrite * files belonging to other packages (see messages above). * If you have no clue what this is all about report it * as a bug for this package on http://bugs.gentoo.org Gentoo Base System version 1.12.5 Portage 2.1.1-r1 (default-linux/amd64/2006.1, gcc-4.1.1, glibc-2.4-r3, 2.6.15-gentoo-r72006040301 x86_64) ================================================================= System uname: 2.6.15-gentoo-r72006040301 x86_64 AMD Athlon(tm) 64 Processor 3700+ Last Sync: Mon, 06 Nov 2006 22:50:01 +0000 app-admin/eselect-compiler: [Not Present] dev-java/java-config: [Not Present] dev-lang/python: 2.4.3-r4 dev-python/pycrypto: 2.0.1-r5 dev-util/ccache: [Not Present] dev-util/confcache: [Not Present] sys-apps/sandbox: 1.2.17 sys-devel/autoconf: 2.13, 2.60 sys-devel/automake: 1.4_p6, 1.5, 1.6.3, 1.7.9-r1, 1.8.5-r3, 1.9.6-r2 sys-devel/binutils: 2.16.1-r3 sys-devel/gcc-config: 1.3.13-r4 sys-devel/libtool: 1.5.22 virtual/os-headers: 2.6.11-r2 ACCEPT_KEYWORDS="amd64" AUTOCLEAN="yes" CBUILD="x86_64-pc-linux-gnu" CFLAGS="-O2 -pipe" CHOST="x86_64-pc-linux-gnu" CONFIG_PROTECT="/etc" CONFIG_PROTECT_MASK="/etc/env.d /etc/gconf /etc/revdep-rebuild /etc/terminfo" CXXFLAGS="-O2 -pipe" DISTDIR="/usr/portage/distfiles" FEATURES="autoconfig collision-protect confcache digest distlocks metadata-transfer multilib-strict sandbox sfperms strict" GENTOO_MIRRORS="http://gentoo.chem.wisc.edu/gentoo/" PKGDIR="/usr/portage/packages" PORTAGE_RSYNC_OPTS="--recursive --links --safe-links --perms --times --compress --force --whole-file --delete --delete-after --stats --timeout=180 --exclude='/distfiles' --exclude='/local' --exclude='/packages'" PORTAGE_TMPDIR="/var/tmp" PORTDIR="/usr/portage" PORTDIR_OVERLAY="/usr/local/portage" SYNC="rsync://rsync.us.gentoo.org/gentoo-portage" USE="amd64 berkdb bitmap-fonts cli cracklib crypt cups dlloader dri elibc_glibc fortran gdbm gpm iconv input_devices_evdev input_devices_keyboard input_devices_mouse ipv6 isdnlog kernel_linux libg++ ncurses nls nptl nptlonly pam pcre perl ppds pppd python readline reflection session spl ssl tcpd truetype-fonts type1-fonts udev unicode userland_GNU video_cards_apm video_cards_ark video_cards_ati video_cards_chips video_cards_cirrus video_cards_cyrix video_cards_dummy video_cards_fbdev video_cards_glint video_cards_i128 video_cards_i810 video_cards_mga video_cards_neomagic video_cards_nv video_cards_rendition video_cards_s3 video_cards_s3virge video_cards_savage video_cards_siliconmotion video_cards_sis video_cards_sisusb video_cards_tdfx video_cards_tga video_cards_trident video_cards_tseng video_cards_v4l video_cards_vesa video_cards_vga video_cards_via video_cards_vmware video_cards_voodoo xorg zlib" Unset: CTARGET, EMERGE_DEFAULT_OPTS, INSTALL_MASK, LANG, LC_ALL, LDFLAGS, LINGUAS, MAKEOPTS, PORTAGE_RSYNC_EXTRA_OPTS
(In reply to comment #33) > When merging with USE="debug cluster", I get the following error repeatably. > > I've got no experience debugging package collisions, so I'm not sure beyond > what I see here.. those files are clearly a part of this package.. > > * checking 1517 files for package collisions > 1000 files checked ... > existing file /usr/lib64/libmysqlclient.so is not owned by this package > existing file /usr/lib64/libmysqlclient_r.so is not owned by this package > * spent 0.226099014282 seconds checking for file collisions > * This package is blocked because it wants to overwrite > * files belonging to other packages (see messages above). > * If you have no clue what this is all about report it > * as a bug for this package on http://bugs.gentoo.org those files are symlinks, and _only_ mysql provide them, emerge app-portage/portage-utils and run # qfile /usr/lib64/libmysqlclient_r.so it should tell you what package own those files, if it tell nothing (it will) than you can safely remove them and reemerge mysql.
I'm in an arch testing chroot, so I don't much care about "fixing" things -- but this is a bug in the mysql package (right?). My arch testing script runs through all combinations of USE flags, calling 'emerge' for each one. Theoretically, this should be a collision-protection-safe operation. When this error occurred, the previous run had been with USE="berkdb big-tables debug", and the merge failed with USE="cluster debug" I'll run an --unmerge/--depclean, clean out hte files, and start the process again, just to be sure.
(In reply to comment #28) I'm still working on client tests, the failure is not dangerous but I need to put my hands on a amd64 box to fix/remove the problem properly. (In reply to comment #35) > I'm in an arch testing chroot, so I don't much care about "fixing" things -- > but this is a bug in the mysql package (right?). > > My arch testing script runs through all combinations of USE flags, calling > 'emerge' for each one. Theoretically, this should be a > collision-protection-safe operation. When this error occurred, the previous > run had been with USE="berkdb big-tables debug", and the merge failed with > USE="cluster debug" > > I'll run an --unmerge/--depclean, clean out hte files, and start the process > again, just to be sure. It's a bug, but not a dev-db/mysql one imo: $qlist dev-db/mysql | grep 'libmysqlclient.*\.so$' /usr/lib/mysql/libmysqlclient_r.so /usr/lib/libmysqlclient.so /usr/lib/libmysqlclient_r.so /usr/lib/mysql/libmysqlclient.so The files are listed as installed by dev-db/mysql but "emerge -C mysql" does not delete them. We've no possibility to fix that inside the ebuild, sorry. There are no other packages that own those files so I cannot exclude other package using DEPEND vars inside the ebuild. To every tester: USE="berkdb perl ssl -cluster -extraengine -max-idx-128 -big-tables -debug -embedded -latin1 -minimal -selinux -srvdir -static innodb" Is the suggested USE flag combination, expecially "extraengine" will not be supported as stable, it constantly has problem with at least "federated" table type in 5.0, things are better with 5.1
sparc stable.
Stable for HPPA.
*bump* MySQL team: What about the failures pasted in comment 28? Are they save to ignore? because that is what stops amd64 from stabilizing right now...
(In reply to comment #39) > MySQL team: What about the failures pasted in comment 28? Are they save to > ignore? because that is what stops amd64 from stabilizing right now... Short answer: test the clients and if they work reliably (say more than one/two hours) stabilize it. Less Short Answer: Sorry, I don't have the hardware to look into it, the only other amd64 I have here it's over-busy (like me ;) right now. Luckily the company I work in has decided to upgrade my workstation to a dual core amd64 that will arrive next week so I'll make tests there. That test failed before, usually giving false positives...
Thanks for the advice. Since this is working for me for several days under average load now I guess it's safe to stabilize it :)
this is amd64 rock'n'roll
BTW, mysql-4 segfaults (probably because of CFLAGS) on my computer, while mysql-5 works pretty fine, so i think it's a really good idea to stabilise mysql-5 ;)
ppc64 stable
Just a note, bugzilla-2.20, 2.22 and 2.23 at least have problem with MySQL 5.0.25 and MySQL 5.1.12 or higher. The problem is how BLOBs are treated: https://bugzilla.mozilla.org/show_bug.cgi?id=321645#c17 . Just a warning about this change in mysql behaviour. (Personally, I had to patch bugzilla to run with 5.0.26-r1 with the two patches attached to that bug)
Alpha: ping, please mark dev-db/mysql-5.0.26-r2 stable, thanks! Best regards, CHTEKK.
First of all, a *big* sorry Luca for the delay on marking mysql on alpha. I've tried during theses last days to compile 5.0.26-r2 but seems like alpha doesn't like it. Looking a bit more on internet I found there is a known bug about this: http://bugs.mysql.com/bug.php?id=23256 After recover myself from read that mysql doesn't support alpha (WTF!), seems like the bug was solved in 5.1.13 version. The patch can be found at: http://lists.mysql.com/commits/13990. Probably is quite easy to make a backport. I've seen the mysql ebuild to provide a patch but seems like it's using part of eclasses blackmagic to make the patching and I don't want to broke anything :) Luca, I'm sorry but I think we need you to make the proper ebuild patch. Thanks and sorry again for the delay.
Thanks for testing it and finding the bug, I'll write up a patch and commit it during the next days, as I have to fixup anyway that "eclass blackmagic" for patching. ;) I'll update the bug here once it's in. Best regards, CHTEKK.
Notes for myself: dev-db/mysql: 4.1.22 works, 4.1.23 includes this fix 5.0.26 needs the backport, 5.0.32 includes this fix, later versions do too dev-db/mysql-community: 5.0.27 doesn't include the fix, 5.0.33 includes it, fix by adding .33 and dropping .27, later versions do have the fix Best regards, CHTEKK.
Finally, alpha stable. It doesn't pass all the tests but seems to work fine.