Thread: DBD::Pg::st execute failed: PQsendQuery() -- There is no connecti on to the backend
DBD::Pg::st execute failed: PQsendQuery() -- There is no connecti on to the backend
From
Philip Camilleri
Date:
Dear All, We have recently switched our applications from MySQL to PgSQL. Everything worked except for one error which I cannot explain! The applications (coded in Perl and using the DBD::Pg module) run as simple processes in the background. The first few requests to the Postgres server are accepted and processed easily. However, after two or three "SELECT" statements, the system returns: DBD::Pg::st execute failed: PQsendQuery() -- There is no connection to the backend. The Postgres database is actually STILL alive and if I restart the applications manually everything works well. But I just can't understand why this error is being returned. The SQL statements seem to be OK. The username/password connection also work fine. Please help! Anyone with some clue as to what might be causing this??? We decided to switch from MySQL to Postgres because of the added functionality. But without a viable Perl-DBMS connection its useless... Thanks. Philip Philip Camilleri +356 942 1888 philip@iWORLDGroup.com EMPOWER PEOPLE - THE WORLD IN YOUR HAND iWORLD GROUP (iWG) is a global e-mobile company creating, building and growing new businesses. iWG founders are pioneers in creating multi-billion dollar mobile and Internet businesses in Europe, Asia and the US.
Re: DBD::Pg::st execute failed: PQsendQuery() -- There is no connecti on to the backend
From
"Oliver Elphick"
Date:
Philip Camilleri wrote: >DBD::Pg::st execute failed: PQsendQuery() -- There is no connection to the >backend. Something crashed the backend. Look in the log to see what happened. If there's nothing there, turn on a higher level of logging and try again. -- Oliver Elphick Oliver.Elphick@lfix.co.uk Isle of Wight http://www.lfix.co.uk/oliver PGP: 1024R/32B8FAA1: 97 EA 1D 47 72 3F 28 47 6B 7E 39 CC 56 E4 C1 47 GPG: 1024D/3E1D0C1C: CA12 09E0 E8D5 8870 5839 932A 614D 4C34 3E1D 0C1C ======================================== "Praying always with all prayer and supplication in the Spirit, and watchingthereunto with all perseverance and supplication for all saints." Ephesians 6:18