Sladjan Vasic

We have a router which routes data from "codelist" tables to client nodes based on table specific rules. In past this router was of type default, which meant that all "codelist" data should be routed to all target nodes of targeted node group. Recently we extended database model in a way, that some of the "codelist" tables became "region" specific. These region specific rules are written in a properties table, for each "codelist" table. Based on these rules, router would decide if data from specific...

Hello, Is there a way to get a reference to a "table name" of data, that is beeing routed? ie in subselect type I would need somthing like c.external_id in (select STORE_ID from XYZ where column = :COLUMN and :TABLE_NAME like 'XX%')

I tried to repeat this problem. I restored database and upgraded symmetricds as in previous try. First it created temp table, then after restart it did move everything back to original table. It didn't make sense to me as I did everything the same as first time, so I retried the whole process again. Now it created the same problem. Temp table was not removed, and all bacthes were left in temp table, while original table was empty. This indeed is strange. I think this may be due to very large table....

Yes it is created, but the data from a temp table is not moved back to a "new" table. As a "new", I mean the same SYM_OUTGOING_BATCH table that was altered with some column changes. After restarting SymmetricDS, new batches are creating as usual, but I'm not sure if the batches from a temp SYM_OUTGOING_BATCH_ table, whose status is still in "NE" be sent to nodes, or will these unrouted data changes be lost?

We have a problem when registering node. Only one table gets stuck when trying to send batch from server to client. It happens only on reload channel. On the client side we can see error: java.net.SocketTimeoutException: Read timed out at java.net.SocketInputStream.socketRead0(Native Method) at java.net.SocketInputStream.socketRead(Unknown Source) at java.net.SocketInputStream.read(Unknown Source) at java.net.SocketInputStream.read(Unknown Source) at java.io.BufferedInputStream.fill(Unknown Source)...

Hi, Recently on test environment, we upgraded symmetricds version from 3.8.30 to 3.9.9 ... We saw that table SYM_OUTGOING_BATCH was (due to uncompatible model changes) renamed to SYM_OUTGOING_BATCH_ (with underscore at the end) New table SYM_OUTGOING_BATCH that was created was empty after upgrade. Will symmetric route data that has not yet been routed to nodes, but was moved to SYM_OUTGOING_BATCH_ table after this upgrade?

Hi, Recently on test environment, we upgraded symmetricds version from 3.8.30 to 3.9.X ... We saw that table SYM_OUTGOING_BATCH was (due to uncompatible model changes) renamed to SYM_OUTGOING_BATCH_ (with underscore at the end) New table SYM_OUTGOING_BATCH that was created was empty after upgrade. Will symmetric route data that has not yet been routed to nodes, but was moved to SYM_OUTGOING_BATCH_ table after this upgrade?

Hi, Recently on test environment, we upgraded symmetricds version from 3.8.30 to 3.9.X ... We saw that table SYM_OUTGOING_BATCH was (due to uncompatible model changes) renamed to SYM_OUTGOING_BATCH_ (with underscore at the end) New table SYM_OUTGOING_BATCH that is beeing created is empty after upgrade. Will symmetric route data that has not yet been routed, but was moved to SYM_OUTGOING_BATCH_ table?