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

Help: Database errors

Discussion in 'Troubleshooting and Problems' started by 3rd AnGle, Nov 28, 2011.

  1. 3rd AnGle

    3rd AnGle Well-Known Member

    I have been experiencing databse errors frequently since the last one month. I thought this was an issue with my hoster so i have been nagging them to fix it but all their fixes seems to be temporary. Now the crash happens every alternate days.
    Hostgator have repaired the database like 10 times but it keeps crashing every alternate days.

    The following is one such error (my ste is running but whenever i try to post something or upload something.. this is what i get)

    Sometimes the error mentions EWRPorta too... I am just wondering whether the error is due to the scripts i am running or is it on the part of my server..

    Plz advise.
     
  2. Brogan

    Brogan XenForo Moderator Staff Member

    It's likely a server problem.

    Try rebuilding the search index in the ACP though to renew the table contents anyway.
     
  3. 3rd AnGle

    3rd AnGle Well-Known Member

    Thanks Brogan for replying..

    I tried to rebuild the search index and the same error gets thrown up. :(
     
  4. Brogan

    Brogan XenForo Moderator Staff Member

    Did you repair the table first?
     
  5. 3rd AnGle

    3rd AnGle Well-Known Member

    eh.. nope :oops: don't know how to..
     
  6. Brogan

    Brogan XenForo Moderator Staff Member

    If you use cPanel, click on MySQL Databases, then click Repair DB next to the one you wish to repair.
     
    hterrag likes this.
  7. 3rd AnGle

    3rd AnGle Well-Known Member

    Oh thanks Brogan... that did it.

    Can't believe Hostgator took more than 6 hrs and still they didn't assign anyone because they had high number of tickets to attend ::mad:
     
  8. Hunter Shenep

    Hunter Shenep Member

    I had the similiar problem, and this fixed it! Thank you!
    [​IMG]
     
  9. Tarynjh

    Tarynjh Member

    okay, I'm having this issue, frequently - like every other hour and it just started happening today. I truncated the table, but it only seems to solve the problem temporarily. When I attempted to repair the table, it came up with an error:
    UGH.png
     
  10. Mike

    Mike XenForo Developer Staff Member

    If this is happening with any frequency -- and I probably mean more than once per, I don't know, year? -- you need to contact your host. Table corruption generally indicates a server issue (including a full disk) or someone is shutting down MySQL incorrectly.

    If they can't resolve the issue, I'd have to recommend another host.
     
    The Forum Heroes and Webby like this.
  11. Tarynjh

    Tarynjh Member

    It's seemed to have resolved itself since last night, after I contacted my host. It was really starting to get annoying, though.

    Thanks for the response :)
     
  12. Webby

    Webby Member

    I have been experiencing this issue for weeks. My host arvixe has not done anything to repair the issue. If I try to repair it myself it only works for a few minutes or posts then it gets messed up again.
     
  13. Brogan

    Brogan XenForo Moderator Staff Member

    As posted above, you should consider switching hosts if your current host is unwilling or unable to resolve it.
     
    The Forum Heroes and Webby like this.
  14. Webby

    Webby Member

    Could that mean that I have filled the gigabytes they allocated for me? I have some big image files on our site.
     
  15. Tracy Perry

    Tracy Perry Well-Known Member

    Shouldn't if you are on shared... now if you are on a VPS that uses it's own file space (which it sounds like) then yes, if you have filled up the space you need to get more.
     
    Webby likes this.
  16. Webby

    Webby Member

    I don't have a backup of when the forum last worked correctly. If I move to a new host with my corrupted database is it repairable by following the steps in this thread or do they have to fix it? How would they do that?
     
  17. Jake B.

    Jake B. Well-Known Member

    From what it looks like it's only the xf_session, so even if it isn't able to be repaired it shouldn't be a huge deal to just recreate the table. Users will be logged out, but no posts/threads/users will be lost
     
    Webby likes this.

Share This Page