EJB Timer not working after DB restart

Posted on

Hi,

Setup:
Jboss version used : EAP 7.2
DB : PG12
Issue desc :
Made Application up ,
Timer got created in table JBOSS_EJB_TIMER
Made DB down for 10 mins
Made DB up.
Timer not initiated again.

In Domain.xml
            <timer-service thread-pool-name="default" default-data-store="clustered-store">
                    <data-stores>
                        <database-data-store name="clustered-store" datasource-jndi-name="java:/AASDS_TS" partition="timer" refresh-interval="1200000" allow-execution="true"/>
                    </data-stores>
                </timer-service> 

<xa-datasource jndi-name="java:/AASDS" pool-name="AASDS" statistics-enabled="true">
                        <xa-datasource-property name="ServerName">
                            localhost
                        </xa-datasource-property>
                        <xa-datasource-property name="PortNumber">
                            5433
                        </xa-datasource-property>
                        <xa-datasource-property name="DatabaseName">
                            aams
                        </xa-datasource-property>
                        <xa-datasource-property name="reWriteBatchedInserts">
                            true
                        </xa-datasource-property>
                        <xa-datasource-class>org.postgresql.xa.PGXADataSource</xa-datasource-class>
                        <driver>postgresql</driver>
                        <transaction-isolation>TRANSACTION_READ_COMMITTED</transaction-isolation>
                        <security>
                            <user-name>mms</user-name>
                            <password>mms</password>
                        </security>
                        <validation>
                            <valid-connection-checker class-name="org.jboss.jca.adapters.jdbc.extensions.postgres.PostgreSQLValidConnectionChecker"/>
                            <check-valid-connection-sql>select 1</check-valid-connection-sql>
                            <background-validation>true</background-validation>
                            <exception-sorter class-name="org.jboss.jca.adapters.jdbc.extensions.postgres.PostgreSQLExceptionSorter"/>
                        </validation>
                    </xa-datasource>