Re: beta1 & beta2 & Windows & heavy load

Tom Lane schrieb:
>Can I see a stack trace from that?  Or at least the verbose form of the>error message?>
actually i dunno know how to create a stack trace. I will do some 
research. Verbose output (debug5)

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
 WARNING:  01000: StartAbortedSubTransaction while in START state LOCATION:  StartAbortedSubTransaction, xact.c:3207
 ERROR:  53200: 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 LOCATION:  LockAcquire, lock.c:562 STATEMENT:  UPDATE art SET ak_res=0;
 WARNING:  01000: StartAbortedSubTransaction while in START state LOCATION:  StartAbortedSubTransaction, xact.c:3207

TEST=# ROLLBACK;
ROLLBACK
TEST=# SELECT count(*) FROM art;
WARNING:  out of shared memory
ERROR:  out of shared memory
TEST=#
 WARNING:  53200: out of shared memory LOCATION:  ShmemAlloc, shmem.c:185 STATEMENT:  SELECT count(*) FROM art;
 ERROR:  53200: out of shared memory LOCATION:  BufTableInsert, buf_table.c:93 STATEMENT:  SELECT count(*) FROM art;


Daniel.