SEATA 1.4.x版本在MySQL8.0中执行undo时报错Cannot construct instance of `java.time.LocalDateTime`的原因及解决方法

最新推荐文章于 2024-07-31 10:34:02 发布
最新推荐文章于 2024-07-31 10:34:02 发布
阅读量3k 收藏 3
点赞数 5
分类专栏： 分布式 微服务 文章标签： spring cloud alibaba 微服务
版权声明：本文为博主原创文章，遵循 CC 4.0 BY 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.csdn.net/richie696/article/details/116896511
版权

SEATA 1.4.x版本在MySQL8.0下DATETIME类型转换错误的问题

该BUG的官方修复补丁已经提交，并且合并到了1.5.0开发分支版本，可以尝试更新的最新的1.5.0版本来解决该问题，不过由于该目前尚未Release，所以请应用于生产环境。

Pull request：https://github.com/seata/seata/pull/3738

SEATA在MySQL8.0上对Datetime类型的转换存在BUG，这个问题让我抓狂，根据错误堆栈的信息打开代码以后发现该问题系BUG，错误堆栈信息如下：

2021-05-16 16:47:32.924  INFO 22268 --- [h_RMROLE_1_8_16] i.seata.rm.datasource.DataSourceManager  : branchRollback failed. branchType:[AT], xid:[172.20.48.1:8091:5485518365424181316], branchId:[5485518365424181322], resourceId:[jdbc:mysql://localhost:3306/seata_order], applicationData:[null]. reason:[Branch session rollback failed and try again later xid = 172.20.48.1:8091:5485518365424181316 branchId = 5485518365424181322 com.fasterxml.jackson.databind.exc.InvalidDefinitionException: Cannot construct instance of `java.time.LocalDateTime` (no Creators, like default constructor, exist): cannot deserialize from Object value (no delegate- or property-based Creator)
 at [Source: (byte[])"{"@class":"io.seata.rm.datasource.undo.BranchUndoLog","xid":"172.20.48.1:8091:5485518365424181316","branchId":5485518365424181322,"sqlUndoLogs":["java.util.ArrayList",[{"@class":"io.seata.rm.datasource.undo.SQLUndoLog","sqlType":"INSERT","tableName":"t_order","beforeImage":{"@class":"io.seata.rm.datasource.sql.struct.TableRecords$EmptyTableRecords","tableName":"t_order","rows":["java.util.ArrayList",[]]},"afterImage":{"@class":"io.seata.rm.datasource.sql.struct.TableRecords","tableName":"t_order"[truncated 14288 bytes]; line: 1, column: 1249] (through reference chain: io.seata.rm.datasource.undo.BranchUndoLog["sqlUndoLogs"]->java.util.ArrayList[0]->io.seata.rm.datasource.undo.SQLUndoLog["afterImage"]->io.seata.rm.datasource.sql.struct.TableRecords["rows"]->java.util.ArrayList[0]->io.seata.rm.datasource.sql.struct.Row["fields"]->java.util.ArrayList[4]->io.seata.rm.datasource.sql.struct.Field["value"])]
2021-05-16 16:47:32.924  INFO 22268 --- [h_RMROLE_1_8_16] io.seata.rm.AbstractRMHandler            : Branch Rollbacked result: PhaseTwo_RollbackFailed_Retryable
2021-05-16 16:47:33.911  INFO 22268 --- [h_RMROLE_1_9_16] i.s.c.r.p.c.RmBranchRollbackProcessor    : rm handle branch rollback process:xid=172.20.48.1:8091:5485518365424181316,branchId=5485518365424181322,branchType=AT,resourceId=jdbc:mysql://localhost:3306/seata_order,applicationData=null
2021-05-16 16:47:33.911  INFO 22268 --- [h_RMROLE_1_9_16] io.seata.rm.AbstractRMHandler            : Branch Rollbacking: 172.20.48.1:8091:5485518365424181316 5485518365424181322 jdbc:mysql://localhost:3306/seata_order
2021-05-16 16:47:33.914 ERROR 22268 --- [h_RMROLE_1_9_16] i.s.r.d.u.parser.JacksonUndoLogParser    : json decode exception, Cannot construct instance of `java.time.LocalDateTime` (no Creators, like default constructor, exist): cannot deserialize from Object value (no delegate- or property-based Creator)
 at [Source: (byte[])"{"@class":"io.seata.rm.datasource.undo.BranchUndoLog","xid":"172.20.48.1:8091:5485518365424181316","branchId":5485518365424181322,"sqlUndoLogs":["java.util.ArrayList",[{"@class":"io.seata.rm.datasource.undo.SQLUndoLog","sqlType":"INSERT","tableName":"t_order","beforeImage":{"@class":"io.seata.rm.datasource.sql.struct.TableRecords$EmptyTableRecords","tableName":"t_order","rows":["java.util.ArrayList",[]]},"afterImage":{"@class":"io.seata.rm.datasource.sql.struct.TableRecords","tableName":"t_order"[truncated 14288 bytes]; line: 1, column: 1249] (through reference chain: io.seata.rm.datasource.undo.BranchUndoLog["sqlUndoLogs"]->java.util.ArrayList[0]->io.seata.rm.datasource.undo.SQLUndoLog["afterImage"]->io.seata.rm.datasource.sql.struct.TableRecords["rows"]->java.util.ArrayList[0]->io.seata.rm.datasource.sql.struct.Row["fields"]->java.util.ArrayList[4]->io.seata.rm.datasource.sql.struct.Field["value"])

com.fasterxml.jackson.databind.exc.InvalidDefinitionException: Cannot construct instance of `java.time.LocalDateTime` (no Creators, like default constructor, exist): cannot deserialize from Object value (no delegate- or property-based Creator)
 at [Source: (byte[])"{"@class":"io.seata.rm.datasource.undo.BranchUndoLog","xid":"172.20.48.1:8091:5485518365424181316","branchId":5485518365424181322,"sqlUndoLogs":["java.util.ArrayList",[{"@class":"io.seata.rm.datasource.undo.SQLUndoLog","sqlType":"INSERT","tableName":"t_order","beforeImage":{"@class":"io.seata.rm.datasource.sql.struct.TableRecords$EmptyTableRecords","tableName":"t_order","rows":["java.util.ArrayList",[]]},"afterImage":{"@class":"io.seata.rm.datasource.sql.struct.TableRecords","tableName":"t_order"[truncated 14288 bytes]; line: 1, column: 1249] (through reference chain: io.seata.rm.datasource.undo.BranchUndoLog["sqlUndoLogs"]->java.util.ArrayList[0]->io.seata.rm.datasource.undo.SQLUndoLog["afterImage"]->io.seata.rm.datasource.sql.struct.TableRecords["rows"]->java.util.ArrayList[0]->io.seata.rm.datasource.sql.struct.Row["fields"]->java.util.ArrayList[4]->io.seata.rm.datasource.sql.struct.Field["value"])
	at com.fasterxml.jackson.databind.exc.InvalidDefinitionException.from(InvalidDefinitionException.java:67) ~[jackson-databind-2.11.4.jar:2.11.4]
	at com.fasterxml.jackson.databind.DeserializationContext.reportBadDefinition(DeserializationContext.java:1615) ~[jackson-databind-2.11.4.jar:2.11.4]
	at com.fasterxml.jackson.databind.DatabindContext.reportBadDefinition(DatabindContext.java:400) ~[jackson-databind-2.11.4.jar:2.11.4]
	at com.fasterxml.jackson.databind.DeserializationContext.handleMissingInstantiator(DeserializationContext.java:1077) ~[jackson-databind-2.11.4.jar:2.11.4]
	at com.fasterxml.jackson.databind.deser.BeanDeserializerBase.deserializeFromObjectUsingNonDefault(BeanDeserializerBase.java:1332) ~[jackson-databind-2.11.4.jar:2.11.4]
	at com.fasterxml.jackson.databind.deser.BeanDeserializer.deserializeFromObject(BeanDeserializer.java:331) ~[jackson-databind-2.11.4.jar:2.11.4]
	at com.fasterxml.jackson.databind.deser.BeanDeserializer._deserializeOther(BeanDeserializer.java:199) ~[jackson-databind-2.11.4.jar:2.11.4]
	at com.fasterxml.jackson.databind.deser.BeanDeserializer.deserialize(BeanDeserializer.java:166) ~[jackson-databind-2.11.4.jar:2.11.4]
	at com.fasterxml.jackson.databind.jsontype.impl.AsPropertyTypeDeserializer._deserializeTypedForId(AsPropertyTypeDeserializer.java:132) ~[jackson-databind-2.11.4.jar:2.11.4]
	at com.fasterxml.jackson.databind.jsontype.impl.AsPropertyTypeDeserializer.deserializeTypedFromObject(AsPropertyTypeDeserializer.java:99) ~[jackson-databind-2.11.4.jar:2.11.4]
	at com.fasterxml.jackson.databind.jsontype.impl.AsPropertyTypeDeserializer.deserializeTypedFromAny(AsPropertyTypeDeserializer.java:195) ~[jackson-databind-2.11.4.jar:2.11.4]
	at com.fasterxml.jackson.databind.deser.std.UntypedObjectDeserializer$Vanilla.deserializeWithType(UntypedObjectDeserializer.java:710) ~[jackson-databind-2.11.4.jar:2.11.4]
	at com.fasterxml.jackson.databind.deser.impl.MethodProperty.deserializeAndSet(MethodProperty.java:138) ~[jackson-databind-2.11.4.jar:2.11.4]
	at com.fasterxml.jackson.databind.deser.BeanDeserializer.vanillaDeserialize(BeanDeserializer.java:293) ~[jackson-databind-2.11.4.jar:2.11.4]
	at com.fasterxml.jackson.databind.deser.BeanDeserializer._deserializeOther(BeanDeserializer.java:194) ~[jackson-databind-2.11.4.jar:2.11.4]
	at com.fasterxml.jackson.databind.deser.BeanDeserializer.deserialize(BeanDeserializer.java:166) ~[jackson-databind-2.11.4.jar:2.11.4]
	at com.fasterxml.jackson.databind.jsontype.impl.AsPropertyTypeDeserializer._deserializeTypedForId(AsPropertyTypeDeserializer.java:132) ~[jackson-databind-2.11.4.jar:2.11.4]
	at com.fasterxml.jackson.databind.jsontype.impl.AsPropertyTypeDeserializer.deserializeTypedFromObject(AsPropertyTypeDeserializer.java:99) ~[jackson-databind-2.11.4.jar:2.11.4]
	at com.fasterxml.jackson.databind.deser.BeanDeserializerBase.deserializeWithType(BeanDeserializerBase.java:1209) ~[jackson-databind-2.11.4.jar:2.11.4]
	at com.fasterxml.jackson.databind.deser.std.CollectionDeserializer.deserialize(CollectionDeserializer.java:292) ~[jackson-databind-2.11.4.jar:2.11.4]
	at com.fasterxml.jackson.databind.deser.std.CollectionDeserializer.deserialize(CollectionDeserializer.java:249) ~[jackson-databind-2.11.4.jar:2.11.4]
	at com.fasterxml.jackson.databind.deser.std.CollectionDeserializer.deserialize(CollectionDeserializer.java:26) ~[jackson-databind-2.11.4.jar:2.11.4]
	at com.fasterxml.jackson.databind.jsontype.impl.AsArrayTypeDeserializer._deserialize(AsArrayTypeDeserializer.java:120) ~[jackson-databind-2.11.4.jar:2.11.4]
	at com.fasterxml.jackson.databind.jsontype.impl.AsArrayTypeDeserializer.deserializeTypedFromArray(AsArrayTypeDeserializer.java:53) ~[jackson-databind-2.11.4.jar:2.11.4]
	at com.fasterxml.jackson.databind.deser.std.CollectionDeserializer.deserializeWithType(CollectionDeserializer.java:318) ~[jackson-databind-2.11.4.jar:2.11.4]
	at com.fasterxml.jackson.databind.deser.impl.MethodProperty.deserializeAndSet(MethodProperty.java:138) ~[jackson-databind-2.11.4.jar:2.11.4]
	at com.fasterxml.jackson.databind.deser.BeanDeserializer.vanillaDeserialize(BeanDeserializer.java:293) ~[jackson-databind-2.11.4.jar:2.11.4]
	at com.fasterxml.jackson.databind.deser.BeanDeserializer._deserializeOther(BeanDeserializer.java:194) ~[jackson-databind-2.11.4.jar:2.11.4]
	at com.fasterxml.jackson.databind.deser.BeanDeserializer.deserialize(BeanDeserializer.java:166) ~[jackson-databind-2.11.4.jar:2.11.4]
	at com.fasterxml.jackson.databind.jsontype.impl.AsPropertyTypeDeserializer._deserializeTypedForId(AsPropertyTypeDeserializer.java:132) ~[jackson-databind-2.11.4.jar:2.11.4]
	at com.fasterxml.jackson.databind.jsontype.impl.AsPropertyTypeDeserializer.deserializeTypedFromObject(AsPropertyTypeDeserializer.java:99) ~[jackson-databind-2.11.4.jar:2.11.4]
	at com.fasterxml.jackson.databind.deser.BeanDeserializerBase.deserializeWithType(BeanDeserializerBase.java:1209) ~[jackson-databind-2.11.4.jar:2.11.4]
	at com.fasterxml.jackson.databind.deser.std.CollectionDeserializer.deserialize(CollectionDeserializer.java:292) ~[jackson-databind-2.11.4.jar:2.11.4]
	at com.fasterxml.jackson.databind.deser.std.CollectionDeserializer.deserialize(CollectionDeserializer.java:249) ~[jackson-databind-2.11.4.jar:2.11.4]
	at com.fasterxml.jackson.databind.deser.std.CollectionDeserializer.deserialize(CollectionDeserializer.java:26) ~[jackson-databind-2.11.4.jar:2.11.4]
	at com.fasterxml.jackson.databind.jsontype.impl.AsArrayTypeDeserializer._deserialize(AsArrayTypeDeserializer.java:120) ~[jackson-databind-2.11.4.jar:2.11.4]
	at com.fasterxml.jackson.databind.jsontype.impl.AsArrayTypeDeserializer.deserializeTypedFromArray(AsArrayTypeDeserializer.java:53) ~[jackson-databind-2.11.4.jar:2.11.4]
	at com.fasterxml.jackson.databind.deser.std.CollectionDeserializer.deserializeWithType(CollectionDeserializer.java:318) ~[jackson-databind-2.11.4.jar:2.11.4]
	at com.fasterxml.jackson.databind.deser.impl.MethodProperty.deserializeAndSet(MethodProperty.java:138) ~[jackson-databind-2.11.4.jar:2.11.4]
	at com.fasterxml.jackson.databind.deser.BeanDeserializer.vanillaDeserialize(BeanDeserializer.java:293) ~[jackson-databind-2.11.4.jar:2.11.4]
	at com.fasterxml.jackson.databind.deser.BeanDeserializer._deserializeOther(BeanDeserializer.java:194) ~[jackson-databind-2.11.4.jar:2.11.4]
	at com.fasterxml.jackson.databind.deser.BeanDeserializer.deserialize(BeanDeserializer.java:166) ~[jackson-databind-2.11.4.jar:2.11.4]
	at com.fasterxml.jackson.databind.jsontype.impl.AsPropertyTypeDeserializer._deserializeTypedForId(AsPropertyTypeDeserializer.java:132) ~[jackson-databind-2.11.4.jar:2.11.4]
	at com.fasterxml.jackson.databind.jsontype.impl.AsPropertyTypeDeserializer.deserializeTypedFromObject(AsPropertyTypeDeserializer.java:99) ~[jackson-databind-2.11.4.jar:2.11.4]
	at com.fasterxml.jackson.databind.deser.BeanDeserializerBase.deserializeWithType(BeanDeserializerBase.java:1209) ~[jackson-databind-2.11.4.jar:2.11.4]
	at com.fasterxml.jackson.databind.deser.impl.MethodProperty.deserializeAndSet(MethodProperty.java:138) ~[jackson-databind-2.11.4.jar:2.11.4]
	at com.fasterxml.jackson.databind.deser.BeanDeserializer.vanillaDeserialize(BeanDeserializer.java:293) ~[jackson-databind-2.11.4.jar:2.11.4]
	at com.fasterxml.jackson.databind.deser.BeanDeserializer._deserializeOther(BeanDeserializer.java:194) ~[jackson-databind-2.11.4.jar:2.11.4]
	at com.fasterxml.jackson.databind.deser.BeanDeserializer.deserialize(BeanDeserializer.java:166) ~[jackson-databind-2.11.4.jar:2.11.4]
	at com.fasterxml.jackson.databind.jsontype.impl.AsPropertyTypeDeserializer._deserializeTypedForId(AsPropertyTypeDeserializer.java:132) ~[jackson-databind-2.11.4.jar:2.11.4]
	at com.fasterxml.jackson.databind.jsontype.impl.AsPropertyTypeDeserializer.deserializeTypedFromObject(AsPropertyTypeDeserializer.java:99) ~[jackson-databind-2.11.4.jar:2.11.4]
	at com.fasterxml.jackson.databind.deser.BeanDeserializerBase.deserializeWithType(BeanDeserializerBase.java:1209) ~[jackson-databind-2.11.4.jar:2.11.4]
	at com.fasterxml.jackson.databind.deser.std.CollectionDeserializer.deserialize(CollectionDeserializer.java:292) ~[jackson-databind-2.11.4.jar:2.11.4]
	at com.fasterxml.jackson.databind.deser.std.CollectionDeserializer.deserialize(CollectionDeserializer.java:249) ~[jackson-databind-2.11.4.jar:2.11.4]
	at com.fasterxml.jackson.databind.deser.std.CollectionDeserializer.deserialize(CollectionDeserializer.java:26) ~[jackson-databind-2.11.4.jar:2.11.4]
	at com.fasterxml.jackson.databind.jsontype.impl.AsArrayTypeDeserializer._deserialize(AsArrayTypeDeserializer.java:120) ~[jackson-databind-2.11.4.jar:2.11.4]
	at com.fasterxml.jackson.databind.jsontype.impl.AsArrayTypeDeserializer.deserializeTypedFromArray(AsArrayTypeDeserializer.java:53) ~[jackson-databind-2.11.4.jar:2.11.4]
	at com.fasterxml.jackson.databind.deser.std.CollectionDeserializer.deserializeWithType(CollectionDeserializer.java:318) ~[jackson-databind-2.11.4.jar:2.11.4]
	at com.fasterxml.jackson.databind.deser.impl.MethodProperty.deserializeAndSet(MethodProperty.java:138) ~[jackson-databind-2.11.4.jar:2.11.4]
	at com.fasterxml.jackson.databind.deser.BeanDeserializer.vanillaDeserialize(BeanDeserializer.java:293) ~[jackson-databind-2.11.4.jar:2.11.4]
	at com.fasterxml.jackson.databind.deser.BeanDeserializer._deserializeOther(BeanDeserializer.java:194) ~[jackson-databind-2.11.4.jar:2.11.4]
	at com.fasterxml.jackson.databind.deser.BeanDeserializer.deserialize(BeanDeserializer.java:166) ~[jackson-databind-2.11.4.jar:2.11.4]
	at com.fasterxml.jackson.databind.jsontype.impl.AsPropertyTypeDeserializer._deserializeTypedForId(AsPropertyTypeDeserializer.java:132) ~[jackson-databind-2.11.4.jar:2.11.4]
	at com.fasterxml.jackson.databind.jsontype.impl.AsPropertyTypeDeserializer.deserializeTypedFromObject(AsPropertyTypeDeserializer.java:99) ~[jackson-databind-2.11.4.jar:2.11.4]
	at com.fasterxml.jackson.databind.deser.BeanDeserializerBase.deserializeWithType(BeanDeserializerBase.java:1209) ~[jackson-databind-2.11.4.jar:2.11.4]
	at com.fasterxml.jackson.databind.deser.impl.TypeWrappedDeserializer.deserialize(TypeWrappedDeserializer.java:68) ~[jackson-databind-2.11.4.jar:2.11.4]
	at com.fasterxml.jackson.databind.ObjectMapper._readMapAndClose(ObjectMapper.java:4526) ~[jackson-databind-2.11.4.jar:2.11.4]
	at com.fasterxml.jackson.databind.ObjectMapper.readValue(ObjectMapper.java:3529) ~[jackson-databind-2.11.4.jar:2.11.4]
	at io.seata.rm.datasource.undo.parser.JacksonUndoLogParser.decode(JacksonUndoLogParser.java:139) ~[seata-all-1.3.0.jar:1.3.0]
	at io.seata.rm.datasource.undo.AbstractUndoLogManager.undo(AbstractUndoLogManager.java:276) ~[seata-all-1.3.0.jar:1.3.0]
	at io.seata.rm.datasource.DataSourceManager.branchRollback(DataSourceManager.java:178) ~[seata-all-1.3.0.jar:1.3.0]
	at io.seata.rm.AbstractRMHandler.doBranchRollback(AbstractRMHandler.java:125) ~[seata-all-1.3.0.jar:1.3.0]
	at io.seata.rm.AbstractRMHandler$2.execute(AbstractRMHandler.java:67) ~[seata-all-1.3.0.jar:1.3.0]
	at io.seata.rm.AbstractRMHandler$2.execute(AbstractRMHandler.java:63) ~[seata-all-1.3.0.jar:1.3.0]
	at io.seata.core.exception.AbstractExceptionHandler.exceptionHandleTemplate(AbstractExceptionHandler.java:116) ~[seata-all-1.3.0.jar:1.3.0]
	at io.seata.rm.AbstractRMHandler.handle(AbstractRMHandler.java:63) ~[seata-all-1.3.0.jar:1.3.0]
	at io.seata.rm.DefaultRMHandler.handle(DefaultRMHandler.java:63) ~[seata-all-1.3.0.jar:1.3.0]
	at io.seata.core.protocol.transaction.BranchRollbackRequest.handle(BranchRollbackRequest.java:35) ~[seata-all-1.3.0.jar:1.3.0]
	at io.seata.rm.AbstractRMHandler.onRequest(AbstractRMHandler.java:150) ~[seata-all-1.3.0.jar:1.3.0]
	at io.seata.core.rpc.processor.client.RmBranchRollbackProcessor.handleBranchRollback(RmBranchRollbackProcessor.java:63) ~[seata-all-1.3.0.jar:1.3.0]
	at io.seata.core.rpc.processor.client.RmBranchRollbackProcessor.process(RmBranchRollbackProcessor.java:58) ~[seata-all-1.3.0.jar:1.3.0]
	at io.seata.core.rpc.netty.AbstractNettyRemoting.lambda$processMessage$2(AbstractNettyRemoting.java:265) ~[seata-all-1.3.0.jar:1.3.0]
	at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1128) ~[na:na]
	at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:628) ~[na:na]
	at io.netty.util.concurrent.FastThreadLocalRunnable.run(FastThreadLocalRunnable.java:30) ~[netty-all-4.1.63.Final.jar:4.1.63.Final]
	at java.base/java.lang.Thread.run(Thread.java:829) ~[na:na]

spring-boot parent如下：

<parent>
    <groupId>org.springframework.boot</groupId>
    <artifactId>spring-boot-starter-parent</artifactId>
    <version>2.3.10.RELEASE</version>
</parent>

我本地的项目使用的alibaba dependencies版本如下：

<dependency>
    <groupId>com.alibaba.cloud</groupId>
    <artifactId>spring-cloud-alibaba-dependencies</artifactId>
    <version>2.2.5.RELEASE</version>
    <type>pom</type>
    <scope>import</scope>
</dependency>

查看了一下spring-cloud-alibaba-dependencies当中对seata的版本引用发现seata-spring-boot-starter的版本是1.3.0，然后我去Maven的中央仓库找到了最新版的seata-starter版本是1.4.2，
于是想尝试通过更新依赖版本的方法来解决，因为我发现在seata的issues列表当中有一个版本修正过JacksonUndoLogParser该文件的反序列化机制有变动，具体出处：

https://github.com/seata/seata/pull/3228/files

于是我按照以下方法更新版本以后运行程序依旧存在同样的问题。

<dependency>
    <groupId>com.alibaba.cloud</groupId>
    <artifactId>spring-cloud-starter-alibaba-seata</artifactId>
    <exclusions>
        <exclusion>
            <groupId>io.seata</groupId>
            <artifactId>seata-spring-boot-starter</artifactId>
        </exclusion>
    </exclusions>
</dependency>
<dependency>
    <groupId>io.seata</groupId>
    <artifactId>seata-spring-boot-starter</artifactId>
    <version>1.4.2</version>
</dependency>

于是去github上搜了一下issues，发现类似的问题有很多人提到了，目前已知的是最新的develop代码已经修复了该问题，但是尚未合并到release版本当中，所以整理了一下目前的几个解决方案：

  1. 降低mysql驱动的版本到5.x版本

  2. 下载最新的develop分支点代码自己手工编译开发版的代码用，但这个方法不适用于企业

  3. 更换序列化/反序列化器，在配置中心中(以nacos为例)修改配置client.undo.logSerialization=kryo，然后代码中再引入kryo的依赖包，更换掉坑爹的jackson。
    在这里插入图片描述

  4. 通过META-INF/spring.factories文件的类spi机制来自定义序列化规则，可以参考 rm-datasource/src/main/java/io/seata/rm/datasource/undo/parser/JacksonUndoLogParser.java的实现方式，写一个自定义序列化解析器。

  5. 修改数据库表中的datetime类型为timestamp，此方法不适用于已上线的项目，新项目可采用该方法临时解决，等新版本seata发布以后再改回来。

  6. 等开发版的代码稳定以后，发布新版本更新。

richie696
关注
  • 5
    点赞
  • 踩
  • 3
    收藏
    觉得还不错? 一键收藏
  • 5
    评论
专栏目录
com.mysql.cj.exceptions.InvalidConnectionAttributeException: The server time zone value ‘Öйú±ê×解决方案
weixin_43178406的博客
01-08 2万+
本文主要介绍了com.mysql.cj.exceptions.InvalidConnectionAttributeException: The server time zone value ‘Öйú±ê׼ʱ¼ä’ is unrecognized or represents more than one time zone解决方案，希望能对使用mysql的同学们有所帮助。 文章目录 1. 问题描述 2. 解决方案
本地mysql5.7以上版本配置及my.ini
Java 技术专栏，从入门到精通，熟悉企业级开发
03-13 2157
Windows 64 位 mysql 5.7以上版本安装包安装之后，没有my-default.ini和my.ini文件。我们本地开发调试的时候， 有时候也需要改变一下参数，比如最大连接数、查询缓存、缓存池、编码等。 Mysql msi安装包的Windows下载地址: https://dev.mysql.com/downloads/installer/
JDBC中使用Java8的日期LocalDate和LocalDateTime操作mysql、postgresql
08-29
主要给大家介绍了关于JDBC中如何使用Java8的日期LocalDate和LocalDateTime的相关资料，文中通过示例代码介绍的非常详细，对大家的学习或者工作具有一定的参考学习价值，需要的朋友们下面随着小编来一起学习学习吧。
seata执行undo时报错Cannot construct instance of `java.time.LocalDateTime`的原因及解决方法
liaomingwu的专栏
01-08 3106
seata执行undo时报错Cannot construct instance of `java.time.LocalDateTime`的原因及解决方法
分布式事务 Seata 教程 - Cannot construct instance of `java.time.LocalDateTime`问题解决
最新发布
qq_33240556的博客
07-31 425
通过上述方法，你应该能够解决的问题。确保你的应用和 Seata 都正确配置了序列化机制，以便能够正确处理类型的数据。如果问题仍然存在，检查是否有其他类型没有被正确处理，并相应地进行配置。
Seata入门系列(28)- Cannot construct instance of `java.time.LocalDateTime`问题解决
记录知识、锤炼自我
04-27 2203
文章目录错误信息当前环境报错信息问题原因位置原因解决方案方案1：更换序列化方式方案2：降低Mysql 驱动版本方案3 ： 修改源码，支持解析 错误信息 当前环境 Spring Boot : 2.3.12.RELEASE Nacos : 2.0.3 Seata:1.4.2 mysql-connector-java：8.0.25 报错信息 在全局事务进行失败进行全局回滚时，出现报错信息，如下： com.fasterxml.jackson.databind.exc.InvalidDefinitionExcep
Seata json decode exception, Cannot construct instance of `java.time.LocalDateTime` 报错原因/解决方案最全汇总版
健身变秃，coding变强
08-05 4136
com.fasterxml.jackson.databind.exc.InvalidDefinitionException: Cannot construct instance of `java.time.LocalDateTime` (no Creators, like default constructor, exist): cannot deserialize from Object value (no delegate- or property-based Creator)
Seata json decode exception, Cannot construct instance of `java.time.LocalDateTime`问题，有效解决！
Hang的博客
08-09 631
seata回滚报错Seata json decode exception, Cannot construct instance of `java.time.LocalDateTime`
seata0.9.0.zip
04-14
描述中提到，通过升级 MySQL 到 8.0.19 版本，可以解决这些不兼容问题。 MySQL 8.0.19 是 MySQL 数据库的一个重要版本，它带来了许多性能提升和新特性。例如，增强的 InnoDB 存储引擎提供了更好的并发性能，新的 ...
seata-2.x 源码包
03-05
在源码中，TM 的接口定义在 `io.seata.core.protocol.transaction` 包下，理解 TM 如何与 TC 交互对掌握 Seata 工作原理至关重要。 5. **资源代理（RM, Resource Manager）**： RM 代表数据库或者其他存储资源，它...
seata-oracle版undolog.sql
09-05
oracle版本的undolog建表语句。 2019 年 1 月，阿里巴巴中间件团队发起了开源项目 Fescar（Fast & EaSy Commit And Rollback），和社区一起共建开源分布式事务解决方案。Fescar 的愿景是让分布式事务的使用像本地...
Cannot construct instance of `java.time.LocalDateTime` (no Creators, like default construct, exist)
mxc1658的博客
10-26 5227
错误信息： Cannot construct instance of java.time.LocalDateTime (no Creators, like default construct, exist): no String-argument constructor/factory method to deserialize from String value (‘2019-09-27T16:54:59’) 解决： 添加注释 import com.fasterxml.jackson.datatype.j
Class cannot be created (missing no-arg constructor) 错误解决方法
0老船长0的博客
12-15 5676
出错原因：类的序列化与反序列化 解决方法： 1、实体类实现 Serializable 序列化 ，还需要添加serialVersionUID。 2、如果构造方法被重写，需要手写一个无参构造方法。 PS： idea快速生成serialVersionUID的方法： 在实现Serializable 时，在类名按住Alt+Enter组合键。 ...
Mysql升级8.0后日期类型兼容性问题
椰汁菠萝
06-12 1675
该问题是因为代码中使用Map类型获取查询返回值，原5.7驱动中，日期类型会被转为Date类型，现有8.0.33驱动中，日期类型转为LocalDateTime;造成前端拿到类型不是Date出现类型装换异常。最近对原有项目数据库进行升级，从MySQL 5.7 升级到8.0，因此项目种的驱动程序也要做相应升级。以为针对LocalDateTime的修改是从8.0.23开始的，只要使用之前版本即可；
Java Cannot deserialize instance of `xxx` out of START_ARRAY token问题2种情况解决（Java、Jackson）
热门推荐
旭东怪的博客
06-28 3万+
问题描述： org.springframework.http.converter.HttpMessageNotReadableException: JSON parse error: Cannot deserialize instance of `java.lang.String` out of START_ARRAY token; nested exception is com.fasterxml.jackson.databind.exc.MismatchedInputException: Cannot
2022-01-10 ObjectMapper问题：Cannot construct instance of `java.time.LocalDateTime`
不爱吃奶昔（zsl0）的博客
01-10 1247
ObjectMapper问题：Cannot construct instance of `java.time.LocalDateTime`问题描述解决方法解决步骤 问题描述 由于想再全局中对 JavaBean 的返回属性进行统一的空值忽略，于是对ObjectMapper 进行setSerializationInclusion(JsonInclude.Include.NON_NULL) @Bean public ObjectMapper objectMapper() { Object
Seata入门系列(6)- undo_log支持的多种序列化方式
记录知识、锤炼自我
01-25 3016
文章目录rollback_infoundo 配置项支持的序列化方式自定义序列化使用fastjson时的主要事项 rollback_info 在undo_log表中，rollback_info字段存储了事务失败时，需要回滚的相关信息，该字段为longblob类型（二进制数据）。 在Navicat 中，可以选中当前数据，然后通过查看选择文本方式展示。 通过Json 格式化工具，可以查看到详细信息。 undo 配置项 @Component @ConfigurationProperties( prefi
关于入参为localdate，序列化失败的问题
cyh0107的博客
11-02 173
可以考虑入参为String，进一步去转LocalDate。反序列化的时候，无法构造LocalDate类。LocalDate构造函数为私有。
我在seata2.x没有找到DefaultTransactionManagerService类
05-26
在 Seata 2.x 中，`DefaultTransactionManagerService` 类已经被重命名为 `DefaultCore（之前的版本是 DefaultCoordinator）`，所以你可以在 Seata 2.x 的代码库中找到 `DefaultCore` 类。可以在如下路径中找到该类： ``` seata-server/src/main/java/io/seata/core/service/impl/DefaultCore.java ``` 请注意，Seata 2.x 的代码结构与 Seata 1.x 有所不同，因此某些类的位置可能已经发生了变化。如果你无法找到某个类，你可以在 Seata 2.x 的代码库中搜索该类的名称或者阅读相关文档以获取更多信息。
评论 5
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值