请问DataX当前的JDBC的驱动是否支持MySQL 8.0.18
- Dominant language
- Java
- Stars
- 17.4k
- Forks
- 5.7k
- PR merge metrics
- No merged PRs in 30d
Description
2021-04-25 21:05:51.454 [0-0-0-writer] ERROR StdoutPluginCollector - 脏数据:
{"exception":"Could not retrieve transation read-only status server","record":[{"byteSize":2,"index":0,"rawData":"柯柯","type":"STRING"},{"byteSize":8,"index":1,"rawData":27798005,"type":"LONG"},{"byteSize":1,"index":2,"rawData":1,"type":"LONG"},{"byteSize":0,"index":3,"type":"DATE"},{"byteSize":3,"index":4,"rawData":236,"type":"LONG"},{"byteSize":0,"index":5,"type":"LONG"},{"byteSize":0,"index":6,"type":"LONG"},{"byteSize":1,"index":7,"rawData":2,"type":"LONG"},{"byteSize":2,"index":8,"rawData":51,"type":"LONG"},{"byteSize":3,"index":9,"rawData":207,"type":"LONG"},{"byteSize":8,"index":10,"rawData":1454256000000,"type":"DATE"},{"byteSize":8,"index":11,"rawData":1547606440000,"type":"DATE"},{"byteSize":1,"index":12,"rawData":0,"type":"LONG"},{"byteSize":0,"index":13,"type":"STRING"},{"byteSize":0,"index":14,"type":"STRING"},{"byteSize":8,"index":15,"rawData":1555306977000,"type":"DATE"},{"byteSize":4,"index":16,"rawData":"微信注册","type":"STRING"},{"byteSize":8,"index":17,"rawData":1547606440000,"type":"DATE"},{"byteSize":0,"index":18,"type":"LONG"},{"byteSize":3,"index":19,"rawData":415,"type":"LONG"},{"byteSize":1,"index":20,"rawData":0,"type":"LONG"},{"byteSize":0,"index":21,"type":"STRING"},{"byteSize":8,"index":22,"rawData":1547606440000,"type":"DATE"},{"byteSize":0,"index":23,"type":"STRING"},{"byteSize":0,"index":24,"type":"LONG"},{"byteSize":1,"index":25,"rawData":0,"type":"LONG"},{"byteSize":0,"index":26,"type":"LONG"},{"byteSize":0,"index":27,"type":"STRING"},{"byteSize":11,"index":28,"rawData":"15921359619","type":"STRING"},{"byteSize":0,"index":29,"type":"DOUBLE"},{"byteSize":0,"index":30,"type":"STRING"},{"byteSize":0,"index":31,"type":"LONG"},{"byteSize":1,"index":32,"rawData":2,"type":"LONG"},{"byteSize":0,"index":33,"type":"LONG"},{"byteSize":0,"index":34,"type":"LONG"},{"byteSize":0,"index":35,"type":"LONG"},{"byteSize":0,"index":36,"type":"LONG"},{"byteSize":0,"index":37,"type":"STRING"},{"byteSize":0,"index":38,"type":"STRING"},{"byteSize":0,"index":39,"type":"DATE"}],"type":"writer"}
2021-04-25 21:05:51.500 [0-0-0-writer] ERROR StdoutPluginCollector - 脏数据:
{"exception":"**Could not retrieve transation read-only status server**","record":[{"byteSize":3,"index":0,"rawData":"肖伟倩","type":"STRING"},{"byteSize":8,"index":1,"rawData":27818378,"type":"LONG"},{"byteSize":1,"index":2,"rawData":1,"type":"LONG"},{"byteSize":0,"index":3,"type":"DATE"},{"byteSize":3,"index":4,"rawData":236,"type":"LONG"},{"byteSize":0,"index":5,"type":"LONG"},{"byteSize":0,"index":6,"type":"LONG"},{"byteSize":1,"index":7,"rawData":2,"type":"LONG"},{"byteSize":2,"index":8,"rawData":51,"type":"LONG"},{"byteSize":3,"index":9,"rawData":207,"type":"LONG"},{"byteSize":8,"index":10,"rawData":682099200000,"type":"DATE"},{"byteSize":8,"index":11,"rawData":1547780147000,"type":"DATE"},{"byteSize":1,"index":12,"rawData":0,"type":"LONG"},{"byteSize":0,"index":13,"type":"STRING"},{"byteSize":0,"index":14,"type":"STRING"},{"byteSize":8,"index":15,"rawData":1555306977000,"type":"DATE"},{"byteSize":4,"index":16,"rawData":"微信注册","type":"STRING"},{"byteSize":8,"index":17,"rawData":1547780147000,"type":"DATE"},{"byteSize":0,"index":18,"type":"LONG"},{"byteSize":3,"index":19,"rawData":415,"type":"LONG"},{"byteSize":1,"index":20,"rawData":0,"type":"LONG"},{"byteSize":0,"index":21,"type":"STRING"},{"byteSize":8,"index":22,"rawData":1547780147000,"type":"DATE"},{"byteSize":0,"index":23,"type":"STRING"},{"byteSize":0,"index":24,"type":"LONG"},{"byteSize":1,"index":25,"rawData":0,"type":"LONG"},{"byteSize":0,"index":26,"type":"LONG"},{"byteSize":0,"index":27,"type":"STRING"},{"byteSize":11,"index":28,"rawData":"13272407753","type":"STRING"},{"byteSize":0,"index":29,"type":"DOUBLE"},{"byteSize":0,"index":30,"type":"STRING"},{"byteSize":0,"index":31,"type":"LONG"},{"byteSize":1,"index":32,"rawData":2,"type":"LONG"},{"byteSize":0,"index":33,"type":"LONG"},{"byteSize":0,"index":34,"type":"LONG"},{"byteSize":0,"index":35,"type":"LONG"},{"byteSize":0,"index":36,"type":"LONG"},{"byteSize":0,"index":37,"type":"STRING"},{"byteSize":0,"index":38,"type":"STRING"},{"byteSize":0,"index":39,"type":"DATE"}],"type":"writer"}
2021-04-25 21:05:59.815 [job-0] INFO StandAloneJobContainerCommunicator - Total 0 records, 0 bytes | Speed 0B/s, 0 records/s | Error 0 records, 0 bytes | All Task WaitWriterTime 0.000s | All Task WaitReaderTime 0.000s | Percentage 0.00%
2021-04-25 21:07:25.124 [0-0-0-writer] WARN CommonRdbmsWriter$Task - **回滚此次写入, 采用每次写入一行方式提交. 因为:Could not retrieve transation read-only status server**
Contributor guide
No contributing guide indexed for this repository
Research direction
Start with the JDBC path involved in CommonRdbmsWriter$Task and the reported “Could not retrieve transation read-only status server” error. Reproduce the writer failure against MySQL 8.0.18, then verify the supported compatibility and transaction behavior; done when the compatibility question has a confirmed outcome.
Written by the indexing model from the issue text.
Assessment
- Tech stack
- java, mysql
- Domain
- databases
- Issue type
- Bug
- Difficulty
- 4/5
- Estimated time
- 3-5 days
- Activity status
- Stale
- Clarity
- Needs clarification
- Newbie friendliness
- 25/100