Quantcast

  1. Welcome to Bantam Talk

    Why not register for an account?

    Not only can you then get fully involved in the community but you also get fewer ads

  2. Premium Membership now Available


    Please see this thread for more details

    Dismiss Notice
Welcome to Bantam Talk Premium Membership now Available

SQL error

Discussion in 'Helpdesk' started by Storck, Jan 4, 2020.

Page 1 of 2
  1. Storck

    Storck Regular Starter

    Joined:
    Apr 8, 2018
    Messages:
    38,975
    Likes Received:
    29,644
    Keep getting one of these errors 8EFDC0E7-FFC1-4852-AC1F-DDE94239B003.png 0733ECB3-AEA9-4905-BFE9-B5B4D662D06F.png 56FA0912-A5B4-420D-A642-E0AB7D26D5EC.png
     
    #1 Storck, Jan 4, 2020
    Bronco likes this.
  2. SimonW

    SimonW
    Staff Member Admin Moderator P.L.24/25 Entrant Qatar 2022 Entrant

    Joined:
    Apr 8, 2018
    Messages:
    6,646
    Likes Received:
    4,467
    Yeah we had a spike in disk activity which then caused a cpu bottleneck, trying to work out what caused it but it seems to have dipped again now
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
    #2 SimonW, Jan 4, 2020
    Storck likes this.
  3. NorthernMonkey

    NorthernMonkey
    Supporter

    Joined:
    Apr 10, 2018
    Messages:
    11,146
    Likes Received:
    22,211
    Clear. Your. Cache
     
    #3 NorthernMonkey, Jan 4, 2020
    Hoochy-Min and Storck like this.
  4. Storck

    Storck Regular Starter

    Joined:
    Apr 8, 2018
    Messages:
    38,975
    Likes Received:
    29,644
    you finally learnt then
     
    #4 Storck, Jan 4, 2020
  5. NorthernMonkey

    NorthernMonkey
    Supporter

    Joined:
    Apr 10, 2018
    Messages:
    11,146
    Likes Received:
    22,211
    It never happens to me, I don't look at that mucky stuff you lot keep getting caught out with.
     
    #5 NorthernMonkey, Jan 4, 2020
    Hoochy-Min and Storck like this.
  6. Hoochy-Min

    Hoochy-Min Squad Player

    Joined:
    Apr 9, 2018
    Messages:
    6,939
    Likes Received:
    11,720
    TimelyJealousHagfish-size_restricted.gif
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
    #6 Hoochy-Min, Jan 6, 2020
    Rogered Tart likes this.
  7. Campbell's soup

    Campbell's soup
    Supporter

    Joined:
    Apr 9, 2018
    Messages:
    8,319
    Likes Received:
    14,049
    E0EA10C9-A326-48EE-8996-11FCEFDD9993.gif
    Big ol’ chinny reckon.
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
    #7 Campbell's soup, Jan 7, 2020
    NorthernMonkey likes this.
  8. Storck

    Storck Regular Starter

    Joined:
    Apr 8, 2018
    Messages:
    38,975
    Likes Received:
    29,644
    Got it again today
     
    #8 Storck, Jan 11, 2020
  9. Storck

    Storck Regular Starter

    Joined:
    Apr 8, 2018
    Messages:
    38,975
    Likes Received:
    29,644
    4531DF93-F8FB-4B05-BE88-518B09C83559.png
     
    #9 Storck, Jan 11, 2020
  10. Rcbantam

    Rcbantam
    Euro24 PL Entrant P.L.24/25 Entrant Supporter

    Joined:
    Apr 8, 2018
    Messages:
    2,603
    Likes Received:
    2,142
    Aye its crashed again today. Again. As BT has become a cash cow.. Its very poor service to be honest.

    Fans that have put money into this service should be p! Ssed off.

    Am not one.
     
    #10 Rcbantam, Jan 11, 2020
  11. bantam65

    bantam65
    P.L. 23/24 Top 10 P.L.24/25 Entrant Supporter

    Joined:
    Apr 8, 2018
    Messages:
    9,770
    Likes Received:
    12,344
    Did it crash because of being flooded by Swindon fans logging in to laugh at how shite we are?
     
    #11 bantam65, Jan 11, 2020
    Storck likes this.
  12. SimonW

    SimonW
    Staff Member Admin Moderator P.L.24/25 Entrant Qatar 2022 Entrant

    Joined:
    Apr 8, 2018
    Messages:
    6,646
    Likes Received:
    4,467
    The last couple of games we have got a sudden large influx of people on the site to a level where its hitting 100% CPU utilisation. Usually, at the most active, we don't hit more than 75%.

    Actually made some tweaks to make some of the processes more efficient after last week but today it was even worse (and was maxing out the RAM as well, that may be related to the CPU getting overloaded though)
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
    #12 SimonW, Jan 11, 2020
  13. SimonW

    SimonW
    Staff Member Admin Moderator P.L.24/25 Entrant Qatar 2022 Entrant

    Joined:
    Apr 8, 2018
    Messages:
    6,646
    Likes Received:
    4,467
    Lol might very well be. There was a sudden large influx of users (And I thought maybe it was the Chinese bots we had an influx of in November/December but I had banned all of China and there is no obvious influx of bots, they all seem like legit people)
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
    #13 SimonW, Jan 11, 2020
  14. Storck

    Storck Regular Starter

    Joined:
    Apr 8, 2018
    Messages:
    38,975
    Likes Received:
    29,644
    Might have to look at increasing the capacity then if it is happening every match. Imagine if we get to play offs or near end of season needing a win
     
    #14 Storck, Jan 11, 2020
  15. SimonW

    SimonW
    Staff Member Admin Moderator P.L.24/25 Entrant Qatar 2022 Entrant

    Joined:
    Apr 8, 2018
    Messages:
    6,646
    Likes Received:
    4,467
    So you expect us to be able to see the future and know a sudden unusual influx of visitors are about to happen. I have the server tools open during matches and actually catch many potential issues before any of you lot even aware but the CPU in the space of 10 seconds went from 62% to 100%
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
    #15 SimonW, Jan 11, 2020
  16. SimonW

    SimonW
    Staff Member Admin Moderator P.L.24/25 Entrant Qatar 2022 Entrant

    Joined:
    Apr 8, 2018
    Messages:
    6,646
    Likes Received:
    4,467
    Already floated that to @king karl@king karl in email
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
    #16 SimonW, Jan 11, 2020
    Storck likes this.
  17. SimonW

    SimonW
    Staff Member Admin Moderator P.L.24/25 Entrant Qatar 2022 Entrant

    Joined:
    Apr 8, 2018
    Messages:
    6,646
    Likes Received:
    4,467
    Going to wait until after the match as the site may go down for a bit but we are going to bump the CPU resources up. Hopefully, that will also solve the RAM usage
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
    #17 SimonW, Jan 11, 2020
    Storck likes this.
  18. Storck

    Storck Regular Starter

    Joined:
    Apr 8, 2018
    Messages:
    38,975
    Likes Received:
    29,644
    Out of interest, if you can, roughly how many were on?
     
    #18 Storck, Jan 11, 2020
  19. king karl

    king karl
    Staff Member Admin Moderator Supporter

    Joined:
    Apr 8, 2018
    Messages:
    3,462
    Likes Received:
    5,571
    Around 300
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
    #19 king karl, Jan 11, 2020
  20. Rcbantam

    Rcbantam
    Euro24 PL Entrant P.L.24/25 Entrant Supporter

    Joined:
    Apr 8, 2018
    Messages:
    2,603
    Likes Received:
    2,142
    Its not like city only have 100 fans.. Our fan base is in the 10s of thousands.. God for bid city having a cup run.
     
    #20 Rcbantam, Jan 11, 2020
(You must log in or sign up to post here.)
Page 1 of 2

Share This Page

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Accept Learn More...
    Dismiss Notice