>Description:
## After building mysql and installing the GRANT tables I start the daemon
## and then try to run the mysql client to alter the GRANT tables to a
## useful configuration. Subcommands like connect and use seem to work
## ok, but if I try entering anything else, even a single character, I get
## a core dump. Following is screen output from a session run via gdb:
watts:/usr/local/mysql/bin $ gdb mysql
GNU gdb 5.0
Copyright 2000 Free Software Foundation, Inc.
.......
(gdb) run -uroot -p mysql
Starting program: /usr/local/mysql/bin/mysql -uroot -p mysql
Enter password:
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 1 to server version: 3.23.47-log
Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
mysql> show table
Program received signal SIGSEGV, Segmentation fault.
0xe0002fa0 in ?? () from (unknown load module)
(gdb) q
The program is running. Exit anyway? (y or n) y
## If I then try to shutdown the server, which is PID 46736:
watts:/usr/local/mysql/bin $ ps
PID TTY TIME CMD
43818 pts/22 0:00 sh safe_mysqld --log
46736 pts/22 0:00 /usr/local/mysql/libexec/mysqld --basedir=/usr/local/mysql
53986 pts/22 0:00 -ksh
58540 pts/22 0:00 ps
watts:/usr/local/mysql/bin $ mysqladmin -uroot -p shutdown
Enter password:
## mysqladmin just sits at this point until I break out.....
^CWarning; Aborted waiting on pid file: '/u/dev/mysql/watts.pid' after 54 seconds
## I then try shutting down again, this time apparently with success, but ....
watts:/usr/local/mysql/bin $ mysqladmin -uroot -p shutdown
Enter password:
watts:/usr/local/mysql/bin $
watts:/usr/local/mysql/bin $
watts:/usr/local/mysql/bin $ ps
PID TTY TIME CMD
43818 pts/22 0:00 sh safe_mysqld --log
46736 pts/22 0:00 /usr/local/mysql/libexec/mysqld --basedir=/usr/local/mysql
53986 pts/22 0:00 -ksh
57260 pts/22 0:00 ps
## the process is still there.
## Following is the contents of the log file:
/usr/local/mysql/libexec/mysqld, Version: 3.23.47-log, started with:
Tcp port: 3306 Unix socket: /var/mysql/sock/mysql.sock
Time Id Command Argument
020104 19:37:23 1 Connect root@localhost on mysql
1 Query show databases
1 Query show tables
1 Field List columns_priv
1 Field List db
1 Field List func
1 Field List host
1 Field List tables_priv
1 Field List user
020104 19:39:28 2 Connect root@localhost on
2 Query SHOW VARIABLES LIKE 'pid_file'
2 Shutdown
020104 19:40:27 3 Connect root@localhost on
3 Query SHOW VARIABLES LIKE 'pid_file'
3 Shutdown
## ... and of the error log:
020104 19:36:59 mysqld started
Warning: One can only use the --user switch if running as root
/usr/local/mysql/libexec/mysqld: ready for connections
020104 19:40:27 mysqld: Got error 9 from select
020104 19:40:27 /usr/local/mysql/libexec/mysqld: Normal shutdown
020104 19:40:28 /usr/local/mysql/libexec/mysqld: Shutdown Complete
>How-To-Repeat:
This happens consistently. You don't need to use an actual SQL command to
crash the client
any string that is not a subcommand of the client seems to do it
>Fix:
<how to correct or work around the problem, if known (multiple lines)>
>Submitter-Id: <submitter ID>
>Originator:
>Organization:
<organization of PR author (multiple lines)>
>MySQL support: [none | licence | email support | extended email support ]
>Synopsis: <synopsis of the problem (one line)>
>Severity: <[ non-critical | serious | critical ] (one line)>
>Priority: <[ low | medium | high ] (one line)>
>Category: mysql
>Class: <[ sw-bug | doc-bug | change-request | support ] (one line)>
>Release: mysql-3.23.47 (Source distribution)
>Environment:
<machine, os, target, libraries (multiple lines)>
System: AIX watts 3 4 00600079C400
IBM rs/6000 7025-F30
AIX 4.3.3.0 Because I had read that there were problems with AIX's libc.a I
tried applying the
following fixes after first encountering the above problem. I did not rebuild
after applying the
fixes because I didn't know if it was necessary or useful.
bos.rte.bind_cmds.4.3.3.75.bff
bos.rte.libc.4.3.3.75.bff
bos.rte.libc.4.3.3.79.bff
bos.rte.libpthreads.4.3.3.75.bff
bos.rte.libpthreads.4.3.3.77.bff
Some paths: /usr/bin/perl /usr/bin/make /usr/local/bin/gcc
I used the GNU make program instead of IBM's - or thought I did. Does the above path
indicate
what was actually used or simply the default?
GCC: Reading specs from /usr/local/lib/gcc-lib/powerpc-ibm-aix4.3.2.0/2.95.3/specs
gcc version 2.95.3 20010315 (release)
Compilation info: CC='gcc -pipe -mcpu=604e -Wa,-many' CFLAGS='' CXX='g++ -pipe
-mcpu=604e -Wa,-many' CXXFLAGS='-felide-constructors -fno-exceptions -fno-rtti'
LDFLAGS=''
LIBC:
lrwxrwxrwx 1 bin bin 19 Jan 04 01:18 /lib/libc.a ->
/usr/ccs/lib/libc.a
lrwxrwxrwx 1 bin bin 19 Jan 04 01:18 /usr/lib/libc.a ->
/usr/ccs/lib/libc.a
Configure command: ./configure --prefix=/usr/local/mysql --with-low-memory
--with-unix-socket-path=/var/mysql/sock/mysql.sock
---------------------------------------------------------------------
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 <mysql-unsubscribe-##L=##[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
