Page 1 of 2 12 LastLast
Results 1 to 10 of 11
  1. #1
    Moo! Are you happy now? Arjan's Avatar
    Join Date
    Oct 2001
    Location
    Woerden, Netherlands
    Posts
    10,307
    Downloads
    39
    Uploads
    1

    Database problems

    As you probably have noticed over the last few day BRnet was unreachable.
    Actually itwas giving database errors when requesting the site.
    It seems the database got corrupted, and mainly the wiki tables.

    Flip is doing what he can to fix things and restore everything. Until then we wont have a wiki.
    At least the forum is back.

    cheers
    Arjan
    Te audire non possum. Musa sapientum fixa est in aure.

  2. #2
    Administrator Arius Vistoon's Avatar
    Join Date
    Jan 2002
    Location
    Paris ( france )
    Posts
    291
    Downloads
    268
    Uploads
    1
    hi,

    Do you need some help ?

  3. #3
    Member SirRobin's Avatar
    Join Date
    May 2009
    Location
    Counciltucky
    Posts
    35
    Downloads
    9
    Uploads
    0
    Well this is the error I get when I try to enter the wiki.

    MediaWiki internal error.

    ..snip
    Last edited by Arjan; 05-13-2009 at 10:02 PM.
    Sir Robin the Not-quite-so-brave-as-Sir-Lancelot,
    who had nearly fought the Dragon of Agnor,
    who had nearly stood up to the vicious Chicken of Bristol,
    and who had personally wet himself at the Battle of Badon Hill.

  4. #4
    Moo! Are you happy now? Arjan's Avatar
    Join Date
    Oct 2001
    Location
    Woerden, Netherlands
    Posts
    10,307
    Downloads
    39
    Uploads
    1
    thnx arius
    dunno if you can help with corrupted database files

    this is what flip wrote:

    There was a bit of a disk issue that ended up with mysql "spin" crashing - it would start up, then crash just about immediately. *Some* requests would get through, but, hit a certain table, and the db crashes. Starts up almost immediately, but the corruptions can cascade ...

    I didn't know that was happening for a long while, so a bunch of tables, all across the board, got corrupted. Most were in a format I could recover with. The wiki tables are proving a lot more problemeatic.
    Te audire non possum. Musa sapientum fixa est in aure.

  5. #5
    Moo! Are you happy now? Arjan's Avatar
    Join Date
    Oct 2001
    Location
    Woerden, Netherlands
    Posts
    10,307
    Downloads
    39
    Uploads
    1
    Quote Originally Posted by SirRobin View Post
    Well this is the error I get when I try to enter the wiki.
    yes, there are no database tables at the moment... hopefully they can be restored
    Te audire non possum. Musa sapientum fixa est in aure.

  6. #6
    Quote Originally Posted by Arjan View Post
    There was a bit of a disk issue that ended up with mysql "spin" crashing - it would start up, then crash just about immediately. *Some* requests would get through, but, hit a certain table, and the db crashes. Starts up almost immediately, but the corruptions can cascade ...
    Ok, ok, so I'm perhaps not as much an expert as your "flip", but you need to do a mysql "REPAIR TABLE" - not sure if you have access to the DB, but if you open a mysql query browser, just run "REPAIR TABLE XXXXX", where XXX is the table name. I'm not sure what wiki software you use, but again, if you have DB access, you should use the mysql admin to find out what table is crashed and repair it; it can't be more than 1 or 2 tables... and a REPAIR TABLE should really do it; email your flip's info or any help I can give to charles@stockphotopro.com for help... (I need to get some stuff from the Wiki on abilities, I've come to rely on it!)

  7. #7
    Ok, so looks like you are using "mediawiki" and you have a missing table called arjan.wiki_page

    1. It's looking for that table on localhost, do you have the correct user/pass to connect to localhost?
    2. Can you try to connect to it to see it it's there at all, or is it really missing (can't be good - hopefully you have a backup, but i rarely do)
    => obviously it's not a crashed table (you'd get another error message), so I sure wish it's just a connection issue.

  8. #8
    Moo! Are you happy now? Arjan's Avatar
    Join Date
    Oct 2001
    Location
    Woerden, Netherlands
    Posts
    10,307
    Downloads
    39
    Uploads
    1
    Quote Originally Posted by cyrano24100 View Post
    Ok, so looks like you are using "mediawiki" and you have a missing table called arjan.wiki_page

    1. It's looking for that table on localhost, do you have the correct user/pass to connect to localhost?
    2. Can you try to connect to it to see it it's there at all, or is it really missing (can't be good - hopefully you have a backup, but i rarely do)
    => obviously it's not a crashed table (you'd get another error message), so I sure wish it's just a connection issue.
    ok, ill try to explain again.

    the database files got corrupted, and flip was only able to restore the vb3_ tables, which are the forum tables.

    most of the wiki_ tables got severely dammaged, so those arent restored.
    So thats why they are missing... and thus the reason you get the current error messages.
    Te audire non possum. Musa sapientum fixa est in aure.

  9. #9
    Site Moderator Sorontar's Avatar
    Join Date
    Jul 2002
    Location
    Melbourne, Australia
    Posts
    3,942
    Downloads
    23
    Uploads
    1
    Well at least the forum<->mailing list relationship has been maintained. I imagine the mailing list is always a fallback plan if br.net has too many problems. It can also be thought of as a pseudo-backup for the general forum. Unfortunately, it doesn't help with the wiki.

    Thanks Flip, Arjan and others for what you do behind the scenes to keep br.net running, even when it doesn't have disasters.

    Sorontar

  10. #10
    Senior Member
    Join Date
    Apr 2002
    Location
    BR mailing list
    Posts
    1,562
    Downloads
    0
    Uploads
    0
    At 01:42 AM 5/13/2009, Arjan wrote:

    >As you probably have noticed over the last few day BRnet was unreachable.
    >Actually itwas giving database errors when requesting the site.
    >It seems the database got corrupted, and mainly the wiki tables.
    >
    >Flip is doing what he can to fix things and restore everything.
    >Until then we wont have a wiki.
    >At least the forum is back.

    Thanks for the head`s up, for your efforts and a proxy thanks to Flip
    for his work.

    Gary

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Piazza problems
    By Sorontar in forum Birthright.net support
    Replies: 1
    Last Post: 08-14-2008, 07:53 PM
  2. BRCS Database
    By ploesch in forum BRCS 3.0/3.5 Edition
    Replies: 3
    Last Post: 09-14-2006, 07:01 PM
  3. BRCS domain tracking database
    By ausrick in forum The Royal Library
    Replies: 13
    Last Post: 07-18-2006, 05:28 PM
  4. Database errors?
    By Salamander in forum Birthright.net support
    Replies: 4
    Last Post: 12-29-2002, 03:00 AM
  5. Replies: 7
    Last Post: 12-04-2001, 05:27 AM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
BIRTHRIGHT, DUNGEONS & DRAGONS, D&D, the BIRTHRIGHT logo, and the D&D logo are trademarks owned by Wizards of the Coast, Inc., a subsidiary of Hasbro, Inc., and are used by permission. ©2002-2010 Wizards of the Coast, Inc.