So I ran the script to delete all index files [delete-search-indexes all] and wanted to try to build the index files from scratch to see if that would work, but it didn’t. Before trying to generate the index files I changed the memory settings at the link referenced by the docker page and set the memory to both 4G and 16G but in both cases the same error got hit.
Bobcat (master) admin$ sudo docker-compose exec indexer python -m sir reindex
[sudo] password for stah0121:
2021-12-02 02:53:03,874: Checking whether the versions of the Solr cores are supported
2021-12-02 02:53:03,970: Importing annotation...
2021-12-02 02:56:47,294: Successfully imported annotation!
2021-12-02 02:56:49,806: Importing area...
2021-12-02 02:57:37,639: Successfully imported area!
2021-12-02 02:57:37,852: Importing artist...
2021-12-02 03:12:09,326: Successfully imported artist!
2021-12-02 03:12:09,553: Importing cdstub...
2021-12-02 03:15:11,058: Successfully imported cdstub!
2021-12-02 03:15:11,206: Importing editor...
2021-12-02 03:15:11,305: Successfully imported editor!
2021-12-02 03:15:11,387: Importing event...
2021-12-02 03:16:48,234: Successfully imported event!
2021-12-02 03:16:48,550: Importing instrument...
2021-12-02 03:16:53,114: Successfully imported instrument!
2021-12-02 03:16:53,614: Importing label...
2021-12-02 03:19:07,820: Successfully imported label!
2021-12-02 03:19:08,008: Importing place...
2021-12-02 03:20:04,947: Successfully imported place!
2021-12-02 03:20:05,128: Importing recording...
2021-12-02 03:23:22,293: Failed to import recording with id 156221
2021-12-02 03:23:22,298: (psycopg2.OperationalError) server closed the connection unexpectedly
This probably means the server terminated abnormally
before or while processing the request.
[SQL: 'SELECT musicbrainz.recording_first_release_date.recording AS musicbrainz_recording_first_release_date_recording, musicbrainz.recording_first_release_date.year AS musicbrainz_recording_first_release_date_year, musicbrainz.recording_first_release_date.month AS musicbrainz_recording_first_release_date_month, musicbrainz.recording_first_release_date.day AS musicbrainz_recording_first_release_date_day \nFROM musicbrainz.recording_first_release_date \nWHERE musicbrainz.recording_first_release_date.recording = %(param_1)s'] [parameters: {'param_1': 156221}]
Traceback (most recent call last):
File "sir/indexing.py", line 262, in _query_database
data_queue.put(row_converter(row))
File "sir/schema/searchentities.py", line 265, in query_result_to_dict
data["_store"] = tostring(self.compatconverter(obj).to_etree())
File "sir/wscompat/convert.py", line 1029, in convert_recording
if obj.first_release is not None and obj.first_release.date is not None:
File "/usr/local/lib/python2.7/site-packages/sqlalchemy/orm/attributes.py", line 237, in __get__
return self.impl.get(instance_state(instance), dict_)
File "/usr/local/lib/python2.7/site-packages/sqlalchemy/orm/attributes.py", line 583, in get
value = self.callable_(state, passive)
File "/usr/local/lib/python2.7/site-packages/sqlalchemy/orm/strategies.py", line 544, in _load_for_state
return self._emit_lazyload(session, state, ident_key, passive)
File "<string>", line 1, in <lambda>
File "/usr/local/lib/python2.7/site-packages/sqlalchemy/orm/strategies.py", line 588, in _emit_lazyload
return loading.load_on_ident(q, ident_key)
File "/usr/local/lib/python2.7/site-packages/sqlalchemy/orm/loading.py", line 219, in load_on_ident
return q.one()
File "/usr/local/lib/python2.7/site-packages/sqlalchemy/orm/query.py", line 2759, in one
ret = list(self)
File "/usr/local/lib/python2.7/site-packages/sqlalchemy/orm/query.py", line 2802, in __iter__
return self._execute_and_instances(context)
File "/usr/local/lib/python2.7/site-packages/sqlalchemy/orm/query.py", line 2817, in _execute_and_instances
result = conn.execute(querycontext.statement, self._params)
File "/usr/local/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 914, in execute
return meth(self, multiparams, params)
File "/usr/local/lib/python2.7/site-packages/sqlalchemy/sql/elements.py", line 323, in _execute_on_connection
return connection._execute_clauseelement(self, multiparams, params)
File "/usr/local/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 1010, in _execute_clauseelement
compiled_sql, distilled_params
File "/usr/local/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 1146, in _execute_context
context)
File "/usr/local/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 1341, in _handle_dbapi_exception
exc_info
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/engine/base.py", line 1139, in _execute_context
context)
File "/usr/local/lib/python2.7/site-packages/sqlalchemy/engine/default.py", line 450, in do_execute
cursor.execute(statement, parameters)
.
.
.
OperationalError: (psycopg2.OperationalError) FATAL: the database system is in recovery mode
2021-12-02 04:38:56,484: Failed to import recording with id in bounds (220891, 234738)
2021-12-02 04:38:56,484: (psycopg2.OperationalError) server closed the connection unexpectedly