AUR web interface

Tasklist

FS#45254 - [AUR 4] push fails with IntegrityError: Duplicate entry for key 'NotifyUserIDPkgID'

Attached to Project: AUR web interface
Opened by Marti (intgr) - Monday, 08 June 2015, 09:36 GMT
Last edited by Lukas Fleischer (lfleischer) - Monday, 08 June 2015, 20:03 GMT
Task Type Bug Report
Category Backend
Status Closed
Assigned To Lukas Fleischer (lfleischer)
Architecture All
Severity Low
Priority Normal
Reported Version 3.5.0
Due in Version Undecided
Due Date Undecided
Percent Complete 100%
Votes 2
Private No

Details

When using the import-to-aur4.sh script provided at https://github.com/ido/packages-archlinux/blob/master/bin/import-to-aur4.sh , I saw a few packages fail with the following error:

Counting objects: 7, done.
Delta compression using up to 4 threads.
Compressing objects: 100% (7/7), done.
Writing objects: 100% (7/7), 1.83 KiB | 0 bytes/s, done.
Total 7 (delta 0), reused 1 (delta 0)
remote: Traceback (most recent call last):
remote: File "hooks/update", line 271, in <module>
remote: save_srcinfo(srcinfo, db, cur, user)
remote: File "hooks/update", line 148, in save_srcinfo
remote: "VALUES (%s, %s)", [pkgbase_id, user_id])
remote: File "/usr/lib/python3.4/site-packages/mysql/connector/cursor.py", line 507, in execute
remote: self._handle_result(self._connection.cmd_query(stmt))
remote: File "/usr/lib/python3.4/site-packages/mysql/connector/connection.py", line 722, in cmd_query
remote: result = self._handle_result(self._send_cmd(ServerCmd.QUERY, query))
remote: File "/usr/lib/python3.4/site-packages/mysql/connector/connection.py", line 640, in _handle_result
remote: raise errors.get_exception(packet)
remote: mysql.connector.errors.IntegrityError: 1062 (23000): Duplicate entry '17572-69805' for key 'NotifyUserIDPkgID'
remote: error: hook declined to update refs/heads/master
To ssh+git://aur@aur-dev.archlinux.org:/pypy-virtualenv.git/
! [remote rejected] aur4/pypy-virtualenv -> master (hook declined)


However, a second run was successful and did not produce this error.
This task depends upon

Closed by  Lukas Fleischer (lfleischer)
Monday, 08 June 2015, 20:03 GMT
Reason for closing:  Fixed
Additional comments about closing:  Fixed in 4.0.0-rc2.
Comment by Andrejs Mivreņiks (gim) - Monday, 08 June 2015, 11:04 GMT
I noticed this bug as well at the first push attempt for some packages, the second attempt went all right.

Loading...