We found it!

The database host was over the firewall which had the port for postgres opened, but the persistent connections were killed by the firewall due to timeouts.

:D

Daniel Rubio wrote:
Hi all

One of our clients (sometimes I think that all freak clients come to our ISP) is using persistent connections via PHP (pg_pconnect) to our 7.3.2 postgres database.

Randomly their scripts fails, and doing a Reload on navigator their work fine again.

I've put debug4 on logs and I've seen this:

2003-11-28 13:28:13 DEBUG: ProcessQuery
2003-11-28 13:28:13 DEBUG: ProcessUtility
2003-11-28 13:28:13 DEBUG: CommitTransactionCommand
2003-11-28 13:28:14 LOG: pq_recvbuf: unexpected EOF on client connection
2003-11-28 13:28:14 DEBUG: proc_exit(0)
2003-11-28 13:28:14 DEBUG: shmem_exit(0)
2003-11-28 13:28:14 DEBUG: exit(0)
2003-11-28 13:28:14 DEBUG: reaping dead processes
2003-11-28 13:28:14 DEBUG: child process (pid 10541) exited with exit code 0
2003-11-28 13:28:14 DEBUG: StartTransactionCommand
2003-11-28 13:28:14 DEBUG: ProcessQuery


It says that is a problem on the client side, but i can't find nothing that helps me.

The web server is a Netscape Enterprise 3.6, and PHP version is 4.3.2.

Someone has been the same problem or knows what is happening?

Thanks in advance.


--
********************************************************
Daniel Rubio Rodr�guez
OASI (Organisme Aut�nom Per la Societat de la Informaci�)
c/ Assalt, 12
43003 - Tarragona
Tef.: 977.244.007 - Fax: 977.224.517
e-mail: [EMAIL PROTECTED]
********************************************************


---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ?

http://www.postgresql.org/docs/faqs/FAQ.html

Reply via email to