From: | Kurt Roeckx <Q(at)ping(dot)be> |
---|---|
To: | pgsql-hackers(at)postgresql(dot)org |
Subject: | Transaction problem? |
Date: | 2003-04-15 22:36:20 |
Message-ID: | 20030415223620.GA26386@ping.be |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
I'm not exactly sure what the problem is, or how it happened.
I have a database where I deleted all records from all tables. I
run a vacuum full and am left with about 1 GB of data.
What I think is happening is that it somehow thinks that data is
still in use by an other transanction, but that is not the case.
I even restated to make sure.
Anybody got any idea how this could have happened?
I once saw this in the log, and think it might be related:
2003-04-12 21:30:55 LOG: database system was interrupted at
2003-04-12 21:30:35 CEST
2003-04-12 21:30:55 LOG: checkpoint record is at 1/1DC89028
2003-04-12 21:30:55 LOG: redo record is at 1/1C128B54; undo
record is at 0/0; shutdown FALSE
2003-04-12 21:30:55 LOG: next transaction id: 741; next oid:
9753304
2003-04-12 21:30:55 LOG: database system was not properly shut
down; automatic
recovery in progress
2003-04-12 21:30:55 LOG: redo starts at 1/1C128B54
2003-04-12 21:32:23 LOG: ReadRecord: unexpected pageaddr
1/15AE2000 in log file 1, segment 36, offset 11411456
2003-04-12 21:32:23 LOG: redo done at 1/24AE0B60
Should I worry about that "unexpected pageaddr"? It ussually
says "ReadRecord: record with zero length" after an unclean shut
down.
Kurt
From | Date | Subject | |
---|---|---|---|
Next Message | Richard Welty | 2003-04-15 22:43:48 | high availability (was Upgrade to Red Hat Linux 9 broke PostgreSQL) |
Previous Message | Guy Fraser | 2003-04-15 22:26:46 | Re: Upgrade to Red Hat Linux 9 broke PostgreSQL |