I'm running server version: 3.22.32, on SunOS 5.6 Generic_105181-17.
The code is perl 5.6.1, using DBI and DBD::mysql as the interface. We
have code that prepares a group of statement handles for use in doing
various queries and inserts in a loop that is executed anywhere from
1-30000 times per use of this program. Another program drives this one,
calling it about 150 times.
Last week (after I filled the local hard disk on the server), we began
to suffer disconnects from the database in these queries and inserts.
There is no obvious pattern to the disconnections, and they appear at
arbitrary times during the connections, but at approximately the same
time for each set of data (some of the shorter datasets are inserted
completely).
The admin for this db is certain the problem is in the code. However
I can't understand this since that code is unchanged.
What should I look for, what should he look for, or what additional
information do I need to supply in order to pursue resolving this issue?
Derrell
--
Derrell Durrett Xilinx, Inc. Productivity Engineering
Longmont, Colorado
720.652.3843
