flow-design 从mysql数据源切换为postgre数据源后创建报错

Blade 已结 1 646
许浩
许浩 2022-03-31 16:50

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

1. flow-design 从mysql数据源切换为postgre数据源后创建报错

2. 

3.


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

能正常创建流程模型


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

2.8.2.RELEASE

linux

springcloud

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) ~[na:1.8.0_202]

        at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) ~[na:1.8.0_202]

        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[na:1.8.0_202]

        at java.lang.reflect.Method.invoke(Method.java:498) ~[na:1.8.0_202]

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

        ... 74 common frames omitted


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

1条回答
  •  admin
    admin (楼主)
    2022-03-31 17:00

    使用红框内配置代替现有配置

    image.png

    0 讨论(1)
提交回复