Forum database crash. Something got screwed [merged]

[Tree]

Did the forum revert to 3 days ago or something? My avatar also changed to my old one.

[Rick]

So did most of the posts

[needlehost]

rats, I got quite a few these last days.
I think we all know why, but by saying what it is, we defeat the whole purpose of it.

[Todd]

I sincerely apologize for this issue. We had a pretty major crash / set back. Things got complicated when the prior days backup was overwritten with corrupt data.

We then restored another SQL dump file that was a bit older. We've had a replacement server running in the datacenter for some time now, but we've been fixing small issues before we moved it over. I think Peo has checked it our pretty thoroughly now, and we'll be moving FreeWebspace.net over this weekend.

Again my apologies. I think we'll all be much happier once we get everything moved over to a faster and more reliable server.

[Tree]

So this was purely a technical issue?

[needlehost]

so nothing to do with the ch/rtg/fws mess then?

[Todd]

Yes, it was purely a technical issue. Hopefully things can resume now without too much confusion. Also just be aware that this weekend the server will be slow at times as we re-sync the content, import the databases to MySQL 5, and fix issues as they come up. Sorry again guys, I hate missing data as much as the next guy.

[needlehost]

so when do we get a fws when the downtime is less than the uptime?

[Todd]

Although far to drastic your point is well taken, and we've been aware of the issues for a while. That's why we have the new server in place. We just took that as an opportunity to upgrade to some newer versions of software, which broke some custom code. We went back and forth with issues for a while, but we've worked out most of the bugs now. I should also note that the network has been fine throughout these incidents so things will be greatly improved with the new server. Just bear with us for another few days, and you should see a significant improvement.

[amz]

Has anyone else around here noticed that all the
posts and private messages for the past 2 days
have dissapeared from freewebspace.net?

What happened?

Did you all have a database crash or something?

[Tree]

Yeah, that's kind of what this thread is about...

http://www.freewebspace.net/forums/showpost.php?p=700984&postcount=4

[amz]

I posted a similiar thread in one of the other forum areas just a little while ago ...

All of the sudden the private messages I read 2 days ago were back to unread again!

All the posts and threads for the past 2 days are gone ....

I guess FWS had a database crash or something and restored a backup.


EDIT: Oh wierd, someone merged my other thread into this one

[hottweelz]

Yeah, that's kind of what this thread is about...

http://www.freewebspace.net/forums/showpost.php?p=700984&postcount=4


Lol I heard that there is 5:1 Odds on http://youwager.com that he clicked on the above link three times before realizing.

Any takers?

[Tree]

I'd say that's a "yes". Maybe even a "definitely".

[A1Owner]

Ok nvm seems like a coverup took place and so i put my reply in this thread :
http://freewebspace.net/forums/showthread.php?t=2162142

[A1Owner]

I sincerely apologize for this issue. We had a pretty major crash / set back. Things got complicated when the prior days backup was overwritten with corrupt data.

We then restored another SQL dump file that was a bit older. We've had a replacement server running in the datacenter for some time now, but we've been fixing small issues before we moved it over. I think Peo has checked it our pretty thoroughly now, and we'll be moving FreeWebspace.net over this weekend.

Again my apologies. I think we'll all be much happier once we get everything moved over to a faster and more reliable server.

Are you sure dude its not a coverup about the hotweelz thread, cause its pretty strange that there are replies that were posted on April 4th that still exists and i think he posted that thread like on april 3rd or on 4th and last reply was on april 5th by peo. So why did the threads dissappear and not the replies? Cause if am correct a db crash and restoration of say 3rd april (3 days old) db would not show april 4ths replies cause at that day 4th had not even arrived yet.

So do you have any proof of this so called "db crash "?

And wait a minute i remember i uploaded this new avatar of mine only yesterday, so if it was really a crash as said why is my avatar still intact? Any Explaination about this?

[build-a-host]

I highly doubt they would revert the forum back 3 or 4 days just to get rid of a thread that got a bit heated.

[Jan]

Exactly, easier to toss it :S Please don't insult Todd and Peo for all the work they have put into getting the place working better. Peo has another forum *somewhere* that has also lost data.

[Craig]

Hey

I been gone for 12 hours & I have lost 40+ posts & half of the threads from yesterday have gone. Can someone explain?. I know this should be in feedback but I feel theres more to this?. :confused4 also my sig has changed?.

[Peo]

We apologize for the server crash and the lost data for the last few days. This effected the whole server and by that several other of my sites. Obviously we wouldn't delibererately crash the server as Todd has already explained. I lost a lot of work I did over the last couple of days for these sites and everybody lost a lot of posts, pms etc. It's very frustrating but in the end it was sadly the only solution to get everything working again.

If you signed up for the forum over the last few days, you would have to sign up again. All data is lost for this period.

We've been having problems with the database for a couple of weeks now as you all know and we'll be moving to a new server to avoid future problems.

Again, we apologize for any inconvenience this may have caused you.

[Wojtek]

its already in feedback craig
http://freewebspace.net/forums/showthread.php?t=2162142

[sep]

I like pie...... Back on subject I only lost 5 posts.

[trev]

Hay i posted a topic called "Advertise of 3 websites for free" in add / offers but i cant find it anywhere?

[Peo]

Unfortunately we had a db crash, read more here (http://www.freewebspace.net/forums/showthread.php?t=2162142)

[trev]

Ok thanks sorry i didnt read i just thought it had bein deleted thanks Peo.

[Jan]

Just a note, if anyone placed an offer in the last couple of days, please repost it (providing it is still over 7 days ;)) I have had a few PMs already about it. Even new members don't exist :S

[needlehost]

all a little too convinent. netcafe can no longer take legal action becuase theres no evidence! is it just me who thinks this is way to fishy?
this is a disgrace.

[Jan]

If you really think that, you don't know Peo and Todd very well. I would strongly suggest that anyone thinking this is a conspiracy theory take a step back from the keyboard for a bit.

[needlehost]

jan, answer this question
am I right in saying netcafe has NO EVIDENCE if he decides to take legal action now?

[Jan]

There is no evidence that anyone posted at all in the last couple of days before they restored the most recent backup. Give it up please!

[needlehost]

so yes, netcafe is going to have a fun time trying to press legal actions now.

[Peo]

NetCafe already said he would not take any legal action, so I suggest you drop your conspiracy theories. The matter was already closed before the db crash even if you were not here to read it at that time.

[needlehost]

ahhh ok. fair enough:P just as well;)

[heymrdj]

Lol guys its a crash and nothing more. I recognied it yesterday. I've seen them before, and the select missing threads, the slight setback to PM's, I knew there had to be another crash. I lost nothing important :P.

[Robert]

By the way some of you talk about this incident, others would think you paid a premium to use the service and aren't getting your monies worth. :confused4

[needlehost]

good idea. if it means that fws gets $99.99 i'd happily pay $10 membership monthly to advertise my host. It would keep out hosts that dissapear after a week as well:P

[A1Owner]

There is no evidence that anyone posted at all in the last couple of days before they restored the most recent backup. Give it up please!

Please define most recent the date and time would be good enough.

[Craig]

Please define most recent the date and time would be good enough.

Yea, & maybe add another 50 posts to my count that I lost :wink2:

[A1Owner]

Yea, & maybe add another 50 posts to my count that I lost :wink2:

Yaa i was sitting at 890 posts count. pirate2

[Tree]

Gah, all of you chill.

[heymrdj]

Gah, all of you chill.

Mr. T says take a chill pill. I pity da foo who tink he can bawizzle Mr. T shizzle. :-)

[Bruce]

Please define most recent the date and time would be good enough.
All data from the last 2 days was lost. This included threads, posts, PMs, and any newly registered users.

The most recent backup was corrupted as well, hence the 2-day rollback.

[A1Owner]

All data from the last 2 days was lost. This included threads, posts, PMs, and any newly registered users.

The most recent backup was corrupted as well, hence the 2-day rollback.


Thanks but date would make it way easier. And i need to hear it from Owner of forums .

[Peo]

I don't know the exact time. As you can see at the forum, posts from early April 5 is still here. (depending on your time zone)

Why do you need the exact time?

[A1Owner]

Because i like exact numbers.

[Peo]

As I said I don't know and I don't see how it would matter. If Todd knows he'll respond.

[Compufusion]

good luck with the change over, hope all goes well and over all I think FWS is doing a good job and if some people dont like it nobody is forcing them to come back.

[build-a-host]

I think the idea of having to pay to post in the offers section is a good one. It would get rid of the hosts that show up, take some money, and then disappear! I would gladly pay to post there, as it has made me plenty of money from signups!

[hottweelz]

But we can Pay FWS via the Advertising Section anyway.

[needlehost]

not all of us have that much hottweelz:P
I think free hosts should have to pay too, but less mabye say $10 for free hosts $20 for paid (monthly)

[hottweelz]

not all of us have that much hottweelz:P
I think free hosts should have to pay too, but less mabye say $10 for free hosts $20 for paid (monthly)

From what I hear, advertising here is a smart move, because of the traffic on this site. i think only 15-20% Of the traffic is actual memberships, the rest are guests and trolls viewing.

The question is "Do you want FWS Targetted Traffic in Ads?"

If so you're probably in for a treat. The pricing is a little high, but, other hosts have told me they got what they wanted.

[heymrdj]

I don't about you hotweel, but I ain't got the extra cash to throw into paying for a forum XD.

[A1Owner]

From what I hear, advertising here is a smart move, because of the traffic on this site.

Nope it wont be cause trust me i wont pay for getting non-quality clients in return. No offense to space seekers but people come here with free web space sort of mentality and paid hosting is like rocket science to them. Plus why spend money here when you can get good quality clients off sitepoint by using same amount there ?

what guarantee exists that after spending money here i will get quality clients?

Anyways back to topic i am still waiting for date (exact one ) , because i find it too inconvinient that after so many years of no db crash it all the sudden crashes just after the HW controversial thread?

[Bruce]

Give up the conspiracy theory. Todd doesn't have the time to be bothered looking up exact times for you, nor should he be expected to.

[A1Owner]

Give up the conspiracy theory. Todd doesn't have the time to be bothered looking up exact times for you, nor should he be expected to.

Ah no conspiracy = no fun :(.

[Craig]

Ah no conspiracy = no fun :(.

Maybe your the conspiracy!. Let it go, have a drink.

[A1Owner]

Maybe your the conspiracy!. Let it go, have a drink.

Seems like it was craigs hand behind all the so called crash . I will get to the bottom of this someday .

[Robert]

Complete disrespect for Todd if you believe that there is a so called conspiracy. Let's end this. I'm locking this thread.