Closed Bug 660931 Opened 15 years ago Closed 15 years ago

Update markup stage and prod

Categories

(Infrastructure & Operations Graveyard :: WebOps: Other, task)

Product:
Infrastructure & Operations Graveyard
Component:
WebOps: Other
Platform:
All
Other
Type:
task
Priority:
Not set
Severity:
critical

Tracking

(Not tracked)

Status:
RESOLVED FIXED

People

(Reporter: wenzel, Assigned: jabba)

References

Details

Please update the markup app on stage and prod. I added more missing indexes and changed the way we generate unique IDs for marks. QA needs this change in production, so we can run another load test. Thanks! User impact: none Downtime: none
Blocks: 660876
Assignee: server-ops → jdow
on stage: [root@mradm02 markup.mozilla.org]# ./update.sh Updating code... Unpacking objects: 100% (74/74), done. /data/engagement-stage/python/markup.mozilla.org Updating vendor... /data/engagement-stage/python/markup.mozilla.org Migrating database.. Running migrations for markup: - Migrating forwards to 0020_add_index_country_code. > markup:0019_add_model_MarkSequence DEBUG:south:south execute "CREATE TABLE `markup_marksequence` (`id` integer NOT NULL PRIMARY KEY);" with params "[]" DEBUG:south:south execute "INSERT INTO markup_marksequence SET id = (SELECT MAX(id) FROM markup_mark)" with params "[]" DEBUG:south:south execute "SET FOREIGN_KEY_CHECKS=1;" with params "[]" DEBUG:south:south execute "CREATE TABLE `markup_marksequence` (`id` integer NOT NULL PRIMARY KEY);" with params "[]" DEBUG:south:south execute "INSERT INTO markup_marksequence SET id = (SELECT MAX(id) FROM markup_mark)" with params "[]" > markup:0020_add_index_country_code DEBUG:south:south execute "CREATE INDEX `markup_mark_country_code` ON `markup_mark` (`country_code`);" with params "[]" DEBUG:south:south execute "CREATE INDEX `markup_mark_country_code` ON `markup_mark` (`country_code`);" with params "[]" Traceback (most recent call last): File "./manage.py", line 49, in <module> execute_manager(settings) File "/data/engagement-stage/python/markup.mozilla.org/markup/ffdemo/vendor/src/django/django/core/management/__init__.py", line 438, in execute_manager utility.execute() File "/data/engagement-stage/python/markup.mozilla.org/markup/ffdemo/vendor/src/django/django/core/management/__init__.py", line 379, in execute self.fetch_command(subcommand).run_from_argv(self.argv) File "/data/engagement-stage/python/markup.mozilla.org/markup/ffdemo/vendor/src/django/django/core/management/base.py", line 191, in run_from_argv self.execute(*args, **options.__dict__) File "/data/engagement-stage/python/markup.mozilla.org/markup/ffdemo/vendor/src/django/django/core/management/base.py", line 220, in execute output = self.handle(*args, **options) File "/data/engagement-stage/python/markup.mozilla.org/markup/ffdemo/vendor/src/south/south/management/commands/migrate.py", line 102, in handle delete_ghosts = delete_ghosts, File "/data/engagement-stage/python/markup.mozilla.org/markup/ffdemo/vendor/src/south/south/migration/__init__.py", line 202, in migrate_app success = migrator.migrate_many(target, workplan, database) File "/data/engagement-stage/python/markup.mozilla.org/markup/ffdemo/vendor/src/south/south/migration/migrators.py", line 215, in migrate_many result = migrator.__class__.migrate_many(migrator, target, migrations, database) File "/data/engagement-stage/python/markup.mozilla.org/markup/ffdemo/vendor/src/south/south/migration/migrators.py", line 289, in migrate_many south.db.db.send_pending_create_signals() File "/data/engagement-stage/python/markup.mozilla.org/markup/ffdemo/vendor/src/south/south/db/generic.py", line 773, in send_pending_create_signals self.really_send_create_signal(app_label, list(set(model_names))) File "/data/engagement-stage/python/markup.mozilla.org/markup/ffdemo/vendor/src/south/south/db/generic.py", line 822, in really_send_create_signal db=self.db_alias, File "/data/engagement-stage/python/markup.mozilla.org/markup/ffdemo/vendor/src/django/django/dispatch/dispatcher.py", line 162, in send response = receiver(signal=self, sender=sender, **named) File "/data/engagement-stage/python/markup.mozilla.org/markup/ffdemo/vendor/src/django/django/contrib/contenttypes/management.py", line 24, in update_contenttypes ct.save() File "/data/engagement-stage/python/markup.mozilla.org/markup/ffdemo/vendor/src/django/django/db/models/base.py", line 434, in save self.save_base(using=using, force_insert=force_insert, force_update=force_update) File "/data/engagement-stage/python/markup.mozilla.org/markup/ffdemo/vendor/src/django/django/db/models/base.py", line 527, in save_base result = manager._insert(values, return_id=update_pk, using=using) File "/data/engagement-stage/python/markup.mozilla.org/markup/ffdemo/vendor/src/django/django/db/models/manager.py", line 195, in _insert return insert_query(self.model, values, **kwargs) File "/data/engagement-stage/python/markup.mozilla.org/markup/ffdemo/vendor/src/django/django/db/models/query.py", line 1479, in insert_query return query.get_compiler(using=using).execute_sql(return_id) File "/data/engagement-stage/python/markup.mozilla.org/markup/ffdemo/vendor/src/django/django/db/models/sql/compiler.py", line 783, in execute_sql cursor = super(SQLInsertCompiler, self).execute_sql(None) File "/data/engagement-stage/python/markup.mozilla.org/markup/ffdemo/vendor/src/django/django/db/models/sql/compiler.py", line 727, in execute_sql cursor.execute(sql, params) File "/data/engagement-stage/python/markup.mozilla.org/markup/ffdemo/vendor/src/django/django/db/backends/mysql/base.py", line 86, in execute return self.cursor.execute(query, args) File "/usr/lib64/python2.6/site-packages/MySQLdb/cursors.py", line 173, in execute self.errorhandler(self, exc, value) File "/usr/lib64/python2.6/site-packages/MySQLdb/connections.py", line 36, in defaulterrorhandler raise errorclass, errorvalue django.db.utils.IntegrityError: (1062, "Duplicate entry 'markup-marksequence' for key 'app_label'") /data/engagement-stage/python/markup.mozilla.org Updating locale.. At revision 89679. /data/engagement-stage/python/markup.mozilla.org [master 20e49cc] push 21 files changed, 542 insertions(+), 384 deletions(-) create mode 100644 python/markup.mozilla.org/markup/ffdemo/markup/migrations/0019_add_model_MarkSequence.py create mode 100644 python/markup.mozilla.org/markup/ffdemo/markup/migrations/0019_add_model_MarkSequence.pyc create mode 100644 python/markup.mozilla.org/markup/ffdemo/markup/migrations/0020_add_index_country_code.py create mode 100644 python/markup.mozilla.org/markup/ffdemo/markup/migrations/0020_add_index_country_code.pyc rewrite python/markup.mozilla.org/markup/ffdemo/settings.pyc (65%) rewrite python/markup.mozilla.org/markup/ffdemo/static/assets/js/markUp_app.min.js (60%) Done [root@mradm02 markup.mozilla.org]#
and prod: [root@mradm02 markup.mozilla.org]# ./update.sh Updating code... Unpacking objects: 100% (79/79), done. /data/engagement/python/markup.mozilla.org Updating vendor... /data/engagement/python/markup.mozilla.org Migrating database.. Running migrations for markup: - Migrating forwards to 0020_add_index_country_code. > markup:0019_add_model_MarkSequence DEBUG:south:south execute "CREATE TABLE `markup_marksequence` (`id` integer NOT NULL PRIMARY KEY);" with params "[]" DEBUG:south:south execute "INSERT INTO markup_marksequence SET id = (SELECT MAX(id) FROM markup_mark)" with params "[]" DEBUG:south:south execute "SET FOREIGN_KEY_CHECKS=1;" with params "[]" DEBUG:south:south execute "CREATE TABLE `markup_marksequence` (`id` integer NOT NULL PRIMARY KEY);" with params "[]" DEBUG:south:south execute "INSERT INTO markup_marksequence SET id = (SELECT MAX(id) FROM markup_mark)" with params "[]" > markup:0020_add_index_country_code DEBUG:south:south execute "CREATE INDEX `markup_mark_country_code` ON `markup_mark` (`country_code`);" with params "[]" DEBUG:south:south execute "CREATE INDEX `markup_mark_country_code` ON `markup_mark` (`country_code`);" with params "[]" Traceback (most recent call last): File "./manage.py", line 49, in <module> execute_manager(settings) File "/data/engagement/python/markup.mozilla.org/markup/ffdemo/vendor/src/django/django/core/management/__init__.py", line 438, in execute_manager utility.execute() File "/data/engagement/python/markup.mozilla.org/markup/ffdemo/vendor/src/django/django/core/management/__init__.py", line 379, in execute self.fetch_command(subcommand).run_from_argv(self.argv) File "/data/engagement/python/markup.mozilla.org/markup/ffdemo/vendor/src/django/django/core/management/base.py", line 191, in run_from_argv self.execute(*args, **options.__dict__) File "/data/engagement/python/markup.mozilla.org/markup/ffdemo/vendor/src/django/django/core/management/base.py", line 220, in execute output = self.handle(*args, **options) File "/data/engagement/python/markup.mozilla.org/markup/ffdemo/vendor/src/south/south/management/commands/migrate.py", line 102, in handle delete_ghosts = delete_ghosts, File "/data/engagement/python/markup.mozilla.org/markup/ffdemo/vendor/src/south/south/migration/__init__.py", line 202, in migrate_app success = migrator.migrate_many(target, workplan, database) File "/data/engagement/python/markup.mozilla.org/markup/ffdemo/vendor/src/south/south/migration/migrators.py", line 215, in migrate_many result = migrator.__class__.migrate_many(migrator, target, migrations, database) File "/data/engagement/python/markup.mozilla.org/markup/ffdemo/vendor/src/south/south/migration/migrators.py", line 289, in migrate_many south.db.db.send_pending_create_signals() File "/data/engagement/python/markup.mozilla.org/markup/ffdemo/vendor/src/south/south/db/generic.py", line 773, in send_pending_create_signals self.really_send_create_signal(app_label, list(set(model_names))) File "/data/engagement/python/markup.mozilla.org/markup/ffdemo/vendor/src/south/south/db/generic.py", line 822, in really_send_create_signal db=self.db_alias, File "/data/engagement/python/markup.mozilla.org/markup/ffdemo/vendor/src/django/django/dispatch/dispatcher.py", line 162, in send response = receiver(signal=self, sender=sender, **named) File "/data/engagement/python/markup.mozilla.org/markup/ffdemo/vendor/src/django/django/contrib/contenttypes/management.py", line 24, in update_contenttypes ct.save() File "/data/engagement/python/markup.mozilla.org/markup/ffdemo/vendor/src/django/django/db/models/base.py", line 434, in save self.save_base(using=using, force_insert=force_insert, force_update=force_update) File "/data/engagement/python/markup.mozilla.org/markup/ffdemo/vendor/src/django/django/db/models/base.py", line 527, in save_base result = manager._insert(values, return_id=update_pk, using=using) File "/data/engagement/python/markup.mozilla.org/markup/ffdemo/vendor/src/django/django/db/models/manager.py", line 195, in _insert return insert_query(self.model, values, **kwargs) File "/data/engagement/python/markup.mozilla.org/markup/ffdemo/vendor/src/django/django/db/models/query.py", line 1479, in insert_query return query.get_compiler(using=using).execute_sql(return_id) File "/data/engagement/python/markup.mozilla.org/markup/ffdemo/vendor/src/django/django/db/models/sql/compiler.py", line 783, in execute_sql cursor = super(SQLInsertCompiler, self).execute_sql(None) File "/data/engagement/python/markup.mozilla.org/markup/ffdemo/vendor/src/django/django/db/models/sql/compiler.py", line 727, in execute_sql cursor.execute(sql, params) File "/data/engagement/python/markup.mozilla.org/markup/ffdemo/vendor/src/django/django/db/backends/mysql/base.py", line 86, in execute return self.cursor.execute(query, args) File "/usr/lib64/python2.6/site-packages/MySQLdb/cursors.py", line 173, in execute self.errorhandler(self, exc, value) File "/usr/lib64/python2.6/site-packages/MySQLdb/connections.py", line 36, in defaulterrorhandler raise errorclass, errorvalue django.db.utils.IntegrityError: (1062, "Duplicate entry 'markup-marksequence' for key 'app_label'") /data/engagement/python/markup.mozilla.org Updating locale.. At revision 89679. /data/engagement/python/markup.mozilla.org Done [root@mradm02 markup.mozilla.org]# (Fred said not to worry about that stacktrace as it seems to have no ill effects.)
Status: NEW → RESOLVED
Closed: 15 years ago
Resolution: --- → FIXED
Component: Server Operations: Web Operations → WebOps: Other
Product: mozilla.org → Infrastructure & Operations
Product: Infrastructure & Operations → Infrastructure & Operations Graveyard
You need to log in before you can comment on or make changes to this bug.