Bug #48866 | mysql.test fails under Fedora 12 | ||
---|---|---|---|
Submitted: | 18 Nov 2009 15:20 | Modified: | 12 Mar 2010 16:48 |
Reporter: | Georgi Kodinov | Email Updates: | |
Status: | Closed | Impact on me: | |
Category: | MySQL Server: Command-line Clients | Severity: | S3 (Non-critical) |
Version: | 5.0, 5.1 | OS: | Linux (Fedora 12 x86_64) |
Assigned to: | Georgi Kodinov | CPU Architecture: | Any |
[18 Nov 2009 15:20]
Georgi Kodinov
[19 Nov 2009 19:26]
Sveta Smirnova
Thank you for the feedback. I can not repeat this too. How do you compile MySQL server?
[20 Nov 2009 13:50]
Oliver Heil
Hello, I also get the failure with Fedora 12 and mysql-5.0.87: [root@dbm02 mysql-test]# uname -a Linux dbm02 2.6.31.5-127.fc12.x86_64 #1 SMP Sat Nov 7 21:11:14 EST 2009 x86_64 x86_64 x86_64 GNU/Linux configuring with: [root@dbm02 mysql-test]# ./configure --prefix=/usr/local/mysql-5.0.87-gcc2 --without-debug --enable-thread-safe-client --enable-local-infile --enable-assembler --disable-shared --with-mysqld-ldflags=-static --with-client-ldflags=-static [root@dbm02 mysql-test]# ./mtr Logging: ./mtr MySQL Version 5.0.87 Skipping ndbcluster, mysqld not compiled with ndbcluster Skipping SSL, mysqld not compiled with SSL Using MTR_BUILD_THREAD = 0 Using MASTER_MYPORT = 9306 Using MASTER_MYPORT1 = 9307 Using SLAVE_MYPORT = 9308 Using SLAVE_MYPORT1 = 9309 Using SLAVE_MYPORT2 = 9310 Using IM_PORT = 9313 Using IM_MYSQLD1_PORT = 9314 Using IM_MYSQLD2_PORT = 9315 Killing Possible Leftover Processes Removing Stale Files Creating Directories Installing Master Database Installing Slave1 Database mysql-test-run: WARNING: running this script as _root_ will cause some tests to be skipped ======================================================= Starting Tests in the 'main' suite TEST RESULT TIME (ms) ------------------------------------------------------- ... mysql [ fail ] --- /usr/local/mysql-5.0.87-gcc2/mysql-test/r/mysql.result 2009-11-20 13:18:37.699184930 +0300 +++ /usr/local/mysql-5.0.87-gcc2/mysql-test/r/mysql.reject 2009-11-20 16:35:58.885996135 +0300 @@ -165,7 +165,7 @@ 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 :)XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX' (errno) +ERROR 2005 (HY000) at line 1: Unknown MySQL server host 'cyrilhas' (errno) Too long dbname ERROR 1049 (42000) at line 1: Unknown database 'test_really_long_dbnamexxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx' Too long hostname mysqltest: Result content mismatch
[20 Nov 2009 14:20]
Georgi Kodinov
What locale are you using ? I'm using the following : LANG=bg_BG.UTF-8 My versioning is as follows : gcc (GCC) 4.4.2 20091027 (Red Hat 4.4.2-7) GNU C Library stable release version 2.11, by Roland McGrath et al. Copyright (C) 2009 Free Software Foundation, Inc. This is free software; see the source for copying conditions. There is NO warranty; not even for MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. Compiled by GNU CC version 4.4.2 20091027 (Red Hat 4.4.2-7). Compiled on a Linux >>2.6.18-164.2.1.el5<< system on 2009-11-05. Available extensions: The C stubs add-on version 2.1.2. crypt add-on version 2.1 by Michael Glad and others GNU Libidn by Simon Josefsson Native POSIX Threads Library by Ulrich Drepper et al BIND-8.2.3-T5B RT using linux kernel aio I also have selinux disabled.
[20 Nov 2009 15:22]
Oliver Heil
Hello, here are the infos, selinux is disabled too: [root@dbm02 mysql-test]# getenforce Permissive [root@dbm02 mysql-test]# cat /etc/sysconfig/i18n LANG="de_DE" SYSFONT="latarcyrheb-sun16" [root@dbm02 mysql-test]# gcc --version gcc (GCC) 4.4.2 20091027 (Red Hat 4.4.2-7) Copyright (C) 2009 Free Software Foundation, Inc. Dies ist freie Software; die Kopierbedingungen stehen in den Quellen. Es gibt KEINE Garantie; auch nicht für MARKTGÄNGIGKEIT oder FÜR SPEZIELLE ZWECKE.
[21 Nov 2009 5:18]
MySQL Verification Team
Now I was able to repeat on INTEL machine running FC 12 64-bit: Killing Possible Leftover Processes Removing Stale Files Creating Directories Installing Master Database ======================================================= Starting Tests in the 'main' suite TEST RESULT TIME (ms) ------------------------------------------------------- mysql [ fail ] --- /home/miguel/bzr/5.0-build/mysql-test/r/mysql.result 2009-11-21 07:42:06.827761472 +0300 +++ /home/miguel/bzr/5.0-build/mysql-test/r/mysql.reject 2009-11-21 08:14:26.790027726 +0300 @@ -165,7 +165,7 @@ 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 :)XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX' (errno) +ERROR 2005 (HY000) at line 1: Unknown MySQL server host 'cyrilhas' (errno) Too long dbname ERROR 1049 (42000) at line 1: Unknown database 'test_really_long_dbnamexxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx' Too long hostname mysqltest: Result content mismatch Aborting: mysql failed in default mode. To continue, re-run with '--force'. Stopping All Servers skipped 9 bytes from file: socket (3) [miguel@quetzal2 mysql-test]$ I failed to repeat before because FC 12 64-bit is running on AMD machine neither the compile nor the test issues happen on AMD machine.
[8 Dec 2009 16:23]
Omer Barnir
triage: setting to SR51MRU - I3 as affects development environments and slows down testing
[9 Dec 2009 11:02]
Bugs System
A patch for this bug has been committed. After review, it may be pushed to the relevant source trees for release in the next version. You can access the patch from: http://lists.mysql.com/commits/93296 2861 Georgi Kodinov 2009-12-09 Bug #48866: mysql.test fails under Fedora 12 strmov() is not guaranteed to work correctly on overlapping source and destination buffers. On some OSes it may work, but Fedora 12 has a stpcpy() that's not working correctly on overlapping buffers. Fixed to use the overlap-safe memmove() instead.
[16 Dec 2009 17:31]
Bugs System
A patch for this bug has been committed. After review, it may be pushed to the relevant source trees for release in the next version. You can access the patch from: http://lists.mysql.com/commits/94537 2861 Georgi Kodinov 2009-12-16 Bug #48866: mysql.test fails under Fedora 12 strmov() is not guaranteed to work correctly on overlapping source and destination buffers. On some OSes it may work, but Fedora 12 has a stpcpy() that's not working correctly on overlapping buffers. Fixed to use the overlap-safe version of strmov instead. Re-vitalized the overlap-safe version of strmov.
[21 Dec 2009 15:40]
Tor Didriksen
Also fails in 6.0-codebase-bugfixing
[24 Dec 2009 8:43]
Bugs System
A patch for this bug has been committed. After review, it may be pushed to the relevant source trees for release in the next version. You can access the patch from: http://lists.mysql.com/commits/95654 2831 Georgi Kodinov 2009-12-16 Bug #48866: mysql.test fails under Fedora 12 strmov() is not guaranteed to work correctly on overlapping source and destination buffers. On some OSes it may work, but Fedora 12 has a stpcpy() that's not working correctly on overlapping buffers. Fixed to use the overlap-safe version of strmov instead. Re-vitalized the overlap-safe version of strmov.
[1 Jan 2010 15:47]
TDavid Hudson
FYI, after applying the first two patches, I run into a further problem in main.mysql (on OpenSuSE 11.1: Linux linux-oz0y 2.6.27.39-0.2-default #1 SMP 2009-11-23 12:57:38 +0100 x86_64 x86_64 x86_64 GNU/Linux). Comcast's DNS nameserver is resolving invalid_hostname and, apparently, any bogus hostname, to actual IP address 63.123.155.104 (in a range of Verizon/MCI addresses), resulting in this discrepancy: @@ -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 @@ -198,7 +198,7 @@ 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 WARNING: --server-arg option not supported in this configuration. Warning (Code 1286): Unknown table engine 'nonexistent' This faulty lookup does not happen on a different, non-Linux system or when using its nameserver from my own system. It does happen, resolving to yet another IP address, when I use yet another nameserver by specifying its domain. My attempts so far to report the problem to Comcast have been unsuccessful. All of "make test" passes when I temporarily change my system to use a better nameserver. I wonder if bug #48866 would have happened in the first place without a similar nameserver problem. It wasn't present a month or so ago using a build from the same source, on essentially the same system.
[4 Jan 2010 14:52]
Georgi Kodinov
The invalid_hostname is a separate well known problem (because of the DNS server's setup). Please report this in a new bug.
[14 Jan 2010 8:27]
Bugs System
Pushed into 5.0.90 (revid:joro@sun.com-20100114082402-05fod2h6z9x9wok8) (version source revid:joro@sun.com-20091216173119-9sglew79undcst7n) (merge vers: 5.0.89) (pib:16)
[15 Jan 2010 9:02]
Bugs System
Pushed into 5.1.43 (revid:joro@sun.com-20100115085139-qkh0i0fpohd9u9p5) (version source revid:joro@sun.com-20091224090004-zhoioiemb6879uuk) (merge vers: 5.1.42) (pib:16)
[16 Jan 2010 2:40]
Paul DuBois
Noted in 5.0.90, 5.1.43 changelogs. On Fedora 12, strmov() did not guarantee correct operation for overlapping source and destination buffer. Calls were fixed to use an overlap-safe version instead. Setting report to NDI pending push to 5.5.x+.
[5 Feb 2010 11:50]
Bugs System
Pushed into mysql-next-mr (revid:alik@sun.com-20100204063540-9czpdmpixi3iw2yb) (version source revid:alik@sun.com-20100119163614-172adculixyu26j5) (pib:16)
[5 Feb 2010 11:56]
Bugs System
Pushed into 6.0.14-alpha (revid:alik@sun.com-20100205113942-oqovjy0eoqbarn7i) (version source revid:alik@sun.com-20100204064210-ljwanqvrjs83s1gq) (merge vers: 6.0.14-alpha) (pib:16)
[5 Feb 2010 12:02]
Bugs System
Pushed into 5.5.2-m2 (revid:alik@sun.com-20100203172258-1n5dsotny40yufxw) (version source revid:alexey.kopytov@sun.com-20091225105650-qletdbs0wz9sx5nc) (merge vers: 5.5.1-m2) (pib:16)
[5 Feb 2010 17:04]
Paul DuBois
Noted in 5.5.2, 6.0.14 changelogs. Setting report to Need Merge pending push to Celosia.
[12 Mar 2010 14:15]
Bugs System
Pushed into 5.1.44-ndb-7.0.14 (revid:jonas@mysql.com-20100312135944-t0z8s1da2orvl66x) (version source revid:jonas@mysql.com-20100312115609-woou0te4a6s4ae9y) (merge vers: 5.1.44-ndb-7.0.14) (pib:16)
[12 Mar 2010 14:31]
Bugs System
Pushed into 5.1.44-ndb-6.2.19 (revid:jonas@mysql.com-20100312134846-tuqhd9w3tv4xgl3d) (version source revid:jonas@mysql.com-20100312060623-mx6407w2vx76h3by) (merge vers: 5.1.44-ndb-6.2.19) (pib:16)
[12 Mar 2010 14:47]
Bugs System
Pushed into 5.1.44-ndb-6.3.33 (revid:jonas@mysql.com-20100312135724-xcw8vw2lu3mijrhn) (version source revid:jonas@mysql.com-20100312103652-snkltsd197l7q2yg) (merge vers: 5.1.44-ndb-6.3.33) (pib:16)
[12 Mar 2010 16:48]
Paul DuBois
Fixed in earlier 5.1.x, 5.5.x.