AAI Stops updating events, logs show - ERROR [JDBCExceptionReporter] I/O Error: Read timed out

Products

• Automation Analytics & Intelligence

Issue/Introduction

 

WARN [JDBCExceptionReporter] SQL Error: 0, SQLState: 08S01

 

ERROR [JDBCExceptionReporter] I/O Error: Read timed out

 

WARN [GenericSessionImpl] error in rollback: : org.hibernate.TransactionException: JDBC rollback failed
    at org.hibernate.transaction.JDBCTransaction.rollback(JDBCTransaction.java:204)
    at com.termalabs.common.connection.hibernate.GenericSessionImpl.rollback(GenericSessionImpl.java:267)
    at com.termalabs.common.connection.hibernate.GenericSessionImpl.close(GenericSessionImpl.java:294)
    at com.termalabs.server.cache.jobstream.JobStreamRunUpdaterImpl.close(JobStreamRunUpdaterImpl.java:505)
    at com.termalabs.server.app.jobstream.run.PredecessorRunsPredictedJobStreamRunBuilder.associateNewRuns(PredecessorRunsPredictedJobStreamRunBuilder.java:381)
    at com.termalabs.server.system.RunCycle.buildPredictedJobStreamRuns(RunCycle.java:718)
    at com.termalabs.server.system.RunCycle.compute(RunCycle.java:514)
    at com.termalabs.server.system.CommonJammerSequence.runCycle(CommonJammerSequence.java:225)
    at com.termalabs.server.system.CommonJammerSequence.runJammerSequence(CommonJammerSequence.java:158)
    at com.termalabs.server.system.JammerSequence.run(JammerSequence.java:136)
    at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511)
    at java.util.concurrent.FutureTask.run(FutureTask.java:266)
    at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
    at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
    at java.lang.Thread.run(Thread.java:750)
Caused by: java.sql.SQLException: I/O Error: Read timed out

Environment

Release : 6.4.3

Resolution

The errors above indicate an issue connecting to a SQL Server database.

 

This is due to either a network or server side issue on the AAI database server.

 

Please check with your DBA and verify database connectivity and responsiveness.