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 <[EMAIL PROTECTED]> > To unsubscribe, e-mail <[EMAIL PROTECTED]> > 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 --------------------------------------------------------------------- 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 <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
