elukey edited a comment on issue #8808: superset db upgrade returns foreign key constraint is incorrectly formed URL: https://github.com/apache/incubator-superset/issues/8808#issuecomment-608537354 I "solved" this issue following @ayushbilala's suggestion, namely appending`DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci` at the end of the CREATE TABLE SQL command (manually executed on the db). the charset/collate is a combination of what I found in the other tables referenced by the foreign keys. Edit: sqlalchemy fails to upgrade because the table is already there, so this part is still open. Edit 2: I have altered the db schema with DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci` and now db upgrade works.
---------------------------------------------------------------- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. For queries about this service, please contact Infrastructure at: [email protected] With regards, Apache Git Services --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
