Skip site navigation (1) Skip section navigation (2)

Re: Query Core Dumping

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Sam Stearns <samtstearns(at)gmail(dot)com>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: Query Core Dumping
Date: 2011-02-08 23:58:44
Message-ID: 15446.1297209524@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-adminpgsql-performance
Sam Stearns <samtstearns(at)gmail(dot)com> writes:
> I have a SELECT query that runs no problem standalone but when running
> within a perl script it intermittently core dumps.  Random, no pattern
> to the timing of the core dumps.  The perl script processes the rows
> from the query, if the rows satisfy  a condition then the perl script
> adds the rows to another table.  When the script works it runs for
> about a minute.  If the script fails, it runs for about 5 minutes and
> core dumps.  The core dump is in the perl error handling routines.  We
> suspect the bug is related to how the perl postgres libraries interact
> with postgres.

Can you get a stack trace from one of the core dumps?

Also, exactly which perl version are you using, and with what build
options?  ("perl -V" output would be a good answer here.)

BTW, this seems pretty off-topic for pgsql-performance.

			regards, tom lane

In response to

Responses

pgsql-performance by date

Next:From: Sam StearnsDate: 2011-02-09 00:03:04
Subject: Re: [PERFORM] Query Core Dumping
Previous:From: Sam StearnsDate: 2011-02-08 23:50:15
Subject: Query Core Dumping

pgsql-admin by date

Next:From: Sam StearnsDate: 2011-02-09 00:03:04
Subject: Re: [PERFORM] Query Core Dumping
Previous:From: Sam StearnsDate: 2011-02-08 23:50:15
Subject: Query Core Dumping

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group