MySQL Bugs: #693: Server hangs on Update

Bug #693	Server hangs on Update
Submitted:	20 Jun 2003 10:03	Modified:	4 Jul 2003 13:13
Reporter:	Nelson Escravana	Email Updates:
Status:	Can't repeat	Impact on me:	None
Category:	MySQL Server	Severity:	S1 (Critical)
Version:	4.0.12-log	OS:	Linux (Linux Redhat (kernel 2.4.18))
Assigned to:		CPU Architecture:	Any

Description:
In a master-slave configuration enviroment.
Sometimes (it happend 2 in a day, till now), during an simple update query like:
UPDATE table SET field=value WHERE a='b' AND c='d'
The mysqld starts using 100% CPU and the query never returns... (i waited half an hour for a query that usualy takes less than a sec.).

Using mysql command no other query is possible.

I will try to stop the replications configuration to see if it goes away....

How to repeat:
I cant reproduce it :-( it happends randomly...

Suggested fix:
no sugestion for now...

The query that hangs is a prepared statement performend via JDBC

Not enough information was provided for us to be able
to handle this bug. Please re-read the instructions at
http://bugs.mysql.com/how-to-report.php

If you can provide more information, feel free to add it
to this bug and change the status back to 'Open'.

Thank you for your interest in MySQL.

Without repeatable test case wae have no way to check yiour bug report.

hey nelson if this is the nelson from portugal its ur cousin jessica so0o if u want email me i really would like to talk to you