Product/components used and version/fix level:
webMethods 10.3
JDBC_10.3_Fix18
IS_10.3_Core_Fix19
Detailed explanation of the problem:
We had a DB outage for around 40 minutes. During that time IntegrationServer tried to reestablish connection. When DB came back online, Integration Servers couldn’t recover the DB connection.
We observed that we had some stuck threads and our thread pool was completely full. It wasn’t able to recover the stuck threads and we couldn’t kill those threads manually either.
We tried disabling the adapter and re-enabling it again, but disable request stuck as well. This only made it worse because we tried to restart after realizing we can’t disable the adapter, then we tried reloading the package hosting the adapter connection and the service stuck, it didn’t help, it caused packages to be stuck as well; then we suspended the triggers and restarted the IS instance. Triggers were re-enabled automatically but the Adapter stayed disabled on boot. This caused messages to be consumed but not to be updated to DB. After enabling the adapter connection is established.
Error messages / full error message screenshot / log file:
Unfortunaltely, I don’t have all of the logs. We are trying to recreate the incident on test environment, will add more info once we have more info.
at com.wm.app.b2b.server.jca.WmConnectionPool.getConnection(WmConnectionPool.java:544)
- waiting on <0x7c56f8fd> (a com.wm.app.b2b.server.jca.WmConnectionPool) owned by thread="HTTP Handler *********" Id=1812
at com.wm.app.b2b.server.jca.WmConnectionManager.allocateManagedConnection(WmConnectionManager.java:423)
at com.wm.app.b2b.server.jca.WmConnectionManager.allocateConnection(WmConnectionManager.java:355)
at com.wm.adk.cci.connection.WmConnectionFactory.getConnection(WmConnectionFactory.java:141)
at com.wm.pkg.art.ns.ConnectionResource.createConnection(ConnectionResource.java:385)
at com.wm.pkg.art.transaction.ConnectionState.getConnection(ConnectionState.java:197)```
Question related to a free trial, or to a production (customer) instance?
commercial license, production environment
Questions are,
Did anyone had similar problems in the past and identified the root cause?
What would be the next problem identification step.
Any insight would be helpful. Thanks
#Adapters-and-E-Standards#webMethods#Integration-Server-and-ESB#Adapter-JDBC