Re: invalid memory alloc request size 18446744073709551614

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



Am 03.02.2016 um 11:45 schrieb clingareddy@xxxxxxxxxxxxx:
> Hi Team,

Hi,

> 
> While running a Query in PostgreSQL i am getting below error. 
>  
> Query:
>  
> SELECT count(1)  ,SUM (DECODE(cr_ind, 'Y', NVL(numeric_amt, 0), 0))
> cr_amt, SUM (DECODE(cr_ind, 'Y', 0, NVL(numeric_amt, 0))) db_amt ,
> sum(decode(cr_ind, 'Y', 1, 0)) cr_cnt, sum(decode(cr_ind, 'Y', 0, 1))
> db_cnt  FROM ITEM_2015_1 a  WHERE a.NUMERIC_AMT = 13066.00 and
> NVL(a.FLD_6_NUM,0) = 000014 and  a.BUS_DATE  =
>  to_date('11212015','mmddyyyy')  AND EXISTS (SELECT 1 FROM batch_master
> b WHERE a.BUS_DATE = b.BUS_DATE AND a.JOB_ID = b.JOB_ID AND a.BLK_NUM =
> b.BLK_NUM AND a.BCH_NUM = b.BCH_NUM )
> 

I'm pretty sure that it's not about the query (see below).

> Error:
> 
> invalid memory alloc request size 18446744073709551614
> Severity: ERROR
> Code: XX000

As googling the error quickly reveals
http://www.postgresql.org/message-id/5863.1138032323@xxxxxxxxxxxxx
and Tom Lane usually knows what he's talking about, I'd check for data
corruption.

Good luck!
-- 
Gunnar "Nick" Bluth
DBA ELSTER

Tel:   +49 911/991-4665
Mobil: +49 172/8853339


-- 
Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin



[Index of Archives]     [KVM ARM]     [KVM ia64]     [KVM ppc]     [Virtualization Tools]     [Spice Development]     [Libvirt]     [Libvirt Users]     [Linux USB Devel]     [Linux Audio Users]     [Yosemite Questions]     [Linux Kernel]     [Linux SCSI]     [XFree86]

  Powered by Linux