>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]

Reply via email to