Needs advice on error detection

From: "S(dot) Horio" <fory(at)twinsun(dot)com>
To: pgsql-hackers(at)postgresql(dot)org
Subject: Needs advice on error detection
Date: 2007-12-06 00:00:21
Message-ID: 47573B95.9090403@twinsun.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

While using PostgreSQL 8.1.4 for Windows on Windows XP (SP2),
the following errors had occurred.

-----
2007-10-11 12:38:21 LOG: autovacuum: processing database "hoge"
2007-10-11 12:38:21 ERROR: xlog flush request 0/2BEB2198 is not satisfied --- flushed only to 0/2BE32740
2007-10-11 12:38:21 CONTEXT: writing block 205 of relation 1663/18096/27212
2007-10-11 12:38:22 ERROR: xlog flush request 0/2BEB6A70 is not satisfied --- flushed only to 0/2BE32740
2007-10-11 12:38:22 CONTEXT: writing block 206 of relation 1663/18096/27212
2007-10-11 12:38:23 ERROR: xlog flush request 0/2BEBB1B8 is not satisfied --- flushed only to 0/2BE32740
2007-10-11 12:38:23 CONTEXT: writing block 207 of relation 1663/18096/27212
...
2007-10-11 14:11:36 ERROR: xlog flush request 0/2C27ABB8 is not satisfied --- flushed only to 0/2C25ED60
2007-10-11 14:11:36 CONTEXT: writing block 258 of relation 1663/18096/27212
2007-10-11 14:11:36 WARNING: could not write block 258 of 1663/18096/27212
2007-10-11 14:11:36 DETAIL: Multiple failures --- write error may be permanent.
2007-10-11 14:11:36 ERROR: xlog flush request 0/2C27ABB8 is not satisfied --- flushed only to 0/2C25ED60
2007-10-11 14:11:36 CONTEXT: writing block 258 of relation1663/18096/27212
2007-10-11 14:11:36 WARNING: could not write block 258 of 1663/18096/27212
2007-10-11 14:11:36 DETAIL: Multiple failures --- write error may be permanent.
2007-10-11 14:11:36 LOG: received fast shutdown request
2007-10-11 14:11:36 LOG: shutting down
2007-10-11 14:11:36 PANIC: xlog flush request 0/2C27ABB8 is not satisfied --- flushed only to 0/2C25ED60
2007-10-11 14:11:36 CONTEXT: writing block 258 of relation 1663/18096/27212
-----

We were using pg_ctl to start up PostgreSQL instead of using
Windows Services. And we weren't shutting down the database
before shutting down the OS. Because of that, we think that
we damaged the disk blocks which were used by the database. Since
our client application did not receive the error, we think
that the error was started during the auto vacuum. In order to
detect these errors, is it possible to force database to
be halted as a PANIC state or it is possible to make this kind
of unrecoverable errors to be sent to existing client connections?
Also, is it common to get these errors when database was not
properly shutdown before halting an OS?

-Best Regards,

---
Shigenori Horio 360 N. Sepulveda Blvd., Suite 1040
Twin Sun Inc. El Segundo, CA 90245
shorio(at)twinsun(dot)com Tel: (310) 524-1800 ext 5, Fax: (310) 524-1818

Browse pgsql-hackers by date

  From Date Subject
Next Message Gregory Stark 2007-12-06 00:00:30 Re: Better default_statistics_target
Previous Message Decibel! 2007-12-05 23:47:42 Re: There's random access and then there's random access