×

Notice

The forum is in read only mode.
× Feel free to discuss any typical forums accepted topic here, Whateley or otherwise. Let's avoid the usual suspects: politics, religion, and so forth that tend to result in flame wars and angered forums readers. Other topics will be considered fair game unless they prove to be too volatile, at which point we'll use Devisor created anti-flame chemicals on the subject.

Question Google gives site admin heart stress tests

8 years 10 months ago - 8 years 10 months ago #1 by Kristin Darken
  • Kristin Darken
  • Kristin Darken's Avatar Topic Author


  • Posts: 3898

  • Gender: Unknown
  • Birthdate: Unknown
  • Opened up my email this morning to get an alert from Google that we were over our 100% budget warning threshold. Now, to give you a bit of background on how this work... the Google developers platform keeps a running tally of queries, CPU seconds, data transfer totals in Mbs, and so on. Each of these elements comes at a per usage charge, tallied against how powerful our VM server is (number of CPUs, whether its SSD or hard drive, etc). All those add up to an estimated costs which, at the end of the month, is billed directly to my credit card. Based on our normal operations, I set up warning thresholds for 50% at $75 and 100% at $150. Generally, we hit the 50% warning late in the month and only rarely hit the 100% warning... especially now that I've moved us down to a less powerful server (we never crossed the 50% point on the resources for the server I set us up on originally - after all, we're only running a web site, not serving business applications or game development).

    Anyway, for us to hit the 100% mark this early in the month meant a large unexpected charge. And, indeed, there was a $130 charge for Cloud DNS queries among the usual numbers. Our usual charge for Cloud DNS queries / zone management is... about 4 cents per month. For us to get a charge of $130, we'd have to have somewhere in excess of 50 million queries, given that we only have four cloud zones (an Enterprise server with 200 zones and 10 million queries pays about $43 / month. And we got charged $130... since yesterday.

    Needless to say... I turned off Cloud DNS zone management. And sent Google a WTF?!!?!!?!?!! letter. :)

    It shouldn't impact anything on the user end of things. It was only on for a VM migration convenience...

    Fate guard you and grant you a Light to brighten your Way.
    Last Edit: 8 years 10 months ago by Kristin Darken.
    8 years 10 months ago #2 by Dreamer
    • Dreamer
    • Dreamer's Avatar


  • Posts: 984

  • Gender: Unknown
  • Birthdate: 03 Dec 1976
  • Good grief, that is ridiculous. Glad to hear your heart held out after seeing that, Kristin, I would have faint at the least. If I were more paranoid I would think the Cloud DNS queries increasing that much was an attempt by someone to attack the site, if that is possible.

    Thank You for story comments appreciated and help me know me they are being read and liked. :-) Note: My story comments can't nor are trying to replace reading the stories, simply my way of enjoying them and letting the authors know I enjoy them.
    8 years 10 months ago #3 by Kristin Darken
    • Kristin Darken
    • Kristin Darken's Avatar Topic Author


  • Posts: 3898

  • Gender: Unknown
  • Birthdate: Unknown
  • I turns out that there's a known issue affecting a number of accounts... reporting a false value/charge for queries. It's supposed to be a high priority fix that they are working on and will update people over the next couple days. So with luck, it won't even be a real charge...and my charge card can rest easy. :)

    Fate guard you and grant you a Light to brighten your Way.
    8 years 10 months ago #4 by Dreamer
    • Dreamer
    • Dreamer's Avatar


  • Posts: 984

  • Gender: Unknown
  • Birthdate: 03 Dec 1976
  • That is great news, so it wasn't a plot against the site and won't hit your charge card. Also I love your avatar, Kristin, did you make that yourself or find it somewhere?

    Thank You for story comments appreciated and help me know me they are being read and liked. :-) Note: My story comments can't nor are trying to replace reading the stories, simply my way of enjoying them and letting the authors know I enjoy them.
    8 years 10 months ago #5 by Kristin Darken
    • Kristin Darken
    • Kristin Darken's Avatar Topic Author


  • Posts: 3898

  • Gender: Unknown
  • Birthdate: Unknown
  • Like most of my avatars, I dug it up at alphacoders in the Avatar Abyss. :)

    Fate guard you and grant you a Light to brighten your Way.
    8 years 9 months ago #6 by Malady
    • Malady
    • Malady's Avatar


  • Posts: 3893

  • Gender: Unknown
  • Birthdate: Unknown
  • 8 years 9 months ago #7 by Kristin Darken
    • Kristin Darken
    • Kristin Darken's Avatar Topic Author


  • Posts: 3898

  • Gender: Unknown
  • Birthdate: Unknown
  • Nope, they had it all worked out in about 48 hours and it was all good. Very positive customer service experience too. They sent me regular emails with updates on what they were doing to solve things, with the option to pull my support ticket out of the mass fix if it didn't sound like the issue they were working on really matched up with the one I was facing. I was impressed.

    Fate guard you and grant you a Light to brighten your Way.
    8 years 9 months ago #8 by Polk Kitsune
    • Polk Kitsune
    • Polk Kitsune's Avatar


  • Posts: 431

  • Gender: Unknown
  • Birthdate: Unknown
  • Well, that's a relief. Good to hear. I know sometimes companies can be rather hard-headed about usages, so glad to hear you got something worked out.
    8 years 9 months ago #9 by ~Archangel~
    • ~Archangel~
    • ~Archangel~'s Avatar


  • Posts: 214

  • Gender: Unknown
  • Birthdate: Unknown
  • Kristin Darken wrote: Nope, they had it all worked out in about 48 hours and it was all good. Very positive customer service experience too. They sent me regular emails with updates on what they were doing to solve things, with the option to pull my support ticket out of the mass fix if it didn't sound like the issue they were working on really matched up with the one I was facing. I was impressed.


    Hold on, customer service THAT helps the customer?!? And leaves you impressed?!?

    It's daylight here can someone check if the moon has turned blood red while I look for dogs running in packs an other signs of the End Times. ;)

    Many people hear voices when no-one is there.
    Some are called 'mad' and shut up in rooms where they stare at the walls all day.
    Others are called 'writers' and they do pretty much the same thing.
    -Ray Bradbury
    8 years 9 months ago #10 by Kristin Darken
    • Kristin Darken
    • Kristin Darken's Avatar Topic Author


  • Posts: 3898

  • Gender: Unknown
  • Birthdate: Unknown
  • Oh... here's an example. This is an email I got today as a follow up.

    We are writing to let you know the results of our analysis of the issue which occurred with Google Cloud DNS billing around the 13th and 14th June. The issue was an error in the costing calculations for Cloud DNS, which caused customers' Google Cloud billing accounts to register excessive costs for their use of the Google Cloud DNS service. We sincerely apologize to all our customers who were affected by this. We have corrected the billing records on all affected accounts, and we have provided full compensation in the minority of cases where the error resulted in a financial charge to the customer.

    The root cause of this issue lay in work being undertaken by the Google Cloud Platform engineering team to increase the flexibility of the Cloud Platform billing system. At present, Cloud Platform usage charges are calculated and applied to customers' billing accounts once per day. In future, charges will be calculated on a faster cycle, giving customers much more fine-grained control of their Cloud Platform resource usage and costing. As part of this work, many of the time units used in internal billing calculations are being changed, in many cases from days to seconds.

    In the case of Cloud DNS, an incidental change introduced a discrepancy between the time units being used by the Cloud DNS and the billing system. Cloud DNS reported customers' managed-zone usage in seconds, but the billing system interpreted this figure as a metric in days, causing the calculated charge to be inflated by a factor of 86400 (the number of seconds in a day).

    If you have any questions about your case, you can reply to this message and a support agent will follow up with you. If you no longer think this is your issue, please click the link below so that we can continue working with you to identify your issue:

    *link cut so no one accidentally restarts the help case*


    As I said before... impressed. :)

    Fate guard you and grant you a Light to brighten your Way.
    8 years 9 months ago #11 by DanZilla
    • DanZilla
    • DanZilla's Avatar


  • Posts: 1648

  • Gender: Unknown
  • Birthdate: Unknown
  • Well Golly!!! (said in my best Gomer Pyle Voice... Yes, I typed it as he would have said it initially and it just got more confusing to try to parse it out as I went along))
    8 years 9 months ago #12 by Arcanist Lupus
    • Arcanist Lupus
    • Arcanist Lupus's Avatar


  • Posts: 1820

  • Gender: Male
  • Birthdate: Unknown
  • In other words - unit mismatch. :D

    "Shared pain is lessened; shared joy, increased — thus do we refute entropy." - Spider Robinson
    8 years 9 months ago #13 by Kristin Darken
    • Kristin Darken
    • Kristin Darken's Avatar Topic Author


  • Posts: 3898

  • Gender: Unknown
  • Birthdate: Unknown
  • yep i can just imagine the eyebrows on some of the busier sites. Figure our little site racked up about $100 more than expected overnight before it hit my alert notification level. Imagine how high those numbers got on some of the really big site accounts. :)

    Fate guard you and grant you a Light to brighten your Way.
    8 years 9 months ago #14 by Nagrij
    • Nagrij
    • Nagrij's Avatar


  • Posts: 1290

  • Gender: Unknown
  • Birthdate: Unknown
  • The fact that they actually told you what they did wrong alone, impresses the hell out of me. You so rarely get an explanation of a screw up anymore. Or even an admission to a screw up.

    www.patreon.com/Nagrij

    If you like my writing, please consider helping me out, and see the rest of the tales I spin on Patreon.
    8 years 9 months ago #15 by ~Archangel~
    • ~Archangel~
    • ~Archangel~'s Avatar


  • Posts: 214

  • Gender: Unknown
  • Birthdate: Unknown
  • Nagrij wrote: The fact that they actually told you what they did wrong alone, impresses the hell out of me. You so rarely get an explanation of a screw up anymore. Or even an admission to a screw up.


    This.

    At one of my previous jobs I suggested that we rename ourselves the Department Of Obfuscation and Prevarication.

    'Don't tell the truth if it makes us look bad, or liable, and don't shift the blame to our client even if they are responsible. And don't lie to the client or the customer you are helping. Always offer to resolve the situation even if you can't.' That was a line from my training class.

    Now I just abandon all hope when I call customer service. :(

    Many people hear voices when no-one is there.
    Some are called 'mad' and shut up in rooms where they stare at the walls all day.
    Others are called 'writers' and they do pretty much the same thing.
    -Ray Bradbury
    8 years 9 months ago #16 by Valentine
    • Valentine
    • Valentine's Avatar


  • Posts: 3121

  • Gender: Unknown
  • Birthdate: 17 Aug 1966
  • Well now we know where the Lockheed-Martin Mars Surveyor programming team works.

    Don't Drick and Drive.
    8 years 9 months ago #17 by Malady
    • Malady
    • Malady's Avatar


  • Posts: 3893

  • Gender: Unknown
  • Birthdate: Unknown
  • Hmm... Well, you're a programmer dealing with customer service, which is different than a non-programmer doing so, so you have background knowledge to understand their explanations and be sympathetic and stuff?
    8 years 9 months ago #18 by Nagrij
    • Nagrij
    • Nagrij's Avatar


  • Posts: 1290

  • Gender: Unknown
  • Birthdate: Unknown
  • Valentine wrote: Well now we know where the Lockheed-Martin Mars Surveyor programming team works.


    Ouch. That was cold, valentine. Apropos, but cold.

    www.patreon.com/Nagrij

    If you like my writing, please consider helping me out, and see the rest of the tales I spin on Patreon.
    8 years 7 months ago #19 by E M Pisek
    • E M Pisek
    • E M Pisek's Avatar


  • Posts: 1299

  • Gender: Male
  • Birthdate: 24 Apr 1960
  • Just remember; the cold truth hurts the worst as you face the facts thrown in your face with the readouts - or lack of readings.

    Hmm. Metric vs Standard. Which one did they use again? Oh never mind I'll just use standard. We are the U.S. after all.

    What is - was. What was - is.
    Moderators: WhateleyAdminKristin DarkenE. E. NalleyelrodwNagrijMageOhkiAstrodragonNeoMagusWarrenMorpheusWasamonsleethrOtherEricBek D CorbinMaLAguASouffle GirlPhoenix SpiritusStarwolfDanZillaKatie_LynMaggie FinsonDrBenderJGBladedancerRenae_Whateley
    Powered by Kunena Forum