[Info-ingres] Weird error on reconnect from perl program

[Martin Bowes]

Hi Nikos

Yes indeed I have. Sadly it wasn't as enlightening as I hoped. Even at trace level 2. 

However, I've managed to work out that the problem was caused by a combination of a few things.
The main one being that one of the 5 database connections was to a host outside our firewall and the network dropped the connection after an hour of inactivity. My job started a database query, and apparently the waiting for it to complete looks inactivity. The network manager was unwilling to extend the hour. I've had to program around it by splitting the job into slices that will complete within the hour...I'm now up to ten slices on one task.

Marty

-----Original Message-----
From: nikosv [mailto:nikos.vaggalis at gmail.com] 
Sent: 06 September 2019 21:06
To: info-ingres at lists.planetingres.org
Subject: Re: [Info-ingres] Weird error on reconnect from perl program

Have you checked with DBI_TRACE level 5 and above ?
https://www.effectiveperlprogramming.com/2010/04/use-dbi_trace-to-follow-dbis-work/
_______________________________________________
Info-ingres mailing list
Info-ingres at lists.planetingres.org
https://lists.planetingres.org/mailman/listinfo/info-ingres