(please CC me on replies, I'm not subscribed to this list)
I didn't see a place to report dak issues on Salsa or the Dak wiki.d.o page, so let me know if there is a better place to report this.
Re-running my query resulted in normal results, but I thought it still might be useful to report this issue. Perhaps the retry can be automated.
---
$ ssh mirror.ftp-master.debian.org "dak rm -Rn entrypoints"
Will remove the following packages from unstable:
entrypoints | 0.4-2 | source
python3-entrypoints | 0.4-2 | all
Maintainer: Debian Python Team <team+python@tracker.debian.org>
------------------- Reason -------------------
----------------------------------------------
Checking reverse dependencies...
Traceback (most recent call last):
File "/usr/lib/python3/dist-packages/sqlalchemy/engine/base.py", line 1276, in _execute_context
self.dialect.do_execute(
File "/usr/lib/python3/dist-packages/sqlalchemy/engine/default.py", line 609, in do_execute
cursor.execute(statement, parameters)
psycopg2.errors.SerializationFailure: canceling statement due to conflict with recovery
DETAIL: User query might have needed to see row versions that must be removed.
The above exception was the direct cause of the following exception:
Traceback (most recent call last):
File "/usr/local/bin/dak", line 254, in <module>
main()
File "/usr/local/bin/dak", line 233, in main
module.main()
File "/srv/ftp-master.debian.org/dak/dak/rm.py", line 391, in main
reverse_depends_check(removals, suites[0], arches, session, include_arch_all=include_arch_all)
File "/srv/ftp-master.debian.org/dak/dak/rm.py", line 109, in reverse_depends_check
if utils.check_reverse_depends(removals, suite, arches, session, include_arch_all=include_arch_all):
File "/srv/ftp-master.debian.org/dak/daklib/utils.py", line 1065, in check_reverse_depends
for package, source, component, depends, provides in query:
File "/usr/lib/python3/dist-packages/sqlalchemy/orm/query.py", line 3535, in __iter__
return self._execute_and_instances(context)
File "/usr/lib/python3/dist-packages/sqlalchemy/orm/query.py", line 3560, in _execute_and_instances
result = conn.execute(querycontext.statement, self._params)
File "/usr/lib/python3/dist-packages/sqlalchemy/engine/base.py", line 1011, in execute
return meth(self, multiparams, params)
File "/usr/lib/python3/dist-packages/sqlalchemy/sql/elements.py", line 298, in _execute_on_connection
return connection._execute_clauseelement(self, multiparams, params)
File "/usr/lib/python3/dist-packages/sqlalchemy/engine/base.py", line 1124, in _execute_clauseelement
ret = self._execute_context(
File "/usr/lib/python3/dist-packages/sqlalchemy/engine/base.py", line 1316, in _execute_context
self._handle_dbapi_exception(
File "/usr/lib/python3/dist-packages/sqlalchemy/engine/base.py", line 1510, in _handle_dbapi_exception
util.raise_(
File "/usr/lib/python3/dist-packages/sqlalchemy/util/compat.py", line 182, in raise_
raise exception
File "/usr/lib/python3/dist-packages/sqlalchemy/engine/base.py", line 1276, in _execute_context
self.dialect.do_execute(
File "/usr/lib/python3/dist-packages/sqlalchemy/engine/default.py", line 609, in do_execute
cursor.execute(statement, parameters)
sqlalchemy.exc.OperationalError: (psycopg2.errors.SerializationFailure) canceling statement due to conflict with recovery
DETAIL: User query might have needed to see row versions that must be removed.
[SQL:
SELECT b.package, s.source, c.name as component,
(SELECT bmd.value FROM binaries_metadata bmd WHERE bmd.bin_id = b.id AND bmd.key_id = %(metakey_d_id)s) AS depends,
(SELECT bmp.value FROM binaries_metadata bmp WHERE bmp.bin_id = b.id AND bmp.key_id = %(metakey_p_id)s) AS provides
FROM binaries b
JOIN bin_associations ba ON b.id = ba.bin AND ba.suite = %(suite_id)s
JOIN source s ON b.source = s.id
JOIN files_archive_map af ON b.file = af.file_id
JOIN component c ON af.component_id = c.id
WHERE b.architecture = %(arch_id)s]
[parameters: {'metakey_d_id': 44, 'metakey_p_id': 51, 'suite_id': 5, 'arch_id': 30}]
(Background on this error at: http://sqlalche.me/e/13/e3q8)
---
--
Michael R. Crusoe
Attachment:
OpenPGP_signature.asc
Description: OpenPGP digital signature