SQL Error on MacRumors

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

  1. wrldwzrd89
    Expand Collapse
    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. mlw1235
    Expand Collapse
    macrumors 6502

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

    telecomm

    Joined:
    Nov 30, 2003
    Location:
    Rome
  4. Sun Baked
    Expand Collapse
    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
    Expand Collapse
    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. Littleodie914
    Expand Collapse
    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. Converted2Truth
    Expand Collapse
    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. lazymuoio
    Expand Collapse
    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. Chip NoVaMac
    Expand Collapse
    macrumors G3

    Chip NoVaMac

    Joined:
    Dec 25, 2003
    Location:
    Northern Virginia
  10. Elan0204
    Expand Collapse
    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. edesignuk
    Expand Collapse
    Moderator emeritus

    edesignuk

    Joined:
    Mar 25, 2002
    Location:
    London, England
    #11
    Wouldn't make a blind bit of difference :rolleyes:
     
  12. kjwebb
    Expand Collapse
    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. friarbayliff
    Expand Collapse
    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. edesignuk
    Expand Collapse
    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. Doctor Q
    Expand Collapse
    Administrator

    Doctor Q

    Staff Member

    Joined:
    Sep 19, 2002
    Location:
    Q Division, Los Angeles
    #15
    I suspect that's not the problem. Now if we trimmed MR of all active members, that would definitely help performance!
     
  16. angelneo
    Expand Collapse
    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. edesignuk
    Expand Collapse
    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. wrldwzrd89
    Expand Collapse
    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. Nermal
    Expand Collapse
    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. kettle
    Expand Collapse
    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. Knox
    Expand Collapse
    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. angelneo
    Expand Collapse
    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. Nermal
    Expand Collapse
    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. kettle
    Expand Collapse
    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. MemphisSoulStew
    Expand Collapse
    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