Results 1 to 5 of 5

Thread: Outages 2018-02-23 and 2018-02-24

  1. #1
    CVR Webmaster / Director Emeritus whodah's Avatar
    Join Date
    Feb 2004
    Location
    clovis, ca, usa, earth!
    Posts
    7,143
    First Name
    Jeremy
    Occupation
    Computer Guy
    Referred to CVR by
    I am the Co-founder of CVR :D

    Outages 2018-02-23 and 2018-02-24

    Hi all,

    We made the server move, but one of the settings keeps resetting. I'm working with tech support to figure out why this is.

    Geeky notes:
    Granting privileges for our database user to our main database keeps disappearing. I set the privileges, and they're gone in 20 minutes to a couple of hours later. I've only got limited access to the server now as it is a shared host vs. our old VPS. (read: no root access) Thus, I have to involve our host's support vs. self diagnosis.
    -Who Dah?


    ------------------------------
    if you value your couch, don't invite tacocat over.

    Tank(s): Couple o' frag tanks.
    Lights: Mostly 14K Phoenix w/ T5 supplements.
    Experience: Since ~2003

  2. #2
    CVR Webmaster / Director Emeritus whodah's Avatar
    Join Date
    Feb 2004
    Location
    clovis, ca, usa, earth!
    Posts
    7,143
    First Name
    Jeremy
    Occupation
    Computer Guy
    Referred to CVR by
    I am the Co-founder of CVR :D
    OK - we figured out what was going wrong. Our database is too large. It was over 2.2GB and our new host has a limit of 25 x 1GB databases. I did some cleaning and got us down to about 1.6GB... But the only way to get it under 1GB quickly was to disable searching. So we are back up and running, hopefully it won't shut down again, but search is disabled temporarily until I can find a new solution. Actually, not so much disabled so much as won't return results.

    I'll continue working on it this week.
    -Who Dah?


    ------------------------------
    if you value your couch, don't invite tacocat over.

    Tank(s): Couple o' frag tanks.
    Lights: Mostly 14K Phoenix w/ T5 supplements.
    Experience: Since ~2003

  3. #3
    CVR Webmaster / Director Emeritus whodah's Avatar
    Join Date
    Feb 2004
    Location
    clovis, ca, usa, earth!
    Posts
    7,143
    First Name
    Jeremy
    Occupation
    Computer Guy
    Referred to CVR by
    I am the Co-founder of CVR :D
    OK all, the new site should now be stable on the new server. I was able to split off some old database tables into their own database, delete a ton of spam that apparently was generated un-noticed back in 2012-2013, rebuild the search index tables, and we are now in compliance w/ the host. So search should work and the site should be stable. Let me know if you have problems!

    Name:  done.gif
Views: 70
Size:  4.3 KB
    -Who Dah?


    ------------------------------
    if you value your couch, don't invite tacocat over.

    Tank(s): Couple o' frag tanks.
    Lights: Mostly 14K Phoenix w/ T5 supplements.
    Experience: Since ~2003

  4. #4
    Administrator
    Join Date
    Dec 2013
    Location
    Fresno, CA
    Posts
    152
    First Name
    Sonny
    Occupation
    Software Developer
    Referred to CVR by
    Xaiz0r
    Awesome Job Jeremy!

  5. #5
    Full Colony Member wonrib00's Avatar
    Join Date
    Aug 2004
    Location
    Salinas, CA
    Posts
    6,108
    First Name
    Nathan
    Occupation
    RN
    Referred to CVR by
    Weatherson

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. New Host - 2018
    By whodah in forum Central Valley Reefers News and Announcements
    Replies: 5
    Last Post: 02-24-2018, 12:38 PM
  2. 2018
    By eznet2u in forum The Lounge
    Replies: 0
    Last Post: 12-31-2017, 07:51 PM
  3. doing server maintenance - intermittent outages
    By whodah in forum Site Update and Feedback
    Replies: 1
    Last Post: 01-15-2007, 02:54 PM
  4. ice cap ballast and power outages
    By purplexfiles in forum Tank Trouble
    Replies: 3
    Last Post: 07-24-2006, 10:16 PM
  5. Power outages are loads of fun...
    By Reefmiester in forum General Discussion
    Replies: 4
    Last Post: 10-25-2005, 01:33 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •