|
Greetings:
My MySQL (4.1.0 alpha) server crashes while processing large queries
from a web page (using ColdFusion 5.0):
ODBC Error Code = S1000 (General error)
[MySQL][ODBC 3.51 Driver][mysqld-4.1.0-alpha-max-nt]Lost connection
to MySQL server during query
The error occurred while processing an element with a general
identifier of (CFQUERY), occupying document position (178:2) to
(178:80).
Query String: li=1&f=0
The main query can get pretty big (> 4K) with a pile of 'IN' clauses
and sub-queries.
I've tried using both Linux i386 and Win2K MySQL server versions
(distributed binaries/not self-compiled), ODBC 3.51 and 2.50. Even
dumping/reloading the database, rebuilding keys/indexes, etc. Nothing
seems to work.
I've seen suggestions that ColdFusion may be crashing due to
unresponsive threads - ColdFusion does restart, but those events don't
reasonably match the MySQL server crashe times and MySQL crashes about
3 to 1. Perhaps I'm expecting too much from an alpha server?
Platforms/drivers/servers in use:
Win2K Server
MySQL (4.1.0-alpha)
ColdFusion (5.0)
ODBC (2.50)
Any insight would be appreciated. I have a sample query if needed
(it's huge).
Thanks!
Matt
| 
