View Issue Details

IDProjectCategoryView StatusLast Update
0004633SymmetricDSBugpublic2022-08-30 13:02
Reporterdgreiss Assigned Toelong  
Prioritynormal 
Status closedResolutionfixed 
Product Version3.12.5 
Target Version3.12.18Fixed in Version3.12.18 
Summary0004633: Tables not created on reverse 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

Relationships

related to 0005424 closedelong Tables not created on reverse initial 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)   

Related Changesets

SymmetricDS: 3.12 a940cf75

2022-08-25 17:33:39

admin

Details Diff
0004633: Tables not created on reverse initial load Affected Issues
0004633
mod - symmetric-core/src/main/java/org/jumpmind/symmetric/service/impl/InitialLoadService.java Diff File

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
2022-08-25 17:34 elong Status assigned => resolved
2022-08-25 17:34 elong Resolution open => fixed
2022-08-25 17:34 elong Fixed in Version => 3.12.18
2022-08-25 17:34 elong Target Version => 3.12.18
2022-08-25 17:34 elong Summary Tables not created on initial load => Tables not created on reverse initial load
2022-08-25 17:35 elong Issue cloned: 0005424
2022-08-25 17:35 elong Relationship added related to 0005424
2022-08-25 18:00 admin Changeset attached => SymmetricDS 3.12 a940cf75
2022-08-30 13:02 admin Status resolved => closed