Re: [PATCHES] Testing pg_terminate_backend()

2008-04-21 Thread Bruce Momjian
Guillaume Smet wrote: > On Mon, Apr 21, 2008 at 7:25 PM, Magnus Hagander <[EMAIL PROTECTED]> wrote: > > Not really, but it did need a couple of adjustments :-) > > > > It's been running fine now for a number of hours, with output that > > looks similar to the stuff you posted. I'll leave it runn

Re: [PATCHES] Testing pg_terminate_backend()

2008-04-21 Thread Guillaume Smet
On Mon, Apr 21, 2008 at 7:25 PM, Magnus Hagander <[EMAIL PROTECTED]> wrote: > Not really, but it did need a couple of adjustments :-) > > It's been running fine now for a number of hours, with output that > looks similar to the stuff you posted. I'll leave it running.. If you can come up with a

Re: [PATCHES] Testing pg_terminate_backend()

2008-04-21 Thread Alvaro Herrera
Magnus Hagander wrote: > It's been running fine now for a number of hours, with output that > looks similar to the stuff you posted. I'll leave it running.. Perhaps it would be a good idea to leave it running on code with some bugs on it, just to check if the problems show up. -- Alvaro Herrera

Re: [PATCHES] Testing pg_terminate_backend()

2008-04-21 Thread Magnus Hagander
Bruce Momjian wrote: > Magnus Hagander wrote: > > Done that. Also, I needed to replace "gmake" with "make", since I'm > > on linux... > > > > Anyway. It's been running for about 12 hours now, and I have > > *nothing* in the output file. That tells me that the script doesn't > > appear to be workin

Re: [PATCHES] Testing pg_terminate_backend()

2008-04-21 Thread Bruce Momjian
Magnus Hagander wrote: > Done that. Also, I needed to replace "gmake" with "make", since I'm on > linux... > > Anyway. It's been running for about 12 hours now, and I have *nothing* > in the output file. That tells me that the script doesn't appear to be > working - correct? It should output *some

Re: [PATCHES] Testing pg_terminate_backend()

2008-04-21 Thread Magnus Hagander
Bruce Momjian wrote: > bruce wrote: > > Magnus Hagander wrote: > > > Tom Lane wrote: > > > > Bruce Momjian <[EMAIL PROTECTED]> writes: > > > > > Attached is my test script. I ran it for 14 hours (asserts > > > > > on), running 450 regression tests, with up to seven backends > > > > > killed per r

Re: [PATCHES] Testing pg_terminate_backend()

2008-04-18 Thread Bruce Momjian
bruce wrote: > bruce wrote: > > Magnus Hagander wrote: > > > Tom Lane wrote: > > > > Bruce Momjian <[EMAIL PROTECTED]> writes: > > > > > Attached is my test script. I ran it for 14 hours (asserts on), > > > > > running 450 regression tests, with up to seven backends killed per > > > > > regressio

Re: [PATCHES] Testing pg_terminate_backend()

2008-04-18 Thread Bruce Momjian
bruce wrote: > Magnus Hagander wrote: > > Tom Lane wrote: > > > Bruce Momjian <[EMAIL PROTECTED]> writes: > > > > Attached is my test script. I ran it for 14 hours (asserts on), > > > > running 450 regression tests, with up to seven backends killed per > > > > regression test. > > > > > > Hmm, t

Re: [PATCHES] Testing pg_terminate_backend()

2008-04-18 Thread Bruce Momjian
Magnus Hagander wrote: > Tom Lane wrote: > > Bruce Momjian <[EMAIL PROTECTED]> writes: > > > Attached is my test script. I ran it for 14 hours (asserts on), > > > running 450 regression tests, with up to seven backends killed per > > > regression test. > > > > Hmm, there are something on the ord

Re: [PATCHES] Testing pg_terminate_backend()

2008-04-18 Thread Bruce Momjian
Tom Lane wrote: > Bruce Momjian <[EMAIL PROTECTED]> writes: > > Attached is my test script. I ran it for 14 hours (asserts on), > > running 450 regression tests, with up to seven backends killed per > > regression test. > > Hmm, there are something on the order of 1 SQL commands in our > reg

Re: [PATCHES] Testing pg_terminate_backend()

2008-04-18 Thread Alvaro Herrera
Magnus Hagander wrote: > Tom Lane wrote: > > > SLEEP=`expr $RANDOM \* $REGRESSION_DURATION / 32767` > > > > Uh, where's the randomness coming from? > > ... but I should probably wait until that one is answered or fixed, I > guess :-) bash. RANDOM Each time this parameter is re

Re: [PATCHES] Testing pg_terminate_backend()

2008-04-18 Thread Magnus Hagander
Tom Lane wrote: > Bruce Momjian <[EMAIL PROTECTED]> writes: > > Attached is my test script. I ran it for 14 hours (asserts on), > > running 450 regression tests, with up to seven backends killed per > > regression test. > > Hmm, there are something on the order of 1 SQL commands in our > reg

Re: [PATCHES] Testing pg_terminate_backend()

2008-04-18 Thread Tom Lane
Bruce Momjian <[EMAIL PROTECTED]> writes: > Attached is my test script. I ran it for 14 hours (asserts on), > running 450 regression tests, with up to seven backends killed per > regression test. Hmm, there are something on the order of 1 SQL commands in our regression tests, so even assumin

[PATCHES] Testing pg_terminate_backend()

2008-04-18 Thread Bruce Momjian
bruce wrote: > Tom Lane wrote: > > Bruce Momjian <[EMAIL PROTECTED]> writes: > > > Tom Lane wrote: > > >> The closest thing I can think of to an automated test is to run repeated > > >> sets of the parallel regression tests, and each time SIGTERM a randomly > > >> chosen backend at a randomly chose