|
Last week my postgres development database fell down because of some transaction id overflowing. We're still running maintenance on the large tables in standalone mode today, and yesterday the production server almost died after a reboot: "Sec Master Hard Disk:S.M.A.R.T. Status BAD, Backup and Replace
Press F1 to Resume". After some investigation it looks like the HD of the database is dying. And, oh goody, the message is :
SMART overall-health self-assessment test result: FAILED!
Drive failure expected in less than 24 hours. SAVE ALL DATA.
Failed Attributes:
ID# ATTRIBUTE_NAME FLAG VALUE WORST THRESH TYPE UPDATED WHEN_FAILED RAW_VALUE
5 Reallocated_Sector_Ct 0x0033 001 001 036 Pre-fail Always FAILING_NOW 4095
oh come one!
And of course no drives available that are large enough for a backup... (I could use the dev database, which is a pretty good copy, but that one is still in maintenance)
So I genuinally, sincerely hope your day is working out better than mine ...
|
|
|
|
|
V. wrote: my postgres development database fell down
That's why you no walk around with Databases!
No seriously, good luck on the backup and restore process, sending some good thoughts to you and hope it doesn't get worse
if(this.signature != "")
{
MessageBox.Show("This is my signature: " + Environment.NewLine + signature);
}
else
{
MessageBox.Show("404-Signature not found");
}
|
|
|
|
|
That reads more like an autopsy report than a rang.
but ... sympathies
«I want to stay as close to the edge as I can without going over. Out on the edge you see all kinds of things you can't see from the center» Kurt Vonnegut, Jr.
|
|
|
|
|
Pity you're so far away - I've got my old RAID NAS (4TB) I could clear, and I could scare up a couple of USB 2TB and 4TB HDDs if you were desperate.
But you are too far away for that to be feasible, so drive quickly to PCWorld, Maplin, or similar and get something similar!
Bad command or file name. Bad, bad command! Sit! Stay! Staaaay...
|
|
|
|
|
I'm working for the goverment, it's a Vogon administration....
but thanks for the offer
|
|
|
|
|
And of course the government has no money to pay for a decent RAID solution...
(If I had a disk failure right now, I would pull out the bad disk from the RAID, call for a replacement disk and push it in before going home...)
Skipper: We'll fix it.
Alex: Fix it? How you gonna fix this?
Skipper: Grit, spit and a whole lotta duct tape.
|
|
|
|
|
I like RAID 5!
Bad command or file name. Bad, bad command! Sit! Stay! Staaaay...
|
|
|
|
|
It is a RAID 1+0 (sometimes called RAID 10) - RAID 5 is less recommended as the rebuilding process is more risky...
Skipper: We'll fix it.
Alex: Fix it? How you gonna fix this?
Skipper: Grit, spit and a whole lotta duct tape.
|
|
|
|
|
RAID10 is good - but expensive in terms of disks, and for my needs RAID5 works well - and has proved it's worth with a HDD failure giving no interruption or data loss, but with a degree of slow down I could live with until the new disk arrived and was rebuilt.
The new NAS is hot-swappable, which is a big plus compared to the old one, but I didn't fancy giving away over 1/2 my new capacity for RAID 10. Just over 1/3 was fine.
Bad command or file name. Bad, bad command! Sit! Stay! Staaaay...
|
|
|
|
|
I'm RAID 5 on my home server for the same reasons as OG - I also run every OS as a VM under esXi I will never go back to dual booting and having separate hardware for different OS's
We can’t stop here, this is bat country - Hunter S Thompson RIP
|
|
|
|
|
RAID 5 is definitely dodgy, and not just because of the rebuild time - another disk can fail during the rebuild. For all my RAID 5 clients, I insist on a hot spare, a cold spare, and a complete replacement set from a different source. Hey - nothing wrong with paranoia!
I am slowly moving my clients to RAID 1 + 0, but they keep asking "What's it gonna cost?". I refer them to a KPMG survey that showed that 85% of companies that suffered a massive critical data loss go belly-up within two years (and another 10% within three years).
|
|
|
|
|
No backup! EEK!
Atleast you can keep on running your DB on one of the mirror disks, right?
Please tell me you have a mirror!
|
|
|
|
|
Yes I have a mirror, but I'm kind off worried about that one too (though it doesn't seem to have errors, yet)
|
|
|
|
|
If it's the same type of disk, bought at the same time, there's a chance it's from the same batch.
And if so, yes, you should worry.
I would pre-emptively buy another replacement disk from another shop (to get another batch) and swap the other disk too as soon as possible
|
|
|
|
|
The Vogon administrative mill has set into motion...
|
|
|
|
|
So, a second hand 1.44 MB floppy drive [without disks] will be with you in 3 and half years.
veni bibi saltavi
|
|
|
|
|
A couple of years ago we had a major outage that effected the business for a couple of days, I can't remember exactly which bit of kit it was, but we had two of them, chatting away, if one of them failed then the other would keep us working so we could get it fixed.
That was the theory anyway.
So a component failed in one, it was able to tell its mate what the problem was as it shut down.
It's mate thought to itself "I don't want that to happen to me" and shut down too.
Whenever we brought the second back up it said "Bugger off, I don't want to die" and shut down again.
I didn't think that was a wonderful piece of design.
Some men are born mediocre, some men achieve mediocrity, and some men have mediocrity thrust upon them.
|
|
|
|
|
I love the certainty in the message: "...expected in less than 24 hours."
Would have been nice to have given you guys that message, maybe, 24 days ago.
|
|
|
|
|
So we have it like 2 years and every half a year someone pops-up to check if everything is in order...Yesterday it was the first time I was in office when he came to inspect - he had only one comment: 'coffee is good here'...
Now you can imagine how good ISO is ...
Skipper: We'll fix it.
Alex: Fix it? How you gonna fix this?
Skipper: Grit, spit and a whole lotta duct tape.
|
|
|
|
|
Coffee inspection according to ISO2058666, what did you expect?
The language is JavaScript. that of Mordor, which I will not utter here
This is Javascript. If you put big wheels and a racing stripe on a golf cart, it's still a f***ing golf cart.
"I don't know, extraterrestrial?"
"You mean like from space?"
"No, from Canada."
If software development were a circus, we would all be the clowns.
|
|
|
|
|
Well imagine what would have happened if coffee was bad ?
if(this.signature != "")
{
MessageBox.Show("This is my signature: " + Environment.NewLine + signature);
}
else
{
MessageBox.Show("404-Signature not found");
}
|
|
|
|
|
If coffee was bad , they will not come again anymore .
நெஞ்சு பொறுக்கு திலையே-இந்த
நிலைகெட்ட மனிதரை நினைந்துவிட்டால்
|
|
|
|
|
The inspector would have left even earlier and wouldn't come back so soon?
If the brain were so simple we could understand it, we would be so simple we couldn't. — Lyall Watson
|
|
|
|
|
To both of you
He would not recertify your company !
if(this.signature != "")
{
MessageBox.Show("This is my signature: " + Environment.NewLine + signature);
}
else
{
MessageBox.Show("404-Signature not found");
}
|
|
|
|
|
Last I checked, coffee quality wasn't one of the ISO 9000 criteria - though it wouldn't surprise me
If the brain were so simple we could understand it, we would be so simple we couldn't. — Lyall Watson
|
|
|
|