Hello!
I use Katello for a while and noticed that the space occupied by the
packages in /var/lib/pulp is constantly growing.The task of cleaning up
orphaned packages is performed regularly, however, no packet removal occurs.
Katello shows that the packages are not included in any repository:
>psql -c "select a.id,a.uuid,a.filename,count(b.id),max(c.name) from
katello_rpms a left outer join katello_repository_rpms b on
a.id=b.rpm_id left outer join katello_repositories c on
b.repository_id=c.id where a.name='zlib' group by 1,2,3 order by 3"
foreman>>
>> id | uuid | filename | count
> max ||
>>-------±-------------------------------------±-----------------------------±------±--------------------------||
>> 9993 | 42a4a2ef-862c-4d9d-bbfd-d8648e85a8e8 |
zlib-1.2.7-15.el7.i686.rpm | 0 | ||
>> 10060 | e4f8f88a-cd38-4494-b8ee-4016f3fe817a |
zlib-1.2.7-15.el7.x86_64.rpm | 0 | ||
>> 45509 | 7bc8c94c-10c8-4d6d-b4db-072d875ff220 |
zlib-1.2.7-17.el7.i686.rpm | 20 | centos 7.3.1611 os x86_64||
>> 44513 | 2fd62f54-8324-426e-ae68-70bce16315ed |
zlib-1.2.7-17.el7.x86_64.rpm | 20 | centos 7.3.1611 os x86_64||
>>(4 rows)|
but in the Pulp database these packages are included in the already
deleted repository
>> db.repo_content_units.find({unit_id:
'42a4a2ef-862c-4d9d-bbfd-d8648e85a8e8'})||
>>{ "_id" : ObjectId("58352c47bc4a271f847a3758"), "repo_id" :
"MyOrg-MyCV-10_0-CentOS_7_2-centos_7_2_1511_os_x86_64", "unit_id" :
"42a4a2ef-862c-4d9d-bbfd-d8648e85a8e8", "unit_type_id" : "rpm",
"updated" : "2016-11-23T05:42:31Z", "created" : "2016-11-23T05:42:31Z" }||
>>> db.repo_content_units.find({unit_id:
'e4f8f88a-cd38-4494-b8ee-4016f3fe817a'})||
>>{ "_id" : ObjectId("58352c7cbc4a271f847a4e19"), "repo_id" :
"MyOrg-MyCV-10_0-CentOS_7_2-centos_7_2_1511_os_x86_64", "unit_id" :
"e4f8f88a-cd38-4494-b8ee-4016f3fe817a", "unit_type_id" : "rpm",
"updated" : "2016-11-23T05:43:24Z", "created" : "2016-11-23T05:43:24Z" }||
>
For this reason, there is no removal of orphaned packages. How can I
correct the situation most correctly?