Re: DBD::Pg returns "DBD::Pg::st execute failed: connection not open" - Mailing list pgsql-interfaces

From Greg Sabino Mullane
Subject Re: DBD::Pg returns "DBD::Pg::st execute failed: connection not open"
Date
Msg-id a4d3aa3cfbf777c12dac75e180c5c13e@biglumber.com
Whole thread Raw
In response to DBD::Pg returns "DBD::Pg::st execute failed: connection not open"  ("Thomas Adam" <thomas.adam22@gmail.com>)
Responses Re: DBD::Pg returns "DBD::Pg::st execute failed: connection not open"  ("Thomas Adam" <thomas.adam22@gmail.com>)
List pgsql-interfaces
-----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-----




pgsql-interfaces by date:

Previous
From: "Thomas Adam"
Date:
Subject: DBD::Pg returns "DBD::Pg::st execute failed: connection not open"
Next
From: "Thomas Adam"
Date:
Subject: Re: DBD::Pg returns "DBD::Pg::st execute failed: connection not open"