This has come up before. In fact, I had the exact same problem. You can see the the thread "Coredump when running scripts/mysql_install_db " at
http://lists.mysql.com/cgi-ez/ezmlm-cgi?1:msp:93051 The conclusion is in "Problem with setrlimit on HPUX 10.20" at http://lists.mysql.com/cgi-ez/ezmlm-cgi?1:msn:94565 In short, HP-UX 10.20 has a bug in dce/cma_ux.h which breaks setrlimit when largefiles is enabled. If I understood him correctly, Monty (Michael Widenius) acknowledged that his copy of HP-UX 10.20 has this flaw, but he says his copy of the official binary works there, though I honestly cannot see how. In my case, I didn't need largefile support, so my workaround was to compile MySQL from source, adding --disable-largefile to the options recommended in the manual. Ideally, the solution would be for HP-UX to fix dce/cma_ux.h as Monty described. Michael On Mon, 8 Apr 2002, Clarence W. Robison wrote: > > > >Description: > 1. Distributed Binary version crashes with scripts/mysql_install_db > vvvvvvvvvvvvvvvvvvvvvvvvvvvv Output vvvvvvvvvvvvvvvvvvvvvvvvvvvvvvv > Preparing db table > Preparing host table > Preparing user table > Preparing func table > Preparing tables_priv table > Preparing columns_priv table > Installing all prepared tables > 020403 14:17:44 Warning: setrlimit couldn't increase number of open files to > more than 60 > 020403 14:17:44 Warning: Changed limits: max_connections: 50 table_cache: > 64 > scripts/mysql_install_db[292]: 422 Memory fault(coredump) > Installation of grant tables failed! > > Examine the logs in ./data for more information. > <!-- Contents of ./data/water.log: --> > ./bin/mysqld, Version: 3.23.49-log, started with: > Tcp port: 3306 Unix socket: /tmp/mysql.sock > Time Id Command Argument > > > ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ > >How-To-Repeat: > > >Fix: > > > >Submitter-Id: <submitter ID> > >Originator: > >Organization: > > >MySQL support: [none | licence | email support | extended email support ] > >Synopsis: Severity: Priority: Category: mysql Class: > >Release: mysql-3.23.49 (Official MySQL binary) > > >Environment: **** This dump from the binary distributed mysqlbug **** > > System: HP-UX water B.10.20 A 9000/715 2004349860 two-user license > > Some paths: /usr/bin/perl /opt/binutils/bin/make /opt/gcc/bin/gcc > /usr/bin/cc > GCC: Reading specs from /opt/gcc/lib/gcc-lib/hppa1.1-hp-hpux10.20/3.0.4/specs > Configured with: ./configure : (reconfigured) ./configure : (reconfigured) > ./configure > Thread model: single gcc version 3.0.4 > Compilation info: > CC='gcc' > CFLAGS='-DHPUX -I/opt/dce/include -O3' > CXX='gcc' > CXXFLAGS='-DHPUX -I/opt/dce/include -felide-constructors -fno-exceptions -fno- > rtti -O3 ' > LDFLAGS='' > LIBC: > -r-xr-xr-x 1 bin bin 1863680 Nov 10 1999 /lib/libc.1 > -r--r--r-- 1 bin bin 2456532 Nov 10 1999 /lib/libc.a > lrwxr-xr-x 1 root sys 15 Jun 10 1996 /lib/libc.sl -> > /usr/lib/libc.1 > -r-xr-xr-x 1 bin bin 1863680 Nov 10 1999 /usr/lib/libc.1 > -r--r--r-- 1 bin bin 2456532 Nov 10 1999 /usr/lib/libc.a > lrwxr-xr-x 1 root sys 15 Jun 10 1996 /usr/lib/libc.sl -> > /usr/lib/libc.1 > > Configure command: ./configure --prefix=/usr/local/mysql '--with- > comment=Official MySQL binary' > --with-extra-charsets=complex --with-server-suffix= > --enable-thread-safe-client --with-pthread --with-named-thread-libs=-ldce > --with-lib-ccflags=-fpic --disable-shared-- > Clarence W. Robison, P.E. > [EMAIL PROTECTED] > --------------------------------------------------------------------- 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