DATABASE CRASH - Lost 24 hours worth of POSTS ONLY!

Matrona · Oct 4, 2004

I was praying for you! I know whenever CF is down you are hard at work to get it back up again. Thanks, dude.

joyshirley · Oct 4, 2004

Erwin, you are soooo the man!! My mind boggles at all you do to keep this site running smoothly. I have no knowledge of how to do what you do so your abilities are doubly awesome to me. Especially considering your line of work and the demands that must put on you as well.

'You're the man!!!" as my kids would say. (And so do I!)

MQTA · Oct 4, 2004

so sorry to hear about CF problems, but thanks for doing what you could to save what you could

Dzhessika · Oct 4, 2004

Thanks sooo much Erwin for all the hard work you put into the site and the lack of sleep you sacrifice for it!The site really is the best ever !!!You Rock!!!

mnmcandiez · Oct 4, 2004

Thanks

Ashlynn · Oct 4, 2004

Thanks so much for all of the hard work you do. We appreciate it so so much!

Snowy · Oct 4, 2004

...wow!...Erwin you need to take a vaction from here..God bless that you for workign on saving CF and God bless God himself for not allowing a disaster to happen

xenia · Oct 4, 2004

Thanks so much Erwin for fixing everything. I was also praying for you.

In Christ Xenia

freespirit2001 · Oct 4, 2004

Bon · Oct 4, 2004

Wow! that is very cool.

Well done, you must be a genius.

Bon

UberLutheran · Oct 4, 2004

Erwin said:
Dear members and guests

Yesterday at 05:47 GMT (4 October 2004) CF's post table reached the maximum default size.

Because of this, the post table started getting corrupted.

Now, when this happened, it was 15:47 AEST and I was at work. I found out almost immediately, and shut the site down.

I left work early, and got home at 18:15 AEST (which is 08:15 GMT). I started work on the database straight away.

Took me LITERALLY 12 hours to SAVE ALL OF CF's POST - Basically, we were VERY CLOSE to losing the whole post table because of corruption,.

But praise God, I managed to save ALL of CF's posts EXCEPT THE LAST 23 HOURS - Basically from approximatel 09:00 GMT 3 October 2004.

I have been working on the CF database all night, and had about 3 hours of sleep - it took a long time to fix because the post table was so huge (many many gigabytes which was part of the problem as it got too big for the default database options). I had to keep repairing, optimizing, restoring and doing all sorts of tricks to save the database.

Praise God, we only lost the last 24 hours or so of POSTS ONLY.

EVERYTHING ELSE IS SAVED. All new users, blessings, data - everything is saved except the last 24 hours of posts.

This is why we have threads from the last 24 hours (we did not lose any threads) but they are empty of posts from the last 24 hours.

I want to sincerely apologize for this - I did not foresee that CF would grow so big that it would reach the normal default theoretical maximum size for a database table.

Anyway, I've fixed it so that the default size is an astronomical number now.

Thanks for your patience.

CF is back!

I know how expensive this stuff gets.

Let me know...

UL

Oblivious · Oct 4, 2004

Thanks for all of your hard work - it is greatly appreciated!!!

Cin · Oct 4, 2004

Thanks Erwin. God Bless You!

TSIBHOD · Oct 4, 2004

Bummer. And I typed (and thought) out a very elaborate post last night -- now gone. Oh, well. It's good that you could save what you did.

"Rejoice in the Lord always."

Adammi · Oct 4, 2004

Thank you so much for taking the time to fix this problem.

Lioness816 · Oct 4, 2004

YIPPEE!!! Thanks Erwin!!! I was so sad with out it...

Picture.Of.Obedience · Oct 4, 2004

Thanks!!!!!!!!!!!

CeeBee · Oct 4, 2004

Thanks Erwin! You're awesome!

Christian Dude · Oct 4, 2004

WHOO HOO! Praise God...

Thanks so much Erwin... If it wasn't for ya... we'd be in trouble.

Victrixa · Oct 4, 2004

Thank you so much Erwin for all that you do for us! I'm impressed by your commitment to these forums. May God bless you and protect you in all you do.

DATABASE CRASH - Lost 24 hours worth of POSTS ONLY!

Lady Godiva Freedom Rider

His Love endures forever

Irregular Member

Lovin' God's beautiful handiwork!

Veteran

Mrs. Paria

Jesus, You're all this heart is living for.

Contributor

Contributor

Truth Seeker

Well-Known Member

Matthew 7:12

Cin

Guest

Voice of Reason

A Nicene Christian not in CF's Xians Only Club

Well-Known Member

I am FREE!

Catholic

• Anointed, On-Fire, &amp; Prophetic Christian •

Dear Lord have mercy on me!

Similar threads

Privacy & Transparency

Privacy & Transparency

• Anointed, On-Fire, & Prophetic Christian •