BUG #11025: could not access status of transaction 7

From: shiguangsheng(at)huawei(dot)com
To: pgsql-bugs(at)postgresql(dot)org
Subject: BUG #11025: could not access status of transaction 7
Date: 2014-07-23 07:24:20
Message-ID: 20140723072420.27765.68794@wrigleys.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

The following bug has been logged on the website:

Bug reference: 11025
Logged by: Paul
Email address: shiguangsheng(at)huawei(dot)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)

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Marti Raudsepp 2014-07-23 08:17:32 Re: BUG #10972: string_agg function incorrectly concatenating varying delimiter
Previous Message PatilChandakantK 2014-07-23 07:03:23 BUG #11024: Exported CSV name is not correct.