[Vtigercrm-developers] Duplicate CRMIDs 5.40

[Daniel Thompson]

+1,

I have found this recently with 2 Contact Records when testing a migration
process to V6.

Regards,

Danny


On 8 January 2014 11:05, Stefan Warnat <ich at stefanwarnat.de> wrote:

> Hy,
>
> Yesterday I found a very strange situation in one of my clients vtiger 5.4
> systems.
> The System ~250k records contains Leads with a leadid, which isn't a
> "setype LEAD" in vtiger_crmentity.
> Some are Contacts, other Accounts, Tickets, ...
> Also the ID exist correctly in the respective tables of contacts,
> accounts, ...
>
> I create the following problem situation:
> Two records are created in absolutely the same moment. (The createdtime
> column is completely equal)
> Because ADODB don't lock the sequence table, there could be a chance of
> duplicate crmid's, I suspect.
> I'm not fully sure how safe the used "LAST_INSERT_ID(id+1)" is.
> The normal "LAST_INSERT_ID()" is per connection, but only get back a auto
> increment.
>
> Anyone other with this problem?
>
> Stefan
>
> _______________________________________________
> http://www.vtiger.com/
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.vtigercrm.com/pipermail/vtigercrm-developers/attachments/20140108/d0f7d787/attachment.html>