You are viewing a plain text version of this content. The canonical link for it is here.
Posted to notifications@seata.apache.org by "897584724 (via GitHub)" <gi...@apache.org> on 2024/06/03 08:58:25 UTC
[I] 对于Oracle数据库中含有Timestamp字段的数据表无法进行二段校验 [incubator-seata]
897584724 opened a new issue, #6598:
URL: https://github.com/apache/incubator-seata/issues/6598
在进行回滚时，会进行数据校验，然而对于含有Timestamp字段的数据表，写到Undo_log表里的时候，只会保存timestamp字段中的秒之前的值到Undo_log里面，例如timestamp的值是2024-05-30 18:51:50:148381，那保存到Undo_log里面的值只有2024-05-30 18:51:50.0，然后回滚前校验seata会拿2024-05-30 18:51:50.0和2024-05-30 18:51:50:148381进行校验，然后就会校验不通过，导致无法回滚。需要设置seata: client:undo: dataValidation: false ，放弃二段校验才能进行回滚
- java8
-seata2.0
-spring-cloud-starter-alibaba-seata 2021.0.5.0或者2021.0.6.0
- oracle 12c
- windows spring tool 4
- seata: client: undo: log-serialization: fastjson
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: notifications-unsubscribe@seata.apache.org.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: notifications-unsubscribe@seata.apache.org
For additional commands, e-mail: notifications-help@seata.apache.org
Re: [I] 对于Oracle数据库中含有Timestamp字段的数据表无法进行二段校验 [incubator-seata]
Posted by "897584724 (via GitHub)" <gi...@apache.org>.
897584724 commented on issue #6598:
URL: https://github.com/apache/incubator-seata/issues/6598#issuecomment-2144872726
不进行回滚前校验感觉会有坑，所以是否能修复这个问题？
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: notifications-unsubscribe@seata.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: notifications-unsubscribe@seata.apache.org
For additional commands, e-mail: notifications-help@seata.apache.org
Re: [I] 对于Oracle数据库中含有Timestamp字段的数据表无法进行二段校验 [incubator-seata]
Posted by "897584724 (via GitHub)" <gi...@apache.org>.
897584724 commented on issue #6598:
URL: https://github.com/apache/incubator-seata/issues/6598#issuecomment-2144869889
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: notifications-unsubscribe@seata.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: notifications-unsubscribe@seata.apache.org
For additional commands, e-mail: notifications-help@seata.apache.org
Re: [I] 对于Oracle数据库中含有Timestamp字段的数据表无法进行二段校验 [incubator-seata]
Posted by "funky-eyes (via GitHub)" <gi...@apache.org>.
funky-eyes closed issue #6598: 对于Oracle数据库中含有Timestamp字段的数据表无法进行二段校验
URL: https://github.com/apache/incubator-seata/issues/6598
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: notifications-unsubscribe@seata.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: notifications-unsubscribe@seata.apache.org
For additional commands, e-mail: notifications-help@seata.apache.org
Re: [I] 对于Oracle数据库中含有Timestamp字段的数据表无法进行二段校验 [incubator-seata]
Posted by "funky-eyes (via GitHub)" <gi...@apache.org>.
funky-eyes commented on issue #6598:
URL: https://github.com/apache/incubator-seata/issues/6598#issuecomment-2149121093
https://seata.apache.org/zh-cn/docs/overview/faq#41
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: notifications-unsubscribe@seata.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: notifications-unsubscribe@seata.apache.org
For additional commands, e-mail: notifications-help@seata.apache.org