postgresql 创建流程入错

Java 未结

关注举报

 0  986

zhaixiaobin 剑者 2020-02-20 09:06

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

1. 创建流程

二、你期待的结果是什么？实际看到的又是什么？

三、你正在使用的是什么产品，什么版本？在什么操作系统上？

2.3.1

四、请提供详细的错误堆栈信息，这很重要。

Caused by: org.springframework.dao.DataIntegrityViolationException: Error attempting to get column 'thumbnail' from result set. Cause: org.postgresql.util.PSQLException: Bad value for type long : \x89504e470d0a1a0a0000000d494844520000002d0000002d08060000003a1ae29a0000032049444154785eed984b4b5b5110c7d595dfa174d57e91424bd72d241a834113250f6308280ac1804157e25a68372552c1554c5ac8a3358bb441ad153735125b4d438bad310f6d14538cc9e97f4ab2994dafb90f28dc1f5c2eb93977e6cf3067ceccedead2d1d1f97f1142f46c6e6e3e5d5e5e7e1308044ad3d3d335a7d3d9ecefef170e87a33e393959c5b3c3b9b9b9c5e1e1e1bbfc7d4d81d8de783cfedceff75f8f8c8c88a5a525b1b5b5258e8e8e44b95c1604dde9373da7ff6d365b637c7c3c373a3afa98db531d881843e46a5eaf5720caa2d168fc15f92f681dadf7783c7597cbb5dbd7d7778fdb561cf8ed4e24122b76bb5d44a351717373c3754982dea3f78786862e4d26d323ee4731e0ab3b140a7d40be8a6c36cb757404d9416a5d0d0c0cd8b83f45a00863638942a1c07dcb82ec61835e188dc687dca72c363636c648b05211e6c06ed362b19c190c86fbdc7747c066effcfc7c8d72504d2291c819d224cefd77442c167b4655a2d34d2715b28ffc2e224d1e700db702b67a666666aea94c69413a9d3ec7a1f49eebb815c8e527380824d761b9901fb3d97c8edcbec3b54826180cbea5934c4bd00aece1d071722d92c1a957d42a35daacafaf67902221ae4532535353b55c2ec7edaacac1c1411ea23f722d92416d6e562a156e5755d0645d40f431d72299c1c14151afd7b95d5581bf2a44ffe65a2483c6a8ae75a48bc5e2a1ac484f4c4c54b5cee9fdfdfd1d5939edf3f93e6b5d3dd6d6d65ec9aa1ea8998b5ad769b7db1d9555a769a6433fd0d0f0443c41948bb24e440233dd57ad52647575f5a5ecde83a02194663a0dbabcef10fc457697d70679b68b7ebac91d2948736161e1054447b9ef8ea189824622b52697542a1584e09f8a4d2e6d686ab65aad574acf88f97cfe3504ff507c466c435333225e552ae2ad081fe3b2725f8a4211414f7246335da79b93365d2b874f548b3087be0c21ea099ae96844925ac7b1ae80b2b6425502574c932f4c1c2a4f70fe0e23d2afd9d9d94fc964720ffdf0b752a974098d17a7a7a7b94c26b3130e8723a8f731ac2dd17ac5ca9a1ce80483180722477dc3362eaab9a275df6e3d77c83ee9747474747474d4e60f806f422c3cd059240000000049454e44ae426082

; Bad value for type long : \x89504e470d0a1a0a0000000d494844520000002d0000002d08060000003a1ae29a0000032049444154785eed984b4b5b5110c7d595dfa174d57e91424bd72d241a834113250f6308280ac1804157e25a68372552c1554c5ac8a3358bb441ad153735125b4d438bad310f6d14538cc9e97f4ab2994dafb90f28dc1f5c2eb93977e6cf3067ceccedead2d1d1f97f1142f46c6e6e3e5d5e5e7e1308044ad3d3d335a7d3d9ecefef170e87a33e393959c5b3c3b9b9b9c5e1e1e1bbfc7d4d81d8de783cfedceff75f8f8c8c88a5a525b1b5b5258e8e8e44b95c1604dde9373da7ff6d365b637c7c3c373a3afa98db531d881843e46a5eaf5720caa2d168fc15f92f681dadf7783c7597cbb5dbd7d7778fdb561cf8ed4e24122b76bb5d44a351717373c3754982dea3f78786862e4d26d323ee4731e0ab3b140a7d40be8a6c36cb757404d9416a5d0d0c0cd8b83f45a00863638942a1c07dcb82ec61835e188dc687dca72c363636c648b05211e6c06ed362b19c190c86fbdc7747c066effcfc7c8d72504d2291c819d224cefd77442c167b4655a2d34d2715b28ffc2e224d1e700db702b67a666666aea94c69413a9d3ec7a1f49eebb815c8e527380824d761b9901fb3d97c8edcbec3b54826180cbea5934c4bd00aece1d071722d92c1a957d42a35daacafaf67902221ae4532535353b55c2ec7edaacac1c1411ea23f722d92416d6e562a156e5755d0645d40f431d72299c1c14151afd7b95d5581bf2a44ffe65a2483c6a8ae75a48bc5e2a1ac484f4c4c54b5cee9fdfdfd1d5939edf3f93e6b5d3dd6d6d65ec9aa1ea8998b5ad769b7db1d9555a769a6433fd0d0f0443c41948bb24e440233dd57ad52647575f5a5ecde83a02194663a0dbabcef10fc457697d70679b68b7ebac91d2948736161e1054447b9ef8ea189824622b52697542a1584e09f8a4d2e6d686ab65aad574acf88f97cfe3504ff507c466c435333225e552ae2ad081fe3b2725f8a4211414f7246335da79b93365d2b874f548b3087be0c21ea099ae96844925ac7b1ae80b2b6425502574c932f4c1c2a4f70fe0e23d2afd9d9d94fc964720ffdf0b752a974098d17a7a7a7b94c26b3130e8723a8f731ac2dd17ac5ca9a1ce80483180722477dc3362eaab9a275df6e3d77c83ee9747474747474d4e60f806f422c3cd059240000000049454e44ae426082; nested exception is org.postgresql.util.PSQLException: Bad value for type long : \x89504e470d0a1a0a0000000d494844520000002d0000002d08060000003a1ae29a0000032049444154785eed984b4b5b5110c7d595dfa174d57e91424bd72d241a834113250f6308280ac1804157e25a68372552c1554c5ac8a3358bb441ad153735125b4d438bad310f6d14538cc9e97f4ab2994dafb90f28dc1f5c2eb93977e6cf3067ceccedead2d1d1f97f1142f46c6e6e3e5d5e5e7e1308044ad3d3d335a7d3d9ecefef170e87a33e393959c5b3c3b9b9b9c5e1e1e1bbfc7d4d81d8de783cfedceff75f8f8c8c88a5a525b1b5b5258e8e8e44b95c1604dde9373da7ff6d365b637c7c3c373a3afa98db531d881843e46a5eaf5720caa2d168fc15f92f681dadf7783c7597cbb5dbd7d7778fdb561cf8ed4e24122b76bb5d44a351717373c3754982dea3f78786862e4d26d323ee4731e0ab3b140a7d40be8a6c36cb757404d9416a5d0d0c0cd8b83f45a00863638942a1c07dcb82ec61835e188dc687dca72c363636c648b05211e6c06ed362b19c190c86fbdc7747c066effcfc7c8d72504d2291c819d224cefd77442c167b4655a2d34d2715b28ffc2e224d1e700db702b67a666666aea94c69413a9d3ec7a1f49eebb815c8e527380824d761b9901fb3d97c8edcbec3b54826180cbea5934c4bd00aece1d071722d92c1a957d42a35daacafaf67902221ae4532535353b55c2ec7edaacac1c1411ea23f722d92416d6e562a156e5755d0645d40f431d72299c1c14151afd7b95d5581bf2a44ffe65a2483c6a8ae75a48bc5e2a1ac484f4c4c54b5cee9fdfdfd1d5939edf3f93e6b5d3dd6d6d65ec9aa1ea8998b5ad769b7db1d9555a769a6433fd0d0f0443c41948bb24e440233dd57ad52647575f5a5ecde83a02194663a0dbabcef10fc457697d70679b68b7ebac91d2948736161e1054447b9ef8ea189824622b52697542a1584e09f8a4d2e6d686ab65aad574acf88f97cfe3504ff507c466c435333225e552ae2ad081fe3b2725f8a4211414f7246335da79b93365d2b874f548b3087be0c21ea099ae96844925ac7b1ae80b2b6425502574c932f4c1c2a4f70fe0e23d2afd9d9d94fc964720ffdf0b752a974098d17a7a7a7b94c26b3130e8723a8f731ac2dd17ac5ca9a1ce80483180722477dc3362eaab9a275df6e3d77c83ee9747474747474d4e60f806f422c3cd059240000000049454e44ae426082

at org.springframework.jdbc.support.SQLStateSQLExceptionTranslator.doTranslate(SQLStateSQLExceptionTranslator.java:104) ~[spring-jdbc-5.1.12.RELEASE.jar!/:5.1.12.RELEASE]

at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:72) ~[spring-jdbc-5.1.12.RELEASE.jar!/:5.1.12.RELEASE]

at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:81) ~[spring-jdbc-5.1.12.RELEASE.jar!/:5.1.12.RELEASE]

at org.mybatis.spring.MyBatisExceptionTranslator.translateExceptionIfPossible(MyBatisExceptionTranslator.java:88) ~[mybatis-spring-2.0.3.jar!/:2.0.3]

at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:440) ~[mybatis-spring-2.0.3.jar!/:2.0.3]

at com.sun.proxy.$Proxy76.selectOne(Unknown Source) ~[na:na]

at org.mybatis.spring.SqlSessionTemplate.selectOne(SqlSessionTemplate.java:159) ~[mybatis-spring-2.0.3.jar!/:2.0.3]

at org.flowable.ui.modeler.repository.ModelRepositoryImpl.get(ModelRepositoryImpl.java:42) ~[flowable-ui-modeler-logic-6.4.2.jar!/:6.4.2]

at org.flowable.ui.modeler.service.ModelServiceImpl.getModel(ModelServiceImpl.java:112) ~[flowable-ui-modeler-logic-6.4.2.jar!/:6.4.2]

at org.flowable.ui.modeler.service.ModelServiceImpl$$FastClassBySpringCGLIB$$93d99e9b.invoke() ~[flowable-ui-modeler-logic-6.4.2.jar!/:6.4.2]

at org.springframework.cglib.proxy.MethodProxy.invoke(MethodProxy.java:218) ~[spring-core-5.1.12.RELEASE.jar!/:5.1.12.RELEASE]

at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.invokeJoinpoint(CglibAopProxy.java:750) ~[spring-aop-5.1.12.RELEASE.jar!/:5.1.12.RELEASE]

at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:163) ~[spring-aop-5.1.12.RELEASE.jar!/:5.1.12.RELEASE]

at org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:295) ~[spring-tx-5.1.12.RELEASE.jar!/:5.1.12.RELEASE]

at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:98) ~[spring-tx-5.1.12.RELEASE.jar!/:5.1.12.RELEASE]

at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186) ~[spring-aop-5.1.12.RELEASE.jar!/:5.1.12.RELEASE]

at org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:689) ~[spring-aop-5.1.12.RELEASE.jar!/:5.1.12.RELEASE]

at org.flowable.ui.modeler.service.ModelServiceImpl$$EnhancerBySpringCGLIB$$7eda9437.getModel() ~[flowable-ui-modeler-logic-6.4.2.jar!/:6.4.2]

at org.flowable.ui.modeler.rest.app.ModelResource.getModelJSON(ModelResource.java:157) ~[flowable-ui-modeler-rest-6.4.2.jar!/:6.4.2]

at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method) ~[na:na]

at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) ~[na:na]

at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[na:na]

at java.base/java.lang.reflect.Method.invoke(Method.java:566) ~[na:na]

at org.springframework.web.method.support.InvocableHandlerMethod.doInvoke(InvocableHandlerMethod.java:190) ~[spring-web-5.1.12.RELEASE.jar!/:5.1.12.RELEASE]

at org.springframework.web.method.support.InvocableHandlerMethod.invokeForRequest(InvocableHandlerMethod.java:138) ~[spring-web-5.1.12.RELEASE.jar!/:5.1.12.RELEASE]

at org.springframework.web.servlet.mvc.method.annotation.ServletInvocableHandlerMethod.invokeAndHandle(ServletInvocableHandlerMethod.java:105) ~[spring-webmvc-5.1.12.RELEASE.jar!/:5.1.12.RELEASE]

at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.invokeHandlerMethod(RequestMappingHandlerAdapter.java:893) ~[spring-webmvc-5.1.12.RELEASE.jar!/:5.1.12.RELEASE]

at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.handleInternal(RequestMappingHandlerAdapter.java:798) ~[spring-webmvc-5.1.12.RELEASE.jar!/:5.1.12.RELEASE]

at org.springframework.web.servlet.mvc.method.AbstractHandlerMethodAdapter.handle(AbstractHandlerMethodAdapter.java:87) ~[spring-webmvc-5.1.12.RELEASE.jar!/:5.1.12.RELEASE]

at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:1040) ~[spring-webmvc-5.1.12.RELEASE.jar!/:5.1.12.RELEASE]

at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:943) ~[spring-webmvc-5.1.12.RELEASE.jar!/:5.1.12.RELEASE]

at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:1006) ~[spring-webmvc-5.1.12.RELEASE.jar!/:5.1.12.RELEASE]

... 42 common frames omitted

Caused by: org.postgresql.util.PSQLException: Bad value for type long : \x89504e470d0a1a0a0000000d494844520000002d0000002d08060000003a1ae29a0000032049444154785eed984b4b5b5110c7d595dfa174d57e91424bd72d241a834113250f6308280ac1804157e25a68372552c1554c5ac8a3358bb441ad153735125b4d438bad310f6d14538cc9e97f4ab2994dafb90f28dc1f5c2eb93977e6cf3067ceccedead2d1d1f97f1142f46c6e6e3e5d5e5e7e1308044ad3d3d335a7d3d9ecefef170e87a33e393959c5b3c3b9b9b9c5e1e1e1bbfc7d4d81d8de783cfedceff75f8f8c8c88a5a525b1b5b5258e8e8e44b95c1604dde9373da7ff6d365b637c7c3c373a3afa98db531d881843e46a5eaf5720caa2d168fc15f92f681dadf7783c7597cbb5dbd7d7778fdb561cf8ed4e24122b76bb5d44a351717373c3754982dea3f78786862e4d26d323ee4731e0ab3b140a7d40be8a6c36cb757404d9416a5d0d0c0cd8b83f45a00863638942a1c07dcb82ec61835e188dc687dca72c363636c648b05211e6c06ed362b19c190c86fbdc7747c066effcfc7c8d72504d2291c819d224cefd77442c167b4655a2d34d2715b28ffc2e224d1e700db702b67a666666aea94c69413a9d3ec7a1f49eebb815c8e527380824d761b9901fb3d97c8edcbec3b54826180cbea5934c4bd00aece1d071722d92c1a957d42a35daacafaf67902221ae4532535353b55c2ec7edaacac1c1411ea23f722d92416d6e562a156e5755d0645d40f431d72299c1c14151afd7b95d5581bf2a44ffe65a2483c6a8ae75a48bc5e2a1ac484f4c4c54b5cee9fdfdfd1d5939edf3f93e6b5d3dd6d6d65ec9aa1ea8998b5ad769b7db1d9555a769a6433fd0d0f0443c41948bb24e440233dd57ad52647575f5a5ecde83a02194663a0dbabcef10fc457697d70679b68b7ebac91d2948736161e1054447b9ef8ea189824622b52697542a1584e09f8a4d2e6d686ab65aad574acf88f97cfe3504ff507c466c435333225e552ae2ad081fe3b2725f8a4211414f7246335da79b93365d2b874f548b3087be0c21ea099ae96844925ac7b1ae80b2b6425502574c932f4c1c2a4f70fe0e23d2afd9d9d94fc964720ffdf0b752a974098d17a7a7a7b94c26b3130e8723a8f731ac2dd17ac5ca9a1ce80483180722477dc3362eaab9a275df6e3d77c83ee9747474747474d4e60f806f422c3cd059240000000049454e44ae426082

at org.postgresql.jdbc.PgResultSet.toLong(PgResultSet.java:2828) ~[postgresql-42.2.6.jar!/:42.2.6]

at org.postgresql.jdbc.PgResultSet.getLong(PgResultSet.java:2042) ~[postgresql-42.2.6.jar!/:42.2.6]

at org.postgresql.jdbc.PgResultSet.getBlob(PgResultSet.java:416) ~[postgresql-42.2.6.jar!/:42.2.6]

at org.postgresql.jdbc.PgResultSet.getBlob(PgResultSet.java:403) ~[postgresql-42.2.6.jar!/:42.2.6]

at com.alibaba.druid.pool.DruidPooledResultSet.getBlob(DruidPooledResultSet.java:1169) ~[druid-1.1.21.jar!/:1.1.21]

at org.apache.ibatis.type.BlobTypeHandler.getNullableResult(BlobTypeHandler.java:40) ~[mybatis-3.5.3.jar!/:3.5.3]

at org.apache.ibatis.type.BlobTypeHandler.getNullableResult(BlobTypeHandler.java:28) ~[mybatis-3.5.3.jar!/:3.5.3]

at org.apache.ibatis.type.BaseTypeHandler.getResult(BaseTypeHandler.java:81) ~[mybatis-3.5.3.jar!/:3.5.3]

at org.apache.ibatis.executor.resultset.DefaultResultSetHandler.getPropertyMappingValue(DefaultResultSetHandler.java:472) ~[mybatis-3.5.3.jar!/:3.5.3]

at org.apache.ibatis.executor.resultset.DefaultResultSetHandler.applyPropertyMappings(DefaultResultSetHandler.java:441) ~[mybatis-3.5.3.jar!/:3.5.3]

at org.apache.ibatis.executor.resultset.DefaultResultSetHandler.getRowValue(DefaultResultSetHandler.java:404) ~[mybatis-3.5.3.jar!/:3.5.3]

at org.apache.ibatis.executor.resultset.DefaultResultSetHandler.handleRowValuesForSimpleResultMap(DefaultResultSetHandler.java:354) ~[mybatis-3.5.3.jar!/:3.5.3]

at org.apache.ibatis.executor.resultset.DefaultResultSetHandler.handleRowValues(DefaultResultSetHandler.java:328) ~[mybatis-3.5.3.jar!/:3.5.3]

at org.apache.ibatis.executor.resultset.DefaultResultSetHandler.handleResultSet(DefaultResultSetHandler.java:301) ~[mybatis-3.5.3.jar!/:3.5.3]

at org.apache.ibatis.executor.resultset.DefaultResultSetHandler.handleResultSets(DefaultResultSetHandler.java:194) ~[mybatis-3.5.3.jar!/:3.5.3]

at org.apache.ibatis.executor.statement.PreparedStatementHandler.query(PreparedStatementHandler.java:65) ~[mybatis-3.5.3.jar!/:3.5.3]

at org.apache.ibatis.executor.statement.RoutingStatementHandler.query(RoutingStatementHandler.java:79) ~[mybatis-3.5.3.jar!/:3.5.3]

at org.apache.ibatis.executor.SimpleExecutor.doQuery(SimpleExecutor.java:63) ~[mybatis-3.5.3.jar!/:3.5.3]

at org.apache.ibatis.executor.BaseExecutor.queryFromDatabase(BaseExecutor.java:324) ~[mybatis-3.5.3.jar!/:3.5.3]

at org.apache.ibatis.executor.BaseExecutor.query(BaseExecutor.java:156) ~[mybatis-3.5.3.jar!/:3.5.3]

at org.apache.ibatis.executor.CachingExecutor.query(CachingExecutor.java:109) ~[mybatis-3.5.3.jar!/:3.5.3]

at org.apache.ibatis.executor.CachingExecutor.query(CachingExecutor.java:83) ~[mybatis-3.5.3.jar!/:3.5.3]

at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:147) ~[mybatis-3.5.3.jar!/:3.5.3]

at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:140) ~[mybatis-3.5.3.jar!/:3.5.3]

at org.apache.ibatis.session.defaults.DefaultSqlSession.selectOne(DefaultSqlSession.java:76) ~[mybatis-3.5.3.jar!/:3.5.3]

at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method) ~[na:na]

at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) ~[na:na]

at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[na:na]

at java.base/java.lang.reflect.Method.invoke(Method.java:566) ~[na:na]

at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:426) ~[mybatis-spring-2.0.3.jar!/:2.0.3]

... 69 common frames omitted

五、若有更多详细信息，请在下面提供。