Pre Migration Most liked posts in thread: Something Weird's Going On....

  1. Ernesto

    Ernesto Club Coordinator

    May 16, 2009
    642
    652
    93
    Oracle DBA
    Skokie Ill
    Ratings:
    +837 / 0 / -0
    Me too a little bit ago, but after I closed the browser and went back the same thread was OK..
     
  2. Nathan

    Nathan Founder

    Mar 30, 2009
    25,144
    10,052
    113
    Writer
    Short North
    Ratings:
    +10,069 / 0 / -0
    Yeah, I've been getting error messages that the max_user_connections to the MySQL database has been maxed out. I've already upped the number of persistent connections allowed and that has not solved the issue. I have a ticket in with the hosting company to try and determine what is causing these all of the sudden.

    My thoughts are that there is a rogue process hitting the database and not letting go as soon as possible. What I find odd is there have been no changes that would effect database calls added to the site since the reviews product was added.

    Thanks for the heads up on these as the error only tells me when and what process was effected, not a lot to go on with this error message.
     
  3. Mr. Jim

    Mr. Jim Mudshark
    Lifetime Supporter

    May 22, 2010
    3,390
    1,213
    113
    North Carolina
    Ratings:
    +1,221 / 0 / -0
    Yep, same here and yesterday also, but i thought it was the computor I was on, as it was not mine. Like a stuck key or something.
     
  4. Nathan

    Nathan Founder

    Mar 30, 2009
    25,144
    10,052
    113
    Writer
    Short North
    Ratings:
    +10,069 / 0 / -0
    I'm going to shut the site down for about 10 minutes at most starting at 10AM CT to reindex, repair and optimize the database. See if that helps.
     
  5. Nathan

    Nathan Founder

    Mar 30, 2009
    25,144
    10,052
    113
    Writer
    Short North
    Ratings:
    +10,069 / 0 / -0
    Database tables have been repaired, optimized and reindexed.

    Hopefully that will fix the issue.
     
  6. am0eba

    am0eba New Member

    Dec 16, 2009
    158
    3
    0
    SoCal - LA County
    Ratings:
    +3 / 0 / -0
    Here's another symptom, and it's still here after your reset:

    The browser "back" button seems to be disabled on this site only. Firefox 3.6.10

    _Dave_
     
  7. Nathan

    Nathan Founder

    Mar 30, 2009
    25,144
    10,052
    113
    Writer
    Short North
    Ratings:
    +10,069 / 0 / -0
    Looks to be a FireFox only issue. Have tested in FF 3.6.11 and see the issue. Have also tested in Opera 11, Chrome 8.0.552.224 and the back button works fine in all cases.

    BTW, M/A is a lot faster in Chrome than in FF.
     
  8. Minidave

    Minidave Well-Known Member
    Lifetime Supporter

    Dec 22, 2009
    5,640
    4,594
    113
    Male
    Overland Park, Ks
    Ratings:
    +5,186 / 1 / -0
    Back Button works fine in IE too....

    Seemed to mess up for me when I hit the reply button, was still doing it a few minutes ago, but not in this reply.

    Appreciate your quick attention Nathan, what a difference from that other NAMeless site, where they respond sometimes within a year or two....
     
  9. goaljnky

    goaljnky New Member

    Apr 7, 2009
    3,105
    394
    0
    LaLaLand, Left Coast, Overpopulated and Underfunde
    Ratings:
    +394 / 0 / -0
    My back button works. Don't see any DB issues.
     
  10. Nathan

    Nathan Founder

    Mar 30, 2009
    25,144
    10,052
    113
    Writer
    Short North
    Ratings:
    +10,069 / 0 / -0
    The db issues are intermittent making it very hard to troubleshoot. After repairing, optimizing and reindexing the tables the issue persists.

    I had made a small change where I added a bit of Java script to the footer. In theory that should not be an issue as it calls another site. To be safe I've pulled that code and will keep monitoring the site to see if it fixes the issue.
     
  11. Crashton

    Crashton Club Coordinator

    Jun 4, 2009
    19,445
    10,057
    113
    Retired old fart
    Hooterville Ohio USA
    Ratings:
    +11,698 / 2 / -0
    No problems for me. It seems very appropriate that a Fiat thread broke something... :lol:
     
  12. minimark

    minimark Well-Known Member

    Jun 24, 2009
    5,146
    1,302
    113
    Winston-Salem, NC
    Ratings:
    +1,302 / 0 / -0
    ROFLMAO!
     
  13. Minidave

    Minidave Well-Known Member
    Lifetime Supporter

    Dec 22, 2009
    5,640
    4,594
    113
    Male
    Overland Park, Ks
    Ratings:
    +5,186 / 1 / -0
    Seems OK now to me too....
     
  14. am0eba

    am0eba New Member

    Dec 16, 2009
    158
    3
    0
    SoCal - LA County
    Ratings:
    +3 / 0 / -0
    For what it's worth, the "back" button is working now.

    _Dave_
     
  15. Nathan

    Nathan Founder

    Mar 30, 2009
    25,144
    10,052
    113
    Writer
    Short North
    Ratings:
    +10,069 / 0 / -0
    Well that bit of Java script is now in the trash heap. I've informed the developers of the problems it caused as well.

    In case you were curious it was a for a banner that was displayed in the footer where an advertiser could purchase the slot on a day to day basis. I know the developers and was helping them test the product. Oh well, so much for that product.

    Sorry to have caused issues on the site.
     
  16. Metalman

    Metalman Well-Known Member
    Lifetime Supporter

    Sep 29, 2009
    12,731
    7,688
    113
    Ex-Owner (Retired) of a custom metal fab company.
    Columbus, Ohio
    Ratings:
    +7,960 / 1 / -0
    Yeah Nathan.......
    I saw that today and thought to myself.......
    Has that been there all this time and I just didn't notice?

    Thinking I'm developing "Olds-hymers" disease.:D
     
  17. Minidave

    Minidave Well-Known Member
    Lifetime Supporter

    Dec 22, 2009
    5,640
    4,594
    113
    Male
    Overland Park, Ks
    Ratings:
    +5,186 / 1 / -0
    I must not get that far down the page, I never saw it! :D

    Anyway, looks like you found the culprit! Good job!

    When something weird crops up on a site I visit regularly, the first thing I think is that I must have gotten a bug somewhere, and since I'm on my work computer I worry that the PTB will take Interwebs access away, then I'll have to find something productive (for them) to do! :D
     
  18. Justa Jim

    Justa Jim Well-Known Member
    Lifetime Supporter

    May 6, 2009
    7,422
    1,685
    113
    Ratings:
    +1,685 / 0 / -0
    You're ahead of me MM, cause I did not even notice it.

    Nathan, when I tried to log on during the shut down, I liked the message saying the site was down for repairs. Nice touch. :Thumbsup:

    Jim
     
  19. Metalman

    Metalman Well-Known Member
    Lifetime Supporter

    Sep 29, 2009
    12,731
    7,688
    113
    Ex-Owner (Retired) of a custom metal fab company.
    Columbus, Ohio
    Ratings:
    +7,960 / 1 / -0
    I think it should say..... Down for "Mods":D
     
  20. Justa Jim

    Justa Jim Well-Known Member
    Lifetime Supporter

    May 6, 2009
    7,422
    1,685
    113
    Ratings:
    +1,685 / 0 / -0
    :Thumbsup:

    Jim