BUG #11025: could not access status of transaction 7 - Mailing list pgsql-bugs

From shiguangsheng@huawei.com
Subject BUG #11025: could not access status of transaction 7
Date
Msg-id 20140723072420.27765.68794@wrigleys.postgresql.org
Whole thread Raw
Responses Re: BUG #11025: could not access status of transaction 7
List pgsql-bugs
The following bug has been logged on the website:

Bug reference:      11025
Logged by:          Paul
Email address:      shiguangsheng@huawei.com
PostgreSQL version: Unsupported/Unknown
Operating system:   Suse 10
Description:

PostgreSQL version: 8.3.17

I added a function that is used to scan the specified table.
An error occurred while performing this function, this problem occurs only
once.
Error log is as follows(When problems occur the minimal CLOG is 04A0):
AutoVacWorker 30562 2014-07-01 21:37:16.122 GMTERROR:  could not access
status of transaction 7 slru.c(846 SlruReportIOError)
AutoVacWorker 30562 2014-07-01 21:37:16.122 GMTDETAIL:  Could not open file
"pg_clog/0000": No such file or directory.
AutoVacWorker 30562 2014-07-01 21:37:16.122 GMTLOG:  relation
"pg_tablespace" block 1 is corrupted pgstattuple.c(746 pgstat_heap)

Function as follows:
if (InvalidTransactionId == xmin)
{
     xminInvalid = true;
}
else
{
     xminCommit = TransactionIdDidCommit(xmin);
}

if (InvalidTransactionId == xmax)
{
     xmaxInvalid = true;
}
else
{
     xmaxCommit = TransactionIdDidCommit(xmax);
}

The current records of pg_tablespace:
omu=# select cmin, cmax, xmin, xmax, oid, ctid, session_id, tableoid, * from
pg_tablespace;
 cmin | cmax | xmin |    xmax    |   oid   |  ctid  | session_id | tableoid
|  spcname   | spcowner |                spclocation              |
  spcacl            | spcmaxsize

------+------+------+------------+---------+--------+------------+----------+------------+----------+-----------------------------------------+------------------------------+------------
    0 |    0 |    1 |          0 |    1663 | (0,1)  |       1663 |     1213
| pg_default |       10 |                                         |
                    |
    0 |    0 |    1 |          0 |    1664 | (0,2)  |       1664 |     1213
| pg_global  |       10 |                                         |
                    |
    4 |    4 |    2 |          0 |   24576 | (0,4)  |      24576 |     1213
| common     |    16385 | /opt/PROTON/data/tablespaces/common     |
{cgp=C/cgp,common=C/cgp}     | 200
    4 |    4 |    2 |          0 |   24764 | (0,6)  |      24764 |     1213
| pds        |    16385 | /opt/PROTON/data/tablespaces/pds        |
{cgp=C/cgp,pds=C/cgp}        | 1024
    0 |    0 |    2 |          0 |   44596 | (0,10) |      44596 |     1213
| rsm        |    16385 | /opt/PROTON/data/tablespaces/RSM        |
{cgp=C/cgp,rsm=C/cgp}        | 1024
    4 |    4 |    2 |          0 |   44599 | (0,12) |      44599 |     1213
| rsm_temp   |    16385 | /opt/PROTON/data/tablespaces/RSM_TEMP   |
{cgp=C/cgp,rsm_temp=C/cgp}   | 1024
    0 |    0 |    2 | 1438322587 | 1062306 | (0,23) |    1062306 |     1213
| cgp_2      |    16385 | /opt/PROTON/data/tablespaces/CGP_2      |
{cgp=C/cgp,cgp_2=C/cgp}      | 2048
    4 |    4 |    2 | 1438198033 | 1076693 | (0,25) |    1076693 |     1213
| pds_ne0_2  |    16385 | /opt/PROTON/data/tablespaces/PDS_NE0_2  |
{cgp=C/cgp,pds_ne0_2=C/cgp}  | 2048
    4 |    4 |    2 |          0 | 1079204 | (0,29) |    1079204 |     1213
| ne91_2     |    16385 | /opt/PROTON/data/tablespaces/NE91_2     |
{cgp=C/cgp,ne91_2=C/cgp}     | 10240
    0 |    0 |    2 | 1438198014 | 1086436 | (0,31) |    1086436 |     1213
| pds_ne91_2 |    16385 | /opt/PROTON/data/tablespaces/PDS_NE91_2 |
{cgp=C/cgp,pds_ne91_2=C/cgp} | 10240
    0 |    0 |    2 | 1436886388 | 1089045 | (0,35) |    1089045 |     1213
| ne81_2     |    16385 | /opt/PROTON/data/tablespaces/NE81_2     |
{cgp=C/cgp,ne81_2=C/cgp}     | 1024
    0 |    0 |    2 | 1438198230 | 1097644 | (0,37) |    1097644 |     1213
| pds_ne81_2 |    16385 | /opt/PROTON/data/tablespaces/PDS_NE81_2 |
{cgp=C/cgp,pds_ne81_2=C/cgp} | 10240
(12 rows)

pgsql-bugs by date:

Previous
From: PatilChandakantK@Gmail.com
Date:
Subject: BUG #11024: Exported CSV name is not correct.
Next
From: Tom Lane
Date:
Subject: Re: BUG #11025: could not access status of transaction 7