Author Topic: Site Maintenance  (Read 5160 times)

Offline iozay

  • Newbie Mark III
  • *
  • Posts: 48
Re: Site Maintenance
« Reply #15 on: May 24, 2015, 10:10:29 AM »
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

Offline Aklyon

  • Core Member
  • *****
  • Posts: 2,089
Re: Site Maintenance
« Reply #16 on: May 24, 2015, 10:21:12 AM »
The wiki appears to be completely empty at the moment. I guess its not done with maintenance?

Offline Dominus Arbitrationis

  • Arcen Games Contractor
  • Administrator
  • Sr. Member Mark III
  • *****
  • Posts: 451
Re: Site Maintenance
« Reply #17 on: May 24, 2015, 10:36:11 AM »
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.
Come help out at the Wiki!

Have ideas or bug reports for one of Arcen's games or any part of the site? Use  Mantis for Suggestions and Bug Reports. Thanks for helping to make our games and site better!

Offline x4000

  • Chris Park, Arcen Games Founder and Lead Designer
  • Administrator
  • Zenith Council Member Mark III
  • *****
  • Posts: 31,162
Re: Site Maintenance
« Reply #18 on: May 24, 2015, 12:54:38 PM »
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.
Have ideas or bug reports for one of our games?  Mantis for Suggestions and Bug Reports. Thanks for helping to make our games better!

Offline Dominus Arbitrationis

  • Arcen Games Contractor
  • Administrator
  • Sr. Member Mark III
  • *****
  • Posts: 451
Re: Site Maintenance
« Reply #19 on: May 24, 2015, 01:00:44 PM »
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.
Come help out at the Wiki!

Have ideas or bug reports for one of Arcen's games or any part of the site? Use  Mantis for Suggestions and Bug Reports. Thanks for helping to make our games and site better!

Offline x4000

  • Chris Park, Arcen Games Founder and Lead Designer
  • Administrator
  • Zenith Council Member Mark III
  • *****
  • Posts: 31,162
Re: Site Maintenance
« Reply #20 on: May 24, 2015, 01:05:25 PM »
That's for the wiki database?  :o

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.
Have ideas or bug reports for one of our games?  Mantis for Suggestions and Bug Reports. Thanks for helping to make our games better!

Offline Dominus Arbitrationis

  • Arcen Games Contractor
  • Administrator
  • Sr. Member Mark III
  • *****
  • Posts: 451
Re: Site Maintenance
« Reply #21 on: May 24, 2015, 01:07:51 PM »
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.
Come help out at the Wiki!

Have ideas or bug reports for one of Arcen's games or any part of the site? Use  Mantis for Suggestions and Bug Reports. Thanks for helping to make our games and site better!

Offline x4000

  • Chris Park, Arcen Games Founder and Lead Designer
  • Administrator
  • Zenith Council Member Mark III
  • *****
  • Posts: 31,162
Re: Site Maintenance
« Reply #22 on: May 24, 2015, 01:10:20 PM »
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.
Have ideas or bug reports for one of our games?  Mantis for Suggestions and Bug Reports. Thanks for helping to make our games better!

Offline Dominus Arbitrationis

  • Arcen Games Contractor
  • Administrator
  • Sr. Member Mark III
  • *****
  • Posts: 451
Re: Site Maintenance
« Reply #23 on: May 24, 2015, 01:16:58 PM »
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.
Come help out at the Wiki!

Have ideas or bug reports for one of Arcen's games or any part of the site? Use  Mantis for Suggestions and Bug Reports. Thanks for helping to make our games and site better!

Offline x4000

  • Chris Park, Arcen Games Founder and Lead Designer
  • Administrator
  • Zenith Council Member Mark III
  • *****
  • Posts: 31,162
Re: Site Maintenance
« Reply #24 on: May 24, 2015, 01:20:18 PM »
No problem at all.
Have ideas or bug reports for one of our games?  Mantis for Suggestions and Bug Reports. Thanks for helping to make our games better!

Offline Aklyon

  • Core Member
  • *****
  • Posts: 2,089
Re: Site Maintenance
« Reply #25 on: May 24, 2015, 01:23:53 PM »
The wiki is that big, even without the revision text? Woah.

Offline x4000

  • Chris Park, Arcen Games Founder and Lead Designer
  • Administrator
  • Zenith Council Member Mark III
  • *****
  • Posts: 31,162
Re: Site Maintenance
« Reply #26 on: May 24, 2015, 01:38:03 PM »
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.
Have ideas or bug reports for one of our games?  Mantis for Suggestions and Bug Reports. Thanks for helping to make our games better!

Offline Dominus Arbitrationis

  • Arcen Games Contractor
  • Administrator
  • Sr. Member Mark III
  • *****
  • Posts: 451
Re: Site Maintenance
« Reply #27 on: May 24, 2015, 01:43:19 PM »
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.
Come help out at the Wiki!

Have ideas or bug reports for one of Arcen's games or any part of the site? Use  Mantis for Suggestions and Bug Reports. Thanks for helping to make our games and site better!

Offline Dominus Arbitrationis

  • Arcen Games Contractor
  • Administrator
  • Sr. Member Mark III
  • *****
  • Posts: 451
Re: Site Maintenance
« Reply #28 on: May 24, 2015, 02:52:14 PM »
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.
« Last Edit: May 24, 2015, 03:05:51 PM by Dominus Arbitrationis »
Come help out at the Wiki!

Have ideas or bug reports for one of Arcen's games or any part of the site? Use  Mantis for Suggestions and Bug Reports. Thanks for helping to make our games and site better!

Offline iozay

  • Newbie Mark III
  • *
  • Posts: 48
Re: Site Maintenance
« Reply #29 on: May 25, 2015, 07:59:29 AM »
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! :)