| Bug #13175 | 5.0 builds done w/ comp-pent & comp-pent-max seem to fail test w/ --ps-protocol | ||
|---|---|---|---|
| Submitted: | 14 Sep 2005 11:24 | Modified: | 29 Mar 2006 21:05 |
| Reporter: | Jonathan Miller | Email Updates: | |
| Status: | Can't repeat | Impact on me: | |
| Category: | MySQL Server: Compiling | Severity: | S2 (Serious) |
| Version: | 5.0.x | OS: | Linux (Linux) |
| Assigned to: | Kent Boortz | CPU Architecture: | Any |
[14 Sep 2005 11:28]
Jonathan Miller
***********************Both regular and Max ******************************* mysql_client_test [ fail ] Errors are (from /home/ndbdev/jmiller/mysql5.0/mysql-test/var/log/mysqltest-time) : mysql_client_test.c:3851: check failed: 'rc == 0' mysqltest: At line 10: command "$MYSQL_CLIENT_TEST" failed (the last lines may be the most important ones) ndb_types [ fail ] Errors are (from /home/ndbdev/jmiller/mysql5.0/mysql-test/var/log/mysqltest-time) : mysqltest: At line 0: Result content mismatch (the last lines may be the most important ones) Below are the diffs between actual and expected results: ***********************Both regular and Max ******************************* ps_2myisam [ fail ] ***********************Both regular and Max ******************************* ps_3innodb [ fail ] ***********************Both regular and Max ******************************* ps_4heap [ fail ] ***********************Both regular and Max ******************************* ps_5merge [ fail ] ps_6bdb [ fail ] ps_7ndb [ fail ] ***********************Both regular and Max ******************************* sp-error [ fail ] ***********************Both regular and Max ******************************* strict [ fail ] ***********************Both regular and Max ******************************* type_float [ fail ] ***********************Both regular and Max ******************************* type_ranges [ fail ]
[27 Dec 2005 16:48]
[ name withheld ]
I've the same problem as described in the first posting -> and if I try to use mysqld it dies (SIGTERM). -> How to repeat: use phpMyAdmin
[12 Feb 2006 10:10]
[ name withheld ]
"Verified (151 days)", but no solution and no answer? :( I want to update to 5.0.x asap
Description: Pulled the latest 5.0-wl1012 tree and built using compile-pentium-max. In running the tests with (--force --ps-protocol) I had 18 failures. To make sure that it was just in the wl1012 clone I pulled the latest 5.0 tree and built using compile-pentium-max. The testing turned up 14 failures. So I cleaned the tree and rebuilt using compile-pentium with the testing ending in 10 failures. (Note: 4 tests are max related) Yesterday, I followed Kent's build instruction and rebuilt the same exact tree ans retested. No failures were produce from this build. System builds was done on: Linux ndb08 2.6.11-1.1369_FC4smp #1 SMP Thu Jun 2 23:08:39 EDT 2005 i686 athlon i386 GNU/Linux ./mysql-test-run --force --ps-protocol federated Errors are (from /home/ndbdev/jmiller/mysql5.0/mysql-test/var/log/mysqltest-time) : mysqltest: At line 0: Result length mismatch (the last lines may be the most important ones) Below are the diffs between actual and expected results: ------------------------------------------------------- *** r/federated.result 2005-09-12 22:14:37.000000000 +0300 --- r/federated.reject 2005-09-12 22:44:01.000000000 +0300 *************** *** 946,953 **** NULL NULL NULL NULL NULL NULL NULL NULL 1 NULL NULL NULL ! NULL foo 33.3333 NULL ! NULL 0 0.3333 NULL SELECT count(*) FROM federated.t1 WHERE id IS NULL AND name IS NULL --- 946,953 ---- NULL NULL NULL NULL NULL NULL NULL NULL 1 NULL NULL NULL ! NULL foo 4.2039e-45 NULL ! NULL 0 1.4013e-45 NULL SELECT count(*) FROM federated.t1 WHERE id IS NULL AND name IS NULL ************ Both regular and max ********************************8 join [ fail ] Errors are (from /home/ndbdev/jmiller/mysql5.0/mysql-test/var/log/mysqltest-time) : mysqltest: At line 0: Result length mismatch (the last lines may be the most important ones) Below are the diffs between actual and expected results: ------------------------------------------------------- *** r/join.result 2005-09-12 22:14:38.000000000 +0300 --- r/join.reject 2005-09-12 22:48:51.000000000 +0300 *************** *** 276,291 **** INSERT INTO t2 VALUES ('rivercats','cust',20); SELECT emp.rate_code, lr.base_rate FROM t1 AS emp LEFT JOIN t2 AS lr USING (siteid, rate_code) WHERE emp.emp_id = 'psmith' AND lr.siteid = 'rivercats'; rate_code base_rate ! cust 20 SELECT emp.rate_code, lr.base_rate FROM t1 AS emp LEFT JOIN t2 AS lr USING (siteid, rate_code) WHERE lr.siteid = 'rivercats' AND emp.emp_id = 'psmith'; rate_code base_rate ! cust 20 SELECT rate_code, lr.base_rate FROM t1 AS emp LEFT JOIN t2 AS lr USING (siteid, rate_code) WHERE emp.emp_id = 'psmith' AND siteid = 'rivercats'; rate_code base_rate ! cust 20 SELECT rate_code, lr.base_rate FROM t1 AS emp LEFT JOIN t2 AS lr USING (siteid, rate_code) WHERE siteid = 'rivercats' AND emp.emp_id = 'psmith'; rate_code base_rate ! cust 20 drop table t1,t2; CREATE TABLE t1 (ID INTEGER NOT NULL PRIMARY KEY, Value1 VARCHAR(255)); CREATE TABLE t2 (ID INTEGER NOT NULL PRIMARY KEY, Value2 VARCHAR(255)); --- 276,291 ---- INSERT INTO t2 VALUES ('rivercats','cust',20); SELECT emp.rate_code, lr.base_rate FROM t1 AS emp LEFT JOIN t2 AS lr USING (siteid, rate_code) WHERE emp.emp_id = 'psmith' AND lr.siteid = 'rivercats'; rate_code base_rate ! cust 5.60519e-45 SELECT emp.rate_code, lr.base_rate FROM t1 AS emp LEFT JOIN t2 AS lr USING (siteid, rate_code) WHERE lr.siteid = 'rivercats' AND emp.emp_id = 'psmith'; rate_code base_rate ! cust 5.60519e-45 SELECT rate_code, lr.base_rate FROM t1 AS emp LEFT JOIN t2 AS lr USING (siteid, rate_code) WHERE emp.emp_id = 'psmith' AND siteid = 'rivercats'; rate_code base_rate ! cust 5.60519e-45 SELECT rate_code, lr.base_rate FROM t1 AS emp LEFT JOIN t2 AS lr USING (siteid, rate_code) WHERE siteid = 'rivercats' AND emp.emp_id = 'psmith'; rate_code base_rate ! cust 5.60519e-45 drop table t1,t2; CREATE TABLE t1 (ID INTEGER NOT NULL PRIMARY KEY, Value1 VARCHAR(255)); CREATE TABLE t2 (ID INTEGER NOT NULL PRIMARY KEY, Value2 VARCHAR(255)); How to repeat: build using the scripts above and run the test with switches listed above.