>Description: I'm running HPUX 10.20 on a 9000/782. I configured
according to section 2.6.6.2, HP-UX Version 10.20 Notes (see below).
make test warns that setrlimit fails, then fails the join test,
presumably because it requires more than 60 files. (Full output below)
It appears that getrlimit/setrlimit, called by mysqld, produce
garbage, at least on my system, when mysqld is built with largefile
support.
Here's the 'make test' output:
$make test
cd mysql-test ; ./mysql-test-run
Installing Test Databases
Removing Stale Files
Installing Master Databases
011030 1:43:53 Warning: setrlimit couldn't increase number of open files to more
than 60
011030 1:43:53 Warning: Changed limits: max_connections: 50 table_cache: 64
011030 1:43:53 ../sql/mysqld: Shutdown Complete
Installing Slave Databases
011030 1:43:53 Warning: setrlimit couldn't increase number of open files to more
than 60
011030 1:43:53 Warning: Changed limits: max_connections: 50 table_cache: 64
011030 1:43:53 ../sql/mysqld: Shutdown Complete
Starting MySQL daemon
Loading Standard Test Databases
Starting Tests
TEST USER SYSTEM ELAPSED RESULT
------------------------------------------------------------------------
alias 0.0 0.0 0.1 [ pass ]
alter_table 0.0 0.0 0.9 [ pass ]
analyse 0.0 0.0 0.1 [ pass ]
auto_increment 0.0 0.0 0.3 [ pass ]
backup 0.0 0.0 0.1 [ pass ]
bdb-crash 0.0 0.0 0.0 [ pass ]
bdb .... .... .... [ skipped ]
bench_count_distinct 0.0 0.0 0.2 [ pass ]
bigint 0.0 0.0 0.0 [ pass ]
binary 0.0 0.0 0.0 [ pass ]
case 0.0 0.0 0.0 [ pass ]
check 0.9 0.5 13.5 [ pass ]
comments 0.0 0.0 0.0 [ pass ]
compare 0.0 0.0 0.0 [ pass ]
count_distinct 0.0 0.0 0.1 [ pass ]
create 0.0 0.0 0.1 [ pass ]
delayed 0.0 0.0 3.0 [ pass ]
delete 0.0 0.0 0.0 [ pass ]
dirty-close 0.0 0.0 0.0 [ pass ]
distinct 0.0 0.0 0.4 [ pass ]
drop 0.0 0.0 0.1 [ pass ]
empty_table 0.0 0.0 0.0 [ pass ]
err000001 0.0 0.0 0.0 [ pass ]
explain 0.0 0.0 0.0 [ pass ]
flush 0.0 0.0 0.3 [ pass ]
flush_table 0.0 0.0 0.0 [ pass ]
foreign_key 0.0 0.0 0.1 [ pass ]
fulltext 0.0 0.0 0.1 [ pass ]
fulltext_cache 0.0 0.0 0.0 [ pass ]
fulltext_left_join 0.0 0.0 0.0 [ pass ]
fulltext_multi 0.0 0.0 0.0 [ pass ]
fulltext_order_by 0.0 0.0 0.0 [ pass ]
fulltext_update 0.0 0.0 0.0 [ pass ]
func_crypt 0.0 0.0 0.0 [ pass ]
func_date_add 0.0 0.0 0.0 [ pass ]
func_equal 0.0 0.0 0.0 [ pass ]
func_group 0.0 0.0 0.1 [ pass ]
func_in 0.0 0.0 0.0 [ pass ]
func_like 0.0 0.0 0.0 [ pass ]
func_math 0.0 0.0 0.0 [ pass ]
func_misc 0.0 0.0 0.0 [ pass ]
func_op 0.0 0.0 0.0 [ pass ]
func_regexp 0.0 0.0 0.0 [ pass ]
func_set 0.0 0.0 0.0 [ pass ]
func_str 0.0 0.0 0.9 [ pass ]
func_system 0.0 0.0 0.0 [ pass ]
func_test 0.0 0.0 0.0 [ pass ]
func_time 0.0 0.0 0.1 [ pass ]
func_timestamp 0.0 0.0 0.0 [ pass ]
gemini .... .... .... [ skipped ]
group_by 0.0 0.0 0.2 [ pass ]
having 0.0 0.0 0.0 [ pass ]
heap 0.0 0.0 0.4 [ pass ]
identity 0.0 0.0 0.0 [ pass ]
innodb .... .... .... [ skipped ]
ins000001 0.0 0.0 0.0 [ pass ]
insert 0.0 0.0 0.0 [ pass ]
insert_select 0.0 0.0 0.0 [ pass ]
isam 0.0 0.0 4.7 [ pass ]
isolation .... .... .... [ skipped ]
join .... .... .... [ fail ]
Aborting. To continue, re-run with '--force'.
Ending Tests
Shutting-down MySQL daemon
Master shutdown finished
Slave shutdown finished
make: *** [test] Error 1
>How-To-Repeat:
Build according to instructions for HP-UX, then run make test.
>Fix:
add --disable-largefile to ./configure options.
I note that every usenet post on building mysql for HPUX 10.20 rI
could find ecommends this. Perhaps the HP-UX Version 10.20 Notes
should mention this, or, better yet, configure should take care of it.
>Submitter-Id: <submitter ID>
>Originator: Michael Stassen
>Organization: Indiana University
>MySQL support: none
>Synopsis: --disable-largefile needed in HPUX 10.20
>Severity: serious
>Priority: medium
>Category: mysql
>Class: sw-bug | doc-bug | change-request
>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' CXX='gcc'
CXXFLAGS='-DHPUX -I/opt/dce/include -felide-constructors -fno-exceptions -fno-rtti'
LDFLAGS=''
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 --with-pthread --with-named-thread-libs=-ldce
--prefix=/usr/local/mysql --disable-shared --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-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
