I'm glad to see that you were able to find a work around. If you upgrade to the latest 3.16.8 you will be able to use Symmetric transforms along with a host of other new features and bug fixes.
This error indicates that there may be an issue with DB permissions. It is pointing to an inability to select from the sym_parameter table. Could you please verify that the DB account for SymmetricDS is allowed to SELECT, UPDATE, DELETE from newly created table(s)? Also, could you verify that your JDBC driver version matches the server version? The meta data surrounding table structure is not being returned to SymmetricDS.
Yes, node group pushing to itself will work. It is like a multi primary.
Can you provide steps to reproduce this situation? Also we have opened a ticket for this issue that can be found here: https://issues.symmetricds.org/view.php?id=6997 You can add steps to reproduce this issue there.
This issue is fixed in 3.16.3. A link to the issue in the tracker can be found here: https://issues.symmetricds.org/view.php?id=6910 Alternatively you can flip the following parameter from true: sync.use.ready.queues=false
This issue is fixed in 3.16.3. A link to the issue in the tracker can be found here: https://issues.symmetricds.org/view.php?id=6910 Alternatively you an flip the following parameter from true: sync.use.ready.queues=false
Was this set on the correct database? This would need to be on the database for node 004. The error is occurring on the client side node. Symmetric pools its connections, you may need to restart it to pick up the setting change.
"thread_id is 0." Thread ID being 0 is correct. Is the batch not being loaded on the target? Are you seeing the data from the source node loaded on the target node? Are you resetting the test with a different table? There was a batch 14 on 4-30, and in the above log snippet there was also a batch 14 on 5-02. In addition the message is not an error, but rather just an info statement saying the extract has been running for more than 60 seconds. Would you be able to attach a SymmetricDS support snapshot?...