apache / apache/incubator-seata

postgresql中如果主键中包含timestampe with time zone列时,seata at事务出错

Open
#5,624 1 comment 0 reactions 0 assignees View on GitHub
task: help-wanted type: bug
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报错,以过增加以下代码解决了问题
![image](https://github.com/seata/seata/assets/9099809/b3b3ea45-96f7-404e-b4bd-c486b35c03c6)

![image](https://github.com/seata/seata/assets/9099809/5f999235-a789-4546-8224-b488c9de4981)
![image](https://github.com/seata/seata/assets/9099809/ad25916d-0214-45cb-98f0-572d0aecea72)

### Ⅱ. Describe what happened

If there is an exception, please attach the exception trace:

```
Just paste your stack trace here!
```
![1685503193843_2E3E0511-3413-4d59-B944-C35AC5D09395](https://github.com/seata/seata/assets/9099809/68e80dbb-fcd9-4513-bd59-c39432168d8a)

### Ⅲ. 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

Open the contributing 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

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.