Hi, please i'm currently having issues with incremental mode encountering this error syncing data between two MariaDB database

[osangs60]

./replicadb --options-file incrmt.conf
2023-12-21 12:18:32,083 INFO ReplicaDB:63 Running ReplicaDB version: 0.15.1
2023-12-21 12:18:32,100 INFO ReplicaDB:66 Setting verbose mode DEBUG
2023-12-21 12:18:32,102 DEBUG ReplicaDB:67 ToolOptions{
sourceConnect='jdbc:mariadb://192.168.3.103:3306/_a3e076f1cadd37be',
sourceUser='root',
sourcePassword='',
sourceTable='tabSales Invoice',
sourceColumns='null',
sourceWhere='null',
sourceQuery='null',
sinkConnect='jdbc:mariadb://192.168.3.103:3306/_08fbc95a2d3223b2',
sinkUser='root',
sinkPassword='',
sinkTable='tabSales Invoice',
sinkStagingTable='null',
sinkStagingSchema='null',
sinkStagingTableAlias='null',
sinkColumns='null',
sinkDisableEscape=true,
sinkDisableIndex=false,
sinkDisableTruncate=true,
sinkAnalyze=false,
jobs=5,
BandwidthThrottling=0,
quotedIdentifiers=false,
fetchSize=1000,
help=false,
version=false,
verbose=DEBUG,
optionsFile='incrmt.conf',
mode='incremental',
sentryDsn='https://400e0daa08c24a399b842048c409416f@o1002451.ingest.sentry.io/5962725',
sourceConnectionParams={},
sinkConnectionParams={},
sourceFileFormat='null',
sinkFileformat='null'}
2023-12-21 12:18:32,296 INFO Sentry:27 Sentry enabled
2023-12-21 12:18:32,780 DEBUG MySQLManager:348 Calculating the chunks size with this sql: SELECT CEIL(count() / 5) chunk_size, count() total_rows FROM tabSales Invoice
2023-12-21 12:18:33,715 DEBUG MySQLManager:353 chunkSize: 307306 totalNumberRows: 1536529
2023-12-21 12:18:33,723 WARN SqlManager:482 No staging schema is defined, setting it as PUBLIC
2023-12-21 12:18:33,753 INFO MySQLManager:246 Creating staging table with this command: CREATE TABLE public.tabSales Invoicerepdb1010 AS (SELECT * FROM tabSales Invoice WHERE 1 = 0 )
2023-12-21 12:18:33,760 ERROR ReplicaDB:134 Got exception running ReplicaDB:
java.sql.SQLSyntaxErrorException: (conn=102) You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'AS (SELECT * FROM tabSales Invoice WHERE 1 = 0 )' at line 1
at org.mariadb.jdbc.internal.util.exceptions.ExceptionFactory.createException(ExceptionFactory.java:62) ~[mariadb-java-client-2.7.3.jar:?]
at org.mariadb.jdbc.internal.util.exceptions.ExceptionFactory.create(ExceptionFactory.java:155) ~[mariadb-java-client-2.7.3.jar:?]
at org.mariadb.jdbc.MariaDbStatement.executeExceptionEpilogue(MariaDbStatement.java:274) ~[mariadb-java-client-2.7.3.jar:?]
at org.mariadb.jdbc.MariaDbStatement.executeInternal(MariaDbStatement.java:363) ~[mariadb-java-client-2.7.3.jar:?]
at org.mariadb.jdbc.MariaDbStatement.executeUpdate(MariaDbStatement.java:627) ~[mariadb-java-client-2.7.3.jar:?] at org.replicadb.manager.MySQLManager.createStagingTable(MySQLManager.java:247) ~[ReplicaDB-0.15.1.jar:0.15.1]
at org.replicadb.manager.SqlManager.preSinkTasks(SqlManager.java:485) ~[ReplicaDB-0.15.1.jar:0.15.1]
at org.replicadb.ReplicaDB.processReplica(ReplicaDB.java:94) [ReplicaDB-0.15.1.jar:0.15.1]
at org.replicadb.ReplicaDB.main(ReplicaDB.java:47) [ReplicaDB-0.15.1.jar:0.15.1]
Caused by: org.mariadb.jdbc.internal.util.exceptions.MariaDbSqlException: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'AS (SELECT * FROM tabSales Invoice WHERE 1 = 0 )' at line 1
at org.mariadb.jdbc.internal.util.exceptions.MariaDbSqlException.of(MariaDbSqlException.java:34) ~[mariadb-java-client-2.7.3.jar:?]
at org.mariadb.jdbc.internal.protocol.AbstractQueryProtocol.exceptionWithQuery(AbstractQueryProtocol.java:194) ~[mariadb-java-client-2.7.3.jar:?]
at org.mariadb.jdbc.internal.protocol.AbstractQueryProtocol.executeQuery(AbstractQueryProtocol.java:262) ~[mariadb-java-client-2.7.3.jar:?]
at org.mariadb.jdbc.MariaDbStatement.executeInternal(MariaDbStatement.java:357) ~[mariadb-java-client-2.7.3.jar:?]
... 5 more
Caused by: java.sql.SQLException: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'AS (SELECT * FROM tabSales Invoice WHERE 1 = 0 )' at line 1
at org.mariadb.jdbc.internal.protocol.AbstractQueryProtocol.readErrorPacket(AbstractQueryProtocol.java:1694) ~[mariadb-java-client-2.7.3.jar:?]
at org.mariadb.jdbc.internal.protocol.AbstractQueryProtocol.readPacket(AbstractQueryProtocol.java:1556) ~[mariadb-java-client-2.7.3.jar:?]
at org.mariadb.jdbc.internal.protocol.AbstractQueryProtocol.getResult(AbstractQueryProtocol.java:1519) ~[mariadb-java-client-2.7.3.jar:?]
at org.mariadb.jdbc.internal.protocol.AbstractQueryProtocol.executeQuery(AbstractQueryProtocol.java:256) ~[mariadb-java-client-2.7.3.jar:?]
at org.mariadb.jdbc.MariaDbStatement.executeInternal(MariaDbStatement.java:357) ~[mariadb-java-client-2.7.3.jar:?]
... 5 more
2023-12-21 12:18:33,885 INFO SqlManager:462 Dropping staging table with this command: DROP TABLE public.tabSales Invoicerepdb1010
2023-12-21 12:18:33,891 ERROR ReplicaDB:156 java.sql.SQLSyntaxErrorException: (conn=102) You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'repdb1010' at line 1
2023-12-21 12:18:33,897 INFO ReplicaDB:54 Total process time: 1834ms

[osalvador]

Hi, maybe you can escape the single quote with a curly slash \.

sourceTable=\'tabSales Invoice\'