You are viewing a plain text version of this content. The canonical link for it is here.
Posted to users@activemq.apache.org by Stefan Arentz <st...@gmail.com> on 2007/05/23 17:53:04 UTC
SQL Exception: The resulting value is outside the range for the data type INTEGER
Has anyone seen this one before? It looks like something internal to
ActiveMQ's JDBC store. I'm using a default 4.1.1 that I unpacked and
started with bin/activemq.
I had to delete the Derby data directory to get the broker going again.
javax.jms.JMSException: java.io.IOException: Failed to broker message:
ID:dev6-58163-1179334575332-1:629188:1:1:1
in container: SQL Exception: The resulting value is outside the
range for the data type INTEGER.
at org.apache.activemq.util.JMSExceptionSupport.create(JMSExceptionSupport.java:46)
at org.apache.activemq.ActiveMQConnection.syncSendPacket(ActiveMQConnection.java:1181)
at org.apache.activemq.ActiveMQSession.syncSendPacket(ActiveMQSession.java:1663)
at org.apache.activemq.ActiveMQMessageConsumer.<init>(ActiveMQMessageConsumer.java:198)
at org.apache.activemq.ActiveMQSession.createConsumer(ActiveMQSession.java:840)
at org.springframework.jms.listener.DefaultMessageListenerContainer.createConsumer(DefaultMessageListenerContainer.java:810)
at org.springframework.jms.listener.DefaultMessageListenerContainer.createListenerConsumer(DefaultMessageListenerContainer.java:443)
at org.springframework.jms.listener.DefaultMessageListenerContainer.doReceiveAndExecute(DefaultMessageListenerContainer.java:520)
at org.springframework.jms.listener.DefaultMessageListenerContainer.receiveAndExecute(DefaultMessageListenerContainer.java:459)
at org.springframework.jms.listener.DefaultMessageListenerContainer$AsyncMessageListenerInvoker.invokeListener(DefaultMessageListenerContainer.java:889)
at org.springframework.jms.listener.DefaultMessageListenerContainer$AsyncMessageListenerInvoker.run(DefaultMessageListenerContainer.java:842)
at org.springframework.core.task.SimpleAsyncTaskExecutor$ConcurrencyThrottlingRunnable.run(SimpleAsyncTaskExecutor.java:203)
at java.lang.Thread.run(Thread.java:595)
Caused by: java.lang.RuntimeException: java.io.IOException: Failed to
broker message: ID:dev6-58163-1179334575332-1:629188:1:1:1 in
container: SQL Exception: The resulting value is outside the range for
the data type INTEGER.
at org.apache.activemq.broker.region.IndirectMessageReference.incrementReferenceCount(IndirectMessageReference.java:103)
at org.apache.activemq.filter.MessageEvaluationContext.getMessage(MessageEvaluationContext.java:55)
at org.apache.activemq.filter.MessageEvaluationContext.isDropped(MessageEvaluationContext.java:48)
at org.apache.activemq.filter.PropertyExpression.evaluate(PropertyExpression.java:152)
at org.apache.activemq.filter.ComparisonExpression$1.evaluate(ComparisonExpression.java:197)
at org.apache.activemq.filter.ComparisonExpression.matches(ComparisonExpression.java:455)
at org.apache.activemq.broker.region.AbstractSubscription.matches(AbstractSubscription.java:92)
at org.apache.activemq.broker.region.Queue.addSubscription(Queue.java:190)
at org.apache.activemq.broker.region.AbstractRegion.addConsumer(AbstractRegion.java:233)
at org.apache.activemq.broker.region.RegionBroker.addConsumer(RegionBroker.java:337)
at org.apache.activemq.broker.BrokerFilter.addConsumer(BrokerFilter.java:86)
at org.apache.activemq.advisory.AdvisoryBroker.addConsumer(AdvisoryBroker.java:78)
at org.apache.activemq.broker.BrokerFilter.addConsumer(BrokerFilter.java:86)
at org.apache.activemq.broker.MutableBrokerFilter.addConsumer(MutableBrokerFilter.java:96)
at org.apache.activemq.broker.TransportConnection.processAddConsumer(TransportConnection.java:586)
at org.apache.activemq.command.ConsumerInfo.visit(ConsumerInfo.java:313)
at org.apache.activemq.broker.TransportConnection.service(TransportConnection.java:294)
at org.apache.activemq.broker.TransportConnection$1.onCommand(TransportConnection.java:185)
at org.apache.activemq.transport.TransportFilter.onCommand(TransportFilter.java:65)
at org.apache.activemq.transport.WireFormatNegotiator.onCommand(WireFormatNegotiator.java:133)
at org.apache.activemq.transport.InactivityMonitor.onCommand(InactivityMonitor.java:122)
at org.apache.activemq.transport.TransportSupport.doConsume(TransportSupport.java:84)
at org.apache.activemq.transport.tcp.TcpTransport.run(TcpTransport.java:137)
... 1 more
Caused by: java.io.IOException: Failed to broker message:
ID:dev6-58163-1179334575332-1:629188:1:1:1 in container: SQL
Exception: The resulting value is outside the range for the data type
INTEGER.
at org.apache.activemq.util.IOExceptionSupport.create(IOExceptionSupport.java:31)
at org.apache.activemq.store.jdbc.JDBCMessageStore.getMessage(JDBCMessageStore.java:110)
at org.apache.activemq.store.journal.JournalMessageStore.getMessage(JournalMessageStore.java:329)
at org.apache.activemq.broker.region.IndirectMessageReference.incrementReferenceCount(IndirectMessageReference.java:95)
... 23 more
Caused by: java.lang.Throwable:
org.apache.derby.impl.jdbc.EmbedSQLException: The resulting value is
outside the range for the data type INTEGER.
at org.apache.derby.impl.jdbc.Util.generateCsSQLException(Unknown
Source)
at org.apache.derby.impl.jdbc.TransactionResourceImpl.wrapInSQLException(Unknown
Source)
at org.apache.derby.impl.jdbc.EmbedResultSet.noStateChangeException(Unknown
Source)
at org.apache.derby.impl.jdbc.EmbedPreparedStatement.setLong(Unknown
Source)
at org.apache.activemq.store.jdbc.adapter.DefaultJDBCAdapter.doGetMessage(DefaultJDBCAdapter.java:239)
at org.apache.activemq.store.jdbc.JDBCMessageStore.getMessage(JDBCMessageStore.java:100)
... 25 more
Re: SQL Exception: The resulting value is outside the range for the
data type INTEGER
Posted by activemqnewbie <ac...@yahoo.co.in>.
Check the last_acked_id column value in activemq_acks table.
Ack id might be too large for integer column.
I had similar issue with selector column,alterd the table (column size)
Stefan Arentz-2 wrote:
>
> Has anyone seen this one before? It looks like something internal to
> ActiveMQ's JDBC store. I'm using a default 4.1.1 that I unpacked and
> started with bin/activemq.
>
> I had to delete the Derby data directory to get the broker going again.
>
> javax.jms.JMSException: java.io.IOException: Failed to broker message:
> ID:dev6-58163-1179334575332-1:629188:1:1:1
> in container: SQL Exception: The resulting value is outside the
> range for the data type INTEGER.
> at
> org.apache.activemq.util.JMSExceptionSupport.create(JMSExceptionSupport.java:46)
> at
> org.apache.activemq.ActiveMQConnection.syncSendPacket(ActiveMQConnection.java:1181)
> at
> org.apache.activemq.ActiveMQSession.syncSendPacket(ActiveMQSession.java:1663)
> at
> org.apache.activemq.ActiveMQMessageConsumer.<init>(ActiveMQMessageConsumer.java:198)
> at
> org.apache.activemq.ActiveMQSession.createConsumer(ActiveMQSession.java:840)
> at
> org.springframework.jms.listener.DefaultMessageListenerContainer.createConsumer(DefaultMessageListenerContainer.java:810)
> at
> org.springframework.jms.listener.DefaultMessageListenerContainer.createListenerConsumer(DefaultMessageListenerContainer.java:443)
> at
> org.springframework.jms.listener.DefaultMessageListenerContainer.doReceiveAndExecute(DefaultMessageListenerContainer.java:520)
> at
> org.springframework.jms.listener.DefaultMessageListenerContainer.receiveAndExecute(DefaultMessageListenerContainer.java:459)
> at
> org.springframework.jms.listener.DefaultMessageListenerContainer$AsyncMessageListenerInvoker.invokeListener(DefaultMessageListenerContainer.java:889)
> at
> org.springframework.jms.listener.DefaultMessageListenerContainer$AsyncMessageListenerInvoker.run(DefaultMessageListenerContainer.java:842)
> at
> org.springframework.core.task.SimpleAsyncTaskExecutor$ConcurrencyThrottlingRunnable.run(SimpleAsyncTaskExecutor.java:203)
> at java.lang.Thread.run(Thread.java:595)
> Caused by: java.lang.RuntimeException: java.io.IOException: Failed to
> broker message: ID:dev6-58163-1179334575332-1:629188:1:1:1 in
> container: SQL Exception: The resulting value is outside the range for
> the data type INTEGER.
> at
> org.apache.activemq.broker.region.IndirectMessageReference.incrementReferenceCount(IndirectMessageReference.java:103)
> at
> org.apache.activemq.filter.MessageEvaluationContext.getMessage(MessageEvaluationContext.java:55)
> at
> org.apache.activemq.filter.MessageEvaluationContext.isDropped(MessageEvaluationContext.java:48)
> at
> org.apache.activemq.filter.PropertyExpression.evaluate(PropertyExpression.java:152)
> at
> org.apache.activemq.filter.ComparisonExpression$1.evaluate(ComparisonExpression.java:197)
> at
> org.apache.activemq.filter.ComparisonExpression.matches(ComparisonExpression.java:455)
> at
> org.apache.activemq.broker.region.AbstractSubscription.matches(AbstractSubscription.java:92)
> at
> org.apache.activemq.broker.region.Queue.addSubscription(Queue.java:190)
> at
> org.apache.activemq.broker.region.AbstractRegion.addConsumer(AbstractRegion.java:233)
> at
> org.apache.activemq.broker.region.RegionBroker.addConsumer(RegionBroker.java:337)
> at
> org.apache.activemq.broker.BrokerFilter.addConsumer(BrokerFilter.java:86)
> at
> org.apache.activemq.advisory.AdvisoryBroker.addConsumer(AdvisoryBroker.java:78)
> at
> org.apache.activemq.broker.BrokerFilter.addConsumer(BrokerFilter.java:86)
> at
> org.apache.activemq.broker.MutableBrokerFilter.addConsumer(MutableBrokerFilter.java:96)
> at
> org.apache.activemq.broker.TransportConnection.processAddConsumer(TransportConnection.java:586)
> at
> org.apache.activemq.command.ConsumerInfo.visit(ConsumerInfo.java:313)
> at
> org.apache.activemq.broker.TransportConnection.service(TransportConnection.java:294)
> at
> org.apache.activemq.broker.TransportConnection$1.onCommand(TransportConnection.java:185)
> at
> org.apache.activemq.transport.TransportFilter.onCommand(TransportFilter.java:65)
> at
> org.apache.activemq.transport.WireFormatNegotiator.onCommand(WireFormatNegotiator.java:133)
> at
> org.apache.activemq.transport.InactivityMonitor.onCommand(InactivityMonitor.java:122)
> at
> org.apache.activemq.transport.TransportSupport.doConsume(TransportSupport.java:84)
> at
> org.apache.activemq.transport.tcp.TcpTransport.run(TcpTransport.java:137)
> ... 1 more
> Caused by: java.io.IOException: Failed to broker message:
> ID:dev6-58163-1179334575332-1:629188:1:1:1 in container: SQL
> Exception: The resulting value is outside the range for the data type
> INTEGER.
> at
> org.apache.activemq.util.IOExceptionSupport.create(IOExceptionSupport.java:31)
> at
> org.apache.activemq.store.jdbc.JDBCMessageStore.getMessage(JDBCMessageStore.java:110)
> at
> org.apache.activemq.store.journal.JournalMessageStore.getMessage(JournalMessageStore.java:329)
> at
> org.apache.activemq.broker.region.IndirectMessageReference.incrementReferenceCount(IndirectMessageReference.java:95)
> ... 23 more
> Caused by: java.lang.Throwable:
> org.apache.derby.impl.jdbc.EmbedSQLException: The resulting value is
> outside the range for the data type INTEGER.
> at org.apache.derby.impl.jdbc.Util.generateCsSQLException(Unknown
> Source)
> at
> org.apache.derby.impl.jdbc.TransactionResourceImpl.wrapInSQLException(Unknown
> Source)
> at
> org.apache.derby.impl.jdbc.EmbedResultSet.noStateChangeException(Unknown
> Source)
> at
> org.apache.derby.impl.jdbc.EmbedPreparedStatement.setLong(Unknown
> Source)
> at
> org.apache.activemq.store.jdbc.adapter.DefaultJDBCAdapter.doGetMessage(DefaultJDBCAdapter.java:239)
> at
> org.apache.activemq.store.jdbc.JDBCMessageStore.getMessage(JDBCMessageStore.java:100)
> ... 25 more
>
>
--
View this message in context: http://www.nabble.com/SQL-Exception%3A-The-resulting-value-is-outside-the-range-for-the-data-type-INTEGER-tp10766886s2354p15418681.html
Sent from the ActiveMQ - User mailing list archive at Nabble.com.
Re: SQL Exception: The resulting value is outside the range for the
data type INTEGER
Posted by crisen <cr...@yahoo.com>.
Hello Stefan.
Did you find the reason for this error?
I have it now and cannot find anything useful about what could be the cause.
Regards,
Cristian.
--
View this message in context: http://www.nabble.com/SQL-Exception%3A-The-resulting-value-is-outside-the-range-for-the-data-type-INTEGER-tp10766886s2354p15288243.html
Sent from the ActiveMQ - User mailing list archive at Nabble.com.
Re: SQL Exception: The resulting value is outside the range for the
data type INTEGER
Posted by activemqnewbie <ac...@yahoo.co.in>.
Check the last_acked_id column value in activemq_acks table.
Ack id might be too large for integer column.
I had similar issue with selector column,alterd the table (column size)
Stefan Arentz-2 wrote:
>
> Has anyone seen this one before? It looks like something internal to
> ActiveMQ's JDBC store. I'm using a default 4.1.1 that I unpacked and
> started with bin/activemq.
>
> I had to delete the Derby data directory to get the broker going again.
>
> javax.jms.JMSException: java.io.IOException: Failed to broker message:
> ID:dev6-58163-1179334575332-1:629188:1:1:1
> in container: SQL Exception: The resulting value is outside the
> range for the data type INTEGER.
> at
> org.apache.activemq.util.JMSExceptionSupport.create(JMSExceptionSupport.java:46)
> at
> org.apache.activemq.ActiveMQConnection.syncSendPacket(ActiveMQConnection.java:1181)
> at
> org.apache.activemq.ActiveMQSession.syncSendPacket(ActiveMQSession.java:1663)
> at
> org.apache.activemq.ActiveMQMessageConsumer.<init>(ActiveMQMessageConsumer.java:198)
> at
> org.apache.activemq.ActiveMQSession.createConsumer(ActiveMQSession.java:840)
> at
> org.springframework.jms.listener.DefaultMessageListenerContainer.createConsumer(DefaultMessageListenerContainer.java:810)
> at
> org.springframework.jms.listener.DefaultMessageListenerContainer.createListenerConsumer(DefaultMessageListenerContainer.java:443)
> at
> org.springframework.jms.listener.DefaultMessageListenerContainer.doReceiveAndExecute(DefaultMessageListenerContainer.java:520)
> at
> org.springframework.jms.listener.DefaultMessageListenerContainer.receiveAndExecute(DefaultMessageListenerContainer.java:459)
> at
> org.springframework.jms.listener.DefaultMessageListenerContainer$AsyncMessageListenerInvoker.invokeListener(DefaultMessageListenerContainer.java:889)
> at
> org.springframework.jms.listener.DefaultMessageListenerContainer$AsyncMessageListenerInvoker.run(DefaultMessageListenerContainer.java:842)
> at
> org.springframework.core.task.SimpleAsyncTaskExecutor$ConcurrencyThrottlingRunnable.run(SimpleAsyncTaskExecutor.java:203)
> at java.lang.Thread.run(Thread.java:595)
> Caused by: java.lang.RuntimeException: java.io.IOException: Failed to
> broker message: ID:dev6-58163-1179334575332-1:629188:1:1:1 in
> container: SQL Exception: The resulting value is outside the range for
> the data type INTEGER.
> at
> org.apache.activemq.broker.region.IndirectMessageReference.incrementReferenceCount(IndirectMessageReference.java:103)
> at
> org.apache.activemq.filter.MessageEvaluationContext.getMessage(MessageEvaluationContext.java:55)
> at
> org.apache.activemq.filter.MessageEvaluationContext.isDropped(MessageEvaluationContext.java:48)
> at
> org.apache.activemq.filter.PropertyExpression.evaluate(PropertyExpression.java:152)
> at
> org.apache.activemq.filter.ComparisonExpression$1.evaluate(ComparisonExpression.java:197)
> at
> org.apache.activemq.filter.ComparisonExpression.matches(ComparisonExpression.java:455)
> at
> org.apache.activemq.broker.region.AbstractSubscription.matches(AbstractSubscription.java:92)
> at
> org.apache.activemq.broker.region.Queue.addSubscription(Queue.java:190)
> at
> org.apache.activemq.broker.region.AbstractRegion.addConsumer(AbstractRegion.java:233)
> at
> org.apache.activemq.broker.region.RegionBroker.addConsumer(RegionBroker.java:337)
> at
> org.apache.activemq.broker.BrokerFilter.addConsumer(BrokerFilter.java:86)
> at
> org.apache.activemq.advisory.AdvisoryBroker.addConsumer(AdvisoryBroker.java:78)
> at
> org.apache.activemq.broker.BrokerFilter.addConsumer(BrokerFilter.java:86)
> at
> org.apache.activemq.broker.MutableBrokerFilter.addConsumer(MutableBrokerFilter.java:96)
> at
> org.apache.activemq.broker.TransportConnection.processAddConsumer(TransportConnection.java:586)
> at
> org.apache.activemq.command.ConsumerInfo.visit(ConsumerInfo.java:313)
> at
> org.apache.activemq.broker.TransportConnection.service(TransportConnection.java:294)
> at
> org.apache.activemq.broker.TransportConnection$1.onCommand(TransportConnection.java:185)
> at
> org.apache.activemq.transport.TransportFilter.onCommand(TransportFilter.java:65)
> at
> org.apache.activemq.transport.WireFormatNegotiator.onCommand(WireFormatNegotiator.java:133)
> at
> org.apache.activemq.transport.InactivityMonitor.onCommand(InactivityMonitor.java:122)
> at
> org.apache.activemq.transport.TransportSupport.doConsume(TransportSupport.java:84)
> at
> org.apache.activemq.transport.tcp.TcpTransport.run(TcpTransport.java:137)
> ... 1 more
> Caused by: java.io.IOException: Failed to broker message:
> ID:dev6-58163-1179334575332-1:629188:1:1:1 in container: SQL
> Exception: The resulting value is outside the range for the data type
> INTEGER.
> at
> org.apache.activemq.util.IOExceptionSupport.create(IOExceptionSupport.java:31)
> at
> org.apache.activemq.store.jdbc.JDBCMessageStore.getMessage(JDBCMessageStore.java:110)
> at
> org.apache.activemq.store.journal.JournalMessageStore.getMessage(JournalMessageStore.java:329)
> at
> org.apache.activemq.broker.region.IndirectMessageReference.incrementReferenceCount(IndirectMessageReference.java:95)
> ... 23 more
> Caused by: java.lang.Throwable:
> org.apache.derby.impl.jdbc.EmbedSQLException: The resulting value is
> outside the range for the data type INTEGER.
> at org.apache.derby.impl.jdbc.Util.generateCsSQLException(Unknown
> Source)
> at
> org.apache.derby.impl.jdbc.TransactionResourceImpl.wrapInSQLException(Unknown
> Source)
> at
> org.apache.derby.impl.jdbc.EmbedResultSet.noStateChangeException(Unknown
> Source)
> at
> org.apache.derby.impl.jdbc.EmbedPreparedStatement.setLong(Unknown
> Source)
> at
> org.apache.activemq.store.jdbc.adapter.DefaultJDBCAdapter.doGetMessage(DefaultJDBCAdapter.java:239)
> at
> org.apache.activemq.store.jdbc.JDBCMessageStore.getMessage(JDBCMessageStore.java:100)
> ... 25 more
>
>
--
View this message in context: http://www.nabble.com/SQL-Exception%3A-The-resulting-value-is-outside-the-range-for-the-data-type-INTEGER-tp10766886s2354p15418680.html
Sent from the ActiveMQ - User mailing list archive at Nabble.com.