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:
    40,322
    Likes Received:
    31,232
    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 World Cup 26 WC 2026 3rd Place ⚽ P.L.25/26 Entrant F1 2026 Entrant

    Joined:
    Apr 8, 2018
    Messages:
    8,080
    Likes Received:
    5,586
    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 Squad Player

    Joined:
    Apr 10, 2018
    Messages:
    13,912
    Likes Received:
    28,966
    Clear. Your. Cache
     
    #3 NorthernMonkey, Jan 4, 2020
    Hoochy-Min and Storck like this.
  4. Storck

    Storck Regular Starter

    Joined:
    Apr 8, 2018
    Messages:
    40,322
    Likes Received:
    31,232
    you finally learnt then
     
    #4 Storck, Jan 4, 2020
  5. NorthernMonkey

    NorthernMonkey Squad Player

    Joined:
    Apr 10, 2018
    Messages:
    13,912
    Likes Received:
    28,966
    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:
    7,016
    Likes Received:
    11,984
    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,516
    Likes Received:
    14,490
    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:
    40,322
    Likes Received:
    31,232
    Got it again today
     
    #8 Storck, Jan 11, 2020
  9. Storck

    Storck Regular Starter

    Joined:
    Apr 8, 2018
    Messages:
    40,322
    Likes Received:
    31,232
    4531DF93-F8FB-4B05-BE88-518B09C83559.png
     
    #9 Storck, Jan 11, 2020
  10. Rcbantam

    Rcbantam
    ⚽ P.L.25/26 Entrant

    Joined:
    Apr 8, 2018
    Messages:
    3,135
    Likes Received:
    2,409
    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.
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
    #10 Rcbantam, Jan 11, 2020
  11. bantam65

    bantam65
    Supporter ⚽ P.L.25/26 Entrant

    Joined:
    Apr 8, 2018
    Messages:
    12,676
    Likes Received:
    17,083
    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 World Cup 26 WC 2026 3rd Place ⚽ P.L.25/26 Entrant F1 2026 Entrant

    Joined:
    Apr 8, 2018
    Messages:
    8,080
    Likes Received:
    5,586
    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 World Cup 26 WC 2026 3rd Place ⚽ P.L.25/26 Entrant F1 2026 Entrant

    Joined:
    Apr 8, 2018
    Messages:
    8,080
    Likes Received:
    5,586
    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:
    40,322
    Likes Received:
    31,232
    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 World Cup 26 WC 2026 3rd Place ⚽ P.L.25/26 Entrant F1 2026 Entrant

    Joined:
    Apr 8, 2018
    Messages:
    8,080
    Likes Received:
    5,586
    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 World Cup 26 WC 2026 3rd Place ⚽ P.L.25/26 Entrant F1 2026 Entrant

    Joined:
    Apr 8, 2018
    Messages:
    8,080
    Likes Received:
    5,586
    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 World Cup 26 WC 2026 3rd Place ⚽ P.L.25/26 Entrant F1 2026 Entrant

    Joined:
    Apr 8, 2018
    Messages:
    8,080
    Likes Received:
    5,586
    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:
    40,322
    Likes Received:
    31,232
    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,921
    Likes Received:
    6,679
    Around 300
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
    #19 king karl, Jan 11, 2020
  20. Rcbantam

    Rcbantam
    ⚽ P.L.25/26 Entrant

    Joined:
    Apr 8, 2018
    Messages:
    3,135
    Likes Received:
    2,409
    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.
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
    #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