Database corruption

Discussion in 'Message Board Help & Notices' started by John Matthews, Mar 13, 2017.

  1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.
  1. John Matthews

    John Matthews Registered User

    Sep 22, 2015
    399
    3
    18
    Retired Systems Architect
    France
    Country Flag:
    Region Flag:
  2. Dick C

    Dick C Registered User

    Oct 14, 2009
    1,250
    4
    38
    Male
    Country Flag:
    I can open it with no problems, seeing your reply.
     
  3. gmorse

    gmorse Registered User
    NAWCC Member

    Jan 7, 2011
    7,183
    22
    38
    Male
    Retired from Xerox
    Breamore, Hampshire, UK
    Country Flag:
    Region Flag:
    Hi John,

    I agree, there is something odd happening, I just tried to post a reply to a thread by Dave Coatsworth and got a "database error".

    [Edit] However, this post is fine!

    Regards,

    Graham
     
  4. Markus Harris

    Markus Harris NAWCC Communications Director
    Staff Member NAWCC Member

    Feb 2, 2009
    1,146
    2
    38
    Male
    Director of Communications, NAWCC Inc.
    Lancaster, PA
    Country Flag:
    Region Flag:
    It appears that if a user opened a reply-to box on a thread immediately after the MB came back online (an hour ago), but before the MB server had completely loaded the back up database, that a glitch was created in the DB (but only for THAT user and THAT thread).

    Other users can still see and interact with that thread. Just not those who tried to respond to it during the reboot process.

    This may clear itself up, or those corrupted session settings may live on in the database until the next time the db gets recompiled.

    The corrupted entry in the DB is the "autosave" string. That's what is causing these errors.
     
  5. Bill Stuntz

    Bill Stuntz Technical Admin
    Staff Member Donor NAWCC Member

    Apr 6, 2012
    4,049
    3
    38
    Male
    PC Tech
    Columbus. OH
    Country Flag:
    Region Flag:
    The database is currently repairing itself after the 30+ hour outage. I got the same message when I tried to post a reply in another thread.
    With a little luck, things will be back to normal soon.
     
  6. John Matthews

    John Matthews Registered User

    Sep 22, 2015
    399
    3
    18
    Retired Systems Architect
    France
    Country Flag:
    Region Flag:
    Many thanks for the replies - if it will require a db compile to fix, what is the compile cycle. overnight, weekly?

    John
     
  7. Tom McIntyre

    Tom McIntyre Technical Admin
    Staff Member Donor Sponsor NAWCC Member

    Aug 24, 2000
    77,816
    396
    146
    Male
    retired SW dev
    Boston
    Country Flag:
    Region Flag:
    It is only necessary to rebuild the database after a crash when there was activity on the database when the hardware failed. The recovery will typically take about half an hour but this one seems to have run a bit longer.
     
Loading...
Similar Threads - Database corruption Forum Date
Database error Message Board Help & Notices Feb 19, 2015
Database Error Green Text Message Board Help & Notices Nov 6, 2014
Problem searching the Hamilton S/N Database Message Board Help & Notices Aug 15, 2014
Serial number Database Down ? Message Board Help & Notices Nov 24, 2013

Share This Page