Re: Randomly error using php persistent connections

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
********************************************************