Uploaded image for project: 'MusicBrainz Search Server'
  1. MusicBrainz Search Server
  2. SEARCH-577

Index limit exceeded on medium formats update

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Open
    • Priority: Low
    • Resolution: Unresolved
    • Affects Version/s: None
    • Fix Version/s: None
    • Component/s: Indexer
    • Labels:
      None

      Description

      Updating Digital Media child order pulled the trigger search_medium_format_update which sent the following message:

      {
         "_table" : "medium_format",
         "_operation" : "update",
         "id" : 12
      }
      

      This message ended in the queue search.failed with the following exception:

      Traceback (most recent call last):
        File "sir/amqp/handler.py", line 120, in wrapper
          f(self=self, parsed_message=parsed_message)
        File "sir/amqp/handler.py", line 262, in index_callback
          self._index_by_pk(parsed_message)
        File "sir/amqp/handler.py", line 361, in _index_by_pk
          self._index_data(core_name, ids, extra_data)
        File "sir/amqp/handler.py", line 331, in _index_data
          raise INDEX_LIMIT_EXCEEDED(core_name, total_ids, extra_data)
      INDEX_LIMIT_EXCEEDED: Index limit exceeded. Entity: recording, Total Rows: 4712506, Extra Data: {'path': 'tracks.medium.format', 'table_name': u'medium_format', 'select_query': 'SELECT recording_1.id AS recording_1_id 
      FROM musicbrainz.recording AS recording_1 JOIN musicbrainz.track AS track_1 ON recording_1.id = track_1.recording JOIN musicbrainz.medium AS medium_1 ON medium_1.id = track_1.medium JOIN musicbrainz.medium_format ON musicbrainz.medium_format.id = medium_1.format 
      WHERE musicbrainz.medium_format.id = :id_1'}
      

      Issue is twofold:

      1. Updating child_order column in the medium_format should not pull the trigger as only name column is actually used for search index;
      2. Even though updating the name of a medium format that has above 2M occurrences is uncommon, it should probably not fail.

        Attachments

          Activity

            People

            Assignee:
            Unassigned Unassigned
            Reporter:
            yvanzo yvanzo
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

              Dates

              Created:
              Updated:

                Packages

                Version Package