We see errors like this only because MCF is a highly multithreaded application, and two threads sometimes are able to collide in what they are doing even though they are transactionally separated. That is because of bugs in the database software. So if you restart the job it should not encounter the same problem.
If the problem IS repeatable, we will of course look deeper into what is going on. Karl On Wed, Oct 27, 2021 at 9:52 AM Karl Wright <daddy...@gmail.com> wrote: > Is it repeatable? My guess is it is not repeatable. > Karl > > On Wed, Oct 27, 2021 at 4:43 AM ritika jain <ritikajain5...@gmail.com> > wrote: > >> So , it can be left as it is.. ? because it is preventing job to complete >> and its stopping. >> >> On Tue, Oct 26, 2021 at 8:40 PM Karl Wright <daddy...@gmail.com> wrote: >> >>> That's a database bug. All of our underlying databases have some bugs >>> of this kind. >>> >>> Karl >>> >>> >>> On Tue, Oct 26, 2021 at 9:17 AM ritika jain <ritikajain5...@gmail.com> >>> wrote: >>> >>>> Hi All, >>>> >>>> While using Manifoldcf 2.14 with Web connector and ES connector. After >>>> a certain time of continuing the job (jobs ingest some documents in lakhs), >>>> we got this error on PROD. >>>> >>>> Can anybody suggest what could be the problem? >>>> >>>> PRODUCTION MANIFOLD ERROR: >>>> >>>> Error: ERROR: duplicate key value violates unique constraint >>>> "ingeststatus_pkey" Detail: Key (id)=(1624*******7) already exists. >>>> >>>> >>>> Thanks >>>> >>>> >>>>