View Issue Details

IDProjectCategoryView StatusLast Update
0004657SymmetricDSBugpublic2021-10-13 02:01
ReporterFutureChalk Assigned Toelong  
Prioritynormal 
Status assignedResolutionopen 
Product Version3.12.4 
Summary0004657: Symmetric generates a dependancy error when a constraint refers to an index. The index does exist.
DescriptionProcess 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 ReproduceThis 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 Information1. 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
TagsNo tags attached.

Activities

elong

2020-11-24 13:17

developer   ~0001857

Can you attach a log file with the error?

FutureChalk

2020-11-25 04:11

reporter   ~0001858

This is part of the symmetric log. An error occurred on line 12855 of log.
symmetricError.log (663,306 bytes)

FutureChalk

2020-11-25 04:12

reporter   ~0001859

This is part of the symmetric log. An error occurred on line 12855 of log.
symmetricError-2.log (663,306 bytes)

gsimpson

2021-08-02 05:44

reporter   ~0001971

So, over 8 months now. Any resolution?

pmarzullo

2021-08-04 18:23

developer   ~0001974

Can you provide your whole config?
Or if you don't, can you provide an export of sym_trigger and sym_trigger_router tables?

elong

2021-10-06 19:05

developer   ~0002010

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?

FutureChalk

2021-10-13 02:01

reporter   ~0002012

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.

Issue History

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