Oracle Communications Interactive Session Recorder (ISR) : Error in Java.sql.SQLException: Could Not Retrieve Transation Read-only Status Server (Doc ID 2731468.1)

Last updated on OCTOBER 11, 2023

Applies to:

Symptoms

Archiver process crashes and Observing the below error in the Archiver and message logs

Nov 16 11:49:13 FRPARCHEISRRSS server: java.sql.SQLException: Could not retrieve transation read-only status server
Nov 16 11:49:13 FRPARCHEISRRSS server: at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1070)
Nov 16 11:49:13 FRPARCHEISRRSS server: at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:973)
Nov 16 11:49:13 FRPARCHEISRRSS server: at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:959)
Nov 16 11:49:13 FRPARCHEISRRSS server: at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:904)
Nov 16 11:49:13 FRPARCHEISRRSS server: at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:935)
Nov 16 11:49:13 FRPARCHEISRRSS server: at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:925)
Nov 16 11:49:13 FRPARCHEISRRSS server: at com.mysql.jdbc.ConnectionImpl.isReadOnly(ConnectionImpl.java:3956)
Nov 16 11:49:13 FRPARCHEISRRSS server: at com.mysql.jdbc.ConnectionImpl.isReadOnly(ConnectionImpl.java:3927)
Nov 16 11:49:13 FRPARCHEISRRSS server: at net.newfoundcommon.Database.Execute(Unknown Source)
Nov 16 11:49:13 FRPARCHEISRRSS server: at net.newfoundcommon.Database.OpenResultSet(Unknown Source)
Nov 16 11:49:13 FRPARCHEISRRSS server: at net.newfoundcomm.archival.base.ArchiverConfig.setFinalDestinationDetails(Unknown Source)
Nov 16 11:49:13 FRPARCHEISRRSS server: at net.newfoundcomm.archival.base.ArchiverConfig.fillArchiveConfDetails(Unknown Source)
Nov 16 11:49:13 FRPARCHEISRRSS server: at net.newfoundcomm.archival.base.ArchiverConfig.<init>(Unknown Source)
Nov 16 11:49:13 FRPARCHEISRRSS server: at net.newfoundcomm.archival.base.ConfigObject.loadArchivalConfig(Unknown Source)
Nov 16 11:49:13 FRPARCHEISRRSS server: at net.newfoundcomm.archivalService.ArchivalEngine.reloadConfAndCheckThreadsStatu s(Unknown Source)
Nov 16 11:49:13 FRPARCHEISRRSS server: at net.newfoundcomm.archivalService.ArchivalEngine.processArchiveItems(Unknown Source)
Nov 16 11:49:13 FRPARCHEISRRSS server: at net.newfoundcomm.archivalService.ArchivalEngine.run(Unknown Source)
Nov 16 11:49:13 FRPARCHEISRRSS server: Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException: No
operations allowed after connection closed.
Nov 16 11:49:13 FRPARCHEISRRSS server: at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
Nov 16 11:49:13 FRPARCHEISRRSS server: at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)
Nov 16 11:49:13 FRPARCHEISRRSS server: at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructo
rAccessorImpl.java:45)
Nov 16 11:49:13 FRPARCHEISRRSS server: at java.lang.reflect.Constructor.newInstance(Constructor.java:423)
Nov 16 11:49:13 FRPARCHEISRRSS server: at com.mysql.jdbc.Util.handleNewInstance(Util.java:395)
Nov 16 11:49:13 FRPARCHEISRRSS server: at com.mysql.jdbc.Util.getInstance(Util.java:370)
Nov 16 11:49:13 FRPARCHEISRRSS server: at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:999)
Nov 16 11:49:13 FRPARCHEISRRSS server: at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:973)
Nov 16 11:49:13 FRPARCHEISRRSS server: at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:959)
Nov 16 11:49:13 FRPARCHEISRRSS server: at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:904)
Nov 16 11:49:13 FRPARCHEISRRSS server: at com.mysql.jdbc.ConnectionImpl.throwConnectionClosedException(ConnectionImpl.ja
va:1304)
Nov 16 11:49:13 FRPARCHEISRRSS server: at com.mysql.jdbc.ConnectionImpl.checkClosed(ConnectionImpl.java:1296)
Nov 16 11:49:13 FRPARCHEISRRSS server: at com.mysql.jdbc.ConnectionImpl.versionMeetsMinimum(ConnectionImpl.java:5835)
Nov 16 11:49:13 FRPARCHEISRRSS server: at com.mysql.jdbc.ConnectionImpl.isCursorFetchEnabled(ConnectionImpl.java:3884)
Nov 16 11:49:13 FRPARCHEISRRSS server: at com.mysql.jdbc.StatementImpl.useServerFetch(StatementImpl.java:2928)
Nov 16 11:49:13 FRPARCHEISRRSS server: at com.mysql.jdbc.StatementImpl.executeQuery(StatementImpl.java:1562)
Nov 16 11:49:13 FRPARCHEISRRSS server: at com.mysql.jdbc.ConnectionImpl.isReadOnly(ConnectionImpl.java:3950)
Nov 16 11:49:13 FRPARCHEISRRSS server: ... 10 more
Nov 16 11:49:13 FRPARCHEISRRSS server: Exception in thread "Thread-10034" java.lang.NullPointerException
Nov 16 11:49:13 FRPARCHEISRRSS server: at net.newfoundcomm.archival.base.ArchiverConfig.setFinalDestinationDetails(Unkno
wn Source)
Nov 16 11:49:13 FRPARCHEISRRSS server: at net.newfoundcomm.archival.base.ArchiverConfig.fillArchiveConfDetails(Unknown
Source)
Nov 16 11:49:13 FRPARCHEISRRSS server: at net.newfoundcomm.archival.base.ArchiverConfig.<init>(Unknown Source)
Nov 16 11:49:13 FRPARCHEISRRSS server: at net.newfoundcomm.archival.base.ConfigObject.loadArchivalConfig(Unknown
Source)
Nov 16 11:49:13 FRPARCHEISRRSS server: at net.newfoundcomm.archivalService.ArchivalEngine.reloadConfAndCheckThreadsStatu
s(Unknown Source)
Nov 16 11:49:13 FRPARCHEISRRSS server: at net.newfoundcomm.archivalService.ArchivalEngine.processArchiveItems(Unknown
Source)
Nov 16 11:49:13 FRPARCHEISRRSS server: at net.newfoundcomm.archivalService.ArchivalEngine.run(Unknown Source)

Changes

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.