Hello, I recently upgraded my linux kernel from 2.2.19smp to 2.4.2smp (on RedHat 7.1). In the process, I also upgraded MySQL from 3.23.38 to 3.23.42. The machine is a dedicated MySQL server, and was running for 6 months without a single problem (until we upgraded the kernel and the version of MySQL). I sent a request to the main MySQL list to see if anyone know of any problems, but they said to report it via here. The problem is I am not able to give you a query or a set of instructions that will let you reproduce this bug. Instead, I can only give you what mysqld.log reports when it crashes. Every time it dies on a query that is calling a create table type=heap type query. They query is called tens of thousands of times before it, but for some reason every now and then it dies. This is pretty much all I know. It has done this 6 times in the past 4 days. 4 of the times it 100% hangs the machine with no logs, the other 2 it was able to write to the log before it crashed. I will be down grading the kernel to the 2.2.19smp in hopes this problem will go away, but thought I would at least make you aware of it as I know many people will (if not already) have switched the the 2.4.x tree.

This is my only suggestion of How-To-Repeat: CREATE TEMPORARY TABLE if not exists results TYPE=HEAP DROP TABLE results

(repeat this 10,000 times or so)

Let me know if there's anything else I can give you to help you out.

Gavin