You are currently reviewing an older revision of this page.

DRAFT KB-XXXX Jboss/Tomcat fails to start with "Too many connections" error in the application server log

Symptoms

Application server fails to start with the following error observed in the application server log:

ERROR [org.jboss.jca.core.tx.jbossts.XAResourceRecoveryImpl] (Periodic Recovery) IJ000906: Error during crash recovery: jdbc/AppianPrimaryDS (Could not create connection): javax.resource.ResourceException: Could not create connection
	at org.jboss.jca.adapters.jdbc.xa.XAManagedConnectionFactory.getXAManagedConnection(XAManagedConnectionFactory.java:522)
...
Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException: Data source rejected establishment of connection, message from server: "Too many connections"

Cause

The application server will throw this error when attempting to connect to the database server, and all available connections are in use by other clients. More information regarding this database error can be found in the MySQL documentation.

Action

  1. Restart the database. This will reset the connections and allow Appian to connect to the database.
  2. If this is a recurring issue, the database team may want to set the max_connections variable to a larger value. Please refer to the respective database documentation on how to perform this.

Affected Versions

This article applies to all versions of Appian.

Last Reviewed: April 2019