Duplicate key error! But there is no duplicate data

Question

I'm getting the following error:

ERROR ERROR #23505 duplicate key value violates unique constraint "tableName_pkey": 
ERROR Error while creating table record =  Record not inserted!:

A little background:

My service was working fine on my branch and there was no duplicate key error.
But my service started throwing this duplicated error ever since I merged my code with my colleague.

I have tried to find the mistake but unable to track it.
Every time unique data is being sent to the table but still this error is displayed.

Can you share the schema of the table, the hypertable and few insert statements? — k_rus, Nov 27 '19 at 08:15

score 0 · Accepted Answer · answered Nov 27 '19 at 05:52

You could try and use git bisect, as in here.

Actually, since you know the error comes from one of the commits from your colleague's merged branch, you could try and merge incrementally that branch (by merging only the first commit of that branch, then the second, and so on), checking each time if those changes introduces the bug you are experiencing.

Duplicate key error! But there is no duplicate data

1 Answers1