Click here to Skip to main content
15,919,749 members

Welcome to the Lounge

   

For discussing anything related to a software developer's life but is not for programming questions. Got a programming question?

The Lounge is rated Safe For Work. If you're about to post something inappropriate for a shared office environment, then don't post it. No ads, no abuse, and no programming questions. Trolling, (political, climate, religious or whatever) will result in your account being removed.

 
GeneralRe: Worst deploy story? Pin
_Damian S_1-Dec-14 17:00
professional_Damian S_1-Dec-14 17:00 
GeneralRe: Worst deploy story? Pin
zpinklb3-Dec-14 0:59
zpinklb3-Dec-14 0:59 
GeneralRe: Worst deploy story? Pin
_Damian S_3-Dec-14 23:57
professional_Damian S_3-Dec-14 23:57 
GeneralRe: Worst deploy story? Pin
rnbergren3-Dec-14 4:19
rnbergren3-Dec-14 4:19 
GeneralRe: Worst deploy story? Pin
S. Kamonere1-Dec-14 22:05
S. Kamonere1-Dec-14 22:05 
AnswerRe: Worst deploy story? Pin
Andy Brummer1-Dec-14 17:23
sitebuilderAndy Brummer1-Dec-14 17:23 
GeneralRe: Worst deploy story? PinPopular
PIEBALDconsult1-Dec-14 17:56
mvePIEBALDconsult1-Dec-14 17:56 
AnswerRe: Worst deploy story? PinPopular
_Maxxx_1-Dec-14 19:11
professional_Maxxx_1-Dec-14 19:11 
We're about to deploy a major major upgrade to the new system.
I'm IT manager, and paranoid, so everything is being tested, tested, then tested again.

This involves using various test pre-deployment databases to run the various update scripts against, then doing a system test against the updated database.

There were a lot of database schema changes. A lot. Somewhat more of a conversion than an update in some cases.

And the Address table was particularly problematic -as we were introducing encoding using the Post Office's Unique Postal ID system - so as it converted the address to the new schema, it used the P.O. software to try to find the matching address.

The ones thrown out were being manually cleaned by a team of cannon fodder - then the conversion run again - we'd agreed not to do a final convert until we could get 95% hit rate.

A contractor was assigned the job of tweaking and testing the conversion.

Everything else was ready, and we still had 2 days before the rollout.

So there was a relaxed atmosphere.

I'm sitting, chatting to one of the devs, and I notice the contractor standing at the end of my desk. I finish the chat, turn to the contractor, who says "Maxxx. I just truncated the Address table"

"That's OK" quoth I, "it's just the pre-deployment database, we can recreate it easy enou.." That's when I noticed his head was shaking, slowly, from side to side.

"Production" he croaked.

That's when my phone rang. 150 phone operators had suddenly lost every address in the system.

During the next 48 hours the contractor, myself, and one of the contractors friends, managed (just) to restore the address table from a backup. Let me tell you, that was not in the least bit easy! And scary! Using undocumented features of Oracle.

After I had bought beers I suggested to the contractor that he might want to make the background colour of his Live vs Pre-Deployment windows a different shade - maybe FLASHING RED for the live database!

It's funny, but although at the time it was very stressful, looking back it was actually bloody good fun!

time is a great healer!
PooperPig - Coming Soon

GeneralRe: Worst deploy story? Pin
_Damian S_1-Dec-14 19:18
professional_Damian S_1-Dec-14 19:18 
GeneralRe: Worst deploy story? Pin
Mycroft Holmes1-Dec-14 19:51
professionalMycroft Holmes1-Dec-14 19:51 
GeneralRe: Worst deploy story? Pin
Chris Maunder2-Dec-14 3:37
cofounderChris Maunder2-Dec-14 3:37 
GeneralRe: Worst deploy story? Pin
PIEBALDconsult2-Dec-14 4:26
mvePIEBALDconsult2-Dec-14 4:26 
GeneralRe: Worst deploy story? Pin
Kirk 103898213-Dec-14 5:30
Kirk 103898213-Dec-14 5:30 
GeneralRe: Worst deploy story? Pin
Caeraerie3-Dec-14 6:48
Caeraerie3-Dec-14 6:48 
AnswerRe: Worst deploy story? PinPopular
Kornfeld Eliyahu Peter1-Dec-14 20:45
professionalKornfeld Eliyahu Peter1-Dec-14 20:45 
AnswerRe: Worst deploy story? Pin
V.1-Dec-14 22:26
professionalV.1-Dec-14 22:26 
AnswerRe: Worst deploy story? Pin
Nagy Vilmos1-Dec-14 23:03
professionalNagy Vilmos1-Dec-14 23:03 
AnswerRe: Worst deploy story? Pin
chriselst1-Dec-14 23:25
professionalchriselst1-Dec-14 23:25 
GeneralRe: Worst deploy story? Pin
StatementTerminator4-Dec-14 8:12
StatementTerminator4-Dec-14 8:12 
AnswerRe: Worst deploy story? Pin
Marc Clifton2-Dec-14 3:02
mvaMarc Clifton2-Dec-14 3:02 
GeneralRe: Worst deploy story? Pin
Chris Maunder2-Dec-14 3:20
cofounderChris Maunder2-Dec-14 3:20 
GeneralRe: Worst deploy story? Pin
agolddog3-Dec-14 5:26
agolddog3-Dec-14 5:26 
GeneralRe: Worst deploy story? Pin
Marc Clifton3-Dec-14 5:41
mvaMarc Clifton3-Dec-14 5:41 
AnswerRe: Worst deploy story? Pin
Tim Carmichael2-Dec-14 3:19
Tim Carmichael2-Dec-14 3:19 
AnswerRe: Worst deploy story? Pin
Ron Anders2-Dec-14 3:24
Ron Anders2-Dec-14 3:24 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.