Re: duplicate key error on autoincrement field while inserting

2001-04-24 Thread Dan Shapella
oincrement problems at virtually the same time. And this is the only app running on this system. Why did MySql decide these 2 keys already exist when in fact they don't? >From: Gerald Clark <[EMAIL PROTECTED]> >To: Dan Shapella <[EMAIL PROTECTED]> >CC: [EMAIL PROTECTED]

Re: duplicate key error on autoincrement field while inserting

2001-04-24 Thread Gerald Clark
What operating system are you running, and how big are these files and indicies? Is this a 2 Gig file size limit problem? You are getting near the limit to the size of an unsigned mediumint. Dan Shapella wrote: > > I have a weird one here. > > I have an application that inserts records into

duplicate key error on autoincrement field while inserting

2001-04-24 Thread Dan Shapella
I have a weird one here. I have an application that inserts records into one of 2 different tables. The other day, an insert attempt on one of the tables failed with a duplicate key error on key 1, an autoincrement field. About a minute later, an insert attempt on the other table failed simi