You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@seatunnel.apache.org by "w398507661 (via GitHub)" <gi...@apache.org> on 2023/03/13 08:16:42 UTC

[GitHub] [incubator-seatunnel] w398507661 opened a new issue, #4341: ST导入ES问题,意思不支持https协议

w398507661 opened a new issue, #4341:
URL: https://github.com/apache/incubator-seatunnel/issues/4341

   ### Search before asking
   
   - [X] I had searched in the [issues](https://github.com/apache/incubator-seatunnel/issues?q=is%3Aissue+label%3A%22bug%22) and found no similar issues.
   
   
   ### What happened
   
   ST导入ES问题,意思不支持https协议
   
   ### SeaTunnel Version
   
   2.3.0
   
   ### SeaTunnel Config
   
   ```conf
   env {
     # seatunnel defined streaming batch duration in seconds
    ## [spark.app.name](http://spark.app.name) = "SeaTunnel"
     #spark.sql.catalogImplementation = "hive"
     spark.executor.instances = 10
     spark.executor.cores = 20
     spark.executor.memory = "40g"
   }
   source {
     jdbc {
       driver = "org.postgresql.Driver"
       url = "jdbc:postgresql://****:5432/cdp_edge"
       user = "dbadmin"
       password = "****"
       table = "cdp_rep_master"
       result_table_name = "cdp_rep_master"
       #jdbc.SSL = "true"
       #jdbc.SSLKeyStorePath = "/data/ludp_jks/keystore.jks"
       query = "SELECT *,zbpli as rowkey from cml.cdp_rep_master where to_timestamp(update_timestamp,'yyyyMMddhh24miss') > current_date - interval '7 day'"
    }
   }
   transform {
     # split data by specific delimiter
   
   # you can also use other filter plugins, such as sql
     # sql {
     #   sql = "select * from accesslog where request_time > 1000"
     #} 
   }
   
   
   sink {
     # choose stdout output plugin to output data to console
     # Console {}
   	elasticsearch {
   		hosts = ["vpc-cdpsupportquotation-es-tst-nwniunh2eqrlgac5varhtd7b3u.us-east-1.es.amazonaws.com:443"]
   		index = "cdp_rep_master_uat_20230313_01"
   		#index_time_format = "yyyyMMdd"
   		index_type = "seatunnel"
   	}
   }
   ```
   
   
   ### Running Command
   
   ```shell
   nohup ./bin/start-seatunnel-spark-connector-v2.sh  --master yarn --deploy-mode client --config config/toes/prod.cml.cdp_rep_master_append.conf &
   ```
   
   
   ### Error Exception
   
   ```log
   2023-03-13 15:29:49 INFO  BlockManagerInfo:54 - Added broadcast_0_piece0 in memory on cbi238.cdh.com:33581 (size: 4.2 KB, free: 21.2 GB)
   2023-03-13 15:29:51 WARN  TaskSetManager:66 - Lost task 0.0 in stage 0.0 (TID 0, cbi238.cdh.com, executor 5): org.apache.spark.util.TaskCompletionListenerException: java.lang.NullPointerException
   
   Previous exception in task: ErrorCode:[ELASTICSEARCH-02], ErrorDescription:[Get elasticsearch version failed] - fail to get elasticsearch version.
   	org.apache.seatunnel.connectors.seatunnel.elasticsearch.client.EsRestClient.getClusterVersion(EsRestClient.java:145)
   	org.apache.seatunnel.connectors.seatunnel.elasticsearch.sink.ElasticsearchSinkWriter.<init>(ElasticsearchSinkWriter.java:75)
   	org.apache.seatunnel.connectors.seatunnel.elasticsearch.sink.ElasticsearchSink.createWriter(ElasticsearchSink.java:78)
   	org.apache.seatunnel.translation.spark.sink.SparkDataWriterFactory.createDataWriter(SparkDataWriterFactory.java:45)
   	org.apache.spark.sql.execution.datasources.v2.DataWritingSparkTask$.run(WriteToDataSourceV2Exec.scala:113)
   	org.apache.spark.sql.execution.datasources.v2.WriteToDataSourceV2Exec$$anonfun$doExecute$2.apply(WriteToDataSourceV2Exec.scala:67)
   	org.apache.spark.sql.execution.datasources.v2.WriteToDataSourceV2Exec$$anonfun$doExecute$2.apply(WriteToDataSourceV2Exec.scala:66)
   	org.apache.spark.scheduler.ResultTask.runTask(ResultTask.scala:90)
   	org.apache.spark.scheduler.Task.run(Task.scala:121)
   	org.apache.spark.executor.Executor$TaskRunner$$anonfun$10.apply(Executor.scala:402)
   	org.apache.spark.util.Utils$.tryWithSafeFinally(Utils.scala:1360)
   	org.apache.spark.executor.Executor$TaskRunner.run(Executor.scala:408)
   	java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
   	java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
   	java.lang.Thread.run(Thread.java:748)
   	at org.apache.spark.TaskContextImpl.invokeListeners(TaskContextImpl.scala:138)
   	at org.apache.spark.TaskContextImpl.markTaskCompleted(TaskContextImpl.scala:116)
   	at org.apache.spark.scheduler.Task.run(Task.scala:131)
   	at org.apache.spark.executor.Executor$TaskRunner$$anonfun$10.apply(Executor.scala:402)
   	at org.apache.spark.util.Utils$.tryWithSafeFinally(Utils.scala:1360)
   	at org.apache.spark.executor.Executor$TaskRunner.run(Executor.scala:408)
   	at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
   	at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
   	at java.lang.Thread.run(Thread.java:748)
   
   2023-03-13 15:29:51 INFO  TaskSetManager:54 - Starting task 0.1 in stage 0.0 (TID 1, cbi238.cdh.com, executor 5, partition 0, PROCESS_LOCAL, 11210 bytes)
   2023-03-13 15:29:51 INFO  TaskSetManager:54 - Lost task 0.1 in stage 0.0 (TID 1) on cbi238.cdh.com, executor 5: org.apache.spark.util.TaskCompletionListenerException (java.lang.NullPointerException
   
   Previous exception in task: ErrorCode:[ELASTICSEARCH-02], ErrorDescription:[Get elasticsearch version failed] - fail to get elasticsearch version.
   	org.apache.seatunnel.connectors.seatunnel.elasticsearch.client.EsRestClient.getClusterVersion(EsRestClient.java:145)
   	org.apache.seatunnel.connectors.seatunnel.elasticsearch.sink.ElasticsearchSinkWriter.<init>(ElasticsearchSinkWriter.java:75)
   	org.apache.seatunnel.connectors.seatunnel.elasticsearch.sink.ElasticsearchSink.createWriter(ElasticsearchSink.java:78)
   	org.apache.seatunnel.translation.spark.sink.SparkDataWriterFactory.createDataWriter(SparkDataWriterFactory.java:45)
   	org.apache.spark.sql.execution.datasources.v2.DataWritingSparkTask$.run(WriteToDataSourceV2Exec.scala:113)
   	org.apache.spark.sql.execution.datasources.v2.WriteToDataSourceV2Exec$$anonfun$doExecute$2.apply(WriteToDataSourceV2Exec.scala:67)
   	org.apache.spark.sql.execution.datasources.v2.WriteToDataSourceV2Exec$$anonfun$doExecute$2.apply(WriteToDataSourceV2Exec.scala:66)
   	org.apache.spark.scheduler.ResultTask.runTask(ResultTask.scala:90)
   	org.apache.spark.scheduler.Task.run(Task.scala:121)
   	org.apache.spark.executor.Executor$TaskRunner$$anonfun$10.apply(Executor.scala:402)
   	org.apache.spark.util.Utils$.tryWithSafeFinally(Utils.scala:1360)
   	org.apache.spark.executor.Executor$TaskRunner.run(Executor.scala:408)
   	java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
   	java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
   	java.lang.Thread.run(Thread.java:748)) [duplicate 1]
   2023-03-13 15:29:51 INFO  TaskSetManager:54 - Starting task 0.2 in stage 0.0 (TID 2, cbi241.cdh.com, executor 4, partition 0, PROCESS_LOCAL, 11210 bytes)
   2023-03-13 15:29:52 INFO  BlockManagerInfo:54 - Added broadcast_0_piece0 in memory on cbi241.cdh.com:38900 (size: 4.2 KB, free: 21.2 GB)
   2023-03-13 15:29:53 INFO  TaskSetManager:54 - Lost task 0.2 in stage 0.0 (TID 2) on cbi241.cdh.com, executor 4: org.apache.spark.util.TaskCompletionListenerException (java.lang.NullPointerException
   
   Previous exception in task: ErrorCode:[ELASTICSEARCH-02], ErrorDescription:[Get elasticsearch version failed] - fail to get elasticsearch version.
   	org.apache.seatunnel.connectors.seatunnel.elasticsearch.client.EsRestClient.getClusterVersion(EsRestClient.java:145)
   	org.apache.seatunnel.connectors.seatunnel.elasticsearch.sink.ElasticsearchSinkWriter.<init>(ElasticsearchSinkWriter.java:75)
   	org.apache.seatunnel.connectors.seatunnel.elasticsearch.sink.ElasticsearchSink.createWriter(ElasticsearchSink.java:78)
   	org.apache.seatunnel.translation.spark.sink.SparkDataWriterFactory.createDataWriter(SparkDataWriterFactory.java:45)
   	org.apache.spark.sql.execution.datasources.v2.DataWritingSparkTask$.run(WriteToDataSourceV2Exec.scala:113)
   	org.apache.spark.sql.execution.datasources.v2.WriteToDataSourceV2Exec$$anonfun$doExecute$2.apply(WriteToDataSourceV2Exec.scala:67)
   	org.apache.spark.sql.execution.datasources.v2.WriteToDataSourceV2Exec$$anonfun$doExecute$2.apply(WriteToDataSourceV2Exec.scala:66)
   	org.apache.spark.scheduler.ResultTask.runTask(ResultTask.scala:90)
   	org.apache.spark.scheduler.Task.run(Task.scala:121)
   	org.apache.spark.executor.Executor$TaskRunner$$anonfun$10.apply(Executor.scala:402)
   	org.apache.spark.util.Utils$.tryWithSafeFinally(Utils.scala:1360)
   	org.apache.spark.executor.Executor$TaskRunner.run(Executor.scala:408)
   	java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
   	java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
   	java.lang.Thread.run(Thread.java:748)) [duplicate 2]
   2023-03-13 15:29:53 INFO  TaskSetManager:54 - Starting task 0.3 in stage 0.0 (TID 3, cbi242.cdh.com, executor 1, partition 0, PROCESS_LOCAL, 11210 bytes)
   2023-03-13 15:29:54 INFO  BlockManagerInfo:54 - Added broadcast_0_piece0 in memory on cbi242.cdh.com:40142 (size: 4.2 KB, free: 21.2 GB)
   2023-03-13 15:29:56 INFO  TaskSetManager:54 - Lost task 0.3 in stage 0.0 (TID 3) on cbi242.cdh.com, executor 1: org.apache.spark.util.TaskCompletionListenerException (java.lang.NullPointerException
   ```
   
   
   ### Flink or Spark Version
   
   _No response_
   
   ### Java or Scala Version
   
   _No response_
   
   ### Screenshots
   
   _No response_
   
   ### Are you willing to submit PR?
   
   - [ ] 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] [incubator-seatunnel] laglangyue commented on issue #4341: The problem of ST importing ES means that the https protocol is not supported

Posted by "laglangyue (via GitHub)" <gi...@apache.org>.
laglangyue commented on issue #4341:
URL: https://github.com/apache/incubator-seatunnel/issues/4341#issuecomment-1474775906

   maybe you need to compile dev and get the e2e-connector which supports HTTPS


-- 
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] [incubator-seatunnel] w398507661 commented on issue #4341: ST导入ES问题,意思不支持https协议

Posted by "w398507661 (via GitHub)" <gi...@apache.org>.
w398507661 commented on issue #4341:
URL: https://github.com/apache/incubator-seatunnel/issues/4341#issuecomment-1465730154

   The problem of ST importing ES means that the https protocol is not supported.


-- 
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] [incubator-seatunnel] lightzhao commented on issue #4341: ST导入ES问题,意思不支持https协议

Posted by "lightzhao (via GitHub)" <gi...@apache.org>.
lightzhao commented on issue #4341:
URL: https://github.com/apache/incubator-seatunnel/issues/4341#issuecomment-1465726474

   Please describe your problem in English.


-- 
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] [incubator-seatunnel] lightzhao commented on issue #4341: The problem of ST importing ES means that the https protocol is not supported

Posted by "lightzhao (via GitHub)" <gi...@apache.org>.
lightzhao commented on issue #4341:
URL: https://github.com/apache/incubator-seatunnel/issues/4341#issuecomment-1465742187

   > The problem of ST importing ES means that the https protocol is not supported.
   
   Which ES version are you using?Currently supported ElasticSearch version is >= 2.x and < 8.x.


-- 
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] [incubator-seatunnel] github-actions[bot] closed issue #4341: The problem of ST importing ES means that the https protocol is not supported

Posted by "github-actions[bot] (via GitHub)" <gi...@apache.org>.
github-actions[bot] closed issue #4341: The problem of ST importing ES means that the https protocol is not supported
URL: https://github.com/apache/incubator-seatunnel/issues/4341


-- 
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] [incubator-seatunnel] w398507661 commented on issue #4341: The problem of ST importing ES means that the https protocol is not supported

Posted by "w398507661 (via GitHub)" <gi...@apache.org>.
w398507661 commented on issue #4341:
URL: https://github.com/apache/incubator-seatunnel/issues/4341#issuecomment-1465745427

   Yes, version 6.8.0.


-- 
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] [incubator-seatunnel] w398507661 commented on issue #4341: The problem of ST importing ES means that the https protocol is not supported

Posted by "w398507661 (via GitHub)" <gi...@apache.org>.
w398507661 commented on issue #4341:
URL: https://github.com/apache/incubator-seatunnel/issues/4341#issuecomment-1467185581

   ![image](https://user-images.githubusercontent.com/123860050/224865194-60d5cd47-3746-45b1-adbc-a4d49cf0ed4d.png)
   
   This exception after adding.


-- 
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] [incubator-seatunnel] laglangyue commented on issue #4341: The problem of ST importing ES means that the https protocol is not supported

Posted by "laglangyue (via GitHub)" <gi...@apache.org>.
laglangyue commented on issue #4341:
URL: https://github.com/apache/incubator-seatunnel/issues/4341#issuecomment-1466456120

   ![image](https://user-images.githubusercontent.com/35491928/224761233-08e8beef-6fb7-4f73-8998-957e322a96f5.png)
   
   could  you  try to add `https://`?


-- 
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] [incubator-seatunnel] laglangyue commented on issue #4341: The problem of ST importing ES means that the https protocol is not supported

Posted by "laglangyue (via GitHub)" <gi...@apache.org>.
laglangyue commented on issue #4341:
URL: https://github.com/apache/incubator-seatunnel/issues/4341#issuecomment-1474775701

   sorry,in v2.3.0. es-connector not supported es


-- 
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] [incubator-seatunnel] github-actions[bot] commented on issue #4341: The problem of ST importing ES means that the https protocol is not supported

Posted by "github-actions[bot] (via GitHub)" <gi...@apache.org>.
github-actions[bot] commented on issue #4341:
URL: https://github.com/apache/incubator-seatunnel/issues/4341#issuecomment-1512270596

   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