View Issue Details
| ID | Project | Category | View Status | Date Submitted | Last Update |
|---|---|---|---|---|---|
| 0000963 | SymmetricDS | Bug | public | 2012-12-19 11:51 | 2019-06-25 18:06 |
| Reporter | gemisigo | Assigned To | josh-a-hicks | ||
| Priority | high | ||||
| Status | closed | Resolution | fixed | ||
| Product Version | 3.2.0 | ||||
| Target Version | 3.10.3 | Fixed in Version | 3.10.3 | ||
| Summary | 0000963: Update and delete does not sync on tables with varbinary primary key | ||||
| Description | When a table contains one single varbinary column and it is the primary key, inserts do propagate from source to target but updates and deletions don't. | ||||
| Steps To Reproduce | Create a table with a single varbinary(13) column and let that be the primary key. Insert a few records. Inserts will sync, sym_data table has the varbinary data in row_data and NULL in both pk_data and old_data columns. Now when you try to delete a record, the logs show there's been a pull that routed 1 data event but nothing changes, the record is not deleted. A peek at sym_data table at the source revealed that the row_data column is NULL (I'm not sure if that's relevant or not) but both pk_data and old_data columns contain empty strings. Altough it's a bit strange to change the primary key column, I tried to update it just out of curiosity. The change wasn't captured at all. | ||||
| Additional Information | Source is MSSQL 2k8 R2. Target is MySQL 5.1.66. I haven't tried this when there are more than one columns in the tables but I guess that wouldn't change anything as long as the varbinary column is the primary key. | ||||
| Tags | data sync | ||||
| related to | 0003936 | closed | josh-a-hicks | MSSQL Server to allow varbinary and binary in the where clause (updates and deletes) |
| related to | 0002563 | closed | josh-a-hicks | When Primary key is binary; SymmetricDS fails capture changes. |
|
|
Have you tried to set use_stream_lobs on sym_trigger? |
|
|
I've tried your suggestion of setting use_stream_lobs to 1 but now I get an error message when I try to insert into that table: Msg 16924, Level 16, State 1, Procedure SYM_ON_I_FOR_VB_PRB_BSDT, Line 3 Cursorfetch: The number of variables declared in the INTO list must match that of selected columns. |
|
|
That sounds like 2 bugs. We'll resolve them in the next point release. |
|
|
Thank you very much. Any info on the release? The roadmap shows schedule for 2012-12-18. |
|
|
It looks like we are still running into this problem. Has this really not been fixed since 2012? |
|
|
Fixed for SQL-Server in 0003936 but need to try for MySQL/MariaDB. |
| Date Modified | Username | Field | Change |
|---|---|---|---|
| 2012-12-19 11:51 | gemisigo | New Issue | |
| 2012-12-20 02:46 | chenson | Note Added: 0000173 | |
| 2012-12-20 09:40 | gemisigo | Note Added: 0000174 | |
| 2012-12-20 13:37 | chenson | Note Added: 0000175 | |
| 2012-12-20 13:37 | chenson | Target Version | => 3.2.1 |
| 2012-12-21 08:52 | gemisigo | Note Added: 0000177 | |
| 2013-01-03 02:01 | chenson | Target Version | 3.2.1 => 3.3.0.pre.1 |
| 2013-01-30 01:56 | chenson | Target Version | 3.3.0.pre.1 => 3.4.0 |
| 2013-03-18 00:56 | chenson | Target Version | 3.4.0 => |
| 2018-02-28 19:34 | rayp | Note Added: 0001135 | |
| 2019-04-23 12:30 | elong | Tag Attached: data sync | |
| 2019-05-13 19:34 | elong | Relationship added | related to 0003936 |
| 2019-05-13 19:35 | elong | Note Added: 0001472 | |
| 2019-05-13 19:36 | elong | Assigned To | => user606 |
| 2019-05-13 19:36 | elong | Status | new => assigned |
| 2019-05-13 19:36 | elong | Target Version | => 3.10.3 |
| 2019-05-14 12:32 | elong | Relationship added | related to 0002563 |
| 2019-05-14 15:11 | pmarzullo | Priority | normal => high |
| 2019-05-15 14:55 |
|
Assigned To | user606 => josh-a-hicks |
| 2019-05-16 15:16 | josh-a-hicks | Status | assigned => resolved |
| 2019-05-16 15:16 | josh-a-hicks | Resolution | open => fixed |
| 2019-05-16 15:16 | josh-a-hicks | Fixed in Version | => 3.10.3 |
| 2019-06-25 18:06 | admin | Status | resolved => closed |