Uploaded image for project: 'Application Server 3  4  5 and 6'
  1. Application Server 3 4 5 and 6
  2. JBAS-6304

EJB3TimerService cannot start with some databases

XMLWordPrintable

    • Icon: Bug Bug
    • Resolution: Won't Do
    • Icon: Major Major
    • None
    • JBossAS-5.0.0.GA
    • EJB
    • None

      After setting up Oracle10g as the DefaultDS using this docs: http://www.jboss.org/file-access/default/members/jbossas/freezone/docs/Installation_And_Getting_Started_Guide/5/html_single/index.html#Configuring_a_datasource_for_Oracle_DB
      and starting the AS instance with "all" config, this error occured:

      07:21:09,609 ERROR [AbstractKernelController] Error installing to Start: name=jboss.ejb:service=EJB3TimerService state=Create mode=Manual requiredState=Installed
      org.quartz.SchedulerConfigException: Failure occured during job recovery. [See nested exception: org.quartz.impl.jdbcjobstore.LockException: Failure obtaining db row lock: ORA-00942: table or view does not exist
      [See nested exception: java.sql.SQLException: ORA-00942: table or view does not exist
      ]]
      at org.quartz.impl.jdbcjobstore.JobStoreSupport.initialize(JobStoreSupport.java:493)
      at org.quartz.impl.jdbcjobstore.JobStoreCMT.initialize(JobStoreCMT.java:144)
      ...

          • CONTEXTS IN ERROR: Name -> Error

      jboss.ejb:service=EJB3TimerService -> org.quartz.SchedulerConfigException: Failure occured during job recovery. [See nested exception: org.quartz.impl.jdbcjobstore.LockException: Failure obtaining db row lock: ORA-00942: table or view does not exist
      [See nested exception: java.sql.SQLException: ORA-00942: table or view does not exist
      ]]

      It seems it fails due to trying to recover non-existing data from the database.

      Similar failure occurs with PostgreSQL and DB2 v9.

        1. oracle10g.log
          36 kB
        2. sybase15.log
          31 kB

              rhn-engineering-cdewolf Carlo de Wolf
              exd-mmalina Martin Malina
              Votes:
              1 Vote for this issue
              Watchers:
              1 Start watching this issue

                Created:
                Updated:
                Resolved: