unixODBC + PHP = Unexpected EOF on client connection

Wils_Gomes

Hi, I have a VirtualBox-VM running CentOS with PHP 5.3 and NGinx. I am trying a to perform a very simple connection to my vertica db. So, looking at the node01 logs I found the following error: 2013-09-04 14:17:21.192 Init Session:0x7f6e2000eb10-a000000000e884 @v_jobsdb_node0001: 00000/3316: Executing statement: 'SELECT COUNT(*) FROM users;' 2013-09-04 14:17:21.201 Init Session:0x7f6e2000eb10-a000000000e884 [Txn] Starting Commit: Txn: a000000000e884 'SELECT COUNT(*) FROM users;' 2013-09-04 14:17:21.202 Init Session:0x7f6e2000eb10 [Txn] Commit Complete: Txn: a000000000e884 at epoch 0x734 2013-09-04 14:17:21.204 Init Session:0x7f6e2000eb10 @v_jobsdb_node0001: 08006/5167: Unexpected EOF on client connection 2013-09-04 14:17:21.204 Init Session:0x7f6e2000eb10 @v_jobsdb_node0001: 00000/4719: Session avert01-1984:0xe9f5 ended; closing connection (connCnt 2) As you can see it does connect, It see the coming SQL hitting the users table, however for some haut reason it drops the connection and I get a 502 HTTP error rather then the result. Any thoughts? thank you

[Deleted User]

"Unexpected EOF on client connection " is usually associated with any neytwork/firewall timeouts. Something seems to be timing out the conenction prematurely.

If there any idle connection timeout configured at firewall/application level? 

Wils_Gomes

Hi pravesh, thank you, but the firewall is disabled. I decided to run my client in another VM and everything is fine now. thank you