Advertisement
Guest User

Untitled

a guest
Apr 22nd, 2019
492
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
Bash 13.85 KB | None | 0 0
  1. scheduler_1_d48fab2aae5e | Mon Apr 22 13:14:58 UTC 2019 - waiting for Postgres... 1/20
  2. scheduler_1_d48fab2aae5e | [2019-04-22 13:15:17,131] {{settings.py:174}} INFO - settings.configure_orm(): Using pool settings. pool_size=5, pool_recycle=1800, pid=1
  3. scheduler_1_d48fab2aae5e | [2019-04-22 13:15:23,823] {{__init__.py:51}} INFO - Using executor CeleryExecutor
  4. scheduler_1_d48fab2aae5e | [2019-04-22 13:15:31,661] {{cli_action_loggers.py:69}} ERROR - Failed on pre-execution callback using <function default_action_log at 0x7fe92f956730>
  5. scheduler_1_d48fab2aae5e | Traceback (most recent call last):
  6. scheduler_1_d48fab2aae5e |   File "/usr/local/lib/python3.6/site-packages/sqlalchemy/engine/base.py", line 1236, in _execute_context
  7. scheduler_1_d48fab2aae5e |     cursor, statement, parameters, context
  8. scheduler_1_d48fab2aae5e |   File "/usr/local/lib/python3.6/site-packages/sqlalchemy/engine/default.py", line 536, in do_execute
  9. scheduler_1_d48fab2aae5e |     cursor.execute(statement, parameters)
  10. scheduler_1_d48fab2aae5e | psycopg2.errors.UndefinedTable: relation "log" does not exist
  11. scheduler_1_d48fab2aae5e | LINE 1: INSERT INTO log (dttm, dag_id, task_id, event, execution_dat...
  12. scheduler_1_d48fab2aae5e |                     ^
  13. scheduler_1_d48fab2aae5e |
  14. scheduler_1_d48fab2aae5e |
  15. scheduler_1_d48fab2aae5e | The above exception was the direct cause of the following exception:
  16. scheduler_1_d48fab2aae5e |
  17. scheduler_1_d48fab2aae5e | Traceback (most recent call last):
  18. scheduler_1_d48fab2aae5e |   File "/usr/local/lib/python3.6/site-packages/airflow/utils/cli_action_loggers.py", line 67, in on_pre_execution
  19. scheduler_1_d48fab2aae5e |     cb(**kwargs)
  20. scheduler_1_d48fab2aae5e |   File "/usr/local/lib/python3.6/site-packages/airflow/utils/cli_action_loggers.py", line 98, in default_action_log
  21. scheduler_1_d48fab2aae5e |     session.add(log)
  22. scheduler_1_d48fab2aae5e |   File "/usr/local/lib/python3.6/contextlib.py", line 88, in __exit__
  23. scheduler_1_d48fab2aae5e |     next(self.gen)
  24. scheduler_1_d48fab2aae5e |   File "/usr/local/lib/python3.6/site-packages/airflow/utils/db.py", line 44, in create_session
  25. scheduler_1_d48fab2aae5e |     session.commit()
  26. scheduler_1_d48fab2aae5e |   File "/usr/local/lib/python3.6/site-packages/sqlalchemy/orm/session.py", line 1023, in commit
  27. scheduler_1_d48fab2aae5e |     self.transaction.commit()
  28. scheduler_1_d48fab2aae5e |   File "/usr/local/lib/python3.6/site-packages/sqlalchemy/orm/session.py", line 487, in commit
  29. scheduler_1_d48fab2aae5e |     self._prepare_impl()
  30. scheduler_1_d48fab2aae5e |   File "/usr/local/lib/python3.6/site-packages/sqlalchemy/orm/session.py", line 466, in _prepare_impl
  31. scheduler_1_d48fab2aae5e |     self.session.flush()
  32. scheduler_1_d48fab2aae5e |   File "/usr/local/lib/python3.6/site-packages/sqlalchemy/orm/session.py", line 2446, in flush
  33. scheduler_1_d48fab2aae5e |     self._flush(objects)
  34. scheduler_1_d48fab2aae5e |   File "/usr/local/lib/python3.6/site-packages/sqlalchemy/orm/session.py", line 2584, in _flush
  35. scheduler_1_d48fab2aae5e |     transaction.rollback(_capture_exception=True)
  36. scheduler_1_d48fab2aae5e |   File "/usr/local/lib/python3.6/site-packages/sqlalchemy/util/langhelpers.py", line 67, in __exit__
  37. scheduler_1_d48fab2aae5e |     compat.reraise(exc_type, exc_value, exc_tb)
  38. scheduler_1_d48fab2aae5e |   File "/usr/local/lib/python3.6/site-packages/sqlalchemy/util/compat.py", line 277, in reraise
  39. scheduler_1_d48fab2aae5e |     raise value
  40. scheduler_1_d48fab2aae5e |   File "/usr/local/lib/python3.6/site-packages/sqlalchemy/orm/session.py", line 2544, in _flush
  41. scheduler_1_d48fab2aae5e |     flush_context.execute()
  42. scheduler_1_d48fab2aae5e |   File "/usr/local/lib/python3.6/site-packages/sqlalchemy/orm/unitofwork.py", line 416, in execute
  43. scheduler_1_d48fab2aae5e |     rec.execute(self)
  44. scheduler_1_d48fab2aae5e |   File "/usr/local/lib/python3.6/site-packages/sqlalchemy/orm/unitofwork.py", line 583, in execute
  45. scheduler_1_d48fab2aae5e |     uow,
  46. scheduler_1_d48fab2aae5e |   File "/usr/local/lib/python3.6/site-packages/sqlalchemy/orm/persistence.py", line 245, in save_obj
  47. scheduler_1_d48fab2aae5e |     insert,
  48. scheduler_1_d48fab2aae5e |   File "/usr/local/lib/python3.6/site-packages/sqlalchemy/orm/persistence.py", line 1116, in _emit_insert_statements
  49. scheduler_1_d48fab2aae5e |     statement, params
  50. scheduler_1_d48fab2aae5e |   File "/usr/local/lib/python3.6/site-packages/sqlalchemy/engine/base.py", line 980, in execute
  51. scheduler_1_d48fab2aae5e |     return meth(self, multiparams, params)
  52. scheduler_1_d48fab2aae5e |   File "/usr/local/lib/python3.6/site-packages/sqlalchemy/sql/elements.py", line 273, in _execute_on_connection
  53. scheduler_1_d48fab2aae5e |     return connection._execute_clauseelement(self, multiparams, params)
  54. scheduler_1_d48fab2aae5e |   File "/usr/local/lib/python3.6/site-packages/sqlalchemy/engine/base.py", line 1099, in _execute_clauseelement
  55. scheduler_1_d48fab2aae5e |     distilled_params,
  56. scheduler_1_d48fab2aae5e |   File "/usr/local/lib/python3.6/site-packages/sqlalchemy/engine/base.py", line 1240, in _execute_context
  57. scheduler_1_d48fab2aae5e |     e, statement, parameters, cursor, context
  58. scheduler_1_d48fab2aae5e |   File "/usr/local/lib/python3.6/site-packages/sqlalchemy/engine/base.py", line 1458, in _handle_dbapi_exception
  59. scheduler_1_d48fab2aae5e |     util.raise_from_cause(sqlalchemy_exception, exc_info)
  60. scheduler_1_d48fab2aae5e |   File "/usr/local/lib/python3.6/site-packages/sqlalchemy/util/compat.py", line 296, in raise_from_cause
  61. scheduler_1_d48fab2aae5e |     reraise(type(exception), exception, tb=exc_tb, cause=cause)
  62. scheduler_1_d48fab2aae5e |   File "/usr/local/lib/python3.6/site-packages/sqlalchemy/util/compat.py", line 276, in reraise
  63. scheduler_1_d48fab2aae5e |     raise value.with_traceback(tb)
  64. scheduler_1_d48fab2aae5e |   File "/usr/local/lib/python3.6/site-packages/sqlalchemy/engine/base.py", line 1236, in _execute_context
  65. scheduler_1_d48fab2aae5e |     cursor, statement, parameters, context
  66. scheduler_1_d48fab2aae5e |   File "/usr/local/lib/python3.6/site-packages/sqlalchemy/engine/default.py", line 536, in do_execute
  67. scheduler_1_d48fab2aae5e |     cursor.execute(statement, parameters)
  68. scheduler_1_d48fab2aae5e | sqlalchemy.exc.ProgrammingError: (psycopg2.errors.UndefinedTable) relation "log" does not exist
  69. scheduler_1_d48fab2aae5e | LINE 1: INSERT INTO log (dttm, dag_id, task_id, event, execution_dat...
  70. scheduler_1_d48fab2aae5e |                     ^
  71. scheduler_1_d48fab2aae5e |  [SQL: 'INSERT INTO log (dttm, dag_id, task_id, event, execution_date, owner, extra) VALUES (%(dttm)s, %(dag_id)s, %(task_id)s, %(event)s, %(execution_date)s, %(owner)s, %(extra)s) RETURNING log.id'] [parameters: {'dttm': datetime.datetime(2019, 4, 22, 13, 15, 31, 580400, tzinfo=<Timezone [UTC]>), 'dag_id': None, 'task_id': None, 'event': 'cli_scheduler', 'execution_date': None, 'owner': 'airflow', 'extra': '{"host_name": "668add730bf7", "full_command": "[\'/usr/local/bin/airflow\', \'scheduler\']"}'}] (Background on this error at: http://sqlalche.me/e/f405)
  72. scheduler_1_d48fab2aae5e |   ____________       _____________
  73. scheduler_1_d48fab2aae5e |  ____    |__( )_________  __/__  /________      __
  74. scheduler_1_d48fab2aae5e | ____  /| |_  /__  ___/_  /_ __  /_  __ \_ | /| / /
  75. scheduler_1_d48fab2aae5e | ___  ___ |  / _  /   _  __/ _  / / /_/ /_ |/ |/ /
  76. scheduler_1_d48fab2aae5e |  _/_/  |_/_/  /_/    /_/    /_/  \____/____/|__/
  77. scheduler_1_d48fab2aae5e |  
  78. scheduler_1_d48fab2aae5e | Traceback (most recent call last):
  79. scheduler_1_d48fab2aae5e |   File "/usr/local/lib/python3.6/site-packages/sqlalchemy/engine/base.py", line 1236, in _execute_context
  80. scheduler_1_d48fab2aae5e |     cursor, statement, parameters, context
  81. scheduler_1_d48fab2aae5e |   File "/usr/local/lib/python3.6/site-packages/sqlalchemy/engine/default.py", line 536, in do_execute
  82. scheduler_1_d48fab2aae5e |     cursor.execute(statement, parameters)
  83. scheduler_1_d48fab2aae5e | psycopg2.errors.UndefinedTable: relation "job" does not exist
  84. scheduler_1_d48fab2aae5e | LINE 1: INSERT INTO job (dag_id, state, job_type, start_date, end_da...
  85. scheduler_1_d48fab2aae5e |                     ^
  86. scheduler_1_d48fab2aae5e |
  87. scheduler_1_d48fab2aae5e |
  88. scheduler_1_d48fab2aae5e | The above exception was the direct cause of the following exception:
  89. scheduler_1_d48fab2aae5e |
  90. scheduler_1_d48fab2aae5e | Traceback (most recent call last):
  91. scheduler_1_d48fab2aae5e |   File "/usr/local/bin/airflow", line 32, in <module>
  92. scheduler_1_d48fab2aae5e |     args.func(args)
  93. scheduler_1_d48fab2aae5e |   File "/usr/local/lib/python3.6/site-packages/airflow/utils/cli.py", line 74, in wrapper
  94. scheduler_1_d48fab2aae5e |     return f(*args, **kwargs)
  95. scheduler_1_d48fab2aae5e |   File "/usr/local/lib/python3.6/site-packages/airflow/bin/cli.py", line 991, in scheduler
  96. scheduler_1_d48fab2aae5e |     job.run()
  97. scheduler_1_d48fab2aae5e |   File "/usr/local/lib/python3.6/site-packages/airflow/jobs.py", line 196, in run
  98. scheduler_1_d48fab2aae5e |     session.commit()
  99. scheduler_1_d48fab2aae5e |   File "/usr/local/lib/python3.6/site-packages/sqlalchemy/orm/session.py", line 1023, in commit
  100. scheduler_1_d48fab2aae5e |     self.transaction.commit()
  101. scheduler_1_d48fab2aae5e |   File "/usr/local/lib/python3.6/site-packages/sqlalchemy/orm/session.py", line 487, in commit
  102. scheduler_1_d48fab2aae5e |     self._prepare_impl()
  103. scheduler_1_d48fab2aae5e |   File "/usr/local/lib/python3.6/site-packages/sqlalchemy/orm/session.py", line 466, in _prepare_impl
  104. scheduler_1_d48fab2aae5e |     self.session.flush()
  105. scheduler_1_d48fab2aae5e |   File "/usr/local/lib/python3.6/site-packages/sqlalchemy/orm/session.py", line 2446, in flush
  106. scheduler_1_d48fab2aae5e |     self._flush(objects)
  107. scheduler_1_d48fab2aae5e |   File "/usr/local/lib/python3.6/site-packages/sqlalchemy/orm/session.py", line 2584, in _flush
  108. scheduler_1_d48fab2aae5e |     transaction.rollback(_capture_exception=True)
  109. scheduler_1_d48fab2aae5e |   File "/usr/local/lib/python3.6/site-packages/sqlalchemy/util/langhelpers.py", line 67, in __exit__
  110. scheduler_1_d48fab2aae5e |     compat.reraise(exc_type, exc_value, exc_tb)
  111. scheduler_1_d48fab2aae5e |   File "/usr/local/lib/python3.6/site-packages/sqlalchemy/util/compat.py", line 277, in reraise
  112. scheduler_1_d48fab2aae5e |     raise value
  113. scheduler_1_d48fab2aae5e |   File "/usr/local/lib/python3.6/site-packages/sqlalchemy/orm/session.py", line 2544, in _flush
  114. scheduler_1_d48fab2aae5e |     flush_context.execute()
  115. scheduler_1_d48fab2aae5e |   File "/usr/local/lib/python3.6/site-packages/sqlalchemy/orm/unitofwork.py", line 416, in execute
  116. scheduler_1_d48fab2aae5e |     rec.execute(self)
  117. scheduler_1_d48fab2aae5e |   File "/usr/local/lib/python3.6/site-packages/sqlalchemy/orm/unitofwork.py", line 583, in execute
  118. scheduler_1_d48fab2aae5e |     uow,
  119. scheduler_1_d48fab2aae5e |   File "/usr/local/lib/python3.6/site-packages/sqlalchemy/orm/persistence.py", line 245, in save_obj
  120. scheduler_1_d48fab2aae5e |     insert,
  121. scheduler_1_d48fab2aae5e |   File "/usr/local/lib/python3.6/site-packages/sqlalchemy/orm/persistence.py", line 1116, in _emit_insert_statements
  122. scheduler_1_d48fab2aae5e |     statement, params
  123. scheduler_1_d48fab2aae5e |   File "/usr/local/lib/python3.6/site-packages/sqlalchemy/engine/base.py", line 980, in execute
  124. scheduler_1_d48fab2aae5e |     return meth(self, multiparams, params)
  125. scheduler_1_d48fab2aae5e |   File "/usr/local/lib/python3.6/site-packages/sqlalchemy/sql/elements.py", line 273, in _execute_on_connection
  126. scheduler_1_d48fab2aae5e |     return connection._execute_clauseelement(self, multiparams, params)
  127. scheduler_1_d48fab2aae5e |   File "/usr/local/lib/python3.6/site-packages/sqlalchemy/engine/base.py", line 1099, in _execute_clauseelement
  128. scheduler_1_d48fab2aae5e |     distilled_params,
  129. scheduler_1_d48fab2aae5e |   File "/usr/local/lib/python3.6/site-packages/sqlalchemy/engine/base.py", line 1240, in _execute_context
  130. scheduler_1_d48fab2aae5e |     e, statement, parameters, cursor, context
  131. scheduler_1_d48fab2aae5e |   File "/usr/local/lib/python3.6/site-packages/sqlalchemy/engine/base.py", line 1458, in _handle_dbapi_exception
  132. scheduler_1_d48fab2aae5e |     util.raise_from_cause(sqlalchemy_exception, exc_info)
  133. scheduler_1_d48fab2aae5e |   File "/usr/local/lib/python3.6/site-packages/sqlalchemy/util/compat.py", line 296, in raise_from_cause
  134. scheduler_1_d48fab2aae5e |     reraise(type(exception), exception, tb=exc_tb, cause=cause)
  135. scheduler_1_d48fab2aae5e |   File "/usr/local/lib/python3.6/site-packages/sqlalchemy/util/compat.py", line 276, in reraise
  136. scheduler_1_d48fab2aae5e |     raise value.with_traceback(tb)
  137. scheduler_1_d48fab2aae5e |   File "/usr/local/lib/python3.6/site-packages/sqlalchemy/engine/base.py", line 1236, in _execute_context
  138. scheduler_1_d48fab2aae5e |     cursor, statement, parameters, context
  139. scheduler_1_d48fab2aae5e |   File "/usr/local/lib/python3.6/site-packages/sqlalchemy/engine/default.py", line 536, in do_execute
  140. scheduler_1_d48fab2aae5e |     cursor.execute(statement, parameters)
  141. scheduler_1_d48fab2aae5e | sqlalchemy.exc.ProgrammingError: (psycopg2.errors.UndefinedTable) relation "job" does not exist
  142. scheduler_1_d48fab2aae5e | LINE 1: INSERT INTO job (dag_id, state, job_type, start_date, end_da...
  143. scheduler_1_d48fab2aae5e |                     ^
  144. scheduler_1_d48fab2aae5e |  [SQL: 'INSERT INTO job (dag_id, state, job_type, start_date, end_date, latest_heartbeat, executor_class, hostname, unixname) VALUES (%(dag_id)s, %(state)s, %(job_type)s, %(start_date)s, %(end_date)s, %(latest_heartbeat)s, %(executor_class)s, %(hostname)s, %(unixname)s) RETURNING job.id'] [parameters: {'dag_id': None, 'state': 'running', 'job_type': 'SchedulerJob', 'start_date': datetime.datetime(2019, 4, 22, 13, 15, 32, 362097, tzinfo=<Timezone [UTC]>), 'end_date': None, 'latest_heartbeat': datetime.datetime(2019, 4, 22, 13, 15, 32, 362158, tzinfo=<Timezone [UTC]>), 'executor_class': 'CeleryExecutor', 'hostname': '668add730bf7', 'unixname': 'airflow'}] (Background on this error at: http://sqlalche.me/e/f405)
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement