You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@manifoldcf.apache.org by ritika jain <ri...@gmail.com> on 2021/10/26 13:17:14 UTC
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
Re: Duplicate key error
Posted by Karl Wright <da...@gmail.com>.
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 <da...@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 <ri...@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 <da...@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 <ri...@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
>>>>
>>>>
>>>>
Re: Duplicate key error
Posted by Karl Wright <da...@gmail.com>.
Is it repeatable? My guess is it is not repeatable.
Karl
On Wed, Oct 27, 2021 at 4:43 AM ritika jain <ri...@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 <da...@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 <ri...@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
>>>
>>>
>>>
Re: Duplicate key error
Posted by ritika jain <ri...@gmail.com>.
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 <da...@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 <ri...@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
>>
>>
>>
Re:
Posted by Karl Wright <da...@gmail.com>.
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 <ri...@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
>
>
>