Re: beta1 & beta2 & Windows & heavy load

Tom Lane schrieb:

> Yeah, I ran into that earlier today while trying to reproduce your
> problem.  It's fixed by this pending patch.  I didn't see any freeze-up
> of the system after running out of lock memory, though.  It seemed to
> release the locks just fine.

Yeah this error is away now.

Now i got the same behavoir as before. Notice that I'v never opened a 
transaction in the following scenario. I'm unable to do anything with 
this connection.

example:

C:\postgres\bin>psql TEST
Welcome to psql 8.0.0beta2, the PostgreSQL interactive terminal.

Type:  \copyright for distribution terms       \h for help with SQL commands       \? for help with psql commands       \g or terminate with semicolon to execute query       \q to quit

Warning: Console codepage (850) differs from windows codepage (1252)         8-bit characters will not work correctly. See PostgreSQL         documentation "Installation on Windows" for details.

TEST=# SELECT count(*) FROM art; count
------- 13534
(1 row)
TEST=# UPDATE art SET ak_res=0 WHERE ak_nr='###';
UPDATE 0
TEST=# UPDATE art SET ak_res=0;
WARNING:  out of shared memory
CONTEXT:  PL/pgSQL function "do_standard_mgc" line 2 at block variables 
initialization
WARNING:  StartAbortedSubTransaction while in START state
ERROR:  out of shared memory
HINT:  You may need to increase max_locks_per_transaction.
CONTEXT:  PL/pgSQL function "do_standard_mgc" line 2 at block variables 
initialization
TEST=# UPDATE art SET ak_res=0 WHERE ak_nr='###';
ERROR:  current transaction is aborted, commands ignored until end of 
transaction block
TEST=# SELECT count(*) FROM art;
ERROR:  current transaction is aborted, commands ignored until end of 
transaction block
TEST=# ROLLBACK;
ROLLBACK
TEST=# SELECT count(*) FROM art;
WARNING:  out of shared memory
ERROR:  out of shared memory
TEST=#

Daniel