I don’t think that’s the case. Its happening in all databases. It has not to do with scripting, simply the automation itself.
I happens by using the ‘create entity’ action, but because the trigger applies to all entities of the lookup parent entity, this action happens as good as simultaneously to multiple, so that may be the reason the ids are duplicated.
I checked the fields, and this happens without any special field other than a relationship and lookup field, and the automation that creates them. Nothing special about the fields. No custom id field.
I can show you that Fibery entity view confirms this issue: