Re: DBD::Pg returns "DBD::Pg::st execute failed: connection not open"
"Greg Sabino Mullane" <[email protected]>
| Newsgroups | gmane.comp.db.postgresql.interfaces |
|---|---|
| Message-ID | <[email protected]> |
-----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 [email protected] PGP Key: 0x14964AC8 200802050023 http://biglumber.com/x/web?pk=2529DF6AB8F79407E94445B4BC9B906714964AC8 -----BEGIN PGP SIGNATURE----- iD8DBQFHp/NJvJuQZxSWSsgRAxDmAKDSrHAK/FFwxnd6eXQPBHQ4p+sEmwCgovOP SOiERoAlhKoaKBrXO7ZMY8s= =E9YC -----END PGP SIGNATURE----- ---------------------------(end of broadcast)--------------------------- TIP 5: don't forget to increase your free space map settings