View Issue Details
ID | Project | Category | View Status | Date Submitted | Last Update |
---|---|---|---|---|---|
0004633 | SymmetricDS | Bug | public | 2020-11-13 07:08 | 2022-08-30 13:02 |
Reporter | dgreiss | Assigned To | elong | ||
Priority | normal | ||||
Status | closed | Resolution | fixed | ||
Product Version | 3.12.5 | ||||
Target Version | 3.12.18 | Fixed in Version | 3.12.18 | ||
Summary | 0004633: Tables not created on reverse initial load | ||||
Description | Upgrading 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 | ||||
Tags | initial/partial load | ||||
|
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. |
|
Ok I’ll create a repo to reproduce the issue. Just need a few days to get to it. |
|
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 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 |
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 |