2 Replies Latest reply on Dec 2, 2004 4:43 AM by orkus9 orkus9

    Fatal Hypersonic startup problem

    ron.ohara Newbie

      This is really wierd ... the log shows some bad SQL generated for a jms entry ... one that has been working fine for months.

      It repeatably happens at startup and then of course the whole thing is broken.


      Even more strange is that a clone of the setup on (and I do mean clone - using rsync --delete etc) on an identical machine (hardware and software) next to it (different IP address of course) ... starts up just fine.

      Does anyone have any idea where I should look for the offending code that invents the SQL string?


      2004-10-01 08:21:08,830 ERROR [org.jboss.jdbc.HypersonicDatabase] Starting failed jboss:service=Hypersonic,database=localDB
      java.sql.SQLException: Unexpected end of command: Unexpected end of command in statement [INSERT INTO JMS_MESSAGES VALUES(6184,'QUEUE.com.jr.logengine.queue',NULL,'A','aced00057372001b6f72672e6a626f73732e6d712e537079546578744d657373616765034578686880ab810c0000787200176f72672e6a626f73732e6d712e5370794d657373616765067bd98e2509da340c000078707a0000027c020016636f6d2e6a722e6c6f67656e67696e652e71756575650000000200000000000000000000000407001649443a362d3130393634313737313430333633303935000000ff47969f740109ffffffff000900000107000449443a36000000020005636c617373070022636f6d2e6a722e6c6f67656e67696e652e6a6178622e4c6f67456e74727954797065000863617465676f727907000b4d41494e54454e414e4345080000000101d13c3f786d6c2076657273696f6e3d22312e302220656e636f64696e673d225554462d3822207374616e64616c6f6e653d22796573223f3e0a3c6c6f672d656e747269657320636f6d706f6e656e743d22756e6b6e6f776e206a722]
      at org.hsqldb.Trace.getError(Unknown Source)
      at org.hsqldb.Log.runScript(Unknown Source)
      at org.hsqldb.Log.open(Unknown Source)
      at org.hsqldb.Database$Logger.openLog(Unknown Source)
      at org.hsqldb.Database.open(Unknown Source)
      at org.hsqldb.Database.(Unknown Source)
      at org.hsqldb.jdbcConnection.openStandalone(Unknown Source)
      at org.hsqldb.jdbcConnection.(Unknown Source)
      at org.hsqldb.jdbcDriver.connect(Unknown Source)
      at java.sql.DriverManager.getConnection(DriverManager.java:512)
      at java.sql.DriverManager.getConnection(DriverManager.java:171)
      at org.jboss.jdbc.HypersonicDatabase.getConnection(HypersonicDatabase.java:812)
      at org.jboss.jdbc.HypersonicDatabase.startStandaloneDatabase(HypersonicDatabase.java:623)
      at org.jboss.jdbc.HypersonicDatabase.startService(HypersonicDatabase.java:593)
      at org.jboss.system.ServiceMBeanSupport.jbossInternalStart(ServiceMBeanSupport.java:271)
      at org.jboss.system.ServiceMBeanSupport.jbossInternalLifecycle(ServiceMBeanSupport.java:221)
      at sun.reflect.GeneratedMethodAccessor10.invoke(Unknown Source)

      .... and more

        • 1. Re: Fatal Hypersonic startup problem
          jayraldyn Newbie

          Hi, Ron.

          I suppose you ran out of space in the filesystem, causing a corruption in Hypersonic files. Try copying file default.script in:

          server/default/data/hypersonic

          from the machine that works to the one that doesn't, and restart JBoss.

          Regards.

          • 2. Re: Fatal Hypersonic startup problem
            orkus9 orkus9 Newbie

            i think, there were something wrong datas in the local db.

            i made this, to solve the problem:

            (my server is "playground" ... your could be "default" or sth. else)

            i opened this folder:
            C:\jboss-4.0.0\server\playground\data\hypersonic
            or e.g.
            C:\jboss-4.0.0\server\default\data\hypersonic

            i deleted all files in there.
            "localDB.properties", "localDB.lck", "localDB.data", "localDB.log"

            then start jboss again and the error is gone ^^
            ps: the saved datas will be deleted!!