Investigate malformed databases during upgrades

learningequality / kolibri-installer-debian

Kolibri installer source for Debian

MIT License

1 stars 8 forks source link

Investigate malformed databases during upgrades #58

Closed benjaoming closed 4 years ago

benjaoming commented 5 years ago

Again, we see people experiencing a malformed database from an upgrade:

https://community.learningequality.org/t/sqlite3-integrityerror-unique-constraint-failed-logger-masterylog-id/1010/3

benjaoming commented 4 years ago

Too much has happened since this was opened. Both related to concurrent DB access in Kolibri and related to starting / stopping the system service.

Filing community forum message for archiving:

I was concerned because the sqlite3.IntegrityError, as when upgrading to 0.11.1 the database was corrupted and had to use the commands I was prompted in the systemctl status kolibri report. After running commands (sorry do not remember commands exactly) the server was able to start normally.