Site Maintenance

[iozay]

Just changed my mail adres. The following PHP code appeared on the confirmation URL:

Code: [Select]

name']) > 25) $context['checked_username'] = $smcFunc['htmltrim']($smcFunc['substr']($context['checked_username'], 0, 25)); // Only these characters are permitted. if (preg_match('~[<>&"\'=\\\]~', preg_replace('~&#(?:\\d{1,7}|x[0-9a-fA-F]{1,6});~', '', $context['checked_username'])) != 0 || $context['checked_username'] == '_' || $context['checked_username'] == '|' || strpos($context['checked_username'], '[code') !== false || strpos($context['checked_username'], '[/code') !== false) $context['valid_username'] = false; if (stristr($context['checked_username'], $txt['guest_title']) !== false) $context['valid_username'] = false; if (trim($context['checked_username']) == '') $context['valid_username'] = false; else { require_once($sourcedir . '/Subs-Members.php'); $context['valid_username'] &= isReservedName($context['checked_username'], 0, false, false) ? 0 : 1; } } ?>
The link that was used:
http://www.arcengames.com/forums/index.php?action=activate;u=13258;code=e326953d26

[Aklyon]

The wiki appears to be completely empty at the moment. I guess its not done with maintenance?

[Dominus Arbitrationis]

Alright, I figured it out. The problem arises from a faulty backup service that duplicated the code and put it at the end of some files. Sometime today I will probably be be refreshing the site files with unbroken ones, which may cause some downtime here.

The wiki appears to be completely empty at the moment. I guess its not done with maintenance?

Yep, the text table is refusing to export fully. So I'm trying to get everything to export properly then import it without damaging the wiki.

[x4000]

What about doing just an entire database copy?  Can we do that while still updating to the newer MySQL version?  And yeah, I'm pretty pissed with codeguard.

[Dominus Arbitrationis]

The database is actually so large that it can't be normally exported. Even a mysqldump takes over fifteen minutes, which is Rackspace's cutoff point. I'm trying to use the codeguard backup right now and it takes a ton of time to download then to extract from the zip. I've looked into doing replication, but Rackspace doesn't support that.

[x4000]

That's for the wiki database? 

I know that mantis is huge with all the file BLOBs, but I thought the wiki was just text in the database and then files externally.  And very few files on that anyway, to my knowledge.

[Dominus Arbitrationis]

The wiki text table is about 2.0 GiB and Mantis's file table is about 4.3GiB. The rest of the tables are pretty small and already imported. Speaking of importing, I am now about to try putting in the Mantis Files table.

[x4000]

Dear god that's a lot of text.  I guess that's because of all the revision histories for massive pages.  If there's a way for us to blow out revision histories and just keep the most recent version of everything that is there right now, I'd be cool with that.  After 5+ years it's plenty time to do that anyhow.

[Dominus Arbitrationis]

Nope. Revisions are stored in their own little table that is only 11 MiB. It is really scary to think about just how much text is on that wiki.

Also, sorry about the tiny bit of downtime there. The SWAP partition got stuck and I had to reboot the system otherwise nothing runs quickly at all.

[x4000]

No problem at all.

[Aklyon]

The wiki is that big, even without the revision text? Woah.

[x4000]

I have a feeling that the revisions table is a lookup table, and the text from the revisions is in the main text table, but I could be wrong.

[Dominus Arbitrationis]

Nope. It stores the edit summaries in blobs in the revisions table. Of course, the blobs are really small, with the largest only being a KB or two I believe. There is a max character limit for the summaries which is what makes it so small.

[Dominus Arbitrationis]

Can I have some volunteers look through Mantis and find all of the uploaded files that are missing? I believe I fixed the database so every uploaded file should be there, but I want to be sure.

EDIT: I just checked the latest issues and I do believe they are all set up. However, about 10 issues have disappeared. I will be sending the people who lost their issues emails containing the details of their post.

[iozay]

Why oh why did I thought that this was a mess before to start... Obviously I was right.

@Chris: You made for sure the right call at allowing some downtime, even an enterprise level organization would have scheduled at the very least a period of time to make parts of the system read only for end-users.

Good luck with ironing out the issues!