|
Has anyone experienced any problems with the Postgres 8.2.x
database crashing when running PLPGSQL functions? When I try to run my plpgsql function it causes Postgres to
restart unexpectedly. The code was working with prior versions of
Postgres, now it seems to be crashing the postmaster. Here are my
log entries... 2007-03-27 10:20:35
LOG: statement: SELECT
"2007-3".getopencharge('822512', '2007-3-31', '2007-3', 'f') 2007-03-27 10:20:35 LOG: server process
(PID 3516) exited with exit code -1073741819 2007-03-27 10:20:35 LOG: terminating
any other active server processes 2007-03-27 10:20:35
WARNING: terminating connection because of crash of another server
process 2007-03-27 10:20:35
DETAIL: The postmaster has commanded this server process to roll back the
current transaction and exit, because another server process exited abnormally
and possibly corrupted shared memory. 2007-03-27 10:20:35
HINT: In a moment you should be able to reconnect to the database and
repeat your command. 2007-03-27 10:20:35
WARNING: terminating connection because of crash of another server
process 2007-03-27 10:20:35
DETAIL: The postmaster has commanded this server process to roll back the
current transaction and exit, because another server process exited abnormally
and possibly corrupted shared memory. 2007-03-27 10:20:35 HINT: In a moment
you should be able to reconnect to the database and repeat your command. 2007-03-27 10:20:35 LOG: all server
processes terminated; reinitializing 2007-03-27 10:20:35 LOG: database
system was interrupted at 2007-03-27 10:18:52 Eastern Daylight Time When I run the function, it runs ok the first
time. The second time right after that, the crash
occurs. This is consistent every time I run this test. This problem seems to be exactly the same symptoms as a bug
I reported already #3158/#3166, but have not seen much dialogue on it.
I am not sure how to correct this problem as it was already working fine in a
prior version of Postgres. I am running this on a Windows 2003 Standard Server
SP1. The server is an Intel P4 XEON with 1GB RAM and Ultra 320 RAID
10 Configuration. My PostgresSQL version is 8.2.3. Can any one help with this? |
