View Issue Details

IDProjectCategoryView StatusLast Update
0004323SymmetricDSBugpublic2020-03-20 17:56
ReportermkleczekAssigned To 
Priorityhigh 
Status newResolutionopen 
Product Version3.11.5 
Target VersionFixed in Version 
Summary0004323: Auto registration fails when custom sync.table.prefix is used due to missing tables when processing virtual 9999 batch
DescriptionMy setup is such that two SymmetricDS nodes use the same database for SymmetricDS tables but slave node is a load only node.
Slave node has the following settings:
load.only = true
db.url=[same as master node - non-Oracle]
...
sync.table.prefix=slave_sym
target.db.url=[slave db url - Oracle]
...
registration.url=[sync url of master]

Master node has the following settings:
load.only = false
db.url=[master db url - non-Oracle]
...
registration.url=[own sync url]
auto.registration = true

When slave node is starting up it successfully contacts master node and initializes registration. Then it reports:
INFO | jvm 1 | main | 2020/03/20 20:08:07.605 | ERROR [slave-dataloader-2] [DefaultDatabaseWriter] Failed to run the following sql: delete from sym_job
INFO | jvm 1 | main | 2020/03/20 20:08:07.605 | ERROR [slave-dataloader-2] [ManageIncomingBatchListener] Failed to load batch i2itarget--9999
INFO | jvm 1 | main | 2020/03/20 20:08:07.617 | org.jumpmind.db.sql.SqlException: ORA-00942: table or view does not exist

Stack trace follows...

INFO | jvm 1 | main | 2020/03/20 20:08:07.622 | INFO [slave-job-3] [RegistrationService] Could not register. Sleeping for 1000ms before attempting again.
INFO | jvm 1 | main | 2020/03/20 20:08:08.631 | INFO [slave-job-3] [RegistrationService] This node is unregistered. It will attempt to register using the registration.url
TagsNo tags attached.

Activities

There are no notes attached to this issue.

Issue History

Date Modified Username Field Change
2020-03-20 17:56 mkleczek New Issue