BUG #13460: ERROR: could not find block containing chunk 0x2930072
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@qq.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
--
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs
1809563951@qq.com writes:
The database log error:
ERROR: could not find block containing chunk 0x2930072
That should not happen. Can you provide a self-contained test case
to reproduce this? The query alone is not much help.
(For the record, 9.1.10 is a couple years out of date. But I don't
recall that we've fixed any bugs recently with this sort of symptom.)
regards, tom lane
--
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs