View Issue Details

IDProjectCategoryView StatusLast Update
0006600SymmetricDSBugpublic2024-10-28 13:23
Reporterelong Assigned Toelong  
Prioritynormal 
Status closedResolutionfixed 
Product Version3.15.0 
Target Version3.15.9Fixed in Version3.15.9 
Summary0006600: DDL replication of create table with insert in same transaction
DescriptionWhen DDL replication creates a table in the same batch with insert, update, and deletes, the transaction can block itself trying to lookup table metadata.
Steps To ReproduceOn SQL-Server with DDL replication enabled.
In same transaction, create a table and insert into it, then commit.
Target will run the create table, but get stuck trying to lookup metadata with a new connection.
Tagsddl/schema

Relationships

related to 0006152 closedelong DDL replication errors on SQL-Server with renaming columns and deadlocks 
related to 0006627 resolvedelong DDL replication stuck from reader on another connection 

Activities

There are no notes attached to this issue.

Related Changesets

SymmetricDS: 3.15 5d3c2bff

2024-09-30 16:36:52

admin

Details Diff
0006600: DDL replication of create table with insert in same transaction Affected Issues
0006600
mod - symmetric-io/src/main/java/org/jumpmind/symmetric/io/data/writer/DefaultDatabaseWriter.java Diff File

SymmetricDS: 3.16 b26285f8

2024-09-30 16:36:52

admin

Details Diff
0006600: DDL replication of create table with insert in same transaction Affected Issues
0006600
mod - symmetric-io/src/main/java/org/jumpmind/symmetric/io/data/writer/DefaultDatabaseWriter.java Diff File

Issue History

Date Modified Username Field Change
2024-09-30 16:30 elong New Issue
2024-09-30 16:30 elong Status new => assigned
2024-09-30 16:30 elong Assigned To => elong
2024-09-30 16:30 elong Tag Attached: ddl/schema
2024-09-30 16:30 elong Relationship added related to 0006152
2024-09-30 16:31 elong Project SymmetricDS Pro => SymmetricDS
2024-09-30 16:38 elong Status assigned => resolved
2024-09-30 16:38 elong Resolution open => fixed
2024-09-30 16:38 elong Fixed in Version => 3.15.9
2024-09-30 17:00 admin Changeset attached => SymmetricDS 3.15 5d3c2bff
2024-09-30 17:00 admin Changeset attached => SymmetricDS 3.16 b26285f8
2024-10-01 19:48 admin Status resolved => closed
2024-10-28 13:23 elong Relationship added related to 0006627