>If you run the app again, does it give errors on the same record again? >If you move the record in question up or down in the sequence of >inserts, does it still give errors on that record?
Don't know about the commit. I have set autocommit to 250 but that is connection by connection and I'm using two different connections. So, it is possible. On the other hand, both the child and the parent record already existed in the database -- this is an update rather than an insert. And, yes, when I re ran the application, it failed on the same record. I can't move the sequence because I'm actually exporting data from a collection of unprocessed documents. My most recent effort, currently under way, is to change the autocommit of the parent table connecttion to 1, then see if it clears up. I'm still quite uncertain however, since the application processed 26,000 records before failing on the one. There is nothing particularly unique or unusual about the one record if failed on except that it was one of the newer documents. Thanks for the thoughts. Randy -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]