Expand my Community achievements bar.

Dive into Adobe Summit 2024! Explore curated list of AEM sessions & labs, register, connect with experts, ask questions, engage, and share insights. Don't miss the excitement.

Scheduler Jobs didnot resume after a DataBase connection reset

Avatar

Former Community Member

Hi,

Due to the connection issues, the Internal Database IDP_DS connection failed.

The scheduler didnot resume processing jobs after the connection has been restored.

I have experienced the following lines in the log:

[org.jboss.resource.connectionmanager.JBossManagedConnectionPool] (Thread-30) Throwable while attempting to get a new connection: null

org.jboss.resource.JBossResourceException: Could not create connection; - nested throwable: (java.sql.SQLRecoverableException: Io exception: Connection reset

ERROR [org.quartz.core.JobRunShell] (SimpleThreadPoolWorker-1) Job QUARTZ_JOBGROUP_IDP.DIRSYNC_FINISHER_JOB threw an unhandled Exception:

[org.jboss.resource.connectionmanager.JBossManagedConnectionPool] (QuartzScheduler_IDPSchedulerService-20_MisfireHandler) Throwable while attempting to get a new connection: null

org.jboss.resource.JBossResourceException: Could not create connection; - nested throwable: (java.sql.SQLRecoverableException: Io exception: Connection reset)

Please suggest me why the scheduler jobs didnot resume...

Thanks in advance.

1 Reply

Avatar

Employee Advisor

It seems that the connection pool (datasource) is not available/created after failure. If that is the case, the scheduler won't be able to fetch the jobs stored inside the database. Restart the Jboss once.

Thanks,

Wasil