Received: from maia.hub.org (maia-3.hub.org [200.46.204.243]) by mail.postgresql.org (Postfix) with ESMTP id 6C0FF133655C for ; Tue, 8 Feb 2011 19:58:53 -0400 (AST) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.243]) (amavisd-maia, port 10024) with ESMTP id 12175-06 for ; Tue, 8 Feb 2011 23:58:45 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from sss.pgh.pa.us (sss.pgh.pa.us [66.207.139.130]) by mail.postgresql.org (Postfix) with ESMTP id 1418D133616B for ; Tue, 8 Feb 2011 19:58:44 -0400 (AST) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.14.2/8.14.2) with ESMTP id p18NwivD015447; Tue, 8 Feb 2011 18:58:44 -0500 (EST) To: Sam Stearns cc: pgsql-performance@postgresql.org Subject: Re: Query Core Dumping In-reply-to: References: Comments: In-reply-to Sam Stearns message dated "Wed, 09 Feb 2011 10:20:15 +1030" Date: Tue, 08 Feb 2011 18:58:44 -0500 Message-ID: <15446.1297209524@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-1.91 tagged_above=-10 required=5 tests=BAYES_00=-1.9, T_RP_MATCHES_RCVD=-0.01 X-Spam-Level: X-Archive-Number: 201102/323 X-Sequence-Number: 42461 Sam Stearns 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