472,351 Members | 1,528 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 472,351 software developers and data experts.

can't find files in pg_clog and invalid page headers

I am running postgres 7.4Beta1 and have found a problem, I'm not sure if
its a bug or something I did wrong. I ran ANALYZE on a large table while
the database was receiving data, after running it on just my large table I
decided to run it on my entire database. When I issued the database wide
analyze I got an error:

data=# analyze;
ERROR: could not access status of transaction 739760128
DETAIL: open of file "/usr/local/pgsql/data/pg_clog/02C1" failed: No such
file or directory

There is only one file in pg_clog its called 0000. I ran it again and got:

data=# analyze;
ERROR: could not access status of transaction 3942652937
DETAIL: open of file "/usr/local/pgsql/data/pg_clog/0EB0" failed: No such
file or directory

Then I tried running analyze just on my large table again and got:

data=# ANALYZE "DetailedMeters";
ERROR: invalid page header in block 10836 of "DetailedMeters"

Now whenever I try to read all of "DetailedMeters" I get that error message
though the block numbers can change (10832,10834,10836).

Anyone know what I did to cause this? Or is this some sort of bug or
hardware failure?

---- Adam Kavan
---- ak****@cox.net
---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?

http://archives.postgresql.org

Nov 11 '05 #1
3 3695
Adam Kavan <ak****@cox.net> writes:
[unstable failure messages]
Anyone know what I did to cause this? Or is this some sort of bug or
hardware failure?


I think you've got a hardware problem. Have you run memtest86 or
badblocks lately?

regards, tom lane

---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to ma*******@postgresql.org

Nov 11 '05 #2
Adam Kavan <ak****@cox.net> writes:
At 03:19 PM 8/14/03 -0400, Tom Lane wrote:
I think you've got a hardware problem. Have you run memtest86 or
badblocks lately?
My machine has passed badblocks and memtest86 with flying colors. To fix
the table I did a TRUNCATE on it which seems to have worked, but I'm left
with a couple of questions. First, will a TRUNCATEd page wind up in
another table and break it or is that bit fixed for good.


TRUNCATE would just return the page back to the filesystem, which would
eventually reallocate it to some other file (or even the same file).

If it was a one-time problem then it's gone, but I still suspect that
your hardware dropped some bits, and if so it may do so again.

FWIW, I have heard reports of disk problems that were not found by
badblocks unless you used the "destructive test" option.

regards, tom lane

---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to ma*******@postgresql.org so that your
message can get through to the mailing list cleanly

Nov 11 '05 #3
At 03:19 PM 8/14/03 -0400, Tom Lane wrote:
Adam Kavan <ak****@cox.net> writes:
[unstable failure messages]
Anyone know what I did to cause this? Or is this some sort of bug or
hardware failure?


I think you've got a hardware problem. Have you run memtest86 or
badblocks lately?

regards, tom lane


My machine has passed badblocks and memtest86 with flying colors. To fix
the table I did a TRUNCATE on it which seems to have worked, but I'm left
with a couple of questions. First, will a TRUNCATEd page wind up in
another table and break it or is that bit fixed for good. Secondly, I have
been unable to recreate the error, ,so I feel it was probably just a fluke
does anyone disagree?

--- Adam Kavan
--- ak****@cox.net
---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to ma*******@postgresql.org

Nov 11 '05 #4

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

3
by: fdsl ysnh | last post by:
--- python-list-request@python.orgд: > Send Python-list mailing list submissions to > python-list@python.org > > To subscribe or...
32
by: Howard Kaikow | last post by:
I often come upon web pages that do not allow themselves to be saved as a ..html file (complete), but do allow themselves to be saved as .mht files....
2
by: Adam Haberlach | last post by:
We had one of our databases suddenly try to reference a pg_clog file that didn't exist whenever we attempted to select from a certain table. ...
38
by: venkatesh | last post by:
int *p=20; printf("%d",*p); printf("%d",p); the above code prints the output as somegarbage value //for *p(may be address 20 //for p why...
1
by: A Palmblad | last post by:
After trying a vacuum of a table, the following error has been occurring: aers=# vacuum XXXXXX; ERROR: could not access status of transaction...
1
by: Amin Abdulghani | last post by:
Hi, We about a week ago installed a clean version of postgres 7.4.5 for testing purposes. For the last couple of days for any transaction it...
6
by: scottyman | last post by:
I can't make this script work properly. I've gone as far as I can with it and the rest is out of my ability. I can do some html editing but I'm...
4
by: mdh | last post by:
K&R briefly mention splitting programs into seperate files.(page 82) Using my compiler (X-code) I noticed that creating a header file gives, as...
68
by: DaveJ | last post by:
Recently I was working on a project where I came across an issue where the program cored and reported "free(): invalid pointer". I found a...
0
better678
by: better678 | last post by:
Question: Discuss your understanding of the Java platform. Is the statement "Java is interpreted" correct? Answer: Java is an object-oriented...
0
by: teenabhardwaj | last post by:
How would one discover a valid source for learning news, comfort, and help for engineering designs? Covering through piles of books takes a lot of...
0
by: antdb | last post by:
Ⅰ. Advantage of AntDB: hyper-convergence + streaming processing engine In the overall architecture, a new "hyper-convergence" concept was...
0
by: Matthew3360 | last post by:
Hi there. I have been struggling to find out how to use a variable as my location in my header redirect function. Here is my code. ...
2
by: Matthew3360 | last post by:
Hi, I have a python app that i want to be able to get variables from a php page on my webserver. My python app is on my computer. How would I make it...
0
by: AndyPSV | last post by:
HOW CAN I CREATE AN AI with an .executable file that would suck all files in the folder and on my computerHOW CAN I CREATE AN AI with an .executable...
0
hi
by: WisdomUfot | last post by:
It's an interesting question you've got about how Gmail hides the HTTP referrer when a link in an email is clicked. While I don't have the specific...
0
by: Matthew3360 | last post by:
Hi, I have been trying to connect to a local host using php curl. But I am finding it hard to do this. I am doing the curl get request from my web...
0
by: Carina712 | last post by:
Setting background colors for Excel documents can help to improve the visual appeal of the document and make it easier to read and understand....

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.