Hi Grant,
I was trying your Django method but it fails in Satellite 6.10.2 .
# sudo -u pulp PULP_SETTINGS='/etc/pulp/settings.py' pulpcore-manager shell
<< EOF
from pulpcore.app.models.content import Content
minutes_since_touched = 1
print(Content.objects.orphaned(minutes_since_touched).all())
EOF
Traceback (most recent call last):
File "/bin/pulpcore-manager", line 11, in <module>
load_entry_point('pulpcore==3.14.9', 'console_scripts',
'pulpcore-manager')()
File "/usr/lib/python3.6/site-packages/pulpcore/app/manage.py", line 11,
in manage
execute_from_command_line(sys.argv)
File
"/usr/lib/python3.6/site-packages/django/core/management/__init__.py", line
381, in execute_from_command_line
utility.execute()
File
"/usr/lib/python3.6/site-packages/django/core/management/__init__.py", line
375, in execute
self.fetch_command(subcommand).run_from_argv(self.argv)
File "/usr/lib/python3.6/site-packages/django/core/management/base.py",
line 323, in run_from_argv
self.execute(*args, **cmd_options)
File "/usr/lib/python3.6/site-packages/django/core/management/base.py",
line 364, in execute
output = self.handle(*args, **options)
File
"/usr/lib/python3.6/site-packages/django/core/management/commands/shell.py",
line 92, in handle
exec(sys.stdin.read())
File "<string>", line 3, in <module>
AttributeError: 'ContentManagerFromBulkTouchQuerySet' object has no
attribute 'orphaned'
I definitely don't see *orphaned *inside *Content.objects*
>>> print(Content.objects.
Content.objects.aggregate( Content.objects.datetimes(
Content.objects.from_queryset( Content.objects.prefetch_related(
Content.objects.all( Content.objects.db
Content.objects.get( Content.objects.raw(
Content.objects.annotate( Content.objects.db_manager(
Content.objects.get_or_create( Content.objects.reverse(
Content.objects.auto_created Content.objects.deconstruct(
Content.objects.get_queryset( Content.objects.select_for_update(
Content.objects.bulk_create( Content.objects.defer(
Content.objects.in_bulk( Content.objects.select_related(
Content.objects.bulk_get_or_create( Content.objects.difference(
Content.objects.intersection( Content.objects.touch(
Content.objects.bulk_update( Content.objects.distinct(
Content.objects.iterator( Content.objects.union(
Content.objects.check( Content.objects.earliest(
Content.objects.last( Content.objects.update(
Content.objects.complex_filter( Content.objects.exclude(
Content.objects.latest( Content.objects.update_or_create(
Content.objects.contribute_to_class( Content.objects.exists(
Content.objects.model( Content.objects.use_in_migrations
Content.objects.count( Content.objects.explain(
Content.objects.name Content.objects.using(
Content.objects.create( Content.objects.extra(
Content.objects.none( Content.objects.values(
Content.objects.creation_counter Content.objects.filter(
Content.objects.only( Content.objects.values_list(
Content.objects.dates( Content.objects.first(
Content.objects.order_by(
My pulpcore version is 3.14.9. So Do I need to be on a higher version ?
Thanks & Regards,
Sayan das
*S*enior* T*echnical *S*upport *E*ngineer, RHCE
Red Hat India
<https://www.redhat.com/>
Red Hat India Pvt. Ltd, Level-5, Tower-10, Cyber City
Magarpatta City Hadapsar, Pune-411013, Maharashtra, India.
say...@redhat.com M: +91-7890892756 IRC: Sayan
<https://red.ht/sig>
On Mon, Jan 31, 2022 at 7:19 PM Sayan Das <say...@redhat.com> wrote:
> Hello Grant,
>
> Thanks for your quick response. I guess, mostly what would matter is the
> Type of Orphaned Content and the count of the same for each type.
>
> Pulp2 API and pulp-admin used to provide this nice summary and then for
> individual content types, There were endpoints available as well to see
> what are those contents.
>
> +----------------------------------------------------------------------+
> Summary
> +----------------------------------------------------------------------+
>
> Distribution: 0
> Docker Blob: 0
> Docker Image: 0
> Docker Manifest: 0
> Docker Manifest List: 0
> Docker Tag: 0
> Drpm: 0
> Erratum: 105
> Iso: 0
> Modulemd: 2
> Modulemd Defaults: 0
> Ostree: 0
> Package Category: 0
> Package Environment: 0
> Package Group: 0
> Package Langpacks: 0
> Puppet Module: 0
> Rpm: 700
> Srpm: 0
> Yum Repo Metadata File: 0
> Total: 807
>
>
> So, I guess, It makes sense to have something similar in Pulp3 as well.
>
> I will try out the method you have mentioned and see what else can be done
> with it.
>
>
> Thanks & Regards,
>
> Sayan das
>
> *S*enior* T*echnical *S*upport *E*ngineer, RHCE
>
> Red Hat India
> <https://www.redhat.com/>
>
> Red Hat India Pvt. Ltd, Level-5, Tower-10, Cyber City
>
> Magarpatta City Hadapsar, Pune-411013, Maharashtra, India.
>
> say...@redhat.com M: +91-7890892756 IRC: Sayan
> <https://red.ht/sig>
>
>
> On Mon, Jan 31, 2022 at 5:59 PM Grant Gainey <ggai...@redhat.com> wrote:
>
>> Hey Sayan,
>>
>> The following dumps all the Content-objects that are orphaned (ie, "not
>> assigned to a repository and not touched in the last
>> "minutes_since_touched" minutes). Needs some expansion, but that depends on
>> what you want to get out of it. Artifact checksums? Content "name"
>> (whatever that means)? UUIDs?
>>
>> $ pulpcore-manager shell
>> from pulpcore.app.models.content import Content
>> minutes_since_touched = 1
>> print(Content.objects.orphaned(minutes_since_touched).all())
>> <BulkTouchQuerySet [<Content (pulp_type=rpm.packagelangpacks):
>> pk=2aee273b-3c1d-493a-9849-5ea717076795>, <Content
>> (pulp_type=rpm.distribution_tree):
>> pk=7aa4d756-fb5b-4630-bfe6-9e9c4f7461ee>, <Content
>> (pulp_type=rpm.packagegroup): shark>, <Content
>> (pulp_type=rpm.packagecategory): all>, <Content
>> (pulp_type=rpm.packageenvironment): SharkEnvironment>]>
>>
>> G
>>
>> On Mon, Jan 31, 2022 at 3:33 AM Sayan Das <say...@redhat.com> wrote:
>>
>>> Hello All,
>>>
>>> I hope everyone is doing great.
>>>
>>> I am reaching out to the developers here as I wanted to find out *How I
>>> can list all orphan contents in Pulp 3* before deleting them?
>>>
>>> I have checked in Pulpcore API as well as Pulp cli but The only option I
>>> see is to remove the orphan contents directly.
>>>
>>> There are many situations where due to customer demand or our own
>>> understanding we may need to understand what all orphan data is present
>>> before we clear them up.
>>>
>>> Keeping that in mind, can anyone please suggest or confirm if we have
>>> any way to simply list the orphan content details in Pulp 3 similar to how
>>> we were able to do with Pulp 2?
>>>
>>>
>>>
>>> Thanks & Regards,
>>>
>>> Sayan das
>>>
>>> *S*enior* T*echnical *S*upport *E*ngineer, RHCE
>>>
>>> Red Hat India
>>> <https://www.redhat.com/>
>>>
>>> Red Hat India Pvt. Ltd, Level-5, Tower-10, Cyber City
>>>
>>> Magarpatta City Hadapsar, Pune-411013, Maharashtra, India.
>>>
>>> say...@redhat.com M: +91-7890892756 IRC: Sayan
>>> <https://red.ht/sig>
>>> _______________________________________________
>>> Pulp-dev mailing list
>>> Pulp-dev@redhat.com
>>> https://listman.redhat.com/mailman/listinfo/pulp-dev
>>>
>>
>>
>> --
>> Grant Gainey
>> Principal Software Engineer, Red Hat System Management Engineering
>>
>
_______________________________________________
Pulp-dev mailing list
Pulp-dev@redhat.com
https://listman.redhat.com/mailman/listinfo/pulp-dev
