Loading...

Type: Bug
Resolution: Done
Priority: Blocker
Fix Version/s: 26.1.2.Final
Affects Version/s: 26.1.0.Final
Component/s: EJB
Labels:
- evalfor26.1

Steps to Reproduce:
Hide

1. configure standalone.xml:

<timer-service thread-pool-name="default" default-data-store="clustered-store"> <data-stores> <database-data-store name="clustered-store" datasource-jndi-name="java:/DataSource" partition="timer"/> </data-stores> </timer-service>

2. add DB table for clustered EJB Timer:

CREATE TABLE "JBOSS_EJB_TIMER" ( "ID" VARCHAR2(255) PRIMARY KEY NOT NULL, "TIMED_OBJECT_ID" VARCHAR2(255) NOT NULL, "INITIAL_DATE" TIMESTAMP, "REPEAT_INTERVAL" NUMBER(20), "NEXT_DATE" TIMESTAMP, "PREVIOUS_RUN" TIMESTAMP, "PRIMARY_KEY" VARCHAR2(255), "INFO" CLOB, "TIMER_STATE" VARCHAR2(32), "SCHEDULE_EXPR_SECOND" VARCHAR2(100), "SCHEDULE_EXPR_MINUTE" VARCHAR2(100), "SCHEDULE_EXPR_HOUR" VARCHAR2(100), "SCHEDULE_EXPR_DAY_OF_WEEK" VARCHAR2(100), "SCHEDULE_EXPR_DAY_OF_MONTH" VARCHAR2(100), "SCHEDULE_EXPR_MONTH" VARCHAR2(100), "SCHEDULE_EXPR_YEAR" VARCHAR2(100), "SCHEDULE_EXPR_START_DATE" VARCHAR2(100), "SCHEDULE_EXPR_END_DATE" VARCHAR(100), "SCHEDULE_EXPR_TIMEZONE" VARCHAR2(100), "AUTO_TIMER" NUMBER(1), "TIMEOUT_METHOD_NAME" VARCHAR2(100), "TIMEOUT_METHOD_DECLARING_CLASS" VARCHAR2(255), "TIMEOUT_METHOD_DESCRIPTOR" VARCHAR2(255), "CALENDAR_TIMER" NUMBER(1), "PARTITION_NAME" VARCHAR2(100), "NODE_NAME" VARCHAR2(255) ); CREATE INDEX "JBOSS_EJB_TIMER_IDENX" ON JBOSS_EJB_TIMER (PARTITION_NAME, TIMED_OBJECT_ID); GRANT SELECT, UPDATE, INSERT, DELETE ON JBOSS_EJB_TIMER TO TWTAM_RW_ROLE;

3. Add a timer like:

@Singleton @Slf4j public class TestTimmer { @Schedule(hour = "*", minute = "*", second = "0", persistent = true) public void log() { logger.info("timer test timer test"); } }

4. and then start the application so the first entry will be added to the table.
Show
1. configure standalone.xml: <timer-service thread-pool-name= " default " default -data-store= "clustered-store" > <data-stores> <database-data-store name= "clustered-store" datasource-jndi-name= "java:/DataSource" partition= "timer" /> </data-stores> </timer-service> 2. add DB table for clustered EJB Timer: CREATE TABLE "JBOSS_EJB_TIMER" ( "ID" VARCHAR2(255) PRIMARY KEY NOT NULL, "TIMED_OBJECT_ID" VARCHAR2(255) NOT NULL, "INITIAL_DATE" TIMESTAMP, "REPEAT_INTERVAL" NUMBER(20), "NEXT_DATE" TIMESTAMP, "PREVIOUS_RUN" TIMESTAMP, "PRIMARY_KEY" VARCHAR2(255), "INFO" CLOB, "TIMER_STATE" VARCHAR2(32), "SCHEDULE_EXPR_SECOND" VARCHAR2(100), "SCHEDULE_EXPR_MINUTE" VARCHAR2(100), "SCHEDULE_EXPR_HOUR" VARCHAR2(100), "SCHEDULE_EXPR_DAY_OF_WEEK" VARCHAR2(100), "SCHEDULE_EXPR_DAY_OF_MONTH" VARCHAR2(100), "SCHEDULE_EXPR_MONTH" VARCHAR2(100), "SCHEDULE_EXPR_YEAR" VARCHAR2(100), "SCHEDULE_EXPR_START_DATE" VARCHAR2(100), "SCHEDULE_EXPR_END_DATE" VARCHAR(100), "SCHEDULE_EXPR_TIMEZONE" VARCHAR2(100), "AUTO_TIMER" NUMBER(1), "TIMEOUT_METHOD_NAME" VARCHAR2(100), "TIMEOUT_METHOD_DECLARING_CLASS" VARCHAR2(255), "TIMEOUT_METHOD_DESCRIPTOR" VARCHAR2(255), "CALENDAR_TIMER" NUMBER(1), "PARTITION_NAME" VARCHAR2(100), "NODE_NAME" VARCHAR2(255) ); CREATE INDEX "JBOSS_EJB_TIMER_IDENX" ON JBOSS_EJB_TIMER (PARTITION_NAME, TIMED_OBJECT_ID); GRANT SELECT, UPDATE, INSERT, DELETE ON JBOSS_EJB_TIMER TO TWTAM_RW_ROLE; 3. Add a timer like: @Singleton @Slf4j public class TestTimmer { @Schedule(hour = "*" , minute = "*" , second = "0" , persistent = true ) public void log() { logger.info( "timer test timer test" ); } } 4. and then start the application so the first entry will be added to the table.
Git Pull Request:
https://github.com/wildfly/wildfly/pull/15568
[QE] How to address?:
---
[QE] Why QE missed?:
---

By Wildfly 26.1 the clustered EJB timer through a DB store is not working anymore.
When adding a timer, then following error is thrown.

And the server will not start!

By the way, the SQL statement is really wrong:
SELECT :1 , :2 , :3 , :4 , 'CREATED', :5 , :6 , :7 , :8 , :9 , :10 , :11 , :12 , :13 , :14 , :15 , :16 , :17 , :18 , :19 , :20 WHERE NOT EXISTS

Stacktrace:

java.lang.RuntimeException: java.lang.RuntimeException: java.sql.SQLSyntaxErrorException: ORA-00923: FROM keyword not found where expected    at org.jboss.as.ee@26.1.0.Final//org.jboss.as.ee.component.ComponentStartService$1.run(ComponentStartService.java:57)
    at java.base/java.util.concurrent.Executors$RunnableAdapter.call(Unknown Source)
    at java.base/java.util.concurrent.FutureTask.run(Unknown Source)
    at org.jboss.threads@2.4.0.Final//org.jboss.threads.ContextClassLoaderSavingRunnable.run(ContextClassLoaderSavingRunnable.java:35)
    at org.jboss.threads@2.4.0.Final//org.jboss.threads.EnhancedQueueExecutor.safeRun(EnhancedQueueExecutor.java:1990)
    at org.jboss.threads@2.4.0.Final//org.jboss.threads.EnhancedQueueExecutor$ThreadBody.doRunTask(EnhancedQueueExecutor.java:1486)
    at org.jboss.threads@2.4.0.Final//org.jboss.threads.EnhancedQueueExecutor$ThreadBody.run(EnhancedQueueExecutor.java:1348)
    at java.base/java.lang.Thread.run(Unknown Source)
    at org.jboss.threads@2.4.0.Final//org.jboss.threads.JBossThread.run(JBossThread.java:513)
Caused by: java.lang.RuntimeException: java.lang.RuntimeException: java.sql.SQLSyntaxErrorException: ORA-00923: FROM keyword not found where expected    at org.jboss.as.ejb3@26.1.0.Final//org.jboss.as.ejb3.timerservice.TimerServiceImpl.persistTimer(TimerServiceImpl.java:654)
    at org.jboss.as.ejb3@26.1.0.Final//org.jboss.as.ejb3.timerservice.TimerServiceImpl.createCalendarTimer(TimerServiceImpl.java:531)
    at org.jboss.as.ejb3@26.1.0.Final//org.jboss.as.ejb3.timerservice.TimerServiceImpl.loadAutoTimer(TimerServiceImpl.java:380)
    at org.jboss.as.ejb3@26.1.0.Final//org.jboss.as.ejb3.timerservice.TimerServiceImpl.restoreTimers(TimerServiceImpl.java:797)
    at org.jboss.as.ejb3@26.1.0.Final//org.jboss.as.ejb3.timerservice.TimerServiceImpl.activate(TimerServiceImpl.java:206)
    at org.jboss.as.ejb3@26.1.0.Final//org.jboss.as.ejb3.component.EJBComponent.init(EJBComponent.java:605)
    at org.jboss.as.ee@26.1.0.Final//org.jboss.as.ee.component.BasicComponent.start(BasicComponent.java:229)
    at org.jboss.as.ejb3@26.1.0.Final//org.jboss.as.ejb3.component.singleton.SingletonComponent.start(SingletonComponent.java:136)
    at org.jboss.as.ee@26.1.0.Final//org.jboss.as.ee.component.ComponentStartService$1.run(ComponentStartService.java:54)
    ... 8 more
Caused by: java.lang.RuntimeException: java.sql.SQLSyntaxErrorException: ORA-00923: FROM keyword not found where expected    at org.jboss.as.ejb3@26.1.0.Final//org.jboss.as.ejb3.timerservice.persistence.database.DatabaseTimerPersistence.addAutoTimer(DatabaseTimerPersistence.java:867)
    at org.jboss.as.ejb3@26.1.0.Final//org.jboss.as.ejb3.timerservice.persistence.database.DatabaseTimerPersistence.addTimer(DatabaseTimerPersistence.java:429)
    at org.jboss.as.ejb3@26.1.0.Final//org.jboss.as.ejb3.timerservice.TimerServiceImpl.persistTimer(TimerServiceImpl.java:635)
    ... 16 more
Caused by: java.sql.SQLSyntaxErrorException: ORA-00923: FROM keyword not found where expected    at com.oracle.jdbc//oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:630)
    at com.oracle.jdbc//oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:564)
    at com.oracle.jdbc//oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:1231)
    at com.oracle.jdbc//oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:772)
    at com.oracle.jdbc//oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:299)
    at com.oracle.jdbc//oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:512)
    at com.oracle.jdbc//oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:163)
    at com.oracle.jdbc//oracle.jdbc.driver.T4CPreparedStatement.executeForRows(T4CPreparedStatement.java:1241)
    at com.oracle.jdbc//oracle.jdbc.driver.OracleStatement.executeSQLStatement(OracleStatement.java:1820)
    at com.oracle.jdbc//oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1472)
    at com.oracle.jdbc//oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3761)
    at com.oracle.jdbc//oracle.jdbc.driver.OraclePreparedStatement.executeLargeUpdate(OraclePreparedStatement.java:4062)
    at com.oracle.jdbc//oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:4037)
    at com.oracle.jdbc//oracle.jdbc.driver.OraclePreparedStatementWrapper.executeUpdate(OraclePreparedStatementWrapper.java:996)
    at org.jboss.ironjacamar.jdbcadapters@1.5.3.Final//org.jboss.jca.adapters.jdbc.CachedPreparedStatement.executeUpdate(CachedPreparedStatement.java:121)
    at org.jboss.ironjacamar.jdbcadapters@1.5.3.Final//org.jboss.jca.adapters.jdbc.WrappedPreparedStatement.executeUpdate(WrappedPreparedStatement.java:537)
    at org.jboss.as.ejb3@26.1.0.Final//org.jboss.as.ejb3.timerservice.persistence.database.DatabaseTimerPersistence.addAutoTimer(DatabaseTimerPersistence.java:858)
    ... 18 more
Caused by: Error : 923, Position : 566, Sql = INSERT INTO JBOSS_EJB_TIMER (ID, TIMED_OBJECT_ID, NEXT_DATE, INFO, TIMER_STATE, SCHEDULE_EXPR_SECOND, SCHEDULE_EXPR_MINUTE, SCHEDULE_EXPR_HOUR, SCHEDULE_EXPR_DAY_OF_WEEK, SCHEDULE_EXPR_DAY_OF_MONTH, SCHEDULE_EXPR_MONTH, SCHEDULE_EXPR_YEAR, SCHEDULE_EXPR_START_DATE, SCHEDULE_EXPR_END_DATE, SCHEDULE_EXPR_TIMEZONE, AUTO_TIMER, TIMEOUT_METHOD_DECLARING_CLASS, TIMEOUT_METHOD_NAME, TIMEOUT_METHOD_DESCRIPTOR, CALENDAR_TIMER, PARTITION_NAME) SELECT :1 , :2 , :3 , :4 , 'CREATED', :5 , :6 , :7 , :8 , :9 , :10 , :11 , :12 , :13 , :14 , :15 , :16 , :17 , :18 , :19 , :20  WHERE NOT EXISTS (SELECT 1 FROM JBOSS_EJB_TIMER WHERE TIMED_OBJECT_ID=:21  AND SCHEDULE_EXPR_SECOND=:22  AND SCHEDULE_EXPR_MINUTE=:23  AND SCHEDULE_EXPR_HOUR=:24  AND SCHEDULE_EXPR_DAY_OF_WEEK=:25  AND SCHEDULE_EXPR_DAY_OF_MONTH=:26  AND SCHEDULE_EXPR_MONTH=:27  AND SCHEDULE_EXPR_YEAR=:28  AND ((SCHEDULE_EXPR_START_DATE IS NULL AND :29  IS NULL) OR SCHEDULE_EXPR_START_DATE=:30 ) AND ((SCHEDULE_EXPR_END_DATE IS NULL AND :31  IS NULL) OR SCHEDULE_EXPR_END_DATE=:32 ) AND ((SCHEDULE_EXPR_TIMEZONE IS NULL AND :33  IS NULL) OR SCHEDULE_EXPR_TIMEZONE=:34 ) AND TIMEOUT_METHOD_DECLARING_CLASS=:35  AND TIMEOUT_METHOD_NAME=:36  AND ((TIMEOUT_METHOD_DESCRIPTOR IS NULL AND :37  IS NULL) OR TIMEOUT_METHOD_DESCRIPTOR=:38 ) AND PARTITION_NAME=:39 ), OriginalSql = INSERT INTO JBOSS_EJB_TIMER (ID, TIMED_OBJECT_ID, NEXT_DATE, INFO, TIMER_STATE, SCHEDULE_EXPR_SECOND, SCHEDULE_EXPR_MINUTE, SCHEDULE_EXPR_HOUR, SCHEDULE_EXPR_DAY_OF_WEEK, SCHEDULE_EXPR_DAY_OF_MONTH, SCHEDULE_EXPR_MONTH, SCHEDULE_EXPR_YEAR, SCHEDULE_EXPR_START_DATE, SCHEDULE_EXPR_END_DATE, SCHEDULE_EXPR_TIMEZONE, AUTO_TIMER, TIMEOUT_METHOD_DECLARING_CLASS, TIMEOUT_METHOD_NAME, TIMEOUT_METHOD_DESCRIPTOR, CALENDAR_TIMER, PARTITION_NAME) SELECT ?, ?, ?, ?, 'CREATED', ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ? WHERE NOT EXISTS (SELECT 1 FROM JBOSS_EJB_TIMER WHERE TIMED_OBJECT_ID=? AND SCHEDULE_EXPR_SECOND=? AND SCHEDULE_EXPR_MINUTE=? AND SCHEDULE_EXPR_HOUR=? AND SCHEDULE_EXPR_DAY_OF_WEEK=? AND SCHEDULE_EXPR_DAY_OF_MONTH=? AND SCHEDULE_EXPR_MONTH=? AND SCHEDULE_EXPR_YEAR=? AND ((SCHEDULE_EXPR_START_DATE IS NULL AND ? IS NULL) OR SCHEDULE_EXPR_START_DATE=?) AND ((SCHEDULE_EXPR_END_DATE IS NULL AND ? IS NULL) OR SCHEDULE_EXPR_END_DATE=?) AND ((SCHEDULE_EXPR_TIMEZONE IS NULL AND ? IS NULL) OR SCHEDULE_EXPR_TIMEZONE=?) AND TIMEOUT_METHOD_DECLARING_CLASS=? AND TIMEOUT_METHOD_NAME=? AND ((TIMEOUT_METHOD_DESCRIPTOR IS NULL AND ? IS NULL) OR TIMEOUT_METHOD_DESCRIPTOR=?) AND PARTITION_NAME=?), Error Msg = ORA-00923: FROM keyword not found where expected

Probably it is related to:
https://issues.redhat.com/browse/WFLY-16290

Details

Description

Attachments

Easy Agile Planning Poker

Activity

People

Dates