Same filename values for different scenes

[dandon223]

Hi,
I am trying to import nuscenes metadata to relational database for my little project. I added unique_constraint to sample_data.filename and discovered that filename samples/RADAR_FRONT_RIGHT/n008-2018-08-30-10-33-52-0400__RADAR_FRONT_RIGHT__1535639656688279.pcd is duplicated in sample_data 640c279304be4ba1943b583c104ffca6 and ae47042444984f9aa5558f27085e2afd.

sample_data 640c279304be4ba1943b583c104ffca6 is assigned to sample 7ffbefad826f4cc1bd0336beb69544e6 which is scene
b07358651c604e2d83da7c4d4755de73

sample_data ae47042444984f9aa5558f27085e2afd is assigned to sample 6123a0c091d24c39ab274cdbad994bc4 which is scene 26a6b03c8e2f4e6692f174a7074e54ff.

I inverstigated some more and there are 2631083 sample_data but 2631073 distinct filenames, meaning there are 10 such duplicates.
Duplicates in question:
samples/RADAR_FRONT_RIGHT/n008-2018-08-30-10-33-52-0400__RADAR_FRONT_RIGHT__1535639656688279.pcd samples/RADAR_BACK_RIGHT/n008-2018-08-30-10-33-52-0400__RADAR_BACK_RIGHT__1535639656680377.pcd samples/RADAR_FRONT/n015-2018-09-25-13-17-43+0800__RADAR_FRONT__1537852775171566.pcd samples/RADAR_FRONT_LEFT/n015-2018-09-25-13-17-43+0800__RADAR_FRONT_LEFT__1537852775180041.pcd samples/RADAR_FRONT_RIGHT/n015-2018-09-25-13-17-43+0800__RADAR_FRONT_RIGHT__1537852775174924.pcd samples/RADAR_BACK_RIGHT/n015-2018-11-21-19-38-26+0800__RADAR_BACK_RIGHT__1542800367914021.pcd samples/RADAR_FRONT/n015-2018-11-21-19-38-26+0800__RADAR_FRONT__1542800387914488.pcd samples/RADAR_FRONT_LEFT/n015-2018-11-21-19-38-26+0800__RADAR_FRONT_LEFT__1542800387935184.pcd samples/RADAR_BACK_LEFT/n015-2018-11-21-19-38-26+0800__RADAR_BACK_LEFT__1542800387930913.pcd samples/RADAR_FRONT/n015-2018-11-21-19-38-26+0800__RADAR_FRONT__1542800547920415.pcd

Can something be done about it?

[dandon223]

I also checked that there are 2631073 files in both sweeps and samples meaning that there are 10 RADAR files missing.