[Vtigercrm-developers] Duplicate modentity_num...

[Joe Bordes]

Yes, it has to happen during the sequence update, it isn't that 
difficult and may happen if you create:

When the import finishes it picks up the last sequence number, then it 
starts updating all the imported records, during that process, a new 
record is created and the seq incremented, then the import update 
finishes and updates the seq to the last value used.

You have to create the record during the update process, because it 
updates at the end, not after processing each record.

Obviously the import update is a fast process, but on a big import set 
it can happen.

Joe
TSolucio


El 09/10/14 a las #4, Alan Lord escribió:
> On 09/10/14 08:18, Joe Bordes wrote:
>> If I remember correctly and it hasn't changed, the entity numbers are
>> added at the end of the import process in a bulk sequential process,
>> that would explain what happened. I guess you can't be creating while
>> importing.
>
> Yes - that's right Joe. This is a 5.4.0 system. I've seen before when 
> doing large imports you can page through a list of just-imported 
> records and the entity numbers get added afterwards.
>
> That's what made me think it might be to do with that.
>
> Still can't quite understand how two people can get the same number 
> though? The individual user and the import process must have hit the 
> request at *exactly* the same time...
>
> Cheers
>
> Al
>
>
> _______________________________________________
> http://www.vtiger.com/