[JBoss Messaging] - Exception: Did not load correct number of messages
by yuvalry
Hi,
We are having the exact same problem as described in
http://www.jboss.com/index.html?module=bb&op=viewtopic&p=4060737#4060737
But we are using Oracle 10g DB.
We decided to follow Tim Fox advice from http://jira.jboss.com/jira/browse/JBMESSAGING-908 and to add a foreign key to JBM_MSG_REF table.
We modified the oracle-persistence-service.xml file and replaces the CREATE_MESSAGE_REFERENCE with following query:
CREATE TABLE JBM_MSG_REF (MESSAGE_ID INTEGER, CHANNEL_ID INTEGER, TRANSACTION_ID INTEGER, STATE CHAR(1), ORD INTEGER, PAGE_ORD INTEGER, DELIVERY_COUNT INTEGER, SCHED_DELIVERY INTEGER, PRIMARY KEY(MESSAGE_ID, CHANNEL_ID), CONSTRAINT FK_JBM_MSG_REF_MESSAGE_ID FOREIGN KEY (MESSAGE_ID) REFERENCES JBM_MSG(MESSAGE_ID))
But when running application server we get the following exception:
2008-05-06 11:17:19,765 DEBUG [org.jboss.messaging.core.impl.JDBCSupport] Failed to execute: CREATE TABLE JBM_MSG_REF (MESSAGE_ID INTEGER, CHANNEL_ID INTEGER, TRANSACTION_ID INTEGER, STATE CHAR(1), ORD INTEGER, PAGE_ORD INTEGER, DELIVERY_COUNT INTEGER, SCHED_DELIVERY INTEGER, PRIMARY KEY(MESSAGE_ID, CHANNEL_ID), CONSTRAINT FK_JBM_MSG_REF_MESSAGE_ID FOREIGN KEY (MESSAGE_ID) REFERENCES JBM_MSG(MESSAGE_ID))
java.sql.SQLException: ORA-00942: table or view does not exist
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)
And of course the table is not created.
Our guess is that it's happening because JBM_MSG_REF table created before JBM_MSG table.
Are we right? How can we change the tables creation order?
Thanks,
Yuval
P.S
We tried to change the order of the queries in the oracle-persistence-service.xml file and it didn't work :-(
View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=4148756#4148756
Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=4148756
16 years, 4 months
[JBoss Messaging] - Re: OutOfMemoryError with JBoss Messaging
by timfox
"harish43" wrote : I
|
| 769946 .. 168189k . char[]
| 2814906 . 98961k .. java.util.HashMap$Entry
| 936726 .. 88564k .. java.util.HashMap$Entry[]
| 2008055 . 54907k .. java.lang.String
| 936446 .. 51211k .. java.util.HashMap
| 434925 .. 25114k .. java.lang.Object[]
| 634584 .. 22309k .. java.util.Hashtable$Entry
| 1788960 . 20964k .. EDU.oswego.cs.dl.util.concurrent.ConcurrentHashMap$Segment (CL #2)
| 389365 .. 18631k .. java.util.TreeMap$Entry
| 45601 ... 14903k .. byte[]
| 27873 ... 11840k .. org.jboss.remoting.transport.bisocket.BisocketServerInvoker (CL #4)
| 243018 .. 11391k .. java.util.Collections$SynchronizedMap
| 86909 ... 9109k ... java.util.Hashtable$Entry[]
| 102026 .. 7970k ... nu.xom.Element (CL #78)
| 55905 ... 7872k ... EDU.oswego.cs.dl.util.concurrent.ConcurrentHashMap$Entry[] (CL #2)
| 55905 ... 7861k ... EDU.oswego.cs.dl.util.concurrent.ConcurrentHashMap$Segment[] (CL #2)
| 306520 .. 7184k ... java.util.ArrayList
| 55751 ... 6642k ... org.jboss.remoting.loading.ClassByteClassLoader (CL #4)
| 28026 ... 5391k ... org.jboss.jms.server.endpoint.ServerSessionEndpoint (CL #4)
| 75425 ... 5376k ... org.jboss.remoting.transport.bisocket.BisocketServerInvoker$ControlMonitorTimerTask (CL #4)
| 28386 ... 4854k ... EDU.oswego.cs.dl.util.concurrent.ConcurrentReaderHashMap$Entry[] (CL #2)
| 27872 ... 4545k ... org.jboss.jms.server.endpoint.ServerConnectionEndpoint (CL #4)
| 55905 ... 4149k ... EDU.oswego.cs.dl.util.concurrent.ConcurrentHashMap (CL #2)
| 27917 ... 3953k ... org.jboss.remoting.Client (CL #4)
| 6582 .... 3684k ... int[]
| 98963 ... 3479k ... EDU.oswego.cs.dl.util.concurrent.ConcurrentReaderHashMap$Entry (CL #2)
| 86490 ... 3378k ... java.lang.ref.WeakReference
| 58692 ... 3209k ... java.util.Hashtable
| 116937 .. 3197k ... java.util.Vector
| 52948 ... 2895k ... java.util.TreeMap
| 50254 ... 2748k ... nu.xom.Attribute (CL #78)
| 27876 ... 2722k ... org.jboss.remoting.callback.ServerInvokerCallbackHandler (CL #4)
| 84194 ... 2631k ... java.lang.ref.ReferenceQueue
| 335308 .. 2619k ... java.lang.Object
| 27903 ... 2506k ... org.jboss.remoting.InvokerLocator (CL #4)
| 18018 ... 2410k ... java.lang.reflect.Method
| 28386 ... 2328k ... EDU.oswego.cs.dl.util.concurrent.ConcurrentReaderHashMap (CL #2)
| 28439 ... 2227k ... java.util.WeakHashMap$Entry[]
| 140604 .. 2196k ... java.util.HashSet
| 56231 ... 1976k ... EDU.oswego.cs.dl.util.concurrent.LinkedQueue (CL #2)
| 27876 ... 1932k ... org.jboss.remoting.transport.local.LocalClientInvoker (CL #4)
| 82629 ... 1901k ... nu.xom.Node[] (CL #78)
| 28439 ... 1777k ... java.util.WeakHashMap
| 28210 ... 1763k ... java.util.Properties
| 28498 ... 1669k ... java.util.WeakHashMap$Entry
| 28104 ... 1564k ... org.jboss.aop.ClassInstanceAdvisor (CL #109)
| 27876 ... 1524k ... org.jboss.remoting.InvocationRequest (CL #4)
| 27977 ... 1420k ... org.jboss.util.LRUCachePolicy$LRUList (CL #2)
| 86154 ... 1346k ... java.util.HashMap$EntrySet
| 56250 ... 1318k ... EDU.oswego.cs.dl.util.concurrent.LinkedNode (CL #2)
| 28104 ... 1317k ... org.jboss.aop.InstanceAdvisorDelegate (CL #109)
| 11647 ... 1296k ... org.jboss.mx.server.InvocationContext (CL #2)
| 28029 ... 1122k ... EDU.oswego.cs.dl.util.concurrent.QueuedExecutor (CL #2)
| 27875 ... 1116k ... org.jboss.remoting.transport.socket.LRUPool (CL #4)
| 55778 ... 1089k ... org.jboss.remoting.Home (CL #4)
| 27876 ... 1088k ... org.jboss.remoting.callback.DefaultCallbackErrorHandler (CL #4)
|
Putting aside the observation that what you're doing is an anti-pattern for a minute....
The objects leaked are JBoss Remoting object - can you try posting in the JBoss Remoting forum please?
View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=4148747#4148747
Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=4148747
16 years, 4 months