Bug#1019380: UDD: import ports.d.o data to ports tables instead of derivatives tables
Control: close -1
On 24/12/22 at 16:58 +0800, Paul Wise wrote:
> Control: reopen -1
>
> On Sat, 2022-12-24 at 09:04 +0100, Lucas Nussbaum wrote:
>
> > OK, I imported ports to ports_* tables.
>
> Thanks, but they don't appear to have any data yet and
> the derivatives tables still have ports data in them.
>
> https://qa.debian.org/cgi-bin/madison.cgi?package=chromium-bsu&table=ports&a=&c=&s=#
> https://qa.debian.org/cgi-bin/madison.cgi?package=chromium-bsu&table=derivatives&a=&c=&s=#
>
> pabs@quantz:~$ PAGER=cat psql service=udd
> psql (11.18 (Debian 11.18-0+deb10u1), server 13.9 (Debian 13.9-0+deb11u1))
> WARNING: psql major version 11, server major version 13.
> Some psql features might not work.
> SSL connection (protocol: TLSv1.3, cipher: TLS_AES_256_GCM_SHA384, bits: 256, compression: off)
> Type "help" for help.
>
> udd=> select * from ports_sources limit 1;
> source | version | maintainer | maintainer_name | maintainer_email | format | files | uploaders | bin | architecture | standards_version | homepage | build_depends | build_depends_indep | build_conflicts | build_conflicts_indep | priority | section | distribution | release | component | vcs_type | vcs_url | vcs_browser | python_version | ruby_versions | checksums_sha1 | checksums_sha256 | original_maintainer | dm_upload_allowed | testsuite | autobuild | extra_source_only | build_depends_arch | build_conflicts_arch
> --------+---------+------------+-----------------+------------------+--------+-------+-----------+-----+--------------+-------------------+----------+---------------+---------------------+-----------------+-----------------------+----------+---------+--------------+---------+-----------+----------+---------+-------------+----------------+---------------+----------------+------------------+---------------------+-------------------+-----------+-----------+-------------------+--------------------+----------------------
> (0 rows)
>
> > I'm closing this bug, assuming you will track the rmadison change in a
> > separate one.
>
> I've added the ports table to madison.cgi:
>
> https://salsa.debian.org/qa/qa/commit/09765f3fa5b7a26c90c82f005593385afbe2220e
>
> Once the above issue is resolved I'll fix rmadison in devscripts.
It's OK now (and I cleaned up derivatives_* as well). I was a bit too
optimistic about the importer finishing, while it was stuck in a
transactionn.
Lucas
Reply to: