Package: qa.debian.org
Severity: normal
User: qa.debian....@packages.debian.org
Usertags: debsources
Some packages cannot be added to the Debsources DB due to violation of
the unique constraint in subject.
Here are the current 2 offender, from debsources.log on the machine
hosting sources.debian.net:
2014-10-18 22:29:57 updater:ERROR plugin hooks for add-package on
shinken/1.4.2-3 failed
2014-10-18 22:29:57 updater:ERROR failed to add shinken/1.4.2-3
Traceback (most recent call last):
File "/srv/debsources/debsources/updater.py", line 211, in _add_package
notify(conf, 'add-package', session, pkg, pkgdir, file_table)
File "/srv/debsources/debsources/updater.py", line 122, in notify
file_table=file_table)
File "/srv/debsources/debsources/updater.py", line 135, in notify_plugins
action(session, pkg, pkgdir, file_table)
File "/srv/debsources/debsources/plugins/hook_checksums.py", line 114, in
add_package
session.execute(insert_q, insert_params)
File "/usr/lib/python2.7/dist-packages/sqlalchemy/orm/session.py", line 802,
in execute
clause, params or {})
File "/usr/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 1449,
in execute
params)
File "/usr/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 1584,
in _execute_clauseelement
compiled_sql, distilled_params
File "/usr/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 1698,
in _execute_context
context)
File "/usr/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 1680,
in _execute_context
context)
File "/usr/lib/python2.7/dist-packages/sqlalchemy/engine/default.py", line
328, in do_executemany
cursor.executemany(statement, parameters)
IntegrityError: (IntegrityError) duplicate key value violates unique constraint
"checksums_package_id_file_id_key"
DETAIL: Key (package_id, file_id)=(126874, 90046831) already exists.
'INSERT INTO checksums (package_id, file_id, sha256) VALUES (%(package_id)s,
%(file_id)s, %(sha256)s)' ({'package_id': 126874, 'sha256':
'c5a9faf4689be0028bb8d5daa60e9be37cdd24a53bea8ce224fd1d5f078b7695', 'file_id':
90044182}, {'package_id': 126874, 'sha256':
'2198e3cce9c1559864d101f500143c3bab05672c6cb1ef3f6b2cd64b2e11e194', 'file_id':
90044542}, {'package_id': 126874, 'sha256':
'24e371cf8ba52ce17c329f4100263f8e459e8048cf8ca73f35df5dfa2d36715a', 'file_id':
90044533}, {'package_id': 126874, 'sha256':
'be51cb3d5bb127cd2919d17e8585abe1585a0f4403ff83a55507579f6b16b42a', 'file_id':
90047153}, {'package_id': 126874, 'sha256':
'aab284a9765e95d92e52165f8d18cfbe206651c726a4843b9820b0cb952bda98', 'file_id':
90045039}, {'package_id': 126874, 'sha256':
'e05b1de9220f1b04490c31be71562cd63e97682285ebe56d01cf672503ab4f58', 'file_id':
90043347}, {'package_id': 126874, 'sha256':
'2f4d70bac5bc84f4d50b459303e949c16f4f57d5497b64d9ea417a531e9eb15a', 'file_id':
90045569}, {'package_id': 126874, 'sha256':
'89716f728b8df8431cc077ff1b56dd2276faa75d7594a74ffade1fdbbc3ce7e2', 'file_id':
90046203} ... displaying 10 of 4226 total bound parameter sets ...
{'package_id': 126874, 'sha256':
'5e19bb5502e896b86d4132af9fce430c94ec8b66dcd3ff71e986c7d8ffcb15a7', 'file_id':
90045590}, {'package_id': 126874, 'sha256':
'950691d36b0228b800cf21b451bca2a9e1b6cd3993c37b4e7d1c1939047ef3bd', 'file_id':
90044703})
2014-10-19 03:53:44 updater:ERROR plugin hooks for add-package on weboob/0.j-1
failed
2014-10-19 03:53:44 updater:ERROR failed to add weboob/0.j-1
Traceback (most recent call last):
File "/srv/debsources/debsources/updater.py", line 211, in _add_package
notify(conf, 'add-package', session, pkg, pkgdir, file_table)
File "/srv/debsources/debsources/updater.py", line 122, in notify
file_table=file_table)
File "/srv/debsources/debsources/updater.py", line 135, in notify_plugins
action(session, pkg, pkgdir, file_table)
File "/srv/debsources/debsources/plugins/hook_checksums.py", line 114, in
add_package
session.execute(insert_q, insert_params)
File "/usr/lib/python2.7/dist-packages/sqlalchemy/orm/session.py", line 802,
in execute
clause, params or {})
File "/usr/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 1449,
in execute
params)
File "/usr/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 1584,
in _execute_clauseelement
compiled_sql, distilled_params
File "/usr/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 1698,
in _execute_context
context)
File "/usr/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 1680,
in _execute_context
context)
File "/usr/lib/python2.7/dist-packages/sqlalchemy/engine/default.py", line
328, in do_executemany
cursor.executemany(statement, parameters)
IntegrityError: (IntegrityError) duplicate key value violates unique constraint
"checksums_package_id_file_id_key"
DETAIL: Key (package_id, file_id)=(126917, 90065484) already exists.
'INSERT INTO checksums (package_id, file_id, sha256) VALUES (%(package_id)s,
%(file_id)s, %(sha256)s)' ({'package_id': 126917, 'sha256':
'e597e48c3e34fe55f691c37b242878359adc6cf0fc4e3975ba1da4d337cdde1b', 'file_id':
90064279}, {'package_id': 126917, 'sha256':
'463102c84ee04b7ec0440d70ac9d19577fda8c3aba4be9570dad579ca96093c3', 'file_id':
90064644}, {'package_id': 126917, 'sha256':
'2dcba9b0fb35392d0a9bd409b384dde4d7bbfbe0daebb2b4c3c6724e425aee6b', 'file_id':
90065146}, {'package_id': 126917, 'sha256':
'e3b0c44298fc1c149afbf4c8996fb92427ae41e4649b934ca495991b7852b855', 'file_id':
90064601}, {'package_id': 126917, 'sha256':
'62a06ccf22bb11781d5eb74c74534b4e0b62d3332b61aa2dce18f08c1f3fd71a', 'file_id':
90064732}, {'package_id': 126917, 'sha256':
'9c537b9226813b11896f613bb3f30bd37db3c2790cd03c19c37e31ba92fd8c6b', 'file_id':
90065070}, {'package_id': 126917, 'sha256':
'a6eaa9387b17d563dcff30de6cd0a5cf3e4dd19ba1206ad9db81ddb080a76eea', 'file_id':
90065144}, {'package_id': 126917, 'sha256':
'561f48408cc6ba43d2236c7dfc29bc13790a44c5bac6227f263e15cca6bb95e2', 'file_id':
90064087} ... displaying 10 of 1605 total bound parameter sets ...
{'package_id': 126917, 'sha256':
'ac26b2846eeb8648b26046c7478d468e957057cbcc42f96cc9e73f90d981a9bb', 'file_id':
90064648}, {'package_id': 126917, 'sha256':
'adbbc5a0ff93cb98ec8ede480385175ddc6d64f6509b9b53aa537bbe689bebc8', 'file_id':
90064901})
-- System Information:
Debian Release: jessie/sid
APT prefers testing
APT policy: (500, 'testing'), (1, 'experimental')
Architecture: amd64 (x86_64)
Foreign Architectures: i386
Kernel: Linux 3.16-2-amd64 (SMP w/4 CPU cores)
Locale: LANG=en_US.UTF-8, LC_CTYPE=en_US.UTF-8 (charmap=UTF-8)
Shell: /bin/sh linked to /bin/dash
--
To UNSUBSCRIBE, email to debian-bugs-dist-requ...@lists.debian.org
with a subject of "unsubscribe". Trouble? Contact listmas...@lists.debian.org
