Skip site navigation (1) Skip section navigation (2)

Re: DBD::Pg returns "DBD::Pg::st execute failed: connection not open"

From: "Greg Sabino Mullane" <greg(at)turnstep(dot)com>
To: pgsql-interfaces(at)postgresql(dot)org
Subject: Re: DBD::Pg returns "DBD::Pg::st execute failed: connection not open"
Date: 2008-02-05 05:25:58
Message-ID: a4d3aa3cfbf777c12dac75e180c5c13e@biglumber.com (view raw or flat)
Thread:
Lists: 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(at)turnstep(dot)com
PGP Key: 0x14964AC8 200802050023
http://biglumber.com/x/web?pk=2529DF6AB8F79407E94445B4BC9B906714964AC8

-----BEGIN PGP SIGNATURE-----

iD8DBQFHp/NJvJuQZxSWSsgRAxDmAKDSrHAK/FFwxnd6eXQPBHQ4p+sEmwCgovOP
SOiERoAlhKoaKBrXO7ZMY8s=
=E9YC
-----END PGP SIGNATURE-----



In response to

Responses

pgsql-interfaces by date

Next:From: Thomas AdamDate: 2008-02-05 20:20:26
Subject: Re: DBD::Pg returns "DBD::Pg::st execute failed: connection not open"
Previous:From: Thomas AdamDate: 2008-01-30 15:56:48
Subject: DBD::Pg returns "DBD::Pg::st execute failed: connection not open"

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group