Bug 300151

Summary: repoview traceback when trying to run as part of rawhide compose
Product: [Fedora] Fedora Reporter: Jesse Keating <jkeating>
Component: repoviewAssignee: Konstantin Ryabitsev <icon>
Status: CLOSED CURRENTRELEASE QA Contact: Fedora Extras Quality Assurance <extras-qa>
Severity: low Docs Contact:
Priority: low    
Version: rawhideCC: dcantrell, joe.christy, orion, trevin
Target Milestone: ---Keywords: Reopened
Target Release: ---   
Hardware: All   
OS: Linux   
Whiteboard:
Fixed In Version: 0.6.2-1.fc8 Doc Type: Bug Fix
Doc Text:
Story Points: ---
Clone Of: Environment:
Last Closed: 2008-02-18 22:15:45 EST Type: ---
Regression: --- Mount Type: ---
Documentation: --- CRM:
Verified Versions: Category: ---
oVirt Team: --- RHEL 7.3 requirements from Atomic Host:
Bug Depends On:    
Bug Blocks: 235704    
Attachments:
Description Flags
primary.sqlite.bz2 for my mirror of the Livna F8/i386 repo
none
other.sqlite.bz2 for my mirror of the Livna F8/i386 repo none

Description Jesse Keating 2007-09-21 08:08:49 EDT
We've recently enabled repoview as part of the rawhide compose.  Unfortunately
it promptly tracebacked and killed the compose :/

Traceback (most recent call last):
  File "/usr/bin/repoview", line 905, in <module>
    main()
  File "/usr/bin/repoview", line 902, in main
    Repoview(opts)
  File "/usr/bin/repoview", line 201, in __init__
    if self.has_changed(grp_filename, checksum):
  File "/usr/bin/repoview", line 592, in has_changed
    scursor.execute(query)
sqlite3.IntegrityError: column filename is not unique

http://koji.fedoraproject.org/mash/repoview-crash/rawhide-20070921/development/source/SRPMS/repoview/
 appears to be the failed run, the repodata content is in SRPMS/ itself.
Comment 1 Konstantin Ryabitsev 2007-09-21 10:14:03 EDT
How odd... I'll take a look.
Comment 2 Konstantin Ryabitsev 2007-09-27 11:47:55 EDT
Fixed in http://mricon.com/trac/changeset/374 and will be in the upcoming 0.6.1
shortly.
Comment 3 Orion Poplawski 2007-10-22 13:30:05 EDT
I still get this with 0.6.1-1.fc8:

Pungi.Pungi:INFO: Running /usr/bin/repoview --quiet --title Fedora development:
CoRA - i386 /export/development/CoRA/i386/os
Pungi.Pungi:ERROR: Got an error from /usr/bin/repoview
Pungi.Pungi:ERROR: Traceback (most recent call last):
  File "/usr/bin/repoview", line 918, in <module>
    main()
  File "/usr/bin/repoview", line 915, in main
    Repoview(opts)
  File "/usr/bin/repoview", line 201, in __init__
    if self.has_changed(grp_filename, checksum):
  File "/usr/bin/repoview", line 600, in has_changed
    scursor.execute(query)
sqlite3.IntegrityError: column filename is not unique
Comment 4 Jesse Keating 2007-10-22 14:13:58 EDT
Can you post your repo and configs somewhere?

I'm moving this off the Blocker list as it's no longer a blocker for F8.
Comment 5 Orion Poplawski 2007-10-22 15:32:40 EDT
The built tree is here: http://www.cora.nwra.com/~orion/fedora/os

Config is http://sw.cora.nwra.com/fedora/pungi/fdevel-cora.ks
Comment 6 Joe Christy 2007-12-30 13:30:18 EST
I see this when trying to run repoview on a mirror of the F8 i386 and x86_64
Livna repos, mirrored from:
rsync://fedora.cat.pdx.edu/rpm.livna.org-fedora/
Comment 7 Konstantin Ryabitsev 2008-01-02 13:40:48 EST
I really need primary.sqlite and other.sqlite in order to be able to
troubleshoot this. Can someone provide these?
Comment 8 Joe Christy 2008-01-11 12:43:46 EST
Created attachment 291403 [details]
primary.sqlite.bz2 for my mirror of the Livna F8/i386 repo
Comment 9 Joe Christy 2008-01-11 12:45:00 EST
Created attachment 291404 [details]
other.sqlite.bz2 for my mirror of the Livna F8/i386 repo
Comment 10 Konstantin Ryabitsev 2008-02-02 14:00:58 EST
Should be fixed in upcoming 0.6.2. See upstream
https://fedorahosted.org/repoview/ticket/4.
Comment 11 Fedora Update System 2008-02-02 14:40:08 EST
repoview-0.6.2-1.fc8 has been submitted as an update for Fedora 8
Comment 12 Fedora Update System 2008-02-18 22:15:42 EST
repoview-0.6.2-1.fc8 has been pushed to the Fedora 8 stable repository.  If problems still persist, please make note of it in this bug report.
Comment 13 Trevin Beattie 2009-02-13 22:16:32 EST
I've just encountered this bug when trying to create a repoview for the Fedora 10 "Everything" repository.  I downloaded all of the files from http://download.fedora.redhat.com/pub/fedora/linux/releases/10/Everything/i386/os/repodata/ and installed repoview-0.6.2-1.fc9.noarch.rpm from the same location.  When I run repoview, it gets most of the way through but after nine thousand packages I get the error:

Writing package php-pear-auth-sasl.html
Traceback (most recent call last):
  File "/usr/bin/repoview", line 926, in <module>
    main()
  File "/usr/bin/repoview", line 923, in main
    Repoview(opts)
  File "/usr/bin/repoview", line 191, in __init__
    packages = self.do_packages(repo_data, group_data, pkgnames)
  File "/usr/bin/repoview", line 554, in do_packages
    if self.has_changed(pkg_filename, checksum):
  File "/usr/bin/repoview", line 607, in has_changed
    scursor.execute(query)
sqlite3.IntegrityError: column filename is not unique

I was able to create a repoview for the base packages (http://download.fedora.redhat.com/pub/fedora/linux/releases/10/Fedora/i386/os/repodata/) without any errors.