983097 - Cannot add new component to a product - Duplicate entry for key 'series_category_idx'

Status: RESOLVED INVALID

(Bugzilla :: Administration, task)

Description

[Heikki Manninen]

Attachment: bugzilla-4.2.7-checksetup-output.txt

User Agent: Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/33.0.1750.149 Safari/537.36

Steps to reproduce:

Platform Information:
OS: CentOS 6.5
Database: MySql 5.1.73
BugZilla Version: 4.2.7

Starting with empty database and clean installation of Bugzilla, checksetup.pl included as an attachment. Basic required parameters set, use classification set to "on".

1. Create a new classification called "Test Classification"
2. Create a new product under "Test Classification called "Test Product" and uncheck:
- Enable the UNCONFIRMED status in this product
- Create chart datasets for this product
3. Create a new component under "Test Product" called "Test Component" and set administrator (only user in the system) e-mail as default assignee and click "Add"



Actual results:

Software error:

DBD::mysql::db do failed: Duplicate entry '1-2-' for key 'series_category_idx' [for Statement "INSERT INTO series (creator, category, subcategory, name, frequency, query, is_public) VALUES (?, ?, ?, ?, ?, ?, ?)"] at Bugzilla/Series.pm line 205
	Bugzilla::Series::writeToDatabase('Bugzilla::Series=HASH(0x3a45370)') called at Bugzilla/Component.pm line 300
	Bugzilla::Component::_create_series('Bugzilla::Component=HASH(0x3a4fea8)') called at Bugzilla/Component.pm line 132
	Bugzilla::Component::create('Bugzilla::Component', 'HASH(0x37efa68)') called at /var/www/bugzilla/editcomponents.cgi line 133

For help, please send mail to the webmaster (root@localhost), giving this error message and the time and date of the error.



Looking at the database:

mysql> select * from bugs.series;
Empty set (0.00 sec)

mysql> SHOW INDEX FROM series;
+--------+------------+--------------------------------------------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+
| Table  | Non_unique | Key_name                                   | Seq_in_index | Column_name | Collation | Cardinality | Sub_part | Packed | Null | Index_type | Comment |
+--------+------------+--------------------------------------------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+
| series |          0 | PRIMARY                                    |            1 | series_id   | A         |           0 |     NULL | NULL   |      | BTREE      |         |
| series |          0 | series_category_idx                        |            1 | category    | A         |           0 |     NULL | NULL   |      | BTREE      |         |
| series |          0 | series_category_idx                        |            2 | subcategory | A         |           0 |     NULL | NULL   |      | BTREE      |         |
| series |          0 | series_category_idx                        |            3 | name        | A         |           0 |     NULL | NULL   |      | BTREE      |         |
| series |          1 | series_creator_idx                         |            1 | creator     | A         |           0 |     NULL | NULL   | YES  | BTREE      |         |
| series |          1 | fk_series_subcategory_series_categories_id |            1 | subcategory | A         |           0 |     NULL | NULL   |      | BTREE      |         |
+--------+------------+--------------------------------------------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+
6 rows in set (0.00 sec)


Expected results:

Component should have been created.

Comment 1

[Frédéric Buclin]

Probably related to the same root cause as bug 983098, which makes this bug a support question.