Social Anxiety Support

Drew · 09-19-2009, 08:11 AM

Social Anxiety Support was down for almost 6 hours from 2am to 8am PDT.

The downtime was due to repairing corruption in the post database table. The corruption was an unintended resulted from a change that was made on the database. It took so long because of the fact that the post table is over 1 million posts

Everything should be back to normal. Let me know if anything seems out of the ordinary, whether that's reading threads or searching.

Thanks for your understanding.

Drew

jer · 09-19-2009, 08:13 AM

thanks for the update Drew.

for a second I thought my ISP was acting up again.

Drew · 09-19-2009, 08:16 AM

Of course! I apologize for the downtime.

Also, I'd like to let everyone know that we do have daily backups for the previous week if something like this ever happens and we are unable to fix it.

caflme · 09-19-2009, 08:30 AM

Definitely thanks for the update.

mind_games · 09-19-2009, 09:41 AM

Thanks Drew

Drew · 09-19-2009, 09:58 AM

I'm still noticing some database errors when people are trying to edit their posts.

If you're reading this, could you try going and editing one of your posts (even if you just add a period or a dash to the end of the post) and let me know if you saw any error.

Thanks!

strawberryjulius · 09-19-2009, 05:56 PM

Yeah, I still get a database error when I try to edit my posts.

VIncymon · 09-19-2009, 06:40 PM

Thanks for that post. I was wondering if my modem was acting up again.

Nani · 09-19-2009, 06:45 PM

Thanks. I also wondered what was going on.

Drew · 09-19-2009, 07:01 PM

I'm working on it. I'll let you guys know when I get it fixed!

Drew · 09-20-2009, 05:51 AM

The problem has been fixed as far as I can tell. Please let me know if you see any other database errors when trying to edit posts.

Thanks for your patience.

(test edit)

power2theweak · 09-20-2009, 06:29 AM

Quote:

Originally Posted by Drew

I'm still noticing some database errors when people are trying to edit their posts.

If you're reading this, could you try going and editing one of your posts (even if you just add a period or a dash to the end of the post) and let me know if you saw any error.

Thanks!

Thanks for the post. I was wondering what happened. Thought it might be my computer again. Oh, and I was able to edit my post.

Drew · 09-20-2009, 06:11 PM

Quote:

Originally Posted by power2theweak

Thanks for the post. I was wondering what happened. Thought it might be my computer again. Oh, and I was able to edit my post.

Thanks for letting me know!

And definitely let me know if you ever have any problems again editing a post. I know how to fix the issue now!

09-19-2009, 08:11 AM	#1 (permalink)
Drew Status: Administrator Join Date: Jan 2006 Location: Seattle, WA Gender: Male Posts: 1,381	SAS Downtime - September 19th, 2009 Social Anxiety Support was down for almost 6 hours from 2am to 8am PDT. The downtime was due to repairing corruption in the post database table. The corruption was an unintended resulted from a change that was made on the database. It took so long because of the fact that the post table is over 1 million posts Everything should be back to normal. Let me know if anything seems out of the ordinary, whether that's reading threads or searching. Thanks for your understanding. Drew

09-19-2009, 09:41 AM	#5 (permalink)
mind_games Status: dances, like a fridge Join Date: Nov 2008 Age: 23 Posts: 1,571	Thanks Drew __________________ "this is not me, this is me reacting to your perception of me"

09-19-2009, 05:56 PM	#7 (permalink)
strawberryjulius Status: ^_^ Join Date: Jun 2009 Location: Australia Gender: Female Age: 18 Posts: 1,569	Yeah, I still get a database error when I try to edit my posts. __________________ Last.fm▪Anime "And if you've been let down, it might not be the last time. Cheer up, it will hurt much less tomorrow. We're all tired of **ing up and that's not just being sorry. It means brush the dirt off, get up and try again." NaNoWriMo Word Count: 470/50,000**

09-19-2009, 08:13 AM	#2 (permalink)
jer Status: SAS Member Join Date: Jun 2009 Location: Texas Gender: Male Posts: 221	thanks for the update Drew. for a second I thought my ISP was acting up again.

09-19-2009, 08:16 AM	#3 (permalink)
Drew Status: Administrator Join Date: Jan 2006 Location: Seattle, WA Gender: Male Posts: 1,381	Of course! I apologize for the downtime. Also, I'd like to let everyone know that we do have daily backups for the previous week if something like this ever happens and we are unable to fix it.

09-19-2009, 08:30 AM	#4 (permalink)
caflme Status: SAS Member Join Date: Jun 2009 Location: Florida Gender: Female Age: 44 Posts: 582	Definitely thanks for the update.

09-19-2009, 09:58 AM	#6 (permalink)
Drew Status: Administrator Join Date: Jan 2006 Location: Seattle, WA Gender: Male Posts: 1,381	I'm still noticing some database errors when people are trying to edit their posts. If you're reading this, could you try going and editing one of your posts (even if you just add a period or a dash to the end of the post) and let me know if you saw any error. Thanks!

09-19-2009, 06:40 PM	#8 (permalink)
VIncymon Status: SAS Member Join Date: Apr 2009 Gender: Male Posts: 741	Thanks for that post. I was wondering if my modem was acting up again.

09-19-2009, 06:45 PM	#9 (permalink)
Nani Status: SAS Member Join Date: Sep 2009 Posts: 21	Thanks. I also wondered what was going on.

09-19-2009, 07:01 PM	#10 (permalink)
Drew Status: Administrator Join Date: Jan 2006 Location: Seattle, WA Gender: Male Posts: 1,381	I'm working on it. I'll let you guys know when I get it fixed!

09-20-2009, 05:51 AM	#11 (permalink)
Drew Status: Administrator Join Date: Jan 2006 Location: Seattle, WA Gender: Male Posts: 1,381	The problem has been fixed as far as I can tell. Please let me know if you see any other database errors when trying to edit posts. Thanks for your patience. (test edit)