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
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 |