Problem:
When we run a large query (returns 4000 records) on a firewalled
XServe (OS X 10.4) against Mysql database (outside firewall) on an
AIX (Version 5.2) machine the database server intermittently
generates the following errors:
ERROR 2006 (HY000): MySQL server has gone away
No connection. Trying to reconnect...
or ERROR 2013 (HY000): Lost connection to MySQL server during query
That behavior is only happening on that firewalled machine with mysql
client Ver 14.12 Distrib 5.0.15, for apple-darwin8.2.0 (powerpc)
using readline 5.0. This is the same version I am using on my
computer with OS X installed without any problems.
I also noticed that sometimes the error - "ERROR 2006 (HY000): MySQL
server has gone away
No connection. Trying to reconnect... " - shows up after the mysql
client was idle for a few minutes.
I have seen posts and links to http://dev.mysql.com/doc/refman/5.0/en/
gone-away.html. Although this gives some general idea, no solution
seems to be directly applicable to our situation.
Appreciate your help,
Peter
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]