Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

seata的at模式,数据源为postgresql的问题 #5359

Closed
hualan77 opened this issue Feb 19, 2023 · 5 comments · Fixed by #6261
Closed

seata的at模式,数据源为postgresql的问题 #5359

hualan77 opened this issue Feb 19, 2023 · 5 comments · Fixed by #6261
Labels
task: help-wanted Extra attention is needed type: bug Category issues or prs related to bug.

Comments

@hualan77
Copy link

1.使用Seata的at模式开发,seata-server和client均设置数据源为postgresql,且为集群模式的,事物回滚时报错,提示rm client找不到,事物回滚失败,想问下是不支持postgresql的集群模式连接吗?
3.将server和client的数据源设置为postgresql的单机连接地址,日志提示事物回滚失败,但是查看数据库发现数据并未回滚,想问下是什么问题?

@funky-eyes
Copy link
Contributor

详细日志贴上来,确认一下回滚的时候,rm的连接是否已经建立了,如果不是最新版seata,请先做升级

@hualan77
Copy link
Author

详细日志贴上来,确认一下回滚的时候,rm的连接是否已经建立了,如果不是最新版seata,请先做升级

seata是支持postgresql的集群连接吗?我写的连接地址是这样的jdbc:postgresql://host1:port,host2:port,host3:port/链接的数据库名

@funky-eyes
Copy link
Contributor

详细日志贴上来,确认一下回滚的时候,rm的连接是否已经建立了,如果不是最新版seata,请先做升级

seata是支持postgresql的集群连接吗?我写的连接地址是这样的jdbc:postgresql://host1:port,host2:port,host3:port/链接的数据库名

把日志栈贴上来,映像中这么写在注册资源的时候会有问题,mysql之前有一个loadBalance也是类似你这种写法在1.4.2及之前存在问题,你方便把rm注册连接到tc的日志贴上来给我看一下吗?

@hualan77
Copy link
Author

hualan77 commented Mar 3, 2023

今天跟了下代码,发现register(图1)和get(图3)的时候的key不同,所以会回滚的时候会报找不到的错误(图4);在register的时候对key指进行了处理,如图2进行了逗号分割,不知道这块处理的原因是出于什么考虑?
9c933afd6e6f609b704975301bc0820
8f898c690dd62256a4c8e8a3378522a
7774346fe12070186406bcbd514634b
28cde0efc1c85f5693a2c237cdb5f02

@funky-eyes
Copy link
Contributor

暂时可以先配置成一个地址吗?会有什么问题不,这个是个bug我们看看如何处理,属于跟之前的mysql loadBalance 为一类问题

@funky-eyes funky-eyes added task: help-wanted Extra attention is needed type: bug Category issues or prs related to bug. labels Jun 9, 2023
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
task: help-wanted Extra attention is needed type: bug Category issues or prs related to bug.
Projects
None yet
Development

Successfully merging a pull request may close this issue.

2 participants