Обсуждение: DBD::Pg::st execute failed: PQsendQuery() -- There is no connecti on to the backend

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. 

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