SMTP stopped sending emails

Keywords: Canvas LMS - Linux - Technical issue - Email configuration (SMTP)
bnsupport ID: 4df7a993-cf26-27a7-4a4d-8aaf45ab9919
Description:
we are using aws ec2 canvas bitnami lms version 2020.12.16.47-1, and the email was working for like 1 months, suddenly the emails stopped without changing anything in the outgoing_mail.yml , i tried to follow your recommendation here https://docs.bitnami.com/installer/apps/canvaslms/configuration/configure-smtp/

but still not working, below is the settings that we used in outgoing mail

production:
enable_starttls_auto: true
address: “smtp.postmarkapp.com
port: 587
user_name: “username”
password: “password”
authentication: plain

plain, login, or cram_md5

domain: “qasid.com
outgoing_address: “example@qasid.com
default_name: “Qasid Arabic Institute”

Hi @waleed,

Did you make any change in the application’s configuration lately?

What’s the content of the delayed_job.log and production.log files?

echo ###########################################
echo production.log
echo ###########################################
sudo tail -n 50 /opt/bitnami/apps/canvaslms/htdocs/log/production.log
echo ###########################################
echo delayed_job.log
echo ###########################################
sudo tail -n 50 /opt/bitnami/apps/canvaslms/htdocs/log/delayed_job.log

no i didn’t do any changes on the configuration.

here is the production log result:

 controller: quizzes/quiz_submissions
action: backup
course_id: ''5095''
quiz_id: ''15730''
context_id: ''5095''
context_type: Course
cnt: 1
question_92388: ''4200''
question_92389: ''6991''
question_92390: ''8634''
question_92391: ''2729''
question_92392: ''867''
question_92393: ''9350''
question_92394: ''8368''
question_92396: ''1983''
question_92397: ''2784''
question_92398: ''7889''
' WHERE "quiz_submissions"."id" = 40884 AND (workflow_state NOT IN ('complete', 'pending_review'))  [production:1 primary]
[c3a5d256b658e0391cb3d736a4d7668f 1b90b235-e946-4978-8149-8fc83f97efb2] Redis (0.296ms) get permissions/quizzes/quiz_submissions/40884-20210331130513289033/users/5539-20210331125257583431/default/record_events [127.0.0.1:6379]
[c3a5d256b658e0391cb3d736a4d7668f 1b90b235-e946-4978-8149-8fc83f97efb2]   SQL  (0.5ms)  BEGIN  [production:1 primary]
[c3a5d256b658e0391cb3d736a4d7668f 1b90b235-e946-4978-8149-8fc83f97efb2]   SQL Quizzes::QuizSubmission Load (0.9ms)  SELECT "quiz_submissions".* FROM "public"."quiz_submissions" WHERE "quiz_submissions"."id" = 40884 LIMIT 1  [production:1 primary]
[c3a5d256b658e0391cb3d736a4d7668f 1b90b235-e946-4978-8149-8fc83f97efb2]   SQL Quizzes::QuizSubmissionEvent Create (1.6ms)  INSERT INTO "public"."quiz_submission_events_2021_3" ("attempt", "event_type", "quiz_submission_id", "created_at", "client_timestamp", "root_account_id") VALUES (1, 'page_focused', 40884, '2021-03-31 14:40:17.144695', '2021-03-31 14:40:16.896000', 1) RETURNING "id"  [production:1 primary]
[c3a5d256b658e0391cb3d736a4d7668f 1b90b235-e946-4978-8149-8fc83f97efb2]   SQL  (1.7ms)  COMMIT  [production:1 primary]
[c3a5d256b658e0391cb3d736a4d7668f 0d33fdb9-4f6a-41db-98c5-ef4e2e1d536a]   SQL Quizzes::QuizSubmissionEvent Exists (1.1ms)  SELECT 1 AS one FROM "public"."quiz_submission_events" WHERE ( created_at >= '2021-03-31 13:05:13.224138'
AND created_at <= '2021-03-31 14:40:17.153776'
AND quiz_submission_id = 40884
AND attempt = 1
AND event_type = 'question_answered'
) LIMIT 1  [production:1 primary]
[c3a5d256b658e0391cb3d736a4d7668f 0d33fdb9-4f6a-41db-98c5-ef4e2e1d536a]   SQL Quizzes::QuizSubmissionEvent Load (1.4ms)  SELECT "quiz_submission_events".* FROM "public"."quiz_submission_events" WHERE ( created_at >= '2021-03-31 13:05:13.224138'
AND created_at <= '2021-03-31 14:40:17.153776'
AND quiz_submission_id = 40884
AND attempt = 1
AND event_type = 'question_answered'
) ORDER BY created_at DESC  [production:1 primary]
[c3a5d256b658e0391cb3d736a4d7668f 1b90b235-e946-4978-8149-8fc83f97efb2]   SQL Enrollment Update All (2.1ms)  UPDATE "public"."enrollments" SET "last_activity_at" = '2021-03-31 14:40:17.154567' WHERE "enrollments"."id" IN (SELECT "enrollments"."id" FROM "public"."enrollments" WHERE "enrollments"."course_id" = 5095 AND "enrollments"."user_id" = 5539 AND (last_activity_at IS NULL OR last_activity_at < '2021-03-31 14:38:17.154567') ORDER BY "enrollments"."id" ASC FOR NO KEY UPDATE)  [production:1 primary]
[c3a5d256b658e0391cb3d736a4d7668f 1b90b235-e946-4978-8149-8fc83f97efb2] Completed 204 No Content in 68ms (ActiveRecord: 11.7ms)
[c3a5d256b658e0391cb3d736a4d7668f 1b90b235-e946-4978-8149-8fc83f97efb2] [STATSD] (sql_read: 5.00) (sql_write: 3.00) (sql_cache: 0.00) (active_record: 6.00) (cache_read: 13.00) (total: 67.96) (db: 11.73)
[c3a5d256b658e0391cb3d736a4d7668f 1b90b235-e946-4978-8149-8fc83f97efb2] [STAT] 1030908 1030908 0 1030908 0.0580320000000043 0.007948999999999984
[c3a5d256b658e0391cb3d736a4d7668f 1b90b235-e946-4978-8149-8fc83f97efb2] request throttling increment: [0.06976358297024632,-50.0,1617201617.16039,["client_identifier","user:10000000005539"],["count",99.69537496566799],["last_touched",1617201617.0849]]
[c3a5d256b658e0391cb3d736a4d7668f 1b90b235-e946-4978-8149-8fc83f97efb2] Redis (0.367ms) evalsha - [127.0.0.1:6379]
[c3a5d256b658e0391cb3d736a4d7668f 0d33fdb9-4f6a-41db-98c5-ef4e2e1d536a]   SQL User Load (0.9ms)  SELECT "users".* FROM "public"."users" WHERE "users"."id" = 5539 LIMIT 1  [production:1 primary]
[c3a5d256b658e0391cb3d736a4d7668f 0d33fdb9-4f6a-41db-98c5-ef4e2e1d536a] Redis (0.262ms) get permissions/quizzes/quizzes/15730-20210331125256047499/users/5539-20210331125257583431/grade [127.0.0.1:6379]
[c3a5d256b658e0391cb3d736a4d7668f 0d33fdb9-4f6a-41db-98c5-ef4e2e1d536a]   SQL  (1.0ms)  SELECT MAX(enrollment_states.state_valid_until) FROM "public"."enrollments" INNER JOIN "public"."enrollment_states" ON "enrollment_states"."enrollment_id" = "enrollments"."id" WHERE "enrollments"."course_id" = 5095 AND (enrollments.workflow_state<>'deleted') AND "enrollments"."user_id" = 5539 AND (enrollment_states.state = 'active')  [production:1 primary]
[c3a5d256b658e0391cb3d736a4d7668f 0d33fdb9-4f6a-41db-98c5-ef4e2e1d536a]   SQL Enrollment Update All (1.0ms)  UPDATE "public"."enrollments" SET "last_activity_at" = '2021-03-31 14:40:17.183310' WHERE "enrollments"."id" IN (SELECT "enrollments"."id" FROM "public"."enrollments" WHERE "enrollments"."course_id" = 5095 AND "enrollments"."user_id" = 5539 AND (last_activity_at IS NULL OR last_activity_at < '2021-03-31 14:38:17.183310') ORDER BY "enrollments"."id" ASC FOR NO KEY UPDATE)  [production:1 primary]
[c3a5d256b658e0391cb3d736a4d7668f 0d33fdb9-4f6a-41db-98c5-ef4e2e1d536a] Completed 200 OK in 127ms (Views: 0.3ms | ActiveRecord: 20.5ms)
[c3a5d256b658e0391cb3d736a4d7668f 0d33fdb9-4f6a-41db-98c5-ef4e2e1d536a] [STATSD] (sql_read: 8.00) (sql_write: 4.00) (sql_cache: 0.00) (active_record: 50.00) (cache_read: 18.00) (total: 126.71) (view: 0.26) (db: 20.49)
[c3a5d256b658e0391cb3d736a4d7668f 0d33fdb9-4f6a-41db-98c5-ef4e2e1d536a] [STAT] 1131160 1131160 0 1131160 0.11555699999999547 0.0
[c3a5d256b658e0391cb3d736a4d7668f 0d33fdb9-4f6a-41db-98c5-ef4e2e1d536a] request throttling increment: [0.136046870992601,-50.0,1617201617.187944,["client_identifier","user:10000000005539"],["count",50.0],["last_touched",1617201617.0544]]
[c3a5d256b658e0391cb3d736a4d7668f 0d33fdb9-4f6a-41db-98c5-ef4e2e1d536a] Redis (0.309ms) evalsha - [127.0.0.1:6379]

and this is the delayed job result:

[- -]   SQL Delayed::Backend::ActiveRecord::Job Load (1.3ms)  WITH limited_jobs AS (SELECT id, ROW_NUMBER() OVER () AS row_number FROM (SELECT "delayed_jobs".* FROM "public"."delayed_jobs" WHERE (run_at<='2021-03-31 14:42:24.301153' AND locked_at IS NULL AND next_in_strand=TRUE) AND "delayed_jobs"."priority" BETWEEN 0 AND 1000000 AND "delayed_jobs"."queue" = 'canvas_queue' ORDER BY "delayed_jobs"."priority" ASC, "delayed_jobs"."run_at" ASC, "delayed_jobs"."id" ASC LIMIT 1 FOR UPDATE SKIP LOCKED) subquery) UPDATE "public"."delayed_jobs" SET locked_by = CASE row_number WHEN 1 THEN 'ip-172-31-0-95:20806' END, locked_at = '2021-03-31 14:42:24.302304' FROM limited_jobs WHERE limited_jobs.id="public"."delayed_jobs".id RETURNING "public"."delayed_jobs".*  [production:1 primary]
[- -]   SQL Delayed::Backend::ActiveRecord::Job Load (1.3ms)  WITH limited_jobs AS (SELECT id, ROW_NUMBER() OVER () AS row_number FROM (SELECT "delayed_jobs".* FROM "public"."delayed_jobs" WHERE (run_at<='2021-03-31 14:42:25.180453' AND locked_at IS NULL AND next_in_strand=TRUE) AND "delayed_jobs"."priority" BETWEEN 0 AND 10 AND "delayed_jobs"."queue" = 'canvas_queue' ORDER BY "delayed_jobs"."priority" ASC, "delayed_jobs"."run_at" ASC, "delayed_jobs"."id" ASC LIMIT 1 FOR UPDATE SKIP LOCKED) subquery) UPDATE "public"."delayed_jobs" SET locked_by = CASE row_number WHEN 1 THEN 'ip-172-31-0-95:20800' END, locked_at = '2021-03-31 14:42:25.181586' FROM limited_jobs WHERE limited_jobs.id="public"."delayed_jobs".id RETURNING "public"."delayed_jobs".*  [production:1 primary]
[- -]   SQL Delayed::Backend::ActiveRecord::Job Load (1.3ms)  WITH limited_jobs AS (SELECT id, ROW_NUMBER() OVER () AS row_number FROM (SELECT "delayed_jobs".* FROM "public"."delayed_jobs" WHERE (run_at<='2021-03-31 14:42:26.039213' AND locked_at IS NULL AND next_in_strand=TRUE) AND "delayed_jobs"."priority" BETWEEN 0 AND 1000000 AND "delayed_jobs"."queue" = 'canvas_queue' ORDER BY "delayed_jobs"."priority" ASC, "delayed_jobs"."run_at" ASC, "delayed_jobs"."id" ASC LIMIT 1 FOR UPDATE SKIP LOCKED) subquery) UPDATE "public"."delayed_jobs" SET locked_by = CASE row_number WHEN 1 THEN 'ip-172-31-0-95:20803' END, locked_at = '2021-03-31 14:42:26.040371' FROM limited_jobs WHERE limited_jobs.id="public"."delayed_jobs".id RETURNING "public"."delayed_jobs".*  [production:1 primary]
[- -]   SQL Delayed::Backend::ActiveRecord::Job Load (1.3ms)  WITH limited_jobs AS (SELECT id, ROW_NUMBER() OVER () AS row_number FROM (SELECT "delayed_jobs".* FROM "public"."delayed_jobs" WHERE (run_at<='2021-03-31 14:42:26.756720' AND locked_at IS NULL AND next_in_strand=TRUE) AND "delayed_jobs"."priority" BETWEEN 0 AND 1000000 AND "delayed_jobs"."queue" = 'canvas_queue' ORDER BY "delayed_jobs"."priority" ASC, "delayed_jobs"."run_at" ASC, "delayed_jobs"."id" ASC LIMIT 1 FOR UPDATE SKIP LOCKED) subquery) UPDATE "public"."delayed_jobs" SET locked_by = CASE row_number WHEN 1 THEN 'ip-172-31-0-95:20806' END, locked_at = '2021-03-31 14:42:26.757881' FROM limited_jobs WHERE limited_jobs.id="public"."delayed_jobs".id RETURNING "public"."delayed_jobs".*  [production:1 primary]
[- -]   SQL Delayed::Backend::ActiveRecord::Job Load (1.3ms)  WITH limited_jobs AS (SELECT id, ROW_NUMBER() OVER () AS row_number FROM (SELECT "delayed_jobs".* FROM "public"."delayed_jobs" WHERE (run_at<='2021-03-31 14:42:27.668526' AND locked_at IS NULL AND next_in_strand=TRUE) AND "delayed_jobs"."priority" BETWEEN 0 AND 10 AND "delayed_jobs"."queue" = 'canvas_queue' ORDER BY "delayed_jobs"."priority" ASC, "delayed_jobs"."run_at" ASC, "delayed_jobs"."id" ASC LIMIT 1 FOR UPDATE SKIP LOCKED) subquery) UPDATE "public"."delayed_jobs" SET locked_by = CASE row_number WHEN 1 THEN 'ip-172-31-0-95:20800' END, locked_at = '2021-03-31 14:42:27.669671' FROM limited_jobs WHERE limited_jobs.id="public"."delayed_jobs".id RETURNING "public"."delayed_jobs".*  [production:1 primary]
[- -]   SQL Delayed::Backend::ActiveRecord::Job Load (1.3ms)  WITH limited_jobs AS (SELECT id, ROW_NUMBER() OVER () AS row_number FROM (SELECT "delayed_jobs".* FROM "public"."delayed_jobs" WHERE (run_at<='2021-03-31 14:42:28.742571' AND locked_at IS NULL AND next_in_strand=TRUE) AND "delayed_jobs"."priority" BETWEEN 0 AND 1000000 AND "delayed_jobs"."queue" = 'canvas_queue' ORDER BY "delayed_jobs"."priority" ASC, "delayed_jobs"."run_at" ASC, "delayed_jobs"."id" ASC LIMIT 1 FOR UPDATE SKIP LOCKED) subquery) UPDATE "public"."delayed_jobs" SET locked_by = CASE row_number WHEN 1 THEN 'ip-172-31-0-95:20803' END, locked_at = '2021-03-31 14:42:28.743765' FROM limited_jobs WHERE limited_jobs.id="public"."delayed_jobs".id RETURNING "public"."delayed_jobs".*  [production:1 primary]
[- -]   SQL Delayed::Backend::ActiveRecord::Job Load (1.3ms)  WITH limited_jobs AS (SELECT id, ROW_NUMBER() OVER () AS row_number FROM (SELECT "delayed_jobs".* FROM "public"."delayed_jobs" WHERE (run_at<='2021-03-31 14:42:30.133996' AND locked_at IS NULL AND next_in_strand=TRUE) AND "delayed_jobs"."priority" BETWEEN 0 AND 1000000 AND "delayed_jobs"."queue" = 'canvas_queue' ORDER BY "delayed_jobs"."priority" ASC, "delayed_jobs"."run_at" ASC, "delayed_jobs"."id" ASC LIMIT 1 FOR UPDATE SKIP LOCKED) subquery) UPDATE "public"."delayed_jobs" SET locked_by = CASE row_number WHEN 1 THEN 'ip-172-31-0-95:20806' END, locked_at = '2021-03-31 14:42:30.135172' FROM limited_jobs WHERE limited_jobs.id="public"."delayed_jobs".id RETURNING "public"."delayed_jobs".*  [production:1 primary]
[- -]   SQL Delayed::Backend::ActiveRecord::Job Load (1.2ms)  WITH limited_jobs AS (SELECT id, ROW_NUMBER() OVER () AS row_number FROM (SELECT "delayed_jobs".* FROM "public"."delayed_jobs" WHERE (run_at<='2021-03-31 14:42:30.820945' AND locked_at IS NULL AND next_in_strand=TRUE) AND "delayed_jobs"."priority" BETWEEN 0 AND 10 AND "delayed_jobs"."queue" = 'canvas_queue' ORDER BY "delayed_jobs"."priority" ASC, "delayed_jobs"."run_at" ASC, "delayed_jobs"."id" ASC LIMIT 1 FOR UPDATE SKIP LOCKED) subquery) UPDATE "public"."delayed_jobs" SET locked_by = CASE row_number WHEN 1 THEN 'ip-172-31-0-95:20800' END, locked_at = '2021-03-31 14:42:30.822068' FROM limited_jobs WHERE limited_jobs.id="public"."delayed_jobs".id RETURNING "public"."delayed_jobs".*  [production:1 primary]
[- -]   SQL Delayed::Backend::ActiveRecord::Job Load (1.3ms)  WITH limited_jobs AS (SELECT id, ROW_NUMBER() OVER () AS row_number FROM (SELECT "delayed_jobs".* FROM "public"."delayed_jobs" WHERE (run_at<='2021-03-31 14:42:30.995135' AND locked_at IS NULL AND next_in_strand=TRUE) AND "delayed_jobs"."priority" BETWEEN 0 AND 1000000 AND "delayed_jobs"."queue" = 'canvas_queue' ORDER BY "delayed_jobs"."priority" ASC, "delayed_jobs"."run_at" ASC, "delayed_jobs"."id" ASC LIMIT 1 FOR UPDATE SKIP LOCKED) subquery) UPDATE "public"."delayed_jobs" SET locked_by = CASE row_number WHEN 1 THEN 'ip-172-31-0-95:20803' END, locked_at = '2021-03-31 14:42:30.996279' FROM limited_jobs WHERE limited_jobs.id="public"."delayed_jobs".id RETURNING "public"."delayed_jobs".*  [production:1 primary]
[- -]   SQL Delayed::Backend::ActiveRecord::Job Load (1.2ms)  WITH limited_jobs AS (SELECT id, ROW_NUMBER() OVER () AS row_number FROM (SELECT "delayed_jobs".* FROM "public"."delayed_jobs" WHERE (run_at<='2021-03-31 14:42:32.527624' AND locked_at IS NULL AND next_in_strand=TRUE) AND "delayed_jobs"."priority" BETWEEN 0 AND 1000000 AND "delayed_jobs"."queue" = 'canvas_queue' ORDER BY "delayed_jobs"."priority" ASC, "delayed_jobs"."run_at" ASC, "delayed_jobs"."id" ASC LIMIT 1 FOR UPDATE SKIP LOCKED) subquery) UPDATE "public"."delayed_jobs" SET locked_by = CASE row_number WHEN 1 THEN 'ip-172-31-0-95:20806' END, locked_at = '2021-03-31 14:42:32.528769' FROM limited_jobs WHERE limited_jobs.id="public"."delayed_jobs".id RETURNING "public"."delayed_jobs".*  [production:1 primary]
[- -]   SQL Delayed::Backend::ActiveRecord::Job Load (1.3ms)  WITH limited_jobs AS (SELECT id, ROW_NUMBER() OVER () AS row_number FROM (SELECT "delayed_jobs".* FROM "public"."delayed_jobs" WHERE (run_at<='2021-03-31 14:42:33.433865' AND locked_at IS NULL AND next_in_strand=TRUE) AND "delayed_jobs"."priority" BETWEEN 0 AND 10 AND "delayed_jobs"."queue" = 'canvas_queue' ORDER BY "delayed_jobs"."priority" ASC, "delayed_jobs"."run_at" ASC, "delayed_jobs"."id" ASC LIMIT 1 FOR UPDATE SKIP LOCKED) subquery) UPDATE "public"."delayed_jobs" SET locked_by = CASE row_number WHEN 1 THEN 'ip-172-31-0-95:20800' END, locked_at = '2021-03-31 14:42:33.435055' FROM limited_jobs WHERE limited_jobs.id="public"."delayed_jobs".id RETURNING "public"."delayed_jobs".*  [production:1 primary]
[- -]   SQL Delayed::Backend::ActiveRecord::Job Load (1.5ms)  WITH limited_jobs AS (SELECT id, ROW_NUMBER() OVER () AS row_number FROM (SELECT "delayed_jobs".* FROM "public"."delayed_jobs" WHERE (run_at<='2021-03-31 14:42:34.039989' AND locked_at IS NULL AND next_in_strand=TRUE) AND "delayed_jobs"."priority" BETWEEN 0 AND 1000000 AND "delayed_jobs"."queue" = 'canvas_queue' ORDER BY "delayed_jobs"."priority" ASC, "delayed_jobs"."run_at" ASC, "delayed_jobs"."id" ASC LIMIT 1 FOR UPDATE SKIP LOCKED) subquery) UPDATE "public"."delayed_jobs" SET locked_by = CASE row_number WHEN 1 THEN 'ip-172-31-0-95:20803' END, locked_at = '2021-03-31 14:42:34.041134' FROM limited_jobs WHERE limited_jobs.id="public"."delayed_jobs".id RETURNING "public"."delayed_jobs".*  [production:1 primary]
[- -]   SQL Delayed::Backend::ActiveRecord::Job Load (1.3ms)  WITH limited_jobs AS (SELECT id, ROW_NUMBER() OVER () AS row_number FROM (SELECT "delayed_jobs".* FROM "public"."delayed_jobs" WHERE (run_at<='2021-03-31 14:42:36.315370' AND locked_at IS NULL AND next_in_strand=TRUE) AND "delayed_jobs"."priority" BETWEEN 0 AND 1000000 AND "delayed_jobs"."queue" = 'canvas_queue' ORDER BY "delayed_jobs"."priority" ASC, "delayed_jobs"."run_at" ASC, "delayed_jobs"."id" ASC LIMIT 1 FOR UPDATE SKIP LOCKED) subquery) UPDATE "public"."delayed_jobs" SET locked_by = CASE row_number WHEN 1 THEN 'ip-172-31-0-95:20806' END, locked_at = '2021-03-31 14:42:36.316532' FROM limited_jobs WHERE limited_jobs.id="public"."delayed_jobs".id RETURNING "public"."delayed_jobs".*  [production:1 primary]
[- -]   SQL Delayed::Backend::ActiveRecord::Job Load (1.4ms)  WITH limited_jobs AS (SELECT id, ROW_NUMBER() OVER () AS row_number FROM (SELECT "delayed_jobs".* FROM "public"."delayed_jobs" WHERE (run_at<='2021-03-31 14:42:36.442717' AND locked_at IS NULL AND next_in_strand=TRUE) AND "delayed_jobs"."priority" BETWEEN 0 AND 1000000 AND "delayed_jobs"."queue" = 'canvas_queue' ORDER BY "delayed_jobs"."priority" ASC, "delayed_jobs"."run_at" ASC, "delayed_jobs"."id" ASC LIMIT 1 FOR UPDATE SKIP LOCKED) subquery) UPDATE "public"."delayed_jobs" SET locked_by = CASE row_number WHEN 1 THEN 'ip-172-31-0-95:20803' END, locked_at = '2021-03-31 14:42:36.443855' FROM limited_jobs WHERE limited_jobs.id="public"."delayed_jobs".id RETURNING "public"."delayed_jobs".*  [production:1 primary]
[- -]   SQL Delayed::Backend::ActiveRecord::Job Load (1.2ms)  WITH limited_jobs AS (SELECT id, ROW_NUMBER() OVER () AS row_number FROM (SELECT "delayed_jobs".* FROM "public"."delayed_jobs" WHERE (run_at<='2021-03-31 14:42:36.912862' AND locked_at IS NULL AND next_in_strand=TRUE) AND "delayed_jobs"."priority" BETWEEN 0 AND 10 AND "delayed_jobs"."queue" = 'canvas_queue' ORDER BY "delayed_jobs"."priority" ASC, "delayed_jobs"."run_at" ASC, "delayed_jobs"."id" ASC LIMIT 1 FOR UPDATE SKIP LOCKED) subquery) UPDATE "public"."delayed_jobs" SET locked_by = CASE row_number WHEN 1 THEN 'ip-172-31-0-95:20800' END, locked_at = '2021-03-31 14:42:36.913993' FROM limited_jobs WHERE limited_jobs.id="public"."delayed_jobs".id RETURNING "public"."delayed_jobs".*  [production:1 primary]
[- -]   SQL Delayed::Backend::ActiveRecord::Job Load (1.1ms)  WITH limited_jobs AS (SELECT id, ROW_NUMBER() OVER () AS row_number FROM (SELECT "delayed_jobs".* FROM "public"."delayed_jobs" WHERE (run_at<='2021-03-31 14:42:39.669994' AND locked_at IS NULL AND next_in_strand=TRUE) AND "delayed_jobs"."priority" BETWEEN 0 AND 1000000 AND "delayed_jobs"."queue" = 'canvas_queue' ORDER BY "delayed_jobs"."priority" ASC, "delayed_jobs"."run_at" ASC, "delayed_jobs"."id" ASC LIMIT 1 FOR UPDATE SKIP LOCKED) subquery) UPDATE "public"."delayed_jobs" SET locked_by = CASE row_number WHEN 1 THEN 'ip-172-31-0-95:20806' END, locked_at = '2021-03-31 14:42:39.671204' FROM limited_jobs WHERE limited_jobs.id="public"."delayed_jobs".id RETURNING "public"."delayed_jobs".*  [production:1 primary]
[- -]   SQL Delayed::Backend::ActiveRecord::Job Load (2.3ms)  WITH limited_jobs AS (SELECT id, ROW_NUMBER() OVER () AS row_number FROM (SELECT "delayed_jobs".* FROM "public"."delayed_jobs" WHERE (run_at<='2021-03-31 14:42:39.707365' AND locked_at IS NULL AND next_in_strand=TRUE) AND "delayed_jobs"."priority" BETWEEN 0 AND 1000000 AND "delayed_jobs"."queue" = 'canvas_queue' ORDER BY "delayed_jobs"."priority" ASC, "delayed_jobs"."run_at" ASC, "delayed_jobs"."id" ASC LIMIT 1 FOR UPDATE SKIP LOCKED) subquery) UPDATE "public"."delayed_jobs" SET locked_by = CASE row_number WHEN 1 THEN 'ip-172-31-0-95:20803' END, locked_at = '2021-03-31 14:42:39.708500' FROM limited_jobs WHERE limited_jobs.id="public"."delayed_jobs".id RETURNING "public"."delayed_jobs".*  [production:1 primary]
[- -]   SQL Delayed::Backend::ActiveRecord::Job Load (1.3ms)  WITH limited_jobs AS (SELECT id, ROW_NUMBER() OVER () AS row_number FROM (SELECT "delayed_jobs".* FROM "public"."delayed_jobs" WHERE (run_at<='2021-03-31 14:42:39.792596' AND locked_at IS NULL AND next_in_strand=TRUE) AND "delayed_jobs"."priority" BETWEEN 0 AND 10 AND "delayed_jobs"."queue" = 'canvas_queue' ORDER BY "delayed_jobs"."priority" ASC, "delayed_jobs"."run_at" ASC, "delayed_jobs"."id" ASC LIMIT 1 FOR UPDATE SKIP LOCKED) subquery) UPDATE "public"."delayed_jobs" SET locked_by = CASE row_number WHEN 1 THEN 'ip-172-31-0-95:20800' END, locked_at = '2021-03-31 14:42:39.793706' FROM limited_jobs WHERE limited_jobs.id="public"."delayed_jobs".id RETURNING "public"."delayed_jobs".*  [production:1 primary]
[- -]   SQL Delayed::Backend::ActiveRecord::Job Load (1.2ms)  WITH limited_jobs AS (SELECT id, ROW_NUMBER() OVER () AS row_number FROM (SELECT "delayed_jobs".* FROM "public"."delayed_jobs" WHERE (run_at<='2021-03-31 14:42:41.813434' AND locked_at IS NULL AND next_in_strand=TRUE) AND "delayed_jobs"."priority" BETWEEN 0 AND 1000000 AND "delayed_jobs"."queue" = 'canvas_queue' ORDER BY "delayed_jobs"."priority" ASC, "delayed_jobs"."run_at" ASC, "delayed_jobs"."id" ASC LIMIT 1 FOR UPDATE SKIP LOCKED) subquery) UPDATE "public"."delayed_jobs" SET locked_by = CASE row_number WHEN 1 THEN 'ip-172-31-0-95:20803' END, locked_at = '2021-03-31 14:42:41.814596' FROM limited_jobs WHERE limited_jobs.id="public"."delayed_jobs".id RETURNING "public"."delayed_jobs".*  [production:1 primary]
[- -]   SQL Delayed::Backend::ActiveRecord::Job Load (1.4ms)  WITH limited_jobs AS (SELECT id, ROW_NUMBER() OVER () AS row_number FROM (SELECT "delayed_jobs".* FROM "public"."delayed_jobs" WHERE (run_at<='2021-03-31 14:42:43.147745' AND locked_at IS NULL AND next_in_strand=TRUE) AND "delayed_jobs"."priority" BETWEEN 0 AND 1000000 AND "delayed_jobs"."queue" = 'canvas_queue' ORDER BY "delayed_jobs"."priority" ASC, "delayed_jobs"."run_at" ASC, "delayed_jobs"."id" ASC LIMIT 1 FOR UPDATE SKIP LOCKED) subquery) UPDATE "public"."delayed_jobs" SET locked_by = CASE row_number WHEN 1 THEN 'ip-172-31-0-95:20806' END, locked_at = '2021-03-31 14:42:43.148908' FROM limited_jobs WHERE limited_jobs.id="public"."delayed_jobs".id RETURNING "public"."delayed_jobs".*  [production:1 primary]
[- -]   SQL Delayed::Backend::ActiveRecord::Job Load (1.1ms)  WITH limited_jobs AS (SELECT id, ROW_NUMBER() OVER () AS row_number FROM (SELECT "delayed_jobs".* FROM "public"."delayed_jobs" WHERE (run_at<='2021-03-31 14:42:43.635416' AND locked_at IS NULL AND next_in_strand=TRUE) AND "delayed_jobs"."priority" BETWEEN 0 AND 10 AND "delayed_jobs"."queue" = 'canvas_queue' ORDER BY "delayed_jobs"."priority" ASC, "delayed_jobs"."run_at" ASC, "delayed_jobs"."id" ASC LIMIT 1 FOR UPDATE SKIP LOCKED) subquery) UPDATE "public"."delayed_jobs" SET locked_by = CASE row_number WHEN 1 THEN 'ip-172-31-0-95:20800' END, locked_at = '2021-03-31 14:42:43.636816' FROM limited_jobs WHERE limited_jobs.id="public"."delayed_jobs".id RETURNING "public"."delayed_jobs".*  [production:1 primary]
[- -]   SQL Delayed::Backend::ActiveRecord::Job Load (1.4ms)  WITH limited_jobs AS (SELECT id, ROW_NUMBER() OVER () AS row_number FROM (SELECT "delayed_jobs".* FROM "public"."delayed_jobs" WHERE (run_at<='2021-03-31 14:42:44.101696' AND locked_at IS NULL AND next_in_strand=TRUE) AND "delayed_jobs"."priority" BETWEEN 0 AND 1000000 AND "delayed_jobs"."queue" = 'canvas_queue' ORDER BY "delayed_jobs"."priority" ASC, "delayed_jobs"."run_at" ASC, "delayed_jobs"."id" ASC LIMIT 1 FOR UPDATE SKIP LOCKED) subquery) UPDATE "public"."delayed_jobs" SET locked_by = CASE row_number WHEN 1 THEN 'ip-172-31-0-95:20803' END, locked_at = '2021-03-31 14:42:44.102880' FROM limited_jobs WHERE limited_jobs.id="public"."delayed_jobs".id RETURNING "public"."delayed_jobs".*  [production:1 primary]
[- -]   SQL Delayed::Backend::ActiveRecord::Job Load (1.3ms)  WITH limited_jobs AS (SELECT id, ROW_NUMBER() OVER () AS row_number FROM (SELECT "delayed_jobs".* FROM "public"."delayed_jobs" WHERE (run_at<='2021-03-31 14:42:45.350434' AND locked_at IS NULL AND next_in_strand=TRUE) AND "delayed_jobs"."priority" BETWEEN 0 AND 1000000 AND "delayed_jobs"."queue" = 'canvas_queue' ORDER BY "delayed_jobs"."priority" ASC, "delayed_jobs"."run_at" ASC, "delayed_jobs"."id" ASC LIMIT 1 FOR UPDATE SKIP LOCKED) subquery) UPDATE "public"."delayed_jobs" SET locked_by = CASE row_number WHEN 1 THEN 'ip-172-31-0-95:20806' END, locked_at = '2021-03-31 14:42:45.351649' FROM limited_jobs WHERE limited_jobs.id="public"."delayed_jobs".id RETURNING "public"."delayed_jobs".*  [production:1 primary]
[- -]   SQL Delayed::Backend::ActiveRecord::Job Load (1.1ms)  WITH limited_jobs AS (SELECT id, ROW_NUMBER() OVER () AS row_number FROM (SELECT "delayed_jobs".* FROM "public"."delayed_jobs" WHERE (run_at<='2021-03-31 14:42:46.269809' AND locked_at IS NULL AND next_in_strand=TRUE) AND "delayed_jobs"."priority" BETWEEN 0 AND 10 AND "delayed_jobs"."queue" = 'canvas_queue' ORDER BY "delayed_jobs"."priority" ASC, "delayed_jobs"."run_at" ASC, "delayed_jobs"."id" ASC LIMIT 1 FOR UPDATE SKIP LOCKED) subquery) UPDATE "public"."delayed_jobs" SET locked_by = CASE row_number WHEN 1 THEN 'ip-172-31-0-95:20800' END, locked_at = '2021-03-31 14:42:46.270977' FROM limited_jobs WHERE limited_jobs.id="public"."delayed_jobs".id RETURNING "public"."delayed_jobs".*  [production:1 primary]
[- -]   SQL Delayed::Backend::ActiveRecord::Job Load (1.2ms)  WITH limited_jobs AS (SELECT id, ROW_NUMBER() OVER () AS row_number FROM (SELECT "delayed_jobs".* FROM "public"."delayed_jobs" WHERE (run_at<='2021-03-31 14:42:46.637457' AND locked_at IS NULL AND next_in_strand=TRUE) AND "delayed_jobs"."priority" BETWEEN 0 AND 1000000 AND "delayed_jobs"."queue" = 'canvas_queue' ORDER BY "delayed_jobs"."priority" ASC, "delayed_jobs"."run_at" ASC, "delayed_jobs"."id" ASC LIMIT 1 FOR UPDATE SKIP LOCKED) subquery) UPDATE "public"."delayed_jobs" SET locked_by = CASE row_number WHEN 1 THEN 'ip-172-31-0-95:20803' END, locked_at = '2021-03-31 14:42:46.638630' FROM limited_jobs WHERE limited_jobs.id="public"."delayed_jobs".id RETURNING "public"."delayed_jobs".*  [production:1 primary]
[- -]   SQL Delayed::Backend::ActiveRecord::Job Load (1.2ms)  WITH limited_jobs AS (SELECT id, ROW_NUMBER() OVER () AS row_number FROM (SELECT "delayed_jobs".* FROM "public"."delayed_jobs" WHERE (run_at<='2021-03-31 14:42:48.614855' AND locked_at IS NULL AND next_in_strand=TRUE) AND "delayed_jobs"."priority" BETWEEN 0 AND 1000000 AND "delayed_jobs"."queue" = 'canvas_queue' ORDER BY "delayed_jobs"."priority" ASC, "delayed_jobs"."run_at" ASC, "delayed_jobs"."id" ASC LIMIT 1 FOR UPDATE SKIP LOCKED) subquery) UPDATE "public"."delayed_jobs" SET locked_by = CASE row_number WHEN 1 THEN 'ip-172-31-0-95:20806' END, locked_at = '2021-03-31 14:42:48.616009' FROM limited_jobs WHERE limited_jobs.id="public"."delayed_jobs".id RETURNING "public"."delayed_jobs".*  [production:1 primary]
[- -]   SQL Delayed::Backend::ActiveRecord::Job Load (1.2ms)  WITH limited_jobs AS (SELECT id, ROW_NUMBER() OVER () AS row_number FROM (SELECT "delayed_jobs".* FROM "public"."delayed_jobs" WHERE (run_at<='2021-03-31 14:42:49.107073' AND locked_at IS NULL AND next_in_strand=TRUE) AND "delayed_jobs"."priority" BETWEEN 0 AND 10 AND "delayed_jobs"."queue" = 'canvas_queue' ORDER BY "delayed_jobs"."priority" ASC, "delayed_jobs"."run_at" ASC, "delayed_jobs"."id" ASC LIMIT 1 FOR UPDATE SKIP LOCKED) subquery) UPDATE "public"."delayed_jobs" SET locked_by = CASE row_number WHEN 1 THEN 'ip-172-31-0-95:20800' END, locked_at = '2021-03-31 14:42:49.108215' FROM limited_jobs WHERE limited_jobs.id="public"."delayed_jobs".id RETURNING "public"."delayed_jobs".*  [production:1 primary]
[- -]   SQL Delayed::Backend::ActiveRecord::Job Load (2.3ms)  WITH limited_jobs AS (SELECT id, ROW_NUMBER() OVER () AS row_number FROM (SELECT "delayed_jobs".* FROM "public"."delayed_jobs" WHERE (run_at<='2021-03-31 14:42:50.015426' AND locked_at IS NULL AND next_in_strand=TRUE) AND "delayed_jobs"."priority" BETWEEN 0 AND 1000000 AND "delayed_jobs"."queue" = 'canvas_queue' ORDER BY "delayed_jobs"."priority" ASC, "delayed_jobs"."run_at" ASC, "delayed_jobs"."id" ASC LIMIT 1 FOR UPDATE SKIP LOCKED) subquery) UPDATE "public"."delayed_jobs" SET locked_by = CASE row_number WHEN 1 THEN 'ip-172-31-0-95:20803' END, locked_at = '2021-03-31 14:42:50.016987' FROM limited_jobs WHERE limited_jobs.id="public"."delayed_jobs".id RETURNING "public"."delayed_jobs".*  [production:1 primary]
[- -]   SQL Delayed::Backend::ActiveRecord::Job Load (1.4ms)  WITH limited_jobs AS (SELECT id, ROW_NUMBER() OVER () AS row_number FROM (SELECT "delayed_jobs".* FROM "public"."delayed_jobs" WHERE (run_at<='2021-03-31 14:42:50.987171' AND locked_at IS NULL AND next_in_strand=TRUE) AND "delayed_jobs"."priority" BETWEEN 0 AND 1000000 AND "delayed_jobs"."queue" = 'canvas_queue' ORDER BY "delayed_jobs"."priority" ASC, "delayed_jobs"."run_at" ASC, "delayed_jobs"."id" ASC LIMIT 1 FOR UPDATE SKIP LOCKED) subquery) UPDATE "public"."delayed_jobs" SET locked_by = CASE row_number WHEN 1 THEN 'ip-172-31-0-95:20806' END, locked_at = '2021-03-31 14:42:50.988323' FROM limited_jobs WHERE limited_jobs.id="public"."delayed_jobs".id RETURNING "public"."delayed_jobs".*  [production:1 primary]
[- -]   SQL Delayed::Backend::ActiveRecord::Job Load (1.3ms)  WITH limited_jobs AS (SELECT id, ROW_NUMBER() OVER () AS row_number FROM (SELECT "delayed_jobs".* FROM "public"."delayed_jobs" WHERE (run_at<='2021-03-31 14:42:52.549074' AND locked_at IS NULL AND next_in_strand=TRUE) AND "delayed_jobs"."priority" BETWEEN 0 AND 10 AND "delayed_jobs"."queue" = 'canvas_queue' ORDER BY "delayed_jobs"."priority" ASC, "delayed_jobs"."run_at" ASC, "delayed_jobs"."id" ASC LIMIT 1 FOR UPDATE SKIP LOCKED) subquery) UPDATE "public"."delayed_jobs" SET locked_by = CASE row_number WHEN 1 THEN 'ip-172-31-0-95:20800' END, locked_at = '2021-03-31 14:42:52.550220' FROM limited_jobs WHERE limited_jobs.id="public"."delayed_jobs".id RETURNING "public"."delayed_jobs".*  [production:1 primary]
[- -]   SQL Delayed::Backend::ActiveRecord::Job Load (1.2ms)  WITH limited_jobs AS (SELECT id, ROW_NUMBER() OVER () AS row_number FROM (SELECT "delayed_jobs".* FROM "public"."delayed_jobs" WHERE (run_at<='2021-03-31 14:42:53.233167' AND locked_at IS NULL AND next_in_strand=TRUE) AND "delayed_jobs"."priority" BETWEEN 0 AND 1000000 AND "delayed_jobs"."queue" = 'canvas_queue' ORDER BY "delayed_jobs"."priority" ASC, "delayed_jobs"."run_at" ASC, "delayed_jobs"."id" ASC LIMIT 1 FOR UPDATE SKIP LOCKED) subquery) UPDATE "public"."delayed_jobs" SET locked_by = CASE row_number WHEN 1 THEN 'ip-172-31-0-95:20806' END, locked_at = '2021-03-31 14:42:53.234337' FROM limited_jobs WHERE limited_jobs.id="public"."delayed_jobs".id RETURNING "public"."delayed_jobs".*  [production:1 primary]
[- -]   SQL Delayed::Backend::ActiveRecord::Job Load (1.2ms)  WITH limited_jobs AS (SELECT id, ROW_NUMBER() OVER () AS row_number FROM (SELECT "delayed_jobs".* FROM "public"."delayed_jobs" WHERE (run_at<='2021-03-31 14:42:53.775366' AND locked_at IS NULL AND next_in_strand=TRUE) AND "delayed_jobs"."priority" BETWEEN 0 AND 1000000 AND "delayed_jobs"."queue" = 'canvas_queue' ORDER BY "delayed_jobs"."priority" ASC, "delayed_jobs"."run_at" ASC, "delayed_jobs"."id" ASC LIMIT 1 FOR UPDATE SKIP LOCKED) subquery) UPDATE "public"."delayed_jobs" SET locked_by = CASE row_number WHEN 1 THEN 'ip-172-31-0-95:20803' END, locked_at = '2021-03-31 14:42:53.776539' FROM limited_jobs WHERE limited_jobs.id="public"."delayed_jobs".id RETURNING "public"."delayed_jobs".*  [production:1 primary]
[- -]   SQL Delayed::Backend::ActiveRecord::Job Load (1.2ms)  WITH limited_jobs AS (SELECT id, ROW_NUMBER() OVER () AS row_number FROM (SELECT "delayed_jobs".* FROM "public"."delayed_jobs" WHERE (run_at<='2021-03-31 14:42:54.692609' AND locked_at IS NULL AND next_in_strand=TRUE) AND "delayed_jobs"."priority" BETWEEN 0 AND 10 AND "delayed_jobs"."queue" = 'canvas_queue' ORDER BY "delayed_jobs"."priority" ASC, "delayed_jobs"."run_at" ASC, "delayed_jobs"."id" ASC LIMIT 1 FOR UPDATE SKIP LOCKED) subquery) UPDATE "public"."delayed_jobs" SET locked_by = CASE row_number WHEN 1 THEN 'ip-172-31-0-95:20800' END, locked_at = '2021-03-31 14:42:54.693755' FROM limited_jobs WHERE limited_jobs.id="public"."delayed_jobs".id RETURNING "public"."delayed_jobs".*  [production:1 primary]
[- -]   SQL Delayed::Backend::ActiveRecord::Job Load (1.5ms)  WITH limited_jobs AS (SELECT id, ROW_NUMBER() OVER () AS row_number FROM (SELECT "delayed_jobs".* FROM "public"."delayed_jobs" WHERE (run_at<='2021-03-31 14:42:56.140624' AND locked_at IS NULL AND next_in_strand=TRUE) AND "delayed_jobs"."priority" BETWEEN 0 AND 1000000 AND "delayed_jobs"."queue" = 'canvas_queue' ORDER BY "delayed_jobs"."priority" ASC, "delayed_jobs"."run_at" ASC, "delayed_jobs"."id" ASC LIMIT 1 FOR UPDATE SKIP LOCKED) subquery) UPDATE "public"."delayed_jobs" SET locked_by = CASE row_number WHEN 1 THEN 'ip-172-31-0-95:20806' END, locked_at = '2021-03-31 14:42:56.141883' FROM limited_jobs WHERE limited_jobs.id="public"."delayed_jobs".id RETURNING "public"."delayed_jobs".*  [production:1 primary]
[- -]   SQL Delayed::Backend::ActiveRecord::Job Load (1.3ms)  WITH limited_jobs AS (SELECT id, ROW_NUMBER() OVER () AS row_number FROM (SELECT "delayed_jobs".* FROM "public"."delayed_jobs" WHERE (run_at<='2021-03-31 14:42:57.135362' AND locked_at IS NULL AND next_in_strand=TRUE) AND "delayed_jobs"."priority" BETWEEN 0 AND 1000000 AND "delayed_jobs"."queue" = 'canvas_queue' ORDER BY "delayed_jobs"."priority" ASC, "delayed_jobs"."run_at" ASC, "delayed_jobs"."id" ASC LIMIT 1 FOR UPDATE SKIP LOCKED) subquery) UPDATE "public"."delayed_jobs" SET locked_by = CASE row_number WHEN 1 THEN 'ip-172-31-0-95:20803' END, locked_at = '2021-03-31 14:42:57.136529' FROM limited_jobs WHERE limited_jobs.id="public"."delayed_jobs".id RETURNING "public"."delayed_jobs".*  [production:1 primary]
[- -]   SQL Delayed::Backend::ActiveRecord::Job Load (1.2ms)  WITH limited_jobs AS (SELECT id, ROW_NUMBER() OVER () AS row_number FROM (SELECT "delayed_jobs".* FROM "public"."delayed_jobs" WHERE (run_at<='2021-03-31 14:42:57.529848' AND locked_at IS NULL AND next_in_strand=TRUE) AND "delayed_jobs"."priority" BETWEEN 0 AND 10 AND "delayed_jobs"."queue" = 'canvas_queue' ORDER BY "delayed_jobs"."priority" ASC, "delayed_jobs"."run_at" ASC, "delayed_jobs"."id" ASC LIMIT 1 FOR UPDATE SKIP LOCKED) subquery) UPDATE "public"."delayed_jobs" SET locked_by = CASE row_number WHEN 1 THEN 'ip-172-31-0-95:20800' END, locked_at = '2021-03-31 14:42:57.531013' FROM limited_jobs WHERE limited_jobs.id="public"."delayed_jobs".id RETURNING "public"."delayed_jobs".*  [production:1 primary]
[- -]   SQL Delayed::Backend::ActiveRecord::Job Load (2.0ms)  WITH limited_jobs AS (SELECT id, ROW_NUMBER() OVER () AS row_number FROM (SELECT "delayed_jobs".* FROM "public"."delayed_jobs" WHERE (run_at<='2021-03-31 14:42:59.110315' AND locked_at IS NULL AND next_in_strand=TRUE) AND "delayed_jobs"."priority" BETWEEN 0 AND 1000000 AND "delayed_jobs"."queue" = 'canvas_queue' ORDER BY "delayed_jobs"."priority" ASC, "delayed_jobs"."run_at" ASC, "delayed_jobs"."id" ASC LIMIT 1 FOR UPDATE SKIP LOCKED) subquery) UPDATE "public"."delayed_jobs" SET locked_by = CASE row_number WHEN 1 THEN 'ip-172-31-0-95:20806' END, locked_at = '2021-03-31 14:42:59.111510' FROM limited_jobs WHERE limited_jobs.id="public"."delayed_jobs".id RETURNING "public"."delayed_jobs".*  [production:1 primary]
[- -]   SQL Delayed::Backend::ActiveRecord::Job Load (1.2ms)  WITH limited_jobs AS (SELECT id, ROW_NUMBER() OVER () AS row_number FROM (SELECT "delayed_jobs".* FROM "public"."delayed_jobs" WHERE (run_at<='2021-03-31 14:43:00.872137' AND locked_at IS NULL AND next_in_strand=TRUE) AND "delayed_jobs"."priority" BETWEEN 0 AND 1000000 AND "delayed_jobs"."queue" = 'canvas_queue' ORDER BY "delayed_jobs"."priority" ASC, "delayed_jobs"."run_at" ASC, "delayed_jobs"."id" ASC LIMIT 1 FOR UPDATE SKIP LOCKED) subquery) UPDATE "public"."delayed_jobs" SET locked_by = CASE row_number WHEN 1 THEN 'ip-172-31-0-95:20803' END, locked_at = '2021-03-31 14:43:00.873319' FROM limited_jobs WHERE limited_jobs.id="public"."delayed_jobs".id RETURNING "public"."delayed_jobs".*  [production:1 primary]
[- -]   SQL Delayed::Backend::ActiveRecord::Job Load (1.2ms)  WITH limited_jobs AS (SELECT id, ROW_NUMBER() OVER () AS row_number FROM (SELECT "delayed_jobs".* FROM "public"."delayed_jobs" WHERE (run_at<='2021-03-31 14:43:01.184878' AND locked_at IS NULL AND next_in_strand=TRUE) AND "delayed_jobs"."priority" BETWEEN 0 AND 10 AND "delayed_jobs"."queue" = 'canvas_queue' ORDER BY "delayed_jobs"."priority" ASC, "delayed_jobs"."run_at" ASC, "delayed_jobs"."id" ASC LIMIT 1 FOR UPDATE SKIP LOCKED) subquery) UPDATE "public"."delayed_jobs" SET locked_by = CASE row_number WHEN 1 THEN 'ip-172-31-0-95:20800' END, locked_at = '2021-03-31 14:43:01.186005' FROM limited_jobs WHERE limited_jobs.id="public"."delayed_jobs".id RETURNING "public"."delayed_jobs".*  [production:1 primary]
[- -]   SQL Delayed::Backend::ActiveRecord::Job Load (1.2ms)  WITH limited_jobs AS (SELECT id, ROW_NUMBER() OVER () AS row_number FROM (SELECT "delayed_jobs".* FROM "public"."delayed_jobs" WHERE (run_at<='2021-03-31 14:43:01.192322' AND locked_at IS NULL AND next_in_strand=TRUE) AND "delayed_jobs"."priority" BETWEEN 0 AND 1000000 AND "delayed_jobs"."queue" = 'canvas_queue' ORDER BY "delayed_jobs"."priority" ASC, "delayed_jobs"."run_at" ASC, "delayed_jobs"."id" ASC LIMIT 1 FOR UPDATE SKIP LOCKED) subquery) UPDATE "public"."delayed_jobs" SET locked_by = CASE row_number WHEN 1 THEN 'ip-172-31-0-95:20806' END, locked_at = '2021-03-31 14:43:01.193449' FROM limited_jobs WHERE limited_jobs.id="public"."delayed_jobs".id RETURNING "public"."delayed_jobs".*  [production:1 primary]

Hi @waleed,

I do not see any error in the app’s log files. Can you contact the CanvasLMS developers to know more about how to troubleshoot this issue?

https://community.canvaslms.com/

Do not hesitate to ask us in case you have any questions regarding the Bitnami solution

sure, I’ll submit to them

thank you

Dear,
My Canvas no send any mails.

What we need to do to resolve SMTP sending mails?

We have this:

production:
enable_starttls_auto: true
address: smtp.office365.com
port: 587
user_name: RealUsername
password: RealPassword
authentication: plain # plain, login, or cram_md5
domain: RealDomain
outgoing_address: RealEmail
default_name: Academy

Apologies

Hi @alvaro.jim,

The configuration seems fine but maybe the Microsoft mail is blocking the requests for some reason. Can you contact the Microsoft support team to know if there is any problem with the connection?

Thanks

Hello jota,
Using hotmail, sendgrid and Office365, we can’t use the sendmail on canvas. How can we send the invite to users confirm account?

Or what email account can we use to send mails?

Best regards,

Hi @alvaro.jim,

This seems to be an issue with the application, can you contact the CanvasLMS team to debug the issue?

https://community.canvaslms.com/

Thanks

Hello jota,

Now we can send emails, just put like login. Issue fixed

production:
enable_starttls_auto: true
address: smtp.office365.com
port: 587
user_name: RealUsername
password: RealPassword
authentication: login # plain, login, or cram_md5
domain: RealDomain
outgoing_address: RealEmail
default_name: Academy

Now we have the doubt, how change email templates?

All mails are sent with [https://canvastest/… and we like to put our own domain.

How fix this?

Best regards,

Alvaro

Hi @alvaro.jim

Would you mind opening a new ticket for this? We usually try to have single-themed threads so that users in the community can find answers to specific topics easier. We will be more than happy to provide you with assistance there as well :slightly_smiling_face:.

Best regards,
Jose Antonio Carmona


Was my answer helpful? Click on :heart:

1 Like

Hello @jcarmona, if needed, let’s start a new ticket.