>Description:
after several days of perfect functioning, mysql hangs completely.
if i try to shut it down with mysqladmin shutdown i get:
mysqladmin: connect to server at 'localhost' failed
error: 'Can't connect to MySQL server on localhost (60)'
Check that mysqld is running on localhost and that the port is 3306.
You can check this by doing 'telnet localhost 3306'
i ktrace'd the mysqld and saw it stuck in an infinite loop doing
this:
19359 mysqld PSIG SIGILL caught handler=0xb0f0c mask=0x0 code=0x1
19359 mysqld CALL sigreturn(0x1e37c78)
19359 mysqld RET sigreturn JUSTRETURN
19359 mysqld PSIG SIGILL caught handler=0xb0f0c mask=0x0 code=0x1
19359 mysqld CALL sigreturn(0x1e37c78)
19359 mysqld RET sigreturn JUSTRETURN
19359 mysqld PSIG SIGILL caught handler=0xb0f0c mask=0x0 code=0x1
19359 mysqld CALL sigreturn(0x1e37c78)
19359 mysqld RET sigreturn JUSTRETURN
19359 mysqld PSIG SIGILL caught handler=0xb0f0c mask=0x0 code=0x1
i am starting mysql with the following command:
/usr/local/mysql-32214b/libexec/mysqld -Omax_connections=300 -Oback_log=25
-Othread_stack=131072 -Otable_cache=128 --skip-thread-prior -l --datadir=/usr/local/var
>How-To-Repeat:
i don't know what triggers it, we have a dozen or so databases
with many tables encompassing millions of rows of data. every
week or so, mysql just gets stuck in an unkillable loop. i have
to kill -9 it which usually corrupts some tables.
>Fix:
>Submitter-Id: <submitter ID>
>Originator: Jon Drukman
>Organization:
>MySQL support: [none | licence | email support | extended email support ]
>Synopsis: mysqld hangs
>Severity: critical
>Priority: high
>Category: mysql
>Class:
>Release: mysql-3.22.14b-gamma (Source distribution)
>Server: /usr/local/bin/mysqladmin Ver 6.8 Distrib 3.21.29-gamma, for
>unknown-freebsd2.2.5 on i386
TCX Datakonsult AB, by Monty
Server version 3.22.14b-gamma-log
Protocol version 10
Connection localhost via TCP/IP
TCP port 3306
Uptime: 44 sec
Threads: 25 Questions: 77 Slow queries: 0 Opens: 7 Flush tables: 1 Open tables: 4
>Environment:
System: FreeBSD sequel.gamespot.com 2.2.5-RELEASE FreeBSD 2.2.5-RELEASE #0: Tue Jun 16
11:07:52 PDT 1998 [EMAIL PROTECTED]:/usr/src/sys/compile/SEQUEL i386
Some paths: /usr/bin/perl /usr/bin/make /usr/bin/gcc /usr/bin/cc
GCC: gcc version 2.7.2.1
Compilation info: CC='gcc' CFLAGS='' CXX='gcc' CXXFLAGS='' LDFLAGS=''
Configure command: ./configure --with-unix-socket-path=/var/tmp/mysql.sock
--with-low-memory --with-mit-threads=yes
Perl: This is perl, version 5.004_04 built for i386-freebsd
-----------------------------------------------------------
Send a mail to [EMAIL PROTECTED] with
unsubscribe mysql [EMAIL PROTECTED]
in the body of the message to unsubscribe from this list.
