Received: from maia.hub.org (maia-3.hub.org [200.46.204.243]) by mail.postgresql.org (Postfix) with ESMTP id AF60DB5DC61 for ; Sun, 28 Aug 2011 11:43:57 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.243]) (amavisd-maia, port 10024) with ESMTP id 80057-08 for ; Sun, 28 Aug 2011 14:43:50 +0000 (UTC) X-Greylist: delayed 00:53:26.203306 by SQLgrey-1.7.6 Received: from mail-yw0-f46.google.com (mail-yw0-f46.google.com [209.85.213.46]) by mail.postgresql.org (Postfix) with ESMTP id D4254B5DC55 for ; Sun, 28 Aug 2011 11:43:48 -0300 (ADT) Received: by ywf7 with SMTP id 7so4104271ywf.19 for ; Sun, 28 Aug 2011 07:43:49 -0700 (PDT) Received: by 10.42.246.137 with SMTP id ly9mr3584103icb.506.1314539032662; Sun, 28 Aug 2011 06:43:52 -0700 (PDT) Received: from [10.1.1.7] (124-169-228-164.dyn.iinet.net.au [124.169.228.164]) by mx.google.com with ESMTPS id fr1sm364792ibb.40.2011.08.28.06.43.49 (version=SSLv3 cipher=OTHER); Sun, 28 Aug 2011 06:43:51 -0700 (PDT) Message-ID: <4E5A4609.1020408@ringerc.id.au> Date: Sun, 28 Aug 2011 21:43:37 +0800 From: Craig Ringer User-Agent: Mozilla/5.0 (Windows NT 6.1; WOW64; rv:6.0) Gecko/20110812 Thunderbird/6.0 MIME-Version: 1.0 To: "Mcleod, John" CC: "'pgsql-admin@postgresql.org'" Subject: Re: What is postgresql status? I'm not sure References: In-Reply-To: Content-Type: multipart/alternative; boundary="------------050401000000030209030808" X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-1.899 tagged_above=-10 required=5 tests=BAYES_00=-1.9, HTML_MESSAGE=0.001 X-Spam-Level: X-Archive-Number: 201108/218 X-Sequence-Number: 38205 This is a multi-part message in MIME format. --------------050401000000030209030808 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit On 25/08/2011 2:09 AM, Mcleod, John wrote: > > Hello all, > > Don't shoot me, I'm just the fella sweeping up after a departure. > > I'm supporting a web site with mapping features using Mapserver and > PostgreSql 7.5 for windows. > > Recently, my mapping features went down. > > Error messages that display are the following... > > Warning: pg_query(): Query failed: ERROR: xlog flush request > 0/34D85078 is not satisfied --- flushed only to 0/34CD4518 CONTEXT: > writing block 0 of relation 394198/412173 in > C:\ms4w\Apache\htdocs\davison\mapping\gis1\viewparcel_nolink.php on > line 10 > Sounds like a disk fault or disk-full issue. > > It looks to me that the query failed based on a hard drive issue. > Well, over the weekend we swapped out the hard drive for new. The > site comes back fine but I'm still receiving the error. If you have actual data corruption as a result of the disk failure, you may have to restore from a backup. Theoretically data corruption shouldn't happen if a HDD just starts failing writes, but in reality it can happen due to possible resulting file-system corruption, OS issues, or the disk actually returning corrupted blocks on reads. > C:\ms4w\apps\pgsql75win\data>del postmaster.pid > > Could Not Find C:\ms4w\apps\pgsql75win\data\postmaster.pid > Eek, who/what is doing that?!? Don't delete the postmaster pid file. If you do so without making EXTREMELY sure there are no backends still running, you risk severe database corruption if you then start a new postmaster. > LOG: database system was shut down at 2011-08-24 17:30:14 Eastern > Standard Time > > LOG: checkpoint record is at 0/34CD4078 > > LOG: redo record is at 0/34CD4078; undo record is at 0/0; shutdown TRUE > > LOG: next transaction ID: 1198832; next OID: 1772830 > > LOG: database system is ready > > I'm not sure if the database is up or not. > Well, it's running. > I don't even see postgresql or mapserver as Windows services. > How did you start it? If you didn't start it with "net service" or using the "services.msc" MMC snapin, it won't start as a service. It looks like you used some kind of batch file to start it under your own user account instead, but you haven't shown the full command line(s) involved. -- Craig Ringer --------------050401000000030209030808 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit On 25/08/2011 2:09 AM, Mcleod, John wrote:

Hello all,

Don't shoot me, I'm just the fella sweeping up after a departure.

I'm supporting a web site with mapping features using Mapserver and PostgreSql 7.5 for windows.

Recently, my mapping features went down.

Error messages that display are the following…

 

 

Warning: pg_query(): Query failed: ERROR: xlog flush request 0/34D85078 is not satisfied --- flushed only to 0/34CD4518 CONTEXT: writing block 0 of relation 394198/412173 in C:\ms4w\Apache\htdocs\davison\mapping\gis1\viewparcel_nolink.php on line 10


Sounds like a disk fault or disk-full issue.


It looks to me that the query failed based on a hard drive issue.  Well, over the weekend we swapped out the hard drive for new.  The site comes back fine but I'm still receiving the error.
If you have actual data corruption as a result of the disk failure, you may have to restore from a backup. Theoretically data corruption shouldn't happen if a HDD just starts failing writes, but in reality it can happen due to possible resulting file-system corruption, OS issues, or the disk actually returning corrupted blocks on reads.

 

C:\ms4w\apps\pgsql75win\data>del postmaster.pid

Could Not Find C:\ms4w\apps\pgsql75win\data\postmaster.pid


Eek, who/what is doing that?!?

Don't delete the postmaster pid file. If you do so without making EXTREMELY sure there are no backends still running, you risk severe database corruption if you then start a new postmaster.

LOG:  database system was shut down at 2011-08-24 17:30:14 Eastern Standard Time

 

LOG:  checkpoint record is at 0/34CD4078

LOG:  redo record is at 0/34CD4078; undo record is at 0/0; shutdown TRUE

LOG:  next transaction ID: 1198832; next OID: 1772830

LOG:  database system is ready

 

 

I'm not sure if the database is up or not.


Well, it's running.

I don't even see postgresql or mapserver as Windows services.


How did you start it? If you didn't start it with "net service" or using the "services.msc" MMC snapin, it won't start as a service. It looks like you used some kind of batch file to start it under your own user account instead, but you haven't shown the full command line(s) involved.

--
Craig Ringer
--------------050401000000030209030808--