Bug 1944812 - pulp3: Package matching query does not exist when syncing TimeScaleDB repo after migration
Summary: pulp3: Package matching query does not exist when syncing TimeScaleDB repo af...
Keywords:
Status: CLOSED ERRATA
Alias: None
Product: Red Hat Satellite
Classification: Red Hat
Component: Repositories
Version: 6.9.0
Hardware: Unspecified
OS: Unspecified
unspecified
high
Target Milestone: 6.9.1
Assignee: Ian Ballou
QA Contact: Tasos Papaioannou
URL:
Whiteboard:
Depends On:
Blocks:
TreeView+ depends on / blocked
 
Reported: 2021-03-30 17:36 UTC by Ian Ballou
Modified: 2021-04-26 17:37 UTC (History)
2 users (show)

Fixed In Version: tfm-rubygem-pulp_rpm_client-3.10.0, python-pulp-rpm-3.10.0,tfm-rubygem-katello-3.18.1.25-1
Doc Type: If docs needed, set a value
Doc Text:
Clone Of:
Environment:
Last Closed: 2021-04-26 17:36:58 UTC
Target Upstream Version:
Embargoed:


Attachments (Terms of Use)


Links
System ID Private Priority Status Summary Last Updated
Foreman Issue Tracker 32232 0 Normal New Package matching query does not exist when syncing TimeScaleDB repo after migration 2021-03-30 18:07:09 UTC
Foreman Issue Tracker 32301 0 Normal New Update pulp-rpm to 3.10.0 for Katello 3.18. 2021-04-12 20:28:48 UTC
Pulp Redmine 8052 0 None None None 2021-03-30 17:36:22 UTC
Red Hat Product Errata RHBA-2021:1371 0 None None None 2021-04-26 17:37:08 UTC

Description Ian Ballou 2021-03-30 17:36:22 UTC
Syncing https://packagecloud.io/timescale/timescaledb/el/7/x86_64 or https://packagecloud.io/timescale/timescaledb/el/8/x86_64 with Pulp 2 and then migrating causes the next sync to fail for those two repositories. Tested on Katello 3.18.1 and Katello 3.18.2.

---
pulp_tasks:
- pulp_href: "/pulp/api/v3/tasks/afed94a5-e893-4140-8712-85c248359961/"
  pulp_created: '2021-03-25T15:18:24.485+00:00'
  state: failed
  name: pulp_rpm.app.tasks.synchronizing.synchronize
  started_at: '2021-03-25T15:18:24.611+00:00'
  finished_at: '2021-03-25T15:18:28.367+00:00'
  error:
    traceback: |2
        File "/usr/lib/python3.6/site-packages/rq/worker.py", line 936, in perform_job
          rv = job.perform()
        File "/usr/lib/python3.6/site-packages/rq/job.py", line 684, in perform
          self._result = self._execute()
        File "/usr/lib/python3.6/site-packages/rq/job.py", line 690, in _execute
          return self.func(*self.args, **self.kwargs)
        File "/usr/lib/python3.6/site-packages/pulp_rpm/app/tasks/synchronizing.py", line 266, in synchronize
          dv.create()
        File "/usr/lib/python3.6/site-packages/pulpcore/plugin/stages/declarative_version.py", line 148, in create
          loop.run_until_complete(pipeline)
        File "/usr/lib64/python3.6/asyncio/base_events.py", line 484, in run_until_complete
          return future.result()
        File "/usr/lib/python3.6/site-packages/pulpcore/plugin/stages/api.py", line 225, in create_pipeline
          await asyncio.gather(*futures)
        File "/usr/lib/python3.6/site-packages/pulpcore/plugin/stages/api.py", line 43, in __call__
          await self.run()
        File "/usr/lib/python3.6/site-packages/pulpcore/plugin/stages/content_stages.py", line 105, in run
          d_content.content.q()
        File "/usr/lib/python3.6/site-packages/django/db/models/manager.py", line 82, in manager_method
          return getattr(self.get_queryset(), name)(*args, **kwargs)
        File "/usr/lib/python3.6/site-packages/django/db/models/query.py", line 408, in get
          self.model._meta.object_name
    description: Package matching query does not exist.
  worker: "/pulp/api/v3/workers/135dc424-94fb-4e18-9fc6-c6549530c8cd/"
  child_tasks: []
  progress_reports:
  - message: Parsed Packages
    code: parsing.packages
    state: completed
    total: 199
    done: 199
  - message: Downloading Metadata Files
    code: downloading.metadata
    state: completed
    done: 4
  - message: Downloading Artifacts
    code: downloading.artifacts
    state: completed
    done: 0
  - message: Associating Content
    code: associating.content
    state: canceled
    done: 0
  - message: Un-Associating Content
    code: unassociating.content
    state: canceled
    done: 0
  created_resources: []
  reserved_resources_record:
  - "/pulp/api/v3/repositories/rpm/rpm/15bb570c-705c-46e2-bae5-8e3b41cfb583/"
  - "/pulp/api/v3/remotes/rpm/rpm/6144e1fc-7b8e-489c-9517-46fd02472156/"
create_version: true
task_groups: []
poll_attempts:
  total: 6
  failed: 1

Comment 1 Ian Ballou 2021-03-30 17:39:05 UTC
This original bug that stopped some repositories from syncing on Katello 3.18.2 after migration is here: https://pulp.plan.io/issues/8452

This bug attached above is the actual cause of the issue.

Comment 2 Ian Ballou 2021-03-30 18:04:45 UTC
The issue is solved in pulp-rpm 3.10.  We need to upgrade Katello 3.18 to that version up from pulp-rpm 3.9.

Comment 3 Ian Ballou 2021-03-30 18:07:09 UTC
Created redmine issue https://projects.theforeman.org/issues/32232 from this bug

Comment 11 Tasos Papaioannou 2021-04-16 18:46:46 UTC
Verified on 6.9.1 snap 2.0.

Comment 16 errata-xmlrpc 2021-04-26 17:36:58 UTC
Since the problem described in this bug report should be
resolved in a recent advisory, it has been closed with a
resolution of ERRATA.

For information on the advisory (Satellite 6.9.1 Async Bug Fix Update), and where to find the updated
files, follow the link below.

If the solution does not work for you, open a new bug report.

https://access.redhat.com/errata/RHBA-2021:1371


Note You need to log in before you can comment on or make changes to this bug.