Author Topic: Encyclopedia down?  (Read 1214 times)

ZealKnight

  • Dimension Crosser (+1000)
  • *
  • Posts: 1067
  • Loyal Knight of the Kingdom of Zeal
    • View Profile
Encyclopedia down?
« on: August 25, 2009, 10:07:33 pm »
I just tried accessing it and it wont work.

Quote
A database query syntax error has occurred. This may indicate a bug in the software. The last attempted database query was:

    (SQL query hidden)

from within function "MediaWikiBagOStuff::_doquery". MySQL returned error "145: Table './ccuser_wiki/objectcache' is marked as crashed and should be repaired (localhost)".

Administrators know anything about this?

ZombieBucky

  • Springtime of Youth
  • Squaretable Knight (+400)
  • *
  • Posts: 409
  • <insert witty phrase to match above avatar>
    • View Profile
Re: Encyclopedia down?
« Reply #1 on: August 25, 2009, 10:24:03 pm »
theres more to it. i just saw a warning thing flash as it loaded up that error:
Quote
Warning: array_map() [function.array-map]: An error occurred while invoking the map callback in /home/ccuser/webapps/htdocs/wiki/includes/Title.php on line 1378
i received an error of a similar type earlier when trying to access the forums by logging in.

FaustWolf

  • Guru of Time Emeritus
  • Arbiter (+8000)
  • *
  • Posts: 8972
  • Fan Power Advocate
    • View Profile
Re: Encyclopedia down?
« Reply #2 on: August 25, 2009, 10:25:57 pm »
Good catch Zombie. Must be something with the Wiki software; it's being looked into.

Temporal Knight

  • Springtime of Youth
  • Acacia Deva (+500)
  • *
  • Posts: 526
  • Roar through the flames of time...
    • View Profile
Re: Encyclopedia down?
« Reply #3 on: August 26, 2009, 12:33:23 am »
I'm glad this was spotted. I haven't been using the Encyclopedia lately, but I usually refer to it every now and then for the Re-TO so I can refer to characters by persona and places by reference correctly.

GenesisOne

  • Bounty Seeker
  • Dimension Crosser (+1000)
  • *
  • Posts: 1215
  • "Time Travel? Possible? Don't make me laugh!"
    • View Profile
Re: Encyclopedia down?
« Reply #4 on: August 26, 2009, 12:38:12 am »

Huh... this never happened before. 

I don't know the cause of the problem, but let's hope it can be fixed in due time.

Ramsus

  • Entity
  • Chronopolitan (+300)
  • *
  • Posts: 313
    • View Profile
Re: Encyclopedia down?
« Reply #5 on: August 26, 2009, 01:38:43 am »
Fixed.

GenesisOne

  • Bounty Seeker
  • Dimension Crosser (+1000)
  • *
  • Posts: 1215
  • "Time Travel? Possible? Don't make me laugh!"
    • View Profile
Re: Encyclopedia down?
« Reply #6 on: August 26, 2009, 02:08:45 am »

Nice. Very nice.

So what was wrong with the coding?

Ramsus

  • Entity
  • Chronopolitan (+300)
  • *
  • Posts: 313
    • View Profile
Re: Encyclopedia down?
« Reply #7 on: August 26, 2009, 02:24:29 am »
Nothing. Just some random database corruption due to some server issues/maintenance on WebFaction's part, so I simply checked and repaired the MySQL table in question.

Temporal Knight

  • Springtime of Youth
  • Acacia Deva (+500)
  • *
  • Posts: 526
  • Roar through the flames of time...
    • View Profile
Re: Encyclopedia down?
« Reply #8 on: August 26, 2009, 12:07:49 pm »
*chuckles*

It is always those simple things that have us the most perplexed, eh?

Ramsus

  • Entity
  • Chronopolitan (+300)
  • *
  • Posts: 313
    • View Profile
Re: Encyclopedia down?
« Reply #9 on: August 26, 2009, 06:57:14 pm »
Actually, the error was pretty straightforward, and everything took less than a minute to fix as soon as the problem was brought to my attention.

It's not too perplexing either. The objectcache table is constantly being updated based on visits to different parts of the Encyclopedia, so if the mysql server is brought down (say, due to a power outage) in the middle of a query, that particular table is more likely to be corrupted, simply because only half of the transaction will have been processed.

Other members have reported some other errors that suggest the server we're on is having some hiccups (e.g. the backend httpd server that handles the main site crashed, so the proxying httpd server was giving 502 errors for a little while, and also our memcached process keeps getting reset, probably due to system restarts -- the current uptime on the server is only 14 hours).

ZealKnight

  • Dimension Crosser (+1000)
  • *
  • Posts: 1067
  • Loyal Knight of the Kingdom of Zeal
    • View Profile
Re: Encyclopedia down?
« Reply #10 on: August 26, 2009, 10:54:07 pm »
Thanks Ramsus! You're a genies!

FaustWolf

  • Guru of Time Emeritus
  • Arbiter (+8000)
  • *
  • Posts: 8972
  • Fan Power Advocate
    • View Profile
Re: Encyclopedia down?
« Reply #11 on: August 27, 2009, 02:26:17 am »
Quote
Thanks Ramsus! You're a genies!
Ramsus has more power than one genie, which is why it is perfectly apropos to call him a "genies."

ZombieBucky

  • Springtime of Youth
  • Squaretable Knight (+400)
  • *
  • Posts: 409
  • <insert witty phrase to match above avatar>
    • View Profile
Re: Encyclopedia down?
« Reply #12 on: August 27, 2009, 10:57:07 am »
so true.

browsing the forums in my usual manner i came across a thread. 'ooh schala sprites!' i cheered to myself, then started reading. after a while i got lost, and then i got this junk of garbage (see attachment).
wtf was with that? was it just me? or did that entire topic corrupt?

Ramsus

  • Entity
  • Chronopolitan (+300)
  • *
  • Posts: 313
    • View Profile
Re: Encyclopedia down?
« Reply #13 on: August 27, 2009, 05:18:03 pm »
Can you post a link to that specific topic?

ZombieBucky

  • Springtime of Youth
  • Squaretable Knight (+400)
  • *
  • Posts: 409
  • <insert witty phrase to match above avatar>
    • View Profile
Re: Encyclopedia down?
« Reply #14 on: August 27, 2009, 05:22:27 pm »
http://www.chronocompendium.com/Forums/index.php/topic,7660.msg176652/topicseen.html#new
this is the topic. im not just seeing it there, but every now and then i see it on other pages. main page most frequently.
there was another one in this very topic but it went away when i refreshed. perhaps its just me.