Warnings and errors: wd_categories JSON

Below is an overview of all parsing and processing issues that appeared while importing the data.

Go back to the global issues overview or view the dataset page.

Issue #90bf4f29e19f4b7cc9ee18b69498db46fefe36d9: nomenklatura.cache

Error while saving to cache: (psycopg2.errors.DeadlockDetected) deadlock detected DETAIL: Process 2501880 waits for ShareLock on transaction 528326596; blocked by process 2508468. Process 2508468 waits for ShareLock on transaction 528326604; blocked by process 2501880. HINT: See server log for query details. CONTEXT: while inserting index tuple (147767,2) in relation "cache" [SQL: INSERT INTO cache (key, text, dataset, timestamp) VALUES (%(key)s, %(text)s, %(dataset)s, %(timestamp)s) ON CONFLICT (key) DO UPDATE SET text = excluded.text, timestamp = excluded.timestamp] [parameters: {'key': 'https://www.wikidata.org/w/api.php?action=wbgetentities&format=json&ids=Q707374', 'text': '{"entities":{"Q707374":{"pageid":665380,"ns":0,"title":"Q707374","lastrevid":2355181006,"modified":"2025-05-31T15:29:53Z","type":"item","id":"Q707374 ... (49527 characters truncated) ... owiki":{"site":"nowiki","title":"Per H\\u00e6kkerup","badges":[]},"svwiki":{"site":"svwiki","title":"Per H\\u00e6kkerup","badges":[]}}}},"success":1}', 'dataset': 'wd_categories', 'timestamp': datetime.datetime(2025, 6, 16, 1, 58, 15, 422242)}] (Background on this error at: https://sqlalche.me/e/20/e3q8)

_from_structlog	`false`
exception	Traceback (most recent call last): File "/venv/lib/python3.12/site-packages/sqlalchemy/engine/base.py", line 1963, in _exec_single_context self.dialect.do_execute( File "/venv/lib/python3.12/site-packages/sqlalchemy/engine/default.py", line 943, in do_execute cursor.execute(statement, parameters) psycopg2.errors.DeadlockDetected: deadlock detected DETAIL: Process 2501880 waits for ShareLock on transaction 528326596; blocked by process 2508468. Process 2508468 waits for ShareLock on transaction 528326604; blocked by process 2501880. HINT: See server log for query details. CONTEXT: while inserting index tuple (147767,2) in relation "cache" The above exception was the direct cause of the following exception: Traceback (most recent call last): File "/venv/lib/python3.12/site-packages/nomenklatura/cache.py", line 80, in set self.conn.execute(stmt) File "/venv/lib/python3.12/site-packages/sqlalchemy/engine/base.py", line 1415, in execute return meth( ^^^^^ File "/venv/lib/python3.12/site-packages/sqlalchemy/sql/elements.py", line 523, in _execute_on_connection return connection._execute_clauseelement( ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ File "/venv/lib/python3.12/site-packages/sqlalchemy/engine/base.py", line 1637, in _execute_clauseelement ret = self._execute_context( ^^^^^^^^^^^^^^^^^^^^^^ File "/venv/lib/python3.12/site-packages/sqlalchemy/engine/base.py", line 1842, in _execute_context return self._exec_single_context( ^^^^^^^^^^^^^^^^^^^^^^^^^^ File "/venv/lib/python3.12/site-packages/sqlalchemy/engine/base.py", line 1982, in _exec_single_context self._handle_dbapi_exception( File "/venv/lib/python3.12/site-packages/sqlalchemy/engine/base.py", line 2351, in _handle_dbapi_exception raise sqlalchemy_exception.with_traceback(exc_info[2]) from e File "/venv/lib/python3.12/site-packages/sqlalchemy/engine/base.py", line 1963, in _exec_single_context self.dialect.do_execute( File "/venv/lib/python3.12/site-packages/sqlalchemy/engine/default.py", line 943, in do_execute cursor.execute(statement, parameters) sqlalchemy.exc.OperationalError: (psycopg2.errors.DeadlockDetected) deadlock detected DETAIL: Process 2501880 waits for ShareLock on transaction 528326596; blocked by process 2508468. Process 2508468 waits for ShareLock on transaction 528326604; blocked by process 2501880. HINT: See server log for query details. CONTEXT: while inserting index tuple (147767,2) in relation "cache" [SQL: INSERT INTO cache (key, text, dataset, timestamp) VALUES (%(key)s, %(text)s, %(dataset)s, %(timestamp)s) ON CONFLICT (key) DO UPDATE SET text = excluded.text, timestamp = excluded.timestamp] [parameters: {'key': 'https://www.wikidata.org/w/api.php?action=wbgetentities&format=json&ids=Q707374', 'text': '{"entities":{"Q707374":{"pageid":665380,"ns":0,"title":"Q707374","lastrevid":2355181006,"modified":"2025-05-31T15:29:53Z","type":"item","id":"Q707374 ... (49527 characters truncated) ... owiki":{"site":"nowiki","title":"Per H\\u00e6kkerup","badges":[]},"svwiki":{"site":"svwiki","title":"Per H\\u00e6kkerup","badges":[]}}}},"success":1}', 'dataset': 'wd_categories', 'timestamp': datetime.datetime(2025, 6, 16, 1, 58, 15, 422242)}] (Background on this error at: https://sqlalche.me/e/20/e3q8)
dataset	`wd_categories`

error · 2025-06-16