pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedurgent
11+ messages / 9 participants
[nested] [flat]
* urgent
@ 2000-10-14 13:00 waheed rahman <waheed_rahuman@yahoo.com>
0 siblings, 1 reply; 11+ messages in thread
From: waheed rahman @ 2000-10-14 13:00 UTC (permalink / raw)
To: bk218@hermes.cam.ac.uk; +Cc: pgsql-admin
Hello
This is waheed from Dubai.I have downloaded the
postgresql software.I request you to send the system
configuration.I want to know whether it will run on
windowsnt or unix or linux.
thank you
waheed.
__________________________________________________
Do You Yahoo!?
Yahoo! Messenger - Talk while you surf! It's FREE.
http://im.yahoo.com/
^ permalink raw reply [nested|flat] 11+ messages in thread
* Re: urgent
@ 2000-10-14 18:31 Gavin M. Roy <gmr@readysetnet.com>
parent: waheed rahman <waheed_rahuman@yahoo.com>
0 siblings, 0 replies; 11+ messages in thread
From: Gavin M. Roy @ 2000-10-14 18:31 UTC (permalink / raw)
To: waheed rahman <waheed_rahuman@yahoo.com>; +Cc: bk218@hermes.cam.ac.uk; pgsql-admin
Yes. :) You can compile PostgresQL on Unix, Linux, and I believe with
the right tools, Windows NT?
Gavin
waheed rahman wrote:
> Hello
> This is waheed from Dubai.I have downloaded the
> postgresql software.I request you to send the system
> configuration.I want to know whether it will run on
> windowsnt or unix or linux.
> thank you
> waheed.
>
> __________________________________________________
> Do You Yahoo!?
> Yahoo! Messenger - Talk while you surf! It's FREE.
> http://im.yahoo.com/
^ permalink raw reply [nested|flat] 11+ messages in thread
* Urgent!
@ 2005-10-13 01:18 Nirav Parikh <nirav.p@workskillsprofessionals.com.au>
0 siblings, 2 replies; 11+ messages in thread
From: Nirav Parikh @ 2005-10-13 01:18 UTC (permalink / raw)
To: pgsql-admin
Hi,
I got this error message when I tried to do pg_dump on the database.
pg_dump: ERROR: invalid memory alloc request size 4294967293
pg_dump: SQL command to dump the contents of table "wordlist" failed:
PQendcopy() failed.
pg_dump: Error message from server: ERROR: invalid memory alloc request
size 4294967293
pg_dump: The command was: COPY public.wordlist (word_id, word,
count_word) TO stdout;
I went to phppgadmin and try to access the worldlist table and it also
gives me following error message:
ERROR: could not access status of transaction 6849340
DETAIL: could not open file "/var/lib/pgsql/data/pg_clog/0006": No such
file or directory
In statement:
SELECT COUNT(*) AS total FROM (SELECT "oid", * FROM "public"."wordlist")
AS sub
CPU was heating up so I turn off the computer and to fix the problem
and after that this occour. I don't know if this has anything to with
database corruption.
This is production server and I don't have latest backup does anyone how
to resolve this.
Please Help
Regards,
Nirav Parikh
^ permalink raw reply [nested|flat] 11+ messages in thread
* Re: Urgent!
@ 2005-10-13 15:30 codeWarrior <gpatnude@hotmail.com>
parent: Nirav Parikh <nirav.p@workskillsprofessionals.com.au>
1 sibling, 1 reply; 11+ messages in thread
From: codeWarrior @ 2005-10-13 15:30 UTC (permalink / raw)
To: pgsql-admin
Lookas as if you've managed to turn off your computer mid-transaction
thereby corrupting the postgreSQL commit logs (pg_clog)...
You should never just turn off a database server... always shut it down
normally... Turning it off was a major mistake. I dont know if you can
recover or not as the system (postgreSQL) now thinks it is in the middle of
a transaction...
As far as recovery goes... You might try a vacuum full and pg_resetxlog
(search the postgreSQL docs for pg_resetxlog)... Other than that you might
need to get Tom Lane's attention on this one...
""Nirav Parikh"" <nirav.p@workskillsprofessionals.com.au> wrote in message
news:221385EC3F18A44DB0925467A1D2395F38FB07@exsrv3.workskillsprofessionals.com.au...
Hi,
I got this error message when I tried to do pg_dump on the database.
pg_dump: ERROR: invalid memory alloc request size 4294967293
pg_dump: SQL command to dump the contents of table "wordlist" failed:
PQendcopy() failed.
pg_dump: Error message from server: ERROR: invalid memory alloc request
size 4294967293
pg_dump: The command was: COPY public.wordlist (word_id, word, count_word)
TO stdout;
I went to phppgadmin and try to access the worldlist table and it also gives
me following error message:
ERROR: could not access status of transaction 6849340
DETAIL: could not open file "/var/lib/pgsql/data/pg_clog/0006": No such
file or directory
In statement:
SELECT COUNT(*) AS total FROM (SELECT "oid", * FROM "public"."wordlist") AS
sub
CPU was heating up so I turn off the computer and to fix the problem and
after that this occour. I don't know if this has anything to with database
corruption.
This is production server and I don't have latest backup does anyone how to
resolve this.
Please Help
Regards,
Nirav Parikh
^ permalink raw reply [nested|flat] 11+ messages in thread
* Re: Urgent!
@ 2005-10-13 15:46 Anjan Dave <adave@vantage.com>
0 siblings, 0 replies; 11+ messages in thread
From: Anjan Dave @ 2005-10-13 15:46 UTC (permalink / raw)
To: codeWarrior <gpatnude@hotmail.com>; pgsql-admin
I've been through a similar situation before (partition was full, and
subsequently, PG wasn't able to access a pg_clog/<one file>.
Tom Lane had referred me to another archive about zeroing out that
particular file, which had worked for me and the database was up.
And yes, don't shutdown the machine like that.
Thanks,
Anjan
-----Original Message-----
From: codeWarrior [mailto:gpatnude@hotmail.com]
Sent: Thursday, October 13, 2005 11:31 AM
To: pgsql-admin@postgresql.org
Subject: Re: [ADMIN] Urgent!
Lookas as if you've managed to turn off your computer mid-transaction
thereby corrupting the postgreSQL commit logs (pg_clog)...
You should never just turn off a database server... always shut it down
normally... Turning it off was a major mistake. I dont know if you can
recover or not as the system (postgreSQL) now thinks it is in the middle
of
a transaction...
As far as recovery goes... You might try a vacuum full and pg_resetxlog
(search the postgreSQL docs for pg_resetxlog)... Other than that you
might
need to get Tom Lane's attention on this one...
""Nirav Parikh"" <nirav.p@workskillsprofessionals.com.au> wrote in
message
news:221385EC3F18A44DB0925467A1D2395F38FB07@exsrv3.workskillsprofessiona
ls.com.au...
Hi,
I got this error message when I tried to do pg_dump on the database.
pg_dump: ERROR: invalid memory alloc request size 4294967293
pg_dump: SQL command to dump the contents of table "wordlist" failed:
PQendcopy() failed.
pg_dump: Error message from server: ERROR: invalid memory alloc request
size 4294967293
pg_dump: The command was: COPY public.wordlist (word_id, word,
count_word)
TO stdout;
I went to phppgadmin and try to access the worldlist table and it also
gives
me following error message:
ERROR: could not access status of transaction 6849340
DETAIL: could not open file "/var/lib/pgsql/data/pg_clog/0006": No such
file or directory
In statement:
SELECT COUNT(*) AS total FROM (SELECT "oid", * FROM "public"."wordlist")
AS
sub
CPU was heating up so I turn off the computer and to fix the problem
and
after that this occour. I don't know if this has anything to with
database
corruption.
This is production server and I don't have latest backup does anyone how
to
resolve this.
Please Help
Regards,
Nirav Parikh
---------------------------(end of broadcast)---------------------------
TIP 2: Don't 'kill -9' the postmaster
^ permalink raw reply [nested|flat] 11+ messages in thread
* Re: Urgent!
@ 2005-10-13 15:56 Bruce Momjian <pgman@candle.pha.pa.us>
parent: codeWarrior <gpatnude@hotmail.com>
0 siblings, 2 replies; 11+ messages in thread
From: Bruce Momjian @ 2005-10-13 15:56 UTC (permalink / raw)
To: codeWarrior <gpatnude@hotmail.com>; +Cc: pgsql-admin
codeWarrior wrote:
> Lookas as if you've managed to turn off your computer mid-transaction
> thereby corrupting the postgreSQL commit logs (pg_clog)...
>
> You should never just turn off a database server... always shut it down
> normally... Turning it off was a major mistake. I dont know if you can
> recover or not as the system (postgreSQL) now thinks it is in the middle of
> a transaction...
PostgreSQL should never get corrupted by turning off the server. It
isn't ideal to do that, but it should not get corrupted.
---------------------------------------------------------------------------
>
> As far as recovery goes... You might try a vacuum full and pg_resetxlog
> (search the postgreSQL docs for pg_resetxlog)... Other than that you might
> need to get Tom Lane's attention on this one...
>
>
>
> ""Nirav Parikh"" <nirav.p@workskillsprofessionals.com.au> wrote in message
> news:221385EC3F18A44DB0925467A1D2395F38FB07@exsrv3.workskillsprofessionals.com.au...
> Hi,
>
> I got this error message when I tried to do pg_dump on the database.
>
> pg_dump: ERROR: invalid memory alloc request size 4294967293
> pg_dump: SQL command to dump the contents of table "wordlist" failed:
> PQendcopy() failed.
> pg_dump: Error message from server: ERROR: invalid memory alloc request
> size 4294967293
> pg_dump: The command was: COPY public.wordlist (word_id, word, count_word)
> TO stdout;
>
> I went to phppgadmin and try to access the worldlist table and it also gives
> me following error message:
>
> ERROR: could not access status of transaction 6849340
> DETAIL: could not open file "/var/lib/pgsql/data/pg_clog/0006": No such
> file or directory
>
> In statement:
> SELECT COUNT(*) AS total FROM (SELECT "oid", * FROM "public"."wordlist") AS
> sub
>
> CPU was heating up so I turn off the computer and to fix the problem and
> after that this occour. I don't know if this has anything to with database
> corruption.
>
> This is production server and I don't have latest backup does anyone how to
> resolve this.
>
> Please Help
>
> Regards,
>
> Nirav Parikh
>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 2: Don't 'kill -9' the postmaster
>
--
Bruce Momjian | http://candle.pha.pa.us
pgman@candle.pha.pa.us | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073
^ permalink raw reply [nested|flat] 11+ messages in thread
* Re: Urgent!
@ 2005-10-13 16:12 Alvaro Herrera <alvherre@alvh.no-ip.org>
parent: Nirav Parikh <nirav.p@workskillsprofessionals.com.au>
1 sibling, 0 replies; 11+ messages in thread
From: Alvaro Herrera @ 2005-10-13 16:12 UTC (permalink / raw)
To: Nirav Parikh <nirav.p@workskillsprofessionals.com.au>; +Cc: pgsql-admin
Nirav Parikh wrote:
> Hi,
>
> I got this error message when I tried to do pg_dump on the database.
>
> pg_dump: ERROR: invalid memory alloc request size 4294967293
> pg_dump: SQL command to dump the contents of table "wordlist" failed:
> PQendcopy() failed.
> pg_dump: Error message from server: ERROR: invalid memory alloc request
> size 4294967293
> pg_dump: The command was: COPY public.wordlist (word_id, word,
> count_word) TO stdout;
>
> I went to phppgadmin and try to access the worldlist table and it also
> gives me following error message:
>
> ERROR: could not access status of transaction 6849340
> DETAIL: could not open file "/var/lib/pgsql/data/pg_clog/0006": No such
> file or directory
What version is this? Also, is the system running with fsync=off or on
disks with write cache enabled?
--
Alvaro Herrera Valdivia, Chile ICBM: S 39º 49' 17.7", W 73º 14' 26.8"
"La fuerza no está en los medios físicos
sino que reside en una voluntad indomable" (Gandhi)
^ permalink raw reply [nested|flat] 11+ messages in thread
* Re: Urgent!
@ 2005-10-13 16:21 Scott Marlowe <smarlowe@g2switchworks.com>
parent: Bruce Momjian <pgman@candle.pha.pa.us>
1 sibling, 1 reply; 11+ messages in thread
From: Scott Marlowe @ 2005-10-13 16:21 UTC (permalink / raw)
To: Bruce Momjian <pgman@candle.pha.pa.us>; +Cc: codeWarrior <gpatnude@hotmail.com>; pgsql-admin
On Thu, 2005-10-13 at 10:56, Bruce Momjian wrote:
> codeWarrior wrote:
> > Lookas as if you've managed to turn off your computer mid-transaction
> > thereby corrupting the postgreSQL commit logs (pg_clog)...
> >
> > You should never just turn off a database server... always shut it down
> > normally... Turning it off was a major mistake. I dont know if you can
> > recover or not as the system (postgreSQL) now thinks it is in the middle of
> > a transaction...
>
> PostgreSQL should never get corrupted by turning off the server. It
> isn't ideal to do that, but it should not get corrupted.
Unless it is installed on hardware that lies about fsync.
Which almost all ATA drives, parallel and serial, do, sadly.
^ permalink raw reply [nested|flat] 11+ messages in thread
* Re: Urgent!
@ 2005-10-13 16:23 Bruce Momjian <pgman@candle.pha.pa.us>
parent: Scott Marlowe <smarlowe@g2switchworks.com>
0 siblings, 1 reply; 11+ messages in thread
From: Bruce Momjian @ 2005-10-13 16:23 UTC (permalink / raw)
To: Scott Marlowe <smarlowe@g2switchworks.com>; +Cc: codeWarrior <gpatnude@hotmail.com>; pgsql-admin
Scott Marlowe wrote:
> On Thu, 2005-10-13 at 10:56, Bruce Momjian wrote:
> > codeWarrior wrote:
> > > Lookas as if you've managed to turn off your computer mid-transaction
> > > thereby corrupting the postgreSQL commit logs (pg_clog)...
> > >
> > > You should never just turn off a database server... always shut it down
> > > normally... Turning it off was a major mistake. I dont know if you can
> > > recover or not as the system (postgreSQL) now thinks it is in the middle of
> > > a transaction...
> >
> > PostgreSQL should never get corrupted by turning off the server. It
> > isn't ideal to do that, but it should not get corrupted.
>
> Unless it is installed on hardware that lies about fsync.
>
> Which almost all ATA drives, parallel and serial, do, sadly.
Ah, yes, that one. We do have a section in the 8.1 beta docs about that
which will help in the future:
http://candle.pha.pa.us/main/writings/pgsql/sgml/reliability.html
--
Bruce Momjian | http://candle.pha.pa.us
pgman@candle.pha.pa.us | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073
^ permalink raw reply [nested|flat] 11+ messages in thread
* Re: Urgent!
@ 2005-10-13 16:29 Scott Marlowe <smarlowe@g2switchworks.com>
parent: Bruce Momjian <pgman@candle.pha.pa.us>
0 siblings, 0 replies; 11+ messages in thread
From: Scott Marlowe @ 2005-10-13 16:29 UTC (permalink / raw)
To: Bruce Momjian <pgman@candle.pha.pa.us>; +Cc: codeWarrior <gpatnude@hotmail.com>; pgsql-admin
On Thu, 2005-10-13 at 11:23, Bruce Momjian wrote:
> Scott Marlowe wrote:
> > On Thu, 2005-10-13 at 10:56, Bruce Momjian wrote:
> > > codeWarrior wrote:
> > > > Lookas as if you've managed to turn off your computer mid-transaction
> > > > thereby corrupting the postgreSQL commit logs (pg_clog)...
> > > >
> > > > You should never just turn off a database server... always shut it down
> > > > normally... Turning it off was a major mistake. I dont know if you can
> > > > recover or not as the system (postgreSQL) now thinks it is in the middle of
> > > > a transaction...
> > >
> > > PostgreSQL should never get corrupted by turning off the server. It
> > > isn't ideal to do that, but it should not get corrupted.
> >
> > Unless it is installed on hardware that lies about fsync.
> >
> > Which almost all ATA drives, parallel and serial, do, sadly.
>
> Ah, yes, that one. We do have a section in the 8.1 beta docs about that
> which will help in the future:
>
> http://candle.pha.pa.us/main/writings/pgsql/sgml/reliability.html
I still remember when I found out that basically all IDE drives lied
about this. So I built my server with battery backed cache and SCSI
drives, and part of it's acceptance testing was having a heavy
transactional load placed on it and have the power switch flipped off.
We did that about 10 times with different loads, and it never failed to
come right back up.
So, 6 months later, when an electrician dropped a piece of clipped off
copper wire into one of our three power conditioners in the hosting
center, thereby causing an overload that blew out all three power
conditioners AND the UPSes they were connected to, and emergency power
was restored, my machine was the only one in a hosting center of about
100 servers that came up perfectly.
Well, almost perfectly. We had to reboot it because it came up too fast
and none of the nfs servers it normally sees were there yet. The nfs
servers were all bsd boxes, and they all came up too, except for the
ones with >1 fried drives in their RAID 5s, which was only a couple.
It was nice knowing my research and all on PostgreSQL had paid off.
There were plenty of machines with MySQL and with Oracle which did not
survive the power outage.
^ permalink raw reply [nested|flat] 11+ messages in thread
* Re: Urgent!
@ 2005-10-13 16:31 Tom Lane <tgl@sss.pgh.pa.us>
parent: Bruce Momjian <pgman@candle.pha.pa.us>
1 sibling, 0 replies; 11+ messages in thread
From: Tom Lane @ 2005-10-13 16:31 UTC (permalink / raw)
To: pgsql-admin
Bruce Momjian <pgman@candle.pha.pa.us> writes:
>> You should never just turn off a database server... always shut it down
>> normally... Turning it off was a major mistake.
> PostgreSQL should never get corrupted by turning off the server. It
> isn't ideal to do that, but it should not get corrupted.
We can only make that promise if we are on hardware that doesn't lie to
us about disk write completion ... if this machine is generic PC
hardware it's probably not configured properly.
The symptoms sound to me like corrupt data (probably due to a partial
page disk write). There isn't going to be any magic fix, but you can
probably recover everything but the specific damaged page(s). See the
mailing list archives for previous discussions of cleaning up data
corruption.
regards, tom lane
^ permalink raw reply [nested|flat] 11+ messages in thread
end of thread, other threads:[~2005-10-13 16:31 UTC | newest]
Thread overview: 11+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2000-10-14 13:00 urgent waheed rahman <waheed_rahuman@yahoo.com>
2000-10-14 18:31 ` Gavin M. Roy <gmr@readysetnet.com>
2005-10-13 01:18 Urgent! Nirav Parikh <nirav.p@workskillsprofessionals.com.au>
2005-10-13 15:30 ` Re: Urgent! codeWarrior <gpatnude@hotmail.com>
2005-10-13 15:56 ` Re: Urgent! Bruce Momjian <pgman@candle.pha.pa.us>
2005-10-13 16:21 ` Re: Urgent! Scott Marlowe <smarlowe@g2switchworks.com>
2005-10-13 16:23 ` Re: Urgent! Bruce Momjian <pgman@candle.pha.pa.us>
2005-10-13 16:29 ` Re: Urgent! Scott Marlowe <smarlowe@g2switchworks.com>
2005-10-13 16:31 ` Re: Urgent! Tom Lane <tgl@sss.pgh.pa.us>
2005-10-13 16:12 ` Re: Urgent! Alvaro Herrera <alvherre@alvh.no-ip.org>
2005-10-13 15:46 Re: Urgent! Anjan Dave <adave@vantage.com>
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