0003284: [Improvement] Add details to email notifications (kstojanovska)
0003283: [Improvement] Trigger creation fails on some platforms when multiple trigger threads working. (kstojanovska)
0003281: [Improvement] Add caching to FileSyncService (kstojanovska)
0003274: [New Feature] Setting to block or unblock channels during initial load error (elong)
0003186: [Improvement] Support throttling multi-homed node startup (chenson)
0003262: [Improvement] Add sym_node_channel_ctl to the snapshot (chenson)
0003261: [Improvement] During the reading of data to route, log every minute the progress to the log file like other processes do (chenson)
0003260: [Bug] Incoming heartbeat batch can be left stranded in error (chenson)
0003253: [Bug] ProcessInfo which is used to gather information about processes can be corrupted on push and pull because of threading in 3.8 (chenson)
0003256: [Bug] Extract stats aren't updated on common outgoing batch rows for nodes that did not do the actual extract (chenson)
0003252: [Improvement] When inserting extract in background reload batches record the data_row_count during the insert of the RQ batch (chenson)
0003232: [Improvement] Upgrade Jetty to the latest version. Require Java 8. (chenson)
0003209: [Improvement] Delay detection of offline nodes after restart (elong)
0003168: [New Feature] Create CSV Router to route data from a CSV file into a database and update documentation. (kstojanovska)
0002684: [New Feature] Support Custom Jobs (mmichalek)
0003060: [Bug] Data generated by a transform isn't visible to later transforms (when using multiple load transforms on one table) (mmichalek)
0003114: [New Feature] Update service detects new software versions (elong)
0002937: [Improvement] Disable and deprecate Grouplets feature in 3.9 (mmichalek)
0003087: [Improvement] When a trigger_hist row can't be found use the catalog and schema from the trigger definition to look up the table to "recreate" (chenson)
0002909: [Bug] Built in extension points should be marked as built in extension points so they show up as such (chenson)
0002911: [New Feature] Immediate re-pull when data was just pulled (elong)
0003220: [Improvement] Cannot Register a remote node to another remote node before initial load (chenson)
0003113: [Bug] Typo in sym_service.conf (chenson)
0003115: [Bug] You can miss sym_monitor_event sync's because they are on the heartbeat channel. Create a new "monitor" channel. (chenson)
0002912: [Improvement] Prevent reading out database password via rest api (elong)
0003053: [Improvement] Default handle_key_updates in sym_trigger to 1 (chenson)
0003120: [Task] Upgrade build to the latest version of gradle (chenson)
0003138: [Task] Default monitor.events.capture.enabled to false (chenson)
0003112: [Improvement] Make Outgoing Batch and Incoming Batch Similar (maxwellpettit)
0003092: [Improvement] Remove sym_trigger_router.initial_load_batch_count. It is no longer used. (chenson)
30 issues View Issues
0003288: [Bug] The cancellation of pending heartbeat batches can cause a deadlock on SQL Server (mmichalek)
0003279: [Bug] Rest services return HTTP response code 200 when disabled, but should return a response code indicating something's wrong. (mmichalek)
0003286: [Improvement] dbcompare improvements (mmichalek)
0003285: [Improvement] Move loading of trigger_routers to more specific execution branch to reduce unneeded db calls (chenson)
0003277: [Bug] null pointer during sorting of tables for initial load (josh-a-hicks)
0003278: [Bug] Fixes for NuoDB dialect (elong)
0003282: [Bug] Common batch extracts may fail when a cluster is using a shared staging area (mmichalek)
7 issues View Issues
Released 2017-10-06
0003258: [Improvement] DB2 support for transaction id (josh-a-hicks)
0002846: [Bug] SymmetricDS blocks on startup when AS400 password expires (elong)
0003210: [Bug] Turkish Locale Problem (elong)
0003212: [New Feature] Add NuoDB Dialect (kstojanovska)
0003224: [Bug] batch_to_send_count does not get reset in hybrid model (kstojanovska)
0003226: [Bug] Enabling File Sync doesn't start jobs on client nodes (maxwellpettit)
0003227: [Improvement] When pushing to a large number of nodes on limited number of thread, only allocate nodes that have pending changes (chenson)
0003234: [Improvement] Ability to store additional statistics by channel (josh-a-hicks)
0003237: [Bug] DB2 zOS does not support to_clob function (josh-a-hicks)
0003239: [Bug] Observed that two load threads are loading the same batch at the same time during a pull (maxwellpettit)
0003240: [Bug] Each time a batch is loaded it uses the same thread name. This can be confusing if the same node is being loaded by two thread (maxwellpettit)
0003246: [Improvement] Check for journaling on DB2 for i (elong)
0003247: [Improvement] Include check for next data_id to ensure within range of sym_data_gap (chenson)
0003249: [Bug] Setting EXTERNAL.ID.IS.UNIQUE can create a race condition that allows to nodes to share registration (gwilmer)
0003250: [Bug] Clustered DataExtractorService re-extracts batches when they have already been extracted by another node in the cluster (gwilmer)
0003259: [Improvement] Retry batch should be flushed when written to the output stream so we don't hit timeouts (chenson)
0003263: [Improvement] Optimize inserting of initial load events for lots of nodes (chenson)
0003264: [Bug] The MySQL Bulk Loader throws a null pointer exception if the table is not found in the target database (chenson)
0003267: [Improvement] Log better error message when SymmetricDS fails to decrypt a db.password (chenson)
0003268: [Bug] symadmin encrypt-text requires a valid properties file that can connect to a database to encrypt new passwords. (chenson)
0003269: [Bug] If a file exists in staging with a done or create suffix and no period to separate the suffix, then the server won't startup (chenson)
0003270: [Improvement] Document how to import a pkcs12 formatted ssl cert into symmetricds (chenson)
0003271: [Bug] Postgres bulk loader will produce a stack overflow error on create tables (josh-a-hicks)
0003272: [Bug] Table reload requests that use the custom sql (for truncates or other) run agains the improper order of tables (josh-a-hicks)
0003273: [Bug] Initial load order was not correct for all cases. (josh-a-hicks)
25 issues View Issues
Released 2017-08-14
0003229: [Improvement] Add Data Loader for Apache Ignite (maxwellpettit)
0003216: [New Feature] Tibero Database Dialect (josh-a-hicks)
0003204: [Bug] File Sync Fast Tracking doesn't initially populate sym_file_snapshot (maxwellpettit)
0003205: [Bug] Enabling File Sync doesn't create triggers on sym_file_snapshot (maxwellpettit)
0003206: [Improvement] Initial load extractor threading does not support multiple queues (josh-a-hicks)
0003194: [Bug] SymmetricDS fails to start on multi-homed installations using the exact same db.url (mmichalek)
0003207: [Bug] Error on Sybase 12.5 on setDecimalValue (josh-a-hicks)
0003173: [Improvement] dbcompare - support overriden target table names. (mmichalek)
0003213: [Improvement] dbcompare - support excluding individual columns from comparison (mmichalek)
0003214: [Bug] Close & delete resource if retry command comes through and the create file has been stranded in staging (chenson)
0003203: [Bug] list outgoing batches query does not work on Sybase ASE when a load is specified (maxwellpettit)
0003211: [Bug] When a node is in "offline" mode (node.offline=true), the offline push and pull jobs don't always pick up incoming files (gwilmer)
0003218: [Bug] Sybase ASE 12.5 updateHandleKeyUpdatesTriggerTemplate Syntax Error (maxwellpettit)
0003222: [Improvement] When restarting a cron job print out the next scheduled time (chenson)
0003223: [Bug] Batches that are corrupted on the file system in the outgoing staging area can cause the system to get stuck (chenson)
15 issues View Issues
Released 2017-07-19
0003197: [Bug] One file trigger that is configured with two routers to two different target locations syncs only to one location (chenson)
0003200: [Bug] Auto Create Router on Group Link Value Too Long (maxwellpettit)
0003176: [Improvement] SymDS V3.7 and V3.8 for "sym_context" With INTERBASE (maxwellpettit)
0003199: [Improvement] Support 'NaN' Datatype for Numeric Columns in Postgres (maxwellpettit)
4 issues View Issues
Released 2017-07-07
0003193: [Bug] Sybase ASE - If you turn off selection of old data during routing and use a column match routers an error is thrown (chenson)
0003163: [Improvement] Detect situations where there are invalid copies of engines.properties files in the engines directory (mmichalek)
0003165: [Bug] Common batch issue when nodes are pushed to or pulled from concurrently (chenson)
0003167: [Bug] Sybase ASE Errors Using Multithreaded Sync Triggers (maxwellpettit)
0003172: [Bug] Table Name for Triggers on Postgres is Case Sensitive (maxwellpettit)
0003174: [Bug] Purge should clean up abandoned sym_data_event rows (elong)
0003177: [Bug] Sync config on upgrade can lose registration (elong)
0003180: [Bug] When a node is re-registered it can propagate deletes of itself back to the registration effectively unregistering itself (chenson)
0003181: [Bug] Corrupt batch on remote target node after an "out of disk space error" (chenson)
0003182: [Bug] Resource is not closed after "out of disk space" error on a remote target node (chenson)
0003183: [Bug] After a failed extract in background batches should be cleaned up and the batch status should be set back to RQ (chenson)
0003184: [Bug] Multi-homed nodes that run out of disk space can end up with zero byte sized files due to the way that copy works (chenson)
0003152: [Bug] org.jumpmind.db.sql.SqlException: JZ0NK: Generated keys are not available because either the Statement.NO_GENERATED_KEYS was use (josh-a-hicks)
0003179: [Improvement] Make start.sync.config.job, auto.sync.config.at.startup editable on the UI. (mmichalek)
0003187: [Bug] Initial load delete first with transforms involving multiple tables (josh-a-hicks)
0003188: [Bug] The ddl builder for Sybase ASE is ignoring the unique='true' setting on the column even though the keyword unique does exist (chenson)
0003190: [Task] Update Supported Data Types in SqlServer in Docs (kstojanovska)
0003191: [Bug] Sybase useHandleKeyUpdates yields trigger that sets nocount incorrectly (chenson)
0003192: [Bug] Sybase ASE Errors in Metadata Using Reserved Words (maxwellpettit)
19 issues View Issues
Released 2017-06-19
0003157: [Improvement] Allow bulk loaders to fall back to default loader when an error occurs (josh-a-hicks)
0003154: [Bug] Reopen registration sets created_at_node_id to be the selected node rather than registration server/managing node (kstojanovska)
0003147: [Improvement] Create table reload requests by channel (josh-a-hicks)
0003145: [Improvement] Allow $(schemaName) variable in channel expression (elong)
0003143: [Bug] Table reload request load sql using alias "t" will not work (josh-a-hicks)
0003148: [Bug] Stream rows does not honor sync key names if provided (josh-a-hicks)
0003150: [Bug] ProcessInfo duration is for the entire sync (versus batch) and the rows/sec is off because it is calculated using the total time (maxwellpettit)
0003155: [Bug] Refresh the group link cache when node group links are modified. (maxwellpettit)
0003156: [Improvement] Validate the number of table columns match the number of data elements before attempting to load data (chenson)
0003146: [Bug] Wildcards for schema and table on Oracle (elong)
0003162: [Bug] Empty batches are created on load when using subselect router (maxwellpettit)
11 issues View Issues
Released 2017-06-05
0003130: [Improvement] Guard against case mismatches in trigger id's and router id's when doing table reloads (mmichalek)
0003104: [New Feature] Log Conflicts Resolutions (maxwellpettit)
0003118: [Bug] Only sync pro tables to professional target nodes. (mmichalek)
0003121: [Bug] Generic JDBC builder improperly handling delimiters (josh-a-hicks)
0003131: [Bug] null pointer when a table reload request is queued up and there is no sym_node_security row (chenson)
0002835: [Bug] Cannot access audit tables when db is postgressql (chenson)
0003129: [Bug] oracle.use.transaction.view=true can cause missing data on busy systems (chenson)
0003137: [Improvement] Updates to SymmetricDS tutorial (kstojanovska)
0003133: [New Feature] Stream rows (josh-a-hicks)
0003127: [Improvement] Add logging to the DBFRouter to log failed line number and field (chenson)
10 issues View Issues
Released 2017-05-12
0003105: [Improvement] The default cluster.lock.timeout.ms is set to 30 minutes. Default to 2 hours instead. (chenson)
0003094: [Bug] Status of batches set to resend when error on channel (elong)
0003096: [Improvement] Variables in router target catalog and schema (elong)
0003097: [Bug] Common batches can get an error if they are in memory and two nodes try to pull with just the right timing. (chenson)
0003099: [Bug] target and source node caches don't get refreshed when sym_node is sync'd to other nodes for the first time (chenson)
0003095: [New Feature] Add basic DDL replication (elong)
0003093: [Bug] Greenplum client won't register properly with master node (gwilmer)
7 issues View Issues
Released 2017-05-04
0003085: [Bug] MySQL JSON columns being converted to hex representation on mysql data on extract at source node (chenson)
0003088: [Bug] The last update time on sym_incoming_batch comes from the app serve while the create time comes from the database (chenson)
0003089: [Bug] data_event_count is not being set for initial load batches (chenson)
0002984: [Bug] Batch was corrupted in incoming staging. The beginning of the batch was appended to the middle of the same batch. (chenson)
0003091: [Bug] A corrupt batch being sent to a target results in a NullPointerException by load writing the batch to staging (chenson)
5 issues View Issues
Released 2017-05-01
0003075: [New Feature] Sync configuration on upgrade and as periodic job (elong)
0003066: [Improvement] Cache frequent use of AppUtils.getHostName() and AppUtils.getIpAddress() (mmichalek)
0003076: [Bug] MySQL binary collation sequence causes incorrect decoding of text data from source (gwilmer)
0002964: [Bug] MEDIUMTEXT/LONGTEXT columns being converted to hex representation on mysql data on extract at source node (maxwellpettit)
0003077: [Task] custom_variable_classes not used in PostgreSQL 9.2+ (maxwellpettit)
0003079: [Improvement] Add capture only changes support for SQLite (chenson)
0003081: [Improvement] Give unique names to the data loader and data extractor threads (chenson)
0003070: [Improvement] Log error details when SymmetricDS is unable to read table metadata (gwilmer)
0003069: [Improvement] Update documentation for 3.8 load balancers to use sticky sessions (josh-a-hicks)
0003080: [Improvement] Show failed batch extract errors even if there is problems updating outgoing batch status for the failure (gwilmer)
0003074: [Bug] Extracted request gets stuck if connection failes while sending batch (chenson)
0003067: [Improvement] Log information about long running routing similar to extract and load (maxwellpettit)
0003068: [Bug] MySQL Create Table with Timestamps (josh-a-hicks)
0003083: [Bug] Support initial load in background with stream to threshold set to a non-zero value (chenson)
0003073: [Bug] When auto.resolve.foreign.key.violation=true and circular fk dependencies exist SymmetricDS can blow up with an OOM error (chenson)
0003086: [Bug] Missing foreign key reference of null is not handled properly in the foreign key recovery code (chenson)
16 issues View Issues
Released 2017-04-20
0003064: [New Feature] Allow the event action on group links to be overridden (elong)
0003065: [Bug] DB2 Error: SQLCODE=-574 during Initial Load when default datatype is CURRENT TIMESTAMP (maxwellpettit)
0003063: [Bug] Keep varchar(max) columns comparable on MSSQL (chenson)
0003061: [Bug] Sync triggers will not create trigger if function already exists (Postgres) (mmichalek)
4 issues View Issues
Released 2017-04-19
0003034: [Bug] Failed to extract batch - IllegalStateException: There is no content to read (chenson)
0003046: [Bug] Table debug log statement causes slowness (maxwellpettit)
0002967: [Bug] SymmetricDS schema-send (sync) fails to create tables for autoindex-ed SQLite tables (maxwellpettit)
0003042: [Bug] Batch protocol incorrect when reload event with no data is followed by two different change events (chenson)
0002766: [Bug] Version 3.8.3 : Symmtric DS Installation on Interbase (maxwellpettit)
0003056: [Improvement] Make XmlPublisherDatabaseWriterFilter configurable to publish either on batch complete or batch commit (chenson)
0003054: [Bug] Support lower_case_names=1 setting for MySQL (chenson)
0003055: [Improvement] When the default database writer fails to execute a SQL event, the SQL that was executed is not logged (chenson)
0003045: [Bug] Sometimes insert on replicated tables fails on MySQL (maxwellpettit)
0003049: [Improvement] Update the documentation for BeanShell Script Transform to talk about how to access "other" columns (maxwellpettit)
0003058: [Bug] Every sql error causes "There is no content to read. Memory buffer was empty and <file> was not found" (chenson)
0003020: [Bug] Problem after upgrading from version 3.8.8 to version 3.8.18 (chenson)
0003030: [Improvement] Test SymmetricDS with Firebird 3 (maxwellpettit)
0003059: [Bug] 0003027 caused columns of type text on SQL Server to not work with handle_key_updates on (chenson)
14 issues View Issues
Released 2017-04-06
0002962: [Bug] Fix typos and dead URLs in tutorials (maxwellpettit)
0003018: [Bug] On Oracle, nvarchar not syncing unicode characters when use_capture_lobs is on (chenson)
0003017: [New Feature] Assign MySQL data Types.OTHER to LONGVARCHAR (maxwellpettit)
0003003: [Improvement] Support JSON data types (maxwellpettit)
0002991: [Bug] Routing still runs with start.route.job=false (maxwellpettit)
0003024: [Improvement] Document sendStringParametersAsUnicode=false for improving performance on Sql Server (chenson)
0002992: [Bug] host.bind.name not being used (maxwellpettit)
0003025: [Improvement] Update the heartbeat (sym_node_host) immediately on an re-opened registration (chenson)
0003026: [Bug] null pointer exception on sqlite. jdbc type name can be null on sqlite (chenson)
0003027: [Bug] Unable to create trigger for varbinary in MsSql (maxwellpettit)
0003028: [Improvement] When jobs.synchronized.enable is true, sync triggers should only use 1 thread (chenson)
0003031: [Bug] Sqlite dialect is broken (chenson)
0003033: [Bug] A beanshell script transform should be able to return a non string value (which would be translated to a screen) (chenson)
0003035: [Bug] When using postgres bulk loader the dataloader.create.table.alter.to.match.db.case setting is not respected (chenson)
0003036: [Bug] ConcurrentModificationException while cleaning staging (chenson)
0003037: [Bug] Update the documentation for configuration of bulk loaders on the channel (chenson)
0003038: [Improvement] Sql Server - default sendStringParametersAsUnicode=false so we use the index when varchar primary keys are used (chenson)
0003039: [Bug] Wildcard table names don't work on Informix (chenson)
18 issues View Issues
Released 2017-03-14
0003016: [Improvement] Don't refresh the sym_node cache on the update of sym_node records (chenson)
0003014: [Improvement] During Extract, ORA-01438: value larger than specified precision allowed for this column (mmichalek)
0003013: [Improvement] Update the heartbeat (sym_node_host) immediately on registration (chenson)
0002999: [Bug] When a node is disabled after it has expired sym_node_host should be deleted as well as sym_node_security (chenson)
0003000: [Bug] The registration ack for registration redirect does not work because the ack url is incorrectly rebuilt for the redirected ack (chenson)
0003002: [Improvement] Add a parameter to enable the old way to purge staging. Default will be stream.to.file.purge.on.ttl.enabled=false (chenson)
0003005: [Bug] SequenceFactory may issue duplicate outgoing_batch (batch_id) sequence numbers when shared db transactions are rolled back (mmichalek)
0003007: [Bug] Initial Load or Table Reload extract may stall when file.sync.enable=true (mmichalek)
0003010: [Improvement] Batches get stranded in ready state in staging on a cluster because the ack that moves them to done occurs on a different server (chenson)
0003011: [Bug] Batches that are behind a transform change batch in the same sync get deleted because of staging purge (chenson)
10 issues View Issues
Released 2017-02-24
0002995: [Improvement] IllegalStateException - no content found after fixing transform (chenson)
0002996: [Bug] DB2 dialect fails to detect existence of sym tables (mmichalek)
0002998: [Bug] Batch incorrect when a reload event with no data followed by change capture data from a different table in the same batch (chenson)
0002978: [Improvement] Remove the packaging of symmetric.properties file in the conf directory. (chenson)
0002993: [Bug] ddl-utils should not drop tables when it can't update their structure (mmichalek)
5 issues View Issues
Released 2017-02-08
0002985: [Bug] C Client FileSync raises an error on empty incoming batches (mmichalek)
0002986: [Bug] Configuration Service master to master only check did not account for both master to master and tiered (josh-a-hicks)
0002988: [Improvement] On registration don't restart jobs if they had not previously been started (chenson)
0002989: [Bug] A sql parsing bug was introduced by 2977 (chenson)
4 issues View Issues
Released 2017-02-01
0002969: [Improvement] Support offline mode for file sync (mmichalek)
0002968: [Bug] java.lang.NullPointerException in getForeignTableRows when foreign key is null (chenson)
0002971: [Bug] C Client crashes during sync triggers if two trigger routers point at the same trigger (mmichalek)
0002973: [Bug] Support http timeout in C client (mmichalek)
0002974: [Bug] 3.8 is not backwards compatible with pre 3.0 versions when multiple batches with the same table are received (chenson)
0002975: [Improvement] Generating a snapshot can fail if the SYM_NODE_COMMUNICATION table has issues while being added (josh-a-hicks)
0002977: [Improvement] SqlScriptReader is slow at parsing multi-line sql statements (chenson)
0002976: [Bug] Foreign key automatic resolution was not handling nested dependencies properly (josh-a-hicks)
8 issues View Issues
Released 2017-01-19
0002963: [New Feature] Support file sync in the C client (mmichalek)
0002470: [New Feature] Add support for MySQL 5.7 (maxwellpettit)
0002959: [Bug] BatchStagingManager deleting incoming files from staging that are not yet processed (chenson)
0002960: [Improvement] Save on memory: StagingManager creates lots of empty maps that just take up memory as staging grows (chenson)
0002961: [Bug] Concurrent extractors of common batches can get into a state where the batch is not found in staging when it goes to sent it (chenson)
5 issues View Issues
Released 2017-01-11
0002953: [Bug] MSSQL Data truncation issue (josh-a-hicks)
0002956: [Improvement] getFullyQualifiedTableName is a CPU hotspot (chenson)
0002957: [Bug] If batch is missing from staging on the target side, don't try to load any other batches while waiting for the resend (chenson)
0002958: [Improvement] Log message about catalog, schema and table use for lookup if an exception occurs while looking up a table (chenson)
4 issues View Issues
Released 2016-12-30
0002936: [Improvement] Provide additional DB2 debug logging around global variables (mmichalek)
0002938: [Bug] Monitor event batches may get mistakenly ignored during heartbeat (mmichalek)
0002939: [Bug] MySQL store: Error after reload node (chenson)
0002940: [Improvement] Sql Server - An implicit conversion on column [sym_outgoing_batch].[status] to data type "nchar" may be causing index su (chenson)
0002941: [Improvement] Update Oracle section to enhance 4k limit documentation and add subsections (chenson)
0002942: [Improvement] Make sym_data_gap regeneration more robust (mmichalek)
0002943: [Improvement] Add min and max sym_data.data_id to support snapshot (mmichalek)
0002944: [Improvement] Attempt to recover if sym_trigger_hist is deleted. If the table and trigger can be found then recreate the row. (chenson)
0002945: [Improvement] Allow environment variables and system properties to be used as replacement properties in engine parameters at startup (chenson)
0002946: [Improvement] Provide explicit default and document the host.bind.name parameter (mmichalek)
0002947: [Bug] Auto resolve foreign key violation fails when table in different catalog or schema (elong)
0002948: [Bug] Columns mismatched with multiline clob and varchar columns with matching protocol data that happens to be in a new line (chenson)
0002949: [Bug] Statistics in sym_node_host_channel_stats are incorrect for extract and send as of 3.8.0 (chenson)
0002951: [Bug] Push HEAD request doesn't use the queue channel to reserve its connection so the request is effectively not doing anything (chenson)
0002952: [Bug] A sym_data row that can't be handled should be ignored. Not reprocessed over and over again. (chenson)
15 issues View Issues
Released 2016-12-05
0002928: [Bug] Staging purge process fails to clean registration batch. Purge staging hourly based on absence of batch in batch tables (chenson)
0002920: [Bug] Offline mode extract is broken (chenson)
0002923: [Bug] Errors are being suppressed when they bubble up to the SymmetricDS Servlet and the nodes are multi-homed (chenson)
0002924: [Bug] java.util.concurrent.TimeoutException: Idle timeout expired: 60000/60000 ms (chenson)
0002925: [New Feature] Add REST service that invokes a job (chenson)
0002926: [Improvement] Reference the latest postgres jar file so that postgres 9.6.1 works (chenson)
0002930: [Improvement] Add node offline monitor (chenson)
7 issues View Issues
Released 2016-11-25
0002910: [Bug] Node Communication Type FILE_EXTRACT is too long (mmichalek)
0002914: [Bug] Don't log full stack trace when registration is not open on client (chenson)
0002915: [Bug] Initial load batches get routed to everyone if initial load is interrupted by a reboot if cluster.lock.enabled is true (chenson)
0002916: [Bug] Sql script in doc is wrong (chenson)
0002917: [Improvement] Don't update the status of an outgoing batch to SE until it has been sending for outgoing.batches.update.status.millis (chenson)
5 issues View Issues
Released 2016-11-17
0002822: [Improvement] DBCompare should support where clauses (mmichalek)
0002885: [Bug] Table reload request delete first out of order (chenson)
0002893: [Improvement] Set the defaults for pull.thread.per.server.count and push.thread.per.server.count to something bigger than 1 (chenson)
0002898: [Bug] DBCompare should consult sym_router when determining target catalog and schema (mmichalek)
0002892: [Bug] Monitor events cause issues when syncing to a node that is running SymmetricDS version less than 3.8. (chenson)
5 issues View Issues
Released 2016-11-08
0002876: [Improvement] FileSync initial load batches should respect max batch size of the filesync_reload channel (mmichalek)
0002863: [Task] Update the documentation for initial loads (josh-a-hicks)
0002874: [Bug] [SQL Server] When capture changes only is enabled, pk is not compared and potential syntax error (elong)
0002875: [Improvement] log at the warning level, not the error level when an unrecognized engine is specified or a bad url is used (chenson)
0002878: [Improvement] Provide for BSH scripting when reading properties files (mhanes)
0002883: [Bug] DBCompare overrides SQL output when using a single SQL file (mmichalek)
0002887: [Improvement] Update sym_service.conf with setting for http server response timeout. Reduce the default timeout from 2 hours to 1 minute (chenson)
0002890: [Improvement] For long running batches, log not only the dml count, but the dml count by table (chenson)
0002768: [Bug] Abandoned batches in StagingArea if Batch is marked as "OK" (josh-a-hicks)
0002888: [New Feature] Remove any staging files that do not associate with a batch in the incoming or outgoing batch table when purged. (josh-a-hicks)
10 issues View Issues
Released 2016-10-20
0002857: [Bug] PostgresBulkDatabaseWriter is not preserving spaces (josh-a-hicks)
0002859: [New Feature] Auto resolve foreign key violation by sending missing rows (elong)
0002852: [Improvement] Add batch summary to incoming batches (mmichalek)
0002860: [Improvement] Avoid locks in extract query with dirty reads (elong)
0002865: [Bug] Console event unique key exception on ignore multiple batches (josh-a-hicks)
0002868: [Bug] Fix really bad error message when a transform transforms a table name to a name that doesn't exist and the original name does (chenson)
0002870: [Improvement] Add getEngine(name) to SymmetricWebServer (elong)
0002871: [Bug] Initial loads and reload were not preserving spaces on an empty space field. (josh-a-hicks)
8 issues View Issues
Released 2016-10-06
0002843: [Bug] When a common batch is sent to more than one target, subsequent target nodes are sent a retry instead of the batch data (chenson)
0002847: [Bug] Clustered system should not cache sequences (elong)
0002841: [New Feature] Add a generic jdbc platform and symmetric dialect that will work with jdbc drivers that are not yet supported. (chenson)
0002845: [Improvement] Upgrade warning on node communication table (josh-a-hicks)
4 issues View Issues
Released 2016-09-30
0002834: [Bug] SQL Server table create fails for date type numeric() identity (josh-a-hicks)
0002801: [Bug] Ignoring a batch will not send the ignore properly to targets (josh-a-hicks)
0002803: [Bug] Outgoing purge job is slower than it needs to be (chenson)
0002807: [Bug] DBCompare should process tables that have a PK mapped in a transform, even if they don't have a physical PK (mmichalek)
0002808: [Improvement] Update cacerts file to latest version (elong)
0002809: [Improvement] Parameter to trust mail server certificate (elong)
0002813: [Bug] Remove monitor event and console event from configuration (elong)
0002814: [Bug] Add debug logging for SMTP session (elong)
0002815: [Improvement] Add an online() call to IOfflineClientListener (elong)
0002805: [Bug] mysql_bulk may cause NullPointerException (elong)
0002816: [Bug] org.jumpmind.symmetric.service.impl.ConfigurationService#channelWindowsByChannelCache filling error (elong)
0002817: [Bug] User Guide misstype (elong)
0002818: [Bug] RouterService is deadlocking on SQLite when clustering enabled (mmichalek)
0002820: [Bug] Unclear meaning of dbcompare's --use-sym-config (mmichalek)
0002823: [Bug] Value too large for router_id in sym_data_event error (elong)
0002825: [Bug] Data with ID = 0 is routed perpetually when using DataGapFastDetector (mmichalek)
0002812: [Improvement] Provide a means to override the default semicolon delimiter for SQL event batches (mhanes)
0002831: [Bug] Newline converison in data can cause data truncation error (elong)
0002832: [Improvement] Sql server unable to read meta data (tables) from when using other databases (josh-a-hicks)
0002833: [Bug] Batch extraction stuck in loop (elong)
0002836: [Improvement] Reduce checks for old files in stage management (elong)
21 issues View Issues
Released 2016-09-15
0002765: [Bug] MS SQL Server 2000 fails to alter table due to dropping of default constraints (josh-a-hicks)
0002788: [Bug] Sync of monitor events gets unique key violation (elong)
0002764: [New Feature] isNull, isBlank, and isEmpty Transform Types (josh-a-hicks)
0002770: [Bug] Monitor/console event tables not routing and syncing (elong)
0002773: [Improvement] Repeating startup messages about nodes being rejected (elong)
0002767: [Bug] Monitoring not working Firebird (elong)
0002771: [Bug] MSSQL 2000 fails to alter tables due to default constraint errors (josh-a-hicks)
0002774: [Bug] Batch with committed data_events was OK'd after server died after commit of sym_data_event but before batch status was updated (chenson)
0002769: [Bug] Initial load extraction gets into a loop if staging file was deleted before being sent. (josh-a-hicks)
0002777: [Bug] Initial load waits for extraction that never happens (elong)
0002782: [Bug] Duplicate data gap immediately after upgrade (elong)
0002748: [Bug] the Table 'sym_trigger' can not be created on informix (elong)
0002775: [Bug] Uninstall fails on version 3.5 database with 3.8 software on Postgres (elong)
0002780: [Improvement] org.jumpmind.db.sql.JdbcSqlReadCursor not using sqlTemplate.getSettings().getResultSetType() for creating statement (elong)
0002781: [Improvement] Loop is continuing even when condition is meet (elong)
0002784: [Bug] 3.5 version of SymmetricDS will not register with a 3.8.3 server (chenson)
0002776: [Bug] SQL Lite nodes fail to register 3.8 - 3.8.3 (josh-a-hicks)
0002792: [Bug] DBCompare leaks database resources (mmichalek)
0002786: [Improvement] Add sym_table_reload_request to support snapshot (josh-a-hicks)
0002793: [Improvement] Add count and is_resolved to monitor events (elong)
0002799: [Improvement] Adjust unrouted data count to not include gaps (josh-a-hicks)
21 issues View Issues
Released 2016-08-31
0002763: [Bug] UI Problems when a row in sym_data has a bad trigger_hist_id (mmichalek)
0002761: [Bug] Stuck in loop of "Batch is marked as ready but it has been deleted" (elong)
0002759: [Improvement] Abstract File Parsing Router needs to remove context entries when file is deleted (josh-a-hicks)
0002756: [Improvement] Allow BSH transforms to control if old data is sent to target (josh-a-hicks)
0002757: [Bug] New tables in 3.8 will fail to load on systems that have a mix of 3.8 nodes and < 3.8 nodes (josh-a-hicks)
0002754: [Bug] iSeries can't detect sym tables on startup (elong)
0002752: [Improvement] Optimize DataExtractorService lookupAndOrderColumnsAccordingToTriggerHistory (elong)
0002753: [Improvement] Optimize calls from TransformWriter to enhanceWithImpliedColumns (mmichalek)
0002750: [Improvement] Firebird extract with configurable cast to varchar sizes (elong)
0002749: [Improvement] Firebird "arithmetic exception, numeric overflow, or string truncation" on extract (elong)
10 issues View Issues
Released 2016-08-22
0002731: [Bug] Insert of TableReloadRequest fails in Oracle (josh-a-hicks)
0002730: [Improvement] Incoming batch has a new ignore row count (josh-a-hicks)
0002725: [Bug] docs have 404 (elong)
0002736: [Bug] TableReloadRequest does not work when sending data to central (josh-a-hicks)
0002737: [Improvement] Log Connection Failure Stack Trace (mmichalek)
0002740: [Bug] "Did not receive an acknowledgement" using sym_table_reload_request (elong)
0002743: [Bug] The entire list of nodes is looked up during a single node's authentication. This was introduced when caching logic was reverted (chenson)
7 issues View Issues
Released 2016-08-19
0002742: [Bug] The entire list of nodes is looked up during a single node's authentication (chenson)
1 issue View Issues
Released 2016-08-16
0002711: [Bug] When system is busy, gaps should wait to expire (elong)
0002714: [New Feature] Upgrade Jetty to the latest 9.2 version and enable websockets (chenson)
0002716: [Bug] Unable to create HSQLDB node (josh-a-hicks)
0002718: [Improvement] Update the documentation for sym_trigger.use_capture_old_data (chenson)
0002705: [Improvement] Record Batch Summaries (mmichalek)
0002708: [Bug] symmetric-ds high cpu usage (elong)
0002710: [Improvement] Buffer Hybrid Pull Status Requests (mmichalek)
0002721: [Bug] Null Pointer on Initial load - sync triggers failed to create trigger (elong)
0002723: [Improvement] Auto configure registration server (elong)
0002728: [Bug] NPE on uninstall using symadmin (elong)
10 issues View Issues
Released 2016-08-08
0002683: [New Feature] Add an api to get trigger text from the ddl utils IDdlReader and implement it for databases that support triggers (rsunderhaus)
0002548: [Improvement] Remove old heap dumps on startup (elong)
0002555: [Bug] REST : postRegisterNode (postRegisterNodeByEngine) using GET method (elong)
0002574: [Improvement] Improve performance of the transfer to and from staging (elong)
0002449: [Bug] File sync sometimes not deleting files with delete_after_sync option (elong)
0002458: [New Feature] Add arbitrary text at the beginning of the trigger (elong)
0002598: [Improvement] DbFill cascade foreign key dependencies (elong)
0002609: [Improvement] Disable file sync by default (elong)
0002611: [Improvement] Heartbeat batches build up when node offline (elong)
0002591: [Improvement] Add transactions to DbFill (elong)
0002618: [New Feature] Throttle network bandwidth usage on channel (elong)
0002638: [Improvement] Allow send-schema to send all tables when no tables as arguments (elong)
0002642: [New Feature] Table trigger configuration to provide included columns setting (josh-a-hicks)
0002651: [Improvement] Add built-in variables for use in beanshell extensions (elong)
0002653: [Improvement] Make unrouted data collection optional (elong)
0002565: [New Feature] Add VoltDB Dialect (mmichalek)
0002635: [Improvement] New data loader type on channels "bulk" to represent any bulk loader if support by platform (josh-a-hicks)
0002661: [Improvement] Perform locking in-memory when clustering is disabled (elong)
0002662: [Improvement] Perform node communication locks in-memory when clustering is disabled (elong)
0002665: [Improvement] Reduce number of times parameters are reread during startup (elong)
0002666: [Improvement] Cache offline node database parameters used by node communication (elong)
0001614: [Improvement] Parallelize the synchronization of triggers to improve performance in a system with lots of tables (elong)
0002667: [Improvement] Use node identity cache (elong)
0002670: [Improvement] Only update sym_node_channel_ctl when using extract millis on channel (elong)
0002671: [Improvement] Use node group link cache for source and target nodes (elong)
0002674: [Improvement] Route for only channels that have data waiting to route (elong)
0002580: [Improvement] Send keepalive during push or pull to prevent connection timeout (elong)
0002668: [Improvement] Use node security cache (elong)
0002677: [Improvement] High CPU for routing to determine common batch status on channels (elong)
0002679: [Improvement] Add event logging to service wrapper start up (elong)
0002680: [Improvement] Avoid updating status of outgoing batch for small batches (elong)
0002681: [Improvement] Only query incoming_error for batch being retried (elong)
0002682: [Improvement] Cache outgoing batch sequences (elong)
0002564: [New Feature] dbcompare feature (mmichalek)
0002577: [Improvement] Separate thread for transfer and loading or extract (elong)
0002603: [Improvement] Retry batches from staging instead of sending them again (elong)
0002658: [New Feature] Initial load defaults to initial load extract in background (josh-a-hicks)
0002675: [New Feature] Ability to add extension point for the purge service (josh-a-hicks)
0002687: [Improvement] Support File Sync on Android (mmichalek)
0002699: [Improvement] Copy directly to staging when nodes are on same server (elong)
0002526: [Improvement] Improve performance of data gap detection (elong)
0002547: [New Feature] Notification of system event problems (elong)
0002664: [Improvement] Misc performance improvements (mmichalek)
0002693: [Improvement] Use node cache (elong)
0002701: [Improvement] Disable Offline Push/Pull By Default. (mmichalek)
0002702: [Improvement] High CPU usage from Table.getFullyQualifiedTableName() (elong)
0002704: [Improvement] AbstractDatabasePlatform.parseTimestamp should always return the Timestamp type (rsunderhaus)
0002625: [New Feature] Hybrid Pull Feature (mmichalek)
0002691: [New Feature] Partial initial loads (josh-a-hicks)
0002498: [Improvement] Service fails after Java upgrade (elong)
0002477: [Improvement] Add command line options to sym that allow me to run a single push or pull (elong)
0002525: [Improvement] Outgoing load summary was designed to only retrieve "reload" channel. (josh-a-hicks)
52 issues View Issues
Released 2016-08-08
0002695: [Bug] Transform with null update action loses updates (elong)
0002724: [Improvement] Eliminate Repeated Stack trace logging (mmichalek)
0002696: [Bug] Fix NPE in XmlPublisherDataRouter when publishing delete event type (elong)
0002697: [Bug] C Client sends empty subsequent batches when max batch size is exceeded (mmichalek)
0002700: [Bug] C Client doesn't properly parse quote characters in incoming data. (mmichalek)
5 issues View Issues
Released 2016-07-22
0002678: [Improvement] DBF Router setup to read files in a read only mode to prevent locking (josh-a-hicks)
0002657: [Bug] Nodes not cleaning staged resources of any type (chenson)
0002685: [Improvement] File sync parameter to remove just the *.ctl file after file has been replicated. (josh-a-hicks)
0002688: [Bug] Heartbeats don't propagate properly in a multi-master situation (mmichalek)
0002690: [Improvement] Parameter to allow creation of tables during initial load without a PK (josh-a-hicks)
5 issues View Issues
Released 2016-07-11
0002639: [Bug] Issue 2519 broke DB2 Z/OS version 10 support (elong)
0002640: [Bug] Wrong node hierarchy when only one group link (rsunderhaus)
0002643: [Bug] Trigger build fails for varchar(5000) when using mssql.use.ntypes.for.sync parameter (elong)
0002646: [Bug] FileRouting throws NPE when lookup router doesn't route (mmichalek)
0002654: [Improvement] Allow to execute update only statements via restservice (chenson)
0002545: [Improvement] AS400 parameter to control what database type CLOBs are cast to. (josh-a-hicks)
0002644: [Bug] Large float values fail to load on Sql Server (chenson)
0002656: [Bug] Registration request update date and time (elong)
0002659: [Improvement] AS400 should return empty string if default catalog can not be determine through meta data (josh-a-hicks)
0002660: [Bug] Postgres bulk loader would not create new tables if intial.load.create.first parameter is in use. (josh-a-hicks)
0002621: [Improvement] Slow performance of ConfigurationChangedDataRouter on trigger re-creation with many triggers (chenson)
0002519: [Improvement] DB2 triggers are not providing the source node id (josh-a-hicks)
12 issues View Issues
Released 2016-06-10
0002605: [Improvement] Document Supported Data Types Across All Platforms (chenson)
0002607: [Bug] SymmetricDS wrapper fails to log when sym_service.conf is misconfigured. (mmichalek)
0002615: [Improvement] Support commas in column names (mmichalek)
0002616: [Improvement] Tighten up default Jetty HTTP security settings (mmichalek)
0002624: [Bug] Prioritize custom extensions over built-in extensions (elong)
0002626: [Improvement] Set order of triggers to first on SQL Server to preserve order of changes (elong)
0002630: [Improvement] Enhance JdbcSqltransaction to allow for preparation and execution of sql with named parameters (gwilmer)
0002636: [Bug] Issue 0002584 in 3.7.33 broke AS/400 triggers
8 issues View Issues
Released 2016-05-17
0002595: [Bug] MSSQL Server store procedures to not include catalog. (josh-a-hicks)
0002561: [Bug] File parsing router was not writing to staging properly (josh-a-hicks)
0002570: [Improvement] DBF reader support through file sync is also syncing the file (josh-a-hicks)
0002601: [Bug] JdbcSqlTemplate NullPointerException when passing null SqlTemplateSettings (mmichalek)
0002571: [Improvement] Improve SQL Logging (mmichalek)
0002584: [Improvement] Improve capture of LOBs and wide tables on DB2 (elong)
0002568: [Improvement] Protect keystore password (elong)
0002560: [Improvement] Initial load extract job parameter to send batches immediately as they are written to staging. (josh-a-hicks)
0002553: [Bug] REST : error on calling postStartByEngine (elong)
0002557: [Improvement] Parameter to allow reload channel to block or not block other channels (elong)
0002572: [Bug] REST API removenode: cannot re-register node until after restarting SymmetricDS (mmichalek)
0002515: [Improvement] Allow configuration of sym_data create_time timezone (mmichalek)
0002575: [Improvement] Support Primary Key Updates on Sybase ASE (mmichalek)
0002576: [Improvement] Initial load extract job to account for table transforms that might increase batch sizes beyond the max (josh-a-hicks)
0002578: [Bug] Staging can clear ready batches which slows initial load (elong)
0002583: [Bug] C Client - Database Parameter Overrides not working (mmichalek)
0002585: [Bug] C Client doesn't populate failure code on RemoteNodeStatus (mmichalek)
0002589: [Bug] Extracting thousands of batches causes OutOfMemoryError during initial load (elong)
0002592: [Bug] Null pointer exception Postgres bulk loader when table is missing (elong)
0002599: [Bug] SqlScriptReader is parsing string literals from comments. (abrougher)
20 issues View Issues
Released 2016-04-06
0002559: [Bug] DB2 Trigger may shift decimal point on millisecond portion of timestamp (mmichalek)
0002550: [Bug] Typo in trigger text broke trigger generation on SQL Server (elong)
0002551: [Bug] Derby sync BLOBs when PK is character type (elong)
3 issues View Issues
Released 2016-03-29
0002542: [Improvement] Allow ignored protocols and ciphers through properties for SSL (josh-a-hicks)
0002536: [Bug] RT batches are left abandoned if routing fails (chenson)
0002524: [Improvement] Data gap detection slow when trying to expire gaps (elong)
0002535: [Bug] Some SQL has sym_ hardcoded in table name (elong)
0002532: [Bug] Some Windows environments unable to command line sym and symcc (elong)
0002534: [Improvement] Allow user to override transaction isolation level (elong)
0002541: [Bug] The SqlScript class should not try to run blank lines (chenson)
7 issues View Issues
Released 2016-03-11
0002505: [Improvement] MSSQL support for "Export Data Tier Application" (josh-a-hicks)
0002514: [Improvement] Reduce Noisy Logging (mmichalek)
0002518: [Improvement] Oracle bulk loader leaves cursors open (josh-a-hicks)
0002499: [New Feature] Add variable transform for system_timestamp_utc (elong)
0002506: [Bug] Redshift support snapshots fail (josh-a-hicks)
0002492: [Bug] Redshift bulk loader does not work with initial.create.first (josh-a-hicks)
0002501: [Improvement] File sync performance on large file system (elong)
0002513: [Bug] Extensions don't load for new nodes until restarted (elong)
0002516: [Bug] Extensions are static to server but should be local to engine (elong)
0002504: [New Feature] DBF reader support through file sync which will read to database (josh-a-hicks)
0002490: [Bug] Oracle ddl reader not escaping "_" (josh-a-hicks)
11 issues View Issues
Released 2016-02-12
0002489: [Bug] DB2 AS400 create tables on initial load is reading views as indexes (josh-a-hicks)
0002469: [Bug] routing.largest.gap.size is limited to an integer sized value, but should be a long. (mmichalek)
0002480: [Bug] Rest API uninstall does not completely uninstall a node. (mmichalek)
0002486: [Bug] Initial Load Purge Statement doesn't honor Transforms (mmichalek)
0002497: [Bug] AS400 attempts to rebuild indexes on each startup of SymmetricDS (josh-a-hicks)
0002474: [Improvement] Support json/jsonb types with indexing for sending schema (elong)
0002479: [Bug] Data gaps expire immediately, data is never routed (elong)
0002452: [Bug] Unable to synchronize longvarchar from MySQL (elong)
0002478: [Bug] Failed to route and batch on channel (elong)
0002483: [Bug] Xml Publisher: data not legal for JDOM (elong)
0002484: [Bug] Failed to route and batch on channel (latest changes) (elong)
0002471: [Improvement] Wrapper logs incorrect current working directory (elong)
0002472: [Bug] Wrapper not restarting server process (elong)
13 issues View Issues
Released 2015-12-15
0002436: [Bug] INSERT converted to UPDATE without FALLBACK conflict resolution (chenson)
0002433: [Bug] "TIMESTAMP(6) WITH TIME ZONE" is not supported by Data Loader Type of "Oracle bulk loader." (mmichalek)
0002459: [Bug] Timestamp Values may get exported with invalid format (mmichalek)
0002328: [Bug] Error during use of dbexport feature on PostgreSQL database (chenson)
0002443: [Bug] Node communication stops running a push thread for a node (elong)
0002453: [Bug] Make the precision of the fractional millisecond capture on oracle timestamps configurable or default to FF (versus FF3) (chenson)
0002454: [Bug] Use DATETIME2 in DDL when available on SQL-Server (elong)
0002455: [Improvement] Use current_timestamp instead of current_date for defaults (elong)
0002456: [Bug] Use unicode for bulk insert file on SQL-Server (elong)
0002460: [Improvement] Redshift driver support (josh-a-hicks)
0002462: [Bug] Replication does not restart after network reconnection between servers (chenson)
0002463: [New Feature] Redshift support for converting clobs to varchar max size (josh-a-hicks)
0002464: [Bug] If individual column templates are changed in a trigger template from release to release, triggers are not rebuilt (chenson)
0002465: [Improvement] Add support for Oracle's XMLType (chenson)
0002466: [Improvement] Add property to disable setting the the h2.basedir system property (chenson)
0002467: [Bug] Issue 0002367 broke insert transformations (chenson)
0002468: [Improvement] Set push.thread.per.server.count to 1. It should not have been bumped up to 100 in 2.7.22 (chenson)
17 issues View Issues
Released 2015-11-17
0002425: [Bug] SymmetricDS Android has a dependency on MySQL libraries (chenson)
0002432: [Bug] SymmetricDS can not create trigger for the table with column type of "TIMESTAMP(0) WITH TIME ZONE" (mmichalek)
0002435: [Improvement] Warning about "Skipping index" should be debug level (elong)
0002437: [Bug] Loading a 'timestamp with time zone' field into a 'timestamp' column appears to mangle the time. (mmichalek)
0002441: [Bug] Failed to read table on Firebird (elong)
0002444: [Bug] DbExport fails when using "MSSQL" Type. (mmichalek)
0002447: [Bug] Redshift create tables does not support identity columns (josh-a-hicks)
7 issues View Issues
Released 2015-10-30
0002431: [Bug] Linux service installer fails to install (gwilmer)
0002430: [Bug] Windows Service Fails to Start from sym_service start command when install directory has space in name (gwilmer)
0002424: [Bug] Lookup Router expression is not considered valid without line breaks. (josh-a-hicks)
0002427: [Improvement] Update postgres jdbc jar file to the latest version (chenson)
0002428: [Improvement] Log who has the sync triggers job locked if it is cluster locked and another node attempts to sync triggers (chenson)
0002429: [Bug] new data is bound as old data in the load filter extension point (chenson)
6 issues View Issues
Released 2015-10-23
0002408: [Bug] Error while starting sym with Java 7 (chenson)
0002416: [Improvement] Remove jmx.agent.enabled and jmx.agent.port from symmetric-server.properties (chenson)
0002421: [Bug] as400 triggers fail to execute with some clob datatypes (chenson)
0002296: [Bug] MySQL bulk loader produced invalid data file if the first column in table is binary. (chenson)
0002297: [Bug] Column names in MySQL bulk loader should be quoted (chenson)
0002409: [Improvement] Cache the sym_node_group_channel_wnd table for use during batch extract (chenson)
0002410: [Bug] Offline jobs should be initialized in the sym_lock table (chenson)
0002411: [Improvement] Order outgoing and incoming batches by create time desc in the snapshot so we get the last 5000 batches (chenson)
0002414: [Improvement] Log the sync url in debug mode (chenson)
0002419: [Improvement] When comparing column names in the model comparator case should be ignored when db.metadata.ignore.case=true (chenson)
10 issues View Issues
Released 2015-10-12
0002407: [Bug] Default generated ssl cert doesn't work with newly upgraded jetty (chenson)
1 issue View Issues
Released 2015-10-09
0002404: [Improvement] Adjusted setup installation to work with PDQ deployer (josh-a-hicks)
0002401: [Improvement] Support clobs in the oracle bulk loader (chenson)
0002402: [Bug] Oracle bulk loader should flush before processing an update or a delete (chenson)
0002403: [Bug] NodeCommunicationService can get stuck if a socket timeout occurs when acquiring the lock (chenson)
4 issues View Issues
Released 2015-10-01
0002367: [New Feature] TableTransformation operation change support for UPDATE-DML (in addition to DELETE) (chenson)
0002311: [Improvement] Don't use 503 when SymmetricDS is unavailable as some proxies return that as well. (chenson)
0002312: [Improvement] Return different error codes for when an engine is stopped or starting versus the server is too busy (chenson)
0002320: [Improvement] Bump up the default amount of memory from 256 to 1024 (chenson)
0002323: [Improvement] Don't select row_data, old_data or pk_data when routing if only default routers are assigned (chenson)
0002329: [Improvement] set http.push.stream.output.enabled=true as the default setting (chenson)
0002395: [Improvement] Delay routing exception logged as error (elong)
0002317: [Improvement] Upgrade Jetty to version 9.3.3.v20150827 (chenson)
0002363: [Bug] CHAR(x) Column Padding with whitespaces won't work if character conversion is needed to (chenson)
0002372: [Improvement] allow SQL-LookupColumnTransform access to OLD-Column values (chenson)
0002375: [New Feature] LoadFilter with SQL-Script support (chenson)
0002396: [Improvement] Provide functionality to not require context table on sqlite for threadsafe data capture (chenson)
0002397: [Improvement] Add support for Oracle interval data type (chenson)
0002399: [Bug] Oracle bulk loader should respect dataloader.max.rows.before.commit and execute database writer filters (chenson)
0002400: [Bug] Unwanted warning: Starting a new process even though the previous 'Database Pull' process ... (chenson)
0002393: [Bug] NVARCHAR limit on SQL Server is a size of 4000 (chenson)
16 issues View Issues
Released 2015-09-11
0002388: [Bug] SQLServer 2008 does not correctly create remote tables with fields of type nvarchar(max) (chenson)
0002392: [Bug] SqlScriptReader has a bug where if multiline literals in a statement have a comment at the end of the line, the comment is lost (chenson)
0001575: [New Feature] Offline data synchronization (elong)
0002368: [Bug] Null key value causes additive transform not to work (chenson)
0002374: [Bug] Memory being held up un-necessarily in StagingManager and StagedResource (chenson)
0002376: [Improvement] Add MSSQL 2008 type for datetimeoffset (chenson)
0002377: [Bug] SQLServer 2008 does not correctly create remote tables with fields of type varbinary(max) (chenson)
0002378: [Improvement] Protect against duplicate sym_data_gap entries (chenson)
0002379: [Improvement] Expose access to the SymmetricEngineHolder from the ServerSymmetricEngine (chenson)
0002383: [Bug] Audit Table Router does not handle column name case sensitivity for SQL Server (josh-a-hicks)
0002385: [Improvement] No need to create functions and enable and disable triggers on greenplum where triggers are not supported (chenson)
0002386: [Improvement] Add logging of data rows that failed to load for the oracle bulk loader (chenson)
0002387: [Improvement] Make oracle.bulk.load.max.rows.before.flush so that it does not require a restart (chenson)
0002389: [Improvement] Make sym_node.external_id bigger. Support an external.id of up to 255 characters. (chenson)
0002390: [Bug] Prevent the extract in background job from going into an endless loop if request extracting takes more than 30 seconds (chenson)
0002391: [Bug] File sync hangs forever when the tracker job breaks a hung shared lock (chenson)
16 issues View Issues
Released 2015-08-08
0002364: [Improvement] DBExport ability to produce drop only statements (josh-a-hicks)
0002313: [Bug] When SymmetricDS is stopped via REST or jmx, auto.start.engine should be set to false so the node won't restart automatically (chenson)
0002314: [Bug] dbimport of xml (XmlDataReader) does not handle xsi:nil correctly (chenson)
0002315: [Bug] Generated ddl should always escape ' with ''. MySQL and Postgres currently do not. (chenson)
0002316: [Bug] On SQL Server a default value of '' is exported as '''' (chenson)
0002318: [Improvement] Performance improvements in gap detection during routing. Improves routing performance with lots of gaps. (chenson)
0002326: [Bug] Empty reload batch causes batch to end prematurely (chenson)
0002327: [Improvement] Add an install method to the REST api that takes a properties file and installs it in the engines directory and starts the node (chenson)
0002332: [Improvement] Better logging for bsh load filter errors (chenson)
0002333: [Bug] Audit router inserts failing due to case sensitive collation (chenson)
0002334: [Bug] create triggers should take into account that the catalog or schema could be blank in database versus null (chenson)
0002335: [Improvement] Make the ISyncUrlExtension more flexible by always calling a registered ISyncUrlExtension (chenson)
0002341: [Improvement] Add the ability to use parameter values in catalog and schema for trigger, router, and transform configuration. (elong)
0002343: [Bug] A load script doesn't fire the error script if the schema is left blank on Oracle (chenson)
0002344: [Improvement] Geography data type support (josh-a-hicks)
0002350: [Bug] setting suspend=1 on sym_node_channel_ctl gets set back to 0 when extract happens (chenson)
0002351: [Improvement] Order configuration export for diff reporting (elong)
0002357: [Improvement] Need to be able to set the field terminator and record terminator for the mssql bulk loader (chenson)
0002359: [Bug] Handle nvarchar default values on sql server that start with N' during schema creation (chenson)
0002360: [Bug] Initial loads not working from source to target in the multiple source to single targets profile (chenson)
0002361: [Bug] Ignore sqlite_autoindex_ indexes in the sqliteddlreader (chenson)
0002365: [Bug] dbexport incorrectly blanks out the schema when the schema is the default schema and the catalog is not (chenson)
0001620: [Improvement] Move SymmetricDS to Github (chenson)
23 issues View Issues
Released 2015-05-31
0002308: [Bug] Bsh variables were removed from bsh column transform accidentally. Readding support (chenson)
0002306: [Improvement] Add a trim() column transform (chenson)
0002307: [Bug] Outgoing batches are missing the sql message sometimes (chenson)
3 issues View Issues
Released 2015-05-28
0002302: [Bug] AckUriHandler has an incorrect Comparator code (chenson)
0002305: [New Feature] Add new extension point that allows batches to be filtered prior to sending them (chenson)
2 issues View Issues
Released 2015-05-18
0002299: [Bug] Deadlock for additive transform. It should use the same transaction that the default writer uses. (chenson)
0002301: [Bug] If an incoming batch is marked as IG when it is loading and the batch fails, then the IG status is lost (chenson)
0002290: [Bug] Postgres bulk writer throws a null pointer error versus logging what is going on when the target table cannot be found (chenson)
0002293: [Bug] sym_node_group_channel_wnd functionality is broken (chenson)
0002294: [Improvement] Improve the bean shell database filter. pk data should be bound on deletes. (chenson)
5 issues View Issues
Released 2015-05-02
0002285: [Improvement] Slight performance improvement in reading table metadata on Firebird (chenson)
0002287: [Bug] Multiplier transform isn't working (chenson)
0002288: [Bug] The file directory listing in the snapshot is inaccurate (chenson)
0002289: [Improvement] When a node is removed, clear out its sym_incoming_batch table (versus just setting batches to OK) (chenson)
4 issues View Issues
Released 2015-04-23
0002282: [Improvement] Add create.table.without.foreign.keys setting that removes foreign keys on table definitions being used during database creation (chenson)
0002279: [Bug] Fix misleading warning. "None of the target nodes specified in the data.node_list field ({}) were qualified nodes" (chenson)
0002273: [Bug] Auto calculate of number of required batches an extract in background extract should use the initial load select (chenson)
0002277: [Improvement] Don't log a warning when there is a missing column data for a transform due to a delete when capture old data is turned off (chenson)
4 issues View Issues
Released 2015-04-16
0002265: [Bug] Xml Publisher fails when delete comes through. Null Pointer Exception. (chenson)
0002270: [Improvement] Log when an initial load or reverse initial load is queued up (chenson)
0002274: [Bug] If a row is marked as IG and an ACK comes in with an ER status the IG status is overwritten (chenson)
0002275: [Bug] Common batch mode not detected if trigger router is defined that does not use the default router and is on the same link (chenson)
4 issues View Issues
Released 2015-04-10
0002263: [Bug] Trigger is not able to be created (chenson)
1 issue View Issues
Released 2015-04-06
0002245: [Bug] Column match router should not do work during initial load if initial load select is used (chenson)
0002249: [Bug] Alter script broken on Sybase ASE because SqlScript parser leaves ; in the script (chenson)
0002251: [Improvement] If the ack response does not come back with a 200 error code, the throw an error. Before we looked for only 4 error codes. (chenson)
0002252: [Improvement] Re-add a buffer flush at the end of a push and at the end of a file push. (chenson)
4 issues View Issues
Released 2015-03-30
0002237: [Improvement] Add new auto.sync.triggers.after.config.loaded property that allows sync triggers to be turned on on client when config changes (chenson)
0002238: [Bug] Router service fails due to Syntax error (chenson)
0002239: [Bug] The xml publisher removes '-' from the key data so 'This is a test" and 'This-is-a-test' are equivalent. This is wrong. (chenson)
0002241: [Bug] Routing fails with null pointer exception (NPE) (elong)
0002242: [Bug] SQL Server fails to create triggers (chenson)
5 issues View Issues
Released 2015-03-17
0002217: [Bug] Android zip contains superflous slf4j jars (chenson)
0002231: [Bug] ; in sql scripts in sql content aren't properly parsed (chenson)
0002232: [Bug] Insert fails due to error in Trigger (chenson)
3 issues View Issues
Released 2015-03-06
0002230: [Bug] HSQLDB ddl builder doesn't creates a varbinary instead of a blob when the type in xml is blob (chenson)
0002216: [Bug] Replication of rows with NULL in large object column on PostgreSQL throws exception (chenson)
0002219: [Bug] When Primary key is binary; SymmetricDS fails capture changes. (chenson)
0002222: [Bug] BSH transform context variables overwrite column variables (elong)
0002223: [Bug] platform should pass in setting for whether to use autocommit for ddl in createDatabase and dropDatabase. (chenson)
0002224: [Bug] When external.id.is.unique.enabled=false calling symadmin open-regsitration only works for the first two nodes with the same id (chenson)
0002225: [Bug] JMX method openRegistration should behave like the command line openRegistration command (chenson)
0002226: [Bug] Sql Server 2000's default schema is the user. We had hardcoded dbo as the schema which only worked for dbowner accounts (chenson)
0002227: [Bug] Initial load create first does not support the creation of REAL columns for sqlite (chenson)
9 issues View Issues
Released 2015-02-24
0002210: [Bug] You should be able to request an initial load from a server by setting the initial_load_enabled flag on the client node. (chenson)
0002211: [Improvement] Don't insert file sync initial load batch if there are no file trigger routers configured (chenson)
0002212: [Bug] getOutgoingBatchStatus only returns pending batches for one status. It should return multiple summaries. (chenson)
0002213: [Bug] Missing space in ORDER BY CLAUSE (chenson)
4 issues View Issues
Released 2015-02-17
0002205: [Bug] Subselect router arguments are encoded on reload (chenson)
0002191: [Bug] Unrouted batches end up with a status of NE and never get purged (chenson)
0002192: [Bug] Conflict resolution of FALLBACK transforms update to insert although row exists (chenson)
0002193: [Improvement] Only run the check for abandoned batches check once after the server starts, not everytime we route (chenson)
0002194: [Bug] postgres geometry types broken by issue 1996 (chenson)
0002196: [Improvement] Bsh Data Router: Bind in nodeIds for nodes that would normally be routed to. Useful for implementing default behavior. (chenson)
0002197: [Bug] Right before a node loads registration configuration, clear out sym_data on the config channel (chenson)
0002200: [Bug] Microsoft JDBC maps nvarchar(max) and varchar(max) to a varchar with a size. Should be mapped to a longvarchar or longnvarchar. (chenson)
8 issues View Issues
Released 2015-02-11
0002186: [Improvement] DB2 iSeries - Change the sym_data row_data storage to CLOB to support longer row data (chenson)
0002187: [Bug] auto create tables doesn't support comment characters in quoted column and table names (chenson)
0002149: [Bug] Create Initial Table for MySQL - TINYTEXT (chenson)
0002185: [Improvement] Improved trigger performance on Sql Server (chenson)
4 issues View Issues
Released 2015-02-05
0002173: [Improvement] "arithmetic exception, numeric overflow, or string truncation" on firebird due to row_data being > 10k. Log a better error msg. (chenson)
0002174: [Bug] Redshift Bulkloader - S3 regions that require v4 of the authentication protocol get an error (chenson)
0002175: [Improvement] Package jt400 ibm as400/iSeries jar file with SymmetricDS (chenson)
0002176: [Bug] iSeries - Any tools that insert into sym_data cause errors because of invalid query to lookup last identity record (chenson)
0002177: [Bug] When a case sensitive collation is used on sql server alters to prevent page lock escalation fail with a warning (chenson)
0002178: [Improvement] Allow the use of wildcards in catalog and schema for load filters (chenson)
6 issues View Issues
Released 2015-02-01
0002172: [Bug] Ignore case not working due to bug in ignore case feature for schema and catalog in table lookup (chenson)
1 issue View Issues
Released 2015-01-29
0002152: [Bug] DDL errors on DB2 i5 AS/400 (elong)
0002124: [Improvement] Support foreign keys in ddl builder for sqlite (chenson)
0002148: [Bug] When checking for gap expiration compare data create times against the database time, not against the symmetric server time (chenson)
0002155: [Improvement] Reduce updates to sym_node_communication (chenson)
0002158: [Improvement] Snapshot util should just package up all files with the .log extension in the log directory (chenson)
0002159: [Improvement] Add database time and server time to support snapshot (chenson)
0002161: [Improvement] Interrupt working threads when a symmetric engine is stopped. Also check for interrupted threads when processing data. (chenson)
0002163: [Bug] Configured extension with a node group id of ALL is not working (chenson)
8 issues View Issues
Released 2015-01-20
0002135: [Bug] bsh column transform can pick up source columns from previous tables in the batch (chenson)
0002136: [Bug] Changing a primary key with an implied transform does not work (chenson)
0002139: [Improvement] Log original conflict error message if available. Makes it easier to identify root cause conflict issues. (chenson)
0002144: [Improvement] When transformed data is retransformed it should only try to match the key values if more than one transformed data is returned (chenson)
0002145: [Improvement] Do a better job of table lookup when case is suppose to be ignored. Lookup across catalogs and schemas is now case insensitive (chenson)
0002147: [Improvement] Add validation and better error message if the parsed tokens doesn't match the column count of the last parsed table (chenson)
6 issues View Issues
Released 2015-01-13
0002127: [Bug] Tinyint is 0 to 255 on Sql Server. JTDS treats it as -128 to 127. The driver throws an error for values > 127. (chenson)
0002133: [Bug] SQL Anywhere capturing wrong date format (elong)
2 issues View Issues
Released 2015-01-06
0002088: [Bug] The addition of a new symds configuration table makes registration incompatible with previous versions (chenson)
0001756: [Bug] dbimport doesn't handle relative pathnames (elong)
0001952: [Bug] NullPointerException when setting replication for an unsupported table in PostgreSQL (chenson)
0000043: [New Feature] Expressions for target_schema_name (elong)
0001621: [Improvement] Move SymmetricDS to Gradle (chenson)
0001650: [New Feature] Reverse initial load with symadmin (elong)
0001828: [Improvement] Update jTDS driver from 1.2.4 to 1.2.8 (chenson)
0001970: [Improvement] Valuemap transform syntax for passing values through (elong)
0002020: [Bug] Log4j cannot be configured to send errors by email (chenson)
0002040: [Improvement] Can't set windows service dependencies in sym_service.conf (elong)
0002047: [Improvement] Add extension service that can read extensions from database (elong)
0002048: [Improvement] Option for delayed start of Windows service (elong)
0002050: [Bug] dropping a table before dropping trigger causes NPE (chenson)
0002057: [Improvement] The sync triggers cluster lock is being grabbed every ten seconds (so initial load events are not inserted during trigger sync) (chenson)
0002060: [Improvement] We currently log data sent and received from jobs at INFO level. Do the same from the server side. (chenson)
0002063: [Improvement] Remove the getName() method from the IColumnTransform interface (chenson)
0002067: [Bug] Snapshot fails when run on nodes that are not registered (chenson)
0002092: [Bug] Should be able to remove mongo and amazon jar files and the application should still work (chenson)
0002102: [Improvement] Remove double logging of exception messages to improve log readability (chenson)
0002108: [Improvement] Add processinfo to track when symmetricds is "inserting load events" on the route job thread (chenson)
0002114: [Improvement] Upgrade sqlite jdbc library version to latest version (chenson)
0002115: [Bug] Stream lobs doesn't work with tables in a different schema when router.use_source_catalog_schema is set to 0 (chenson)
0002119: [Bug] common batch mode incorrectly detected if a table syncs bidirectionally on different channels (chenson)
0002122: [Improvement] Remove deprecated Data Gap Purge Job (chenson)
0002109: [Bug] Trigger creation fails on Sybase ASE database for CLOB,BLOB,BINARY,VARBINARY,LONGBINARY (chenson)
25 issues View Issues
Released 2014-12-26
0002078: [Bug] Service wrapper unsatisfied link error (elong)
0002090: [Bug] Informix installations fail when existing SymmetricDS tables exist due to case sensitive comparisons (chenson)
0002094: [Bug] Row deletion is not synced if table has conflict resolution by timestamp (chenson)
0002100: [Bug] getChannelStatus REST call is broken (chenson)
0002101: [Improvement] Add a property that instructs symmetricds to use PK from target tables when creating update and delete statements (chenson)
0002103: [Bug] Create table to check and allow for identity columns that are not part of PK. (josh-a-hicks)
0002104: [Improvement] Add feature to turn off the use of default values in the create schema first feature (chenson)
0002105: [Bug] Error code 2601 on Sql Server should be treated like other unique constraint errors (chenson)
0002107: [Bug] Initial load extract in background can fail when purge is set aggressively (chenson)
0002110: [Bug] On firebird ddl fails if table column switches from NOT NULL to NULLABLE (chenson)
0002111: [Improvement] When big transactions are interspersed routing requires a lot of memory which can result in OOM errors (chenson)
0002112: [Bug] When lots of unrouted data exists with small transactions, the peek ahead queue can get big and cause out of memory errors (chenson)
0002113: [Bug] sqlite trigger fails to capture data when a blank string is inserted into a datetime field (chenson)
13 issues View Issues
Released 2014-12-11
0002093: [Bug] Table structure changes, sym_trigger is updated and old table structure is used for new trigger (chenson)
0002097: [Bug] sync triggers gets called during and initial load (chenson)
2 issues View Issues
Released 2014-12-04
0002087: [Bug] Extract initial load in background doesn't work with wildcard catalogs and schemas (chenson)
1 issue View Issues
Released 2014-12-01
0002065: [Bug] Newer wins conflict resolution does not work on Android (chenson)
0001310: [Improvement] Support sql dialect 1 for firebird (elong)
0002062: [Bug] Slow SYM_DATA reads on Firebird (chenson)
0002064: [Bug] NVARCHAR field is not mapped in MySQL DDL Builder (josh-a-hicks)
0002068: [Bug] SymmetricLauncher references a MySQL string utils class. The MySQL jdbc jar file should not be required (chenson)
0002069: [Bug] MySQL DDL Builder for auto increment columns, decimal type is not valid must be bigint (josh-a-hicks)
0002076: [Bug] Synchronization is not performed if datetime column has changes in fractional seconds part (chenson)
0002077: [Bug] Sql Server and MySQL bulk database writer should use quoted identifiers around table names (chenson)
0002081: [Improvement] Disable SSLv3 (chenson)
9 issues View Issues
Released 2014-11-10
0002052: [Bug] Remove transform when used on a primary key without the pk column checked fails (chenson)
0002053: [Bug] Fallback to insert fails when transform is configured as update first on the LOAD side. Data is retransformed as an update. (chenson)
0002054: [Bug] NullPointerException happens during file sync pull (chenson)
0002059: [Improvement] Do not blindly update outgoing batch where status = RT at start of routing. Select first to see if the update is needed. (chenson)
4 issues View Issues
Released 2014-11-03
0002029: [Bug] When old data is off and a primary key is updated in the same batch where a primary key is not updated will result in a failure (chenson)
0002030: [Improvement] For initial load deletes, provide BOTH source and target node replacement variables (chenson)
0002032: [Improvement] Resolve table name in create trigger statement with default catalog and schema if source catalog and schema are not specified (chenson)
0002036: [Improvement] When a router fails to route a data row, no information is logged about the failed data row (chenson)
0002041: [Bug] Initial load failing on Interbase because of "Implementation limit exceeded. Block size exceeds implementation restricti (chenson)
0002042: [Bug] Create of data_id trigger on sym_data fails on firebird and interbase if db.delimited.identifier.mode=false (chenson)
0002043: [Bug] The "other" data type template for Postgres should escape string values just like the string template. (chenson)
0002046: [Improvement] Add left and bleft column transforms (chenson)
8 issues View Issues
Released 2014-10-27
0002009: [Bug] Java column transform cannot compile inner classes (elong)
0002027: [Bug] Firebird detection of auto increment columns should look for existence of trigger, not the generator itself (chenson)
0001286: [Bug] Failed to create trigger when table contains timestamp with time zone column in Oracle (chenson)
0002010: [Bug] Initial load failing on Firebird because of "Implementation limit exceeded. Block size exceeds implementation restriction" (chenson)
0002011: [Improvement] Automatically handle conversion from Time to Timestamp during data load (chenson)
0002014: [Bug] Stopping service from sym_service on Windows does not stop wrapper (elong)
0002016: [Bug] On some platforms (sybase) sql fails when numeric column names are used in the where clause of initial load sql (chenson)
0002017: [Improvement] Log the DDL that installs functions required for SymmetricDS as it is being installed (similar to the way we log table DDL) (chenson)
0002018: [Improvement] Translate sql server's getdate() function to current_timestamp when used as a default value in building ddl for other platforms (chenson)
0002022: [Improvement] Add redshift.append.to.copy.command which allows the options to be passed to the copy command for the red shift bulk loader (chenson)
0002023: [Bug] bsh router is broken when capture old data is turned off (chenson)
0002024: [Bug] Should not have to specify properties file for symadmin command if only one properties file exists (chenson)
12 issues View Issues
Released 2014-10-09
0001997: [Bug] Excessive logging from PropertiesFactoryBean (elong)
0001998: [Bug] Support ntext type on sql server with the JTDS driver (chenson)
0001999: [Bug] Server can hang when database is unavailable while attempting to handle connection attempt from client (chenson)
0002000: [Bug] SymmetricDS startup fails. Check for existence of sym tables isn't limited to the default catalog and schema at start up (chenson)
0002002: [Bug] delete and update transforms are broken when dealing with compound primary keys (chenson)
0002004: [Bug] Multiplier transforms don't use correct old data (chenson)
0002006: [Improvement] Add dataloader.apply.changes.only property that control whether update statements will update all columns or only changed column (chenson)
7 issues View Issues
Released 2014-09-30
0001996: [Improvement] Support JSON data type. Map all Types.OTHER to LONGVARCHAR for Postgres. (chenson)
0001942: [Bug] PostGIS initial load fails unless you set initial.load.concat.csv.in.sql.enabled=true (chenson)
0001969: [Bug] Integer conversion between Oracle and PostgreSQL maps to wrong type (chenson)
0001977: [Bug] The bean shell router swallows errors and does not route the data (chenson)
0001978: [Bug] NullPointerException in ColumnsToRowsValueColumnTransform (chenson)
0001979: [Bug] Broken replication on tables with uuid field (chenson)
0001980: [Improvement] Report script line number for bsh transforms and bsh routers (chenson)
0001983: [Improvement] Better document reverse initial load (chenson)
0001984: [Bug] Wrong key values can be returned when load transforms don't put keys at beginning of transform list (chenson)
0001986: [Improvement] REST call for reading parameters (elong)
0001987: [Improvement] Add extension for filtering parameters as they are saved (elong)
0001988: [Bug] Default values for ARRAY types on Postgres cause create tables to fail (chenson)
0001989: [Bug] Switching cluster locks off causes initialization error (elong)
0001993: [Improvement] Add support for composite data types in postgres (chenson)
0001994: [Bug] Time columns in postgres should be captured as time only. Date is currently captured which breaks the postgres bulk loader (chenson)
0001991: [Improvement] Allow override of startup parameters (elong)
16 issues View Issues
Released 2014-09-17
0001950: [Bug] Reinsert of sym_data_gap after it has been purged can fall outside of captured sym_data range (chenson)
0001953: [Bug] Transform column value to NULL removes column (chenson)
0001959: [Improvement] Add feature where character data can be modified by an property expression in order to support "weird" character issues (chenson)
0001961: [Bug] Routing does not stop when sym_channel.max_data_to_route is reached and batch_algorithm is set to nontransactional (chenson)
0001962: [Bug] Log the actual values that were passed to prepared statement in the default data loader (currently logs those passed in csv) (chenson)
0001963: [Bug] Memory issue on nontransactional channel during routing (chenson)
0001964: [Bug] Upgrade from 3.1.5 to 3.6 fails on MySQL (chenson)
0001965: [Bug] Initial load uses wrong case on Oracle to PostgreSQL table creation. (chenson)
0001966: [Improvement] Add better logging when a subselect router query fails. Log table and event for which the query failed. (chenson)
0001968: [Bug] Oracle LONG types don't work when stream_to_lob is turned on (chenson)
0001971: [Bug] Missing AWS java SDK needed for Redshift bulk load (elong)
0001973: [Bug] Use LSB-compliant dependency in init script (elong)
0001974: [Bug] fallback to update fails with implied load transform that adds to pk (chenson)
0001975: [Bug] Push service continues to quickly attempt to push data on failure to read ack condition during initial load (chenson)
14 issues View Issues
Released 2014-09-02
0001940: [Bug] On MySQL sym_transaction_id_post_5_1_23 function should not be checking the autocommit session variable (chenson)
0001946: [Bug] ConcurrentModificationException due to timing issue in OutgoingBatchService (chenson)
2 issues View Issues
Released 2014-08-27
0001920: [New Feature] Redshift database dialect (elong)
0001869: [Bug] The symmetric wrapper kills the process when an OOM error occurs before the heap can be dumped (elong)
0001907: [Improvement] Add the ability to republish xml messages via jmx (chenson)
0001910: [Bug] Too many connections when network environment is bad. Bug in DBCP. (chenson)
0001917: [Improvement] SymmetricDS should find tables in schemas and catalogs other than the default schema/catalog when schema/catalog is left blank (chenson)
0001921: [Bug] While sending a batch, if a batch is set to IG and an error occurs, then the batch gets set to ER and the IG status is ignored (chenson)
0001922: [Bug] Incorrect conversion of values of type BIT in SQL Server 2005 to SQLite (chenson)
0001925: [Bug] Send Table Schema uses cached tables (chenson)
0001926: [Improvement] Add dataloader.fit.to.column that when set will truncate data to fit in the target column (chenson)
0001929: [Bug] Routing reader can get stuck if an Error is thrown during the close of the read cursor (chenson)
0001930: [Bug] Upgrade from 3.5 to 3.6 of Sybase ASA fails (chenson)
0001935: [Improvement] Upgrade mongodb java client (chenson)
0001938: [Improvement] Add the ability to copy a node to a new node id (chenson)
13 issues View Issues
Released 2014-08-11
0001668: [Bug] PostGIS Spatial data replication fails with SRID problem (chenson)
0001860: [Bug] symmetric-wrapper should not include the version number, otherwise the service needs to be reinstalled on each upgrade (elong)
0001868: [Bug] Introduce a more accurate way to get a machine's hostname (chenson)
0001870: [Improvement] Include directory listing of symmetricds installation in snapshot (chenson)
0001873: [Bug] Control Center doesn't start on Windows if not Administrator (elong)
0001875: [Improvement] Add extensions.xml property which can be used to configure symmetric extensions (like jms) via database configuration (chenson)
0001877: [Bug] Process status can be stranded in non-ok or non-error status on pull if an io expection occurs in the uri handler (chenson)
0001879: [Bug] Database upgrade fails on sql server because drop index doesn't allow database name in the ddl (chenson)
0001881: [Bug] MS Azure does not support the sysconstraints view (chenson)
0001886: [Bug] SymmetricDS upgrade on Azure fails. (chenson)
0001887: [Bug] http.concurrent.workers.max doesn't prevent the same node from over pulling on itself (chenson)
0001888: [Improvement] Improve stagedresource (chenson)
0001889: [Improvement] Add reverse version of initial load before/after sql (elong)
0001892: [Bug] New version of Postgis fails to replicate (chenson)
0001893: [Improvement] Log information about failed column transform to make it easier to debug transforms (chenson)
0001894: [Improvement] Make lookup transform column names case insensitive when used as named parameters in sql (chenson)
0001895: [Improvement] Add support for token replacement for $(sourceCatalogName) and $(sourceSchemaName) in lookup table transform (chenson)
17 issues View Issues
Released 2014-08-02
0001867: [Bug] Windows service won't stop (elong)
0001852: [Bug] When a table has multiple transforms, the order of execution should be reversed when a delete comes through the system (chenson)
0001853: [Improvement] Clear staging if transformation changes come through the data loader or data router (chenson)
0001856: [Bug] Bsh variables for transformedData and transformColumn not being updated (elong)
0001857: [Bug] Initial load is broken for the master to master sync scenario (chenson)
0001859: [Improvement] Document that a -1 node id in outgoing batch means that the batch was unrouted (chenson)
0001863: [Bug] Triggers get blown away when saving a link for an individual table. broke with 0001827 fix (chenson)
7 issues View Issues
Released 2014-07-29
0001827: [Bug] Long Oracle tables generate ORA-04095 on trigger creation (chenson)
0001845: [Bug] The transaction id for sybase ase isn't always unique (chenson)
0001846: [Improvement] Update router helper methods that get column values use a case insensitive map (chenson)
0001805: [Improvement] Add support for mysql enums in dbfill (chenson)
0001806: [Bug] dbfill only inserts 1 char for char fields. It should respect the size of the char field (chenson)
0001807: [Bug] dbfill mishandles clob fields (chenson)
0001808: [Bug] '0000-00-00 00:00:00' fails when initial.load.concat.csv.in.sql.enabled=false and db.treat.date.time.as.varchar.enabled=true (chenson)
0001812: [Bug] bit type in should be mapped to a bit type in mysql. not a tinyint(1) (chenson)
0001814: [Bug] NullPointerException in AbstractTriggerTemplate.createInitalLoadSql (chenson)
0001818: [Bug] sym script error with Java 5 detection (elong)
0001820: [Improvement] Add property that instructs symmetric to keep the same node_password for a node on re-registration (chenson)
0001821: [Improvement] Add the ability, through configuration, to specify a system commands to dump and load a database's schema during initial load. (chenson)
0001829: [Bug] dbexport doesn't respect "use quoted identifiers" for schema exports (chenson)
0001830: [Bug] sql server needs to explicitly ALLOW_PAGE_LOCKS = OFF if mssql.allow.only.row.level.locks.on.runtime.tables is set (chenson)
0001831: [Improvement] Add new property that instructs the data loader to alter the case of db artifacts being created to the default case of the db. (chenson)
0001832: [Bug] Null values aren't being passed through transforms (chenson)
0001619: [Improvement] Stabilize the Sybase unit tests. (chenson)
0001811: [Improvement] Add new transform types that will put the source catalog, schema or table names into a column (chenson)
0001823: [Improvement] DB2 sync trigger variables should use prefix (elong)
0001833: [Bug] ASE 12.5 create triggers in a multi-statement fails (chenson)
0001836: [Bug] The removal of a node isn't synchronized to other nodes in a master to master scenario (chenson)
0001837: [Bug] If the engine isn't found, the logging context should be '?', not the previously handled symmetric engine name for that thread (chenson)
0001839: [Improvement] Global BSH script for transforms (elong)
0001841: [Bug] Update registration request doesn't work on sql server with the latest microsoft jdbc driver (chenson)
0001842: [Improvement] Additional transform variables for bsh (elong)
0001843: [Bug] Oracle dialect has static "sym" prefix on objects (elong)
0001844: [Improvement] Make picking conflict detection strategy case independent when matching tables (chenson)
27 issues View Issues
Released 2014-07-12
0001755: [Bug] XML Data (schema and data) is not properly escaped. (chenson)
0001758: [Bug] PostgreSQL default value for 'uuid' field type (chenson)
0001781: [Bug] Uninstall fails if file sync is configured (chenson)
0001782: [Bug] initial.load.create.first fails for tables with a unique index on the primary key (chenson)
0001783: [Bug] A default value of (sysdate) should not translate to '(sysdate)' in the create statement when initial.load.create.first is on (chenson)
0001785: [Bug] Hard coded EXECUTE AS OWNER in Sql Server triggers causes issues if the tables are created under another account (chenson)
0001787: [Bug] Reverse initial load is broken in 3.6 (chenson)
0001789: [Bug] external.id.is.unique.enabled property is defined backwards. It is being used opposite of the definition. (chenson)
0001790: [Improvement] Add REST service to send schema changes (chenson)
0001793: [Bug] When the stream.to.file.threshold.bytes is reached and the staging manager writes the buffer to a file the buffer is not removed (chenson)
0001794: [Bug] Fix null pointer on busy system during staging area clean (chenson)
0001795: [Bug] DDL modification in schema different than symetricds one (chenson)
0001796: [Bug] Unable to parse ISO-8601 datetime on sqlite (chenson)
0001797: [Bug] sym_table_reload_request should be cleaned up when a node is deleted (chenson)
0001798: [Improvement] Add support for wildcarded catalogs and schemas (chenson)
0001801: [Bug] DbExport does not handle timestamp(9) on Oracle (elong)
0001802: [Bug] DbExport does not handle BLOB on DB2 (elong)
0001803: [Bug] Removing a node using engine.removeAndCleanupNode method on a master to master cluster does not send the remove to other nodes (chenson)
0001804: [Bug] sym_node_host on the heartbeat channel can cause FK errors when a node is removed (chenson)
19 issues View Issues
Released 2014-06-26
0001734: [Bug] Audit table created with wrong schema (chenson)
0001771: [Bug] Add support for ansi literal default date values. Also support well known sql 92 function types for the default values (chenson)
0001772: [Bug] Custom IColumnTransform weren't being marked as installed. (chenson)
0001776: [Bug] Postgres should auto commit ddl changes. Otherwise, if a ddl fails to run it cannot continue to move forward. (chenson)
4 issues View Issues
Released 2014-06-16
0001735: [Improvement] Transforms write out the start of a table before every row which is inefficient and causes bulk loaders to become unusable (chenson)
0001737: [Improvement] Trim numeric values before parsing into primitive to handle situations where the source db might have whitespace prepended (chenson)
0001738: [Improvement] Introduce a new columntransform type that returns both new and old data. use it for the copy transform (chenson)
0001441: [New Feature] Add ability to sync on control file (chenson)
0001485: [New Feature] Create a delete_after_sync function for file sync (chenson)
0000166: [New Feature] Integrate changes to support spatial data replication using http://postgis.refractions.net/ (elong)
0001581: [New Feature] Add support for multiple channels for file sync (chenson)
0001609: [Improvement] File sync mutex limits scaling multiple clients (elong)
0001637: [Improvement] Refactor databasewriter into abstractdatabasewriter and defaultdatabasewriter so we can subclass off of abstract databasewriter (chenson)
0001642: [Bug] Triggers referencing tables with case sensitive schemas fail to create on H2 (chenson)
0001643: [Improvement] Support multiple reload channels (chenson)
0001647: [New Feature] Create a Java router, transform, and load filter that uses compiled Java code (elong)
0001648: [New Feature] Add support for choosing the channel a trigger/table will use dynamically (chenson)
0001653: [Improvement] Allow downgrades within same minor version (elong)
0001654: [Bug] Restarting server crashes due to primary key violation (elong)
0001655: [Bug] host.bind.name has no effect when running stand-alone (elong)
0001656: [Improvement] PostgreSQL server side prepared statements causing slow query processing (elong)
0001658: [Improvement] Add sync triggers by table to REST API (elong)
0001371: [Improvement] Add a drop triggers feature (elong)
0001467: [Bug] trigger creation failed with MSSQL database column of nvarchar and ntext data type using the microsoft jdbc driver (chenson)
0001592: [New Feature] Create bulk loader for MySQL (elong)
0001652: [Improvement] Add BLOB support to PostgreSQL bulk loader (elong)
0000952: [Bug] Data can be skipped due to aggressive purge on some platforms (chenson)
0001240: [Bug] No way to send schema changes in schema other, than public (elong)
0001606: [New Feature] Create dialect for DB2 z/OS (elong)
0001624: [Improvement] Add setting to sym_node_group_link to prevent clients from updating configuration (chenson)
0001626: [Improvement] Create event should not store XML is row data (elong)
0001644: [Improvement] SQL Optimizations (chenson)
0001660: [Bug] Table creation generates wrong syntax when source is SQLServer (josh-a-hicks)
0001661: [Improvement] Parameter to collect router statistics (elong)
0001665: [Improvement] Upgrade JDBC drivers (elong)
0001678: [Improvement] Make trigger id column size larger (chenson)
0001689: [Improvement] While routing config changes sync triggers by id that haven't already been sync'd versus calling syncTriggers() (chenson)
0001691: [Improvement] Additional Logging for compliance (chenson)
0001699: [Bug] Changing Trigger results in Error om Tables with an uppercase letter (chenson)
0001700: [Improvement] Parameterized the node Id assignment directly from external Id (josh-a-hicks)
0001701: [Improvement] Re-add support for db.spring.bean.name (chenson)
0001705: [Improvement] Improve initial load query performance (chenson)
0001707: [Bug] Trigger for all tables * is not creating triggers for some of the tables (chenson)
0001717: [Improvement] IReloadListener should be passed the current loadId for use (chenson)
0001718: [Bug] If a node is deregistered by deleting it's sym_node* records and it is registered it will route and sync the deletes (chenson)
0001721: [Improvement] Heartbeat immediately after registration so node information doesn't have to wait for next heartbeat to show up at reg server (chenson)
0001727: [Bug] 100% CPU when expiring SYM_DATA_GAP with missing SYM_DATA (chenson)
0001224: [Task] Remove dependency on java service wrapper (elong)
0001615: [Improvement] Figure out a way to make the usage of source schema and catalog more user friendly (elong)
0001618: [New Feature] Create a MongoDB data loader for SymmetricDS (chenson)
0001723: [Improvement] Unique constraint violation is not logged for tables declared for conflict detection (chenson)
0001729: [Bug] create of table with a varchar/char column with a default values of: ('N') fails to create table on client side (chenson)
0001742: [Bug] Fix SQLServer 2005 issue where defaults for BIGINT's are being read with an extra "." at the end. (gwilmer)
0001743: [Improvement] package android dependency jars in zip under the libs directory. not lib. it is misleading because eclipse adk requires libs (chenson)
0001744: [Improvement] NodeService.deleteNode should remove delete from all ancillary tables (in addition to node, node_security and node_host) (chenson)
0001746: [Improvement] Add jdbc driver version to sym_node_host (chenson)
0001748: [Task] Remove auto increment from sym_trigger_hist and sym_extract_request. Use sym_sequence to get the pks. (chenson)
0001749: [Bug] Incoming ProcessInfo is not marked as ERROR when a batch ERROR occurs. It is marked as OK. (chenson)
0001750: [Task] Upgrade the spring framework to the latest released version (chenson)
0001752: [Improvement] Date format setting in triggers (chenson)
0001757: [Bug] java.lang.NumberFormatException w/ MSSQL and BIT column (chenson)
0001759: [Bug] PostgreSqlTriggerTemplate not handling timezone fractional minutes properly when timezone minute < 10 (gwilmer)
0001760: [Improvement] increase channel_id size (chenson)
0001762: [Bug] old data showing up as an array of nulls versus an array that is null causes a code path to be missed that strips out pks (chenson)
0001764: [Improvement] Add parameter to disable sync triggers at server startup (chenson)
0001765: [Bug] Uninstalling symmetric from the database staging area doesn't get wiped out (chenson)
0001766: [Bug] nvarchar data can be corrupted when the default database collation is set to a value that does not support double byte character (chenson)
0001767: [Improvement] On sql server build triggers with "execute as owner" so less grants are need for application users (chenson)
64 issues View Issues
Released 2014-05-27
0001367: [New Feature] Create bulk loader for SQLServer (gwilmer)
0001712: [Bug] null pointer at startup when sync.url is null in the database (chenson)
0001713: [Improvement] Add initial.load.before.sql and initial.load.after.sql which can contain sql that runs on the client before and after a load (chenson)
0001722: [Bug] Trigger errors for large numerics on SQL Server: Arithmetic Overflow Error (josh-a-hicks)
0001671: [Improvement] Cache node group links (chenson)
0001708: [Improvement] Disable page level locking and enable row level locking on sym_data and sym_data_event (chenson)
0001714: [Bug] The keystore type should be settable via a system property. It is currently hardcoded. (chenson)
0001715: [Improvement] Add a new column transform that can be used to set a column to the value from a SymmetricDS parameter (chenson)
0001725: [Improvement] MSSQL Bulk Loader support for UNC paths (elong)
0001726: [Bug] When trigger.update.capture.changed.data.only.enabled is enabled on SQL Server and old data capture is off, updates don't work (chenson)
0001728: [Improvement] MSSQL Bulk Loader support for columns in different order (elong)
11 issues View Issues
Released 2014-04-28
0001697: [Bug] Extract millis aren't captured on outgoing batch when initial.load.use.extract.job.enabled is true (chenson)
0001299: [Improvement] Transforms should be case insensitive when matching catalog, schema, tablename and columns to make configuration much easier (chenson)
0001649: [Improvement] Default auto.reload.sym.tables.on.upgrade to false (chenson)
0001672: [Bug] network_millis on outgoing batch is incorrect (chenson)
0001673: [Bug] snapshot functionality null pointers in open source (chenson)
0001684: [Improvement] Passing the correct data type to select data statement improves performance on Postgres (chenson)
0001685: [Bug] early commit doesn't work when data rows are in conflict. the uncommitted count doesn't increment (chenson)
0001698: [Improvement] Provide the ability to pass the load time and network time to be populated in outgoing batch via the rest service (chenson)
8 issues View Issues
Released 2014-04-14
0001667: [Improvement] Support capturing only changed data (trigger.update.capture.changed.data.only.enabled) on SQL Server (chenson)
0001651: [Bug] MySQL and SQL-Server bulk loaders handle BLOBs between different platforms (elong)
0001662: [Bug] SqlUtils is not thread safe. Can result in OOM errors. (chenson)
0001664: [Bug] NullPointer with MSSQL Bulk Loader (elong)
0001666: [Bug] SQL Server bulk loader does not handle comma (elong)
5 issues View Issues
Released 2014-03-16
0001636: [New Feature] Add capture changed data only to Postgres (elong)
0001629: [Improvement] SQL Server bulk loader option to fire triggers (elong)
0001630: [Bug] SQL Server bulk loader extra spaces causes truncation error (elong)
0001631: [Bug] CSV is missing "columns" row when two different sets of columns are being used with three different inserts or updates (chenson)
0001632: [Bug] SQL Server bulk loader does not handle BLOB (elong)
0001633: [Bug] MySQL bulk loader error with Windows-based server (elong)
0001634: [Improvement] Snapshot utility properties show changes, remove passwords, and sort (elong)
0001638: [Improvement] REST call for client to know how many batches and rows are waiting (elong)
0001639: [Improvement] MySQL and SQL-Server bulk loaders loading rows multiple times (elong)
0001645: [Bug] MySQL bulk loader does not load NULL (elong)
0001646: [Bug] MySQL bulk loader columns out of order (elong)
11 issues View Issues
Released 2014-03-02
0001586: [Bug] Stage manager doesn't check to see if a file is actually deleted when it qualifies for cleaning. (chenson)
0001593: [Bug] Background initial load extract can get stuck. (chenson)
0001597: [Bug] Overlapping database pull processes after connection outage - Default pull.thread.per.server.count=1 (chenson)
0001601: [Improvement] Add Map-based methods to TransformData so one can more easily lookup target transform data (mhanes)
0001602: [Improvement] Allow old source values to be accessible to other column transforms than just copy column (mhanes)
0001603: [Improvement] Create new 'copy if the value has changed' column transform (mhanes)
0001604: [Improvement] Create a set of two transforms that can map a series of columns to a series of rows based on a Map (mhanes)
0001608: [Improvement] Reduce default purge retention period (elong)
0001610: [Bug] CopyIfChangedTransform should only evaluate on non-delete DML (mhanes)
9 issues View Issues
Released 2014-02-15
0001562: [Bug] Routing using TransactionId causes bad routing when H2 DB is restarted (chenson)
0001420: [Task] Generate parameter documentation automatically from symmetric-default.properties. (elong)
0001566: [Improvement] Column match router support for "contains" and "not contains" (elong)
0001578: [Bug] Jobs can lock up if jobs.synchronized.enable is on and routing.peek.ahead.window.after.max.size is smaller then data rows (chenson)
0000810: [Improvement] symadmin reload-table - pass multiple tables (elong)
0001568: [Bug] NullPointerException when initial.load.create.first is on using wildcard trigger definitions on postgres (chenson)
0001455: [Bug] Audit tables don't get created (chenson)
0001484: [Improvement] Firebird trigger should be created at a position other than 0 so that users can define triggers that fire before the sym trigger (chenson)
0001565: [Bug] Ambiguous reference to sysindexes (elong)
0001567: [Bug] Transforms that are symmetric aware can get the wrong symmetric engine when multi-homed (chenson)
0001569: [Bug] System clock goes too fast (elong)
0001572: [Bug] Windows Problem Calling sym.bat from Another Drive (chenson)
0001573: [Bug] Peek ahead window smaller than expected (chenson)
0001574: [Bug] Too many routers are run when file sync targets more than one node group (chenson)
0001576: [Improvement] File Sync's default batch algorithm should be nontransactional (chenson)
0001579: [Bug] target_base_dir can be null in file_trigger. causes null pointer in filesyncservice save of snapshot due to / replacement (mhanes)
0001580: [New Feature] Expose the relative target directory as a variable that can be scripted in order to flatten the directory structure in file sync (chenson)
0001583: [Improvement] Create new value map column transform (mhanes)
18 issues View Issues
Released 2014-02-05
0001559: [Improvement] If there are no primary keys defined when the database writer is processing an update or delete report an error. (chenson)
0001553: [Bug] REST API HEARTBEAT returning NotAllowException (chenson)
0001556: [Bug] Wildcard triggers for tables with same name in different catalog/schema (elong)
0000677: [Improvement] Allow the sym commands to be added to PATH and be called from any location (elong)
0001542: [Improvement] Need a math transform for transforming columns. (abrougher)
0001543: [Bug] Upgrade of schema from 3.3 to 3.5 on H2 fails (chenson)
0001544: [Bug] API - transactions aren't being committed in the sequence service api for applications (outside of symmetricds) that use the api (chenson)
0001545: [Improvement] Unlock should use symmetricds server time, not database time, for consistency. (chenson)
0001546: [Bug] Table definition does not update correctly (postgresql) (chenson)
0001548: [Bug] Subdirectories with file sync from Windows to Linux has backslashes (elong)
0001549: [Bug] Delete of file is not synced (chenson)
0001550: [Bug] Sybase ASE : Lost precision from Datetime fields (elong)
0001555: [Bug] API - ddl of type CLOB for sql server tries to change the column type on restarts (chenson)
0001529: [Bug] Columns in old data are not transformed causing conflict detection (chenson)
0001558: [Improvement] Add the ability to use the old column value to the list of variable column transform options (mhanes)
0001561: [Task] Example of configuring log4j to send errors over email (elong)
16 issues View Issues
Released 2014-01-22
0001319: [Bug] Symmetric databases install fails on Postgres (elong)
0001536: [Improvement] Change to sync.url not picked up (elong)
0001538: [Bug] Target schema and catalog are not picked up on second router to the same node if different from the first router (chenson)
0001539: [Bug] Fix *nix sym and setenv shell scripts after bug introduced in 3.5.14 (elong)
4 issues View Issues
Released 2014-01-17
0001434: [Improvement] Build up classpath differently so path too long error isn't encountered in windows (elong)
0001518: [Bug] rebuild of trigger hist fails on some platforms (postgres, firebird, oracle) when upgrading from 3.1 to 3.5 (chenson)
0001520: [Improvement] Add further details about Linux installation as a service options (mhanes)
0001521: [Improvement] For system snapshot capture not only outbound table definitions, but also incoming table definitions (chenson)
0001524: [Improvement] When applying a SQL event, support multiple SQL statements. Support additional replacement tokens. (chenson)
0001527: [Improvement] Add information about data gaps to the snapshot (chenson)
0001528: [Bug] Routing can get stuck if there are lots of gaps that range across a large amount of data that has already been routed (chenson)
0001531: [Bug] isDataGapExpired() in DataGapDectector can leave old gaps if the next data id is not present (chenson)
0001532: [Bug] integer value logged correctly at server, but inserted as different value at client (chenson)
0001533: [Bug] Unable to create trigger if primary key column excluded (chenson)
0001534: [Bug] API - createTriggersOnChannelForTables() fails when it encounters a table name that is longer than 50 characters (chenson)
11 issues View Issues
Released 2014-01-06
0001497: [Bug] Missing primary key with Stream Lobs causes initial load to fail (mhanes)
0001513: [Improvement] Add API Operation description to the REST API (mhanes)
0001514: [Bug] Stream Lobs for SQL Server fails with bad trigger syntax (mhanes)
0001496: [Bug] Triggers not created when "handle key updates" enabled (mhanes)
0001498: [Bug] Table reload broken on Sybase ASA 9 (elong)
0001502: [Improvement] Assign a load id to batches that contain reload events when the batch is created during routing (chenson)
0001504: [Improvement] Add variables to initial load delete SQL (elong)
0001505: [Task] Add blurb about the resolve_row_only column's functionality in the NEWER_WINS resolve type documentation. (chenson)
0001506: [Bug] NullPointerException on Android when INTENTKEY_PROPERTIES is not provided in the Intent when starting service (chenson)
0001507: [Improvement] API Improvement - Added getTableTypes() to IDdlReader (chenson)
0001511: [Bug] Firebird TIME fields don't synchronize properly because of the fractional seconds component (chenson)
0001512: [Bug] sqlscriptreader has bug where tokens aren't replaced if the script has a single sql statement with no end of statement token (chenson)
0001469: [Bug] Time and Timestamp field issues on Firebird and Postgres databases (chenson)
13 issues View Issues
Released 2013-12-18
0001490: [Improvement] Background extract process currently just handles one request at a time. Change to handle multiple requests. (chenson)
0001491: [Bug] Mark outgoing batches as OK during the start of an initial load can hang until the config channel has been pulled (chenson)
0001492: [Bug] Staging manager bases purging of staging files based on create time of the resource, not the last modified time of the file. (chenson)
0001466: [Bug] REST API - setting the target schema and/or catalog does not work when using the REST API (chenson)
0001468: [Bug] Sync triggers on Oracle: Maximum open cursors exceeded (elong)
0001471: [Bug] Reload from TABLE_RELOAD_REQUEST does not support deletes (elong)
0001472: [Bug] Node Ids don't work in URLs if they have spaces in them. Need to urlencode the node id. (chenson)
0001473: [Bug] Oracle DDL Util issue isn't correctly recognizing varchar2() columns (chenson)
0001474: [Bug] sync blocks with java error when a field with affinity 'INTEGER' contains a (empty) string (chenson)
0001479: [Improvement] When using DmlStatement if columns are not provided then generate a select * for the SELECT_ALL type (chenson)
0001480: [Bug] SymmetricEngineHolder doesn't update engine count when installing a new engine (mhanes)
0001481: [Bug] Updates and Deletes can fail when a transform exists that have PKs where the source and target column names are different (chenson)
0001486: [Bug] File Sync "sync_on_delete" not honored. (chenson)
0001488: [Bug] If a create event and update event for a file happen in the same batch the building of the zip file fails (chenson)
0001489: [Improvement] Don't log stack trace on a file sync conflict. Just log the message. (chenson)
0001465: [Bug] REST API - default schema and/or catalog are filled in for generated sql statement even if they are blank in sym_trigger (chenson)
0001475: [Bug] Replication From Branch to Central Broken (Firebird at Both Ends) (chenson)
17 issues View Issues
Released 2013-11-15
0000575: [Bug] Triggers are created without transaction_id function when auto.config.database=false (chenson)
0001269: [New Feature] Update ddl utils xml to support specific database types so create schema commands replicate the same schema on same databases (chenson)
0001448: [Improvement] Provide global parameter to specify that BSH database writer filters will handle missing tables (mhanes)
0001449: [Improvement] Add support for allowing a database writer filter to change the target tables catalog, schema and table name (chenson)
0001450: [Bug] ignore case parameter should apply to only the table (not schema and catalog) for now in the load filter (chenson)
0001451: [Improvement] Expose apis to prefix a Database and read a list of Table from the physical database (chenson)
0001457: [Bug] PostgreSQL timestamp with timezone columns won't sync for very old, European dates. (mhanes)
0001460: [Bug] On postgres, when sync triggers is run from symadmin tool the generated triggers put null into the transaction id field (chenson)
0001462: [Bug] Stored procedure with NOCOUNT is rolled back (elong)
0001458: [Improvement] Add support for Oracle's TIMESTAMP WITH LOCAL TIME ZONE data type (chenson)
10 issues View Issues
Released 2013-10-20
0001429: [Bug] sym_pkg is hard coded in the oracle dialect so the prefix parameter doesn't work on Oracle (chenson)
0001438: [Improvement] Improve memory footprint usage when big lobs are in flight (chenson)
0001440: [Improvement] Implement simple conflict resolution for file sync (chenson)
0001442: [Bug] Statements are being prepared too often. Results in poor data loading performance on Firebird (and possibly other platforms) (chenson)
0001447: [Improvement] Change error message if a batch fails to transport because of an EOF error to be more intuitive. (chenson)
5 issues View Issues
Released 2013-10-10
0001430: [Bug] When a file is modified on Windows it is not unpacked at the target of a file sync (chenson)
0001431: [Bug] SQLite primary keys only recognized when they are in column position 1. (mhanes)
0001433: [Improvement] Expose api so a single sym table and single trigger can be installed without other SymmetricDS configuration (chenson)
0001436: [Improvement] Set table name on processinfo before attempting extract query for initial load (chenson)
0001437: [Bug] Multi-homed temp file system should be keyed by engine name to prevent collisions (mhanes)
5 issues View Issues
Released 2013-09-24
0001426: [Bug] Postgres datetime with timezone not formatted correctly when timezone_hour offset = 0 and timezone_minute offset < 0 (gwilmer)
1 issue View Issues
Released 2013-09-14
0001414: [Improvement] Add build information to Manifest and use it from AbstractVersion to get version information. Add build time to the version api (chenson)
0001412: [Bug] Numeric(15,5) type columns are truncated when written to Sybase dialects. (abrougher)
0001416: [Improvement] TriggerRouterService should cache a list of TriggerRouter's for each channel instead of querying db each time. (abrougher)
0001419: [Bug] USE_STREAM_LOBS=1 in Oracle does not replicate LOB data (chenson)
0001413: [Bug] SymmetricDS not returning the fully qualified hostname (abrougher)
5 issues View Issues
Released 2013-09-05
0001356: [Bug] money field type with PostgreSQL (chenson)
0001409: [Bug] The database uninstall feature does not remove the sym_ H2 trigger tables. (abrougher)
0001410: [Bug] When USE_CAPTURE_OLD_DATA is not set, the database writer will not update non null columns to null. (abrougher)
3 issues View Issues
Released 2013-08-27
0001381: [Bug] transform_table.target_table_name should be optional according the documentation. the transform code requires that is be set (chenson)
0001395: [Improvement] When data is transformed the old values are not retained. (abrougher)
0001397: [Improvement] Conflict detection mechanism USE_CHANGED_DATA should be able to specify columns to ignore. (abrougher)
0001399: [Bug] Config and heartbeat batches can be lost if initial load is scheduled (chenson)
0001400: [Bug] Implied transforms are not implying individual DML transforms. (abrougher)
0001404: [Improvement] Add db.read.strings.as.bytes to turn on functionality to better control character encoding on MySQL (chenson)
0001405: [Bug] If sym_trigger_router.initial_load_delete_stmt is not set, then the initial.load.delete.first.sql property should be used (chenson)
0001396: [Bug] Null pointer in log message when initial load extract job is turned on and a table takes longer than 60 seconds to extract (chenson)
8 issues View Issues
Released 2013-08-20
0001334: [Bug] The issue with jConnect JDBC, SQL Anywhere and decimal value (chenson)
0001335: [Bug] dbexport doesn't work with SQL Anywhere (abrougher)
0001382: [Bug] Bad external_data: The bean shell router should unbind external data if it is void because the interpreter is reused (chenson)
0001389: [Bug] Postgres alter to add a default varchar value to a column without a default value fails (chenson)
0001390: [Bug] Not routing configuration properly when a source node group has multiple target node groups (chenson)
0001392: [Bug] When initial.load.use.extract.job.enabled is set to true the byte count and data count aren't being captured (chenson)
0001393: [Bug] Setting a batch to status of IG causes exception when initial.load.use.extract.job.enabled is set to true (chenson)
0001388: [Bug] "The current version of 3.5.3 is newer than the last running version of 3.4.5" prints out many times in the log file at INFO (chenson)
8 issues View Issues
Released 2013-08-10
0001368: [Bug] On extraction retries the data_event_count is not reset (chenson)
0001369: [Bug] Alter generated by table upgrade that requires a rebuild of the table, and includes the addition or removal of columns, fails (chenson)
0001370: [Improvement] When initial loads are configured to extract in the background, multiple load requests can queue up on top of each other (chenson)
0001373: [Bug] dropping a column with a default value fails on sql server because of default constraint (chenson)
0001374: [Bug] The primary key constraint name needs to be quoted when dropping a PK on Postgres (chenson)
0001375: [Bug] DB2 dropping column that is part of a composite primary key on a table causes error (chenson)
0001376: [Bug] DB2 table needs reorg after dropping a column. (abrougher)
0001377: [Bug] RestService handleError method should be public. Exceptions are not being serialized to the client properly (chenson)
0001378: [Bug] alterTables(boolean continueOnError, Table... desiredTables) in platform should use isRequiresAutoCommitForDdl (chenson)
0001379: [Improvement] When SymmetricDS starts, schedule the first run of the periodic jobs the period amount away from the last run (chenson)
10 issues View Issues
Released 2013-08-04
0001346: [Bug] reloadTable JMX method and command should always route to the node_list (chenson)
0001347: [Bug] Initial load ignores subselect routers and routes to all nodes. (chenson)
0001348: [Bug] Table object passed to DatabaseWriterFilters do not have types on them any more (chenson)
0001350: [Bug] Push batch not getting acked when multiple batches exist and it passed the transport.max.bytes.to.sync threshold (chenson)
0001351: [Bug] PK transform columns transformations run twice (chenson)
0001360: [Bug] rest service should set the engine name for logging (chenson)
0001361: [Bug] StagedResource.setState should support setting the state to itself without failing (chenson)
0001362: [Bug] Background initial load extract was allowing the client to start pulling data for a table that was currently extracting (chenson)
0001363: [Bug] SQL Server DateTime2 type does not work with conflict resolution. (abrougher)
0001365: [Improvement] Print out statistics if data rows in associated with a table/batch take longer than 60 seconds to process (chenson)
0001366: [Bug] If a custom column transformation isn't found the engine silently ignores it. An error should be thrown. (chenson)
0001364: [Improvement] Speed up bsh column transform by evaluating a transform as a method once and then call that method for each data element (chenson)
0001353: [Bug] The batch URL feature is broken (chenson)
13 issues View Issues
Released 2013-07-24
0001342: [Bug] Upgrade to 3.5.0 causes sym_trigger_hist to be rebuilt (chenson)
0001343: [Bug] alter of default column value on postgres is not working (chenson)
0001344: [Bug] Sybase ASE can not return columns with the alias "count". (abrougher)
0001345: [Bug] The reload table JMX method and command isn't working (chenson)
0001339: [Bug] When using PayloadType.SQL Symmetric doesn't pay attention to target database catalog and schema rules (gwilmer)
5 issues View Issues
Released 2013-07-22
0000046: [New Feature] National Language Support (NLS) data types such as NTEXT and NVARCHAR2 (elong)
0000281: [Bug] MS SQL: Update on varbinary(max) gets not synchronized (elong)
0000398: [Task] Test with latest Oracle JDBC drivers (elong)
0000949: [Bug] reload table doesn't work with wildcard triggers (chenson)
0001143: [Improvement] (Firebird) 64-bit Sym_UDF.dll (chenson)
0001236: [Improvement] Hash trigger text in sym_trigger_hist so we know when triggers change to force a rebuild. (abrougher)
0001295: [Bug] Numeric type on postgres should be read in as a JDBC decimal type (chenson)
0001297: [Improvement] The load filter target table value should only be case sensitive on case sensitive databases. (abrougher)
0001301: [Bug] BSH Load filter will not execute unless table exists on the target database. (abrougher)
0001302: [Improvement] Speed up queries against sym_data, sym_data_gap and sym_outgoing_batch on postgres (chenson)
0001307: [Improvement] Allow users to insert custom trigger text in the Symmetric triggers. (abrougher)
0001317: [Improvement] Bind column names using original case versus requiring router expressions to reference them in UPPER case. (abrougher)
0001318: [Improvement] Bind column names using original case and UPPER case for load filters. (abrougher)
0001321: [Improvement] Attempt recovery from corrupt trigger_hist table by looking up trigger_hist rows by table name when the table name mismatches (chenson)
0001322: [Bug] node_communication locks don't time out (chenson)
0001325: [Improvement] Add sym_registration_request to the purge process (chenson)
0001329: [Bug] ArrayOutOfBoundsException - during removal of column (chenson)
0001330: [Bug] stream.to.file.threshold.bytes and stream.to.file.ttl.ms were documented as overridable in the database but weren't really (chenson)
0001332: [Bug] The /batch url always extracts from the database. It should extract the same way the pull does (use staging). (chenson)
0001333: [Bug] Transforms with a source column containing an empty string or white space fail. (abrougher)
0001336: [Bug] Restart of Android job manager fails when job parameters are changed in the database (chenson)
0001052: [Improvement] Install a default ssl cert if none exists when ssl is turned on so that ssl works by default (chenson)
0001203: [Bug] SymmetricDS cannot operate on Oracle tables with dollar sign in name (chenson)
0001222: [Bug] db. properties are not overridable as -D system properties (chenson)
0001247: [Task] Change license to GPL 3.0 (chenson)
0001249: [New Feature] Add REST API methods to allow a "Pull Only" client (gwilmer)
0001260: [Bug] A null pointer happens when trying to schedule load when sync triggers has never run (chenson)
0001262: [Bug] Locally suspended channels are ignored when a node is pushing during extraction. (abrougher)
0001271: [Bug] Table creation on reload creates columns with default of 'NULL' incorrectly. (chenson)
0001272: [Improvement] Add support for the MySQL POINT data type. (abrougher)
0001274: [Improvement] Do not query the RECYCLEBIN while reading table metadata to see if the table has been recycled. (chenson)
0001277: [Bug] NPE during conflict resolution (use_version -> newer_wins) (chenson)
0001278: [Bug] The IDatabaseWriterFilter should always be passed the source table, not the target table (chenson)
0001218: [Improvement] bind a logger as the "log" variable to the beanshell router, column transform and load filter to make debugging easier (chenson)
0001226: [Bug] Table sym_node_group_channel_window exceeds the max table name length for Sybase ASE 12. (chenson)
0001231: [Improvement] Bind initialLoad flag to the beanshell data router so it can making routing decisions on initial load (chenson)
0001237: [Improvement] JdbcSqlTransaction not logging sql and args for some methods (chenson)
0001245: [Bug] Mariab driver doesn't recognize tables in a different database (chenson)
0000032: [New Feature] Implement file synchronization (chenson)
0001064: [New Feature] Add interactive command line sql tool. dbsql (chenson)
0001188: [Improvement] Inserting leading or trailing spaces in column ROUTER_EXPRESSION on table ROUTER produce ER in outgoing batch (chenson)
0001192: [Bug] Unrouted batches can't be extracted http://localhost:31415/batch/-1-50 gets a 404 (chenson)
0001193: [Improvement] rename snapshot files from yyyyMMddhhmmss.jar to {engine.name}-yyyyMMddhhmmss.zip (chenson)
0001194: [Improvement] Use a constant router_id for the virtual sym_ tables instead of an ever incrementing number (chenson)
0001199: [Improvement] EXCLUDED COLUMNS in triggers can't participate in lookuptable router expressions (chenson)
0001204: [Bug] Invalid target node on "lookup table data router", trouble cache key resolution (chenson)
0000370: [New Feature] SymmetricDS support for Sybase Database (abrougher)
0001182: [New Feature] Open source the android client implementation (chenson)
0001210: [Bug] Wildcards don't work on Derby, DB2, and HSQLDB (chenson)
0001270: [Improvement] Update sqlite jdbc driver to the latest version to fix result set metadata issue. Allows unit tests to pass. (chenson)
0001273: [Improvement] Add new parameter to dbexport to request that dates and time NOT be in JDBC format (chenson)
0001223: [Bug] the sendSql JMX method and command can end up with multiple batches due to timing issue (chenson)
0001296: [Bug] Prevent invalid size DDL of (0) or (0,0) to be written for data types that have size (chenson)
0001056: [Bug] Sync on incoming batch causes ping-back when in common batch mode (chenson)
0001303: [Bug] REST API doesn't return heartbeat interval properly when getting node status (gwilmer)
0001309: [Bug] Reload node events are not taking place in the correct order. (chenson)
56 issues View Issues
Released 2013-07-16
0001323: [Bug] Missing columns at target table can cause columns after the missing columns to not be updated (chenson)
1 issue View Issues
Released 2013-07-03
0001291: [Bug] Transforms can cause an error when attempting to use the create tables feature of SymmetricDS (chenson)
0001305: [Bug] Possible lock up during extraction. If the max number of locks are reached on a batch the extract method can hang forever (chenson)
0001306: [Improvement] Add setting in web.xml to allow the engines to be stored statically so multiple wars in an ear can reference the same engine (chenson)
3 issues View Issues
Released 2013-06-18
0001285: [Bug] If an Error (versus an Exception) happens during the data load process, the database transaction can be left hanging (chenson)
0001284: [Bug] StackOverflowError can happen when a transform exists and the primary keys mismatch causing conflicts on both update and insert (chenson)
0001287: [Bug] EXTERNAL_DATA is not available for routing for event types other than I, U, or D (chenson)
3 issues View Issues
Released 2013-06-06
0001246: [Bug] Oracle NUMBER datatype is incorrectly mapped to an Integer data type. (abrougher)
0001253: [Bug] Node communication records can be stranded (chenson)
0001254: [Improvement] Allow additional paramters min idle and max idle on connection pool (gwilmer)
0001256: [Improvement] Add a parameter that turns off writing to sym_incoming_batch altogether unless there is an ER (chenson)
0001257: [Bug] common batches report data_event_count on outgoing_batch only on the first batch (chenson)
0001258: [Bug] When an incoming_batch is finished, it's status is updated twice. (chenson)
0001259: [Improvement] Add JMX method to extract batches to a file for a node and time and channel ranges (chenson)
0001244: [Bug] Mariadb driver is chosen even though the MySQL driver is specified (chenson)
8 issues View Issues
Released 2013-05-29
0001220: [Bug] Wrong number of sym_data_events being logged when routing common batch (chenson)
0001221: [Bug] lookup column transform throws null pointer when used during extract (chenson)
0001227: [Bug] Reading of MySQL tables can sometimes include the PRIMARY index if the primary key columns aren't at the start (chenson)
0001238: [Bug] Issue with detecting whether batch is common or not. (chenson)
0001239: [Improvement] Add the ability to NOT add triggers to a client database until initial load has finished (chenson)
0001242: [Bug] ping_back settings broken for conflict resolution. class cast exception. (chenson)
0001211: [Bug] Backwards compatibility change. Use the client's Charset-Accept http header to decide what encoding to use. (chenson)
0001214: [Bug] reloadTable race condition (chenson)
0001215: [Bug] The initial load sql is not overridden in the reloadTable method (chenson)
0001232: [Bug] NullPointerException in BshDataRouter for reload events (chenson)
0001233: [Bug] DataService.insertData(Data data) should populate external_data (chenson)
0001235: [Bug] https settings in symmetric-server.properties not working with sym_service (chenson)
12 issues View Issues
Released 2013-05-12
0001206: [Bug] dataloader.ignore.missing.tables not working for initial load when initial.load.delete.first=true (chenson)
0001207: [Bug] DB2 text column default value metadata values are quoted. Need to remove quotes when reading table metadata from database. (chenson)
2 issues View Issues
Released 2013-05-07
0001202: [Bug] Wild card expressions are currently broken (chenson)
1 issue View Issues
Released 2013-04-24
0001190: [Improvement] Remove file sync tables. They should not have been released yet. (chenson)
1 issue View Issues
Released 2013-04-24
0001183: [Improvement] Add new property db.init.sql that allows sql to be run against a database connection right after it is created (chenson)
0001053: [Improvement] Verify that NOCOUNT is off for SQL Server before starting SymmetricDS. When NOCOUNT is turned on SymmetricDS won't work. (chenson)
0001184: [Improvement] Record ProcessInfo for server side registration process so it can more easily be monitored for errors (chenson)
3 issues View Issues
Released 2013-04-21
0000026: [New Feature] Provide an API to ignore or cancel a batch (elong)
0000142: [New Feature] Support SQL Server 2000 (elong)
0000246: [New Feature] Add script or JMX feature to capture system state to help debug issues (elong)
0000546: [Bug] Update of identical rows for a table not possible (no primary key and no uniqueness constraint) (elong)
0000553: [Bug] H2DbDialect Bad writeColumnAutoIncrementStmt definition (elong)
0001139: [New Feature] Expose information about the processes that are currently running via an api to be used to inspect what is going on in an engine (chenson)
0001149: [Bug] Log error message when an invalid sync_key_name column is specified. If no columns match, then return the original keys. (chenson)
0001150: [Bug] Allow wild card load filters to work on tables sharing the same prefix as the symmetric tables. (chenson)
0001154: [Improvement] Make the max_batch_size for the config channel bigger (2000) than its current default of 100 (chenson)
0001160: [Bug] Marking of old incoming batches as OK during initial load should also include the setting of the error_flag to 0 (chenson)
0001161: [Improvement] Set the default fetch size to 100. 1000 is a little big for smaller installations or for database with very BIG rows. (chenson)
0001162: [Improvement] Reuse nodes when auto.registration is turned on so you don't end up with a bunch of stranded nodes (chenson)
0001163: [Bug] If a database error occurs while initializing SymmetricDS the error bubbles out of a startup thread and is logged to std err (chenson)
0001164: [Bug] If a protocol error happens during extract (corrupted staging file), then delete the staging file so it will be reextracted (chenson)
0001165: [Bug] For an initial load on push, exit out of load loop if one of the batches failed (chenson)
0001166: [Improvement] Add DbFill support for PostgreSQL 'text' and 'active_inactive' column types. (chenson)
0001168: [Bug] Audit router throws NPE on Oracle and PostgreSQL. (chenson)
0001169: [Bug] Selection of batches is short circuited when a channel is encountered that is missing or disabled (chenson)
0001171: [Bug] Don't refresh the ParameterService cache if the database is unavailable because you can end up misconfigured for a timeperiod (chenson)
0001175: [Improvement] Add reload_id and create_by to sym_outgoing_batch (chenson)
0001176: [Improvement] Add support for MariaDB's Jdbc Driver (chenson)
0001179: [Bug] Parameters are not refreshed right after registration (chenson)
0000580: [Improvement] MySQL trigger throwing error on special characters (chenson)
0001117: [Bug] registration_enabled doesn't get set to 0 when node is really registered (chenson)
0000958: [New Feature] JNDI DataSource Support (chenson)
0000989: [Improvement] Provide a way to blank out the target schema/catalogs in sym_router (chenson)
0001046: [Bug] There are 2 log4j-1.2.16.jar files in the symmetricds deployment (chenson)
0001086: [Improvement] Make the 3.x use 1.x protocol for backwards compatibility (chenson)
0001104: [Improvement] Exclude sym_ tables from being effected by wildcard load filters (chenson)
0001105: [Improvement] Add new web.xml setting that controls whether the symmetric engine(s) are started (chenson)
0001107: [Improvement] Bind all of the symmetric properties to the spring context for use in extensions points (chenson)
0001109: [Bug] Registration can fail when multiple sym_node records exist with a null created_at_node_id value (chenson)
0001110: [Bug] Triggers not removed when sym_trigger source_ catalog, schema or table name changed (chenson)
0001111: [Bug] MySQL upgrade issue: Columns not modified when symmetricds table columns type or size change (chenson)
0001115: [New Feature] Add option to dbexport to NOT use quoted identifiers when exporting data as SQL (chenson)
0001116: [Bug] sym_data_gap referenced directly instead of using sync.table.prefix (chenson)
0001118: [Improvement] Allow the sync.url to be blank. Past versions of SymmetricDS allowed this and defaulted to using the registration.url (chenson)
0001119: [Bug] When dead triggers are disabled SymmetricDS attempts to delete triggers that don't exist. Causes warning in log file. (chenson)
0001121: [New Feature] Add a new "remove" column transform type that can be used with implied table transforms to remove a column completely. (chenson)
0001124: [Improvement] Add support to use the jboss.binding.address system property in JBoss 7 for the cluster.server.id (chenson)
0001128: [Improvement] Add new parameter to make heartbeat at server startup optional. Defaulting heartbeat at startup to off. (chenson)
0001129: [Bug] Null pointer happens if trigger router is removed for a reload event that has not been sent. Should just skip the reload event. (chenson)
0000939: [New Feature] Provide capability to specify initial load delete statement by trigger / router (gwilmer)
0000865: [Bug] Ignore batch is not working for an initial load batch that was failing to extract because of a bad initial_load_select (chenson)
44 issues View Issues
Released 2013-04-15
0001170: [Bug] postgres - Inserts fail on reverse reload events when a table contains duplicate rows. (chenson)
0001172: [Bug] postgres - Syncing slow for tables with bigint keys (chenson)
0001178: [Improvement] Performance Improvement: Many calls are being made to the file system to check if file exists while extracting big batches (chenson)
3 issues View Issues
Released 2013-04-03
0001133: [Bug] Multiple reverse reloads can be queued up because of timing issues (chenson)
0001137: [Improvement] Rest API Enhancements (gwilmer)
0001140: [Bug] SQL Server 2000 triggers are being created using the 'max' keyword, which 2000 does not support. (abrougher)
0001141: [Bug] Prevent invalid warning that expected ack was not received (chenson)
0001144: [Bug] When a reload is queued up the outgoing batches should be marked as OK in reverse order so as to not cause FK issues (chenson)
0001151: [Bug] NullPointerException can happen on reload events queued up by sym_table_reload_request during an upgrade (chenson)
0001155: [Bug] Audit router causes NPE on MySQL. (chenson)
0001156: [Bug] Fatal Error (like OOM) could possibly cause a reload event to be stranded in sym_data and routed to all child nodes (chenson)
0001157: [Bug] Don't allow api status methods if the engine isn't registered (gwilmer)
0001131: [Bug] NPE in conflict resolution when detecting a conflict using TIMESTAMP and existing row doesn't exist (gwilmer)
0001134: [Bug] An incoming batch can be left stranded in the ER state after an initial load sets the outgoing batch to OK (chenson)
0001135: [Bug] symmetric-server.properties enable flags for ssl are not working (chenson)
12 issues View Issues
Released 2013-03-18
0001122: [Improvement] Add support for Sql Server 2000 (abrougher)
1 issue View Issues
Released 2013-03-09
0001087: [Bug] If engine.name isn't used, then some services are not available. Should be available as long as there is only one node deployed (chenson)
0001094: [Bug] sync_keys isn't used to create triggers which causes a SQL Server table w/out primary keys and sync_keys to not capture updates (chenson)
0001101: [Bug] sqlite create tables doesn't work because a transaction is in process and the database is locked (chenson)
0001100: [Bug] sqlite create tables quotes create_timestamp default values (chenson)
4 issues View Issues
Released 2013-03-01
0001079: [Improvement] Children node are selected from the database each heartbeat but not necessarily used, can be time consuming w. lots of children (chenson)
0001080: [Bug] Reload and config channel should never be "common" channels (chenson)
0001082: [Bug] MySQL - error calling unknown function sym_transaction_idnull() (chenson)
0001083: [Bug] Registration slow on Oracle with lots of nodes (chenson)
4 issues View Issues
Released 2013-02-26
0000396: [Improvement] Updates of primary keys are not captured on SQL Server (gwilmer)
0001045: [Bug] Upgrade from 3.0.9 to 3.3.1 fails. Fix the oracle dialect so it can run alter statements to change column sizes (chenson)
0001047: [Improvement] Incoming Error's cur_data columns should reflect values at moment of conflict, not values prior to start of transaction (mhanes)
0001048: [Bug] Timestamps are not exported correctly using dbexport. (abrougher)
0001049: [Bug] DbExport allows --sql option without a table name argument. (abrougher)
0001050: [Improvement] Introduce conf/symmetric-server.properties which contains http/https/jmx port/enabled settings and other server specific setting (chenson)
0001057: [Bug] Postgres datetime with timezone not formatted correctly when timezone offset < 0 and timezone offset has minutes (gwilmer)
0001058: [Improvement] Provide access to include-on and source dml type in bean shell transforms (mhanes)
0001061: [Improvement] Support synchronization of Oracle Synonyms (chenson)
0001066: [Bug] Reverse initial load may be computed and routed before triggers are done synchronizing when a client first registers (chenson)
0001067: [Bug] syncTriggers called multiple times when multiple batches have queued up for the client and at least one has config changes (chenson)
0001070: [Bug] If trigger table name changes and the new trigger table name doesn't exist, the old triggers don't get remove from the old table (chenson)
0001071: [Improvement] Column transforms are being called even if the includeOn does not match. Only effects custom transforms that take some action. (chenson)
0001074: [Bug] sym_node_channel_ctl should not be included in the list of tables to load during registration (chenson)
0001075: [Improvement] Turn on sym_trigger.use_capture_lobs and sym_channel.contains_big_lobs by default for sym tables and the config channel (chenson)
0001076: [Bug] Update transform that falls back to insert does not retransform (chenson)
0001077: [Bug] SymmetricDS has to be restarted to recognize a change in the data load filter table. (chenson)
0001078: [Improvement] Allow sym_load_filter.target_table_name to be left blank so that filters are applied to all tables (chenson)
0001051: [Bug] --jmx-port and --jmx-disabled command line help is not available (chenson)
0001068: [Improvement] Add new extension point ILoadSyncLifecycleListener which gets callbacks before and after a load sync (chenson)
20 issues View Issues
Released 2013-02-12
0001042: [New Feature] MariaDB Dialect (gwilmer)
0001043: [Bug] dataloader.error.save.curval=true doesn't work (chenson)
0001044: [Bug] Map of semaphores used to prevent concurrent extraction of individual batches are not cleaned up (chenson)
0001041: [Improvement] If an outgoing_batches status is set back to NE, then always re-extract it versus using the already staged batch. (chenson)
4 issues View Issues
Released 2013-02-08
0000274: [New Feature] Allow keywords in table names (enable identifier delimiters) (elong)
0000016: [Bug] GIve options on how to handle non-existant table at client node (elong)
0000967: [Bug] Unknown table "INFORMATION_SCHEMA.SESSION_STATUS" error for MySQL 5.0.XX (chenson)
0000987: [New Feature] Add the "current" (conflicting) data to a column in sym_incoming_error (chenson)
0000994: [Improvement] Update Users Guide to describe how to deploy to separate machines (tutorial is multi-homed) (chenson)
0001010: [Improvement] Log better messages when server node is unavailable giving users a clue as to what action needs to be taken (admin)
0001019: [New Feature] Grouplets - Add a feature to specify a subset of nodes for which a router is enabled to allow piloting of configuration. (chenson)
0001033: [Improvement] Before allocating push/pull jobs check to see if thread count has changed and if so, restart thread pool (chenson)
0001025: [Improvement] Don't log staging area cleanup at the info level. Change logging to debug level (chenson)
0001026: [New Feature] If the minor version is upgraded, then (if you aren't the reg server) request a reload of key symmetric tables (chenson)
0001027: [New Feature] Add the ability to enable or disable trigger routers with an enabled column (chenson)
0001028: [Bug] stream.to.file.enabled=false is broken (chenson)
0001030: [Bug] Exception in clustered firebird environment (chenson)
0001031: [Bug] Documentation for outgoing_batch is missing IG and has RE instead of RT and QE instead of QY (chenson)
0001035: [New Feature] Add new refresh cache job that can be turned on in a clustered environment to check for configuration changes (chenson)
0001036: [Bug] Error is not getting recorded in outgoing batch if there isn't a line number (chenson)
0001037: [Improvement] Default dataloader.ignore.missing.tables to false instead of true (chenson)
0001040: [Bug] When use_stream_lobs is on use_changed_data conflict resolution doesn't work because the lobs old data is always null (chenson)
0001013: [Improvement] BshDatabaseWriterFilter should bind the error to use in a HANDLE_ERROR script (chenson)
0001014: [Improvement] Don't write STOPPED for the last server id in sym_lock when releasing an infinite lock (chenson)
0001015: [Bug] Data event count and insert event count get lost for big reload batches because status is requeried and overwrites the values (chenson)
0001018: [New Feature] Add a mechanism for a remote node to request a table reload. This is helpful while rolling out new tables. (chenson)
0001039: [Bug] syncTriggers should not abort when metadata cannot be read due to db permissions for just one trigger (chenson)
0000986: [New Feature] Include conflict_id reference in sym_incoming_error table to crossreference the type of conflict that occurred (chenson)
0001034: [New Feature] Add last_update_by, last_update_time, create_time to transform_*, parameter, channel, node_group, and node_group_link (chenson)
0001024: [Improvement] Use the symmetric table name as the virtual trigger name instead of a hashcode of the table name (chenson)
26 issues View Issues
Released 2013-01-24
0000983: [Bug] Table wasn't being quoted while selected lob data when stream_lobs is turned on and db.delimited.identifier.mode=true (chenson)
0000988: [Bug] use_stream_lobs uses routers target schema and catalog instead of the triggers source schema and catalog (chenson)
0000995: [Improvement] Upgrade to the latest postgres jdbc driver to get bug fix for retrieval of result set metadata (chenson)
0000997: [Improvement] dbimport and symmetricds dataloader throttle (abrougher)
0000998: [Improvement] Add parameters that allow the routing query to be optimized for large numbers of gaps with a large set of unrouted sym_data rows (chenson)
0001000: [Bug] Prevent null pointer if node channel control exists and channel does not. (chenson)
0001003: [Improvement] Don't allow a node to register if there are not links defined that will allow it to be part of the network (chenson)
7 issues View Issues
Released 2013-01-12
0000976: [Bug] Using wildcards in the source_table_name in databases that have foreign keys across schemas can cause triggers to not be built (chenson)
0000973: [Bug] batch_to_send_count not getting set properly unless you have batches in error (gwilmer)
0000982: [Bug] A conflict is not recorded in sym_incoming_error for sqlite because the database is locked and we use a different connection (chenson)
0000974: [Bug] Informix - Function created with the schema name as part of the function name (chenson)
0000978: [Bug] int8 datatype doesn't work as a primary key for an update on postgresql (chenson)
5 issues View Issues
Released 2013-01-05
0000961: [Bug] Uninstall feature needs to delete conflicts and transforms before trying to delete group links (chenson)
0000964: [Bug] Unchecked substring() while retrieving database name in firebird (chenson)
0000965: [Bug] Firebird and Interbase report unique constraint error code of 335544349 (chenson)
0000971: [Bug] Push / Pull threads should run in Job's thread when jobs.synchronized.enable is true (mhanes)
0000968: [Bug] Staging area clean up job can corrupt data extractions in progress (chenson)
0000969: [Bug] Trying to open registration on a node that has not been configured/registered itself causes null pointer (chenson)
6 issues View Issues
Released 2012-12-16
0000021: [New Feature] Add support for Sqlite over JDBC (mhanes)
0000708: [New Feature] Add ability to exclude BFILE columns from triggers for Oracle (chenson)
0000779: [New Feature] Add a symmetric parameter that tells the data loader that it is NOT ok to ignore a table if it is missing in the database (chenson)
0000809: [Improvement] Firebird trigger template improvement for generators. (chenson)
0000848: [Bug] Tutorial doesn't work for MySQL (chenson)
0000852: [Improvement] Add the ability to define the "sync key" of a table versus using the actual primary key (chenson)
0000892: [Bug] Common batch mode should not be detected if a channel is bidirectional with separate trigger definitions for the same table. (chenson)
0000907: [Improvement] Document conflict resolution's ping-back settings, and resolve booleans (row only, changes only) (chenson)
0000936: [Bug] Oracle integer datatype has a larger precision than the java Integer datatype. (chenson)
0000937: [New Feature] Provide capability to specify initial load / reverse initial load ordering (chenson)
0000940: [Bug] Conflict resolution uses the target table to lookup data for timestamp and version checks. Should be using source. (chenson)
0000941: [Bug] Triggers should exclude excluded columns even if column is part of primary key (mhanes)
0000942: [New Feature] Add a router type of 'audit' that captures changes in an dynamically created audit table. (chenson)
0000943: [Improvement] Do simple column validation of extracted initial load row during the extraction process. Log better message. (chenson)
0000944: [Bug] Recursive call while processing data for routing when there are a lot of gaps can cause stack over flow error (chenson)
0000945: [Bug] batchCommit was being called for earlyCommit and for normal commit. The api is suppose to only be call for a normal commit (chenson)
0000946: [Bug] Cannot delete triggers from tables if SymmetricDS user doesn't own those tables (chenson)
0000947: [Bug] Bad alter statement generated on oracle upgrade: ALTER TABLE "SYM_DATA_EVENT" MODIFY ("BATCH_ID" DEFAULT ) (chenson)
0000948: [Bug] Fix upgrade to sym_trigger_hist to not blow away sequences (chenson)
0000951: [Bug] use_timestamp conflict resolution with transform can get into endless loop (chenson)
0000954: [Improvement] Change default file permissions for executables to 755 (vs 774) (chenson)
0000955: [Improvement] Add parameter to allow SymmetricDS jobs to be synchronized (mhanes)
0000831: [Bug] Timeout is not set on a re-directed registration request (chenson)
0000855: [Improvement] Create a new heartbeat channel for sym_node_host. Deprecate heartbeat_time on sym_node (chenson)
0000871: [New Feature] Implement a REST API for SymmetricDS (gwilmer)
0000872: [New Feature] Add an uninstall feature to SymmetricDS (chenson)
0000890: [Improvement] The symmetricds client should always request UTF-8 character encoding. Also set -Dfile.encoding=utf-8 (chenson)
0000893: [Bug] Hidden feature to override the sym_ tables virtual triggers shouldn't look at router id to see if needs to replace the trigger (chenson)
0000899: [Bug] Prevent nodes from syncing with themselves (chenson)
0000904: [Bug] DbExport does not respect the compatible setting for data (chenson)
0000900: [Improvement] Add grant information to User's Guide for PostreSQL when a different schema is involved. (chenson)
0000902: [Bug] Don't allow an engine to service a request if that engine is not "started" (chenson)
0000903: [Bug] dbexport not replacing ? in cases (chenson)
0000906: [Bug] Altering a default value for a varchar column on oracle fails. Default value not quoted. (chenson)
0000908: [Bug] Table that has a sequence for increment column fails to migrate data (chenson)
0000909: [New Feature] Support GEOMETRY type on MySQL (chenson)
0000911: [New Feature] Support GEOMETRY type on SQL Server (chenson)
0000912: [Bug] Missing primary key columns from source at target can cause data corruption or errors. Columns misaligned. (chenson)
0000914: [Improvement] Update startup scripts to explicitly use the -server option, output out of memory errors, and restart on memory errors (chenson)
0000915: [Bug] backslash (\) is exported as doubule backslash (\\) in CSV format (chenson)
0000916: [Bug] After registration sym_node_security does not get updated with update enabled flag and times (chenson)
0000918: [Bug] Add startup parameters to support basic authentication (chenson)
0000920: [Improvement] Support timestamp with time zone in dbfill (chenson)
0000921: [Improvement] postgres trigger template for timestamp with time zone did not zero pad negative time zone hours (chenson)
0000924: [Bug] dbexport's xml format does not export null data values correctly (chenson)
0000925: [Improvement] DbFill should ignore the symmetric tables by default. (abrougher)
0000935: [Bug] dbexport null timestamp values from Oracle result in empty string ("") in CSV. (chenson)
0000896: [Bug] RouterService.getUnroutedDataCount() is not accurate. Uses max(last_id) when it should use max(start_id) (chenson)
0000806: [Bug] DbFill --help argument captions are not displayed correctly. (abrougher)
0000880: [New Feature] Add support for cascading random data to DbFill. (abrougher)
50 issues View Issues
Released 2012-11-29
0000929: [Improvement] Add oracle hint to query to select data from sym_data to force it to use the obvious index (chenson)
0000931: [New Feature] Add property that specifies minimum time between pushes and pulls. Default to 0 so pull and push periods have same behavior (chenson)
0000894: [New Feature] Add property to turn sync_on_incoming off for sym_ table triggers (chenson)
3 issues View Issues
Released 2012-11-27
0000913: [Bug] Verify that a staged resource reference exists before returning the reference. Symmetricds wasn't allowing me to remove failed (chenson)
0000926: [Bug] Staging area is not being cleaned up. Can cause out of memory or file system issues. (chenson)
2 issues View Issues
Released 2012-10-30
0000886: [Improvement] Routing of configuration data (especially the node tables) is very slow when there are lots of nodes (chenson)
0000889: [Bug] dbimport of xml format fails with mark/reset error (chenson)
2 issues View Issues
Released 2012-10-29
0000860: [Bug] Timestamp with timezone doesn't work with timestamp new wins conflict resolution (chenson)
0000868: [Task] dbimport needs to support imports from xml format (chenson)
0000870: [Improvement] Do not attempt to route data if a node does not have an identity (chenson)
0000875: [Bug] Node attempts to re-register when it attempts to pull from a non-registration server node that does yet have its security record (chenson)
0000876: [Improvement] During schema upgrade log the old version before attempting upgrade (chenson)
0000883: [Bug] Non-authenticated pull wasn't being recorded as a failed pull attempt in sym_node_communication (chenson)
0000884: [Bug] Documented cluster.server.id property is not supported. Add support. (chenson)
0000877: [Improvement] Downgrade not supported. Don't allow a older version of symmetricds start up against an newer schema (chenson)
0000882: [Bug] Stats Purge Job needs to be clustered. Running on multiple nodes can cause deadlocks (chenson)
9 issues View Issues
Released 2012-10-22
0000863: [Bug] When testing to see if a symmetric trigger exists on postgres, also check for the existence of the function (chenson)
0000825: [Improvement] Improve error handling around SymmetricEngineHolder if the engines dir isn't writeable or isn't a directory (chenson)
0000834: [Improvement] Add clarity to mention of CRON to differentiate Springs version vs the typical Unix one. (mhanes)
0000846: [Bug] SymmetricDS won't work with database names with a '-' in them on MySQL (chenson)
0000847: [Bug] dbexport does not extract timestamp columns correctly on oracle or postgres (chenson)
0000851: [Bug] Add primary key to SYM_REGISTRATION_REQUEST to make Azure happy (chenson)
0000856: [Bug] DbExport to XML and SYM_XML does not escape data (chenson)
0000859: [Bug] Changing external_select on sym_trigger does not cause syncTriggers to regenerate a trigger (chenson)
0000862: [Bug] Wildcard matches in sym_trigger match more than they should (chenson)
0000864: [Bug] LoadFilterService insert method fails. Effects the pro gui. (chenson)
10 issues View Issues
Released 2012-10-02
0000841: [Bug] 2 triggers for the same table that sync different subsets can end up causing errors (chenson)
0000843: [Improvement] Add ability wire in database writer filters to dbimport (chenson)
0000844: [Bug] Windows Azure does not allow the use of context_info which SymmetricDS uses (chenson)
0000845: [Bug] The STAGE_MANGEMENT and WATCHDOG jobs are not initialized (they won't work in a clustered environment) (chenson)
4 issues View Issues
Released 2012-09-12
0000807: [Improvement] Allow the symmetric-core parameter parser to work with other parameter files. (abrougher)
0000808: [Improvement] Document installing as a service for Ubuntu (chenson)
0000811: [Bug] H2 trigger template doesn't resolve schema (chenson)
0000812: [Improvement] Better document various options related to inital loads in the User's Guide (chenson)
0000813: [Bug] Trigger and Router Cache should be refreshed prior to syncTriggers (chenson)
0000814: [Bug] SqlScript autocommit=false with unique key error doesn't rollback or report exception in listener (chenson)
0000815: [Bug] decode() function needs qualified in most recent version of Greenplum (mhanes)
0000816: [Bug] Log messages in AbstractJob are reversed (chenson)
0000817: [Improvement] Take only the first 50 characters of an ipaddress in order to make sure database save to tables doesn't fail (chenson)
0000818: [Bug] Support alters tables statements for column size changes in postgres (chenson)
0000819: [Bug] Support alter table alter column on H2 when column size changes (chenson)
0000820: [Bug] Inactivate database trigger when trigger_router is removed. (chenson)
0000821: [Bug] Mark data row as unrouted if no trigger_router can be found for it (chenson)
0000822: [Improvement] Add new constructor to ClientSymmetricEngine so SymmetricDS can share an embedding application's Datasource and Spring Context (chenson)
14 issues View Issues
Released 2012-09-08
0000792: [Improvement] Support tables with names greater than 50 chars (chenson)
0000793: [Bug] Columns of type OID and LO in Postgres do not work with sym_trigger.use_stream_lobs set to 1 (chenson)
0000794: [Improvement] Support the lo datatype in postgres (chenson)
0000795: [Bug] ip_address field is not long enough to contain ipv6 addresses (chenson)
0000796: [Improvement] AbstractSqlTemplate should report an error if a named parameter map is passed in that does not contain a required parameter (chenson)
0000797: [Bug] table structure sync with wildcards (chenson)
0000798: [Improvement] Refactor and improved Subselect Router, External Select, and Column Match Router documentation (chenson)
0000799: [Bug] Tutorial initial load select needs single quotes around external id variable (chenson)
0000800: [Bug] DbFill is incorrectly generating new random values for columns containing a FK reference. (abrougher)
0000803: [Improvement] Check that column names match column values in the abstract router. If not log details. (chenson)
0000804: [Bug] Derby update trigger doubles up the row data (capture columns twice) (chenson)
11 issues View Issues
Released 2012-08-28
0000783: [Bug] Null date in the primary key causes parse exception on postgres (chenson)
0000784: [Improvement] Use the NetworkInterface Java class to get the current ipAddress of a node (chenson)
0000785: [Bug] syncTriggers(true) does not force trigger to be rebuilt (chenson)
0000788: [Bug] DbFill is populating columns with foreign values when a foreign key is not defined for the column. (abrougher)
0000790: [Bug] stream.to.file.enabled=false opens outgoing transport multiple times which causes ack to be lost sometimes (chenson)
0000786: [Improvement] Create a unit test for DbFill. (abrougher)
0000787: [Bug] DbFill does not generate random values from BigInteger columns. (abrougher)
7 issues View Issues
Released 2012-08-22
0000778: [Bug] If database user doesn't have permission to drop trigger, extra trigger_hist rows get created and the old are not deactivated (chenson)
0000781: [Bug] Restart of jobs can cause embedded derby database connections to fail (chenson)
0000774: [Bug] DbFill does not respect a columns scale and precision. (abrougher)
0000776: [Improvement] Change SqlScriptReader to allow comments in places other than the beginning of a line in a sql script (chenson)
0000775: [Improvement] Change SqlScript to use SqlScriptReader so that statements are streamed (chenson)
5 issues View Issues
Released 2012-08-14
0000773: [Bug] SqlScriptReader doesn't handle // comments correctly (chenson)
1 issue View Issues
Released 2012-08-13
0000430: [Improvement] Create a patches directory in the standalone distribution of SymmetricDS that can be used to drop jar or class file patches (elong)
0000375: [Improvement] Document example for bi-directional synchronization in the tutorial (elong)
0000766: [Bug] dbimport of timestamp column doesn't support 'default' for Oracle (maybe others) (chenson)
0000669: [Improvement] Add schema and catalog to the SymmetricDS Batch XML and change the publisher to fill in the schema and catalog (chenson)
0000770: [New Feature] Improve DbImport so that it incorporates the SymmetricDS data loader (chenson)
0000725: [New Feature] Add a feature to allow dynamic load filters to be created and executed based configuration (gwilmer)
0000726: [New Feature] Add a new parameter that, when set, is evaluated to choose a node id (chenson)
0000727: [Improvement] Upgrade Derby to 10.9.1.0 (chenson)
0000728: [Improvement] Lookup table router should throw an exception when the router expression is invalid. (abrougher)
0000731: [Improvement] Redo the derby database triggers so they can handle tables with more columns (chenson)
0000733: [Improvement] dbexport should use the default schema and default catalog if they aren't specified (chenson)
0000735: [New Feature] dbimport and dbexport should support symmetric batch xml. (chenson)
0000737: [Bug] The symmetric engine won't startup in single server mode as a war unless a property file has been specified in the web.xml (chenson)
0000738: [Bug] AbstractSymmetricEngine should call init() method of the SecurityService (chenson)
0000739: [Bug] Multiple wildcard expressions, only one used (chenson)
0000740: [Bug] Symadmin help subcommand missing (chenson)
0000742: [Bug] "ORA-01000: maximum open cursors exceeded" during initial load (RouterService.insertInitialLoadEvents) (chenson)
0000743: [Bug] Load fails when a null lob column is updated in same batch where the lob column is not null (chenson)
0000744: [Bug] Inefficient 'Sort by Foreign Keys' algorithm (chenson)
0000745: [Bug] Type of float(63) on oracle loses precision during data load. (chenson)
0000746: [Improvement] Improve documentation on how to handle Oracle error 'ORA-01489: result of string concatenation is too long' (chenson)
0000747: [Improvement] DbImport should have an empty constructor to make dependency injection easier. (abrougher)
0000748: [Bug] Data in a single transaction is split across batches and is out of order on Firebird (gwilmer)
0000751: [Improvement] Add new extension point called INodeIdCreator that replaces INodeIdGenerator and gets the remote address and host passed to it (chenson)
0000752: [Bug] Null pointer during trigger inactivation of deleted table can cause SymmetricDS engine not to start (chenson)
0000753: [Bug] The url for extracting a batch http://server:31415/sync/batch/nodeid-batchid does not work if the nodeid has a '-' in it (chenson)
0000756: [Bug] If an initial load is aborted by marking batches as OK, the client might remain in initial load mode and end up in a loop. (chenson)
0000757: [Improvement] All tables are synchronized during a CREATE batch when initial.load.create.first is true resulting in a lot of table missing (chenson)
0000759: [New Feature] Create utility to fill a given database with random data. (abrougher)
0000762: [Improvement] Change command line options --noconsole to --no-log-console and --nologfile to --no-log-file (chenson)
0000763: [Improvement] When logging to the console, log to system.err so that command line utilities can redirect system.out to files (chenson)
0000767: [Bug] Latest oracle jdbc drivers for 11g return (0,-127) for types defined as integer resulting in bad mappings (chenson)
0000771: [Improvement] DbFill should have the ability to load all of the tables in a given schema with random data. (abrougher)
0000724: [Task] Include an example of filtering or data subsetting (route items to a store) in the User Guide Tutorial (chenson)
0000729: [Bug] oracle.template.precision should be supported in 3.0 (chenson)
0000732: [Bug] Support varying Locales for the "REAL" data type (e.g., Oracle's Float(63)) (chenson)
0000734: [Bug] H2 wasn't selecting the schema or catalog in the table lookup (chenson)
0000736: [Bug] deployment_type not being recorded properly in sym_node (chenson)
0000716: [Improvement] dbimport should have an option that allows tables to be altered to match the import versus always trying to create them. (chenson)
0000760: [Bug] Columns mismatched on updates when source table has more columns than the target table. (chenson)
0000768: [Bug] Don't hide startup errors if the spring context fails to start (chenson)
0000655: [Task] Update dbexport and dbimport to support the SymmetricDS XML format (abrougher)
0000730: [Bug] dbexport schema property ignored when data is exported. (abrougher)
0000769: [Bug] Tomcat Deployment Broken (chenson)
44 issues View Issues
Released 2012-07-23
0000700: [Bug] StackOverflowError when filtering data during initial load (chenson)
0000713: [Bug] Automate upgrade from 2.x to 3.x on most platforms (chenson)
0000722: [Bug] Sync of a date field on the source to a datetime field on a target fails (chenson)
0000715: [Bug] Default values with underscores end up escaped (unecessarily) with a '\' or '%' character on MySQL (chenson)
0000720: [Bug] Variable Transform source-node-id incorrect on Extract type transforms (chenson)
0000723: [Bug] XML with DATE column type gets created as a DATETIME on SQL Server (chenson)
0000721: [Improvement] Explicitly set the key alias and the keystore type on the ssl connector (chenson)
7 issues View Issues
Released 2012-07-14
0000707: [Bug] Fix JarBuilder for Windows (gwilmer)
0000709: [Bug] Wildcard table lookup should respect the db.metadata.ignore.case property (chenson)
0000712: [Bug] drop trigger doesn't work on Oracle if the trigger is in a different schema (chenson)
0000711: [Bug] Table inactivation doesn't work properly when using the wildcard feature of sym_trigger (chenson)
4 issues View Issues
Released 2012-07-11
0000695: [Bug] UseVariableDates option for DbImport and DbExport do not work properly (gwilmer)
0000696: [Bug] Data is being pinged back during a re-registration (chenson)
0000705: [Bug] When using the wildcard feature of SymmetricDS, the reload events aren't being generated properly (chenson)
0000694: [Bug] JdbcSqlTemplate allows null SqlTemplateSettings and then uses it without null check later on (gwilmer)
4 issues View Issues
Released 2012-07-04
0000692: [Bug] Escaped varchar data can get corrupted (chenson)
0000690: [Bug] symmetric-util test code is being packaged with runtime application (chenson)
2 issues View Issues
Released 2012-06-29
0000670: [Improvement] Better document how nodes are deployed in the engines directory. (chenson)
0000671: [Bug] When the router type is null the batch type is always common. (chenson)
0000672: [Improvement] Support a --engine option for the syadmin create-war command (chenson)
0000673: [Improvement] Start symmetricds engine instance in background (chenson)
0000676: [Bug] dbimport fails to create unique indexes (chenson)
0000678: [Bug] auto.reload is broke in 3.0 (chenson)
0000679: [Bug] DbImport help screen does not display description for --use-variable-dates. (abrougher)
0000680: [Improvement] Don't run the sync triggers process at all if in a SymmetricDS instance and auto.sync.triggers is false (chenson)
0000683: [Bug] Error synchronyzing triggers (NPE) (chenson)
9 issues View Issues
Released 2012-06-26
0000665: [Bug] Don't commit a batch that doesn't have commit in the csv protocol (chenson)
0000668: [Bug] sym_trigger.use_stream_lobs had a bug where every column after a lob is not captured (chenson)
0000666: [Improvement] Don't capture the raw record in the csv parser. It allocates more memory than need be. (chenson)
0000667: [Improvement] Improve debug logging when the payload is VERY big. truncate data in the log. (chenson)
4 issues View Issues
Released 2012-06-22
0000656: [Bug] Change the default secret key algorithm used for encrypting/decrypting password from PBEWithMD5AndTripleDES to PBEWithMD5AndDES (chenson)
0000657: [Improvement] SymmetricEngineHolder.install should encrypt database password by default (chenson)
0000663: [Improvement] Add a variable transform that makes a column <null> (chenson)
0000664: [Improvement] Pass a reference to ISymmetricEngine to the Scripted Router so it has access to SymmetricDS services
0000658: [Bug] Fix null pointer exception that hides true exception during install of triggers (chenson)
0000659: [Improvement] Instead of failing to load a failed file, log warnings and delete staged resource if it was abandoned during xfer (chenson)
6 issues View Issues
Released 2012-06-18
0000647: [Bug] Fallback from insert to update causes an array index out of bounds exception (admin)
0000652: [Bug] Update documentation about how to configure purge (chenson)
2 issues View Issues
Released 2012-06-18
0000648: [Bug] Nested database transactions prevents H2 installation from deleting transforms sometimes. (chenson)
0000649: [Bug] Column matching routers can't match values with spaces. (abrougher)
0000651: [Bug] Initial Load Order not being honored. (chenson)
0000645: [Bug] Empty staged resource can be left around during the extract if there is an error during data extraction which causes SymmetricDS (chenson)
4 issues View Issues
Released 2012-06-06
0000646: [Bug] Command lines should fail if specified engines file doesn't exist (mhanes)
0000638: [Improvement] Support Microsoft's JDBC 4 Driver for SQL Server
0000639: [Improvement] Support Windows Azure
0000640: [Improvement] For fallback, if update fails and then the insert fails (pk changed and row already exists), then attempt to update using the ne
0000641: [Improvement] Don't initial load a table if the initial load order is < 0
0000642: [Bug] transforms with a transform_policy of implied don't copy primary keys to transform on insert
0000643: [Bug] Firebird requires commits after each ddl statement during upgrades
0000644: [Bug] Carriage return and line feeds are not being handled properly in the creation and parsing of CSV for 3.0.0
8 issues View Issues
Released 2012-06-04
This major release restructures the code for performance improvements and adds conflict management.
0000033: [New Feature] Rewrite csv loader/reader to make it a core SymmetricDS component (elong)
0000041: [New Feature] Addition of HTTPS Transport Type (elong)
0000054: [Bug] The initial.load.create.first feature should include foreign keys (elong)
0000057: [Improvement] Triggers should be created in same catalog and schema as source table (elong)
0000064: [New Feature] Support for HTTP Authentication Methods (elong)
0000143: [Bug] bin/sym root.properties --auto-create fails on some sym_* tables (elong)
0000160: [Bug] The where statement generated by the data loader needs to use 'is null' instead of '= null' when a primary key is null. (elong)
0000219: [New Feature] Synchronize tables to same schema/catalog in target if source_schema_name / source_catalog_name is defined for trigger (elong)
0000228: [Improvement] Store trigger creation errors in sym_trigger_hist (elong)
0000238: [New Feature] Optionally, send the source_node_id from sym_data in the protocol so the dataloader has access to it. (elong)
0000360: [Bug] Fallback for insert statements doesn't work (elong)
0000629: [Bug] We don't quote the catalog and schema when allowing sql server identity inserts
0000630: [Bug] Make sure cached table definitions are cleared out before running sync triggers.
0000560: [Improvement] Support of AES Encryption Is Needed (elong)
0000628: [Bug] Duplicate columns in table. Fix jdbc ddl reader so that reading table columns is qualified by schema and catalog
0000608: [Improvement] Optimization - Only capture one row in sym_data_event per sym_data when all the routers on a channel always send to all nodes in
0000618: [New Feature] Add setting on trigger that indicates whether old data should be captured by the triggers
0000621: [Improvement] Reload parameters from sym_parameter when they come through the data loader or data router (so you don't have to wait for the ca
0000622: [Improvement] Restart jobs if job parameters come through the data loader or data router
0000623: [New Feature] Add the ability to set a status of IG (ignore) on either an incoming or outgoing batch so that the status will be transmitted re
0000624: [Bug] The subselect router should not kick in during an initial load if the initial_load_select is used
0000625: [Improvement] Upgrade Jetty from 7.1 to 7.6 (latest stable 7.x version) to fix sporadic EOF exceptions
0000626: [Improvement] Use prepared args for the OK status in the purge service. Not sure if it makes a difference, but the wrong query plans are somet
0000006: [New Feature] Add more robust conflict resolution strategies
0000423: [Improvement] Add configurable file cache folder
0000543: [Bug] Column's JdbcTypeName is Null
0000548: [Bug] Remove invalid documentation for embedded.webserver.basic.auth.username and embedded.webserver.basic.auth.password
0000549: [Bug] Section 4.8.2 Transformation Types fails to mention pre-defined Lookup Transform type
0000562: [Bug] Fix DataService bug. Max data id that is currently handled in 2.x is Integer.MAX_VALUE. It should go all the way up to Long.MAX_
0000564: [Improvement] Add external_data to subselect router
0000566: [Improvement] Add documentation re purge requirements and sym_node_security
0000592: [New Feature] Make the data loader pluggable so that bulk loaders can be configured at the channel level.
0000593: [Improvement] Re-factor the data loader and data extractor so the components can be re-used outside of the core symmetricds engine
0000594: [Improvement] Remove dependency on commons-logging in favor of using slf4j everywhere for logging
0000595: [Improvement] Turn on multiServerMode as the default. Update tutorial and documentation
0000601: [Bug] Data type for data_id and batch_id should be a type that scales bigger than an integer
0000605: [New Feature] Support wildcards for the source_table_name in sym_trigger so you only have to configure one trigger entry to sync and entire da
0000607: [New Feature] Order triggers by FK constraints for initial load when initial_load_order is the same.
0000609: [New Feature] Add dbexport and dbimport features to SymmetricDS
0000613: [New Feature] Add a column_policy column to sym_transform_table that indicates whether undefined columns are specified or implied
0000616: [Improvement] Refresh parameter cache whenever new parameters come through the data loader or data router.
0000597: [Improvement] Consolidate database platform (former ddlutils) code and symmetricdialect code that contains information that should be in the p (chenson)
0000596: [Improvement] Load each batch as it arrives at the target (instead of transporting all batches for 1 sync and then loading them all) (chenson)
0000631: [Improvement] Add FKs to the SymmetricDS configuration tables
0000632: [New Feature] Create new feature to allow concurrent pulling and pushing of nodes
0000633: [Bug] Don't route inserts of sym_node or sym_node_security to the associated node_id
0000634: [Improvement] Speed up node reloads on push. Continuously push to a node if the previous push contained a reload event.
0000636: [Improvement] Support bigger than 32k clobs and varchar columns by swapping out sym_escape for REPLACE in the Firebird dialect
0000637: [Improvement] By default delete sym_data_gap rows instead of marking them as OK or SK
49 issues View Issues
Released 2012-05-31
0000617: [Bug] Transforms run in separate connection from data loader
0000619: [Improvement] Add support for Postgres UUID and VARBIT types
0000620: [Improvement] Make sure sequences are ordered (on Oracle) when creating them for SymmetricDS
0000627: [Improvement] auto.reload.reverse feature does not support datareload.batch.insert.transactional
0000635: [Bug] Column of type money loses precision on MSSQL
5 issues View Issues
Released 2012-05-02
0000606: [Improvement] Add -D system property org.jumpmind.symmetric.ddl.use.table.seq that forces postgres to NOT use sequences for SymmetricDS tables
0000610: [Bug] A delete transform on the load side does not have access to columns if transform has occurred on the extract side because old da
0000611: [Bug] auto.reload.reverse causes other nodes to auto reload.
0000612: [Bug] Postgres DATE field leaves an extra '.' at the end of captured data in version 8.5 which causes a parse exception during the dat
0000615: [Bug] When a timestamp with time zone column is part of a primary key or part of a table w.out a primary key, then the trigger fails t (chenson)
5 issues View Issues
Released 2012-04-10
0000600: [Bug] Some versions of Postgres 8.3 (EnterpriseDB 8.3.x) don't support txid_current() function
0000603: [New Feature] Add setting to allow a client to push an initial load back to the server after registration.
0000602: [Bug] Export of configuration does not work because all data is filtered out. The config router thinks it doesn't need to route the ex (chenson)
3 issues View Issues
Released 2012-04-02
0000581: [Bug] Registration problems when you have a multi-tier system with many nodes at the same group level that allows registration of chil (chenson)
1 issue View Issues
Released 2012-03-27
0000589: [Improvement] Register JMX HTTP adapter with the host (network interface) that is specified on the command line
0000590: [Bug] "Time Zone is not captured correctly for columns that are of type ""Timestamp With Time Zone"""
0000591: [Bug] Oracle NUMBER(3) isn't java.sql.TINYINT
3 issues View Issues
Released 2012-03-05
0000541: [Improvement] Support GeoSpatial data type (SDO_GEOMETRY) in oracle spatial
0000585: [Bug] Schemas and catalogs should be quoted during trigger generation.
0000586: [Improvement] Provide the capability to start up SymmetricDS on different network interfaces
0000587: [Bug] Allows tables with FK to be used with initial.load.create.first=true
0000588: [Bug] Oracle model reader translates a number(1) to a bit type which breaks synchronization (only values of 1 or 0 are inserted)
5 issues View Issues
Released 2012-02-23
0000583: [Bug] Race condition can leave sym_node_security in an incorrect state at a client after reload (chenson)
1 issue View Issues
Released 2012-02-13
0000558: [Bug] Transaction boundaries can be broken when max_batch_size is set to a small number and batch algorithm is set to 'transactional'
0000577: [Bug] When more than one channel is in error, channels that are not in error have the possibility of being held up
0000578: [Improvement] The outgoing.batches.max.to.select property should not have to take into account that a channel might be disabled
0000579: [Bug] The feature to pass a properties file to the sym command when creating a war file does not work
0000582: [Bug] Identity column transform not working
5 issues View Issues
Released 2012-01-27
0000569: [Improvement] Allow StandaloneSymmetricEngine to be embedded with Symmetric-Core only (gwilmer)
0000570: [Bug] Make sure the insert of a GP record never fails. (chenson)
0000573: [Bug] ColumnMatchDataRouter incorrectly parses router expressions with column names that contain 'OR'. e.g. CONCENTRATOR_ID (chenson)
0000574: [Improvement] Remove the check to run purge only if an initial load has happened (chenson)
0000571: [Bug] "Time Zone is not captured/sent to the replicated node for columns that are of type ""Timestamp With Time Zone""" (chenson)
0000572: [Bug] Misleading error printed out during transformation where no columns were found to transform (chenson)
6 issues View Issues
Released 2011-12-23
0000561: [Bug] Issue deleting tuples from a table that has a column of type timestamp as part of the Primary Key (chenson)
0000563: [Bug] When a transformation happens on a primary key, it does not have access to new column values other than the keys of the original (chenson)
0000565: [Improvement] Add the ability to use the source node's external id as a column value in a variable transform (chenson)
0000567: [New Feature] Provide a load filter that will enable bulk load for Postgres and Greenplum dialects (gwilmer)
0000568: [Improvement] Increase the default idle time for the standalone instance's embedded jetty instance (chenson)
5 issues View Issues
Released 2011-11-30
0000555: [Bug] Connection pool can exhaust at high activity because of out of order interceptors in 2.5 (chenson)
0000557: [Bug] sym_data_gap can be left stranded without a required last gap entry record (chenson)
0000559: [New Feature] Add support for geometry types in postgres. The fix should work for other unknown types that can be cast and dealt with as varch (gwilmer)
0000556: [Bug] Slow extracts - During the extract process routers are being queried from the database for each data event read. (chenson)
4 issues View Issues
Released 2011-11-19
0000540: [Bug] Postgres insert of same row with no primary keys does not insert a row past the first insert. (chenson)
0000542: [Bug] two errors in JRE5.0 (chenson)
0000547: [Improvement] Limit the number of nodes that can register in parallel the same way nodes that can pull and push are limited. (chenson)
3 issues View Issues
Released 2011-11-06
0000518: [Bug] Fix NullPointerException in transform dataloader's fallback logging (chenson)
0000519: [Bug] When a transformed row is being loaded (from the dataloader) and it encounters a conflict it should re-transform the original da (chenson)
0000525: [Bug] Pass old data to transformations when a DELETE event comes through (chenson)
0000527: [Bug] Postgres doesn't accept null characters (0x00) in textfields while other databases do. Strip them out during synchronization. (chenson)
0000529: [Bug] Support reading in TIMESTAMP WITH TIME ZONE data types in Oracle (chenson)
0000524: [Bug] Client DataLoad nullpointers when registering if server fails to send down a values for sym_node (chenson)
0000539: [Improvement] Capture and route node and node_security changes out to all interested nodes.
0000517: [Improvement] Add support for hosting multiple engines in a single SymmetricDS server (chenson)
0000523: [Bug] Make postgres dataloader more efficient by removing the use of savepoints. (chenson)