Where communities thrive


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

    erilong on 3.12

    0004680: Spaces in sym_trigger … (compare)

  • Dec 04 00:18

    erilong on 3.12

    0004679: Snowflake module is mi… (compare)

  • Dec 02 20:55

    philipmarzullo64 on 3.12

    0004676: Insert into sym_data r… (compare)

  • Dec 01 13:48

    erilong on 3.12

    0004673: Quick test before upgr… (compare)

  • Dec 01 13:45

    erilong on 3.11

    0004672: Quick test before upgr… (compare)

  • Nov 30 19:24

    erilong on 3.12

    0004671: sym command should log… (compare)

  • Nov 27 20:54

    erilong on 3.12

    0004670: Deletes and conflict d… (compare)

  • Nov 27 14:25

    erilong on 3.12

    0004669: Extensions should relo… (compare)

  • Nov 27 14:19

    erilong on 3.12

    0004668: Extensions global BSH … (compare)

  • Nov 25 20:20

    evan-miller-jumpmind on 4663-add-parameter-encryption

    (compare)

  • Nov 25 20:20

    evan-miller-jumpmind on 3.12

    0004663: Added encrypted type t… (compare)

  • Nov 25 20:20
    evan-miller-jumpmind closed #124
  • Nov 25 20:20
    evan-miller-jumpmind opened #124
  • Nov 25 20:19

    evan-miller-jumpmind on 4663-add-parameter-encryption

    0004663: Added encrypted type t… (compare)

  • Nov 25 14:20

    evan-miller-jumpmind on 4659-edit-query-results

    (compare)

  • Nov 25 14:20

    evan-miller-jumpmind on 3.12

    0004659: Added query result edi… (compare)

  • Nov 25 14:20
    evan-miller-jumpmind closed #123
  • Nov 25 14:20
    evan-miller-jumpmind opened #123
  • Nov 25 14:19

    evan-miller-jumpmind on 4659-edit-query-results

    0004659: Added query result edi… (compare)

  • Nov 24 21:57

    erilong on 3.12

    0004661: Initial load foreign k… (compare)

Manish Kumar
@man1989
Okay i will try to create multiple node and will try to see how it works
Albrod
@Albrod
hello
im trying to add a new node into my working symmetricds the thing is this node is using a mysql 5.7 instead of postgresql 9.6 like all others nodes i have

im using symm 2.5.13 and getting this error when this new node try to get an incoming batch

org.springframework.jdbc.BadSqlGrammarException: PreparedStatementCallback; bad SQL grammar [ select batch_id, node_id, channel_id, status, network_millis, filter_millis, database_millis, failed_row_number, byte_count, statement_count, fallback_insert_count, fallback_update_count, missing_delete_count, skip_count, sql_state, sql_code, sql_message, last_update_hostname, last_update_time, create_time, error_flag from sym_incoming_batch

    where batch_id = ?::integer and node_id = ?
  ]; nested exception is java.sql.SQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '::integer and node_id = '2362725'' at line 5 
joshahicks
@joshahicks
Wow thats an old version
looks like it is not resolving something in the sql ::integer properly
you may need a new node group
sometimes the same configuration can not be used for different databases
Albrod
@Albrod
yes its old and working to update it to 3.11.8 (last one i could make it work with 2.5.13) we have 1000 nodes with this version so the upgrade will be slow in the mean time need to implement new node with mysql (all others are on postgresql 9.6)
joshahicks
@joshahicks
I would add a new node group and try
Albrod
@Albrod
i made a new node group for this but it use some of the old sym_router
could it be that where the problem is ?
in this case i have 2 nodes, one with psql 9.6 that its a concentrator and this new node on mysql 5.7 that will receive all the things the concentrator gets but no send anything to anyone
so i just reutilized some of the existent router
joshahicks
@joshahicks
yeah with a new node group for mysql you could add a new router and group links etc so that you do not affect the PG nodes
Albrod
@Albrod
node group doesn't have options but will give a try to make new routers for every table
don't know if there is a way to make one router for all tables
joshahicks
@joshahicks
Sym_trigger_router links a router to a table trigger so you can have one router linked to many tables
Thwipp
@Thwipp
Good morning all. I added a single table for replication and then restarted symmetricds. I have also run . symadmin sync-triggers and now all of my triggers are missing. All values are as expected in channel, trigger, router, etc. Has anyone encountered this before?
sync-triggers being run with --properties
Thwipp
@Thwipp
Is there solid way for adding a table to be replicated to two different sources? Should it just be added twice?
joshahicks
@joshahicks
if the nodes (sources) are part of the same group they will replicate the same configured tables
Thwipp
@Thwipp
Thanks for that Josh. I was able to get the triggers recreated as well (user error)
joshahicks
@joshahicks
ok good
(good that you were able to get them fixed not that it was user error :)
Thwipp
@Thwipp
For sure! Have a great day and thank you for all of your help
Thwipp
@Thwipp
Hey Josh, have you seen anything regarding " Could not communicate with node 'nodename:1:1' at http://localhost:31415/sync/nodename because of unexpected error StackTraceKey [SymmetricException:443694955]"?
This is going from mysql to SQL Server
joshahicks
@joshahicks
Search the log for that exception key and find first instance of it there should be a full stack trace
Josh Nijenhuis
@josiah47
Good Morning, We are getting a "Data truncation: Data too long for column 'parameters' at row 1" for a outgoing_batch
looks like sym_data.row_data is a mediumtext... but the docs https://www.symmetricds.org/doc/3.12/html/user-guide.html#_mariadb say LongText is supported...
any thoughts?
Josh Nijenhuis
@josiah47
we don't even have a column called parameters in our tables that we are syncing. so I am assuming its an internal thing to symmetricds
joshahicks
@joshahicks
what database platform
Josh Nijenhuis
@josiah47
10.3.23-MariaDB
joshahicks
@joshahicks
What is the summary data on the outgoing batch in error
sym_parameter?
Josh Nijenhuis
@josiah47
producttemplate, task, log_global
joshahicks
@joshahicks
so are those your tables?
those are not symmetric tables
Josh Nijenhuis
@josiah47
yes sir
but none of those tables have a column parameters
lol, wait a minute
got a lead
indirectly triggered a back ground task i thinks. i'll stop bugging you...
thanks for the help
Josh Nijenhuis
@josiah47
Good to go! was a custom insert in a filter
Alexandr Varyanik
@boggard

Hello.

I opened a pull request on github two weeks ago. JumpMind/symmetric-ds#122.
PR is still open and has not feedback or anything else.

Is there someone who works with PRs and processes/reviewes them?

joshahicks
@joshahicks
Sorry for the delay we usually review as a team every Wednesday but have busy with quite a bit of other work. I will make sure we take a look at pull requests at our next Wednesday engineers meeting. Thanks for the reminder.
Alexandr Varyanik
@boggard
Understood. Thanks for reply!