Skip to content

Instantly share code, notes, and snippets.

Show Gist options
  • Save efischer19/f1f5f0f3b91295d1a41ec8d2a8eb2115 to your computer and use it in GitHub Desktop.
Save efischer19/f1f5f0f3b91295d1a41ec8d2a8eb2115 to your computer and use it in GitHub Desktop.
edxapp@precise64:~/edx-platform$ rm common/test/db_cache/bok_choy_*
edxapp@precise64:~/edx-platform$ . scripts/reset-test-db.sh
Issuing a reset_db command to the default bok_choy MySQL database.
System check identified some issues:
WARNINGS:
wiki.ArticleRevision.ip_address: (fields.W900) IPAddressField has been deprecated. Support for it (except in historical migrations) will be removed in Django 1.9.
HINT: Use GenericIPAddressField instead.
2016-05-06 15:30:28,297 INFO 32621 [root] reset_db.py:123 - Executing... "DROP DATABASE IF EXISTS `edxtest`"
2016-05-06 15:30:30,704 INFO 32621 [root] reset_db.py:125 - Executing... "CREATE DATABASE `edxtest` CHARACTER SET utf8"
Missing common/test/db_cache/bok_choy_schema_default.sql or common/test/db_cache/bok_choy_data_default.json, or common/test/db_cache/bok_choy_migrations_data_default.sql rebuilding cache
Issuing a reset_db command to the student_module_history bok_choy MySQL database.
System check identified some issues:
WARNINGS:
wiki.ArticleRevision.ip_address: (fields.W900) IPAddressField has been deprecated. Support for it (except in historical migrations) will be removed in Django 1.9.
HINT: Use GenericIPAddressField instead.
2016-05-06 15:30:33,312 INFO 32637 [root] reset_db.py:123 - Executing... "DROP DATABASE IF EXISTS `student_module_history_test`"
2016-05-06 15:30:33,315 INFO 32637 [root] reset_db.py:125 - Executing... "CREATE DATABASE `student_module_history_test` CHARACTER SET utf8"
Missing common/test/db_cache/bok_choy_schema_student_module_history.sql or common/test/db_cache/bok_choy_data_student_module_history.json, or common/test/db_cache/bok_choy_migrations_data_student_module_history.sql rebuilding cache
Did not find a bok_choy DB cache. Creating a new one from scratch.
Issuing a migrate command to the default bok_choy MySQL database for the lms django apps.
System check identified some issues:
WARNINGS:
wiki.ArticleRevision.ip_address: (fields.W900) IPAddressField has been deprecated. Support for it (except in historical migrations) will be removed in Django 1.9.
HINT: Use GenericIPAddressField instead.
Operations to perform:
Synchronize unmigrated apps: eventtracking_django, links, djcelery, discussion_api, learner_dashboard, edxnotes, auth_exchange, service_status, gating, sekizai, rest_framework, django_extensions, edxmako, openassessment, datadog, staticbook, common_views, course_wiki, support, course_structure_api, django_countries, humanize, course_blocks, provider, notification_prefs, thumbnail, xblock, mptt, staticfiles, markdownedx, fileupload, edx_sga, management_commands, edx_jsme, monitoring, instructor, static_template_view, corsheaders, statici18n, pipeline, simple_history, enrollment, messages, config_models, notifier_api, dashboard, django_nose, debug, mailing, theming
Apply all migrations: wiki, verified_track_content, dark_lang, branding, user_api, django_comment_common, course_overviews, sites, rss_proxy, bookmarks, mobile_api, badges, course_groups, site_configuration, course_modes, sessions, shoppingcart, workflow, external_auth, default, contenttypes, splash, certificates, static_replace, third_party_auth, assessment, submissions, status, oauth2_provider, instructor_task, organizations, edx_oauth2_provider, microsite_configuration, django_notify, api_admin, auth, coursetalk, util, verify_student, lms_xblock, oauth2, track, student, credentials, contentserver, xblock_django, course_action_state, embargo, commerce, milestones, ccx, edx_proctoring, admin, oauth_provider, courseware, programs, edxval, teams, credit, django_openid_auth, bulk_email, survey, course_structures, cors_csrf, coursewarehistoryextended, ccxcon, notes, self_paced
Synchronizing apps without migrations:
Creating tables...
Creating table celery_taskmeta
Creating table celery_tasksetmeta
Creating table djcelery_intervalschedule
Creating table djcelery_crontabschedule
Creating table djcelery_periodictasks
Creating table djcelery_periodictask
Creating table djcelery_workerstate
Creating table djcelery_taskstate
Creating table corsheaders_corsmodel
Creating table thumbnail_kvstore
Running deferred SQL...
Installing custom SQL...
Running migrations:
Rendering model states... DONE
Applying contenttypes.0001_initial... OK
Applying auth.0001_initial... OK
Applying admin.0001_initial... OK
Applying sites.0001_initial... OK
Applying contenttypes.0002_remove_content_type_name... OK
Applying api_admin.0001_initial... OK
Applying api_admin.0002_auto_20160325_1604... OK
Applying api_admin.0003_auto_20160404_1618... OK
Applying api_admin.0004_auto_20160412_1506... OK
Applying api_admin.0005_auto_20160414_1232... OK
Applying api_admin.0006_catalog... OK
Applying assessment.0001_initial... OK
Applying assessment.0002_staffworkflow... OK
Applying auth.0002_alter_permission_name_max_length... OK
Applying auth.0003_alter_user_email_max_length... OK
Applying auth.0004_alter_user_username_opts... OK
Applying auth.0005_alter_user_last_login_null... OK
Applying auth.0006_require_contenttypes_0002... OK
Applying instructor_task.0001_initial... OK
Applying certificates.0001_initial... OK
Applying certificates.0002_data__certificatehtmlviewconfiguration_data... OK
Applying certificates.0003_data__default_modes... OK
Applying certificates.0004_certificategenerationhistory... OK
Applying certificates.0005_auto_20151208_0801... OK
Applying certificates.0006_certificatetemplateasset_asset_slug... OK
Applying certificates.0007_certificateinvalidation... OK
Applying badges.0001_initial... OK
Applying badges.0002_data__migrate_assertions... OK
Applying badges.0003_schema__add_event_configuration... OK
Applying bookmarks.0001_initial... OK
Applying branding.0001_initial... OK
Applying bulk_email.0001_initial... OK
Applying bulk_email.0002_data__load_course_email_template...Installed 2 object(s) from 1 fixture(s)
OK
Applying bulk_email.0003_admin_feature_switch... OK
Applying verified_track_content.0001_initial... OK
Applying course_overviews.0001_initial... OK
Applying course_overviews.0002_add_course_catalog_fields... OK
Applying course_overviews.0003_courseoverviewgeneratedhistory... OK
Applying course_overviews.0004_courseoverview_org... OK
Applying course_overviews.0005_delete_courseoverviewgeneratedhistory... OK
Applying course_overviews.0006_courseoverviewimageset... OK
Applying course_overviews.0007_courseoverviewimageconfig... OK
Applying course_overviews.0008_remove_courseoverview_facebook_url... OK
Applying course_overviews.0009_readd_facebook_url... OK
Applying course_overviews.0010_auto_20160329_2317... OK
Applying ccx.0001_initial... OK
Applying ccx.0002_customcourseforedx_structure_json... OK
Applying ccx.0003_add_master_course_staff_in_ccx... OK
Applying ccxcon.0001_initial_ccxcon_model... OK
Applying ccxcon.0002_auto_20160325_0407... OK
Applying certificates.0008_schema__remove_badges... OK
Applying commerce.0001_data__add_ecommerce_service_user... OK
Applying commerce.0002_commerceconfiguration... OK
Applying commerce.0003_auto_20160329_0709... OK
Applying contentserver.0001_initial... OK
Applying contentserver.0002_cdnuseragentsconfig... OK
Applying cors_csrf.0001_initial... OK
Applying course_action_state.0001_initial... OK
Applying course_groups.0001_initial... OK
Applying course_modes.0001_initial... OK
Applying course_modes.0002_coursemode_expiration_datetime_is_explicit... OK
Applying course_modes.0003_auto_20151113_1443... OK
Applying course_modes.0004_auto_20151113_1457... OK
Applying course_modes.0005_auto_20151217_0958... OK
Applying course_modes.0006_auto_20160208_1407... OK
Applying course_structures.0001_initial... OK
Applying coursetalk.0001_initial... OK
Applying coursetalk.0002_auto_20160325_0631... OK
Applying courseware.0001_initial... OK
Applying coursewarehistoryextended.0001_initial... OK
Applying coursewarehistoryextended.0002_force_studentmodule_index... OK
Applying credentials.0001_initial... OK
Applying credentials.0002_auto_20160325_0631... OK
Applying credit.0001_initial... OK
Applying credit.0002_creditconfig... OK
Applying dark_lang.0001_initial... OK
Applying dark_lang.0002_data__enable_on_install... OK
Applying default.0001_initial... OK
Applying default.0002_add_related_name... OK
Applying default.0003_alter_email_max_length... OK
Applying django_comment_common.0001_initial... OK
Applying django_notify.0001_initial... OK
Applying django_openid_auth.0001_initial... OK
Applying oauth2.0001_initial... OK
Applying edx_oauth2_provider.0001_initial... OK
Applying edx_proctoring.0001_initial... OK
Applying edx_proctoring.0002_proctoredexamstudentattempt_is_status_acknowledged... OK
Applying edx_proctoring.0003_auto_20160101_0525... OK
Applying edx_proctoring.0004_auto_20160201_0523... OK
Applying edx_proctoring.0005_proctoredexam_hide_after_due... OK
Applying edxval.0001_initial... OK
Applying edxval.0002_data__default_profiles... OK
Applying embargo.0001_initial... OK
Applying embargo.0002_data__add_countries... OK
Applying external_auth.0001_initial... OK
Applying lms_xblock.0001_initial... OK
Applying microsite_configuration.0001_initial... OK
Applying microsite_configuration.0002_auto_20160202_0228... OK
Applying milestones.0001_initial... OK
Applying milestones.0002_data__seed_relationship_types... OK
Applying milestones.0003_coursecontentmilestone_requirements... OK
Applying milestones.0004_auto_20151221_1445... OK
Applying mobile_api.0001_initial... OK
Applying mobile_api.0002_auto_20160406_0904... OK
Applying notes.0001_initial... OK
Applying oauth2.0002_auto_20160404_0813... OK
Applying oauth2_provider.0001_initial... OK
Applying oauth2_provider.0002_08_updates... OK
Applying oauth_provider.0001_initial... OK
Applying organizations.0001_initial... OK
Applying programs.0001_initial... OK
Applying programs.0002_programsapiconfig_cache_ttl... OK
Applying programs.0003_auto_20151120_1613... OK
Applying programs.0004_programsapiconfig_enable_certification... OK
Applying programs.0005_programsapiconfig_max_retries... OK
Applying programs.0006_programsapiconfig_xseries_ad_enabled... OK
Applying programs.0007_programsapiconfig_program_listing_enabled... OK
Applying rss_proxy.0001_initial... OK
Applying self_paced.0001_initial... OK
Applying sessions.0001_initial... OK
Applying student.0001_initial... OK
Applying shoppingcart.0001_initial... OK
Applying shoppingcart.0002_auto_20151208_1034... OK
Applying shoppingcart.0003_auto_20151217_0958... OK
Applying site_configuration.0001_initial... OK
Applying splash.0001_initial... OK
Applying static_replace.0001_initial... OK
Applying static_replace.0002_assetexcludedextensionsconfig... OK
Applying status.0001_initial... OK
Applying student.0002_auto_20151208_1034... OK
Applying submissions.0001_initial... OK
Applying submissions.0002_auto_20151119_0913... OK
Applying submissions.0003_submission_status... OK
Applying survey.0001_initial... OK
Applying teams.0001_initial... OK
Applying third_party_auth.0001_initial... OK
Applying third_party_auth.0002_schema__provider_icon_image... OK
Applying track.0001_initial... OK
Applying user_api.0001_initial... OK
Applying util.0001_initial... OK
Applying util.0002_data__default_rate_limit_config... OK
Applying verified_track_content.0002_verifiedtrackcohortedcourse_verified_cohort_name... OK
Applying verify_student.0001_initial... OK
Applying verify_student.0002_auto_20151124_1024... OK
Applying verify_student.0003_auto_20151113_1443... OK
Applying wiki.0001_initial... OK
Applying wiki.0002_remove_article_subscription... OK
Applying workflow.0001_initial... OK
Applying xblock_django.0001_initial... OK
Applying xblock_django.0002_auto_20160204_0809... OK
Issuing a migrate command to the default bok_choy MySQL database for the cms django apps.
2016-05-06 15:34:45,877 INFO 582 [dd.dogapi] dog_stats_api.py:66 - Initializing dog api to use statsd: localhost, 8125
Operations to perform:
Synchronize unmigrated apps: eventtracking_django, djcelery, statici18n, fileupload, service_status, method_override, edxmako, openassessment, datadog, common_views, provider, staticfiles, management_commands, edx_jsme, monitoring, pipeline, simple_history, require, messages, config_models, django_extensions, xblock, django_nose, edx_sga, theming
Apply all migrations: dark_lang, student, user_api, django_comment_common, course_overviews, bookmarks, xblock_django, course_groups, site_configuration, course_modes, workflow, sites, external_auth, track, contenttypes, static_replace, assessment, oauth2_provider, sessions, edx_oauth2_provider, microsite_configuration, auth, coursetalk, verify_student, oauth2, contentstore, xblock_config, contentserver, tagging, embargo, organizations, milestones, course_action_state, course_creators, edx_proctoring, admin, submissions, programs, edxval, credit, django_openid_auth, course_structures, self_paced
Synchronizing apps without migrations:
Creating tables...
Running deferred SQL...
Installing custom SQL...
Running migrations:
Rendering model states... DONE
Applying contentstore.0001_initial... OK
Applying course_creators.0001_initial... OK
Applying tagging.0001_initial... OK
Applying xblock_config.0001_initial... OK
Using the dumpdata command to save the default fixture data to the filesystem.
System check identified some issues:
WARNINGS:
wiki.ArticleRevision.ip_address: (fields.W900) IPAddressField has been deprecated. Support for it (except in historical migrations) will be removed in Django 1.9.
HINT: Use GenericIPAddressField instead.
Traceback (most recent call last):
File "./manage.py", line 116, in <module>
execute_from_command_line([sys.argv[0]] + django_args)
File "/edx/app/edxapp/venvs/edxapp/local/lib/python2.7/site-packages/django/core/management/__init__.py", line 354, in execute_from_command_line
utility.execute()
File "/edx/app/edxapp/venvs/edxapp/local/lib/python2.7/site-packages/django/core/management/__init__.py", line 346, in execute
self.fetch_command(subcommand).run_from_argv(self.argv)
File "/edx/app/edxapp/venvs/edxapp/local/lib/python2.7/site-packages/django/core/management/base.py", line 394, in run_from_argv
self.execute(*args, **cmd_options)
File "/edx/app/edxapp/venvs/edxapp/local/lib/python2.7/site-packages/django/core/management/base.py", line 445, in execute
output = self.handle(*args, **options)
File "/edx/app/edxapp/venvs/edxapp/local/lib/python2.7/site-packages/django/core/management/commands/dumpdata.py", line 162, in handle
stream=stream or self.stdout)
File "/edx/app/edxapp/venvs/edxapp/local/lib/python2.7/site-packages/django/core/serializers/__init__.py", line 129, in serialize
s.serialize(queryset, **options)
File "/edx/app/edxapp/venvs/edxapp/local/lib/python2.7/site-packages/django/core/serializers/base.py", line 52, in serialize
for obj in queryset:
File "/edx/app/edxapp/venvs/edxapp/local/lib/python2.7/site-packages/django/core/management/commands/dumpdata.py", line 152, in get_objects
for obj in queryset.iterator():
File "/edx/app/edxapp/venvs/edxapp/local/lib/python2.7/site-packages/django/db/models/query.py", line 238, in iterator
results = compiler.execute_sql()
File "/edx/app/edxapp/venvs/edxapp/local/lib/python2.7/site-packages/django/db/models/sql/compiler.py", line 840, in execute_sql
cursor.execute(sql, params)
File "/edx/app/edxapp/venvs/edxapp/local/lib/python2.7/site-packages/django/db/backends/utils.py", line 79, in execute
return super(CursorDebugWrapper, self).execute(sql, params)
File "/edx/app/edxapp/venvs/edxapp/local/lib/python2.7/site-packages/django/db/backends/utils.py", line 64, in execute
return self.cursor.execute(sql, params)
File "/edx/app/edxapp/venvs/edxapp/local/lib/python2.7/site-packages/django/db/utils.py", line 98, in __exit__
six.reraise(dj_exc_type, dj_exc_value, traceback)
File "/edx/app/edxapp/venvs/edxapp/local/lib/python2.7/site-packages/django/db/backends/utils.py", line 64, in execute
return self.cursor.execute(sql, params)
File "/edx/app/edxapp/venvs/edxapp/local/lib/python2.7/site-packages/django/db/backends/mysql/base.py", line 124, in execute
return self.cursor.execute(query, args)
File "/edx/app/edxapp/venvs/edxapp/local/lib/python2.7/site-packages/MySQLdb/cursors.py", line 205, in execute
self.errorhandler(self, exc, value)
File "/edx/app/edxapp/venvs/edxapp/local/lib/python2.7/site-packages/MySQLdb/connections.py", line 36, in defaulterrorhandler
raise errorclass, errorvalue
django.db.utils.ProgrammingError: (1146, "Table 'edxtest.api_admin_catalog' doesn't exist")
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment