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
   
   ![4e495aea11ab90d9d07e6db3d389ca9](https://github.com/apache/seatunnel/assets/104044911/5e0e0297-aaf1-4d2e-aa22-1eb5e15acf66)
   ![57db584924ed5a2644d1b6039d11bc0](https://github.com/apache/seatunnel/assets/104044911/737046b7-0dca-48f8-af4a-92f0d2211a79)
   ![0e088ba4a82dbbe229803b39928eab2](https://github.com/apache/seatunnel/assets/104044911/cd6ef2c7-7d4d-4f9b-bc48-9bece5c8751f)
   
   
   ### 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