5.0.19 on Solaris: hangs after several days

Henning Schulzrinne <[email protected]> Sun, 9 Apr 2006 22:55:19 -0400
Newsgroups gmane.comp.db.mysql.bugs
Message-ID <[email protected]>
I upgraded from 4.1.12 to 5.0.19 on Solaris (5.8 sun4u). It generally  
works, but after a few days (and sometimes a few hours), a sequence  
of events seems to take place:

- queries lock (judging from the processlist)
- the connection limit (around 100) is reached
- the server becomes unresponsive and has to be killed hard (kill - 
TERM doesn't work)

Besides upgrading the tables, nothing has changed between 4.1.12 and  
5.0.19 (same hardware, some OS).

As an additional oddity, the only indication of trouble in the error  
log is

060409 21:10:17 [Note] /proj/signal/mysql-5.0.19/bin/mysqld: ready  
for connections.
Version: '5.0.19-standard-log'  socket: '/proj/signal/mysql/ 
mysql.sock'  port: 3306  MySQL Community Edition - Standard (GPL)
060409 21:40:56 [Warning] Got signal 14 from thread 8
[server unusable shortly thereafter]

I'm only using myISAM tables.

Henning Schulzrinne
Columbia University

-- 
MySQL Bugs Mailing List
For list archives: http://lists.mysql.com/bugs
To unsubscribe:    http://lists.mysql.com/[email protected]