Icon View Thread

The following is the text of the current message along with any replies.
Messages 1 to 6 of 6 total
Thread Duplicate key
Mon, Feb 27 2006 2:54 AMPermanent Link

"Godfrey"
Dbisam V4.22 B5

Hi All

I am picking up a duplicate key error on a table with a autoinc primary key
(Unique).  There are not other unique
indexes on the table.  It happens once in a while and the only way to get
rid of it is to switch off the machine and do a repair on the table.  If I
view the table in DBSys there appears to nothing wrong with it.

I am using a local database with up to approx 5 users, also using
transactions when editing and posting.

Problem seems to occur when system is busy.

Any suggestions

Mon, Feb 27 2006 7:10 AMPermanent Link

Tim Young [Elevate Software]

Elevate Software, Inc.

Avatar

Email timyoung@elevatesoft.com

Godfrey,

<< I am picking up a duplicate key error on a table with a autoinc primary
key (Unique).  There are not other unique indexes on the table.  It happens
once in a while and the only way to get  rid of it is to switch off the
machine and do a repair on the table.  If I view the table in DBSys there
appears to nothing wrong with it. >>

What does the repair say is wrong with the table ?  Is there any chance that
someone is shutting off their machine improperly after working with your
application ?

<< I am using a local database with up to approx 5 users, also using
transactions when editing and posting.>>

This is peer-to-peer, correct ?

--
Tim Young
Elevate Software
www.elevatesoft.com

Mon, Feb 27 2006 7:32 AMPermanent Link

"Godfrey"
Hi Tim

What does the repair say is wrong with the table ?

Unfortunately it seems to happen at the most unopportune moment like late on
a Saturday.
I was not onsite at the time.  It is a pos system and I had to get it up and
running asap.
Did not manage to get any details.

Is there any chance that someone is shutting off their machine improperly
after working with your
application ?

There is unfortunately a chance of this happening with my clients.  The
system however should only be shutdown
at the end of the evening.

> This is peer-to-peer, correct ?

Yes

Thanks
Godfrey


Tue, Feb 28 2006 8:46 AMPermanent Link

Tim Young [Elevate Software]

Elevate Software, Inc.

Avatar

Email timyoung@elevatesoft.com

Godfrey,

<< There is unfortunately a chance of this happening with my clients.  The
system however should only be shutdown at the end of the evening. >>

You could log the application startups to a table (call FlushBuffers after
the insert to preserve it in case of a crash) or text file and use that to
analyse this.  It will at least help you determine what is going on.

--
Tim Young
Elevate Software
www.elevatesoft.com

Thu, Mar 2 2006 1:05 AMPermanent Link

"Godfrey"
Hi Tim

I am using ForceFlushBuffers for the entire app.  I notice recentlyyou have
been advising to rather use FlushBuffers after each post.  Does this make a
big difference?

Thanks
Godfrey


"Tim Young [Elevate Software]" <timyoung@elevatesoft.com> wrote in message
news:3F4A960D-9296-4026-B545-A7F9F73A8340@news.elevatesoft.com...
> Godfrey,
>
> << There is unfortunately a chance of this happening with my clients.  The
> system however should only be shutdown at the end of the evening. >>
>
> You could log the application startups to a table (call FlushBuffers after
> the insert to preserve it in case of a crash) or text file and use that to
> analyse this.  It will at least help you determine what is going on.
>
> --
> Tim Young
> Elevate Software
> www.elevatesoft.com
>
>

Thu, Mar 2 2006 9:39 AMPermanent Link

Tim Young [Elevate Software]

Elevate Software, Inc.

Avatar

Email timyoung@elevatesoft.com

Godfrey,

<< I am using ForceFlushBuffers for the entire app.  I notice recentlyyou
have been advising to rather use FlushBuffers after each post.  Does this
make a big difference? >>

It can in some cases, but if you haven't noticed a difference then I
wouldn't change a thing if I were you. Smiley

--
Tim Young
Elevate Software
www.elevatesoft.com

Image