You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@dolphinscheduler.apache.org by GitBox <gi...@apache.org> on 2022/04/26 02:11:28 UTC

[GitHub] [dolphinscheduler] Wilson-BT opened a new issue, #9767: [Bug] [dolphinscheduler-alert-email] send mail with attachment from sql task failed

Wilson-BT opened a new issue, #9767:
URL: https://github.com/apache/dolphinscheduler/issues/9767

   ### Search before asking
   
   - [X] I had searched in the [issues](https://github.com/apache/dolphinscheduler/issues?q=is%3Aissue) and found no similar issues.
   
   
   ### What happened
   
   When we exec DML sql task,and send mail with attachment.it will fail with no exception.
   
   ### What you expected to happen
   
   Send mail success.
   
   ### How to reproduce
   
   As this image:
   ![image](https://user-images.githubusercontent.com/40427110/165202496-5e9273f9-9d3c-4394-961d-a2ae60b3c163.png)
   the alert type is send mail like this:
   ![image](https://user-images.githubusercontent.com/40427110/165202733-67c7eadc-8510-40b7-84e2-3d4b54785cad.png)
   it will not write a whole .xlsx file and send failed with no exception.
   
   ### Anything else
   
   Hadoop-common and hadoop-client use common-compress-1.4.1, and  poi-ooxml use common-compress-1.19.1.
   But the project maven package has only common-compress-1.4.1, it will cause ClassNotFoundError  when alert write xlsx-type file.
   
   
   ### Version
   
   2.0.5
   
   ### 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@dolphinscheduler.apache.org.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org


[GitHub] [dolphinscheduler] Wilson-BT commented on issue #9767: [Bug] [dolphinscheduler-alert-email] send mail with attachment from sql task failed

Posted by GitBox <gi...@apache.org>.
Wilson-BT commented on issue #9767:
URL: https://github.com/apache/dolphinscheduler/issues/9767#issuecomment-1109241029

   I just add  the flow exclusion code in dolphinscheduler/pom.xml to solve this problem.
   But because i have no hadoop env,i can`t do some hadoop test.
   ```
   <dependency>
                   <groupId>org.apache.hadoop</groupId>
                   <artifactId>hadoop-common</artifactId>
                   <version>${hadoop.version}</version>
                   <exclusion>
                           <groupId>org.apache.commons</groupId>
                           <artifactId>commons-compress</artifactId>
                   </exclusion>
   <dependency>
   <dependency>
                   <groupId>org.apache.hadoop</groupId>
                   <artifactId>hadoop-client</artifactId>
                   <version>${hadoop.version}</version>
                   <exclusions>
                       <exclusion>
                           <groupId>org.apache.commons</groupId>
                           <artifactId>commons-compress</artifactId>
                       </exclusion>
                   </exclusions>
               </dependency>
   <dependency>
                   <groupId>org.apache.hadoop</groupId>
                   <artifactId>hadoop-yarn-common</artifactId>
                   <version>${hadoop.version}</version>
                   <exclusions>
                       <exclusion>
                           <groupId>org.apache.commons</groupId>
                           <artifactId>commons-compress</artifactId>
                       </exclusion>
                   </exclusions>
               </dependency>
   ``


-- 
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@dolphinscheduler.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org


[GitHub] [dolphinscheduler] github-actions[bot] commented on issue #9767: [Bug] [dolphinscheduler-alert-email] send mail with attachment from sql task failed

Posted by GitBox <gi...@apache.org>.
github-actions[bot] commented on issue #9767:
URL: https://github.com/apache/dolphinscheduler/issues/9767#issuecomment-1146474784

   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@dolphinscheduler.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org


[GitHub] [dolphinscheduler] github-actions[bot] commented on issue #9767: [Bug] [dolphinscheduler-alert-email] send mail with attachment from sql task failed

Posted by GitBox <gi...@apache.org>.
github-actions[bot] commented on issue #9767:
URL: https://github.com/apache/dolphinscheduler/issues/9767#issuecomment-1109224267

   Thank you for your feedback, we have received your issue, Please wait patiently for a reply.
   * In order for us to understand your request as soon as possible, please provide detailed information、version or pictures.
   * If you haven't received a reply for a long time, you can [join our slack](https://join.slack.com/t/asf-dolphinscheduler/shared_invite/zt-omtdhuio-_JISsxYhiVsltmC5h38yfw) and send your question to channel `#troubleshooting`


-- 
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@dolphinscheduler.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org


[GitHub] [dolphinscheduler] Tianqi-Dotes commented on issue #9767: [Bug] [dolphinscheduler-alert-email] send mail with attachment from sql task failed

Posted by GitBox <gi...@apache.org>.
Tianqi-Dotes commented on issue #9767:
URL: https://github.com/apache/dolphinscheduler/issues/9767#issuecomment-1109262622

   @Wilson-BT hi, 205 exactly have this issue will cause function dead when you using attachments.
   please refer to https://github.com/apache/dolphinscheduler/issues/7874
   I will come back to the issue these days and will check the differences between dev and version 2.0.5


-- 
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@dolphinscheduler.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org


[GitHub] [dolphinscheduler] Wilson-BT commented on issue #9767: [Bug] [dolphinscheduler-alert-email] send mail with attachment from sql task failed

Posted by GitBox <gi...@apache.org>.
Wilson-BT commented on issue #9767:
URL: https://github.com/apache/dolphinscheduler/issues/9767#issuecomment-1109302854

   > @Wilson-BT hi, 205 exactly have this issue will cause function dead when you using attachments. please refer to #7874 I will come back to the issue these days and will check the differences between dev and version 2.0.5
   
   The cause of the incident has been found out like my reply above. It`s just my solution.I don`t know if it suitable for hadoop project


-- 
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@dolphinscheduler.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org


[GitHub] [dolphinscheduler] github-actions[bot] closed issue #9767: [Bug] [dolphinscheduler-alert-email] send mail with attachment from sql task failed

Posted by GitBox <gi...@apache.org>.
github-actions[bot] closed issue #9767: [Bug] [dolphinscheduler-alert-email] send mail with attachment from sql task failed
URL: https://github.com/apache/dolphinscheduler/issues/9767


-- 
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@dolphinscheduler.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org


[GitHub] [dolphinscheduler] github-actions[bot] commented on issue #9767: [Bug] [dolphinscheduler-alert-email] send mail with attachment from sql task failed

Posted by GitBox <gi...@apache.org>.
github-actions[bot] commented on issue #9767:
URL: https://github.com/apache/dolphinscheduler/issues/9767#issuecomment-1139168843

   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@dolphinscheduler.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org