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
