Gentoo Websites Logo
Go to: Gentoo Home Documentation Forums Lists Bugs Planet Store Wiki Get Gentoo!
Bug 185059 - dev-db/mysql-5.0.42: mysql and mysql_upgrade tests failing
Summary: dev-db/mysql-5.0.42: mysql and mysql_upgrade tests failing
Status: RESOLVED INVALID
Alias: None
Product: Gentoo Linux
Classification: Unclassified
Component: New packages (show other bugs)
Hardware: All Linux
: High normal (vote)
Assignee: Gentoo Linux MySQL bugs team
URL:
Whiteboard:
Keywords:
: 185060 (view as bug list)
Depends on:
Blocks:
 
Reported: 2007-07-12 10:52 UTC by Jesus de Santos Garcia
Modified: 2008-01-15 15:36 UTC (History)
0 users

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


Attachments

Note You need to log in before you can comment on or make changes to this bug.
Description Jesus de Santos Garcia 2007-07-12 10:52:23 UTC
--------------------------------------------------------
mysql-test-run in ps-protocol mode: *** Failing the test(s): mysql mysql_upgrade
mysql-test-run: *** ERROR: there were failing test cases
--------------------------------------------------------

The error seems trivial to me (the file against which compare the output to seems wrong). These are the detailed error of each of the two tests:

--------------------------------------------------------
mysql_upgrade                  [ fail ]

Errors are (from /var/tmp/portage/dev-db/mysql-5.0.42/work/mysql/mysql-test/var/log/mysqltest-time) :
mysqltest: Result length mismatch
(the last lines may be the most important ones)
Below are the diffs between actual and expected results:
-------------------------------------------------------
*** r/mysql_upgrade.result      2007-05-14 17:10:26.000000000 +0300
--- r/mysql_upgrade.reject      2007-07-09 17:46:41.000000000 +0300
***************
*** 58,62 ****
  mysql.user                                         OK
  DROP USER mysqltest1@'%';
  Run mysql_upgrade with a non existing server socket
! mysqlcheck: Got error: 2005: Unknown MySQL server host 'not_existing_host' (errno) when trying to connect
  FATAL ERROR: Upgrade failed
--- 58,62 ----
  mysql.user                                         OK
  DROP USER mysqltest1@'%';
  Run mysql_upgrade with a non existing server socket
! mysqlcheck: Got error: 2003: Can't connect to MySQL server on 'not_existing_host' (errno) when trying to connect
  FATAL ERROR: Upgrade failed
--------------------------------------------------------
mysql                          [ fail ]

Errors are (from /var/tmp/portage/dev-db/mysql-5.0.42/work/mysql/mysql-test/var/log/mysqltest-time) :
mysqltest: Result length mismatch
(the last lines may be the most important ones)
Below are the diffs between actual and expected results:
-------------------------------------------------------
*** r/mysql.result      2007-05-14 17:10:26.000000000 +0300
--- r/mysql.reject      2007-07-09 17:46:13.000000000 +0300
***************
*** 162,169 ****
  ERROR 1049 (42000) at line 1: Unknown database 'invalid'
  Test connect with dbname + hostname
  Test connect with dbname + _invalid_ hostname
! ERROR 2005 (HY000) at line 1: Unknown MySQL server host 'invalid_hostname' (errno)
! ERROR 2005 (HY000) at line 1: Unknown MySQL server host 'invalid_hostname' (errno)
  The commands reported in the bug report
  ERROR 2005 (HY000) at line 1: Unknown MySQL server host 'cyril has found a bug :)XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX$
  Too long dbname
--- 162,169 ----
  ERROR 1049 (42000) at line 1: Unknown database 'invalid'
  Test connect with dbname + hostname
  Test connect with dbname + _invalid_ hostname
! ERROR 2003 (HY000) at line 1: Can't connect to MySQL server on 'invalid_hostname' (errno)
! ERROR 2003 (HY000) at line 1: Can't connect to MySQL server on 'invalid_hostname' (errno)
  The commands reported in the bug report
  ERROR 2005 (HY000) at line 1: Unknown MySQL server host 'cyril has found a bug :)XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX$
  Too long dbname
-------------------------------------------------------




Portage 2.1.2.9 (default-linux/x86/2007.0, gcc-4.1.2, glibc-2.5-r4, 2.6.19-gentoo-r5 i686)
=================================================================
System uname: 2.6.19-gentoo-r5 i686 Intel(R) Celeron(R) CPU 2.40GHz
Gentoo Base System release 1.12.9
Timestamp of tree: Thu, 12 Jul 2007 01:20:01 +0000
dev-lang/python:     2.3.5-r3, 2.4.4-r4
dev-python/pycrypto: 2.0.1-r5
sys-apps/sandbox:    1.2.17
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.16.1-r3
sys-devel/gcc-config: 1.3.16
sys-devel/libtool:   1.5.22
virtual/os-headers:  2.6.17-r2
ACCEPT_KEYWORDS="x86"
AUTOCLEAN="yes"
CBUILD="i686-pc-linux-gnu"
CFLAGS="-O3 -pipe -march=pentium4 -fomit-frame-pointer"
CHOST="i686-pc-linux-gnu"
CONFIG_PROTECT="/etc /usr/share/logwatch/default.conf /var/www/localhost/htdocs/cacti/include /var/www/localhost/htdocs/wordpress /var/www/noesis.mine.nu/htdocs/dokuwiki/conf"
CONFIG_PROTECT_MASK="/etc/env.d /etc/gconf /etc/php/apache2-php5/ext-active/ /etc/php/cgi-php5/ext-active/ /etc/php/cli-php5/ext-active/ /etc/revdep-rebuild /etc/terminfo"
CXXFLAGS="-O3 -pipe -march=pentium4 -fomit-frame-pointer"
DISTDIR="/usr/portage/distfiles"
FEATURES="collision-protect distlocks metadata-transfer sandbox sfperms strict test userpriv"
GENTOO_MIRRORS="http://ftp.belnet.be/mirror/rsync.gentoo.org/gentoo/ http://linuv.uv.es/mirror/gentoo/ http://ftp-stud.fht-esslingen.de/pub/Mirrors/gentoo/"
LANG="en_US"
LC_ALL="en_US"
LINGUAS="en"
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 --filter=H_**/files/digest-*"
PORTAGE_TMPDIR="/var/tmp"
PORTDIR="/usr/portage"
PORTDIR_OVERLAY="/usr/local/portage"
SYNC="rsync://rsync.europe.gentoo.org/gentoo-portage"
USE="acpi apache2 berkdb bitmap-fonts cli cracklib crypt dri gdbm gnome gtk gtk2 iconv isdnlog libg++ midi mmx mudflap ncurses nls nptl nptlonly openmp pam pcre perl pppd python readline reflection samba session snmp spl sse sse2 ssl svg test truetype-fonts type1-fonts usb vhosts x86 xorg zlib" ELIBC="glibc" INPUT_DEVICES="keyboard mouse" KERNEL="linux" LCD_DEVICES="cfontz cfontzpacket" LINGUAS="en" USERLAND="GNU" VIDEO_CARDS="fglrx"
Unset:  CTARGET, EMERGE_DEFAULT_OPTS, INSTALL_MASK, LDFLAGS, PORTAGE_COMPRESS, PORTAGE_COMPRESS_FLAGS, PORTAGE_RSYNC_EXTRA_OPTS
Comment 1 Jakub Moc (RETIRED) gentoo-dev 2007-07-12 11:10:22 UTC
*** Bug 185060 has been marked as a duplicate of this bug. ***
Comment 2 Jesus de Santos Garcia 2007-07-21 18:43:48 UTC
Same problem with version 5.0.44

Comment 3 Robin Johnson archtester Gentoo Infrastructure gentoo-dev Security 2007-07-24 07:52:37 UTC
Can you please test with 5.0.44-r1, and then tar up the following:
/var/tmp/portage/dev-db/mysql-5.0.44-r1/work/mysql/test*
And upload it somewhere onto the internet for me?
Sendspace.com or similar sites work well if you won't have your own server.
Comment 4 Jesus de Santos Garcia 2007-07-24 12:04:07 UTC
(In reply to comment #3)
> Can you please test with 5.0.44-r1, and then tar up the following:
> /var/tmp/portage/dev-db/mysql-5.0.44-r1/work/mysql/test*
> And upload it somewhere onto the internet for me?
> Sendspace.com or similar sites work well if you won't have your own server.
> 

Yes, here you have:

http://entland.homelinux.com/blog/wp-content/mysql-5.0.44-r1

Comment 5 Robin Johnson archtester Gentoo Infrastructure gentoo-dev Security 2008-01-15 15:36:14 UTC
I ran into this a moment ago myself, when my nameserver was mucking up.
So it's not a mysql per se, it's a system misconfiguration.