| Bug #5522 | Test 'ps_2myisam' fails, --debug makes server crash | ||
|---|---|---|---|
| Submitted: | 10 Sep 2004 21:55 | Modified: | 15 Sep 2004 17:04 |
| Reporter: | Joerg Bruehe | Email Updates: | |
| Status: | Closed | Impact on me: | |
| Category: | MySQL Server: Compiling | Severity: | S1 (Critical) |
| Version: | 4.1.5 | OS: | SunOS 5.8 / x86 |
| Assigned to: | Lenz Grimmer | CPU Architecture: | Any |
[14 Sep 2004 22:45]
Konstantin Osipov
I wasn't able to repeat the problem in debug build: CC=gcc CXX=gcc ./configure --with-debug --without-bdb --without-innodb --without-ndbcluster mysqldev@intelxeon3:~/kostja/mysql-4.1.5-gamma/mysql-test> ./mysql-test-run --force t/ps* Installing Test Databases Removing Stale Files Installing Master Databases running ../sql/mysqld --no-defaults --bootstrap --skip-grant-tables --basedir=. --datadir=./var/master-data --skip-innodb --skip-ndbcluster --skip-bdb --language=../sql/share/english/ --character-sets-dir=../sql/share/charsets/ Installing Slave Databases running ../sql/mysqld --no-defaults --bootstrap --skip-grant-tables --basedir=. --datadir=./var/slave-data --skip-innodb --skip-ndbcluster --skip-bdb --language=../sql/share/english/ --character-sets-dir=../sql/share/charsets/ Manager disabled, skipping manager start. Loading Standard Test Databases Starting Tests TEST RESULT ------------------------------------------ ps [ fail ] Errors are (from /export/home/mysqldev/kostja/mysql-4.1.5-gamma/mysql-test/var/log/mysqltest-time) : /export/home/mysqldev/kostja/mysql-4.1.5-gamma/client/.libs/mysqltest: At line 114: query 'set @str2 = convert(@str1 using ucs2)' failed: 1115: Unknown character set: 'ucs2' (the last lines may be the most important ones) Ending Tests Shutting-down MySQL daemon Master shutdown finished Slave shutdown finished Resuming Tests ps_1general [ pass ] ps_2myisam [ pass ] ps_3innodb [ skipped ] ps_4heap [ pass ] ps_5merge [ pass ] ps_6bdb [ skipped ] ------------------------------------------ Ending Tests Shutting-down MySQL daemon Master shutdown finished Slave shutdown finished Failed 1/5 tests, 80.0% successful. The log files in /export/home/mysqldev/kostja/mysql-4.1.5-gamma/mysql-test/var/log may give you some hint of what when wrong. If you want to report this error, please read first the documentation at http://www.mysql.com/doc/en/MySQL_test_suite.html mysqldev@intelxeon3:~/kostja/mysql-4.1.5-gamma/mysql-test>
[15 Sep 2004 11:02]
Konstantin Osipov
I'm closing the bug, please reopen if the problem is still there: bk commit - 4.1 tree (konstantin:1.2013)
[15 Sep 2004 17:04]
Lenz Grimmer
The test suite failure was fixed in the meanwhile: ChangeSet@1.2014, 2004-09-15 14:25:58+04:00, konstantin@mysql.com Fix the test case to make it more predictable (cause: 4.1.5 test failure on intelxeon3 (Solaris x86)) The crashes of the binaries seems to be a local configuration problem - the dynamic linker does not find the required libgcc shared lib which causes the binary to crash (instead of giving a more helpful error message)
Description: On build host 'intelxeon3', version 4.1.5 fails in test 'ps_2myisam' by giving select results in different order: ------------------------------------------------------- *** r/ps_2myisam.result Thu Sep 9 22:26:18 2004 --- r/ps_2myisam.reject Sat Sep 11 00:48:14 2004 *************** *** 399,410 **** a @arg00 a 1 ABC 1 2 ABC 1 - 3 ABC 1 - 4 ABC 1 2 ABC 2 2 ABC 3 - 3 ABC 3 2 ABC 4 4 ABC 4 prepare stmt1 from ' select first.a, ?, second.a FROM t1 first, t1 second where ? = first.b or first.a = second.a or second.b = ? '; --- 399,410 ---- a @arg00 a 1 ABC 1 2 ABC 1 2 ABC 2 2 ABC 3 2 ABC 4 + 3 ABC 1 + 3 ABC 3 + 4 ABC 1 4 ABC 4 prepare stmt1 from ' select first.a, ?, second.a FROM t1 first, t1 second where ? = first.b or first.a = second.a or second.b = ? '; *************** *** 412,423 **** a ? a 1 ABC 1 2 ABC 1 - 3 ABC 1 - 4 ABC 1 2 ABC 2 2 ABC 3 - 3 ABC 3 2 ABC 4 4 ABC 4 test_sequence ------ subquery tests ------ --- 412,423 ---- a ? a 1 ABC 1 2 ABC 1 2 ABC 2 2 ABC 3 2 ABC 4 + 3 ABC 1 + 3 ABC 3 + 4 ABC 1 4 ABC 4 test_sequence ------ subquery tests ------ ------------------------------------------------------- I then tried to run the test with '--debug', this causes the server to crash: TEST RESULT ------------------------------------------ ps_2myisam [ fail ] Errors are (from /export/home/mysqldev/intelxeon3/mysql-4.1.5-gamma/mysql-test/var/log/mysqltest-time) : /export/home/mysqldev/intelxeon3/mysql-4.1.5-gamma/client/mysqltest: At line 26: query 'insert into t_many_col_types set c1= 9, c2= 9, c3= 9, c4= 9, c5= 9, c6= 9, c7= 9, c8= 9, c9= 9, c10= 9, c11= 9, c12 = 9, c13= '2004-02-29', c14= '2004-02-29 11:11:11', c15= '2004-02-29 11:11:11', c16= '11:11:11', c17= '2004', c18= 1, c19=false, c20= 'a', c21= '123456789a', c22= '123456789a123456789b123456789c', c23= 'tinyblob', c24= 'tinytext', c25= 'blob', c26= 'text', c27= 'mediumblob', c28= 'mediumtext', c29= 'longblob', c30= 'longtext', c31='two', c32= 'tuesday'' failed: 2013: Lost connection to MySQL server during query (the last lines may be the most important ones) This blocks building on that host. The error has not (yet?) been observed on other platforms. How to repeat: Run the test (suite).