zhudyos / duic Goto Github PK

java -Dspring.profiles.active=postgresql -jar duic-2.3.2-beta.jar

|_ _ . (_) .' ___ | | | . \ __ _ __ / .' _|
| | | |[ | | | [ || |
| |.' / | _/ |, | |\ .___.'\ |______.' '.__.'_/[___].____ .'
:: duic :: (v2.3.2-beta)

2019-02-02 22:01:47,049 INFO i.z.d.server.Application$Companion - Starting Application.Companion v2.3.2-beta on ubuntu with PID 16816 (/home/bill/Downloads/duic-2.3.2-beta.jar started by bill in /home/bill/Downloads)
2019-02-02 22:01:47,051 INFO i.z.d.server.Application$Companion - The following profiles are active: postgresql
2019-02-02 22:01:48,588 INFO o.s.c.a.ConfigurationClassEnhancer - @bean method Application.kotlinPropertyConfigurer is non-static and returns an object assignable to Spring's BeanFactoryPostProcessor interface. This will result in a failure to process annotations such as @Autowired, @resource and @PostConstruct within the method's declaring @configuration class. Add the 'static' modifier to this method to avoid these container lifecycle issues; see @bean javadoc for complete details.
2019-02-02 22:01:49,695 INFO com.zaxxer.hikari.HikariDataSource - HikariPool-1 - Starting...
2019-02-02 22:01:50,279 INFO com.zaxxer.hikari.HikariDataSource - HikariPool-1 - Start completed.
2019-02-02 22:01:55,034 INFO o.s.s.c.ThreadPoolTaskScheduler - Initializing ExecutorService 'taskScheduler'
2019-02-02 22:01:55,379 INFO o.s.b.w.e.netty.NettyWebServer - Netty started on port(s): 7777
2019-02-02 22:01:55,391 INFO i.z.d.server.Application$Companion - Started Application.Companion in 9.799 seconds (JVM running for 10.636)
2019-02-02 22:01:55,581 ERROR reactor.core.scheduler.Schedulers - Scheduler worker in group main failed with an uncaught exception
reactor.core.Exceptions$ErrorCallbackNotImplemented: org.springframework.jdbc.BadSqlGrammarException: PreparedStatementCallback; bad SQL grammar [SELECT VERSION() AS 'version']; nested exception is org.postgresql.util.PSQLException: ERROR: syntax error at or near "'version'"
Position: 21
Caused by: org.springframework.jdbc.BadSqlGrammarException: PreparedStatementCallback; bad SQL grammar [SELECT VERSION() AS 'version']; nested exception is org.postgresql.util.PSQLException: ERROR: syntax error at or near "'version'"
Position: 21
at org.springframework.jdbc.support.SQLErrorCodeSQLExceptionTranslator.doTranslate(SQLErrorCodeSQLExceptionTranslator.java:234)
at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:72)
at org.springframework.jdbc.core.JdbcTemplate.translateException(JdbcTemplate.java:1444)
at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:632)
at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:669)
at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:694)
at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:748)
at org.springframework.jdbc.core.namedparam.NamedParameterJdbcTemplate.queryForObject(NamedParameterJdbcTemplate.java:235)
at org.springframework.jdbc.core.namedparam.NamedParameterJdbcTemplate.queryForObject(NamedParameterJdbcTemplate.java:244)
at org.springframework.jdbc.core.namedparam.NamedParameterJdbcTemplate.queryForMap(NamedParameterJdbcTemplate.java:272)
at io.zhudy.duic.repository.impl.PostgreSQLServerRepository$findDbVersion$1$v$1.doInTransaction(PostgreSQLServerRepository.kt:112)
at io.zhudy.duic.repository.impl.PostgreSQLServerRepository$findDbVersion$1$v$1.doInTransaction(PostgreSQLServerRepository.kt:34)
at org.springframework.transaction.support.TransactionTemplate.execute(TransactionTemplate.java:140)
at io.zhudy.duic.repository.impl.PostgreSQLServerRepository$findDbVersion$1.accept(PostgreSQLServerRepository.kt:111)
at io.zhudy.duic.repository.impl.PostgreSQLServerRepository$findDbVersion$1.accept(PostgreSQLServerRepository.kt:34)
at reactor.core.publisher.MonoCreate.subscribe(MonoCreate.java:53)
at reactor.core.publisher.MonoOnAssembly.subscribe(MonoOnAssembly.java:61)
at reactor.core.publisher.Mono.subscribe(Mono.java:3695)
at reactor.core.publisher.MonoSubscribeOn$SubscribeOnSubscriber.run(MonoSubscribeOn.java:123)
at reactor.core.scheduler.WorkerTask.call(WorkerTask.java:84)
at reactor.core.scheduler.WorkerTask.call(WorkerTask.java:37)
at java.base/java.util.concurrent.FutureTask.run(FutureTask.java:264)
at java.base/java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(ScheduledThreadPoolExecutor.java:304)
at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1128)
at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:628)
at java.base/java.lang.Thread.run(Thread.java:834)
Suppressed: reactor.core.publisher.FluxOnAssembly$OnAssemblyException:
Assembly trace from producer [reactor.core.publisher.MonoCreate] :
reactor.core.publisher.Mono.create(Mono.java:183)
io.zhudy.duic.repository.impl.PostgreSQLServerRepository.findDbVersion(PostgreSQLServerRepository.kt:110)
Error has been observed by the following operator(s):
|_ Mono.create ⇢ io.zhudy.duic.repository.impl.PostgreSQLServerRepository.findDbVersion(PostgreSQLServerRepository.kt:110)
|_ Mono.subscribeOn ⇢ io.zhudy.duic.repository.impl.PostgreSQLServerRepository.findDbVersion(PostgreSQLServerRepository.kt:116)

Caused by: org.postgresql.util.PSQLException: ERROR: syntax error at or near "'version'"
Position: 21
at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2433)
at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:2178)
at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:306)
at org.postgresql.jdbc.PgStatement.executeInternal(PgStatement.java:441)
at org.postgresql.jdbc.PgStatement.execute(PgStatement.java:365)
at org.postgresql.jdbc.PgPreparedStatement.executeWithFlags(PgPreparedStatement.java:155)
at org.postgresql.jdbc.PgPreparedStatement.executeQuery(PgPreparedStatement.java:118)
at com.zaxxer.hikari.pool.ProxyPreparedStatement.executeQuery(ProxyPreparedStatement.java:52)
at com.zaxxer.hikari.pool.HikariProxyPreparedStatement.executeQuery(HikariProxyPreparedStatement.java)
at org.springframework.jdbc.core.JdbcTemplate$1.doInPreparedStatement(JdbcTemplate.java:678)
at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:617)
... 22 common frames omitted
2019-02-02 22:01:58,398 INFO o.s.s.c.ThreadPoolTaskScheduler - Shutting down ExecutorService 'taskScheduler'
2019-02-02 22:01:58,402 INFO com.zaxxer.hikari.HikariDataSource - HikariPool-1 - Shutdown initiated...
2019-02-02 22:01:58,431 ERROR io.zhudy.duic.service.ServerService - unregister 服务失败: ubuntu:7777
org.springframework.transaction.CannotCreateTransactionException: Could not open JDBC Connection for transaction; nested exception is java.lang.NullPointerException
at org.springframework.jdbc.datasource.DataSourceTransactionManager.doBegin(DataSourceTransactionManager.java:305)
at org.springframework.transaction.support.AbstractPlatformTransactionManager.getTransaction(AbstractPlatformTransactionManager.java:378)
at org.springframework.transaction.support.TransactionTemplate.execute(TransactionTemplate.java:137)
at io.zhudy.duic.repository.impl.PostgreSQLServerRepository$register$1.accept(PostgreSQLServerRepository.kt:41)
at io.zhudy.duic.repository.impl.PostgreSQLServerRepository$register$1.accept(PostgreSQLServerRepository.kt:34)
at reactor.core.publisher.MonoCreate.subscribe(MonoCreate.java:53)
at reactor.core.publisher.MonoOnAssembly.subscribe(MonoOnAssembly.java:61)
at reactor.core.publisher.Mono.subscribe(Mono.java:3695)
at reactor.core.publisher.MonoSubscribeOn$SubscribeOnSubscriber.run(MonoSubscribeOn.java:123)
at reactor.core.scheduler.WorkerTask.call(WorkerTask.java:84)
at reactor.core.scheduler.WorkerTask.call(WorkerTask.java:37)
at java.base/java.util.concurrent.FutureTask.run(FutureTask.java:264)
at java.base/java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(ScheduledThreadPoolExecutor.java:304)
at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1128)
at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:628)
at java.base/java.lang.Thread.run(Thread.java:834)
Suppressed: reactor.core.publisher.FluxOnAssembly$OnAssemblyException:
Assembly trace from producer [reactor.core.publisher.MonoCreate] :
reactor.core.publisher.Mono.create(Mono.java:183)
io.zhudy.duic.repository.impl.PostgreSQLServerRepository.register(PostgreSQLServerRepository.kt:40)
Error has been observed by the following operator(s):
|_ Mono.create ⇢ io.zhudy.duic.repository.impl.PostgreSQLServerRepository.register(PostgreSQLServerRepository.kt:40)
|_ Mono.subscribeOn ⇢ io.zhudy.duic.repository.impl.PostgreSQLServerRepository.register(PostgreSQLServerRepository.kt:52)

Caused by: java.lang.NullPointerException: null
at com.zaxxer.hikari.pool.HikariProxyConnection.getAutoCommit(HikariProxyConnection.java)
at org.springframework.jdbc.datasource.DataSourceTransactionManager.doBegin(DataSourceTransactionManager.java:278)
... 15 common frames omitted
2019-02-02 22:01:58,440 INFO com.zaxxer.hikari.HikariDataSource - HikariPool-1 - Shutdown completed.

增加 /api/info 接口用于获取服务信息。

在启动前检查必要的参数配置。

如未配置 spring.data.mongo.uri 参数时，提供更加明确的错误信息。

请不要在该 issue 提交任何问题, 谢谢配合

CORS 请求返回 403 错误

添加应用 name/profile 中有空格，导致修改配置不成功

请问一下配置实时更新的实现,是通过client实时发送http请求根据state的值判断是否重载来实现的么

启动服务过程中中止进程， schema 更新 lock 未回滚。

支持 Oracle 存储配置

Admin Console 控制改版，提供更便捷的操作方式，提升更具观赏性的界面。

1. 支持打开多个配置编辑窗口
2. 全新 DARK 主题
3. 优化 JS 加载方式，提高访问速度

数据库连接失败，给予用户明确的错误信息反馈。目前信息很笼统，用户无法明确了解数据库错误的异常。

https://www.2339.com

我使用的是duic 2.2.2版本和MySQL 部署，但是在启动日志中会出现死锁的提示。如下：
2019-02-16 16:27:53,729 ERROR reactor.core.scheduler.Schedulers - Scheduler worker in group main failed with an uncaught exception
reactor.core.Exceptions$ErrorCallbackNotImplemented: org.springframework.dao.DeadlockLoserDataAccessException: PreparedStatementCallback; SQL [DELETE FROM DUIC_SERVER WHERE ACTIVE_AT<=?(conn=109) Deadlock found when trying to get lock; try restarting transaction; nested exception is java.sql.SQLTransactionRollbackException: (conn=109) Deadlock found when trying to get lock; try restarting transaction
Caused by: org.springframework.dao.DeadlockLoserDataAccessException: PreparedStatementCallback; SQL [DELETE FROM DUIC_SERVER WHERE ACTIVE_AT<=?(conn=109) Deadlock found when trying to get lock; try restarting transaction; nested exception is java.sql.SQLTransactionRollbackException: (conn=109) Deadlock found when trying to get lock; try restarting transaction
at org.springframework.jdbc.support.SQLErrorCodeSQLExceptionTranslator.doTranslate(SQLErrorCodeSQLExceptionTranslator.java:266)
at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:72)
at org.springframework.jdbc.core.JdbcTemplate.translateException(JdbcTemplate.java:1402)
at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:620)
at org.springframework.jdbc.core.JdbcTemplate.update(JdbcTemplate.java:850)
at org.springframework.jdbc.core.JdbcTemplate.update(JdbcTemplate.java:871)
at org.springframework.jdbc.core.namedparam.NamedParameterJdbcTemplate.update(NamedParameterJdbcTemplate.java:317)
at org.springframework.jdbc.core.namedparam.NamedParameterJdbcTemplate.update(NamedParameterJdbcTemplate.java:322)
at io.zhudy.duic.repository.impl.MySQLServerRepository$clean$1$n$1.doInTransaction(MySQLServerRepository.kt:93)
at io.zhudy.duic.repository.impl.MySQLServerRepository$clean$1$n$1.doInTransaction(MySQLServerRepository.kt:33)
at org.springframework.transaction.support.TransactionTemplate.execute(TransactionTemplate.java:140)
at io.zhudy.duic.repository.impl.MySQLServerRepository$clean$1.accept(MySQLServerRepository.kt:92)
at io.zhudy.duic.repository.impl.MySQLServerRepository$clean$1.accept(MySQLServerRepository.kt:33)
at reactor.core.publisher.MonoCreate.subscribe(MonoCreate.java:54)
at reactor.core.publisher.MonoOnAssembly.subscribe(MonoOnAssembly.java:76)
at reactor.core.publisher.Mono.subscribe(Mono.java:3080)
at reactor.core.publisher.MonoSubscribeOn$SubscribeOnSubscriber.run(MonoSubscribeOn.java:123)
at reactor.core.scheduler.WorkerTask.call(WorkerTask.java:84)
at reactor.core.scheduler.WorkerTask.call(WorkerTask.java:37)
at java.util.concurrent.FutureTask.run(FutureTask.java:266)
at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.access$201(ScheduledThreadPoolExecutor.java:180)
at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(ScheduledThreadPoolExecutor.java:293)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
at java.lang.Thread.run(Thread.java:748)
Suppressed: reactor.core.publisher.FluxOnAssembly$OnAssemblyException:
Assembly trace from producer [reactor.core.publisher.MonoCreate] :
reactor.core.publisher.Mono.create(Mono.java:172)
io.zhudy.duic.repository.impl.MySQLServerRepository.clean(MySQLServerRepository.kt:91)
io.zhudy.duic.service.ServerService.clockPing(ServerService.kt:77)
org.springframework.scheduling.support.ScheduledMethodRunnable.run(ScheduledMethodRunnable.java:84)
org.springframework.scheduling.support.DelegatingErrorHandlingRunnable.run(DelegatingErrorHandlingRunnable.java:54)
java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511)
java.util.concurrent.FutureTask.runAndReset(FutureTask.java:308)
Error has been observed by the following operator(s):
|_ Mono.create(MySQLServerRepository.kt:91)
|_ Mono.subscribeOn(ServerService.kt:78)

Caused by: java.sql.SQLTransactionRollbackException: (conn=109) Deadlock found when trying to get lock; try restarting transaction
at org.mariadb.jdbc.internal.util.exceptions.ExceptionMapper.get(ExceptionMapper.java:179)
at org.mariadb.jdbc.internal.util.exceptions.ExceptionMapper.getException(ExceptionMapper.java:110)
at org.mariadb.jdbc.MariaDbStatement.executeExceptionEpilogue(MariaDbStatement.java:228)
at org.mariadb.jdbc.MariaDbPreparedStatementServer.executeInternal(MariaDbPreparedStatementServer.java:382)
at org.mariadb.jdbc.MariaDbPreparedStatementServer.execute(MariaDbPreparedStatementServer.java:344)
at org.mariadb.jdbc.MariaDbPreparedStatementServer.executeUpdate(MariaDbPreparedStatementServer.java:331)
at com.zaxxer.hikari.pool.ProxyPreparedStatement.executeUpdate(ProxyPreparedStatement.java:61)
at com.zaxxer.hikari.pool.HikariProxyPreparedStatement.executeUpdate(HikariProxyPreparedStatement.java)
at org.springframework.jdbc.core.JdbcTemplate.lambda$update$0(JdbcTemplate.java:855)
at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:605)
... 21 common frames omitted
Caused by: java.sql.SQLException: Deadlock found when trying to get lock; try restarting transaction
Query is: DELETE FROM DUIC_SERVER WHERE ACTIVE_AT<=?, parameters ['2019-02-16 16:25:53.725']
at org.mariadb.jdbc.internal.util.LogQueryTool.exceptionWithQuery(LogQueryTool.java:153)
at org.mariadb.jdbc.internal.protocol.AbstractQueryProtocol.executePreparedQuery(AbstractQueryProtocol.java:971)
at org.mariadb.jdbc.MariaDbPreparedStatementServer.executeInternal(MariaDbPreparedStatementServer.java:376)
... 27 common frames omitted

启动配置增加默认扫描 /etc/duic 目录中的配置文件。

目前启动配置扫描的配置在工作目录下的 config 在不同的目录下启动 duic 时需要用户手动设置 user.dir 造成不必要的困扰。现提供固定的配置目录扫描，降低部署的成本，提高应用统一性。

如题

支持 PostgreSQL 存储配置

增加 /api/health 接口，用于检查服务可用状态。

第一次启动自动创建表之后，由于我的mysql数据库是InnoDB，不支持FULLTEXT，所以手动将 DUIC_APP表的引擎改成了MyISAM，再次启动服务时就报以下错误说表DUIC_APP已存在，已存在难道就不能再启动？

Reason: liquibase.exception.DatabaseException: (conn=139828) Table 'DUIC_APP' already exists [Failed SQL: CREATE TABLE configcenter.DUIC_APP (ID INT AUTO_INCREMENT NOT NULL, NAME VARCHAR(64) NOT NULL COMMENT '应用名称', PROFILE VARCHAR(64) NOT NULL COMMENT '应用环境', DESCRIPTION VARCHAR(1024) NOT NULL COMMENT '应用描述', TOKEN VARCHAR(64) NULL COMMENT '访问令牌', IP_LIMIT VARCHAR(1024) NULL COMMENT '可访问 IP', V INT NOT NULL COMMENT '应用版本', CREATED_AT timestamp NULL COMMENT '创建时间', UPDATED_AT timestamp NULL COMMENT '修改时间', CONTENT LONGTEXT NULL COMMENT '应用配置内容', USERS VARCHAR(1024) NULL COMMENT '应用所属用户', CONSTRAINT PK_DUIC_APP PRIMARY KEY (ID))]
at org.springframework.boot.web.reactive.context.ReactiveWebServerApplicationContext.onRefresh(ReactiveWebServerApplicationContext.java:76)
at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:544)
at org.springframework.boot.web.reactive.context.ReactiveWebServerApplicationContext.refresh(ReactiveWebServerApplicationContext.java:61)
at org.springframework.boot.SpringApplication.refresh(SpringApplication.java:762)
at org.springframework.boot.SpringApplication.refreshContext(SpringApplication.java:398)
at org.springframework.boot.SpringApplication.run(SpringApplication.java:330)
at io.zhudy.duic.server.Application$Companion.main(Application.kt:67)
at io.zhudy.duic.server.Application.main(Application.kt)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:498)
at org.springframework.boot.loader.MainMethodRunner.run(MainMethodRunner.java:48)
at org.springframework.boot.loader.Launcher.launch(Launcher.java:87)
at org.springframework.boot.loader.Launcher.launch(Launcher.java:50)
at org.springframework.boot.loader.JarLauncher.main(JarLauncher.java:51)

一点建议，dev级别支持克隆：
-- 应用
|
-- dev（令牌）[config1,config2...]
|
--test（令牌）[config1,config2...]
|
--online（令牌）[config1,config2...]

在 firefox 中配置编辑器一直闪烁