HTTP 500 Error when Creating Assignment (AWS S3 Deployed)

[tonylabs]

Summary:

Folks, I was trying to create an assignment but the Canvas test instance hosted locally always return response_code: 500. Please help.

Steps to reproduce:

1. AWS S3 storage configured
2. Attachment uploaded correctly
3. Create assignment without submission type

Expected behavior:

Assignment created

Actual behavior:

response_code: 500 request_id: 8fb79264-4d81-404e-b1a0-2b5eba809566 session_id: 6adf889a0429577c4f9680b9f51efce0 meta_headers: o=assignments_api;n=create;t=Course;i=7; format: !ruby/object:Mime::Type synonyms:

• text/x-json

• application/jsonrequest symbol: :json string: application/json hash: 925650144571346338 HTTP_ACCEPT: application/json, text/javascript, application/json+canvas-string-ids, /; q=0.01 HTTP_ACCEPT_ENCODING: gzip, deflate, br HTTP_HOST: dev.canvas.local HTTP_REFERER: https://dev.canvas.local/courses/7/assignments/new?submission_types=none&name=Test&due_at=2023-10-26T15%3A59%3A59.000Z&points_possible=10&assignment_group_id=6 HTTP_USER_AGENT: Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/17.0 Safari/605.1.15 PATH_INFO: "/api/v1/courses/7/assignments" QUERY_STRING: "?" REQUEST_METHOD: POST REQUEST_URI: https://dev.canvas.local/api/v1/courses/7/assignments SERVER_NAME: dev.canvas.local SERVER_PORT: ''443'' SERVER_PROTOCOL: HTTP/1.1 REMOTE_ADDR: 114.86.62.121 path_parameters: ''{:format=>"json", :controller=>"assignments_api", :action=>"create", :course_id=>"7"}'' query_parameters: "{}" request_parameters: ''{"assignment"=>{"due_at"=>"2023-10-26T15:59:59.000Z", "points_possible"=>10, "assignment_group_id"=>"6", "post_to_sis"=>false, "graders_anonymous_to_graders"=>false, "grader_comments_visible_to_graders"=>true, "grader_names_visible_to_final_grader"=>true, "annotatable_attachment_id"=>"", "secure_params"=>"eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJsdGlfYXNzaWdubWVudF9pZCI6IjgwOGYyYTIzLThkMjYtNGM4Yi1iM2I5LTcxNjIwNDgxMDUzYiIsImx0aV9hc3NpZ25tZW50X2Rlc2NyaXB0aW9uIjpudWxsfQ.ROHvbd673j5wBGjEYnyNkQHeVA6j-_Mnex3r78i3SJw", "lti_context_id"=>nil, "course_id"=>"7", "name"=>"Test", "submission_types"=>["none"], "has_submitted_submissions"=>false, "due_date_required"=>false, "max_name_length"=>255, "allowed_attempts"=>"5", "in_closed_grading_period"=>false, "graded_submissions_exist"=>false, "omit_from_final_grade"=>"0", "hide_in_gradebook"=>false, "is_quiz_assignment"=>false, "can_duplicate"=>true, "original_course_id"=>nil, "original_assignment_id"=>nil, "original_lti_resource_link_id"=>nil, "original_assignment_name"=>nil, "original_quiz_id"=>nil, "workflow_state"=>"unpublished", "important_dates"=>false, "assignment_overrides"=>[], "publishable"=>true, "hidden"=>false, "unpublishable"=>true, "grading_type"=>"points", "submission_type"=>"none", "allowed_extensions"=>["jpg", " docx"], "only_visible_to_overrides"=>false, "description"=>"", "grading_standard_id"=>"", "turnitin_enabled"=>"0", "vericite_enabled"=>"0", "external_tool_tag_attributes"=>{"external_data"=>"", "custom_params"=>"", "line_item"=>"", "link_settings"=>{"selection_width"=>"", "selection_height"=>""}, "url"=>"", "content_type"=>"", "content_id"=>"", "new_tab"=>"0"}, "similarityDetectionTool"=>"None", "configuration_tool_type"=>"", "grade_group_students_individually"=>false, "group_category_id"=>nil, "peer_reviews"=>"0", "automatic_peer_reviews"=>"0", "peer_review_count"=>0, "peer_reviews_assign_at"=>nil, "intra_group_peer_reviews"=>"0", "anonymous_peer_reviews"=>"0", "notify_of_update"=>"0", "lock_at"=>nil, "unlock_at"=>nil}}'' exception_message: |- undefined method `-'' for nil:NilClass

  where("number <= ?", maximum(:number) - versions_to_keep).each(&:destroy) ^ hostname: canvas pid: 1705 ', 'NoMethodError') RETURNING "id" [production:1 primary] [6adf889a0429577c4f9680b9f51efce0 8fb79264-4d81-404e-b1a0-2b5eba809566] SQL TRANSACTION (0.7ms) COMMIT [production:1 primary] [6adf889a0429577c4f9680b9f51efce0 8fb79264-4d81-404e-b1a0-2b5eba809566] Created ErrorReport ID 10000000000065 [6adf889a0429577c4f9680b9f51efce0 8fb79264-4d81-404e-b1a0-2b5eba809566]

[CANVAS_ERRORS] EXCEPTION LOG NoMethodError (undefined method `-' for nil:NilClass

  where("number <= ?", maximum(:number) - versions_to_keep).each(&:destroy)

Additional notes:

[tonylabs]

Issue got fixed by downgrade PostgreSQL from 14 to 12.