[jboss-jira] [JBoss JIRA] Created: (JBAS-3643) null message blob is created in the jms_messages table which leads to PersistenceManager fail to restore queue during restart

[Edward Lu (JIRA)]

null message blob is created in the jms_messages table which leads to PersistenceManager fail to restore queue during restart
-----------------------------------------------------------------------------------------------------------------------------

                 Key: JBAS-3643
                 URL: http://jira.jboss.com/jira/browse/JBAS-3643
             Project: JBoss Application Server
          Issue Type: Bug
      Security Level: Public (Everyone can see)
          Components: JMS service
    Affects Versions: JBossAS-4.0.4.GA
         Environment: Windows XP, Oracle 9.2.0.5
            Reporter: Edward Lu
         Assigned To: Adrian Brock
            Priority: Critical


A null blob is inserted into the jms_message table as a result of sending message (greater than 4k messages) to jms queue.  The Oracle jdbc persistence manager is deployed in our environment as JMS queue persistence mechanism.  As a result, when JBoss is restarted, the persistence manager could not restore queue since there is null blob in the jms_messages table (please see the following stack traces and sqlplus output):

I did a quick search and found that JBAS-2503 indicates the Oracle 4k limit problem should be resolved with JBossAS-4.0.4 GA.   But I did run into the above problem with JBossAS-4.0.4 GA version.

Your help is highly appreciated.

****************************************************************************************
SQL> select count(*) from jms_messages where messageblob is null;

  COUNT(*)
----------
         3

*******************************************************************************************
2006-09-11 15:56:43,447 WARN  [ServiceController]  - Problem starting service jboss.mq.destination:name=edAuditQueue,service=Queue^M
org.jboss.mq.SpyJMSException: Unexpected error in recovery; - nested throwable:
(java.lang.NullPointerException)^M
        at org.jboss.mq.SpyJMSException.getAsJMSException(SpyJMSException.java:78)^M
        at org.jboss.mq.SpyJMSException.rethrowAsJMSException(SpyJMSException.java:63)^M
        at org.jboss.mq.pm.jdbc2.PersistenceManager.restoreQueue(PersistenceManager.java:525)^M
        at org.jboss.mq.server.JMSQueue.<init>(JMSQueue.java:65)^M
        at org.jboss.mq.server.jmx.Queue.startService(Queue.java:78)^M

......
......

Caused by: java.lang.NullPointerException^M
        at java.io.ObjectInputStream$PeekInputStream.read(ObjectInputStream.java:2150)^M
        at java.io.ObjectInputStream$PeekInputStream.readFully(ObjectInputStream.java:2163)^M
        at java.io.ObjectInputStream$BlockDataInputStream.readShort(ObjectInputStream.java:2631)^M
        at java.io.ObjectInputStream.readStreamHeader(ObjectInputStream.java:734)^M
        at java.io.ObjectInputStream.<init>(ObjectInputStream.java:253)^M
        at org.jboss.mq.pm.jdbc2.PersistenceManager.extractMessage(PersistenceManager.java:665)^M
        at org.jboss.mq.pm.jdbc2.PersistenceManager.internalRestoreQueue(PersistenceManager.java:556)^M
        at org.jboss.mq.pm.jdbc2.PersistenceManager.restoreQueue(PersistenceManager.java:514)^M

*******************************************************************************************************************



-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: http://jira.jboss.com/jira/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira