Bug 1159040

Summary:	--generate-sqlite breaks yum groups
Product:	[Retired] Pulp	Reporter:	Justin Garrison <justin.garrison>
Component:	rpm-support	Assignee:	Barnaby Court <bcourt>
Status:	CLOSED CURRENTRELEASE	QA Contact:	Preethi Thomas <pthomas>
Severity:	medium	Docs Contact:
Priority:	high
Version:	2.4.2	CC:	bcourt, cduryee, dkliban, jortel, pthomas, rbarlow
Target Milestone:	---	Keywords:	Triaged
Target Release:	2.5.2
Hardware:	Unspecified
OS:	Unspecified
Whiteboard:
Fixed In Version:		Doc Type:	Bug Fix
Doc Text:		Story Points:	---
Clone Of:		Environment:
Last Closed:	2015-02-05 21:47:04 UTC	Type:	Bug
Regression:	---	Mount Type:	---
Documentation:	---	CRM:
Verified Versions:		Category:	---
oVirt Team:	---	RHEL 7.3 requirements from Atomic Host:
Cloudforms Team:	---	Target Upstream Version:
Embargoed:

Description Justin Garrison 2014-10-30 18:12:57 UTC

Description of problem: After enabling generating sqlite information for many repos and republishing yum grouplist gives the error "Error: No group data available for configured repositories"


Version-Release number of selected component (if applicable): 2.4.3


How reproducible: Every time


Steps to Reproduce:
1. Create repo with --generate-sqlite=true
2. Publish to http and set up client repo with url
3. run yum grouplist

Actual results: No groups found on client


Expected results: Groups should work as they do with sqlite=false


Additional info:
comps.xml exists in both cases but is not being used when sqlite data is present.

Comment 1 Barnaby Court 2014-12-15 15:40:32 UTC

This is fixed by: https://github.com/pulp/pulp_rpm/pull/610

Comment 2 Randy Barlow 2014-12-22 15:56:37 UTC

This issue was actually fixed by https://github.com/pulp/pulp_rpm/pull/613.

Comment 3 Preethi Thomas 2015-01-12 15:36:59 UTC

Fails-qa

[root@cloud-qe-22 yum.repos.d]# cat /etc/redhat-release 
Red Hat Enterprise Linux Server release 6.6 (Santiago)
[root@cloud-qe-22 yum.repos.d]# 


On rhel6 server & client



Created a repo with rhel6 feed and synced


on the client

[root@ivanova ~]# yum grouplist --disablerepo="*" --enablerepo="rhel6"
Loaded plugins: product-id, pulp-profile-update, security, subscription-manager
This system is not registered to Red Hat Subscription Management. You can use subscription-manager to register.
Setting up Group Process
rhel6/group                                              | 1.0 MB     00:00     
Installed Groups:
   Additional Development
   Base
   Compatibility libraries
   Development tools
   E-mail server
   Emacs
   Graphical Administration Tools
   Hardware monitoring utilities
   Japanese Support
   Korean Support
   Legacy UNIX compatibility
   Legacy X Window System compatibility
   Network file system client
   Networking Tools
   Performance Tools
   Perl Support
   Ruby Support
   Security Tools
   Server Platform
   Server Platform Development
   System administration tools
Available Groups:
   Afrikaans Support
   Albanian Support
   Amazigh Support
   Arabic Support
   Armenian Support
   Assamese Support
   Azerbaijani Support
   Backup Client
   Backup Server
   Basque Support
   Belarusian Support
   Bengali Support
   Bhutanese Support
   Brazilian Portuguese Support
   Breton Support
   Bulgarian Support
   CIFS file server
   Catalan Support
   Chhattisgarhi Support
   Chichewa Support
   Chinese Support
   Client management tools
   Console internet tools
   Coptic Support
   Croatian Support
   Czech Support
   Danish Support
   Debugging Tools
   Desktop
   Desktop Debugging and Performance Tools
   Desktop Platform
   Desktop Platform Development
   Dial-up Networking Support
   Directory Client
   Directory Server
   Dutch Support
   Eclipse
   English (UK) Support
   Esperanto Support
   Estonian Support
   Ethiopic Support
   FCoE Storage Client
   FTP server
   Faroese Support
   Fijian Support
   Filipino Support
   Finnish Support
   Fonts
   French Support
   Frisian Support
   Friulian Support
   Gaelic Support
   Galician Support
   General Purpose Desktop
   Georgian Support
   German Support
   Graphics Creation Tools
   Greek Support
   Guest Agents
   Gujarati Support
   Hebrew Support
   Hiligaynon Support
   Hindi Support
   Hungarian Support
   Icelandic Support
   Identity Management Server
   Indonesian Support
   Infiniband Support
   Input Methods
   Interlingua Support
   Internet Browser
   Inuktitut Support
   Irish Support
   Italian Support
   Java Platform
   KDE Desktop
   Kannada Support
   Kashmiri Support
   Kashubian Support
   Kazakh Support
   Khmer Support
   Kinyarwanda Support
   Konkani Support
   Kurdish Support
   Lao Support
   Large Systems Performance
   Latin Support
   Latvian Support
   Lithuanian Support
   Low Saxon Support
   Luxembourgish Support
   Macedonian Support
   Mainframe Access
   Maithili Support
   Malagasy Support
   Malay Support
   Malayalam Support
   Maltese Support
   Manx Support
   Maori Support
   Marathi Support
   Messaging Client Support
   Mongolian Support
   MySQL Database client
   MySQL Database server
   Myanmar (Burmese) Support
   NFS file server
   Nepali Support
   Network Infrastructure Server
   Network Storage Server
   Northern Sotho Support
   Norwegian Support
   Occitan Support
   Oriya Support
   PHP Support
   Persian Support
   Polish Support
   Portuguese Support
   PostgreSQL Database client
   PostgreSQL Database server
   Print Server
   Printing client
   Punjabi Support
   Remote Desktop Clients
   Romanian Support
   Russian Support
   SNMP Support
   Sanskrit Support
   Sardinian Support
   Scientific support
   Serbian Support
   Sindhi Support
   Sinhala Support
   Slovak Support
   Slovenian Support
   Smart card support
   Somali Support
   Southern Ndebele Support
   Southern Sotho Support
   Spanish Support
   Storage Availability Tools
   Swahili Support
   Swati Support
   Swedish Support
   System Management
   Tagalog Support
   Tajik Support
   Tamil Support
   TeX support
   Technical Writing
   Telugu Support
   Tetum Support
   Thai Support
   Tibetan Support
   Tsonga Support
   Tswana Support
   TurboGears application framework
   Turkish Support
   Turkmen Support
   Ukrainian Support
   Upper Sorbian Support
   Urdu Support
   Uzbek Support
   Venda Support
   Vietnamese Support
   Virtualization
   Virtualization Client
   Virtualization Platform
   Virtualization Tools
   Walloon Support
   Web Server
   Web Servlet Engine
   Web-Based Enterprise Management
   Welsh Support
   X Window System
   Xhosa Support
   Zulu Support
   iSCSI Storage Client
Done
[root@ivanova ~]# 


Now I did

root@cloud-qe-22 yum.repos.d]# pulp-admin rpm repo update --repo-id rhel6 --generate-sqlite true
This command may be exited via ctrl+c without affecting the request.


[\]
Running...
Updating distributor: yum_distributor

Task Succeeded



[\]
Running...
Updating distributor: export_distributor

Task Succeeded



[\]
Running...

Task Succeeded


[root@cloud-qe-22 yum.repos.d]# 
[root@cloud-qe-22 yum.repos.d]# 
[root@cloud-qe-22 yum.repos.d]# 
[root@cloud-qe-22 yum.repos.d]# pulp-admin rpm repo sync run -repo-id rhel6
Command: run
Description: triggers an immediate sync of a repository

Available Arguments:

  --bg      - if specified, the client process will end immediately (the task
              will continue to run on the server)
  --repo-id - (required) unique identifier; only alphanumeric, ., -, and _
              allowed
The following options were specified but do not exist on the command:
  -r
[root@cloud-qe-22 yum.repos.d]# pulp-admin rpm repo sync run --repo-id rhel6
+----------------------------------------------------------------------+
                    Synchronizing Repository [rhel6]
+----------------------------------------------------------------------+

This command may be exited via ctrl+c without affecting the request.


Downloading metadata...
[\]
... completed

Downloading repository content...
[==================================================] 100%
RPMs:       0/0 items
Delta RPMs: 0/0 items

... completed

Downloading distribution files...
[==================================================] 100%
Distributions: 0/0 items
... completed

Importing errata...
[-]
... completed

Importing package groups/categories...
[\]
... completed


Task Succeeded



Copying files
[\]
... completed

Initializing repo metadata
[-]
... completed

Publishing Distribution files
[-]
... completed

Publishing RPMs
[                                                  ] 0%
0 of 5235 items
... completed

Publishing Delta RPMs
... skipped

Publishing Errata
[==================================================] 100%
2822 of 2822 items
... completed

Publishing Comps file
[==================================================] 100%
212 of 212 items
... completed

Publishing Metadata.
[-]
... completed

Closing repo metadata
[-]
... completed

Generating sqlite files
[\]
... completed

Publishing files to web
[|]
... completed

Writing Listings File
[-]
... completed


Task Succeeded


[root@ivanova ~]# yum grouplist --disablerepo="*" --enablerepo="rhel6"
Loaded plugins: product-id, pulp-profile-update, security, subscription-manager
This system is not registered to Red Hat Subscription Management. You can use subscription-manager to register.
Setting up Group Process
rhel6                                                    | 3.0 kB     00:00     
rhel6/primary_db                                         |  35 MB     00:01     
Error: No group data available for configured repositories

Comment 4 Barnaby Court 2015-01-12 22:06:36 UTC

https://github.com/pulp/pulp_rpm/pull/632

Comment 5 Preethi Thomas 2015-01-15 16:00:06 UTC

verified
[root@rhsm-jenkins ~]# rpm -qa pulp-server
pulp-server-2.5.2-0.3.beta.el6.noarch
[root@rhsm-jenkins ~]# 

After updating the repo with  --generate-sqlite true  republished the repo. 

Then ran  yum grouplist on the client. It should the repo groups

Comment 6 Randy Barlow 2015-02-05 21:47:04 UTC

Pulp 2.5.2 has been released.