Fatal Hypersonic startup problem

[ron.ohara]

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

[jayraldyn]

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.

[orkus9]

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!!