Bug 484525

Summary: Repoview: column filename is not unique
Product: [Fedora] Fedora Reporter: Paulo Roma Cavalcanti <promac>
Component: repoviewAssignee: Konstantin Ryabitsev <icon>
Status: CLOSED NEXTRELEASE QA Contact: Fedora Extras Quality Assurance <extras-qa>
Severity: medium Docs Contact:
Priority: low    
Version: 10CC: icon, ron
Target Milestone: ---   
Target Release: ---   
Hardware: All   
OS: Linux   
Whiteboard:
Fixed In Version: 0.6.3-1.fc9 Doc Type: Bug Fix
Doc Text:
Story Points: ---
Clone Of: Environment:
Last Closed: 2009-04-14 15:55:03 UTC Type: ---
Regression: --- Mount Type: ---
Documentation: --- CRM:
Verified Versions: Category: ---
oVirt Team: --- RHEL 7.3 requirements from Atomic Host:
Cloudforms Team: --- Target Upstream Version:
Embargoed:

Description Paulo Roma Cavalcanti 2009-02-07 21:45:49 UTC
Description of problem:

repoview aborts with the following error:

sqlite3.IntegrityError: column filename is not unique

This did not happen with repoview 0.5.2

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

repoview 0.6.2 (repoview-0.6.2-1.fc9.noarch)

How reproducible:

Always, when there are rpms with the same name, even if they
use uppercase/lowercase letters, such as:

MuSE-0.9.2-2.fc8.x86_64.rpm
muse-0.9-2.fc8.ccrma.x86_64.rpm

Steps to Reproduce:
1./usr/bin/repoview -q -t "some title" "repo_path"
2.
3.
  
Actual results:

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


Expected results:

A clean output.

Additional info:

https://bugzilla.redhat.com/show_bug.cgi?id=300151

Please, try a small repo with only these rpms:

http://orion.lcg.ufrj.br/RPMS/ccrma/

Comment 1 Fedora Update System 2009-03-27 04:15:28 UTC
repoview-0.6.3-1.fc9 has been submitted as an update for Fedora 9.
http://admin.fedoraproject.org/updates/repoview-0.6.3-1.fc9

Comment 2 Fedora Update System 2009-03-27 04:15:33 UTC
repoview-0.6.3-1.fc10 has been submitted as an update for Fedora 10.
http://admin.fedoraproject.org/updates/repoview-0.6.3-1.fc10

Comment 3 Paulo Roma Cavalcanti 2009-03-27 10:22:51 UTC
Worked for me.

Thanks.

Comment 4 Fedora Update System 2009-03-27 14:51:25 UTC
repoview-0.6.3-1.fc10 has been pushed to the Fedora 10 testing repository.  If problems still persist, please make note of it in this bug report.
 If you want to test the update, you can install it with 
 su -c 'yum --enablerepo=updates-testing update repoview'.  You can provide feedback for this update here: http://admin.fedoraproject.org/updates/F10/FEDORA-2009-3088

Comment 5 Fedora Update System 2009-03-27 14:55:34 UTC
repoview-0.6.3-1.fc9 has been pushed to the Fedora 9 testing repository.  If problems still persist, please make note of it in this bug report.
 If you want to test the update, you can install it with 
 su -c 'yum --enablerepo=updates-testing-newkey update repoview'.  You can provide feedback for this update here: http://admin.fedoraproject.org/updates/F9/FEDORA-2009-3097

Comment 6 Fedora Update System 2009-04-14 15:54:59 UTC
repoview-0.6.3-1.fc10 has been pushed to the Fedora 10 stable repository.  If problems still persist, please make note of it in this bug report.

Comment 7 Fedora Update System 2009-04-14 15:57:35 UTC
repoview-0.6.3-1.fc9 has been pushed to the Fedora 9 stable repository.  If problems still persist, please make note of it in this bug report.

Comment 8 Rasmus Ory Nielsen 2009-10-13 06:28:27 UTC
Hi,

Please excuse me if this is not the right place.
I would like to suggest an update of repoview for epel5, which currently has 0.6.2-1.1.el5

Thanks.