Received: from localhost (unknown [200.46.204.184]) by postgresql.org (Postfix) with ESMTP id C33B52E330E for ; Tue, 5 Feb 2008 01:26:02 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.184]) (amavisd-maia, port 10024) with ESMTP id 93772-10 for ; Tue, 5 Feb 2008 01:25:49 -0400 (AST) Received: from tinlc.com (unknown [72.18.206.65]) by postgresql.org (Postfix) with ESMTP id 672B42E330A for ; Tue, 5 Feb 2008 01:25:59 -0400 (AST) Received: from biglumber.com ([72.18.206.64] helo=localhost) by tinlc.com with smtp (Exim 4.60) (envelope-from ) id 1JMGJi-0000L0-7v; Tue, 05 Feb 2008 00:25:58 -0500 From: "Greg Sabino Mullane" To: pgsql-interfaces@postgresql.org Subject: Re: DBD::Pg returns "DBD::Pg::st execute failed: connection not open" X-PGP-Key: 2529 DF6A B8F7 9407 E944 45B4 BC9B 9067 1496 4AC8 X-Request-PGP: http://www.biglumber.com/x/web?pk=2529DF6AB8F79407E94445B4BC9B906714964AC8 In-Reply-To: <18071eea0801300756m7d1d2273n16ffb2323f2998a3@mail.gmail.com> Date: Tue, 5 Feb 2008 05:25:58 -0000 X-Mailer: JoyMail 2.01 Message-ID: X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200802/1 X-Sequence-Number: 6699 -----BEGIN PGP SIGNED MESSAGE----- Hash: RIPEMD160 > I'm using Perl 5.8.8 with DBD-Pg-1.49. I have a perl script which ... > I had previously set DBI->trace(4) and found out that my script was > able to connect just fine to the database, and perform SELECT queries, > but as soon as it came to running an INSERT query, the script > segfaults [1]. Most likely a DBD::Pg bug. Some ideas: 1) Try out the new version of DBD::Pg and see if it helps. If so, it's most likely an already-fixed bug. http://search.cpan.org/dist/DBD-Pg/ - the 2.0.0_x one 2) Try setting trace to 10 and see if you can figure out the last thing it did before dying. 3) Use gdb to see what it's dying on. Run "gdb perl core" after it coredumps and do a "backtrace". - -- Greg Sabino Mullane greg@turnstep.com PGP Key: 0x14964AC8 200802050023 http://biglumber.com/x/web?pk=2529DF6AB8F79407E94445B4BC9B906714964AC8 -----BEGIN PGP SIGNATURE----- iD8DBQFHp/NJvJuQZxSWSsgRAxDmAKDSrHAK/FFwxnd6eXQPBHQ4p+sEmwCgovOP SOiERoAlhKoaKBrXO7ZMY8s= =E9YC -----END PGP SIGNATURE-----