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)
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 |