1 Reply Latest reply on Mar 23, 2006 5:58 PM by Jeremy Levy

    Persistence and caching using MySQL errors

    Jeremy Levy Newbie

      My development enviroment is on Windows / MySql5 / JDK5, I am setting up my prod enviroment on RHEL3 /MySql5/JDK5. I have configured (in both envorments) all of the Persistence and caching using MySQL. This works fine in my development enviroment. However on Linux everytime I restart I get the following errors unless I clean the DB first.


      20:04:50,579 WARN [ServiceController] Problem starting service jboss:service=KeyGeneratorFactory,type=HiLo
      java.sql.SQLException: Table 'HILOSEQUENCES' already exists
      ... (truncated)
      --- MBeans waiting for other MBeans ---
      ObjectName: jboss:service=KeyGeneratorFactory,type=HiLo
      State: FAILED
      Reason: java.sql.SQLException: Table 'HILOSEQUENCES' already exists
      I Depend On:
      jboss:service=TransactionManager
      jboss.jca:service=DataSourceBinding,name=DefaultDS

      ObjectName: jboss.ejb:service=EJBTimerService,persistencePolicy=database
      State: FAILED
      Reason: java.sql.SQLException: Table 'TIMERS' already exists
      I Depend On:
      jboss.jca:service=DataSourceBinding,name=DefaultDS

      --- MBEANS THAT ARE THE ROOT CAUSE OF THE PROBLEM ---
      ObjectName: jboss:service=KeyGeneratorFactory,type=HiLo
      State: FAILED
      Reason: java.sql.SQLException: Table 'HILOSEQUENCES' already exists
      I Depend On:
      jboss:service=TransactionManager
      jboss.jca:service=DataSourceBinding,name=DefaultDS

      ObjectName: jboss.ejb:service=EJBTimerService,persistencePolicy=database
      State: FAILED
      Reason: java.sql.SQLException: Table 'TIMERS' already exists
      I Depend On:
      jboss.jca:service=DataSourceBinding,name=DefaultDS

      Any suggestions?