Received: from localhost (maia-5.hub.org [200.46.204.182]) by postgresql.org (Postfix) with ESMTP id 6FC9B9FB371; Mon, 12 Mar 2007 10:33:08 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.182]) (amavisd-new, port 10024) with ESMTP id 56380-03; Mon, 12 Mar 2007 10:32:53 -0300 (ADT) X-Greylist: delayed 00:12:09.944381 by SQLgrey-1.7.4 X-Greylist: from auto-whitelisted by SQLgrey-1.7.4 Received: from obelix.askesis.nl (laudanum.demon.nl [82.161.125.16]) by postgresql.org (Postfix) with ESMTP id 1613E9FB32D; Mon, 12 Mar 2007 10:32:58 -0300 (ADT) Received: obelix 172.31.0.1 from 172.31.1.1 172.31.1.1 via HTTP with MS-WebStorage 6.0.6249 MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable X-MimeOLE: Produced By Microsoft Exchange V6.0.6603.0 Received: from panoramix by obelix; 12 Mar 2007 14:20:44 +0100 X-Mailer: Evolution 2.6.3 Content-Class: urn:content-classes:message Subject: PostgreSQL crashes on Windows 2003 Date: Mon, 12 Mar 2007 14:20:44 +0100 Message-ID: <1173705643.20587.32.camel@panoramix> X-MS-Has-Attach: X-MS-TNEF-Correlator: Thread-Topic: PostgreSQL crashes on Windows 2003 thread-index: AcdkqT0vZ9wzvpx7ShyBvG+qQYG+IQ== From: "Joost Kraaijeveld" To: , X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.137 tagged_above=0 required=5 tests=BAYES_50, FORGED_RCVD_HELO, UNPARSEABLE_RELAY X-Spam-Level: X-Archive-Number: 200703/58 X-Sequence-Number: 24882 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=3D$1, spent_time=3D$2, status=3D$3, = when_registered=3D$4, actively_registered=3D$5 WHERE = deliver_care_id=3D$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 --=20 Groeten, Joost Kraaijeveld Askesis B.V. Molukkenstraat 14 6524NB Nijmegen tel: 024-3888063 / 06-51855277 fax: 024-3608416 web: www.askesis.nl