apache / apache/incubator-seata
postgresql中如果主键中包含timestampe with time zone列时,seata at事务出错
- Dominant language
- Java
- Stars
- 26k
- Forks
- 8.8k
- Avg merge
- 1d 8h
- Merged PRs (30d)
- 4
Description
- [ ] I have searched the [issues](https://github.com/seata/seata/issues) of this repository and believe that this is not a duplicate.
### Ⅰ. Issue Description
我们现在的根据时间timestamp with time zone进行了分区,postgresql要求主键要包含分区键,主键中出现了timestampe with time zone类型后,seata报错,以过增加以下代码解决了问题



### Ⅱ. Describe what happened
If there is an exception, please attach the exception trace:
```
Just paste your stack trace here!
```

### Ⅲ. Describe what you expected to happen
### Ⅳ. How to reproduce it (as minimally and precisely as possible)
1. xxx
2. xxx
3. xxx
Minimal yet complete reproducer code (or URL to code):
### Ⅴ. Anything else we need to know?
### Ⅵ. Environment:
- JDK version(e.g. `java -version`):
- Seata client/server version: 1.6.1
- Database version: postgresql14.2
- OS(e.g. `uname -a`):
- Others:
Contributor guide
Research direction
The report concerns Seata 1.6.1 AT transactions with PostgreSQL 14.2 when a primary key includes a timestamp with time zone partition key. Start by collecting the missing stack trace, schema, and minimal reproduction; done means reproducing the failure and verifying the behavior against the reported workaround.
Written by the indexing model from the issue text.
Assessment
- Tech stack
- java, postgresql
- Domain
- databases, distributed-systems
- Issue type
- Bug
- Difficulty
- 4/5
- Estimated time
- 3-5 days
- Activity status
- Stale
- Clarity
- Needs clarification
- Newbie friendliness
- 20/100