Re: Recursive queries fail after bind has been running for a few hours

2012-03-13 Thread Mr X
On Mon, Mar 12, 2012 at 3:37 PM, Kevin Oberman wrote: > On Mon, Mar 12, 2012 at 12:05 PM, Mr X wrote: > > Hey there > > > > I'm having a bizarre issue with 9.7.3-P3-RedHat-9.7.3-8.P3.el6_2.2 - > > recursive queries stop functioning after bind has been running for a few > > hours. It's a very low

Re: Recursive queries fail after bind has been running for a few hours

2012-03-13 Thread G.W. Haywood
B0;261;0cHi there, On Mon, Mar 12, 2012 at 12:05 PM, Mr X wrote: I'm having a bizarre issue with 9.7.3-P3-RedHat-9.7.3-8.P3.el6_2.2 - recursive queries stop functioning after bind has been running for a few hours. It's a very low volume system (dev), maybe a few queries per hour ... I saw so

Re: Recursive queries fail after bind has been running for a few hours

2012-03-12 Thread Lyle Giese
I don't look at debug logs and may be WAY off base. But the time period for the log seems to be about 10 seconds start to finish in the failed query. However line 56 indicates that it timed out the query after 30 seconds. That just doesn't add up to me for some reason. Or is there 20 second

Re: Recursive queries fail after bind has been running for a few hours

2012-03-12 Thread Kevin Oberman
On Mon, Mar 12, 2012 at 12:05 PM, Mr X wrote: > Hey there > > I'm having a bizarre issue with 9.7.3-P3-RedHat-9.7.3-8.P3.el6_2.2 - > recursive queries stop functioning after bind has been running for a few > hours. It's a very low volume system (dev), maybe a few queries per hour at > most. It's n