14

There's this link that shows your reputation across all networks (just change the id with the appropriate one. me doesn't work).

Trying to view Jon Skeet's... well, unsurprisingly, the server doesn't face the request.

enter image description here

4
  • 4
    There's a good chance to DoS SE with meta readers trying now :)
    – Tensibai
    Commented Jul 19, 2018 at 14:14
  • 2
    Sorry--can't help myself--but that picture and its caption ("Something Bad Happened!") is so freaking ADORABLE Commented Jul 19, 2018 at 14:41
  • 1
    Most likely same root issue as this other bug, and the fix wasn't applied in stackexchane.com yet. Commented Jul 19, 2018 at 14:48
  • 1
    @ShadowWizard Not the same root cause as the previous issue, but it should be resolved.
    – Taryn StaffMod
    Commented Jul 19, 2018 at 18:37

1 Answer 1

10

This should be resolved now. Over the last couple of weeks we have been doing some query tuning which was applied to all the databases across the network, but SQL was being very stubborn and didn't want to use the plan we were expecting. This morning after digging through many execution plans, we resolved the issue forcefully.

On a more technical level, SQL Server was basically trying to perform something similar a CROSS JOIN on rep history which resulted in it reading more rows than it actually needed, so we resorted to using query hint to force a LEFT HASH JOIN. Miraculously, it worked as we wanted and now the graph loads.

1
  • 2
    Reading this reminded me of my kids refusing to do stuff (e.g. dressing, brushing teeth) and we (parents) have to force them into it. :D Commented Jul 19, 2018 at 18:49

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .