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.