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