Problems with DB connection

Hi all,

I’m having issues with my DB connection and Ignition. I have 2 DB connections db_energia and db_energia_hist. Recently, the DB connection with db_energia started to have connecton problems.

Here is part of the log console message

INFO | jvm 4 | 2020/05/19 10:09:28 | ERROR [db_energia ] [10:09:27,782]: Database connection FAULTED.
INFO | jvm 4 | 2020/05/19 10:09:28 | org.apache.commons.dbcp.SQLNestedException: Cannot get a connection, pool error Timeout waiting for idle object
INFO | jvm 4 | 2020/05/19 10:09:28 | at org.apache.commons.dbcp.PoolingDataSource.getConnection(PoolingDataSource.java:104)
INFO | jvm 4 | 2020/05/19 10:09:28 | at org.apache.commons.dbcp.BasicDataSource.getConnection(BasicDataSource.java:880)
INFO | jvm 4 | 2020/05/19 10:09:28 | at com.inductiveautomation.ignition.gateway.datasource.DatasourceImpl.getConnectionInternal(DatasourceImpl.java:199)
INFO | jvm 4 | 2020/05/19 10:09:28 | at com.inductiveautomation.ignition.gateway.datasource.DatasourceManagerImpl.getConnectionImpl(DatasourceManagerImpl.java:131)
INFO | jvm 4 | 2020/05/19 10:09:28 | at com.inductiveautomation.ignition.gateway.datasource.DatasourceImpl.getConnection(DatasourceImpl.java:194)
INFO | jvm 4 | 2020/05/19 10:09:28 | at com.inductiveautomation.ignition.gateway.datasource.DatasourceManagerImpl.getConnection(DatasourceManagerImpl.java:116)
INFO | jvm 4 | 2020/05/19 10:09:28 | at com.inductiveautomation.ignition.gateway.script.GatewayDBUtilities.getConnection(GatewayDBUtilities.java:66)
INFO | jvm 4 | 2020/05/19 10:09:28 | at com.inductiveautomation.ignition.gateway.servlets.gateway.functions.AbstractDBAction.invoke(AbstractDBAction.java:60)
INFO | jvm 4 | 2020/05/19 10:09:28 | at com.inductiveautomation.ignition.gateway.servlets.Gateway.doPost(Gateway.java:345)
INFO | jvm 4 | 2020/05/19 10:09:28 | at javax.servlet.http.HttpServlet.service(HttpServlet.java:707)
INFO | jvm 4 | 2020/05/19 10:09:28 | at javax.servlet.http.HttpServlet.service(HttpServlet.java:790)
INFO | jvm 4 | 2020/05/19 10:09:28 | at com.inductiveautomation.ignition.gateway.bootstrap.MapServlet.service(MapServlet.java:85)
INFO | jvm 4 | 2020/05/19 10:09:28 | at org.eclipse.jetty.servlet.ServletHolder.handle(ServletHolder.java:837)
INFO | jvm 4 | 2020/05/19 10:09:28 | at org.eclipse.jetty.servlet.ServletHandler.doHandle(ServletHandler.java:583)
INFO | jvm 4 | 2020/05/19 10:09:28 | at org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:143)
INFO | jvm 4 | 2020/05/19 10:09:28 | at org.eclipse.jetty.security.SecurityHandler.handle(SecurityHandler.java:548)
INFO | jvm 4 | 2020/05/19 10:09:28 | at org.eclipse.jetty.server.session.SessionHandler.doHandle(SessionHandler.java:226)
INFO | jvm 4 | 2020/05/19 10:09:28 | at org.eclipse.jetty.server.handler.ContextHandler.doHandle(ContextHandler.java:1160)
INFO | jvm 4 | 2020/05/19 10:09:28 | at org.eclipse.jetty.servlet.ServletHandler.doScope(ServletHandler.java:511)
INFO | jvm 4 | 2020/05/19 10:09:28 | at org.eclipse.jetty.server.session.SessionHandler.doScope(SessionHandler.java:185)
INFO | jvm 4 | 2020/05/19 10:09:28 | at org.eclipse.jetty.server.handler.ContextHandler.doScope(ContextHandler.java:1092)
INFO | jvm 4 | 2020/05/19 10:09:28 | at org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:141)
INFO | jvm 4 | 2020/05/19 10:09:28 | at org.eclipse.jetty.server.handler.HandlerList.handle(HandlerList.java:52)
INFO | jvm 4 | 2020/05/19 10:09:28 | at org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:134)
INFO | jvm 4 | 2020/05/19 10:09:28 | at org.eclipse.jetty.server.Server.handle(Server.java:518)
INFO | jvm 4 | 2020/05/19 10:09:28 | at org.eclipse.jetty.server.HttpChannel.handle(HttpChannel.java:308)
INFO | jvm 4 | 2020/05/19 10:09:28 | at org.eclipse.jetty.server.HttpConnection.onFillable(HttpConnection.java:244)
INFO | jvm 4 | 2020/05/19 10:09:28 | at org.eclipse.jetty.io.AbstractConnection$ReadCallback.succeeded(AbstractConnection.java:273)
INFO | jvm 4 | 2020/05/19 10:09:28 | at org.eclipse.jetty.io.FillInterest.fillable(FillInterest.java:95)
INFO | jvm 4 | 2020/05/19 10:09:28 | at org.eclipse.jetty.io.SelectChannelEndPoint$2.run(SelectChannelEndPoint.java:93)
INFO | jvm 4 | 2020/05/19 10:09:28 | at org.eclipse.jetty.util.thread.strategy.ExecuteProduceConsume.produceAndRun(ExecuteProduceConsume.java:246)
INFO | jvm 4 | 2020/05/19 10:09:28 | at org.eclipse.jetty.util.thread.strategy.ExecuteProduceConsume.run(ExecuteProduceConsume.java:156)
INFO | jvm 4 | 2020/05/19 10:09:28 | at org.eclipse.jetty.util.thread.QueuedThreadPool.runJob(QueuedThreadPool.java:654)
INFO | jvm 4 | 2020/05/19 10:09:28 | at org.eclipse.jetty.util.thread.QueuedThreadPool$3.run(QueuedThreadPool.java:572)
INFO | jvm 4 | 2020/05/19 10:09:28 | at java.lang.Thread.run(Unknown Source)
INFO | jvm 4 | 2020/05/19 10:09:28 | Caused by: java.util.NoSuchElementException: Timeout waiting for idle object
INFO | jvm 4 | 2020/05/19 10:09:28 | at org.apache.commons.pool.impl.GenericObjectPool.borrowObject(GenericObjectPool.java:958)
INFO | jvm 4 | 2020/05/19 10:09:28 | at org.apache.commons.dbcp.PoolingDataSource.getConnection(PoolingDataSource.java:96)
INFO | jvm 4 | 2020/05/19 10:09:28 | … 34 more

The thing is that db_energia_hist is working just fine and both connections are pointing to the same DB. Does anyone had a similar problem? Before this problem my connection between Ignition and MySQL5.6 was just fine.

Thanks

What is the max number of connections? What is your innodb buffer pool size?

the innodb_buffer_pool_size is 846200832