View Revisions: Issue #4933
| Summary | 0004933: Invalid MySQL update statement that queries same table when starting load to multiple nodes | ||
|---|---|---|---|
| Revision | 2021-03-31 18:20 by matthewwhittenham | ||
| Description | I am getting the following SQLException: Failed to execute EXTRACT for node XXX and channel default. You can't specify target table 'sym_extract_request' for update in FROM clause when running SymmetricDS. My setup is a single SymmetricDS instance with 1 x "master" node, and 2 x "local" nodes - where the master node is the main node and the local nodes are in a separate node group together. My master node connects to an AWS Aurora MySQL database, using the MariaDB JDBC driver. The local nodes connect to SQLite Database files stored locally on my machine, using the standard SQLite JDBC driver. |
||
| Revision | 2021-04-23 14:53 by elong | ||
| Description | I am getting the following SQLException: Failed to execute EXTRACT for node XXX and channel default. You can't specify target table 'sym_extract_request' for update in FROM clause when running SymmetricDS. My setup is a single SymmetricDS instance with 1 x "master" node, and 2 x "local" nodes - where the master node is the main node and the local nodes are in a separate node group together. My master node connects to an AWS Aurora MySQL database, using the MariaDB JDBC driver. The local nodes connect to SQLite Database files stored locally on my machine, using the standard SQLite JDBC driver. |
||