'Re: 3.23.43 fails merge and some rpl tests on HPUX 10.20'

[prev in list] [next in list] [prev in thread] [next in thread] 

List:       mysql
Subject:    Re: 3.23.43 fails merge and some rpl tests on HPUX 10.20
From:       Michael Stassen <stassenm () indiana ! edu>
Date:       2001-10-31 20:53:26
[Download RAW message or body]


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 rpl000001.  So, I ran `chmod -R o+r std_data`, then reran
the failed tests.  With this change, tests rpl000001, rpl000004, and
rpl000007 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 ]
> rpl000001              [ fail ]
> rpl000002               hangs
> rpl000004              [ fail ]
> prl000007              [ fail ]
> rpl000011               hangs
> rpl000014               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  ELAPSED        RESULT
> ------------------------------------------------------------------------
> 
> 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  ELAPSED        RESULT
> ------------------------------------------------------------------------
> 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 type    possible_keys   key     key_len ref     rows    Extra
> --- 6,15 ----
> 2     table
> 3     t2
> a     b
> ! 1     Testing
> ! 1     Testing
> ! 1     Testing
> ! 1     Testing
> 1     Testing
> 1     Testing
> table type    possible_keys   key     key_len ref     rows    Extra
> ***************
> *** 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-x    1 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     sys            15 Oct 17 12:29 /lib/libc.sl -> \
>                 /usr/lib/libc.1
> -r-xr-xr-x    1 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     sys            15 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 <mysql-thread89429@lists.mysql.com>
> To unsubscribe, e-mail <mysql-unsubscribe-stassenm=indiana.edu@lists.mysql.com>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
> 



---------------------------------------------------------------------
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 <mysql-thread89660@lists.mysql.com>
To unsubscribe, e-mail <mysql-unsubscribe-mysql=progressive-comp.com@lists.mysql.com>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php


[prev in list] [next in list] [prev in thread] [next in thread]
Configure | About | News | Add a list | Sponsored by KoreLogic