activemq-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From eklas <klas.eriks...@netgiro.com>
Subject Re: mysql message size
Date Wed, 30 Aug 2006 07:07:17 GMT

This seems to happen:

Caused by: java.io.IOException: Data truncation: Data too long for column
'MSG' at row 1
 at
org.apache.activemq.util.IOExceptionSupport.create(IOExceptionSupport.java:42)
 at
org.apache.activemq.store.jdbc.TransactionContext.close(TransactionContext.java:125)
 at
org.apache.activemq.store.jdbc.JDBCMessageStore.addMessage(JDBCMessageStore.java:74)
 at
org.apache.activemq.store.memory.MemoryTransactionStore.addMessage(MemoryTransactionStore.java:223)
 at
org.apache.activemq.store.memory.MemoryTransactionStore$1.addMessage(MemoryTransactionStore.java:116)
 at org.apache.activemq.broker.region.Queue.send(Queue.java:253)
 at
org.apache.activemq.broker.region.AbstractRegion.send(AbstractRegion.java:225)
 at
org.apache.activemq.broker.region.RegionBroker.send(RegionBroker.java:342)
 at
org.apache.activemq.broker.TransactionBroker.send(TransactionBroker.java:192)
 at org.apache.activemq.broker.BrokerFilter.send(BrokerFilter.java:113)
 at
org.apache.activemq.broker.CompositeDestinationBroker.send(CompositeDestinationBroker.java:97)
 at
org.apache.activemq.broker.MutableBrokerFilter.send(MutableBrokerFilter.java:126)
 at
org.apache.activemq.broker.AbstractConnection.processMessage(AbstractConnection.java:351)
 at
org.apache.activemq.command.ActiveMQMessage.visit(ActiveMQMessage.java:590)
 at
org.apache.activemq.broker.AbstractConnection.service(AbstractConnection.java:201)
 at
org.apache.activemq.broker.TransportConnection$1.onCommand(TransportConnection.java:62)
 at
org.apache.activemq.transport.ResponseCorrelator.onCommand(ResponseCorrelator.java:97)
 at
org.apache.activemq.transport.TransportFilter.onCommand(TransportFilter.java:63)
 at
org.apache.activemq.transport.WireFormatNegotiator.onCommand(WireFormatNegotiator.java:114)
 at
org.apache.activemq.transport.InactivityMonitor.onCommand(InactivityMonitor.java:122)
 at
org.apache.activemq.transport.TransportSupport.doConsume(TransportSupport.java:87)
 at
org.apache.activemq.transport.tcp.TcpTransport.run(TcpTransport.java:143)
 at java.lang.Thread.run(Thread.java:595)
Caused by: java.lang.Throwable: java.sql.BatchUpdateException: Data
truncation: Data too long for column 'MSG' at row 1
 at
com.mysql.jdbc.ServerPreparedStatement.executeBatch(ServerPreparedStatement.java:648)
 at
org.apache.commons.dbcp.DelegatingStatement.executeBatch(DelegatingStatement.java:205)
 at
org.apache.commons.dbcp.DelegatingStatement.executeBatch(DelegatingStatement.java:205)
 at
org.apache.activemq.store.jdbc.TransactionContext.executeBatch(TransactionContext.java:92)
 at
org.apache.activemq.store.jdbc.TransactionContext.executeBatch(TransactionContext.java:71)
 at
org.apache.activemq.store.jdbc.TransactionContext.close(TransactionContext.java:107)


Jonathan Duty-2 wrote:
> 
> I notice that the mysql persistence uses the datatype "blob''.  What  
> happens if a message is larger than 2^16 ?
> 

-- 
View this message in context: http://www.nabble.com/mysql-message-size-tf693529.html#a6053536
Sent from the ActiveMQ - User forum at Nabble.com.


Mime
View raw message