# Pastebin 9C8H9ymO
reosarevok@reolappy:/media/data/musicbrainz-docker$ sudo docker-compose exec indexer python -m sir -d reindex --entity-type=instrument
MainProcess 2021-08-30 16:48:33,371  INFO: Checking whether the versions of the Solr cores are supported
MainProcess 2021-08-30 16:48:33,378  DEBUG: instrument: version 1.5 matches 1.5
MainProcess 2021-08-30 16:48:33,543  INFO: Importing instrument...
MainProcess 2021-08-30 16:48:33,559  DEBUG: Setting up a connection to http://search:8983/solr
MainProcess 2021-08-30 16:48:33,559  DEBUG: Pinging http://search:8983/solr/instrument/admin/ping
MainProcess 2021-08-30 16:48:33,567  DEBUG: Connection to the Solr core at http://search:8983/solr/instrument
PoolWorker-1 2021-08-30 16:48:33,619  DEBUG: Importing <class 'sir.schema.modelext.CustomInstrument'> (1, None)
PoolWorker-1 2021-08-30 16:48:33,620  DEBUG: search_entity.model <class 'sir.schema.modelext.CustomInstrument'>
PoolWorker-1 2021-08-30 16:48:33,623  DEBUG: condition is musicbrainz.instrument.id >= :id_1
PoolWorker-1 2021-08-30 16:48:33,624  DEBUG: entity name is instrument
PoolWorker-1 2021-08-30 16:48:33,625  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:48:33,626  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:48:33,626  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:48:33,627  DEBUG: Loading only ['count', 'tag', 'instrument'] on <class 'mbdata.models.InstrumentTag'>
PoolWorker-1 2021-08-30 16:48:33,627  DEBUG: Loading only ['name', 'id'] on <class 'mbdata.models.Tag'>
PoolWorker-1 2021-08-30 16:48:33,627  DEBUG: Loading only ['gid', 'name', 'id'] on <class 'mbdata.models.InstrumentType'>
PoolWorker-1 2021-08-30 16:48:33,628  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:48:33,628  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:48:33,628  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:48:33,628  DEBUG: Loading only ['gid', 'name', 'id', 'id'] on <class 'mbdata.models.InstrumentAliasType'>
PoolWorker-1 2021-08-30 16:48:33,629  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:48:33,629  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:48:33,629  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:48:33,629  DEBUG: Loading only ['gid', 'name', 'id', 'id'] on <class 'mbdata.models.InstrumentAliasType'>
PoolWorker-1 2021-08-30 16:48:33,630  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:48:33,630  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:48:33,630  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:48:33,630  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:48:33,630  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:48:33,630  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:48:33,631  DEBUG: Loading only ['gid', 'name', 'id', 'id'] on <class 'mbdata.models.InstrumentAliasType'>
PoolWorker-1 2021-08-30 16:48:33,631  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:48:33,631  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:48:33,631  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:48:33,632  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:48:33,632  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:48:33,632  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:48:33,633  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:48:33,633  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:48:33,633  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:48:33,634  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:48:33,634  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:48:33,634  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:48:33,634  DEBUG: Loading only ['count', 'tag', 'instrument'] on <class 'mbdata.models.InstrumentTag'>
PoolWorker-1 2021-08-30 16:48:33,635  DEBUG: Loading only ['gid', 'name', 'id'] on <class 'mbdata.models.InstrumentType'>
PoolWorker-1 2021-08-30 16:48:33,672  ERROR: Failed to import instrument with id in bounds (1, None)
PoolWorker-1 2021-08-30 16:48:33,673  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 263, 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:48:33,676  ERROR: Failed to import instrument.
MainProcess 2021-08-30 16:48:33,676  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:48:33,752  DEBUG: <pysolr.Solr object at 0x7fce599e2e10>: Sending remaining data & stopping
Solr-1 2021-08-30 16:48:33,752  DEBUG: <pysolr.Solr object at 0x7fce599e2e10>: Sending remaining data & stopping
Solr-2 2021-08-30 16:48:33,753  DEBUG: <pysolr.Solr object at 0x7fce599e2e10>: Sending remaining data & stopping
Solr-3 2021-08-30 16:48:33,753  DEBUG: <pysolr.Solr object at 0x7fce599e2e10>: Sending remaining data & stopping
Solr-4 2021-08-30 16:48:33,754  DEBUG: <pysolr.Solr object at 0x7fce599e2e10>: Sending remaining data & stopping
Solr-5 2021-08-30 16:48:33,754  DEBUG: <pysolr.Solr object at 0x7fce599e2e10>: Sending remaining data & stopping
Solr-6 2021-08-30 16:48:33,754  DEBUG: <pysolr.Solr object at 0x7fce599e2e10>: Sending remaining data & stopping
Solr-7 2021-08-30 16:48:33,768  DEBUG: <pysolr.Solr object at 0x7fce599e2e10>: Sending remaining data & stopping
Solr-3 2021-08-30 16:48:33,777  DEBUG: Done sending data to Solr
Solr-3 2021-08-30 16:48:33,777  DEBUG: Sent data to Solr
Solr-3 2021-08-30 16:48:33,778  DEBUG: Committing changes to Solr
Solr-6 2021-08-30 16:48:33,778  DEBUG: Done sending data to Solr
Solr-6 2021-08-30 16:48:33,778  DEBUG: Sent data to Solr
Solr-6 2021-08-30 16:48:33,779  DEBUG: Committing changes to Solr
Solr-0 2021-08-30 16:48:33,777  DEBUG: Done sending data to Solr
Solr-4 2021-08-30 16:48:33,781  DEBUG: Done sending data to Solr
Solr-0 2021-08-30 16:48:33,781  DEBUG: Sent data to Solr
Solr-0 2021-08-30 16:48:33,781  DEBUG: Committing changes to Solr
Solr-4 2021-08-30 16:48:33,781  DEBUG: Sent data to Solr
Solr-4 2021-08-30 16:48:33,782  DEBUG: Committing changes to Solr
Solr-1 2021-08-30 16:48:33,784  DEBUG: Done sending data to Solr
Solr-1 2021-08-30 16:48:33,785  DEBUG: Sent data to Solr
Solr-1 2021-08-30 16:48:33,785  DEBUG: Committing changes to Solr
Solr-5 2021-08-30 16:48:33,786  DEBUG: Done sending data to Solr
Solr-5 2021-08-30 16:48:33,786  DEBUG: Sent data to Solr
Solr-5 2021-08-30 16:48:33,787  DEBUG: Committing changes to Solr
Solr-2 2021-08-30 16:48:33,791  DEBUG: Done sending data to Solr
Solr-2 2021-08-30 16:48:33,791  DEBUG: Sent data to Solr
Solr-2 2021-08-30 16:48:33,792  DEBUG: Committing changes to Solr
Solr-7 2021-08-30 16:48:33,793  DEBUG: Done sending data to Solr
Solr-7 2021-08-30 16:48:33,793  DEBUG: Sent data to Solr
Solr-7 2021-08-30 16:48:33,793  DEBUG: Committing changes to Solr