View Issue Details

IDProjectCategoryView StatusLast Update
0005778SymmetricDSImprovementpublic2023-10-03 23:00
Reportercquamme Assigned Tocquamme  
Prioritynormal 
Status closedResolutionfixed 
Target Version3.15.0Fixed in Version3.15.0 
Summary0005778: Change timestamp size on sym tables with a timestamp as a primary key
DescriptionTo avoid errors during table syncs between databases with different precisions, we will change the timestamp size on sym tables with a timestamp as a primary key to be a size of 2. Some databases (Oracle, SQL Server) will have an error during upgrade with this change, so we will make sure the appropriate actions are taken during the upgrade process to avoid this causing an error.

Affected sym tables:
table_reload_request
node_group_channel_wnd
node_host_channel_stats
node_host_job_stats
node_host_stats
registration_request
TagsNo tags attached.

Relationships

related to 0002826 closedcquamme Monitor event duplicate key when syncing 
related to 0003505 closedelong SYM_TABLE_RELOAD_REQUEST is updated via DateTime which sometimes fails due to precision mismatch 

Activities

There are no notes attached to this issue.

Related Changesets

SymmetricDS: 3.15 23502ebd

2023-04-13 16:47:02

cquamme

Details Diff
0005778: Change create_time size on sym_table_reload_request table Affected Issues
0005778
mod - symmetric-core/src/main/java/org/jumpmind/symmetric/db/DatabaseUpgradeListener.java Diff File
mod - symmetric-core/src/main/resources/symmetric-schema.xml Diff File

SymmetricDS: 3.15 bbfc990d

2023-05-16 17:40:07

cquamme

Details Diff
0005778: Change timestamp size on sym tables with a timestamp as a
primary key
Affected Issues
0005778
mod - symmetric-core/src/main/java/org/jumpmind/symmetric/db/DatabaseUpgradeListener.java Diff File
mod - symmetric-core/src/main/resources/symmetric-schema.xml Diff File

Issue History

Date Modified Username Field Change
2023-04-06 16:59 cquamme New Issue
2023-04-06 16:59 cquamme Status new => assigned
2023-04-06 16:59 cquamme Assigned To => cquamme
2023-04-13 16:47 cquamme Status assigned => resolved
2023-05-10 18:18 cquamme Status resolved => assigned
2023-05-10 18:18 cquamme Resolution fixed => open
2023-05-10 18:18 cquamme Fixed in Version 3.15.0 =>
2023-05-15 12:01 cquamme Target Version => 3.15.0
2023-05-15 18:49 cquamme Summary Change create_time size on sym_table_reload_request table => Change timestamp size on sym tables with a timestamp as a primary key
2023-05-15 18:49 cquamme Description Updated View Revisions
2023-05-16 12:58 elong Relationship added related to 0002826
2023-05-16 17:40 cquamme Status assigned => resolved
2023-05-16 17:40 cquamme Resolution open => fixed
2023-05-17 15:29 elong Relationship added related to 0003505
2023-10-01 23:46 admin Status resolved => closed
2023-10-03 23:00 cquamme Changeset attached => SymmetricDS 3.15 bbfc990d
2023-10-03 23:00 cquamme Changeset attached => SymmetricDS 3.15 23502ebd