User Tag List

Results 1 to 9 of 9

Thread: Database Errors - PLEASE READ

  1. #1
    Super Moderator 3000 posts, Grand Master SCAPER shawndoc's Avatar
    Member Since
    May 2011
    Location
    Santa Ana Canyon
    Posts
    3,874
    Post Thanks / Like
    Real Name
    Shawn
    Mentioned
    3 Post(s)
    Tagged
    0 Thread(s)

    Database Errors - PLEASE READ

    I've been getting a lot of database errors lately, tonight I've gotten it to pop up several times when doing a search.

  2. #2
    SCAPE Member SCAPEr CACrimson's Avatar
    Member Since
    Dec 2012
    Location
    Los Angeles
    Posts
    487
    Post Thanks / Like
    Real Name
    Joe
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    I emailed Chris about 20 minutes ago so I think he may be working on it.

  3. #3
    Admin Master SCAPER CGAR's Avatar
    Member Since
    Jul 2011
    Location
    Tashirojima
    Posts
    2,535
    Post Thanks / Like
    Real Name
    Chris
    Mentioned
    16 Post(s)
    Tagged
    0 Thread(s)
    ill take a look into it... may need to clean up, backup and repair tables.... expect schedule downtime this friday thanks

  4. Thanks adin thanked for this post
  5. #4
    Admin Master SCAPER CGAR's Avatar
    Member Since
    Jul 2011
    Location
    Tashirojima
    Posts
    2,535
    Post Thanks / Like
    Real Name
    Chris
    Mentioned
    16 Post(s)
    Tagged
    0 Thread(s)
    I forgot about this and will be scheduled on Tuesday at 12AM. Forums will be down and I will send out notice.

  6. Likes CACrimson, sayurasem liked this post
  7. #5
    Admin Master SCAPER CGAR's Avatar
    Member Since
    Jul 2011
    Location
    Tashirojima
    Posts
    2,535
    Post Thanks / Like
    Real Name
    Chris
    Mentioned
    16 Post(s)
    Tagged
    0 Thread(s)
    so these errors continue to go on after doing backups, updates, table optimizations and repairs. The database (MySQL) crashed according to the logs (the errors telling me that vBulletin cannot connect to our database) and vbulletin's documents suggest to contact the hosting provider since it's possible that it's a problem on their end. I've contacted them few minutes ago and the support rep sounded like he doesn't know what the cause is only giving me the current status of the database. The database errors happens frequently in the early morning hours and the server would self-heal/restart itself back to normal. I assume it could be limited connections allowed to the database. I'll be contacting our provider again later today and get better answers from them. Will keep you all updated.

  8. Thanks adin thanked for this post
  9. #6
    Admin Master SCAPER CGAR's Avatar
    Member Since
    Jul 2011
    Location
    Tashirojima
    Posts
    2,535
    Post Thanks / Like
    Real Name
    Chris
    Mentioned
    16 Post(s)
    Tagged
    0 Thread(s)
    just got a reply from them and they are transferring our server:

    'We are pleased to inform you that we have started the migration process for your shared account **** on ****. At this time we are transferring all data from your current shared server onto brand new hardware. Once the migration has completed, we will send another update that contains new IP addresses and information on any DNS changes that will need to be made. We will also be forwarding all traffic from your old account to the new server. This will allow you to immediately view your website on the new hardware."

    hopefully this solves most of the MySQL disconnects.

  10. #7
    SCAPE Member SCAPEr CACrimson's Avatar
    Member Since
    Dec 2012
    Location
    Los Angeles
    Posts
    487
    Post Thanks / Like
    Real Name
    Joe
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Just got a database error message =)

  11. #8
    Admin Master SCAPER CGAR's Avatar
    Member Since
    Jul 2011
    Location
    Tashirojima
    Posts
    2,535
    Post Thanks / Like
    Real Name
    Chris
    Mentioned
    16 Post(s)
    Tagged
    0 Thread(s)
    Quote Originally Posted by CACrimson View Post
    Just got a database error message =)
    I found the solutions to these problems most commonly:

    "MySQL Error : Got error -1 from storage engine"
    "MySQL Error : Got error 28 from storage engine"

    but unfortunately, we are on a 'Shared Hosting' server. I do not have access to the MYSQL my.cnf or it's config files to make changes.Only way is to upgrade to a dedicated server to fix these problems (which costs us more).

    According to reply message from our host's support: "I apologize for any confusion. Unfortunately, you are unable to change these values in our shared hosting environment as you need access to the My.CNF file, which is only available on our Virtual Dedicated or Dedicated servers."

    For now we will have to tolerate these database errors until i bring this up on our next board meeting in upgrading to a dedicated server or til our funds/budget allows. As mentioned before, these errors go away after second attempt since server self-heals/restarts itself.

  12. #9
    Admin Master SCAPER CGAR's Avatar
    Member Since
    Jul 2011
    Location
    Tashirojima
    Posts
    2,535
    Post Thanks / Like
    Real Name
    Chris
    Mentioned
    16 Post(s)
    Tagged
    0 Thread(s)
    made this thread sticky for everyone to be aware.

Posting Permissions

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