[GitHub] [dolphinscheduler] SbloodyS commented on issue #9628: [Bug] [DAO] Dev branch database initialization failure

[GitBox <gi...@apache.org>]

SbloodyS commented on issue #9628:
URL: https://github.com/apache/dolphinscheduler/issues/9628#issuecomment-1104654475

   > Some wired issues appeared when I tried to fix this. It took me quite some time to figure out what was really going on here.
   > 
   > Actually, db initialization failure is not directly caused by outdated `soft_version`. There are two main reasons:
   > 
   > 1. `create-schema.sh` is outdated and some paths in it are incorrect, failing to get correct db type. https://github.com/apache/dolphinscheduler/blob/239be31ab732f5bbe68fca3033245125e8388657/dolphinscheduler-tools/src/main/bin/create-schema.sh#L22-L27
   > 2. SQL scripts in `dolphinscheduler-dao/src/main/resources/sql/upgrade/2.1.0_schema` causes a few duplicate key and duplicate index error. https://github.com/apache/dolphinscheduler/blob/239be31ab732f5bbe68fca3033245125e8388657/dolphinscheduler-dao/src/main/resources/sql/upgrade/2.1.0_schema/mysql/dolphinscheduler_ddl.sql#L18-L30
   
   I don't think the second problem will appear after the upgrade soft_version to 3.0.0. Can you give it a try?


-- 
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.

To unsubscribe, e-mail: commits-unsubscribe@dolphinscheduler.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org