[Bug] docker compose fail from branch 'dev'

[wellCh4n]

Search before asking

• I had searched in the issues and found no similar issues.

What happened

Execute the Docker Compose build command

docker-compose up -d

It seems to be missing a sql file named 'final.sql'. I found the same file from another branch.
Link is: https://github.com/apache/incubator-streampark/blob/1.2.3-release/streamx-console/streamx-console-service/src/assembly/script/final.sql

I compared the 'final.sql' with '/streampark-console/streampark-console-service/src/assembly/script/schema/mysql-schema.sql'. They look the same, should I copy mysql-schema content to final.sql OR update mysql's DockerFile?

StreamPark Version

branch dev

Java Version

openjdk 11

Flink Version

1.14.5

Scala Version of Flink

2.12

Error Exception

Creating network "docker_default" with the default driver
Creating volume "docker_mysql-data" with default driver
Creating volume "docker_flink1.14.5" with default driver
Building database
[+] Building 3.3s (6/6) FINISHED
 => [internal] load build definition from Dockerfile                                                                                                                                                                                     0.1s
 => => transferring dockerfile: 1.16kB                                                                                                                                                                                                   0.0s
 => [internal] load .dockerignore                                                                                                                                                                                                        0.1s
 => => transferring context: 2B                                                                                                                                                                                                          0.0s
 => [internal] load metadata for docker.io/biarms/mysql:5.7                                                                                                                                                                              3.0s
 => [internal] load build context                                                                                                                                                                                                        0.0s
 => => transferring context: 337B                                                                                                                                                                                                        0.0s
 => CANCELED [1/2] FROM docker.io/biarms/mysql:5.7@sha256:b39d533d02e6b8f7bf61e9f884b99b6560a106d812eb1a24ca7a842f8334b5a2                                                                                                               0.1s
 => => resolve docker.io/biarms/mysql:5.7@sha256:b39d533d02e6b8f7bf61e9f884b99b6560a106d812eb1a24ca7a842f8334b5a2                                                                                                                        0.0s
 => => sha256:87e408fb202281a63754ed23780eea349c06f83f3911920411174ec8b6cb5cf7 3.04kB / 3.04kB                                                                                                                                           0.0s
 => => sha256:babd77b9be8d7948c4ccc09d185074fcf522ef1cbc3a6a640b32d672380bf84f 10.15kB / 10.15kB                                                                                                                                         0.0s
 => => sha256:b39d533d02e6b8f7bf61e9f884b99b6560a106d812eb1a24ca7a842f8334b5a2 1.11kB / 1.11kB                                                                                                                                           0.0s
 => ERROR [2/2] COPY streampark-console/streampark-console-service/src/assembly/script/final.sql /docker-entrypoint-initdb.d/01-streampark.sql                                                                                           0.0s
------
 > [2/2] COPY streampark-console/streampark-console-service/src/assembly/script/final.sql /docker-entrypoint-initdb.d/01-streampark.sql:
------
failed to compute cache key: "/streampark-console/streampark-console-service/src/assembly/script/final.sql" not found: not found
ERROR: Service 'database' failed to build : Build failed

Screenshots

No response

Are you willing to submit PR?

• Yes I am willing to submit a PR!

Code of Conduct

• I agree to follow this project's Code of Conduct

[wolfboys]

/cc @MonsterChenzhuo PTAL

[wellCh4n]

@wolfboys @MonsterChenzhuo I found schema and data sql file in /streampark-console/streampark-console-service/src/assembly/script. Should fix DockerFile, I guess. Could I commit PR for this?

[MonsterChenzhuo]

@wellCh4n The problem with this piece is that streampark supports multiple data sources this pr, the changes that come with it, and thus the problems that arise.The default is to use h2, I think the mysql part inside docker-compose can be removed? You can try to do modify. modify docker-compse and remove the mysql part. Get it running, make sure it's okay, and I'll review the pr for you.

[wellCh4n]

@MonsterChenzhuo Remove mysql part inside docker-compose is not a good idea in my opinion. Cuz Dockerfile is a fast mode for beginner.
Could we provide multiple docker-compose.yml for this project?

[wellCh4n]

I had committed PR, its a quickly solution for this problem.
We need do something after fix it if we wanna support multiple data source.