Database migration

[Wattana Pattanagul]

Hi,

I have canvas LMS running self-hosted since 2022. Until last night, the system got corrupted. I managed to install the system to a new host, with a newer canvas version due to OS and dependencies. I try to import the old database to the new system, but some pages like Assignment, Settings, etc showed "Page Error". Is there anyway I can migrate the old database to the new system without having to go to incremental upgrade the system. Please help since a lot of faculties and students are depending on it.

Thanks,

Wattana

[Cody Cutrer]

No. You need to install and run migrations from quarterly historical releases of Canvas.

Cody Cutrer

Software Engineer

Instructure

--

---
You received this message because you are subscribed to the Google Groups "Canvas LMS Users" group.
To unsubscribe from this group and stop receiving emails from it, send an email to canvas-lms-use...@googlegroups.com.
To view this discussion visit https://groups.google.com/d/msgid/canvas-lms-users/2b175128-300a-4568-94aa-50a9c4ef30d6n%40googlegroups.com.

[Wattana Pattanagul]

Thank Cody. Do I need to set up canvas lms to a fully-function system before running db:migrate or can I clone the source code and run db:migrate from command line?

[Cody Cutrer]

You’ll need to have `bundle install` and enough configuration set up for connecting to the database and probably security.yml. But no need to compile assets for the front end.

Cody Cutrer

Software Engineer

Instructure

To view this discussion visit https://groups.google.com/d/msgid/canvas-lms-users/ad43d4d6-3213-4f14-a0b1-0f91e0689c60n%40googlegroups.com.

[Wattana Pattanagul]

Thanks Cody. It works! I managed to incrementally update the database as you suggest and plug it into the new system. Also I moved /tmp/files from the old system to the new system. Now everything seems to work perfectly, except when I tried to use speedgrader, it won't show up and displayed a running circle asking me to wait indefinitely. Do you have any idea what I did wrong?

Wattana

[Cody Cutrer]

Wattana,

Not with that amount of information. I would suggest looking at browser requests, browser console, and server logs for specific errors.

Cody Cutrer

Software Engineer

Instructure

To view this discussion visit https://groups.google.com/d/msgid/canvas-lms-users/f8a3a04f-8f2d-4d84-b180-57b88844c85an%40googlegroups.com.

[Wattana Pattanagul]

Cody,

Thanks! I managed to fix the issue, which was caused by the Redis configuration. The problem I’m facing now is that after migrating the old database in 3-month increments to the current version, when students click on the “Grades” page, it shows page errors. In addition, when trying to access the Learning Mastery Gradebook, it displays the message “There was an error fetching outcome results.”

Could it be that I missed a database migration step? The system was working fine with the initial database, so I don’t think the issue is with the system itself. Do you have any advice on where I could look for information to fix this?

Anyway, you’ve been a great help — thank you again.

Wattana