List:General Discussion« Previous MessageNext Message »
From:James Tyson Date:May 11 1999 9:32pm
Subject:Re: MySQL daemon mysteriously dieing.
View as plain text  
When I execute my script I get the following:

euclid:~/utils> ./optimize_table
DBD::mysql::st execute failed: Lost connection to MySQL server during
query at ./optimize_table line 10.
dieing: Lost connection to MySQL server during query

> In this case its very likely that MySQL is waiting on a disk full
> condition!

Filesystem         1024-blocks  Used Available Capacity Mounted on
/dev/hda2            3943284 1879155  1860104     50%   /

Somehow, I doubt it.

> - Check what MySQL is doing with 'mysqladmin proc'

euclid:~> mysqladmin proc
+-----+--------+-----------+--------+-----------+------+----------------+-------------------------------------------------------------------------------+
| Id  | User   | Host      | db     | Command   | Time | State          | Info
+-----+--------+-----------+--------+-----------+------+----------------+-------------------------------------------------------------------------------+
| 475 | euclid | localhost | euclid | Query     | 14   | Sorting result | select distinct
configuration, hostname, type, timestamp, status from configs |
| 481 | euclid | localhost |        | Processes | 0    |                |   
+-----+--------+-----------+--------+-----------+------+----------------+-------------------------------------------------------------------------------+

euclid:~> mysqladmin proc
mysqladmin: connect to server at 'localhost' failed
error: 'Can't connect to local MySQL server through socket
'/tmp/mysql.sock' (111)'
Check that mysqld is running and that the socket: '/tmp/mysql.sock'
exists!

> - Use 'top' to check that MySQL is running.

euclid:~# ps -aux | grep my 
root     16181  0.0  0.2   952   312  p2 S    09:19   0:00 grep my 

it just died.

> - Check the MySQL log files for any recent entries.

in /usr/local/var/euclid.err:

990512  9:17:51  Aborting
mysqld ended on  Wed May 12 09:17:51 NZST 1999

I can't find anything else anywhere.

> - Check the MySQL documentation, Section 'Debugging MySQL'.

basedir:     /usr/local/
datadir:     /usr/local/var/
tmpdir:      /tmp/
language:    /usr/local/share/mysql/english/
pid file:    /usr/local/var/euclid.pid
TCP port:    3306
Unix socket: /tmp/mysql.sock

system locking is not in use

Possible variables for option --set-variable (-O) are:
back_log              current value: 5
connect_timeout       current value: 5
delayed_insert_timeout  current value: 300
delayed_insert_limit  current value: 100
flush_time            current value: 0
join_buffer           current value: 131072
key_buffer            current value: 8388600
long_query_time       current value: 10
max_allowed_packet    current value: 1048576
max_connections       current value: 100
max_connect_errors    current value: 10
max_delayed_insert_threads  current value: 20
delayed_queue_size    current value: 1000
max_join_size         current value: 4294967295
max_sort_length       current value: 1024
net_buffer_length     current value: 16384
record_buffer         current value: 131072
sort_buffer           current value: 2097144
table_cache           current value: 64
tmp_table_size        current value: 1048576
thread_stack          current value: 65536
wait_timeout          current value: 28800

/usr/local/libexec/mysqld: ready for connections
Segmentation fault

--- SIGUSR1 (User defined signal 1) ---
<... sigsuspend resumed> )              = -1 EINTR (Interrupted system
call)
sigreturn()                             = ? (mask now [HUP QUIT USR1 TERM
TSTP])
oldselect(5, [3 4], NULL, NULL, NULL)   = ? ERESTARTNOHAND (To be
restarted)
--- SIGSEGV (Segmentation fault) ---
+++ killed by SIGSEGV +++


Thanks for your help Monty, but this is all I can find.

James Tyson         --          System Administrator - The Internet Group.
                                                          It's all good^Hf

Thread
mysql config & ISPBrian Clarkson10 May
  • Re: mysql config & ISPSasha Pachev10 May
    • MySQL daemon mysteriously dieing.James Tyson10 May
      • MySQL daemon mysteriously dieing.Michael Widenius11 May
        • Re: MySQL daemon mysteriously dieing.James Tyson12 May
  • Re: mysql config & ISPPaul DuBois10 May