I'm trying to move our webserver with MySQL 3.22.32 from a slow AIX 4330-09 box to a somewhat faster one with 4330-10. Though not heavily used, the 3.22.32 has worked like a charm for several years in a chroot:ed environment. It seems that we've forgotten to update the libraries (e.g. libpthreads.a) in the chroot, which might be relevant.
Moving the Apache server was easy, and at first it appeared that MySQL worked OK too. Unfortunately this is not true for networked connections, only for local connections (not using TCP). We downloaded MySQL 3.23.53, which appears to work partially, but not for TCP connections. It's own log file says:
mysqld got signal 11;
This could be because you hit a bug. It is also possible that this binary
or one of the libraries it was linked agaist is corrupt, improperly built,
or misconfigured. This error can also be caused by malfunctioning hardware.
We will try our best to scrape up some info that will hopefully help diagnose
the problem, but since we have already crashed, something is definitely wrong
and this may fail
key_buffer_size=8388600
record_buffer=131072
sort_buffer=2097144
max_used_connections=0
max_connections=100
threads_connected=1
It is possible that mysqld could use up to key_buffer_size + (record_buffer + sort_buffer)*max_connections = 225791 K
bytes of memory
Hope that's ok, if not, decrease some variables in the equation
021216 19:20:34 mysqld restarted
/usr/local/mysql/libexec/mysqld: ready for connections
and the operating system (errpt) reports:
Detail Data
SIGNAL NUMBER
11
USER'S PROCESS ID:
25276
FILE SYSTEM SERIAL NUMBER
32
INODE NUMBER
41984
PROGRAM NAME
mysqld
ADDITIONAL INFORMATION
_doprnt 20
sprintf 68
ho_byaddr 284
ho_byaddr 1BC
gethostby 12C
_Z14ip_to 100
_Z17check D0
_Z21handl F4
_pthread_ D4
??
Symptom Data
REPORTABLE
1
INTERNAL ERROR
0
/etc/netsvc.conf says
hosts = local , bind
I tried to download MySQL 3.23.35 from www.bull.com, on a different machine (AIX 4300-09, running MySQL in the real root). A simple test 'telnet localhost 3306' gives:
/usr/local/bin/safe_mysqld[222]: 29488 Segmentation fault(coredump)
030103 17:27:14 mysqld restarted
and a core file revealing the following calling sequence:
is_data_there()
ho_byaddr()
ho_byaddr()
gethostbyaddr()
ip_to_hostname__FP7in_addrPUi()
check_connections_FP3THD()
handle_one_connection__FPV()
This system lacks /etc/netsvc.conf (using default values).
In yet another attempt I tried to compile MySQL from source, but I'm sorry to say that this too failed for me:
.
.
.
Making all in client
make[2]: Entering directory `/usr/local/src/mysql-3.23.54a/client'
source='mysql.cc' object='mysql.o' libtool=no \
depfile='.deps/mysql.Po' tmpdepfile='.deps/mysql.TPo' \
depmode=aix /bin/sh ../depcomp \
xlC_r -ma -O -qmaxmem=8192 -DUNDEF_THREADS_HACK -I. -I. -I.. -I./../include -I../include -I./.. -I.. -I.. -I/usr/local/include -DHAVE_INT_8_16_32 -DHAVE_GETHOSTBYNAME_R_RETURN_INT=1 -O3 -DDBUG_OFF -I/usr/local/include -DHAVE_INT_8_16_32 -DHAVE_GETHOSTBYNAME_R_RETURN_INT=1 -Wa,-many -DUNDEF_HAVE_INITGROUPS -DSIGNALS_DONT_BREAK_READ -c -o mysql.o `test -f mysql.cc || echo './'`mysql.cc
Unable to retrieve messagemake[2]: *** [mysql.o] Error 1
make[2]: Leaving directory `/usr/local/src/mysql-3.23.54a/client'
make[1]: *** [all-recursive] Error 1
make[1]: Leaving directory `/usr/local/src/mysql-3.23.54a'
make: *** [all] Error 2
I'm using version 3.1.4.9 of the C++ component of xlC, and 3.1.4.10 of C. Both machines produce the same result. I've used the settings suggested in the MySQL manual as well as the hints provied by Bull's freeware team, with the same end result. I understand that the messagemake-problem has been reported in the past, but I'm not sure what to do anyway. If configure is asked to use gcc instead, it looks for MIT Pthreads in an eternal loop.
Any suggestions are greatly appreciated.
Best regards,
Lars-Owe
---------------------------------------------------------------------
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
