apache / apache/incubator-seata

在MySQL8.0默认状态下无法正常启动

Open
#3,089 0 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
MySQL8默认需要区分表名大小写,启动时报以下警告:
```
global_table table or TRANSACTION_NAME column not found
```
分析源码后发现在LogStoreDataBaseDAO中,以下代码使用了大写字段名,而seata数据库中为小写字段。
```
private static final String TRANSACTION_NAME_KEY = "TRANSACTION_NAME";
```

### Ⅱ. 处理建议
将以上代码修改为:
```
private static final String TRANSACTION_NAME_KEY = "transaction_name";
```

Contributor guide

Open the contributing guide

Research direction

Start in LogStoreDataBaseDAO and inspect the TRANSACTION_NAME_KEY constant against the lowercase schema names described in the issue. Verify the change with a MySQL 8.0 startup using the Seata database schema; done means startup no longer reports that global_table or the TRANSACTION_NAME column is missing.

Written by the indexing model from the issue text.

Assessment

Tech stack
java, mysql
Domain
databases
Issue type
Bug
Difficulty
1/5
Estimated time
Under an hour
Activity status
Stale
Clarity
Clearly specified
Newbie friendliness
45/100

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.