EricGao888 commented on issue #9628: URL: https://github.com/apache/dolphinscheduler/issues/9628#issuecomment-1104656446
> > 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? I upgraded soft_version to 3.0.0, cleaned up and recompiled project and still have the second issue. Not sure whether I missed any steps. Anyway I will try again to confirm this. -- 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: [email protected] For queries about this service, please contact Infrastructure at: [email protected]
