Gentoo Websites Logo
Go to: Gentoo Home Documentation Forums Lists Bugs Planet Store Wiki Get Gentoo!
Bug 158274 - dev-db/mysql-5.0.30 test failures
Summary: dev-db/mysql-5.0.30 test failures
Status: RESOLVED TEST-REQUEST
Alias: None
Product: Gentoo Linux
Classification: Unclassified
Component: Current packages (show other bugs)
Hardware: All Linux
: High normal (vote)
Assignee: Gentoo Linux MySQL bugs team
URL:
Whiteboard:
Keywords:
: 160935 (view as bug list)
Depends on:
Blocks:
 
Reported: 2006-12-16 03:52 UTC by Matti Bickel (RETIRED)
Modified: 2007-04-15 13:04 UTC (History)
4 users (show)

See Also:
Package list:
Runtime testing required: ---


Attachments
mysql_upgrade failure (test.failure,3.16 KB, text/plain)
2007-01-17 22:00 UTC, Matti Bickel (RETIRED)
Details

Note You need to log in before you can comment on or make changes to this bug.
Description Matti Bickel (RETIRED) gentoo-dev 2006-12-16 03:52:00 UTC
[ebuild   R   ] dev-db/mysql-5.0.30  USE="ssl -berkdb -big-tables -cluster -debug -embedded -extraengine -latin1 -max-idx-128 -minimal -perl (-selinux) -srvdir -static

Mysql-5.0.30 fails the following tests here:
execution_constants            [ fail ]
mysqltest: At line 65: query '$query_head 0 $query_tail' failed with wrong errno 2013: 'Lost connection to MySQL server during query', instead of 0...
openssl_1                      [ fail ]
mysqltest: At line 20: query 'connect  con3,localhost,ssl_user3,,,,,SSL' failed: 1045: Access denied for user 'ssl_user3'@'localhost' (using password: NO)
rpl_openssl                    [ fail ]  timeout

[Enter PEM pass phrase:mysql-test-run: WARNING: Waited 60 seconds for /var/tmp/portage/mysql-5.0.30/work/mysql/mysql-test/var/run/master.pid to be created, still waiting for 340 seconds...]
ssl_des                        [ fail ]
ERROR: Failed to start master mysqld 0

Right in the beginning i get this:
Killing Possible Leftover Processes
mysql-test-run: *** ERROR(child): can't redirect STDOUT to "/var/tmp/portage/mysql-5.0.30/work/mysql/mysql-test/var/log/mysqladmin.log": No such file o
r directory

emerge --info:
Portage 2.1.1-r2 (default-linux/ppc/ppc32/2006.0, gcc-4.1.1, glibc-2.4-r4, 2.6.19-rc5-20061114 ppc)
=================================================================
System uname: 2.6.19-rc5-20061114 ppc 7455, altivec supported
Gentoo Base System version 1.12.6
Last Sync: Sat, 25 Feb 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, 2.4.3-r4
dev-python/pycrypto: 2.0.1-r5
dev-util/ccache:     2.3
dev-util/confcache:  0.4.2-r1
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.17
sys-devel/gcc-config: 1.3.13-r4
sys-devel/libtool:   1.5.22
virtual/os-headers:  2.6.16
ACCEPT_KEYWORDS="ppc"
AUTOCLEAN="yes"
CBUILD="powerpc-unknown-linux-gnu"
CFLAGS="-O2 -mtune=G4 -maltivec -mabi=altivec -pipe"
CHOST="powerpc-unknown-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/env.d/java/ /etc/gconf /etc/java-config/vms/ /etc/revdep-rebuild /etc/terminfo /etc/texmf/web2c"
CXXFLAGS="-O2 -mtune=G4 -maltivec -mabi=altivec -pipe"
DISTDIR="/usr/portage/distfiles"
FEATURES="autoaddcvs autoconfig ccache collision-protect cvs distlocks metadata-transfer sandbox sfperms sign strict userpriv usersandbox"
GENTOO_MIRRORS="http://mirror.switch.ch/ftp/mirror/gentoo/ http://pandemonium.tiscali.de/pub/gentoo/ http://ftp.uni-erlangen.de/pub/mirrors/gentoo"
LANG="en_US.ISO-8859-1"
LINGUAS="de en en_GB"
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/overlays/local /usr/portage/local/layman/science /usr/portage/local/layman/postgresql-experimental"
SYNC="rsync://rsync.europe.gentoo.org/gentoo-portage"
USE="ppc X alsa alsa_cards_aoa alsa_cards_aoa-fabric-layout alsa_cards_aoa-onyx alsa_cards_aoa-soundbus alsa_cards_aoa-soundbus-i2s alsa_cards_aoa-tas alsa_cards_aoa-toonie alsa_cards_powermac alsa_cards_usb-audio alsa_cards_via82xx altivec apache2 apm bitmap-fonts bonobo bzip2 cdr cli cracklib crypt cups curl dlloader dri dvd eds elibc_glibc emboss encode foomaticdb gif gpm gstreamer gtkhtml iconv imlib input_devices_evdev input_devices_keyboard input_devices_mouse ipv6 isdnlog jpeg kde kernel_linux libg++ libwww linguas_de linguas_en linguas_en_GB mad motif mozilla mp3 mpeg ncurses nls nptl ogg opengl pam pcre perl pic png pppd python qt3 qt4 quicktime readline reflection samba sdl session slang spell spl ssl svg tcpd truetype truetype-fonts type1-fonts udev unicode userland_GNU video_cards_radeon vorbis xinerama xml xorg xv zlib"
Unset:  CTARGET, EMERGE_DEFAULT_OPTS, INSTALL_MASK, LC_ALL, LDFLAGS, PORTAGE_RSYNC_EXTRA_OPTS
Comment 1 Sergiy Borodych 2007-01-07 11:12:45 UTC
same error on ssl tests
with

# emerge -pv dev-db/mysql

These are the packages that would be merged, in order:

Calculating dependencies... done!
[ebuild     U ] dev-db/mysql-5.0.30-r1 [5.0.30] USE="berkdb%* perl%* ssl%* -big-tables% -cluster% -debug% -embedded% -extraengine% -latin1% -max-idx-128% -minimal% (-selinux) -static%" 0 kB

# emerge -v dev-db/mysql
...
openssl_1                      [ fail ]

Errors are (from /var/tmp/portage/dev-db/mysql-5.0.30-r1/work/mysql/mysql-test/var/log/mysqltest-time) :
mysqltest: At line 20: query 'connect  con3,localhost,ssl_user3,,,,,SSL' failed: 1045: Access denied for user 'ssl_user3'@'localhost' (using password: NO)
(the last lines may be the most important ones)
Result from queries before failure can be found in r/openssl_1.log

Stopping All Servers
Restoring snapshot of databases
Resuming Tests

rpl_openssl                    [ fail ]  timeout

Stopping All Servers
Restoring snapshot of databases
Resuming Tests

mysql-test-run: WARNING: Waited 360.9 seconds for /var/tmp/portage/dev-db/mysql-5.0.30-r1/work/mysql/mysql-test/var/run/master.pid to be created, still waiting for 39.1 seconds...
ssl_des                        [ fail ]

ERROR: Failed to start master mysqld 0

Stopping All Servers
Restoring snapshot of databases
Resuming Tests


# emerge --info
Portage 2.1.2_rc4-r6 (default-linux/amd64/2006.1/desktop, gcc-4.1.1, glibc-2.5-r0, 2.6.19-gentoo-r3 x86_64)
=================================================================
System uname: 2.6.19-gentoo-r3 x86_64 AMD Athlon(tm) 64 Processor 3000+
Gentoo Base System version 1.12.8
Last Sync: Sun, 07 Jan 2007 03:50:01 +0000
ccache version 2.4 [enabled]
dev-lang/python:     2.4.4
dev-python/pycrypto: 2.0.1-r5
dev-util/ccache:     2.4-r6
sys-apps/sandbox:    1.2.18.1
sys-devel/autoconf:  2.13, 2.61
sys-devel/automake:  1.4_p6, 1.5, 1.6.3, 1.7.9-r1, 1.8.5-r3, 1.9.6-r2, 1.10
sys-devel/binutils:  2.17
sys-devel/gcc-config: 1.3.14
sys-devel/libtool:   1.5.22
virtual/os-headers:  2.6.19
ACCEPT_KEYWORDS="amd64 ~amd64"
AUTOCLEAN="yes"
CBUILD="x86_64-pc-linux-gnu"
CFLAGS="-march=athlon64 -mtune=athlon64 -O2 -pipe"
CHOST="x86_64-pc-linux-gnu"
CONFIG_PROTECT="/etc /usr/share/X11/xkb"
CONFIG_PROTECT_MASK="/etc/env.d /etc/gconf /etc/revdep-rebuild /etc/terminfo"
CXXFLAGS="-march=athlon64 -mtune=athlon64 -O2 -pipe"
DISTDIR="/usr/portage/distfiles"
FEATURES="autoaddcvs autoconfig ccache collision-protect distlocks metadata-transfer sandbox sfperms strict test"
GENTOO_MIRRORS="http://distfiles.gentoo.org http://distro.ibiblio.org/pub/linux/distributions/gentoo"
LANG="ru_RU.utf8"
LINGUAS="ru uk"
MAKEOPTS="-j2"
PKGDIR="/usr/portage/packages"
PORTAGE_RSYNC_EXTRA_OPTS="--exclude-from=/etc/portage/rsync_excludes"
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.ua/gentoo-portage"
USE="X aac acpi aiglx alsa amd64 amr apache2 berkdb bitmap-fonts bzip2 cairo caps cdr cli cracklib crypt dbus djvu dlloader dri dvd dvdr emboss encode fam fat ffmpeg firefox flac gd gif glut gnome gpm gstreamer gtk gtk2 hal iconv isdnlog ithreads jpeg logrotate lzo mmap mozbranding mozdevelop mozilla moznocompose moznoirc moznomail mp3 mysql ncurses nls nptl nptlonly nsplugin ntfs nvidia ogg opengl pam pcre pdf perl pic png ppds pppd qt4 quicktime readline reflection reiser4 reiserfs samba sdl session slang sox spell spl sqlite ssl svg symlink tcpd threads timidity truetype truetype-fonts type1-fonts udev unicode usb vim-with-x vorbis wma x264 xml xorg xv xvid zlib" ALSA_CARDS="ali5451 als4000 atiixp atiixp-modem bt87x ca0106 cmipci emu10k1x ens1370 ens1371 es1938 es1968 fm801 hda-intel intel8x0 intel8x0m maestro3 trident usb-audio via82xx via82xx-modem ymfpci" ALSA_PCM_PLUGINS="adpcm alaw asym copy dmix dshare dsnoop empty extplug file hooks iec958 ioplug ladspa lfloat linear meter mulaw multi null plug rate route share shm softvol" ELIBC="glibc" INPUT_DEVICES="keyboard mouse" KERNEL="linux" LINGUAS="ru uk" USERLAND="GNU" VIDEO_CARDS="nv nvidia vesa vga"
Unset:  CTARGET, EMERGE_DEFAULT_OPTS, INSTALL_MASK, LC_ALL, LDFLAGS
Comment 2 Francesco R. (RETIRED) gentoo-dev 2007-01-08 09:34:41 UTC
short version: mysql-5.0.32 is in the tree

#c1 don't know very much about ppc but that kind of errors generally mean a crashed server, require much deeper investigation.

#c2 on 5.0.32 the only ssl test I get falling it's "ssl_des" and it fail because require a password to the user (so it's disabled now by the ebuild).
Comment 3 Jakub Moc (RETIRED) gentoo-dev 2007-01-08 21:35:22 UTC
*** Bug 160935 has been marked as a duplicate of this bug. ***
Comment 4 Matti Bickel (RETIRED) gentoo-dev 2007-01-17 21:58:48 UTC
Here's mysql-5.0.32:
Failed 3/397 tests, 99.24% were successful.
mysql-test-run in default mode: *** Failing the test(s): mysql_upgrade openssl_1 rpl_openssl

rpl_openssl                    [ fail ]  timeout

openssl_1                      [ fail ]

Errors are (from /var/tmp/paludis/dev-db/mysql-5.0.32/work/mysql/mysql-test/var/log/mysqltest-time) :
mysqltest: At line 20: query 'connect  con3,localhost,ssl_user3,,,,,SSL' failed: 1045: Access denied for user 'ssl_user3'@'localhost' (using password: NO)

[mysql_upgrade failure attached, so i don't clobber the bug]
Comment 5 Matti Bickel (RETIRED) gentoo-dev 2007-01-17 22:00:14 UTC
Created attachment 107309 [details]
mysql_upgrade failure
Comment 6 Robin Johnson archtester Gentoo Infrastructure gentoo-dev Security 2007-04-15 13:04:49 UTC
Please retest on 5.0.38 (in the tree as of 10 minutes ago, give it a bit longer to propogate the patches).

Reopen if the problems still occur for you.

I have tested on my ppc64-32ul and my core2duo with the following:
time FEATURES=test USE='berkdb big-tables cluster embedded extraengine' ebuild mysql-5.0.38.ebuild test