BUG #8245: Urgent:Query on slave failing with invalid memory alloc request size 18446744073709537559 - Mailing list pgsql-bugs

From kapplegate@apsalar.com
Subject BUG #8245: Urgent:Query on slave failing with invalid memory alloc request size 18446744073709537559
Date
Msg-id E1Uq1xU-0003lP-Qe@wrigleys.postgresql.org
Whole thread Raw
Responses Re: BUG #8245: Urgent:Query on slave failing with invalid memory alloc request size 18446744073709537559
Re: BUG #8245: Urgent:Query on slave failing with invalid memory alloc request size 18446744073709537559
List pgsql-bugs
The following bug has been logged on the website:

Bug reference:      8245
Logged by:          Kim Applegate
Email address:      kapplegate@apsalar.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)

pgsql-bugs by date:

Previous
From: Борис Ромашов
Date:
Subject: Re: BUG #8242: No way to debug "subquery must return only one column" error
Next
From: "Stephen Brearley"
Date:
Subject: Postgres 9.2.4 for Windows (Vista) Dell Vostro 400, re-installation failure