1025771 - manually alter the bugzilla production database to fix cf_fx_iteration issues

Status: RESOLVED FIXED

(Data & BI Services Team :: DB: MySQL, task)

Description

[:glob ✱]

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

Comment 1

[Brandon Johnson [:cyborgshadow]]

Kicked off. Should be finished soon.

Comment 2

[Brandon Johnson [:cyborgshadow]]

This completed. Made sure there was no production impact (that was part of the purpose of the last comment).

Comment 3

[:glob ✱]

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 ('---')

Comment 4

[Brandon Johnson [:cyborgshadow]]

It would seem this table and row already exist.

Please advise.

Comment 5

[:glob ✱]

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!