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

Details

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

    Description

      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.

      Attachments

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

        Issue Links

          is incorporated by

          Task - Represents a small unit of work that is not end-user facing. EJBTHREE-1697 Move the current ejb3 timer service to a separate optional component

          • Critical - To be worked on immediately following BLOCKER issues.
          • Resolved
          is related to

          Bug - A problem that impairs or prevents the functions of the product. JBAS-6305 Error installing KeyGeneratorFactory with some databases

          • Major - To be worked after higher priority work items are addressed. When the severity is high and the effort to change it is low to moderate, this term is chosen. Issues in this category likely have an existing workaround but implementation or execution may be non-trivial.
          • Closed

          Task - Represents a small unit of work that is not end-user facing. JBAS-6417 Move ejb3-timer-service.xml to docs/examples/ejb3

          • Major - To be worked after higher priority work items are addressed. When the severity is high and the effort to change it is low to moderate, this term is chosen. Issues in this category likely have an existing workaround but implementation or execution may be non-trivial.
          • Closed
          relates to

          Feature Request - Feature requests from customers and/or users EJBTHREE-619 Build EJB Timer Service on top of Quartz

          • Major - To be worked after higher priority work items are addressed. When the severity is high and the effort to change it is low to moderate, this term is chosen. Issues in this category likely have an existing workaround but implementation or execution may be non-trivial.
          • Closed

          Activity

            People

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

              Dates

                Created:
                Updated:
                Resolved: