manually alter the bugzilla production database to fix cf_fx_iteration issues

RESOLVED FIXED

Status

Data & BI Services Team
DB: MySQL
--
major
RESOLVED FIXED
4 years ago
3 years ago

People

(Reporter: glob, Assigned: cyborgshadow)

Tracking

Details

(Reporter)

Description

4 years ago
last week i added the cf_fx_iteration custom field to bugzilla, however it looks like something went wrong.  i don't recall any errors being thrown at the time.  the other field i created at the same time (cf_fx_points) was created without issue.

i've just tried to add values to the field, and it reported that cf_fx_iteration table didn't exist :(  i deleted the field and re-created it, however it's now broken in a different way.


the field doesn't exist according to bz_schema or the fielddefs table.
however the schema for the field exists (bugs.cf_fx_iteration and the cf_fx_iteration table), so any attempt to create the field now fails.


can the following actions please be taken on the bugzilla master database:
- drop the bugs.cf_fx_iteration column
- drop the cf_fx_iteration table


thanks
(Assignee)

Comment 1

4 years ago
Kicked off. Should be finished soon.
(Assignee)

Comment 2

4 years ago
This completed. Made sure there was no production impact (that was part of the purpose of the last comment).
Status: NEW → RESOLVED
Last Resolved: 4 years ago
Resolution: --- → FIXED
(Reporter)

Comment 3

4 years ago
thanks for the quick turn around on this request :)

unfortunately things went south when i tried again to create the field.  thankfully i had my tools pointed at bugzilla so i think i know the sequence of events which lead us to this situation (long story short: failure during field creation isn't rolled back on mysql or memcached).

in order to get this field live, can you please create the following table on production and insert a single row:

CREATE TABLE `cf_fx_iteration` (
    `id` smallint(6) NOT NULL AUTO_INCREMENT,
    `value` varchar(64) NOT NULL,
    `sortkey` smallint(6) NOT NULL DEFAULT '0',
    `isactive` tinyint(4) NOT NULL DEFAULT '1',
    `visibility_value_id` smallint(6) DEFAULT NULL,
    PRIMARY KEY (`id`),
    UNIQUE KEY `cf_fx_iteration_value_idx` (`value`),
    KEY `cf_fx_iteration_visibility_value_id_idx` (`visibility_value_id`),
    KEY `cf_fx_iteration_sortkey_idx` (`sortkey` , `value`)
)

INSERT INTO cf_fx_iteration (value) VALUES ('---')
Status: RESOLVED → REOPENED
Resolution: FIXED → ---
(Assignee)

Comment 4

4 years ago
It would seem this table and row already exist.

Please advise.
Assignee: server-ops-database → bjohnson
(Reporter)

Comment 5

4 years ago
sorry, my bad.  not sure what happened to make me think the table wasn't there, but it's there for sure and i can add values to it.  thanks again for the prompt response!
Status: REOPENED → RESOLVED
Last Resolved: 4 years ago4 years ago
Resolution: --- → FIXED
Product: mozilla.org → Data & BI Services Team
You need to log in before you can comment on or make changes to this bug.