Failed to create new item (Pages, Assignment)
18 views
Skip to first unread message
lucifer
Jul 23, 2025, 11:08:47 PMJul 23
to Canvas LMS Users
when i try to create a new page under courses it is throwing an error in browser as well as in browser console
This is my browser console's output,
jquery.ajaxJSON.js:119 POST https://mydomain.in/api/v1/courses/14/pages 500 (Internal Server Error)
I have also attached the browser console output
[- -] Reading app-canvas/data/secrets from vault
[- -] (0.3ms) SELECT * FROM unnest(current_schemas(false))
[- -] Switchman::Shard Load (0.9ms) SELECT "switchman_shards".* FROM "public"."switchman_shards" WHERE "switchman_shards"."default" = TRUE LIMIT 1
[- -] SQL (0.7ms) SELECT * FROM unnest(current_schemas(false)) [production:1 primary]
[- -] SQL Setting Pluck (0.5ms) SELECT "settings"."name", "settings"."value" FROM "public"."settings" [production:1 primary]
[- -] Initializing the background worker with 8 threads
[- -] SQL Switchman::Shard Exists (1.3ms) SELECT 1 AS one FROM "public"."switchman_shards" WHERE "switchman_shards"."id" IN (SELECT DISTINCT "switchman_shards"."delayed_jobs_shard_id" FROM "public"."switchman_shards" WHERE "switchman_shards"."delayed_jobs_shard_id" IS NOT NULL) LIMIT 1 [production:1 primary]
[- -] SQL Switchman::Shard Load (0.4ms) SELECT "switchman_shards".* FROM "public"."switchman_shards" WHERE "switchman_shards"."id" = 1 [production:1 primary]
[06cfbb7e77325750e2fc1a4a0572d628 800abef5-58bf-4c05-b104-9f19f294e737] Started GET "/dashboard-sidebar" for 2401:4900:8825:e3b1:d871:40c8:b602:a33c at 2025-07-24 08:21:16 +0530
[06cfbb7e77325750e2fc1a4a0572d628 54208b97-4a3e-4915-a38f-cab74be316f8] Started GET "/api/v1/users/self/content_shares/unread_count" for 2401:4900:8825:e3b1:d871:40c8:b602:a33c at 2025-07-24 08:21:18 +0530
[06cfbb7e77325750e2fc1a4a0572d628 63f4b404-7f2a-4de8-9320-855b88911920] Started GET "/api/v1/courses/14/activity_stream/summary" for 2401:4900:8825:e3b1:d871:40c8:b602:a33c at 2025-07-24 08:21:19 +0530
[06cfbb7e77325750e2fc1a4a0572d628 800abef5-58bf-4c05-b104-9f19f294e737] SQL ActiveRecord::SchemaMigration Pluck (0.8ms) SELECT "schema_migrations"."version" FROM "public"."schema_migrations" ORDER BY "schema_migrations"."version" ASC [production:1 primary]
[06cfbb7e77325750e2fc1a4a0572d628 800abef5-58bf-4c05-b104-9f19f294e737] SQL Account Load (1.3ms) SELECT "accounts".* FROM "public"."accounts" WHERE "accounts"."id" = 1 LIMIT 1 [production:1 primary]
[06cfbb7e77325750e2fc1a4a0572d628 800abef5-58bf-4c05-b104-9f19f294e737] SQL FeatureFlag Load (0.7ms) SELECT "feature_flags".* FROM "public"."feature_flags" WHERE "feature_flags"."context_id" = 1 AND "feature_flags"."context_type" = 'Account' [production:1 primary]
[06cfbb7e77325750e2fc1a4a0572d628 800abef5-58bf-4c05-b104-9f19f294e737] SQL Account Load (0.6ms) SELECT "accounts".* FROM "public"."accounts" WHERE "accounts"."id" = 2 LIMIT 1 [production:1 primary]
[06cfbb7e77325750e2fc1a4a0572d628 800abef5-58bf-4c05-b104-9f19f294e737] SQL FeatureFlag Load (0.4ms) SELECT "feature_flags".* FROM "public"."feature_flags" WHERE "feature_flags"."context_id" = 2 AND "feature_flags"."context_type" = 'Account' [production:1 primary]
[06cfbb7e77325750e2fc1a4a0572d628 800abef5-58bf-4c05-b104-9f19f294e737] SQL PluginSetting Load (0.7ms) SELECT "plugin_settings".* FROM "public"."plugin_settings" WHERE "plugin_settings"."name" = 'sessions' ORDER BY "plugin_settings"."id" ASC LIMIT 1 [production:1 primary]
[06cfbb7e77325750e2fc1a4a0572d628 800abef5-58bf-4c05-b104-9f19f294e737] request throttling increment: [0,50.0,1753325483.221251,["client_identifier","user:10000000000001"],["count",0.0],["last_touched",null]]
[06cfbb7e77325750e2fc1a4a0572d628 800abef5-58bf-4c05-b104-9f19f294e737] Redis (0.655ms) evalsha - [redis://192.168.0.7:6379/0]
[06cfbb7e77325750e2fc1a4a0572d628 800abef5-58bf-4c05-b104-9f19f294e737] Processing by UsersController#dashboard_sidebar as JSON
[06cfbb7e77325750e2fc1a4a0572d628 800abef5-58bf-4c05-b104-9f19f294e737] No separate files host specified for account id 1. This is a potential security risk.
[06cfbb7e77325750e2fc1a4a0572d628 800abef5-58bf-4c05-b104-9f19f294e737] SQL SQL (3.1ms) SELECT "pseudonyms"."id" AS t0_r0, "pseudonyms"."user_id" AS t0_r1, "pseudonyms"."account_id" AS t0_r2, "pseudonyms"."workflow_state" AS t0_r3, "pseudonyms"."unique_id" AS t0_r4, "pseudonyms"."crypted_password" AS t0_r5, "pseudonyms"."password_salt" AS t0_r6, "pseudonyms"."persistence_token" AS t0_r7, "pseudonyms"."single_access_token" AS t0_r8, "pseudonyms"."perishable_token" AS t0_r9, "pseudonyms"."login_count" AS t0_r10, "pseudonyms"."failed_login_count" AS t0_r11, "pseudonyms"."last_request_at" AS t0_r12, "pseudonyms"."last_login_at" AS t0_r13, "pseudonyms"."current_login_at" AS t0_r14, "pseudonyms"."last_login_ip" AS t0_r15, "pseudonyms"."current_login_ip" AS t0_r16, "pseudonyms"."reset_password_token" AS t0_r17, "pseudonyms"."position" AS t0_r18, "pseudonyms"."created_at" AS t0_r19, "pseudonyms"."updated_at" AS t0_r20, "pseudonyms"."password_auto_generated" AS t0_r21, "pseudonyms"."deleted_at" AS t0_r22, "pseudonyms"."sis_batch_id" AS t0_r23, "pseudonyms"."sis_user_id" AS t0_r24, "pseudonyms"."sis_ssha" AS t0_r25, "pseudonyms"."communication_channel_id" AS t0_r26, "pseudonyms"."sis_communication_channel_id" AS t0_r27, "pseudonyms"."stuck_sis_fields" AS t0_r28, "pseudonyms"."integration_id" AS t0_r29, "pseudonyms"."authentication_provider_id" AS t0_r30, "pseudonyms"."declared_user_type" AS t0_r31, "users"."id" AS t1_r0, "users"."name" AS t1_r1, "users"."sortable_name" AS t1_r2, "users"."workflow_state" AS t1_r3, "users"."time_zone" AS t1_r4, "users"."uuid" AS t1_r5, "users"."created_at" AS t1_r6, "users"."updated_at" AS t1_r7, "users"."avatar_image_url" AS t1_r8, "users"."avatar_image_source" AS t1_r9, "users"."avatar_image_updated_at" AS t1_r10, "users"."phone" AS t1_r11, "users"."school_name" AS t1_r12, "users"."school_position" AS t1_r13, "users"."short_name" AS t1_r14, "users"."deleted_at" AS t1_r15, "users"."show_user_services" AS t1_r16, "users"."page_views_count" AS t1_r17, "users"."reminder_time_for_due_dates" AS t1_r18, "users"."reminder_time_for_grading" AS t1_r19, "users"."storage_quota" AS t1_r20, "users"."visible_inbox_types" AS t1_r21, "users"."last_user_note" AS t1_r22, "users"."subscribe_to_emails" AS t1_r23, "users"."features_used" AS t1_r24, "users"."preferences" AS t1_r25, "users"."avatar_state" AS t1_r26, "users"."locale" AS t1_r27, "users"."browser_locale" AS t1_r28, "users"."unread_conversations_count" AS t1_r29, "users"."stuck_sis_fields" AS t1_r30, "users"."public" AS t1_r31, "users"."otp_secret_key_enc" AS t1_r32, "users"."otp_secret_key_salt" AS t1_r33, "users"."otp_communication_channel_id" AS t1_r34, "users"."initial_enrollment_type" AS t1_r35, "users"."crocodoc_id" AS t1_r36, "users"."last_logged_out" AS t1_r37, "users"."lti_context_id" AS t1_r38, "users"."turnitin_id" AS t1_r39, "users"."lti_id" AS t1_r40, "users"."pronouns" AS t1_r41, "users"."root_account_ids" AS t1_r42, "users"."merged_into_user_id" AS t1_r43 FROM "public"."pseudonyms" LEFT OUTER JOIN "public"."users" ON "users"."id" = "pseudonyms"."user_id" WHERE "pseudonyms"."id" = 19 LIMIT 1 [production:1 primary]
[06cfbb7e77325750e2fc1a4a0572d628 800abef5-58bf-4c05-b104-9f19f294e737] [AUTH] Approved Authlogic session
[06cfbb7e77325750e2fc1a4a0572d628 800abef5-58bf-4c05-b104-9f19f294e737] [AUTH] inital load: pseud -> 19, user -> 1
[06cfbb7e77325750e2fc1a4a0572d628 800abef5-58bf-4c05-b104-9f19f294e737] [AUTH] final user: 1
[06cfbb7e77325750e2fc1a4a0572d628 800abef5-58bf-4c05-b104-9f19f294e737] SQL Enrollment Exists (2.2ms) SELECT 1 AS one FROM "public"."enrollments" WHERE "enrollments"."user_id" = 1 AND "enrollments"."type" IN ('StudentEnrollment', 'StudentViewEnrollment') AND "enrollments"."workflow_state" NOT IN ('rejected', 'inactive', 'deleted') LIMIT 1 [production:1 secondary]
[06cfbb7e77325750e2fc1a4a0572d628 800abef5-58bf-4c05-b104-9f19f294e737] SQL Enrollment Exists (0.5ms) SELECT 1 AS one FROM "public"."enrollments" WHERE "enrollments"."user_id" = 1 AND "enrollments"."type" NOT IN ('StudentEnrollment', 'StudentViewEnrollment', 'ObserverEnrollment') AND "enrollments"."workflow_state" NOT IN ('rejected', 'inactive', 'deleted') LIMIT 1 [production:1 secondary]
[06cfbb7e77325750e2fc1a4a0572d628 800abef5-58bf-4c05-b104-9f19f294e737] SQL Group Pluck (1.9ms) SELECT "groups"."id" FROM "public"."groups" INNER JOIN "public"."group_memberships" ON "groups"."id" = "group_memberships"."group_id" WHERE "group_memberships"."user_id" = 1 AND (group_memberships.workflow_state<>'deleted') AND (groups.workflow_state<>'deleted') [production:1 secondary]
[06cfbb7e77325750e2fc1a4a0572d628 800abef5-58bf-4c05-b104-9f19f294e737] SQL Enrollment Pluck (5.2ms) SELECT DISTINCT "enrollments"."course_id" FROM "public"."enrollments" INNER JOIN "public"."courses" ON "courses"."id" = "enrollments"."course_id" INNER JOIN "public"."enrollment_states" ON "enrollment_states"."enrollment_id" = "enrollments"."id" WHERE "enrollments"."user_id" = 1 AND (enrollments.workflow_state='active' AND (courses.workflow_state='available' OR courses.workflow_state IN ('created', 'claimed') AND enrollments.type IN ('TeacherEnrollment','TaEnrollment','DesignerEnrollment','StudentViewEnrollment'))) AND (enrollment_states.state = 'active') [production:1 secondary]
[06cfbb7e77325750e2fc1a4a0572d628 800abef5-58bf-4c05-b104-9f19f294e737] SQL Course Load (1.3ms) SELECT "courses".* FROM "public"."courses" WHERE "courses"."id" IN (2, 3, 4, 5, 10, 11, 12, 13, 14, 16, 18, 19, 20, 21, 22, 27, 28, 29, 30, 31, 32, 33, 34) [production:1 secondary]
[06cfbb7e77325750e2fc1a4a0572d628 800abef5-58bf-4c05-b104-9f19f294e737] SQL Enrollment Pluck (2.1ms) SELECT "enrollments"."course_section_id", "enrollments"."limit_privileges_to_course_section", "enrollments"."type", "enrollments"."associated_user_id", "enrollments"."workflow_state" FROM "public"."enrollments" WHERE "enrollments"."course_id" = 3 AND "enrollments"."user_id" = 1 AND "enrollments"."workflow_state" != 'deleted' [production:1 primary]
[06cfbb7e77325750e2fc1a4a0572d628 800abef5-58bf-4c05-b104-9f19f294e737] SQL Enrollment Load (1.5ms) SELECT enrollments.*, enrollment_states.state AS date_based_state_in_db FROM "public"."enrollments" INNER JOIN "public"."enrollment_states" ON "enrollment_states"."enrollment_id" = "enrollments"."id" WHERE "enrollments"."course_id" = 3 AND (enrollments.workflow_state<>'deleted') AND "enrollments"."user_id" = 1 AND "enrollment_states"."restricted_access" = FALSE AND (enrollment_states.state IN ('active', 'invited', 'pending_invited', 'pending_active')) [production:1 primary]
[06cfbb7e77325750e2fc1a4a0572d628 602ebae5-ca01-444c-aecb-41556a010bc3] Started POST "/api/graphql" for 2401:4900:8825:e3b1:d871:40c8:b602:a33c at 2025-07-24 08:21:23 +0530
[06cfbb7e77325750e2fc1a4a0572d628 800abef5-58bf-4c05-b104-9f19f294e737] SQL Role Load (0.8ms) SELECT "roles".* FROM "public"."roles" WHERE "roles"."id" = 12 LIMIT 1 [production:1 secondary]
[06cfbb7e77325750e2fc1a4a0572d628 800abef5-58bf-4c05-b104-9f19f294e737] SQL Account Load (3.0ms) WITH RECURSIVE t AS ( SELECT * FROM "public"."accounts" WHERE id=3 UNION SELECT accounts.* FROM "public"."accounts" INNER JOIN t ON accounts.id=t.parent_account_id ) SELECT * FROM t [production:1 secondary]
[06cfbb7e77325750e2fc1a4a0572d628 800abef5-58bf-4c05-b104-9f19f294e737] SQL Role Load (0.5ms) SELECT "roles".* FROM "public"."roles" WHERE "roles"."workflow_state" = 'built_in' AND "roles"."root_account_id" = 1 AND "roles"."base_role_type" = 'TeacherEnrollment' [production:1 secondary]
[06cfbb7e77325750e2fc1a4a0572d628 800abef5-58bf-4c05-b104-9f19f294e737] SQL RoleOverride Load (2.1ms) COPY (SELECT "role_overrides".* FROM "public"."role_overrides" WHERE "role_overrides"."role_id" IN (12, 12) AND "role_overrides"."context_id" IN (3, 1)) TO STDOUT [production:1 secondary]
[06cfbb7e77325750e2fc1a4a0572d628 800abef5-58bf-4c05-b104-9f19f294e737] SQL Enrollment Pluck (0.8ms) SELECT "enrollments"."course_section_id", "enrollments"."limit_privileges_to_course_section", "enrollments"."type", "enrollments"."associated_user_id", "enrollments"."workflow_state" FROM "public"."enrollments" WHERE "enrollments"."course_id" = 2 AND "enrollments"."user_id" = 1 AND "enrollments"."workflow_state" != 'deleted' [production:1 primary]
[06cfbb7e77325750e2fc1a4a0572d628 800abef5-58bf-4c05-b104-9f19f294e737] SQL Enrollment Load (1.1ms) SELECT enrollments.*, enrollment_states.state AS date_based_state_in_db FROM "public"."enrollments" INNER JOIN "public"."enrollment_states" ON "enrollment_states"."enrollment_id" = "enrollments"."id" WHERE "enrollments"."course_id" = 2 AND (enrollments.workflow_state<>'deleted') AND "enrollments"."user_id" = 1 AND "enrollment_states"."restricted_access" = FALSE AND (enrollment_states.state IN ('active', 'invited', 'pending_invited', 'pending_active')) [production:1 primary]
[06cfbb7e77325750e2fc1a4a0572d628 800abef5-58bf-4c05-b104-9f19f294e737] SQL Enrollment Pluck (0.7ms) SELECT "enrollments"."course_section_id", "enrollments"."limit_privileges_to_course_section", "enrollments"."type", "enrollments"."associated_user_id", "enrollments"."workflow_state" FROM "public"."enrollments" WHERE "enrollments"."course_id" = 4 AND "enrollments"."user_id" = 1 AND "enrollments"."workflow_state" != 'deleted' [production:1 primary]
[06cfbb7e77325750e2fc1a4a0572d628 800abef5-58bf-4c05-b104-9f19f294e737] SQL Enrollment Load (1.1ms) SELECT enrollments.*, enrollment_states.state AS date_based_state_in_db FROM "public"."enrollments" INNER JOIN "public"."enrollment_states" ON "enrollment_states"."enrollment_id" = "enrollments"."id" WHERE "enrollments"."course_id" = 4 AND (enrollments.workflow_state<>'deleted') AND "enrollments"."user_id" = 1 AND "enrollment_states"."restricted_access" = FALSE AND (enrollment_states.state IN ('active', 'invited', 'pending_invited', 'pending_active')) [production:1 primary]
[06cfbb7e77325750e2fc1a4a0572d628 800abef5-58bf-4c05-b104-9f19f294e737] SQL Enrollment Pluck (0.6ms) SELECT "enrollments"."course_section_id", "enrollments"."limit_privileges_to_course_section", "enrollments"."type", "enrollments"."associated_user_id", "enrollments"."workflow_state" FROM "public"."enrollments" WHERE "enrollments"."course_id" = 31 AND "enrollments"."user_id" = 1 AND "enrollments"."workflow_state" != 'deleted' [production:1 primary]
[06cfbb7e77325750e2fc1a4a0572d628 800abef5-58bf-4c05-b104-9f19f294e737] SQL Enrollment Load (1.0ms) SELECT enrollments.*, enrollment_states.state AS date_based_state_in_db FROM "public"."enrollments" INNER JOIN "public"."enrollment_states" ON "enrollment_states"."enrollment_id" = "enrollments"."id" WHERE "enrollments"."course_id" = 31 AND (enrollments.workflow_state<>'deleted') AND "enrollments"."user_id" = 1 AND "enrollment_states"."restricted_access" = FALSE AND (enrollment_states.state IN ('active', 'invited', 'pending_invited', 'pending_active')) AND "enrollments"."type" IN ('TeacherEnrollment', 'TaEnrollment', 'DesignerEnrollment', 'StudentViewEnrollment') [production:1 primary]
[06cfbb7e77325750e2fc1a4a0572d628 800abef5-58bf-4c05-b104-9f19f294e737] SQL Enrollment Pluck (0.7ms) SELECT "enrollments"."course_section_id", "enrollments"."limit_privileges_to_course_section", "enrollments"."type", "enrollments"."associated_user_id", "enrollments"."workflow_state" FROM "public"."enrollments" WHERE "enrollments"."course_id" = 5 AND "enrollments"."user_id" = 1 AND "enrollments"."workflow_state" != 'deleted' [production:1 primary]
[06cfbb7e77325750e2fc1a4a0572d628 800abef5-58bf-4c05-b104-9f19f294e737] SQL Enrollment Load (0.8ms) SELECT enrollments.*, enrollment_states.state AS date_based_state_in_db FROM "public"."enrollments" INNER JOIN "public"."enrollment_states" ON "enrollment_states"."enrollment_id" = "enrollments"."id" WHERE "enrollments"."course_id" = 5 AND (enrollments.workflow_state<>'deleted') AND "enrollments"."user_id" = 1 AND "enrollment_states"."restricted_access" = FALSE AND (enrollment_states.state IN ('active', 'invited', 'pending_invited', 'pending_active')) [production:1 primary]
[06cfbb7e77325750e2fc1a4a0572d628 800abef5-58bf-4c05-b104-9f19f294e737] SQL Enrollment Pluck (0.8ms) SELECT "enrollments"."course_section_id", "enrollments"."limit_privileges_to_course_section", "enrollments"."type", "enrollments"."associated_user_id", "enrollments"."workflow_state" FROM "public"."enrollments" WHERE "enrollments"."course_id" = 10 AND "enrollments"."user_id" = 1 AND "enrollments"."workflow_state" != 'deleted' [production:1 primary]
[06cfbb7e77325750e2fc1a4a0572d628 800abef5-58bf-4c05-b104-9f19f294e737] SQL Enrollment Load (0.9ms) SELECT enrollments.*, enrollment_states.state AS date_based_state_in_db FROM "public"."enrollments" INNER JOIN "public"."enrollment_states" ON "enrollment_states"."enrollment_id" = "enrollments"."id" WHERE "enrollments"."course_id" = 10 AND (enrollments.workflow_state<>'deleted') AND "enrollments"."user_id" = 1 AND "enrollment_states"."restricted_access" = FALSE AND (enrollment_states.state IN ('active', 'invited', 'pending_invited', 'pending_active')) [production:1 primary]
[06cfbb7e77325750e2fc1a4a0572d628 800abef5-58bf-4c05-b104-9f19f294e737] SQL Role Load (0.5ms) SELECT "roles".* FROM "public"."roles" WHERE "roles"."id" = 11 LIMIT 1 [production:1 secondary]
[06cfbb7e77325750e2fc1a4a0572d628 800abef5-58bf-4c05-b104-9f19f294e737] CACHE SQL Account Load (0.0ms) 1::WITH RECURSIVE t AS ( SELECT * FROM "public"."accounts" WHERE id=3 UNION SELECT accounts.* FROM "public"."accounts" INNER JOIN t ON accounts.id=t.parent_account_id ) SELECT * FROM t
[06cfbb7e77325750e2fc1a4a0572d628 800abef5-58bf-4c05-b104-9f19f294e737] SQL Role Load (0.6ms) SELECT "roles".* FROM "public"."roles" WHERE "roles"."workflow_state" = 'built_in' AND "roles"."root_account_id" = 1 AND "roles"."base_role_type" = 'StudentEnrollment' [production:1 secondary]
[06cfbb7e77325750e2fc1a4a0572d628 800abef5-58bf-4c05-b104-9f19f294e737] SQL RoleOverride Load (1.3ms) COPY (SELECT "role_overrides".* FROM "public"."role_overrides" WHERE "role_overrides"."role_id" IN (11, 11) AND "role_overrides"."context_id" IN (3, 1)) TO STDOUT [production:1 secondary]
[06cfbb7e77325750e2fc1a4a0572d628 800abef5-58bf-4c05-b104-9f19f294e737] SQL Enrollment Pluck (0.7ms) SELECT "enrollments"."course_section_id", "enrollments"."limit_privileges_to_course_section", "enrollments"."type", "enrollments"."associated_user_id", "enrollments"."workflow_state" FROM "public"."enrollments" WHERE "enrollments"."course_id" = 11 AND "enrollments"."user_id" = 1 AND "enrollments"."workflow_state" != 'deleted' [production:1 primary]
[06cfbb7e77325750e2fc1a4a0572d628 800abef5-58bf-4c05-b104-9f19f294e737] SQL Enrollment Load (0.9ms) SELECT enrollments.*, enrollment_states.state AS date_based_state_in_db FROM "public"."enrollments" INNER JOIN "public"."enrollment_states" ON "enrollment_states"."enrollment_id" = "enrollments"."id" WHERE "enrollments"."course_id" = 11 AND (enrollments.workflow_state<>'deleted') AND "enrollments"."user_id" = 1 AND "enrollment_states"."restricted_access" = FALSE AND (enrollment_states.state IN ('active', 'invited', 'pending_invited', 'pending_active')) AND "enrollments"."type" IN ('TeacherEnrollment', 'TaEnrollment', 'DesignerEnrollment', 'StudentViewEnrollment') [production:1 primary]
[06cfbb7e77325750e2fc1a4a0572d628 800abef5-58bf-4c05-b104-9f19f294e737] SQL Enrollment Pluck (0.6ms) SELECT "enrollments"."course_section_id", "enrollments"."limit_privileges_to_course_section", "enrollments"."type", "enrollments"."associated_user_id", "enrollments"."workflow_state" FROM "public"."enrollments" WHERE "enrollments"."course_id" = 12 AND "enrollments"."user_id" = 1 AND "enrollments"."workflow_state" != 'deleted' [production:1 primary]
[06cfbb7e77325750e2fc1a4a0572d628 800abef5-58bf-4c05-b104-9f19f294e737] SQL Enrollment Load (1.2ms) SELECT enrollments.*, enrollment_states.state AS date_based_state_in_db FROM "public"."enrollments" INNER JOIN "public"."enrollment_states" ON "enrollment_states"."enrollment_id" = "enrollments"."id" WHERE "enrollments"."course_id" = 12 AND (enrollments.workflow_state<>'deleted') AND "enrollments"."user_id" = 1 AND "enrollment_states"."restricted_access" = FALSE AND (enrollment_states.state IN ('active', 'invited', 'pending_invited', 'pending_active')) [production:1 primary]
[06cfbb7e77325750e2fc1a4a0572d628 800abef5-58bf-4c05-b104-9f19f294e737] SQL Enrollment Pluck (0.7ms) SELECT "enrollments"."course_section_id", "enrollments"."limit_privileges_to_course_section", "enrollments"."type", "enrollments"."associated_user_id", "enrollments"."workflow_state" FROM "public"."enrollments" WHERE "enrollments"."course_id" = 32 AND "enrollments"."user_id" = 1 AND "enrollments"."workflow_state" != 'deleted' [production:1 primary]
[06cfbb7e77325750e2fc1a4a0572d628 800abef5-58bf-4c05-b104-9f19f294e737] SQL Enrollment Load (1.2ms) SELECT enrollments.*, enrollment_states.state AS date_based_state_in_db FROM "public"."enrollments" INNER JOIN "public"."enrollment_states" ON "enrollment_states"."enrollment_id" = "enrollments"."id" WHERE "enrollments"."course_id" = 32 AND (enrollments.workflow_state<>'deleted') AND "enrollments"."user_id" = 1 AND "enrollment_states"."restricted_access" = FALSE AND (enrollment_states.state IN ('active', 'invited', 'pending_invited', 'pending_active')) [production:1 primary]
[06cfbb7e77325750e2fc1a4a0572d628 800abef5-58bf-4c05-b104-9f19f294e737] SQL Enrollment Pluck (0.8ms) SELECT "enrollments"."course_section_id", "enrollments"."limit_privileges_to_course_section", "enrollments"."type", "enrollments"."associated_user_id", "enrollments"."workflow_state" FROM "public"."enrollments" WHERE "enrollments"."course_id" = 16 AND "enrollments"."user_id" = 1 AND "enrollments"."workflow_state" != 'deleted' [production:1 primary]
[06cfbb7e77325750e2fc1a4a0572d628 800abef5-58bf-4c05-b104-9f19f294e737] SQL Enrollment Load (1.1ms) SELECT enrollments.*, enrollment_states.state AS date_based_state_in_db FROM "public"."enrollments" INNER JOIN "public"."enrollment_states" ON "enrollment_states"."enrollment_id" = "enrollments"."id" WHERE "enrollments"."course_id" = 16 AND (enrollments.workflow_state<>'deleted') AND "enrollments"."user_id" = 1 AND "enrollment_states"."restricted_access" = FALSE AND (enrollment_states.state IN ('active', 'invited', 'pending_invited', 'pending_active')) [production:1 primary]
[06cfbb7e77325750e2fc1a4a0572d628 800abef5-58bf-4c05-b104-9f19f294e737] SQL Enrollment Pluck (1.0ms) SELECT "enrollments"."course_section_id", "enrollments"."limit_privileges_to_course_section", "enrollments"."type", "enrollments"."associated_user_id", "enrollments"."workflow_state" FROM "public"."enrollments" WHERE "enrollments"."course_id" = 22 AND "enrollments"."user_id" = 1 AND "enrollments"."workflow_state" != 'deleted' [production:1 primary]
[06cfbb7e77325750e2fc1a4a0572d628 800abef5-58bf-4c05-b104-9f19f294e737] SQL Enrollment Load (1.2ms) SELECT enrollments.*, enrollment_states.state AS date_based_state_in_db FROM "public"."enrollments" INNER JOIN "public"."enrollment_states" ON "enrollment_states"."enrollment_id" = "enrollments"."id" WHERE "enrollments"."course_id" = 22 AND (enrollments.workflow_state<>'deleted') AND "enrollments"."user_id" = 1 AND "enrollment_states"."restricted_access" = FALSE AND (enrollment_states.state IN ('active', 'invited', 'pending_invited', 'pending_active')) [production:1 primary]
[06cfbb7e77325750e2fc1a4a0572d628 800abef5-58bf-4c05-b104-9f19f294e737] SQL Enrollment Pluck (0.8ms) SELECT "enrollments"."course_section_id", "enrollments"."limit_privileges_to_course_section", "enrollments"."type", "enrollments"."associated_user_id", "enrollments"."workflow_state" FROM "public"."enrollments" WHERE "enrollments"."course_id" = 14 AND "enrollments"."user_id" = 1 AND "enrollments"."workflow_state" != 'deleted' [production:1 primary]
[06cfbb7e77325750e2fc1a4a0572d628 800abef5-58bf-4c05-b104-9f19f294e737] SQL Enrollment Load (0.8ms) SELECT enrollments.*, enrollment_states.state AS date_based_state_in_db FROM "public"."enrollments" INNER JOIN "public"."enrollment_states" ON "enrollment_states"."enrollment_id" = "enrollments"."id" WHERE "enrollments"."course_id" = 14 AND (enrollments.workflow_state<>'deleted') AND "enrollments"."user_id" = 1 AND "enrollment_states"."restricted_access" = FALSE AND (enrollment_states.state IN ('active', 'invited', 'pending_invited', 'pending_active')) AND "enrollments"."type" IN ('TeacherEnrollment', 'TaEnrollment', 'DesignerEnrollment', 'StudentViewEnrollment') [production:1 primary]
[06cfbb7e77325750e2fc1a4a0572d628 800abef5-58bf-4c05-b104-9f19f294e737] SQL Enrollment Pluck (0.7ms) SELECT "enrollments"."course_section_id", "enrollments"."limit_privileges_to_course_section", "enrollments"."type", "enrollments"."associated_user_id", "enrollments"."workflow_state" FROM "public"."enrollments" WHERE "enrollments"."course_id" = 27 AND "enrollments"."user_id" = 1 AND "enrollments"."workflow_state" != 'deleted' [production:1 primary]
[06cfbb7e77325750e2fc1a4a0572d628 800abef5-58bf-4c05-b104-9f19f294e737] SQL Enrollment Load (0.8ms) SELECT enrollments.*, enrollment_states.state AS date_based_state_in_db FROM "public"."enrollments" INNER JOIN "public"."enrollment_states" ON "enrollment_states"."enrollment_id" = "enrollments"."id" WHERE "enrollments"."course_id" = 27 AND (enrollments.workflow_state<>'deleted') AND "enrollments"."user_id" = 1 AND "enrollment_states"."restricted_access" = FALSE AND (enrollment_states.state IN ('active', 'invited', 'pending_invited', 'pending_active')) AND "enrollments"."type" IN ('TeacherEnrollment', 'TaEnrollment', 'DesignerEnrollment', 'StudentViewEnrollment') [production:1 primary]
[06cfbb7e77325750e2fc1a4a0572d628 800abef5-58bf-4c05-b104-9f19f294e737] SQL Enrollment Pluck (0.5ms) SELECT "enrollments"."course_section_id", "enrollments"."limit_privileges_to_course_section", "enrollments"."type", "enrollments"."associated_user_id", "enrollments"."workflow_state" FROM "public"."enrollments" WHERE "enrollments"."course_id" = 29 AND "enrollments"."user_id" = 1 AND "enrollments"."workflow_state" != 'deleted' [production:1 primary]
[06cfbb7e77325750e2fc1a4a0572d628 800abef5-58bf-4c05-b104-9f19f294e737] SQL Enrollment Load (0.8ms) SELECT enrollments.*, enrollment_states.state AS date_based_state_in_db FROM "public"."enrollments" INNER JOIN "public"."enrollment_states" ON "enrollment_states"."enrollment_id" = "enrollments"."id" WHERE "enrollments"."course_id" = 29 AND (enrollments.workflow_state<>'deleted') AND "enrollments"."user_id" = 1 AND "enrollment_states"."restricted_access" = FALSE AND (enrollment_states.state IN ('active', 'invited', 'pending_invited', 'pending_active')) [production:1 primary]
[06cfbb7e77325750e2fc1a4a0572d628 800abef5-58bf-4c05-b104-9f19f294e737] SQL Enrollment Pluck (0.7ms) SELECT "enrollments"."course_section_id", "enrollments"."limit_privileges_to_course_section", "enrollments"."type", "enrollments"."associated_user_id", "enrollments"."workflow_state" FROM "public"."enrollments" WHERE "enrollments"."course_id" = 18 AND "enrollments"."user_id" = 1 AND "enrollments"."workflow_state" != 'deleted' [production:1 primary]
[06cfbb7e77325750e2fc1a4a0572d628 800abef5-58bf-4c05-b104-9f19f294e737] SQL Enrollment Load (0.9ms) SELECT enrollments.*, enrollment_states.state AS date_based_state_in_db FROM "public"."enrollments" INNER JOIN "public"."enrollment_states" ON "enrollment_states"."enrollment_id" = "enrollments"."id" WHERE "enrollments"."course_id" = 18 AND (enrollments.workflow_state<>'deleted') AND "enrollments"."user_id" = 1 AND "enrollment_states"."restricted_access" = FALSE AND (enrollment_states.state IN ('active', 'invited', 'pending_invited', 'pending_active')) [production:1 primary]
[06cfbb7e77325750e2fc1a4a0572d628 800abef5-58bf-4c05-b104-9f19f294e737] SQL Enrollment Pluck (0.6ms) SELECT "enrollments"."course_section_id", "enrollments"."limit_privileges_to_course_section", "enrollments"."type", "enrollments"."associated_user_id", "enrollments"."workflow_state" FROM "public"."enrollments" WHERE "enrollments"."course_id" = 30 AND "enrollments"."user_id" = 1 AND "enrollments"."workflow_state" != 'deleted' [production:1 primary]
[06cfbb7e77325750e2fc1a4a0572d628 800abef5-58bf-4c05-b104-9f19f294e737] SQL Enrollment Load (1.1ms) SELECT enrollments.*, enrollment_states.state AS date_based_state_in_db FROM "public"."enrollments" INNER JOIN "public"."enrollment_states" ON "enrollment_states"."enrollment_id" = "enrollments"."id" WHERE "enrollments"."course_id" = 30 AND (enrollments.workflow_state<>'deleted') AND "enrollments"."user_id" = 1 AND "enrollment_states"."restricted_access" = FALSE AND (enrollment_states.state IN ('active', 'invited', 'pending_invited', 'pending_active')) AND "enrollments"."type" IN ('TeacherEnrollment', 'TaEnrollment', 'DesignerEnrollment', 'StudentViewEnrollment') [production:1 primary]
[06cfbb7e77325750e2fc1a4a0572d628 800abef5-58bf-4c05-b104-9f19f294e737] SQL Enrollment Pluck (0.6ms) SELECT "enrollments"."course_section_id", "enrollments"."limit_privileges_to_course_section", "enrollments"."type", "enrollments"."associated_user_id", "enrollments"."workflow_state" FROM "public"."enrollments" WHERE "enrollments"."course_id" = 28 AND "enrollments"."user_id" = 1 AND "enrollments"."workflow_state" != 'deleted' [production:1 primary]
[06cfbb7e77325750e2fc1a4a0572d628 800abef5-58bf-4c05-b104-9f19f294e737] SQL Enrollment Load (0.9ms) SELECT enrollments.*, enrollment_states.state AS date_based_state_in_db FROM "public"."enrollments" INNER JOIN "public"."enrollment_states" ON "enrollment_states"."enrollment_id" = "enrollments"."id" WHERE "enrollments"."course_id" = 28 AND (enrollments.workflow_state<>'deleted') AND "enrollments"."user_id" = 1 AND "enrollment_states"."restricted_access" = FALSE AND (enrollment_states.state IN ('active', 'invited', 'pending_invited', 'pending_active')) AND "enrollments"."type" IN ('TeacherEnrollment', 'TaEnrollment', 'DesignerEnrollment', 'StudentViewEnrollment') [production:1 primary]
[06cfbb7e77325750e2fc1a4a0572d628 800abef5-58bf-4c05-b104-9f19f294e737] SQL Enrollment Pluck (0.7ms) SELECT "enrollments"."course_section_id", "enrollments"."limit_privileges_to_course_section", "enrollments"."type", "enrollments"."associated_user_id", "enrollments"."workflow_state" FROM "public"."enrollments" WHERE "enrollments"."course_id" = 33 AND "enrollments"."user_id" = 1 AND "enrollments"."workflow_state" != 'deleted' [production:1 primary]
[06cfbb7e77325750e2fc1a4a0572d628 800abef5-58bf-4c05-b104-9f19f294e737] SQL Enrollment Load (0.9ms) SELECT enrollments.*, enrollment_states.state AS date_based_state_in_db FROM "public"."enrollments" INNER JOIN "public"."enrollment_states" ON "enrollment_states"."enrollment_id" = "enrollments"."id" WHERE "enrollments"."course_id" = 33 AND (enrollments.workflow_state<>'deleted') AND "enrollments"."user_id" = 1 AND "enrollment_states"."restricted_access" = FALSE AND (enrollment_states.state IN ('active', 'invited', 'pending_invited', 'pending_active')) AND "enrollments"."type" IN ('TeacherEnrollment', 'TaEnrollment', 'DesignerEnrollment', 'StudentViewEnrollment') [production:1 primary]
[06cfbb7e77325750e2fc1a4a0572d628 800abef5-58bf-4c05-b104-9f19f294e737] SQL Enrollment Pluck (0.6ms) SELECT "enrollments"."course_section_id", "enrollments"."limit_privileges_to_course_section", "enrollments"."type", "enrollments"."associated_user_id", "enrollments"."workflow_state" FROM "public"."enrollments" WHERE "enrollments"."course_id" = 34 AND "enrollments"."user_id" = 1 AND "enrollments"."workflow_state" != 'deleted' [production:1 primary]
[06cfbb7e77325750e2fc1a4a0572d628 800abef5-58bf-4c05-b104-9f19f294e737] SQL Enrollment Load (0.9ms) SELECT enrollments.*, enrollment_states.state AS date_based_state_in_db FROM "public"."enrollments" INNER JOIN "public"."enrollment_states" ON "enrollment_states"."enrollment_id" = "enrollments"."id" WHERE "enrollments"."course_id" = 34 AND (enrollments.workflow_state<>'deleted') AND "enrollments"."user_id" = 1 AND "enrollment_states"."restricted_access" = FALSE AND (enrollment_states.state IN ('active', 'invited', 'pending_invited', 'pending_active')) AND "enrollments"."type" IN ('TeacherEnrollment', 'TaEnrollment', 'DesignerEnrollment', 'StudentViewEnrollment') [production:1 primary]
[06cfbb7e77325750e2fc1a4a0572d628 800abef5-58bf-4c05-b104-9f19f294e737] SQL Enrollment Pluck (0.7ms) SELECT "enrollments"."course_section_id", "enrollments"."limit_privileges_to_course_section", "enrollments"."type", "enrollments"."associated_user_id", "enrollments"."workflow_state" FROM "public"."enrollments" WHERE "enrollments"."course_id" = 13 AND "enrollments"."user_id" = 1 AND "enrollments"."workflow_state" != 'deleted' [production:1 primary]
[06cfbb7e77325750e2fc1a4a0572d628 800abef5-58bf-4c05-b104-9f19f294e737] SQL Enrollment Load (0.8ms) SELECT enrollments.*, enrollment_states.state AS date_based_state_in_db FROM "public"."enrollments" INNER JOIN "public"."enrollment_states" ON "enrollment_states"."enrollment_id" = "enrollments"."id" WHERE "enrollments"."course_id" = 13 AND (enrollments.workflow_state<>'deleted') AND "enrollments"."user_id" = 1 AND "enrollment_states"."restricted_access" = FALSE AND (enrollment_states.state IN ('active', 'invited', 'pending_invited', 'pending_active')) [production:1 primary]
[06cfbb7e77325750e2fc1a4a0572d628 800abef5-58bf-4c05-b104-9f19f294e737] SQL Enrollment Pluck (0.8ms) SELECT "enrollments"."course_section_id", "enrollments"."limit_privileges_to_course_section", "enrollments"."type", "enrollments"."associated_user_id", "enrollments"."workflow_state" FROM "public"."enrollments" WHERE "enrollments"."course_id" = 21 AND "enrollments"."user_id" = 1 AND "enrollments"."workflow_state" != 'deleted' [production:1 primary]
[06cfbb7e77325750e2fc1a4a0572d628 800abef5-58bf-4c05-b104-9f19f294e737] SQL Enrollment Load (1.1ms) SELECT enrollments.*, enrollment_states.state AS date_based_state_in_db FROM "public"."enrollments" INNER JOIN "public"."enrollment_states" ON "enrollment_states"."enrollment_id" = "enrollments"."id" WHERE "enrollments"."course_id" = 21 AND (enrollments.workflow_state<>'deleted') AND "enrollments"."user_id" = 1 AND "enrollment_states"."restricted_access" = FALSE AND (enrollment_states.state IN ('active', 'invited', 'pending_invited', 'pending_active')) [production:1 primary]
[06cfbb7e77325750e2fc1a4a0572d628 800abef5-58bf-4c05-b104-9f19f294e737] SQL Enrollment Pluck (0.7ms) SELECT "enrollments"."course_section_id", "enrollments"."limit_privileges_to_course_section", "enrollments"."type", "enrollments"."associated_user_id", "enrollments"."workflow_state" FROM "public"."enrollments" WHERE "enrollments"."course_id" = 20 AND "enrollments"."user_id" = 1 AND "enrollments"."workflow_state" != 'deleted' [production:1 primary]
[06cfbb7e77325750e2fc1a4a0572d628 800abef5-58bf-4c05-b104-9f19f294e737] SQL Enrollment Load (0.8ms) SELECT enrollments.*, enrollment_states.state AS date_based_state_in_db FROM "public"."enrollments" INNER JOIN "public"."enrollment_states" ON "enrollment_states"."enrollment_id" = "enrollments"."id" WHERE "enrollments"."course_id" = 20 AND (enrollments.workflow_state<>'deleted') AND "enrollments"."user_id" = 1 AND "enrollment_states"."restricted_access" = FALSE AND (enrollment_states.state IN ('active', 'invited', 'pending_invited', 'pending_active')) [production:1 primary]
[06cfbb7e77325750e2fc1a4a0572d628 800abef5-58bf-4c05-b104-9f19f294e737] SQL Enrollment Pluck (0.5ms) SELECT "enrollments"."course_section_id", "enrollments"."limit_privileges_to_course_section", "enrollments"."type", "enrollments"."associated_user_id", "enrollments"."workflow_state" FROM "public"."enrollments" WHERE "enrollments"."course_id" = 19 AND "enrollments"."user_id" = 1 AND "enrollments"."workflow_state" != 'deleted' [production:1 primary]
[06cfbb7e77325750e2fc1a4a0572d628 800abef5-58bf-4c05-b104-9f19f294e737] SQL Enrollment Load (0.9ms) SELECT enrollments.*, enrollment_states.state AS date_based_state_in_db FROM "public"."enrollments" INNER JOIN "public"."enrollment_states" ON "enrollment_states"."enrollment_id" = "enrollments"."id" WHERE "enrollments"."course_id" = 19 AND (enrollments.workflow_state<>'deleted') AND "enrollments"."user_id" = 1 AND "enrollment_states"."restricted_access" = FALSE AND (enrollment_states.state IN ('active', 'invited', 'pending_invited', 'pending_active')) AND "enrollments"."type" IN ('TeacherEnrollment', 'TaEnrollment', 'DesignerEnrollment', 'StudentViewEnrollment') [production:1 primary]
[06cfbb7e77325750e2fc1a4a0572d628 800abef5-58bf-4c05-b104-9f19f294e737] SQL CourseSection Pluck (1.1ms) SELECT "course_sections"."id" FROM "public"."course_sections" WHERE (course_sections.workflow_state<>'deleted') AND "course_sections"."course_id" IN (3, 2, 4, 31, 5, 10, 11, 12, 32, 16, 22, 14, 27, 29, 18, 30, 28, 33, 34, 13, 21, 20, 19) [production:1 secondary]
[06cfbb7e77325750e2fc1a4a0572d628 800abef5-58bf-4c05-b104-9f19f294e737] SQL CalendarEvent Load (2.4ms) SELECT "calendar_events".* FROM "public"."calendar_events" WHERE (calendar_events.workflow_state<>'deleted') AND "calendar_events"."context_code" IN ('user_1', 'course_2', 'course_3', 'course_4', 'course_5', 'course_10', 'course_11', 'course_12', 'course_13', 'course_14', 'course_16', 'course_18', 'course_19', 'course_20', 'course_21', 'course_22', 'course_27', 'course_28', 'course_29', 'course_30', 'course_31', 'course_32', 'course_33', 'course_34', 'course_section_2', 'course_section_3', 'course_section_4', 'course_section_5', 'course_section_10', 'course_section_11', 'course_section_12', 'course_section_13', 'course_section_14', 'course_section_15', 'course_section_17', 'course_section_19', 'course_section_20', 'course_section_21', 'course_section_22', 'course_section_23', 'course_section_25', 'course_section_26', 'course_section_27', 'course_section_28', 'course_section_29', 'course_section_30', 'course_section_31', 'course_section_32') AND ("calendar_events"."context_code" IN ('user_1', 'course_2', 'course_3', 'course_4', 'course_5', 'course_10', 'course_11', 'course_12', 'course_13', 'course_14', 'course_16', 'course_18', 'course_19', 'course_20', 'course_21', 'course_22', 'course_27', 'course_28', 'course_29', 'course_30', 'course_31', 'course_32', 'course_33', 'course_34') AND "calendar_events"."effective_context_code" IS NULL OR "calendar_events"."context_code" IN ('user_1', 'course_section_2', 'course_section_3', 'course_section_4', 'course_section_5', 'course_section_10', 'course_section_11', 'course_section_12', 'course_section_13', 'course_section_14', 'course_section_15', 'course_section_17', 'course_section_19', 'course_section_20', 'course_section_21', 'course_section_22', 'course_section_23', 'course_section_25', 'course_section_26', 'course_section_27', 'course_section_28', 'course_section_29', 'course_section_30', 'course_section_31', 'course_section_32') AND ((LOWER(',' || "public"."calendar_events".effective_context_code || ',') LIKE '%,user\_1,%') OR (LOWER(',' || "public"."calendar_events".effective_context_code || ',') LIKE '%,course\_2,%') OR (LOWER(',' || "public"."calendar_events".effective_context_code || ',') LIKE '%,course\_3,%') OR (LOWER(',' || "public"."calendar_events".effective_context_code || ',') LIKE '%,course\_4,%') OR (LOWER(',' || "public"."calendar_events".effective_context_code || ',') LIKE '%,course\_5,%') OR (LOWER(',' || "public"."calendar_events".effective_context_code || ',') LIKE '%,course\_10,%') OR (LOWER(',' || "public"."calendar_events".effective_context_code || ',') LIKE '%,course\_11,%') OR (LOWER(',' || "public"."calendar_events".effective_context_code || ',') LIKE '%,course\_12,%') OR (LOWER(',' || "public"."calendar_events".effective_context_code || ',') LIKE '%,course\_13,%') OR (LOWER(',' || "public"."calendar_events".effective_context_code || ',') LIKE '%,course\_14,%') OR (LOWER(',' || "public"."calendar_events".effective_context_code || ',') LIKE '%,course\_16,%') OR (LOWER(',' || "public"."calendar_events".effective_context_code || ',') LIKE '%,course\_18,%') OR (LOWER(',' || "public"."calendar_events".effective_context_code || ',') LIKE '%,course\_19,%') OR (LOWER(',' || "public"."calendar_events".effective_context_code || ',') LIKE '%,course\_20,%') OR (LOWER(',' || "public"."calendar_events".effective_context_code || ',') LIKE '%,course\_21,%') OR (LOWER(',' || "public"."calendar_events".effective_context_code || ',') LIKE '%,course\_22,%') OR (LOWER(',' || "public"."calendar_events".effective_context_code || ',') LIKE '%,course\_27,%') OR (LOWER(',' || "public"."calendar_events".effective_context_code || ',') LIKE '%,course\_28,%') OR (LOWER(',' || "public"."calendar_events".effective_context_code || ',') LIKE '%,course\_29,%') OR (LOWER(',' || "public"."calendar_events".effective_context_code || ',') LIKE '%,course\_30,%') OR (LOWER(',' || "public"."calendar_events".effective_context_code || ',') LIKE '%,course\_31,%') OR (LOWER(',' || "public"."calendar_events".effective_context_code || ',') LIKE '%,course\_32,%') OR (LOWER(',' || "public"."calendar_events".effective_context_code || ',') LIKE '%,course\_33,%') OR (LOWER(',' || "public"."calendar_events".effective_context_code || ',') LIKE '%,course\_34,%'))) AND "calendar_events"."start_at" <= '2025-07-31 02:51:23.588561' AND "calendar_events"."end_at" >= '2025-07-24 02:51:23.588515' ORDER BY "calendar_events"."start_at" ASC LIMIT 20 [production:1 secondary]
[06cfbb7e77325750e2fc1a4a0572d628 800abef5-58bf-4c05-b104-9f19f294e737] SQL Assignment Load (8.5ms) SELECT assignments.*, (SELECT COUNT(*) FROM "public"."submissions"
WHERE assignments.id = submissions.assignment_id
AND submissions.submission_type IS NOT NULL
AND submissions.workflow_state <> 'deleted') AS submitted_count FROM ((SELECT "assignments".* FROM "public"."assignments" WHERE "assignments"."workflow_state" = 'published' AND "assignments"."context_type" = 'Course' AND "assignments"."context_id" IN (2, 3, 4, 5, 10, 11, 12, 13, 14, 16, 18, 19, 20, 21, 22, 27, 28, 29, 30, 31, 32, 33, 34) AND "assignments"."due_at" BETWEEN '2025-07-24 02:51:23.588515' AND '2025-07-31 02:51:23.588561') UNION ALL (SELECT "assignments".* FROM "public"."assignments" WHERE "assignments"."workflow_state" = 'published' AND "assignments"."context_type" = 'Course' AND "assignments"."context_id" IN (2, 3, 4, 5, 10, 11, 12, 13, 14, 16, 18, 19, 20, 21, 22, 27, 28, 29, 30, 31, 32, 33, 34) AND EXISTS (SELECT "assignment_overrides".* FROM "public"."assignment_overrides" WHERE (assignment_id=assignments.id) AND "assignment_overrides"."due_at_overridden" = TRUE AND "assignment_overrides"."due_at" BETWEEN '2025-07-24 02:51:23.588515' AND '2025-07-31 02:51:23.588561') AND (NOT ("assignments"."due_at" BETWEEN '2025-07-24 02:51:23.588515' AND '2025-07-31 02:51:23.588561') OR "assignments"."due_at" IS NULL))) "assignments" [production:1 secondary]
[06cfbb7e77325750e2fc1a4a0572d628 800abef5-58bf-4c05-b104-9f19f294e737] SQL StudentEnrollment Exists (0.7ms) SELECT 1 AS one FROM "public"."enrollments" WHERE "enrollments"."type" IN ('StudentEnrollment', 'StudentViewEnrollment') AND "enrollments"."user_id" = 1 AND (enrollments.workflow_state<>'deleted') LIMIT 1 [production:1 secondary]
[06cfbb7e77325750e2fc1a4a0572d628 800abef5-58bf-4c05-b104-9f19f294e737] SQL Enrollment Pluck (1.5ms) SELECT DISTINCT "enrollments"."course_id" FROM "public"."enrollments" INNER JOIN "public"."courses" ON "courses"."id" = "enrollments"."course_id" INNER JOIN "public"."enrollment_states" ON "enrollment_states"."enrollment_id" = "enrollments"."id" WHERE "enrollments"."user_id" = 1 AND (enrollments.workflow_state='active' AND (courses.workflow_state='available' OR courses.workflow_state IN ('created', 'claimed') AND enrollments.type IN ('TeacherEnrollment','TaEnrollment','DesignerEnrollment','StudentViewEnrollment'))) AND (enrollment_states.state = 'active') AND "enrollments"."type" IN ('StudentEnrollment', 'StudentViewEnrollment') [production:1 secondary]
[06cfbb7e77325750e2fc1a4a0572d628 800abef5-58bf-4c05-b104-9f19f294e737] SQL SQL (3.2ms) SELECT "submissions"."id" AS t0_r0, "submissions"."body" AS t0_r1, "submissions"."url" AS t0_r2, "submissions"."attachment_id" AS t0_r3, "submissions"."grade" AS t0_r4, "submissions"."score" AS t0_r5, "submissions"."submitted_at" AS t0_r6, "submissions"."assignment_id" AS t0_r7, "submissions"."user_id" AS t0_r8, "submissions"."submission_type" AS t0_r9, "submissions"."workflow_state" AS t0_r10, "submissions"."created_at" AS t0_r11, "submissions"."updated_at" AS t0_r12, "submissions"."group_id" AS t0_r13, "submissions"."attachment_ids" AS t0_r14, "submissions"."processed" AS t0_r15, "submissions"."grade_matches_current_submission" AS t0_r16, "submissions"."published_score" AS t0_r17, "submissions"."published_grade" AS t0_r18, "submissions"."graded_at" AS t0_r19, "submissions"."student_entered_score" AS t0_r20, "submissions"."grader_id" AS t0_r21, "submissions"."media_comment_id" AS t0_r22, "submissions"."media_comment_type" AS t0_r23, "submissions"."quiz_submission_id" AS t0_r24, "submissions"."submission_comments_count" AS t0_r25, "submissions"."attempt" AS t0_r26, "submissions"."media_object_id" AS t0_r27, "submissions"."turnitin_data" AS t0_r28, "submissions"."cached_due_date" AS t0_r29, "submissions"."excused" AS t0_r30, "submissions"."graded_anonymously" AS t0_r31, "submissions"."late_policy_status" AS t0_r32, "submissions"."points_deducted" AS t0_r33, "submissions"."grading_period_id" AS t0_r34, "submissions"."seconds_late_override" AS t0_r35, "submissions"."lti_user_id" AS t0_r36, "submissions"."anonymous_id" AS t0_r37, "submissions"."last_comment_at" AS t0_r38, "submissions"."extra_attempts" AS t0_r39, "submissions"."posted_at" AS t0_r40, "submissions"."cached_quiz_lti" AS t0_r41, "submissions"."cached_tardiness" AS t0_r42, "submissions"."course_id" AS t0_r43, "submissions"."root_account_id" AS t0_r44, "submissions"."redo_request" AS t0_r45, "submissions"."resource_link_lookup_uuid" AS t0_r46, "submissions"."proxy_submitter_id" AS t0_r47, "submissions"."custom_grade_status_id" AS t0_r48, "submissions"."sticker" AS t0_r49, "assignments"."id" AS t1_r0, "assignments"."title" AS t1_r1, "assignments"."description" AS t1_r2, "assignments"."due_at" AS t1_r3, "assignments"."unlock_at" AS t1_r4, "assignments"."lock_at" AS t1_r5, "assignments"."points_possible" AS t1_r6, "assignments"."min_score" AS t1_r7, "assignments"."max_score" AS t1_r8, "assignments"."mastery_score" AS t1_r9, "assignments"."grading_type" AS t1_r10, "assignments"."submission_types" AS t1_r11, "assignments"."workflow_state" AS t1_r12, "assignments"."context_id" AS t1_r13, "assignments"."context_type" AS t1_r14, "assignments"."assignment_group_id" AS t1_r15, "assignments"."grading_standard_id" AS t1_r16, "assignments"."created_at" AS t1_r17, "assignments"."updated_at" AS t1_r18, "assignments"."group_category" AS t1_r19, "assignments"."submissions_downloads" AS t1_r20, "assignments"."peer_review_count" AS t1_r21, "assignments"."peer_reviews_due_at" AS t1_r22, "assignments"."peer_reviews_assigned" AS t1_r23, "assignments"."peer_reviews" AS t1_r24, "assignments"."automatic_peer_reviews" AS t1_r25, "assignments"."all_day" AS t1_r26, "assignments"."all_day_date" AS t1_r27, "assignments"."could_be_locked" AS t1_r28, "assignments"."cloned_item_id" AS t1_r29, "assignments"."position" AS t1_r30, "assignments"."migration_id" AS t1_r31, "assignments"."grade_group_students_individually" AS t1_r32, "assignments"."anonymous_peer_reviews" AS t1_r33, "assignments"."time_zone_edited" AS t1_r34, "assignments"."turnitin_enabled" AS t1_r35, "assignments"."allowed_extensions" AS t1_r36, "assignments"."turnitin_settings" AS t1_r37, "assignments"."muted" AS t1_r38, "assignments"."group_category_id" AS t1_r39, "assignments"."freeze_on_copy" AS t1_r40, "assignments"."copied" AS t1_r41, "assignments"."only_visible_to_overrides" AS t1_r42, "assignments"."post_to_sis" AS t1_r43, "assignments"."integration_id" AS t1_r44, "assignments"."integration_data" AS t1_r45, "assignments"."turnitin_id" AS t1_r46, "assignments"."moderated_grading" AS t1_r47, "assignments"."grades_published_at" AS t1_r48, "assignments"."omit_from_final_grade" AS t1_r49, "assignments"."vericite_enabled" AS t1_r50, "assignments"."intra_group_peer_reviews" AS t1_r51, "assignments"."lti_context_id" AS t1_r52, "assignments"."anonymous_instructor_annotations" AS t1_r53, "assignments"."duplicate_of_id" AS t1_r54, "assignments"."anonymous_grading" AS t1_r55, "assignments"."graders_anonymous_to_graders" AS t1_r56, "assignments"."grader_count" AS t1_r57, "assignments"."grader_comments_visible_to_graders" AS t1_r58, "assignments"."grader_section_id" AS t1_r59, "assignments"."final_grader_id" AS t1_r60, "assignments"."grader_names_visible_to_final_grader" AS t1_r61, "assignments"."duplication_started_at" AS t1_r62, "assignments"."importing_started_at" AS t1_r63, "assignments"."allowed_attempts" AS t1_r64, "assignments"."root_account_id" AS t1_r65, "assignments"."sis_source_id" AS t1_r66, "assignments"."migrate_from_id" AS t1_r67, "assignments"."settings" AS t1_r68, "assignments"."annotatable_attachment_id" AS t1_r69, "assignments"."important_dates" AS t1_r70, "assignments"."hide_in_gradebook" AS t1_r71, "assignments"."ab_guid" AS t1_r72, "assignments"."checkpointed" AS t1_r73, "assignments"."checkpoint_label" AS t1_r74, "assignments"."parent_assignment_id" AS t1_r75, "assignments"."type" AS t1_r76 FROM "public"."submissions" LEFT OUTER JOIN "public"."assignments" ON "assignments"."id" = "submissions"."assignment_id" WHERE "submissions"."user_id" = 1 AND (submissions.workflow_state <> 'deleted') AND "submissions"."posted_at" IS NOT NULL AND (GREATEST(submissions.submitted_at, submissions.created_at) > '2025-06-26 02:51:24.078907') AND "submissions"."course_id" = 10 AND (submissions.score IS NOT NULL AND assignments.workflow_state='published') ORDER BY "submissions"."updated_at" DESC, submissions.created_at DESC LIMIT 20 [production:1 secondary]
[06cfbb7e77325750e2fc1a4a0572d628 800abef5-58bf-4c05-b104-9f19f294e737] SQL Submission Load (2.6ms) SELECT "submissions".* FROM "public"."submissions" INNER JOIN "public"."assignments" ON "assignments"."id" = "submissions"."assignment_id" INNER JOIN "public"."post_policies" ON "post_policies"."assignment_id" = "assignments"."id" WHERE (submissions.workflow_state <> 'deleted') AND "submissions"."user_id" = 1 AND "submissions"."course_id" = 10 AND (submissions.posted_at IS NOT NULL OR post_policies.post_manually IS FALSE) AND "assignments"."workflow_state" = 'published' AND (last_comment_at > '2025-06-26 02:51:24.078907') ORDER BY last_comment_at LIMIT 20 [production:1 secondary]
[06cfbb7e77325750e2fc1a4a0572d628 800abef5-58bf-4c05-b104-9f19f294e737] Rendering users/dashboard_sidebar.html.erb
[06cfbb7e77325750e2fc1a4a0572d628 800abef5-58bf-4c05-b104-9f19f294e737] SQL FeatureFlag Load (0.6ms) SELECT "feature_flags".* FROM "public"."feature_flags" WHERE "feature_flags"."feature" = 'high_contrast' AND "feature_flags"."context_type" = 'User' AND "feature_flags"."context_id" = 1 ORDER BY "feature_flags"."id" ASC LIMIT 1 [production:1 primary]
[06cfbb7e77325750e2fc1a4a0572d628 800abef5-58bf-4c05-b104-9f19f294e737] SQL Account Load (1.4ms) SELECT "accounts".* FROM "public"."accounts" INNER JOIN "public"."user_account_associations" ON "accounts"."id" = "user_account_associations"."account_id" WHERE "user_account_associations"."user_id" = 1 AND (accounts.id = 1 OR accounts.root_account_id = 1) ORDER BY user_account_associations.depth [production:1 secondary]
[06cfbb7e77325750e2fc1a4a0572d628 800abef5-58bf-4c05-b104-9f19f294e737] SQL Enrollment Pluck (2.0ms) SELECT DISTINCT "account_id" FROM "public"."enrollments" INNER JOIN "public"."courses" ON "courses"."id" = "enrollments"."course_id" WHERE "enrollments"."root_account_id" = 1 AND (enrollments.workflow_state='active' AND (courses.workflow_state='available' OR courses.workflow_state IN ('created', 'claimed') AND enrollments.type IN ('TeacherEnrollment','TaEnrollment','DesignerEnrollment','StudentViewEnrollment'))) AND "enrollments"."user_id" = 1 [production:1 secondary]
[06cfbb7e77325750e2fc1a4a0572d628 800abef5-58bf-4c05-b104-9f19f294e737] SQL Account Load (1.0ms) WITH RECURSIVE t AS ( SELECT * FROM "public"."accounts" WHERE id=1 UNION SELECT accounts.* FROM "public"."accounts" INNER JOIN t ON accounts.id=t.parent_account_id ) SELECT * FROM t [production:1 secondary]
[06cfbb7e77325750e2fc1a4a0572d628 800abef5-58bf-4c05-b104-9f19f294e737] SQL BrandConfig Load (0.6ms) SELECT "brand_configs".* FROM "public"."brand_configs" WHERE "brand_configs"."md5" = '3ba81c2a42a55ab9e224f20c27c3366f' LIMIT 1 [production:1 primary]
[06cfbb7e77325750e2fc1a4a0572d628 800abef5-58bf-4c05-b104-9f19f294e737] SQL BrandConfig Load (0.5ms) SELECT "brand_configs".* FROM "public"."brand_configs" WHERE "brand_configs"."md5" = '848d50addff314a5e4c17051651261da' LIMIT 1 [production:1 primary]
[06cfbb7e77325750e2fc1a4a0572d628 800abef5-58bf-4c05-b104-9f19f294e737] CACHE SQL BrandConfig Load (0.0ms) 1::SELECT "brand_configs".* FROM "public"."brand_configs" WHERE "brand_configs"."md5" = '848d50addff314a5e4c17051651261da' LIMIT 1
[06cfbb7e77325750e2fc1a4a0572d628 800abef5-58bf-4c05-b104-9f19f294e737] SQL Enrollment Load (1.9ms) SELECT "enrollments".* FROM "public"."enrollments" INNER JOIN "public"."courses" ON "courses"."id" = "enrollments"."course_id" INNER JOIN "public"."enrollment_states" ON "enrollment_states"."enrollment_id" = "enrollments"."id" WHERE "enrollments"."user_id" = 1 AND (enrollments.workflow_state='active' AND (courses.workflow_state='available' OR courses.workflow_state IN ('created', 'claimed') AND enrollments.type IN ('TeacherEnrollment','TaEnrollment','DesignerEnrollment','StudentViewEnrollment'))) AND (enrollment_states.state = 'active') [production:1 secondary]
[06cfbb7e77325750e2fc1a4a0572d628 800abef5-58bf-4c05-b104-9f19f294e737] SQL Course Load (1.4ms) SELECT "courses".* FROM "public"."courses" WHERE "courses"."id" IN (16, 19, 5, 10, 14, 34, 18, 20, 28, 29, 13, 27, 30, 3, 33, 12, 22, 2, 31, 32, 4, 21, 11) [production:1 secondary]
[06cfbb7e77325750e2fc1a4a0572d628 800abef5-58bf-4c05-b104-9f19f294e737] SQL EnrollmentState Load (0.9ms) SELECT "enrollment_states".* FROM "public"."enrollment_states" WHERE "enrollment_states"."enrollment_id" IN (39, 50, 7, 41, 35, 115, 43, 53, 13, 72, 76, 32, 68, 81, 3, 114, 29, 58, 2, 88, 97, 4, 55, 22) [production:1 secondary]
[06cfbb7e77325750e2fc1a4a0572d628 800abef5-58bf-4c05-b104-9f19f294e737] SQL AccountUser Load (1.2ms) SELECT "account_users".* FROM "public"."account_users" WHERE "account_users"."user_id" = 1 AND "account_users"."workflow_state" != 'deleted' [production:1 secondary]
[06cfbb7e77325750e2fc1a4a0572d628 800abef5-58bf-4c05-b104-9f19f294e737] SQL Role Load (0.7ms) SELECT "roles".* FROM "public"."roles" WHERE "roles"."id" IN (17, 9) [production:1 secondary]
[06cfbb7e77325750e2fc1a4a0572d628 800abef5-58bf-4c05-b104-9f19f294e737] SQL (1.6ms) WITH RECURSIVE t(id, name, parent_account_id, role_id, enabled, locked, self, children, permission) AS ( SELECT accounts.id, name, parent_account_id, ro.role_id, ro.enabled, ro.locked, ro.applies_to_self, ro.applies_to_descendants, ro.permission FROM "public"."accounts" LEFT JOIN "public"."role_overrides" AS ro ON ro.context_id = accounts.id AND ro.context_type = 'Account' AND ro.permission IN ('manage_grades') AND ro.role_id IN (12,11,17,9) WHERE accounts.id IN (3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3) UNION SELECT accounts.id, accounts.name, accounts.parent_account_id, ro.role_id, ro.enabled, ro.locked, ro.applies_to_self, ro.applies_to_descendants, ro.permission FROM "public"."accounts" INNER JOIN t ON accounts.id = t.parent_account_id LEFT JOIN "public"."role_overrides" AS ro ON ro.context_id = accounts.id AND ro.context_type = 'Account' AND ro.permission IN ('manage_grades') AND ro.role_id IN (12,11,17,9) WHERE accounts.workflow_state = 'active' ) SELECT * FROM t [production:1 secondary]
[06cfbb7e77325750e2fc1a4a0572d628 800abef5-58bf-4c05-b104-9f19f294e737] SQL GroupMembership Load (2.7ms) SELECT "group_memberships".* FROM "public"."group_memberships" INNER JOIN "public"."groups" ON "groups"."id" = "group_memberships"."group_id" LEFT OUTER JOIN "public"."enrollments" ON enrollments.user_id=group_memberships.user_id AND enrollments.course_id=groups.context_id AND groups.context_type='Course' LEFT OUTER JOIN "public"."enrollment_states" ON enrollment_states.enrollment_id=enrollments.id WHERE "group_memberships"."user_id" = 1 AND (group_memberships.workflow_state='accepted' AND groups.workflow_state<>'deleted' AND COALESCE(enrollment_states.state,'active') IN ('invited','active')) [production:1 primary]
[06cfbb7e77325750e2fc1a4a0572d628 800abef5-58bf-4c05-b104-9f19f294e737] SQL Assignment Load (8.4ms) SELECT "assignments".* FROM "public"."assignments" INNER JOIN (SELECT "submissions"."assignment_id", "submissions"."user_id" FROM "public"."submissions" INNER JOIN (SELECT "assignments".* FROM "public"."assignments" WHERE NOT (EXISTS (SELECT "ignores".* FROM "public"."ignores" WHERE "ignores"."asset_type" = 'Assignment' AND "ignores"."user_id" = 1 AND "ignores"."purpose" = 'grading' AND (asset_id=assignments.id))) AND "assignments"."context_type" = 'Course' AND "assignments"."context_id" IN (16, 19, 5, 10, 14, 34, 18, 20, 10, 28, 29, 13, 27, 30, 3, 33, 12, 22, 2, 31, 32, 4, 21, 11) AND "assignments"."workflow_state" != 'deleted' AND NOT (("assignments"."submission_types" IN ('', 'none', 'not_graded', 'on_paper', 'wiki_page') OR "assignments"."submission_types" IS NULL))) assignments ON assignment_id=assignments.id WHERE (submissions.submission_type IS NOT NULL AND (submissions.excused=false OR submissions.excused IS NULL) AND (submissions.workflow_state = 'pending_review' OR (submissions.workflow_state IN ('submitted', 'graded') AND (submissions.score IS NULL OR submissions.grade_matches_current_submission = 'f') ) ))) AS submissions_needing_grading ON assignments.id=submissions_needing_grading.assignment_id INNER JOIN "public"."enrollments" ON enrollments.course_id = assignments.context_id WHERE NOT (EXISTS (SELECT "ignores".* FROM "public"."ignores" WHERE "ignores"."asset_type" = 'Assignment' AND "ignores"."user_id" = 1 AND "ignores"."purpose" = 'grading' AND (asset_id=assignments.id))) AND "assignments"."context_type" = 'Course' AND "assignments"."context_id" IN (16, 19, 5, 10, 14, 34, 18, 20, 10, 28, 29, 13, 27, 30, 3, 33, 12, 22, 2, 31, 32, 4, 21, 11) AND "assignments"."workflow_state" != 'deleted' AND NOT (("assignments"."submission_types" IN ('', 'none', 'not_graded', 'on_paper', 'wiki_page') OR "assignments"."submission_types" IS NULL)) AND EXISTS (SELECT 1 FROM "public"."enrollments" student_enrollments WHERE (student_enrollments.course_id=assignments.context_id) AND (student_enrollments.user_id=submissions_needing_grading.user_id AND student_enrollments.workflow_state='active') AND ((enrollments.limit_privileges_to_course_section='f' OR student_enrollments.course_section_id=enrollments.course_section_id))) AND "enrollments"."user_id" = 1 AND "enrollments"."workflow_state" = 'active' AND "enrollments"."type" IN ('TeacherEnrollment', 'TaEnrollment') GROUP BY "assignments"."id" ORDER BY assignments.due_at [production:1 secondary]
[06cfbb7e77325750e2fc1a4a0572d628 800abef5-58bf-4c05-b104-9f19f294e737] CACHE SQL AccountUser Load (0.0ms) 1::SELECT "account_users".* FROM "public"."account_users" WHERE "account_users"."user_id" = 1 AND "account_users"."workflow_state" != 'deleted'
[06cfbb7e77325750e2fc1a4a0572d628 800abef5-58bf-4c05-b104-9f19f294e737] CACHE SQL Role Load (0.0ms) 1::SELECT "roles".* FROM "public"."roles" WHERE "roles"."id" IN (17, 9)
[06cfbb7e77325750e2fc1a4a0572d628 800abef5-58bf-4c05-b104-9f19f294e737] SQL (1.6ms) WITH RECURSIVE t(id, name, parent_account_id, role_id, enabled, locked, self, children, permission) AS ( SELECT accounts.id, name, parent_account_id, ro.role_id, ro.enabled, ro.locked, ro.applies_to_self, ro.applies_to_descendants, ro.permission FROM "public"."accounts" LEFT JOIN "public"."role_overrides" AS ro ON ro.context_id = accounts.id AND ro.context_type = 'Account' AND ro.permission IN ('select_final_grade') AND ro.role_id IN (12,11,17,9) WHERE accounts.id IN (3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3) UNION SELECT accounts.id, accounts.name, accounts.parent_account_id, ro.role_id, ro.enabled, ro.locked, ro.applies_to_self, ro.applies_to_descendants, ro.permission FROM "public"."accounts" INNER JOIN t ON accounts.id = t.parent_account_id LEFT JOIN "public"."role_overrides" AS ro ON ro.context_id = accounts.id AND ro.context_type = 'Account' AND ro.permission IN ('select_final_grade') AND ro.role_id IN (12,11,17,9) WHERE accounts.workflow_state = 'active' ) SELECT * FROM t [production:1 secondary]
[06cfbb7e77325750e2fc1a4a0572d628 800abef5-58bf-4c05-b104-9f19f294e737] SQL Assignment Load (2.8ms) SELECT "assignments".* FROM "public"."assignments" WHERE NOT (EXISTS (SELECT "ignores".* FROM "public"."ignores" WHERE "ignores"."asset_type" = 'Assignment' AND "ignores"."user_id" = 1 AND "ignores"."purpose" = 'moderation' AND (asset_id=assignments.id))) AND "assignments"."context_type" = 'Course' AND "assignments"."context_id" IN (16, 19, 5, 10, 14, 34, 18, 20, 10, 28, 29, 13, 27, 30, 3, 33, 12, 22, 2, 31, 32, 4, 21, 11) AND "assignments"."workflow_state" != 'deleted' AND NOT (("assignments"."submission_types" IN ('', 'none', 'not_graded', 'on_paper', 'wiki_page') OR "assignments"."submission_types" IS NULL)) AND "assignments"."workflow_state" != 'deleted' AND NOT (("assignments"."submission_types" IN ('', 'none', 'not_graded', 'on_paper', 'wiki_page') OR "assignments"."submission_types" IS NULL)) AND "assignments"."final_grader_id" = 1 AND "assignments"."moderated_grading" = TRUE AND "assignments"."grades_published_at" IS NULL AND "assignments"."id" IN (SELECT DISTINCT "assignment_id" FROM "public"."moderated_grading_provisional_grades" INNER JOIN "public"."submissions" ON "submissions"."id" = "moderated_grading_provisional_grades"."submission_id" WHERE (submissions.assignment_id=assignments.id) AND (submissions.submission_type IS NOT NULL AND (submissions.excused=false OR submissions.excused IS NULL) AND (submissions.workflow_state = 'pending_review' OR (submissions.workflow_state IN ('submitted', 'graded') AND (submissions.score IS NULL OR submissions.grade_matches_current_submission = 'f') ) ))) [production:1 secondary]
[06cfbb7e77325750e2fc1a4a0572d628 800abef5-58bf-4c05-b104-9f19f294e737] SQL Assignment Load (12.7ms) SELECT "assignments".* FROM (SELECT s.cached_due_date AS user_due_date, a.*
FROM "public"."assignments" a
INNER JOIN "public"."submissions" AS s ON s.assignment_id = a.id
WHERE s.user_id = 1 AND s.workflow_state <> 'deleted') AS assignments WHERE NOT (EXISTS (SELECT "ignores".* FROM "public"."ignores" WHERE "ignores"."asset_type" = 'Assignment' AND "ignores"."user_id" = 1 AND "ignores"."purpose" = 'submitting' AND (asset_id=assignments.id))) AND "assignments"."context_type" = 'Course' AND "assignments"."context_id" = 10 AND "assignments"."workflow_state" = 'published' AND "assignments"."user_due_date" BETWEEN '2025-06-26 02:51:24.534265' AND '2025-07-31 02:51:24.534526' AND (NOT EXISTS (SELECT 1 FROM "public"."submissions"
WHERE assignment_id = assignments.id
AND submissions.workflow_state <> 'deleted'
AND (submission_type IS NOT NULL OR excused = TRUE)
AND user_id = 1)) AND (NOT (("assignments"."submission_types" IN ('on_paper', 'external_tool', 'none', 'not_graded', 'wiki_page') OR "assignments"."submission_types" IS NULL)) OR assignments.user_due_date > '2025-07-24 02:51:24.538883') AND ((assignments.unlock_at IS NULL OR assignments.unlock_at<'2025-07-24 02:51:24.539474') AND (assignments.lock_at IS NULL OR assignments.lock_at>'2025-07-24 02:51:24.539474')) ORDER BY assignments.due_at LIMIT 100 [production:1 secondary]
[06cfbb7e77325750e2fc1a4a0572d628 800abef5-58bf-4c05-b104-9f19f294e737] SQL Quizzes::Quiz Exists (5.0ms) SELECT 1 AS one FROM (WITH overrides AS (
SELECT DISTINCT ON (o.quiz_id, o.user_id) *
FROM (
SELECT ao.quiz_id, aos.user_id, ao.due_at, ao.due_at_overridden, 1 AS priority
FROM "public"."assignment_overrides" ao
INNER JOIN "public"."assignment_override_students" aos ON ao.id = aos.assignment_override_id AND ao.set_type = 'ADHOC'
WHERE aos.user_id = 1
AND ao.workflow_state = 'active'
AND aos.workflow_state <> 'deleted'
UNION
SELECT ao.quiz_id, e.user_id, ao.due_at, ao.due_at_overridden, 1 AS priority
FROM "public"."assignment_overrides" ao
INNER JOIN "public"."enrollments" e ON e.course_section_id = ao.set_id AND ao.set_type = 'CourseSection'
WHERE e.user_id = 1
AND e.workflow_state NOT IN ('rejected', 'deleted', 'inactive')
AND ao.workflow_state = 'active'
UNION
SELECT q.id, e.user_id, q.due_at, FALSE as due_at_overridden, 2 AS priority
FROM "public"."quizzes" q
INNER JOIN "public"."enrollments" e ON e.course_id = q.context_id
WHERE e.workflow_state NOT IN ('rejected', 'deleted', 'inactive')
AND e.type in ('StudentEnrollment', 'StudentViewEnrollment')
AND e.user_id = 1
AND q.assignment_id IS NULL
AND NOT q.only_visible_to_overrides
) o
ORDER BY o.user_id ASC, o.quiz_id ASC, priority ASC, o.due_at_overridden DESC, o.due_at DESC NULLS FIRST
)
SELECT CASE WHEN overrides.due_at_overridden THEN overrides.due_at ELSE q.due_at END as user_due_date, q.*
FROM "public"."quizzes" q
INNER JOIN overrides ON overrides.quiz_id = q.id) as quizzes WHERE NOT (EXISTS (SELECT "ignores".* FROM "public"."ignores" WHERE "ignores"."asset_type" = 'Quizzes::Quiz' AND "ignores"."user_id" = 1 AND "ignores"."purpose" = 'viewing' AND (asset_id=quizzes.id))) AND "quizzes"."context_type" = 'Course' AND "quizzes"."context_id" = 10 AND (quizzes.workflow_state = 'available') AND ((quizzes.unlock_at IS NULL OR quizzes.unlock_at<'2025-07-24 02:51:24.565297') AND (quizzes.lock_at IS NULL OR quizzes.lock_at>'2025-07-24 02:51:24.565297')) AND "quizzes"."assignment_id" IS NULL AND "quizzes"."user_due_date" BETWEEN '2025-07-24 02:51:24.554687' AND '2025-07-31 02:51:24.554715' AND ((SELECT COUNT(id) FROM "public"."quiz_submissions"
WHERE quiz_id = quizzes.id
AND workflow_state = 'complete'
AND user_id = 1) = 0) LIMIT 1 [production:1 secondary]
[06cfbb7e77325750e2fc1a4a0572d628 54208b97-4a3e-4915-a38f-cab74be316f8] SQL ActiveRecord::SchemaMigration Pluck (0.9ms) SELECT "schema_migrations"."version" FROM "public"."schema_migrations" ORDER BY "schema_migrations"."version" ASC [production:1 primary]
[06cfbb7e77325750e2fc1a4a0572d628 800abef5-58bf-4c05-b104-9f19f294e737] SQL SQL (4.0ms) SELECT "assessment_requests"."id" AS t0_r0, "assessment_requests"."rubric_assessment_id" AS t0_r1, "assessment_requests"."user_id" AS t0_r2, "assessment_requests"."asset_id" AS t0_r3, "assessment_requests"."asset_type" AS t0_r4, "assessment_requests"."assessor_asset_id" AS t0_r5, "assessment_requests"."assessor_asset_type" AS t0_r6, "assessment_requests"."workflow_state" AS t0_r7, "assessment_requests"."created_at" AS t0_r8, "assessment_requests"."updated_at" AS t0_r9, "assessment_requests"."uuid" AS t0_r10, "assessment_requests"."rubric_association_id" AS t0_r11, "assessment_requests"."assessor_id" AS t0_r12, "submissions"."id" AS t1_r0, "submissions"."body" AS t1_r1, "submissions"."url" AS t1_r2, "submissions"."attachment_id" AS t1_r3, "submissions"."grade" AS t1_r4, "submissions"."score" AS t1_r5, "submissions"."submitted_at" AS t1_r6, "submissions"."assignment_id" AS t1_r7, "submissions"."user_id" AS t1_r8, "submissions"."submission_type" AS t1_r9, "submissions"."workflow_state" AS t1_r10, "submissions"."created_at" AS t1_r11, "submissions"."updated_at" AS t1_r12, "submissions"."group_id" AS t1_r13, "submissions"."attachment_ids" AS t1_r14, "submissions"."processed" AS t1_r15, "submissions"."grade_matches_current_submission" AS t1_r16, "submissions"."published_score" AS t1_r17, "submissions"."published_grade" AS t1_r18, "submissions"."graded_at" AS t1_r19, "submissions"."student_entered_score" AS t1_r20, "submissions"."grader_id" AS t1_r21, "submissions"."media_comment_id" AS t1_r22, "submissions"."media_comment_type" AS t1_r23, "submissions"."quiz_submission_id" AS t1_r24, "submissions"."submission_comments_count" AS t1_r25, "submissions"."attempt" AS t1_r26, "submissions"."media_object_id" AS t1_r27, "submissions"."turnitin_data" AS t1_r28, "submissions"."cached_due_date" AS t1_r29, "submissions"."excused" AS t1_r30, "submissions"."graded_anonymously" AS t1_r31, "submissions"."late_policy_status" AS t1_r32, "submissions"."points_deducted" AS t1_r33, "submissions"."grading_period_id" AS t1_r34, "submissions"."seconds_late_override" AS t1_r35, "submissions"."lti_user_id" AS t1_r36, "submissions"."anonymous_id" AS t1_r37, "submissions"."last_comment_at" AS t1_r38, "submissions"."extra_attempts" AS t1_r39, "submissions"."posted_at" AS t1_r40, "submissions"."cached_quiz_lti" AS t1_r41, "submissions"."cached_tardiness" AS t1_r42, "submissions"."course_id" AS t1_r43, "submissions"."root_account_id" AS t1_r44, "submissions"."redo_request" AS t1_r45, "submissions"."resource_link_lookup_uuid" AS t1_r46, "submissions"."proxy_submitter_id" AS t1_r47, "submissions"."custom_grade_status_id" AS t1_r48, "submissions"."sticker" AS t1_r49 FROM "public"."assessment_requests" INNER JOIN "public"."submissions" ON "submissions"."id" = "assessment_requests"."asset_id" AND "assessment_requests"."asset_type" = 'Submission' INNER JOIN "public"."assignments" ON "assignments"."id" = "submissions"."assignment_id" INNER JOIN "public"."submissions" AS assessor_asset ON assessment_requests.assessor_asset_id = assessor_asset.id
AND assessor_asset.assignment_id = assignments.id INNER JOIN "public"."enrollments" AS enrollments ON enrollments.user_id = assessment_requests.user_id
AND enrollments.course_id = assessor_asset.course_id AND enrollments.workflow_state NOT IN ('rejected', 'completed', 'deleted', 'inactive') WHERE NOT (EXISTS (SELECT "ignores".* FROM "public"."ignores" WHERE (asset_id=assessment_requests.id) AND "ignores"."asset_type" = 'AssessmentRequest' AND "ignores"."user_id" = 1 AND "ignores"."purpose" = 'reviewing')) AND "assessment_requests"."assessor_id" = 1 AND "assessor_asset"."course_id" = 10 AND "assessment_requests"."workflow_state" = 'assigned' AND "submissions"."course_id" = 10 AND (submissions.workflow_state <> 'deleted') AND "assignments"."workflow_state" = 'published' AND "assignments"."peer_reviews" = TRUE AND (assessor_asset.cached_due_date <= '2025-08-07 02:51:24.575195') AND (assessor_asset.cached_due_date > '2025-07-10 02:51:24.574990') LIMIT 100 [production:1 secondary]
[06cfbb7e77325750e2fc1a4a0572d628 800abef5-58bf-4c05-b104-9f19f294e737] Rendered courses/_to_do_list.html.erb (Duration: 392.7ms | Allocations: 45080) [cache miss]
[06cfbb7e77325750e2fc1a4a0572d628 800abef5-58bf-4c05-b104-9f19f294e737] Rendered shared/_event_list.html.erb (Duration: 3.7ms | Allocations: 1702)
[06cfbb7e77325750e2fc1a4a0572d628 800abef5-58bf-4c05-b104-9f19f294e737] Rendered shared/_event_list.html.erb (Duration: 3.2ms | Allocations: 1455)
[06cfbb7e77325750e2fc1a4a0572d628 800abef5-58bf-4c05-b104-9f19f294e737] SQL Account Load (0.7ms) SELECT "accounts".* FROM "public"."accounts" WHERE "accounts"."parent_account_id" = 1 AND (workflow_state<>'deleted') AND "accounts"."id" = 3 ORDER BY "accounts"."id" ASC LIMIT 1 [production:1 primary]
[06cfbb7e77325750e2fc1a4a0572d628 800abef5-58bf-4c05-b104-9f19f294e737] CACHE SQL Account Load (0.0ms) 1::WITH RECURSIVE t AS ( SELECT * FROM "public"."accounts" WHERE id=1 UNION SELECT accounts.* FROM "public"."accounts" INNER JOIN t ON accounts.id=t.parent_account_id ) SELECT * FROM t
[06cfbb7e77325750e2fc1a4a0572d628 54208b97-4a3e-4915-a38f-cab74be316f8] SQL Account Load (1.9ms) SELECT "accounts".* FROM "public"."accounts" WHERE "accounts"."id" = 1 LIMIT 1 [production:1 primary]
[06cfbb7e77325750e2fc1a4a0572d628 800abef5-58bf-4c05-b104-9f19f294e737] SQL AccountUser Load (0.8ms) SELECT "account_users".* FROM "public"."account_users" WHERE "account_users"."account_id" IN (3, 1, 2) AND "account_users"."user_id" = 1 AND "account_users"."workflow_state" != 'deleted' [production:1 primary]
[06cfbb7e77325750e2fc1a4a0572d628 800abef5-58bf-4c05-b104-9f19f294e737] SQL Role Load (0.7ms) SELECT "roles".* FROM "public"."roles" WHERE "roles"."id" = 17 LIMIT 1 [production:1 primary]
[06cfbb7e77325750e2fc1a4a0572d628 800abef5-58bf-4c05-b104-9f19f294e737] CACHE SQL Account Load (0.0ms) 1::SELECT "accounts".* FROM "public"."accounts" WHERE "accounts"."id" = 2 LIMIT 1
[06cfbb7e77325750e2fc1a4a0572d628 800abef5-58bf-4c05-b104-9f19f294e737] CACHE SQL FeatureFlag Load (0.0ms) 1::SELECT "feature_flags".* FROM "public"."feature_flags" WHERE "feature_flags"."context_id" = 2 AND "feature_flags"."context_type" = 'Account'
[06cfbb7e77325750e2fc1a4a0572d628 800abef5-58bf-4c05-b104-9f19f294e737] SQL FeatureFlag Load (0.5ms) SELECT "feature_flags".* FROM "public"."feature_flags" WHERE "feature_flags"."feature" = 'granular_permissions_manage_courses' AND "feature_flags"."context_type" = 'Account' AND "feature_flags"."context_id" = 1 ORDER BY "feature_flags"."id" ASC LIMIT 1 [production:1 primary]
[06cfbb7e77325750e2fc1a4a0572d628 800abef5-58bf-4c05-b104-9f19f294e737] SQL Role Load (0.5ms) SELECT "roles".* FROM "public"."roles" WHERE "roles"."id" = 9 LIMIT 1 [production:1 primary]
[06cfbb7e77325750e2fc1a4a0572d628 54208b97-4a3e-4915-a38f-cab74be316f8] SQL FeatureFlag Load (0.7ms) SELECT "feature_flags".* FROM "public"."feature_flags" WHERE "feature_flags"."context_id" = 1 AND "feature_flags"."context_type" = 'Account' [production:1 primary]
[06cfbb7e77325750e2fc1a4a0572d628 800abef5-58bf-4c05-b104-9f19f294e737] SQL Role Load (0.8ms) SELECT "roles".* FROM "public"."roles" WHERE "roles"."workflow_state" = 'built_in' AND "roles"."root_account_id" IN (1, 2) AND "roles"."base_role_type" = 'AccountAdmin' [production:1 primary]
[06cfbb7e77325750e2fc1a4a0572d628 54208b97-4a3e-4915-a38f-cab74be316f8] SQL Account Load (0.6ms) SELECT "accounts".* FROM "public"."accounts" WHERE "accounts"."id" = 2 LIMIT 1 [production:1 primary]
[06cfbb7e77325750e2fc1a4a0572d628 800abef5-58bf-4c05-b104-9f19f294e737] SQL (0.4ms) SELECT pg_is_in_recovery() [production:1 primary]
[06cfbb7e77325750e2fc1a4a0572d628 54208b97-4a3e-4915-a38f-cab74be316f8] SQL FeatureFlag Load (0.5ms) SELECT "feature_flags".* FROM "public"."feature_flags" WHERE "feature_flags"."context_id" = 2 AND "feature_flags"."context_type" = 'Account' [production:1 primary]
[06cfbb7e77325750e2fc1a4a0572d628 800abef5-58bf-4c05-b104-9f19f294e737] SQL RoleOverride Load (1.5ms) COPY (SELECT "role_overrides".* FROM "public"."role_overrides" WHERE "role_overrides"."role_id" IN (17, 9, 17) AND "role_overrides"."context_id" IN (3, 1, 2)) TO STDOUT [production:1 primary]
[06cfbb7e77325750e2fc1a4a0572d628 54208b97-4a3e-4915-a38f-cab74be316f8] SQL PluginSetting Load (1.0ms) SELECT "plugin_settings".* FROM "public"."plugin_settings" WHERE "plugin_settings"."name" = 'sessions' ORDER BY "plugin_settings"."id" ASC LIMIT 1 [production:1 primary]
[06cfbb7e77325750e2fc1a4a0572d628 54208b97-4a3e-4915-a38f-cab74be316f8] request throttling increment: [0,50.0,1753325484.6679,["client_identifier","user:10000000000001"],["count",0.0],["last_touched",null]]
[06cfbb7e77325750e2fc1a4a0572d628 800abef5-58bf-4c05-b104-9f19f294e737] CACHE SQL Account Load (0.0ms) 1::SELECT "accounts".* FROM "public"."accounts" WHERE "accounts"."parent_account_id" = 1 AND (workflow_state<>'deleted') AND "accounts"."id" = 3 ORDER BY "accounts"."id" ASC LIMIT 1
[06cfbb7e77325750e2fc1a4a0572d628 800abef5-58bf-4c05-b104-9f19f294e737] CACHE SQL Account Load (0.0ms) 1::WITH RECURSIVE t AS ( SELECT * FROM "public"."accounts" WHERE id=1 UNION SELECT accounts.* FROM "public"."accounts" INNER JOIN t ON accounts.id=t.parent_account_id ) SELECT * FROM t
[06cfbb7e77325750e2fc1a4a0572d628 800abef5-58bf-4c05-b104-9f19f294e737] CACHE SQL AccountUser Load (0.0ms) 1::SELECT "account_users".* FROM "public"."account_users" WHERE "account_users"."account_id" IN (3, 1, 2) AND "account_users"."user_id" = 1 AND "account_users"."workflow_state" != 'deleted'
[06cfbb7e77325750e2fc1a4a0572d628 800abef5-58bf-4c05-b104-9f19f294e737] CACHE SQL Role Load (0.1ms) 1::SELECT "roles".* FROM "public"."roles" WHERE "roles"."id" = 17 LIMIT 1
[06cfbb7e77325750e2fc1a4a0572d628 800abef5-58bf-4c05-b104-9f19f294e737] Rendered shared/_new_course_form.html.erb (Duration: 25.6ms | Allocations: 6303)
[06cfbb7e77325750e2fc1a4a0572d628 800abef5-58bf-4c05-b104-9f19f294e737] Rendered users/dashboard_sidebar.html.erb (Duration: 563.7ms | Allocations: 90707)
[06cfbb7e77325750e2fc1a4a0572d628 800abef5-58bf-4c05-b104-9f19f294e737] Completed 200 OK in 1415ms (Views: 516.6ms | ActiveRecord: 147.9ms | Allocations: 280477)
[06cfbb7e77325750e2fc1a4a0572d628 800abef5-58bf-4c05-b104-9f19f294e737] [STATSD] (sql_read: 96.00) (sql_write: 5.00) (sql_cache: 0.00) (active_record: 182.00) (cache_read: 209.00) (total: 1415.23) (view: 516.58) (db: 147.86)
[06cfbb7e77325750e2fc1a4a0572d628 800abef5-58bf-4c05-b104-9f19f294e737] [STAT] 963284 963284 0 0 1.067487 0.132031
[06cfbb7e77325750e2fc1a4a0572d628 800abef5-58bf-4c05-b104-9f19f294e737] request throttling increment: [1.215343953054667,-50.0,1753325484.687921,["client_identifier","user:10000000000001"],["count",50.0],["last_touched",1753325483.2213]]
[06cfbb7e77325750e2fc1a4a0572d628 800abef5-58bf-4c05-b104-9f19f294e737] Redis (0.407ms) evalsha - [redis://192.168.0.7:6379/0]
[06cfbb7e77325750e2fc1a4a0572d628 54208b97-4a3e-4915-a38f-cab74be316f8] Redis (0.712ms) evalsha - [redis://192.168.0.7:6379/0]
[06cfbb7e77325750e2fc1a4a0572d628 54208b97-4a3e-4915-a38f-cab74be316f8] Processing by ContentSharesController#unread_count as JSON
[06cfbb7e77325750e2fc1a4a0572d628 54208b97-4a3e-4915-a38f-cab74be316f8] Parameters: {"user_id"=>"self"}
[06cfbb7e77325750e2fc1a4a0572d628 54208b97-4a3e-4915-a38f-cab74be316f8] No separate files host specified for account id 1. This is a potential security risk.
[06cfbb7e77325750e2fc1a4a0572d628 54208b97-4a3e-4915-a38f-cab74be316f8] SQL SQL (4.9ms) SELECT "pseudonyms"."id" AS t0_r0, "pseudonyms"."user_id" AS t0_r1, "pseudonyms"."account_id" AS t0_r2, "pseudonyms"."workflow_state" AS t0_r3, "pseudonyms"."unique_id" AS t0_r4, "pseudonyms"."crypted_password" AS t0_r5, "pseudonyms"."password_salt" AS t0_r6, "pseudonyms"."persistence_token" AS t0_r7, "pseudonyms"."single_access_token" AS t0_r8, "pseudonyms"."perishable_token" AS t0_r9, "pseudonyms"."login_count" AS t0_r10, "pseudonyms"."failed_login_count" AS t0_r11, "pseudonyms"."last_request_at" AS t0_r12, "pseudonyms"."last_login_at" AS t0_r13, "pseudonyms"."current_login_at" AS t0_r14, "pseudonyms"."last_login_ip" AS t0_r15, "pseudonyms"."current_login_ip" AS t0_r16, "pseudonyms"."reset_password_token" AS t0_r17, "pseudonyms"."position" AS t0_r18, "pseudonyms"."created_at" AS t0_r19, "pseudonyms"."updated_at" AS t0_r20, "pseudonyms"."password_auto_generated" AS t0_r21, "pseudonyms"."deleted_at" AS t0_r22, "pseudonyms"."sis_batch_id" AS t0_r23, "pseudonyms"."sis_user_id" AS t0_r24, "pseudonyms"."sis_ssha" AS t0_r25, "pseudonyms"."communication_channel_id" AS t0_r26, "pseudonyms"."sis_communication_channel_id" AS t0_r27, "pseudonyms"."stuck_sis_fields" AS t0_r28, "pseudonyms"."integration_id" AS t0_r29, "pseudonyms"."authentication_provider_id" AS t0_r30, "pseudonyms"."declared_user_type" AS t0_r31, "users"."id" AS t1_r0, "users"."name" AS t1_r1, "users"."sortable_name" AS t1_r2, "users"."workflow_state" AS t1_r3, "users"."time_zone" AS t1_r4, "users"."uuid" AS t1_r5, "users"."created_at" AS t1_r6, "users"."updated_at" AS t1_r7, "users"."avatar_image_url" AS t1_r8, "users"."avatar_image_source" AS t1_r9, "users"."avatar_image_updated_at" AS t1_r10, "users"."phone" AS t1_r11, "users"."school_name" AS t1_r12, "users"."school_position" AS t1_r13, "users"."short_name" AS t1_r14, "users"."deleted_at" AS t1_r15, "users"."show_user_services" AS t1_r16, "users"."page_views_count" AS t1_r17, "users"."reminder_time_for_due_dates" AS t1_r18, "users"."reminder_time_for_grading" AS t1_r19, "users"."storage_quota" AS t1_r20, "users"."visible_inbox_types" AS t1_r21, "users"."last_user_note" AS t1_r22, "users"."subscribe_to_emails" AS t1_r23, "users"."features_used" AS t1_r24, "users"."preferences" AS t1_r25, "users"."avatar_state" AS t1_r26, "users"."locale" AS t1_r27, "users"."browser_locale" AS t1_r28, "users"."unread_conversations_count" AS t1_r29, "users"."stuck_sis_fields" AS t1_r30, "users"."public" AS t1_r31, "users"."otp_secret_key_enc" AS t1_r32, "users"."otp_secret_key_salt" AS t1_r33, "users"."otp_communication_channel_id" AS t1_r34, "users"."initial_enrollment_type" AS t1_r35, "users"."crocodoc_id" AS t1_r36, "users"."last_logged_out" AS t1_r37, "users"."lti_context_id" AS t1_r38, "users"."turnitin_id" AS t1_r39, "users"."lti_id" AS t1_r40, "users"."pronouns" AS t1_r41, "users"."root_account_ids" AS t1_r42, "users"."merged_into_user_id" AS t1_r43 FROM "public"."pseudonyms" LEFT OUTER JOIN "public"."users" ON "users"."id" = "pseudonyms"."user_id" WHERE "pseudonyms"."id" = 19 LIMIT 1 [production:1 primary]
[06cfbb7e77325750e2fc1a4a0572d628 54208b97-4a3e-4915-a38f-cab74be316f8] [AUTH] Approved Authlogic session
[06cfbb7e77325750e2fc1a4a0572d628 54208b97-4a3e-4915-a38f-cab74be316f8] [AUTH] inital load: pseud -> 19, user -> 1
[06cfbb7e77325750e2fc1a4a0572d628 54208b97-4a3e-4915-a38f-cab74be316f8] [AUTH] final user: 1
[06cfbb7e77325750e2fc1a4a0572d628 54208b97-4a3e-4915-a38f-cab74be316f8] SQL SQL (1.6ms) SELECT "users"."id" AS t0_r0, "users"."name" AS t0_r1, "users"."sortable_name" AS t0_r2, "users"."workflow_state" AS t0_r3, "users"."time_zone" AS t0_r4, "users"."uuid" AS t0_r5, "users"."created_at" AS t0_r6, "users"."updated_at" AS t0_r7, "users"."avatar_image_url" AS t0_r8, "users"."avatar_image_source" AS t0_r9, "users"."avatar_image_updated_at" AS t0_r10, "users"."phone" AS t0_r11, "users"."school_name" AS t0_r12, "users"."school_position" AS t0_r13, "users"."short_name" AS t0_r14, "users"."deleted_at" AS t0_r15, "users"."show_user_services" AS t0_r16, "users"."page_views_count" AS t0_r17, "users"."reminder_time_for_due_dates" AS t0_r18, "users"."reminder_time_for_grading" AS t0_r19, "users"."storage_quota" AS t0_r20, "users"."visible_inbox_types" AS t0_r21, "users"."last_user_note" AS t0_r22, "users"."subscribe_to_emails" AS t0_r23, "users"."features_used" AS t0_r24, "users"."preferences" AS t0_r25, "users"."avatar_state" AS t0_r26, "users"."locale" AS t0_r27, "users"."browser_locale" AS t0_r28, "users"."unread_conversations_count" AS t0_r29, "users"."stuck_sis_fields" AS t0_r30, "users"."public" AS t0_r31, "users"."otp_secret_key_enc" AS t0_r32, "users"."otp_secret_key_salt" AS t0_r33, "users"."otp_communication_channel_id" AS t0_r34, "users"."initial_enrollment_type" AS t0_r35, "users"."crocodoc_id" AS t0_r36, "users"."last_logged_out" AS t0_r37, "users"."lti_context_id" AS t0_r38, "users"."turnitin_id" AS t0_r39, "users"."lti_id" AS t0_r40, "users"."pronouns" AS t0_r41, "users"."root_account_ids" AS t0_r42, "users"."merged_into_user_id" AS t0_r43, "pseudonyms"."id" AS t1_r0, "pseudonyms"."user_id" AS t1_r1, "pseudonyms"."account_id" AS t1_r2, "pseudonyms"."workflow_state" AS t1_r3, "pseudonyms"."unique_id" AS t1_r4, "pseudonyms"."crypted_password" AS t1_r5, "pseudonyms"."password_salt" AS t1_r6, "pseudonyms"."persistence_token" AS t1_r7, "pseudonyms"."single_access_token" AS t1_r8, "pseudonyms"."perishable_token" AS t1_r9, "pseudonyms"."login_count" AS t1_r10, "pseudonyms"."failed_login_count" AS t1_r11, "pseudonyms"."last_request_at" AS t1_r12, "pseudonyms"."last_login_at" AS t1_r13, "pseudonyms"."current_login_at" AS t1_r14, "pseudonyms"."last_login_ip" AS t1_r15, "pseudonyms"."current_login_ip" AS t1_r16, "pseudonyms"."reset_password_token" AS t1_r17, "pseudonyms"."position" AS t1_r18, "pseudonyms"."created_at" AS t1_r19, "pseudonyms"."updated_at" AS t1_r20, "pseudonyms"."password_auto_generated" AS t1_r21, "pseudonyms"."deleted_at" AS t1_r22, "pseudonyms"."sis_batch_id" AS t1_r23, "pseudonyms"."sis_user_id" AS t1_r24, "pseudonyms"."sis_ssha" AS t1_r25, "pseudonyms"."communication_channel_id" AS t1_r26, "pseudonyms"."sis_communication_channel_id" AS t1_r27, "pseudonyms"."stuck_sis_fields" AS t1_r28, "pseudonyms"."integration_id" AS t1_r29, "pseudonyms"."authentication_provider_id" AS t1_r30, "pseudonyms"."declared_user_type" AS t1_r31 FROM "public"."users" LEFT OUTER JOIN "public"."pseudonyms" ON "pseudonyms"."user_id" = "users"."id" AND (pseudonyms.workflow_state<>'deleted') WHERE "users"."id" = 1 ORDER BY "users"."id" ASC LIMIT 1 [production:1 primary]
[06cfbb7e77325750e2fc1a4a0572d628 54208b97-4a3e-4915-a38f-cab74be316f8] SQL ReceivedContentShare Count (1.1ms) SELECT COUNT(*) FROM "public"."content_shares" WHERE "content_shares"."type" = 'ReceivedContentShare' AND "content_shares"."user_id" = 1 AND "content_shares"."read_state" = 'unread' [production:1 primary]
[06cfbb7e77325750e2fc1a4a0572d628 54208b97-4a3e-4915-a38f-cab74be316f8] Completed 200 OK in 143ms (Views: 1.2ms | ActiveRecord: 7.6ms | Allocations: 58485)
[06cfbb7e77325750e2fc1a4a0572d628 54208b97-4a3e-4915-a38f-cab74be316f8] [STATSD] (sql_read: 3.00) (sql_write: 0.00) (sql_cache: 0.00) (active_record: 4.00) (cache_read: 52.00) (total: 143.16) (view: 1.15) (db: 7.57)
[06cfbb7e77325750e2fc1a4a0572d628 54208b97-4a3e-4915-a38f-cab74be316f8] [STAT] 963384 963384 0 0 0.1839010000000001 0.03581099999999998
[06cfbb7e77325750e2fc1a4a0572d628 54208b97-4a3e-4915-a38f-cab74be316f8] request throttling increment: [0.1914689289922119,-50.0,1753325484.87764,["client_identifier","user:10000000000001"],["count",50.0],["last_touched",1753325484.6679]]
[06cfbb7e77325750e2fc1a4a0572d628 54208b97-4a3e-4915-a38f-cab74be316f8] Redis (0.436ms) evalsha - [redis://192.168.0.7:6379/0]
[06cfbb7e77325750e2fc1a4a0572d628 63f4b404-7f2a-4de8-9320-855b88911920] SQL ActiveRecord::SchemaMigration Pluck (1.0ms) SELECT "schema_migrations"."version" FROM "public"."schema_migrations" ORDER BY "schema_migrations"."version" ASC [production:1 primary]
[06cfbb7e77325750e2fc1a4a0572d628 63f4b404-7f2a-4de8-9320-855b88911920] SQL Account Load (1.2ms) SELECT "accounts".* FROM "public"."accounts" WHERE "accounts"."id" = 1 LIMIT 1 [production:1 primary]
[06cfbb7e77325750e2fc1a4a0572d628 63f4b404-7f2a-4de8-9320-855b88911920] SQL FeatureFlag Load (0.6ms) SELECT "feature_flags".* FROM "public"."feature_flags" WHERE "feature_flags"."context_id" = 1 AND "feature_flags"."context_type" = 'Account' [production:1 primary]
[06cfbb7e77325750e2fc1a4a0572d628 63f4b404-7f2a-4de8-9320-855b88911920] SQL Account Load (0.5ms) SELECT "accounts".* FROM "public"."accounts" WHERE "accounts"."id" = 2 LIMIT 1 [production:1 primary]
[06cfbb7e77325750e2fc1a4a0572d628 63f4b404-7f2a-4de8-9320-855b88911920] SQL FeatureFlag Load (0.4ms) SELECT "feature_flags".* FROM "public"."feature_flags" WHERE "feature_flags"."context_id" = 2 AND "feature_flags"."context_type" = 'Account' [production:1 primary]
[06cfbb7e77325750e2fc1a4a0572d628 63f4b404-7f2a-4de8-9320-855b88911920] SQL PluginSetting Load (0.7ms) SELECT "plugin_settings".* FROM "public"."plugin_settings" WHERE "plugin_settings"."name" = 'sessions' ORDER BY "plugin_settings"."id" ASC LIMIT 1 [production:1 primary]
[06cfbb7e77325750e2fc1a4a0572d628 63f4b404-7f2a-4de8-9320-855b88911920] request throttling increment: [0,50.0,1753325485.462976,["client_identifier","user:10000000000001"],["count",0.0],["last_touched",null]]
[06cfbb7e77325750e2fc1a4a0572d628 63f4b404-7f2a-4de8-9320-855b88911920] Redis (0.569ms) evalsha - [redis://192.168.0.7:6379/0]
[06cfbb7e77325750e2fc1a4a0572d628 63f4b404-7f2a-4de8-9320-855b88911920] Processing by CoursesController#activity_stream_summary as JSON
[06cfbb7e77325750e2fc1a4a0572d628 63f4b404-7f2a-4de8-9320-855b88911920] Parameters: {"course_id"=>"14"}
[06cfbb7e77325750e2fc1a4a0572d628 63f4b404-7f2a-4de8-9320-855b88911920] No separate files host specified for account id 1. This is a potential security risk.
[06cfbb7e77325750e2fc1a4a0572d628 63f4b404-7f2a-4de8-9320-855b88911920] SQL SQL (2.8ms) SELECT "pseudonyms"."id" AS t0_r0, "pseudonyms"."user_id" AS t0_r1, "pseudonyms"."account_id" AS t0_r2, "pseudonyms"."workflow_state" AS t0_r3, "pseudonyms"."unique_id" AS t0_r4, "pseudonyms"."crypted_password" AS t0_r5, "pseudonyms"."password_salt" AS t0_r6, "pseudonyms"."persistence_token" AS t0_r7, "pseudonyms"."single_access_token" AS t0_r8, "pseudonyms"."perishable_token" AS t0_r9, "pseudonyms"."login_count" AS t0_r10, "pseudonyms"."failed_login_count" AS t0_r11, "pseudonyms"."last_request_at" AS t0_r12, "pseudonyms"."last_login_at" AS t0_r13, "pseudonyms"."current_login_at" AS t0_r14, "pseudonyms"."last_login_ip" AS t0_r15, "pseudonyms"."current_login_ip" AS t0_r16, "pseudonyms"."reset_password_token" AS t0_r17, "pseudonyms"."position" AS t0_r18, "pseudonyms"."created_at" AS t0_r19, "pseudonyms"."updated_at" AS t0_r20, "pseudonyms"."password_auto_generated" AS t0_r21, "pseudonyms"."deleted_at" AS t0_r22, "pseudonyms"."sis_batch_id" AS t0_r23, "pseudonyms"."sis_user_id" AS t0_r24, "pseudonyms"."sis_ssha" AS t0_r25, "pseudonyms"."communication_channel_id" AS t0_r26, "pseudonyms"."sis_communication_channel_id" AS t0_r27, "pseudonyms"."stuck_sis_fields" AS t0_r28, "pseudonyms"."integration_id" AS t0_r29, "pseudonyms"."authentication_provider_id" AS t0_r30, "pseudonyms"."declared_user_type" AS t0_r31, "users"."id" AS t1_r0, "users"."name" AS t1_r1, "users"."sortable_name" AS t1_r2, "users"."workflow_state" AS t1_r3, "users"."time_zone" AS t1_r4, "users"."uuid" AS t1_r5, "users"."created_at" AS t1_r6, "users"."updated_at" AS t1_r7, "users"."avatar_image_url" AS t1_r8, "users"."avatar_image_source" AS t1_r9, "users"."avatar_image_updated_at" AS t1_r10, "users"."phone" AS t1_r11, "users"."school_name" AS t1_r12, "users"."school_position" AS t1_r13, "users"."short_name" AS t1_r14, "users"."deleted_at" AS t1_r15, "users"."show_user_services" AS t1_r16, "users"."page_views_count" AS t1_r17, "users"."reminder_time_for_due_dates" AS t1_r18, "users"."reminder_time_for_grading" AS t1_r19, "users"."storage_quota" AS t1_r20, "users"."visible_inbox_types" AS t1_r21, "users"."last_user_note" AS t1_r22, "users"."subscribe_to_emails" AS t1_r23, "users"."features_used" AS t1_r24, "users"."preferences" AS t1_r25, "users"."avatar_state" AS t1_r26, "users"."locale" AS t1_r27, "users"."browser_locale" AS t1_r28, "users"."unread_conversations_count" AS t1_r29, "users"."stuck_sis_fields" AS t1_r30, "users"."public" AS t1_r31, "users"."otp_secret_key_enc" AS t1_r32, "users"."otp_secret_key_salt" AS t1_r33, "users"."otp_communication_channel_id" AS t1_r34, "users"."initial_enrollment_type" AS t1_r35, "users"."crocodoc_id" AS t1_r36, "users"."last_logged_out" AS t1_r37, "users"."lti_context_id" AS t1_r38, "users"."turnitin_id" AS t1_r39, "users"."lti_id" AS t1_r40, "users"."pronouns" AS t1_r41, "users"."root_account_ids" AS t1_r42, "users"."merged_into_user_id" AS t1_r43 FROM "public"."pseudonyms" LEFT OUTER JOIN "public"."users" ON "users"."id" = "pseudonyms"."user_id" WHERE "pseudonyms"."id" = 19 LIMIT 1 [production:1 primary]
[06cfbb7e77325750e2fc1a4a0572d628 63f4b404-7f2a-4de8-9320-855b88911920] [AUTH] Approved Authlogic session
[06cfbb7e77325750e2fc1a4a0572d628 63f4b404-7f2a-4de8-9320-855b88911920] [AUTH] inital load: pseud -> 19, user -> 1
[06cfbb7e77325750e2fc1a4a0572d628 63f4b404-7f2a-4de8-9320-855b88911920] [AUTH] final user: 1
[06cfbb7e77325750e2fc1a4a0572d628 63f4b404-7f2a-4de8-9320-855b88911920] SQL Course Load (2.4ms) SELECT "courses".* FROM "public"."courses" WHERE "courses"."workflow_state" != 'deleted' AND "courses"."id" = 14 ORDER BY "courses"."id" ASC LIMIT 1 [production:1 secondary]
[06cfbb7e77325750e2fc1a4a0572d628 63f4b404-7f2a-4de8-9320-855b88911920] SQL Enrollment Load (3.1ms) SELECT "enrollments".* FROM "public"."enrollments" INNER JOIN "public"."enrollment_states" ON "enrollment_states"."enrollment_id" = "enrollments"."id" WHERE "enrollments"."course_id" = 14 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 secondary]
[06cfbb7e77325750e2fc1a4a0572d628 63f4b404-7f2a-4de8-9320-855b88911920] SQL Enrollment Exists (1.8ms) SELECT 1 AS one FROM "public"."enrollments" INNER JOIN "public"."enrollment_states" ON "enrollment_states"."enrollment_id" = "enrollments"."id" WHERE "enrollments"."course_id" = 14 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 primary]
[06cfbb7e77325750e2fc1a4a0572d628 63f4b404-7f2a-4de8-9320-855b88911920] SQL (1.5ms) SELECT COUNT(*) AS count_all, stream_items.asset_type AS stream_items_asset_type, stream_items.notification_category AS stream_items_notification_category, stream_item_instances.workflow_state AS stream_item_instances_workflow_state FROM "public"."stream_item_instances" INNER JOIN "public"."stream_items" ON "stream_items"."id" = "stream_item_instances"."stream_item_id" WHERE "stream_item_instances"."user_id" = 1 AND "stream_item_instances"."hidden" = FALSE AND "stream_item_instances"."context_type" = 'Course' AND "stream_item_instances"."context_id" = 14 GROUP BY "stream_items"."asset_type", "stream_items"."notification_category", "stream_item_instances"."workflow_state" [production:1 secondary]
[06cfbb7e77325750e2fc1a4a0572d628 63f4b404-7f2a-4de8-9320-855b88911920] SQL StreamItemInstance Pluck (0.6ms) SELECT "stream_item_instances"."stream_item_id" FROM "public"."stream_item_instances" WHERE "stream_item_instances"."user_id" = 1 AND "stream_item_instances"."hidden" = FALSE AND "stream_item_instances"."context_type" = 'Course' AND "stream_item_instances"."context_id" = 14 AND (stream_item_id > 10000000000000) ORDER BY stream_item_instances.id desc [production:1 secondary]
[06cfbb7e77325750e2fc1a4a0572d628 63f4b404-7f2a-4de8-9320-855b88911920] SQL Account Load (0.5ms) SELECT "accounts".* FROM "public"."accounts" WHERE "accounts"."id" = 3 LIMIT 1 [production:1 primary]
[06cfbb7e77325750e2fc1a4a0572d628 63f4b404-7f2a-4de8-9320-855b88911920] CACHE SQL Account Load (0.0ms) 1::SELECT "accounts".* FROM "public"."accounts" WHERE "accounts"."id" = 1 LIMIT 1
[06cfbb7e77325750e2fc1a4a0572d628 63f4b404-7f2a-4de8-9320-855b88911920] Completed 200 OK in 398ms (Views: 1.1ms | ActiveRecord: 19.8ms | Allocations: 93744)
[06cfbb7e77325750e2fc1a4a0572d628 63f4b404-7f2a-4de8-9320-855b88911920] [STATSD] (sql_read: 7.00) (sql_write: 0.00) (sql_cache: 0.00) (active_record: 8.00) (cache_read: 32.00) (total: 398.53) (view: 1.08) (db: 19.76)
[06cfbb7e77325750e2fc1a4a0572d628 63f4b404-7f2a-4de8-9320-855b88911920] [STAT] 963484 963484 0 0 0.22296700000000014 0.04042000000000001
[06cfbb7e77325750e2fc1a4a0572d628 63f4b404-7f2a-4de8-9320-855b88911920] request throttling increment: [0.2427231339884998,-50.0,1753325485.90751,["client_identifier","user:10000000000001"],["count",50.0],["last_touched",1753325485.463]]
[06cfbb7e77325750e2fc1a4a0572d628 63f4b404-7f2a-4de8-9320-855b88911920] Redis (0.404ms) evalsha - [redis://192.168.0.7:6379/0]
[06cfbb7e77325750e2fc1a4a0572d628 602ebae5-ca01-444c-aecb-41556a010bc3] SQL ActiveRecord::SchemaMigration Pluck (0.8ms) SELECT "schema_migrations"."version" FROM "public"."schema_migrations" ORDER BY "schema_migrations"."version" ASC [production:1 primary]
[06cfbb7e77325750e2fc1a4a0572d628 602ebae5-ca01-444c-aecb-41556a010bc3] SQL Account Load (1.5ms) SELECT "accounts".* FROM "public"."accounts" WHERE "accounts"."id" = 1 LIMIT 1 [production:1 primary]
[06cfbb7e77325750e2fc1a4a0572d628 602ebae5-ca01-444c-aecb-41556a010bc3] SQL FeatureFlag Load (1.0ms) SELECT "feature_flags".* FROM "public"."feature_flags" WHERE "feature_flags"."context_id" = 1 AND "feature_flags"."context_type" = 'Account' [production:1 primary]
[06cfbb7e77325750e2fc1a4a0572d628 602ebae5-ca01-444c-aecb-41556a010bc3] SQL Account Load (0.8ms) SELECT "accounts".* FROM "public"."accounts" WHERE "accounts"."id" = 2 LIMIT 1 [production:1 primary]
[06cfbb7e77325750e2fc1a4a0572d628 602ebae5-ca01-444c-aecb-41556a010bc3] SQL FeatureFlag Load (0.7ms) SELECT "feature_flags".* FROM "public"."feature_flags" WHERE "feature_flags"."context_id" = 2 AND "feature_flags"."context_type" = 'Account' [production:1 primary]
[06cfbb7e77325750e2fc1a4a0572d628 602ebae5-ca01-444c-aecb-41556a010bc3] SQL PluginSetting Load (1.0ms) SELECT "plugin_settings".* FROM "public"."plugin_settings" WHERE "plugin_settings"."name" = 'sessions' ORDER BY "plugin_settings"."id" ASC LIMIT 1 [production:1 primary]
[06cfbb7e77325750e2fc1a4a0572d628 602ebae5-ca01-444c-aecb-41556a010bc3] request throttling increment: [0,50.0,1753325489.566603,["client_identifier","user:10000000000001"],["count",0.0],["last_touched",null]]
[06cfbb7e77325750e2fc1a4a0572d628 602ebae5-ca01-444c-aecb-41556a010bc3] Redis (0.678ms) evalsha - [redis://192.168.0.7:6379/0]
[06cfbb7e77325750e2fc1a4a0572d628 602ebae5-ca01-444c-aecb-41556a010bc3] Processing by GraphQLController#execute as */*
[06cfbb7e77325750e2fc1a4a0572d628 602ebae5-ca01-444c-aecb-41556a010bc3] Parameters: {"operationName"=>"GetCourseModules", "variables"=>{"courseId"=>"14"}, "query"=>"query GetCourseModules($courseId: ID!) {\n course(id: $courseId) {\n modulesConnection {\n nodes {\n id: _id\n moduleItems {\n content {\n ... on Assignment {\n name\n _id\n peerReviews {\n anonymousReviews\n __typename\n }\n assessmentRequestsForCurrentUser {\n id: _id\n anonymousId\n available\n createdAt\n workflowState\n user {\n id: _id\n name\n __typename\n }\n anonymizedUser {\n id: _id\n name\n __typename\n }\n __typename\n }\n __typename\n }\n __typename\n }\n __typename\n }\n __typename\n }\n __typename\n }\n __typename\n }\n}\n"}
[06cfbb7e77325750e2fc1a4a0572d628 602ebae5-ca01-444c-aecb-41556a010bc3] No separate files host specified for account id 1. This is a potential security risk.
[06cfbb7e77325750e2fc1a4a0572d628 602ebae5-ca01-444c-aecb-41556a010bc3] SQL SQL (3.2ms) SELECT "pseudonyms"."id" AS t0_r0, "pseudonyms"."user_id" AS t0_r1, "pseudonyms"."account_id" AS t0_r2, "pseudonyms"."workflow_state" AS t0_r3, "pseudonyms"."unique_id" AS t0_r4, "pseudonyms"."crypted_password" AS t0_r5, "pseudonyms"."password_salt" AS t0_r6, "pseudonyms"."persistence_token" AS t0_r7, "pseudonyms"."single_access_token" AS t0_r8, "pseudonyms"."perishable_token" AS t0_r9, "pseudonyms"."login_count" AS t0_r10, "pseudonyms"."failed_login_count" AS t0_r11, "pseudonyms"."last_request_at" AS t0_r12, "pseudonyms"."last_login_at" AS t0_r13, "pseudonyms"."current_login_at" AS t0_r14, "pseudonyms"."last_login_ip" AS t0_r15, "pseudonyms"."current_login_ip" AS t0_r16, "pseudonyms"."reset_password_token" AS t0_r17, "pseudonyms"."position" AS t0_r18, "pseudonyms"."created_at" AS t0_r19, "pseudonyms"."updated_at" AS t0_r20, "pseudonyms"."password_auto_generated" AS t0_r21, "pseudonyms"."deleted_at" AS t0_r22, "pseudonyms"."sis_batch_id" AS t0_r23, "pseudonyms"."sis_user_id" AS t0_r24, "pseudonyms"."sis_ssha" AS t0_r25, "pseudonyms"."communication_channel_id" AS t0_r26, "pseudonyms"."sis_communication_channel_id" AS t0_r27, "pseudonyms"."stuck_sis_fields" AS t0_r28, "pseudonyms"."integration_id" AS t0_r29, "pseudonyms"."authentication_provider_id" AS t0_r30, "pseudonyms"."declared_user_type" AS t0_r31, "users"."id" AS t1_r0, "users"."name" AS t1_r1, "users"."sortable_name" AS t1_r2, "users"."workflow_state" AS t1_r3, "users"."time_zone" AS t1_r4, "users"."uuid" AS t1_r5, "users"."created_at" AS t1_r6, "users"."updated_at" AS t1_r7, "users"."avatar_image_url" AS t1_r8, "users"."avatar_image_source" AS t1_r9, "users"."avatar_image_updated_at" AS t1_r10, "users"."phone" AS t1_r11, "users"."school_name" AS t1_r12, "users"."school_position" AS t1_r13, "users"."short_name" AS t1_r14, "users"."deleted_at" AS t1_r15, "users"."show_user_services" AS t1_r16, "users"."page_views_count" AS t1_r17, "users"."reminder_time_for_due_dates" AS t1_r18, "users"."reminder_time_for_grading" AS t1_r19, "users"."storage_quota" AS t1_r20, "users"."visible_inbox_types" AS t1_r21, "users"."last_user_note" AS t1_r22, "users"."subscribe_to_emails" AS t1_r23, "users"."features_used" AS t1_r24, "users"."preferences" AS t1_r25, "users"."avatar_state" AS t1_r26, "users"."locale" AS t1_r27, "users"."browser_locale" AS t1_r28, "users"."unread_conversations_count" AS t1_r29, "users"."stuck_sis_fields" AS t1_r30, "users"."public" AS t1_r31, "users"."otp_secret_key_enc" AS t1_r32, "users"."otp_secret_key_salt" AS t1_r33, "users"."otp_communication_channel_id" AS t1_r34, "users"."initial_enrollment_type" AS t1_r35, "users"."crocodoc_id" AS t1_r36, "users"."last_logged_out" AS t1_r37, "users"."lti_context_id" AS t1_r38, "users"."turnitin_id" AS t1_r39, "users"."lti_id" AS t1_r40, "users"."pronouns" AS t1_r41, "users"."root_account_ids" AS t1_r42, "users"."merged_into_user_id" AS t1_r43 FROM "public"."pseudonyms" LEFT OUTER JOIN "public"."users" ON "users"."id" = "pseudonyms"."user_id" WHERE "pseudonyms"."id" = 19 LIMIT 1 [production:1 primary]
[06cfbb7e77325750e2fc1a4a0572d628 602ebae5-ca01-444c-aecb-41556a010bc3] [AUTH] Approved Authlogic session
[06cfbb7e77325750e2fc1a4a0572d628 602ebae5-ca01-444c-aecb-41556a010bc3] [AUTH] inital load: pseud -> 19, user -> 1
[06cfbb7e77325750e2fc1a4a0572d628 602ebae5-ca01-444c-aecb-41556a010bc3] [AUTH] final user: 1
[06cfbb7e77325750e2fc1a4a0572d628 602ebae5-ca01-444c-aecb-41556a010bc3] SQL TRANSACTION (0.8ms) BEGIN [production:1 primary]
[06cfbb7e77325750e2fc1a4a0572d628 602ebae5-ca01-444c-aecb-41556a010bc3] SQL (0.3ms) SET statement_timeout = 60000 [production:1 primary]
[06cfbb7e77325750e2fc1a4a0572d628 602ebae5-ca01-444c-aecb-41556a010bc3] SQL Course Load (1.7ms) SELECT "courses".* FROM "public"."courses" WHERE "courses"."id" = 14 [production:1 primary]
[06cfbb7e77325750e2fc1a4a0572d628 602ebae5-ca01-444c-aecb-41556a010bc3] SQL Enrollment Exists (2.1ms) SELECT 1 AS one FROM "public"."enrollments" INNER JOIN "public"."enrollment_states" ON "enrollment_states"."enrollment_id" = "enrollments"."id" WHERE "enrollments"."course_id" = 14 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 primary]
[06cfbb7e77325750e2fc1a4a0572d628 602ebae5-ca01-444c-aecb-41556a010bc3] SQL ContextModule Load (1.1ms) SELECT "context_modules".* FROM "public"."context_modules" WHERE "context_modules"."context_id" = 14 AND "context_modules"."context_type" = 'Course' AND (context_modules.workflow_state<>'deleted') ORDER BY "context_modules"."position" ASC, "context_modules"."id" ASC, name [production:1 primary]
[06cfbb7e77325750e2fc1a4a0572d628 602ebae5-ca01-444c-aecb-41556a010bc3] SQL Enrollment Load (1.3ms) SELECT enrollments.*, enrollment_states.state AS date_based_state_in_db FROM "public"."enrollments" INNER JOIN "public"."enrollment_states" ON "enrollment_states"."enrollment_id" = "enrollments"."id" WHERE "enrollments"."course_id" = 14 AND (enrollments.workflow_state<>'deleted') AND "enrollments"."user_id" = 1 AND "enrollment_states"."restricted_access" = FALSE AND (enrollment_states.state IN ('active', 'invited', 'pending_invited', 'pending_active')) AND "enrollments"."type" IN ('TeacherEnrollment', 'TaEnrollment', 'DesignerEnrollment', 'StudentViewEnrollment') [production:1 primary]
[06cfbb7e77325750e2fc1a4a0572d628 602ebae5-ca01-444c-aecb-41556a010bc3] SQL Role Load (1.7ms) SELECT "roles".* FROM "public"."roles" WHERE "roles"."id" = 12 LIMIT 1 [production:1 secondary]
[06cfbb7e77325750e2fc1a4a0572d628 602ebae5-ca01-444c-aecb-41556a010bc3] SQL Account Load (7.5ms) WITH RECURSIVE t AS ( SELECT * FROM "public"."accounts" WHERE id=3 UNION SELECT accounts.* FROM "public"."accounts" INNER JOIN t ON accounts.id=t.parent_account_id ) SELECT * FROM t [production:1 secondary]
[06cfbb7e77325750e2fc1a4a0572d628 602ebae5-ca01-444c-aecb-41556a010bc3] SQL Role Load (1.0ms) SELECT "roles".* FROM "public"."roles" WHERE "roles"."workflow_state" = 'built_in' AND "roles"."root_account_id" = 1 AND "roles"."base_role_type" = 'TeacherEnrollment' [production:1 secondary]
[06cfbb7e77325750e2fc1a4a0572d628 602ebae5-ca01-444c-aecb-41556a010bc3] SQL RoleOverride Load (2.0ms) COPY (SELECT "role_overrides".* FROM "public"."role_overrides" WHERE "role_overrides"."role_id" IN (12, 12) AND "role_overrides"."context_id" IN (3, 1)) TO STDOUT [production:1 secondary]
[06cfbb7e77325750e2fc1a4a0572d628 602ebae5-ca01-444c-aecb-41556a010bc3] SQL ContentTag Load (1.8ms) SELECT "content_tags".* FROM "public"."content_tags" WHERE "content_tags"."context_module_id" = 47 AND (content_tags.workflow_state<>'deleted') ORDER BY content_tags.position, content_tags.title [production:1 secondary]
[06cfbb7e77325750e2fc1a4a0572d628 602ebae5-ca01-444c-aecb-41556a010bc3] SQL WikiPage Load (1.4ms) SELECT "wiki_pages".* FROM "public"."wiki_pages" WHERE "wiki_pages"."id" = 717 [production:1 primary]
[06cfbb7e77325750e2fc1a4a0572d628 602ebae5-ca01-444c-aecb-41556a010bc3] SQL TRANSACTION (0.7ms) COMMIT [production:1 primary]
[06cfbb7e77325750e2fc1a4a0572d628 602ebae5-ca01-444c-aecb-41556a010bc3] Completed 200 OK in 540ms (Views: 1.2ms | ActiveRecord: 37.2ms | Allocations: 142363)
[06cfbb7e77325750e2fc1a4a0572d628 602ebae5-ca01-444c-aecb-41556a010bc3] [STATSD] (sql_read: 10.00) (sql_write: 3.00) (sql_cache: 0.00) (active_record: 12.00) (cache_read: 69.00) (total: 540.32) (view: 1.24) (db: 37.23)
[06cfbb7e77325750e2fc1a4a0572d628 602ebae5-ca01-444c-aecb-41556a010bc3] [STAT] 963584 1031172 67588 0 0.32711899999999994 0.09374699999999997
[06cfbb7e77325750e2fc1a4a0572d628 602ebae5-ca01-444c-aecb-41556a010bc3] request throttling increment: [0.3643528789999484,-50.0,1753325490.156284,["client_identifier","user:10000000000001"],["count",50.0],["last_touched",1753325489.5666]]
[06cfbb7e77325750e2fc1a4a0572d628 602ebae5-ca01-444c-aecb-41556a010bc3] Redis (0.379ms) evalsha - [redis://192.168.0.7:6379/0]
[- -] Shutting down background worker
[- -] Killing session flusher
[- -] Shutting down background worker
[- -] Killing session flusher
[- -] Shutting down background worker
[- -] Killing session flusher
[- -] Shutting down background worker
[- -] Killing session flusher
[- -] Shutting down background worker
[- -] Killing session flusher
Kindly anyone help me to debug and resolve this issue. Thanks in advance.
This is my browser console's output,
jquery.ajaxJSON.js:119 POST https://mydomain.in/api/v1/courses/14/pages 500 (Internal Server Error)
I have also attached the browser console output
This is my /var/canvas/log/production.log
sudo tail -300f production.log
sudo tail -300f production.log
[- -] Reading app-canvas/data/secrets from vault
[- -] (0.3ms) SELECT * FROM unnest(current_schemas(false))
[- -] Switchman::Shard Load (0.9ms) SELECT "switchman_shards".* FROM "public"."switchman_shards" WHERE "switchman_shards"."default" = TRUE LIMIT 1
[- -] SQL (0.7ms) SELECT * FROM unnest(current_schemas(false)) [production:1 primary]
[- -] SQL Setting Pluck (0.5ms) SELECT "settings"."name", "settings"."value" FROM "public"."settings" [production:1 primary]
[- -] Initializing the background worker with 8 threads
[- -] SQL Switchman::Shard Exists (1.3ms) SELECT 1 AS one FROM "public"."switchman_shards" WHERE "switchman_shards"."id" IN (SELECT DISTINCT "switchman_shards"."delayed_jobs_shard_id" FROM "public"."switchman_shards" WHERE "switchman_shards"."delayed_jobs_shard_id" IS NOT NULL) LIMIT 1 [production:1 primary]
[- -] SQL Switchman::Shard Load (0.4ms) SELECT "switchman_shards".* FROM "public"."switchman_shards" WHERE "switchman_shards"."id" = 1 [production:1 primary]
[06cfbb7e77325750e2fc1a4a0572d628 800abef5-58bf-4c05-b104-9f19f294e737] Started GET "/dashboard-sidebar" for 2401:4900:8825:e3b1:d871:40c8:b602:a33c at 2025-07-24 08:21:16 +0530
[06cfbb7e77325750e2fc1a4a0572d628 54208b97-4a3e-4915-a38f-cab74be316f8] Started GET "/api/v1/users/self/content_shares/unread_count" for 2401:4900:8825:e3b1:d871:40c8:b602:a33c at 2025-07-24 08:21:18 +0530
[06cfbb7e77325750e2fc1a4a0572d628 63f4b404-7f2a-4de8-9320-855b88911920] Started GET "/api/v1/courses/14/activity_stream/summary" for 2401:4900:8825:e3b1:d871:40c8:b602:a33c at 2025-07-24 08:21:19 +0530
[06cfbb7e77325750e2fc1a4a0572d628 800abef5-58bf-4c05-b104-9f19f294e737] SQL ActiveRecord::SchemaMigration Pluck (0.8ms) SELECT "schema_migrations"."version" FROM "public"."schema_migrations" ORDER BY "schema_migrations"."version" ASC [production:1 primary]
[06cfbb7e77325750e2fc1a4a0572d628 800abef5-58bf-4c05-b104-9f19f294e737] SQL Account Load (1.3ms) SELECT "accounts".* FROM "public"."accounts" WHERE "accounts"."id" = 1 LIMIT 1 [production:1 primary]
[06cfbb7e77325750e2fc1a4a0572d628 800abef5-58bf-4c05-b104-9f19f294e737] SQL FeatureFlag Load (0.7ms) SELECT "feature_flags".* FROM "public"."feature_flags" WHERE "feature_flags"."context_id" = 1 AND "feature_flags"."context_type" = 'Account' [production:1 primary]
[06cfbb7e77325750e2fc1a4a0572d628 800abef5-58bf-4c05-b104-9f19f294e737] SQL Account Load (0.6ms) SELECT "accounts".* FROM "public"."accounts" WHERE "accounts"."id" = 2 LIMIT 1 [production:1 primary]
[06cfbb7e77325750e2fc1a4a0572d628 800abef5-58bf-4c05-b104-9f19f294e737] SQL FeatureFlag Load (0.4ms) SELECT "feature_flags".* FROM "public"."feature_flags" WHERE "feature_flags"."context_id" = 2 AND "feature_flags"."context_type" = 'Account' [production:1 primary]
[06cfbb7e77325750e2fc1a4a0572d628 800abef5-58bf-4c05-b104-9f19f294e737] SQL PluginSetting Load (0.7ms) SELECT "plugin_settings".* FROM "public"."plugin_settings" WHERE "plugin_settings"."name" = 'sessions' ORDER BY "plugin_settings"."id" ASC LIMIT 1 [production:1 primary]
[06cfbb7e77325750e2fc1a4a0572d628 800abef5-58bf-4c05-b104-9f19f294e737] request throttling increment: [0,50.0,1753325483.221251,["client_identifier","user:10000000000001"],["count",0.0],["last_touched",null]]
[06cfbb7e77325750e2fc1a4a0572d628 800abef5-58bf-4c05-b104-9f19f294e737] Redis (0.655ms) evalsha - [redis://192.168.0.7:6379/0]
[06cfbb7e77325750e2fc1a4a0572d628 800abef5-58bf-4c05-b104-9f19f294e737] Processing by UsersController#dashboard_sidebar as JSON
[06cfbb7e77325750e2fc1a4a0572d628 800abef5-58bf-4c05-b104-9f19f294e737] No separate files host specified for account id 1. This is a potential security risk.
[06cfbb7e77325750e2fc1a4a0572d628 800abef5-58bf-4c05-b104-9f19f294e737] SQL SQL (3.1ms) SELECT "pseudonyms"."id" AS t0_r0, "pseudonyms"."user_id" AS t0_r1, "pseudonyms"."account_id" AS t0_r2, "pseudonyms"."workflow_state" AS t0_r3, "pseudonyms"."unique_id" AS t0_r4, "pseudonyms"."crypted_password" AS t0_r5, "pseudonyms"."password_salt" AS t0_r6, "pseudonyms"."persistence_token" AS t0_r7, "pseudonyms"."single_access_token" AS t0_r8, "pseudonyms"."perishable_token" AS t0_r9, "pseudonyms"."login_count" AS t0_r10, "pseudonyms"."failed_login_count" AS t0_r11, "pseudonyms"."last_request_at" AS t0_r12, "pseudonyms"."last_login_at" AS t0_r13, "pseudonyms"."current_login_at" AS t0_r14, "pseudonyms"."last_login_ip" AS t0_r15, "pseudonyms"."current_login_ip" AS t0_r16, "pseudonyms"."reset_password_token" AS t0_r17, "pseudonyms"."position" AS t0_r18, "pseudonyms"."created_at" AS t0_r19, "pseudonyms"."updated_at" AS t0_r20, "pseudonyms"."password_auto_generated" AS t0_r21, "pseudonyms"."deleted_at" AS t0_r22, "pseudonyms"."sis_batch_id" AS t0_r23, "pseudonyms"."sis_user_id" AS t0_r24, "pseudonyms"."sis_ssha" AS t0_r25, "pseudonyms"."communication_channel_id" AS t0_r26, "pseudonyms"."sis_communication_channel_id" AS t0_r27, "pseudonyms"."stuck_sis_fields" AS t0_r28, "pseudonyms"."integration_id" AS t0_r29, "pseudonyms"."authentication_provider_id" AS t0_r30, "pseudonyms"."declared_user_type" AS t0_r31, "users"."id" AS t1_r0, "users"."name" AS t1_r1, "users"."sortable_name" AS t1_r2, "users"."workflow_state" AS t1_r3, "users"."time_zone" AS t1_r4, "users"."uuid" AS t1_r5, "users"."created_at" AS t1_r6, "users"."updated_at" AS t1_r7, "users"."avatar_image_url" AS t1_r8, "users"."avatar_image_source" AS t1_r9, "users"."avatar_image_updated_at" AS t1_r10, "users"."phone" AS t1_r11, "users"."school_name" AS t1_r12, "users"."school_position" AS t1_r13, "users"."short_name" AS t1_r14, "users"."deleted_at" AS t1_r15, "users"."show_user_services" AS t1_r16, "users"."page_views_count" AS t1_r17, "users"."reminder_time_for_due_dates" AS t1_r18, "users"."reminder_time_for_grading" AS t1_r19, "users"."storage_quota" AS t1_r20, "users"."visible_inbox_types" AS t1_r21, "users"."last_user_note" AS t1_r22, "users"."subscribe_to_emails" AS t1_r23, "users"."features_used" AS t1_r24, "users"."preferences" AS t1_r25, "users"."avatar_state" AS t1_r26, "users"."locale" AS t1_r27, "users"."browser_locale" AS t1_r28, "users"."unread_conversations_count" AS t1_r29, "users"."stuck_sis_fields" AS t1_r30, "users"."public" AS t1_r31, "users"."otp_secret_key_enc" AS t1_r32, "users"."otp_secret_key_salt" AS t1_r33, "users"."otp_communication_channel_id" AS t1_r34, "users"."initial_enrollment_type" AS t1_r35, "users"."crocodoc_id" AS t1_r36, "users"."last_logged_out" AS t1_r37, "users"."lti_context_id" AS t1_r38, "users"."turnitin_id" AS t1_r39, "users"."lti_id" AS t1_r40, "users"."pronouns" AS t1_r41, "users"."root_account_ids" AS t1_r42, "users"."merged_into_user_id" AS t1_r43 FROM "public"."pseudonyms" LEFT OUTER JOIN "public"."users" ON "users"."id" = "pseudonyms"."user_id" WHERE "pseudonyms"."id" = 19 LIMIT 1 [production:1 primary]
[06cfbb7e77325750e2fc1a4a0572d628 800abef5-58bf-4c05-b104-9f19f294e737] [AUTH] Approved Authlogic session
[06cfbb7e77325750e2fc1a4a0572d628 800abef5-58bf-4c05-b104-9f19f294e737] [AUTH] inital load: pseud -> 19, user -> 1
[06cfbb7e77325750e2fc1a4a0572d628 800abef5-58bf-4c05-b104-9f19f294e737] [AUTH] final user: 1
[06cfbb7e77325750e2fc1a4a0572d628 800abef5-58bf-4c05-b104-9f19f294e737] SQL Enrollment Exists (2.2ms) SELECT 1 AS one FROM "public"."enrollments" WHERE "enrollments"."user_id" = 1 AND "enrollments"."type" IN ('StudentEnrollment', 'StudentViewEnrollment') AND "enrollments"."workflow_state" NOT IN ('rejected', 'inactive', 'deleted') LIMIT 1 [production:1 secondary]
[06cfbb7e77325750e2fc1a4a0572d628 800abef5-58bf-4c05-b104-9f19f294e737] SQL Enrollment Exists (0.5ms) SELECT 1 AS one FROM "public"."enrollments" WHERE "enrollments"."user_id" = 1 AND "enrollments"."type" NOT IN ('StudentEnrollment', 'StudentViewEnrollment', 'ObserverEnrollment') AND "enrollments"."workflow_state" NOT IN ('rejected', 'inactive', 'deleted') LIMIT 1 [production:1 secondary]
[06cfbb7e77325750e2fc1a4a0572d628 800abef5-58bf-4c05-b104-9f19f294e737] SQL Group Pluck (1.9ms) SELECT "groups"."id" FROM "public"."groups" INNER JOIN "public"."group_memberships" ON "groups"."id" = "group_memberships"."group_id" WHERE "group_memberships"."user_id" = 1 AND (group_memberships.workflow_state<>'deleted') AND (groups.workflow_state<>'deleted') [production:1 secondary]
[06cfbb7e77325750e2fc1a4a0572d628 800abef5-58bf-4c05-b104-9f19f294e737] SQL Enrollment Pluck (5.2ms) SELECT DISTINCT "enrollments"."course_id" FROM "public"."enrollments" INNER JOIN "public"."courses" ON "courses"."id" = "enrollments"."course_id" INNER JOIN "public"."enrollment_states" ON "enrollment_states"."enrollment_id" = "enrollments"."id" WHERE "enrollments"."user_id" = 1 AND (enrollments.workflow_state='active' AND (courses.workflow_state='available' OR courses.workflow_state IN ('created', 'claimed') AND enrollments.type IN ('TeacherEnrollment','TaEnrollment','DesignerEnrollment','StudentViewEnrollment'))) AND (enrollment_states.state = 'active') [production:1 secondary]
[06cfbb7e77325750e2fc1a4a0572d628 800abef5-58bf-4c05-b104-9f19f294e737] SQL Course Load (1.3ms) SELECT "courses".* FROM "public"."courses" WHERE "courses"."id" IN (2, 3, 4, 5, 10, 11, 12, 13, 14, 16, 18, 19, 20, 21, 22, 27, 28, 29, 30, 31, 32, 33, 34) [production:1 secondary]
[06cfbb7e77325750e2fc1a4a0572d628 800abef5-58bf-4c05-b104-9f19f294e737] SQL Enrollment Pluck (2.1ms) SELECT "enrollments"."course_section_id", "enrollments"."limit_privileges_to_course_section", "enrollments"."type", "enrollments"."associated_user_id", "enrollments"."workflow_state" FROM "public"."enrollments" WHERE "enrollments"."course_id" = 3 AND "enrollments"."user_id" = 1 AND "enrollments"."workflow_state" != 'deleted' [production:1 primary]
[06cfbb7e77325750e2fc1a4a0572d628 800abef5-58bf-4c05-b104-9f19f294e737] SQL Enrollment Load (1.5ms) SELECT enrollments.*, enrollment_states.state AS date_based_state_in_db FROM "public"."enrollments" INNER JOIN "public"."enrollment_states" ON "enrollment_states"."enrollment_id" = "enrollments"."id" WHERE "enrollments"."course_id" = 3 AND (enrollments.workflow_state<>'deleted') AND "enrollments"."user_id" = 1 AND "enrollment_states"."restricted_access" = FALSE AND (enrollment_states.state IN ('active', 'invited', 'pending_invited', 'pending_active')) [production:1 primary]
[06cfbb7e77325750e2fc1a4a0572d628 602ebae5-ca01-444c-aecb-41556a010bc3] Started POST "/api/graphql" for 2401:4900:8825:e3b1:d871:40c8:b602:a33c at 2025-07-24 08:21:23 +0530
[06cfbb7e77325750e2fc1a4a0572d628 800abef5-58bf-4c05-b104-9f19f294e737] SQL Role Load (0.8ms) SELECT "roles".* FROM "public"."roles" WHERE "roles"."id" = 12 LIMIT 1 [production:1 secondary]
[06cfbb7e77325750e2fc1a4a0572d628 800abef5-58bf-4c05-b104-9f19f294e737] SQL Account Load (3.0ms) WITH RECURSIVE t AS ( SELECT * FROM "public"."accounts" WHERE id=3 UNION SELECT accounts.* FROM "public"."accounts" INNER JOIN t ON accounts.id=t.parent_account_id ) SELECT * FROM t [production:1 secondary]
[06cfbb7e77325750e2fc1a4a0572d628 800abef5-58bf-4c05-b104-9f19f294e737] SQL Role Load (0.5ms) SELECT "roles".* FROM "public"."roles" WHERE "roles"."workflow_state" = 'built_in' AND "roles"."root_account_id" = 1 AND "roles"."base_role_type" = 'TeacherEnrollment' [production:1 secondary]
[06cfbb7e77325750e2fc1a4a0572d628 800abef5-58bf-4c05-b104-9f19f294e737] SQL RoleOverride Load (2.1ms) COPY (SELECT "role_overrides".* FROM "public"."role_overrides" WHERE "role_overrides"."role_id" IN (12, 12) AND "role_overrides"."context_id" IN (3, 1)) TO STDOUT [production:1 secondary]
[06cfbb7e77325750e2fc1a4a0572d628 800abef5-58bf-4c05-b104-9f19f294e737] SQL Enrollment Pluck (0.8ms) SELECT "enrollments"."course_section_id", "enrollments"."limit_privileges_to_course_section", "enrollments"."type", "enrollments"."associated_user_id", "enrollments"."workflow_state" FROM "public"."enrollments" WHERE "enrollments"."course_id" = 2 AND "enrollments"."user_id" = 1 AND "enrollments"."workflow_state" != 'deleted' [production:1 primary]
[06cfbb7e77325750e2fc1a4a0572d628 800abef5-58bf-4c05-b104-9f19f294e737] SQL Enrollment Load (1.1ms) SELECT enrollments.*, enrollment_states.state AS date_based_state_in_db FROM "public"."enrollments" INNER JOIN "public"."enrollment_states" ON "enrollment_states"."enrollment_id" = "enrollments"."id" WHERE "enrollments"."course_id" = 2 AND (enrollments.workflow_state<>'deleted') AND "enrollments"."user_id" = 1 AND "enrollment_states"."restricted_access" = FALSE AND (enrollment_states.state IN ('active', 'invited', 'pending_invited', 'pending_active')) [production:1 primary]
[06cfbb7e77325750e2fc1a4a0572d628 800abef5-58bf-4c05-b104-9f19f294e737] SQL Enrollment Pluck (0.7ms) SELECT "enrollments"."course_section_id", "enrollments"."limit_privileges_to_course_section", "enrollments"."type", "enrollments"."associated_user_id", "enrollments"."workflow_state" FROM "public"."enrollments" WHERE "enrollments"."course_id" = 4 AND "enrollments"."user_id" = 1 AND "enrollments"."workflow_state" != 'deleted' [production:1 primary]
[06cfbb7e77325750e2fc1a4a0572d628 800abef5-58bf-4c05-b104-9f19f294e737] SQL Enrollment Load (1.1ms) SELECT enrollments.*, enrollment_states.state AS date_based_state_in_db FROM "public"."enrollments" INNER JOIN "public"."enrollment_states" ON "enrollment_states"."enrollment_id" = "enrollments"."id" WHERE "enrollments"."course_id" = 4 AND (enrollments.workflow_state<>'deleted') AND "enrollments"."user_id" = 1 AND "enrollment_states"."restricted_access" = FALSE AND (enrollment_states.state IN ('active', 'invited', 'pending_invited', 'pending_active')) [production:1 primary]
[06cfbb7e77325750e2fc1a4a0572d628 800abef5-58bf-4c05-b104-9f19f294e737] SQL Enrollment Pluck (0.6ms) SELECT "enrollments"."course_section_id", "enrollments"."limit_privileges_to_course_section", "enrollments"."type", "enrollments"."associated_user_id", "enrollments"."workflow_state" FROM "public"."enrollments" WHERE "enrollments"."course_id" = 31 AND "enrollments"."user_id" = 1 AND "enrollments"."workflow_state" != 'deleted' [production:1 primary]
[06cfbb7e77325750e2fc1a4a0572d628 800abef5-58bf-4c05-b104-9f19f294e737] SQL Enrollment Load (1.0ms) SELECT enrollments.*, enrollment_states.state AS date_based_state_in_db FROM "public"."enrollments" INNER JOIN "public"."enrollment_states" ON "enrollment_states"."enrollment_id" = "enrollments"."id" WHERE "enrollments"."course_id" = 31 AND (enrollments.workflow_state<>'deleted') AND "enrollments"."user_id" = 1 AND "enrollment_states"."restricted_access" = FALSE AND (enrollment_states.state IN ('active', 'invited', 'pending_invited', 'pending_active')) AND "enrollments"."type" IN ('TeacherEnrollment', 'TaEnrollment', 'DesignerEnrollment', 'StudentViewEnrollment') [production:1 primary]
[06cfbb7e77325750e2fc1a4a0572d628 800abef5-58bf-4c05-b104-9f19f294e737] SQL Enrollment Pluck (0.7ms) SELECT "enrollments"."course_section_id", "enrollments"."limit_privileges_to_course_section", "enrollments"."type", "enrollments"."associated_user_id", "enrollments"."workflow_state" FROM "public"."enrollments" WHERE "enrollments"."course_id" = 5 AND "enrollments"."user_id" = 1 AND "enrollments"."workflow_state" != 'deleted' [production:1 primary]
[06cfbb7e77325750e2fc1a4a0572d628 800abef5-58bf-4c05-b104-9f19f294e737] SQL Enrollment Load (0.8ms) SELECT enrollments.*, enrollment_states.state AS date_based_state_in_db FROM "public"."enrollments" INNER JOIN "public"."enrollment_states" ON "enrollment_states"."enrollment_id" = "enrollments"."id" WHERE "enrollments"."course_id" = 5 AND (enrollments.workflow_state<>'deleted') AND "enrollments"."user_id" = 1 AND "enrollment_states"."restricted_access" = FALSE AND (enrollment_states.state IN ('active', 'invited', 'pending_invited', 'pending_active')) [production:1 primary]
[06cfbb7e77325750e2fc1a4a0572d628 800abef5-58bf-4c05-b104-9f19f294e737] SQL Enrollment Pluck (0.8ms) SELECT "enrollments"."course_section_id", "enrollments"."limit_privileges_to_course_section", "enrollments"."type", "enrollments"."associated_user_id", "enrollments"."workflow_state" FROM "public"."enrollments" WHERE "enrollments"."course_id" = 10 AND "enrollments"."user_id" = 1 AND "enrollments"."workflow_state" != 'deleted' [production:1 primary]
[06cfbb7e77325750e2fc1a4a0572d628 800abef5-58bf-4c05-b104-9f19f294e737] SQL Enrollment Load (0.9ms) SELECT enrollments.*, enrollment_states.state AS date_based_state_in_db FROM "public"."enrollments" INNER JOIN "public"."enrollment_states" ON "enrollment_states"."enrollment_id" = "enrollments"."id" WHERE "enrollments"."course_id" = 10 AND (enrollments.workflow_state<>'deleted') AND "enrollments"."user_id" = 1 AND "enrollment_states"."restricted_access" = FALSE AND (enrollment_states.state IN ('active', 'invited', 'pending_invited', 'pending_active')) [production:1 primary]
[06cfbb7e77325750e2fc1a4a0572d628 800abef5-58bf-4c05-b104-9f19f294e737] SQL Role Load (0.5ms) SELECT "roles".* FROM "public"."roles" WHERE "roles"."id" = 11 LIMIT 1 [production:1 secondary]
[06cfbb7e77325750e2fc1a4a0572d628 800abef5-58bf-4c05-b104-9f19f294e737] CACHE SQL Account Load (0.0ms) 1::WITH RECURSIVE t AS ( SELECT * FROM "public"."accounts" WHERE id=3 UNION SELECT accounts.* FROM "public"."accounts" INNER JOIN t ON accounts.id=t.parent_account_id ) SELECT * FROM t
[06cfbb7e77325750e2fc1a4a0572d628 800abef5-58bf-4c05-b104-9f19f294e737] SQL Role Load (0.6ms) SELECT "roles".* FROM "public"."roles" WHERE "roles"."workflow_state" = 'built_in' AND "roles"."root_account_id" = 1 AND "roles"."base_role_type" = 'StudentEnrollment' [production:1 secondary]
[06cfbb7e77325750e2fc1a4a0572d628 800abef5-58bf-4c05-b104-9f19f294e737] SQL RoleOverride Load (1.3ms) COPY (SELECT "role_overrides".* FROM "public"."role_overrides" WHERE "role_overrides"."role_id" IN (11, 11) AND "role_overrides"."context_id" IN (3, 1)) TO STDOUT [production:1 secondary]
[06cfbb7e77325750e2fc1a4a0572d628 800abef5-58bf-4c05-b104-9f19f294e737] SQL Enrollment Pluck (0.7ms) SELECT "enrollments"."course_section_id", "enrollments"."limit_privileges_to_course_section", "enrollments"."type", "enrollments"."associated_user_id", "enrollments"."workflow_state" FROM "public"."enrollments" WHERE "enrollments"."course_id" = 11 AND "enrollments"."user_id" = 1 AND "enrollments"."workflow_state" != 'deleted' [production:1 primary]
[06cfbb7e77325750e2fc1a4a0572d628 800abef5-58bf-4c05-b104-9f19f294e737] SQL Enrollment Load (0.9ms) SELECT enrollments.*, enrollment_states.state AS date_based_state_in_db FROM "public"."enrollments" INNER JOIN "public"."enrollment_states" ON "enrollment_states"."enrollment_id" = "enrollments"."id" WHERE "enrollments"."course_id" = 11 AND (enrollments.workflow_state<>'deleted') AND "enrollments"."user_id" = 1 AND "enrollment_states"."restricted_access" = FALSE AND (enrollment_states.state IN ('active', 'invited', 'pending_invited', 'pending_active')) AND "enrollments"."type" IN ('TeacherEnrollment', 'TaEnrollment', 'DesignerEnrollment', 'StudentViewEnrollment') [production:1 primary]
[06cfbb7e77325750e2fc1a4a0572d628 800abef5-58bf-4c05-b104-9f19f294e737] SQL Enrollment Pluck (0.6ms) SELECT "enrollments"."course_section_id", "enrollments"."limit_privileges_to_course_section", "enrollments"."type", "enrollments"."associated_user_id", "enrollments"."workflow_state" FROM "public"."enrollments" WHERE "enrollments"."course_id" = 12 AND "enrollments"."user_id" = 1 AND "enrollments"."workflow_state" != 'deleted' [production:1 primary]
[06cfbb7e77325750e2fc1a4a0572d628 800abef5-58bf-4c05-b104-9f19f294e737] SQL Enrollment Load (1.2ms) SELECT enrollments.*, enrollment_states.state AS date_based_state_in_db FROM "public"."enrollments" INNER JOIN "public"."enrollment_states" ON "enrollment_states"."enrollment_id" = "enrollments"."id" WHERE "enrollments"."course_id" = 12 AND (enrollments.workflow_state<>'deleted') AND "enrollments"."user_id" = 1 AND "enrollment_states"."restricted_access" = FALSE AND (enrollment_states.state IN ('active', 'invited', 'pending_invited', 'pending_active')) [production:1 primary]
[06cfbb7e77325750e2fc1a4a0572d628 800abef5-58bf-4c05-b104-9f19f294e737] SQL Enrollment Pluck (0.7ms) SELECT "enrollments"."course_section_id", "enrollments"."limit_privileges_to_course_section", "enrollments"."type", "enrollments"."associated_user_id", "enrollments"."workflow_state" FROM "public"."enrollments" WHERE "enrollments"."course_id" = 32 AND "enrollments"."user_id" = 1 AND "enrollments"."workflow_state" != 'deleted' [production:1 primary]
[06cfbb7e77325750e2fc1a4a0572d628 800abef5-58bf-4c05-b104-9f19f294e737] SQL Enrollment Load (1.2ms) SELECT enrollments.*, enrollment_states.state AS date_based_state_in_db FROM "public"."enrollments" INNER JOIN "public"."enrollment_states" ON "enrollment_states"."enrollment_id" = "enrollments"."id" WHERE "enrollments"."course_id" = 32 AND (enrollments.workflow_state<>'deleted') AND "enrollments"."user_id" = 1 AND "enrollment_states"."restricted_access" = FALSE AND (enrollment_states.state IN ('active', 'invited', 'pending_invited', 'pending_active')) [production:1 primary]
[06cfbb7e77325750e2fc1a4a0572d628 800abef5-58bf-4c05-b104-9f19f294e737] SQL Enrollment Pluck (0.8ms) SELECT "enrollments"."course_section_id", "enrollments"."limit_privileges_to_course_section", "enrollments"."type", "enrollments"."associated_user_id", "enrollments"."workflow_state" FROM "public"."enrollments" WHERE "enrollments"."course_id" = 16 AND "enrollments"."user_id" = 1 AND "enrollments"."workflow_state" != 'deleted' [production:1 primary]
[06cfbb7e77325750e2fc1a4a0572d628 800abef5-58bf-4c05-b104-9f19f294e737] SQL Enrollment Load (1.1ms) SELECT enrollments.*, enrollment_states.state AS date_based_state_in_db FROM "public"."enrollments" INNER JOIN "public"."enrollment_states" ON "enrollment_states"."enrollment_id" = "enrollments"."id" WHERE "enrollments"."course_id" = 16 AND (enrollments.workflow_state<>'deleted') AND "enrollments"."user_id" = 1 AND "enrollment_states"."restricted_access" = FALSE AND (enrollment_states.state IN ('active', 'invited', 'pending_invited', 'pending_active')) [production:1 primary]
[06cfbb7e77325750e2fc1a4a0572d628 800abef5-58bf-4c05-b104-9f19f294e737] SQL Enrollment Pluck (1.0ms) SELECT "enrollments"."course_section_id", "enrollments"."limit_privileges_to_course_section", "enrollments"."type", "enrollments"."associated_user_id", "enrollments"."workflow_state" FROM "public"."enrollments" WHERE "enrollments"."course_id" = 22 AND "enrollments"."user_id" = 1 AND "enrollments"."workflow_state" != 'deleted' [production:1 primary]
[06cfbb7e77325750e2fc1a4a0572d628 800abef5-58bf-4c05-b104-9f19f294e737] SQL Enrollment Load (1.2ms) SELECT enrollments.*, enrollment_states.state AS date_based_state_in_db FROM "public"."enrollments" INNER JOIN "public"."enrollment_states" ON "enrollment_states"."enrollment_id" = "enrollments"."id" WHERE "enrollments"."course_id" = 22 AND (enrollments.workflow_state<>'deleted') AND "enrollments"."user_id" = 1 AND "enrollment_states"."restricted_access" = FALSE AND (enrollment_states.state IN ('active', 'invited', 'pending_invited', 'pending_active')) [production:1 primary]
[06cfbb7e77325750e2fc1a4a0572d628 800abef5-58bf-4c05-b104-9f19f294e737] SQL Enrollment Pluck (0.8ms) SELECT "enrollments"."course_section_id", "enrollments"."limit_privileges_to_course_section", "enrollments"."type", "enrollments"."associated_user_id", "enrollments"."workflow_state" FROM "public"."enrollments" WHERE "enrollments"."course_id" = 14 AND "enrollments"."user_id" = 1 AND "enrollments"."workflow_state" != 'deleted' [production:1 primary]
[06cfbb7e77325750e2fc1a4a0572d628 800abef5-58bf-4c05-b104-9f19f294e737] SQL Enrollment Load (0.8ms) SELECT enrollments.*, enrollment_states.state AS date_based_state_in_db FROM "public"."enrollments" INNER JOIN "public"."enrollment_states" ON "enrollment_states"."enrollment_id" = "enrollments"."id" WHERE "enrollments"."course_id" = 14 AND (enrollments.workflow_state<>'deleted') AND "enrollments"."user_id" = 1 AND "enrollment_states"."restricted_access" = FALSE AND (enrollment_states.state IN ('active', 'invited', 'pending_invited', 'pending_active')) AND "enrollments"."type" IN ('TeacherEnrollment', 'TaEnrollment', 'DesignerEnrollment', 'StudentViewEnrollment') [production:1 primary]
[06cfbb7e77325750e2fc1a4a0572d628 800abef5-58bf-4c05-b104-9f19f294e737] SQL Enrollment Pluck (0.7ms) SELECT "enrollments"."course_section_id", "enrollments"."limit_privileges_to_course_section", "enrollments"."type", "enrollments"."associated_user_id", "enrollments"."workflow_state" FROM "public"."enrollments" WHERE "enrollments"."course_id" = 27 AND "enrollments"."user_id" = 1 AND "enrollments"."workflow_state" != 'deleted' [production:1 primary]
[06cfbb7e77325750e2fc1a4a0572d628 800abef5-58bf-4c05-b104-9f19f294e737] SQL Enrollment Load (0.8ms) SELECT enrollments.*, enrollment_states.state AS date_based_state_in_db FROM "public"."enrollments" INNER JOIN "public"."enrollment_states" ON "enrollment_states"."enrollment_id" = "enrollments"."id" WHERE "enrollments"."course_id" = 27 AND (enrollments.workflow_state<>'deleted') AND "enrollments"."user_id" = 1 AND "enrollment_states"."restricted_access" = FALSE AND (enrollment_states.state IN ('active', 'invited', 'pending_invited', 'pending_active')) AND "enrollments"."type" IN ('TeacherEnrollment', 'TaEnrollment', 'DesignerEnrollment', 'StudentViewEnrollment') [production:1 primary]
[06cfbb7e77325750e2fc1a4a0572d628 800abef5-58bf-4c05-b104-9f19f294e737] SQL Enrollment Pluck (0.5ms) SELECT "enrollments"."course_section_id", "enrollments"."limit_privileges_to_course_section", "enrollments"."type", "enrollments"."associated_user_id", "enrollments"."workflow_state" FROM "public"."enrollments" WHERE "enrollments"."course_id" = 29 AND "enrollments"."user_id" = 1 AND "enrollments"."workflow_state" != 'deleted' [production:1 primary]
[06cfbb7e77325750e2fc1a4a0572d628 800abef5-58bf-4c05-b104-9f19f294e737] SQL Enrollment Load (0.8ms) SELECT enrollments.*, enrollment_states.state AS date_based_state_in_db FROM "public"."enrollments" INNER JOIN "public"."enrollment_states" ON "enrollment_states"."enrollment_id" = "enrollments"."id" WHERE "enrollments"."course_id" = 29 AND (enrollments.workflow_state<>'deleted') AND "enrollments"."user_id" = 1 AND "enrollment_states"."restricted_access" = FALSE AND (enrollment_states.state IN ('active', 'invited', 'pending_invited', 'pending_active')) [production:1 primary]
[06cfbb7e77325750e2fc1a4a0572d628 800abef5-58bf-4c05-b104-9f19f294e737] SQL Enrollment Pluck (0.7ms) SELECT "enrollments"."course_section_id", "enrollments"."limit_privileges_to_course_section", "enrollments"."type", "enrollments"."associated_user_id", "enrollments"."workflow_state" FROM "public"."enrollments" WHERE "enrollments"."course_id" = 18 AND "enrollments"."user_id" = 1 AND "enrollments"."workflow_state" != 'deleted' [production:1 primary]
[06cfbb7e77325750e2fc1a4a0572d628 800abef5-58bf-4c05-b104-9f19f294e737] SQL Enrollment Load (0.9ms) SELECT enrollments.*, enrollment_states.state AS date_based_state_in_db FROM "public"."enrollments" INNER JOIN "public"."enrollment_states" ON "enrollment_states"."enrollment_id" = "enrollments"."id" WHERE "enrollments"."course_id" = 18 AND (enrollments.workflow_state<>'deleted') AND "enrollments"."user_id" = 1 AND "enrollment_states"."restricted_access" = FALSE AND (enrollment_states.state IN ('active', 'invited', 'pending_invited', 'pending_active')) [production:1 primary]
[06cfbb7e77325750e2fc1a4a0572d628 800abef5-58bf-4c05-b104-9f19f294e737] SQL Enrollment Pluck (0.6ms) SELECT "enrollments"."course_section_id", "enrollments"."limit_privileges_to_course_section", "enrollments"."type", "enrollments"."associated_user_id", "enrollments"."workflow_state" FROM "public"."enrollments" WHERE "enrollments"."course_id" = 30 AND "enrollments"."user_id" = 1 AND "enrollments"."workflow_state" != 'deleted' [production:1 primary]
[06cfbb7e77325750e2fc1a4a0572d628 800abef5-58bf-4c05-b104-9f19f294e737] SQL Enrollment Load (1.1ms) SELECT enrollments.*, enrollment_states.state AS date_based_state_in_db FROM "public"."enrollments" INNER JOIN "public"."enrollment_states" ON "enrollment_states"."enrollment_id" = "enrollments"."id" WHERE "enrollments"."course_id" = 30 AND (enrollments.workflow_state<>'deleted') AND "enrollments"."user_id" = 1 AND "enrollment_states"."restricted_access" = FALSE AND (enrollment_states.state IN ('active', 'invited', 'pending_invited', 'pending_active')) AND "enrollments"."type" IN ('TeacherEnrollment', 'TaEnrollment', 'DesignerEnrollment', 'StudentViewEnrollment') [production:1 primary]
[06cfbb7e77325750e2fc1a4a0572d628 800abef5-58bf-4c05-b104-9f19f294e737] SQL Enrollment Pluck (0.6ms) SELECT "enrollments"."course_section_id", "enrollments"."limit_privileges_to_course_section", "enrollments"."type", "enrollments"."associated_user_id", "enrollments"."workflow_state" FROM "public"."enrollments" WHERE "enrollments"."course_id" = 28 AND "enrollments"."user_id" = 1 AND "enrollments"."workflow_state" != 'deleted' [production:1 primary]
[06cfbb7e77325750e2fc1a4a0572d628 800abef5-58bf-4c05-b104-9f19f294e737] SQL Enrollment Load (0.9ms) SELECT enrollments.*, enrollment_states.state AS date_based_state_in_db FROM "public"."enrollments" INNER JOIN "public"."enrollment_states" ON "enrollment_states"."enrollment_id" = "enrollments"."id" WHERE "enrollments"."course_id" = 28 AND (enrollments.workflow_state<>'deleted') AND "enrollments"."user_id" = 1 AND "enrollment_states"."restricted_access" = FALSE AND (enrollment_states.state IN ('active', 'invited', 'pending_invited', 'pending_active')) AND "enrollments"."type" IN ('TeacherEnrollment', 'TaEnrollment', 'DesignerEnrollment', 'StudentViewEnrollment') [production:1 primary]
[06cfbb7e77325750e2fc1a4a0572d628 800abef5-58bf-4c05-b104-9f19f294e737] SQL Enrollment Pluck (0.7ms) SELECT "enrollments"."course_section_id", "enrollments"."limit_privileges_to_course_section", "enrollments"."type", "enrollments"."associated_user_id", "enrollments"."workflow_state" FROM "public"."enrollments" WHERE "enrollments"."course_id" = 33 AND "enrollments"."user_id" = 1 AND "enrollments"."workflow_state" != 'deleted' [production:1 primary]
[06cfbb7e77325750e2fc1a4a0572d628 800abef5-58bf-4c05-b104-9f19f294e737] SQL Enrollment Load (0.9ms) SELECT enrollments.*, enrollment_states.state AS date_based_state_in_db FROM "public"."enrollments" INNER JOIN "public"."enrollment_states" ON "enrollment_states"."enrollment_id" = "enrollments"."id" WHERE "enrollments"."course_id" = 33 AND (enrollments.workflow_state<>'deleted') AND "enrollments"."user_id" = 1 AND "enrollment_states"."restricted_access" = FALSE AND (enrollment_states.state IN ('active', 'invited', 'pending_invited', 'pending_active')) AND "enrollments"."type" IN ('TeacherEnrollment', 'TaEnrollment', 'DesignerEnrollment', 'StudentViewEnrollment') [production:1 primary]
[06cfbb7e77325750e2fc1a4a0572d628 800abef5-58bf-4c05-b104-9f19f294e737] SQL Enrollment Pluck (0.6ms) SELECT "enrollments"."course_section_id", "enrollments"."limit_privileges_to_course_section", "enrollments"."type", "enrollments"."associated_user_id", "enrollments"."workflow_state" FROM "public"."enrollments" WHERE "enrollments"."course_id" = 34 AND "enrollments"."user_id" = 1 AND "enrollments"."workflow_state" != 'deleted' [production:1 primary]
[06cfbb7e77325750e2fc1a4a0572d628 800abef5-58bf-4c05-b104-9f19f294e737] SQL Enrollment Load (0.9ms) SELECT enrollments.*, enrollment_states.state AS date_based_state_in_db FROM "public"."enrollments" INNER JOIN "public"."enrollment_states" ON "enrollment_states"."enrollment_id" = "enrollments"."id" WHERE "enrollments"."course_id" = 34 AND (enrollments.workflow_state<>'deleted') AND "enrollments"."user_id" = 1 AND "enrollment_states"."restricted_access" = FALSE AND (enrollment_states.state IN ('active', 'invited', 'pending_invited', 'pending_active')) AND "enrollments"."type" IN ('TeacherEnrollment', 'TaEnrollment', 'DesignerEnrollment', 'StudentViewEnrollment') [production:1 primary]
[06cfbb7e77325750e2fc1a4a0572d628 800abef5-58bf-4c05-b104-9f19f294e737] SQL Enrollment Pluck (0.7ms) SELECT "enrollments"."course_section_id", "enrollments"."limit_privileges_to_course_section", "enrollments"."type", "enrollments"."associated_user_id", "enrollments"."workflow_state" FROM "public"."enrollments" WHERE "enrollments"."course_id" = 13 AND "enrollments"."user_id" = 1 AND "enrollments"."workflow_state" != 'deleted' [production:1 primary]
[06cfbb7e77325750e2fc1a4a0572d628 800abef5-58bf-4c05-b104-9f19f294e737] SQL Enrollment Load (0.8ms) SELECT enrollments.*, enrollment_states.state AS date_based_state_in_db FROM "public"."enrollments" INNER JOIN "public"."enrollment_states" ON "enrollment_states"."enrollment_id" = "enrollments"."id" WHERE "enrollments"."course_id" = 13 AND (enrollments.workflow_state<>'deleted') AND "enrollments"."user_id" = 1 AND "enrollment_states"."restricted_access" = FALSE AND (enrollment_states.state IN ('active', 'invited', 'pending_invited', 'pending_active')) [production:1 primary]
[06cfbb7e77325750e2fc1a4a0572d628 800abef5-58bf-4c05-b104-9f19f294e737] SQL Enrollment Pluck (0.8ms) SELECT "enrollments"."course_section_id", "enrollments"."limit_privileges_to_course_section", "enrollments"."type", "enrollments"."associated_user_id", "enrollments"."workflow_state" FROM "public"."enrollments" WHERE "enrollments"."course_id" = 21 AND "enrollments"."user_id" = 1 AND "enrollments"."workflow_state" != 'deleted' [production:1 primary]
[06cfbb7e77325750e2fc1a4a0572d628 800abef5-58bf-4c05-b104-9f19f294e737] SQL Enrollment Load (1.1ms) SELECT enrollments.*, enrollment_states.state AS date_based_state_in_db FROM "public"."enrollments" INNER JOIN "public"."enrollment_states" ON "enrollment_states"."enrollment_id" = "enrollments"."id" WHERE "enrollments"."course_id" = 21 AND (enrollments.workflow_state<>'deleted') AND "enrollments"."user_id" = 1 AND "enrollment_states"."restricted_access" = FALSE AND (enrollment_states.state IN ('active', 'invited', 'pending_invited', 'pending_active')) [production:1 primary]
[06cfbb7e77325750e2fc1a4a0572d628 800abef5-58bf-4c05-b104-9f19f294e737] SQL Enrollment Pluck (0.7ms) SELECT "enrollments"."course_section_id", "enrollments"."limit_privileges_to_course_section", "enrollments"."type", "enrollments"."associated_user_id", "enrollments"."workflow_state" FROM "public"."enrollments" WHERE "enrollments"."course_id" = 20 AND "enrollments"."user_id" = 1 AND "enrollments"."workflow_state" != 'deleted' [production:1 primary]
[06cfbb7e77325750e2fc1a4a0572d628 800abef5-58bf-4c05-b104-9f19f294e737] SQL Enrollment Load (0.8ms) SELECT enrollments.*, enrollment_states.state AS date_based_state_in_db FROM "public"."enrollments" INNER JOIN "public"."enrollment_states" ON "enrollment_states"."enrollment_id" = "enrollments"."id" WHERE "enrollments"."course_id" = 20 AND (enrollments.workflow_state<>'deleted') AND "enrollments"."user_id" = 1 AND "enrollment_states"."restricted_access" = FALSE AND (enrollment_states.state IN ('active', 'invited', 'pending_invited', 'pending_active')) [production:1 primary]
[06cfbb7e77325750e2fc1a4a0572d628 800abef5-58bf-4c05-b104-9f19f294e737] SQL Enrollment Pluck (0.5ms) SELECT "enrollments"."course_section_id", "enrollments"."limit_privileges_to_course_section", "enrollments"."type", "enrollments"."associated_user_id", "enrollments"."workflow_state" FROM "public"."enrollments" WHERE "enrollments"."course_id" = 19 AND "enrollments"."user_id" = 1 AND "enrollments"."workflow_state" != 'deleted' [production:1 primary]
[06cfbb7e77325750e2fc1a4a0572d628 800abef5-58bf-4c05-b104-9f19f294e737] SQL Enrollment Load (0.9ms) SELECT enrollments.*, enrollment_states.state AS date_based_state_in_db FROM "public"."enrollments" INNER JOIN "public"."enrollment_states" ON "enrollment_states"."enrollment_id" = "enrollments"."id" WHERE "enrollments"."course_id" = 19 AND (enrollments.workflow_state<>'deleted') AND "enrollments"."user_id" = 1 AND "enrollment_states"."restricted_access" = FALSE AND (enrollment_states.state IN ('active', 'invited', 'pending_invited', 'pending_active')) AND "enrollments"."type" IN ('TeacherEnrollment', 'TaEnrollment', 'DesignerEnrollment', 'StudentViewEnrollment') [production:1 primary]
[06cfbb7e77325750e2fc1a4a0572d628 800abef5-58bf-4c05-b104-9f19f294e737] SQL CourseSection Pluck (1.1ms) SELECT "course_sections"."id" FROM "public"."course_sections" WHERE (course_sections.workflow_state<>'deleted') AND "course_sections"."course_id" IN (3, 2, 4, 31, 5, 10, 11, 12, 32, 16, 22, 14, 27, 29, 18, 30, 28, 33, 34, 13, 21, 20, 19) [production:1 secondary]
[06cfbb7e77325750e2fc1a4a0572d628 800abef5-58bf-4c05-b104-9f19f294e737] SQL CalendarEvent Load (2.4ms) SELECT "calendar_events".* FROM "public"."calendar_events" WHERE (calendar_events.workflow_state<>'deleted') AND "calendar_events"."context_code" IN ('user_1', 'course_2', 'course_3', 'course_4', 'course_5', 'course_10', 'course_11', 'course_12', 'course_13', 'course_14', 'course_16', 'course_18', 'course_19', 'course_20', 'course_21', 'course_22', 'course_27', 'course_28', 'course_29', 'course_30', 'course_31', 'course_32', 'course_33', 'course_34', 'course_section_2', 'course_section_3', 'course_section_4', 'course_section_5', 'course_section_10', 'course_section_11', 'course_section_12', 'course_section_13', 'course_section_14', 'course_section_15', 'course_section_17', 'course_section_19', 'course_section_20', 'course_section_21', 'course_section_22', 'course_section_23', 'course_section_25', 'course_section_26', 'course_section_27', 'course_section_28', 'course_section_29', 'course_section_30', 'course_section_31', 'course_section_32') AND ("calendar_events"."context_code" IN ('user_1', 'course_2', 'course_3', 'course_4', 'course_5', 'course_10', 'course_11', 'course_12', 'course_13', 'course_14', 'course_16', 'course_18', 'course_19', 'course_20', 'course_21', 'course_22', 'course_27', 'course_28', 'course_29', 'course_30', 'course_31', 'course_32', 'course_33', 'course_34') AND "calendar_events"."effective_context_code" IS NULL OR "calendar_events"."context_code" IN ('user_1', 'course_section_2', 'course_section_3', 'course_section_4', 'course_section_5', 'course_section_10', 'course_section_11', 'course_section_12', 'course_section_13', 'course_section_14', 'course_section_15', 'course_section_17', 'course_section_19', 'course_section_20', 'course_section_21', 'course_section_22', 'course_section_23', 'course_section_25', 'course_section_26', 'course_section_27', 'course_section_28', 'course_section_29', 'course_section_30', 'course_section_31', 'course_section_32') AND ((LOWER(',' || "public"."calendar_events".effective_context_code || ',') LIKE '%,user\_1,%') OR (LOWER(',' || "public"."calendar_events".effective_context_code || ',') LIKE '%,course\_2,%') OR (LOWER(',' || "public"."calendar_events".effective_context_code || ',') LIKE '%,course\_3,%') OR (LOWER(',' || "public"."calendar_events".effective_context_code || ',') LIKE '%,course\_4,%') OR (LOWER(',' || "public"."calendar_events".effective_context_code || ',') LIKE '%,course\_5,%') OR (LOWER(',' || "public"."calendar_events".effective_context_code || ',') LIKE '%,course\_10,%') OR (LOWER(',' || "public"."calendar_events".effective_context_code || ',') LIKE '%,course\_11,%') OR (LOWER(',' || "public"."calendar_events".effective_context_code || ',') LIKE '%,course\_12,%') OR (LOWER(',' || "public"."calendar_events".effective_context_code || ',') LIKE '%,course\_13,%') OR (LOWER(',' || "public"."calendar_events".effective_context_code || ',') LIKE '%,course\_14,%') OR (LOWER(',' || "public"."calendar_events".effective_context_code || ',') LIKE '%,course\_16,%') OR (LOWER(',' || "public"."calendar_events".effective_context_code || ',') LIKE '%,course\_18,%') OR (LOWER(',' || "public"."calendar_events".effective_context_code || ',') LIKE '%,course\_19,%') OR (LOWER(',' || "public"."calendar_events".effective_context_code || ',') LIKE '%,course\_20,%') OR (LOWER(',' || "public"."calendar_events".effective_context_code || ',') LIKE '%,course\_21,%') OR (LOWER(',' || "public"."calendar_events".effective_context_code || ',') LIKE '%,course\_22,%') OR (LOWER(',' || "public"."calendar_events".effective_context_code || ',') LIKE '%,course\_27,%') OR (LOWER(',' || "public"."calendar_events".effective_context_code || ',') LIKE '%,course\_28,%') OR (LOWER(',' || "public"."calendar_events".effective_context_code || ',') LIKE '%,course\_29,%') OR (LOWER(',' || "public"."calendar_events".effective_context_code || ',') LIKE '%,course\_30,%') OR (LOWER(',' || "public"."calendar_events".effective_context_code || ',') LIKE '%,course\_31,%') OR (LOWER(',' || "public"."calendar_events".effective_context_code || ',') LIKE '%,course\_32,%') OR (LOWER(',' || "public"."calendar_events".effective_context_code || ',') LIKE '%,course\_33,%') OR (LOWER(',' || "public"."calendar_events".effective_context_code || ',') LIKE '%,course\_34,%'))) AND "calendar_events"."start_at" <= '2025-07-31 02:51:23.588561' AND "calendar_events"."end_at" >= '2025-07-24 02:51:23.588515' ORDER BY "calendar_events"."start_at" ASC LIMIT 20 [production:1 secondary]
[06cfbb7e77325750e2fc1a4a0572d628 800abef5-58bf-4c05-b104-9f19f294e737] SQL Assignment Load (8.5ms) SELECT assignments.*, (SELECT COUNT(*) FROM "public"."submissions"
WHERE assignments.id = submissions.assignment_id
AND submissions.submission_type IS NOT NULL
AND submissions.workflow_state <> 'deleted') AS submitted_count FROM ((SELECT "assignments".* FROM "public"."assignments" WHERE "assignments"."workflow_state" = 'published' AND "assignments"."context_type" = 'Course' AND "assignments"."context_id" IN (2, 3, 4, 5, 10, 11, 12, 13, 14, 16, 18, 19, 20, 21, 22, 27, 28, 29, 30, 31, 32, 33, 34) AND "assignments"."due_at" BETWEEN '2025-07-24 02:51:23.588515' AND '2025-07-31 02:51:23.588561') UNION ALL (SELECT "assignments".* FROM "public"."assignments" WHERE "assignments"."workflow_state" = 'published' AND "assignments"."context_type" = 'Course' AND "assignments"."context_id" IN (2, 3, 4, 5, 10, 11, 12, 13, 14, 16, 18, 19, 20, 21, 22, 27, 28, 29, 30, 31, 32, 33, 34) AND EXISTS (SELECT "assignment_overrides".* FROM "public"."assignment_overrides" WHERE (assignment_id=assignments.id) AND "assignment_overrides"."due_at_overridden" = TRUE AND "assignment_overrides"."due_at" BETWEEN '2025-07-24 02:51:23.588515' AND '2025-07-31 02:51:23.588561') AND (NOT ("assignments"."due_at" BETWEEN '2025-07-24 02:51:23.588515' AND '2025-07-31 02:51:23.588561') OR "assignments"."due_at" IS NULL))) "assignments" [production:1 secondary]
[06cfbb7e77325750e2fc1a4a0572d628 800abef5-58bf-4c05-b104-9f19f294e737] SQL StudentEnrollment Exists (0.7ms) SELECT 1 AS one FROM "public"."enrollments" WHERE "enrollments"."type" IN ('StudentEnrollment', 'StudentViewEnrollment') AND "enrollments"."user_id" = 1 AND (enrollments.workflow_state<>'deleted') LIMIT 1 [production:1 secondary]
[06cfbb7e77325750e2fc1a4a0572d628 800abef5-58bf-4c05-b104-9f19f294e737] SQL Enrollment Pluck (1.5ms) SELECT DISTINCT "enrollments"."course_id" FROM "public"."enrollments" INNER JOIN "public"."courses" ON "courses"."id" = "enrollments"."course_id" INNER JOIN "public"."enrollment_states" ON "enrollment_states"."enrollment_id" = "enrollments"."id" WHERE "enrollments"."user_id" = 1 AND (enrollments.workflow_state='active' AND (courses.workflow_state='available' OR courses.workflow_state IN ('created', 'claimed') AND enrollments.type IN ('TeacherEnrollment','TaEnrollment','DesignerEnrollment','StudentViewEnrollment'))) AND (enrollment_states.state = 'active') AND "enrollments"."type" IN ('StudentEnrollment', 'StudentViewEnrollment') [production:1 secondary]
[06cfbb7e77325750e2fc1a4a0572d628 800abef5-58bf-4c05-b104-9f19f294e737] SQL SQL (3.2ms) SELECT "submissions"."id" AS t0_r0, "submissions"."body" AS t0_r1, "submissions"."url" AS t0_r2, "submissions"."attachment_id" AS t0_r3, "submissions"."grade" AS t0_r4, "submissions"."score" AS t0_r5, "submissions"."submitted_at" AS t0_r6, "submissions"."assignment_id" AS t0_r7, "submissions"."user_id" AS t0_r8, "submissions"."submission_type" AS t0_r9, "submissions"."workflow_state" AS t0_r10, "submissions"."created_at" AS t0_r11, "submissions"."updated_at" AS t0_r12, "submissions"."group_id" AS t0_r13, "submissions"."attachment_ids" AS t0_r14, "submissions"."processed" AS t0_r15, "submissions"."grade_matches_current_submission" AS t0_r16, "submissions"."published_score" AS t0_r17, "submissions"."published_grade" AS t0_r18, "submissions"."graded_at" AS t0_r19, "submissions"."student_entered_score" AS t0_r20, "submissions"."grader_id" AS t0_r21, "submissions"."media_comment_id" AS t0_r22, "submissions"."media_comment_type" AS t0_r23, "submissions"."quiz_submission_id" AS t0_r24, "submissions"."submission_comments_count" AS t0_r25, "submissions"."attempt" AS t0_r26, "submissions"."media_object_id" AS t0_r27, "submissions"."turnitin_data" AS t0_r28, "submissions"."cached_due_date" AS t0_r29, "submissions"."excused" AS t0_r30, "submissions"."graded_anonymously" AS t0_r31, "submissions"."late_policy_status" AS t0_r32, "submissions"."points_deducted" AS t0_r33, "submissions"."grading_period_id" AS t0_r34, "submissions"."seconds_late_override" AS t0_r35, "submissions"."lti_user_id" AS t0_r36, "submissions"."anonymous_id" AS t0_r37, "submissions"."last_comment_at" AS t0_r38, "submissions"."extra_attempts" AS t0_r39, "submissions"."posted_at" AS t0_r40, "submissions"."cached_quiz_lti" AS t0_r41, "submissions"."cached_tardiness" AS t0_r42, "submissions"."course_id" AS t0_r43, "submissions"."root_account_id" AS t0_r44, "submissions"."redo_request" AS t0_r45, "submissions"."resource_link_lookup_uuid" AS t0_r46, "submissions"."proxy_submitter_id" AS t0_r47, "submissions"."custom_grade_status_id" AS t0_r48, "submissions"."sticker" AS t0_r49, "assignments"."id" AS t1_r0, "assignments"."title" AS t1_r1, "assignments"."description" AS t1_r2, "assignments"."due_at" AS t1_r3, "assignments"."unlock_at" AS t1_r4, "assignments"."lock_at" AS t1_r5, "assignments"."points_possible" AS t1_r6, "assignments"."min_score" AS t1_r7, "assignments"."max_score" AS t1_r8, "assignments"."mastery_score" AS t1_r9, "assignments"."grading_type" AS t1_r10, "assignments"."submission_types" AS t1_r11, "assignments"."workflow_state" AS t1_r12, "assignments"."context_id" AS t1_r13, "assignments"."context_type" AS t1_r14, "assignments"."assignment_group_id" AS t1_r15, "assignments"."grading_standard_id" AS t1_r16, "assignments"."created_at" AS t1_r17, "assignments"."updated_at" AS t1_r18, "assignments"."group_category" AS t1_r19, "assignments"."submissions_downloads" AS t1_r20, "assignments"."peer_review_count" AS t1_r21, "assignments"."peer_reviews_due_at" AS t1_r22, "assignments"."peer_reviews_assigned" AS t1_r23, "assignments"."peer_reviews" AS t1_r24, "assignments"."automatic_peer_reviews" AS t1_r25, "assignments"."all_day" AS t1_r26, "assignments"."all_day_date" AS t1_r27, "assignments"."could_be_locked" AS t1_r28, "assignments"."cloned_item_id" AS t1_r29, "assignments"."position" AS t1_r30, "assignments"."migration_id" AS t1_r31, "assignments"."grade_group_students_individually" AS t1_r32, "assignments"."anonymous_peer_reviews" AS t1_r33, "assignments"."time_zone_edited" AS t1_r34, "assignments"."turnitin_enabled" AS t1_r35, "assignments"."allowed_extensions" AS t1_r36, "assignments"."turnitin_settings" AS t1_r37, "assignments"."muted" AS t1_r38, "assignments"."group_category_id" AS t1_r39, "assignments"."freeze_on_copy" AS t1_r40, "assignments"."copied" AS t1_r41, "assignments"."only_visible_to_overrides" AS t1_r42, "assignments"."post_to_sis" AS t1_r43, "assignments"."integration_id" AS t1_r44, "assignments"."integration_data" AS t1_r45, "assignments"."turnitin_id" AS t1_r46, "assignments"."moderated_grading" AS t1_r47, "assignments"."grades_published_at" AS t1_r48, "assignments"."omit_from_final_grade" AS t1_r49, "assignments"."vericite_enabled" AS t1_r50, "assignments"."intra_group_peer_reviews" AS t1_r51, "assignments"."lti_context_id" AS t1_r52, "assignments"."anonymous_instructor_annotations" AS t1_r53, "assignments"."duplicate_of_id" AS t1_r54, "assignments"."anonymous_grading" AS t1_r55, "assignments"."graders_anonymous_to_graders" AS t1_r56, "assignments"."grader_count" AS t1_r57, "assignments"."grader_comments_visible_to_graders" AS t1_r58, "assignments"."grader_section_id" AS t1_r59, "assignments"."final_grader_id" AS t1_r60, "assignments"."grader_names_visible_to_final_grader" AS t1_r61, "assignments"."duplication_started_at" AS t1_r62, "assignments"."importing_started_at" AS t1_r63, "assignments"."allowed_attempts" AS t1_r64, "assignments"."root_account_id" AS t1_r65, "assignments"."sis_source_id" AS t1_r66, "assignments"."migrate_from_id" AS t1_r67, "assignments"."settings" AS t1_r68, "assignments"."annotatable_attachment_id" AS t1_r69, "assignments"."important_dates" AS t1_r70, "assignments"."hide_in_gradebook" AS t1_r71, "assignments"."ab_guid" AS t1_r72, "assignments"."checkpointed" AS t1_r73, "assignments"."checkpoint_label" AS t1_r74, "assignments"."parent_assignment_id" AS t1_r75, "assignments"."type" AS t1_r76 FROM "public"."submissions" LEFT OUTER JOIN "public"."assignments" ON "assignments"."id" = "submissions"."assignment_id" WHERE "submissions"."user_id" = 1 AND (submissions.workflow_state <> 'deleted') AND "submissions"."posted_at" IS NOT NULL AND (GREATEST(submissions.submitted_at, submissions.created_at) > '2025-06-26 02:51:24.078907') AND "submissions"."course_id" = 10 AND (submissions.score IS NOT NULL AND assignments.workflow_state='published') ORDER BY "submissions"."updated_at" DESC, submissions.created_at DESC LIMIT 20 [production:1 secondary]
[06cfbb7e77325750e2fc1a4a0572d628 800abef5-58bf-4c05-b104-9f19f294e737] SQL Submission Load (2.6ms) SELECT "submissions".* FROM "public"."submissions" INNER JOIN "public"."assignments" ON "assignments"."id" = "submissions"."assignment_id" INNER JOIN "public"."post_policies" ON "post_policies"."assignment_id" = "assignments"."id" WHERE (submissions.workflow_state <> 'deleted') AND "submissions"."user_id" = 1 AND "submissions"."course_id" = 10 AND (submissions.posted_at IS NOT NULL OR post_policies.post_manually IS FALSE) AND "assignments"."workflow_state" = 'published' AND (last_comment_at > '2025-06-26 02:51:24.078907') ORDER BY last_comment_at LIMIT 20 [production:1 secondary]
[06cfbb7e77325750e2fc1a4a0572d628 800abef5-58bf-4c05-b104-9f19f294e737] Rendering users/dashboard_sidebar.html.erb
[06cfbb7e77325750e2fc1a4a0572d628 800abef5-58bf-4c05-b104-9f19f294e737] SQL FeatureFlag Load (0.6ms) SELECT "feature_flags".* FROM "public"."feature_flags" WHERE "feature_flags"."feature" = 'high_contrast' AND "feature_flags"."context_type" = 'User' AND "feature_flags"."context_id" = 1 ORDER BY "feature_flags"."id" ASC LIMIT 1 [production:1 primary]
[06cfbb7e77325750e2fc1a4a0572d628 800abef5-58bf-4c05-b104-9f19f294e737] SQL Account Load (1.4ms) SELECT "accounts".* FROM "public"."accounts" INNER JOIN "public"."user_account_associations" ON "accounts"."id" = "user_account_associations"."account_id" WHERE "user_account_associations"."user_id" = 1 AND (accounts.id = 1 OR accounts.root_account_id = 1) ORDER BY user_account_associations.depth [production:1 secondary]
[06cfbb7e77325750e2fc1a4a0572d628 800abef5-58bf-4c05-b104-9f19f294e737] SQL Enrollment Pluck (2.0ms) SELECT DISTINCT "account_id" FROM "public"."enrollments" INNER JOIN "public"."courses" ON "courses"."id" = "enrollments"."course_id" WHERE "enrollments"."root_account_id" = 1 AND (enrollments.workflow_state='active' AND (courses.workflow_state='available' OR courses.workflow_state IN ('created', 'claimed') AND enrollments.type IN ('TeacherEnrollment','TaEnrollment','DesignerEnrollment','StudentViewEnrollment'))) AND "enrollments"."user_id" = 1 [production:1 secondary]
[06cfbb7e77325750e2fc1a4a0572d628 800abef5-58bf-4c05-b104-9f19f294e737] SQL Account Load (1.0ms) WITH RECURSIVE t AS ( SELECT * FROM "public"."accounts" WHERE id=1 UNION SELECT accounts.* FROM "public"."accounts" INNER JOIN t ON accounts.id=t.parent_account_id ) SELECT * FROM t [production:1 secondary]
[06cfbb7e77325750e2fc1a4a0572d628 800abef5-58bf-4c05-b104-9f19f294e737] SQL BrandConfig Load (0.6ms) SELECT "brand_configs".* FROM "public"."brand_configs" WHERE "brand_configs"."md5" = '3ba81c2a42a55ab9e224f20c27c3366f' LIMIT 1 [production:1 primary]
[06cfbb7e77325750e2fc1a4a0572d628 800abef5-58bf-4c05-b104-9f19f294e737] SQL BrandConfig Load (0.5ms) SELECT "brand_configs".* FROM "public"."brand_configs" WHERE "brand_configs"."md5" = '848d50addff314a5e4c17051651261da' LIMIT 1 [production:1 primary]
[06cfbb7e77325750e2fc1a4a0572d628 800abef5-58bf-4c05-b104-9f19f294e737] CACHE SQL BrandConfig Load (0.0ms) 1::SELECT "brand_configs".* FROM "public"."brand_configs" WHERE "brand_configs"."md5" = '848d50addff314a5e4c17051651261da' LIMIT 1
[06cfbb7e77325750e2fc1a4a0572d628 800abef5-58bf-4c05-b104-9f19f294e737] SQL Enrollment Load (1.9ms) SELECT "enrollments".* FROM "public"."enrollments" INNER JOIN "public"."courses" ON "courses"."id" = "enrollments"."course_id" INNER JOIN "public"."enrollment_states" ON "enrollment_states"."enrollment_id" = "enrollments"."id" WHERE "enrollments"."user_id" = 1 AND (enrollments.workflow_state='active' AND (courses.workflow_state='available' OR courses.workflow_state IN ('created', 'claimed') AND enrollments.type IN ('TeacherEnrollment','TaEnrollment','DesignerEnrollment','StudentViewEnrollment'))) AND (enrollment_states.state = 'active') [production:1 secondary]
[06cfbb7e77325750e2fc1a4a0572d628 800abef5-58bf-4c05-b104-9f19f294e737] SQL Course Load (1.4ms) SELECT "courses".* FROM "public"."courses" WHERE "courses"."id" IN (16, 19, 5, 10, 14, 34, 18, 20, 28, 29, 13, 27, 30, 3, 33, 12, 22, 2, 31, 32, 4, 21, 11) [production:1 secondary]
[06cfbb7e77325750e2fc1a4a0572d628 800abef5-58bf-4c05-b104-9f19f294e737] SQL EnrollmentState Load (0.9ms) SELECT "enrollment_states".* FROM "public"."enrollment_states" WHERE "enrollment_states"."enrollment_id" IN (39, 50, 7, 41, 35, 115, 43, 53, 13, 72, 76, 32, 68, 81, 3, 114, 29, 58, 2, 88, 97, 4, 55, 22) [production:1 secondary]
[06cfbb7e77325750e2fc1a4a0572d628 800abef5-58bf-4c05-b104-9f19f294e737] SQL AccountUser Load (1.2ms) SELECT "account_users".* FROM "public"."account_users" WHERE "account_users"."user_id" = 1 AND "account_users"."workflow_state" != 'deleted' [production:1 secondary]
[06cfbb7e77325750e2fc1a4a0572d628 800abef5-58bf-4c05-b104-9f19f294e737] SQL Role Load (0.7ms) SELECT "roles".* FROM "public"."roles" WHERE "roles"."id" IN (17, 9) [production:1 secondary]
[06cfbb7e77325750e2fc1a4a0572d628 800abef5-58bf-4c05-b104-9f19f294e737] SQL (1.6ms) WITH RECURSIVE t(id, name, parent_account_id, role_id, enabled, locked, self, children, permission) AS ( SELECT accounts.id, name, parent_account_id, ro.role_id, ro.enabled, ro.locked, ro.applies_to_self, ro.applies_to_descendants, ro.permission FROM "public"."accounts" LEFT JOIN "public"."role_overrides" AS ro ON ro.context_id = accounts.id AND ro.context_type = 'Account' AND ro.permission IN ('manage_grades') AND ro.role_id IN (12,11,17,9) WHERE accounts.id IN (3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3) UNION SELECT accounts.id, accounts.name, accounts.parent_account_id, ro.role_id, ro.enabled, ro.locked, ro.applies_to_self, ro.applies_to_descendants, ro.permission FROM "public"."accounts" INNER JOIN t ON accounts.id = t.parent_account_id LEFT JOIN "public"."role_overrides" AS ro ON ro.context_id = accounts.id AND ro.context_type = 'Account' AND ro.permission IN ('manage_grades') AND ro.role_id IN (12,11,17,9) WHERE accounts.workflow_state = 'active' ) SELECT * FROM t [production:1 secondary]
[06cfbb7e77325750e2fc1a4a0572d628 800abef5-58bf-4c05-b104-9f19f294e737] SQL GroupMembership Load (2.7ms) SELECT "group_memberships".* FROM "public"."group_memberships" INNER JOIN "public"."groups" ON "groups"."id" = "group_memberships"."group_id" LEFT OUTER JOIN "public"."enrollments" ON enrollments.user_id=group_memberships.user_id AND enrollments.course_id=groups.context_id AND groups.context_type='Course' LEFT OUTER JOIN "public"."enrollment_states" ON enrollment_states.enrollment_id=enrollments.id WHERE "group_memberships"."user_id" = 1 AND (group_memberships.workflow_state='accepted' AND groups.workflow_state<>'deleted' AND COALESCE(enrollment_states.state,'active') IN ('invited','active')) [production:1 primary]
[06cfbb7e77325750e2fc1a4a0572d628 800abef5-58bf-4c05-b104-9f19f294e737] SQL Assignment Load (8.4ms) SELECT "assignments".* FROM "public"."assignments" INNER JOIN (SELECT "submissions"."assignment_id", "submissions"."user_id" FROM "public"."submissions" INNER JOIN (SELECT "assignments".* FROM "public"."assignments" WHERE NOT (EXISTS (SELECT "ignores".* FROM "public"."ignores" WHERE "ignores"."asset_type" = 'Assignment' AND "ignores"."user_id" = 1 AND "ignores"."purpose" = 'grading' AND (asset_id=assignments.id))) AND "assignments"."context_type" = 'Course' AND "assignments"."context_id" IN (16, 19, 5, 10, 14, 34, 18, 20, 10, 28, 29, 13, 27, 30, 3, 33, 12, 22, 2, 31, 32, 4, 21, 11) AND "assignments"."workflow_state" != 'deleted' AND NOT (("assignments"."submission_types" IN ('', 'none', 'not_graded', 'on_paper', 'wiki_page') OR "assignments"."submission_types" IS NULL))) assignments ON assignment_id=assignments.id WHERE (submissions.submission_type IS NOT NULL AND (submissions.excused=false OR submissions.excused IS NULL) AND (submissions.workflow_state = 'pending_review' OR (submissions.workflow_state IN ('submitted', 'graded') AND (submissions.score IS NULL OR submissions.grade_matches_current_submission = 'f') ) ))) AS submissions_needing_grading ON assignments.id=submissions_needing_grading.assignment_id INNER JOIN "public"."enrollments" ON enrollments.course_id = assignments.context_id WHERE NOT (EXISTS (SELECT "ignores".* FROM "public"."ignores" WHERE "ignores"."asset_type" = 'Assignment' AND "ignores"."user_id" = 1 AND "ignores"."purpose" = 'grading' AND (asset_id=assignments.id))) AND "assignments"."context_type" = 'Course' AND "assignments"."context_id" IN (16, 19, 5, 10, 14, 34, 18, 20, 10, 28, 29, 13, 27, 30, 3, 33, 12, 22, 2, 31, 32, 4, 21, 11) AND "assignments"."workflow_state" != 'deleted' AND NOT (("assignments"."submission_types" IN ('', 'none', 'not_graded', 'on_paper', 'wiki_page') OR "assignments"."submission_types" IS NULL)) AND EXISTS (SELECT 1 FROM "public"."enrollments" student_enrollments WHERE (student_enrollments.course_id=assignments.context_id) AND (student_enrollments.user_id=submissions_needing_grading.user_id AND student_enrollments.workflow_state='active') AND ((enrollments.limit_privileges_to_course_section='f' OR student_enrollments.course_section_id=enrollments.course_section_id))) AND "enrollments"."user_id" = 1 AND "enrollments"."workflow_state" = 'active' AND "enrollments"."type" IN ('TeacherEnrollment', 'TaEnrollment') GROUP BY "assignments"."id" ORDER BY assignments.due_at [production:1 secondary]
[06cfbb7e77325750e2fc1a4a0572d628 800abef5-58bf-4c05-b104-9f19f294e737] CACHE SQL AccountUser Load (0.0ms) 1::SELECT "account_users".* FROM "public"."account_users" WHERE "account_users"."user_id" = 1 AND "account_users"."workflow_state" != 'deleted'
[06cfbb7e77325750e2fc1a4a0572d628 800abef5-58bf-4c05-b104-9f19f294e737] CACHE SQL Role Load (0.0ms) 1::SELECT "roles".* FROM "public"."roles" WHERE "roles"."id" IN (17, 9)
[06cfbb7e77325750e2fc1a4a0572d628 800abef5-58bf-4c05-b104-9f19f294e737] SQL (1.6ms) WITH RECURSIVE t(id, name, parent_account_id, role_id, enabled, locked, self, children, permission) AS ( SELECT accounts.id, name, parent_account_id, ro.role_id, ro.enabled, ro.locked, ro.applies_to_self, ro.applies_to_descendants, ro.permission FROM "public"."accounts" LEFT JOIN "public"."role_overrides" AS ro ON ro.context_id = accounts.id AND ro.context_type = 'Account' AND ro.permission IN ('select_final_grade') AND ro.role_id IN (12,11,17,9) WHERE accounts.id IN (3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3) UNION SELECT accounts.id, accounts.name, accounts.parent_account_id, ro.role_id, ro.enabled, ro.locked, ro.applies_to_self, ro.applies_to_descendants, ro.permission FROM "public"."accounts" INNER JOIN t ON accounts.id = t.parent_account_id LEFT JOIN "public"."role_overrides" AS ro ON ro.context_id = accounts.id AND ro.context_type = 'Account' AND ro.permission IN ('select_final_grade') AND ro.role_id IN (12,11,17,9) WHERE accounts.workflow_state = 'active' ) SELECT * FROM t [production:1 secondary]
[06cfbb7e77325750e2fc1a4a0572d628 800abef5-58bf-4c05-b104-9f19f294e737] SQL Assignment Load (2.8ms) SELECT "assignments".* FROM "public"."assignments" WHERE NOT (EXISTS (SELECT "ignores".* FROM "public"."ignores" WHERE "ignores"."asset_type" = 'Assignment' AND "ignores"."user_id" = 1 AND "ignores"."purpose" = 'moderation' AND (asset_id=assignments.id))) AND "assignments"."context_type" = 'Course' AND "assignments"."context_id" IN (16, 19, 5, 10, 14, 34, 18, 20, 10, 28, 29, 13, 27, 30, 3, 33, 12, 22, 2, 31, 32, 4, 21, 11) AND "assignments"."workflow_state" != 'deleted' AND NOT (("assignments"."submission_types" IN ('', 'none', 'not_graded', 'on_paper', 'wiki_page') OR "assignments"."submission_types" IS NULL)) AND "assignments"."workflow_state" != 'deleted' AND NOT (("assignments"."submission_types" IN ('', 'none', 'not_graded', 'on_paper', 'wiki_page') OR "assignments"."submission_types" IS NULL)) AND "assignments"."final_grader_id" = 1 AND "assignments"."moderated_grading" = TRUE AND "assignments"."grades_published_at" IS NULL AND "assignments"."id" IN (SELECT DISTINCT "assignment_id" FROM "public"."moderated_grading_provisional_grades" INNER JOIN "public"."submissions" ON "submissions"."id" = "moderated_grading_provisional_grades"."submission_id" WHERE (submissions.assignment_id=assignments.id) AND (submissions.submission_type IS NOT NULL AND (submissions.excused=false OR submissions.excused IS NULL) AND (submissions.workflow_state = 'pending_review' OR (submissions.workflow_state IN ('submitted', 'graded') AND (submissions.score IS NULL OR submissions.grade_matches_current_submission = 'f') ) ))) [production:1 secondary]
[06cfbb7e77325750e2fc1a4a0572d628 800abef5-58bf-4c05-b104-9f19f294e737] SQL Assignment Load (12.7ms) SELECT "assignments".* FROM (SELECT s.cached_due_date AS user_due_date, a.*
FROM "public"."assignments" a
INNER JOIN "public"."submissions" AS s ON s.assignment_id = a.id
WHERE s.user_id = 1 AND s.workflow_state <> 'deleted') AS assignments WHERE NOT (EXISTS (SELECT "ignores".* FROM "public"."ignores" WHERE "ignores"."asset_type" = 'Assignment' AND "ignores"."user_id" = 1 AND "ignores"."purpose" = 'submitting' AND (asset_id=assignments.id))) AND "assignments"."context_type" = 'Course' AND "assignments"."context_id" = 10 AND "assignments"."workflow_state" = 'published' AND "assignments"."user_due_date" BETWEEN '2025-06-26 02:51:24.534265' AND '2025-07-31 02:51:24.534526' AND (NOT EXISTS (SELECT 1 FROM "public"."submissions"
WHERE assignment_id = assignments.id
AND submissions.workflow_state <> 'deleted'
AND (submission_type IS NOT NULL OR excused = TRUE)
AND user_id = 1)) AND (NOT (("assignments"."submission_types" IN ('on_paper', 'external_tool', 'none', 'not_graded', 'wiki_page') OR "assignments"."submission_types" IS NULL)) OR assignments.user_due_date > '2025-07-24 02:51:24.538883') AND ((assignments.unlock_at IS NULL OR assignments.unlock_at<'2025-07-24 02:51:24.539474') AND (assignments.lock_at IS NULL OR assignments.lock_at>'2025-07-24 02:51:24.539474')) ORDER BY assignments.due_at LIMIT 100 [production:1 secondary]
[06cfbb7e77325750e2fc1a4a0572d628 800abef5-58bf-4c05-b104-9f19f294e737] SQL Quizzes::Quiz Exists (5.0ms) SELECT 1 AS one FROM (WITH overrides AS (
SELECT DISTINCT ON (o.quiz_id, o.user_id) *
FROM (
SELECT ao.quiz_id, aos.user_id, ao.due_at, ao.due_at_overridden, 1 AS priority
FROM "public"."assignment_overrides" ao
INNER JOIN "public"."assignment_override_students" aos ON ao.id = aos.assignment_override_id AND ao.set_type = 'ADHOC'
WHERE aos.user_id = 1
AND ao.workflow_state = 'active'
AND aos.workflow_state <> 'deleted'
UNION
SELECT ao.quiz_id, e.user_id, ao.due_at, ao.due_at_overridden, 1 AS priority
FROM "public"."assignment_overrides" ao
INNER JOIN "public"."enrollments" e ON e.course_section_id = ao.set_id AND ao.set_type = 'CourseSection'
WHERE e.user_id = 1
AND e.workflow_state NOT IN ('rejected', 'deleted', 'inactive')
AND ao.workflow_state = 'active'
UNION
SELECT q.id, e.user_id, q.due_at, FALSE as due_at_overridden, 2 AS priority
FROM "public"."quizzes" q
INNER JOIN "public"."enrollments" e ON e.course_id = q.context_id
WHERE e.workflow_state NOT IN ('rejected', 'deleted', 'inactive')
AND e.type in ('StudentEnrollment', 'StudentViewEnrollment')
AND e.user_id = 1
AND q.assignment_id IS NULL
AND NOT q.only_visible_to_overrides
) o
ORDER BY o.user_id ASC, o.quiz_id ASC, priority ASC, o.due_at_overridden DESC, o.due_at DESC NULLS FIRST
)
SELECT CASE WHEN overrides.due_at_overridden THEN overrides.due_at ELSE q.due_at END as user_due_date, q.*
FROM "public"."quizzes" q
INNER JOIN overrides ON overrides.quiz_id = q.id) as quizzes WHERE NOT (EXISTS (SELECT "ignores".* FROM "public"."ignores" WHERE "ignores"."asset_type" = 'Quizzes::Quiz' AND "ignores"."user_id" = 1 AND "ignores"."purpose" = 'viewing' AND (asset_id=quizzes.id))) AND "quizzes"."context_type" = 'Course' AND "quizzes"."context_id" = 10 AND (quizzes.workflow_state = 'available') AND ((quizzes.unlock_at IS NULL OR quizzes.unlock_at<'2025-07-24 02:51:24.565297') AND (quizzes.lock_at IS NULL OR quizzes.lock_at>'2025-07-24 02:51:24.565297')) AND "quizzes"."assignment_id" IS NULL AND "quizzes"."user_due_date" BETWEEN '2025-07-24 02:51:24.554687' AND '2025-07-31 02:51:24.554715' AND ((SELECT COUNT(id) FROM "public"."quiz_submissions"
WHERE quiz_id = quizzes.id
AND workflow_state = 'complete'
AND user_id = 1) = 0) LIMIT 1 [production:1 secondary]
[06cfbb7e77325750e2fc1a4a0572d628 54208b97-4a3e-4915-a38f-cab74be316f8] SQL ActiveRecord::SchemaMigration Pluck (0.9ms) SELECT "schema_migrations"."version" FROM "public"."schema_migrations" ORDER BY "schema_migrations"."version" ASC [production:1 primary]
[06cfbb7e77325750e2fc1a4a0572d628 800abef5-58bf-4c05-b104-9f19f294e737] SQL SQL (4.0ms) SELECT "assessment_requests"."id" AS t0_r0, "assessment_requests"."rubric_assessment_id" AS t0_r1, "assessment_requests"."user_id" AS t0_r2, "assessment_requests"."asset_id" AS t0_r3, "assessment_requests"."asset_type" AS t0_r4, "assessment_requests"."assessor_asset_id" AS t0_r5, "assessment_requests"."assessor_asset_type" AS t0_r6, "assessment_requests"."workflow_state" AS t0_r7, "assessment_requests"."created_at" AS t0_r8, "assessment_requests"."updated_at" AS t0_r9, "assessment_requests"."uuid" AS t0_r10, "assessment_requests"."rubric_association_id" AS t0_r11, "assessment_requests"."assessor_id" AS t0_r12, "submissions"."id" AS t1_r0, "submissions"."body" AS t1_r1, "submissions"."url" AS t1_r2, "submissions"."attachment_id" AS t1_r3, "submissions"."grade" AS t1_r4, "submissions"."score" AS t1_r5, "submissions"."submitted_at" AS t1_r6, "submissions"."assignment_id" AS t1_r7, "submissions"."user_id" AS t1_r8, "submissions"."submission_type" AS t1_r9, "submissions"."workflow_state" AS t1_r10, "submissions"."created_at" AS t1_r11, "submissions"."updated_at" AS t1_r12, "submissions"."group_id" AS t1_r13, "submissions"."attachment_ids" AS t1_r14, "submissions"."processed" AS t1_r15, "submissions"."grade_matches_current_submission" AS t1_r16, "submissions"."published_score" AS t1_r17, "submissions"."published_grade" AS t1_r18, "submissions"."graded_at" AS t1_r19, "submissions"."student_entered_score" AS t1_r20, "submissions"."grader_id" AS t1_r21, "submissions"."media_comment_id" AS t1_r22, "submissions"."media_comment_type" AS t1_r23, "submissions"."quiz_submission_id" AS t1_r24, "submissions"."submission_comments_count" AS t1_r25, "submissions"."attempt" AS t1_r26, "submissions"."media_object_id" AS t1_r27, "submissions"."turnitin_data" AS t1_r28, "submissions"."cached_due_date" AS t1_r29, "submissions"."excused" AS t1_r30, "submissions"."graded_anonymously" AS t1_r31, "submissions"."late_policy_status" AS t1_r32, "submissions"."points_deducted" AS t1_r33, "submissions"."grading_period_id" AS t1_r34, "submissions"."seconds_late_override" AS t1_r35, "submissions"."lti_user_id" AS t1_r36, "submissions"."anonymous_id" AS t1_r37, "submissions"."last_comment_at" AS t1_r38, "submissions"."extra_attempts" AS t1_r39, "submissions"."posted_at" AS t1_r40, "submissions"."cached_quiz_lti" AS t1_r41, "submissions"."cached_tardiness" AS t1_r42, "submissions"."course_id" AS t1_r43, "submissions"."root_account_id" AS t1_r44, "submissions"."redo_request" AS t1_r45, "submissions"."resource_link_lookup_uuid" AS t1_r46, "submissions"."proxy_submitter_id" AS t1_r47, "submissions"."custom_grade_status_id" AS t1_r48, "submissions"."sticker" AS t1_r49 FROM "public"."assessment_requests" INNER JOIN "public"."submissions" ON "submissions"."id" = "assessment_requests"."asset_id" AND "assessment_requests"."asset_type" = 'Submission' INNER JOIN "public"."assignments" ON "assignments"."id" = "submissions"."assignment_id" INNER JOIN "public"."submissions" AS assessor_asset ON assessment_requests.assessor_asset_id = assessor_asset.id
AND assessor_asset.assignment_id = assignments.id INNER JOIN "public"."enrollments" AS enrollments ON enrollments.user_id = assessment_requests.user_id
AND enrollments.course_id = assessor_asset.course_id AND enrollments.workflow_state NOT IN ('rejected', 'completed', 'deleted', 'inactive') WHERE NOT (EXISTS (SELECT "ignores".* FROM "public"."ignores" WHERE (asset_id=assessment_requests.id) AND "ignores"."asset_type" = 'AssessmentRequest' AND "ignores"."user_id" = 1 AND "ignores"."purpose" = 'reviewing')) AND "assessment_requests"."assessor_id" = 1 AND "assessor_asset"."course_id" = 10 AND "assessment_requests"."workflow_state" = 'assigned' AND "submissions"."course_id" = 10 AND (submissions.workflow_state <> 'deleted') AND "assignments"."workflow_state" = 'published' AND "assignments"."peer_reviews" = TRUE AND (assessor_asset.cached_due_date <= '2025-08-07 02:51:24.575195') AND (assessor_asset.cached_due_date > '2025-07-10 02:51:24.574990') LIMIT 100 [production:1 secondary]
[06cfbb7e77325750e2fc1a4a0572d628 800abef5-58bf-4c05-b104-9f19f294e737] Rendered courses/_to_do_list.html.erb (Duration: 392.7ms | Allocations: 45080) [cache miss]
[06cfbb7e77325750e2fc1a4a0572d628 800abef5-58bf-4c05-b104-9f19f294e737] Rendered shared/_event_list.html.erb (Duration: 3.7ms | Allocations: 1702)
[06cfbb7e77325750e2fc1a4a0572d628 800abef5-58bf-4c05-b104-9f19f294e737] Rendered shared/_event_list.html.erb (Duration: 3.2ms | Allocations: 1455)
[06cfbb7e77325750e2fc1a4a0572d628 800abef5-58bf-4c05-b104-9f19f294e737] SQL Account Load (0.7ms) SELECT "accounts".* FROM "public"."accounts" WHERE "accounts"."parent_account_id" = 1 AND (workflow_state<>'deleted') AND "accounts"."id" = 3 ORDER BY "accounts"."id" ASC LIMIT 1 [production:1 primary]
[06cfbb7e77325750e2fc1a4a0572d628 800abef5-58bf-4c05-b104-9f19f294e737] CACHE SQL Account Load (0.0ms) 1::WITH RECURSIVE t AS ( SELECT * FROM "public"."accounts" WHERE id=1 UNION SELECT accounts.* FROM "public"."accounts" INNER JOIN t ON accounts.id=t.parent_account_id ) SELECT * FROM t
[06cfbb7e77325750e2fc1a4a0572d628 54208b97-4a3e-4915-a38f-cab74be316f8] SQL Account Load (1.9ms) SELECT "accounts".* FROM "public"."accounts" WHERE "accounts"."id" = 1 LIMIT 1 [production:1 primary]
[06cfbb7e77325750e2fc1a4a0572d628 800abef5-58bf-4c05-b104-9f19f294e737] SQL AccountUser Load (0.8ms) SELECT "account_users".* FROM "public"."account_users" WHERE "account_users"."account_id" IN (3, 1, 2) AND "account_users"."user_id" = 1 AND "account_users"."workflow_state" != 'deleted' [production:1 primary]
[06cfbb7e77325750e2fc1a4a0572d628 800abef5-58bf-4c05-b104-9f19f294e737] SQL Role Load (0.7ms) SELECT "roles".* FROM "public"."roles" WHERE "roles"."id" = 17 LIMIT 1 [production:1 primary]
[06cfbb7e77325750e2fc1a4a0572d628 800abef5-58bf-4c05-b104-9f19f294e737] CACHE SQL Account Load (0.0ms) 1::SELECT "accounts".* FROM "public"."accounts" WHERE "accounts"."id" = 2 LIMIT 1
[06cfbb7e77325750e2fc1a4a0572d628 800abef5-58bf-4c05-b104-9f19f294e737] CACHE SQL FeatureFlag Load (0.0ms) 1::SELECT "feature_flags".* FROM "public"."feature_flags" WHERE "feature_flags"."context_id" = 2 AND "feature_flags"."context_type" = 'Account'
[06cfbb7e77325750e2fc1a4a0572d628 800abef5-58bf-4c05-b104-9f19f294e737] SQL FeatureFlag Load (0.5ms) SELECT "feature_flags".* FROM "public"."feature_flags" WHERE "feature_flags"."feature" = 'granular_permissions_manage_courses' AND "feature_flags"."context_type" = 'Account' AND "feature_flags"."context_id" = 1 ORDER BY "feature_flags"."id" ASC LIMIT 1 [production:1 primary]
[06cfbb7e77325750e2fc1a4a0572d628 800abef5-58bf-4c05-b104-9f19f294e737] SQL Role Load (0.5ms) SELECT "roles".* FROM "public"."roles" WHERE "roles"."id" = 9 LIMIT 1 [production:1 primary]
[06cfbb7e77325750e2fc1a4a0572d628 54208b97-4a3e-4915-a38f-cab74be316f8] SQL FeatureFlag Load (0.7ms) SELECT "feature_flags".* FROM "public"."feature_flags" WHERE "feature_flags"."context_id" = 1 AND "feature_flags"."context_type" = 'Account' [production:1 primary]
[06cfbb7e77325750e2fc1a4a0572d628 800abef5-58bf-4c05-b104-9f19f294e737] SQL Role Load (0.8ms) SELECT "roles".* FROM "public"."roles" WHERE "roles"."workflow_state" = 'built_in' AND "roles"."root_account_id" IN (1, 2) AND "roles"."base_role_type" = 'AccountAdmin' [production:1 primary]
[06cfbb7e77325750e2fc1a4a0572d628 54208b97-4a3e-4915-a38f-cab74be316f8] SQL Account Load (0.6ms) SELECT "accounts".* FROM "public"."accounts" WHERE "accounts"."id" = 2 LIMIT 1 [production:1 primary]
[06cfbb7e77325750e2fc1a4a0572d628 800abef5-58bf-4c05-b104-9f19f294e737] SQL (0.4ms) SELECT pg_is_in_recovery() [production:1 primary]
[06cfbb7e77325750e2fc1a4a0572d628 54208b97-4a3e-4915-a38f-cab74be316f8] SQL FeatureFlag Load (0.5ms) SELECT "feature_flags".* FROM "public"."feature_flags" WHERE "feature_flags"."context_id" = 2 AND "feature_flags"."context_type" = 'Account' [production:1 primary]
[06cfbb7e77325750e2fc1a4a0572d628 800abef5-58bf-4c05-b104-9f19f294e737] SQL RoleOverride Load (1.5ms) COPY (SELECT "role_overrides".* FROM "public"."role_overrides" WHERE "role_overrides"."role_id" IN (17, 9, 17) AND "role_overrides"."context_id" IN (3, 1, 2)) TO STDOUT [production:1 primary]
[06cfbb7e77325750e2fc1a4a0572d628 54208b97-4a3e-4915-a38f-cab74be316f8] SQL PluginSetting Load (1.0ms) SELECT "plugin_settings".* FROM "public"."plugin_settings" WHERE "plugin_settings"."name" = 'sessions' ORDER BY "plugin_settings"."id" ASC LIMIT 1 [production:1 primary]
[06cfbb7e77325750e2fc1a4a0572d628 54208b97-4a3e-4915-a38f-cab74be316f8] request throttling increment: [0,50.0,1753325484.6679,["client_identifier","user:10000000000001"],["count",0.0],["last_touched",null]]
[06cfbb7e77325750e2fc1a4a0572d628 800abef5-58bf-4c05-b104-9f19f294e737] CACHE SQL Account Load (0.0ms) 1::SELECT "accounts".* FROM "public"."accounts" WHERE "accounts"."parent_account_id" = 1 AND (workflow_state<>'deleted') AND "accounts"."id" = 3 ORDER BY "accounts"."id" ASC LIMIT 1
[06cfbb7e77325750e2fc1a4a0572d628 800abef5-58bf-4c05-b104-9f19f294e737] CACHE SQL Account Load (0.0ms) 1::WITH RECURSIVE t AS ( SELECT * FROM "public"."accounts" WHERE id=1 UNION SELECT accounts.* FROM "public"."accounts" INNER JOIN t ON accounts.id=t.parent_account_id ) SELECT * FROM t
[06cfbb7e77325750e2fc1a4a0572d628 800abef5-58bf-4c05-b104-9f19f294e737] CACHE SQL AccountUser Load (0.0ms) 1::SELECT "account_users".* FROM "public"."account_users" WHERE "account_users"."account_id" IN (3, 1, 2) AND "account_users"."user_id" = 1 AND "account_users"."workflow_state" != 'deleted'
[06cfbb7e77325750e2fc1a4a0572d628 800abef5-58bf-4c05-b104-9f19f294e737] CACHE SQL Role Load (0.1ms) 1::SELECT "roles".* FROM "public"."roles" WHERE "roles"."id" = 17 LIMIT 1
[06cfbb7e77325750e2fc1a4a0572d628 800abef5-58bf-4c05-b104-9f19f294e737] Rendered shared/_new_course_form.html.erb (Duration: 25.6ms | Allocations: 6303)
[06cfbb7e77325750e2fc1a4a0572d628 800abef5-58bf-4c05-b104-9f19f294e737] Rendered users/dashboard_sidebar.html.erb (Duration: 563.7ms | Allocations: 90707)
[06cfbb7e77325750e2fc1a4a0572d628 800abef5-58bf-4c05-b104-9f19f294e737] Completed 200 OK in 1415ms (Views: 516.6ms | ActiveRecord: 147.9ms | Allocations: 280477)
[06cfbb7e77325750e2fc1a4a0572d628 800abef5-58bf-4c05-b104-9f19f294e737] [STATSD] (sql_read: 96.00) (sql_write: 5.00) (sql_cache: 0.00) (active_record: 182.00) (cache_read: 209.00) (total: 1415.23) (view: 516.58) (db: 147.86)
[06cfbb7e77325750e2fc1a4a0572d628 800abef5-58bf-4c05-b104-9f19f294e737] [STAT] 963284 963284 0 0 1.067487 0.132031
[06cfbb7e77325750e2fc1a4a0572d628 800abef5-58bf-4c05-b104-9f19f294e737] request throttling increment: [1.215343953054667,-50.0,1753325484.687921,["client_identifier","user:10000000000001"],["count",50.0],["last_touched",1753325483.2213]]
[06cfbb7e77325750e2fc1a4a0572d628 800abef5-58bf-4c05-b104-9f19f294e737] Redis (0.407ms) evalsha - [redis://192.168.0.7:6379/0]
[06cfbb7e77325750e2fc1a4a0572d628 54208b97-4a3e-4915-a38f-cab74be316f8] Redis (0.712ms) evalsha - [redis://192.168.0.7:6379/0]
[06cfbb7e77325750e2fc1a4a0572d628 54208b97-4a3e-4915-a38f-cab74be316f8] Processing by ContentSharesController#unread_count as JSON
[06cfbb7e77325750e2fc1a4a0572d628 54208b97-4a3e-4915-a38f-cab74be316f8] Parameters: {"user_id"=>"self"}
[06cfbb7e77325750e2fc1a4a0572d628 54208b97-4a3e-4915-a38f-cab74be316f8] No separate files host specified for account id 1. This is a potential security risk.
[06cfbb7e77325750e2fc1a4a0572d628 54208b97-4a3e-4915-a38f-cab74be316f8] SQL SQL (4.9ms) SELECT "pseudonyms"."id" AS t0_r0, "pseudonyms"."user_id" AS t0_r1, "pseudonyms"."account_id" AS t0_r2, "pseudonyms"."workflow_state" AS t0_r3, "pseudonyms"."unique_id" AS t0_r4, "pseudonyms"."crypted_password" AS t0_r5, "pseudonyms"."password_salt" AS t0_r6, "pseudonyms"."persistence_token" AS t0_r7, "pseudonyms"."single_access_token" AS t0_r8, "pseudonyms"."perishable_token" AS t0_r9, "pseudonyms"."login_count" AS t0_r10, "pseudonyms"."failed_login_count" AS t0_r11, "pseudonyms"."last_request_at" AS t0_r12, "pseudonyms"."last_login_at" AS t0_r13, "pseudonyms"."current_login_at" AS t0_r14, "pseudonyms"."last_login_ip" AS t0_r15, "pseudonyms"."current_login_ip" AS t0_r16, "pseudonyms"."reset_password_token" AS t0_r17, "pseudonyms"."position" AS t0_r18, "pseudonyms"."created_at" AS t0_r19, "pseudonyms"."updated_at" AS t0_r20, "pseudonyms"."password_auto_generated" AS t0_r21, "pseudonyms"."deleted_at" AS t0_r22, "pseudonyms"."sis_batch_id" AS t0_r23, "pseudonyms"."sis_user_id" AS t0_r24, "pseudonyms"."sis_ssha" AS t0_r25, "pseudonyms"."communication_channel_id" AS t0_r26, "pseudonyms"."sis_communication_channel_id" AS t0_r27, "pseudonyms"."stuck_sis_fields" AS t0_r28, "pseudonyms"."integration_id" AS t0_r29, "pseudonyms"."authentication_provider_id" AS t0_r30, "pseudonyms"."declared_user_type" AS t0_r31, "users"."id" AS t1_r0, "users"."name" AS t1_r1, "users"."sortable_name" AS t1_r2, "users"."workflow_state" AS t1_r3, "users"."time_zone" AS t1_r4, "users"."uuid" AS t1_r5, "users"."created_at" AS t1_r6, "users"."updated_at" AS t1_r7, "users"."avatar_image_url" AS t1_r8, "users"."avatar_image_source" AS t1_r9, "users"."avatar_image_updated_at" AS t1_r10, "users"."phone" AS t1_r11, "users"."school_name" AS t1_r12, "users"."school_position" AS t1_r13, "users"."short_name" AS t1_r14, "users"."deleted_at" AS t1_r15, "users"."show_user_services" AS t1_r16, "users"."page_views_count" AS t1_r17, "users"."reminder_time_for_due_dates" AS t1_r18, "users"."reminder_time_for_grading" AS t1_r19, "users"."storage_quota" AS t1_r20, "users"."visible_inbox_types" AS t1_r21, "users"."last_user_note" AS t1_r22, "users"."subscribe_to_emails" AS t1_r23, "users"."features_used" AS t1_r24, "users"."preferences" AS t1_r25, "users"."avatar_state" AS t1_r26, "users"."locale" AS t1_r27, "users"."browser_locale" AS t1_r28, "users"."unread_conversations_count" AS t1_r29, "users"."stuck_sis_fields" AS t1_r30, "users"."public" AS t1_r31, "users"."otp_secret_key_enc" AS t1_r32, "users"."otp_secret_key_salt" AS t1_r33, "users"."otp_communication_channel_id" AS t1_r34, "users"."initial_enrollment_type" AS t1_r35, "users"."crocodoc_id" AS t1_r36, "users"."last_logged_out" AS t1_r37, "users"."lti_context_id" AS t1_r38, "users"."turnitin_id" AS t1_r39, "users"."lti_id" AS t1_r40, "users"."pronouns" AS t1_r41, "users"."root_account_ids" AS t1_r42, "users"."merged_into_user_id" AS t1_r43 FROM "public"."pseudonyms" LEFT OUTER JOIN "public"."users" ON "users"."id" = "pseudonyms"."user_id" WHERE "pseudonyms"."id" = 19 LIMIT 1 [production:1 primary]
[06cfbb7e77325750e2fc1a4a0572d628 54208b97-4a3e-4915-a38f-cab74be316f8] [AUTH] Approved Authlogic session
[06cfbb7e77325750e2fc1a4a0572d628 54208b97-4a3e-4915-a38f-cab74be316f8] [AUTH] inital load: pseud -> 19, user -> 1
[06cfbb7e77325750e2fc1a4a0572d628 54208b97-4a3e-4915-a38f-cab74be316f8] [AUTH] final user: 1
[06cfbb7e77325750e2fc1a4a0572d628 54208b97-4a3e-4915-a38f-cab74be316f8] SQL SQL (1.6ms) SELECT "users"."id" AS t0_r0, "users"."name" AS t0_r1, "users"."sortable_name" AS t0_r2, "users"."workflow_state" AS t0_r3, "users"."time_zone" AS t0_r4, "users"."uuid" AS t0_r5, "users"."created_at" AS t0_r6, "users"."updated_at" AS t0_r7, "users"."avatar_image_url" AS t0_r8, "users"."avatar_image_source" AS t0_r9, "users"."avatar_image_updated_at" AS t0_r10, "users"."phone" AS t0_r11, "users"."school_name" AS t0_r12, "users"."school_position" AS t0_r13, "users"."short_name" AS t0_r14, "users"."deleted_at" AS t0_r15, "users"."show_user_services" AS t0_r16, "users"."page_views_count" AS t0_r17, "users"."reminder_time_for_due_dates" AS t0_r18, "users"."reminder_time_for_grading" AS t0_r19, "users"."storage_quota" AS t0_r20, "users"."visible_inbox_types" AS t0_r21, "users"."last_user_note" AS t0_r22, "users"."subscribe_to_emails" AS t0_r23, "users"."features_used" AS t0_r24, "users"."preferences" AS t0_r25, "users"."avatar_state" AS t0_r26, "users"."locale" AS t0_r27, "users"."browser_locale" AS t0_r28, "users"."unread_conversations_count" AS t0_r29, "users"."stuck_sis_fields" AS t0_r30, "users"."public" AS t0_r31, "users"."otp_secret_key_enc" AS t0_r32, "users"."otp_secret_key_salt" AS t0_r33, "users"."otp_communication_channel_id" AS t0_r34, "users"."initial_enrollment_type" AS t0_r35, "users"."crocodoc_id" AS t0_r36, "users"."last_logged_out" AS t0_r37, "users"."lti_context_id" AS t0_r38, "users"."turnitin_id" AS t0_r39, "users"."lti_id" AS t0_r40, "users"."pronouns" AS t0_r41, "users"."root_account_ids" AS t0_r42, "users"."merged_into_user_id" AS t0_r43, "pseudonyms"."id" AS t1_r0, "pseudonyms"."user_id" AS t1_r1, "pseudonyms"."account_id" AS t1_r2, "pseudonyms"."workflow_state" AS t1_r3, "pseudonyms"."unique_id" AS t1_r4, "pseudonyms"."crypted_password" AS t1_r5, "pseudonyms"."password_salt" AS t1_r6, "pseudonyms"."persistence_token" AS t1_r7, "pseudonyms"."single_access_token" AS t1_r8, "pseudonyms"."perishable_token" AS t1_r9, "pseudonyms"."login_count" AS t1_r10, "pseudonyms"."failed_login_count" AS t1_r11, "pseudonyms"."last_request_at" AS t1_r12, "pseudonyms"."last_login_at" AS t1_r13, "pseudonyms"."current_login_at" AS t1_r14, "pseudonyms"."last_login_ip" AS t1_r15, "pseudonyms"."current_login_ip" AS t1_r16, "pseudonyms"."reset_password_token" AS t1_r17, "pseudonyms"."position" AS t1_r18, "pseudonyms"."created_at" AS t1_r19, "pseudonyms"."updated_at" AS t1_r20, "pseudonyms"."password_auto_generated" AS t1_r21, "pseudonyms"."deleted_at" AS t1_r22, "pseudonyms"."sis_batch_id" AS t1_r23, "pseudonyms"."sis_user_id" AS t1_r24, "pseudonyms"."sis_ssha" AS t1_r25, "pseudonyms"."communication_channel_id" AS t1_r26, "pseudonyms"."sis_communication_channel_id" AS t1_r27, "pseudonyms"."stuck_sis_fields" AS t1_r28, "pseudonyms"."integration_id" AS t1_r29, "pseudonyms"."authentication_provider_id" AS t1_r30, "pseudonyms"."declared_user_type" AS t1_r31 FROM "public"."users" LEFT OUTER JOIN "public"."pseudonyms" ON "pseudonyms"."user_id" = "users"."id" AND (pseudonyms.workflow_state<>'deleted') WHERE "users"."id" = 1 ORDER BY "users"."id" ASC LIMIT 1 [production:1 primary]
[06cfbb7e77325750e2fc1a4a0572d628 54208b97-4a3e-4915-a38f-cab74be316f8] SQL ReceivedContentShare Count (1.1ms) SELECT COUNT(*) FROM "public"."content_shares" WHERE "content_shares"."type" = 'ReceivedContentShare' AND "content_shares"."user_id" = 1 AND "content_shares"."read_state" = 'unread' [production:1 primary]
[06cfbb7e77325750e2fc1a4a0572d628 54208b97-4a3e-4915-a38f-cab74be316f8] Completed 200 OK in 143ms (Views: 1.2ms | ActiveRecord: 7.6ms | Allocations: 58485)
[06cfbb7e77325750e2fc1a4a0572d628 54208b97-4a3e-4915-a38f-cab74be316f8] [STATSD] (sql_read: 3.00) (sql_write: 0.00) (sql_cache: 0.00) (active_record: 4.00) (cache_read: 52.00) (total: 143.16) (view: 1.15) (db: 7.57)
[06cfbb7e77325750e2fc1a4a0572d628 54208b97-4a3e-4915-a38f-cab74be316f8] [STAT] 963384 963384 0 0 0.1839010000000001 0.03581099999999998
[06cfbb7e77325750e2fc1a4a0572d628 54208b97-4a3e-4915-a38f-cab74be316f8] request throttling increment: [0.1914689289922119,-50.0,1753325484.87764,["client_identifier","user:10000000000001"],["count",50.0],["last_touched",1753325484.6679]]
[06cfbb7e77325750e2fc1a4a0572d628 54208b97-4a3e-4915-a38f-cab74be316f8] Redis (0.436ms) evalsha - [redis://192.168.0.7:6379/0]
[06cfbb7e77325750e2fc1a4a0572d628 63f4b404-7f2a-4de8-9320-855b88911920] SQL ActiveRecord::SchemaMigration Pluck (1.0ms) SELECT "schema_migrations"."version" FROM "public"."schema_migrations" ORDER BY "schema_migrations"."version" ASC [production:1 primary]
[06cfbb7e77325750e2fc1a4a0572d628 63f4b404-7f2a-4de8-9320-855b88911920] SQL Account Load (1.2ms) SELECT "accounts".* FROM "public"."accounts" WHERE "accounts"."id" = 1 LIMIT 1 [production:1 primary]
[06cfbb7e77325750e2fc1a4a0572d628 63f4b404-7f2a-4de8-9320-855b88911920] SQL FeatureFlag Load (0.6ms) SELECT "feature_flags".* FROM "public"."feature_flags" WHERE "feature_flags"."context_id" = 1 AND "feature_flags"."context_type" = 'Account' [production:1 primary]
[06cfbb7e77325750e2fc1a4a0572d628 63f4b404-7f2a-4de8-9320-855b88911920] SQL Account Load (0.5ms) SELECT "accounts".* FROM "public"."accounts" WHERE "accounts"."id" = 2 LIMIT 1 [production:1 primary]
[06cfbb7e77325750e2fc1a4a0572d628 63f4b404-7f2a-4de8-9320-855b88911920] SQL FeatureFlag Load (0.4ms) SELECT "feature_flags".* FROM "public"."feature_flags" WHERE "feature_flags"."context_id" = 2 AND "feature_flags"."context_type" = 'Account' [production:1 primary]
[06cfbb7e77325750e2fc1a4a0572d628 63f4b404-7f2a-4de8-9320-855b88911920] SQL PluginSetting Load (0.7ms) SELECT "plugin_settings".* FROM "public"."plugin_settings" WHERE "plugin_settings"."name" = 'sessions' ORDER BY "plugin_settings"."id" ASC LIMIT 1 [production:1 primary]
[06cfbb7e77325750e2fc1a4a0572d628 63f4b404-7f2a-4de8-9320-855b88911920] request throttling increment: [0,50.0,1753325485.462976,["client_identifier","user:10000000000001"],["count",0.0],["last_touched",null]]
[06cfbb7e77325750e2fc1a4a0572d628 63f4b404-7f2a-4de8-9320-855b88911920] Redis (0.569ms) evalsha - [redis://192.168.0.7:6379/0]
[06cfbb7e77325750e2fc1a4a0572d628 63f4b404-7f2a-4de8-9320-855b88911920] Processing by CoursesController#activity_stream_summary as JSON
[06cfbb7e77325750e2fc1a4a0572d628 63f4b404-7f2a-4de8-9320-855b88911920] Parameters: {"course_id"=>"14"}
[06cfbb7e77325750e2fc1a4a0572d628 63f4b404-7f2a-4de8-9320-855b88911920] No separate files host specified for account id 1. This is a potential security risk.
[06cfbb7e77325750e2fc1a4a0572d628 63f4b404-7f2a-4de8-9320-855b88911920] SQL SQL (2.8ms) SELECT "pseudonyms"."id" AS t0_r0, "pseudonyms"."user_id" AS t0_r1, "pseudonyms"."account_id" AS t0_r2, "pseudonyms"."workflow_state" AS t0_r3, "pseudonyms"."unique_id" AS t0_r4, "pseudonyms"."crypted_password" AS t0_r5, "pseudonyms"."password_salt" AS t0_r6, "pseudonyms"."persistence_token" AS t0_r7, "pseudonyms"."single_access_token" AS t0_r8, "pseudonyms"."perishable_token" AS t0_r9, "pseudonyms"."login_count" AS t0_r10, "pseudonyms"."failed_login_count" AS t0_r11, "pseudonyms"."last_request_at" AS t0_r12, "pseudonyms"."last_login_at" AS t0_r13, "pseudonyms"."current_login_at" AS t0_r14, "pseudonyms"."last_login_ip" AS t0_r15, "pseudonyms"."current_login_ip" AS t0_r16, "pseudonyms"."reset_password_token" AS t0_r17, "pseudonyms"."position" AS t0_r18, "pseudonyms"."created_at" AS t0_r19, "pseudonyms"."updated_at" AS t0_r20, "pseudonyms"."password_auto_generated" AS t0_r21, "pseudonyms"."deleted_at" AS t0_r22, "pseudonyms"."sis_batch_id" AS t0_r23, "pseudonyms"."sis_user_id" AS t0_r24, "pseudonyms"."sis_ssha" AS t0_r25, "pseudonyms"."communication_channel_id" AS t0_r26, "pseudonyms"."sis_communication_channel_id" AS t0_r27, "pseudonyms"."stuck_sis_fields" AS t0_r28, "pseudonyms"."integration_id" AS t0_r29, "pseudonyms"."authentication_provider_id" AS t0_r30, "pseudonyms"."declared_user_type" AS t0_r31, "users"."id" AS t1_r0, "users"."name" AS t1_r1, "users"."sortable_name" AS t1_r2, "users"."workflow_state" AS t1_r3, "users"."time_zone" AS t1_r4, "users"."uuid" AS t1_r5, "users"."created_at" AS t1_r6, "users"."updated_at" AS t1_r7, "users"."avatar_image_url" AS t1_r8, "users"."avatar_image_source" AS t1_r9, "users"."avatar_image_updated_at" AS t1_r10, "users"."phone" AS t1_r11, "users"."school_name" AS t1_r12, "users"."school_position" AS t1_r13, "users"."short_name" AS t1_r14, "users"."deleted_at" AS t1_r15, "users"."show_user_services" AS t1_r16, "users"."page_views_count" AS t1_r17, "users"."reminder_time_for_due_dates" AS t1_r18, "users"."reminder_time_for_grading" AS t1_r19, "users"."storage_quota" AS t1_r20, "users"."visible_inbox_types" AS t1_r21, "users"."last_user_note" AS t1_r22, "users"."subscribe_to_emails" AS t1_r23, "users"."features_used" AS t1_r24, "users"."preferences" AS t1_r25, "users"."avatar_state" AS t1_r26, "users"."locale" AS t1_r27, "users"."browser_locale" AS t1_r28, "users"."unread_conversations_count" AS t1_r29, "users"."stuck_sis_fields" AS t1_r30, "users"."public" AS t1_r31, "users"."otp_secret_key_enc" AS t1_r32, "users"."otp_secret_key_salt" AS t1_r33, "users"."otp_communication_channel_id" AS t1_r34, "users"."initial_enrollment_type" AS t1_r35, "users"."crocodoc_id" AS t1_r36, "users"."last_logged_out" AS t1_r37, "users"."lti_context_id" AS t1_r38, "users"."turnitin_id" AS t1_r39, "users"."lti_id" AS t1_r40, "users"."pronouns" AS t1_r41, "users"."root_account_ids" AS t1_r42, "users"."merged_into_user_id" AS t1_r43 FROM "public"."pseudonyms" LEFT OUTER JOIN "public"."users" ON "users"."id" = "pseudonyms"."user_id" WHERE "pseudonyms"."id" = 19 LIMIT 1 [production:1 primary]
[06cfbb7e77325750e2fc1a4a0572d628 63f4b404-7f2a-4de8-9320-855b88911920] [AUTH] Approved Authlogic session
[06cfbb7e77325750e2fc1a4a0572d628 63f4b404-7f2a-4de8-9320-855b88911920] [AUTH] inital load: pseud -> 19, user -> 1
[06cfbb7e77325750e2fc1a4a0572d628 63f4b404-7f2a-4de8-9320-855b88911920] [AUTH] final user: 1
[06cfbb7e77325750e2fc1a4a0572d628 63f4b404-7f2a-4de8-9320-855b88911920] SQL Course Load (2.4ms) SELECT "courses".* FROM "public"."courses" WHERE "courses"."workflow_state" != 'deleted' AND "courses"."id" = 14 ORDER BY "courses"."id" ASC LIMIT 1 [production:1 secondary]
[06cfbb7e77325750e2fc1a4a0572d628 63f4b404-7f2a-4de8-9320-855b88911920] SQL Enrollment Load (3.1ms) SELECT "enrollments".* FROM "public"."enrollments" INNER JOIN "public"."enrollment_states" ON "enrollment_states"."enrollment_id" = "enrollments"."id" WHERE "enrollments"."course_id" = 14 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 secondary]
[06cfbb7e77325750e2fc1a4a0572d628 63f4b404-7f2a-4de8-9320-855b88911920] SQL Enrollment Exists (1.8ms) SELECT 1 AS one FROM "public"."enrollments" INNER JOIN "public"."enrollment_states" ON "enrollment_states"."enrollment_id" = "enrollments"."id" WHERE "enrollments"."course_id" = 14 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 primary]
[06cfbb7e77325750e2fc1a4a0572d628 63f4b404-7f2a-4de8-9320-855b88911920] SQL (1.5ms) SELECT COUNT(*) AS count_all, stream_items.asset_type AS stream_items_asset_type, stream_items.notification_category AS stream_items_notification_category, stream_item_instances.workflow_state AS stream_item_instances_workflow_state FROM "public"."stream_item_instances" INNER JOIN "public"."stream_items" ON "stream_items"."id" = "stream_item_instances"."stream_item_id" WHERE "stream_item_instances"."user_id" = 1 AND "stream_item_instances"."hidden" = FALSE AND "stream_item_instances"."context_type" = 'Course' AND "stream_item_instances"."context_id" = 14 GROUP BY "stream_items"."asset_type", "stream_items"."notification_category", "stream_item_instances"."workflow_state" [production:1 secondary]
[06cfbb7e77325750e2fc1a4a0572d628 63f4b404-7f2a-4de8-9320-855b88911920] SQL StreamItemInstance Pluck (0.6ms) SELECT "stream_item_instances"."stream_item_id" FROM "public"."stream_item_instances" WHERE "stream_item_instances"."user_id" = 1 AND "stream_item_instances"."hidden" = FALSE AND "stream_item_instances"."context_type" = 'Course' AND "stream_item_instances"."context_id" = 14 AND (stream_item_id > 10000000000000) ORDER BY stream_item_instances.id desc [production:1 secondary]
[06cfbb7e77325750e2fc1a4a0572d628 63f4b404-7f2a-4de8-9320-855b88911920] SQL Account Load (0.5ms) SELECT "accounts".* FROM "public"."accounts" WHERE "accounts"."id" = 3 LIMIT 1 [production:1 primary]
[06cfbb7e77325750e2fc1a4a0572d628 63f4b404-7f2a-4de8-9320-855b88911920] CACHE SQL Account Load (0.0ms) 1::SELECT "accounts".* FROM "public"."accounts" WHERE "accounts"."id" = 1 LIMIT 1
[06cfbb7e77325750e2fc1a4a0572d628 63f4b404-7f2a-4de8-9320-855b88911920] Completed 200 OK in 398ms (Views: 1.1ms | ActiveRecord: 19.8ms | Allocations: 93744)
[06cfbb7e77325750e2fc1a4a0572d628 63f4b404-7f2a-4de8-9320-855b88911920] [STATSD] (sql_read: 7.00) (sql_write: 0.00) (sql_cache: 0.00) (active_record: 8.00) (cache_read: 32.00) (total: 398.53) (view: 1.08) (db: 19.76)
[06cfbb7e77325750e2fc1a4a0572d628 63f4b404-7f2a-4de8-9320-855b88911920] [STAT] 963484 963484 0 0 0.22296700000000014 0.04042000000000001
[06cfbb7e77325750e2fc1a4a0572d628 63f4b404-7f2a-4de8-9320-855b88911920] request throttling increment: [0.2427231339884998,-50.0,1753325485.90751,["client_identifier","user:10000000000001"],["count",50.0],["last_touched",1753325485.463]]
[06cfbb7e77325750e2fc1a4a0572d628 63f4b404-7f2a-4de8-9320-855b88911920] Redis (0.404ms) evalsha - [redis://192.168.0.7:6379/0]
[06cfbb7e77325750e2fc1a4a0572d628 602ebae5-ca01-444c-aecb-41556a010bc3] SQL ActiveRecord::SchemaMigration Pluck (0.8ms) SELECT "schema_migrations"."version" FROM "public"."schema_migrations" ORDER BY "schema_migrations"."version" ASC [production:1 primary]
[06cfbb7e77325750e2fc1a4a0572d628 602ebae5-ca01-444c-aecb-41556a010bc3] SQL Account Load (1.5ms) SELECT "accounts".* FROM "public"."accounts" WHERE "accounts"."id" = 1 LIMIT 1 [production:1 primary]
[06cfbb7e77325750e2fc1a4a0572d628 602ebae5-ca01-444c-aecb-41556a010bc3] SQL FeatureFlag Load (1.0ms) SELECT "feature_flags".* FROM "public"."feature_flags" WHERE "feature_flags"."context_id" = 1 AND "feature_flags"."context_type" = 'Account' [production:1 primary]
[06cfbb7e77325750e2fc1a4a0572d628 602ebae5-ca01-444c-aecb-41556a010bc3] SQL Account Load (0.8ms) SELECT "accounts".* FROM "public"."accounts" WHERE "accounts"."id" = 2 LIMIT 1 [production:1 primary]
[06cfbb7e77325750e2fc1a4a0572d628 602ebae5-ca01-444c-aecb-41556a010bc3] SQL FeatureFlag Load (0.7ms) SELECT "feature_flags".* FROM "public"."feature_flags" WHERE "feature_flags"."context_id" = 2 AND "feature_flags"."context_type" = 'Account' [production:1 primary]
[06cfbb7e77325750e2fc1a4a0572d628 602ebae5-ca01-444c-aecb-41556a010bc3] SQL PluginSetting Load (1.0ms) SELECT "plugin_settings".* FROM "public"."plugin_settings" WHERE "plugin_settings"."name" = 'sessions' ORDER BY "plugin_settings"."id" ASC LIMIT 1 [production:1 primary]
[06cfbb7e77325750e2fc1a4a0572d628 602ebae5-ca01-444c-aecb-41556a010bc3] request throttling increment: [0,50.0,1753325489.566603,["client_identifier","user:10000000000001"],["count",0.0],["last_touched",null]]
[06cfbb7e77325750e2fc1a4a0572d628 602ebae5-ca01-444c-aecb-41556a010bc3] Redis (0.678ms) evalsha - [redis://192.168.0.7:6379/0]
[06cfbb7e77325750e2fc1a4a0572d628 602ebae5-ca01-444c-aecb-41556a010bc3] Processing by GraphQLController#execute as */*
[06cfbb7e77325750e2fc1a4a0572d628 602ebae5-ca01-444c-aecb-41556a010bc3] Parameters: {"operationName"=>"GetCourseModules", "variables"=>{"courseId"=>"14"}, "query"=>"query GetCourseModules($courseId: ID!) {\n course(id: $courseId) {\n modulesConnection {\n nodes {\n id: _id\n moduleItems {\n content {\n ... on Assignment {\n name\n _id\n peerReviews {\n anonymousReviews\n __typename\n }\n assessmentRequestsForCurrentUser {\n id: _id\n anonymousId\n available\n createdAt\n workflowState\n user {\n id: _id\n name\n __typename\n }\n anonymizedUser {\n id: _id\n name\n __typename\n }\n __typename\n }\n __typename\n }\n __typename\n }\n __typename\n }\n __typename\n }\n __typename\n }\n __typename\n }\n}\n"}
[06cfbb7e77325750e2fc1a4a0572d628 602ebae5-ca01-444c-aecb-41556a010bc3] No separate files host specified for account id 1. This is a potential security risk.
[06cfbb7e77325750e2fc1a4a0572d628 602ebae5-ca01-444c-aecb-41556a010bc3] SQL SQL (3.2ms) SELECT "pseudonyms"."id" AS t0_r0, "pseudonyms"."user_id" AS t0_r1, "pseudonyms"."account_id" AS t0_r2, "pseudonyms"."workflow_state" AS t0_r3, "pseudonyms"."unique_id" AS t0_r4, "pseudonyms"."crypted_password" AS t0_r5, "pseudonyms"."password_salt" AS t0_r6, "pseudonyms"."persistence_token" AS t0_r7, "pseudonyms"."single_access_token" AS t0_r8, "pseudonyms"."perishable_token" AS t0_r9, "pseudonyms"."login_count" AS t0_r10, "pseudonyms"."failed_login_count" AS t0_r11, "pseudonyms"."last_request_at" AS t0_r12, "pseudonyms"."last_login_at" AS t0_r13, "pseudonyms"."current_login_at" AS t0_r14, "pseudonyms"."last_login_ip" AS t0_r15, "pseudonyms"."current_login_ip" AS t0_r16, "pseudonyms"."reset_password_token" AS t0_r17, "pseudonyms"."position" AS t0_r18, "pseudonyms"."created_at" AS t0_r19, "pseudonyms"."updated_at" AS t0_r20, "pseudonyms"."password_auto_generated" AS t0_r21, "pseudonyms"."deleted_at" AS t0_r22, "pseudonyms"."sis_batch_id" AS t0_r23, "pseudonyms"."sis_user_id" AS t0_r24, "pseudonyms"."sis_ssha" AS t0_r25, "pseudonyms"."communication_channel_id" AS t0_r26, "pseudonyms"."sis_communication_channel_id" AS t0_r27, "pseudonyms"."stuck_sis_fields" AS t0_r28, "pseudonyms"."integration_id" AS t0_r29, "pseudonyms"."authentication_provider_id" AS t0_r30, "pseudonyms"."declared_user_type" AS t0_r31, "users"."id" AS t1_r0, "users"."name" AS t1_r1, "users"."sortable_name" AS t1_r2, "users"."workflow_state" AS t1_r3, "users"."time_zone" AS t1_r4, "users"."uuid" AS t1_r5, "users"."created_at" AS t1_r6, "users"."updated_at" AS t1_r7, "users"."avatar_image_url" AS t1_r8, "users"."avatar_image_source" AS t1_r9, "users"."avatar_image_updated_at" AS t1_r10, "users"."phone" AS t1_r11, "users"."school_name" AS t1_r12, "users"."school_position" AS t1_r13, "users"."short_name" AS t1_r14, "users"."deleted_at" AS t1_r15, "users"."show_user_services" AS t1_r16, "users"."page_views_count" AS t1_r17, "users"."reminder_time_for_due_dates" AS t1_r18, "users"."reminder_time_for_grading" AS t1_r19, "users"."storage_quota" AS t1_r20, "users"."visible_inbox_types" AS t1_r21, "users"."last_user_note" AS t1_r22, "users"."subscribe_to_emails" AS t1_r23, "users"."features_used" AS t1_r24, "users"."preferences" AS t1_r25, "users"."avatar_state" AS t1_r26, "users"."locale" AS t1_r27, "users"."browser_locale" AS t1_r28, "users"."unread_conversations_count" AS t1_r29, "users"."stuck_sis_fields" AS t1_r30, "users"."public" AS t1_r31, "users"."otp_secret_key_enc" AS t1_r32, "users"."otp_secret_key_salt" AS t1_r33, "users"."otp_communication_channel_id" AS t1_r34, "users"."initial_enrollment_type" AS t1_r35, "users"."crocodoc_id" AS t1_r36, "users"."last_logged_out" AS t1_r37, "users"."lti_context_id" AS t1_r38, "users"."turnitin_id" AS t1_r39, "users"."lti_id" AS t1_r40, "users"."pronouns" AS t1_r41, "users"."root_account_ids" AS t1_r42, "users"."merged_into_user_id" AS t1_r43 FROM "public"."pseudonyms" LEFT OUTER JOIN "public"."users" ON "users"."id" = "pseudonyms"."user_id" WHERE "pseudonyms"."id" = 19 LIMIT 1 [production:1 primary]
[06cfbb7e77325750e2fc1a4a0572d628 602ebae5-ca01-444c-aecb-41556a010bc3] [AUTH] Approved Authlogic session
[06cfbb7e77325750e2fc1a4a0572d628 602ebae5-ca01-444c-aecb-41556a010bc3] [AUTH] inital load: pseud -> 19, user -> 1
[06cfbb7e77325750e2fc1a4a0572d628 602ebae5-ca01-444c-aecb-41556a010bc3] [AUTH] final user: 1
[06cfbb7e77325750e2fc1a4a0572d628 602ebae5-ca01-444c-aecb-41556a010bc3] SQL TRANSACTION (0.8ms) BEGIN [production:1 primary]
[06cfbb7e77325750e2fc1a4a0572d628 602ebae5-ca01-444c-aecb-41556a010bc3] SQL (0.3ms) SET statement_timeout = 60000 [production:1 primary]
[06cfbb7e77325750e2fc1a4a0572d628 602ebae5-ca01-444c-aecb-41556a010bc3] SQL Course Load (1.7ms) SELECT "courses".* FROM "public"."courses" WHERE "courses"."id" = 14 [production:1 primary]
[06cfbb7e77325750e2fc1a4a0572d628 602ebae5-ca01-444c-aecb-41556a010bc3] SQL Enrollment Exists (2.1ms) SELECT 1 AS one FROM "public"."enrollments" INNER JOIN "public"."enrollment_states" ON "enrollment_states"."enrollment_id" = "enrollments"."id" WHERE "enrollments"."course_id" = 14 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 primary]
[06cfbb7e77325750e2fc1a4a0572d628 602ebae5-ca01-444c-aecb-41556a010bc3] SQL ContextModule Load (1.1ms) SELECT "context_modules".* FROM "public"."context_modules" WHERE "context_modules"."context_id" = 14 AND "context_modules"."context_type" = 'Course' AND (context_modules.workflow_state<>'deleted') ORDER BY "context_modules"."position" ASC, "context_modules"."id" ASC, name [production:1 primary]
[06cfbb7e77325750e2fc1a4a0572d628 602ebae5-ca01-444c-aecb-41556a010bc3] SQL Enrollment Load (1.3ms) SELECT enrollments.*, enrollment_states.state AS date_based_state_in_db FROM "public"."enrollments" INNER JOIN "public"."enrollment_states" ON "enrollment_states"."enrollment_id" = "enrollments"."id" WHERE "enrollments"."course_id" = 14 AND (enrollments.workflow_state<>'deleted') AND "enrollments"."user_id" = 1 AND "enrollment_states"."restricted_access" = FALSE AND (enrollment_states.state IN ('active', 'invited', 'pending_invited', 'pending_active')) AND "enrollments"."type" IN ('TeacherEnrollment', 'TaEnrollment', 'DesignerEnrollment', 'StudentViewEnrollment') [production:1 primary]
[06cfbb7e77325750e2fc1a4a0572d628 602ebae5-ca01-444c-aecb-41556a010bc3] SQL Role Load (1.7ms) SELECT "roles".* FROM "public"."roles" WHERE "roles"."id" = 12 LIMIT 1 [production:1 secondary]
[06cfbb7e77325750e2fc1a4a0572d628 602ebae5-ca01-444c-aecb-41556a010bc3] SQL Account Load (7.5ms) WITH RECURSIVE t AS ( SELECT * FROM "public"."accounts" WHERE id=3 UNION SELECT accounts.* FROM "public"."accounts" INNER JOIN t ON accounts.id=t.parent_account_id ) SELECT * FROM t [production:1 secondary]
[06cfbb7e77325750e2fc1a4a0572d628 602ebae5-ca01-444c-aecb-41556a010bc3] SQL Role Load (1.0ms) SELECT "roles".* FROM "public"."roles" WHERE "roles"."workflow_state" = 'built_in' AND "roles"."root_account_id" = 1 AND "roles"."base_role_type" = 'TeacherEnrollment' [production:1 secondary]
[06cfbb7e77325750e2fc1a4a0572d628 602ebae5-ca01-444c-aecb-41556a010bc3] SQL RoleOverride Load (2.0ms) COPY (SELECT "role_overrides".* FROM "public"."role_overrides" WHERE "role_overrides"."role_id" IN (12, 12) AND "role_overrides"."context_id" IN (3, 1)) TO STDOUT [production:1 secondary]
[06cfbb7e77325750e2fc1a4a0572d628 602ebae5-ca01-444c-aecb-41556a010bc3] SQL ContentTag Load (1.8ms) SELECT "content_tags".* FROM "public"."content_tags" WHERE "content_tags"."context_module_id" = 47 AND (content_tags.workflow_state<>'deleted') ORDER BY content_tags.position, content_tags.title [production:1 secondary]
[06cfbb7e77325750e2fc1a4a0572d628 602ebae5-ca01-444c-aecb-41556a010bc3] SQL WikiPage Load (1.4ms) SELECT "wiki_pages".* FROM "public"."wiki_pages" WHERE "wiki_pages"."id" = 717 [production:1 primary]
[06cfbb7e77325750e2fc1a4a0572d628 602ebae5-ca01-444c-aecb-41556a010bc3] SQL TRANSACTION (0.7ms) COMMIT [production:1 primary]
[06cfbb7e77325750e2fc1a4a0572d628 602ebae5-ca01-444c-aecb-41556a010bc3] Completed 200 OK in 540ms (Views: 1.2ms | ActiveRecord: 37.2ms | Allocations: 142363)
[06cfbb7e77325750e2fc1a4a0572d628 602ebae5-ca01-444c-aecb-41556a010bc3] [STATSD] (sql_read: 10.00) (sql_write: 3.00) (sql_cache: 0.00) (active_record: 12.00) (cache_read: 69.00) (total: 540.32) (view: 1.24) (db: 37.23)
[06cfbb7e77325750e2fc1a4a0572d628 602ebae5-ca01-444c-aecb-41556a010bc3] [STAT] 963584 1031172 67588 0 0.32711899999999994 0.09374699999999997
[06cfbb7e77325750e2fc1a4a0572d628 602ebae5-ca01-444c-aecb-41556a010bc3] request throttling increment: [0.3643528789999484,-50.0,1753325490.156284,["client_identifier","user:10000000000001"],["count",50.0],["last_touched",1753325489.5666]]
[06cfbb7e77325750e2fc1a4a0572d628 602ebae5-ca01-444c-aecb-41556a010bc3] Redis (0.379ms) evalsha - [redis://192.168.0.7:6379/0]
[- -] Shutting down background worker
[- -] Killing session flusher
[- -] Shutting down background worker
[- -] Killing session flusher
[- -] Shutting down background worker
[- -] Killing session flusher
[- -] Shutting down background worker
[- -] Killing session flusher
[- -] Shutting down background worker
[- -] Killing session flusher
Kindly anyone help me to debug and resolve this issue. Thanks in advance.
Andrey Gangan
Aug 12, 2025, 12:06:12 PMAug 12
to Canvas LMS Users
did you update recently?
it can be caused by some feature settings or incorrect complied assets.
try nuke_node.sh from scripts folder
четверг, 24 июля 2025 г. в 06:08:47 UTC+3, lucifer:
Reply all
Reply to author
Forward
0 new messages