CF Database corrupted again on 27 January with 28 hour downtime, now fixed!

[bubblefish]

Well done Erwin You really do a good juob keeping the forums running...

 

[Cin]

Thanks Erwin! Great job as usual.

 

[Alexis OCA]

Thank you for all you do Dr. Loh.

 

[I_are_sceptical]

Thank you very much, Erwin. I was bored while CF was down. I spend more time here than on any other forum.

Did anyone see the Google link at the bottom of page 1 for "new and used Erwins"? I think we are doing just fine with the one we already have.

 

[JunkYardFrog]

I'll leave things alone!

There's an old expression we old mechanics use. I'm sure you've heard it before:

"If it ain't broke, don't fix it!"

I know it doesn't exactly apply here, but I haven't had a chance to use it for a long time....



Anyway, thank you for your tremendous work for our Lord. I think it's entirely possible that some people we will meet in heaven will be there as a result of this message board. Please make sure you take enough time to take of YOU also. I hope you have enough helpers here to lighten your load.

God bless you, my brother.

Good night,

Bruce

 

[Zacharias]

As members would know, CF had a database crash on 25 January caused by the wrong setting in a config file - I fixed it in about 12 hours with no data loss.

Well, I didn't learn my lesson and kept modifying the database config to try to optimize the database so I could put our "find member's posts" feature back in.
It worked but because of the way I recoded things, the database was cacheing a lot of disk writes into RAM, and this caused occasional writes not to be written - leading to another database corruption.

This database corruption affected the WHOLE database - I had to restore our backups 3 times but they ended up being corrupted, and in the end decided to try to fix up the corrupted database. Took about 12 ours again...

Praise God, I fixed it, with minimal or no data loss whatsoever.

So now CF is back.

I promise I won't try to be too smart now. I'll leave things alone!

Erwin you've done a GREAT job with the CF. I've yet to find a forum that would come close to rivaling it.

 

[Matrona]

Praise God, I fixed it, with minimal or no data loss whatsoever.

So now CF is back.

Good job, Erwin.

I promise I won't try to be too smart now. I'll leave things alone!

But you are very smart!

I hope there is some way that feature can come back... not having it is driving me slightly nuts.

 

[crossrunner]

Once again thanks for all your hard work and tireless dedication, Erwin. You are simply the best!

 

[Glowworm]

Great job Erwin! Thanks for everything.

 

[Foofish]

You da man

 

[Nancaroo]

Thank you Erwin. I know I sure appreciate all the hard work you do. You are truly awesome and we thank the Lord for you

 

[Erwin]

Thanks for all the kind words.

I was expecting members to be angry at me!

 

[brinny]

Thanks for all the kind words.

I was expecting members to be angry at me!

Praying brother, praying

 

[Iron Sun 254]

Thanks for all the kind words.

I was expecting members to be angry at me!

After all you've done to create such a wonderful place? Not likely.

 

[krstlros]

Thanks for all the kind words.

I was expecting members to be angry at me!

Nah!!!!

I figured there was a good reason for the shut down. There always is.

Thanks, Erwin. For all you do for us around here, you are exceedingly blessed.

 

[Matrona]

Thanks for all the kind words.

I was expecting members to be angry at me!

[sign] Erwin is the coolest! [/sign]
​

Most of us know how much you put into CF and we have benefited greatly from the sacrifices you've made. I wouldn't have met my sweetie Michael if it wasn't for CF. And I know Michael and I aren't the first couple to have met on CF! How could anyone be angry with you for doing the best you can? Even if you lost every single post in CF history I know I would not be angry with you for it, I would just be glad to get CF back! ​

 

[MQTA]

Minimal data loss... and 28 hours of time. wow! Take a good break Erwin, you deserve it!

 

[prodromos]

Even if you lost every single post in CF history I know I would not be angry with you for it, I would just be glad to get CF back!

Ditto from me too. All that we post here is transient anyway, and my poor words aren't worth much in terms of eternity. I think the occasional downtime helps us to appreciate how much is involved in keeping this ship afloat.

God bless you Erwin.

John

 

[Johnboy60]

Thanks for all your work Erwin.



Robert.

 

[Ann M]

Thanks for all the kind words.

I was expecting members to be angry at me!

We're not mad at you Erwin.

We're more concerned about whether or not you're getting enough sleep and taking care of yourself. Please don't get sick.