PostgreSQL crashes on Windows 2003

From: "Joost Kraaijeveld" <J(dot)Kraaijeveld(at)Askesis(dot)nl>
To: <pgsql-general(at)postgresql(dot)org>, <pgsql-admin(at)postgresql(dot)org>
Subject: PostgreSQL crashes on Windows 2003
Date: 2007-03-12 13:20:44
Message-ID: 1173705643.20587.32.camel@panoramix
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin pgsql-general

Hi,

The PostgreSQL of a customer database (running on Windows 2003) crashed
and wrote the messages below in the logfile. According to the customer
the drives are working OK, partitions are not full and nothing has
changed in the permissions. The customer could restart the PostgreSQL
service manually, without resorting to a backup.

Could this be the result of not enough check_point segments?

2007-03-08 22:36:26 ERROR: could not read block 15894 of relation 1663/3227318/3227439: Permission denied
2007-03-08 22:36:26 STATEMENT: UPDATE deliver_cares SET org_personnel_id=$1, spent_time=$2, status=$3, when_registered=$4, actively_registered=$5 WHERE deliver_care_id=$6
2007-03-08 22:37:31 ERROR: could not write block 8 of relation 1663/3227318/4689678: Permission denied
2007-03-08 22:37:31 CONTEXT: writing block 8 of relation 1663/3227318/4689678
2007-03-08 22:38:57 FATAL: could not read from statistics collector pipe: No error
2007-03-08 22:38:57 FATAL: could not write to statistics collector pipe: No connection could be made because the target machine actively refused it.
2007-03-08 22:40:00 PANIC: could not write to log file 9, segment 219 at offset 15073280, length 24576: Permission denied
2007-03-08 22:40:00 STATEMENT: COMMIT

This application has requested the Runtime to terminate it in an unusual way.
Please contact the application's support team for more information.
2007-03-08 22:40:00 LOG: server process (PID 20508) was terminated by signal 3
2007-03-08 22:40:00 LOG: terminating any other active server processes
2007-03-08 22:40:00 WARNING: terminating connection because of crash of another server process
2007-03-08 22:40:00 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-08 22:40:00 HINT: In a moment you should be able to reconnect to the database and repeat your command.
2007-03-08 22:40:00 WARNING: terminating connection because of crash of another server process
2007-03-08 22:40:00 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-08 22:40:00 HINT: In a moment you should be able to reconnect to the database and repeat your command.
2007-03-08 22:40:01 LOG: all server processes terminated; reinitializing
2007-03-08 22:40:01 LOG: database system was interrupted at 2007-03-08 22:36:24 W. Europe Standard Time
2007-03-08 22:40:01 LOG: could not read from log file 9, segment 219 at offset 14876672: Permission denied
2007-03-08 22:40:01 LOG: invalid primary checkpoint record
2007-03-08 22:40:01 LOG: could not read from log file 9, segment 219 at offset 14721024: Permission denied
2007-03-08 22:40:01 LOG: invalid secondary checkpoint record
2007-03-08 22:40:01 PANIC: could not locate a valid checkpoint record

This application has requested the Runtime to terminate it in an unusual way.
Please contact the application's support team for more information.

2007-03-08 22:40:01 LOG: startup process (PID 20504) was terminated by signal 3
2007-03-08 22:40:01 LOG: aborting startup due to startup process failure
2007-03-08 22:40:01 LOG: logger shutting down

TIA

--
Groeten,

Joost Kraaijeveld
Askesis B.V.
Molukkenstraat 14
6524NB Nijmegen
tel: 024-3888063 / 06-51855277
fax: 024-3608416
web: www.askesis.nl

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Magnus Hagander 2007-03-12 13:39:33 Re: [GENERAL] PostgreSQL crashes on Windows 2003
Previous Message Rajesh Kumar Mallah 2007-03-11 02:44:38 Re: pg_dump and pg_dumpall is hanging

Browse pgsql-general by date

  From Date Subject
Next Message Magnus Hagander 2007-03-12 13:39:33 Re: [GENERAL] PostgreSQL crashes on Windows 2003
Previous Message Peter Eisentraut 2007-03-12 12:58:19 Re: Getting Text data as C string