AnsweredAssumed Answered

Content Exports is not Completed.

Question asked by Kazu Mori on Sep 26, 2018
Latest reply on Oct 10, 2018 by Kona Jones

Dear CANVAS,

 

I read the following page on June 21, 2018, and built CanvasLMS.
https://github.com/instructure/canvas-lms/wiki/Production-Start
And I ran the content exports to get backup of Courses. However, the process can not be completed even after waiting for a few days.

The screen shot I have attached is the page that remains unchanged. Would anyone please let me know how to solve this problem ?

 

-Server information
OS: Ubuntu 18.04 LTS
DB version: postgresql-10
Ruby version: 2.5
Code: I downloaded Canvas with the git command.

 

The following messages have been appearing continuously in the /var/canvas/log/production.log.
-----
Started GET "/courses/1/content_exports/1" for 10.11.0.1 at 2018-09-26 05:26:03 +0000
SQL PluginSetting Load (0.8ms) SELECT "plugin_settings".* FROM "plugin_settings" WHERE "plugin_settings"."name" = 'sessions' ORDER BY "plugin_settings"."id" ASC LIMIT 1 [production:1 master]
Processing by ContentExportsController#show as JSON
Parameters: {"course_id"=>"1", "id"=>"1"}
SQL Pseudonym Load (1.0ms) SELECT "pseudonyms".* FROM "pseudonyms" WHERE "pseudonyms"."id" = 1 LIMIT 1 [production:1 master]
SQL User Load (1.0ms) SELECT "users".* FROM "users" WHERE "users"."id" = 1 LIMIT 1 [production:1 master]
SQL Course Load (1.2ms) SELECT "courses".* FROM "courses" WHERE (courses.workflow_state<>'deleted') AND "courses"."id" = 1 ORDER BY "courses"."id" ASC LIMIT 1 [production:1 master]
SQL Enrollment Load (1.9ms) SELECT "enrollments".* FROM "enrollments" INNER JOIN "enrollment_states" ON "enrollment_states"."enrollment_id" = "enrollments"."id" WHERE "enrollments"."course_id" = 1 AND (enrollments.workflow_state<>'deleted') AND "enrollments"."user_id" = 1 ORDER BY CASE WHEN enrollment_states.restricted_access THEN 3 WHEN enrollment_states.state IN ('active') THEN 0 WHEN enrollment_states.state IN ('invited', 'creation_pending', 'pending_active', 'pending_invited') THEN 1 WHEN enrollment_states.state IN ('completed') THEN 2 WHEN enrollment_states.state IN ('inactive') THEN 3 WHEN enrollment_states.state IN ('rejected') THEN 4 WHEN enrollment_states.state IN ('deleted') THEN 5 ELSE 6 END, CASE WHEN enrollments.type IN ('TeacherEnrollment') THEN 0 WHEN enrollments.type IN ('TaEnrollment') THEN 1 WHEN enrollments.type IN ('DesignerEnrollment') THEN 2 WHEN enrollments.type IN ('StudentEnrollment') THEN 3 WHEN enrollments.type IN ('StudentViewEnrollment') THEN 4 WHEN enrollments.type IN ('ObserverEnrollment') THEN 5 ELSE 6 END LIMIT 1 [production:1 master]
SQL Enrollment Exists (1.3ms) SELECT 1 AS one FROM "enrollments" INNER JOIN "enrollment_states" ON "enrollment_states"."enrollment_id" = "enrollments"."id" WHERE "enrollments"."course_id" = 1 AND (enrollments.workflow_state<>'deleted') AND "enrollments"."user_id" = 1 AND "enrollments"."type" IN ('TeacherEnrollment', 'TaEnrollment', 'DesignerEnrollment') AND (enrollment_states.state = 'active') LIMIT 1 [production:1 master]
[STATSD adheres_to_policy.course.read] (sql_read: 1.00) (sql_write: 0.00) (sql_cache: 0.00) (active_record: 0.00) (cache_read: 14.00) (total: 8.74) (exclusive_sql_read: 1.00) (exclusive_sql_write: 0.00) (exclusive_sql_cache: 0.00) (exclusive_active_record: 0.00) (exclusive_cache_read: 14.00) (exclusive_total: 8.74)
SQL ContentExport Load (1.0ms) SELECT "content_exports".* FROM "content_exports" WHERE "content_exports"."context_id" = 1 AND "content_exports"."context_type" = 'Course' AND (content_exports.export_type NOT IN ('zip','user_data') OR content_exports.user_id='1') AND "content_exports"."id" = 1 ORDER BY "content_exports"."id" ASC LIMIT 1 [production:1 master]
Completed 200 OK in 49ms (Views: 0.3ms | ActiveRecord: 7.4ms)
[STATSD] (sql_read: 6.00) (sql_write: 0.00) (sql_cache: 0.00) (active_record: 5.00) (cache_read: 25.00) (total: 49.26) (view: 0.29) (db: 7.39)
[STAT] 924984 924984 0 924984 0.052435000000002674 0.00013599999999946988
-----

Outcomes