916188 - Update database from production

Status: RESOLVED FIXED

(Cloud Services :: Operations: Marketplace, task)

Description

[Christopher Van Wiemeersch [:cvan]]

For -dev please update the databases and file systems from production.  Please use parallel databases with different names so as not to have any downtime.

When finished, run this on them: https://wiki.mozilla.org/User:Clouserw/AMODBrefresh

Can we do this on Saturday, 9/14?

Thanks!

Comment 1

[Andy McKay]

Updated the wiki with the necessary OAuth tokens, as we did in bug 868578 last time.

Comment 2

[Jason Thomas [:jason]]

I won't be available this Saturday to perform this. Does next Saturday, 9/21 work?

Comment 3

[Jason Thomas [:jason]]

I have started the database and file system refresh. I will update the bug once completed.

Comment 4

[Jason Thomas [:jason]]

Database and filesystem updated on -dev. I ran reindex_mkt and reindex to update elasticsearch indices. marketplace-dev elasticsearch index is up to date, addons-dev indices are still being populated. 

When running the AMO DB Refresh SQL commands the following did not complete:

mysql> insert into groups_users (group_id, user_id) values (50067, 5520425);
ERROR 1452 (23000): Cannot add or update a child row: a foreign key constraint fails (`addons_dev_allizom_org_new`.`groups_users`, CONSTRAINT `groups_users_ibfk_3` FOREIGN KEY (`group_id`) REFERENCES `groups` (`id`) ON DELETE CASCADE)

mysql>   insert into groups_users (group_id, user_id) values (50069, 5520425);
ERROR 1452 (23000): Cannot add or update a child row: a foreign key constraint fails (`addons_dev_allizom_org_new`.`groups_users`, CONSTRAINT `groups_users_ibfk_3` FOREIGN KEY (`group_id`) REFERENCES `groups` (`id`) ON DELETE CASCADE)

Comment 5

[Andrew Williamson [:eviljeff]]

fwiw, user 5520425 is a certain Mr McKay.