Problem
When upgrade_db.sh is run, it fails with
ERROR 1050 (42S01) at line 1: Table 'permission_fks' already exists
Abort, /home/datameer/current/upgrade_transformed/20180323151720/upgrade-6.0.0-DAP_26040.sql fails!
Cause
The table was introduced in an older version of Datameer for future use, but was not implemented in release 5.x
The script upgrade-6.0.0-DAP_26040.sql contains a statement CREATE TABLE permission_fks If the table exists
prior to the upgrade, the script can't create it again, so it fails.
Solution
Drop that table using the command: DROP TABLE permission_fks and rerun the upgrade script.
Comments
0 comments
Please sign in to leave a comment.