apache / apache/incubator-seata
The seata at mode is incorrect
- 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
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