Duplicate Row IDs

Bug Reports
1

I manually created a row in a database and the Row Id was the same as the previous
IMAGE1
this is not a visual glitch as one of my flows uses the row id as a unique identifier and this caused a duplicate entry error
IMAGE2
If you see in the json below the id field has 58 twice
IMAGE3
IMAGE4
Creating a new row then shows the new row as row 59
IMAGE5

I havent been able to reproduce this yet

astro wanted to report this, but got limited to 1 embed for new users
i dont know the order of the images :joy:
image
image
image

image
image921×848 34.7 KB

image

2

I only asked 8bit to report this as i was unable to due to image embed restrictions for “new users”

3

The Image order is slightly out of sorts but it should be pretty clear what is referencing what

4

I’ve seen this before, we don’t have strict locking on DB rows (other than creations being transactional) so this can happen. This will likely be improved in the future.

5

DBs will probably be switching to UUID-based IDs in the future to combat this. More details to come.