The Vertica Forum recently got a makeover! Let us know what you think by filling out this short, anonymous survey.

unixODBC + PHP = Unexpected EOF on client connection

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

Comments

  • "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? 
  • 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

Leave a Comment

BoldItalicStrikethroughOrdered listUnordered list
Emoji
Image
Align leftAlign centerAlign rightToggle HTML viewToggle full pageToggle lights
Drop image/file

Can't find what you're looking for? Search the Vertica Documentation, Knowledge Base, or Blog for more information.