[jira] Created: (CAMEL-173) BAM example failure

classic Classic list List threaded Threaded
10 messages Options
Reply | Threaded
Open this post in threaded view
|

[jira] Created: (CAMEL-173) BAM example failure

JIRA jira@apache.org
BAM example failure
-------------------

                 Key: CAMEL-173
                 URL: https://issues.apache.org/activemq/browse/CAMEL-173
             Project: Apache Camel
          Issue Type: Bug
          Components: examples
    Affects Versions: 1.2.0
         Environment: testing the camel-1.2.0 RC2 on SUSE Linux
            Reporter: Bozhong Lin


the example throws following error:

[pache.camel.spring.Main.main()] Main                           INFO  Apache Camel 1.2.0 starting
[pache.camel.spring.Main.main()] Main                           INFO  Generating DOT file for routes: /opt/dev/apache-camel-1.2.0/examples/camel-example-bam/target/site/cameldoc for: org.apache.camel.spring.SpringCamelContext@352d87
[nent.file.FileComponent@db248c] JDBCExceptionReporter          WARN  SQL Error: 0, SQLState: null
[nent.file.FileComponent@db248c] JDBCExceptionReporter          ERROR failed batch
Failed to load preferences.  Proceeding with defaults:

[nent.file.FileComponent@db248c] AbstractFlushingEventListener  ERROR Could not synchronize database state with session
org.hibernate.exception.GenericJDBCException: Could not execute JDBC batch update
        at org.hibernate.exception.SQLStateConverter.handledNonSpecificException(SQLStateConverter.java:103)
        at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:91)
        at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)
        at org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:249)
        at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:235)
        at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:139)
        at org.hibernate.event.def.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:298)
        at org.hibernate.event.def.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:27)
        at org.hibernate.impl.SessionImpl.flush(SessionImpl.java:1000)
        at org.hibernate.ejb.AbstractEntityManagerImpl.flush(AbstractEntityManagerImpl.java:296)
        at org.springframework.orm.jpa.JpaTemplate$8.doInJpa(JpaTemplate.java:289)
        at org.springframework.orm.jpa.JpaTemplate.execute(JpaTemplate.java:191)
        at org.springframework.orm.jpa.JpaTemplate.flush(JpaTemplate.java:287)
        at org.apache.camel.bam.processor.JpaBamProcessorSupport.loadEntity(JpaBamProcessorSupport.java:118)
        at org.apache.camel.bam.processor.BamProcessorSupport$1.doInTransaction(BamProcessorSupport.java:96)
        at org.springframework.transaction.support.TransactionTemplate.execute(TransactionTemplate.java:127)
        at org.apache.camel.bam.processor.BamProcessorSupport.process(BamProcessorSupport.java:91)
        at org.apache.camel.impl.converter.AsyncProcessorTypeConverter$ProcessorToAsynProcessorBridge.process(AsyncProcessorTypeConverter.java:44)
        at org.apache.camel.component.file.FileConsumer.pollFile(FileConsumer.java:131)
        at org.apache.camel.component.file.FileConsumer.pollFileOrDirectory(FileConsumer.java:68)
        at org.apache.camel.component.file.FileConsumer.pollFileOrDirectory(FileConsumer.java:76)
        at org.apache.camel.component.file.FileConsumer.poll(FileConsumer.java:49)
        at org.apache.camel.impl.ScheduledPollConsumer.run(ScheduledPollConsumer.java:63)
        at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:417)
        at java.util.concurrent.FutureTask$Sync.innerRunAndReset(FutureTask.java:280)
        at java.util.concurrent.FutureTask.runAndReset(FutureTask.java:135)
        at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.access$101(ScheduledThreadPoolExecutor.java:65)
        at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.runPeriodic(ScheduledThreadPoolExecutor.java:142)
        at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(ScheduledThreadPoolExecutor.java:166)
        at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:650)
        at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:675)
        at java.lang.Thread.run(Thread.java:595)
Caused by: java.sql.BatchUpdateException: failed batch
        at org.hsqldb.jdbc.jdbcStatement.executeBatch(Unknown Source)
        at org.hsqldb.jdbc.jdbcPreparedStatement.executeBatch(Unknown Source)
        at org.hibernate.jdbc.BatchingBatcher.doExecuteBatch(BatchingBatcher.java:48)
        at org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:242)
        ... 28 more
[nent.file.FileComponent@db248c] BamProcessorSupport            INFO  Attempt to insert duplicate row due to concurrency issue, so retrying: org.springframework.orm.jpa.JpaSystemException: org.hibernate.exception.GenericJDBCException: Could not execute JDBC batch update; nested exception is javax.persistence.PersistenceException: org.hibernate.exception.GenericJDBCException: Could not execute JDBC batch update
[nent.file.FileComponent@db248c] BamProcessorSupport            INFO  Retry attempt due to duplicate row: 1
[         ActivityMonitorEngine] BamFailures                    ERROR Exchange[Message: ActivityState[2 on ProcessInstance[p3] Activity[2 name: file:src/data/invoices?noop=true]]]
[         ActivityMonitorEngine] BamFailures                    ERROR Exchange[Message: ActivityState[7 on ProcessInstance[p2] Activity[2 name: file:src/data/invoices?noop=true]]]


--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.

Reply | Threaded
Open this post in threaded view
|

[jira] Assigned: (CAMEL-173) BAM example failure

JIRA jira@apache.org

     [ https://issues.apache.org/activemq/browse/CAMEL-173?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Claus Ibsen reassigned CAMEL-173:
---------------------------------

    Assignee: Claus Ibsen

> BAM example failure
> -------------------
>
>                 Key: CAMEL-173
>                 URL: https://issues.apache.org/activemq/browse/CAMEL-173
>             Project: Apache Camel
>          Issue Type: Bug
>          Components: examples
>    Affects Versions: 1.2.0
>         Environment: testing the camel-1.2.0 RC2 on SUSE Linux
>            Reporter: Bozhong Lin
>            Assignee: Claus Ibsen
>
> the example throws following error:
> [pache.camel.spring.Main.main()] Main                           INFO  Apache Camel 1.2.0 starting
> [pache.camel.spring.Main.main()] Main                           INFO  Generating DOT file for routes: /opt/dev/apache-camel-1.2.0/examples/camel-example-bam/target/site/cameldoc for: org.apache.camel.spring.SpringCamelContext@352d87
> [nent.file.FileComponent@db248c] JDBCExceptionReporter          WARN  SQL Error: 0, SQLState: null
> [nent.file.FileComponent@db248c] JDBCExceptionReporter          ERROR failed batch
> Failed to load preferences.  Proceeding with defaults:
> [nent.file.FileComponent@db248c] AbstractFlushingEventListener  ERROR Could not synchronize database state with session
> org.hibernate.exception.GenericJDBCException: Could not execute JDBC batch update
>         at org.hibernate.exception.SQLStateConverter.handledNonSpecificException(SQLStateConverter.java:103)
>         at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:91)
>         at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)
>         at org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:249)
>         at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:235)
>         at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:139)
>         at org.hibernate.event.def.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:298)
>         at org.hibernate.event.def.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:27)
>         at org.hibernate.impl.SessionImpl.flush(SessionImpl.java:1000)
>         at org.hibernate.ejb.AbstractEntityManagerImpl.flush(AbstractEntityManagerImpl.java:296)
>         at org.springframework.orm.jpa.JpaTemplate$8.doInJpa(JpaTemplate.java:289)
>         at org.springframework.orm.jpa.JpaTemplate.execute(JpaTemplate.java:191)
>         at org.springframework.orm.jpa.JpaTemplate.flush(JpaTemplate.java:287)
>         at org.apache.camel.bam.processor.JpaBamProcessorSupport.loadEntity(JpaBamProcessorSupport.java:118)
>         at org.apache.camel.bam.processor.BamProcessorSupport$1.doInTransaction(BamProcessorSupport.java:96)
>         at org.springframework.transaction.support.TransactionTemplate.execute(TransactionTemplate.java:127)
>         at org.apache.camel.bam.processor.BamProcessorSupport.process(BamProcessorSupport.java:91)
>         at org.apache.camel.impl.converter.AsyncProcessorTypeConverter$ProcessorToAsynProcessorBridge.process(AsyncProcessorTypeConverter.java:44)
>         at org.apache.camel.component.file.FileConsumer.pollFile(FileConsumer.java:131)
>         at org.apache.camel.component.file.FileConsumer.pollFileOrDirectory(FileConsumer.java:68)
>         at org.apache.camel.component.file.FileConsumer.pollFileOrDirectory(FileConsumer.java:76)
>         at org.apache.camel.component.file.FileConsumer.poll(FileConsumer.java:49)
>         at org.apache.camel.impl.ScheduledPollConsumer.run(ScheduledPollConsumer.java:63)
>         at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:417)
>         at java.util.concurrent.FutureTask$Sync.innerRunAndReset(FutureTask.java:280)
>         at java.util.concurrent.FutureTask.runAndReset(FutureTask.java:135)
>         at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.access$101(ScheduledThreadPoolExecutor.java:65)
>         at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.runPeriodic(ScheduledThreadPoolExecutor.java:142)
>         at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(ScheduledThreadPoolExecutor.java:166)
>         at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:650)
>         at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:675)
>         at java.lang.Thread.run(Thread.java:595)
> Caused by: java.sql.BatchUpdateException: failed batch
>         at org.hsqldb.jdbc.jdbcStatement.executeBatch(Unknown Source)
>         at org.hsqldb.jdbc.jdbcPreparedStatement.executeBatch(Unknown Source)
>         at org.hibernate.jdbc.BatchingBatcher.doExecuteBatch(BatchingBatcher.java:48)
>         at org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:242)
>         ... 28 more
> [nent.file.FileComponent@db248c] BamProcessorSupport            INFO  Attempt to insert duplicate row due to concurrency issue, so retrying: org.springframework.orm.jpa.JpaSystemException: org.hibernate.exception.GenericJDBCException: Could not execute JDBC batch update; nested exception is javax.persistence.PersistenceException: org.hibernate.exception.GenericJDBCException: Could not execute JDBC batch update
> [nent.file.FileComponent@db248c] BamProcessorSupport            INFO  Retry attempt due to duplicate row: 1
> [         ActivityMonitorEngine] BamFailures                    ERROR Exchange[Message: ActivityState[2 on ProcessInstance[p3] Activity[2 name: file:src/data/invoices?noop=true]]]
> [         ActivityMonitorEngine] BamFailures                    ERROR Exchange[Message: ActivityState[7 on ProcessInstance[p2] Activity[2 name: file:src/data/invoices?noop=true]]]

--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.

Reply | Threaded
Open this post in threaded view
|

[jira] Work started: (CAMEL-173) BAM example failure

JIRA jira@apache.org
In reply to this post by JIRA jira@apache.org

     [ https://issues.apache.org/activemq/browse/CAMEL-173?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Work on CAMEL-173 started by Claus Ibsen.

> BAM example failure
> -------------------
>
>                 Key: CAMEL-173
>                 URL: https://issues.apache.org/activemq/browse/CAMEL-173
>             Project: Apache Camel
>          Issue Type: Bug
>          Components: examples
>    Affects Versions: 1.2.0
>         Environment: testing the camel-1.2.0 RC2 on SUSE Linux
>            Reporter: Bozhong Lin
>            Assignee: Claus Ibsen
>
> the example throws following error:
> [pache.camel.spring.Main.main()] Main                           INFO  Apache Camel 1.2.0 starting
> [pache.camel.spring.Main.main()] Main                           INFO  Generating DOT file for routes: /opt/dev/apache-camel-1.2.0/examples/camel-example-bam/target/site/cameldoc for: org.apache.camel.spring.SpringCamelContext@352d87
> [nent.file.FileComponent@db248c] JDBCExceptionReporter          WARN  SQL Error: 0, SQLState: null
> [nent.file.FileComponent@db248c] JDBCExceptionReporter          ERROR failed batch
> Failed to load preferences.  Proceeding with defaults:
> [nent.file.FileComponent@db248c] AbstractFlushingEventListener  ERROR Could not synchronize database state with session
> org.hibernate.exception.GenericJDBCException: Could not execute JDBC batch update
>         at org.hibernate.exception.SQLStateConverter.handledNonSpecificException(SQLStateConverter.java:103)
>         at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:91)
>         at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)
>         at org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:249)
>         at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:235)
>         at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:139)
>         at org.hibernate.event.def.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:298)
>         at org.hibernate.event.def.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:27)
>         at org.hibernate.impl.SessionImpl.flush(SessionImpl.java:1000)
>         at org.hibernate.ejb.AbstractEntityManagerImpl.flush(AbstractEntityManagerImpl.java:296)
>         at org.springframework.orm.jpa.JpaTemplate$8.doInJpa(JpaTemplate.java:289)
>         at org.springframework.orm.jpa.JpaTemplate.execute(JpaTemplate.java:191)
>         at org.springframework.orm.jpa.JpaTemplate.flush(JpaTemplate.java:287)
>         at org.apache.camel.bam.processor.JpaBamProcessorSupport.loadEntity(JpaBamProcessorSupport.java:118)
>         at org.apache.camel.bam.processor.BamProcessorSupport$1.doInTransaction(BamProcessorSupport.java:96)
>         at org.springframework.transaction.support.TransactionTemplate.execute(TransactionTemplate.java:127)
>         at org.apache.camel.bam.processor.BamProcessorSupport.process(BamProcessorSupport.java:91)
>         at org.apache.camel.impl.converter.AsyncProcessorTypeConverter$ProcessorToAsynProcessorBridge.process(AsyncProcessorTypeConverter.java:44)
>         at org.apache.camel.component.file.FileConsumer.pollFile(FileConsumer.java:131)
>         at org.apache.camel.component.file.FileConsumer.pollFileOrDirectory(FileConsumer.java:68)
>         at org.apache.camel.component.file.FileConsumer.pollFileOrDirectory(FileConsumer.java:76)
>         at org.apache.camel.component.file.FileConsumer.poll(FileConsumer.java:49)
>         at org.apache.camel.impl.ScheduledPollConsumer.run(ScheduledPollConsumer.java:63)
>         at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:417)
>         at java.util.concurrent.FutureTask$Sync.innerRunAndReset(FutureTask.java:280)
>         at java.util.concurrent.FutureTask.runAndReset(FutureTask.java:135)
>         at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.access$101(ScheduledThreadPoolExecutor.java:65)
>         at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.runPeriodic(ScheduledThreadPoolExecutor.java:142)
>         at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(ScheduledThreadPoolExecutor.java:166)
>         at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:650)
>         at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:675)
>         at java.lang.Thread.run(Thread.java:595)
> Caused by: java.sql.BatchUpdateException: failed batch
>         at org.hsqldb.jdbc.jdbcStatement.executeBatch(Unknown Source)
>         at org.hsqldb.jdbc.jdbcPreparedStatement.executeBatch(Unknown Source)
>         at org.hibernate.jdbc.BatchingBatcher.doExecuteBatch(BatchingBatcher.java:48)
>         at org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:242)
>         ... 28 more
> [nent.file.FileComponent@db248c] BamProcessorSupport            INFO  Attempt to insert duplicate row due to concurrency issue, so retrying: org.springframework.orm.jpa.JpaSystemException: org.hibernate.exception.GenericJDBCException: Could not execute JDBC batch update; nested exception is javax.persistence.PersistenceException: org.hibernate.exception.GenericJDBCException: Could not execute JDBC batch update
> [nent.file.FileComponent@db248c] BamProcessorSupport            INFO  Retry attempt due to duplicate row: 1
> [         ActivityMonitorEngine] BamFailures                    ERROR Exchange[Message: ActivityState[2 on ProcessInstance[p3] Activity[2 name: file:src/data/invoices?noop=true]]]
> [         ActivityMonitorEngine] BamFailures                    ERROR Exchange[Message: ActivityState[7 on ProcessInstance[p2] Activity[2 name: file:src/data/invoices?noop=true]]]

--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.

Reply | Threaded
Open this post in threaded view
|

[jira] Updated: (CAMEL-173) BAM example failure

JIRA jira@apache.org
In reply to this post by JIRA jira@apache.org

     [ https://issues.apache.org/activemq/browse/CAMEL-173?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Claus Ibsen updated CAMEL-173:
------------------------------

    Fix Version/s: 1.4.0
         Priority: Minor  (was: Major)

> BAM example failure
> -------------------
>
>                 Key: CAMEL-173
>                 URL: https://issues.apache.org/activemq/browse/CAMEL-173
>             Project: Apache Camel
>          Issue Type: Bug
>          Components: examples
>    Affects Versions: 1.2.0
>         Environment: testing the camel-1.2.0 RC2 on SUSE Linux
>            Reporter: Bozhong Lin
>            Assignee: Claus Ibsen
>            Priority: Minor
>             Fix For: 1.4.0
>
>
> the example throws following error:
> [pache.camel.spring.Main.main()] Main                           INFO  Apache Camel 1.2.0 starting
> [pache.camel.spring.Main.main()] Main                           INFO  Generating DOT file for routes: /opt/dev/apache-camel-1.2.0/examples/camel-example-bam/target/site/cameldoc for: org.apache.camel.spring.SpringCamelContext@352d87
> [nent.file.FileComponent@db248c] JDBCExceptionReporter          WARN  SQL Error: 0, SQLState: null
> [nent.file.FileComponent@db248c] JDBCExceptionReporter          ERROR failed batch
> Failed to load preferences.  Proceeding with defaults:
> [nent.file.FileComponent@db248c] AbstractFlushingEventListener  ERROR Could not synchronize database state with session
> org.hibernate.exception.GenericJDBCException: Could not execute JDBC batch update
>         at org.hibernate.exception.SQLStateConverter.handledNonSpecificException(SQLStateConverter.java:103)
>         at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:91)
>         at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)
>         at org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:249)
>         at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:235)
>         at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:139)
>         at org.hibernate.event.def.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:298)
>         at org.hibernate.event.def.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:27)
>         at org.hibernate.impl.SessionImpl.flush(SessionImpl.java:1000)
>         at org.hibernate.ejb.AbstractEntityManagerImpl.flush(AbstractEntityManagerImpl.java:296)
>         at org.springframework.orm.jpa.JpaTemplate$8.doInJpa(JpaTemplate.java:289)
>         at org.springframework.orm.jpa.JpaTemplate.execute(JpaTemplate.java:191)
>         at org.springframework.orm.jpa.JpaTemplate.flush(JpaTemplate.java:287)
>         at org.apache.camel.bam.processor.JpaBamProcessorSupport.loadEntity(JpaBamProcessorSupport.java:118)
>         at org.apache.camel.bam.processor.BamProcessorSupport$1.doInTransaction(BamProcessorSupport.java:96)
>         at org.springframework.transaction.support.TransactionTemplate.execute(TransactionTemplate.java:127)
>         at org.apache.camel.bam.processor.BamProcessorSupport.process(BamProcessorSupport.java:91)
>         at org.apache.camel.impl.converter.AsyncProcessorTypeConverter$ProcessorToAsynProcessorBridge.process(AsyncProcessorTypeConverter.java:44)
>         at org.apache.camel.component.file.FileConsumer.pollFile(FileConsumer.java:131)
>         at org.apache.camel.component.file.FileConsumer.pollFileOrDirectory(FileConsumer.java:68)
>         at org.apache.camel.component.file.FileConsumer.pollFileOrDirectory(FileConsumer.java:76)
>         at org.apache.camel.component.file.FileConsumer.poll(FileConsumer.java:49)
>         at org.apache.camel.impl.ScheduledPollConsumer.run(ScheduledPollConsumer.java:63)
>         at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:417)
>         at java.util.concurrent.FutureTask$Sync.innerRunAndReset(FutureTask.java:280)
>         at java.util.concurrent.FutureTask.runAndReset(FutureTask.java:135)
>         at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.access$101(ScheduledThreadPoolExecutor.java:65)
>         at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.runPeriodic(ScheduledThreadPoolExecutor.java:142)
>         at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(ScheduledThreadPoolExecutor.java:166)
>         at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:650)
>         at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:675)
>         at java.lang.Thread.run(Thread.java:595)
> Caused by: java.sql.BatchUpdateException: failed batch
>         at org.hsqldb.jdbc.jdbcStatement.executeBatch(Unknown Source)
>         at org.hsqldb.jdbc.jdbcPreparedStatement.executeBatch(Unknown Source)
>         at org.hibernate.jdbc.BatchingBatcher.doExecuteBatch(BatchingBatcher.java:48)
>         at org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:242)
>         ... 28 more
> [nent.file.FileComponent@db248c] BamProcessorSupport            INFO  Attempt to insert duplicate row due to concurrency issue, so retrying: org.springframework.orm.jpa.JpaSystemException: org.hibernate.exception.GenericJDBCException: Could not execute JDBC batch update; nested exception is javax.persistence.PersistenceException: org.hibernate.exception.GenericJDBCException: Could not execute JDBC batch update
> [nent.file.FileComponent@db248c] BamProcessorSupport            INFO  Retry attempt due to duplicate row: 1
> [         ActivityMonitorEngine] BamFailures                    ERROR Exchange[Message: ActivityState[2 on ProcessInstance[p3] Activity[2 name: file:src/data/invoices?noop=true]]]
> [         ActivityMonitorEngine] BamFailures                    ERROR Exchange[Message: ActivityState[7 on ProcessInstance[p2] Activity[2 name: file:src/data/invoices?noop=true]]]

--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.

Reply | Threaded
Open this post in threaded view
|

[jira] Commented: (CAMEL-173) BAM example failure

JIRA jira@apache.org
In reply to this post by JIRA jira@apache.org

    [ https://issues.apache.org/activemq/browse/CAMEL-173?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=41871#action_41871 ]

Claus Ibsen commented on CAMEL-173:
-----------------------------------

The exception is happening on startup, it does not affect the application later on.
However it would be nicer to remove this noise.

> BAM example failure
> -------------------
>
>                 Key: CAMEL-173
>                 URL: https://issues.apache.org/activemq/browse/CAMEL-173
>             Project: Apache Camel
>          Issue Type: Bug
>          Components: examples
>    Affects Versions: 1.2.0
>         Environment: testing the camel-1.2.0 RC2 on SUSE Linux
>            Reporter: Bozhong Lin
>            Assignee: Claus Ibsen
>             Fix For: 1.4.0
>
>
> the example throws following error:
> [pache.camel.spring.Main.main()] Main                           INFO  Apache Camel 1.2.0 starting
> [pache.camel.spring.Main.main()] Main                           INFO  Generating DOT file for routes: /opt/dev/apache-camel-1.2.0/examples/camel-example-bam/target/site/cameldoc for: org.apache.camel.spring.SpringCamelContext@352d87
> [nent.file.FileComponent@db248c] JDBCExceptionReporter          WARN  SQL Error: 0, SQLState: null
> [nent.file.FileComponent@db248c] JDBCExceptionReporter          ERROR failed batch
> Failed to load preferences.  Proceeding with defaults:
> [nent.file.FileComponent@db248c] AbstractFlushingEventListener  ERROR Could not synchronize database state with session
> org.hibernate.exception.GenericJDBCException: Could not execute JDBC batch update
>         at org.hibernate.exception.SQLStateConverter.handledNonSpecificException(SQLStateConverter.java:103)
>         at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:91)
>         at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)
>         at org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:249)
>         at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:235)
>         at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:139)
>         at org.hibernate.event.def.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:298)
>         at org.hibernate.event.def.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:27)
>         at org.hibernate.impl.SessionImpl.flush(SessionImpl.java:1000)
>         at org.hibernate.ejb.AbstractEntityManagerImpl.flush(AbstractEntityManagerImpl.java:296)
>         at org.springframework.orm.jpa.JpaTemplate$8.doInJpa(JpaTemplate.java:289)
>         at org.springframework.orm.jpa.JpaTemplate.execute(JpaTemplate.java:191)
>         at org.springframework.orm.jpa.JpaTemplate.flush(JpaTemplate.java:287)
>         at org.apache.camel.bam.processor.JpaBamProcessorSupport.loadEntity(JpaBamProcessorSupport.java:118)
>         at org.apache.camel.bam.processor.BamProcessorSupport$1.doInTransaction(BamProcessorSupport.java:96)
>         at org.springframework.transaction.support.TransactionTemplate.execute(TransactionTemplate.java:127)
>         at org.apache.camel.bam.processor.BamProcessorSupport.process(BamProcessorSupport.java:91)
>         at org.apache.camel.impl.converter.AsyncProcessorTypeConverter$ProcessorToAsynProcessorBridge.process(AsyncProcessorTypeConverter.java:44)
>         at org.apache.camel.component.file.FileConsumer.pollFile(FileConsumer.java:131)
>         at org.apache.camel.component.file.FileConsumer.pollFileOrDirectory(FileConsumer.java:68)
>         at org.apache.camel.component.file.FileConsumer.pollFileOrDirectory(FileConsumer.java:76)
>         at org.apache.camel.component.file.FileConsumer.poll(FileConsumer.java:49)
>         at org.apache.camel.impl.ScheduledPollConsumer.run(ScheduledPollConsumer.java:63)
>         at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:417)
>         at java.util.concurrent.FutureTask$Sync.innerRunAndReset(FutureTask.java:280)
>         at java.util.concurrent.FutureTask.runAndReset(FutureTask.java:135)
>         at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.access$101(ScheduledThreadPoolExecutor.java:65)
>         at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.runPeriodic(ScheduledThreadPoolExecutor.java:142)
>         at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(ScheduledThreadPoolExecutor.java:166)
>         at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:650)
>         at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:675)
>         at java.lang.Thread.run(Thread.java:595)
> Caused by: java.sql.BatchUpdateException: failed batch
>         at org.hsqldb.jdbc.jdbcStatement.executeBatch(Unknown Source)
>         at org.hsqldb.jdbc.jdbcPreparedStatement.executeBatch(Unknown Source)
>         at org.hibernate.jdbc.BatchingBatcher.doExecuteBatch(BatchingBatcher.java:48)
>         at org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:242)
>         ... 28 more
> [nent.file.FileComponent@db248c] BamProcessorSupport            INFO  Attempt to insert duplicate row due to concurrency issue, so retrying: org.springframework.orm.jpa.JpaSystemException: org.hibernate.exception.GenericJDBCException: Could not execute JDBC batch update; nested exception is javax.persistence.PersistenceException: org.hibernate.exception.GenericJDBCException: Could not execute JDBC batch update
> [nent.file.FileComponent@db248c] BamProcessorSupport            INFO  Retry attempt due to duplicate row: 1
> [         ActivityMonitorEngine] BamFailures                    ERROR Exchange[Message: ActivityState[2 on ProcessInstance[p3] Activity[2 name: file:src/data/invoices?noop=true]]]
> [         ActivityMonitorEngine] BamFailures                    ERROR Exchange[Message: ActivityState[7 on ProcessInstance[p2] Activity[2 name: file:src/data/invoices?noop=true]]]

--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.

Reply | Threaded
Open this post in threaded view
|

[jira] Commented: (CAMEL-173) BAM example failure

JIRA jira@apache.org
In reply to this post by JIRA jira@apache.org

    [ https://issues.apache.org/activemq/browse/CAMEL-173?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=41874#action_41874 ]

James Strachan commented on CAMEL-173:
--------------------------------------

Agreed. I"m thinking this could be caused by concurrent threads trying to insert the same row? Am wondering if a different JDBC provider does locking better or something?

> BAM example failure
> -------------------
>
>                 Key: CAMEL-173
>                 URL: https://issues.apache.org/activemq/browse/CAMEL-173
>             Project: Apache Camel
>          Issue Type: Bug
>          Components: examples
>    Affects Versions: 1.2.0
>         Environment: testing the camel-1.2.0 RC2 on SUSE Linux
>            Reporter: Bozhong Lin
>            Assignee: Claus Ibsen
>            Priority: Minor
>             Fix For: 1.4.0
>
>
> the example throws following error:
> [pache.camel.spring.Main.main()] Main                           INFO  Apache Camel 1.2.0 starting
> [pache.camel.spring.Main.main()] Main                           INFO  Generating DOT file for routes: /opt/dev/apache-camel-1.2.0/examples/camel-example-bam/target/site/cameldoc for: org.apache.camel.spring.SpringCamelContext@352d87
> [nent.file.FileComponent@db248c] JDBCExceptionReporter          WARN  SQL Error: 0, SQLState: null
> [nent.file.FileComponent@db248c] JDBCExceptionReporter          ERROR failed batch
> Failed to load preferences.  Proceeding with defaults:
> [nent.file.FileComponent@db248c] AbstractFlushingEventListener  ERROR Could not synchronize database state with session
> org.hibernate.exception.GenericJDBCException: Could not execute JDBC batch update
>         at org.hibernate.exception.SQLStateConverter.handledNonSpecificException(SQLStateConverter.java:103)
>         at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:91)
>         at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)
>         at org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:249)
>         at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:235)
>         at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:139)
>         at org.hibernate.event.def.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:298)
>         at org.hibernate.event.def.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:27)
>         at org.hibernate.impl.SessionImpl.flush(SessionImpl.java:1000)
>         at org.hibernate.ejb.AbstractEntityManagerImpl.flush(AbstractEntityManagerImpl.java:296)
>         at org.springframework.orm.jpa.JpaTemplate$8.doInJpa(JpaTemplate.java:289)
>         at org.springframework.orm.jpa.JpaTemplate.execute(JpaTemplate.java:191)
>         at org.springframework.orm.jpa.JpaTemplate.flush(JpaTemplate.java:287)
>         at org.apache.camel.bam.processor.JpaBamProcessorSupport.loadEntity(JpaBamProcessorSupport.java:118)
>         at org.apache.camel.bam.processor.BamProcessorSupport$1.doInTransaction(BamProcessorSupport.java:96)
>         at org.springframework.transaction.support.TransactionTemplate.execute(TransactionTemplate.java:127)
>         at org.apache.camel.bam.processor.BamProcessorSupport.process(BamProcessorSupport.java:91)
>         at org.apache.camel.impl.converter.AsyncProcessorTypeConverter$ProcessorToAsynProcessorBridge.process(AsyncProcessorTypeConverter.java:44)
>         at org.apache.camel.component.file.FileConsumer.pollFile(FileConsumer.java:131)
>         at org.apache.camel.component.file.FileConsumer.pollFileOrDirectory(FileConsumer.java:68)
>         at org.apache.camel.component.file.FileConsumer.pollFileOrDirectory(FileConsumer.java:76)
>         at org.apache.camel.component.file.FileConsumer.poll(FileConsumer.java:49)
>         at org.apache.camel.impl.ScheduledPollConsumer.run(ScheduledPollConsumer.java:63)
>         at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:417)
>         at java.util.concurrent.FutureTask$Sync.innerRunAndReset(FutureTask.java:280)
>         at java.util.concurrent.FutureTask.runAndReset(FutureTask.java:135)
>         at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.access$101(ScheduledThreadPoolExecutor.java:65)
>         at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.runPeriodic(ScheduledThreadPoolExecutor.java:142)
>         at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(ScheduledThreadPoolExecutor.java:166)
>         at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:650)
>         at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:675)
>         at java.lang.Thread.run(Thread.java:595)
> Caused by: java.sql.BatchUpdateException: failed batch
>         at org.hsqldb.jdbc.jdbcStatement.executeBatch(Unknown Source)
>         at org.hsqldb.jdbc.jdbcPreparedStatement.executeBatch(Unknown Source)
>         at org.hibernate.jdbc.BatchingBatcher.doExecuteBatch(BatchingBatcher.java:48)
>         at org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:242)
>         ... 28 more
> [nent.file.FileComponent@db248c] BamProcessorSupport            INFO  Attempt to insert duplicate row due to concurrency issue, so retrying: org.springframework.orm.jpa.JpaSystemException: org.hibernate.exception.GenericJDBCException: Could not execute JDBC batch update; nested exception is javax.persistence.PersistenceException: org.hibernate.exception.GenericJDBCException: Could not execute JDBC batch update
> [nent.file.FileComponent@db248c] BamProcessorSupport            INFO  Retry attempt due to duplicate row: 1
> [         ActivityMonitorEngine] BamFailures                    ERROR Exchange[Message: ActivityState[2 on ProcessInstance[p3] Activity[2 name: file:src/data/invoices?noop=true]]]
> [         ActivityMonitorEngine] BamFailures                    ERROR Exchange[Message: ActivityState[7 on ProcessInstance[p2] Activity[2 name: file:src/data/invoices?noop=true]]]

--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.

Reply | Threaded
Open this post in threaded view
|

[jira] Commented: (CAMEL-173) BAM example failure

JIRA jira@apache.org
In reply to this post by JIRA jira@apache.org

    [ https://issues.apache.org/activemq/browse/CAMEL-173?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=41877#action_41877 ]

Claus Ibsen commented on CAMEL-173:
-----------------------------------

James please by all means review my patch committed.

Running the demo app now only displays:
{code}
[INFO] [camel:run]
[pache.camel.spring.Main.main()] Main                           INFO  Apache Camel 1.3-SNAPSHOT starting
[pache.camel.spring.Main.main()] Main                           INFO  Generating DOT file for routes: D:\project\camel\examples\camel-example-bam\target/site/cameldoc for: org.apache.camel.spring.SpringCamelContext@ae4f8b
Failed to load preferences.  Proceeding with defaults:

[         ActivityMonitorEngine] BamFailures                    ERROR Exchange[Message: ActivityState[3 on ProcessInstance[p1] Activity[2 name: file:src/data/invoices?noop=true]]]
[         ActivityMonitorEngine] BamFailures                    ERROR Exchange[Message: ActivityState[4 on ProcessInstance[p3] Activity[2 name: file:src/data/invoices?noop=true]]]
[         ActivityMonitorEngine] BamFailures                    ERROR Exchange[Message: ActivityState[6 on ProcessInstance[p2] Activity[2 name: file:src/data/invoices?noop=true]]]
Stopping
{code}

> BAM example failure
> -------------------
>
>                 Key: CAMEL-173
>                 URL: https://issues.apache.org/activemq/browse/CAMEL-173
>             Project: Apache Camel
>          Issue Type: Bug
>          Components: examples
>    Affects Versions: 1.2.0
>         Environment: testing the camel-1.2.0 RC2 on SUSE Linux
>            Reporter: Bozhong Lin
>            Assignee: Claus Ibsen
>            Priority: Minor
>             Fix For: 1.4.0
>
>
> the example throws following error:
> [pache.camel.spring.Main.main()] Main                           INFO  Apache Camel 1.2.0 starting
> [pache.camel.spring.Main.main()] Main                           INFO  Generating DOT file for routes: /opt/dev/apache-camel-1.2.0/examples/camel-example-bam/target/site/cameldoc for: org.apache.camel.spring.SpringCamelContext@352d87
> [nent.file.FileComponent@db248c] JDBCExceptionReporter          WARN  SQL Error: 0, SQLState: null
> [nent.file.FileComponent@db248c] JDBCExceptionReporter          ERROR failed batch
> Failed to load preferences.  Proceeding with defaults:
> [nent.file.FileComponent@db248c] AbstractFlushingEventListener  ERROR Could not synchronize database state with session
> org.hibernate.exception.GenericJDBCException: Could not execute JDBC batch update
>         at org.hibernate.exception.SQLStateConverter.handledNonSpecificException(SQLStateConverter.java:103)
>         at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:91)
>         at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)
>         at org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:249)
>         at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:235)
>         at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:139)
>         at org.hibernate.event.def.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:298)
>         at org.hibernate.event.def.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:27)
>         at org.hibernate.impl.SessionImpl.flush(SessionImpl.java:1000)
>         at org.hibernate.ejb.AbstractEntityManagerImpl.flush(AbstractEntityManagerImpl.java:296)
>         at org.springframework.orm.jpa.JpaTemplate$8.doInJpa(JpaTemplate.java:289)
>         at org.springframework.orm.jpa.JpaTemplate.execute(JpaTemplate.java:191)
>         at org.springframework.orm.jpa.JpaTemplate.flush(JpaTemplate.java:287)
>         at org.apache.camel.bam.processor.JpaBamProcessorSupport.loadEntity(JpaBamProcessorSupport.java:118)
>         at org.apache.camel.bam.processor.BamProcessorSupport$1.doInTransaction(BamProcessorSupport.java:96)
>         at org.springframework.transaction.support.TransactionTemplate.execute(TransactionTemplate.java:127)
>         at org.apache.camel.bam.processor.BamProcessorSupport.process(BamProcessorSupport.java:91)
>         at org.apache.camel.impl.converter.AsyncProcessorTypeConverter$ProcessorToAsynProcessorBridge.process(AsyncProcessorTypeConverter.java:44)
>         at org.apache.camel.component.file.FileConsumer.pollFile(FileConsumer.java:131)
>         at org.apache.camel.component.file.FileConsumer.pollFileOrDirectory(FileConsumer.java:68)
>         at org.apache.camel.component.file.FileConsumer.pollFileOrDirectory(FileConsumer.java:76)
>         at org.apache.camel.component.file.FileConsumer.poll(FileConsumer.java:49)
>         at org.apache.camel.impl.ScheduledPollConsumer.run(ScheduledPollConsumer.java:63)
>         at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:417)
>         at java.util.concurrent.FutureTask$Sync.innerRunAndReset(FutureTask.java:280)
>         at java.util.concurrent.FutureTask.runAndReset(FutureTask.java:135)
>         at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.access$101(ScheduledThreadPoolExecutor.java:65)
>         at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.runPeriodic(ScheduledThreadPoolExecutor.java:142)
>         at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(ScheduledThreadPoolExecutor.java:166)
>         at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:650)
>         at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:675)
>         at java.lang.Thread.run(Thread.java:595)
> Caused by: java.sql.BatchUpdateException: failed batch
>         at org.hsqldb.jdbc.jdbcStatement.executeBatch(Unknown Source)
>         at org.hsqldb.jdbc.jdbcPreparedStatement.executeBatch(Unknown Source)
>         at org.hibernate.jdbc.BatchingBatcher.doExecuteBatch(BatchingBatcher.java:48)
>         at org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:242)
>         ... 28 more
> [nent.file.FileComponent@db248c] BamProcessorSupport            INFO  Attempt to insert duplicate row due to concurrency issue, so retrying: org.springframework.orm.jpa.JpaSystemException: org.hibernate.exception.GenericJDBCException: Could not execute JDBC batch update; nested exception is javax.persistence.PersistenceException: org.hibernate.exception.GenericJDBCException: Could not execute JDBC batch update
> [nent.file.FileComponent@db248c] BamProcessorSupport            INFO  Retry attempt due to duplicate row: 1
> [         ActivityMonitorEngine] BamFailures                    ERROR Exchange[Message: ActivityState[2 on ProcessInstance[p3] Activity[2 name: file:src/data/invoices?noop=true]]]
> [         ActivityMonitorEngine] BamFailures                    ERROR Exchange[Message: ActivityState[7 on ProcessInstance[p2] Activity[2 name: file:src/data/invoices?noop=true]]]

--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.

Reply | Threaded
Open this post in threaded view
|

[jira] Resolved: (CAMEL-173) BAM example failure

JIRA jira@apache.org
In reply to this post by JIRA jira@apache.org

     [ https://issues.apache.org/activemq/browse/CAMEL-173?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Claus Ibsen resolved CAMEL-173.
-------------------------------

    Resolution: Fixed

CAMEL-173
- fixed concurrency issue with creating a new entity. Now using a ReentrantLock from Java.
- no more exceptions in the camel-bam-example demo app as well.
- added some assertions to the unit test

> BAM example failure
> -------------------
>
>                 Key: CAMEL-173
>                 URL: https://issues.apache.org/activemq/browse/CAMEL-173
>             Project: Apache Camel
>          Issue Type: Bug
>          Components: examples
>    Affects Versions: 1.2.0
>         Environment: testing the camel-1.2.0 RC2 on SUSE Linux
>            Reporter: Bozhong Lin
>            Assignee: Claus Ibsen
>            Priority: Minor
>             Fix For: 1.4.0
>
>
> the example throws following error:
> [pache.camel.spring.Main.main()] Main                           INFO  Apache Camel 1.2.0 starting
> [pache.camel.spring.Main.main()] Main                           INFO  Generating DOT file for routes: /opt/dev/apache-camel-1.2.0/examples/camel-example-bam/target/site/cameldoc for: org.apache.camel.spring.SpringCamelContext@352d87
> [nent.file.FileComponent@db248c] JDBCExceptionReporter          WARN  SQL Error: 0, SQLState: null
> [nent.file.FileComponent@db248c] JDBCExceptionReporter          ERROR failed batch
> Failed to load preferences.  Proceeding with defaults:
> [nent.file.FileComponent@db248c] AbstractFlushingEventListener  ERROR Could not synchronize database state with session
> org.hibernate.exception.GenericJDBCException: Could not execute JDBC batch update
>         at org.hibernate.exception.SQLStateConverter.handledNonSpecificException(SQLStateConverter.java:103)
>         at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:91)
>         at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)
>         at org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:249)
>         at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:235)
>         at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:139)
>         at org.hibernate.event.def.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:298)
>         at org.hibernate.event.def.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:27)
>         at org.hibernate.impl.SessionImpl.flush(SessionImpl.java:1000)
>         at org.hibernate.ejb.AbstractEntityManagerImpl.flush(AbstractEntityManagerImpl.java:296)
>         at org.springframework.orm.jpa.JpaTemplate$8.doInJpa(JpaTemplate.java:289)
>         at org.springframework.orm.jpa.JpaTemplate.execute(JpaTemplate.java:191)
>         at org.springframework.orm.jpa.JpaTemplate.flush(JpaTemplate.java:287)
>         at org.apache.camel.bam.processor.JpaBamProcessorSupport.loadEntity(JpaBamProcessorSupport.java:118)
>         at org.apache.camel.bam.processor.BamProcessorSupport$1.doInTransaction(BamProcessorSupport.java:96)
>         at org.springframework.transaction.support.TransactionTemplate.execute(TransactionTemplate.java:127)
>         at org.apache.camel.bam.processor.BamProcessorSupport.process(BamProcessorSupport.java:91)
>         at org.apache.camel.impl.converter.AsyncProcessorTypeConverter$ProcessorToAsynProcessorBridge.process(AsyncProcessorTypeConverter.java:44)
>         at org.apache.camel.component.file.FileConsumer.pollFile(FileConsumer.java:131)
>         at org.apache.camel.component.file.FileConsumer.pollFileOrDirectory(FileConsumer.java:68)
>         at org.apache.camel.component.file.FileConsumer.pollFileOrDirectory(FileConsumer.java:76)
>         at org.apache.camel.component.file.FileConsumer.poll(FileConsumer.java:49)
>         at org.apache.camel.impl.ScheduledPollConsumer.run(ScheduledPollConsumer.java:63)
>         at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:417)
>         at java.util.concurrent.FutureTask$Sync.innerRunAndReset(FutureTask.java:280)
>         at java.util.concurrent.FutureTask.runAndReset(FutureTask.java:135)
>         at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.access$101(ScheduledThreadPoolExecutor.java:65)
>         at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.runPeriodic(ScheduledThreadPoolExecutor.java:142)
>         at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(ScheduledThreadPoolExecutor.java:166)
>         at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:650)
>         at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:675)
>         at java.lang.Thread.run(Thread.java:595)
> Caused by: java.sql.BatchUpdateException: failed batch
>         at org.hsqldb.jdbc.jdbcStatement.executeBatch(Unknown Source)
>         at org.hsqldb.jdbc.jdbcPreparedStatement.executeBatch(Unknown Source)
>         at org.hibernate.jdbc.BatchingBatcher.doExecuteBatch(BatchingBatcher.java:48)
>         at org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:242)
>         ... 28 more
> [nent.file.FileComponent@db248c] BamProcessorSupport            INFO  Attempt to insert duplicate row due to concurrency issue, so retrying: org.springframework.orm.jpa.JpaSystemException: org.hibernate.exception.GenericJDBCException: Could not execute JDBC batch update; nested exception is javax.persistence.PersistenceException: org.hibernate.exception.GenericJDBCException: Could not execute JDBC batch update
> [nent.file.FileComponent@db248c] BamProcessorSupport            INFO  Retry attempt due to duplicate row: 1
> [         ActivityMonitorEngine] BamFailures                    ERROR Exchange[Message: ActivityState[2 on ProcessInstance[p3] Activity[2 name: file:src/data/invoices?noop=true]]]
> [         ActivityMonitorEngine] BamFailures                    ERROR Exchange[Message: ActivityState[7 on ProcessInstance[p2] Activity[2 name: file:src/data/invoices?noop=true]]]

--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.

Reply | Threaded
Open this post in threaded view
|

[jira] Commented: (CAMEL-173) BAM example failure

JIRA jira@apache.org
In reply to this post by JIRA jira@apache.org

    [ https://issues.apache.org/activemq/browse/CAMEL-173?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=41878#action_41878 ]

James Strachan commented on CAMEL-173:
--------------------------------------

Awesome stuff! :)

I guess the problem could still happen if folks were running multiple JVMs against the same database; though in that case a real database would be used that properly implements locks etc :)

> BAM example failure
> -------------------
>
>                 Key: CAMEL-173
>                 URL: https://issues.apache.org/activemq/browse/CAMEL-173
>             Project: Apache Camel
>          Issue Type: Bug
>          Components: examples
>    Affects Versions: 1.2.0
>         Environment: testing the camel-1.2.0 RC2 on SUSE Linux
>            Reporter: Bozhong Lin
>            Assignee: Claus Ibsen
>            Priority: Minor
>             Fix For: 1.4.0
>
>
> the example throws following error:
> [pache.camel.spring.Main.main()] Main                           INFO  Apache Camel 1.2.0 starting
> [pache.camel.spring.Main.main()] Main                           INFO  Generating DOT file for routes: /opt/dev/apache-camel-1.2.0/examples/camel-example-bam/target/site/cameldoc for: org.apache.camel.spring.SpringCamelContext@352d87
> [nent.file.FileComponent@db248c] JDBCExceptionReporter          WARN  SQL Error: 0, SQLState: null
> [nent.file.FileComponent@db248c] JDBCExceptionReporter          ERROR failed batch
> Failed to load preferences.  Proceeding with defaults:
> [nent.file.FileComponent@db248c] AbstractFlushingEventListener  ERROR Could not synchronize database state with session
> org.hibernate.exception.GenericJDBCException: Could not execute JDBC batch update
>         at org.hibernate.exception.SQLStateConverter.handledNonSpecificException(SQLStateConverter.java:103)
>         at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:91)
>         at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)
>         at org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:249)
>         at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:235)
>         at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:139)
>         at org.hibernate.event.def.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:298)
>         at org.hibernate.event.def.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:27)
>         at org.hibernate.impl.SessionImpl.flush(SessionImpl.java:1000)
>         at org.hibernate.ejb.AbstractEntityManagerImpl.flush(AbstractEntityManagerImpl.java:296)
>         at org.springframework.orm.jpa.JpaTemplate$8.doInJpa(JpaTemplate.java:289)
>         at org.springframework.orm.jpa.JpaTemplate.execute(JpaTemplate.java:191)
>         at org.springframework.orm.jpa.JpaTemplate.flush(JpaTemplate.java:287)
>         at org.apache.camel.bam.processor.JpaBamProcessorSupport.loadEntity(JpaBamProcessorSupport.java:118)
>         at org.apache.camel.bam.processor.BamProcessorSupport$1.doInTransaction(BamProcessorSupport.java:96)
>         at org.springframework.transaction.support.TransactionTemplate.execute(TransactionTemplate.java:127)
>         at org.apache.camel.bam.processor.BamProcessorSupport.process(BamProcessorSupport.java:91)
>         at org.apache.camel.impl.converter.AsyncProcessorTypeConverter$ProcessorToAsynProcessorBridge.process(AsyncProcessorTypeConverter.java:44)
>         at org.apache.camel.component.file.FileConsumer.pollFile(FileConsumer.java:131)
>         at org.apache.camel.component.file.FileConsumer.pollFileOrDirectory(FileConsumer.java:68)
>         at org.apache.camel.component.file.FileConsumer.pollFileOrDirectory(FileConsumer.java:76)
>         at org.apache.camel.component.file.FileConsumer.poll(FileConsumer.java:49)
>         at org.apache.camel.impl.ScheduledPollConsumer.run(ScheduledPollConsumer.java:63)
>         at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:417)
>         at java.util.concurrent.FutureTask$Sync.innerRunAndReset(FutureTask.java:280)
>         at java.util.concurrent.FutureTask.runAndReset(FutureTask.java:135)
>         at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.access$101(ScheduledThreadPoolExecutor.java:65)
>         at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.runPeriodic(ScheduledThreadPoolExecutor.java:142)
>         at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(ScheduledThreadPoolExecutor.java:166)
>         at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:650)
>         at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:675)
>         at java.lang.Thread.run(Thread.java:595)
> Caused by: java.sql.BatchUpdateException: failed batch
>         at org.hsqldb.jdbc.jdbcStatement.executeBatch(Unknown Source)
>         at org.hsqldb.jdbc.jdbcPreparedStatement.executeBatch(Unknown Source)
>         at org.hibernate.jdbc.BatchingBatcher.doExecuteBatch(BatchingBatcher.java:48)
>         at org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:242)
>         ... 28 more
> [nent.file.FileComponent@db248c] BamProcessorSupport            INFO  Attempt to insert duplicate row due to concurrency issue, so retrying: org.springframework.orm.jpa.JpaSystemException: org.hibernate.exception.GenericJDBCException: Could not execute JDBC batch update; nested exception is javax.persistence.PersistenceException: org.hibernate.exception.GenericJDBCException: Could not execute JDBC batch update
> [nent.file.FileComponent@db248c] BamProcessorSupport            INFO  Retry attempt due to duplicate row: 1
> [         ActivityMonitorEngine] BamFailures                    ERROR Exchange[Message: ActivityState[2 on ProcessInstance[p3] Activity[2 name: file:src/data/invoices?noop=true]]]
> [         ActivityMonitorEngine] BamFailures                    ERROR Exchange[Message: ActivityState[7 on ProcessInstance[p2] Activity[2 name: file:src/data/invoices?noop=true]]]

--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.

Reply | Threaded
Open this post in threaded view
|

[jira] Updated: (CAMEL-173) BAM example failure

JIRA jira@apache.org
In reply to this post by JIRA jira@apache.org

     [ https://issues.apache.org/activemq/browse/CAMEL-173?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Hadrian Zbarcea updated CAMEL-173:
----------------------------------

    Fix Version/s: 1.3.0
                       (was: 1.4.0)

> BAM example failure
> -------------------
>
>                 Key: CAMEL-173
>                 URL: https://issues.apache.org/activemq/browse/CAMEL-173
>             Project: Apache Camel
>          Issue Type: Bug
>          Components: examples
>    Affects Versions: 1.2.0
>         Environment: testing the camel-1.2.0 RC2 on SUSE Linux
>            Reporter: Bozhong Lin
>            Assignee: Claus Ibsen
>            Priority: Minor
>             Fix For: 1.3.0
>
>
> the example throws following error:
> [pache.camel.spring.Main.main()] Main                           INFO  Apache Camel 1.2.0 starting
> [pache.camel.spring.Main.main()] Main                           INFO  Generating DOT file for routes: /opt/dev/apache-camel-1.2.0/examples/camel-example-bam/target/site/cameldoc for: org.apache.camel.spring.SpringCamelContext@352d87
> [nent.file.FileComponent@db248c] JDBCExceptionReporter          WARN  SQL Error: 0, SQLState: null
> [nent.file.FileComponent@db248c] JDBCExceptionReporter          ERROR failed batch
> Failed to load preferences.  Proceeding with defaults:
> [nent.file.FileComponent@db248c] AbstractFlushingEventListener  ERROR Could not synchronize database state with session
> org.hibernate.exception.GenericJDBCException: Could not execute JDBC batch update
>         at org.hibernate.exception.SQLStateConverter.handledNonSpecificException(SQLStateConverter.java:103)
>         at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:91)
>         at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)
>         at org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:249)
>         at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:235)
>         at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:139)
>         at org.hibernate.event.def.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:298)
>         at org.hibernate.event.def.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:27)
>         at org.hibernate.impl.SessionImpl.flush(SessionImpl.java:1000)
>         at org.hibernate.ejb.AbstractEntityManagerImpl.flush(AbstractEntityManagerImpl.java:296)
>         at org.springframework.orm.jpa.JpaTemplate$8.doInJpa(JpaTemplate.java:289)
>         at org.springframework.orm.jpa.JpaTemplate.execute(JpaTemplate.java:191)
>         at org.springframework.orm.jpa.JpaTemplate.flush(JpaTemplate.java:287)
>         at org.apache.camel.bam.processor.JpaBamProcessorSupport.loadEntity(JpaBamProcessorSupport.java:118)
>         at org.apache.camel.bam.processor.BamProcessorSupport$1.doInTransaction(BamProcessorSupport.java:96)
>         at org.springframework.transaction.support.TransactionTemplate.execute(TransactionTemplate.java:127)
>         at org.apache.camel.bam.processor.BamProcessorSupport.process(BamProcessorSupport.java:91)
>         at org.apache.camel.impl.converter.AsyncProcessorTypeConverter$ProcessorToAsynProcessorBridge.process(AsyncProcessorTypeConverter.java:44)
>         at org.apache.camel.component.file.FileConsumer.pollFile(FileConsumer.java:131)
>         at org.apache.camel.component.file.FileConsumer.pollFileOrDirectory(FileConsumer.java:68)
>         at org.apache.camel.component.file.FileConsumer.pollFileOrDirectory(FileConsumer.java:76)
>         at org.apache.camel.component.file.FileConsumer.poll(FileConsumer.java:49)
>         at org.apache.camel.impl.ScheduledPollConsumer.run(ScheduledPollConsumer.java:63)
>         at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:417)
>         at java.util.concurrent.FutureTask$Sync.innerRunAndReset(FutureTask.java:280)
>         at java.util.concurrent.FutureTask.runAndReset(FutureTask.java:135)
>         at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.access$101(ScheduledThreadPoolExecutor.java:65)
>         at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.runPeriodic(ScheduledThreadPoolExecutor.java:142)
>         at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(ScheduledThreadPoolExecutor.java:166)
>         at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:650)
>         at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:675)
>         at java.lang.Thread.run(Thread.java:595)
> Caused by: java.sql.BatchUpdateException: failed batch
>         at org.hsqldb.jdbc.jdbcStatement.executeBatch(Unknown Source)
>         at org.hsqldb.jdbc.jdbcPreparedStatement.executeBatch(Unknown Source)
>         at org.hibernate.jdbc.BatchingBatcher.doExecuteBatch(BatchingBatcher.java:48)
>         at org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:242)
>         ... 28 more
> [nent.file.FileComponent@db248c] BamProcessorSupport            INFO  Attempt to insert duplicate row due to concurrency issue, so retrying: org.springframework.orm.jpa.JpaSystemException: org.hibernate.exception.GenericJDBCException: Could not execute JDBC batch update; nested exception is javax.persistence.PersistenceException: org.hibernate.exception.GenericJDBCException: Could not execute JDBC batch update
> [nent.file.FileComponent@db248c] BamProcessorSupport            INFO  Retry attempt due to duplicate row: 1
> [         ActivityMonitorEngine] BamFailures                    ERROR Exchange[Message: ActivityState[2 on ProcessInstance[p3] Activity[2 name: file:src/data/invoices?noop=true]]]
> [         ActivityMonitorEngine] BamFailures                    ERROR Exchange[Message: ActivityState[7 on ProcessInstance[p2] Activity[2 name: file:src/data/invoices?noop=true]]]

--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.