Mailinglist Archive: opensuse-bugs (7182 mails)

[bugzilla_noreply@xxxxxxxxxx]

https://bugzilla.novell.com/show_bug.cgi?id=355245


           Summary: Deleting a project with two path entries in the meta
                    data leads to MySql Error
           Product: openSUSE.org
           Version: unspecified
          Platform: x86-64
        OS/Version: SuSE Linux 10.1
            Status: NEW
          Severity: Normal
          Priority: P5 - None
         Component: BuildService
        AssignedTo: bnc-team-screening@xxxxxxxxxxxxxxxxxxxxxx
        ReportedBy: christopher.lang@xxxxxxxxxx
         QAContact: adrian@xxxxxxxxxx
          Found By: Other


When trying to delete a project that has two path entries as per:

http://en.opensuse.org/Build_Service/Tips_and_Tricks#Adding_multiple_repositories_to_a_project

the following Mysql Error happens:


Mysql::Error: Duplicate entry '32-1' for key 3: UPDATE path_elements SET
position = (position -1 ) WHERE (parent_id = 32 AND position >1)


Workaround: remove one path entry with command 'osc meta prj <projectname> -e'
then delete the project.


Example meta data that leads to this  error:

<project name="someproject:Factory">
  <title>someproject for Linux</title>
  <description></description>
  <person role="maintainer" userid="Admin" />
  <repository name="SUSE_Linux_10.1">
    <path project="SUSE:SL-10.1" repository="standard" />
    <path project="SUSE:SL-10.1:Tools" repository="standard" />
    <arch>i586</arch>
    <arch>x86_64</arch>
  </repository>
  <repository name="xUbuntu_7.04">
    <path project="Ubuntu:7.04" repository="standard" />
    <arch>i586</arch>
  </repository>
</project>


-- 
Configure bugmail: https://bugzilla.novell.com/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are on the CC list for the bug.