While registering adapter agent with tea server, it fails with error: "java.net.SocketException: Software caused connection abort: socket write error"
Article ID: KB0078307
Updated On:
| Products | Versions |
|---|---|
| TIBCO ActiveMatrix Adapter Framework | All supported versions |
Description
When tried to register the adapter agent with tea server, it throws below error:
=====
pool-1-thread-1] WARN c.t.a.m.p.r.AdapterRDBMSDataManager -
SQLState : 08S01
ErrorCode: 0
Message: The last packet successfully received from the server was 169,960,854 milliseconds ago. The last packet sent successfully to the server was 169,960,885 milliseconds ago. is longer than the server configured value of 'wait_timeout'. You should consider either expiring and/or testing connection validity before use in your application, increasing the server configured values for client timeouts, or using the Connector/J connection property 'autoReconnect=true' to avoid this problem.
Cause : java.net.SocketException: Software caused connection abort: socket write error
[HttpClient-295] WARN o.eclipse.jetty.client.HttpExchange - EXPIRED ContentExchangeWrapper@5f34c738=PUT//host:8777/teaa/task#WAITING(59990ms)->EXPIRED(0ms)sent=59990ms
[pool-1-thread-1] ERROR com.tibco.tea.agent - Auto registration failed with timeout error: STATUS_EXPIRED.
=====
Cause:
This error caused due to the MySQL database server has terminated the connection with the adapter agent when configured in DBEMS mode. In most cases, this can be caused either by the timeout issue (e.g. the response takes too much time).
Environment
Resolution
OR
Update the JDBC url present in adapteragent.ini file with "autoReconnect=true" jdbc property
e.g
admin.technology.dbems.db.connectionURL=jdbc:mysql://<host>:<port>/adapteragentdb?useSSL=false&autoReconnect=true
When autoReconnect=true is set then database driver will try to re-establish the connection with the database.
Issue/Introduction
Feedback
