Issue with Database Migration After Reinstallation

Site Operators
,
1

Hello Open edX Community,

I’m encountering an issue with database migration after performing a reinstallation of the MySQL database for my Open edX setup.

Steps Taken:

  1. I deleted the directory and volume where the MySQL data was stored as suggested.
  2. I reinstalled the MySQL database to ensure a fresh start.
  3. The database connection issue has been resolved, and I can now access the database.

Current Issue:

Despite the resolution of the database connection issue, it seems that the data migration was not successfully executed. The database is currently empty, and no tables are present.

Additionally, when I check the logs for the backend service lms, I encounter the following error:

django.db.utils.ProgrammingError: (1146, “Table ‘openedx.waffle_switch’ doesn’t exist”)

Request for Assistance:

Could anyone provide guidance on how to ensure that all necessary database migrations are correctly applied? I need to verify that the database schema is set up properly for Open edX to function as expected.

Thank you for your assistance!!

2

You deleted the volumes without creating a back-up?

3

Could you please let me know which version of Tutor you are trying to install?"

Try to run this command based on tutor version. This will migrate the mysql database and create tables.

  • tutor local launch
    or
  • tutor local quickstart