View Issue Details

IDProjectCategoryView StatusLast Update
0004633SymmetricDSBugpublic2022-08-02 20:10
Reporterdgreiss Assigned Toelong  
Prioritynormal 
Status assignedResolutionopen 
Product Version3.12.5 
Summary0004633: Tables not created on initial load
DescriptionUpgrading from 3.9 to the latest version 3.12.5, I found that tables are not created on initial load. Previously I set initial.load.create.first=true and the tables were created at the target node. I’ve tested this setting with MSSQL, Postgres and MariaDB
Tagsinitial/partial load

Activities

elong

2020-11-18 18:30

developer   ~0001842

It works for me. I set initial.load.create.first=true and then ran update sym_node_security set initial_load_enabled = 1 where node_id = '2'. It also works with auto.reload=true to send the initial load and create tables when a new node registers. The parameter needs to be set at the source node. Please provide steps to reproduce.

dgreiss

2020-11-20 00:50

reporter   ~0001850

Ok I’ll create a repo to reproduce the issue. Just need a few days to get to it.

dgreiss

2020-12-15 01:17

reporter   ~0001869

Apologies for the delay. I've created a repo to reproduce what I'm finding: https://github.com/dgreiss/symds-example

The setup is a master node which does not have data and a client node that has the store data. The client node contains the data which would need to be synced with the master with a reverse initial load. I've set auto.reload.reverse=true on master so that data can be pushed from the client to master. On the client node initial.load.create.first=true.

A reverse initial load is sent, but the tables are not created. I've tried setting initial.load.create.first=true on both the client and master but to no avail.

The master and client property files are attached as well. Thanks!
client.properties (591 bytes)   
engine.name=client
external.id=client
group.id=client

db.driver=org.mariadb.jdbc.Driver
db.url=jdbc:mariadb://127.0.0.1:3306/symds?tinyInt1isBit=false
db.user=root
db.password=password


registration.url=http://127.0.0.1:31415/sync/master

initial.load.defer.create.constraints=true
initial.load.create.first=true
initial.load.delete.first=true

create.table.without.defaults=true
create.table.without.foreign.keys=true
create.table.without.pk.if.source.without.pk=true
job.purge.period.time.ms=2000
job.routing.period.time.ms=2000
job.push.period.time.ms=1000
job.pull.period.time.ms=1000
client.properties (591 bytes)   
master.properties (958 bytes)   
engine.name=master
group.id=master
external.id=master

db.driver=org.postgresql.Driver
db.url=jdbc:postgresql://127.0.0.1:5432/symds?stringtype=unspecified
db.user=postgres
db.password=password

# This node will contact the root node's sync.url to register itself.
# Leave blank to indicate this is the root node.
registration.url=
# Sync URL where other nodes can contact this node to push/pull data or register.
sync.url=http://localhost:31415/sync/master

auto.reload.reverse=true
auto.registration=true

cache.node.group.link.time.ms=2000

job.purge.period.time.ms=2000
job.routing.period.time.ms=2000
job.push.period.time.ms=2000
job.pull.period.time.ms=2000

start.purge.incoming.job=true
job.purge.incoming.cron=*/5 * * * * *
purge.retention.minutes=5

# The number of milliseconds parameters will be cached by the ParameterService before they are reread from the file system and database.
parameter.reload.timeout.ms=5000
log.conflict.resolution=true
master.properties (958 bytes)   

Issue History

Date Modified Username Field Change
2020-11-13 07:08 dgreiss New Issue
2020-11-18 18:30 elong Assigned To => elong
2020-11-18 18:30 elong Status new => feedback
2020-11-18 18:30 elong Note Added: 0001842
2020-11-20 00:50 dgreiss Note Added: 0001850
2020-11-20 00:50 dgreiss Status feedback => assigned
2020-12-15 01:17 dgreiss Note Added: 0001869
2020-12-15 01:17 dgreiss File Added: client.properties
2020-12-15 01:17 dgreiss File Added: master.properties
2022-08-02 20:10 elong Tag Attached: initial/partial load