From: Greg Sabino Mullane <greg@turnstep.com>
To: pgsql-interfaces@postgresql.org
Subject: Re: DBD::Pg returns "DBD::Pg::st execute failed: connection not open"
Date: Tue, 5 Feb 2008 05:25:58 -0000
Message-ID: <a4d3aa3cfbf777c12dac75e180c5c13e@biglumber.com> (raw)
In-Reply-To: <18071eea0801300756m7d1d2273n16ffb2323f2998a3@mail.gmail.com>
-----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-----
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-interfaces@postgresql.org
Cc: greg@turnstep.com
Subject: Re: DBD::Pg returns "DBD::Pg::st execute failed: connection not open"
In-Reply-To: <a4d3aa3cfbf777c12dac75e180c5c13e@biglumber.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox