安装datakit 6.0,运行后提示relation “sys_setting” does not exist on gaussdb为什么?
部署环境为windows docker部署172.17.0.3为openGauss极简版
很多表都没有,而且我并没有使用gaussdb
datakit的 application-tem.yml如下
system:
# File storage path
defaultStoragePath: /datakit-server/files
# Whitelist control switch
whitelist:
enabled: false
file:
encoding=UTF-8:
server:
port: 9494
ssl:
key-store: /datakit-server/ssl/keystore.p12
key-store-password: 123456
key-store-type: PKCS12
enabled: true
servlet:
context-path: /
logging:
file:
path: /datakit-server/logs/
spring:
datasource:
type: com.alibaba.druid.pool.DruidDataSource
# For openGauss
driver-class-name: org.opengauss.Driver
url: jdbc:opengauss://172.17.0.3:5432/datakit?currentSchema=public&batchMode=off&characterEncoding=utf-8&allowEncodingChanges=true
username: datakit
password: WoDe@1234
# For Intarkdb
# driver-class-name: org.intarkdb.IntarkdbJDBC
# url: jdbc:intarkdb:data/datakit
druid:
test-while-idle: true
test-on-borrow: true
validation-query: “select 1”
validation-query-timeout: 10000
connection-error-retry-attempts: 0
break-after-acquire-failure: true
max-wait: 300000
keep-alive: true
max-active: 30
min-evictable-idle-time-millis: 600000
management:
server:
port: 9494
plugins:
oauth-login:
# A unique identifier obtained by registering with DevKit
client-id: your_client_id
# A secret key paired with the client_id
client-secret: your_client_secret
datakit-url: https://ip:port
devkit-url: https://ip:port
# SSL certificate
ssl-key: your_ssl_key
运行jar如下
java -Xms1024m -Xmx2048m -jar /datakit-server/openGauss-datakit-6.0.0.jar --spring.profiles.active=temp
执行后,datakit中创建表如下
部分运行日志如下
ava -Xms1024m -Xmx2048m -jar /datakit-server/openGauss-datakit-6.0.0.jar --spring.profiles.active=temp
Application Version: ${system.version}
Spring Boot Version:
2026-06-06 08:43:47 [main] [com.gitee.starblues.loader.launcher.SpringMainProdBootstrap]-[INFO] Starting SpringMainProdBootstrap v6.0.0 using Java 11.0.2 on 0e6c4827eaef with PID 1413 (/datakit-server/openGauss-datakit-6.0.0.jar started by root in /datakit-server)
2026-06-06 08:43:47 [main] [com.gitee.starblues.loader.launcher.SpringMainProdBootstrap]-[INFO] The following profiles are active: temp
2026-06-06 08:43:47 [background-preinit] [org.hibernate.validator.internal.util.Version]-[INFO] HV000001: Hibernate Validator null
2026-06-06 08:43:59 [main] [org.springframework.context.support.PostProcessorRegistrationDelegate$BeanPostProcessorChecker]-[INFO] Bean ‘org.springframework.security.access.expression.method.DefaultMethodSecurityExpressionHandler@5ea502e0’ of type [org.springframework.security.access.expression.method.DefaultMethodSecurityExpressionHandler] is not eligible for getting processed by all BeanPostProcessors (for example: not eligible for auto-proxying)
2026-06-06 08:43:59 [main] [org.springframework.context.support.PostProcessorRegistrationDelegate$BeanPostProcessorChecker]-[INFO] Bean ‘methodSecurityMetadataSource’ of type [org.springframework.security.access.method.DelegatingMethodSecurityMetadataSource] is not eligible for getting processed by all BeanPostProcessors (for example: not eligible for auto-proxying)
2026-06-06 08:44:00 [main] [org.springframework.boot.web.embedded.tomcat.TomcatWebServer]-[INFO] Tomcat initialized with port(s): 9494 (https)
2026-06-06 08:44:00 [main] [org.apache.coyote.http11.Http11NioProtocol]-[INFO] Initializing ProtocolHandler [“https-jsse-nio-9494”]
2026-06-06 08:44:00 [main] [org.apache.catalina.core.StandardService]-[INFO] Starting service [Tomcat]
2026-06-06 08:44:00 [main] [org.apache.catalina.core.StandardEngine]-[INFO] Starting Servlet engine: [Apache Tomcat/9.0.54]
2026-06-06 08:44:00 [main] [org.apache.catalina.core.ContainerBase.[Tomcat].[localhost].[/]]-[INFO] Initializing Spring embedded WebApplicationContext
2026-06-06 08:44:00 [main] [org.springframework.boot.web.servlet.context.ServletWebServerApplicationContext]-[INFO] Root WebApplicationContext: initialization completed in 13174 ms
2026-06-06 08:44:01 [main] [com.alibaba.druid.spring.boot.autoconfigure.DruidDataSourceAutoConfigure]-[INFO] Init DruidDataSource
2026-06-06 08:44:02 [main] [com.alibaba.druid.pool.DruidDataSource]-[INFO] {dataSource-1} inited
2026-06-06 08:44:03 [main] [com.baomidou.mybatisplus.core.injector.DefaultSqlInjector]-[WARN] class org.opengauss.admin.system.domain.SysUserRole ,Not found @TableId annotation, Cannot use Mybatis-Plus ‘xxById’ Method.
2026-06-06 08:44:04 [main] [com.baomidou.mybatisplus.core.injector.DefaultSqlInjector]-[WARN] class org.opengauss.admin.system.domain.SysRoleMenu ,Not found @TableId annotation, Cannot use Mybatis-Plus ‘xxById’ Method.
_ _ |_ _ |. __ _ | _
| | |/|)(| | |\ |)|||
/ |
null
2026-06-06 08:44:06 [main] [org.springframework.boot.actuate.endpoint.web.EndpointLinksResolver]-[INFO] Exposing 1 endpoint(s) beneath base path ‘’
2026-06-06 08:44:06 [main] [org.opengauss.core.v3.ConnectionFactoryImpl]-[INFO] [84d809c7-cbb6-4ba4-b0f3-ba2c4a3989a7] Try to connect. IP: 172.17.0.3:5432
2026-06-06 08:44:06 [main] [org.opengauss.core.v3.ConnectionFactoryImpl]-[INFO] [172.17.0.2:33552/172.17.0.3:5432] Connection is established. ID: 84d809c7-cbb6-4ba4-b0f3-ba2c4a3989a7
2026-06-06 08:44:06 [main] [org.opengauss.core.v3.ConnectionFactoryImpl]-[INFO] Connect complete. ID: 84d809c7-cbb6-4ba4-b0f3-ba2c4a3989a7
2026-06-06 08:44:07 [Druid-ConnectionPool-Create-1819897025] [org.opengauss.core.v3.ConnectionFactoryImpl]-[INFO] [fe28c07c-3068-429a-b13a-3e366b152f78] Try to connect. IP: 172.17.0.3:5432
2026-06-06 08:44:07 [Druid-ConnectionPool-Create-1819897025] [org.opengauss.core.v3.ConnectionFactoryImpl]-[INFO] [172.17.0.2:33566/172.17.0.3:5432] Connection is established. ID: fe28c07c-3068-429a-b13a-3e366b152f78
2026-06-06 08:44:07 [Druid-ConnectionPool-Create-1819897025] [org.opengauss.core.v3.ConnectionFactoryImpl]-[INFO] Connect complete. ID: fe28c07c-3068-429a-b13a-3e366b152f78
2026-06-06 08:44:09 [main] [org.springframework.boot.autoconfigure.web.servlet.WelcomePageHandlerMapping]-[INFO] Adding welcome page: class path resource [static/index.html]
2026-06-06 08:44:09 [main] [org.springframework.security.web.DefaultSecurityFilterChain]-[INFO] Will secure any request with [org.springframework.security.web.context.request.async.WebAsyncManagerIntegrationFilter@6baf25d7, org.springframework.security.web.context.SecurityContextPersistenceFilter@2eda072, org.springframework.security.web.header.HeaderWriterFilter@388623ad, org.springframework.web.filter.CorsFilter@aa004a0, org.springframework.security.web.authentication.logout.LogoutFilter@a6c54c3, org.springframework.web.filter.CorsFilter@aa004a0, org.opengauss.admin.framework.security.filter.JwtAuthenticationTokenFilter@6272c96f, org.springframework.security.web.savedrequest.RequestCacheAwareFilter@7951c3a2, org.springframework.security.web.servletapi.SecurityContextHolderAwareRequestFilter@57e388c3, org.springframework.security.web.authentication.AnonymousAuthenticationFilter@57a6a933, org.springframework.security.web.session.SessionManagementFilter@1ddc6db2, org.springframework.security.web.access.ExceptionTranslationFilter@22bdb1d0, org.springframework.security.web.access.intercept.FilterSecurityInterceptor@38d08cb5]
2026-06-06 08:44:10 [main] [org.apache.coyote.http11.Http11NioProtocol]-[INFO] Starting ProtocolHandler [“https-jsse-nio-9494”]
2026-06-06 08:44:10 [main] [org.springframework.boot.web.embedded.tomcat.TomcatWebServer]-[INFO] Tomcat started on port(s): 9494 (https) with context path ‘’
2026-06-06 08:44:10 [main] [springfox.documentation.swagger.readers.operation.OperationImplicitParameterReader]-[WARN] Unable to interpret the implicit parameter configuration with dataType: string, dataTypeClass: class java.lang.Void
2026-06-06 08:44:10 [main] [springfox.documentation.swagger.readers.operation.OperationImplicitParameterReader]-[WARN] Unable to interpret the implicit parameter configuration with dataType: string, dataTypeClass: class java.lang.Void
2026-06-06 08:44:11 [main] [springfox.documentation.swagger.readers.operation.OperationImplicitParameterReader]-[WARN] Unable to interpret the implicit parameter configuration with dataType: , dataTypeClass: class java.lang.Void
2026-06-06 08:44:11 [main] [springfox.documentation.swagger.readers.operation.OperationImplicitParameterReader]-[WARN] Unable to interpret the implicit parameter configuration with dataType: , dataTypeClass: class java.lang.Void
2026-06-06 08:44:11 [main] [springfox.documentation.swagger.readers.operation.OperationImplicitParameterReader]-[WARN] Unable to interpret the implicit parameter configuration with dataType: , dataTypeClass: class java.lang.Void
2026-06-06 08:44:11 [main] [springfox.documentation.swagger.readers.operation.OperationImplicitParameterReader]-[WARN] Unable to interpret the implicit parameter configuration with dataType: , dataTypeClass: class java.lang.Void
2026-06-06 08:44:11 [main] [com.gitee.starblues.loader.launcher.SpringMainProdBootstrap]-[INFO] Started SpringMainProdBootstrap in 24.999 seconds (JVM running for 123.774)
2026-06-06 08:44:11 [main] [com.gitee.starblues.integration.operator.DefaultPluginOperator]-[INFO] ???: prod
2026-06-06 08:44:11 [main] [com.gitee.starblues.integration.operator.DefaultPluginOperator]-[INFO] ???: isolation
2026-06-06 08:44:11 [main] [com.gitee.starblues.integration.operator.DefaultPluginOperator]-[INFO] ???, ???:
/datakit-server/visualtool-plugin
2026-06-06 08:44:11 [main] [com.gitee.starblues.spring.web.PluginStaticResourceConfig]-[INFO] ???: /static-plugin/{pluginId}
2026-06-06 08:44:11 [main] [com.gitee.starblues.core.DefaultPluginManager]-[INFO] ??[alert-monitor@6.0.0]???
2026-06-06 08:44:11 [main] [org.opengauss.admin.web.listener.MypluginListener]-[INFO] plugin [alert-monitor] load success.
2026-06-06 08:44:11 [main] [com.gitee.starblues.core.DefaultPluginManager]-[INFO] ??[base-ops@6.0.0]???
2026-06-06 08:44:11 [main] [org.opengauss.admin.web.listener.MypluginListener]-[INFO] plugin [base-ops] load success.
2026-06-06 08:44:11 [main] [com.gitee.starblues.core.DefaultPluginManager]-[INFO] ??[compatibility-assessment@6.0.0]???
2026-06-06 08:44:11 [main] [org.opengauss.admin.web.listener.MypluginListener]-[INFO] plugin [compatibility-assessment] load success.
2026-06-06 08:44:11 [main] [com.gitee.starblues.core.DefaultPluginManager]-[INFO] ??[data-migration@6.0.0]???
2026-06-06 08:44:11 [main] [org.opengauss.admin.web.listener.MypluginListener]-[INFO] plugin [data-migration] load success.
2026-06-06 08:44:11 [main] [com.gitee.starblues.core.DefaultPluginManager]-[INFO] ??[MetaTune@6.0.0]???
2026-06-06 08:44:11 [main] [org.opengauss.admin.web.listener.MypluginListener]-[INFO] plugin [MetaTune] load success.
2026-06-06 08:44:11 [main] [com.gitee.starblues.core.DefaultPluginManager]-[INFO] ??[monitor-tools@6.0.0]???
2026-06-06 08:44:11 [main] [org.opengauss.admin.web.listener.MypluginListener]-[INFO] plugin [monitor-tools] load success.
2026-06-06 08:44:11 [main] [com.gitee.starblues.core.DefaultPluginManager]-[INFO] ??[oauth-login@6.0.0]???
2026-06-06 08:44:11 [main] [org.opengauss.admin.web.listener.MypluginListener]-[INFO] plugin [oauth-login] load success.
2026-06-06 08:44:11 [main] [com.gitee.starblues.core.DefaultPluginManager]-[INFO] ??[observability-instance@6.0.0]???
2026-06-06 08:44:11 [main] [org.opengauss.admin.web.listener.MypluginListener]-[INFO] plugin [observability-instance] load success.
2026-06-06 08:44:11 [main] [com.gitee.starblues.core.DefaultPluginManager]-[INFO] ??[observability-log-search@6.0.0]???
2026-06-06 08:44:11 [main] [org.opengauss.admin.web.listener.MypluginListener]-[INFO] plugin [observability-log-search] load success.
2026-06-06 08:44:11 [main] [com.gitee.starblues.core.DefaultPluginManager]-[INFO] ??[observability-sql-diagnosis@6.0.0]???
2026-06-06 08:44:11 [main] [org.opengauss.admin.web.listener.MypluginListener]-[INFO] plugin [observability-sql-diagnosis] load success.
2026-06-06 08:44:11 [main] [com.gitee.starblues.core.DefaultPluginManager]-[INFO] ??[webds-plugin@6.0.0]???
2026-06-06 08:44:11 [main] [org.opengauss.admin.web.listener.MypluginListener]-[INFO] plugin [webds-plugin] load success.
2026-06-06 08:44:11 [main] [org.opengauss.admin.web.listener.MyPluginInitializerListener]-[INFO] My plugin init before.
2026-06-06 08:44:11 [main] [org.opengauss.admin.system.service.ops.impl.EncryptionUtils]-[INFO] encryption key not found, generate it.
2026-06-06 08:44:12 [main] [org.opengauss.admin.framework.config.AutoFillMetaObjectHandler]-[INFO] default user information not found, this is a new installation
2026-06-06 08:44:55.157 INFO 1413 — [ main] c.b.d.d.DynamicRoutingDataSource : dynamic-datasource - add a datasource named [primary] success
2026-06-06 08:44:55.201 INFO 1413 — [ main] c.b.d.d.DynamicRoutingDataSource : dynamic-datasource initial loaded [0] datasource,primary datasource named [primary]
_ _ |_ _ |. __ _ | _
| | |/|)(| | |\ |)|||
/ |
null
2026-06-06 08:44:57.219 WARN 1413 — [ main] com.alibaba.druid.pool.DruidDataSource : removeAbandoned is true, not use in production.
2026-06-06 08:44:57.233 INFO 1413 — [ main] com.alibaba.druid.pool.DruidDataSource : {dataSource-1} inited
2026-06-06 08:44:57 [Druid-ConnectionPool-Create-105302830] [org.opengauss.core.v3.ConnectionFactoryImpl]-[INFO] [eb53e0d2-5933-45db-8187-08bfec72bee6] Try to connect. IP: 172.17.0.3:5432
2026-06-06 08:44:57 [Druid-ConnectionPool-Create-105302830] [org.opengauss.core.v3.ConnectionFactoryImpl]-[INFO] [172.17.0.2:51728/172.17.0.3:5432] Connection is established. ID: eb53e0d2-5933-45db-8187-08bfec72bee6
2026-06-06 08:44:57 [Druid-ConnectionPool-Create-105302830] [org.opengauss.core.v3.ConnectionFactoryImpl]-[INFO] Connect complete. ID: eb53e0d2-5933-45db-8187-08bfec72bee6
2026-06-06 08:44:58.820 INFO 1413 — [ main] c.g.s.b.p.web.PluginControllerProcessor : ??[alert-monitor]???: {GET [/plugins/alert-monitor/api/v1/environment/cluster]}
2026-06-06 08:44:58.821 INFO 1413 — [ main] c.g.s.b.p.web.PluginControllerProcessor : ??[alert-monitor]???: {GET [/plugins/alert-monitor/api/v1/environment/checkPrometheus]}
2026-06-06 08:44:58.824 INFO 1413 — [ main] c.g.s.b.p.web.PluginControllerProcessor : ??[alert-monitor]???: {GET [/plugins/alert-monitor/api/v1/notifyConfig/list]}
2026-06-06 08:44:58.824 INFO 1413 — [ main] c.g.s.b.p.web.PluginControllerProcessor : ??[alert-monitor]???: {POST [/plugins/alert-monitor/api/v1/notifyConfig/list]}
2026-06-06 08:44:58.824 INFO 1413 — [ main] c.g.s.b.p.web.PluginControllerProcessor : ??[alert-monitor]???: {POST [/plugins/alert-monitor/api/v1/notifyConfig/testConfig]}
2026-06-06 08:44:58.827 INFO 1413 — [ main] c.g.s.b.p.web.PluginControllerProcessor : ??[alert-monitor]???: {GET [/plugins/alert-monitor/api/v1/alertRecord/export]}
2026-06-06 08:44:58.827 INFO 1413 — [ main] c.g.s.b.p.web.PluginControllerProcessor : ??[alert-monitor]???: {GET [/plugins/alert-monitor/api/v1/alertRecord/{id}]}
2026-06-06 08:44:58.827 INFO 1413 — [ main] c.g.s.b.p.web.PluginControllerProcessor : ??[alert-monitor]???: {GET [/plugins/alert-monitor/api/v1/alertRecord]}
2026-06-06 08:44:58.828 INFO 1413 — [ main] c.g.s.b.p.web.PluginControllerProcessor : ??[alert-monitor]???: {GET [/plugins/alert-monitor/api/v1/alertRecord/statistics]}
2026-06-06 08:44:58.828 INFO 1413 — [ main] c.g.s.b.p.web.PluginControllerProcessor : ??[alert-monitor]???: {POST [/plugins/alert-monitor/api/v1/alertRecord/markAsUnread]}
2026-06-06 08:44:58.828 INFO 1413 — [ main] c.g.s.b.p.web.PluginControllerProcessor : ??[alert-monitor]???: {POST [/plugins/alert-monitor/api/v1/alertRecord/markAsRead]}
2026-06-06 08:44:58.829 INFO 1413 — [ main] c.g.s.b.p.web.PluginControllerProcessor : ??[alert-monitor]???: {GET [/plugins/alert-monitor/api/v1/alertRecord/{id}/relation]}
