SymmetricDS / News: Recent posts

SymmetricDS 3.15.8 is released! This release includes 8 improvements and 23 bug fixes. Here are some highlights:

• Filter extension point for extract phase
• SQL-Server support for user defined types when creating tables
• Support automatic ignoring of computed columns when loading tables
• Cancel previous initial load if a new initial load is requested
• Optimized Sybase ASE trigger execution
• Fixes to SQL-Server DDL table alterations... read more

SymmetricDS 3.15.7 is released! This release includes 2 features, 8 improvements, and 17 bug fixes. Here are some highlights:

• Column match router expression for has, starts with, and ends with
• Add symadmin export-sym-objects subcommand
• Add a --use-sym-db option to the DbImport and DbSql commands
• If auto resolve missing foreign key fails, try again
• SQL Server money data type error with commas ... read more

SymmetricDS 3.15.5 is released! This release includes 5 improvements and 16 bug fixes. Here are some highlights:

• Support Sybase ASE unitypes with dbcompare
• Support autosave setting with PostgreSQL JDBC driver
• Support unsigned columns on MySQL and MariaDB
• Use read uncommitted in some jobs to prevent deadlocks
• Updated Spring libraries to fix vulnerabilities

SymmetricDS 3.15.5 changelog

SymmetricDS 3.15.4 is released! This release includes 1 new feature, 8 improvements, and 21 bug fixes. Here are some highlights:

• Support for H2 2.2, although driver for H2 2.1 is still included for compatibility
• Improved performance of file sync when handling a large number of files
• Added TOP_RELATIVE_DIR variable for routing subsets of files
• Added support for N-types like NVARCHAR when creating tables across different platforms
• Fixed changing of web context root for custom deployments
• Upgraded SQL-Server driver to fix memory leak
• Upgraded MySQL, Postgres, and Jetty libraries to fix vulnerabilities... read more

SymmetricDS 3.15.3 is released! This release includes 1 new feature, 9 improvements, and 12 bug fixes. Here are some highlights:

• Support for boolean type on Oracle 23c
• Improved performance of multi-threaded routing
• Improved handling of "had X columns but expected Y" error
• Fixed sporadic "node failed to authenticate" error
• Fixed file sync push reservation problem
• DDL replication fixes to right size LOB and integer types... read more

SymmetricDS 3.15.2 is released! This release includes 1 new feature, 4 improvements, and 10 bug fixes. Here are some highlights:

• Additional trigger template variables for use in conditions
• Parameter to disable types of conflict resolution
• Fixes for DDL replication on SQL-Server
• Fix for Postgres timestamp with timezone on initial load
• Add support for filters with bulk loading

SymmetricDS 3.15.2 changelog

SymmetricDS 3.15.1 is released! This release includes 3 new features, 12 improvements, and 13 bug fixes. Here are some highlights:

• Fixes to DDL replication
• Modified index on sym_outgoing_batch for faster queries
• Added more variables to column match router
• Enhanced symadmin with support snapshot feature
• Enabled watchdog to unregister very old offline nodes
• Better check for Oracle with contains_big_lob... read more

SymmetricDS 3.15.0 is released! This release includes 5 new features, 12 improvements, and 6 bug fixes. Here are some highlights:

• Added sym_outgoing_error table for user to resolve conflicts from outgoing side
• Create tables based on table name and column names set by routers and transforms
• Track expired data gaps and repair any data missed from long running transactions
• Support for PostgreSQL infinity value in timestamp
• Fixed timestamp size on runtime tables for better cross platform sync
• Optimizations to purge service and routing service
• File sync enhanced to use staging to help with bad network connections... read more

SymmetricDS 3.14.9 is released! This release includes 1 new feature, 6 improvements, and 6 bug fixes. Here are some highlights:

• Support for UNI types on Sybase ASE
• Fixes for SQLAnywhere dialect
• Enhanced symadmin command with configuration import/export
• New parameter for logging slow SQL queries
• Updates to user guide

SymmetricDS 3.14.9 changelog

SymmetricDS 3.14.7 is released! This release includes 4 new features, 14 improvements, and 12 bug fixes. Here are some highlights:

• Support for H2 2.x database
• Fixes for Redshift, Interbase, Sybase ASE, SQL-Server, and Kafka dialects
• File sync with file names listed in batch summary
• Improvements to DDL replication
• Fix for internal error caused by user renaming a column name on a table
• Handle case of nulls in unique index allowed on source but not on target... read more

SymmetricDS 3.14.4 is released! This release includes 1 new feature, 6 improvements, and 9 bug fixes. Here are some highlights:

• SqlAnywhere support for version 12 and higher
• Improved DDL replication for Oracle and Postgres
• Fix automatic resolution of conflict on delete with missing FK children
• Fix dbexport for formatting time data
• Fix registration redirect when using older client version
• Fix stack overflow when table with backlog of changes is removed
• Checks that sync URL is formatted correctly... read more

SymmetricDS 3.14.3 is released! This release includes 4 new features, 15 improvements, and 23 bug fixes. Here are some highlights:

• Fixes to DDL default values on table creation
• Parameter to map source and target default value functions
• More robust logic to handle missing trigger history during routing
• Kafka data writer support for filtering
• Support for Postgres inet, cidr, and macaddr data types
• Support for SQL-Server non-LOB rows exceeding the 4k/8k character result set limit
• Quicker service startup time
• Detection and mitigation of staging file corruption... read more

SymmetricDS 3.14.2 is released! This release includes 1 new feature, 17 improvements, and 25 bug fixes. Here are some highlights:

• Protection from routing a large transaction that exceeds max batch size
• Ability to disable sync trigger when using sync on incoming
• Compatibility fixes for mixed version environments
• Fixes to DDL table creation
• Fixes to dbcompare, dbfill, dbimport, and dbexport... read more

SymmetricDS 3.14.1 is released! This release includes 1 new feature, 3 improvements, and 29 bug fixes.

• Added conflict statistics to batch tables
• Fixed DDL table creation bugs for Oracle, MySQL, SQL-Server, PostgreSQL, Firebird, and H2
• Fixed bugs with initial load not starting and not clearing tables involved in transforms
• Fixed bugs with dbcompare to handle not-nullable and time zone columns... read more

SymmetricDS 3.14.0 is released! This release includes 2 new features, 19 improvements, and 9 bug fixes. Here are some highlights:

• Improved query performance of routing with a large number of gaps
• Scheduled registration of nodes
• Registration of nodes over push links
• SQL-Server/Sybase trigger improvement when PK is changing
• Improved conflicts to handle timestamps with different fractional second precision
• Improved DDL for timestamps to include fractional second precision... read more

SymmetricDS 3.13.5 is released! This release fixes 14 issues and makes 1 improvement. Here are some highlights:

• Fixes for relational to Kafka publishing
• Fixes for conflict resolution when table is missing a primary key
• Fixes to DDL table creation for initial load
• Support foreign key correction of batch error with self-referencing table
• Use unique constraint for update/deletes when table is missing a primary key... read more

SymmetricDS 3.13.2 and 3.12.14 are released! This bugfix release includes log4j 2.17 to address the recent Apache Log4J vulnerability. (SymmetricDS 3.11 and older are not vulnerable.) One additional fix was made for 3.13.2:

• Initial load stuck in loop with "there is no content to read" error

3.13.2 changelog
3.12.14 changelog

SymmetricDS 3.13.1 and 3.12.13 are now available. This bugfix release addresses the recent Apache Log4J vulnerability. (SymmetricDS 3.11 and older are not vulnerable.) Here are some issues fixed:

• Upgrade log4j to fix log4shell vulnerability
• Multiple active trigger histories result when more than one trigger assigned to a table
• During a full load do not ok existing batches for the same load id
• Data mapping is incorrect on an insert fallback to update potentially when column count on target is not the same as row data... read more

SymmetricDS 3.13.0 is now available! This minor release fixes 6 issues and makes 13 improvements, including:

• Faster startup time by checking if sync triggers or auto create tables need to run
• Cleaner shutdown that closes connections and stops jobs to properly reclaim resources
• Changing parameters no longer restarts all jobs, avoiding interruptions
• Added purge of trigger history to keep system lean and fast
• Improved purge performance of extract requests... read more

SymmetricDS 3.12.12 is now available! This patch release fixes 31 issues, including:

• Loading data when same column name on table twice in different cases
• Handle change to primary when using single-value transforms
• Fix foreign key resolution when primary key contains newlines
• Fix for conflict handling when using user-defined types on PostgreSQL
• Fix for using tables with unitext column and no primary key on Sybase
• Error with LOB and geometry types on same table in Oracle
• Fix timing issue in service wrapper for Amazon EC2
• Fix purge error on Firebird with dialect 1... read more

SymmetricDS 3.12.11 is now available! This patch release fixes 17 issues, including:

• Performance improvements for sync triggers from config changes
• Fixed ack rejected errors when using channel queues
• Fixed service installation for SUSE 15
• Support dbfill with load-only nodes
• Support for Informix with 2k page size
• Added escaping of data for publishing to Kafka

See the changelog for more details.

SymmetricDS 3.12.10 is now available. This patch release fixes 21 issues, including:

• Added NCHAR type to triggers for SQL-Server
• Fixed loading of arrays on PostgreSQL
• Fixed connection leak when group link is added
• Auto resolve of missing foreign key on load only and extract only
• Fixes to work with MySQL 8 JDBC driver
• Fixed escaping of special characters publishing to Kafka
• Fixed "token unknown" error on Firebird... read more

SymmetricDS 3.12.9 for data replication is now available.

• Improvements to conflict resolution
• Added max-text-size and max-binary-size options to dbfill utility
• Fixed blocking problem for initial load on SQL-Server
• Upgraded dependency libraries for Jetty, BC, Kotlin, and okhttp
• Fixed ClassNotFound exception for command line utilities

See change log at https://www.symmetricds.org/issues/changelog_page.php?version_id=593

SymmetricDS 3.12.8 is now available.

• Switched to session_context on SQL-Server for better compatibility
• Select date/timestamp without using functions on initial load for performance
• Fixed auto resolve to work with binary primary keys
• Fixed startup issue with Docker image
• Fixed result closed error on Firebird

See change log at https://www.symmetricds.org/issues/changelog_page.php?version_id=591

SymmetricDS 3.12.7 is now available.

• Improved WAR options for deployment
• Fixes for Postgres "transaction is aborted" during conflict
• Added lock timeout for Firebird to avoid blocking transactions
• Added batch and data counts to JMX
• Fix to sync binary fields as empty instead of null
• Fixes for more conflicts during initial load

See change log at https://www.symmetricds.org/issues/changelog_page.php?version_id=589