000014528 - Eserver or Aserver will not reconnect to the SQL DB after a DB restart

Document created by RSA Customer Support Employee on Jun 16, 2016Last modified by RSA Customer Support Employee on Apr 21, 2017
Version 2Show Document
  • View in full screen mode

Article Content

Article Number000014528
Applies ToRSA Access Manager 6
SQL datastore
Issueeserver or aserver will not reconnect to the SQL DB after a DB restart
An exception similar to the following is appearing in the eserver/aserver debug log:
 sirrus.da.exception.DataStoreException: SQLException : Code:08006;TextAn I/O error occured while sending to the backend. 
CauseWhen restarting the SQL DB used by AxM as its datastore, it has been noticed that the eserver and aserver processes are unable to reconnect to the DB. A restart of these processes is needed to resume normal operation.

An exception similar to the following would appear in the server's debug logs.

20:44:55:960 [*] [APIClientProxy-0] - Thread requesting stream.
sirrus.da.exception.DataStoreException: SQLException : Code:08006;TextAn I/O error occured while sending to the backend
        at
sirrus.da.sql.util.SQLEntityHelper.getUsers(SQLEntityHelper.java:669)
        at
sirrus.da.sql.util.SQLConnectionImpl.searchUsers(SQLConnectionImpl.java:702)

ResolutionPlease take note of the error code returned by the JDBC driver (in the example above: 08006) that is appearing in your debug logs and add it to the paramet in sql.conf, as follows:

cleartrust.data.sql.server.postgresql.databasefatalcodes  :08006

Then restart your AxM server for the change to take effect.

Failed DB connection will then be removed from the DB connection pool as the error code above is encountered. It might take a few SQL queries for all failed DB connections to be flushed from the connection pool.
Legacy Article IDa45225

Attachments

    Outcomes