[jboss-user] [Beginners Corner] - HSQL fail to close data file

[niefeng]

Dear all, 
 
Did anyone encounter the following error before ? 
[JMSSender.sendMessageToTopic] Error  
org.jboss.mq.SpyJMSException: Could not store message: 18837 msg=282 hard NOT_STORED PERSISTENT queue=TOPIC.fromRouter.ID:7.-2147483648 priority=4 lateClone=false hashCode=31865957; - nested throwable: (java.sql.SQLException: File input/output errorerror java.io.IOException closing file - file E:\jboss-4.0.2\server\default\data\hypersonic\localDB.data in statement [INSERT INTO JMS_MESSAGES (MESSAGEID, DESTINATION, MESSAGEBLOB, TXID, TXOP) VALUES(?,?,?,?,?)]) 
at org.jboss.mq.pm.jdbc2.PersistenceManager.saveToStorage(PersistenceManager.java:1283) 
at org.jboss.mq.server.MessageCache.saveToStorage(MessageCache.java:407) 
at org.jboss.mq.server.MessageReference.makeSoft(MessageReference.java:301) 
at org.jboss.mq.server.MessageCache.validateSoftReferenceDepth(MessageCache.java:354) 
at org.jboss.mq.server.MessageCache.addInternal(MessageCache.java:145) 
at org.jboss.mq.server.MessageCache.add(MessageCache.java:115) 
at org.jboss.mq.server.JMSTopic.addMessage(JMSTopic.java:358) 
at org.jboss.mq.server.JMSDestinationManager.addMessage(JMSDestinationManager.java:397) 
at org.jboss.mq.server.JMSDestinationManager.addMessage(JMSDestinationManager.java:373) 
at org.jboss.mq.server.JMSServerInvoker.addMessage(JMSServerInvoker.java:136) 
at org.jboss.mq.il.jvm.JVMServerIL.addMessage(JVMServerIL.java:136) 
at org.jboss.mq.Connection.sendToServer(Connection.java:965) 
at org.jboss.mq.SpySession.sendMessage(SpySession.java:975) 
at org.jboss.mq.SpyMessageProducer.send(SpyMessageProducer.java:265) 
at org.jboss.mq.SpyMessageProducer.send(SpyMessageProducer.java:199) 
at org.jboss.mq.SpyTopicPublisher.publish(SpyTopicPublisher.java:58) 
 
 
I am not sure why the hsql db can't close the localdb.data file properly. The JMS message is fairly large, it is about 1.7MB, will it be the issue? The size of the localdb.data has grown up to 210MB, however it still haven't reached the limit as specified in the hsql properties file.
 
The jboss vesion i am using now is 4.0.2.  
Hypersonic DB version 1.8.0

The properties for the HSQL are as follow

hsqldb.cache_file_scale=1
runtime.gc_interval=0
hsqldb.first_identity=0
version=1.8.0
modified=yes
hsqldb.script_format=0
sql.enforce_size=false
hsqldb.cache_size_scale=8
hsqldb.cache_scale=14
hsqldb.log_size=200
sql.enforce_strict_size=false
readonly=false
hsqldb.compatible_version=1.7.2
hsqldb.original_version=1.8.0
sql.compare_in_locale=false
hsqldb.nio_data_file=true
hsqldb.cache_version=1.7.0
hsqldb.default_table_type=memory
 
 
Any help will be greatly appreciated. 

View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=3992688#3992688

Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=3992688