FS#55068 - [SSH backend] attempt to disown a recently upload package lead to sql error

Attached to Project: AUR web interface
Opened by Pablo Lezaeta (Jristz) - Tuesday, 08 August 2017, 00:12 GMT
Last edited by Eli Schwartz (eschwartz) - Sunday, 05 November 2017, 10:05 GMT
Task Type Bug Report
Category Backend
Status Closed
Assigned To No-one
Architecture All
Severity High
Priority Normal
Reported Version 4.4.0
Due in Version 4.6.0
Due Date Undecided
Percent Complete 100%
Votes 2
Private No

Details

What happened?

I tryed to upload a package xfmedia and then use the ssh backend to disown leading to an error and no dissown.

TOSHIBA: $ ssh aur@aur.archlinux.org adopt xfmedia
TOSHIBA: $ ssh aur@aur.archlinux.org disown xfmedia
Traceback (most recent call last):
File "/usr/bin/aurweb-git-serve", line 11, in <module>
load_entry_point('aurweb==4.5.1', 'console_scripts', 'aurweb-git-serve')()
File "/usr/lib/python3.6/site-packages/aurweb-4.5.1-py3.6.egg/aurweb/git/serve.py", line 596, in main
File "/usr/lib/python3.6/site-packages/aurweb-4.5.1-py3.6.egg/aurweb/git/serve.py", line 532, in serve
File "/usr/lib/python3.6/site-packages/aurweb-4.5.1-py3.6.egg/aurweb/git/serve.py", line 238, in pkgbase_disown
File "/usr/lib/python3.6/site-packages/aurweb-4.5.1-py3.6.egg/aurweb/git/serve.py", line 195, in pkgreq_by_pkgbase
File "/usr/lib/python3.6/site-packages/aurweb-4.5.1-py3.6.egg/aurweb/db.py", line 43, in execute
File "/usr/lib/python3.6/site-packages/mysql/connector/cursor.py", line 559, in execute
self._handle_result(self._connection.cmd_query(stmt))
File "/usr/lib/python3.6/site-packages/mysql/connector/connection.py", line 494, in cmd_query
result = self._handle_result(self._send_cmd(ServerCmd.QUERY, query))
File "/usr/lib/python3.6/site-packages/mysql/connector/connection.py", line 396, in _handle_result
raise errors.get_exception(packet)
mysql.connector.errors.ProgrammingError: 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'RequestTypes.Name = 'orphan'' at line 1
TOSHIBA: $

I manage to reproduce it woth other packages under same sirscuntances.

So far I only manage to disown in the aur interface.
My guest is maybe the confirm present on the web is not present not have an equivalent on the cli?
This task depends upon

Closed by  Eli Schwartz (eschwartz)
Sunday, 05 November 2017, 10:05 GMT
Reason for closing:  Fixed
Additional comments about closing:  https://git.archlinux.org/aurweb.git/com mit/?id=624d168b22ef48b304d09c4ef8c58b78 dc061e92
Comment by Pablo Lezaeta (Jristz) - Wednesday, 16 August 2017, 00:48 GMT
I can confirm Ican reproduce it here anywhere anyhow anytime and everywhere with everypackage.
Comment by Eli Schwartz (eschwartz) - Wednesday, 16 August 2017, 01:02 GMT Comment by Pablo Lezaeta (Jristz) - Wednesday, 16 August 2017, 01:04 GMT
Thanks, but I only could test it when a new aurweb is released and published/aur updated for the newest version 4.5.2

or do you have a way to thest a aurweb snapshoot?
Comment by Eli Schwartz (eschwartz) - Wednesday, 16 August 2017, 03:03 GMT
There's no need for you to test it as lfleischer has already done so, but if you are interested in doing so anyway you will have to set up an aurweb development environment.
Comment by Daniel M. Capella (polyzen) - Wednesday, 16 August 2017, 03:13 GMT
I don't recall when this gets updated: https://aur-dev.archlinux.org/
Comment by Eli Schwartz (eschwartz) - Wednesday, 16 August 2017, 03:24 GMT
IIRC it gets updated whenever lfleischer feels personally motivated to update it for the specific purpose of testing out some specific change.

Loading...