Re: Should read selects on one mysql session cause inserts on another to fail?
Dean Ellis <[email protected]>
| Newsgroups | gmane.comp.db.mysql.bugs |
|---|---|
| Message-ID | <[email protected]> |
On 09:26 Thu 15 Jan , Ashok Vadekar wrote: > I'm trying to evaluate mySQL for a commercial use. The first thing I want to > do is use prepared statements for a large number of inserts. At the same time, > I will have other threads reading from the database. > > In my initial testing, when I use a mysql session to do a select on the table > that the inserting session is using, it causes the inserting session to fail > with a Duplicate key error. The inserting session sequentially inserts > incrementing key values, so it can't really be a duplicate insert. Thank you for the test case! I have repeated the behavior you report, and it does appear to be a bug. We have a report that may be related to this regarding prepared UPDATEs, but I will enter this into our bugs database with your test case. Best regards, -- Dean Ellis, Support Engineer & Software Developer MySQL AB, www.mysql.com Want to swim with the dolphins? (April 14-16, 2004) http://www.mysql.com/uc2004/ -- MySQL Bugs Mailing List For list archives: http://lists.mysql.com/bugs To unsubscribe: http://lists.mysql.com/[email protected]