BUG #13460: ERROR: could not find block containing chunk 0x2930072

From: 1809563951(at)qq(dot)com
To: pgsql-bugs(at)postgresql(dot)org
Subject: BUG #13460: ERROR: could not find block containing chunk 0x2930072
Date: 2015-06-22 13:15:52
Message-ID: 20150622131552.3874.21539@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: 13460
Logged by: ERROR: could not find block containing chunk 0x2930072
Email address: 1809563951(at)qq(dot)com
PostgreSQL version: 9.1.10
Operating system: centos
Description:

The database log error:
ERROR: could not find block containing chunk 0x2930072
STATEMENT: insert into
T_FM_SALEINFO(id,agenid,busiid,ecrno,appregno,rrstno,patchno,itemid,saledate,saleamount,saleprice,nsalesum,salesum,remark,recetime,updatename,lasttime,code,nrrstno,customercode,customername,ipaddr)
select
nextval('s_t_fm_saleinfo'),a.agenid,b.busiid,a.ecrno,a.appregno,a.rrstno,a.patchno,c.itemid,a.saledate,a.saleamount,a.nsalesum/a.saleamount,a.nsalesum,a.salesum,a.remark,a.recetime,a.updatename,a.lasttime,a.code,a.nrrstno,a.customercode,a.customername,a.ipaddr
from LS_T_FM_SALEINFOO a, t_fm_business b, t_fm_cfg_ecritem c where c.agenid
= b.agenid and c.busiid = b.busiid and c.pluno = a.pluno and b.agenid =
a.agenid and b.code = a.code and a.agenid = 499

Is there anything wrong ?
thanks a lot

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Tom Lane 2015-06-22 13:41:07 Re: BUG #13458: postgres_fdw with usermapping dumped with pg_dump --no-owners results in dump file with implicit own
Previous Message chris+postgresql 2015-06-22 08:42:01 BUG #13459: Replaying WAL logs can hang on startup