Re: BUG #5531: REGEXP_ REPLACE causes connection drop

Sure.

Here is the copy from postgresql log from June 23:

ErrorContext: 8192 total in 1 blocks; 8176 free (0 chunks); 16 used
ERROR: out of memory
DETAIL: Failed on request of size 251049.
CONTEXT: PL/pgSQL function "composite_statements_as_set" line 36 at assignment
SQL function "composite_statements_wrapper" statement 1
SQL function "dml_statements" statement 1
LOG: unexpected EOF on client connection

The 8.1.18 is used in our product and it is embedded in the production environment of our client. We are planning to upgrade to more recent release, but currently it is not possible.

Please let me know if you need any more help.

> From: bruce(at)momjian(dot)us
> Subject: Re: [BUGS] BUG #5531: REGEXP_ REPLACE causes connection drop
> To: ola_sergatchov(at)hotmail(dot)com
> Date: Wed, 30 Jun 2010 11:46:53 -0400
> CC: pgsql-bugs(at)postgresql(dot)org
>
> Ola Sergatchov wrote:
> >
> > The following bug has been logged online:
> >
> > Bug reference: 5531
> > Logged by: Ola Sergatchov
> > Email address: ola_sergatchov(at)hotmail(dot)com
> > PostgreSQL version: 8.1.18
> > Operating system: RedHat Linux 4.1.2-46
> > Description: REGEXP_ REPLACE causes connection drop
> > Details:
> >
> > Passing large string to REGEXP_REPLACE function causes the DB connection to
> > drop. We executed this function with very large strings (20,000 - 250,000
> > characters) both from RedHat and PgAdmin and in both cases the function
> > fails to return and eventually the connection drops. From looking in the
> > documentation, there is no reference to the maximum size of the string that
> > his function can process.
>
> Can you show us any relevant entries in the server logs? FYI, 8.1.18 is
> both old for minor and major release.
>
> --
> Bruce Momjian <bruce(at)momjian(dot)us> http://momjian.us
> EnterpriseDB http://enterprisedb.com
>
> + None of us is going to be here forever. +

_________________________________________________________________
Hotmail: Powerful Free email with security by Microsoft.
https://signup.live.com/signup.aspx?id=60969