SQL Error on MacRumors

Discussion in 'Site and Forum Feedback' started by wrldwzrd89, Aug 11, 2004.

  1. macrumors G4

    wrldwzrd89

    Joined:
    Jun 6, 2003
    Location:
    Solon, OH
    #1
    I'm getting this error when I try to access MacRumors:
    Warning: mysql_connect(): Host '192.168.1.4' is blocked because of many connection errors. Unblock with 'mysqladmin flush-hosts' in /home/macrumor/public_html/csspvt/cssdbinit.inc on line 8
    Unable to connect to database
     
  2. macrumors 6502

    Joined:
    Jul 16, 2004
    Location:
    Milwaukee, WI
  3. macrumors 65816

    telecomm

    Joined:
    Nov 30, 2003
    Location:
    Rome
  4. macrumors G5

    Sun Baked

    Joined:
    May 19, 2002
    #4
    Yep, look's like we may have to prepare for another extended downtime day as arn does some extended cleanup.
     
  5. jsw
    Moderator emeritus

    jsw

    Joined:
    Mar 16, 2004
    Location:
    Andover, MA
    #5
    I'd though I'd read that www.macrumors.com and forums.macrumors.com were hosted by different machines, yet both seem to be going down almost in sync nowadays. Are they on the same server, or different ones?
     
  6. macrumors 68000

    Littleodie914

    Joined:
    Jun 9, 2004
    Location:
    Rochester, NY
    #6
    Weird...

    I'm having this problem too, but only when accessing Macrumors.com... The forum is working just fine. I also get the same thing when attempting to access macbytes.com links... (even the ones that don't link to macrumors)
     
  7. macrumors 6502a

    Converted2Truth

    Joined:
    Feb 6, 2004
    Location:
    Hell@HighAltitude
    #7
    They should use XServes to host this stuff. Then we wouldn't have these issues... maybe...
     
  8. macrumors member

    Joined:
    Jun 30, 2004
    Location:
    New York
    #8
    same here

    im getting the same message when i try to connect to macrumors but any of the other parts , forums and stuff works

    i also cannot acsess macbytes
     
  9. macrumors G3

    Chip NoVaMac

    Joined:
    Dec 25, 2003
    Location:
    Northern Virginia
  10. macrumors 65816

    Elan0204

    Joined:
    Apr 16, 2002
    Location:
    Chicago, IL
    #10
    Yeah the forum is working for me right now, but the main page won't load. I get the same error as wrldwzrd89.
    I actually got this same error a few days ago too.
     
  11. Moderator emeritus

    edesignuk

    Joined:
    Mar 25, 2002
    Location:
    London, England
    #11
    Wouldn't make a blind bit of difference :rolleyes:
     
  12. macrumors regular

    Joined:
    May 19, 2003
    Location:
    Australia
    #12
    True. It looks like the PHP scripting they are using is not flushing old users or is not managing the SQL correctly, or something like that.
     
  13. macrumors regular

    Joined:
    Jul 20, 2004
    Location:
    MN / IN
    #13
    Yeah, it is kind of a dumb problem. The error message seems to come up at seemingly random times of the day - gets really annoying.
     
  14. Moderator emeritus

    edesignuk

    Joined:
    Mar 25, 2002
    Location:
    London, England
    #14
    Maybe it's time to trim MR of all it's non-active members...
     
  15. Administrator

    Doctor Q

    Staff Member

    Joined:
    Sep 19, 2002
    Location:
    Kepler-452b
    #15
    I suspect that's not the problem. Now if we trimmed MR of all active members, that would definitely help performance!
     
  16. macrumors 68000

    Joined:
    Jun 13, 2004
    Location:
    afk
    #16
    Guess its time for MR to upgrade to oracle and start charging each member $10 per month....just joking.
     
  17. Moderator emeritus

    edesignuk

    Joined:
    Mar 25, 2002
    Location:
    London, England
    #17
    It would help tidy things up a fair bit though wouldn't it?
     
  18. thread starter macrumors G4

    wrldwzrd89

    Joined:
    Jun 6, 2003
    Location:
    Solon, OH
    #18
    EDIT: Scratch that - it's back again. It was gone yesterday, but it appears to have come back.
     
  19. Moderator

    Nermal

    Staff Member

    Joined:
    Dec 7, 2002
    Location:
    Whakatane, New Zealand
    #19
    As of right now, it's not working. And I agree with edesign, it'd be great to trim out all those non-users. I mean, come on, we have 11028 members with a post count of zero :eek:
     
  20. macrumors 65816

    kettle

    Joined:
    May 12, 2002
    Location:
    England, Great Britain (Airstrip One)
    #20
    It was like it at 07:30 this morning (BST uk)

    People in the so say know on IRC don't seem to give a monkey's about it either.

    Where is Arn lately?
     
  21. Administrator

    Knox

    Staff Member

    Joined:
    Jul 1, 2002
    Location:
    UK
    #21
    If the number of users was a problem the forums would die as well as the main site. The number of registered users doesn't affect vbulletin much, within reason obviously. Without knowing the setup exactly (ie what 192.168.1.4 is) it's difficult to say, but my first suspicion would be the connection between the web server and the db server.
     
  22. macrumors 68000

    Joined:
    Jun 13, 2004
    Location:
    afk
    #22
    I agreed with Doctor Q that the inactive members are not really the problem. I'm guessing the site is overloaded with too many site visitors and causes too many connections for MySQL to handle. Most probably they could do some form of load balancing.
     
  23. Moderator

    Nermal

    Staff Member

    Joined:
    Dec 7, 2002
    Location:
    Whakatane, New Zealand
    #23
    I mean I agree in the sense that it'll be good to clean up. I know that it won't help with the database problem.
     
  24. macrumors 65816

    kettle

    Joined:
    May 12, 2002
    Location:
    England, Great Britain (Airstrip One)
    #24
    wow, someone found a finger and pulled it out. :rolleyes:
     
  25. macrumors regular

    Joined:
    May 10, 2004
    Location:
    UK
    #25
    It still happens in Safari (but not IE) if I click on a Forum link from the MR front page then click the back button. Clicking Refresh will load the page though.
     

Share This Page