The Daily WTF: Curious Perversions in Information Technology
Welcome to TDWTF Forums Sign in | Join | Help
in Search

But it works in the test DB

Last post 04-25-2012 10:12 PM by morbiuswilters. 25 replies.
Page 1 of 1 (26 items)
Sort Posts: Previous Next
  • 04-24-2012 2:18 PM

    But it works in the test DB

    A mentally junior coworker creates and debugs a new feature with a new db table in our test environment.

    When done, he commits the code to svn, but doesn't bother to commit the ddl/dml to svn. As such, when migrating it to a preprod test environment, the code gets built, but the table doesn't get created. Naturally, this causes all sorts of table-does-not-exist errors.

    When we track it back to this guy and confront him, he says: But it works in the test DB!

    Be brief, no matter how long it takes.
  • 04-24-2012 2:23 PM In reply to

    Re: But it works in the test DB

    snoofle:
    mentally junior

    Thanks! Now we have a great new euphemism for "special!" He's not special, he's just a little mentally junior.

    snoofle:

    When we track it back to this guy and confront him, he says: But it works in the test DB!

    You did immediately punch him in the face, right?

  • 04-24-2012 2:31 PM In reply to

    Re: But it works in the test DB

    snoofle:
    But it works in the test DB!

    snoofle enters, waving a Spiky Cluebat of Deeper Understanding, occasionally letting the tip drop to the floor.

    "Now, Junior... let's riddle me this....."

    *thock*

    "one: it worked in the test DB"

    *thock*

    "two: it DIDN'T work in the live DB"

    *thock*

    "now for the question: why is that?"

    *thock*

  • 04-24-2012 2:39 PM In reply to

    • Anketam
    • Top 150 Contributor
    • Joined on 10-12-2011
    • Nar Shaddaa
    • Posts 484

    Re: But it works in the test DB

    I put "But it works in the test DB!" in the same category as:

    "But it works in Dev"
    "But it works on my desktop"
    "Impossible I tested it on {environment} and it worked"
    "You are wrong there is no way that it does not work"
    "It is impossible that you got that error message"

    Project Manager: I don't know. I'm not allowed to talk directly to the customer. Apparently my grip on reality is too tight.
    - Weng
  • 04-24-2012 3:12 PM In reply to

    • Anarud
    • Not Ranked
    • Joined on 12-16-2011
    • Portugal
    • Posts 27

    Re: But it works in the test DB

    Boy oh boy, where have i seen this before...
    Bah... Humbug.
  • 04-24-2012 3:14 PM In reply to

    • Anarud
    • Not Ranked
    • Joined on 12-16-2011
    • Portugal
    • Posts 27

    Re: But it works in the test DB

    Why punch the developer in the face? Wouldn't a simple case of caning (like the one performed in Singapore and Malaysia) do the trick just fine as well?
    Bah... Humbug.
  • 04-24-2012 3:22 PM In reply to

    Re: But it works in the test DB

    Anarud:
    Why punch the developer in the face? Wouldn't a simple case of caning (like the one performed in Singapore and Malaysia) do the trick just fine as well?

    It's a matter of immediate feedback. So, unless Snoofle carries around a cane for this purpose -- which he probably ought to do, come to think of it -- punching, kicking, or the like may have to do.

  • 04-24-2012 4:04 PM In reply to

    Re: But it works in the test DB

    The really old-school way about it would be to challenge the dipshit to a duel.
  • 04-24-2012 4:26 PM In reply to

    Re: But it works in the test DB

    Ha ha! You guys are all so angry about an easily fixable mistake.

  • 04-24-2012 4:35 PM In reply to

    Re: But it works in the test DB

     I wouldn't call my wife a "fixable mistake"...

  • 04-24-2012 5:45 PM In reply to

    Re: But it works in the test DB

    Cassidy:

     I wouldn't call my wife a "fixable mistake"...

     

    But a bunch of 'em would.

     


    In complex analysis, a meromorphic function on an open subset D of the complex plane is a function that is holomorphic on all D except a set of isolated points

  • 04-24-2012 8:17 PM In reply to

    Re: But it works in the test DB

    Anketam:

    I put "But it works in the test DB!" in the same category as:

    "But it works in Dev"
    "But it works on my desktop"
    "Impossible I tested it on {environment} and it worked"
    "You are wrong there is no way that it does not work"
    "It is impossible that you got that error message"


    Certified: Works on My Machine - got to admit, though, the logo looks a little boring. A lot of people seem to sell t-shirts and stuff, though
  • 04-24-2012 8:20 PM In reply to

    Re: But it works in the test DB

    frits:

    Ha ha! You guys are all so angry about an easily fixable mistake.

    This developer's conception on this Earth is not easily fixable. Not without getting arrested, at any rate.

     

  • 04-24-2012 8:42 PM In reply to

    Re: But it works in the test DB

    frits:

    Ha ha! You guys are all so angry about an easily fixable mistake.

    It's called "bikeshedding". People like to get worked up over the small things because it's easy; arguing about complex topics is hard.

    Let the healing begin!

  • I may not agree with everything Morbs just said, but he expresses himself in a way that is dignified, respectful, polite and non-threatening!
  • 04-25-2012 3:33 AM In reply to

    • PJH
    • Top 10 Contributor
    • Joined on 02-14-2007
    • Newcastle, UK
    • Posts 3,908

    Re: But it works in the test DB

    Anketam:

    I put "But it works in the test DB!" in the same category as:

    "But it works in Dev"
    "But it works on my desktop"
    "Impossible I tested it on {environment} and it worked"
    "You are wrong there is no way that it does not work"
    "It is impossible that you got that error message"

    "It compiled."
    "Because you watched 'The Very Hungry Caterpillar,' we recommend 'The Human Centipede.'"
    --
    UED - Countryside: To kill Piers Morgan
  • Parp!
  • 04-25-2012 8:55 AM In reply to

    Re: But it works in the test DB

    PJH:
    Anketam:

    I put "But it works in the test DB!" in the same category as:

    "But it works in Dev"
    "But it works on my desktop"
    "Impossible I tested it on {environment} and it worked"
    "You are wrong there is no way that it does not work"
    "It is impossible that you got that error message"

    "It compiled."
    "When I tried to compile it, I didn't notice a single error message."
  • 04-25-2012 9:06 AM In reply to

    • PJH
    • Top 10 Contributor
    • Joined on 02-14-2007
    • Newcastle, UK
    • Posts 3,908

    Re: But it works in the test DB

    pkmnfrk:
    PJH:
    Anketam:

    I put "But it works in the test DB!" in the same category as:

    "But it works in Dev"
    "But it works on my desktop"
    "Impossible I tested it on {environment} and it worked"
    "You are wrong there is no way that it does not work"
    "It is impossible that you got that error message"

    "It compiled."
    "When I tried to compile it, I didn't notice a single error message."
    "It always spews out warnings when it compiles - my changes only added a couple more."
    "Because you watched 'The Very Hungry Caterpillar,' we recommend 'The Human Centipede.'"
    --
    UED - Countryside: To kill Piers Morgan
  • Parp!
  • 04-25-2012 9:15 AM In reply to

    Re: But it works in the test DB

    PJH:
    pkmnfrk:
    PJH:
    Anketam:

    I put "But it works in the test DB!" in the same category as:

    "But it works in Dev"
    "But it works on my desktop"
    "Impossible I tested it on {environment} and it worked"
    "You are wrong there is no way that it does not work"
    "It is impossible that you got that error message"

    "It compiled."
    "When I tried to compile it, I didn't notice a single error message."
    "It always spews out warnings when it compiles - my changes only added a couple more."

    "When I saved the source code, Notepad didn't give me any errors."

  • 04-25-2012 10:58 AM In reply to

    • galgorah
    • Top 75 Contributor
    • Joined on 04-18-2007
    • Cambridge, Ma
    • Posts 731

    Re: But it works in the test DB

    snoofle:

    A mentally junior coworker creates and debugs a new feature with a new db table in our test environment.

    When done, he commits the code to svn, but doesn't bother to commit the ddl/dml to svn. As such, when migrating it to a preprod test environment, the code gets built, but the table doesn't get created. Naturally, this causes all sorts of table-does-not-exist errors.

    When we track it back to this guy and confront him, he says: But it works in the test DB!

    Perhaps talk to management about continuous integration for databases.  The moment he checks in his database changes, a tool compares the old and new version of each database object and generates a deployment script.  This script then immediatly is run against a test environment.  However this still requires hiim to check it in.  RedGate has some tools for this that are pretty cheap.

     At least it would reduce the human presence require in the process.

     

    Reformed Developer and SQL Server DBA
  • 04-25-2012 12:41 PM In reply to

    Re: But it works in the test DB

    pkmnfrk:
    PJH:
    pkmnfrk:
    PJH:
    Anketam:

    I put "But it works in the test DB!" in the same category as:

    "But it works in Dev"
    "But it works on my desktop"
    "Impossible I tested it on {environment} and it worked"
    "You are wrong there is no way that it does not work"
    "It is impossible that you got that error message"

    "It compiled."
    "When I tried to compile it, I didn't notice a single error message."
    "It always spews out warnings when it compiles - my changes only added a couple more."

    "When I saved the source code, Notepad didn't give me any errors."

    "But that's how Twitter does it.."

    Let the healing begin!

  • I may not agree with everything Morbs just said, but he expresses himself in a way that is dignified, respectful, polite and non-threatening!
  • 04-25-2012 4:25 PM In reply to

    • PJH
    • Top 10 Contributor
    • Joined on 02-14-2007
    • Newcastle, UK
    • Posts 3,908

    Re: But it works in the test DB

    morbiuswilters:
    "But that's how Twitter does it.."
    That's a new one on me morbs - any examples to show us?
    "Because you watched 'The Very Hungry Caterpillar,' we recommend 'The Human Centipede.'"
    --
    UED - Countryside: To kill Piers Morgan
  • Parp!
  • 04-25-2012 4:38 PM In reply to

    Re: But it works in the test DB

    PJH:
    morbiuswilters:
    "But that's how Twitter does it.."
    That's a new one on me morbs - any examples to show us?
    He was obviously exaggerating. None of Twitter's API changes have ever been tested.
      <-  I couldn't make my shit work, so here's a Godzilla head.
  • 04-25-2012 4:45 PM In reply to

    Re: But it works in the test DB

    PJH:
    morbiuswilters:
    "But that's how Twitter does it.."
    That's a new one on me morbs - any examples to show us?
    Referring to things like using a certain technology, framework or architecture. As in: "I can't use Ruby on Rails? But that's how Twitter does it.." or "I'm replacing the entire relational database with message queues because that's how Twitter does it.." or "I can leave out the semicolons if I want to because that's how Twitter does it.."

    The fact that Twitter does something always makes me think twice about doing it myself.

    Let the healing begin!

  • I may not agree with everything Morbs just said, but he expresses himself in a way that is dignified, respectful, polite and non-threatening!
  • 04-25-2012 5:10 PM In reply to

    Re: But it works in the test DB

    Interesting concept.

    I wonder if I can use this paradigm to force wafflers into reducing overly verbose documentation  down to 140 characters or less.

  • 04-25-2012 9:06 PM In reply to

    Re: But it works in the test DB

    morbiuswilters:
    PJH:
    morbiuswilters:
    "But that's how Twitter does it.."
    That's a new one on me morbs - any examples to show us?
    Referring to things like using a certain technology, framework or architecture. As in: "I can't use Ruby on Rails? But that's how Twitter does it.." or "I'm replacing the entire relational database with message queues because that's how Twitter does it.." or "I can leave out the semicolons if I want to because that's how Twitter does it.."

    The fact that Twitter does something always makes me think twice about doing it myself.
    But it's great when you want to get a pet technology in. 90% of the followers fall for "appeal to authority" every time. Sometimes I do it just for fun.
  • 04-25-2012 10:12 PM In reply to

    Re: But it works in the test DB

    Jaime:
    morbiuswilters:
    PJH:
    morbiuswilters:
    "But that's how Twitter does it.."
    That's a new one on me morbs - any examples to show us?
    Referring to things like using a certain technology, framework or architecture. As in: "I can't use Ruby on Rails? But that's how Twitter does it.." or "I'm replacing the entire relational database with message queues because that's how Twitter does it.." or "I can leave out the semicolons if I want to because that's how Twitter does it.."

    The fact that Twitter does something always makes me think twice about doing it myself.
    But it's great when you want to get a pet technology in. 90% of the followers fall for "appeal to authority" every time. Sometimes I do it just for fun.
    I do that, too. I usually use Google or Apple (or maybe Facebook if I'm in a pinch). I don't even know if they actually do do the things I tell people they do, but I figure with thousands of employees at least one of them has done the same thing..

    Let the healing begin!

  • I may not agree with everything Morbs just said, but he expresses himself in a way that is dignified, respectful, polite and non-threatening!
Page 1 of 1 (26 items)
Powered by Community Server (Non-Commercial Edition), by Telligent Systems