MySQL looses connection

[HowTheyDoThat]

We have a customer that is getting error with CFMX loosing connection to MySQL
during a query. QueryError: [Macromedia][SequeLink JDBC Driver][ODBC
Socket][MySQL][ODBC 3.51 Driver][mysqld-4.0.21-standard]Lost connection to
MySQL server during query Any suggestions where to look for problem. CF
server Windows 2000 with latest patches, MySQL server on Linux box. Both
servers have very light load.

[HowTheyDoThat]

We have tried moving to JDBC connector and still receive this error. We have
checked MySQL logs and everyting there apears normail. Any suggestions would
be apreciated. Message: Error Executing Database Query. Caught an exception,
type = Database Detail: Communications link failure due to underlying
exception: ** BEGIN NESTED EXCEPTION ** java.net.SocketException MESSAGE:
Connection reset STACKTRACE: java.net.SocketException: Connection reset at
java.net.SocketInputStream.read(SocketInputStream. java:168) at
com.mysql.jdbc.util.ReadAheadInputStream.fill(Read AheadInputStream.java:104) at
com.mysql.jdbc.util.ReadAheadInputStream.readFromU nderlyingStreamIfNecessary(Rea
dAheadInputStream.java:144) at
com.mysql.jdbc.util.ReadAheadInputStream.read(Read AheadInputStream.java:172) at
com.mysql.jdbc.MysqlIO.readFully(MysqlIO.java:1839 ) at
com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO. java:2288) at
com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.ja va:2784) at
com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:15 31) at
com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java :1622) at
com.mysql.jdbc.Connection.execSQL(Connection.java: 2370) at
com.mysql.jdbc.Connection.execSQL(Connection.java: 2297) at
com.mysql.jdbc.Statement.execute(Statement.java:9. .. NativeErrorCode: 0
SQLState: 08S01 SQL: select listing.listid, listing.title, listing.keycode,
listing.listtype, listing.price, listing.photo, listing.state,
category.catdesc, liststyle.styledescription, listing.city, user.active,
user.userid, listing.userid, listing.active_listing, listing.areacode from
((listing left outer join category on category.catid = listing.catid) left
outer join liststyle on liststyle.styleid = listing.styleid) left outer join
user on user.userid = listing.userid WHERE listid > 0 and user.active = 'A' and
listing.active_listing = 1 ORDER BY listing.city QueryError: Communications
link failure due to underlying exception: ** BEGIN NESTED EXCEPTION **
java.net.SocketException MESSAGE: Connection reset STACKTRACE:
java.net.SocketException: Connection reset at
java.net.SocketInputStream.read(SocketInputStream. java:168) at
com.mysql.jdbc.util.ReadAheadInputStream.fill(Read AheadInputStream.java:104) at
com.mysql.jdbc.util.ReadAheadInputStream.readFromU nderlyingStreamIfNecessary(Rea
dAheadInputStream.java:144) at
com.mysql.jdbc.util.ReadAheadInputStream.read(Read AheadInputStream.java:172) at
com.mysql.jdbc.MysqlIO.readFully(MysqlIO.java:1839 ) at
com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO. java:2288) at
com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.ja va:2784) at
com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:15 31) at
com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java :1622) at
com.mysql.jdbc.Connection.execSQL(Connection.java: 2370) at
com.mysql.jdbc.Connection.execSQL(Connection.java: 2297) at
com.mysql.jdbc.Statement.execute(Statement.java:90 2) at
coldfusion.server.j2ee.sql.JRunStatement.execute(J RunStatement.java:212) at
coldfusion.sql.Executive.executeQuery(Executive.ja va:974) at
coldfusion.sql.Executive.executeQuery(Executive.ja va:886) at
coldfusion.sql.SqlImpl.execute(SqlImpl.java:236) at
coldfusion.tagext.sql.QueryTag.doEndTag(QueryTag.j ava:447) at
cflisting_results2ecfm2141572317._factor3(D:\hshom e\XXXXXXXX\xxxxxxxxxxxxxxxx.co
m\listing_results.cfm:91) at
cflisting_results2ecfm2141572317._factor6(D:\hshom e\XXXXXXXX\xxxxxxxxxxxxxxxx.co
m\listing_results.cfm:48) at
cflisting_results2ecfm2141572317._factor11(D:\hsho me\XXXXXXXX\xxxxxxxxxxxxxxxx.c
om\listing_results.cfm:3) at
cflisting_results2ecfm2141572317.runPage(D:\hshome \XXXXXXXX\xxxxxxxxxxxxxxxx.com
\listing_results.cfm:1) at
coldfusion.runtime.CfJspPage.invoke(CfJspPage.java :147) at
coldfusion.tagext.lang.IncludeTag.doStartTag(Inclu deTag.java:357) at
coldfusion.filter.CfincludeFilter.invoke(Cfinclude Filter.java:62) at
coldfusion.filter.ApplicationFilter.invoke(Applica tionFilter.java:107) at
coldfusion.filter.RequestMonitorFilter.invoke(Requ estMonitorFilter.java:48) at
coldfusion.filter.PathFilter.invoke(PathFilter.jav a:80) at
coldfusion.filter.ExceptionFilter.invoke(Exception Filter.java:47) at
coldfusion.filter.ClientScopePersistenceFilter.inv oke(ClientScopePersistenceFilt
er.java:28) at coldfusion.filter.BrowserFilter.invoke(BrowserFilt er.java:35) at
coldfusion.filter.GlobalsFilter.invoke(GlobalsFilt er.java:43) at
coldfusion.filter.DatasourceFilter.invoke(Datasour ceFilter.java:22) at
coldfusion.CfmServlet.service(CfmServlet.java:105) at
jrun.servlet.ServletInvoker.invoke(ServletInvoker. java:91) at
jrun.servlet.JRunInvokerChain.invokeNext(JRunInvok erChain.java:42) at
jrun.servlet.JRunRequestDispatcher.invoke(JRunRequ estDispatcher.java:249) at
jrun.servlet.ServletEngineService.dispatch(Servlet EngineService.java:527) at
jrun.servlet.jrpp.JRunProxyService.invokeRunnable( JRunProxyService.java:192) at
jrunx.scheduler.ThreadPool$DownstreamMetrics.invok eRunnable(ThreadPool.java:348)
at
jrunx.scheduler.ThreadPool$ThreadThrottle.invokeRu nnable(ThreadPool.java:451)
at
jrunx.scheduler.ThreadPool$UpstreamMetrics.invokeR unnable(ThreadPool.java:294)
at jrunx.scheduler.WorkerThread.run(WorkerThread.java :66) ** END NESTED
EXCEPTION ** The contents of the tag stack are: 1 CFQUERY (91,0)
D:\hshome\XXXXXXXX\xxxxxxxxxxxxxxxx.com\listing_re sults.cfm 2
CF_LISTING_RESULTS (48,0)
D:\hshome\XXXXXXXX\xxxxxxxxxxxxxxxx.com\listing_re sults.cfm 3
CF_LISTING_RESULTS (3,0)
D:\hshome\XXXXXXXX\xxxxxxxxxxxxxxxx.com\listing_re sults.cfm 4
CF_LISTING_RESULTS (1,0)
D:\hshome\XXXXXXXX\xxxxxxxxxxxxxxxx.com\listing_re sults.cfm