Error while importing data

I don't have an easy answer, but a few things come to mind that you might want to check:

(1) Did you delete any indexes which were related to the attribute (uid) you enabled uniqueness on?

(2) Did you delete any of the system indexes listed in the Admin guide table 10-1?

(3) If you deleted any of the default indexesin table 10-2, are you sure that they were not being used?

(4) Are you using Multi-Master Replication? (If so check the warnings in the docs)

(5) Do you know if you have any duplicate uids in your existing data or in the data you're adding?

You might try reverting your changes, rebuilding your indexes (see page 350 of the Admin Guide), and running the inserts anew.

I'm wondering why you both disabled the indexes (presumably to improve modify performance) and enabled the uid uniqueness plugin (which will probably cause a hit on modify performance). Modifies should be much less frequent than reads (unlike many relational databases), so you may not have enough modify activity to warrant fine tuning of it.

Good Luck,

-Scott-

Scott.R.Corzinea at 2007-7-12 9:07:02 >