[jira] [Commented] (AIRFLOW-4848) MySQL warnings about aborted connections, missing engine disposal

2021-10-11 Thread Angelo Huang (Jira)


[ 
https://issues.apache.org/jira/browse/AIRFLOW-4848?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17427242#comment-17427242
 ] 

Angelo Huang commented on AIRFLOW-4848:
---

{{We're seeing a lot connection warnnigs as well with Airflow 1.10.9 and 
Mariadb: 10.4.15.}}

{{2021-10-11 16:48:03 63580 [Warning] Aborted connection 63580 to db: 'airflow' 
user: 'blabla' host: 
'airflow-scheduler-prod-64d6cf8879-gb4lz.airflow-scheduler-pr' (Got an error 
reading communication packets)}}
{{2021-10-11 16:48:03 63578 [Warning] Aborted connection 63578 to db: 'airflow' 
user: 'blabla' host: 
'airflow-scheduler-prod-64d6cf8879-gb4lz.airflow-scheduler-pr' (Got an error 
reading communication packets)}}
{{2021-10-11 16:48:03 63581 [Warning] Aborted connection 63581 to db: 'airflow' 
user: 'blabla' host: 
'airflow-scheduler-prod-64d6cf8879-gb4lz.airflow-scheduler-pr' (Got an error 
reading communication packets)}}

> MySQL warnings about aborted connections, missing engine disposal
> -
>
> Key: AIRFLOW-4848
> URL: https://issues.apache.org/jira/browse/AIRFLOW-4848
> Project: Apache Airflow
>  Issue Type: Bug
>  Components: database
>Reporter: t oo
>Assignee: Daniel Huang
>Priority: Minor
>
> I am not referring to airflow logs in filesystem. I am referrring to logs in 
> the MySQL db itself. This affects airflow 1.10.3, mysql rds 5.7.25
>  
> ie
>  
> 2019-06-25T09:55:25.126187Z 54996343 [Note] Aborted connection 54996343 to 
> db: 'airflowdb' user: 'f' host: 'host' (Got an error reading communication 
> packets)
>  2019-06-25T09:55:25.392705Z 54996375 [Note] Aborted connection 54996375 to 
> db: 'airflowdb' user: 'f' host: 'host' (Got an error reading communication 
> packets)
>  2019-06-25T09:55:25.450276Z 54996240 [Note] Aborted connection 54996240 to 
> db: 'airflowdb' user: 'f' host: 'host' (Got an error reading communication 
> packets)
>  2019-06-25T09:55:25.592741Z 54996391 [Note] Aborted connection 54996391 to 
> db: 'airflowdb' user: 'f' host: 'host' (Got an error reading communication 
> packets)



--
This message was sent by Atlassian Jira
(v8.3.4#803005)


[jira] [Comment Edited] (AIRFLOW-4848) MySQL warnings about aborted connections, missing engine disposal

2021-10-11 Thread Angelo Huang (Jira)


[ 
https://issues.apache.org/jira/browse/AIRFLOW-4848?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17427242#comment-17427242
 ] 

Angelo Huang edited comment on AIRFLOW-4848 at 10/11/21, 4:56 PM:
--

[~dxhuang]

{{We're seeing a lot connection warnnigs as well with Airflow 1.10.9 and 
Mariadb: 10.4.15.}}

{{2021-10-11 16:48:03 63580 [Warning] Aborted connection 63580 to db: 'airflow' 
user: 'blabla' host: 
'airflow-scheduler-prod-64d6cf8879-gb4lz.airflow-scheduler-pr' (Got an error 
reading communication packets)}}
 {{2021-10-11 16:48:03 63578 [Warning] Aborted connection 63578 to db: 
'airflow' user: 'blabla' host: 
'airflow-scheduler-prod-64d6cf8879-gb4lz.airflow-scheduler-pr' (Got an error 
reading communication packets)}}
 {{2021-10-11 16:48:03 63581 [Warning] Aborted connection 63581 to db: 
'airflow' user: 'blabla' host: 
'airflow-scheduler-prod-64d6cf8879-gb4lz.airflow-scheduler-pr' (Got an error 
reading communication packets)}}


was (Author: angelohuang):
{{[~dxhuang] }}

{{We're seeing a lot connection warnnigs as well with Airflow 1.10.9 and 
Mariadb: 10.4.15.}}

{{2021-10-11 16:48:03 63580 [Warning] Aborted connection 63580 to db: 'airflow' 
user: 'blabla' host: 
'airflow-scheduler-prod-64d6cf8879-gb4lz.airflow-scheduler-pr' (Got an error 
reading communication packets)}}
 {{2021-10-11 16:48:03 63578 [Warning] Aborted connection 63578 to db: 
'airflow' user: 'blabla' host: 
'airflow-scheduler-prod-64d6cf8879-gb4lz.airflow-scheduler-pr' (Got an error 
reading communication packets)}}
 {{2021-10-11 16:48:03 63581 [Warning] Aborted connection 63581 to db: 
'airflow' user: 'blabla' host: 
'airflow-scheduler-prod-64d6cf8879-gb4lz.airflow-scheduler-pr' (Got an error 
reading communication packets)}}

> MySQL warnings about aborted connections, missing engine disposal
> -
>
> Key: AIRFLOW-4848
> URL: https://issues.apache.org/jira/browse/AIRFLOW-4848
> Project: Apache Airflow
>  Issue Type: Bug
>  Components: database
>Reporter: t oo
>Assignee: Daniel Huang
>Priority: Minor
>
> I am not referring to airflow logs in filesystem. I am referrring to logs in 
> the MySQL db itself. This affects airflow 1.10.3, mysql rds 5.7.25
>  
> ie
>  
> 2019-06-25T09:55:25.126187Z 54996343 [Note] Aborted connection 54996343 to 
> db: 'airflowdb' user: 'f' host: 'host' (Got an error reading communication 
> packets)
>  2019-06-25T09:55:25.392705Z 54996375 [Note] Aborted connection 54996375 to 
> db: 'airflowdb' user: 'f' host: 'host' (Got an error reading communication 
> packets)
>  2019-06-25T09:55:25.450276Z 54996240 [Note] Aborted connection 54996240 to 
> db: 'airflowdb' user: 'f' host: 'host' (Got an error reading communication 
> packets)
>  2019-06-25T09:55:25.592741Z 54996391 [Note] Aborted connection 54996391 to 
> db: 'airflowdb' user: 'f' host: 'host' (Got an error reading communication 
> packets)



--
This message was sent by Atlassian Jira
(v8.3.4#803005)


[jira] [Comment Edited] (AIRFLOW-4848) MySQL warnings about aborted connections, missing engine disposal

2021-10-11 Thread Angelo Huang (Jira)


[ 
https://issues.apache.org/jira/browse/AIRFLOW-4848?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17427242#comment-17427242
 ] 

Angelo Huang edited comment on AIRFLOW-4848 at 10/11/21, 4:56 PM:
--

{{[~dxhuang] }}

{{We're seeing a lot connection warnnigs as well with Airflow 1.10.9 and 
Mariadb: 10.4.15.}}

{{2021-10-11 16:48:03 63580 [Warning] Aborted connection 63580 to db: 'airflow' 
user: 'blabla' host: 
'airflow-scheduler-prod-64d6cf8879-gb4lz.airflow-scheduler-pr' (Got an error 
reading communication packets)}}
 {{2021-10-11 16:48:03 63578 [Warning] Aborted connection 63578 to db: 
'airflow' user: 'blabla' host: 
'airflow-scheduler-prod-64d6cf8879-gb4lz.airflow-scheduler-pr' (Got an error 
reading communication packets)}}
 {{2021-10-11 16:48:03 63581 [Warning] Aborted connection 63581 to db: 
'airflow' user: 'blabla' host: 
'airflow-scheduler-prod-64d6cf8879-gb4lz.airflow-scheduler-pr' (Got an error 
reading communication packets)}}


was (Author: angelohuang):
{{We're seeing a lot connection warnnigs as well with Airflow 1.10.9 and 
Mariadb: 10.4.15.}}

{{2021-10-11 16:48:03 63580 [Warning] Aborted connection 63580 to db: 'airflow' 
user: 'blabla' host: 
'airflow-scheduler-prod-64d6cf8879-gb4lz.airflow-scheduler-pr' (Got an error 
reading communication packets)}}
{{2021-10-11 16:48:03 63578 [Warning] Aborted connection 63578 to db: 'airflow' 
user: 'blabla' host: 
'airflow-scheduler-prod-64d6cf8879-gb4lz.airflow-scheduler-pr' (Got an error 
reading communication packets)}}
{{2021-10-11 16:48:03 63581 [Warning] Aborted connection 63581 to db: 'airflow' 
user: 'blabla' host: 
'airflow-scheduler-prod-64d6cf8879-gb4lz.airflow-scheduler-pr' (Got an error 
reading communication packets)}}

> MySQL warnings about aborted connections, missing engine disposal
> -
>
> Key: AIRFLOW-4848
> URL: https://issues.apache.org/jira/browse/AIRFLOW-4848
> Project: Apache Airflow
>  Issue Type: Bug
>  Components: database
>Reporter: t oo
>Assignee: Daniel Huang
>Priority: Minor
>
> I am not referring to airflow logs in filesystem. I am referrring to logs in 
> the MySQL db itself. This affects airflow 1.10.3, mysql rds 5.7.25
>  
> ie
>  
> 2019-06-25T09:55:25.126187Z 54996343 [Note] Aborted connection 54996343 to 
> db: 'airflowdb' user: 'f' host: 'host' (Got an error reading communication 
> packets)
>  2019-06-25T09:55:25.392705Z 54996375 [Note] Aborted connection 54996375 to 
> db: 'airflowdb' user: 'f' host: 'host' (Got an error reading communication 
> packets)
>  2019-06-25T09:55:25.450276Z 54996240 [Note] Aborted connection 54996240 to 
> db: 'airflowdb' user: 'f' host: 'host' (Got an error reading communication 
> packets)
>  2019-06-25T09:55:25.592741Z 54996391 [Note] Aborted connection 54996391 to 
> db: 'airflowdb' user: 'f' host: 'host' (Got an error reading communication 
> packets)



--
This message was sent by Atlassian Jira
(v8.3.4#803005)


[jira] [Commented] (AIRFLOW-4848) MySQL warnings about aborted connections, missing engine disposal

2021-10-11 Thread Angelo Huang (Jira)


[ 
https://issues.apache.org/jira/browse/AIRFLOW-4848?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17427273#comment-17427273
 ] 

Angelo Huang commented on AIRFLOW-4848:
---

[~mkjasinski] Have you found a solution yet?

> MySQL warnings about aborted connections, missing engine disposal
> -
>
> Key: AIRFLOW-4848
> URL: https://issues.apache.org/jira/browse/AIRFLOW-4848
> Project: Apache Airflow
>  Issue Type: Bug
>  Components: database
>Reporter: t oo
>Assignee: Daniel Huang
>Priority: Minor
>
> I am not referring to airflow logs in filesystem. I am referrring to logs in 
> the MySQL db itself. This affects airflow 1.10.3, mysql rds 5.7.25
>  
> ie
>  
> 2019-06-25T09:55:25.126187Z 54996343 [Note] Aborted connection 54996343 to 
> db: 'airflowdb' user: 'f' host: 'host' (Got an error reading communication 
> packets)
>  2019-06-25T09:55:25.392705Z 54996375 [Note] Aborted connection 54996375 to 
> db: 'airflowdb' user: 'f' host: 'host' (Got an error reading communication 
> packets)
>  2019-06-25T09:55:25.450276Z 54996240 [Note] Aborted connection 54996240 to 
> db: 'airflowdb' user: 'f' host: 'host' (Got an error reading communication 
> packets)
>  2019-06-25T09:55:25.592741Z 54996391 [Note] Aborted connection 54996391 to 
> db: 'airflowdb' user: 'f' host: 'host' (Got an error reading communication 
> packets)



--
This message was sent by Atlassian Jira
(v8.3.4#803005)