View Issue Details
| ID | Project | Category | View Status | Date Submitted | Last Update |
|---|---|---|---|---|---|
| 0004749 | SymmetricDS Pro | Bug | public | 2021-01-08 14:18 | 2021-01-11 13:48 |
| Reporter | elong | Assigned To | elong | ||
| Priority | normal | ||||
| Status | closed | Resolution | fixed | ||
| Product Version | 3.12.0 | ||||
| Target Version | 3.12.6 | Fixed in Version | 3.12.6 | ||
| Summary | 0004749: Value too long for column node_password | ||||
| Description | When adding a new group link and then registering a new node for that group link, an the node_password for sym_node_security will not load. There is a built-in transform for that table that encrypts and decrypts the node_password column, but the transform is only applied at startup. Use the config channel router and data loader filter to detect a change to sym_node_group_link and then flush the transform cache. ERROR [SYMDS-MASTER] [AcknowledgeService] [qtp121678773-13] The outgoing batch CLIENT-6 failed: [22001,22001] Value too long for column "NODE_PASSWORD VARCHAR(50) NOT NULL": "'enc:UFWb2OJKBTF6lIS2yzbeY6AFEUosjTWsAJknGNMYJcx3RD+mJ3aVF4mGBCBKzk6KmSXAxe225K3GvmNTxHp0vg==' (92)"; SQL statement: update "LOAD-ONLY-MYSQL20210108161611"."PUBLIC"."SYM_NODE_SECURITY" set "NODE_PASSWORD" = ?, "REGISTRATION_ENABLED" = ?, "REGISTRATION_TIME" = ?, "INITIAL_LOAD_ENABLED" = ?, "INITIAL_LOAD_TIME" = ?, "INITIAL_LOAD_END_TIME" = ?, "INITIAL_LOAD_ID" = ?, "INITIAL_LOAD_CREATE_BY" = ?, "REV_INITIAL_LOAD_ENABLED" = ?, "REV_INITIAL_LOAD_TIME" = ?, "REV_INITIAL_LOAD_ID" = ?, "REV_INITIAL_LOAD_CREATE_BY" = ?, "FAILED_LOGINS" = ?, "CREATED_AT_NODE_ID" = ? where "NODE_ID" = ? [22001-176] | ||||
| Tags | No tags attached. | ||||
|
SymmetricDS: 3.12 32476bee 2021-01-08 14:19:35 Details Diff |
0004749: Value too long for column node_password |
Affected Issues 0004749 |
|
| mod - symmetric-core/src/main/java/org/jumpmind/symmetric/load/ConfigurationChangedDatabaseWriterFilter.java | Diff File | ||
| mod - symmetric-core/src/main/java/org/jumpmind/symmetric/route/ConfigurationChangedDataRouter.java | Diff File | ||
| Date Modified | Username | Field | Change |
|---|---|---|---|
| 2021-01-08 14:18 | elong | New Issue | |
| 2021-01-08 14:18 | elong | Status | new => assigned |
| 2021-01-08 14:18 | elong | Assigned To | => elong |
| 2021-01-08 14:19 | elong | Status | assigned => resolved |
| 2021-01-08 14:19 | elong | Resolution | open => fixed |
| 2021-01-08 14:19 | elong | Fixed in Version | => 3.12.6 |
| 2021-01-08 15:00 | admin | Changeset attached | => SymmetricDS 3.12 32476bee |
| 2021-01-11 13:48 | admin | Status | resolved => closed |