powerjob 最新版本 4.3.6 之后的版本 需要添加一个新的参数 --oms.storage.dfs.mysql_series.url

[baisui1981]

官方（PowerJobServerApplication v4.3.8）也有一个一样的错误 PowerJob/PowerJob#835

2024-03-02 00:10:14.545  INFO 7 --- [           main] t.p.s.c.s.c.PropertyAndOneBeanCondition  : [PropertyAndOneBeanCondition] [MySqlSeriesCondition] bean of type[DFsService] exist check result: false
2024-03-02 00:10:14.548  INFO 7 --- [           main] t.p.s.c.s.c.PropertyAndOneBeanCondition  : [PropertyAndOneBeanCondition] [AliOssCondition] check any config exist result with keys=[oms.storage.dfs.alioss.endpoint]: false
2024-03-02 00:10:14.551  INFO 7 --- [           main] t.p.s.c.s.c.PropertyAndOneBeanCondition  : [PropertyAndOneBeanCondition] [MinioOssCondition] check any config exist result with keys=[oms.storage.dfs.minio.endpoint]: false
2024-03-02 00:10:14.552  INFO 7 --- [           main] t.p.s.c.s.c.PropertyAndOneBeanCondition  : [PropertyAndOneBeanCondition] [EmptyCondition] check any config exist result with keys=null: true
2024-03-02 00:10:14.555  INFO 7 --- [           main] t.p.s.p.s.AbstractDFsService             : [DFsService] invoke [tech.powerjob.server.persistence.storage.impl.MySqlSeriesDfsService]'s constructor
2024-03-02 00:10:14.556  INFO 7 --- [           main] t.p.s.p.s.AbstractDFsService             : [DFsService] invoke [tech.powerjob.server.persistence.storage.impl.MySqlSeriesDfsService]'s setApplicationContext
2024-03-02 00:10:14.557  INFO 7 --- [           main] t.p.s.p.s.i.MySqlSeriesDfsService        : [MySqlSeriesDfsService] init datasource by config: MySqlSeriesDfsService.MySQLProperty(driver=com.mysql.cj.jdbc.Driver, url=jdbc:mysql://localhost:3306/powerjob-daily?useUnicode=true&characterEncoding=UTF-8&serverTimezone=Asia/Shanghai, username=root, password=No1Bug2Please3!, autoCreateTable=true)
2024-03-02 00:10:15.029  INFO 7 --- [           main] c.z.h.HikariDataSource                   : HikariPool-1 - Starting...
2024-03-02 00:10:16.356 ERROR 7 --- [           main] c.z.h.p.HikariPool                       : HikariPool-1 - Exception during pool initialization.

由于没有配置
MySQLProperty(driver=com.mysql.cj.jdbc.Driver, url=jdbc:mysql://localhost:3306/powerjob-daily?useUnicode=true&characterEncoding=UTF-8&serverTimezone=Asia/Shanghai, username=root, password=No1Bug2Please3!, autoCreateTable=true), 最终会报错。

2024-03-02 00:10:14.438  INFO 7 --- [           main] t.p.s.c.s.c.PropertyAndOneBeanCondition  : [PropertyAndOneBeanCondition] [MySqlSeriesCondition] check any config exist result with keys=[oms.storage.dfs.mysql_series.url]: true
2024-03-02 00:10:14.545  INFO 7 --- [           main] t.p.s.c.s.c.PropertyAndOneBeanCondition  : [PropertyAndOneBeanCondition] [MySqlSeriesCondition] bean of type[DFsService] exist check result: false
2024-03-02 00:10:14.548  INFO 7 --- [           main] t.p.s.c.s.c.PropertyAndOneBeanCondition  : [PropertyAndOneBeanCondition] [AliOssCondition] check any config exist result with keys=[oms.storage.dfs.alioss.endpoint]: false
2024-03-02 00:10:14.551  INFO 7 --- [           main] t.p.s.c.s.c.PropertyAndOneBeanCondition  : [PropertyAndOneBeanCondition] [MinioOssCondition] check any config exist result with keys=[oms.storage.dfs.minio.endpoint]: false
2024-03-02 00:10:14.552  INFO 7 --- [           main] t.p.s.c.s.c.PropertyAndOneBeanCondition  : [PropertyAndOneBeanCondition] [EmptyCondition] check any config exist result with keys=null: true
2024-03-02 00:10:14.555  INFO 7 --- [           main] t.p.s.p.s.AbstractDFsService             : [DFsService] invoke [tech.powerjob.server.persistence.storage.impl.MySqlSeriesDfsService]'s constructor
2024-03-02 00:10:14.556  INFO 7 --- [           main] t.p.s.p.s.AbstractDFsService             : [DFsService] invoke [tech.powerjob.server.persistence.storage.impl.MySqlSeriesDfsService]'s setApplicationContext
2024-03-02 00:10:14.557  INFO 7 --- [           main] t.p.s.p.s.i.MySqlSeriesDfsService        : [MySqlSeriesDfsService] init datasource by config: MySqlSeriesDfsService.MySQLProperty(driver=com.mysql.cj.jdbc.Driver, url=jdbc:mysql://localhost:3306/powerjob-daily?useUnicode=true&characterEncoding=UTF-8&serverTimezone=Asia/Shanghai, username=root, password=No1Bug2Please3!, autoCreateTable=true)
2024-03-02 00:10:15.029  INFO 7 --- [           main] c.z.h.HikariDataSource                   : HikariPool-1 - Starting...
2024-03-02 00:10:16.356 ERROR 7 --- [           main] c.z.h.p.HikariPool                       : HikariPool-1 - Exception during pool initialization.
2024-03-02 01:39:12.728  INFO 7 --- [           main] t.p.s.PowerJobServerApplication          : Starting PowerJobServerApplication v4.3.8 using Java 1.8.0_292 on powerjob-server-tqnxs with PID 7 (/powerjob-server.jar started by root in /)
2024-03-02 01:39:12.729 DEBUG 7 --- [           main] t.p.s.PowerJobServerApplication          : Running with Spring Boot v2.7.18, Spring v5.3.31
2024-03-02 01:39:12.731  INFO 7 --- [           main] t.p.s.PowerJobServerApplication          : The following 1 profile is active: "daily"
2024-03-02 01:39:17.024  INFO 7 --- [           main] .s.d.r.c.RepositoryConfigurationDelegate : Bootstrapping Spring Data JPA repositories in DEFAULT mode.
2024-03-02 01:39:17.329  INFO 7 --- [           main] .s.d.r.c.RepositoryConfigurationDelegate : Finished Spring Data repository scanning in 280 ms. Found 10 JPA repository interfaces.
2024-03-02 01:39:17.330  INFO 7 --- [           main] .s.d.r.c.RepositoryConfigurationDelegate : Bootstrapping Spring Data JPA repositories in DEFAULT mode.
2024-03-02 01:39:17.338  INFO 7 --- [           main] .s.d.r.c.RepositoryConfigurationDelegate : Finished Spring Data repository scanning in 8 ms. Found 1 JPA repository interfaces.
2024-03-02 01:39:17.361  INFO 7 --- [           main] t.p.s.c.s.c.PropertyAndOneBeanCondition  : [PropertyAndOneBeanCondition] [GridFsCondition] check any config exist result with keys=[spring.data.mongodb.uri, oms.storage.dfs.mongodb.uri]: false
2024-03-02 01:39:17.365  INFO 7 --- [           main] t.p.s.c.s.c.PropertyAndOneBeanCondition  : [PropertyAndOneBeanCondition] [MySqlSeriesCondition] check any config exist result with keys=[oms.storage.dfs.mysql_series.url]: true
2024-03-02 01:39:17.612  INFO 7 --- [           main] t.p.s.c.s.c.PropertyAndOneBeanCondition  : [PropertyAndOneBeanCondition] [MySqlSeriesCondition] bean of type[DFsService] exist check result: false
2024-03-02 01:39:17.617  INFO 7 --- [           main] t.p.s.c.s.c.PropertyAndOneBeanCondition  : [PropertyAndOneBeanCondition] [AliOssCondition] check any config exist result with keys=[oms.storage.dfs.alioss.endpoint]: false
2024-03-02 01:39:17.623  INFO 7 --- [           main] t.p.s.c.s.c.PropertyAndOneBeanCondition  : [PropertyAndOneBeanCondition] [MinioOssCondition] check any config exist result with keys=[oms.storage.dfs.minio.endpoint]: false
2024-03-02 01:39:17.627  INFO 7 --- [           main] t.p.s.c.s.c.PropertyAndOneBeanCondition  : [PropertyAndOneBeanCondition] [EmptyCondition] check any config exist result with keys=null: true
2024-03-02 01:39:17.637  INFO 7 --- [           main] t.p.s.p.s.AbstractDFsService             : [DFsService] invoke [tech.powerjob.server.persistence.storage.impl.MySqlSeriesDfsService]'s constructor
2024-03-02 01:39:17.638  INFO 7 --- [           main] t.p.s.p.s.AbstractDFsService             : [DFsService] invoke [tech.powerjob.server.persistence.storage.impl.MySqlSeriesDfsService]'s setApplicationContext
2024-03-02 01:39:17.641  INFO 7 --- [           main] t.p.s.p.s.i.MySqlSeriesDfsService        : [MySqlSeriesDfsService] init datasource by config: MySqlSeriesDfsService.MySQLProperty(driver=com.mysql.cj.jdbc.Driver, url=jdbc:mysql://localhost:3306/powerjob-daily?useUnicode=true&characterEncoding=UTF-8&serverTimezone=Asia/Shanghai, username=root, password=No1Bug2Please3!, autoCreateTable=true)
2024-03-02 01:39:18.079  INFO 7 --- [           main] c.z.h.HikariDataSource                   : HikariPool-1 - Starting...
2024-03-02 01:39:19.370 ERROR 7 --- [           main] c.z.h.p.HikariPool                       : HikariPool-1 - Exception during pool initialization.

启动过程会轮训：MySqlSeriesCondition，AliOssCondition，EmptyCondition，最终会创建一个默认的MySqlSeriesDfsService