Database Glitch Grounds American/US Airways 274
An anonymous reader writes "According to numerous news sources, all American Airlines and US Airways flights were grounded for two or three hours this morning. Both problems were caused by a computer glitch in the systems hosted by EDS. Quote: The operating system that drives the airline's flight plans went down."
Great News! (Score:2)
Well isn't that some great news, that makes me feel 20x better about taking my gf to the airport this morning. Fortunately she wasn't flying U.S. Airways or American Airlines.
She is absolutely frightened of flying, and somewhat of a computer nerd, I can't wait to talk to her, and tell her the scary news.
Re:Great News! (Score:5, Informative)
Once you head for the runway, you care about Air Traffic Control's software. The only exception I can think of is for flights to the US where the authorities want passenger lists.
I work for an airline and we host for other airlines. I feel sorry for whoever carries the can for this mess. As to the OS, those who said it will be MVS are almost certainly correct. AA and US Airways are/were IBM customers.
Re:Great News! (Score:2)
Actually, it's probably TPF.
Re:Great News! (Score:3, Interesting)
After I submitted the grandfather post, I saw something I'd missed first time around:
The operating system that drives the airline's flight plans went down. It might even be a Windows problem. A 'Flight Planning' application is a low volume application where you work out the optimum route for a plane based on the weather. That bit about the weather involves serious number crunching and the PC world has more of that kind of power to spare than the mainframe world. I helped write one of these apps 2
Re:Great News! (Score:5, Insightful)
Offtopic reply to sig (Score:2, Offtopic)
For my money, I see so many "Fuck Whoever", and "GNAA" posts when I read at -1 that I only bother when I'm moderating. Their first ammendment rights a) don't apply to a privately owned board, and b) don't mean I have to wade through the crap they spew to see the good stuff.
I'm completely offtopic here, but it bugs
Re:Great News! (Score:3)
One of my worst flights ever was on a business trip to Edinburgh, Scotland. I was accompanied by a genuine RAF pilot, who flies the tanker Boeings for NATO warplanes. There was a rainstorm and strong wind over the whole UK and my friend was busy explaining me that Boeings are very vulnerable to strong winds and wind is the scariest threat for Boeing pilots and so on. It wasn't
Air Canada at the same time too (Score:3, Interesting)
href=http://www.ctv.ca/servlet/ArticleNews/story/
Probably just the CIA moving them all onto some big CIA super-computer.
Operating System (singular) (Score:5, Insightful)
How in the world can they state that as singular. Surely they have a backup of some sort. Especially with all the supposed "increased security" around air flight, you are telling me that one system crash can knock out half of the major airlines? That's ridiculous. Have they not learned about redundancy?
Re:Operating System (singular) (Score:5, Funny)
Re:Operating System (singular) (Score:3, Insightful)
Well duh! Your average "aviation writer" is flat out telling the difference between an aeroplane and a hole in the ground. Asking them to write a story that involves aeroplanes *and* computers is just asking for trouble. Why, that's like asking a six year old to pat his head and rub his stomach at the same time!
Basically the way these morons operate is that they latch on to any half-valid snippet of information - if their editor believes it, it must be true -
Re:Operating System (singular) (Score:4, Funny)
Re:Operating System (singular) (Score:3, Funny)
I'm an MBA. Would you please explain the joke?
Well, it's like when you have two people doing the same job in case one gets sick, except that, instead of firing one, you keep both around.
Re:Operating System (singular) (Score:3, Funny)
Re:Operating System (singular) (Score:3, Insightful)
Either way, somebody fucked up somewhere.
Re:Operating System (singular) (Score:3, Insightful)
Re:Operating System (singular) (Score:5, Funny)
Yep, their so good, even the failure was replicated!
Re:Operating System (singular) (Score:2)
Re:Operating System (singular) (Score:3, Insightful)
That's not what it says at all. American and U.S. Airways certainly don't count as half the major airlines in the United States. There are hundreds of airlines in the U.S. of A., and maybe a dozen qualify as "major." And by some measures, U.S. Airways doesn't count as a "major." So, no, you're completely wrong. Don't read things into the article that aren't there (assuming you RTFAs.)
Re:Operating System (singular) (Score:5, Informative)
For any *normal* 'extreme situation', a reboot should help.
Having just read that The operating system that drives the airline's flight plans went down, it might even be a Windows problem. A 'Flight Planning' application is a low volume application where you work out the optimum route for a plane based on the weather. That bit about the weather involves serious number crunching and the PC world has more of that kind of power to spare than the mainframe world. I helped write one of these apps 20-18 years ago and the central part has since been converted to run on PCs.
So they had a system crash ... (Score:2)
It's hard to tell from the sketchy news stories, but it looks like AA and UA *do* have a backup plan and *are* executing it. The backup plan is a ground stop for 2-3 hours while they sort things out.
If you want them to have a backup plan which involves providing full service with no interruptions, then you would have a ticket price to fund that.
Do you know the cost of redundency ? (Score:5, Interesting)
Redundancy is OK, as long as it is not bleeding you dry.
Re:Operating System (singular) (Score:3, Insightful)
Re:Operating System (singular) (Score:3, Interesting)
Settle down, we've all seen this before... (Score:4, Funny)
Last thing you want to hear (Score:5, Funny)
>_ Why don't they swtich to Linux?
You probably won't hear it (Score:5, Informative)
Example 1 - The pilot and co-pilot can't eat the same meal. That way, only one of them can get food poisoning.
Example 2 - The hydraulic system fails and the wheels won't go down. There's a hand crank.
Example 3 - The communication systems at every tower I have worked at have two separate backbones. There are two of absolutely everything. If that fails, there are emergency radios under the desk. If the emergency radios don't work
Example 4 - You can't fly very far over open water in a single engine aircraft.
It used to be frustrating working on systems older than I was but we never had to worry about surprises.
Of course all of this redundancy is very expensive. You spend the money where people's lives are at stake. On the other hand, if the worst problem is that some planes will be late, perhaps you don't spend the big bucks.
Re:You probably won't hear it (Score:2)
Yeah just as well they have that rule, just imagine the arguments if the co-pilot was allowed to eat the captain's lunch. Do they have rules that stop them both sitting in the same seat as well?
Example 2 - The hydraulic system fails and the wheels won't go down. There's a hand crank.
Its the same thing with software, no shortage of cranks.
Re:You probably won't hear it (Score:2)
It's not a joke. They have light guns (think God's Own Spotlight here) instead of fire extinguishers, and they use them from
Re:You probably won't hear it (Score:3, Insightful)
I though that was what hand lights [nasa.gov] were for.
Re:Last thing you want to hear (Score:5, Funny)
A: All the way to the scene of the crash. Hell, it will probably beat the paramedics there by half an hour!
Re:Last thing you want to hear (Score:2)
A: The rest of his life.
BSOL (Score:4, Funny)
Acronym homophones? (Score:2)
EDS (Score:3, Interesting)
Re:EDS (Score:3, Insightful)
Re:EDS (Score:3, Insightful)
Penny wise, pound foolish. Always the way, these days.
EDS? Quelle surprise. (Score:5, Interesting)
EDS, in cahoots with the UK govenment, have wasted millions of pounds of taxpayers money on failed IT projects. Notable ones include the Inland Revenue (UK IRS), Child Support Agency (£50M over budget and still not working) and an email and directory service for the NHS (withdrew at last minute allowing C&W to steal at a much inflated price).
Though the blame cannot completely be laid at the door of EDS, the government has been guilty of sloppy auditing and the worst being the willingness to hand over extra money when EDS has come around with the begging bowl.
Re:EDS? Quelle surprise. (Score:4, Insightful)
EDS and other large IT vendors try their best to discourage scope creep by making changes-after-the-fact billable for time and materials, instead of a negotiated cost. This makes the project go over budget. If the clients knew what they wanted at the begining, instead of wasting time and money doing engineering on the fly during the project, then the costs wouldn't be so high.
Don't be so quick to slag EDS about the outage either. There are lots of factors out there that could have contributed. I have worked on projects where the clients say the servers are mission critical, yet can't be bothered to shell out money to upgrade from ultra-1 and ultra-5s, let alone pay for an HA solution. The technical people keep providing the justification and making the requests, but it's the project managers and accountants that really determine what kind of solution is feasible.
Re:EDS? Quelle surprise. (Score:3, Insightful)
Isn't this what Systems Analysts are supposed to do?
Re:EDS? Quelle surprise. (Score:2)
Most clients aren't willing to pay for a systems analyst.
Or even have an idea why they really should...
Re:EDS? Quelle surprise. (Score:2)
What's the record for government contracts/descriptions?
German Toll Collect (a country-wide, per-kilometer road use toll from trucks) had an 17000 page contract with the goverment.
The system should have been running since mid 2003, it still doesn't work.
Re:EDS? Quelle surprise. (Score:2)
That's odd, "a quick google" produced about 43,000 hits for me.
Re:EDS? Quelle surprise. (Score:4, Insightful)
The problem with these companies is they specialize in winning big contracts. They put their best people on the proposals. They don't specialize in delivering great systems. Their best people probably move to the next RFP and they mostly fill the contracts with warm bodies.
They can get away with it because its pretty rare for them to actually be punished for poor performance. If they get blacklisted by the agency that awarded the contract the agency ends up just replacing EDS with CSC or vice versa and the results don't get any better. I'd be interested if someone could cite a huge government IT contract that actually worked well. At some point governments need to figure out this methodology doesn't work and try something new.
Steve Balmer (Score:3, Funny)
Operating system? (Score:3, Informative)
Re:Operating system? (Score:2)
Here at /.? No!
doesn't it say (Score:2)
Re:doesn't it say (Score:3, Insightful)
I'm sure the MS website experiences problems all the time. The difference is that, because it's such a large scale website and the company took the time to plan for failure, there is a lot of redundancy.
Microsoft has *at least* three levels of redundancy on the co
Re:doesn't it say (Score:2)
Re:doesn't it say (Score:2, Informative)
By the way, when's the last time you saw Microsoft.com go down?
Uhh
http://www.informationweek.com/story/showArticle.j html?articleID=12808118 [informationweek.com]
I thought everyone knew (Score:5, Funny)
That's what you get when you use EDS (Score:2)
Wild speculation (Score:4, Insightful)
I come from Solaris/Veritas/Oracle and Redhat/Oracle RAC environments. One single system going down cannot take out the service. Database HA is somewhat complicated and expensive, but it's not rocket science, regardless of platform.
I find it very difficult to believe that they would have any single points of failure in a system of that importance. Blaming MS is the easy way out.
Re:Wild speculation (Score:3, Insightful)
Re:Wild speculation (Score:2)
Re:Wild speculation (Score:5, Interesting)
I just read all the stories that were linked to this article.
None of them blamed Microsoft. In fact the only blame pushed in their direction was your comment...
The articles did say that there was a problem with the operating system. Now we don't know who exactly said this, or what they said precisely, so it is quite possible that this isn't entirely accurate reporting.
I find it very difficult to believe that they would have any single points of failure in a system of that importance.
I agree it's unlikely, but it is possible that there is a single point of failure in their system. There are a great deal of shoddily engineered systems in use today.
Not Windows, Unix (Score:5, Informative)
Sabre started it's life as an American Airlines internal system (SABER, slight spelling difference), running on a rare operating system (PARS, later called ACP and currently TPF) on IBM mainframes. In the last few years Sabre completed a lengthy migration to HP Unix on Non-Stop (i.e. ex-Tandem) hardware. The mainframe systems were rock solid, but software talent was hard to come by, so they decided the time had come to switch.
Sorry, no Microsoft to blame here!
Re:Not Windows, Unix (Score:3, Interesting)
They use the same system for flight operations and for reservations? I've seen Sabre in use at the travel agent's office, somehow I would have thought this problem involved a different system...
More info about Sabre than you ever wanted... (Score:4, Informative)
All Sabre applications are text mode, no GUI whatsoever... think CLI from hell, with no command history if you fat finger an entry.
The system that went down was probably DECS (Dispatch Environment Control System), which is the system used by both American and USAir for generating flight plans, load planning, weight and balance, and various other flight operations functions.
RES is the Reservations system, which covers the spectrum from building reservations and selling tickets, to customer checkin, boarding and god knows what else. IIRC, it will even do car rentals and hotels.
TIM is also called Timatic. Its used for accessing information from the US State Department regarding internation travel to any country, from any country in the world. It covers entry and exit requirements, documentation, and pretty much anything you could want to know.
I don't remember what BMAS stands for, but it is a lost bag tracking and reporting system. When AA or US looses your luggage, this is what they use to find it.
Sabre is used by a whole variety of airlines and travel agencies, and is customised in modules to each particular user's needs.
Now you are probably wondering how I know all this... I work for a major airline that uses a majority of the systems listed above, with the exception of the Dispatch system. We were not affected by whatever snafu took down that portion of Sabre
Probably Sabre Holdings, rest probably wrong (Score:5, Interesting)
Second, this failure isn't in the Sabre reservations system, it's in some ancillary product, so who knows? Maybe they have no intention of switching it to Unix.
Third, he didn't say so, but the migration isn't just to Unix. It's also migration to MySQL! (Hahahahahahahaha. Then again, coming from TPF, coded in assembly language for 4Kword pages, and a hierarchical database, that might seem pretty advanced.) Sabre had to fund a MySQL port to 64 bits, and a new "stored procedures" feature.
Re:Probably Sabre Holdings, rest probably wrong (Score:3, Funny)
I guess the should have heeded the cabin crew's warning: Procedures stored in the overhead compartments may have shifted during flight.
Re:Not Windows, Unix (Score:3, Interesting)
Mainframe issues... (Score:2)
Not HP Classic, Compaq/Tandem (Score:2)
Guess IT Does Matter (Score:2, Funny)
You don't understand how databases work! (Score:2)
here's what happened (Score:3, Funny)
What *REALLY* happened... (Score:5, Funny)
Not Smart Enough (Score:3, Interesting)
Perhaps the efficiencies of a computerized business offset the cost of short downtimes, and the business is able to grow to the complexity that it isn't worth running without the computer. A 2 or 3 hour stoppage once in a blue moon (that was last month, and it looked big) might not be worth working around.
All the same I'm hesitant to let computer failures stand in the way of normality. Major infrastructure may be interrupted by nature but it can be scary for it to be stopped by computer problems. Who knows how long the system will be down? Who knows how much damage to information went unnoticed? Who knows what errors still exist?
Increasing computerization causes increasing paranoia. Guard yourself prophylactically? Ask hard questions before entering relationships with big business? Insist on financial compensation against computer delays?
Computer systems need to be built with more safeguards (redundancy, logging, checkpoints, backups), isolation of failure, data accessibility during failure (example: Windows safe mode) even for end users, etc.
This isn't what you think (Score:3, Interesting)
Even though this sounds dire, I have a feeling that this does nothing to compromise airline safety.
From the sounds of it, the flight planning system went down. This is a ground-system only, often a terminal next to the ticket checking counter. The purpose is to file flight plans, check weather airport conditions, etc. It is not an onboard system. This would not have likely decreased passenger safety.
The reason that the FAA got involved was because AA decided to ground the planes because the pilots most likely couldn't file flight plans electronically. If left to the filing flight plans the old way, it would have delayed things more and caused more headaches to just wait out the system outage.
However, when any business runs and depends on a particular piece of software to generate revenue and to provide a service, I would be more inclined to host such a system on something like a mainframe or at least a big Unix server.
I found the root of the problem (Score:5, Funny)
uh oh, was that me? (Score:2)
What's going on here? (Score:3, Interesting)
Hmm... what's going on here?
I like how spokesfolk try to .. (Score:2)
"Customers won't necessarily miss their connections," he said, "because everything was stopped."
You're not gonna DIE (Score:2, Informative)
Not "OS" (Score:5, Informative)
See this quote from one of the articles:
Wagner said a database malfunctioned that "basically runs every aspect of our client operations -- aircraft dispatch, crew scheduling (and) reporting weight, passenger load, balance."
This system is hosted by EDS, who only said it was a "systems issue".
So there's no evidence it was an OS problem. It could have been anything - OS, Oracle/DB2/SQL Server database, application code, upgrade, whatever.
Nothing to conclude here except that somebody screwed up - and even that isn't certain - could have been a bad memory board someplace, who knows.
Not having a backup is even irrelevant, since the "backup" might have taken three hours to bring up, when you're dealing with a production system like this. "Failover" is what you want, and they should have had, but if something got screwed there, it could still have been three hours.
Shouldn't have happened, but crap like this happens all the time because nobody can do their damn jobs.
Same Thing Happened to NorthWest (Score:3, Interesting)
You'd think they'd have redundancy and backups, but they probably don't. That requires some planning beyond the immediate need of the company and, even if it's more profitable to invest in backups, long term planning simply isn't considered as much.
This happens to my University all the time. The power goes out in one building for a few hours and services across the entire University are disrupted completely. This building happens to house most of the license servers for important software, but no one would _ever_ think of putting a backup license server in another building _just in case_. No, that'd be thinking ahead.
EDS works with a variety of systems (Score:5, Insightful)
Re:EDS works with a variety of systems (Score:2)
Stuff like scheduling and cargo loading was mentioned.
Re:EDS works with a variety of systems (Score:5, Informative)
They actually have a data center that is underground, and has a retinal scanner to get in (for some reason, our group got in with keycards - I'm not really sure why). Their tape library is about three times the size of my house. It's a pretty massive operation. Travelocity, hosted in the same location (but on the ground floor, not downstairs), is a bunch of huge SGI machines (8 processors and more each - probably about 30 of them).
They run pretty much everything under the sun. I enjoyed being around the cool equipment while I was there, but absolutely hated the "big company" mentality, so I left after a year.
Re:Windows (Score:5, Informative)
(1) American Airlines,
(2) US Airways,
(3) EDS.
So, what the hell are you talking about?
Why did you link to this article?
(I know, I know, because nobody will read it anyway)
Re:Windows (Score:2, Funny)
(1) American Airlines,
(2) US Airways,
(3) EDS.
So, what the hell are you talking about?
Why did you link to this article?
(I know, I know, because nobody will read it anyway)
You are such a nitpicker.
Re:Windows (Score:4, Informative)
Re:Windows (Score:3, Funny)
Re:Windows (Score:2)
On a more serious note ; a few weeks ago (two i think) : We also had a software problem in the Netherlands (Schiphol Airport) : Causing the monitors which display the departures/arrivals, to go blank : Only to get working 2 hours later.
This also caused great delays, as people had to ask to the airport personnel where to go.
Re:Windows (Score:2)
MOD PARENT DOWn (Score:3, Informative)
Re:Windows (Score:2, Funny)
Microsoft Bob. Now, where do I go to collect my bonus air miles?
Re:Gee, gods, ... (Score:3, Funny)
Don't be so sure... [virgin.net]
Re:I wonder if they could get any more vague.. (Score:4, Funny)
The PATRIOT Act?
My guess ... (Score:3, Interesting)
Re:My guess ... (Score:4, Informative)
Of the 360-based operating systems, IBM's TPF [ibm.com] has a major presence in the airline industry, but this probably isn't the system in question. TPF tends to handle ticketing and reservations. TPF stands for the Transaction Processing Facility; it's the descendant of the old Airline Control Program (ACP) developed for Sabre. Sabre in fact is still running TPF, although I believe they're busy transitioning away from the mainframe to Tandem's er I mean Compaq's er I mean HP's NonStop/UX.
Of course, it might not be an IBM mainframe at all; Unisys has a niche in the airline industry. But heck; given that this is route planning, just about anything from AIX to z/OS is a possibility. Even *shudder* Windows.
UNIX (Score:2)
Nice try, though.
Re:UNIX (Score:2)
Re: (Score:2)
Re:UNIX (Score:2, Insightful)
Re:And in related news (Score:3, Insightful)
That's only for DC. The terror level is still "Bert" [geekandproud.net] for the rest of the country.
Regarding his pay, Ridge has got to have one of the most stressful, time consuming, and important jobs in the country, and as such I for one do not think that $175K is nearly en
Re:EDS (Score:2)
Unfortunately, no (Score:3, Informative)
Unfortunately, the Windows-everywhere trend seems to be winning here. My airport is going to a common-use terminal system, and it's Win2K based. All but one of the big common use vendors are selling Windows-based equipment. Northwest's CUSS (common use self service) terminals are Win2K based as well.