View Issue Details

Related ChangesetsJump to NotesJump to History
IDProjectCategoryView StatusDate SubmittedLast Update
0005423SymmetricDSBugpublic2022-08-25 12:322022-08-30 13:03
Reporterelong Assigned Toelong  
Prioritynormal 
Status closedResolutionfixed 
Product Version3.13.0 
Target Version3.13.7Fixed in Version3.13.7 
Summary0005423: JDBC Bulk Transactions Fallback While Using PostgreSQL
DescriptionJDBC Bulk Transactions will fallback to default for PostgreSQL databases, with this exception:

StackTraceKey.init [IllegalStateException:3160589133] java.lang.IllegalStateException: Cannot prepare a new batch before the last batch has been flushed.
     at org.jumpmind.db.sql.JdbcSqlTransaction.prepare(JdbcSqlTransaction.java:410)
     at org.jumpmind.symmetric.io.data.writer.DefaultDatabaseWriter.findAndThrowInsertException(DefaultDatabaseWriter.java:290)
     at org.jumpmind.symmetric.io.data.writer.DefaultDatabaseWriter.insert(DefaultDatabaseWriter.java:253)
     at org.jumpmind.symmetric.io.JdbcBatchBulkDatabaseWriter.insert(JdbcBatchBulkDatabaseWriter.java:71)
     at org.jumpmind.symmetric.io.data.writer.AbstractDatabaseWriter.write(AbstractDatabaseWriter.java:186)
     at org.jumpmind.symmetric.io.AbstractBulkDatabaseWriter.writeDefault(AbstractBulkDatabaseWriter.java:99)
     at org.jumpmind.symmetric.io.JdbcBatchBulkDatabaseWriter.bulkWrite(JdbcBatchBulkDatabaseWriter.java:55)
     at org.jumpmind.symmetric.io.AbstractBulkDatabaseWriter.write(AbstractBulkDatabaseWriter.java:82)
     at org.jumpmind.symmetric.io.data.writer.NestedDataWriter.write(NestedDataWriter.java:62)
     at org.jumpmind.symmetric.model.ProcessInfoDataWriter.write(ProcessInfoDataWriter.java:84)
     at org.jumpmind.symmetric.io.data.writer.NestedDataWriter.write(NestedDataWriter.java:62)
     at org.jumpmind.symmetric.io.data.writer.TransformWriter.write(TransformWriter.java:186)
     at org.jumpmind.symmetric.io.data.DataProcessor.forEachDataInTable(DataProcessor.java:194)
     at org.jumpmind.symmetric.io.data.DataProcessor.forEachTableInBatch(DataProcessor.java:160)
     at org.jumpmind.symmetric.io.data.DataProcessor.process(DataProcessor.java:108)
     at org.jumpmind.symmetric.service.impl.DataLoaderService$LoadIntoDatabaseOnArrivalListener$2.call(DataLoaderService.java:1043)
     at org.jumpmind.symmetric.service.impl.DataLoaderService$LoadIntoDatabaseOnArrivalListener$2.call(DataLoaderService.java:1)
     at java.util.concurrent.FutureTask.run(FutureTask.java:266)
     at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
     at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
     at java.lang.Thread.run(Thread.java:750)
Tagsbulk

Activities

There are no notes attached to this issue.

Related Changesets

SymmetricDS: 3.13 696b057a

2022-08-25 12:33:15

admin

Details Diff 		0005423: JDBC Bulk Transactions Fallback While Using PostgreSQL Affected Issues
0005423
mod - symmetric-io/src/main/java/org/jumpmind/symmetric/io/data/writer/DefaultDatabaseWriter.java Diff File

Issue History

Date Modified Username Field Change
2022-08-25 12:32 elong New Issue
2022-08-25 12:32 elong Status new => assigned
2022-08-25 12:32 elong Assigned To => elong
2022-08-25 12:32 elong Tag Attached: bulk
2022-08-25 12:32 elong Issue generated from: 0005414
2022-08-25 12:33 elong Status assigned => resolved
2022-08-25 12:33 elong Resolution open => fixed
2022-08-25 12:33 elong Fixed in Version => 3.13.7
2022-08-25 13:00 admin Changeset attached => SymmetricDS 3.13 696b057a
2022-08-30 13:03 admin Status resolved => closed