apache / apache/incubator-seata

The seata at mode is incorrect

Open
#5,439 4 comments 0 reactions 0 assignees View on GitHub
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
seata AT mode error, XA mode is normal,The error message is as follows

```
2023-03-14 16:08:38.538 [http-nio-9003-exec-1] ERROR c.c.k.c.c.f.aop.LogRemoteAspect - [?,?] - [TID: N/A] ERROR-Remote-当前业务执行类:cn.xxx.north.remote.resource.XxxxResource,方法名:newLabel,异常信息:org.springframework.jdbc.UncategorizedSQLException:
### Error updating database. Cause: java.sql.SQLException: 无效的列类型
### The error may exist in xxx/south/port/repository/XxxxxMapper.java (best guess)
### The error may involve xxxx.south.port.repository.XxxxxMapper.insert-Inline
### The error occurred while setting parameters
### SQL: INSERT INTO XXXXX ( ID, user_id, user_type, label_content, sort, create_user, create_time, update_user, update_time ) VALUES ( ?, ?, ?, ?, ?, ?, ?, ?, ? )
### Cause: java.sql.SQLException: 无效的列类型
; uncategorized SQLException; SQL state [99999]; error code [17004]; 无效的列类型; nested exception is java.sql.SQLException: 无效的列类型
```

### Ⅵ. Environment:

- JDK version : 1.8
- Seata version: client 1.5.1 server 1.6.0
- OS :
- Others:

Contributor guide

Open the contributing guide

Research direction

Start with the reported INSERT in XxxxxMapper.java and reproduce it using JDK 1.8, Seata client 1.5.1, and server 1.6.0, comparing AT mode with the working XA mode. Investigate the parameter-setting failure and verify that the AT-mode insert completes without the invalid-column-type SQLException.

Written by the indexing model from the issue text.

Assessment

Tech stack
java, spring, sql
Domain
backend, databases, distributed-systems
Issue type
Bug
Difficulty
4/5
Estimated time
3-5 days
Activity status
Stale
Clarity
Needs clarification
Newbie friendliness
25/100

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.