[aur-dev] Can't update repo because source URL is too long

[Johannes Löthberg]

On 25/09, Andreas via aur-dev wrote:
>|remote: Traceback (most recent call last): remote: File "hooks/update",
>line 389, in <module> remote: save_metadata(metadata, conn, user)
>remote: File "hooks/update", line 135, in save_metadata remote: [pkgid,
>source_info['value'], source_info['arch']]) remote: File
>"/srv/http/vhosts/aur.archlinux.org/public/git-interface/db.py", line
>43, in execute remote: cur.execute(query, params) remote: File
>"/usr/lib/python3.5/site-packages/mysql/connector/cursor.py", line 515,
>in execute remote: self._handle_result(self._connection.cmd_query(stmt))
>remote: File
>"/usr/lib/python3.5/site-packages/mysql/connector/connection.py", line
>488, in cmd_query remote: result =
>self._handle_result(self._send_cmd(ServerCmd.QUERY, query)) remote: File
>"/usr/lib/python3.5/site-packages/mysql/connector/connection.py", line
>395, in _handle_result remote: raise errors.get_exception(packet)
>remote: mysql.connector.errors.DataError: 1406 (22001): Data too long
>for column 'Source' at row 1 remote: error: hook declined to update
>refs/heads/master To git+ssh://aur.archlinux.org/caddy-full-bin.git|
>
>It seems that the column that stores source URLs in the database is to
>small: `|Data too long for column 'Source' at row 1|`.
>Here is an example source URL from the `.SRCINFO`: `|source_i686 =
>caddy.tar.gz::https://caddyserver.com/download/build?os=linux&features=awslambda,cors,filemanager,git,hugo,ipfilter,jwt,locale,mailout,minify,multipass,prometheus,ratelimit,realip,search,upload,cloudflare,digitalocean,dnsimple,dyn,gandi,googlecloud,namecheap,rfc2136,route53,vultr&arch=386`|
>
>|Caddys buildserver requires to pass all those parameters, therfore I
>can't reduce the length of the URL.
>There is an archlinux forum thread for discussing this issue:
>https://bbs.archlinux.org/viewtopic.php?id=217364 .
>|
>

Hmm, seems the Source column is a 255 octet varchar.  The current RFCs 
recommend that at least 8000 octet long URIs are accepted, but in 
practice most things only support around 2000.

-- 
Sincerely,
  Johannes Löthberg
  PGP Key ID: 0x50FB9B273A9D0BB5
  https://theos.kyriasis.com/~kyrias/
-------------- next part --------------
A non-text attachment was scrubbed...
Name: signature.asc
Type: application/pgp-signature
Size: 1768 bytes
Desc: not available
URL: <https://lists.archlinux.org/pipermail/aur-dev/attachments/20160925/acba35f6/attachment.asc>