From users-return-23901-apmail-activemq-users-archive=activemq.apache.org@activemq.apache.org Thu Jun 03 01:54:18 2010 Return-Path: Delivered-To: apmail-activemq-users-archive@www.apache.org Received: (qmail 48473 invoked from network); 3 Jun 2010 01:54:18 -0000 Received: from unknown (HELO mail.apache.org) (140.211.11.3) by 140.211.11.9 with SMTP; 3 Jun 2010 01:54:18 -0000 Received: (qmail 45041 invoked by uid 500); 3 Jun 2010 01:54:18 -0000 Delivered-To: apmail-activemq-users-archive@activemq.apache.org Received: (qmail 44998 invoked by uid 500); 3 Jun 2010 01:54:18 -0000 Mailing-List: contact users-help@activemq.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: users@activemq.apache.org Delivered-To: mailing list users@activemq.apache.org Received: (qmail 44990 invoked by uid 99); 3 Jun 2010 01:54:18 -0000 Received: from athena.apache.org (HELO athena.apache.org) (140.211.11.136) by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 03 Jun 2010 01:54:18 +0000 X-ASF-Spam-Status: No, hits=2.2 required=10.0 tests=FREEMAIL_FROM,HTML_MESSAGE,RCVD_IN_DNSWL_NONE,SPF_PASS,T_TO_NO_BRKTS_FREEMAIL X-Spam-Check-By: apache.org Received-SPF: pass (athena.apache.org: domain of marciogj@gmail.com designates 209.85.212.43 as permitted sender) Received: from [209.85.212.43] (HELO mail-vw0-f43.google.com) (209.85.212.43) by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 03 Jun 2010 01:54:13 +0000 Received: by vws3 with SMTP id 3so3970402vws.2 for ; Wed, 02 Jun 2010 18:53:52 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=domainkey-signature:mime-version:received:received:in-reply-to :references:date:message-id:subject:from:to:content-type; bh=PUlDW88UEnIyna6yVnntYeZmp2tTptEAisijfxx5dKw=; b=KQ7zKtu10cWIboUXCGhrkY5Eg47vtfVShiUSdUS+jhMH/kh/bl2xCNLhcTxF/zcSar SAEy+dNaJ1/KRYSsCcPuzpNUAhPBDyon+sXLyQBZrU3/oPC7L07xhKDaQA9oimZ4Zlar no090p8TzMVDUWRg+DdwrZEqa4djThOjjcRJE= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma; h=mime-version:in-reply-to:references:date:message-id:subject:from:to :content-type; b=CvLGd8D5UAAv97bbs0O6fWpktvb0sOoyEZd4k+YLp0i4ydRLgdeE8qRg+VEe+7ZzKQ Ri3dXT8AHjUUaDupUYZ9ZXzAhV2Ej7ovDMBjYp/cPh8wQCpg7sVQxQBRrZ+hfGXOfdZu uzV/9bni9OilAnd3q+Nrpm5eYH7ctVevdqCXE= MIME-Version: 1.0 Received: by 10.224.52.233 with SMTP id j41mr4142742qag.234.1275530032116; Wed, 02 Jun 2010 18:53:52 -0700 (PDT) Received: by 10.229.189.149 with HTTP; Wed, 2 Jun 2010 18:53:52 -0700 (PDT) In-Reply-To: <28728694.post@talk.nabble.com> References: <28728694.post@talk.nabble.com> Date: Wed, 2 Jun 2010 22:53:52 -0300 Message-ID: Subject: Re: ActiveMQ stops processing messages From: =?ISO-8859-1?Q?M=E1rcio_Geovani_Jasinski?= To: users@activemq.apache.org Content-Type: multipart/alternative; boundary=00c09f93d602770a2d0488167a1a --00c09f93d602770a2d0488167a1a Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Hi, Pretty strange,,, Looks like a persistence issue... Somebody is trying to insert a string into bigint field. Do you have more details about this enviroment? Does the basic ActiveMQ samples works on this enviroment? 2010/5/31 Spooky13 > > Hi, > > my ActiveMQ 5.3.2 installation stops processing messages completely after= a > while. If I stop and restart I get the following exception and the messag= es > stored in the queue are processed again: > > 11:06:22 WARN JDBC Failure: Invalid character string format for type > BIGINT. > java.sql.SQLException: Invalid character string format for type BIGINT. > at > org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(Unknown > Source) > at org.apache.derby.impl.jdbc.Util.generateCsSQLException(Unknown > Source) > at > > org.apache.derby.impl.jdbc.TransactionResourceImpl.wrapInSQLException(Unk= nown > Source) > at > org.apache.derby.impl.jdbc.EmbedResultSet.noStateChangeException(Unknown > Source) > at > org.apache.derby.impl.jdbc.EmbedPreparedStatement.setString(Unknown > Source) > at > > org.apache.activemq.store.jdbc.adapter.DefaultJDBCAdapter.doGetMessage(De= faultJDBCAdapter.java:266) > at > > org.apache.activemq.store.jdbc.JDBCMessageStore.getMessage(JDBCMessageSto= re.java:111) > at > > org.apache.activemq.store.journal.JournalMessageStore.replayAddMessage(Jo= urnalMessageStore.java:148) > at > > org.apache.activemq.store.journal.JournalPersistenceAdapter.recover(Journ= alPersistenceAdapter.java:525) > at > > org.apache.activemq.store.journal.JournalPersistenceAdapter.start(Journal= PersistenceAdapter.java:267) > at > org.apache.activemq.broker.BrokerService.start(BrokerService.java:466) > at > > org.apache.activemq.xbean.XBeanBrokerService.afterPropertiesSet(XBeanBrok= erService.java:85) > at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) > at > > sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java= :39) > at > > sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorI= mpl.java:25) > at java.lang.reflect.Method.invoke(Method.java:585) > at > > org.springframework.beans.factory.support.AbstractAutowireCapableBeanFact= ory.invokeCustomInitMethod(AbstractAutowireCapableBeanFactory.java:1414) > at > > org.springframework.beans.factory.support.AbstractAutowireCapableBeanFact= ory.invokeInitMethods(AbstractAutowireCapableBeanFactory.java:1375) > at > > org.springframework.beans.factory.support.AbstractAutowireCapableBeanFact= ory.initializeBean(AbstractAutowireCapableBeanFactory.java:1335) > at > > org.springframework.beans.factory.support.AbstractAutowireCapableBeanFact= ory.doCreateBean(AbstractAutowireCapableBeanFactory.java:473) > at > > org.springframework.beans.factory.support.AbstractAutowireCapableBeanFact= ory$1.run(AbstractAutowireCapableBeanFactory.java:409) > at java.security.AccessController.doPrivileged(Native Method) > at > > org.springframework.beans.factory.support.AbstractAutowireCapableBeanFact= ory.createBean(AbstractAutowireCapableBeanFactory.java:380) > at > > org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject= (AbstractBeanFactory.java:264) > at > > org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.ge= tSingleton(DefaultSingletonBeanRegistry.java:222) > at > > org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(A= bstractBeanFactory.java:261) > at > > org.springframework.beans.factory.support.AbstractBeanFactory.getBean(Abs= tractBeanFactory.java:185) > at > > org.springframework.beans.factory.support.AbstractBeanFactory.getBean(Abs= tractBeanFactory.java:164) > at > > org.springframework.beans.factory.support.DefaultListableBeanFactory.preI= nstantiateSingletons(DefaultListableBeanFactory.java:429) > at > > org.springframework.context.support.AbstractApplicationContext.finishBean= FactoryInitialization(AbstractApplicationContext.java:728) > at > > org.springframework.context.support.AbstractApplicationContext.refresh(Ab= stractApplicationContext.java:380) > at > > org.apache.xbean.spring.context.ResourceXmlApplicationContext.(Reso= urceXmlApplicationContext.java:64) > at > > org.apache.xbean.spring.context.ResourceXmlApplicationContext.(Reso= urceXmlApplicationContext.java:52) > at > > org.apache.activemq.xbean.XBeanBrokerFactory.createApplicationContext(XBe= anBrokerFactory.java:96) > at > > org.apache.activemq.xbean.XBeanBrokerFactory.createBroker(XBeanBrokerFact= ory.java:52) > at > > org.apache.activemq.broker.BrokerFactory.createBroker(BrokerFactory.java:= 71) > at > > org.apache.activemq.broker.BrokerFactory.createBroker(BrokerFactory.java:= 54) > at > > org.apache.activemq.console.command.StartCommand.startBroker(StartCommand= .java:115) > at > > org.apache.activemq.console.command.StartCommand.runTask(StartCommand.jav= a:74) > at > > org.apache.activemq.console.command.AbstractCommand.execute(AbstractComma= nd.java:57) > at > > org.apache.activemq.console.command.ShellCommand.runTask(ShellCommand.jav= a:136) > at > > org.apache.activemq.console.command.AbstractCommand.execute(AbstractComma= nd.java:57) > at > org.apache.activemq.console.command.ShellCommand.main(ShellCommand.java:8= 2) > at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) > at > > sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java= :39) > at > > sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorI= mpl.java:25) > at java.lang.reflect.Method.invoke(Method.java:585) > at org.apache.activemq.console.Main.runTaskClass(Main.java:251) > at org.apache.activemq.console.Main.main(Main.java:107) > at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) > at > > sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java= :39) > at > > sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorI= mpl.java:25) > at java.lang.reflect.Method.invoke(Method.java:585) > at > org.tanukisoftware.wrapper.WrapperSimpleApp.run(WrapperSimpleApp.java:240= ) > at java.lang.Thread.run(Thread.java:595) > Caused by: ERROR 22018: Invalid character string format for type BIGINT. > at > org.apache.derby.iapi.error.StandardException.newException(Unknown > Source) > at org.apache.derby.iapi.types.DataType.invalidFormat(Unknown > Source) > at org.apache.derby.iapi.types.SQLLongint.setValue(Unknown Source) > ... 51 more > > Any ideas? However I don't know if the exception is related to the issue > that no more messages are delivered until I restart the ActiveMQ > installation. > -- > View this message in context: > http://old.nabble.com/ActiveMQ-stops-processing-messages-tp28728694p28728= 694.html > Sent from the ActiveMQ - User mailing list archive at Nabble.com. > > --=20 M=E1rcio Geovani Jasinski Blumenau, Santa Catarina Fone: +55 47 9653 4899 --00c09f93d602770a2d0488167a1a--