Site Status

Talk about the website, offer suggestions, express opinions, and get help with understanding and using the forums.
User avatar
Hardcore
Absolute Otaku
Posts: 3604
Joined: Jun 23, 2007 7:08pm
Gender: Female
Location: Ohio

Re: Site Status

Post by Hardcore »

I googled "tacobell and things you can buy theo for xmas"
Nothing. :(
Decisions to decisions are made and not bought, but I thought this wouldn't hurt a lot. I guess not.
User avatar
Athos
Moderator
Moderator
Posts: 7625
Joined: Feb 17, 2006 7:10pm
Gender: Male
Location: U.S.

Re: Site Status

Post by Athos »

Theo wrote:There was a problem with the database today. For some reason the mysql database decided that it would continously crash because of a bad innodb page. If this sounds greek, then you're part of the 99.99% of the world who doesn't need to know this. To fix the problem I had to stop the web services, stop mysql, add a special line to the mysql config file to allow innodb recovery, do a full export of the entire database (which wasn't that bad), renamed the mysql data folder, created a new mysql data folder, ran the mysql_install_db script, updated the permissions on the folder (and it's contents), removed the line that I added to the mysql config, started mysql, performed a full import of the data (which was slow as it's a large database), and then finally started the web services.

Why is this important. It's not, but if someone runs into the same problem, google would have indexed this page and they might just find the answer they were looking for.

So, the keywords of the day are: mysql innodb corrupt table recovery shot who in the foot and didn't know it tacobell and things you can buy theo for xmas

Would this be also be the reason why I was unable to access the Board index? Google claimed it was a reported attack site for malware.
Member of the ModSquad 8)
User avatar
Hardcore
Absolute Otaku
Posts: 3604
Joined: Jun 23, 2007 7:08pm
Gender: Female
Location: Ohio

Re: Site Status

Post by Hardcore »

Mista Cola's did that, too.
Last edited by Hardcore on Feb 06, 2010 7:23pm, edited 1 time in total.
Decisions to decisions are made and not bought, but I thought this wouldn't hurt a lot. I guess not.
User avatar
webmaster
Site Admin
Site Admin
Posts: 1102
Joined: Jul 24, 2004 10:25pm
Gender: Male
Location: Redding, CA
Contact:

Re: Site Status

Post by webmaster »

I don't think that had anything to do with it. Google Webmaster Tools couldn't pinpoint any cause, so I submitted for a re-check and apparently it came out good because there is no more malware warning.
User avatar
SASSZAIN
Moderator
Moderator
Posts: 5325
Joined: Jan 27, 2006 8:09am
Gender: Female
Location: Everywhere and nowhere
Contact:

Re: Site Status

Post by SASSZAIN »

I had the malware warning as well lust 5ish minutes after Athos did, then it went away just as randomly as it came back.. Really odd.
"You dont have to be alive to make yourself relevant.And you dont have to be a good person to be a hero.You just have to know who you are and stay true to that.So Im going to keep fighting for people the only way I ever knew how"-Vriska Serket
User avatar
webmaster
Site Admin
Site Admin
Posts: 1102
Joined: Jul 24, 2004 10:25pm
Gender: Male
Location: Redding, CA
Contact:

Re: Site Status

Post by webmaster »

I think it went away because I requested they recheck my site, and the recheck turned up nothing bad.
User avatar
Athos
Moderator
Moderator
Posts: 7625
Joined: Feb 17, 2006 7:10pm
Gender: Male
Location: U.S.

Re: Site Status

Post by Athos »

Aye, the web is a queer mistress.
Member of the ModSquad 8)
Theo
Host Admin
Host Admin
Posts: 276
Joined: Aug 27, 1973 12:03am
Gender: Male
Location: CA, USA, Earth, Milkyway

Re: Site Status

Post by Theo »

Major change to the networking of AA today. Prior to today we used to have everything running behind a NAT'ed firewall. Today we are running it through a bridged firewall. This should once and for all solve global warming. Once and for all!

As always, if any of the moderators find a problem with the site, email Ken (or myself if you are one of the privileges people who ever wrote down my email address).

If you are a moderator and need my email, just PM me.
User avatar
Dretlin
Moderator
Moderator
Posts: 2898
Joined: Oct 29, 2004 8:00am
Gender: Male
Location: Scotland

Re: Site Status

Post by Dretlin »

Theo wrote:Major change to the networking of AA today. Prior to today we used to have everything running behind a NAT'ed firewall. Today we are running it through a bridged firewall. This should once and for all solve global warming. Once and for all!

As always, if any of the moderators find a problem with the site, email Ken (or myself if you are one of the privileges people who ever wrote down my email address).

If you are a moderator and need my email, just PM me.
I do require your email - but mostly for the purpose of shenanigans and nothing productive.
Theo
Host Admin
Host Admin
Posts: 276
Joined: Aug 27, 1973 12:03am
Gender: Male
Location: CA, USA, Earth, Milkyway

Re: Site Status

Post by Theo »

The server had a hiccup this week. We received an alert saying one of the mirrored drives was having some problems. So, like the good boys we are, we looking into the problem. The drive reporting the problem would not succesfully complete a disk check. The mirror was still fine. The other disk had an error form before, but selfcheck worked fine.

So I created a temporary virtual server and replicated all files/config/data/etc from the normal server to the temp server. I've done it a few times today. After the last replication, the main server stopped responding. So, we failed over to the replicated copy. There may be a 20 minutes window where forum topics were missed.

Hopefully I can get these drives replaced ASAP, assuming that's the problem. The virtual server doesn't have the ram I would like it to have to keep it on that server (it's much faster, just not enough memory). What really sucks is these drives were purchase and installed about a year ago. They have around 400 days on them and they both have errors now (one about 3 months ago, and the one this week).
Theo
Host Admin
Host Admin
Posts: 276
Joined: Aug 27, 1973 12:03am
Gender: Male
Location: CA, USA, Earth, Milkyway

Re: Site Status

Post by Theo »

There was a crash last night. For some reason we received from Segmentation fault errors in the apache log. A backtrace showed "zend_mm_heap corrupted", which, after doing some research, appears to be a non-fixed long standing PHP bug. I'm not sure why we haven't received this type of error before, in the 10+ years of running this site, I think it's the first time we have seen this bug. We have seen other bugs, just not this one. Anyway, I have implemented the suggest workaround from the PHP site for it.

Anyway, if all this sounds greek to you, well, it just means that we had a hiccup...
User avatar
Dretlin
Moderator
Moderator
Posts: 2898
Joined: Oct 29, 2004 8:00am
Gender: Male
Location: Scotland

Re: Site Status

Post by Dretlin »

Aye, I was wondering what that was.
Mai
Moderator
Moderator
Posts: 5580
Joined: Oct 30, 2004 6:54pm
Gender: Female
Location: New York

Re: Site Status

Post by Mai »

Theo wrote:There was a crash last night. For some reason we received from Segmentation fault errors in the apache log. A backtrace showed "zend_mm_heap corrupted", which, after doing some research, appears to be a non-fixed long standing PHP bug. I'm not sure why we haven't received this type of error before, in the 10+ years of running this site, I think it's the first time we have seen this bug. We have seen other bugs, just not this one. Anyway, I have implemented the suggest workaround from the PHP site for it.

Anyway, if all this sounds greek to you, well, it just means that we had a hiccup...
I know latin, that just sounded nerdy.
I felt like a race horse in a world without racetracks or a champion college footballer suddenly confronted by Wall Street and a business suit, his days of glory shrunk to a little gold cup on his mantel with a date engraved on it like a tombstone.
Theo
Host Admin
Host Admin
Posts: 276
Joined: Aug 27, 1973 12:03am
Gender: Male
Location: CA, USA, Earth, Milkyway

Re: Site Status

Post by Theo »

nosaj thing wrote:I know latin, that just sounded nerdy.
And proud of it. Remember, nerdy != weird, which means..., well I'll stop there.
testeeerwe
Visitor

Re: Site Status

Post by testeeerwe »

test
Theo
Host Admin
Host Admin
Posts: 276
Joined: Aug 27, 1973 12:03am
Gender: Male
Location: CA, USA, Earth, Milkyway

Re: Site Status

Post by Theo »

Failed
Post Reply