Hi,
I was trying to use debugging (creating a trace and log file) in order to
find the crashing problem we have been experiencing. However, I tend to come
up against another problem in the course of things -- mysql not shutting
down.
This time I have a log file and a trace file. When I shut down, most of the
processes quit, but a few remain (exhibit A). At this point the log stops
(no additional info being written)(exhibit B), but the trace continues. Then
the trace file stops (exhibit C). Everything is on hold. So I have a trace
file, and log file that are not be written to, but still have processes
running. What is going on?
Sincerely,
Steven Roussey
Network54.com
http://network54.com/?pp=e
exhibit A:
11519 pts/2 S 0:00 /bin/sh ./bin/safe_mysqld --user=root -O
back_log=20 -O table_cache=3500 --log --debug=d,info,query
11567 pts/2 S 1:48
/usr/local/mysql/libexec/mysqld --basedir=/usr/local/mysql --datadir=/usr/lo
cal/mysql/var --user=ro
11569 pts/2 S 0:28
/usr/local/mysql/libexec/mysqld --basedir=/usr/local/mysql --datadir=/usr/lo
cal/mysql/var --user=ro
11570 pts/2 S 0:01
/usr/local/mysql/libexec/mysqld --basedir=/usr/local/mysql --datadir=/usr/lo
cal/mysql/var --user=ro
11597 pts/2 S 2:49
/usr/local/mysql/libexec/mysqld --basedir=/usr/local/mysql --datadir=/usr/lo
cal/mysql/var --user=ro
5391 pts/2 S 0:00 /usr/local/mysql/bin/mysqladmin shutdown
5405 pts/2 S 0:00
/usr/local/mysql/libexec/mysqld --basedir=/usr/local/mysql --datadir=/usr/lo
cal/mysql/var --user=ro
5546 pts/0 R 0:00 ps ax
Exhibit B:
# tail switch.network54.com.err -n20
010307 12:33:41 Aborted connection 87779 to db: 'logging' user: 'apache'
host: `tank.f' (Got timeout reading communication packets)
010307 12:33:41 Aborted connection 90741 to db: 'logging' user: 'apache'
host: `morpheus.f' (Got timeout reading communication packets)
010307 12:33:41 Aborted connection 90700 to db: 'logging' user: 'apache'
host: `mouse.f' (Got timeout reading communication packets)
010307 12:33:41 Aborted connection 90714 to db: 'logging' user: 'apache'
host: `neo.f' (Got timeout reading communication packets)
010307 12:33:41 Aborted connection 90722 to db: 'logging' user: 'apache'
host: `morpheus.f' (Got timeout reading communication packets)
010307 12:33:41 Aborted connection 90733 to db: 'logging' user: 'apache'
host: `morpheus.f' (Got timeout reading communication packets)
010307 12:33:41 Aborted connection 90736 to db: 'logging' user: 'apache'
host: `morpheus.f' (Got timeout reading communication packets)
010307 12:33:41 Aborted connection 90729 to db: 'logging' user: 'apache'
host: `neo.f' (Got timeout reading communication packets)
010307 12:33:41 Delayed insert thread couldn't get requested lock for table
log_day_20010307
010307 12:33:41 Aborted connection 72115 to db: 'logging' user: 'apache'
host: `neo.f' (Got an error writing communication packets)
010307 12:33:41 Aborted connection 70096 to db: 'logging' user: 'apache'
host: `mouse.f' (Got an error writing communication packets)
010307 12:33:41 Aborted connection 66934 to db: 'logging' user: 'apache'
host: `mouse.f' (Got an error writing communication packets)
010307 12:33:41 Aborted connection 56536 to db: 'logging' user: 'apache'
host: `mouse.f' (Got an error writing communication packets)
010307 12:33:41 Aborted connection 46514 to db: 'logging' user: 'apache'
host: `tank.f' (Got an error writing communication packets)
010307 12:33:41 Aborted connection 40577 to db: 'logging' user: 'apache'
host: `tank.f' (Got an error writing communication packets)
010307 12:33:41 Aborted connection 45130 to db: 'logging' user: 'apache'
host: `tank.f' (Got an error writing communication packets)
010307 12:33:41 Aborted connection 39806 to db: 'logging' user: 'apache'
host: `mouse.f' (Got an error writing communication packets)
010307 12:33:41 Aborted connection 39819 to db: 'logging' user: 'apache'
host: `tank.f' (Got an error writing communication packets)
010307 12:33:41 Aborted connection 39476 to db: 'logging' user: 'apache'
host: `tank.f' (Got an error writing communication packets)
010307 12:33:41 Aborted connection 30930 to db: 'logging' user: 'apache'
host: `neo.f' (Got an error writing communication packets)
Exhibit C:
# tail switch.trace -n50
_mi_bin_search: exit: flag: 1 keypos: 38
_mi_bin_search: exit: flag: 1 keypos: 78
_mi_bin_search: exit: flag: 1 keypos: 106
_mi_make_key: exit: keynr: 0
_mi_bin_search: exit: flag: 1 keypos: 0
_mi_bin_search: exit: flag: 1 keypos: 34
_mi_bin_search: exit: flag: 1 keypos: 2
_mi_bin_search: exit: flag: 1 keypos: 19
_mi_make_key: exit: keynr: 1
_mi_bin_search: exit: flag: 1 keypos: 19
_mi_bin_search: exit: flag: 1 keypos: 85
_mi_bin_search: exit: flag: 1 keypos: 113
my_malloc: exit: ptr: 42a00008
init_io_cache: info: init_io_cache: cachesize = 1048576
_mi_make_key: exit: keynr: 0
_mi_bin_search: exit: flag: 2 keypos: 1
_mi_bin_search: exit: flag: 1 keypos: 10
_mi_bin_search: exit: flag: 1 keypos: 22
_mi_bin_search: exit: flag: 1 keypos: 16
_mi_make_key: exit: keynr: 1
_mi_bin_search: exit: flag: 1 keypos: 19
_mi_bin_search: exit: flag: 1 keypos: 85
_mi_bin_search: exit: flag: 1 keypos: 114
_mi_make_key: exit: keynr: 0
_mi_bin_search: exit: flag: -2 keypos: 4
_mi_bin_search: exit: flag: 1 keypos: 11
_mi_bin_search: exit: flag: 1 keypos: 25
_mi_bin_search: exit: flag: 1 keypos: 66
_mi_make_key: exit: keynr: 1
_mi_bin_search: exit: flag: 1 keypos: 40
_mi_bin_search: exit: flag: 1 keypos: 79
_mi_bin_search: exit: flag: 1 keypos: 107
_mi_make_key: exit: keynr: 0
_mi_bin_search: exit: flag: -1 keypos: 4
_mi_bin_search: exit: flag: 1 keypos: 0
_mi_bin_search: exit: flag: 1 keypos: 10
_mi_bin_search: exit: flag: 1 keypos: 25
_mi_make_key: exit: keynr: 1
_mi_bin_search: exit: flag: 1 keypos: 38
_mi_bin_search: exit: flag: 1 keypos: 78
_mi_bin_search: exit: flag: 1 keypos: 107
_mi_make_key: exit: keynr: 0
_mi_bin_search: exit: flag: 1 keypos: 3
_mi_bin_search: exit: flag: 1 keypos: 12
_mi_bin_search: exit: flag: 1 keypos: 15
_mi_bin_search: exit: flag: 1 keypos: 12
_mi_make_key: exit: keynr: 1
_mi_bin_search: exit: flag: 1 keypos: 38
_mi_bin_search: exit: flag: 1 keypos: 78
_mi_bin_search: exit: flag: 1 keypos: 108
---------------------------------------------------------------------
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
