Re: PG94RC1- plv8 functions - problem with input parameter length

From: Andres Freund <andres(at)2ndquadrant(dot)com>
To: Misa Simic <misa(dot)simic(at)gmail(dot)com>
Cc: Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com>, pgsql <pgsql-general(at)postgresql(dot)org>
Subject: Re: PG94RC1- plv8 functions - problem with input parameter length
Date: 2014-12-01 18:02:47
Message-ID: 20141201180247.GA2456@alap3.anarazel.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On 2014-12-01 16:20:54 +0100, Misa Simic wrote:
> We have just found that it creates problems on machines with ubuntu 14.10
> (pg94rc1) - we have tried to install 14.10 in different environments
> (cloud, xen, virtual box) - and everywhere problems happens...

I suggest running postgres under valgrind - it tends to be very useful
to analyze problems like this. To do so run valgrind like
valgrind --suppress
valgrind \
--suppressions=/path/to/source/postgresql/src/tools/valgrind.supp \
--trace-children=yes --track-origins=yes --read-var-info=yes \
/path/to/postgres/install/bin/postgres -D ...

You should compile postgres with --enable-cassert to debug.

> Other wierd thing problem hapens just if input parametar length is 200-255.
> 256 work fine.

That sounds a bit like it might be toast related. Maybe plv8's parameter
handling isn't entirely correct?

Greetings,

Andres Freund

--
Andres Freund http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Training & Services

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Andres Freund 2014-12-01 18:08:09 Re: recovering from "too many failures" wal error
Previous Message Andy Colson 2014-12-01 17:26:11 Re: Partitioning of a dependent table not based on date