Failed course import, no stuck running job

[Tony]

I tried to import a course, but we ran out diskspace and then the import failed, but the job never terminated. It has been running for 3 days now and preventing the ability to import other courses. The courses imports are stuck on queued.

The job strand is: migrations:import content/100..001

Question: How to clear the running job so the other courses will import?

Many thanks,

Tony

[Cody Cutrer]

Tony,

If the job is not actually running, just restarting jobs on the server it _was_ running on should get it to realize that and retry. Otherwise, you can directly delete the job.

Cody Cutrer

Software Engineer

Instructure

--

---
You received this message because you are subscribed to the Google Groups "Canvas LMS Users" group.
To unsubscribe from this group and stop receiving emails from it, send an email to canvas-lms-users+unsubscribe@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

[tony.h...@gmail.com]

Thank you, Cody! The job persists when the server is restarted, and when the DB and data are restored in clean install. Where does one directly delete the job? The DB? Or is there a place in the UI?

 

-Tony

--

To unsubscribe from this group and stop receiving emails from it, send an email to canvas-lms-use...@googlegroups.com.

For more options, visit https://groups.google.com/d/optout.

 

--

---
You received this message because you are subscribed to a topic in the Google Groups "Canvas LMS Users" group.
To unsubscribe from this topic, visit https://groups.google.com/d/topic/canvas-lms-users/mByu-DXsVCg/unsubscribe.
To unsubscribe from this group and all its topics, send an email to canvas-lms-use...@googlegroups.com.

[Cody Cutrer]

Tony,

I apologize for the slow response. You can deleted the job in the UI at /jobs, or you can do it directly in the database in the delayed_jobs table.

Cody Cutrer

Software Engineer

Instructure

On Thu, Sep 1, 2016 at 10:20 AM, <tony.h...@gmail.com> wrote:

Thank you, Cody! The job persists when the server is restarted, and when the DB and data are restored in clean install. Where does one directly delete the job? The DB? Or is there a place in the UI?

 

-Tony

 

From: Cody Cutrer
Sent: Thursday, September 1, 2016 10:15 PM
To: canvas-lms-users@googlegroups.com
Subject: Re: [Canvas] Failed course import, no stuck running job

 

Tony,

 

If the job is not actually running, just restarting jobs on the server it _was_ running on should get it to realize that and retry. Otherwise, you can directly delete the job.

 

Cody Cutrer

Software Engineer

Instructure

On Sat, Aug 20, 2016 at 9:53 AM, Tony <tony.h...@gmail.com> wrote:

I tried to import a course, but we ran out diskspace and then the import failed, but the job never terminated. It has been running for 3 days now and preventing the ability to import other courses. The courses imports are stuck on queued.

The job strand is: migrations:import content/100..001

 

Question: How to clear the running job so the other courses will import?

 

Many thanks,

Tony

--

---
You received this message because you are subscribed to the Google Groups "Canvas LMS Users" group.

To unsubscribe from this group and stop receiving emails from it, send an email to canvas-lms-users+unsubscribe@googlegroups.com.

For more options, visit https://groups.google.com/d/optout.

--

---
You received this message because you are subscribed to a topic in the Google Groups "Canvas LMS Users" group.
To unsubscribe from this topic, visit https://groups.google.com/d/topic/canvas-lms-users/mByu-DXsVCg/unsubscribe.

To unsubscribe from this group and all its topics, send an email to canvas-lms-users+unsubscribe@googlegroups.com.

[Tony]

Thanks, Cody! For some reason the UI wouldn't let me delete the job. I'll see if removing it from the DB allows the other jobs to run.

-Tony

--

To unsubscribe from this group and stop receiving emails from it, send an email to canvas-lms-use...@googlegroups.com.

For more options, visit https://groups.google.com/d/optout.

--

---
You received this message because you are subscribed to a topic in the Google Groups "Canvas LMS Users" group.
To unsubscribe from this topic, visit https://groups.google.com/d/topic/canvas-lms-users/mByu-DXsVCg/unsubscribe.

To unsubscribe from this group and all its topics, send an email to canvas-lms-use...@googlegroups.com.

[Graham Ballantyne]

How old is your Canvas release? The ability to delete jobs from the UI was added some time ago.  

-- 

Graham Ballantyne 

IT Services 

Simon Fraser University 

[Tony]

I pulled the latest stable from Git in Aug 2016, so it is recent. The delete button is there, but the job will not delete. This happened when I tried to import a course from Canvas Commons and ran out disk space. The running job comes back with a restored db. I'll see if removing the job from table delayed_jobs and if that clears it and allows the jobs regular jobs to run.

-Tony

[Tony]

Just to confirm: Removing the entry from the delayed_jobs table cleared the active job and jobs run as usual. Cody, thanks again for the location in the db!

-Tony