BUG #17892: Bug primary key

The following bug has been logged on the website:

Bug reference:      17892
Logged by:          Comanici Bogdan
Email address:      comanicibogdy@yahoo.com
PostgreSQL version: 13.9
Operating system:   Debian 11
Description:

We have a database with over 3 milions apps in it
Something happend we just found duplicates with same id, but we have
constraints : PRIMARY KEY on id

How it's happened?
ID(PRIMARY KEY) SLUG(UNIQUE KEY)
29181513    nottiled    0    Home-and-Hobby    Recreation    mirwanda-center    false    0    false    false    false
true    false    2019-07-15 
11:53:38.000    2023-04-10
21:44:34.000    0.0    0.0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    NotTiled    0
 0.00    1.8.6    Freeware            0.0    2022-09-19    adsense    true    0            2    false
 
29181513    nottiled    0    Home-and-Hobby    Recreation    mirwanda-center    false    0    false    false    false
true    false    2019-07-15 
11:53:38.000    2023-03-25
14:32:55.000    0.0    0.0    0    26    0    1    0    26    0    0    5    0    0    0    5    0    0    NotTiled
22020096   0.00    1.7.0a    Freeware            0.0    2021-09-03    adsense    true    20230410            2
false

We tried manually to insert a new row with same value, get error for unique
key slug