Re: EO_PK_TABLE and weird stuff
Re: EO_PK_TABLE and weird stuff
- Subject: Re: EO_PK_TABLE and weird stuff
- From: Timothy Worman <email@hidden>
- Date: Thu, 03 Jul 2014 15:15:03 -0700
I haven’t done any maintenance lately and I’ve never done any individual table restores with this database - I always do full dumps. So it’s unlikely that any tables would individually have their state changed.
I checked the value yesterday to confirm that it properly incremented after a successful add of a record. It did - so I was relieved about that. It sits (properly) at 16667 right now.
Where is the code that handles this? Deep in the bowels of EOF or in the DB plug-in?
Tim
On Jul 3, 2014, at 3:00 PM, Ken Anderson <email@hidden> wrote:
> This usually happens to me when I restore database tables and forget about EO_PK_TABLE. Have you checked to see what value is in EO_PK_TABLE right now?
>
> Have you done any maintenance to your DB lately?
>
> Ken
>
> On Jul 3, 2014, at 5:56 PM, Timothy Worman <email@hidden> wrote:
>
>> All:
>>
>> This week I had something happen that I’d never experienced before. I had two EO’s get inserted without incrementing the pk value in EO_PK_TABLE. The app is a self-serve account creation tool that injects records into LDAP - so the EO is <Person>.
>>
>> The last id’s to be used for this Person entity were:
>>
>> 16662 2014-06-25 13:57:33 -0700
>> 16663 2014-06-25 13:59:49 -0700
>> 16664 2014-07-02 08:25:37 -0700
>> 16665 2014-07-02 12:35:36 -0700
>>
>> Jul 02 12:02:43PM I have a person trying to create a record for themselves and it attempts to use 16662 as the person_id. Then, at Jul 02 12:11:23PM, there is an attempt by the same person and the pk selected is 16663.
>>
>> On the chance that this possibly continues to happen, where should I be looking to figure out what might be occurring here.
>>
>> Tim
>> UCLA GSE&IS
>> _______________________________________________
>> Do not post admin requests to the list. They will be ignored.
>> Webobjects-dev mailing list (email@hidden)
>> Help/Unsubscribe/Update your Subscription:
>>
>> This email sent to email@hidden
>
_______________________________________________
Do not post admin requests to the list. They will be ignored.
Webobjects-dev mailing list (email@hidden)
Help/Unsubscribe/Update your Subscription:
This email sent to email@hidden