安装logo图片无法进行修改，报错

liukuan · 2021 年5 月 8 日 03:09

Choerodon平台版本: 0.24
遇到问题的执行步骤:
无法修改logo图
文档地址:
环境信息(如:节点信息):
报错日志:

image1610×1362 172 KB
原因分析:

提出您分析问题的过程,以便我们能更准确的找到问题所在
疑问:

提出您对于遇到和解决该问题时的疑问

change · 2021 年5 月 8 日 07:44

choerodon-file 服务minio的相关配置正确吗？

liukuan · 2021 年5 月 8 日 08:02

我看了下我的配置文件是正确的

change · 2021 年5 月 8 日 08:14

那看下choerodon-file的错误日志呢

liukuan · 2021 年5 月 8 日 08:49

2021-05-08 16:34:19.097 INFO 7 — [freshExecutor-0] com.netflix.discovery.DiscoveryClient : The response status is 200
2021-05-08 16:34:28.512 ERROR 7 — [ XNIO-3 task-62] o.h.s.file.service.MinioFileServiceImpl : The access key ID you provided does not exist in our records.
2021-05-08 16:34:28.516 WARN 7 — [ XNIO-3 task-62] o.h.core.exception.BaseExceptionHandler : Common exception, request: RequestInfo{URI=/choerodon/v1/1/cut_image, method=public org.springframework.http.ResponseEntity<java.lang.String> io.choerodon.file.api.controller.v1.CutImageC7nController.cutImage(org.springframework.web.multipart.MultipartFile,java.lang.Double,java.lang.Integer,java.lang.Integer,java.lang.Integer,java.lang.Integer,java.lang.Long,java.lang.String)}, user: null

io.choerodon.core.exception.CommonException: error.cut.and.upload.image
Caused by: io.choerodon.core.exception.CommonException: hfle.error.file.upload
Caused by: io.minio.errors.ErrorResponseException: The access key ID you provided does not exist in our records.
at io.minio.MinioClient.execute(MinioClient.java:1201) ~[minio-3.0.10.jar!/:3.0.10]
at io.minio.MinioClient.updateRegionCache(MinioClient.java:1216) ~[minio-3.0.10.jar!/:3.0.10]
at io.minio.MinioClient.getRegion(MinioClient.java:1262) ~[minio-3.0.10.jar!/:3.0.10]
at io.minio.MinioClient.executeHead(MinioClient.java:1309) ~[minio-3.0.10.jar!/:3.0.10]
at io.minio.MinioClient.bucketExists(MinioClient.java:2979) ~[minio-3.0.10.jar!/:3.0.10]
at org.hzero.starter.file.service.MinioFileServiceImpl.checkAndCreateBucket(MinioFileServiceImpl.java:125) ~[hzero-starter-file-minio-1.4.0.RELEASE.jar!/:1.4.0.RELEASE]
at org.hzero.starter.file.service.MinioFileServiceImpl.upload(MinioFileServiceImpl.java:108) ~[hzero-starter-file-minio-1.4.0.RELEASE.jar!/:1.4.0.RELEASE]
at org.hzero.file.domain.service.factory.StoreService.uploadFile(StoreService.java:124) ~[hzero-file-saas-1.4.0.RELEASE.jar!/:1.4.0.RELEASE]
at org.hzero.file.app.service.impl.FileServiceImpl.uploadMultipart(FileServiceImpl.java:129) ~[hzero-file-saas-1.4.0.RELEASE.jar!/:1.4.0.RELEASE]
at org.hzero.file.app.service.impl.FileServiceImpl$$FastClassBySpringCGLIB$$51e9cb7b.invoke() ~[hzero-file-saas-1.4.0.RELEASE.jar!/:1.4.0.RELEASE]
at org.springframework.cglib.proxy.MethodProxy.invoke(MethodProxy.java:204) ~[spring-core-5.0.10.RELEASE.jar!/:5.0.10.RELEASE]
at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.invokeJoinpoint(CglibAopProxy.java:746) ~[spring-aop-5.0.10.RELEASE.jar!/:5.0.10.RELEASE]
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:163) ~[spring-aop-5.0.10.RELEASE.jar!/:5.0.10.RELEASE]
at org.springframework.transaction.interceptor.TransactionInterceptor$$Lambda$835/000000004760BE90.proceedWithInvocation(Unknown Source) ~[na:na]
at org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:294) ~[spring-tx-5.0.10.RELEASE.jar!/:5.0.10.RELEASE]
at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:98) ~[spring-tx-5.0.10.RELEASE.jar!/:5.0.10.RELEASE]
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:185) ~[spring-aop-5.0.10.RELEASE.jar!/:5.0.10.RELEASE]
at org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:688) ~[spring-aop-5.0.10.RELEASE.jar!/:5.0.10.RELEASE]
at org.hzero.file.app.service.impl.FileServiceImpl$$EnhancerBySpringCGLIB$$3a45500c.uploadMultipart() ~[hzero-file-saas-1.4.0.RELEASE.jar!/:1.4.0.RELEASE]
at io.choerodon.file.app.service.impl.FileC7nServiceImpl.cutImage(FileC7nServiceImpl.java:48) ~[classes!/:0.23.1]
at io.choerodon.file.app.service.impl.FileC7nServiceImpl$$FastClassBySpringCGLIB$$ff4ba9b8.invoke() ~[classes!/:0.23.1]
at org.springframework.cglib.proxy.MethodProxy.invoke(MethodProxy.java:204) ~[spring-core-5.0.10.RELEASE.jar!/:5.0.10.RELEASE]
at org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:684) ~[spring-aop-5.0.10.RELEASE.jar!/:5.0.10.RELEASE]
at io.choerodon.file.app.service.impl.FileC7nServiceImpl$$EnhancerBySpringCGLIB$$b39538e3.cutImage() ~[classes!/:0.23.1]
at io.choerodon.file.api.controller.v1.CutImageC7nController.cutImage(CutImageC7nController.java:48) ~[classes!/:0.23.1]
at sun.reflect.GeneratedMethodAccessor376.invoke(Unknown Source) ~[na:na]
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source) ~[na:1.8.0_242]
at java.lang.reflect.Method.invoke(Unknown Source) ~[na:1.8.0_242]
at org.springframework.web.method.support.InvocableHandlerMethod.doInvoke(InvocableHandlerMethod.java:209) ~[spring-web-5.0.10.RELEASE.jar!/:5.0.10.RELEASE]
at org.springframework.web.method.support.InvocableHandlerMethod.invokeForRequest(InvocableHandlerMethod.java:136) ~[spring-web-5.0.10.RELEASE.jar!/:5.0.10.RELEASE]
at org.springframework.web.servlet.mvc.method.annotation.ServletInvocableHandlerMethod.invokeAndHandle(ServletInvocableHandlerMethod.java:102) ~[spring-webmvc-5.0.10.RELEASE.jar!/:5.0.10.RELEASE]
at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.invokeHandlerMethod(RequestMappingHandlerAdapter.java:891) ~[spring-webmvc-5.0.10.RELEASE.jar!/:5.0.10.RELEASE]
at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.handleInternal(RequestMappingHandlerAdapter.java:797) ~[spring-webmvc-5.0.10.RELEASE.jar!/:5.0.10.RELEASE]
at org.springframework.web.servlet.mvc.method.AbstractHandlerMethodAdapter.handle(AbstractHandlerMethodAdapter.java:87) ~[spring-webmvc-5.0.10.RELEASE.jar!/:5.0.10.RELEASE]
at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:991) ~[spring-webmvc-5.0.10.RELEASE.jar!/:5.0.10.RELEASE]
at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:925) ~[spring-webmvc-5.0.10.RELEASE.jar!/:5.0.10.RELEASE]
at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:974) ~[spring-webmvc-5.0.10.RELEASE.jar!/:5.0.10.RELEASE]
at org.springframework.web.servlet.FrameworkServlet.doPost(FrameworkServlet.java:877) ~[spring-webmvc-5.0.10.RELEASE.jar!/:5.0.10.RELEASE]
at javax.servlet.http.HttpServlet.service(HttpServlet.java:707) [javax.servlet-api-3.1.0.jar!/:3.1.0]
at org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:851) ~[spring-webmvc-5.0.10.RELEASE.jar!/:5.0.10.RELEASE]
at javax.servlet.http.HttpServlet.service(HttpServlet.java:790) [javax.servlet-api-3.1.0.jar!/:3.1.0]
at io.undertow.servlet.handlers.ServletHandler.handleRequest(ServletHandler.java:74) [undertow-servlet-1.4.26.Final.jar!/:1.4.26.Final]
at io.undertow.servlet.handlers.FilterHandler$FilterChainImpl.doFilter(FilterHandler.java:129) [undertow-servlet-1.4.26.Final.jar!/:1.4.26.Final]
at org.hzero.mybatis.parser.autoconfigure.SqlParserInterceptorConfiguration$SqlParserAutoClearFilter.doFilter(SqlParserInterceptorConfiguration.java:52) [hzero-starter-mybatis-mapper-1.4.0.RELEASE.jar!/:1.4.0.RELEASE]
at io.undertow.servlet.core.ManagedFilter.doFilter(ManagedFilter.java:61) [undertow-servlet-1.4.26.Final.jar!/:1.4.26.Final]
at io.undertow.servlet.handlers.FilterHandler$FilterChainImpl.doFilter(FilterHandler.java:131) [undertow-servlet-1.4.26.Final.jar!/:1.4.26.Final]
at org.hzero.core.jackson.config.ObjectMapperConfiguration$SensitiveAutoCloseFilter.doFilter(ObjectMapperConfiguration.java:51) [hzero-starter-core-1.4.0.RELEASE.jar!/:1.4.0.RELEASE]
at io.undertow.servlet.core.ManagedFilter.doFilter(ManagedFilter.java:61) [undertow-servlet-1.4.26.Final.jar!/:1.4.26.Final]
at io.undertow.servlet.handlers.FilterHandler$FilterChainImpl.doFilter(FilterHandler.java:131) [undertow-servlet-1.4.26.Final.jar!/:1.4.26.Final]
at org.springframework.boot.actuate.web.trace.servlet.HttpTraceFilter.doFilterInternal(HttpTraceFilter.java:90) [spring-boot-actuator-2.0.6.RELEASE.jar!/:2.0.6.RELEASE]
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107) [spring-web-5.0.10.RELEASE.jar!/:5.0.10.RELEASE]
at io.undertow.servlet.core.ManagedFilter.doFilter(ManagedFilter.java:61) [undertow-servlet-1.4.26.Final.jar!/:1.4.26.Final]
at io.undertow.servlet.handlers.FilterHandler$FilterChainImpl.doFilter(FilterHandler.java:131) [undertow-servlet-1.4.26.Final.jar!/:1.4.26.Final]
at org.hzero.starter.keyencrypt.mvc.EncryptHeaderContextFilter.doFilter(EncryptHeaderContextFilter.java:34) [hzero-starter-keyencrypt-1.4.0.RELEASE.jar!/:1.4.0.RELEASE]
at io.undertow.servlet.core.ManagedFilter.doFilter(ManagedFilter.java:61) [undertow-servlet-1.4.26.Final.jar!/:1.4.26.Final]
at io.undertow.servlet.handlers.FilterHandler$FilterChainImpl.doFilter(FilterHandler.java:131) [undertow-servlet-1.4.26.Final.jar!/:1.4.26.Final]
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:320) [spring-security-web-5.0.9.RELEASE.jar!/:5.0.9.RELEASE]
at org.springframework.security.web.access.ExceptionTranslationFilter.doFilter(ExceptionTranslationFilter.java:119) [spring-security-web-5.0.9.RELEASE.jar!/:5.0.9.RELEASE]
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334) [spring-security-web-5.0.9.RELEASE.jar!/:5.0.9.RELEASE]
at org.springframework.security.web.session.SessionManagementFilter.doFilter(SessionManagementFilter.java:137) [spring-security-web-5.0.9.RELEASE.jar!/:5.0.9.RELEASE]
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334) [spring-security-web-5.0.9.RELEASE.jar!/:5.0.9.RELEASE]
at org.springframework.security.web.authentication.AnonymousAuthenticationFilter.doFilter(AnonymousAuthenticationFilter.java:111) [spring-security-web-5.0.9.RELEASE.jar!/:5.0.9.RELEASE]
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334) [spring-security-web-5.0.9.RELEASE.jar!/:5.0.9.RELEASE]
at org.springframework.security.web.servletapi.SecurityContextHolderAwareRequestFilter.doFilter(SecurityContextHolderAwareRequestFilter.java:170) [spring-security-web-5.0.9.RELEASE.jar!/:5.0.9.RELEASE]
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334) [spring-security-web-5.0.9.RELEASE.jar!/:5.0.9.RELEASE]
at org.springframework.security.web.savedrequest.RequestCacheAwareFilter.doFilter(RequestCacheAwareFilter.java:63) [spring-security-web-5.0.9.RELEASE.jar!/:5.0.9.RELEASE]
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334) [spring-security-web-5.0.9.RELEASE.jar!/:5.0.9.RELEASE]
at org.springframework.security.web.authentication.logout.LogoutFilter.doFilter(LogoutFilter.java:116) [spring-security-web-5.0.9.RELEASE.jar!/:5.0.9.RELEASE]
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334) [spring-security-web-5.0.9.RELEASE.jar!/:5.0.9.RELEASE]
at org.springframework.security.web.header.HeaderWriterFilter.doFilterInternal(HeaderWriterFilter.java:66) [spring-security-web-5.0.9.RELEASE.jar!/:5.0.9.RELEASE]
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107) [spring-web-5.0.10.RELEASE.jar!/:5.0.10.RELEASE]
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334) [spring-security-web-5.0.9.RELEASE.jar!/:5.0.9.RELEASE]
at org.springframework.security.web.context.SecurityContextPersistenceFilter.doFilter(SecurityContextPersistenceFilter.java:105) [spring-security-web-5.0.9.RELEASE.jar!/:5.0.9.RELEASE]
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334) [spring-security-web-5.0.9.RELEASE.jar!/:5.0.9.RELEASE]
at org.springframework.security.web.context.request.async.WebAsyncManagerIntegrationFilter.doFilterInternal(WebAsyncManagerIntegrationFilter.java:56) [spring-security-web-5.0.9.RELEASE.jar!/:5.0.9.RELEASE]
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107) [spring-web-5.0.10.RELEASE.jar!/:5.0.10.RELEASE]
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334) [spring-security-web-5.0.9.RELEASE.jar!/:5.0.9.RELEASE]
at org.springframework.security.web.FilterChainProxy.doFilterInternal(FilterChainProxy.java:215) [spring-security-web-5.0.9.RELEASE.jar!/:5.0.9.RELEASE]
at org.springframework.security.web.FilterChainProxy.doFilter(FilterChainProxy.java:178) [spring-security-web-5.0.9.RELEASE.jar!/:5.0.9.RELEASE]
at org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:357) [spring-web-5.0.10.RELEASE.jar!/:5.0.10.RELEASE]
at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:270) [spring-web-5.0.10.RELEASE.jar!/:5.0.10.RELEASE]

change · 2021 年5 月 8 日 08:55

他的报错是说这个配置不对，你能用这个信息登录minio吗？

liukuan · 2021 年5 月 8 日 09:09

知道了，谢谢

liukuan · 2021 年5 月 8 日 09:26

在麻烦问您一下，我把choerodon-file卸载了，同时卸载了job也进行了卸载。现在报错如下：

liukuan · 2021 年5 月 8 日 09:27

超时也加长到了1000，–set preJob.timeout=1000

change · 2021 年5 月 8 日 09:38

你看执行的job是否有报错

liukuan · 2021 年5 月 8 日 10:15

1-05-08 18:11:17.703 ERROR 6 — [ main] o.h.installer.liquibase.excel.DbAdaptor : [hpfm_lov]update error, row:[322, HFLE.CAPACITY.ACCESS_CONTROL, IDP, , 存储配置目录权限, Storage Configuration Directory Permissions, 存储配置目录权限值集(父值集为服务供应商), 存储配置目录权限值集(父值集为服务供应商), 0, 0, HFLE.SERVER_PROVIDER, 0, , , , , 1, 1, , , 0, ] ,sql:update hpfm_lov set lov_type_code=?,route_name=?,lov_name=?,description=?,parent_lov_code=?,parent_tenant_id=?,custom_sql=?,custom_url=?,value_field=?,display_field=?,must_page_flag=?,enabled_flag=?,translation_sql=?,encrypt_field=?,public_flag=?,decrypt_field=? where lov_id=?
2021-05-08 18:11:17.705 ERROR 6 — [ main] o.h.i.liquibase.excel.ExcelDataLoader : Unknown column ‘decrypt_field’ in ‘field list’

java.sql.SQLSyntaxErrorException: Unknown column ‘decrypt_field’ in ‘field list’
at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:120) ~[mysql-connector-java-8.0.15.jar!/:8.0.15]
at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:97) ~[mysql-connector-java-8.0.15.jar!/:8.0.15]
at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:122) ~[mysql-connector-java-8.0.15.jar!/:8.0.15]
at com.mysql.cj.jdbc.ClientPreparedStatement.executeInternal(ClientPreparedStatement.java:970) ~[mysql-connector-java-8.0.15.jar!/:8.0.15]
at com.mysql.cj.jdbc.ClientPreparedStatement.executeUpdateInternal(ClientPreparedStatement.java:1109) ~[mysql-connector-java-8.0.15.jar!/:8.0.15]
at com.mysql.cj.jdbc.ClientPreparedStatement.executeUpdateInternal(ClientPreparedStatement.java:1057) ~[mysql-connector-java-8.0.15.jar!/:8.0.15]
at com.mysql.cj.jdbc.ClientPreparedStatement.executeLargeUpdate(ClientPreparedStatement.java:1377) ~[mysql-connector-java-8.0.15.jar!/:8.0.15]
at com.mysql.cj.jdbc.ClientPreparedStatement.executeUpdate(ClientPreparedStatement.java:1042) ~[mysql-connector-java-8.0.15.jar!/:8.0.15]
at org.hzero.installer.liquibase.excel.DbAdaptor.doUpdate(DbAdaptor.java:338) ~[hzero-installer-0.2.6.RELEASE.jar!/:0.2.6.RELEASE]
at org.hzero.installer.liquibase.excel.ExcelDataLoader.processUpdate(ExcelDataLoader.java:165) [hzero-installer-0.2.6.RELEASE.jar!/:0.2.6.RELEASE]
at org.hzero.installer.liquibase.excel.ExcelDataLoader.processData(ExcelDataLoader.java:102) [hzero-installer-0.2.6.RELEASE.jar!/:0.2.6.RELEASE]
at org.hzero.installer.liquibase.excel.ExcelDataLoader.execute(ExcelDataLoader.java:315) [hzero-installer-0.2.6.RELEASE.jar!/:0.2.6.RELEASE]
at org.hzero.installer.liquibase.LiquibaseExecutor.load(LiquibaseExecutor.java:324) [hzero-installer-0.2.6.RELEASE.jar!/:0.2.6.RELEASE]
at org.hzero.installer.liquibase.LiquibaseExecutor.runToDb(LiquibaseExecutor.java:200) [hzero-installer-0.2.6.RELEASE.jar!/:0.2.6.RELEASE]
at org.hzero.installer.liquibase.LiquibaseExecutor.execute(LiquibaseExecutor.java:116) [hzero-installer-0.2.6.RELEASE.jar!/:0.2.6.RELEASE]
at org.hzero.installer.service.impl.ImportDataServiceImpl.executor(ImportDataServiceImpl.java:297) [hzero-installer-0.2.6.RELEASE.jar!/:0.2.6.RELEASE]
at org.hzero.installer.service.impl.ImportDataServiceImpl.executor(ImportDataServiceImpl.java:282) [hzero-installer-0.2.6.RELEASE.jar!/:0.2.6.RELEASE]
at org.hzero.installer.service.impl.ImportDataServiceImpl.importData(ImportDataServiceImpl.java:226) [hzero-installer-0.2.6.RELEASE.jar!/:0.2.6.RELEASE]
at org.hzero.installer.service.impl.ImportDataServiceImpl.selfData(ImportDataServiceImpl.java:237) [hzero-installer-0.2.6.RELEASE.jar!/:0.2.6.RELEASE]
at io.choerodon.liquibase.StartupRunner.run(StartupRunner.java:68) [classes!/:0.17.1.RELEASE]
at org.springframework.boot.SpringApplication.callRunner(SpringApplication.java:792) [spring-boot-2.0.6.RELEASE.jar!/:2.0.6.RELEASE]
at org.springframework.boot.SpringApplication.callRunners(SpringApplication.java:776) [spring-boot-2.0.6.RELEASE.jar!/:2.0.6.RELEASE]
at org.springframework.boot.SpringApplication.run(SpringApplication.java:315) [spring-boot-2.0.6.RELEASE.jar!/:2.0.6.RELEASE]
at io.choerodon.liquibase.LiquibaseTools.main(LiquibaseTools.java:20) [classes!/:0.17.1.RELEASE]
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) ~[na:1.8.0_272]
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) ~[na:1.8.0_272]
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[na:1.8.0_272]
at java.lang.reflect.Method.invoke(Method.java:498) ~[na:1.8.0_272]
at org.springframework.boot.loader.MainMethodRunner.run(MainMethodRunner.java:48) [choerodon-tool-liquibase.jar:0.17.1.RELEASE]
at org.springframework.boot.loader.Launcher.launch(Launcher.java:87) [choerodon-tool-liquibase.jar:0.17.1.RELEASE]
at org.springframework.boot.loader.Launcher.launch(Launcher.java:50) [choerodon-tool-liquibase.jar:0.17.1.RELEASE]
at org.springframework.boot.loader.JarLauncher.main(JarLauncher.java:51) [choerodon-tool-liquibase.jar:0.17.1.RELEASE]

2021-05-08 18:11:17.706 INFO 6 — [ main] o.h.i.liquibase.excel.ExcelDataLoader : data process finish, time: 300 ms
2021-05-08 18:11:17.711 ERROR 6 — [ main] o.h.i.liquibase.LiquibaseExecutor : excel: /hzero-platform-lov.xlsx 处理失败

org.hzero.installer.liquibase.exception.LiquibaseException: org.hzero.installer.liquibase.exception.LiquibaseException: java.sql.SQLSyntaxErrorException: Unknown column ‘decrypt_field’ in ‘field list’
at org.hzero.installer.liquibase.excel.ExcelDataLoader.execute(ExcelDataLoader.java:324) ~[hzero-installer-0.2.6.RELEASE.jar!/:0.2.6.RELEASE]
at org.hzero.installer.liquibase.LiquibaseExecutor.load(LiquibaseExecutor.java:324) [hzero-installer-0.2.6.RELEASE.jar!/:0.2.6.RELEASE]
at org.hzero.installer.liquibase.LiquibaseExecutor.runToDb(LiquibaseExecutor.java:200) [hzero-installer-0.2.6.RELEASE.jar!/:0.2.6.RELEASE]
at org.hzero.installer.liquibase.LiquibaseExecutor.execute(LiquibaseExecutor.java:116) [hzero-installer-0.2.6.RELEASE.jar!/:0.2.6.RELEASE]
at org.hzero.installer.service.impl.ImportDataServiceImpl.executor(ImportDataServiceImpl.java:297) [hzero-installer-0.2.6.RELEASE.jar!/:0.2.6.RELEASE]
at org.hzero.installer.service.impl.ImportDataServiceImpl.executor(ImportDataServiceImpl.java:282) [hzero-installer-0.2.6.RELEASE.jar!/:0.2.6.RELEASE]
at org.hzero.installer.service.impl.ImportDataServiceImpl.importData(ImportDataServiceImpl.java:226) [hzero-installer-0.2.6.RELEASE.jar!/:0.2.6.RELEASE]
at org.hzero.installer.service.impl.ImportDataServiceImpl.selfData(ImportDataServiceImpl.java:237) [hzero-installer-0.2.6.RELEASE.jar!/:0.2.6.RELEASE]
at io.choerodon.liquibase.StartupRunner.run(StartupRunner.java:68) [classes!/:0.17.1.RELEASE]
at org.springframework.boot.SpringApplication.callRunner(SpringApplication.java:792) [spring-boot-2.0.6.RELEASE.jar!/:2.0.6.RELEASE]
at org.springframework.boot.SpringApplication.callRunners(SpringApplication.java:776) [spring-boot-2.0.6.RELEASE.jar!/:2.0.6.RELEASE]
at org.springframework.boot.SpringApplication.run(SpringApplication.java:315) [spring-boot-2.0.6.RELEASE.jar!/:2.0.6.RELEASE]
at io.choerodon.liquibase.LiquibaseTools.main(LiquibaseTools.java:20) [classes!/:0.17.1.RELEASE]
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) ~[na:1.8.0_272]
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) ~[na:1.8.0_272]
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[na:1.8.0_272]
at java.lang.reflect.Method.invoke(Method.java:498) ~[na:1.8.0_272]
at org.springframework.boot.loader.MainMethodRunner.run(MainMethodRunner.java:48) [choerodon-tool-liquibase.jar:0.17.1.RELEASE]
at org.springframework.boot.loader.Launcher.launch(Launcher.java:87) [choerodon-tool-liquibase.jar:0.17.1.RELEASE]
at org.springframework.boot.loader.Launcher.launch(Launcher.java:50) [choerodon-tool-liquibase.jar:0.17.1.RELEASE]
at org.springframework.boot.loader.JarLauncher.main(JarLauncher.java:51) [choerodon-tool-liquibase.jar:0.17.1.RELEASE]
Caused by: org.hzero.installer.liquibase.exception.LiquibaseException: java.sql.SQLSyntaxErrorException: Unknown column ‘decrypt_field’ in ‘field list’
at org.hzero.installer.liquibase.excel.ExcelDataLoader.processData(ExcelDataLoader.java:107) ~[hzero-installer-0.2.6.RELEASE.jar!/:0.2.6.RELEASE]
at org.hzero.installer.liquibase.excel.ExcelDataLoader.execute(ExcelDataLoader.java:315) ~[hzero-installer-0.2.6.RELEASE.jar!/:0.2.6.RELEASE]
… 20 common frames omitted
Caused by: java.sql.SQLSyntaxErrorException: Unknown column ‘decrypt_field’ in ‘field list’
at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:120) ~[mysql-connector-java-8.0.15.jar!/:8.0.15]
at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:97) ~[mysql-connector-java-8.0.15.jar!/:8.0.15]
at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:122) ~[mysql-connector-java-8.0.15.jar!/:8.0.15]
at com.mysql.cj.jdbc.ClientPreparedStatement.executeInternal(ClientPreparedStatement.java:970) ~[mysql-connector-java-8.0.15.jar!/:8.0.15]
at com.mysql.cj.jdbc.ClientPreparedStatement.executeUpdateInternal(ClientPreparedStatement.java:1109) ~[mysql-connector-java-8.0.15.jar!/:8.0.15]
at com.mysql.cj.jdbc.ClientPreparedStatement.executeUpdateInternal(ClientPreparedStatement.java:1057) ~[mysql-connector-java-8.0.15.jar!/:8.0.15]
at com.mysql.cj.jdbc.ClientPreparedStatement.executeLargeUpdate(ClientPreparedStatement.java:1377) ~[mysql-connector-java-8.0.15.jar!/:8.0.15]
at com.mysql.cj.jdbc.ClientPreparedStatement.executeUpdate(ClientPreparedStatement.java:1042) ~[mysql-connector-java-8.0.15.jar!/:8.0.15]
at org.hzero.installer.liquibase.excel.DbAdaptor.doUpdate(DbAdaptor.java:338) ~[hzero-installer-0.2.6.RELEASE.jar!/:0.2.6.RELEASE]
at org.hzero.installer.liquibase.excel.ExcelDataLoader.processUpdate(ExcelDataLoader.java:165) ~[hzero-installer-0.2.6.RELEASE.jar!/:0.2.6.RELEASE]
at org.hzero.installer.liquibase.excel.ExcelDataLoader.processData(ExcelDataLoader.java:102) ~[hzero-installer-0.2.6.RELEASE.jar!/:0.2.6.RELEASE]
… 21 common frames omitted

2021-05-08 18:11:17.711 ERROR 6 — [ main] o.h.i.liquibase.LiquibaseExecutor : The database initialization task failed
2021-05-08 18:11:17.711 ERROR 6 — [ main] io.choerodon.liquibase.StartupRunner : 数据库初始化任务失败, message: java.lang.Exception: org.hzero.installer.liquibase.exception.LiquibaseException: java.sql.SQLSyntaxErrorException: Unknown column ‘decrypt_field’ in ‘field list’, exception:

java.lang.Exception: java.lang.Exception: org.hzero.installer.liquibase.exception.LiquibaseException: java.sql.SQLSyntaxErrorException: Unknown column ‘decrypt_field’ in ‘field list’
at org.hzero.installer.liquibase.LiquibaseExecutor.execute(LiquibaseExecutor.java:120) ~[hzero-installer-0.2.6.RELEASE.jar!/:0.2.6.RELEASE]
at org.hzero.installer.service.impl.ImportDataServiceImpl.executor(ImportDataServiceImpl.java:297) ~[hzero-installer-0.2.6.RELEASE.jar!/:0.2.6.RELEASE]
at org.hzero.installer.service.impl.ImportDataServiceImpl.executor(ImportDataServiceImpl.java:282) ~[hzero-installer-0.2.6.RELEASE.jar!/:0.2.6.RELEASE]
at org.hzero.installer.service.impl.ImportDataServiceImpl.importData(ImportDataServiceImpl.java:226) ~[hzero-installer-0.2.6.RELEASE.jar!/:0.2.6.RELEASE]
at org.hzero.installer.service.impl.ImportDataServiceImpl.selfData(ImportDataServiceImpl.java:237) ~[hzero-installer-0.2.6.RELEASE.jar!/:0.2.6.RELEASE]
at io.choerodon.liquibase.StartupRunner.run(StartupRunner.java:68) ~[classes!/:0.17.1.RELEASE]
at org.springframework.boot.SpringApplication.callRunner(SpringApplication.java:792) [spring-boot-2.0.6.RELEASE.jar!/:2.0.6.RELEASE]
at org.springframework.boot.SpringApplication.callRunners(SpringApplication.java:776) [spring-boot-2.0.6.RELEASE.jar!/:2.0.6.RELEASE]
at org.springframework.boot.SpringApplication.run(SpringApplication.java:315) [spring-boot-2.0.6.RELEASE.jar!/:2.0.6.RELEASE]
at io.choerodon.liquibase.LiquibaseTools.main(LiquibaseTools.java:20) [classes!/:0.17.1.RELEASE]
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) ~[na:1.8.0_272]
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) ~[na:1.8.0_272]
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[na:1.8.0_272]
at java.lang.reflect.Method.invoke(Method.java:498) ~[na:1.8.0_272]
at org.springframework.boot.loader.MainMethodRunner.run(MainMethodRunner.java:48) [choerodon-tool-liquibase.jar:0.17.1.RELEASE]
at org.springframework.boot.loader.Launcher.launch(Launcher.java:87) [choerodon-tool-liquibase.jar:0.17.1.RELEASE]
at org.springframework.boot.loader.Launcher.launch(Launcher.java:50) [choerodon-tool-liquibase.jar:0.17.1.RELEASE]
at org.springframework.boot.loader.JarLauncher.main(JarLauncher.java:51) [choerodon-tool-liquibase.jar:0.17.1.RELEASE]
Caused by: java.lang.Exception: org.hzero.installer.liquibase.exception.LiquibaseException: java.sql.SQLSyntaxErrorException: Unknown column ‘decrypt_field’ in ‘field list’
at org.hzero.installer.liquibase.LiquibaseExecutor.load(LiquibaseExecutor.java:327) ~[hzero-installer-0.2.6.RELEASE.jar!/:0.2.6.RELEASE]
at org.hzero.installer.liquibase.LiquibaseExecutor.runToDb(LiquibaseExecutor.java:200) ~[hzero-installer-0.2.6.RELEASE.jar!/:0.2.6.RELEASE]
at org.hzero.installer.liquibase.LiquibaseExecutor.execute(LiquibaseExecutor.java:116) ~[hzero-installer-0.2.6.RELEASE.jar!/:0.2.6.RELEASE]
… 17 common frames omitted

2021-05-08 18:11:17.712 INFO 6 — [ Thread-6] ConfigServletWebServerApplicationContext : Closing org.springframework.boot.web.servlet.context.AnnotationConfigServletWebServerApplicationContext@e1771256: startup date [Sat May 08 18:11:11 CST 2021]; root of context hierarchy
2021-05-08 18:11:17.714 INFO 6 — [ Thread-6] com.zaxxer.hikari.HikariDataSource : HikariPool-1 - Shutdown initiated…
2021-05-08 18:11:17.716 INFO 6 — [ Thread-6] com.zaxxer.hikari.HikariDataSource : HikariPool-1 - Shutdown completed.
[root@vm10-30-0-75 wfy]#

change · 2021 年5 月 10 日 01:12

你部署的choerodon-file具体是哪个版本呢