Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1aQxIy-0006PU-SD for pgsql-admin@arkaria.postgresql.org; Wed, 03 Feb 2016 13:17:08 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.84) (envelope-from ) id 1aQxIx-0001rW-VX for pgsql-admin@arkaria.postgresql.org; Wed, 03 Feb 2016 13:17:08 +0000 Received: from makus.postgresql.org ([2001:4800:1501:1::229]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.84) (envelope-from ) id 1aQxIx-0001rJ-B7 for pgsql-admin@postgresql.org; Wed, 03 Feb 2016 13:17:07 +0000 Received: from blog.elster.de ([217.6.110.187] helo=edmmai02.een.elster.de) by makus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.84) (envelope-from ) id 1aQxIq-0004k1-LI for pgsql-admin@postgresql.org; Wed, 03 Feb 2016 13:17:06 +0000 X-IronPort-AV: E=Sophos;i="5.22,390,1449529200"; d="scan'208";a="2415366" Received: from webmail.een.elster.de (HELO edmzarafa01.een.elster.de) ([10.1.20.13]) by edmmai02.een.elster.de with ESMTP; 03 Feb 2016 14:16:56 +0100 Received: from [10.200.128.23] (enmfwa02ext.een.elster.de [192.168.90.2]) by edmzarafa01.een.elster.de (Postfix) with ESMTPSA id 19E822D60380 for ; Wed, 3 Feb 2016 14:16:56 +0100 (CET) Subject: Re: invalid memory alloc request size 18446744073709551614 To: pgsql-admin@postgresql.org References: <1454496310.031717503@apps.rackspace.com> From: "Gunnar \"Nick\" Bluth" X-Enigmail-Draft-Status: N1110 Message-ID: <56B1FDC4.2060502@elster.de> Date: Wed, 3 Feb 2016 14:16:52 +0100 User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:38.0) Gecko/20100101 Thunderbird/38.5.1 MIME-Version: 1.0 In-Reply-To: <1454496310.031717503@apps.rackspace.com> Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: 8bit X-Pg-Spam-Score: -1.7 (-) List-Archive: List-Help: List-ID: List-Owner: List-Post: List-Subscribe: List-Unsubscribe: X-Mailing-List: pgsql-admin Precedence: bulk Sender: pgsql-admin-owner@postgresql.org 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