media query doesn't die

[dustymc]

Source

error logs

Summary

look at running queries, probably a lot of hung media queries (I think for the viewer). Why?!?

Ex:

select distinct                                                                                                                                                           +
         media_flat.media_id,                                                                                                                                              +
         media_flat.media_uri,                                                                                                                                             +
         media_flat.mime_type,                                                                                                                                             +
         media_flat.media_type,                                                                                                                                            +
         media_flat.preview_uri,                                                                                                                                           +
         media_flat.hastags,                                                                                                                                               +
                 alt_text,                                                                                                                                                 +
                 license,                                                                                                                                                  +
         media_flat.descr,                                                                                                                                                 +
                 media_flat.thumbnail                                                                                                                                      +
      from                                                                                                                                                                 +
          media_flat                                                                                                                                                       +
                 inner join media_relations on media_flat.media_id=media_relations.media_id                                                                                +
      where                                                                                                                                                                +
          media_relations.cataloged_item_id =$1

User Interface Changes

none

Data Structure Changes

none

[dustymc]

Implemented some timeouts for 3.3.8.2, but I don't understand why this is happening and will leave this open to keep monitoring.

Also found a bug (https://github.com/ArctosDB/arctos/issues/8182), not clear how or if that's related other than both being involved in zombie queries.