306587 - DB error attachments_submitter_id_idx running checksetup.pl

Status: RESOLVED WORKSFORME

(Bugzilla :: Installation & Upgrading, defect)

Description

[Ryan Adler]

User-Agent:       Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1; .NET CLR 1.1.4322; .NET CLR 2.0.50215)
Build Identifier: 

Installed 2.18.3, it was working without problems.  Made some users, products, 
categories, and bugs.
Did a CVS upgrade to 2.20RC2 tag, ran checksetup.pl.
Checksetup.pl bombed out with an error: 

Populating duplicates table...
Adding new index 'attachments_submitter_id_idx' to the attachments table ...
DBD::mysql::db do failed: Duplicate key name 'attachments_submitter_id_idx' at 
Bugzilla/DB.pm line 468
        Bugzilla::DB::bz_add_index_raw('Bugzilla::DB::Mysql=HASH
(0x26c4a74)', 'a
ttachments', 'attachments_submitter_id_idx', 'ARRAY(0x270b2a8)') called at 
Bugzi
lla/DB.pm line 441
        Bugzilla::DB::bz_add_index('Bugzilla::DB::Mysql=HASH
(0x26c4a74)', 'attac
hments', 'attachments_submitter_id_idx', 'ARRAY(0x270b2a8)') called at C:\<my 
install dir>\checksetup.pl line 3998

To work around this, I had to DROP the index and rerun checksetup.pl.  This 
solved the issue.

Reproducible: Always

Steps to Reproduce:
See details.
Actual Results:  
If I accessed the site, it worked, except that only the most recent comments 
were shown, the user prefs were empty, and there was a couple errors on the 
top of every bug page.

Comment 1

[Max Kanat-Alexander]

Why did you already have an index called attachments_submitter_id_idx? Did you
add an index locally?

Comment 2

[Ryan Adler]

I did nothing out of the ordinary.  I believe I only ran checksetup.pl a few 
times, since I installed some of the graphing modules for ppm.

Comment 3

[Max Kanat-Alexander]

Okay. If you still have a backup of that 2.18.2 database, make a "mysqldump --no-data" of it and attach that to this bug as an attachment.

Comment 4

[Max Kanat-Alexander]

I haven't gotten any response from the reporter, and I can't duplicate this bug.