A database connection is in an unexpected state.

Installation Forum (Inactive)
A database connection is in an unexpected state. Romina  2016-11-08 07:13
Status: Closed
 
Hi, I'm trying to start Labkey 16.2 on tomcat 7, but I get the following error message:

"A database connection is in an unexpected state: auto-commit is false. This indicates a configuration problem with the datasource definition or the database connection pool."

I installed Labkey on Ubuntu 14.04 and the database is Postgress 9.5.5.

How could I fix this error?

Thanks,
Romina.
 
 
Jon (LabKey DevOps) responded:  2016-11-08 14:54
Hello Romina,

Can you give us the full error that is being displayed?

Also, what version of Tomcat are you specifically trying to use? Not all of them are properly supported.

Please refer to our Supported Technologies page to see what versions of software are supported with LabKey here.

https://www.labkey.org/home/Documentation/wiki-page.view?name=supported

Regards,

Jon
 
Romina responded:  2016-11-08 15:01
Hello Jon,

The version of Tomcat is 7.0.52.0.
The full error is this:

Configuration Error Detected at LabKey Server Startup

A database connection is in an unexpected state: auto-commit is false. This indicates a configuration problem with the datasource definition or the database connection pool.

This is a problem with your configuration. Please contact your local server administrator for assistance, or LabKey at support@labkey.com for operational assistance with correcting the configuration error.

org.labkey.api.util.ConfigurationException: A database connection is in an unexpected state: auto-commit is false. This indicates a configuration problem with the datasource definition or the database connection pool.
       at org.labkey.api.data.DbScope._getConnection(DbScope.java:799)
       at org.labkey.api.data.DbScope.getConnection(DbScope.java:619)
       at org.labkey.api.data.DbScope.getConnection(DbScope.java:611)
       at org.labkey.api.data.dialect.SqlDialect.getJdbcVersion(SqlDialect.java:1217)
       at org.labkey.core.dialect.PostgreSql91Dialect.initializeInClauseGenerator(PostgreSql91Dialect.java:817)
       at org.labkey.core.dialect.PostgreSql91Dialect.prepare(PostgreSql91Dialect.java:746)
       at org.labkey.core.dialect.PostgreSql92Dialect.prepare(PostgreSql92Dialect.java:28)
       at org.labkey.api.data.DbScope.addScope(DbScope.java:1084)
       at org.labkey.api.data.DbScope.initializeScopes(DbScope.java:1051)
       at org.labkey.api.module.ModuleLoader.initializeDataSources(ModuleLoader.java:917)
       at org.labkey.api.module.ModuleLoader.doInit(ModuleLoader.java:330)
       at org.labkey.api.module.ModuleLoader.init(ModuleLoader.java:240)
       at org.apache.catalina.core.ApplicationFilterConfig.initFilter(ApplicationFilterConfig.java:279)
       at org.apache.catalina.core.ApplicationFilterConfig.getFilter(ApplicationFilterConfig.java:260)
       at org.apache.catalina.core.ApplicationFilterConfig.<init>(ApplicationFilterConfig.java:105)
       at org.apache.catalina.core.StandardContext.filterStart(StandardContext.java:4846)
       at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5522)
       at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:150)
       at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:901)
       at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:877)
       at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:632)
       at org.apache.catalina.startup.HostConfig.deployDescriptor(HostConfig.java:670)
       at org.apache.catalina.startup.HostConfig$DeployDescriptor.run(HostConfig.java:1839)
       at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511)
       at java.util.concurrent.FutureTask.run(FutureTask.java:266)
       at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
       at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
       at java.lang.Thread.run(Thread.java:745)

Regards,
Romina.
 
Jon (LabKey DevOps) responded:  2016-11-08 22:17
Thanks Romina,

Just curious, is your version of Tomcat directly downloaded from Apache's website or did you use a package manager to get it? Sometimes connections get weird when you use a package manager version.

Also, is there any chance you can use a more recent version of Tomcat as well? We support 7.0.72 and 8.0.38.

Regards,

Jon