You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@seatunnel.apache.org by "DreamWingsGO (via GitHub)" <gi...@apache.org> on 2023/06/29 08:55:58 UTC
[GitHub] [seatunnel] DreamWingsGO opened a new issue, #4998: MySQL Jdbc 导数据导同服务下的另一个库异常
DreamWingsGO opened a new issue, #4998:
URL: https://github.com/apache/seatunnel/issues/4998
### Search before asking
- [X] I had searched in the [issues](https://github.com/apache/seatunnel/issues?q=is%3Aissue+label%3A%22bug%22) and found no similar issues.
### What happened
MySQL Jdbc 导数据导同服务下的另一个库 一直显示一样的日志
### SeaTunnel Version
2.3.2
### SeaTunnel Config
```conf
env {
execution.parallelism = 2
job.mode = "BATCH"
# 10秒检查一次,可以适当加大这个值
checkpoint.interval = 20000
}
source {
Jdbc {
user = "root"
password = "root"
driver = "com.mysql.cj.jdbc.Driver"
url = "jdbc:mysql://10.0.0.15:59001/ga?useUnicode=true&characterEncoding=utf8&serverTimezone=Asia/Shanghai"
query = "select * from user"
connection_check-timeout_sec = 100
}
}
transform{
}
sink {
jdbc {
url = "jdbc:mysql://10.0.0.15:59001/demo?useUnicode=true&characterEncoding=utf8&serverTimezone=Asia/Shanghai"
driver = "com.mysql.cj.jdbc.Driver"
user = "root"
password = "root"
xa_data_source_class_name = "com.mysql.cj.jdbc.MysqlXADataSource"
query = "INSERT INTO demo.user (id, userId, mobile, user_uuid, wx_id, real_name, user_id_card, nickname, market_channel, gender, birthday, created_time, last_update_time, status, push_id, avatar_image_res_id) VALUES (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)"
}
}
```
### Running Command
```shell
./bin/seatunnel.sh --config ./config/seatunnel.mysql.conf.template -e local
```
### Error Exception
```log
2023-06-29 16:52:04,205 INFO org.apache.seatunnel.engine.server.CoordinatorService - [localhost]:6801 [seatunnel-335839] [5.1]
***********************************************
CoordinatorService Thread Pool Status
***********************************************
activeCount : 1
corePoolSize : 0
maximumPoolSize : 2147483647
poolSize : 1
completedTaskCount : 15
taskCount : 16
***********************************************
2023-06-29 16:52:04,206 INFO org.apache.seatunnel.engine.server.CoordinatorService - [localhost]:6801 [seatunnel-335839] [5.1]
***********************************************
Job info detail
***********************************************
createdJobCount : 0
scheduledJobCount : 0
runningJobCount : 1
failingJobCount : 0
failedJobCount : 0
cancellingJobCount : 0
canceledJobCount : 0
finishedJobCount : 0
restartingJobCount : 0
suspendedJobCount : 0
reconcilingJobCount : 0
***********************************************
2023-06-29 16:52:07,072 INFO org.apache.seatunnel.engine.client.job.JobMetricsRunner -
***********************************************
Job Progress Information
***********************************************
Job Id : 726719814378192897
Read Count So Far : 3048
Write Count So Far : 999
Average Read Count : 0/s
Average Write Count : 0/s
Last Statistic Time : 2023-06-29 16:51:07
Current Statistic Time : 2023-06-29 16:52:07
***********************************************
```
### Flink or Spark Version
_No response_
### Java or Scala Version
jdk 11.0.19
### Screenshots



### Are you willing to submit PR?
- [X] Yes I am willing to submit a PR!
### Code of Conduct
- [X] I agree to follow this project's [Code of Conduct](https://www.apache.org/foundation/policies/conduct)
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: commits-unsubscribe@seatunnel.apache.org.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [seatunnel] DreamWingsGO commented on issue #4998: MySQL Jdbc 导数据导同服务下的另一个库异常
Posted by "DreamWingsGO (via GitHub)" <gi...@apache.org>.
DreamWingsGO commented on issue #4998:
URL: https://github.com/apache/seatunnel/issues/4998#issuecomment-1639520541
> 你的数据库版本是多少,驱动版本是多少
MySQL8.0.21 mysql-connector-java-8.0.21.jar
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: commits-unsubscribe@seatunnel.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [seatunnel] DreamWingsGO commented on issue #4998: MySQL Jdbc 导数据导同服务下的另一个库异常
Posted by "DreamWingsGO (via GitHub)" <gi...@apache.org>.
DreamWingsGO commented on issue #4998:
URL: https://github.com/apache/seatunnel/issues/4998#issuecomment-1612664644
新的表一直没有数据
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: commits-unsubscribe@seatunnel.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
Re: [I] MySQL Jdbc 导数据导同服务下的另一个库异常 [seatunnel]
Posted by "github-actions[bot] (via GitHub)" <gi...@apache.org>.
github-actions[bot] closed issue #4998: MySQL Jdbc 导数据导同服务下的另一个库异常
URL: https://github.com/apache/seatunnel/issues/4998
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: commits-unsubscribe@seatunnel.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [seatunnel] samgang commented on issue #4998: MySQL Jdbc 导数据导同服务下的另一个库异常
Posted by "samgang (via GitHub)" <gi...@apache.org>.
samgang commented on issue #4998:
URL: https://github.com/apache/seatunnel/issues/4998#issuecomment-1639320506
你的数据库版本是多少,驱动版本是多少
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: commits-unsubscribe@seatunnel.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
Re: [I] MySQL Jdbc 导数据导同服务下的另一个库异常 [seatunnel]
Posted by "github-actions[bot] (via GitHub)" <gi...@apache.org>.
github-actions[bot] commented on issue #4998:
URL: https://github.com/apache/seatunnel/issues/4998#issuecomment-3071527097
This issue has been closed because it has not received response for too long time. You could reopen it if you encountered similar problems in the future.
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: commits-unsubscribe@seatunnel.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
Re: [I] MySQL Jdbc 导数据导同服务下的另一个库异常 [seatunnel]
Posted by "github-actions[bot] (via GitHub)" <gi...@apache.org>.
github-actions[bot] commented on issue #4998:
URL: https://github.com/apache/seatunnel/issues/4998#issuecomment-1769681952
This issue has been automatically marked as stale because it has not had recent activity for 30 days. It will be closed in next 7 days if no further activity occurs.
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: commits-unsubscribe@seatunnel.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org