1

HAProxy, client timeouts when connecting from JDBC pool

view story
linux-howto

http://serverfault.com – I have a webapp (Tomcat/Hibernate/DBCP 1.4) that runs queries against MySQL, and this works fine for a certain load, say 50 queries a second. When I route the same moderate load through HAProxy (still just using a single database), I get a failure, maybe one for every 500 queries. My app reports: Caused by: com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failure The last packet successfully received from the server was 196,898 milliseconds ago. The last packet sent successfully to the server was 0 milliseconds ago. at sun.reflect.GeneratedConstructorAccessor21 (HowTos)

u85500's picture
Submitted by u85500 on 10/17/2012

Stories similar to HAProxy, client timeouts when connecting from JDBC pool

We are seeing "The last packet sent successfully to the server was 0 milliseconds ago. The driver has not received any packets from the server" exception from all of our java applications at a time. And this is happening after every 3 or 4 days. We tried pinging the host where mysql runs, some times it works some times it wont.

I have a problem with the application I'm developing. I am trying to connect to a database in Mysql that is in local in a WIFI network with my application on android. I use for this, a direct method, with mysql-connector-java 5.1.23. The application works fine on my nexus one (Android 2.3).

We are seeing "The last packet sent successfully to the server was 0 milliseconds ago. The driver has not received any packets from the server" exception from all of our java applications at a time. And this is happening after every 3 or 4 days. We tried pinging the host where mysql runs, some times it works some times it wont.

MySQL JDBC Driver missing 3 years 24 weeks ago

Hi,

I am trying access a mysql database using jdbc. I have tried several applications, but all of them fail with the message

com.mysql.jdbc.Driver not found

I have installed the mysql-connector-java rpm. Just doesnt seem to work still.

Is there another rpm I need to load?

When I migrated my web application from Tomcat7 to Tomcat6 I'm getting this exception:

java.lang.ClassCastException: org.apache.tomcat.jdbc.pool.DataSource cannot be cast to javax.sql.ConnectionPoolDataSource

When I try to run my webapp (in Tomcat6) that use tomcat jdbc pool that seamlessly work with Tomcat7

I have included these jars already in tomcat 6 lib folder:

tomcat-jdbc.jar tomcat-jul

I got a dedicated VPS and installed mysql on it(I am new at this).

Now from my web server(on a different server), when I make queries it takes 10x longer than it used to take to make the queries when the database server was on the same server.

I have a MySQL server on my Scientific Linux 6.2 system. Right now I know how to create a new database, and set up users.

I need to setup LibreOffice Base to connect to the MySQL server, via either ODBC or JDBC (ideally over SSL).

How do I do this? Do I need to install anything on the server to allow this to happen?

I am using MAMP Pro 2.0.5 (latest) and copied the my-medium.cnf file and placed it into /mamp/conf/ and renamed it to my.cnf under the [mysqld] i placed

log = /Volumes/www/public/logs/mysql-queries.log

to get the log going ( i want to log all queries)

but nothing happends. I resarted mamp and when i run queries nothing gets logged. what am i doing wrong?

Recently my Debian Linux server has been experiencing slow web server response times.