You are viewing a plain text version of this content. The canonical link for it is here.
Posted to users@activemq.apache.org by Kamlesh <KS...@scrippsnetworks.com> on 2007/04/21 01:37:21 UTC

Message could not be added to long term store

Hi, All

I am getting following message in log, can sombody help why?

2007-04-20 19:02:46,064 [eckpoint worker] WARN  JournalMessageStore           
- Message could not be added to long term store: Failed to broker message:
ID:rtbn-1289-1177098726692-1:0:110:1:1 in container: java.sql.SQLException:
Data size bigger than max size for this type: 4262
java.io.IOException: Failed to broker message:
ID:snkxw-gdev-1289-1177098726692-1:0:110:1:1 in container:
java.sql.SQLException: Data size bigger than max size for this type: 4262
	at
org.apache.activemq.util.IOExceptionSupport.create(IOExceptionSupport.java:31)
	at
org.apache.activemq.store.jdbc.JDBCMessageStore.addMessage(JDBCMessageStore.java:72)
	at
org.apache.activemq.store.journal.JournalMessageStore$3.execute(JournalMessageStore.java:260)
	at
org.apache.activemq.util.TransactionTemplate.run(TransactionTemplate.java:44)
	at
org.apache.activemq.store.journal.JournalMessageStore.checkpoint(JournalMessageStore.java:247)
	at
org.apache.activemq.store.journal.JournalTopicMessageStore.checkpoint(JournalTopicMessageStore.java:162)
	at
org.apache.activemq.store.journal.JournalPersistenceAdapter$5.call(JournalPersistenceAdapter.java:373)
	at
edu.emory.mathcs.backport.java.util.concurrent.FutureTask.run(FutureTask.java:176)
	at
edu.emory.mathcs.backport.java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:650)
	at
edu.emory.mathcs.backport.java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:675)
	at java.lang.Thread.run(Thread.java:595)

Kamlesh
-- 
View this message in context: http://www.nabble.com/Message-could-not-be-added-to-long-term-store-tf3621199s2354.html#a10112063
Sent from the ActiveMQ - User mailing list archive at Nabble.com.


Re: Message could not be added to long term store

Posted by Kamlesh <KS...@scrippsnetworks.com>.
HI, All

Can anybody help? I am using Active MQ 4.1.0 with ojdbc14.jar. Here is more
detailed message:

2007-04-20 15:57:31,830 [eckpoint worker] WARN  JournalMessageStore           
- Message could not be added to long term store: Failed to broker message:
ID:snkxw-gdev-1289-1177098726692-1:0:23:1:1 in container:
java.sql.SQLException: Data size bigger than max size for this type: 4638
java.io.IOException: Failed to broker message:
ID:snkxw-gdev-1289-1177098726692-1:0:23:1:1 in container:
java.sql.SQLException: Data size bigger than max size for this type: 4638
	at
org.apache.activemq.util.IOExceptionSupport.create(IOExceptionSupport.java:31)
	at
org.apache.activemq.store.jdbc.JDBCMessageStore.addMessage(JDBCMessageStore.java:72)
	at
org.apache.activemq.store.journal.JournalMessageStore$3.execute(JournalMessageStore.java:260)
	at
org.apache.activemq.util.TransactionTemplate.run(TransactionTemplate.java:44)
	at
org.apache.activemq.store.journal.JournalMessageStore.checkpoint(JournalMessageStore.java:247)
	at
org.apache.activemq.store.journal.JournalTopicMessageStore.checkpoint(JournalTopicMessageStore.java:162)
	at
org.apache.activemq.store.journal.JournalPersistenceAdapter$5.call(JournalPersistenceAdapter.java:373)
	at
edu.emory.mathcs.backport.java.util.concurrent.FutureTask.run(FutureTask.java:176)
	at
edu.emory.mathcs.backport.java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:650)
	at
edu.emory.mathcs.backport.java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:675)
	at java.lang.Thread.run(Thread.java:595)
Caused by: java.sql.SQLException: Data size bigger than max size for this
type: 4638
	at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:134)
	at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:179)
	at oracle.jdbc.ttc7.TTCItem.setArrayData(TTCItem.java:95)
	at
oracle.jdbc.dbaccess.DBDataSetImpl.setBytesBindItem(DBDataSetImpl.java:2414)
	at
oracle.jdbc.driver.OraclePreparedStatement.setItem(OraclePreparedStatement.java:1134)
	at
oracle.jdbc.driver.OraclePreparedStatement.setBytes(OraclePreparedStatement.java:2170)
	at
org.apache.commons.dbcp.DelegatingPreparedStatement.setBytes(DelegatingPreparedStatement.java:105)
	at
org.apache.commons.dbcp.DelegatingPreparedStatement.setBytes(DelegatingPreparedStatement.java:105)
	at
org.apache.activemq.store.jdbc.adapter.DefaultJDBCAdapter.setBinaryData(DefaultJDBCAdapter.java:56)
	at
org.apache.activemq.store.jdbc.adapter.DefaultJDBCAdapter.doAddMessage(DefaultJDBCAdapter.java:175)
	at
org.apache.activemq.store.jdbc.JDBCMessageStore.addMessage(JDBCMessageStore.java:69)
	... 9 more



Kamlesh wrote:
> 
> Hi, All
> 
> I am getting following message in log, can sombody help why?
> 
> 2007-04-20 19:02:46,064 [eckpoint worker] WARN  JournalMessageStore           
> - Message could not be added to long term store: Failed to broker message:
> ID:rtbn-1289-1177098726692-1:0:110:1:1 in container:
> java.sql.SQLException: Data size bigger than max size for this type: 4262
> java.io.IOException: Failed to broker message:
> ID:snkxw-gdev-1289-1177098726692-1:0:110:1:1 in container:
> java.sql.SQLException: Data size bigger than max size for this type: 4262
> 	at
> org.apache.activemq.util.IOExceptionSupport.create(IOExceptionSupport.java:31)
> 	at
> org.apache.activemq.store.jdbc.JDBCMessageStore.addMessage(JDBCMessageStore.java:72)
> 	at
> org.apache.activemq.store.journal.JournalMessageStore$3.execute(JournalMessageStore.java:260)
> 	at
> org.apache.activemq.util.TransactionTemplate.run(TransactionTemplate.java:44)
> 	at
> org.apache.activemq.store.journal.JournalMessageStore.checkpoint(JournalMessageStore.java:247)
> 	at
> org.apache.activemq.store.journal.JournalTopicMessageStore.checkpoint(JournalTopicMessageStore.java:162)
> 	at
> org.apache.activemq.store.journal.JournalPersistenceAdapter$5.call(JournalPersistenceAdapter.java:373)
> 	at
> edu.emory.mathcs.backport.java.util.concurrent.FutureTask.run(FutureTask.java:176)
> 	at
> edu.emory.mathcs.backport.java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:650)
> 	at
> edu.emory.mathcs.backport.java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:675)
> 	at java.lang.Thread.run(Thread.java:595)
> 
> Kamlesh
> 

-- 
View this message in context: http://www.nabble.com/Message-could-not-be-added-to-long-term-store-tf3621199s2354.html#a10150312
Sent from the ActiveMQ - User mailing list archive at Nabble.com.