Re: 3.23.43 fails merge and some rpl tests on HPUX 10.20
Since I sent this, I've noticed two things: 1. Somewhere in the process of reporting and working around problems in the build process, I lost a few recommended CXXFLAGS. I started over from scratch, so mysqlbug now reports Compilation info: CC='gcc' CFLAGS='-DHPUX -I/opt/dce/include' CXX='gcc' CXXFLAGS='-DHPUX -I/opt/dce/include -felide-constructors -fno-exceptions -fno-rtti' LDFLAGS='' (Everything else is the same). The test results remain identical, however. 2. I noticed the following in mysql-test/var/tmp/mysqltest-time: /scr/src/mysql-3.23.43/client/mysqltest: At line 6: query 'load data infile '../../std_data/words.dat' into table t1' failed: 1085: The file '../../std_data/words.dat' must be in the database directory or be readable by all after I ran test rpl01. So, I ran `chmod -R o+r std_data`, then reran the failed tests. With this change, tests rpl01, rpl04, and rpl07 now pass. Test merge still fails, however, and the remaining rpl tests (2, 11, 14, mystery22, and sporadic_master) still hang. I'd suggest that configure/make should ensure that all needed permissions are correct. Michael On Tue, 30 Oct 2001, Michael Stassen wrote: Description: Configured and built mysql 3.23.43 without errors on a 9000/782 running HPUX 10.20. All tests pass except: merge [ fail ] rpl01 [ fail ] rpl02 hangs rpl04 [ fail ] prl07 [ fail ] rpl11 hangs rpl14 hangs rpl_mystery22 hangs rpl_sporadic_master hangs Tests rpl 1, 4, and 7 fail with no additional output. The remaining rpl tests seem to just hang, with no output after the lines TEST USER SYSTEM ELAPSEDRESULT I let rpl 2 run for 7 hours, aborted 11 after 30 minutes, and gave up on the rest after about 5 minutes each. Merge fails with: - $./mysql-test-run --local merge Installing Test Databases Removing Stale Files Installing Master Databases 011030 18:04:33 ../sql/mysqld: Shutdown Complete Installing Slave Databases 011030 18:04:33 ../sql/mysqld: Shutdown Complete Starting MySQL daemon Loading Standard Test Databases Starting Tests TEST USER SYSTEM ELAPSEDRESULT merge [ fail ] Below are the diffs between actual and expected results: --- *** r/merge.result Wed Oct 3 19:21:17 2001 --- r/merge.reject Tue Oct 30 18:04:41 2001 *** *** 6,15 2 table 3 t2 a b ! 3 t1 ! 3 t2 ! 2 table ! 2 table 1 Testing 1 Testing table typepossible_keys key key_len ref rowsExtra --- 6,15 2 table 3 t2 a b ! 1 Testing ! 1 Testing ! 1 Testing ! 1 Testing 1 Testing 1 Testing table typepossible_keys key key_len ref rowsExtra *** *** 106,114 incr othr incr othr 1 10 ! 2 24 ! 4 33 ! 3 53 count(*) 10 count(*) --- 106,114 incr othr incr othr 1 10 ! 1 10 ! 1 10 ! 1 10 count(*) 10 count(*) --- Please follow the instructions outlined at http://www.mysql.com/doc/R/e/Reporting_mysqltest_bugs.html to find the reason to this problem and how to report this. Aborting. To continue, re-run with '--force'. Ending Tests Shutting-down MySQL daemon Master shutdown finished Slave shutdown finished - I've seen this exact output reported by others (running Solaris 2.5.1 and Linux, if I recall correctly), but have not seen any resolution. On a side note, mysql-test-run was determined to use /bin/diff, which doesn't support '-a' on my system, rather than /usr/local/bin/diff. I had to edit the script to set DIFF in order to get the output above. I didn't see any mention of the need to do this, or a better method, in the documentation. How-To-Repeat: build for hpux 10.20, run 'make test' or run './mysql-test-run --local testname' in mysql-test. Fix: Unknown Submitter-Id:submitter ID Originator: Michael Stassen Organization: Indiana University MySQL support: none Synopsis:3.23.43 fails merge and some rpl tests on HPUX 10.20 Severity:serious Priority:medium Category:mysql Class: sw-bug Release: mysql-3.23.43 (Source distribution) Environment: System: HP-UX dr B.10.20 A 9000/782 2015374635 two-user license Some paths: /usr/local/bin/perl /usr/local/bin/make /usr
3.23.43 fails merge and some rpl tests on HPUX 10.20
Description: Configured and built mysql 3.23.43 without errors on a 9000/782 running HPUX 10.20. All tests pass except: merge [ fail ] rpl01 [ fail ] rpl02 hangs rpl04 [ fail ] prl07 [ fail ] rpl11 hangs rpl14 hangs rpl_mystery22 hangs rpl_sporadic_master hangs Tests rpl 1, 4, and 7 fail with no additional output. The remaining rpl tests seem to just hang, with no output after the lines TEST USER SYSTEM ELAPSEDRESULT I let rpl 2 run for 7 hours, aborted 11 after 30 minutes, and gave up on the rest after about 5 minutes each. Merge fails with: - $./mysql-test-run --local merge Installing Test Databases Removing Stale Files Installing Master Databases 011030 18:04:33 ../sql/mysqld: Shutdown Complete Installing Slave Databases 011030 18:04:33 ../sql/mysqld: Shutdown Complete Starting MySQL daemon Loading Standard Test Databases Starting Tests TEST USER SYSTEM ELAPSEDRESULT merge [ fail ] Below are the diffs between actual and expected results: --- *** r/merge.result Wed Oct 3 19:21:17 2001 --- r/merge.reject Tue Oct 30 18:04:41 2001 *** *** 6,15 2 table 3 t2 a b ! 3 t1 ! 3 t2 ! 2 table ! 2 table 1 Testing 1 Testing table typepossible_keys key key_len ref rowsExtra --- 6,15 2 table 3 t2 a b ! 1 Testing ! 1 Testing ! 1 Testing ! 1 Testing 1 Testing 1 Testing table typepossible_keys key key_len ref rowsExtra *** *** 106,114 incr othr incr othr 1 10 ! 2 24 ! 4 33 ! 3 53 count(*) 10 count(*) --- 106,114 incr othr incr othr 1 10 ! 1 10 ! 1 10 ! 1 10 count(*) 10 count(*) --- Please follow the instructions outlined at http://www.mysql.com/doc/R/e/Reporting_mysqltest_bugs.html to find the reason to this problem and how to report this. Aborting. To continue, re-run with '--force'. Ending Tests Shutting-down MySQL daemon Master shutdown finished Slave shutdown finished - I've seen this exact output reported by others (running Solaris 2.5.1 and Linux, if I recall correctly), but have not seen any resolution. On a side note, mysql-test-run was determined to use /bin/diff, which doesn't support '-a' on my system, rather than /usr/local/bin/diff. I had to edit the script to set DIFF in order to get the output above. I didn't see any mention of the need to do this, or a better method, in the documentation. How-To-Repeat: build for hpux 10.20, run 'make test' or run './mysql-test-run --local testname' in mysql-test. Fix: Unknown Submitter-Id: submitter ID Originator:Michael Stassen Organization: Indiana University MySQL support: none Synopsis: 3.23.43 fails merge and some rpl tests on HPUX 10.20 Severity: serious Priority: medium Category: mysql Class: sw-bug Release: mysql-3.23.43 (Source distribution) Environment: System: HP-UX dr B.10.20 A 9000/782 2015374635 two-user license Some paths: /usr/local/bin/perl /usr/local/bin/make /usr/local/bin/gcc /usr/ccs/bin/cc GCC: Reading specs from /usr/local/lib/gcc-lib/hppa2.0-hp-hpux10.20/2.95.3/specs gcc version 2.95.3 20010315 (release) Compilation info: CC='gcc' CFLAGS='-DHPUX -I/opt/dce/include -I/usr/local/include -O2' CXX='gcc' CXXFLAGS='-DHPUX -I/opt/dce/include -I/usr/local/include -O2' LDFLAGS='-L/usr/local/lib' LIBC: -r-xr-xr-x1 bin bin 1867776 May 2 16:51 /lib/libc.1 -r--r--r--1 bin bin 2456780 May 2 16:51 /lib/libc.a lrwx--1 root sys15 Oct 17 12:29 /lib/libc.sl - /usr/lib/libc.1 -r-xr-xr-x1 bin bin 1867776 May 2 16:51 /usr/lib/libc.1 -r--r--r--1 bin bin 2456780 May 2 16:51 /usr/lib/libc.a lrwx--1 root sys15 Oct 17 12:29 /usr/lib/libc.sl - /usr/lib/libc.1 Configure command: ./configure --disable-largefile --with-pthread --with-named-thread-libs=-ldce --disable-shared --prefix=/usr/local/mysql --with-mysqld-user=mysql --libexecdir=/usr/local/mysql/sbin --datadir=/usr/local/mysql/data --with-libwrap - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e
