BUG #8245: Urgent:Query on slave failing with invalid memory alloc request size 18446744073709537559

From: kapplegate(at)apsalar(dot)com
To: pgsql-bugs(at)postgresql(dot)org
Subject: BUG #8245: Urgent:Query on slave failing with invalid memory alloc request size 18446744073709537559
Date: 2013-06-21 14:05:00
Message-ID: E1Uq1xU-0003lP-Qe@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: 8245
Logged by: Kim Applegate
Email address: kapplegate(at)apsalar(dot)com
PostgreSQL version: 9.2.4
Operating system: OpenIndiana
Description:

One of our queries has started failing randomly on our slaves with

invalid memory alloc request size 18446744073709537559

This is eventually repeatable on any slave that has failed. Of the 64 slaves
it will fail on 1-5 of them for any given run. The stored procedure that is
failing queries on a partition with 64 children and only returns rows from 4
of the child tables.

Turning Debug on in the logs only gives this

Jun 20 06:50:53 * postgres[14825]: [ID 748848 local2.warning] [27-1] ERROR:
invalid memory alloc request size 18446744073709532101
Jun 20 06:50:53 * postgres[14825]: [ID 748848 local2.warning] [27-2]
CONTEXT: SQL function "events_args_top500_week" statement 1
Jun 20 06:50:53 * postgres[14825]: [ID 748848 local2.debug] [28-1] DEBUG:
shmem_exit(0): 7 callbacks to make
Jun 20 06:50:53 * postgres[14825]: [ID 748848 local2.debug] [29-1] DEBUG:
proc_exit(0): 3 callbacks to make
Jun 20 06:50:53 * postgres[14825]: [ID 748848 local2.debug] [30-1] DEBUG:
exit(0)
Jun 20 06:50:53 * postgres[14825]: [ID 748848 local2.debug] [31-1] DEBUG:
shmem_exit(-1): 0 callbacks to make
Jun 20 06:50:53 * postgres[14825]: [ID 748848 local2.debug] [32-1] DEBUG:
proc_exit(-1): 0 callbacks to make

apsalar=# select version();

--------------------------------------------------------------------------------
PostgreSQL 9.2.4 on x86_64-pc-solaris2.11, compiled by gcc (GCC) 4.7.2,
64-bit
(1 row)

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Hiroshi Saito 2013-06-21 14:25:05 Re: Re: [BUGS] Sorry to bother you. Please tell me exactly how the compiler was built ODBC
Previous Message Magnus Hagander 2013-06-21 08:27:56 Re: BUG #8241: submisson