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: drubio@oasi.org
********************************************************