the $440,000,000 codeing error!

[edscdk]

http://www.theregister.co.uk/2012/08/03/bad_algorithm_lost_440_million_dollars/

Its a shame some of the trades got reversed,

They should not be permitted to operate this sort of stock manipulation anyway

 

[GravyMonster]

Youch.

Makes me feel better about my biggest mistake; deleting 60million transactions from a SQL database.

 

[Spenty]

Youch.

Makes me feel better about my biggest mistake; deleting 60million transactions from a SQL database.

Were you sacked for that?

 

[MooMoo444]

codeing

 

[Cosimo]

codeing

With spelling like that he's probably a programmer.

 

[Haircut]

Sounds like the errors were in the testing and release processes to me.

 

[Ranked1_of_1]

Were you sacked for that?

No, he was sacked for not having a backup.

 

[GravyMonster]

Were you sacked for that?

No There was a backup thankfully, so we only lost that days transactions, which was about 30,000 records. Got a major *******ing and an insta-written warning though, all for forgetting a WHERE clause.

 

[pitchfork]

Surprised he wasn't rolled up in a carpet and thown into the sea

 

[Imy]

Don't some databases stop you running a DELETE command if you don't specify a WHERE clause or did you just WHERE 1=1?

 

[Wizardskills]

No There was a backup thankfully, so we only lost that days transactions, which was about 30,000 records. Got a major *******ing and an insta-written warning though, all for forgetting a WHERE clause.

Ah that old chestnut, everyone does it at some point. I once made a similar mistake when cleaning up a linking table and I put "EXISTS" instead of "IN" in my WHERE clause. Cue the whole system breaking and me running round in a panic to get a backup asap .

 

[GravyMonster]

Don't some databases stop you running a DELETE command if you don't specify a WHERE clause or did you just WHERE 1=1?

They may well do, but I can tell you now SQL Server 7 doesn't

 

[robgmun]

This is why i don't do SQL, hated that job with a passion

 

[jon86]

Youch.

Makes me feel better about my biggest mistake; deleting 60million transactions from a SQL database.

Do you happen to work for a big national bank per chance?

 

[StriderX]

$440 million?

Pretty worthless overall id say, the only interesting part of this is the arguments for and against auto-trading, with this blunder.

 

[Greebo]

Reading the articles on this, isn't Knight Capital in danger of being bankrupt?

 

[Pestilence]

Reading the articles on this, isn't Knight Capital in danger of being bankrupt?

They'll get about 30% mitigation on it, I think, but yeah -- this is going to hit them very hard indeed.

 

[StriderX]

Why the hell is it called Knight capital?

So anal.

 

[mrk]

$440 million?

Pretty worthless overall id say, the only interesting part of this is the arguments for and against auto-trading, with this blunder.

Good thing what you say isn't correct then! The article states that the "lost" monies is enough to wipe out any profit Knight made in 2011 and seriously affect its future.

Somewhat important I'd say!

 

[estebanrey]

They may well do, but I can tell you now SQL Server 7 doesn't

Why are you using 14 year old software anyway???

Besides don't triggers work in ver 7? I use 2008 R2 and you can set up triggers which catch things like this. So you can set one up that looks at any DELETE query and will abort it when there isn't a WHERE clause.

This explains how to do it.....

http://www.mssqltips.com/sqlservert...e-commands-of-all-rows-in-a-sql-server-table/