Yesterday, around noon I took our databases IIS component offline and disabled the database triggers on the “attribute” table. I then inserted 248k attributes into the database, took all of about 5 minutes. I re-enabled the triggers and everything was working well. I went home, without a care in the world.

Last night, at around 3am my nightly-scheduled “Data Sync” program ran on my primary database and it’s designed to markup “attributes” that are missing some key details. This script ran into my 248k attributes and was busy processing them, in fact, it was busy doing that all along until I discovered it was still struggling at Noon today. Of course I sort of knew something wasn’t right as I didn’t get a successfully completed email from my database server telling me that this program had completed. I should have had the presence of mind to check first thing this morning, but, like many things, it slipped my mind. 🙁

After I discovered what was going on I fiddled with the triggers and mopped up the data. Now all is right with the world once again. To say I feel foolish is an understatement. I really have to work on my spidey-sense when it comes to these things. 🙂

“All’s Well that Ends Well”…