pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feed8.1.3 Problem
2+ messages / 2 participants
[nested] [flat]
* 8.1.3 Problem
@ 2007-01-31 21:08 Chris Hoover <revoohc@gmail.com>
0 siblings, 1 reply; 2+ messages in thread
From: Chris Hoover @ 2007-01-31 21:08 UTC (permalink / raw)
To: pgsql-admin
I am starting to have some significant problems with one of my
8.1.3databases. I am getting more and more of these errors:
wbd,20552,dholton,2007-01-31 15:32:27.137 EST,45c0fcb4.5048,16,2007-01-31
15:31:48 EST,342126177,UPDATE,ERROR: could not access status of transaction
253762136
wbd,20552,dholton,2007-01-31 15:32:27.137 EST,45c0fcb4.5048,17,2007-01-31
15:31:48 EST,342126177,UPDATE,DETAIL: could not open file "pg_clog/00F2":
No such file or directory
This is happening more and more, and on seeming random databases. Any idea
what is going on? I have already dumped and reloaded 2-3 of my databases
and now have about 3 more suffering from this.
Right now, I can't upgrade to 8.1.6 until around March (have to wait until
the current release of our application is released). I have 7 databases
running 8.1.3 (6 prod and 1 test/dev) and only the test/dev is exhibiting
this problem
Any help/ideas on what is going on and how to fix would be appreciated.
Chris
^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: 8.1.3 Problem
@ 2007-02-01 07:02 Shoaib Mir <shoaibmir@gmail.com>
parent: Chris Hoover <revoohc@gmail.com>
0 siblings, 0 replies; 2+ messages in thread
From: Shoaib Mir @ 2007-02-01 07:02 UTC (permalink / raw)
To: Chris Hoover <revoohc@gmail.com>; +Cc: pgsql-admin
It looks like to be a data corruption case.... a few cases like this have
been discussed in the past as well. The following link -->
http://archives.postgresql.org/pgsql-general/2006-12/msg01546.php might help
you resolve the problem.
--------------
Shoaib Mir
EnterpriseDB (www.enterprisedb.com)
On 2/1/07, Chris Hoover <revoohc@gmail.com> wrote:
>
> I am starting to have some significant problems with one of my 8.1.3databases. I am getting more and more of these errors:
> wbd,20552,dholton,2007-01-31 15:32:27.137 EST,45c0fcb4.5048,16,2007-01-31
> 15:31:48 EST,342126177,UPDATE,ERROR: could not access status of transaction
> 253762136
> wbd,20552,dholton,2007-01-31 15:32:27.137 EST,45c0fcb4.5048,17,2007-01-31
> 15:31:48 EST,342126177,UPDATE,DETAIL: could not open file "pg_clog/00F2":
> No such file or directory
>
>
> This is happening more and more, and on seeming random databases. Any
> idea what is going on? I have already dumped and reloaded 2-3 of my
> databases and now have about 3 more suffering from this.
>
> Right now, I can't upgrade to 8.1.6 until around March (have to wait until
> the current release of our application is released). I have 7 databases
> running 8.1.3 (6 prod and 1 test/dev) and only the test/dev is exhibiting
> this problem
>
> Any help/ideas on what is going on and how to fix would be appreciated.
>
> Chris
>
^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2007-02-01 07:02 UTC | newest]
Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2007-01-31 21:08 8.1.3 Problem Chris Hoover <revoohc@gmail.com>
2007-02-01 07:02 ` Shoaib Mir <shoaibmir@gmail.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