Re: mysterious disconnects during processing

2002-09-10 Thread Joseph Bueno
Your db admin should know that ;) Otherwise, you can do a mysqladmin variables and look at 'datadir' value. In this directory, you should find a file named .err (see http://www.mysql.com/doc/en/Error_log.html). Regards -- Joseph Bueno Derrell Durrett wrote: > Joseph Bueno wrote: > > >>Have yo

Re: mysterious disconnects during processing

2002-09-10 Thread Derrell Durrett
Joseph Bueno wrote: > Have you looked at mysql error log file on the server ? Where would I find that? Derrell > > Derrell Durrett wrote: > > Since I didn't get a response, I tried one of the suggestions here. See my >response to > > it below. > > > > Additionally, I've turned on the environ

Re: mysterious disconnects during processing

2002-09-10 Thread Joseph Bueno
Hi, Have you looked at mysql error log file on the server ? Regards -- Joseph Bueno Derrell Durrett wrote: > Since I didn't get a response, I tried one of the suggestions here. See my response >to > it below. > > Additionally, I've turned on the environment variables DBI_TRACE and PERL_DBI_

Re: mysterious disconnects during processing

2002-09-10 Thread Derrell Durrett
Since I didn't get a response, I tried one of the suggestions here. See my response to it below. Additionally, I've turned on the environment variables DBI_TRACE and PERL_DBI_DEBUG, both to level '8'. This produces voluminous, but not particularly illuminating, output. If anyone has a suggesti

Re: mysterious disconnects during processing

2002-09-09 Thread Derrell Durrett
walt wrote: > 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

Re: mysterious disconnects during processing

2002-09-06 Thread walt
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 a

mysterious disconnects during processing

2002-09-06 Thread Derrell Durrett
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-3 times per u