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

Fixed Random errorr when click to ip link in posts

Discussion in 'Resolved Bug Reports' started by Umit, Feb 27, 2011.

  1. Umit

    Umit Active Member

    I get this error randomly when i clicked to ip link in posts;
    sometimes happening and sometimes not.
     
  2. Dodgeboard

    Dodgeboard Well-Known Member

    What host are you using? Shared plan?

    Unfortunately "MySQL server has gone away" errors are pretty much always a host/server issue.
     
  3. Vincent

    Vincent Well-Known Member

    Cannot reproduce in a 50 replies page :S
     
  4. Umit

    Umit Active Member

    It is happening to my posts and posts that are edited by me.
     
  5. Vincent

    Vincent Well-Known Member

    Wanna test if it is only a problem with you or also at my forum?
    If you feel like, register at my site (http://www.hlxbans.net/forum/) and post something random, I'll delete it later.
     
    Dodgeboard likes this.
  6. Dodgeboard

    Dodgeboard Well-Known Member

    What host are you using? Shared plan?
     
  7. Brogan

    Brogan XenForo Moderator Staff Member

    Vincent likes this.
  8. Dodgeboard

    Dodgeboard Well-Known Member

    I used to get this error 20-30 times a day when I was with Registerfly. Then I switched to Hostgator and the problem went away...mostly. Under vBulletin 4 it returned but only saw it two or three times a week. Now with Xenforo, I've never seen it. It's a hosting error mostly, but I have seen hung scripts cause the error as well. Log into your cpanel and see if there are any alerts.
     
  9. Umit

    Umit Active Member

    Possible chit-chat with server tech guys:
    Me: Hey guys, when i click on ip link in posts i am getting error msgs, wth?
    Server guy: go to your software provider :p

    Brogan, i doubt it is about php execution time. Because when i use this function it is working fast and i am seeing the results in a second with ajax window. But when i click on my posts (o posts that are edited by me) the ajax indicator is waiting and waiting (like 30secs) and then giving that error.
     
  10. Dodgeboard

    Dodgeboard Well-Known Member

    Tell them "Hey guys, I am losing connection with the SQL database with all kinds of "My SQL Hase Gone Away" errors. How many simultaneous connections does my account allow and is there anything you can do to "up" the timeouts so this does not occur?"
     
  11. Umit

    Umit Active Member

    This can tell something?
    and my PHP Version 5.2.6.
     
  12. Dodgeboard

    Dodgeboard Well-Known Member

    What host are you using? Shared plan?
     
  13. Umit

    Umit Active Member

    VPS
     
  14. Dodgeboard

    Dodgeboard Well-Known Member

    Ouch!

    I'd definitely complain to your host.
     
  15. Umit

    Umit Active Member

    OK, what should i ask them? Increasing the php exec limit looks to me a quick/dirty fix (correct me if i am wrong). Should i ask them to upgrade my php and mysql?
     
  16. Dodgeboard

    Dodgeboard Well-Known Member

    Just tell them you are getting a lot of "MySQL has gone away" errors and let them figure out where the problem is.
     
    Umit likes this.
  17. Brogan

    Brogan XenForo Moderator Staff Member

    It shouldn't really be happening on a VPS, so it could be indicative of a server configuration issue.

    As Dodgeboard said, get your host to investigate.
     
    Umit likes this.
  18. Mike

    Mike XenForo Developer Staff Member

    Is there a long delay before you get that? This would indicate that your MySQL's wait_timeout value is very low, and it's timing out because the IP lookup is taking too long. This lookup shouldn't take that long, though there are 2 approaches depending on server specs. Wait_timeout defaults to 86400, which is actually 1 day (which is far too long really, but if it's set to something like 3 or 5, that's too low).

    Your best bet may be to ask your host to help. If you have root access (which you should with a VPS), you can change the value via /etc/my.cnf -- but something must've changed it down already.
     
    Umit likes this.
  19. Brogan

    Brogan XenForo Moderator Staff Member

    I've just tried checking the author's IP address here on this thread and I'm getting server timeout error.
    So it would seem to be a problem with his IP address.

    error.PNG
     
    Dodgeboard and Umit like this.
  20. Umit

    Umit Active Member

    What can be the problem? [​IMG]
    i tried to run nslookup command in my ubuntu netbook and it returned me an error too, my IP cant lookup my ip [​IMG]
     

Share This Page