Gentoo Websites Logo
Go to: Gentoo Home Documentation Forums Lists Bugs Planet Store Wiki Get Gentoo!
Bug 297234 - dev-db/mysql-5.0.84-r1 fails test mysql and mysql_upgrade
Summary: dev-db/mysql-5.0.84-r1 fails test mysql and mysql_upgrade
Status: RESOLVED INVALID
Alias: None
Product: Gentoo Linux
Classification: Unclassified
Component: Current packages (show other bugs)
Hardware: AMD64 Linux
: High minor (vote)
Assignee: Gentoo Linux MySQL bugs team
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2009-12-16 23:22 UTC by Christian Harms
Modified: 2010-03-24 02:31 UTC (History)
0 users

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


Attachments
emerge --info (emerge.info,12.27 KB, text/plain)
2009-12-16 23:24 UTC, Christian Harms
Details
the requested info (bug297234.txt,4.40 KB, text/plain)
2010-02-03 13:01 UTC, Christian Harms
Details

Note You need to log in before you can comment on or make changes to this bug.
Description Christian Harms 2009-12-16 23:22:58 UTC
both failing tests are, it seems, due to different wording of the expected error messages, as seen in the diffs between .result and .reject files shown.

I expected LC_MESSAGES=en_GB.utf8 to be the culprit, but setting LC=C did not help.

Reproducible: Always

Steps to Reproduce:
1. FEATURES="-userpriv -usersandbox" emerge -av1 dev-db/mysql
Actual Results:  
mysql                          [ fail ]                                                                                   

--- /var/tmp/portage/dev-db/mysql-5.0.84-r1/work/mysql/mysql-test/r/mysql.result        2009-12-17 00:19:22.178543222 +0300
+++ /var/tmp/portage/dev-db/mysql-5.0.84-r1/work/mysql/mysql-test/r/mysql.reject        2009-12-17 00:52:41.971542501 +0300
@@ -162,8 +162,8 @@                                                                                                        
 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)                                        
+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 :)XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX' (errno)                                                                                                                           
 Too long dbname                                                                                                                                 
@@ -199,5 +199,5 @@                                                                                                                              
 1                                                                                                                                               
 COUNT (*)                                                                                                                                       
 1                                                                                                                                               
-ERROR 2005 (HY000) at line 1: Unknown MySQL server host 'invalid_hostname' (errno)                                                              
+ERROR 2003 (HY000) at line 1: Can't connect to MySQL server on 'invalid_hostname' (errno)                                                       
 End of 5.0 tests                                                                                                                                

mysqltest: Result content mismatch

Stopping All Servers
Restoring snapshot of databases
Resuming Tests

mysql_upgrade                  [ fail ]               

--- /var/tmp/portage/dev-db/mysql-5.0.84-r1/work/mysql/mysql-test/r/mysql_upgrade.result        2009-07-07 17:04:18.000000000 +0300
+++ /var/tmp/portage/dev-db/mysql-5.0.84-r1/work/mysql/mysql-test/r/mysql_upgrade.reject        2009-12-17 00:56:34.326543933 +0300
@@ -58,7 +58,7 @@                                                                                                                  
 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                         
+mysqlcheck: Got error: 2003: Can't connect to MySQL server on 'not_existing_host' (errno) when trying to connect                  
 FATAL ERROR: Upgrade failed                                                                                                       
 set GLOBAL sql_mode='STRICT_ALL_TABLES,ANSI_QUOTES,NO_ZERO_DATE';                                                                 
 mysql.columns_priv                                 OK                                                                             

mysqltest: Result content mismatch

Stopping All Servers
Restoring snapshot of databases
Resuming Tests

Expected Results:  
all tests should pass.
Comment 1 Christian Harms 2009-12-16 23:24:22 UTC
Created attachment 213249 [details]
emerge --info

output of emerge --info
Comment 2 Robin Johnson archtester Gentoo Infrastructure gentoo-dev Security 2009-12-19 00:54:23 UTC
I need the output of the following
# uname -a
# grep $(hostname) /etc/hosts
# getent hosts $(hostname)
# grep hosts /etc/nsswitch.conf
# cat /etc/resolv.conf
# ping -c 1 invalid_hostname
# iptables-save
Comment 3 Robin Johnson archtester Gentoo Infrastructure gentoo-dev Security 2010-01-31 04:44:00 UTC
No response from user.
Comment 4 Christian Harms 2010-02-03 13:01:54 UTC
Created attachment 218285 [details]
the requested info

Sorry for the delay. I must have missed bugzilla's email announcing your previous comment.
Comment 5 Christian Harms 2010-02-03 13:03:10 UTC
reopened with requested info.
Comment 6 Robin Johnson archtester Gentoo Infrastructure gentoo-dev Security 2010-03-24 02:31:10 UTC
Your DNS is completely broken:

lordhelmchen@bucephalos ~ $ ping -c 1 invalid_hostname               
PING procyon.canisminor.de (213.239.212.56) 56(84) bytes of data.    
64 bytes from canisminor.de (213.239.212.56): icmp_seq=1 ttl=55 time=109 ms

Something in your resolver chain is resolving any random hostname to that IP.

The correct output there is:
# ping invalid_hostname
ping: unknown host invalid_hostname