Evergreen

  1. Bug #1704396
  2. Comment #11

Comment 11 for bug 1704396

Revision history for this message
Jason Boyer (jboyer) wrote : Re: Slowness for metecord and one-hit searches in 2.12

Because I know everyone loves the spicy zing of anecdata:

Something I've seen more and more since our move to 2.12 is pileups of unapi.bre and biblio.record_copy_count queries. So many and so slow that they've been added to the list of queries that we cancel after 90 seconds. They can run for minutes and minutes if unchecked, and there was one day where postgres was literally crashed due to their piling up. I didn't bug it at the time because I assumed it was a local config bottleneck, but maybe that's not the case? It doesn't seem to be related to metarecords but if the problem is potentially record detail pages they may have some nebulous relation at least.