View Issue Details
ID | Project | Category | View Status | Date Submitted | Last Update |
---|---|---|---|---|---|
0004657 | SymmetricDS | Bug | public | 2020-11-24 00:40 | 2024-12-31 19:07 |
Reporter | FutureChalk | Assigned To | |||
Priority | normal | ||||
Status | feedback | Resolution | open | ||
Product Version | 3.12.4 | ||||
Summary | 0004657: Symmetric generates a dependancy error when a constraint refers to an index. The index does exist. | ||||
Description | Process is the sync from registration server to client. There are no missing indexes they are in the source database. What happens is that the sync progresses fine and then an error occurs saying such and such index is missing and is needed in a constraint. Yet the index is in the source database. To clear the error you just create the missing index and then the sync continues withou a hitch. Sometimes it work all the way through without failing. The other interesting thing is that it is not always the same index. In our setup it usually occurs on one of three indexes. When looking at the postgres log you can see the index add and then a short bit later it says the index is a duplicate. Not sure where to look. It appears to be a timing of maybe batches getting out of sync. | ||||
Steps To Reproduce | This error occurs most of the time but not all the time. Process is the sync from registration server to client. There are no missing indexes they are in the source database. What happens is that the sync progresses fine and then an error occurs saying such and such index is missing and is needed in a constraint. Yet the index is in the source database. To clear the error you just create the missing index and then the sync continues withou a hitch. Sometimes it work all the way through without failing. The other interesting thing is that it is not always the same index. In our setup it usually occurs on one of three indexes. When looking at the postgres log you can see the index add and then a short bit later it says the index is a duplicate. Not sure where to look. It appears to be a timing of maybe batches getting out of sync. | ||||
Additional Information | 1. Symmetricds Version 3.12.4 2. Database is Postgresql version 12 3. Operating systems tried on Windows 10, Mac Catalina, SME Server. Description of Problem | ||||
Tags | No tags attached. | ||||
|
Can you attach a log file with the error? |
|
This is part of the symmetric log. An error occurred on line 12855 of log. |
|
This is part of the symmetric log. An error occurred on line 12855 of log. |
|
So, over 8 months now. Any resolution? |
|
Can you provide your whole config? Or if you don't, can you provide an export of sym_trigger and sym_trigger_router tables? |
|
It would normally create tables without any constraints, load the data, then add the constraints on afterwards. The initial.load.defer.create.constraints parameter defaults to true, which controls that behavior. Have you changed any parameters? Are you starting an initial load? How are you starting it? |
|
To answer @elong questions. The parameters are all defaulted except the post sql commands has a script (fails before the script starts), otherwise it is all initial load at startup. Nothing special is done. |
|
Waiting on the following information: 1) An export of your configuration, like pmarzullo requested earlier 2) The table definitions for gpcounty and gpstate 3) Steps to reproduce the issue |
Date Modified | Username | Field | Change |
---|---|---|---|
2020-11-24 00:40 | FutureChalk | New Issue | |
2020-11-24 13:17 | elong | Assigned To | => elong |
2020-11-24 13:17 | elong | Status | new => feedback |
2020-11-24 13:17 | elong | Note Added: 0001857 | |
2020-11-25 04:11 | FutureChalk | Note Added: 0001858 | |
2020-11-25 04:11 | FutureChalk | File Added: symmetricError.log | |
2020-11-25 04:11 | FutureChalk | Status | feedback => assigned |
2020-11-25 04:12 | FutureChalk | Note Added: 0001859 | |
2020-11-25 04:12 | FutureChalk | File Added: symmetricError-2.log | |
2021-08-02 05:44 | gsimpson | Note Added: 0001971 | |
2021-08-04 18:23 | pmarzullo | Note Added: 0001974 | |
2021-10-06 19:05 | elong | Note Added: 0002010 | |
2021-10-13 02:01 | FutureChalk | Note Added: 0002012 | |
2024-12-31 19:07 | emiller | Assigned To | elong => |
2024-12-31 19:07 | emiller | Status | assigned => feedback |
2024-12-31 19:07 | emiller | Note Added: 0002570 | |
2024-12-31 19:07 | emiller | Note Edited: 0002570 | View Revisions |