Where communities thrive


  • Join over 1.5M+ people
  • Join over 100K+ communities
  • Free without limits
  • Create your own community
People
Activity
  • Dec 13 14:57

    erilong on 3.10

    0004206: Disable initial load i… (compare)

  • Dec 13 14:51

    erilong on 3.11

    0004205: Disable initial load i… (compare)

  • Dec 12 19:07

    erilong on 3.11

    0004204: Efficient logging of t… (compare)

  • Dec 12 19:01

    erilong on 3.11

    0004203: Captured Data on the B… (compare)

  • Dec 12 18:33

    erilong on 3.11

    0004204: Efficient logging of t… (compare)

  • Dec 12 18:09

    erilong on 3.11

    0004204: Efficient logging of t… (compare)

  • Dec 12 12:29

    erilong on 3.11

    0004198: NPE loading batch with… (compare)

  • Dec 11 23:59

    erilong on 3.10

    0004198: NPE loading batch with… (compare)

  • Dec 11 17:09

    erilong on 3.11

    set logging to debug (compare)

  • Dec 11 09:43
    mkurz01 synchronize #108
  • Dec 10 21:48

    joshahicks on 3.10

    0004190: Google Big Query Suppo… Merge branch '3.10' of https://… 0004190: Google Big Query Suppo… and 1 more (compare)

  • Dec 10 20:56

    erilong on 3.11

    0004193: Tables with zero rows … 0004195: Tables with zero rows … (compare)

  • Dec 10 20:52

    erilong on 3.10

    0004193: Tables with zero rows … (compare)

  • Dec 10 08:11
    mkurz01 opened #108
  • Dec 09 16:22

    chenson42 on 3.11.2

    (compare)

  • Dec 09 16:03

    chenson42 on 3.10.7

    (compare)

  • Dec 09 15:14

    erilong on 3.11

    0004187: Initial load queue and… fix test for sqlite (compare)

  • Dec 06 15:57

    erilong on 3.11

    0004187: Initial load queue and… (compare)

  • Dec 06 14:59

    erilong on 3.11

    0004187: Initial load queue and… (compare)

  • Dec 05 18:58

    erilong on 3.11

    0004176: When conflict detectio… (compare)

joshahicks
@joshahicks
Normally you could do it with a column in the table that contained the node id
I think you were heading down the right path with a bsh router. You could do something like the following in a bsh router.
targetNodes.add(dataMetaData.getTable().getNameLowerCase().substring(6));
return targetNodes;
ChaoYang
@nuoyaneasy
I see what you mean, but I think that's not my case. All my store nodes will sync data to corp and all store nodes runs with a table name 'sys_log'.
joshahicks
@joshahicks
Ok you are talking about store to corp
I was setting up the other direction
ChaoYang
@nuoyaneasy
What I want is when I sync from store to corp, 'target_table_name' will be resolved from liks bsh or something rather than configure "target_table_name' for every store
joshahicks
@joshahicks
in that case you would need a transform I believe
I believe you can refer to parameters in the target table name on a router though
ChaoYang
@nuoyaneasy
yeah, @joshahicks I checked transform doc, but I haven't a clue
joshahicks
@joshahicks
so your router from store to corp try target table name as: sys_log$(node_id)
ChaoYang
@nuoyaneasy
could I get table_table_name from engine? when I set up my bsh script containing 'target_table_name', the engine prompts error with bounds variables (nodes, nodesID, etc), I didn't find any variable referencing 'target_table_name'
I see, you mean I set up my value in 'target_table_name' directly in sql with sys_log$(node_id)
joshahicks
@joshahicks
I believe it will resolve variables where the router runs
so routing would run at each store and the node id is a built in parameter
ChaoYang
@nuoyaneasy
I will try it. Thank you very much @joshahicks
joshahicks
@joshahicks
Unfortunately there are some different variable mappings used and I am not sure which one is in target table name of the router.
I believe it is $(variable name)
ChaoYang
@nuoyaneasy
ok I will try this
Could not find the target table 'platform-ops.syslog$(node_id)'
joshahicks
@joshahicks
try this one
$(sourceNodeId)
ChaoYang
@nuoyaneasy
Could not find the target table 'platform-ops.sys_opslog$(sourceNodeId) :(
still not working :(
joshahicks
@joshahicks
looks like its setup to resolve on target catalog and schema but may not be for table
ChaoYang
@nuoyaneasy
Could not find the target table 'platform-ops123124.sys_opslog$(sourceExternalId)
yes @joshahicks I tried with target catalog, it can be resolved but not for table
joshahicks
@joshahicks
what version of SDS do you have
ChaoYang
@nuoyaneasy
3.10.3
joshahicks
@joshahicks
Im signing off for tonight but will take a look again tomorrow
ChaoYang
@nuoyaneasy
OK
thank you help help
thanks for your help
姚慎慎
@yaoshenshen
symmetricds support DDL ?
@joshahicks
姚慎慎
@yaoshenshen
I want to know whether symmetricds support DDL
The version is 3.10.4
郭志姗
@guozhishan
Hi~How does symmtric implement file synchronization, is there a sample configuration file? Thank you!
Hi~How does symmetricds implement file synchronization, is there a sample configuration file? Thank you!
joshahicks
@joshahicks

@yaoshenshen yes you can send create events on demand for each table. If the target table does not match the source it will automatically alter. Here is an example of creating a create event

dataService.insertCreateEvent(targetNode, triggerHistory, triggerRouter
.getRouter().getRouterId(), false, -1, createBy);

@guozhishan File sync is a bit complicated to explain over chat but check sections 4.7 and 4.8 in the guide.

http://www.symmetricds.org/doc/3.10/html/user-guide.html#_file_triggers

@yaoshenshen if your using MSSQL server there is a parameter to capture DDL changes and autmatically sync. trigger.capture.ddl.changes
DIEGO FAUDA
@diego_fauda_twitter
Hola buen dia a todos...hay proveedores y consultores en Argentina?
joshahicks
@joshahicks
We do not have consultants on site in Argentina
DIEGO FAUDA
@diego_fauda_twitter
Les interesa tener? trabajo en una empresa en sistemas que necesita de un producto como este
ChaoYang
@nuoyaneasy
hi @joshahicks ,about the store corp sync, since target_table_name not supporting resolving parameters, do I have to consider using transform now?
joshahicks
@joshahicks
@nuoyaneasy unfortunately we confirmed in our lab yesterday that the variables only apply to target catalog and target schema currently on the routers. It should be a simple addition to apply to tables as well. Created an issue.
https://www.symmetricds.org/issues/view.php?id=4158
ChaoYang
@nuoyaneasy
@joshahicks OK, I see that, thanks for your help.
zhouz
@zhouz_twitter
"Data cannot be retained in table" ... "because of the addition of the required column" <- why is that the case? Why does adding a column make symmetric orphan existing data into a table with _ at the end and start over with a blank table? is there a place to control this behavior? even having a reload-table fire would be more desirable than a blank table.
joshahicks
@joshahicks
It is because you are adding a new column that is required but does not have a default value. As a result it can not add the rows back to the table without putting fake data in here so it retains it in a temp table. If you add your new required column with a default value this would work.
zhouz
@zhouz_twitter
I see. In my case, these schema changes are controlled by the application (microsoft dynamics nav) so I can't change that behavior (of new columns having no default value). Is there any configs or controls for having something like a table-reload initiated when schema changes lead to data not being retainable?