Derrell Durrett wrote:
> 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
>
> ---------------------------------------------------------------------
> Before posting, please check:
> http://www.mysql.com/manual.php (the manual)
> http://lists.mysql.com/ (the list archive)
>
> To request this thread, e-mail <mysql-thread118965@stripped>
> To unsubscribe, e-mail <mysql-unsubscribe-kernel=nea-fast.com@stripped>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Derrell,
There are a few things I'd check.
1. Is anything else touching this/these table/tables while the application is
running.
2. In your perl code, are you running ->finish on each query?
3. Is/are the table/tables you're touching innodb or myisam (could be log issue);
4. What error message does perl give you from the db?
5. What is the load avg on the db and application server when query/update fails?
6. If the query or update fails, what happens if the perl app sleeps for a few
seconds and trys again?
hope this helps
walt
