[Postgres-xl-general] Invalid memory alloc request size

Aaron Jackson ajackson at revionics.com
Mon Sep 22 06:49:37 PDT 2014

Yes, it appears (or at least is highly correlated) to be related to the size of the table - 60M rows  So, I dumped the table, truncated the table, added the node and then reloaded - no issues.

I'll retry it in my sandbox and try to get you a stack trace.

From: Pavan Deolasee [pavan.deolasee at gmail.com]
Sent: Monday, September 22, 2014 12:17 AM
To: Aaron Jackson
Cc: postgres-xl-general at lists.sourceforge.net
Subject: Re: [Postgres-xl-general] Invalid memory alloc request size

On Fri, Sep 19, 2014 at 10:49 AM, Aaron Jackson <ajackson at revionics.com<mailto:ajackson at revionics.com>> wrote:
I've looked at this one for a while, so I will throw it out here and continue looking to see if I can make sense of it.

I have an i2 with 32GB of memory.  Kernel parameters are set as follows:
kernel.shmall = 7864320
kernel.shmmax = 32212254720
kernel.shmmni = 4096
This machine is host to one coordinator and two datanodes (datanode1 and datanode4).  Datanode4 was recently added and I wanted to redistribute data that was currently on 1,2 and 3 onto 4.  Thus, I issued the following command.
ALTER TABLE client.foo ADD NODE (datanode4);
It processes the request, eventually failing with the following:
ERROR:  invalid memory alloc request size 1073741824

That error clearly comes from trying to palloc/repalloc memory more than 1GB. What's the size of the table that you are redistributing? While it should not cause such failures, I am not sure if this part of the code is tested well for very large tables or not.

If the error is reproducible, I would request you to attach the session to a debugger and set break point at errfinish(). If the error occurs, please get the stack trace when the function gets called.

You could run "SELECT pg_backend_pid();" to get the PID of the backend process serving the given psql session.


-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.postgres-xl.org/private.cgi/postgres-xl-general-postgres-xl.org/attachments/20140922/40cffa84/attachment.htm>

More information about the postgres-xl-general mailing list