Mysterious 'duplicate entry' database error when building ta

hi,

i tried posting this yesterday, but i never saw my message make it to
the list
so i suspect something went awry…

my rails app has some ‘sync’ code where it connects to a remote db,
grabs the
records from a table, deletes all the records from a table which is a
local
copy, and then rebuild the table with the records fetched on the remote
db…

it boggles the mind how a duplicate entry error can come up when the
source
database is confirmed to have no dups in it, the local table gets torn
down
completely, and rebuilt from scratch. the error only comes up every once
in a
while, so often the code runs fine… here’s the code in question:

begin #rescue block in event remote db is unreachable
homelinks = Syncinventorydesc.find(:all) #fetch all records
rescue
end

InventoryDescription.delete_all() #drop all records from local
table

for link in homelinks #for each record we fetched…
locallink = InventoryDescription.new()

   locallink.inventory_id = link.inventory_id
   locallink.description_id = link.description_id

   locallink.save!       #insert into table

end

since it was just a duplicate entry (no loss of data) i just wrapped
that save
in a rescue block too. the mystery remains however… what happened?

thanks for the assistance!
stuart

This forum is not affiliated to the Ruby language, Ruby on Rails framework, nor any Ruby applications discussed here.

| Privacy Policy | Terms of Service | Remote Ruby Jobs