View Issue Details
| ID | Project | Category | View Status | Date Submitted | Last Update |
|---|---|---|---|---|---|
| 0006235 | SymmetricDS Pro | Bug | public | 2024-02-09 08:07 | 2024-05-22 17:24 |
| Reporter | Tadiwanashe | Assigned To | pmarzullo | ||
| Priority | high | ||||
| Status | closed | Resolution | fixed | ||
| Product Version | 3.15.3 | ||||
| Target Version | 3.15.0 | Fixed in Version | 3.15.0 | ||
| Summary | 0006235: Linking table is failing to replicate with error "There is 1 table without a primary key, which can cause slow replication." | ||||
| Description | I have a couple of linking tables that replicate. (By linking I mean it's the bridge between a many to many relationship). I have added a new one now and it fails saying there is no primary key. The table does have a composite primary key though, just like all the other linking tables I have set up that are replicating. | ||||
| Steps To Reproduce | Create two tables, then create a bridge for the two tables with just two columns in it. Id for table 1 and ID for table 2. Making the combination of those two your primary key. | ||||
| Tags | No tags attached. | ||||
|
|
What version did you experience this issue, where all columns in the table are part of the primary key, and the warning about this table not having a primary key? This was a problem before 3.14.10, and was fixed in 3.14.10 by issue 5976 (and was put into 3.15.0), located here: https://issues.symmetricds.org/view.php?id=5976 I just tested using version 3.15.3, creating a table with two columns, both columns are part of the primary key, and there was no warning about the table not having a primary key. What is the DDL specification of the bridge table? |
| Date Modified | Username | Field | Change |
|---|---|---|---|
| 2024-02-09 08:07 | Tadiwanashe | New Issue | |
| 2024-02-14 19:20 | pmarzullo | Assigned To | => pmarzullo |
| 2024-02-14 19:20 | pmarzullo | Status | new => feedback |
| 2024-02-14 19:20 | pmarzullo | Note Added: 0002411 | |
| 2024-05-22 17:24 | emiller | Status | feedback => closed |
| 2024-05-22 17:24 | emiller | Resolution | open => fixed |
| 2024-05-22 17:24 | emiller | Fixed in Version | => 3.15.0 |