• Content count

  • Joined

  • Last visited

About Sparks

  • Rank
    Sysadmin of Ice and Fire

Contact Methods

  • Website URL
  • ICQ 0

Profile Information

  • Gender Female
  • Location Seattle, WA
  • Interests I ride horses, I take pictures, I write stories and hope to eventually be published. For my day job, I make computer software.

    In my oh-so-copious free time I also run a small private ISP that hosts a number of largish websites as favors to friends, including (and the ASoIaF board, and Blood of Dragons, and so on...). This caused GRRM to quip once that I was 'The Sysadmin of Ice and Fire,' hence my board title.

Previous Fields

  • Name Rachel Blackman

Recent Profile Visitors

1,275 profile views
  1. Board Issues 4

      There was an issue with the indexer's automated runs not working right; I tweaked it this morning, so hopefully Sphinx now works in all indexing cases.
  2. Board Issues 4

    Since the only actual error that happens when that crops up is that the sidebar uses an older copy of the 'news' feed, I've just made the server strip out the error messages for the moment. I figure we can sort out the rest after the seasonal traffic dies down. :P
  3. Board Issues 4

    The PHP errors seem to be an issue in the stuff that ties back to the main site, for the "The Latest News" sidebar. They're happening very sporadically, so they're hard to track down, but I'll poke a bit this week.
  4. Board Issues 4

    To elaborate slightly, there's an issue with this particular version of Mediawiki that arose after the upgrade. This issue is also the thing which led the forum and wiki to not co-exist well, which is why the forum was shifted back over to another machine; at least this way if the wiki does Strange Things, it doesn't take the forum down by virtue of being on the same webserver. There is a watchdog running which, if the wiki goes wonky, should function to shut it down and repair things. It means you'll get a Varnish error for about a minute or two when that happens, but then the wiki should come back properly after that. Hopefully we'll have a fix for the wonky wiki weirdness (yes, I'm just going for the alliteration at this point) soon and that will go away.
  5. Board Issues 4

    I did also just reboot the servers, since we'd had like a bajillion years of uptime since the machine was last restarted; I decided that "have you tried turning it off and on again" couldn't hurt. ;)
  6. Board Issues 4

    Yeah. I didn't have any idea the Mediawiki upgrade would basically dynamite everything, or else I would've raised and waved red flags like mad, as if there was a bridge out ahead. But it seemed a pretty straightforward upgrade, and the test version of it didn't seem to blow everything up, soooo.
  7. Board Issues 4

    To elaborate slightly: the upgrade to Mediawiki has thrown a bit of a spanner in the works for all the load-balancing magic; that upgrade required some changes to the version of PHP we were using, which required changes to the PHP bytecode cache, which introduced an issue with Invision's use of that PHP bytecode cache... follow the chain of dominos. The short form is that what happens right now is that when the load gets heavy, Invision seems to corrupt the PHP bytecode cache, which causes Mediawiki to start hitting things harder, which causes load to increase, which causes Invision to catch fire and run screaming off a cliff. If the caching is turned off, the corruption doesn't happen, but then the load sets the server on fire anyway. :P I'm working on finding some more magic glue to stick the hamsters to their wheels. I put something new in place this morning (Pacific time) and we'll see how it goes, and depending on that, I may tear down a bunch of things and rebuild tonight. Alternatively, as a last resort, since they no longer are required to be on the same server by their configuration, I may yank the Wiki and Invision installations onto separate physical servers, so that they aren't sharing a PHP bytecode cache and see if we can't solve the issue that way.
  8. search function

    FYI, just to follow up on Linda's post, there appear to have been two things that were going wrong since the season started. First, one of the switches that handles the private network between Skrog (the server that handles the web/PHP stuff) and Segfault (the server that handles the database) started to malfunction. That was replaced earlier by the colocation provider, but during that time the connection between Skrog's PHP handler and Segfault's MySQL instance was bogging down. Second, however, the most recent MediaWiki upgrade had a change in how it handled caching; I didn't realize that so didn't account for this during the upgrade—mea culpa—and that caused issues with all of the optimizations. It happened sporadically enough (but ruined everything when it did) that I wasn't able to diagnose it until the episode tonight, when it happened pretty reliably and I was able to see what was going wrong. A couple of hours ago (as of the time I post this), I tweaked how things are optimized; it seems to be running much better now. Ran and I are still keeping an eye on things to make sure everything's solid with the tweak, though. :)
  9. Board Issues 4

    (Okay, so locking the posts table as part of the snapshot shut down Invision a little harder than I expected for a little longer than I expected. Sorry!)
  10. Board Issues 4

    I should add, if you see a Server Internal Error, that just means Invision isn't happy with a table being locked temporarily. Give it a minute or two and come back. :)
  11. Board Issues 4

    FYI (since I know people are going to come here to post), server's going to be slow for the next hour or so while I do a comprehensive backup of various things. It's been too long since I took a full restorable snapshot (as opposed to just incremental backups), and I want to get that up-to-date. I decided to leave things up and running as much as possible to avoid taking things offline; everything should be readable at all times, though there might be a few sporadic spots where the database is locked to read-only for a couple of minutes. Just bear with me, and it'll be done before too long. :)
  12. Board Issues 4

    I've made some changes to the backend to hopefully alleviate a little stress. We'll see what happens; I'm stuck at work, so I'm keeping only half an eye on things, and it will probably take about 15 minutes-ish from this to settle down after the changes I made. We'll see if it improves anything.
  13. has been staring at the ceiling for hours. It is 5:20 in the morning. This is the third day running. I give up; I'm calling in an Ambien refill tomorrow.