Page 1 of 3 123 LastLast
Results 1 to 10 of 21

Thread: Intermittent issues

  1. #1
    SEC Member Jeff's Avatar
    Join Date
    Sep 2011
    Location
    Framfield , East Sussex
    Posts
    695
    Rep Power
    10

    Intermittent issues

    Hi All,

    It seems that we're having some intermittent issues with the access to the database behind the website. For me this has presented itself as a screen showing a vBulletin error message. Looking into this as best I can (I'm in a field in Yorkshire at the moment) it seems that the database is being swamped with connections and is simply refusing additional connections above a certain number. This is, in itself, normal except that the number of connections at which this happens should be way above the normal number of connections which the database should be seeing at any single point in time.

    The fact that I can post this means that all is not lost (so no need to act like Corporal Jones just yet), I'll be home in the next few days and have a more detailed look into things.

    Regards,
    Jeff
    (Web thingie)
    Jeff

  2. #2
    SEC Member Stratos Fear's Avatar
    Join Date
    May 2014
    Location
    West Sussex
    Posts
    609
    Blog Entries
    52
    Rep Power
    12

    Re: Intermittent issues

    Hi Jeff (chief Web Thingie) - I havent experienced any issues so maybe not such a big problem ?

  3. #3
    SEC Member Jeff's Avatar
    Join Date
    Sep 2011
    Location
    Framfield , East Sussex
    Posts
    695
    Rep Power
    10

    Re: Intermittent issues

    Possibly not .. but still worth looking into.
    Jeff

  4. #4
    Super Moderator
    Join Date
    Sep 2016
    Location
    St Helens
    Posts
    830
    Rep Power
    12

    Re: Intermittent issues

    I tend to have a quick look to see who might be online whenever I log on, and there always seem to be a ton of "guests" - right now there are 10 members and 237 guests. OK, so some will be members who want a quick peek at something and can't be bothered logging in, but 237...??
    Not saying we should limit them - we've got nothing to hide (quick tidy up of incriminating evidence...) and hopefully some will become full members (and then we can spend their subs on beer). Be interesting to know what the figures are for max users vs. how many are on when the DB throws a wobbly.

    Oh, and, er, Hello, Guest-Type Peeps

  5. #5
    SEC Life Member The Slug's Avatar
    Join Date
    Sep 2011
    Location
    A hole in the ground
    Posts
    1,728
    Rep Power
    10

    Re: Intermittent issues

    Quote Originally Posted by Normb666 View Post
    Be interesting to know what the figures are for max users vs. how many are on when the DB throws a wobbly.
    The max we have had on is shown on the front page at the bottom and currently stands at:
    Most users ever online was 522, 02-02-2017 at 08:06.

    If you try to login as a guest you wont see much other than what your missing!!

  6. #6
    Super Moderator
    Join Date
    Sep 2016
    Location
    St Helens
    Posts
    830
    Rep Power
    12

    Re: Intermittent issues

    Ahhh, but then you either wouldn't be missing it cos you could see it, or you couldn't see it and wouldn't know anyway....sheesh, I really make my head hurt sometimes

  7. #7
    SEC Life Member The Slug's Avatar
    Join Date
    Sep 2011
    Location
    A hole in the ground
    Posts
    1,728
    Rep Power
    10

    Re: Intermittent issues

    You see the titles and the thread headers but some sneaky bugger hide the rest of the thread!!!

  8. #8
    SEC Member Jeff's Avatar
    Join Date
    Sep 2011
    Location
    Framfield , East Sussex
    Posts
    695
    Rep Power
    10

    Re: Intermittent issues

    Hi All,

    An advanced warning (though not that advanced)...

    I'm home and having looked into the database. It seems that we've only got 25 MBytes free space left before everything grinds to a halt. It's sort of that serious.

    The set up with the hosting providers limits the database to 1024 MBytes and we're pretty close to it already. This might be the root cause behind some of the issues that I see occasionally, it also may not be.

    Anyway .. I am aware of the situation and am looking into options. What ever happens there will probably need to be some down time in the next few days/weeks once I have a plan of how address this issue.

    PS: Now is the time to get Corporal Jones out..
    Jeff

  9. #9
    SEC Member Stratos Fear's Avatar
    Join Date
    May 2014
    Location
    West Sussex
    Posts
    609
    Blog Entries
    52
    Rep Power
    12

    Re: Intermittent issues

    oh dear ! I'll put my tin helmet on (Mr Mainwaring)

  10. #10
    Super Moderator
    Join Date
    Sep 2016
    Location
    St Helens
    Posts
    830
    Rep Power
    12

    Re: Intermittent issues

    Kinell, it's just like being back at work...as a SAN and Storage Array Administrator I get this from our DBAs all the time, "we're nearly out of space, can we have 500GB extra storage or the XYZ system will collapse". Unfortunately I can't help out here as I think it might be noticed if an unknown server suddenly appeared in one of the data centres and I asked one of the Installations guys to connect it to the SAN...

    A thought though, 1GB doesn't seem much for a database?? Hopefully extending it'll not cost too much!

    Good work tho Jeff, keep us all posted, or else "we're doomed!" (Scottish accent)

Similar Threads

  1. website and Microsoft Edge issues
    By Griff in forum Web site, suggestions, problems etc
    Replies: 7
    Last Post: 13-09-2018, 18:39
  2. Translator issues
    By The Slug in forum French
    Replies: 5
    Last Post: 04-07-2017, 07:30
  3. Website issues
    By The Slug in forum Web site, suggestions, problems etc
    Replies: 27
    Last Post: 23-06-2017, 21:20
  4. Quick rack issues for competition cars
    By ChrisCar6 in forum Suspension
    Replies: 0
    Last Post: 02-10-2015, 17:34
  5. Workshop issues
    By StruanR in forum Stratos Forum
    Replies: 8
    Last Post: 13-05-2015, 18:44

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •