Duplicate / Identical Auto ID from Row Creation in Prod

[EmonSM]

Hi,

I noticed a serious issue with the Auto ID column in my form: duplicate numbers are frequently being assigned to the Auto ID field, even though the autogenerated field promises uniqueness.

See screenshots:

I'm aware that the same issue was discussed in this thread #7105, but the root cause of my issue must be completely different, as I verified that the duplicate Auto ID rows were all created in prod (as the users responsible did not have access to dev). Therefore, these duplicate Auto ID values cannot be due to the same prod & dev sync issue identified in that thread.

Please look into why this is occurring, as my Budibase integration relies on this Auto ID field being a unique identifier for each row.

If the cause can't be identified, is there a way to always force an increment somehow? It's fine for me if there's potentially some values skipped in such an approach, I only need uniqueness guaranteed.

Thank you in advance!

[melohagan]

Hey @EmonSM

Would you be able to share your app export to: [email protected] ?

Do you have automations that create rows into this table? Just a thought.

[EmonSM]

Hey @melohagan,

Thanks for the quick response. No, we don't have any automations that create rows into this table. All of the duplicate Auto ID rows were manually created by users in the prod app. The typical scenario was that the same individual would create two different form submissions minutes apart and the Auto ID was duplicated for some reason.

We will follow your suggestion and share the app export to [email protected].

Thanks,
Emon

[applicationuser]

Hello @melohagan

we also noticed similar issue , initial table data was loaded through CSV import.

Later created an automation to update and add rows. On Automation execute, Create row automation step added row that had duplicate Auto ID value

Budibase Cloud
app version : 2.2.22
App not published yet, error noticed in development mode

[DustinDobernig]

Had the same issue happen today. Not certain what caused it. My app is all based on this functionality as well.

2.7.26.
Self Hosted

[Shadowfita]

I've experienced this as well.

[Shadowfita]

@melohagan is there a way to update the AutoIDs? This is a pretty breaking issue for some data structures in my app.

[melohagan]

One way could be to create an automation that queries rows (sorting on the auto ID ascending) and then doing an update / delete row action on loop to merge rows.

Alternatively if you want to keep both rows that have a duplicate Auto ID, then your automation could create a new row for each duplicate, and then delete that duplicate.