BUG #11025: could not access status of transaction 7

Поиск
Список
Период
Сортировка
От shiguangsheng@huawei.com
Тема BUG #11025: could not access status of transaction 7
Дата
Msg-id 20140723072420.27765.68794@wrigleys.postgresql.org
обсуждение исходный текст
Ответы Re: BUG #11025: could not access status of transaction 7  (Tom Lane <tgl@sss.pgh.pa.us>)
Список 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 по дате отправления:

Предыдущее
От: PatilChandakantK@Gmail.com
Дата:
Сообщение: BUG #11024: Exported CSV name is not correct.
Следующее
От: Tom Lane
Дата:
Сообщение: Re: BUG #11025: could not access status of transaction 7