Thousands of Delta passengers delayed by computer outage
bbc.co.uk
bbc.co.uk
I'm not suggestion that the bug should be explained in details in the evening news, but at least give some indication of the nature of the problem. They could just refer to a website, if people want the technical details.
When a car has a problem, it's not reported as a "glitch". Imagine the stupidity of a media report claiming "A glitch in the latests Ford models cause several drivers to crash". You don't do that, you explain that it's a fault in the steering, breaks, electric systems, or where ever the issue lies. I think we should reasonably expect the same when errors in computer systems hit the news.
I wonder if companies do cost-benefit analysis on those kinds of situation. "We saved X amount of £ on cutting costs. Outages as a result of cost cutting Y amount of £". You would think that at least stock holders would insist.
Okay, maybe not Comcast.
Plus doing a proper post mortem and understanding how it works woudl take a lot of time and money. Things they most of the time to not have budget for.
A while ago (when I was in aerospace) there was one senior people who gave us the price of insurance per head.
Given that we're talking about 1M€ per head and that a plane can easily have 200 people. I have a hard time finding a situation where I can expect a Return On Investment by doing things poorly and cheaply. We're talking many millions of payout.
(And yet, I'd love to have such a situation, it's always good to attract the attention of attendees at conference or student classrooms).
Then later I realized that I've made a mistake in my calculation... I'm only accounting for A SINGLE plane failing and killing everyone. In the real world, a bad component would be shipped to a whole batch of planes and they'd fall randomly like flies.
That batch-effect drastically increases the cost of failure. So... I really don't see ANY place where there is a ROI on people dying.
BAZINGA!!! I'm from Europe and people are expensive there. The trick is to manufacture things for the 3rd world market where people get peanuts when they die (sometimes even nothing) :D
But then again... we're back to square one, how could I build parts AND guarantee that they're only shipped to planes in low-cost locations? At that point, it's probably closer to a plane-by-plane targeted sabotage rather than a scheme of doing minimum-shit-to-close-sales. And when doing plane-by-plane there is no economy of scale :(
... Anyway! Just wanted to say that any analysis would clearly reveal that THE PLANE IS CHEAPER WHEN IT FLIES!!! (and your life is truly expensive) so you're fine. You can keep on using airplanes ;)
Also, people at work do have a conscience. Once in a while they may forget about the importance of what they do, luckily there is a plane crash happening every few months to remind them that there are lifes at stake, for real (in case it was ever forgotten).
Now we know this is not always true, but even giving out details about schema, data-organization or technologies used could provide more detail than is necessary.
We could argue the merits of this approach - I can certainly sympathize with the idea - but security by obscurity is still a rampant ethos in huge corporations. I wouldn't be surprised if TSA also enforced a bit of this as well.
That's one of the main goals of a postmortem: document what the cause of the problem was, not just for you, but for all interested parties. If some human caused the issue, you need to document what happened and what should be done to prevent it from re-occurring. And fix it, of course.
That being said, of course I am much more likely to patronize businesses who do give me this type of information. Given a choice between a bank with satisfactory service and amazing transparency, and a bank with great service and no transparency, I will choose the former every time.
But government regulators opening up the working of private businesses is not a proportional response to your bill pay being unavailable for a few days.
In the case of airlines though, they have a strong collective interest in avoiding incidents.
After the power outage of 2003, the NYISO released a post-mortem [1], but I don't remember CNN reporting on it. This is probably because it takes a significant quantity of effort to turn a detailed report into a 10-minute video.
I imagine that a youtube channel that ran post-mortems on large-scale systems would be popular.
[1] http://www.nyiso.com/public/webdocs/media_room/press_release...
> A power outage in Atlanta, which began at approximately 2:30 a.m. ET, has impacted Delta computer systems and operations worldwide, resulting in flight delays. Large-scale cancellations are expected today. All flights en route are operating normally. We are aware that flight status systems, including airport screens, are incorrectly showing flights on time. We apologize to customers who are affected by this issue, and our teams are working to resolve the problem as quickly as possible. Updates will be available on news.delta.com.
http://news.delta.com/more-flights-resume-delays-cancels-con...
Something like this can literally kill a semester/year of college if you arent savvy enough to deal with it. Luckily for us, tens of thousands of other customers had the same issue and the school was inundated with similar cases -- they realized something was amiss.
Incidentally, Washington Mutual refused to help -- they noted that the statement did not show my brother's name. They also noted that they cant talk to my brother since he isnt a customer!!!
Its easy for us on the outside to say "well, have a backup" or "just replace all the legacy systems", but in the real world its not that simple.
Yes, you can have a backup server, but it has to be running exactly the same software and working on a copy of the data. If some unforeseen event corrupts the database, its likely to corrupt the backup replicant in exactly the same way. Also its likely that some of the legacy systems are not designed to support replication and can't have it retrofitted with any reasonable degree of cost and risk.
Replacing a single legacy system with another system that does exactly the same thing is expensive, risky, and wins you almost nothing. You have to replace a large chunk of the whole legacy all at once, without disrupting your day to day business. This is hard to do; any project to try this is likely to fail before it really gets started.
The way to do this is to create an automatic translation tool. Furthermore, this translation tool can't be generic. Instead, it has to map the idioms of the legacy project to new code in the idioms of the new environment. Done properly, doing the port at one level of indirection like this, you can absorb all of the changes to the legacy system as they are happening, then instantly switch over when the new system is finally ready.
http://fox61.com/2016/08/08/delta-airline-reports-outage-eve...
The outage began at 0230 and is presumably ongoing and beyond the capacity of their backup generators to cope with.
http://news.delta.com/730-am-et-update-outage-affects-depart...
A power outage in Atlanta, which began at approximately 2:30 a.m. ET, has impacted Delta computer systems and operations worldwide, resulting in flight delays
8:40 a.m. ET UPDATE: A Delta ground stop has been lifted and limited departures are resuming following a power outage in Atlanta that impacted Delta computer systems and operations worldwide. Cancellations and delays continue.
That being said, I expect them to upgrade their generators to handle outages like this, and distribute more of their IT infrastructure. Unlike the typical summer storms in the Atlanta area that delay flights, this affected them worldwide.
The "all over the world" bit is why there's a single point of failure.
A while back there was a story that made the rounds of aviation geeks, about Delta flying an empty 747 to Korea. That was to replace a 747 which had been badly damaged by hail, to the point that it would be unable to operate its scheduled return flight to the US.
Do you want to guess how many people, parts and places were involved in the "simple" task of dealing with this problem?
At first, the replacement 747 is in storage in a "boneyard" facility in Arizona, due to having been recently retired. So first it has to be pulled from the storage facility, put through basic airworthiness checks and fueled up, and then a flight crew has to be present to fly it to a Delta hub where it can be readied for a trans-Pacific flight.
The hub in question turned out to be Minneapolis. There, the plane has to undergo more work to get it ready for a long flight, and now multiple flight crews have to be present, since they need to rotate in and out over the duration of the flight (that's how you do long flights). Oh, and Minneapolis isn't normally a 747 base; it only gets them during peak travel seasons and on the occasional charter. So crews probably have to be brought in, stores and maintenance setups need to be brought online, etc.
Then the plane can -- finally -- fly out to replace its damaged counterpart, pick up any stranded passengers and bring them to the US. Which will mean flying into yet another hub, since the flight doesn't go back to Minneapolis.
Meanwhile the damaged plane is still sitting there in Korea, and needs to be repaired on-site to get it into minimum airworthy condition to fly home (empty of passengers). It's going to need parts, maintenance crew, flight crews, etc. just like the replacement plane did.
And the deeper you dig the more stuff you'll find like this. Running an airline with global, or even national-across-the-US, service is not something you can decentralize to avoid problems at one operations center. The amount of coordination just of people, parts and planes across widely disparate locations requires centralized operational control instead of devolved regional centers with high autonomy.
At this point I consider a company as large as this having such a rudimentary single point of failure to be incompetence in the IT department. We wouldn't be so forgiving if delta needlessly kept all of its pilots in one city during the night so a single storm wiped out every flight.
You're still out of luck when the centralized admin center goes down, though. That's the place that is the source of all the humans performing the coordination and dispatching work. Having a bunch of extra data centers and backup generators around the country will not cause those humans to become accessible.
And building out full redundant continuity of everything, including the humans, is not something that tends to happen outside of major governments.
Also, "centralize administration" just means that you can control everything from a single location. It doesn't preclude being able to control from multiple locations.
Think of AWS, you can control everything across multiple data centers from a centralized interface from anywhere with an Internet connection, even if entire data centers go down.
A sane system should essentially allow delta to operate from many possible locations seamlessly as long as they have the human operators required.
Delta airlines, with $40B of revenue last year, has less than 8 hours of backup power for their mission critical computers?
Even on classic DBs, setting up a failover with a lag of 15 minutes isn't a herculean effort. It's expensive, yes, but probably worth it...
Plus sometimes backup power isn't reliable (e.g. generator problem) or they have different tiers of coverage (and Delta didn't pay for it). We'll just have to wait and see.
There are things that are fairly easy to make redundant. I don't know anything about their infrastructure, but I doubt building a failover would be trivial.
Even if you had it in place, the risk of something occuring as you switch back and forth might not be worth it if you expect your regular setup to come back up within a reasonable time frame. Most people around here know how close to impossible it is to replicate real world usage on a test system, and how much overhead it adds to any change you make to your production system if you want the others to follow.
I've worked at several places where there has been battery backup, diesel generators, and a a disaster recovery site with generally nice and thorough strategies for replication including really expensive "sysplex-mode" for mainframes, topped with regular contigency tests where one half of the site is shut down.
And somehow, at every place, eventually something bad happened in a way that took down the applications.
It could be a power outage in the exactly the wrong circuit, fluctuating power messed up exactly the wrong storage system, someone dug up exactly the wrong fiber, the fire extinguisher set off by mistake and sprayed just the wrong cabinet with water fog through a door(!) that was supposed to automatically close, the diesel generator caught fire and the backup battery had to be taken offline, etc etc.
I'm not saying that you shouldn't try, but it's damn hard.
One day during a power cut the generator kicked in as it was supposed to, but a minute later it spluttered to a halt. After much fiddling around by maintenance staff they gave up and we were all told to go home.
The postmortem revealed that the diesel had become contaminated with all sorts of gunk - water, grit/sand and lumps of unidentifiable "stuff". The best laid plans and all that.
Edit: And cigarette butts as well.
How often did you test that?
> has less than 8 hours of backup power for their mission critical computers?
It's plausible that they thought they had that, but some part of it failed.
Not parent, but here is a single data point. When I was a student, I worked for some sysadmins who managed a small, internal data center. ~200 IBM servers, a SAN, an old VAX, etc. It had a backup gas generator that was tested loudly, every single week. It was also tested whenever the power went out for too long.
Obviously lots can go wrong, even with the best plans, but at least at the tiny little place I worked, the generator was tested every week.
Mind you, I'm not saying they don't have one, just that it can be difficult to get -- there can also be limits on the number of hours you can run them.
> According to the flight captain of JFK-SLC this morning, a routine scheduled switch to the backup generator this morning at 2:30am caused a fire that destroyed both the backup and the primary. Firefighters took a while to extinguish the fire. Power is now back up and 400 out of the 500 servers rebooted, still waiting for the last 100 to have the whole system fully functional.
http://www.flyertalk.com/forum/27032000-post135.html
Update: Confirmed.
> But Georgia Power said the issue had to do with Delta's own equipment, not a larger power outage. "We believe Delta Air Lines experienced an equipment outage; other Georgia Power customers were not affected," said John Kraft, spokesperson for the utility. Georgia power has staff on site trying to assist Delta, he said.
https://www.washingtonpost.com/news/the-switch/wp/2016/08/08...
The generators have been know to fail hard, and then the entire DC is down. On top of that, generators often are only able to run for a limited amount of time hours to days [2].
[1] https://en.wikipedia.org/wiki/Flywheel_energy_storage [2] http://www.graniteblockglobaldatacenter.com/powersystems.htm...
- Legacy systems: the thing is probably old and has had a lot of patchwork done to it by various people, many of whom are retired by now.
- The thing is also large and distributed, which makes noticing potential failures quite hard. There are loads of postmortems on the web about how some minor issue like a line going down caused some cascade of unforeseen problems. There's a lot of lessons being learned about how to solve this problem though, so I suppose there's hope.
- Always on: it's hard to change something once the business is relying on it. Loads of staff need to be shown how it works, which makes it hard to incrementally improve the thing because "how it works" would be something that people would have to be updated on.
- Never finished: large organisations will always have loads of feature requests and bug fixes. If you start responding to some of them, you might find yourself swamped. Either you work on the next item, or you spend valuable time making sure fewer items are fixed. It's a balancing act.
Alternatively it could just be an catastrophic infrastructure failure.
Deltas generally regarded as the well oiled machine of the airline industry. You're paying for always on time and consistent quality.
It's one of the reasons a story like this is surprising.
No source listings that I know of.
I'm guessing a critical hardware problem affecting some central part of their flight dispatching system.
The latter seems like something that could be overridden with pen/paper, but I can understand how the weight calc is intricately tied to the scheduling system. I just can't believe they can't have a fall-back at each airport: a simple program that runs on a PC that certifies a single flight based on who physically showed up and how heavy their bags are.
> According to the flight captain of JFK-SLC this morning, a routine scheduled switch to the backup generator this morning at 2:30am caused a fire that destroyed both the backup and the primary. Firefighters took a while to extinguish the fire. Power is now back up and 400 out of the 500 servers rebooted, still waiting for the last 100 to have the whole system fully functional.
If the attack was possible, than it was just as likely, if not more, that Delta managed to merely shoot itself in the foot.
Assuming what you've heard is correct this seems to span multiple Delta systems.
http://qz.com/417617/every-united-airlines-flight-was-ground...
and again http://www.pcworld.com/article/2945552/united-airlines-fligh...
and again http://newyork.cbslocal.com/2016/05/29/computer-system-shuts...
Well, that would make it less obvious.
1. Take a short-position on Delta on the stock exchange
2. Sabotage a piece of infrastructure that's important to operations
3. ???
4. Profit!
:)
https://www.google.com/finance?q=NYSE%3ADAL&ei=ncSpV_m8MsG9i...
I've tested our DR plans and we were operational after 4.5hours, optimally. And we were 3 people.
This outage reeks of PHBs doing lots of kicking the can and not a whole of implementing.
For the datacentre I have a friend that we worked out a mutually beneficial arrangement. I keep a few spare servers in his racks and he has a few in ours. Just enough to run the essentials.
Testing was literally walking up to the rack and switching off the power. Then documenting what happens next. If you've configured the ASN just right the domain should roll right over to the backup servers. Offsite DR servers needed a little kick to bring up to speed (I can't remember why this wasn't fully automated).
Most of the time was waiting for backup files to restore and verify. Since we were using someone else's network we were shaped down to a small percentage of their bandwidth.
After that we had a debriefing to see what worked, what didn't work. The usual IT stuff.
Only about a third of of from-scratch large corporate and government software systems succeed. Having to hire the cheapest contractor doesnt always work.
But apparently it is a normal mode of operations for Allegiant. Absolutely horrid airline. https://www.allegiantair.com/travel-alerts
I've only flown with them once, but it was a popular route to Vegas. It was fine for the price, especially since they don't surge as much as normal domestic airlines when you book with less than 2 weeks notice.