I was running a stock 7.2b4 Postgres with pgbench.

RedHat Linux 7.2, stock everything.
Dual PIII 650MHZ
SMP kernel
1G RAM
EXT3 file system

Adaptec SCSI disks, one for /base and ont for/pg_xlog

pgbench scaled to 50

./pgbench -n -t 100 -h $HOST -c 100 bench

It hung in the checkpoint. I wasn't able to trace it.

Fri, 11 Jan 2002 22:53:08 -0500
mlw <markw@mohawksoft.com>
checkpoint hang in 7.2b4
mlw <markw@mohawksoft.com> writes:
> ./pgbench -n -t 100 -h $HOST -c 100 bench

> It hung in the checkpoint. I wasn't able to trace it.

Hung, or just took longer than you expected?

I don't see how you expect us to do anything with that report.
I can assure you I've run quite a few pgbenches on stock RH 
Linux 7.2, with no sign of a problem.  So you'll have to do some
investigation of your own, if you see a problem...

			regards, tom lane

Fri, 11 Jan 2002 23:15:29 -0500
Tom Lane <tgl@sss.pgh.pa.us>
Re: checkpoint hang in 7.2b4 
Tom Lane wrote:
> 
> mlw <markw@mohawksoft.com> writes:
> > ./pgbench -n -t 100 -h $HOST -c 100 bench
> 
> > It hung in the checkpoint. I wasn't able to trace it.
> 
> Hung, or just took longer than you expected?

No, hung, 20 minutes. Load average dropped to zero.

> 
> I don't see how you expect us to do anything with that report.
> I can assure you I've run quite a few pgbenches on stock RH
> Linux 7.2, with no sign of a problem.  So you'll have to do some
> investigation of your own, if you see a problem...

Hey I didn't have the debugger going, I was doing a performance test. I will
look into it if it happens again. This wasn't a request for help, it was a
heads up. If what I saw was anomalous that's great, but if it isn't I want to
make sure that you guys heard about it, just in case.

Fri, 11 Jan 2002 23:30:19 -0500
mlw <markw@mohawksoft.com>
Re: checkpoint hang in 7.2b4
mlw wrote:
> 
> I was running a stock 7.2b4 Postgres with pgbench.
> 
> RedHat Linux 7.2, stock everything.
> Dual PIII 650MHZ
> SMP kernel
> 1G RAM
> EXT3 file system
> 
> Adaptec SCSI disks, one for /base and ont for/pg_xlog
> 
> pgbench scaled to 50
> 
> ./pgbench -n -t 100 -h $HOST -c 100 bench
> 
> It hung in the checkpoint. I wasn't able to trace it.

I had a similar experience once with -c 5. I sent output of 
"ps ax| grep post" to this list and Tom claimed it to be 
fixed in CVS head.

------------
Hannu

Sat, 12 Jan 2002 16:51:23 +0200
Hannu Krosing <hannu@tm.ee>
Re: checkpoint hang in 7.2b4
Hannu Krosing <hannu@tm.ee> writes:
>> It hung in the checkpoint. I wasn't able to trace it.

> I had a similar experience once with -c 5. I sent output of 
> "ps ax| grep post" to this list and Tom claimed it to be 
> fixed in CVS head.

Oh, you're thinking of that three-way deadlock condition.  I've
forgotten, was that in b4?

			regards, tom lane

Sat, 12 Jan 2002 11:21:12 -0500
Tom Lane <tgl@sss.pgh.pa.us>
Re: checkpoint hang in 7.2b4 
On Sat, 2002-01-12 at 21:21, Tom Lane wrote:
> Hannu Krosing <hannu@tm.ee> writes:
> >> It hung in the checkpoint. I wasn't able to trace it.
> 
> > I had a similar experience once with -c 5. I sent output of 
> > "ps ax| grep post" to this list and Tom claimed it to be 
> > fixed in CVS head.
> 
> Oh, you're thinking of that three-way deadlock condition.  I've
> forgotten, was that in b4?

Yes.

--------------
Hannu

12 Jan 2002 22:40:14 +0500
Hannu Krosing <hannu@krosing.net>
Re: checkpoint hang in 7.2b4