A newer version of this documentation is available.
View Latest (v2.0)

Gluesync - SQL to NoSQL release notes and changelog

DEPRECATION NOTICE: Gluesync 1.5 is reaching its end of life. New features will no longer be supported a part from security updates and Data modeling features. MOLO17 will continue to support Gluesync 1.5 for security updates only until end of 2025, and users relying on Data modeling features up to that date. If you’re not using Data modeling features, please upgrade to Gluesync 2.0 to continue receiving product support, features and security updates. We will no longer support Gluesync 1.5 non-data modeling users after June 2025. Support for Gluesync 1.5 will end of 2025.
Users not relying on data modeling features will not be supported after June 2025, consider upgrading to Gluesync 2.0 as soon as possible.

1.5

1.5.51

2024-11-29

  • For Couchbase target connector: Fixed a bug when comparing equality between different number types;

  • For MS SQL Server CDC connector: CDC (delta changes) emission in certain cases could have been unable to initiate. This has been fixed;

1.5.50

2024-11-12

  • Fixed a bug that caused, in some cases, the use of an old transaction ID when the synchronization restarted after an error, leading to the rereading of already synchronized data.

  • Added an index to speed up reading from the action log table.

  • Lowered isolation level for queries that read the last transaction ID in the action log table.

  • Reset isolation level to the previous value after certain operations.

  • Added a query condition to filter changes more precisely.

  • For MS SQL Server CDC connector: Gluesync does not try anymore to enable CDC at database level; this lowers the previously required sysadmin role permissions transitioning the requirement to just db_owner role;

1.5.48

2024-09-19

  • GSSD-129: Oracle Xstream connector. If a table falls behind with no data changes for days (only applies on low-to-none data rotation on tables) there’s a potential risk of halting the Oracle archival process due to Xstream low watermark set to far away compared to actual SCN value being processed for lively updating tables. By applying xstreamLowWatermarkRetentionHours low watermark is set to an higher value corresponding to actual last known processed SCN (safe). Default xstreamLowWatermarkRetentionHours value is 24 hours.

Consider before upgrading: this introduce a breaking change to state preservation table, adding a new timestamp column. Please find below the alter table statement to be run before upgrading. Consider contacing the support for any question around that. This only applies to Oracle Xstream source connector users.

Alter table statement:

ALTER TABLE YOURUSERSCHEMA.GLUESYNC_STATE_PRESERVATION
ADD UPDATE_DATE DATE DEFAULT SYSDATE;
Substitute YOURUSERSCHEMA with the actual schema given to Gluesync for connecting over your Oracle Xstream instance.

1.5.47

2024-09-18

  • GSSD-126: Oracle Xstream connector. Fixed an issue where, under a delete operation and multiple custom user-defined keys a target document key fails to be built.

1.5.46

2024-09-12

  • Added additional logging around Xstream source connector.

1.5.45

2024-09-11

  • Oracle trigger-based auditing has now ACTION_LOGS partitions set to hourly values instead of DAILY values only for source change retention.

1.5.38

2024-05-07

  • Added support for AWSS3-like storages;

  • Added separate storage for Oracle Xstream for compatibility with DataGuard Logical standby;

  • GSSD-93: This release changes the Java heap memory behavior with a new max RAM limit set to 75%. For more information please refer to this useful link.

  • Fixed MySQL source connector case sensitivity;

  • Fixed MS SQL Server’s first migration error;

1.5.37

2024-04-16

  • Fixed Oracle null pointer in configuration

  • Fixed Sybase setup Statements

  • Fixed CheckMigrationCheckpointTableSetup table recreation condition

  • Fixed all databases migration checkpoint update query

  • Added logs to MS SQL Server source connector check state preservation component setup

1.5.36

2024-04-15

  • Updated Gluesync shared libraries to v0.10.1

  • Added validation query to Sybase source connector;

1.5.35

2024-03-15

  • Oracle Xstream source connector now provides the same support to datatypes as per Oracle-triggers source connectors, including support for CLOBs data types;

  • Improvements on Aerospike target connector that now includes support for TLS encryption using Netty event loops;

  • Added support for MongoDB source connector with none user authentication.

1.5.34

2024-03-11

  • Improved Couchbase target connector retry strategy;

  • Added Query entity support for Oracle Triggers source;

  • Improved Oracle source DATE types support.

1.5.33

2024-02-21

  • Improved AS400 source connector;

  • Other minor improvements.

1.5.32

2024-02-13

  • Fixed an issue affecting the first migration of entities with data modeling enabled;

1.5.31

2024-02-06

  • GSSD-80: Fixed an unhandled exception on MS SQL CDC source connector when Gluesync reads a single huge transaction with a row count greater than the given page size;

  • Improved AS400 journals support on IBM i series source connector.

1.5.30

2024-01-18

  • GSSD-86: Oracle Triggers source connector has been updated to fix an issue that in certain circumstances could have led to the creation of duplicated entries under the STATE PRESERVATION TABLE.

1.5.29

2024-01-15

  • MS SQL Server Change Data Capture connector: has been updated to fix sync delete operation for data modeling entities;

  • Oracle Triggers source connector: has been updated to fix sync delete operation for data modeling entities.

1.5.28

2024-01-12

  • MS SQL Server Change Tracking has more detailed logs for state preservation table creation;

  • IBM i (AS/400) has a new streamed transaction handling to improve performances;

  • Gluesync now outputs a log config file every 5 minutes for helping to track down config file changes over time;

  • GSSD-86: Oracle Triggers fix for last read transaction ID update.

1.5.27

2024-01-05

  • Added timer-based buffer SMTP appender for Logback;

  • Fixed logging of custom exceptions.

1.5.26

2024-01-04

  • For Oracle triggers-based source connector:

    • Added 4 parameters to Oracle Triggers configuration to customize JDBC timeouts;

    • Fixed a bug on Oracle Triggers that prevented some transactions from syncing if the affected table no longer receives changes;

  • Updated Logback framework dependency;

  • 🔥 NEW PostgreSQL native CDC source connector is now available and part of that release: it implements logical replication making use of PgSQL’s replication slot API through standard JDBC driver. Read more about this new source connector by following this link.

1.5.25

2023-12-18

  • For Oracle triggers-based source connector:

    • Improved query performance on the Action Log Table by adding a specific index;

    • Fixed upper/lower case issue for keys on data modeling mapper;

    • Added support for Query and DataModeling entities.

1.5.24

2023-12-07

  • For Oracle triggers-based source connector:

    • Improved consumed transaction query for Action Log Table;

    • Added mechanism to prevent duplicated row emissions;

    • Added not consumed rows retrieved.

1.5.23

2023-12-04

  • Fixed Oracle Triggers document keys generation;

1.5.22

2023-12-01

  • For Oracle triggers-based source connector the error handling in purge mechanism has been improved.

1.5.21

2023-12-28

  • For Oracle triggers-based source connector:

    • Added new streamed transactions handling to improve performance;

    • Added enableActionLogReadCheck parameter to the configuration to enable consumed transactions checks within the action logs table;

    • Set transactionIsolation to Connection.TRANSACTION_SERIALIZABLE when sourcing changes from the action logs table.

1.5.20

2023-11-29

  • For Aerospike target connector: fixed IllegalArgumentException that occasionally was throwing fields names too long error instead of its specific exception;

  • GSSD-71: Improved MS SQL Server CDC source connector transaction handling algorithm to better handle single-row transactions.

1.5.19

2023-11-27

  • GSSD-66: Fixed issue that caused license validation to fail if there was an empty line at the end of the file;

  • GSSD-67: Improved reading of new transactions on Oracle Triggers-based source connector, now it makes use of READ COMMITTED transaction isolation for all connections.

1.5.18

2023-11-24

  • Added JVM memory stats;

  • Fixed issue on Query entities for Oracle Xstream;

  • Improve error logging for MS SQL Server CDC source connector as well as Aerospike target connector.

1.5.17

2023-11-23

This release updates the following dependencies:

  • Updated Kotlin version;

  • Updated Gradle version;

  • Updated JDBC drivers;

  • Updated minor third-party library dependencies.

1.5.16

2023-11-20

  • For MS SQL Server CDC connector has been added support for recursion protection. Disabled by default to ensure maximum performance. Can be activated via configuration file if necessary;

  • Fixed an issue with Logback appenders after the upgrade causing logs to freeze;

  • Fixed an issue with the buffer pressure calculation (part of the monitoring feature) which in some cases could have led to experiencing values outside boundaries failing to reset;

  • In case of a retryable error the entity name has been added to the error log;

  • We carried out a major refactor on the SQL parser engine to make it more rugged when it comes to parsing syntax differences between databases especially in scenarios where characters like " " & ` ' ' ` are used to define schema names & table names;

  • Added support for using single quotes, double quotes or backticks on queries for some databases. Added bracket support for SQL Server (supported on Gluesync SQL to NoSQL only ATM).

  • Added connection check to connection pool to validate the returned connection

1.5.15

2023-11-02

  • MS SQL Server CDC connector enhancements:

    • A built-in set of SQL queries to fetch for CDC events has been put into place, rather than using Microsoft’s provided functions;

    • Gluesync at first initialization (meaning empty STATE_PRESERVATION entry) recovers from the last known LNS provided by SQL Agent.

1.5.14

2023-10-31

  • Fixed an issue when composing document IDs in case of user-defined primary keys (through entitiesKeyMapping feature) and empty prefix could result in having an unwanted _ (underscore) value as the first character;

  • Improved MS SQL Server CDC connector stability and performance.

1.5.13

2023-10-30

  • 🔥 NEW Native support for ARM64 CPUs;

    • Java SDK has been updated to Azul Zulu OpenJDK 11.0.21.

  • Fixed an issue where MSSQL CDC might have not consumed deletion events properly;

  • Fixed a bug on AS400 where applied column aliases weren’t ported to target when a deletion operation was performed;

1.5.12

2023-10-24

  • Fixed an issue that could prevent labels belonging to Prometheus metrics from being parsed properly;

1.5.11

2023-10-19

  • 🔥 NEW Microsoft SQL Server transaction-logs based source connector (previously only available as Change Tracking) that extends support for MS SQL Server versions starting from 2008;

    • This new source connector also comes with support for tables without primary keys;

  • Improvements on multi-threading support on Oracle Xstream source connector;

  • Oracle triggers-based source connector now creates a local index instead of a global index when usePartition is set to true inside GLUESYNC_ACTION_LOG table;

  • Improvements in license verification;

1.5.10

2023-10-09

  • Updated Aerospike Java SDK, now running on version 7.10;

  • Fixed a bug affecting Oracle Xstream source connector when OCI-39257: Message 39257 not found raises, now it is being properly handled without halting the replication process;

  • Fixed a bug affecting Oracle Xstream source connector when an incoming LCR presents a LOB TRIM action that in certain circumstances could lead the replication engine to silently stop for encountered error;

  • Full table migration now supports a new way for fetching pages of data from the source database, giving a 10x in terms of performance improvements compared to the legacy version. The legacy version will still be supported and available using the flag usePaginatedMigration set to true, the new version is now the default standard;

  • Added support for LOB fields under Oracle Xstream source connector.

1.5.6

2023-09-22

  • GSSD-34: Multiple IP Address Configuration on Aerospike target connector

1.5.0

Our new milestone release, to a full set of changes introduced with that major release please check the What’s new in Gluesync 1.5 section.

  • GSSD-8 added support for HEX values in the MS SQL Server source connector

1.4

1.4.25

2023-06-26

  • Fixed an issue with dependency injection affecting Sybase images;

  • 🔥 Added support for CDC over IBM AS/400 - i series databases.

1.4.24

2023-06-19

  • GSSD-10: Fixed level 2 joins not being reflecting updates;

  • GSSD-7: Level 2 Date/DateTime datatypes objects being written as a data structure rather than an ISO-8601 format;

  • Other minor fixes and general improvements.

  • Comes also with an improvement around binary values handling (partial GSSD-8 since it lacks a solution for HEX values)

1.4.24

2023-06-05

  • Minor improvements

1.4.14

2023-03-21

  • Fixes on _tablenames

1.4.13

2023-03-20

  • Fixes on MSSQL server temp table creation on duplicate entities involved

1.4.12

2023-03-14

  • GSSD-5: fix on partitions not getting dropped;

  • GSSD-3: triggers not working on Oracle when a MERGE statement is involved;

1.4.11

2023-03-08

  • Password base64 obfuscation

1.4.10

2023-02-28

  • GLUESYNC_ACTION_LOG table partitioning under Oracle trigger-based source connector for Oracle databases >11.X

1.4.9

2023-01-11

  • New license management via JWT token

Past changelogs are currently being imported and will be moved here soon.