Live data from Hacker News

A corrupt file led to the FAA ground stoppage – also found in backup system

cnn.com

401–402 of 402 posts

Re: A corrupt file led to the FAA ground stoppage – also found in backup system

#401
post #51

Earlier quoted context omitted.

Why would this be an indictment of any specific database technology? If your disk fails and corrupts the filesystem, you're toast, regardless of what database you are using.

The technology to detect and recover from disk failures does exist. RAID and ZFS, for example. I would not expect a disk failure to replicate to the backup.

RAID does not really protect you from bit rot that tends to happen from time to time. ZFS might because it checksums the blocks. But if the corruption happens in memory and then it is transferred to disk and replicated, then from a disk perspective the data was valid.

Re: A corrupt file led to the FAA ground stoppage – also found in backup system

#402
post #10

Quote from FAA: "Our preliminary work has traced the outage to a damaged database file." UK news source The Independent is reporting that Nav Canada's NOTAM system also suffered an issue.[1] Speculation: corrupting input, either international or North American? E.G. UTF-8, SQL escape, CSV quoting. edit: Better reporting of Canada's issue from Canada's CBC (and frankly, better reporting about the US, too). [2] "In Can…

Someone put an emoji in a NOTAM

Something like ... "CAVOK :)"
Post reply on HN