[daisy] Problems starting daisy repository
Andreas Deininger
adeininger at googlemail.com
Tue Jan 30 16:44:44 CST 2007
2007/1/30, Bruno Dumon <bruno at outerthought.org>:
>From a quick look around on some other installations, I think you're not
> the only with this problem.
Good to know, so let's tackle that issue.
I deleted the two tables inside my ActiveMQ database, like proposed
from your side, and they were recreated during repository startup.
However, the message table still filled up quickly. Every time a row
was added, I got an error inside my repository log file:
(daisy.jcl.org.apache.activemq.broker.AbstractConnection.Service):
Sync error occurred: java.io.IOException: Data truncation: Data
truncated for column 'MSG' at row 1
Obviously the blob field MSG is to small to store the message data.
After changing MSG to longblob, no error messages occurred any more,
and the table size is not growing any more. For me, now everything
looks fine again.
Hope that information is helpful.
Regards
--
Andreas
Excerpt from log-file:
-----------
[INFO ] <2007-01-30 23:07:33,637>
(daisy.jcl.org.apache.xbean.spring.context.impl.XBeanXmlBeanDefinitionReader):
Loading XML bean definitions from URL
[file:/cons/daisy5/daisydata/repository/MACE/conf/activemq-conf.xml]
[INFO ] <2007-01-30 23:07:33,847>
(daisy.jcl.org.apache.xbean.spring.context.ClassPathXmlApplicationContext):
Bean factory for application context
[org.apache.xbean.spring.context.ClassPathXmlApplicationContext;hashCode=10268916]:
org.springframework.beans.factory.support.DefaultListableBeanFactory
defining beans [org.apache.activemq.xbean.XBeanBrokerService,dataSource,statements];
root of BeanFactory hierarchy
[INFO ] <2007-01-30 23:07:33,863>
(daisy.jcl.org.apache.xbean.spring.context.ClassPathXmlApplicationContext):
3 beans defined in application context
[org.apache.xbean.spring.context.ClassPathXmlApplicationContext;hashCode=10268916]
[INFO ] <2007-01-30 23:07:33,879>
(daisy.jcl.org.springframework.core.CollectionFactory): JDK 1.4+
collections available
[INFO ] <2007-01-30 23:07:33,885>
(daisy.jcl.org.springframework.core.CollectionFactory): Commons
Collections 3.x available
[INFO ] <2007-01-30 23:07:33,888>
(daisy.jcl.org.apache.xbean.spring.context.ClassPathXmlApplicationContext):
Unable to locate MessageSource with name 'messageSource': using
default [org.springframework.context.support.DelegatingMessageSource at 26e9f9]
[INFO ] <2007-01-30 23:07:33,891>
(daisy.jcl.org.apache.xbean.spring.context.ClassPathXmlApplicationContext):
Unable to locate ApplicationEventMulticaster with name
'applicationEventMulticaster': using default
[org.springframework.context.event.SimpleApplicationEventMulticaster at 1a7ddcf]
[INFO ] <2007-01-30 23:07:33,891>
(daisy.jcl.org.springframework.beans.factory.support.DefaultListableBeanFactory):
Pre-instantiating singletons in factory
[org.springframework.beans.factory.support.DefaultListableBeanFactory
defining beans [org.apache.activemq.xbean.XBeanBrokerService,dataSource,statements];
root of BeanFactory hierarchy]
[INFO ] <2007-01-30 23:07:34,193>
(daisy.jcl.org.apache.activemq.broker.BrokerService): ActiveMQ 4.0 JMS
Message Broker (DaisyJMS) is starting
[INFO ] <2007-01-30 23:07:34,193>
(daisy.jcl.org.apache.activemq.broker.BrokerService): For help or more
information please see: http://incubator.apache.org/activemq/
[INFO ] <2007-01-30 23:07:34,473>
(daisy.jcl.org.apache.activemq.store.jdbc.JDBCPersistenceAdapter):
Database driver recognized: [mysql-ab_jdbc_driver]
[INFO ] <2007-01-30 23:07:34,876>
(daisy.jcl.org.apache.activemq.transport.TransportServerThreadSupport):
Listening for connections at: tcp://port10:61626
[INFO ] <2007-01-30 23:07:34,877>
(daisy.jcl.org.apache.activemq.broker.TransportConnector): Connector
tcp://localhost:61626 Started
[INFO ] <2007-01-30 23:07:34,877>
(daisy.jcl.org.apache.activemq.transport.vm.VMTransportFactory):
binding to broker: DaisyJMS
[INFO ] <2007-01-30 23:07:34,881>
(daisy.jcl.org.apache.activemq.broker.TransportConnector): Connector
vm://DaisyJMS Started
[INFO ] <2007-01-30 23:07:34,882>
(daisy.jcl.org.apache.activemq.broker.BrokerService): ActiveMQ JMS
Message Broker (DaisyJMS, ID:port10-34334-1170194853946-1:0) started
[INFO ] <2007-01-30 23:07:35,051> (daisy.jmsclient.jmsclient): JMS
connection established.
[INFO ] <2007-01-30 23:07:35,110> (daisy.datasource.datasource):
Running on database: "MySQL" version "5.0.24-standard".
[INFO ] <2007-01-30 23:07:35,538> (daisy.repository.httpconnector):
Version Jetty/5.1.10
[INFO ] <2007-01-30 23:07:35,540> (daisy.repository.httpconnector):
Started HttpContext[/,/]
[INFO ] <2007-01-30 23:07:35,543> (daisy.repository.httpconnector):
Started SocketListener on 0.0.0.0:9263
[INFO ] <2007-01-30 23:07:35,543> (daisy.repository.httpconnector):
Started org.mortbay.http.HttpServer at 3afb99
[INFO ] <2007-01-30 23:07:35,870>
(daisy.jcl.org.apache.activemq.broker.AbstractConnection.Service):
Sync error occurred: java.io.IOException: Data truncation: Data
truncated for column 'MSG' at row 1
java.io.IOException: Data truncation: Data truncated 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$2.addMessage(MemoryTransactionStore.java:128)
at org.apache.activemq.broker.region.Topic.send(Topic.java:240)
at org.apache.activemq.broker.region.AbstractRegion.send(AbstractRegion.java:225)
at org.apache.activemq.broker.region.RegionBroker.send(RegionBroker.java:345)
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.BrokerFilter.send(BrokerFilter.java:113)
at org.apache.activemq.broker.BrokerFilter.send(BrokerFilter.java:113)
at org.apache.activemq.security.AuthorizationBroker.send(AuthorizationBroker.java:156)
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.vm.VMTransport.oneway(VMTransport.java:76)
at org.apache.activemq.transport.MutexTransport.oneway(MutexTransport.java:44)
at org.apache.activemq.transport.ResponseCorrelator.asyncRequest(ResponseCorrelator.java:68)
at org.apache.activemq.transport.ResponseCorrelator.request(ResponseCorrelator.java:73)
at org.apache.activemq.ActiveMQConnection.syncSendPacket(ActiveMQConnection.java:1131)
at org.apache.activemq.ActiveMQSession.send(ActiveMQSession.java:1555)
at org.apache.activemq.ActiveMQMessageProducer.send(ActiveMQMessageProducer.java:462)
at org.apache.activemq.ActiveMQMessageProducer.send(ActiveMQMessageProducer.java:356)
at org.outerj.daisy.jms.impl.JmsClientImpl$SenderImpl$1.run(JmsClientImpl.java:367)
at org.outerj.daisy.jms.impl.JmsClientImpl$SenderImpl.executeWhenConnectionIsUp(JmsClientImpl.java:437)
at org.outerj.daisy.jms.impl.JmsClientImpl$SenderImpl.send(JmsClientImpl.java:365)
at org.outerj.daisy.event.EventDispatcherImpl$EventDispatchThread.run(EventDispatcherImpl.java:137)
Caused by: java.sql.BatchUpdateException: Data truncation: Data
truncated for column 'MSG' at row 1
at com.mysql.jdbc.PreparedStatement.executeBatch(PreparedStatement.java:896)
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)
... 31 more
[INFO ] <2007-01-30 23:07:36,066> (daisy.repository.httpconnector):
Stopped HttpContext[/,/]
[INFO ] <2007-01-30 23:07:36,066> (daisy.repository.httpconnector):
Started HttpContext[/,/]
[INFO ] <2007-01-30 23:07:36,164> (daisy.repository.httpconnector):
Stopped HttpContext[/,/]
[INFO ] <2007-01-30 23:07:36,164> (daisy.repository.httpconnector):
Started HttpContext[/,/]
[INFO ] <2007-01-30 23:07:36,260> (daisy.repository.httpconnector):
Stopped HttpContext[/,/]
[INFO ] <2007-01-30 23:07:36,260> (daisy.repository.httpconnector):
Started HttpContext[/,/]
[INFO ] <2007-01-30 23:07:36,376> (daisy.repository.httpconnector):
Stopped HttpContext[/,/]
[INFO ] <2007-01-30 23:07:36,377> (daisy.repository.httpconnector):
Started HttpContext[/,/]
[INFO ] <2007-01-30 23:07:36,593> (daisy.repository.httpconnector):
Stopped HttpContext[/,/]
[INFO ] <2007-01-30 23:07:36,593> (daisy.repository.httpconnector):
Started HttpContext[/,/]
[INFO ] <2007-01-30 23:07:45,935>
(daisy.jcl.org.apache.activemq.broker.AbstractConnection.Service):
Sync error occurred: java.io.IOException: Data truncation: Data
truncated for column 'MSG' at row 1
java.io.IOException: Data truncation: Data truncated 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$2.addMessage(MemoryTransactionStore.java:128)
at org.apache.activemq.broker.region.Topic.send(Topic.java:240)
at org.apache.activemq.broker.region.AbstractRegion.send(AbstractRegion.java:225)
at org.apache.activemq.broker.region.RegionBroker.send(RegionBroker.java:345)
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.BrokerFilter.send(BrokerFilter.java:113)
at org.apache.activemq.broker.BrokerFilter.send(BrokerFilter.java:113)
at org.apache.activemq.security.AuthorizationBroker.send(AuthorizationBroker.java:156)
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.vm.VMTransport.oneway(VMTransport.java:76)
at org.apache.activemq.transport.MutexTransport.oneway(MutexTransport.java:44)
at org.apache.activemq.transport.ResponseCorrelator.asyncRequest(ResponseCorrelator.java:68)
at org.apache.activemq.transport.ResponseCorrelator.request(ResponseCorrelator.java:73)
at org.apache.activemq.ActiveMQConnection.syncSendPacket(ActiveMQConnection.java:1131)
at org.apache.activemq.ActiveMQSession.send(ActiveMQSession.java:1555)
at org.apache.activemq.ActiveMQMessageProducer.send(ActiveMQMessageProducer.java:462)
at org.apache.activemq.ActiveMQMessageProducer.send(ActiveMQMessageProducer.java:356)
at org.outerj.daisy.jms.impl.JmsClientImpl$SenderImpl$1.run(JmsClientImpl.java:367)
at org.outerj.daisy.jms.impl.JmsClientImpl$SenderImpl.executeWhenConnectionIsUp(JmsClientImpl.java:437)
at org.outerj.daisy.jms.impl.JmsClientImpl$SenderImpl.send(JmsClientImpl.java:365)
at org.outerj.daisy.event.EventDispatcherImpl$EventDispatchThread.run(EventDispatcherImpl.java:137)
Caused by: java.sql.BatchUpdateException: Data truncation: Data
truncated for column 'MSG' at row 1
at com.mysql.jdbc.PreparedStatement.executeBatch(PreparedStatement.java:896)
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)
... 31 more
[INFO ] <2007-01-30 23:07:55,984>
(daisy.jcl.org.apache.activemq.broker.AbstractConnection.Service):
Sync error occurred: java.io.IOException: Data truncation: Data
truncated for column 'MSG' at row 1
More information about the daisy
mailing list