The Seafile CE server on Ubuntu 16.04.2 was running version 6.0.9 with no prior issues. The upgrade to version 6.1.1 was attempted but incurred this error in the process:
This script would upgrade your seafile server from 6.0 to 6.1
Press [ENTER] to contiune
Updating seafile/seahub database …
[INFO] You are using MySQL
[INFO] updating seahub database…
[ERROR] Failed to execute sql: REFERENCES command denied to user ‘seafile’@‘localhost’ for table ‘institutions_institution’
Failed to upgrade your database
The server originated at version 4.0 and has received every minor and incremental upgrade through versions 4, 5 and 6.0 to this, 6.1.1, seemingly without a problem. Operationally no problems have been found or reported. The MySQL user seafile is the same as described in the manual (https://manual.seafile.com/deploy/using_mysql.html) and was created and tested manually. It is the user found in all Seafile config files.
Restoring from backup the upgrade was retried after elevating the MySQL user’s privileges. The upgrade completed successfully only after the user’s privileges were elevated to essentially root levels, after which they were restored back down again for server operation.
Anyone have any ideas why this error was encountered? Is this a database problem, a script error? I am concerned about future upgrades and the overall ‘health’ of the MySQL server.