I have a rails app that has a sync feature which looks up a remote
database and
updates the local database accordingly. Anyway, things work great for
the most
part, but there is a section of code which seems to randomly raise
errors. I
have something like this:
homelinks = Syncinventorydesc.find(:all)
InventoryDescription.delete_all()
for link in homelinks
locallink = InventoryDescription.new()
locallink.inventory_id = link.inventory_id
locallink.description_id = link.description_id
locallink.save!
end
this code tears down the local table completely before going through
each item
fetched on the remote db and inserting them in. Every now and then i get
the
duplicate error message (there a no duplicate keys in the original
table), which
suggests that either not all records are getting wiped out of the local
table OR
a record is getting saved twice somehow… both seem very unlikely.
i have wrapped the locallink.save! in a rescue block to let the
exception slide
which should silence this problem, but the mystery remains. Anybody know
what’s
up? Thanks
Stuart
Thanks