工作流引擎切换postgres,无法创建流程

Blade 已结 1 500
renjiangyang
renjiangyang 2022-10-04 10:34

一、该问题的重现步骤是什么?

1. 按照文档修改配置文件,将数据库切换成postgres,可以正常启动

2. 创建新流程报错,如下

"D:\Program Files\Java\jdk1.8.0_311\bin\java.exe" ...
连接到目标VM, 地址: ''javadebug',传输: '共享内存'', 传输: '{1}'
----启动中,读取到的环境变量:[dev],jar地址:[/D:/MyWork/db/gitee/blade-cloud/frank-flowable-design/target/classes/]----
            ______  _             _       ___   ___
            | ___ \| |           | |      \  \ /  /
            | |_/ /| |  __ _   __| |  ___  \  V  /
            | ___ \| | / _` | / _` | / _ \   > <
            | |_/ /| || (_| || (_| ||  __/ /  .  \
            \____/ |_| \__,_| \__,_| \___|/__/ \__\

:: BladeX :: blade-flowdesign:dev :: Running SpringBoot 2.7.1 :: 

2022-10-04 10:31:24.086  INFO 16068 --- [           main] o.s.flow.FlowDesignApplication           : The following 1 profile is active: "dev"
2022-10-04 10:31:24.715  INFO 16068 --- [           main] o.s.cloud.context.scope.GenericScope     : BeanFactory id=69bf76c2-643f-3b03-87c0-f686b9c23c65
2022-10-04 10:31:24.717  INFO 16068 --- [           main] s.c.l.p.BladePropertySourcePostProcessor : BladePropertySourcePostProcessor init.
2022-10-04 10:31:24.740  INFO 16068 --- [           main] s.c.l.p.BladePropertySourcePostProcessor : BladePropertySourcePostProcessor process @BladePropertySource bean.
2022-10-04 10:31:24.742  WARN 16068 --- [           main] s.c.l.p.BladePropertySourcePostProcessor : Not found @BladePropertySource on spring bean class.
2022-10-04 10:31:24.936  WARN 16068 --- [           main] io.undertow.websockets.jsr               : UT026010: Buffer pool was not set on WebSocketDeploymentInfo, the default pool will be used
2022-10-04 10:31:24.954  INFO 16068 --- [           main] io.undertow.servlet                      : Initializing Spring embedded WebApplicationContext
2022-10-04 10:31:24.954  INFO 16068 --- [           main] w.s.c.ServletWebServerApplicationContext : Root WebApplicationContext: initialization completed in 856 ms
2022-10-04 10:31:25.025  INFO 16068 --- [           main] f.a.AutowiredAnnotationBeanPostProcessor : Inconsistent constructor declaration on bean with name 'serverInfo': single autowire-marked constructor flagged as optional - this constructor is effectively required since there is no default constructor to fall back to: public org.springblade.core.launch.server.ServerInfo(org.springframework.boot.autoconfigure.web.ServerProperties)
2022-10-04 10:31:25.126  INFO 16068 --- [           main] c.a.d.s.b.a.DruidDataSourceAutoConfigure : Init DruidDataSource
2022-10-04 10:31:26.610  INFO 16068 --- [           main] com.alibaba.druid.pool.DruidDataSource   : {dataSource-1} inited
2022-10-04 10:31:27.202  INFO 16068 --- [           main] guration$$EnhancerBySpringCGLIB$$7626502 : No deployment resources were found for autodeployment
2022-10-04 10:31:27.523  INFO 16068 --- [           main] uration$$EnhancerBySpringCGLIB$$57f96d48 : No deployment resources were found for autodeployment
2022-10-04 10:31:27.575  INFO 16068 --- [           main] uration$$EnhancerBySpringCGLIB$$af7aaf3a : No deployment resources were found for autodeployment
2022-10-04 10:31:27.599  INFO 16068 --- [           main] uration$$EnhancerBySpringCGLIB$$f3a029a8 : No deployment resources were found for autodeployment
2022-10-04 10:31:27.620  INFO 16068 --- [           main] o.f.a.s.SpringAppEngineConfiguration     : Found 6 Engine Configurators in total:
2022-10-04 10:31:27.620  INFO 16068 --- [           main] o.f.a.s.SpringAppEngineConfiguration     : class org.flowable.engine.spring.configurator.SpringProcessEngineConfigurator (priority:50000)
2022-10-04 10:31:27.620  INFO 16068 --- [           main] o.f.a.s.SpringAppEngineConfiguration     : class org.flowable.idm.spring.configurator.SpringIdmEngineConfigurator (priority:100000)
2022-10-04 10:31:27.620  INFO 16068 --- [           main] o.f.a.s.SpringAppEngineConfiguration     : class org.flowable.dmn.spring.configurator.SpringDmnEngineConfigurator (priority:200000)
2022-10-04 10:31:27.620  INFO 16068 --- [           main] o.f.a.s.SpringAppEngineConfiguration     : class org.flowable.form.spring.configurator.SpringFormEngineConfigurator (priority:300000)
2022-10-04 10:31:27.621  INFO 16068 --- [           main] o.f.a.s.SpringAppEngineConfiguration     : class org.flowable.content.spring.configurator.SpringContentEngineConfigurator (priority:400000)
2022-10-04 10:31:27.621  INFO 16068 --- [           main] o.f.a.s.SpringAppEngineConfiguration     : class org.flowable.cmmn.spring.configurator.SpringCmmnEngineConfigurator (priority:500000)
2022-10-04 10:31:27.621  INFO 16068 --- [           main] o.f.a.s.SpringAppEngineConfiguration     : Executing beforeInit() of class org.flowable.engine.spring.configurator.SpringProcessEngineConfigurator (priority:50000)
2022-10-04 10:31:27.625  INFO 16068 --- [           main] o.f.a.s.SpringAppEngineConfiguration     : Executing beforeInit() of class org.flowable.idm.spring.configurator.SpringIdmEngineConfigurator (priority:100000)
2022-10-04 10:31:27.627  INFO 16068 --- [           main] o.f.a.s.SpringAppEngineConfiguration     : Executing beforeInit() of class org.flowable.dmn.spring.configurator.SpringDmnEngineConfigurator (priority:200000)
2022-10-04 10:31:27.629  INFO 16068 --- [           main] o.f.a.s.SpringAppEngineConfiguration     : Executing beforeInit() of class org.flowable.form.spring.configurator.SpringFormEngineConfigurator (priority:300000)
2022-10-04 10:31:27.631  INFO 16068 --- [           main] o.f.a.s.SpringAppEngineConfiguration     : Executing beforeInit() of class org.flowable.content.spring.configurator.SpringContentEngineConfigurator (priority:400000)
2022-10-04 10:31:27.634  INFO 16068 --- [           main] o.f.a.s.SpringAppEngineConfiguration     : Executing beforeInit() of class org.flowable.cmmn.spring.configurator.SpringCmmnEngineConfigurator (priority:500000)
2022-10-04 10:31:28.223  INFO 16068 --- [           main] o.f.a.s.SpringAppEngineConfiguration     : Executing configure() of class org.flowable.engine.spring.configurator.SpringProcessEngineConfigurator (priority:50000)
2022-10-04 10:31:28.491  INFO 16068 --- [           main] o.f.engine.impl.ProcessEngineImpl        : ProcessEngine default created
2022-10-04 10:31:28.551  INFO 16068 --- [           main] o.f.e.impl.cmd.ValidateV5EntitiesCmd     : Total of v5 deployments found: 0
2022-10-04 10:31:28.722  INFO 16068 --- [           main] o.f.a.s.SpringAppEngineConfiguration     : Executing configure() of class org.flowable.idm.spring.configurator.SpringIdmEngineConfigurator (priority:100000)
2022-10-04 10:31:29.134  INFO 16068 --- [           main] o.f.idm.engine.impl.IdmEngineImpl        : IdmEngine default created
2022-10-04 10:31:29.137  INFO 16068 --- [           main] o.f.a.s.SpringAppEngineConfiguration     : Executing configure() of class org.flowable.dmn.spring.configurator.SpringDmnEngineConfigurator (priority:200000)
2022-10-04 10:31:29.147  INFO 16068 --- [           main] o.f.dmn.engine.impl.DmnEngineImpl        : DmnEngine default created
2022-10-04 10:31:29.148  INFO 16068 --- [           main] o.f.a.s.SpringAppEngineConfiguration     : Executing configure() of class org.flowable.form.spring.configurator.SpringFormEngineConfigurator (priority:300000)
2022-10-04 10:31:29.154  INFO 16068 --- [           main] o.f.form.engine.impl.FormEngineImpl      : FormEngine default created
2022-10-04 10:31:29.155  INFO 16068 --- [           main] o.f.a.s.SpringAppEngineConfiguration     : Executing configure() of class org.flowable.content.spring.configurator.SpringContentEngineConfigurator (priority:400000)
2022-10-04 10:31:29.158  INFO 16068 --- [           main] o.f.c.s.SpringContentEngineConfiguration : Content file system root : C:\Users\renji\content
2022-10-04 10:31:29.338  INFO 16068 --- [           main] o.f.c.engine.impl.ContentEngineImpl      : ContentEngine default created
2022-10-04 10:31:29.339  INFO 16068 --- [           main] o.f.a.s.SpringAppEngineConfiguration     : Executing configure() of class org.flowable.cmmn.spring.configurator.SpringCmmnEngineConfigurator (priority:500000)
2022-10-04 10:31:29.371  INFO 16068 --- [           main] o.f.cmmn.engine.impl.CmmnEngineImpl      : CmmnEngine default created
2022-10-04 10:31:29.373  INFO 16068 --- [           main] o.f.app.engine.impl.AppEngineImpl        : AppEngine default created
2022-10-04 10:31:29.486  WARN 16068 --- [           main] ion$DefaultTemplateResolverConfiguration : Cannot find template location: classpath:/templates/ (please add some templates or check your Thymeleaf configuration)
2022-10-04 10:31:29.486  WARN 16068 --- [           main] org.thymeleaf.templatemode.TemplateMode  : [THYMELEAF][main] Template Mode 'LEGACYHTML5' is deprecated. Using Template Mode 'HTML' instead.
2022-10-04 10:31:30.066  INFO 16068 --- [           main] io.undertow                              : starting server: Undertow - 2.2.18.Final
2022-10-04 10:31:30.070  INFO 16068 --- [           main] org.xnio                                 : XNIO version 3.8.7.Final
2022-10-04 10:31:30.075  INFO 16068 --- [           main] org.xnio.nio                             : XNIO NIO Implementation Version 3.8.7.Final
2022-10-04 10:31:30.109  INFO 16068 --- [           main] org.jboss.threads                        : JBoss Threads version 3.1.0.Final
2022-10-04 10:31:30.160  INFO 16068 --- [           main] o.s.b.w.e.undertow.UndertowWebServer     : Undertow started on port(s) 9999 (http)
2022-10-04 10:31:30.470  INFO 16068 --- [           main] o.s.core.launch.StartEventListener       : ---[BLADE-FLOWDESIGN]---启动完成,当前使用的端口:[9999],环境变量:[dev]---
2022-10-04 10:31:30.479  INFO 16068 --- [           main] o.s.flow.FlowDesignApplication           : Started FlowDesignApplication in 7.61 seconds (JVM running for 8.578)
2022-10-04 10:32:06.572  INFO 16068 --- [  XNIO-1 task-1] io.undertow.servlet                      : Initializing Spring DispatcherServlet 'dispatcherServlet'
2022-10-04 10:32:06.572  INFO 16068 --- [  XNIO-1 task-1] o.s.web.servlet.DispatcherServlet        : Initializing Servlet 'dispatcherServlet'
2022-10-04 10:32:06.573  INFO 16068 --- [  XNIO-1 task-1] o.s.web.servlet.DispatcherServlet        : Completed initialization in 1 ms
2022-10-04 10:32:10.451 ERROR 16068 --- [  XNIO-1 task-1] io.undertow.request                      : UT005023: Exception handling request to /app/rest/models

org.springframework.web.util.NestedServletException: Request processing failed; nested exception is org.springframework.dao.DataIntegrityViolationException: Error attempting to get column 'thumbnail' from result set.  Cause: org.postgresql.util.PSQLException: 不良的类型值 long : \x89504e470d0a1a0a0000000d494844520000002d0000002d08060000003a1ae29a000002e04944415478daed58df6b526118dec52efa23ba080aeacff08f48747a5051f157f3d74c10744ca6178a8c5d0b42188b2e4236314b6585919814132744b46a3936e7c19b31aa63fec8aff71d79135dcc73bef38de03c7038777ecf7978bee77d5e1716142850f0ff821072addd6edbb3d9ecab442271eef178c626938968b55ac271dcd4e9740ec3e1f0613299dc82e7f69593cde5720f63b1d8d8e7f391743a4d1a8d06e976bb6430181004befbfd3ed9dbdb23f051c4ebf54efd7e7fc766b35999130672e6783cfe33180c5e109a4c26e4b268b55a24140a4dec76fb07b55a7d8b85ba8bf97cfea5c3e1208542612eb27fa3542a11b3d92cc8aa3a12ae56ab6fdd6e373938382034d0e97408082058add67bb290468591307a9426f0f740ed6f4b4b4b1c750fa3256829fc2fc50d06c31910bf432d25d6d7d787e86139512c1605bd5eff860ae9ededed479812a3d188c80d97cbc54bb609aa8c398cb1c602fbfbfb43c96ae3a4c3cb2725dae605c4200fd3f48668d2389a33990c6189cdcdcd1690be2f9a3476091ccd2c51afd73b40ba209a34969f5eafc79434cff37d207d2c9a34b6b559f961053c0f480f4493c67a7915c0734593361a8d53d64a0b82c04b521ae26ec8dad3a7a7a71f25797a7575f513ebf42897cbcf24a5472a95cab0cee9b5b5b5a2a49c8e4422379797977f319c88039d4ef745d24444acacac7c66d53dc01a5b40f8b5e49667b158d4814060cc40ed3350b9496d198025b42d779fc6fb832aab54aa452aa4d163b884cab5b9409bccc3193d6a9bcb0c1cc7e941f11fb477c49393931ad8e288fa8e38031474332ea1b414478591b046a309c9fadf071ca005d5cf777676be4bb89c671b1b1b0fd012f09898fcc3841e07855e805df866b329cc93c3954ae5317cf43bbc74d43d7c49f277913c54d83e2c0cef6bb5da51b7dbedcd4a16961fec12bbbbbb4fa3d1e873b0d721924575a9a58404af5f07d57c40e6093c5fb1a561bdfcf33ec62e81a359f2a453a0408102050ae4c66fb109509232650d3b0000000049454e44ae426082
; 不良的类型值 long : \x89504e470d0a1a0a0000000d494844520000002d0000002d08060000003a1ae29a000002e04944415478daed58df6b526118dec52efa23ba080aeacff08f48747a5051f157f3d74c10744ca6178a8c5d0b42188b2e4236314b6585919814132744b46a3936e7c19b31aa63fec8aff71d79135dcc73bef38de03c7038777ecf7978bee77d5e1716142850f0ff821072addd6edbb3d9ecab442271eef178c626938968b55ac271dcd4e9740ec3e1f0613299dc82e7f69593cde5720f63b1d8d8e7f391743a4d1a8d06e976bb6430181004befbfd3ed9dbdb23f051c4ebf54efd7e7fc766b35999130672e6783cfe33180c5e109a4c26e4b268b55a24140a4dec76fb07b55a7d8b85ba8bf97cfea5c3e1208542612eb27fa3542a11b3d92cc8aa3a12ae56ab6fdd6e373938382034d0e97408082058add67bb290468591307a9426f0f740ed6f4b4b4b1c750fa3256829fc2fc50d06c31910bf432d25d6d7d787e86139512c1605bd5eff860ae9ededed479812a3d188c80d97cbc54bb609aa8c398cb1c602fbfbfb43c96ae3a4c3cb2725dae605c4200fd3f48668d2389a33990c6189cdcdcd1690be2f9a3476091ccd2c51afd73b40ba209a34969f5eafc79434cff37d207d2c9a34b6b559f961053c0f480f4493c67a7915c0734593361a8d53d64a0b82c04b521ae26ec8dad3a7a7a71f25797a7575f513ebf42897cbcf24a5472a95cab0cee9b5b5b5a2a49c8e4422379797977f319c88039d4ef745d24444acacac7c66d53dc01a5b40f8b5e49667b158d4814060cc40ed3350b9496d198025b42d779fc6fb832aab54aa452aa4d163b884cab5b9409bccc3193d6a9bcb0c1cc7e941f11fb477c49393931ad8e288fa8e38031474332ea1b414478591b046a309c9fadf071ca005d5cf777676be4bb89c671b1b1b0fd012f09898fcc3841e07855e805df866b329cc93c3954ae5317cf43bbc74d43d7c49f277913c54d83e2c0cef6bb5da51b7dbedcd4a16961fec12bbbbbb4fa3d1e873b0d721924575a9a58404af5f07d57c40e6093c5fb1a561bdfcf33ec62e81a359f2a453a0408102050ae4c66fb109509232650d3b0000000049454e44ae426082; nested exception is org.postgresql.util.PSQLException: 不良的类型值 long : \x89504e470d0a1a0a0000000d494844520000002d0000002d08060000003a1ae29a000002e04944415478daed58df6b526118dec52efa23ba080aeacff08f48747a5051f157f3d74c10744ca6178a8c5d0b42188b2e4236314b6585919814132744b46a3936e7c19b31aa63fec8aff71d79135dcc73bef38de03c7038777ecf7978bee77d5e1716142850f0ff821072addd6edbb3d9ecab442271eef178c626938968b55ac271dcd4e9740ec3e1f0613299dc82e7f69593cde5720f63b1d8d8e7f391743a4d1a8d06e976bb6430181004befbfd3ed9dbdb23f051c4ebf54efd7e7fc766b35999130672e6783cfe33180c5e109a4c26e4b268b55a24140a4dec76fb07b55a7d8b85ba8bf97cfea5c3e1208542612eb27fa3542a11b3d92cc8aa3a12ae56ab6fdd6e373938382034d0e97408082058add67bb290468591307a9426f0f740ed6f4b4b4b1c750fa3256829fc2fc50d06c31910bf432d25d6d7d787e86139512c1605bd5eff860ae9ededed479812a3d188c80d97cbc54bb609aa8c398cb1c602fbfbfb43c96ae3a4c3cb2725dae605c4200fd3f48668d2389a33990c6189cdcdcd1690be2f9a3476091ccd2c51afd73b40ba209a34969f5eafc79434cff37d207d2c9a34b6b559f961053c0f480f4493c67a7915c0734593361a8d53d64a0b82c04b521ae26ec8dad3a7a7a71f25797a7575f513ebf42897cbcf24a5472a95cab0cee9b5b5b5a2a49c8e4422379797977f319c88039d4ef745d24444acacac7c66d53dc01a5b40f8b5e49667b158d4814060cc40ed3350b9496d198025b42d779fc6fb832aab54aa452aa4d163b884cab5b9409bccc3193d6a9bcb0c1cc7e941f11fb477c49393931ad8e288fa8e38031474332ea1b414478591b046a309c9fadf071ca005d5cf777676be4bb89c671b1b1b0fd012f09898fcc3841e07855e805df866b329cc93c3954ae5317cf43bbc74d43d7c49f277913c54d83e2c0cef6bb5da51b7dbedcd4a16961fec12bbbbbb4fa3d1e873b0d721924575a9a58404af5f07d57c40e6093c5fb1a561bdfcf33ec62e81a359f2a453a0408102050ae4c66fb109509232650d3b0000000049454e44ae426082
	at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:1014) ~[spring-webmvc-5.3.21.jar:5.3.21]
	at org.springframework.web.servlet.FrameworkServlet.doGet(FrameworkServlet.java:898) ~[spring-webmvc-5.3.21.jar:5.3.21]
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:497) ~[jakarta.servlet-api-4.0.4.jar:4.0.4]
	at org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:883) ~[spring-webmvc-5.3.21.jar:5.3.21]
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:584) ~[jakarta.servlet-api-4.0.4.jar:4.0.4]
	at io.undertow.servlet.handlers.ServletHandler.handleRequest(ServletHandler.java:74) ~[undertow-servlet-2.2.18.Final.jar:2.2.18.Final]
	at io.undertow.servlet.handlers.FilterHandler$FilterChainImpl.doFilter(FilterHandler.java:129) ~[undertow-servlet-2.2.18.Final.jar:2.2.18.Final]
	at com.alibaba.druid.support.http.WebStatFilter.doFilter(WebStatFilter.java:124) ~[druid-1.2.8.jar:1.2.8]
	at io.undertow.servlet.core.ManagedFilter.doFilter(ManagedFilter.java:61) ~[undertow-servlet-2.2.18.Final.jar:2.2.18.Final]
	at io.undertow.servlet.handlers.FilterHandler$FilterChainImpl.doFilter(FilterHandler.java:131) ~[undertow-servlet-2.2.18.Final.jar:2.2.18.Final]
	at org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:201) ~[spring-web-5.3.21.jar:5.3.21]
	at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:117) ~[spring-web-5.3.21.jar:5.3.21]
	at io.undertow.servlet.core.ManagedFilter.doFilter(ManagedFilter.java:61) ~[undertow-servlet-2.2.18.Final.jar:2.2.18.Final]
	at io.undertow.servlet.handlers.FilterHandler$FilterChainImpl.doFilter(FilterHandler.java:131) ~[undertow-servlet-2.2.18.Final.jar:2.2.18.Final]
	at io.undertow.servlet.handlers.FilterHandler.handleRequest(FilterHandler.java:84) ~[undertow-servlet-2.2.18.Final.jar:2.2.18.Final]
	at io.undertow.servlet.handlers.security.ServletSecurityRoleHandler.handleRequest(ServletSecurityRoleHandler.java:62) ~[undertow-servlet-2.2.18.Final.jar:2.2.18.Final]
	at io.undertow.servlet.handlers.ServletChain$1.handleRequest(ServletChain.java:68) ~[undertow-servlet-2.2.18.Final.jar:2.2.18.Final]
	at io.undertow.servlet.handlers.ServletDispatchingHandler.handleRequest(ServletDispatchingHandler.java:36) ~[undertow-servlet-2.2.18.Final.jar:2.2.18.Final]
	at io.undertow.servlet.handlers.RedirectDirHandler.handleRequest(RedirectDirHandler.java:68) ~[undertow-servlet-2.2.18.Final.jar:2.2.18.Final]
	at io.undertow.servlet.handlers.security.SSLInformationAssociationHandler.handleRequest(SSLInformationAssociationHandler.java:117) ~[undertow-servlet-2.2.18.Final.jar:2.2.18.Final]
	at io.undertow.servlet.handlers.security.ServletAuthenticationCallHandler.handleRequest(ServletAuthenticationCallHandler.java:57) ~[undertow-servlet-2.2.18.Final.jar:2.2.18.Final]
	at io.undertow.server.handlers.PredicateHandler.handleRequest(PredicateHandler.java:43) ~[undertow-core-2.2.18.Final.jar:2.2.18.Final]
	at io.undertow.security.handlers.AbstractConfidentialityHandler.handleRequest(AbstractConfidentialityHandler.java:46) ~[undertow-core-2.2.18.Final.jar:2.2.18.Final]
	at io.undertow.servlet.handlers.security.ServletConfidentialityConstraintHandler.handleRequest(ServletConfidentialityConstraintHandler.java:64) ~[undertow-servlet-2.2.18.Final.jar:2.2.18.Final]
	at io.undertow.security.handlers.AuthenticationMechanismsHandler.handleRequest(AuthenticationMechanismsHandler.java:60) ~[undertow-core-2.2.18.Final.jar:2.2.18.Final]
	at io.undertow.servlet.handlers.security.CachedAuthenticatedSessionHandler.handleRequest(CachedAuthenticatedSessionHandler.java:77) ~[undertow-servlet-2.2.18.Final.jar:2.2.18.Final]
	at io.undertow.security.handlers.AbstractSecurityContextAssociationHandler.handleRequest(AbstractSecurityContextAssociationHandler.java:43) ~[undertow-core-2.2.18.Final.jar:2.2.18.Final]
	at io.undertow.server.handlers.PredicateHandler.handleRequest(PredicateHandler.java:43) ~[undertow-core-2.2.18.Final.jar:2.2.18.Final]
	at io.undertow.servlet.handlers.SendErrorPageHandler.handleRequest(SendErrorPageHandler.java:52) ~[undertow-servlet-2.2.18.Final.jar:2.2.18.Final]
	at io.undertow.server.handlers.PredicateHandler.handleRequest(PredicateHandler.java:43) ~[undertow-core-2.2.18.Final.jar:2.2.18.Final]
	at io.undertow.servlet.handlers.ServletInitialHandler.handleFirstRequest(ServletInitialHandler.java:275) [undertow-servlet-2.2.18.Final.jar:2.2.18.Final]
	at io.undertow.servlet.handlers.ServletInitialHandler.access$100(ServletInitialHandler.java:79) [undertow-servlet-2.2.18.Final.jar:2.2.18.Final]
	at io.undertow.servlet.handlers.ServletInitialHandler$2.call(ServletInitialHandler.java:134) [undertow-servlet-2.2.18.Final.jar:2.2.18.Final]
	at io.undertow.servlet.handlers.ServletInitialHandler$2.call(ServletInitialHandler.java:131) [undertow-servlet-2.2.18.Final.jar:2.2.18.Final]
	at io.undertow.servlet.core.ServletRequestContextThreadSetupAction$1.call(ServletRequestContextThreadSetupAction.java:48) [undertow-servlet-2.2.18.Final.jar:2.2.18.Final]
	at io.undertow.servlet.core.ContextClassLoaderSetupAction$1.call(ContextClassLoaderSetupAction.java:43) [undertow-servlet-2.2.18.Final.jar:2.2.18.Final]
	at io.undertow.servlet.handlers.ServletInitialHandler.dispatchRequest(ServletInitialHandler.java:255) [undertow-servlet-2.2.18.Final.jar:2.2.18.Final]
	at io.undertow.servlet.handlers.ServletInitialHandler.access$000(ServletInitialHandler.java:79) [undertow-servlet-2.2.18.Final.jar:2.2.18.Final]
	at io.undertow.servlet.handlers.ServletInitialHandler$1.handleRequest(ServletInitialHandler.java:100) [undertow-servlet-2.2.18.Final.jar:2.2.18.Final]
	at io.undertow.server.Connectors.executeRootHandler(Connectors.java:387) [undertow-core-2.2.18.Final.jar:2.2.18.Final]
	at io.undertow.server.HttpServerExchange$1.run(HttpServerExchange.java:852) [undertow-core-2.2.18.Final.jar:2.2.18.Final]
	at org.jboss.threads.ContextClassLoaderSavingRunnable.run(ContextClassLoaderSavingRunnable.java:35) [jboss-threads-3.1.0.Final.jar:3.1.0.Final]
	at org.jboss.threads.EnhancedQueueExecutor.safeRun(EnhancedQueueExecutor.java:2019) [jboss-threads-3.1.0.Final.jar:3.1.0.Final]
	at org.jboss.threads.EnhancedQueueExecutor$ThreadBody.doRunTask(EnhancedQueueExecutor.java:1558) [jboss-threads-3.1.0.Final.jar:3.1.0.Final]
	at org.jboss.threads.EnhancedQueueExecutor$ThreadBody.run(EnhancedQueueExecutor.java:1449) [jboss-threads-3.1.0.Final.jar:3.1.0.Final]
	at org.xnio.XnioWorker$WorkerThreadFactory$1$1.run(XnioWorker.java:1282) [xnio-api-3.8.7.Final.jar:3.8.7.Final]
	at java.lang.Thread.run(Thread.java:748) [na:1.8.0_311]
Caused by: org.springframework.dao.DataIntegrityViolationException: Error attempting to get column 'thumbnail' from result set.  Cause: org.postgresql.util.PSQLException: 不良的类型值 long : \x89504e470d0a1a0a0000000d494844520000002d0000002d08060000003a1ae29a000002e04944415478daed58df6b526118dec52efa23ba080aeacff08f48747a5051f157f3d74c10744ca6178a8c5d0b42188b2e4236314b6585919814132744b46a3936e7c19b31aa63fec8aff71d79135dcc73bef38de03c7038777ecf7978bee77d5e1716142850f0ff821072addd6edbb3d9ecab442271eef178c626938968b55ac271dcd4e9740ec3e1f0613299dc82e7f69593cde5720f63b1d8d8e7f391743a4d1a8d06e976bb6430181004befbfd3ed9dbdb23f051c4ebf54efd7e7fc766b35999130672e6783cfe33180c5e109a4c26e4b268b55a24140a4dec76fb07b55a7d8b85ba8bf97cfea5c3e1208542612eb27fa3542a11b3d92cc8aa3a12ae56ab6fdd6e373938382034d0e97408082058add67bb290468591307a9426f0f740ed6f4b4b4b1c750fa3256829fc2fc50d06c31910bf432d25d6d7d787e86139512c1605bd5eff860ae9ededed479812a3d188c80d97cbc54bb609aa8c398cb1c602fbfbfb43c96ae3a4c3cb2725dae605c4200fd3f48668d2389a33990c6189cdcdcd1690be2f9a3476091ccd2c51afd73b40ba209a34969f5eafc79434cff37d207d2c9a34b6b559f961053c0f480f4493c67a7915c0734593361a8d53d64a0b82c04b521ae26ec8dad3a7a7a71f25797a7575f513ebf42897cbcf24a5472a95cab0cee9b5b5b5a2a49c8e4422379797977f319c88039d4ef745d24444acacac7c66d53dc01a5b40f8b5e49667b158d4814060cc40ed3350b9496d198025b42d779fc6fb832aab54aa452aa4d163b884cab5b9409bccc3193d6a9bcb0c1cc7e941f11fb477c49393931ad8e288fa8e38031474332ea1b414478591b046a309c9fadf071ca005d5cf777676be4bb89c671b1b1b0fd012f09898fcc3841e07855e805df866b329cc93c3954ae5317cf43bbc74d43d7c49f277913c54d83e2c0cef6bb5da51b7dbedcd4a16961fec12bbbbbb4fa3d1e873b0d721924575a9a58404af5f07d57c40e6093c5fb1a561bdfcf33ec62e81a359f2a453a0408102050ae4c66fb109509232650d3b0000000049454e44ae426082
; 不良的类型值 long : \x89504e470d0a1a0a0000000d494844520000002d0000002d08060000003a1ae29a000002e04944415478daed58df6b526118dec52efa23ba080aeacff08f48747a5051f157f3d74c10744ca6178a8c5d0b42188b2e4236314b6585919814132744b46a3936e7c19b31aa63fec8aff71d79135dcc7

3. 感觉创建id的策略有问题, blade的微服务中也有类似问题,烦请查看


1条回答
  •  admin
    admin (楼主)
    2022-10-08 02:19

    如果是pg,需要修改一下配置,具体见下图

    image.png

    0 讨论(1)
提交回复