5

Some SO profile pages won't load at all, others will load but you can't go to the Activity tab, others are absolutely fine.

Examples:

Presumably the fact my main profile fails for me but not others has to do with me being signed in as the person whose profile I'm viewing.

(Why did I choose those accounts? I chose my account because, well, that's where I first hit the problem. I chose Tholle at random. I chose gnat because he'd had a similar problem before. Finally, I chose Jon because he's a long-term, high-rep user with a lot of activity.)

Possibly related:

  • 1
    I can't repro the error on your main profile page, but the rep tab fails on you, gnat, and Jon. – Nathan Tuggy Jul 15 '18 at 13:14
  • @NathanTuggy - Interesting. It still fails for me on my main browser where I'm logged in, but works if I use a different browser and don't log in. – T.J. Crowder Jul 15 '18 at 13:18
10

This should be fixed. Last week, we made changes to the query to adjust a couple of indexes and 'hey, it worked', but then we did the maintenance yesterday which failed the database over to a different server and guess what it decided to stop working as expected.

All of the indexes were the same, but the SQL Engine picked a different execution plan for the page which was not the plan we wanted. The good news is that last week, I turned on query store for SQL Server which captures different execution plans for queries. The query store captured both the good and the bad plan, and one of the nice things about this is it lets me tell the server to use the good plan. I just forced the plan for the query and it should be loading now.

  • From the little I understood it means that when you'll "fail the database over to a different server" again, it might pick the wrong plan again (since you forced it only on the current server) and this bug will just happen again. Is this correct? If so, why not just get rid of the bad execution plan so it can't be picked up in the future? – Shadow The Princess Wizard Jul 15 '18 at 15:19
  • 1
    @ShadowWizard it’s possible that would happen. Since it’s the weekend I didn’t dig in too much on this. My goal was to get the page to load for the time being, I’ll look closer next week. The hope would be that since we sync things via availability groups, the query store selections would sync as well but I’ll have to look later. – Taryn Jul 15 '18 at 15:23
  • Working great this morning, thanks! – T.J. Crowder Jul 16 '18 at 6:39

You must log in to answer this question.

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