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