601226 - Investigate potential schematic issue on support-stage

Status: VERIFIED FIXED

(mozilla.org Graveyard :: Server Operations, task)

Description

[James Socol [:jsocol, :james]]

It appears that schematic is stalled on support-stage.mozilla.com. I suspect that when we just reimported the production data, the full database wasn't dropped first, so schematic is trying to run migration 32 and failing. Easy fix:

UPDATE schematic_version SET version = 35;

That _should_ do it. If not ping me and we'll figure it out.

Comment 1

[Dave Miller [:justdave]]

mysql> UPDATE schematic_version SET version = 35;
ERROR 1146 (42S02): Table 'support_stage_new_mozilla_com.schematic_version' doesn't exist

ooohkay.

Comment 2

[Dave Miller [:justdave]]

per instructions on irc:

[root@mrapp-stage04 ~]# python26 /data/www/support-stage-new.mozilla.com/kitsune/vendor/src/schematic/schematic -u 35 /data/www/support-stage-new.mozilla.com/kitsune/migrations/
[root@mrapp-stage04 ~]# python26 /data/www/support-stage-new.mozilla.com/kitsune/vendor/src/schematic/schematic /data/www/support-stage-new.mozilla.com/kitsune/migrations/
Running migration 36:
-- Model: Answer
ALTER TABLE `questions_answer`
    ADD `page` integer default 1;

-- Set page numbers for existing answers.
UPDATE questions_answer a
SET
    page = (
        SELECT COUNT(*)
        FROM (
            SELECT id, question_id, created
            FROM questions_answer) b
        WHERE b.question_id = a.question_id AND b.created < a.created
        ) / 20 + 1;

That took 134.44 seconds
##################################################

Comment 3

[James Socol [:jsocol, :james]]

Thanks, Dave!