From: Gunnar \"Nick\" Bluth <gunnar.bluth.extern@elster.de>
To: pgsql-admin@postgresql.org
Subject: Re: invalid memory alloc request size 18446744073709551614
Date: Wed, 3 Feb 2016 14:16:52 +0100
Message-ID: <56B1FDC4.2060502@elster.de> (raw)
In-Reply-To: <1454496310.031717503@apps.rackspace.com>
References: <1454496310.031717503@apps.rackspace.com>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-admin>
Am 03.02.2016 um 11:45 schrieb clingareddy@vsoftcorp.com:
> 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@sss.pgh.pa.us
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@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: gunnar.bluth.extern@elster.de
Subject: Re: invalid memory alloc request size 18446744073709551614
In-Reply-To: <56B1FDC4.2060502@elster.de>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox