Steven,
I had an experience the other day in a controlled test environment that appears
to be similar. An advantage is that i know precisely what was taking place.
Consider the following:
1) A servlet makes a single 'insert delayed' into a relation. (no auto increment
field - and just a simple primary key char(16) )
2) Shortly afterwards the same servlet attempts to see if the record has been
added.
3a) On occasions that it finds it, all continues just fine.
3b) When it is not found the transaction continues normally but the delayed
insert NEVER occurs. Furthermore if a further attempt is made to make another
insert delayed on the same relation this also never occurs.
In the case 3b (which only happens occasionally - not most of the time) i
presume the thread handling the inserts has become jammed in some way.
Regards,
Dave.
Steven Roussey wrote:
> 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
---------------------------------------------------------------------
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
