Обсуждение: BUG #13460: ERROR: could not find block containing chunk 0x2930072

Поиск
Список
Период
Сортировка

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

От
1809563951@qq.com
Дата:
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

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

От
Tom Lane
Дата:
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