LIKEL123 commented on issue #19192: URL: https://github.com/apache/airflow/issues/19192#issuecomment-1022819326
> 顺便提一句。是的，检查在您的数据库中打开的连接的限制可能是一个好主意。特别是如果您在顶层的 DAG 中使用变量，它**可能**会导致打开大量连接，这*最终_可能_导致调度程序尝试打开新连接并耐心等待数据库服务器有任何空闲连接。可能只是因为您长时间运行的任务的编写方式是它们（意外地）打开了许多这些连接并且在任务完成之前不关闭它们。 > > 我认为 PGBouncer**可能会**对此有所帮助，但如果一个长时间运行的任务打开了太多连接并且它们没有关闭，那也可能没有太大帮助。My problem should be the database I have the same problem, and I don't know how to solve it. but my airflow-scheduler.err the errors reported in this log are: "**sqlalchemy.orm.exc.StaleDataError: UPDATE statement on table 'dag_run' expected to update 5 row(s); 0 were matched.** ", How should this problem be solved -- 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: [email protected] For queries about this service, please contact Infrastructure at: [email protected]
