Hi at Proxy2897d49f_3cca_4235_b5e6_89baf89c1782.saveOrUpdate(Unknown Source)[:] at core.camel.product.WpmToDartFinishProcessor.process(WpmToDartFinishProcessor.java:71)
It looks like you do some jpa logic in your processor, maybe you can show us the code? Also as you use OSGi then class-loading can be "more picky". You may need to do your own bundle to make osgi package imports of dart.core.product.service.api and possible some JPA apis as well. On Mon, Jul 13, 2015 at 9:14 PM, Pratt, Jason <jason.pr...@windriver.com> wrote: > Thanks Claus, I realized that as well and adjusted the timeout settings. > However, I am getting a cryptic camel casting error now. > > I have the camel processor/routes in its own bundle calling a separate > persistent services bundle to write off data to the db. From what I can tell > camel doesn't like this. > However, when the camel processor/routes were/are in the same bundle these > casting issues don't appear and it persists the data as expected. > > Any idea why this cast exception would be happening? > > Here is the error: > 2015-07-13 11:50:03,271 | ERROR | #1 - timer://foo | DefaultErrorHandler > | 257 - org.apache.camel.camel-core - 2.15.2 | Failed delivery for > (MessageId: ID-ALA-JPRATT-L2-56182-1436813364589-0-47 on ExchangeId: > ID-ALA-JPRATT-L2-56182-1436813364589-0-46). Exhausted after delivery attempt: > 1 caught: java.lang.ClassCastException: > Proxy22e97ab2_6214_4dc9_893d_39670338edbb cannot be cast to > dart.core.product.service.api.ProductLineService > > Message History > --------------------------------------------------------------------------------------------------------------------------------------- > RouteId ProcessorId Processor > Elapsed (ms) > [Noncache ] [Noncache ] [timer://foo?repeatCount=1 > ] [ 37183] > [Noncache ] [process3 ] [Processor@0x65cb9fe8 > ] [ 2] > [Noncache ] [to3 ] [jdbc:NonCache > ] [ 13] > [Noncache ] [split3 ] [split[{body}] > ] [ 37049] > [Noncache ] [process9 ] [Processor@0x1ecd4abc > ] [ 36] > > Exchange > --------------------------------------------------------------------------------------------------------------------------------------- > Exchange[ > Id ID-ALA-JPRATT-L2-56182-1436813364589-0-46 > ExchangePattern InOnly > Headers {CamelJdbcColumnNames=[myKey, mPortfolio, id, > mName, mDeleted], CamelJdbcRowCount=2, CamelRedelivered=false, > CamelRedeliveryCounter=0} > BodyType java.util.ArrayList > Body [{myKey=CQ2, id=1, name=bench, folio=bench, > deleted=false}, {mKey=CQ2, id=4, name=debugging, folio=bench, deleted=false}] > ] > > Stacktrace > --------------------------------------------------------------------------------------------------------------------------------------- > java.lang.ClassCastException: Proxy22e97ab2_6214_4dc9_893d_39670338edbb > cannot be cast to dart.core.product.service.api.ProductLineService > at Proxy2897d49f_3cca_4235_b5e6_89baf89c1782.saveOrUpdate(Unknown > Source)[:] > at > core.camel.product.WpmToDartFinishProcessor.process(WpmToDartFinishProcessor.java:71)[333:core-camel:1.0.0] > at > org.apache.camel.processor.DelegateSyncProcessor.process(DelegateSyncProcessor.java:63)[257:org.apache.camel.camel-core:2.15.2] > at > org.apache.camel.management.InstrumentationProcessor.process(InstrumentationProcessor.java:77)[257:org.apache.camel.camel-core:2.15.2] > at > org.apache.camel.processor.RedeliveryErrorHandler.process(RedeliveryErrorHandler.java:448)[257:org.apache.camel.camel-core:2.15.2] > at > org.apache.camel.processor.CamelInternalProcessor.process(CamelInternalProcessor.java:191)[257:org.apache.camel.camel-core:2.15.2] > at > org.apache.camel.processor.Pipeline.process(Pipeline.java:118)[257:org.apache.camel.camel-core:2.15.2] > at > org.apache.camel.processor.Pipeline.process(Pipeline.java:80)[257:org.apache.camel.camel-core:2.15.2] > at > org.apache.camel.processor.RedeliveryErrorHandler.process(RedeliveryErrorHandler.java:448)[257:org.apache.camel.camel-core:2.15.2] > at > org.apache.camel.processor.CamelInternalProcessor.process(CamelInternalProcessor.java:191)[257:org.apache.camel.camel-core:2.15.2] > at > org.apache.camel.processor.MulticastProcessor.doProcessSequential(MulticastProcessor.java:652)[257:org.apache.camel.camel-core:2.15.2] > at > org.apache.camel.processor.MulticastProcessor.doProcessSequential(MulticastProcessor.java:580)[257:org.apache.camel.camel-core:2.15.2] > at > org.apache.camel.processor.MulticastProcessor.process(MulticastProcessor.java:227)[257:org.apache.camel.camel-core:2.15.2] > at > org.apache.camel.processor.Splitter.process(Splitter.java:104)[257:org.apache.camel.camel-core:2.15.2] > at > org.apache.camel.management.InstrumentationProcessor.process(InstrumentationProcessor.java:77)[257:org.apache.camel.camel-core:2.15.2] > at > org.apache.camel.processor.RedeliveryErrorHandler.process(RedeliveryErrorHandler.java:448)[257:org.apache.camel.camel-core:2.15.2] > at > org.apache.camel.processor.CamelInternalProcessor.process(CamelInternalProcessor.java:191)[257:org.apache.camel.camel-core:2.15.2] > at > org.apache.camel.processor.Pipeline.process(Pipeline.java:118)[257:org.apache.camel.camel-core:2.15.2] > at > org.apache.camel.processor.Pipeline.process(Pipeline.java:80)[257:org.apache.camel.camel-core:2.15.2] > at > org.apache.camel.processor.CamelInternalProcessor.process(CamelInternalProcessor.java:191)[257:org.apache.camel.camel-core:2.15.2] > at > org.apache.camel.component.timer.TimerConsumer.sendTimerExchange(TimerConsumer.java:165)[257:org.apache.camel.camel-core:2.15.2] > at > org.apache.camel.component.timer.TimerConsumer$1.run(TimerConsumer.java:73)[257:org.apache.camel.camel-core:2.15.2] > at java.util.TimerThread.mainLoop(Timer.java:555)[:1.7.0_79] > at java.util.TimerThread.run(Timer.java:505)[:1.7.0_79] > > > -----Original Message----- > From: Claus Ibsen [mailto:claus.ib...@gmail.com] > Sent: Wednesday, July 08, 2015 10:27 PM > To: users@camel.apache.org > Subject: Re: HELP camel-sql and jpa problem > > Hi > > That indicates you need to either limit the returned data set so you can > process it faster, or increase the TX timeout so it wont trigger a timeout > while you process the data. > > > > On Wed, Jul 8, 2015 at 8:56 PM, Pratt, Jason <jason.pr...@windriver.com> > wrote: >> This also happens if we have a LARGE dataset. >> >> 2015-07-07 21:07:31,969 | INFO | #1 - timer://foo | >> WpmToDartFinishProcessor | 315 - core-product - 1.0.1 | >>> >> getProductService = >> com.wrs.ept.dart.core.product.service.ProductLineServiceImpl@7dd31e8b >> 2015-07-07 21:40:39,928 | INFO | #1 - timer://foo | >> ticalLoggingSessionEventListener | 79 - org.jboss.logging.jboss-logging - >> 3.1.4.GA | Session Metrics { >> 639049432972 nanoseconds spent acquiring 116853 JDBC connections; >> 15578656409 nanoseconds spent releasing 116853 JDBC connections; >> 651493686650 nanoseconds spent preparing 116959 JDBC statements; >> 884948912356 nanoseconds spent executing 116852 JDBC statements; >> 357116928277 nanoseconds spent executing 688 JDBC batches; >> 0 nanoseconds spent performing 0 L2C puts; >> 0 nanoseconds spent performing 0 L2C hits; >> 0 nanoseconds spent performing 0 L2C misses; >> 378287504498 nanoseconds spent executing 3 flushes (flushing a total of >> 467401 entities and 180 collections); >> 42345 nanoseconds spent executing 1 partial-flushes (flushing a >> total of 0 entities and 0 collections) } >> 2015-07-07 21:40:40,003 | ERROR | #1 - timer://foo | DefaultErrorHandler >> | 264 - org.apache.camel.camel-core - 2.15.2 | Failed delivery for >> (MessageId: ID-ala-pcheung-l3-63967-1436328423513-0-6 on ExchangeId: ID- >> ala-pcheung-l3-63967-1436328423513-0-5). Exhausted after delivery >> attempt: 1 caught: >> org.apache.aries.transaction.exception.TransactionRollbackException: >> javax.transaction.RollbackException: Unable to commit: transaction >> mark ed for rollback >> >> Message History >> --------------------------------------------------------------------------------------------------------------------------------------- >> RouteId ProcessorId Processor >> Elapsed (ms) >> [Noncache ] [wpmSuiteNoncache ] [timer://foo?repeatCount=1 >> ] [ 2013785] >> [Noncache ] [process1 ] [Processor@0x726b22b >> ] [ 1] >> [Noncache ] [to2 ] [jdbc: NonCache >> ] [ 11] >> [Noncache ] [split2 ] [split[{body}] >> ] [ 20968] >> [Noncache ] [process7 ] [Processor@0x199a7572 >> ] [ 1992771] >> >> Exchange >> ---------------------------------------------------------------------- >> ----------------------------------------------------------------- >> Exchange[ >> Id ID-ala-pcheung-l3-63967-1436328423513-0-5 >> ExchangePattern InOnly >> Headers {CamelJdbcColumnNames=[mKey, mPortfolio, mId, >> mName], CamelJdbcRowCount=1, CamelRedelivered=false, >> CamelRedeliveryCounter=0} >> BodyType java.util.ArrayList >> Body [{mKey=MYSQL1:25, mId=25, mName=xxx, >> mPortfolio=xxx}] >> ] >> >> Stacktrace >> ---------------------------------------------------------------------- >> ----------------------------------------------------------------- >> org.apache.aries.transaction.exception.TransactionRollbackException: >> javax.transaction.RollbackException: Unable to commit: transaction marked >> for rollback >> at >> org.apache.aries.transaction.TxInterceptorImpl.postCallWithReturn(TxInterceptorImpl.java:91)[95:org.apache.aries.transaction.blueprint:1.0.2] >> at >> org.apache.aries.blueprint.proxy.Collaborator.postInvoke(Collaborator.java:105)[15:org.apache.aries.blueprint.core:1.4.3] >> at Proxyd0d0974b_705f_4ea5_b64e_a32066c869ca.saveOrUpdate(Unknown >> Source)[:] >> at >> com.wrs.ept.dart.core.product.camel.WpmToDartFinishProcessor.process(WpmToDartFinishProcessor.java:30)[315:core-product:1.0.1] >> at >> org.apache.camel.processor.DelegateSyncProcessor.process(DelegateSyncProcessor.java:63)[264:org.apache.camel.camel-core:2.15.2] >> at >> org.apache.camel.management.InstrumentationProcessor.process(InstrumentationProcessor.java:77)[264:org.apache.camel.camel-core:2.15.2] >> at >> org.apache.camel.processor.RedeliveryErrorHandler.process(RedeliveryErrorHandler.java:448)[264:org.apache.camel.camel-core:2.15.2] >> at >> org.apache.camel.processor.CamelInternalProcessor.process(CamelInternalProcessor.java:191)[264:org.apache.camel.camel-core:2.15.2] >> at >> org.apache.camel.processor.Pipeline.process(Pipeline.java:118)[264:org.apache.camel.camel-core:2.15.2] >> at >> org.apache.camel.processor.Pipeline.process(Pipeline.java:80)[264:org.apache.camel.camel-core:2.15.2] >> at >> org.apache.camel.processor.RedeliveryErrorHandler.process(RedeliveryErrorHandler.java:448)[264:org.apache.camel.camel-core:2.15.2] >> at >> org.apache.camel.processor.CamelInternalProcessor.process(CamelInternalProcessor.java:191)[264:org.apache.camel.camel-core:2.15.2] >> at >> org.apache.camel.processor.MulticastProcessor.doProcessSequential(MulticastProcessor.java:652)[264:org.apache.camel.camel-core:2.15.2] >> at >> org.apache.camel.processor.MulticastProcessor.doProcessSequential(MulticastProcessor.java:580)[264:org.apache.camel.camel-core:2.15.2] >> at >> org.apache.camel.processor.MulticastProcessor.process(MulticastProcessor.java:227)[264:org.apache.camel.camel-core:2.15.2] >> at >> org.apache.camel.processor.Splitter.process(Splitter.java:104)[264:org.apache.camel.camel-core:2.15.2] >> at >> org.apache.camel.management.InstrumentationProcessor.process(InstrumentationProcessor.java:77)[264:org.apache.camel.camel-core:2.15.2] >> at >> org.apache.camel.processor.RedeliveryErrorHandler.process(RedeliveryErrorHandler.java:448)[264:org.apache.camel.camel-core:2.15.2] >> at >> org.apache.camel.processor.CamelInternalProcessor.process(CamelInternalProcessor.java:191)[264:org.apache.camel.camel-core:2.15.2] >> at >> org.apache.camel.processor.Pipeline.process(Pipeline.java:118)[264:org.apache.camel.camel-core:2.15.2] >> at >> org.apache.camel.processor.Pipeline.process(Pipeline.java:80)[264:org.apache.camel.camel-core:2.15.2] >> at >> org.apache.camel.processor.CamelInternalProcessor.process(CamelInternalProcessor.java:191)[264:org.apache.camel.camel-core:2.15.2] >> at >> org.apache.camel.component.timer.TimerConsumer.sendTimerExchange(TimerConsumer.java:165)[264:org.apache.camel.camel-core:2.15.2] >> at >> org.apache.camel.component.timer.TimerConsumer$1.run(TimerConsumer.java:73)[264:org.apache.camel.camel-core:2.15.2] >> at java.util.TimerThread.mainLoop(Timer.java:555)[:1.7.0_79] >> at java.util.TimerThread.run(Timer.java:505)[:1.7.0_79] >> Caused by: javax.transaction.RollbackException: Unable to commit: >> transaction marked for rollback >> at >> org.apache.geronimo.transaction.manager.TransactionImpl.commit(TransactionImpl.java:272)[96:org.apache.aries.transaction.manager:1.1.1] >> at >> org.apache.geronimo.transaction.manager.TransactionManagerImpl.commit(TransactionManagerImpl.java:252)[96:org.apache.aries.transaction.manager:1.1.1] >> at Proxy13505eb8_8516_4525_ae35_742e7cb9e34d.commit(Unknown >> Source)[:] >> at >> org.apache.aries.transaction.TransactionAttribute$4.finish(TransactionAttribute.java:94)[95:org.apache.aries.transaction.blueprint:1.0.2] >> at >> org.apache.aries.transaction.TxInterceptorImpl.postCallWithReturn(TxInterceptorImpl.java:85)[95:org.apache.aries.transaction.blueprint:1.0.2] >> ... 25 more >> Caused by: java.lang.Exception: Transaction has timed out >> at >> org.apache.geronimo.transaction.manager.TransactionImpl.commit(TransactionImpl.java:266)[96:org.apache.aries.transaction.manager:1.1.1] >> ... 29 more >> 2015-07-07 21:40:40,187 | WARN | #1 - timer://foo | TimerConsumer >> | 264 - org.apache.camel.camel-core - 2.15.2 | Error processing >> exchange. Exchange[Message: { "xxx": [{"id":1,"mKey":"xxx","uuid":" >> 7f694555-01c9-4ddd-9c4e- [Body clipped after xxx chars, total length >> is 32987]]. Caused by: >> [org.apache.aries.transaction.exception.TransactionRollbackException - >> javax.transaction.RollbackExc >> eption: Unable to commit: transaction marked for rollback] >> org.apache.aries.transaction.exception.TransactionRollbackException: >> javax.transaction.RollbackException: Unable to commit: transaction marked >> for rollback >> at >> org.apache.aries.transaction.TxInterceptorImpl.postCallWithReturn(TxInterceptorImpl.java:91)[95:org.apache.aries.transaction.blueprint:1.0.2] >> at >> org.apache.aries.blueprint.proxy.Collaborator.postInvoke(Collaborator.java:105)[15:org.apache.aries.blueprint.core:1.4.3] >> at Proxyd0d0974b_705f_4ea5_b64e_a32066c869ca.saveOrUpdate(Unknown >> Source)[:] >> at >> com.wrs.ept.dart.core.product.camel.WpmToDartFinishProcessor.process(WpmToDartFinishProcessor.java:30)[315:core-product:1.0.1] >> at >> org.apache.camel.processor.DelegateSyncProcessor.process(DelegateSyncProcessor.java:63)[264:org.apache.camel.camel-core:2.15.2] >> at >> org.apache.camel.management.InstrumentationProcessor.process(InstrumentationProcessor.java:77)[264:org.apache.camel.camel-core:2.15.2] >> at >> org.apache.camel.processor.RedeliveryErrorHandler.process(RedeliveryErrorHandler.java:448)[264:org.apache.camel.camel-core:2.15.2] >> at >> org.apache.camel.processor.CamelInternalProcessor.process(CamelInternalProcessor.java:191)[264:org.apache.camel.camel-core:2.15.2] >> at >> org.apache.camel.processor.Pipeline.process(Pipeline.java:118)[264:org.apache.camel.camel-core:2.15.2] >> at >> org.apache.camel.processor.Pipeline.process(Pipeline.java:80)[264:org.apache.camel.camel-core:2.15.2] >> at >> org.apache.camel.processor.RedeliveryErrorHandler.process(RedeliveryErrorHandler.java:448)[264:org.apache.camel.camel-core:2.15.2] >> at >> org.apache.camel.processor.CamelInternalProcessor.process(CamelInternalProcessor.java:191)[264:org.apache.camel.camel-core:2.15.2] >> at >> org.apache.camel.processor.MulticastProcessor.doProcessSequential(MulticastProcessor.java:652)[264:org.apache.camel.camel-core:2.15.2] >> at >> org.apache.camel.processor.MulticastProcessor.doProcessSequential(MulticastProcessor.java:580)[264:org.apache.camel.camel-core:2.15.2] >> at >> org.apache.camel.processor.MulticastProcessor.process(MulticastProcessor.java:227)[264:org.apache.camel.camel-core:2.15.2] >> at >> org.apache.camel.processor.Splitter.process(Splitter.java:104)[264:org.apache.camel.camel-core:2.15.2] >> at >> org.apache.camel.management.InstrumentationProcessor.process(InstrumentationProcessor.java:77)[264:org.apache.camel.camel-core:2.15.2] >> at >> org.apache.camel.processor.RedeliveryErrorHandler.process(RedeliveryErrorHandler.java:448)[264:org.apache.camel.camel-core:2.15.2] >> at >> org.apache.camel.processor.CamelInternalProcessor.process(CamelInternalProcessor.java:191)[264:org.apache.camel.camel-core:2.15.2] >> at >> org.apache.camel.processor.Pipeline.process(Pipeline.java:118)[264:org.apache.camel.camel-core:2.15.2] >> at >> org.apache.camel.processor.Pipeline.process(Pipeline.java:80)[264:org.apache.camel.camel-core:2.15.2] >> at >> org.apache.camel.processor.CamelInternalProcessor.process(CamelInternalProcessor.java:191)[264:org.apache.camel.camel-core:2.15.2] >> at >> org.apache.camel.component.timer.TimerConsumer.sendTimerExchange(TimerConsumer.java:165)[264:org.apache.camel.camel-core:2.15.2] >> at >> org.apache.camel.component.timer.TimerConsumer$1.run(TimerConsumer.java:73)[264:org.apache.camel.camel-core:2.15.2] >> at java.util.TimerThread.mainLoop(Timer.java:555)[:1.7.0_79] >> at java.util.TimerThread.run(Timer.java:505)[:1.7.0_79] >> Caused by: javax.transaction.RollbackException: Unable to commit: >> transaction marked for rollback >> at >> org.apache.geronimo.transaction.manager.TransactionImpl.commit(TransactionImpl.java:272)[96:org.apache.aries.transaction.manager:1.1.1] >> at >> org.apache.geronimo.transaction.manager.TransactionManagerImpl.commit(TransactionManagerImpl.java:252)[96:org.apache.aries.transaction.manager:1.1.1] >> at Proxy13505eb8_8516_4525_ae35_742e7cb9e34d.commit(Unknown >> Source)[:] >> at >> org.apache.aries.transaction.TransactionAttribute$4.finish(TransactionAttribute.java:94)[95:org.apache.aries.transaction.blueprint:1.0.2] >> at >> org.apache.aries.transaction.TxInterceptorImpl.postCallWithReturn(TxInterceptorImpl.java:85)[95:org.apache.aries.transaction.blueprint:1.0.2] >> ... 25 more >> Caused by: java.lang.Exception: Transaction has timed out >> at >> org.apache.geronimo.transaction.manager.TransactionImpl.commit(TransactionImpl.java:266)[96:org.apache.aries.transaction.manager:1.1.1] >> ... 29 more >> >> -----Original Message----- >> From: Pratt, Jason [mailto:jason.pr...@windriver.com] >> Sent: Wednesday, July 08, 2015 11:18 AM >> To: users@camel.apache.org >> Subject: RE: HELP camel-sql and jpa problem >> >> A more complete stacktrace is listed below. It appears to be timing out, but >> I am not sure. >> >> Exchange >> ---------------------------------------------------------------------- >> ----------------------------------------------------------------- >> Exchange[ >> Id ID-ALA-JPRATT-L2-57521-1436377974985-0-498020 >> ExchangePattern InOnly >> Headers >> {breadcrumbId=ID-ALA-JPRATT-L2-57521-1436377974985-0-498019, >> CamelRedelivered=false, CamelRedeliveryCounter=0} >> BodyType String >> Body select envName, legacyEnvId from >> releaseToEnvName where releaseKey = "xxx"; >> ] >> >> Stacktrace >> ---------------------------------------------------------------------- >> ----------------------------------------------------------------- >> java.sql.SQLException: java.lang.NoClassDefFoundError: >> javax/net/ssl/SSLException >> at >> com.mysql.jdbc.SQLError.createSQLException(SQLError.java:998)[163:com.mysql.jdbc:5.1.35] >> at >> com.mysql.jdbc.SQLError.createSQLException(SQLError.java:937)[163:com.mysql.jdbc:5.1.35] >> at >> com.mysql.jdbc.SQLError.createSQLException(SQLError.java:926)[163:com.mysql.jdbc:5.1.35] >> at >> com.mysql.jdbc.SQLError.createSQLException(SQLError.java:872)[163:com.mysql.jdbc:5.1.35] >> at >> com.mysql.jdbc.SQLError.createSQLException(SQLError.java:904)[163:com.mysql.jdbc:5.1.35] >> at >> com.mysql.jdbc.SQLError.createSQLException(SQLError.java:894)[163:com.mysql.jdbc:5.1.35] >> at >> com.mysql.jdbc.Util.handleNewInstance(Util.java:407)[163:com.mysql.jdbc:5.1.35] >> at >> com.mysql.jdbc.SQLError.createCommunicationsException(SQLError.java:1038)[163:com.mysql.jdbc:5.1.35] >> at >> com.mysql.jdbc.MysqlIO.<init>(MysqlIO.java:338)[163:com.mysql.jdbc:5.1.35] >> at >> com.mysql.jdbc.ConnectionImpl.coreConnect(ConnectionImpl.java:2237)[163:com.mysql.jdbc:5.1.35] >> at >> com.mysql.jdbc.ConnectionImpl.connectOneTryOnly(ConnectionImpl.java:2270)[163:com.mysql.jdbc:5.1.35] >> at >> com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2069)[163:com.mysql.jdbc:5.1.35] >> at >> com.mysql.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:794)[163:com.mysql.jdbc:5.1.35] >> at >> com.mysql.jdbc.JDBC4Connection.<init>(JDBC4Connection.java:44)[163:com.mysql.jdbc:5.1.35] >> at sun.reflect.GeneratedConstructorAccessor91.newInstance(Unknown >> Source)[:1.7.0_79] >> at >> sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)[:1.7.0_79] >> at >> java.lang.reflect.Constructor.newInstance(Constructor.java:526)[:1.7.0_79] >> at >> com.mysql.jdbc.Util.handleNewInstance(Util.java:389)[163:com.mysql.jdbc:5.1.35] >> at >> com.mysql.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:399)[163:com.mysql.jdbc:5.1.35] >> at >> com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:325)[163:com.mysql.jdbc:5.1.35] >> at >> com.mysql.jdbc.jdbc2.optional.MysqlDataSource.getConnection(MysqlDataSource.java:422)[163:com.mysql.jdbc:5.1.35] >> at >> com.mysql.jdbc.jdbc2.optional.MysqlDataSource.getConnection(MysqlDataSource.java:134)[163:com.mysql.jdbc:5.1.35] >> at >> com.mysql.jdbc.jdbc2.optional.MysqlDataSource.getConnection(MysqlDataSource.java:105)[163:com.mysql.jdbc:5.1.35] >> at Proxy799360c1_2c24_4e0e_b421_2593c684b8e5.getConnection(Unknown >> Source)[:] >> at Proxyfaee2ad9_ba00_4d29_a45f_81e9105c0467.getConnection(Unknown >> Source)[:] >> at >> org.apache.camel.component.jdbc.JdbcProducer.processingSqlBySettingAutoCommit(JdbcProducer.java:78)[291:org.apache.camel.camel-jdbc:2.15.2] >> at >> org.apache.camel.component.jdbc.JdbcProducer.process(JdbcProducer.java:65)[291:org.apache.camel.camel-jdbc:2.15.2] >> at >> org.apache.camel.util.AsyncProcessorConverterHelper$ProcessorToAsyncProcessorBridge.process(AsyncProcessorConverterHelper.java:61)[264:org.apache.camel.camel-core:2.15.2] >> at >> org.apache.camel.processor.SendProcessor.process(SendProcessor.java:129)[264:org.apache.camel.camel-core:2.15.2] >> at >> org.apache.camel.management.InstrumentationProcessor.process(InstrumentationProcessor.java:77)[264:org.apache.camel.camel-core:2.15.2] >> at >> org.apache.camel.processor.RedeliveryErrorHandler.process(RedeliveryErrorHandler.java:448)[264:org.apache.camel.camel-core:2.15.2] >> at >> org.apache.camel.processor.CamelInternalProcessor.process(CamelInternalProcessor.java:191)[264:org.apache.camel.camel-core:2.15.2] >> at >> org.apache.camel.processor.Pipeline.process(Pipeline.java:118)[264:org.apache.camel.camel-core:2.15.2] >> at >> org.apache.camel.processor.Pipeline.process(Pipeline.java:80)[264:org.apache.camel.camel-core:2.15.2] >> at >> org.apache.camel.processor.FilterProcessor.process(FilterProcessor.java:58)[264:org.apache.camel.camel-core:2.15.2] >> at >> org.apache.camel.management.InstrumentationProcessor.process(InstrumentationProcessor.java:77)[264:org.apache.camel.camel-core:2.15.2] >> at >> org.apache.camel.processor.RedeliveryErrorHandler.process(RedeliveryErrorHandler.java:448)[264:org.apache.camel.camel-core:2.15.2] >> at >> org.apache.camel.processor.CamelInternalProcessor.process(CamelInternalProcessor.java:191)[264:org.apache.camel.camel-core:2.15.2] >> at >> org.apache.camel.processor.Pipeline.process(Pipeline.java:118)[264:org.apache.camel.camel-core:2.15.2] >> at >> org.apache.camel.processor.Pipeline.process(Pipeline.java:80)[264:org.apache.camel.camel-core:2.15.2] >> at >> org.apache.camel.processor.RedeliveryErrorHandler.process(RedeliveryErrorHandler.java:448)[264:org.apache.camel.camel-core:2.15.2] >> at >> org.apache.camel.processor.CamelInternalProcessor.process(CamelInternalProcessor.java:191)[264:org.apache.camel.camel-core:2.15.2] >> at >> org.apache.camel.processor.MulticastProcessor.doProcessSequential(MulticastProcessor.java:652)[264:org.apache.camel.camel-core:2.15.2] >> at >> org.apache.camel.processor.MulticastProcessor.doProcessSequential(MulticastProcessor.java:580)[264:org.apache.camel.camel-core:2.15.2] >> at >> org.apache.camel.processor.MulticastProcessor.process(MulticastProcessor.java:227)[264:org.apache.camel.camel-core:2.15.2] >> at >> org.apache.camel.processor.Splitter.process(Splitter.java:104)[264:org.apache.camel.camel-core:2.15.2] >> at >> org.apache.camel.management.InstrumentationProcessor.process(InstrumentationProcessor.java:77)[264:org.apache.camel.camel-core:2.15.2] >> at >> org.apache.camel.processor.RedeliveryErrorHandler.process(RedeliveryErrorHandler.java:448)[264:org.apache.camel.camel-core:2.15.2] >> at >> org.apache.camel.processor.CamelInternalProcessor.process(CamelInternalProcessor.java:191)[264:org.apache.camel.camel-core:2.15.2] >> at >> org.apache.camel.processor.Pipeline.process(Pipeline.java:118)[264:org.apache.camel.camel-core:2.15.2] >> at >> org.apache.camel.processor.Pipeline.process(Pipeline.java:80)[264:org.apache.camel.camel-core:2.15.2] >> at >> org.apache.camel.processor.RedeliveryErrorHandler.process(RedeliveryErrorHandler.java:448)[264:org.apache.camel.camel-core:2.15.2] >> at >> org.apache.camel.processor.CamelInternalProcessor.process(CamelInternalProcessor.java:191)[264:org.apache.camel.camel-core:2.15.2] >> at >> org.apache.camel.processor.MulticastProcessor.doProcessSequential(MulticastProcessor.java:652)[264:org.apache.camel.camel-core:2.15.2] >> at >> org.apache.camel.processor.MulticastProcessor.doProcessSequential(MulticastProcessor.java:580)[264:org.apache.camel.camel-core:2.15.2] >> at >> org.apache.camel.processor.MulticastProcessor.process(MulticastProcessor.java:227)[264:org.apache.camel.camel-core:2.15.2] >> at >> org.apache.camel.processor.Splitter.process(Splitter.java:104)[264:org.apache.camel.camel-core:2.15.2] >> at >> org.apache.camel.management.InstrumentationProcessor.process(InstrumentationProcessor.java:77)[264:org.apache.camel.camel-core:2.15.2] >> at >> org.apache.camel.processor.RedeliveryErrorHandler.process(RedeliveryErrorHandler.java:448)[264:org.apache.camel.camel-core:2.15.2] >> at >> org.apache.camel.processor.CamelInternalProcessor.process(CamelInternalProcessor.java:191)[264:org.apache.camel.camel-core:2.15.2] >> at >> org.apache.camel.processor.Pipeline.process(Pipeline.java:118)[264:org.apache.camel.camel-core:2.15.2] >> at >> org.apache.camel.processor.Pipeline.process(Pipeline.java:80)[264:org.apache.camel.camel-core:2.15.2] >> at >> org.apache.camel.processor.RedeliveryErrorHandler.process(RedeliveryErrorHandler.java:448)[264:org.apache.camel.camel-core:2.15.2] >> at >> org.apache.camel.processor.CamelInternalProcessor.process(CamelInternalProcessor.java:191)[264:org.apache.camel.camel-core:2.15.2] >> at >> org.apache.camel.processor.MulticastProcessor.doProcessSequential(MulticastProcessor.java:652)[264:org.apache.camel.camel-core:2.15.2] >> at >> org.apache.camel.processor.MulticastProcessor.doProcessSequential(MulticastProcessor.java:580)[264:org.apache.camel.camel-core:2.15.2] >> at >> org.apache.camel.processor.MulticastProcessor.process(MulticastProcessor.java:227)[264:org.apache.camel.camel-core:2.15.2] >> at >> org.apache.camel.processor.Splitter.process(Splitter.java:104)[264:org.apache.camel.camel-core:2.15.2] >> at >> org.apache.camel.management.InstrumentationProcessor.process(InstrumentationProcessor.java:77)[264:org.apache.camel.camel-core:2.15.2] >> at >> org.apache.camel.processor.RedeliveryErrorHandler.process(RedeliveryErrorHandler.java:448)[264:org.apache.camel.camel-core:2.15.2] >> at >> org.apache.camel.processor.CamelInternalProcessor.process(CamelInternalProcessor.java:191)[264:org.apache.camel.camel-core:2.15.2] >> at >> org.apache.camel.processor.Pipeline.process(Pipeline.java:118)[264:org.apache.camel.camel-core:2.15.2] >> at >> org.apache.camel.processor.Pipeline.process(Pipeline.java:80)[264:org.apache.camel.camel-core:2.15.2] >> at >> org.apache.camel.processor.RedeliveryErrorHandler.process(RedeliveryErrorHandler.java:448)[264:org.apache.camel.camel-core:2.15.2] >> at >> org.apache.camel.processor.CamelInternalProcessor.process(CamelInternalProcessor.java:191)[264:org.apache.camel.camel-core:2.15.2] >> at >> org.apache.camel.processor.MulticastProcessor.doProcessSequential(MulticastProcessor.java:652)[264:org.apache.camel.camel-core:2.15.2] >> at >> org.apache.camel.processor.MulticastProcessor.doProcessSequential(MulticastProcessor.java:580)[264:org.apache.camel.camel-core:2.15.2] >> at >> org.apache.camel.processor.MulticastProcessor.process(MulticastProcessor.java:227)[264:org.apache.camel.camel-core:2.15.2] >> at >> org.apache.camel.processor.Splitter.process(Splitter.java:104)[264:org.apache.camel.camel-core:2.15.2] >> at >> org.apache.camel.management.InstrumentationProcessor.process(InstrumentationProcessor.java:77)[264:org.apache.camel.camel-core:2.15.2] >> at >> org.apache.camel.processor.RedeliveryErrorHandler.process(RedeliveryErrorHandler.java:448)[264:org.apache.camel.camel-core:2.15.2] >> at >> org.apache.camel.processor.CamelInternalProcessor.process(CamelInternalProcessor.java:191)[264:org.apache.camel.camel-core:2.15.2] >> at >> org.apache.camel.processor.Pipeline.process(Pipeline.java:118)[264:org.apache.camel.camel-core:2.15.2] >> at >> org.apache.camel.processor.Pipeline.process(Pipeline.java:80)[264:org.apache.camel.camel-core:2.15.2] >> at >> org.apache.camel.processor.CamelInternalProcessor.process(CamelInternalProcessor.java:191)[264:org.apache.camel.camel-core:2.15.2] >> at >> org.apache.camel.component.timer.TimerConsumer.sendTimerExchange(TimerConsumer.java:165)[264:org.apache.camel.camel-core:2.15.2] >> at >> org.apache.camel.component.timer.TimerConsumer$1.run(TimerConsumer.java:73)[264:org.apache.camel.camel-core:2.15.2] >> at java.util.TimerThread.mainLoop(Timer.java:555)[:1.7.0_79] >> at java.util.TimerThread.run(Timer.java:505)[:1.7.0_79] >> Caused by: java.lang.NoClassDefFoundError: javax/net/ssl/SSLException >> at >> com.mysql.jdbc.SQLError.createLinkFailureMessageBasedOnHeuristics(SQLError.java:1174) >> at >> com.mysql.jdbc.exceptions.jdbc4.CommunicationsException.<init>(CommunicationsException.java:45) >> at sun.reflect.GeneratedConstructorAccessor100.newInstance(Unknown >> Source) >> at >> sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)[:1.7.0_79] >> at >> java.lang.reflect.Constructor.newInstance(Constructor.java:526)[:1.7.0_79] >> at com.mysql.jdbc.Util.handleNewInstance(Util.java:389) >> ... 82 more >> 2015-07-08 10:56:55,522 | ERROR | #1 - timer://foo | DefaultErrorHandler >> | 264 - org.apache.camel.camel-core - 2.15.2 | Failed delivery for >> (MessageId: ID-ALA-JPRATT-L2-57521-1436377974985-0-498024 on ExchangeId: >> ID-ALA-JPRATT-L2-57521-1436377974985-0-498025). Exhausted after delivery >> attempt: 1 caught: java.sql.SQLException: java.lang.NoClassDefFoundError: >> javax/net/ssl/SSLException >> >> Message History >> --------------------------------------------------------------------------------------------------------------------------------------- >> RouteId ProcessorId Processor >> Elapsed (ms) >> [Noncache ] [Noncache ] [timer://foo?fixedRate=true&period=900000 >> ] [ 238712] >> [Noncache ] [filter1 ] [filter[{body contains Milestone}] >> ] [ 5] >> [Noncache ] [to4 ] [jdbc: mydb] [ 4] >> >> >> >> >> -----Original Message----- >> From: Claus Ibsen [mailto:claus.ib...@gmail.com] >> Sent: Wednesday, July 08, 2015 12:29 AM >> To: users@camel.apache.org >> Subject: Re: HELP camel-sql and jpa problem >> >> Hi >> >> Is there more of that stacktrace? >> >> Though OSGi can be tricky with classloading. >> >> On Tue, Jul 7, 2015 at 10:00 PM, Pratt, Jason <jason.pr...@windriver.com> >> wrote: >>> Hello - I just started seeing this in my logs and haven't seen it happening >>> before. I am running: >>> >>> Karaf-3.0.4 >>> Camel-2.15.2 >>> >>> I am at a loss for what could be causing this. Its basically stopping >>> during a run after writing some items to the database, but dropping most of >>> the balance. >>> >>> >>> >>> Message History >>> --------------------------------------------------------------------------------------------------------------------------------------- >>> RouteId ProcessorId Processor >>> Elapsed (ms) >>> [Noncache ] [Noncache ] [timer://foo?fixedRate=true&period=900000 >>> ] [ 234744] >>> [Noncache ] [process1 ] [Processor@0x2cf91aaf >>> ] [ 0] >>> [Noncache ] [to2 ] [jdbc:mydb >>> ] [ 5] >>> >>> Exchange >>> --------------------------------------------------------------------- >>> ------------------------------------------------------------------ >>> Exchange[ >>> Id ID-ALA-JPRATT-L2-64645-1436297885034-0-489002 >>> ExchangePattern InOnly >>> Headers {CamelRedelivered=false, >>> CamelRedeliveryCounter=0} >>> BodyType String >>> Body select key, id, name, ppp from pl >>> where ppp = 'MyProd'; >>> ] >>> >>> Stacktrace >>> --------------------------------------------------------------------- >>> ------------------------------------------------------------------ >>> java.sql.SQLException: java.lang.NoClassDefFoundError: >>> javax/net/ssl/SSLException >> >> >> >> -- >> Claus Ibsen >> ----------------- >> Red Hat, Inc. >> Email: cib...@redhat.com >> Twitter: davsclaus >> Blog: http://davsclaus.com >> Author of Camel in Action: http://www.manning.com/ibsen >> hawtio: http://hawt.io/ >> fabric8: http://fabric8.io/ > > > > -- > Claus Ibsen > ----------------- > Red Hat, Inc. > Email: cib...@redhat.com > Twitter: davsclaus > Blog: http://davsclaus.com > Author of Camel in Action: http://www.manning.com/ibsen > hawtio: http://hawt.io/ > fabric8: http://fabric8.io/ -- Claus Ibsen ----------------- Red Hat, Inc. Email: cib...@redhat.com Twitter: davsclaus Blog: http://davsclaus.com Author of Camel in Action: http://www.manning.com/ibsen hawtio: http://hawt.io/ fabric8: http://fabric8.io/