# Pastebin dSqxYIhd
reosarevok@reolappy:/media/data/musicbrainz-docker$ sudo docker-compose exec indexer python -m sir -d reindex --entity-type=instrument
MainProcess 2021-08-30 16:08:25,107  INFO: Checking whether the versions of the Solr cores are supported
MainProcess 2021-08-30 16:08:26,582  DEBUG: instrument: version 1.5 matches 1.5
MainProcess 2021-08-30 16:08:26,831  INFO: Importing instrument...
MainProcess 2021-08-30 16:08:26,846  DEBUG: Setting up a connection to http://search:8983/solr
MainProcess 2021-08-30 16:08:26,846  DEBUG: Pinging http://search:8983/solr/instrument/admin/ping
MainProcess 2021-08-30 16:08:28,061  DEBUG: Connection to the Solr core at http://search:8983/solr/instrument
PoolWorker-1 2021-08-30 16:08:30,561  DEBUG: Importing <class 'sir.schema.modelext.CustomInstrument'> (1, None)
PoolWorker-1 2021-08-30 16:08:30,562  DEBUG: search_entity.model <class 'sir.schema.modelext.CustomInstrument'>
PoolWorker-1 2021-08-30 16:08:30,565  DEBUG: condition is musicbrainz.instrument.id >= :id_1
PoolWorker-1 2021-08-30 16:08:30,568  DEBUG: pathelem is aliases
PoolWorker-1 2021-08-30 16:08:30,568  DEBUG: CustomInstrument.aliases is a relationship
PoolWorker-1 2021-08-30 16:08:30,569  DEBUG: required_columns: ['begin_date', 'name', 'end_date', 'locale', 'sort_name', 'type', 'primary_for_locale']
PoolWorker-1 2021-08-30 16:08:30,570  DEBUG: Loading ['begin_date_year', 'begin_date_month', 'begin_date_day'] instead of begin_date on <class 'mbdata.models.InstrumentAlias'>
PoolWorker-1 2021-08-30 16:08:30,570  DEBUG: Loading ['end_date_year', 'end_date_month', 'end_date_day'] instead of end_date on <class 'mbdata.models.InstrumentAlias'>
PoolWorker-1 2021-08-30 16:08:30,570  DEBUG: Loading only ['name', 'locale', 'sort_name', 'type', 'primary_for_locale', 'id', 'begin_date_year', 'begin_date_month', 'begin_date_day', 'end_date_year', 'end_date_month', 'end_date_day'] on <class 'mbdata.models.InstrumentAlias'>
PoolWorker-1 2021-08-30 16:08:30,571  DEBUG: pathelem is name
PoolWorker-1 2021-08-30 16:08:30,571  DEBUG: pathelem is comment
PoolWorker-1 2021-08-30 16:08:30,571  DEBUG: pathelem is description
PoolWorker-1 2021-08-30 16:08:30,571  DEBUG: pathelem is gid
PoolWorker-1 2021-08-30 16:08:30,571  DEBUG: pathelem is name
PoolWorker-1 2021-08-30 16:08:30,571  DEBUG: pathelem is tags
PoolWorker-1 2021-08-30 16:08:30,571  DEBUG: CustomInstrument.tags is a relationship
PoolWorker-1 2021-08-30 16:08:30,572  DEBUG: required_columns: ['count', 'tag']
PoolWorker-1 2021-08-30 16:08:30,572  DEBUG: Loading only ['count', 'tag', 'instrument'] on <class 'mbdata.models.InstrumentTag'>
PoolWorker-1 2021-08-30 16:08:30,572  DEBUG: pathelem is tag
PoolWorker-1 2021-08-30 16:08:30,572  DEBUG: InstrumentTag.tag is a relationship
PoolWorker-1 2021-08-30 16:08:30,572  DEBUG: required_columns: ['name']
PoolWorker-1 2021-08-30 16:08:30,572  DEBUG: Loading only ['name', 'id'] on <class 'mbdata.models.Tag'>
PoolWorker-1 2021-08-30 16:08:30,573  DEBUG: pathelem is name
PoolWorker-1 2021-08-30 16:08:30,573  DEBUG: pathelem is type
PoolWorker-1 2021-08-30 16:08:30,573  DEBUG: Instrument.type is a relationship
PoolWorker-1 2021-08-30 16:08:30,573  DEBUG: required_columns: ['gid', 'name']
PoolWorker-1 2021-08-30 16:08:30,573  DEBUG: Loading only ['gid', 'name', 'id'] on <class 'mbdata.models.InstrumentType'>
PoolWorker-1 2021-08-30 16:08:30,573  DEBUG: pathelem is name
PoolWorker-1 2021-08-30 16:08:30,573  DEBUG: pathelem is aliases
PoolWorker-1 2021-08-30 16:08:30,573  DEBUG: CustomInstrument.aliases is a relationship
PoolWorker-1 2021-08-30 16:08:30,574  DEBUG: required_columns: ['begin_date', 'name', 'end_date', 'locale', 'sort_name', 'type', 'primary_for_locale']
PoolWorker-1 2021-08-30 16:08:30,574  DEBUG: Loading ['begin_date_year', 'begin_date_month', 'begin_date_day'] instead of begin_date on <class 'mbdata.models.InstrumentAlias'>
PoolWorker-1 2021-08-30 16:08:30,574  DEBUG: Loading ['end_date_year', 'end_date_month', 'end_date_day'] instead of end_date on <class 'mbdata.models.InstrumentAlias'>
PoolWorker-1 2021-08-30 16:08:30,574  DEBUG: Loading only ['name', 'locale', 'sort_name', 'type', 'primary_for_locale', 'id', 'begin_date_year', 'begin_date_month', 'begin_date_day', 'end_date_year', 'end_date_month', 'end_date_day'] on <class 'mbdata.models.InstrumentAlias'>
PoolWorker-1 2021-08-30 16:08:30,574  DEBUG: pathelem is type
PoolWorker-1 2021-08-30 16:08:30,574  DEBUG: InstrumentAlias.type is a relationship
PoolWorker-1 2021-08-30 16:08:30,575  DEBUG: required_columns: ['gid', 'name', 'id']
PoolWorker-1 2021-08-30 16:08:30,575  DEBUG: Loading only ['gid', 'name', 'id', 'id'] on <class 'mbdata.models.InstrumentAliasType'>
PoolWorker-1 2021-08-30 16:08:30,575  DEBUG: pathelem is name
PoolWorker-1 2021-08-30 16:08:30,575  DEBUG: pathelem is aliases
PoolWorker-1 2021-08-30 16:08:30,575  DEBUG: CustomInstrument.aliases is a relationship
PoolWorker-1 2021-08-30 16:08:30,575  DEBUG: required_columns: ['begin_date', 'name', 'end_date', 'locale', 'sort_name', 'type', 'primary_for_locale']
PoolWorker-1 2021-08-30 16:08:30,575  DEBUG: Loading ['begin_date_year', 'begin_date_month', 'begin_date_day'] instead of begin_date on <class 'mbdata.models.InstrumentAlias'>
PoolWorker-1 2021-08-30 16:08:30,575  DEBUG: Loading ['end_date_year', 'end_date_month', 'end_date_day'] instead of end_date on <class 'mbdata.models.InstrumentAlias'>
PoolWorker-1 2021-08-30 16:08:30,575  DEBUG: Loading only ['name', 'locale', 'sort_name', 'type', 'primary_for_locale', 'id', 'begin_date_year', 'begin_date_month', 'begin_date_day', 'end_date_year', 'end_date_month', 'end_date_day'] on <class 'mbdata.models.InstrumentAlias'>
PoolWorker-1 2021-08-30 16:08:30,576  DEBUG: pathelem is type
PoolWorker-1 2021-08-30 16:08:30,576  DEBUG: InstrumentAlias.type is a relationship
PoolWorker-1 2021-08-30 16:08:30,576  DEBUG: required_columns: ['gid', 'name', 'id']
PoolWorker-1 2021-08-30 16:08:30,576  DEBUG: Loading only ['gid', 'name', 'id', 'id'] on <class 'mbdata.models.InstrumentAliasType'>
PoolWorker-1 2021-08-30 16:08:30,577  DEBUG: pathelem is id
PoolWorker-1 2021-08-30 16:08:30,577  DEBUG: pathelem is aliases
PoolWorker-1 2021-08-30 16:08:30,577  DEBUG: CustomInstrument.aliases is a relationship
PoolWorker-1 2021-08-30 16:08:30,577  DEBUG: required_columns: ['begin_date', 'name', 'end_date', 'locale', 'sort_name', 'type', 'primary_for_locale']
PoolWorker-1 2021-08-30 16:08:30,577  DEBUG: Loading ['begin_date_year', 'begin_date_month', 'begin_date_day'] instead of begin_date on <class 'mbdata.models.InstrumentAlias'>
PoolWorker-1 2021-08-30 16:08:30,577  DEBUG: Loading ['end_date_year', 'end_date_month', 'end_date_day'] instead of end_date on <class 'mbdata.models.InstrumentAlias'>
PoolWorker-1 2021-08-30 16:08:30,577  DEBUG: Loading only ['name', 'locale', 'sort_name', 'type', 'primary_for_locale', 'id', 'begin_date_year', 'begin_date_month', 'begin_date_day', 'end_date_year', 'end_date_month', 'end_date_day'] on <class 'mbdata.models.InstrumentAlias'>
PoolWorker-1 2021-08-30 16:08:30,578  DEBUG: pathelem is sort_name
PoolWorker-1 2021-08-30 16:08:30,578  DEBUG: pathelem is aliases
PoolWorker-1 2021-08-30 16:08:30,578  DEBUG: CustomInstrument.aliases is a relationship
PoolWorker-1 2021-08-30 16:08:30,578  DEBUG: required_columns: ['begin_date', 'name', 'end_date', 'locale', 'sort_name', 'type', 'primary_for_locale']
PoolWorker-1 2021-08-30 16:08:30,578  DEBUG: Loading ['begin_date_year', 'begin_date_month', 'begin_date_day'] instead of begin_date on <class 'mbdata.models.InstrumentAlias'>
PoolWorker-1 2021-08-30 16:08:30,578  DEBUG: Loading ['end_date_year', 'end_date_month', 'end_date_day'] instead of end_date on <class 'mbdata.models.InstrumentAlias'>
PoolWorker-1 2021-08-30 16:08:30,578  DEBUG: Loading only ['name', 'locale', 'sort_name', 'type', 'primary_for_locale', 'id', 'begin_date_year', 'begin_date_month', 'begin_date_day', 'end_date_year', 'end_date_month', 'end_date_day'] on <class 'mbdata.models.InstrumentAlias'>
PoolWorker-1 2021-08-30 16:08:30,579  DEBUG: pathelem is type
PoolWorker-1 2021-08-30 16:08:30,579  DEBUG: InstrumentAlias.type is a relationship
PoolWorker-1 2021-08-30 16:08:30,579  DEBUG: required_columns: ['gid', 'name', 'id']
PoolWorker-1 2021-08-30 16:08:30,579  DEBUG: Loading only ['gid', 'name', 'id', 'id'] on <class 'mbdata.models.InstrumentAliasType'>
PoolWorker-1 2021-08-30 16:08:30,579  DEBUG: pathelem is gid
PoolWorker-1 2021-08-30 16:08:30,579  DEBUG: pathelem is aliases
PoolWorker-1 2021-08-30 16:08:30,579  DEBUG: CustomInstrument.aliases is a relationship
PoolWorker-1 2021-08-30 16:08:30,579  DEBUG: required_columns: ['begin_date', 'name', 'end_date', 'locale', 'sort_name', 'type', 'primary_for_locale']
PoolWorker-1 2021-08-30 16:08:30,579  DEBUG: Loading ['begin_date_year', 'begin_date_month', 'begin_date_day'] instead of begin_date on <class 'mbdata.models.InstrumentAlias'>
PoolWorker-1 2021-08-30 16:08:30,580  DEBUG: Loading ['end_date_year', 'end_date_month', 'end_date_day'] instead of end_date on <class 'mbdata.models.InstrumentAlias'>
PoolWorker-1 2021-08-30 16:08:30,580  DEBUG: Loading only ['name', 'locale', 'sort_name', 'type', 'primary_for_locale', 'id', 'begin_date_year', 'begin_date_month', 'begin_date_day', 'end_date_year', 'end_date_month', 'end_date_day'] on <class 'mbdata.models.InstrumentAlias'>
PoolWorker-1 2021-08-30 16:08:30,580  DEBUG: pathelem is locale
PoolWorker-1 2021-08-30 16:08:30,580  DEBUG: pathelem is aliases
PoolWorker-1 2021-08-30 16:08:30,580  DEBUG: CustomInstrument.aliases is a relationship
PoolWorker-1 2021-08-30 16:08:30,580  DEBUG: required_columns: ['begin_date', 'name', 'end_date', 'locale', 'sort_name', 'type', 'primary_for_locale']
PoolWorker-1 2021-08-30 16:08:30,581  DEBUG: Loading ['begin_date_year', 'begin_date_month', 'begin_date_day'] instead of begin_date on <class 'mbdata.models.InstrumentAlias'>
PoolWorker-1 2021-08-30 16:08:30,581  DEBUG: Loading ['end_date_year', 'end_date_month', 'end_date_day'] instead of end_date on <class 'mbdata.models.InstrumentAlias'>
PoolWorker-1 2021-08-30 16:08:30,581  DEBUG: Loading only ['name', 'locale', 'sort_name', 'type', 'primary_for_locale', 'id', 'begin_date_year', 'begin_date_month', 'begin_date_day', 'end_date_year', 'end_date_month', 'end_date_day'] on <class 'mbdata.models.InstrumentAlias'>
PoolWorker-1 2021-08-30 16:08:30,581  DEBUG: pathelem is primary_for_locale
PoolWorker-1 2021-08-30 16:08:30,581  DEBUG: pathelem is aliases
PoolWorker-1 2021-08-30 16:08:30,581  DEBUG: CustomInstrument.aliases is a relationship
PoolWorker-1 2021-08-30 16:08:30,581  DEBUG: required_columns: ['begin_date', 'name', 'end_date', 'locale', 'sort_name', 'type', 'primary_for_locale']
PoolWorker-1 2021-08-30 16:08:30,582  DEBUG: Loading ['begin_date_year', 'begin_date_month', 'begin_date_day'] instead of begin_date on <class 'mbdata.models.InstrumentAlias'>
PoolWorker-1 2021-08-30 16:08:30,582  DEBUG: Loading ['end_date_year', 'end_date_month', 'end_date_day'] instead of end_date on <class 'mbdata.models.InstrumentAlias'>
PoolWorker-1 2021-08-30 16:08:30,582  DEBUG: Loading only ['name', 'locale', 'sort_name', 'type', 'primary_for_locale', 'id', 'begin_date_year', 'begin_date_month', 'begin_date_day', 'end_date_year', 'end_date_month', 'end_date_day'] on <class 'mbdata.models.InstrumentAlias'>
PoolWorker-1 2021-08-30 16:08:30,582  DEBUG: pathelem is begin_date
PoolWorker-1 2021-08-30 16:08:30,582  DEBUG: pathelem is aliases
PoolWorker-1 2021-08-30 16:08:30,582  DEBUG: CustomInstrument.aliases is a relationship
PoolWorker-1 2021-08-30 16:08:30,582  DEBUG: required_columns: ['begin_date', 'name', 'end_date', 'locale', 'sort_name', 'type', 'primary_for_locale']
PoolWorker-1 2021-08-30 16:08:30,583  DEBUG: Loading ['begin_date_year', 'begin_date_month', 'begin_date_day'] instead of begin_date on <class 'mbdata.models.InstrumentAlias'>
PoolWorker-1 2021-08-30 16:08:30,583  DEBUG: Loading ['end_date_year', 'end_date_month', 'end_date_day'] instead of end_date on <class 'mbdata.models.InstrumentAlias'>
PoolWorker-1 2021-08-30 16:08:30,583  DEBUG: Loading only ['name', 'locale', 'sort_name', 'type', 'primary_for_locale', 'id', 'begin_date_year', 'begin_date_month', 'begin_date_day', 'end_date_year', 'end_date_month', 'end_date_day'] on <class 'mbdata.models.InstrumentAlias'>
PoolWorker-1 2021-08-30 16:08:30,583  DEBUG: pathelem is end_date
PoolWorker-1 2021-08-30 16:08:30,583  DEBUG: pathelem is tags
PoolWorker-1 2021-08-30 16:08:30,583  DEBUG: CustomInstrument.tags is a relationship
PoolWorker-1 2021-08-30 16:08:30,583  DEBUG: required_columns: ['count', 'tag']
PoolWorker-1 2021-08-30 16:08:30,583  DEBUG: Loading only ['count', 'tag', 'instrument'] on <class 'mbdata.models.InstrumentTag'>
PoolWorker-1 2021-08-30 16:08:30,584  DEBUG: pathelem is count
PoolWorker-1 2021-08-30 16:08:30,584  DEBUG: pathelem is type
PoolWorker-1 2021-08-30 16:08:30,584  DEBUG: Instrument.type is a relationship
PoolWorker-1 2021-08-30 16:08:30,584  DEBUG: required_columns: ['gid', 'name']
PoolWorker-1 2021-08-30 16:08:30,584  DEBUG: Loading only ['gid', 'name', 'id'] on <class 'mbdata.models.InstrumentType'>
PoolWorker-1 2021-08-30 16:08:30,584  DEBUG: pathelem is gid
PoolWorker-1 2021-08-30 16:08:31,345  ERROR: Failed to import instrument with id in bounds (1, None)
PoolWorker-1 2021-08-30 16:08:31,345  ERROR: can't locate strategy for <class 'sqlalchemy.orm.relationships.RelationshipProperty'> (('deferred', False), ('instrument', True))
Traceback (most recent call last):
  File "sir/indexing.py", line 193, in _index_entity_process_wrapper
    return index_entity(*args)
  File "sir/indexing.py", line 220, in index_entity
    _query_database(entity_name, condition, data_queue)
  File "sir/indexing.py", line 262, in _query_database
    for row in query:
  File "/usr/local/lib/python2.7/site-packages/sqlalchemy/orm/loading.py", line 90, in instances
    util.raise_from_cause(err)
  File "/usr/local/lib/python2.7/site-packages/sqlalchemy/util/compat.py", line 203, in raise_from_cause
    reraise(type(exception), exception, tb=exc_tb, cause=cause)
  File "/usr/local/lib/python2.7/site-packages/sqlalchemy/orm/loading.py", line 75, in instances
    rows = [proc(row) for row in fetch]
  File "/usr/local/lib/python2.7/site-packages/sqlalchemy/orm/loading.py", line 452, in _instance
    loaded_instance, populate_existing, populators)
  File "/usr/local/lib/python2.7/site-packages/sqlalchemy/orm/loading.py", line 524, in _populate_full
    populator(state, dict_, row)
  File "/usr/local/lib/python2.7/site-packages/sqlalchemy/orm/strategies.py", line 1096, in load_collection_from_subq
    ()
  File "/usr/local/lib/python2.7/site-packages/sqlalchemy/orm/strategies.py", line 1033, in get
    self._load()
  File "/usr/local/lib/python2.7/site-packages/sqlalchemy/orm/strategies.py", line 1041, in _load
    lambda x: x[1:]
  File "/usr/local/lib/python2.7/site-packages/sqlalchemy/orm/query.py", line 2851, in __iter__
    context = self._compile_context()
  File "/usr/local/lib/python2.7/site-packages/sqlalchemy/orm/query.py", line 3365, in _compile_context
    entity.setup_context(self, context)
  File "/usr/local/lib/python2.7/site-packages/sqlalchemy/orm/query.py", line 3727, in setup_context
    polymorphic_discriminator=self._polymorphic_discriminator)
  File "/usr/local/lib/python2.7/site-packages/sqlalchemy/orm/loading.py", line 259, in _setup_entity_query
    **kw
  File "/usr/local/lib/python2.7/site-packages/sqlalchemy/orm/interfaces.py", line 514, in setup
    strat = self._get_strategy(loader.strategy)
  File "/usr/local/lib/python2.7/site-packages/sqlalchemy/orm/interfaces.py", line 505, in _get_strategy
    cls = self._strategy_lookup(*key)
  File "/usr/local/lib/python2.7/site-packages/sqlalchemy/orm/interfaces.py", line 564, in _strategy_lookup
    raise Exception("can't locate strategy for %s %s" % (cls, key))
Exception: can't locate strategy for <class 'sqlalchemy.orm.relationships.RelationshipProperty'> (('deferred', False), ('instrument', True))
MainProcess 2021-08-30 16:08:31,456  ERROR: Failed to import instrument.
MainProcess 2021-08-30 16:08:31,457  ERROR: can't locate strategy for <class 'sqlalchemy.orm.relationships.RelationshipProperty'> (('deferred', False), ('instrument', True))
Traceback (most recent call last):
  File "sir/indexing.py", line 152, in _multiprocessed_import
    for r in results:
  File "/usr/local/lib/python2.7/multiprocessing/pool.py", line 673, in next
    raise value
Exception: can't locate strategy for <class 'sqlalchemy.orm.relationships.RelationshipProperty'> (('deferred', False), ('instrument', True))
Solr-0 2021-08-30 16:08:31,557  DEBUG: <pysolr.Solr object at 0x7f06c9a37f50>: Sending remaining data & stopping
Solr-1 2021-08-30 16:08:31,557  DEBUG: <pysolr.Solr object at 0x7f06c9a37f50>: Sending remaining data & stopping
Solr-2 2021-08-30 16:08:31,557  DEBUG: <pysolr.Solr object at 0x7f06c9a37f50>: Sending remaining data & stopping
Solr-3 2021-08-30 16:08:31,557  DEBUG: <pysolr.Solr object at 0x7f06c9a37f50>: Sending remaining data & stopping
Solr-4 2021-08-30 16:08:31,558  DEBUG: <pysolr.Solr object at 0x7f06c9a37f50>: Sending remaining data & stopping
Solr-5 2021-08-30 16:08:31,558  DEBUG: <pysolr.Solr object at 0x7f06c9a37f50>: Sending remaining data & stopping
Solr-6 2021-08-30 16:08:31,558  DEBUG: <pysolr.Solr object at 0x7f06c9a37f50>: Sending remaining data & stopping
Solr-7 2021-08-30 16:08:31,567  DEBUG: <pysolr.Solr object at 0x7f06c9a37f50>: Sending remaining data & stopping
Solr-0 2021-08-30 16:08:32,256  DEBUG: Done sending data to Solr
Solr-4 2021-08-30 16:08:32,256  DEBUG: Done sending data to Solr
Solr-5 2021-08-30 16:08:32,256  DEBUG: Done sending data to Solr
Solr-7 2021-08-30 16:08:32,256  DEBUG: Done sending data to Solr
Solr-0 2021-08-30 16:08:32,256  DEBUG: Sent data to Solr
Solr-5 2021-08-30 16:08:32,256  DEBUG: Sent data to Solr
Solr-4 2021-08-30 16:08:32,257  DEBUG: Sent data to Solr
Solr-7 2021-08-30 16:08:32,257  DEBUG: Sent data to Solr
Solr-4 2021-08-30 16:08:32,257  DEBUG: Committing changes to Solr
Solr-5 2021-08-30 16:08:32,257  DEBUG: Committing changes to Solr
Solr-1 2021-08-30 16:08:32,258  DEBUG: Done sending data to Solr
Solr-6 2021-08-30 16:08:32,258  DEBUG: Done sending data to Solr
Solr-3 2021-08-30 16:08:32,258  DEBUG: Done sending data to Solr
Solr-7 2021-08-30 16:08:32,258  DEBUG: Committing changes to Solr
Solr-1 2021-08-30 16:08:32,258  DEBUG: Sent data to Solr
Solr-3 2021-08-30 16:08:32,258  DEBUG: Sent data to Solr
Solr-6 2021-08-30 16:08:32,258  DEBUG: Sent data to Solr
Solr-1 2021-08-30 16:08:32,258  DEBUG: Committing changes to Solr
Solr-3 2021-08-30 16:08:32,258  DEBUG: Committing changes to Solr
Solr-6 2021-08-30 16:08:32,258  DEBUG: Committing changes to Solr
Solr-0 2021-08-30 16:08:32,262  DEBUG: Committing changes to Solr
Solr-2 2021-08-30 16:08:32,267  DEBUG: Done sending data to Solr
Solr-2 2021-08-30 16:08:32,268  DEBUG: Sent data to Solr
Solr-2 2021-08-30 16:08:32,269  DEBUG: Committing changes to Solr