pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedWhat is postgresql status? I'm not sure
3+ messages / 3 participants
[nested] [flat]
* What is postgresql status? I'm not sure
@ 2011-08-24 18:09 Mcleod, John <johnm@spicergroup.com>
2011-08-26 07:00 ` Re: What is postgresql status? I'm not sure Lukasz Brodziak <lukasz.brodziak@gmail.com>
2011-08-28 13:43 ` Re: What is postgresql status? I'm not sure Craig Ringer <ringerc@ringerc.id.au>
0 siblings, 2 replies; 3+ messages in thread
From: Mcleod, John @ 2011-08-24 18:09 UTC (permalink / raw)
To: pgsql-admin
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
Warning: pg_fetch_row(): supplied argument is not a valid PostgreSQL result resource in C:\ms4w\Apache\htdocs\davison\mapping\gis1\viewparcel_nolink.php on line 12
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.
Another notice is when I shutdown and restart the database, I get this...
C:\ms4w\apps\pgsql75win>cd c:\
C:\>cd ms4w/apps/pgsql75win/data/
C:\ms4w\apps\pgsql75win\data>del postmaster.pid
Could Not Find C:\ms4w\apps\pgsql75win\data\postmaster.pid
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.
I don't even see postgresql or mapserver as Windows services.
I'm very confused.
Thank you for any help with this continuing problem.
John
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: What is postgresql status? I'm not sure
2011-08-24 18:09 What is postgresql status? I'm not sure Mcleod, John <johnm@spicergroup.com>
@ 2011-08-26 07:00 ` Lukasz Brodziak <lukasz.brodziak@gmail.com>
1 sibling, 0 replies; 3+ messages in thread
From: Lukasz Brodziak @ 2011-08-26 07:00 UTC (permalink / raw)
To: Mcleod, John <johnm@spicergroup.com>; +Cc: pgsql-admin
First thing to check is wether the postmaster.pid file has been created in
data folder. If so try to log into the server using pgAdmin (if You don't
know the password to the server You can change authentication mode to trust
in pg_hba.conf file). If not go to event viewer:
1. Click *Start*, and then click *Control Panel*. Click *Performance and
Maintenance*, then click *Administrative Tools*, and then
double-click *Computer
Management*. Or, open the MMC containing the Event Viewer snap-in.
2. In the console tree, click *Event Viewer*.
And look for eny errors regarding PostgreSQL. Feel free to post any of the
errors here to find further support.
2011/8/24 Mcleod, John <johnm@spicergroup.com>
> 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
> ****
>
> ** **
>
> Warning: pg_fetch_row(): supplied argument is not a valid PostgreSQL result
> resource in C:\ms4w\Apache\htdocs\davison\mapping\gis1\viewparcel_nolink.php
> on line 12****
>
> ** **
>
> ** **
>
> 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. ****
>
> ** **
>
> Another notice is when I shutdown and restart the database, I get this…***
> *
>
> ** **
>
> C:\ms4w\apps\pgsql75win>cd c:\****
>
> ** **
>
> C:\>cd ms4w/apps/pgsql75win/data/****
>
> ** **
>
> C:\ms4w\apps\pgsql75win\data>del postmaster.pid****
>
> Could Not Find C:\ms4w\apps\pgsql75win\data\postmaster.pid****
>
> 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.****
>
> I don't even see postgresql or mapserver as Windows services.****
>
> I'm very confused.****
>
> ** **
>
> Thank you for any help with this continuing problem.****
>
> ** **
>
> John****
>
--
Łukasz Brodziak
"Do you bury me when I'm gone
Do you teach me while I'm here
Just as soon I belong
Then it's time I disappear"
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: What is postgresql status? I'm not sure
2011-08-24 18:09 What is postgresql status? I'm not sure Mcleod, John <johnm@spicergroup.com>
@ 2011-08-28 13:43 ` Craig Ringer <ringerc@ringerc.id.au>
1 sibling, 0 replies; 3+ messages in thread
From: Craig Ringer @ 2011-08-28 13:43 UTC (permalink / raw)
To: Mcleod, John <johnm@spicergroup.com>; +Cc: pgsql-admin
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
^ permalink raw reply [nested|flat] 3+ messages in thread
end of thread, other threads:[~2011-08-28 13:43 UTC | newest]
Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2011-08-24 18:09 What is postgresql status? I'm not sure Mcleod, John <johnm@spicergroup.com>
2011-08-26 07:00 ` Re: What is postgresql status? I'm not sure Lukasz Brodziak <lukasz.brodziak@gmail.com>
2011-08-28 13:43 ` Craig Ringer <ringerc@ringerc.id.au>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox