View Issue Details

IDProjectCategoryView StatusLast Update
0006152SymmetricDSBugpublic2024-09-30 16:30
Reporterelong Assigned Toelong  
Prioritynormal 
Status closedResolutionfixed 
Product Version3.15.0 
Target Version3.15.2Fixed in Version3.15.2 
Summary0006152: DDL replication errors on SQL-Server with renaming columns and deadlocks
DescriptionDDL replication can get errors:
- table or column rename is missing from capture
- deadlocks between data loader and sync triggers job
- deadlocks between data loader and platform metadata lookups
Tagsddl/schema, dialect: sql-server

Relationships

related to 0006600 closedelong DDL replication of create table with insert in same transaction 

Activities

There are no notes attached to this issue.

Related Changesets

SymmetricDS: 3.15 ca31b03d

2023-12-11 20:49:03

admin

Details Diff
0006152: DDL replication errors on SQL-Server with renaming columns and
deadlocks
Affected Issues
0006152
mod - symmetric-client/src/main/java/org/jumpmind/symmetric/db/mssql/MsSqlTriggerTemplate.java Diff File
mod - symmetric-core/src/main/java/org/jumpmind/symmetric/service/impl/TriggerRouterService.java Diff File
mod - symmetric-db/src/main/java/org/jumpmind/db/platform/AbstractDatabasePlatform.java Diff File
mod - symmetric-db/src/main/java/org/jumpmind/db/platform/IDatabasePlatform.java Diff File
mod - symmetric-db/src/main/java/org/jumpmind/db/platform/IDdlReader.java Diff File
mod - symmetric-db/src/main/java/org/jumpmind/db/platform/cassandra/CassandraDdlReader.java Diff File
mod - symmetric-db/src/main/java/org/jumpmind/db/platform/kafka/KafkaDdlReader.java Diff File
mod - symmetric-db/src/main/java/org/jumpmind/db/platform/sqlite/SqliteDdlReader.java Diff File
mod - symmetric-io/src/main/java/org/jumpmind/symmetric/io/data/writer/DefaultDatabaseWriter.java Diff File
mod - symmetric-jdbc/src/main/java/org/jumpmind/db/platform/AbstractJdbcDdlReader.java Diff File

Issue History

Date Modified Username Field Change
2023-12-11 20:43 elong New Issue
2023-12-11 20:43 elong Status new => assigned
2023-12-11 20:43 elong Assigned To => elong
2023-12-11 20:43 elong Tag Attached: ddl/schema
2023-12-11 20:43 elong Tag Attached: dialect: sql-server
2023-12-11 20:49 elong Status assigned => resolved
2023-12-11 20:49 elong Resolution open => fixed
2023-12-11 20:49 elong Fixed in Version => 3.15.2
2023-12-11 21:00 admin Changeset attached => SymmetricDS 3.15 ca31b03d
2023-12-16 02:02 admin Status resolved => closed
2024-09-30 16:30 elong Relationship added related to 0006600