Mailing-List: contact users-help@activemq.apache.org; run by ezmlm
Precedence: bulk
Reply-To: users@activemq.apache.org
Received-SPF: pass (athena.apache.org: domain of lists@nabble.com designates
 216.139.236.158 as permitted sender)
Message-ID: <15418680.post@talk.nabble.com>
Date: Mon, 11 Feb 2008 11:20:26 -0800 (PST)
From: activemqnewbie <acquaj29@yahoo.co.in>
To: users@activemq.apache.org
Subject: Re: SQL Exception: The resulting value is outside the range for the
 data type INTEGER
In-Reply-To: <adf34c300705230853r7da1cdbdic984398043ae99ee@mail.gmail.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
References: <adf34c300705230853r7da1cdbdic984398043ae99ee@mail.gmail.com>


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.