wh-scheduler-api_1 | Using pip from /srv/softwareheritage/venv/bin/pip swh-scheduler-api_1 | Installed Python packages: swh-scheduler-api_1 | Package Version swh-scheduler-api_1 | ----------------------------- -------- swh-scheduler-api_1 | aiohttp 3.5.4 swh-scheduler-api_1 | alabaster 0.7.12 swh-scheduler-api_1 | amqp 2.5.0 swh-scheduler-api_1 | arrow 0.14.2 swh-scheduler-api_1 | async-timeout 3.0.1 swh-scheduler-api_1 | attrs 19.1.0 swh-scheduler-api_1 | Babel 2.7.0 swh-scheduler-api_1 | beautifulsoup4 4.7.1 swh-scheduler-api_1 | billiard 3.6.0.0 swh-scheduler-api_1 | celery 4.3.0 swh-scheduler-api_1 | certifi 2019.3.9 swh-scheduler-api_1 | chardet 3.0.4 swh-scheduler-api_1 | Click 7.0 swh-scheduler-api_1 | decorator 4.4.0 swh-scheduler-api_1 | Django 1.11.21 swh-scheduler-api_1 | django-js-reverse 0.9.1 swh-scheduler-api_1 | django-webpack-loader 0.6.0 swh-scheduler-api_1 | djangorestframework 3.9.4 swh-scheduler-api_1 | docutils 0.14 swh-scheduler-api_1 | dulwich 0.19.11 swh-scheduler-api_1 | elasticsearch 7.0.2 swh-scheduler-api_1 | fastimport 0.9.8 swh-scheduler-api_1 | file-magic 0.4.0 swh-scheduler-api_1 | Flask 1.0.3 swh-scheduler-api_1 | gunicorn 19.9.0 swh-scheduler-api_1 | htmlmin 0.1.12 swh-scheduler-api_1 | hypothesis 4.24.2 swh-scheduler-api_1 | idna 2.8 swh-scheduler-api_1 | imagesize 1.1.0 swh-scheduler-api_1 | iso8601 0.1.12 swh-scheduler-api_1 | itsdangerous 1.1.0 swh-scheduler-api_1 | Jinja2 2.10.1 swh-scheduler-api_1 | kafka-python 1.4.6 swh-scheduler-api_1 | kombu 4.6.1 swh-scheduler-api_1 | lxml 4.3.3 swh-scheduler-api_1 | MarkupSafe 1.1.1 swh-scheduler-api_1 | msgpack 0.6.1 swh-scheduler-api_1 | multidict 4.5.2 swh-scheduler-api_1 | packaging 19.0 swh-scheduler-api_1 | patool 1.12 swh-scheduler-api_1 | pip 19.1.1 swh-scheduler-api_1 | pkginfo 1.5.0.1 swh-scheduler-api_1 | psutil 5.6.2 swh-scheduler-api_1 | psycopg2 2.8.2 swh-scheduler-api_1 | Pygments 2.4.2 swh-scheduler-api_1 | PyLD 1.0.5 swh-scheduler-api_1 | pypandoc 1.4 swh-scheduler-api_1 | pyparsing 2.4.0 swh-scheduler-api_1 | python-dateutil 2.8.0 swh-scheduler-api_1 | python-debian 0.1.34 swh-scheduler-api_1 | python-hglib 2.6.1 swh-scheduler-api_1 | python-memcached 1.59 swh-scheduler-api_1 | pytz 2019.1 swh-scheduler-api_1 | PyYAML 5.1 swh-scheduler-api_1 | requests 2.22.0 swh-scheduler-api_1 | retrying 1.3.3 swh-scheduler-api_1 | setuptools 41.0.1 swh-scheduler-api_1 | six 1.12.0 swh-scheduler-api_1 | snowballstemmer 1.2.1 swh-scheduler-api_1 | soupsieve 1.9.1 swh-scheduler-api_1 | Sphinx 2.1.0 swh-scheduler-api_1 | sphinxcontrib-applehelp 1.0.1 swh-scheduler-api_1 | sphinxcontrib-devhelp 1.0.1 swh-scheduler-api_1 | sphinxcontrib-htmlhelp 1.0.2 swh-scheduler-api_1 | sphinxcontrib-httpdomain 1.7.0 swh-scheduler-api_1 | sphinxcontrib-jsmath 1.0.1 swh-scheduler-api_1 | sphinxcontrib-qthelp 1.0.2 swh-scheduler-api_1 | sphinxcontrib-serializinghtml 1.1.3 swh-scheduler-api_1 | SQLAlchemy 1.3.4 swh-scheduler-api_1 | sqlitedict 1.6.0 swh-scheduler-api_1 | subvertpy 0.10.1 swh-scheduler-api_1 | swh.core 0.0.63 swh-scheduler-api_1 | swh.deposit 0.0.71 swh-scheduler-api_1 | swh.indexer 0.0.147 swh-scheduler-api_1 | swh.journal 0.0.10 swh-scheduler-api_1 | swh.lister 0.0.23 swh-scheduler-api_1 | swh.loader.core 0.0.42 swh-scheduler-api_1 | swh.loader.debian 0.0.13 swh-scheduler-api_1 | swh.loader.dir 0.0.34 swh-scheduler-api_1 | swh.loader.git 0.0.48 swh-scheduler-api_1 | swh.loader.mercurial 0.0.16 swh-scheduler-api_1 | swh.loader.npm 0.0.6 swh-scheduler-api_1 | swh.loader.pypi 0.0.9 swh-scheduler-api_1 | swh.loader.svn 0.0.44 swh-scheduler-api_1 | swh.loader.tar 0.0.40 swh-scheduler-api_1 | swh.model 0.0.36 swh-scheduler-api_1 | swh.objstorage 0.0.33 swh-scheduler-api_1 | swh.scheduler 0.0.56 swh-scheduler-api_1 | swh.storage 0.0.140 swh-scheduler-api_1 | swh.vault 0.0.29 swh-scheduler-api_1 | swh.web 0.0.201 swh-scheduler-api_1 | systemd-python 234 swh-scheduler-api_1 | urllib3 1.25.3 swh-scheduler-api_1 | vcversioner 2.16.0.0 swh-scheduler-api_1 | vine 1.3.0 swh-scheduler-api_1 | Werkzeug 0.15.4 swh-scheduler-api_1 | wheel 0.33.4 swh-scheduler-api_1 | xmltodict 0.12.0 swh-scheduler-api_1 | yarl 1.3.0 swh-scheduler-api_1 | Waiting for postgresql to start swh-scheduler-api_1 | wait-for-it: waiting for swh-scheduler-db:5432 without a timeout swh-scheduler-api_1 | wait-for-it: swh-scheduler-db:5432 is available after 168 seconds swh-scheduler-api_1 | Setup the swh-scheduler API database swh-scheduler-api_1 | createdb: database creation failed: ERROR: database "swh-scheduler" already exists swh-scheduler-api_1 | ERROR: relation "dbversion" does not exist swh-scheduler-api_1 | LINE 1: select version from dbversion order by dbversion desc limit ... swh-scheduler-api_1 | ^ swh-scheduler-api_1 | Loading /srv/softwareheritage/venv/lib/python3.7/site-packages/swh/scheduler/sql/30-swh-schema.sql swh-scheduler-api_1 | Loading /srv/softwareheritage/venv/lib/python3.7/site-packages/swh/scheduler/sql/40-swh-func.sql swh-scheduler-api_1 | Loading /srv/softwareheritage/venv/lib/python3.7/site-packages/swh/scheduler/sql/50-swh-data.sql swh-scheduler-api_1 | swh_add_backward_compatible_task_name swh-scheduler-api_1 | --------------------------------------- swh-scheduler-api_1 | swh-scheduler-api_1 | (1 row) swh-scheduler-api_1 | swh-scheduler-api_1 | swh_add_backward_compatible_task_name swh-scheduler-api_1 | --------------------------------------- swh-scheduler-api_1 | swh-scheduler-api_1 | (1 row) swh-scheduler-api_1 | swh-scheduler-api_1 | swh_add_backward_compatible_task_name swh-scheduler-api_1 | --------------------------------------- swh-scheduler-api_1 | swh-scheduler-api_1 | (1 row) swh-scheduler-api_1 | swh-scheduler-api_1 | swh_add_backward_compatible_task_name swh-scheduler-api_1 | --------------------------------------- swh-scheduler-api_1 | swh-scheduler-api_1 | (1 row) swh-scheduler-api_1 | swh-scheduler-api_1 | swh_add_backward_compatible_task_name swh-scheduler-api_1 | --------------------------------------- swh-scheduler-api_1 | swh-scheduler-api_1 | (1 row) swh-scheduler-api_1 | swh-scheduler-api_1 | swh_add_backward_compatible_task_name swh-scheduler-api_1 | --------------------------------------- swh-scheduler-api_1 | swh-scheduler-api_1 | (1 row) swh-scheduler-api_1 | swh-scheduler-api_1 | swh_add_backward_compatible_task_name swh-scheduler-api_1 | --------------------------------------- swh-scheduler-api_1 | swh-scheduler-api_1 | (1 row) swh-scheduler-api_1 | swh-scheduler-api_1 | swh_add_backward_compatible_task_name swh-scheduler-api_1 | --------------------------------------- swh-scheduler-api_1 | swh-scheduler-api_1 | (1 row) swh-scheduler-api_1 | swh-scheduler-api_1 | swh_add_backward_compatible_task_name swh-scheduler-api_1 | --------------------------------------- swh-scheduler-api_1 | swh-scheduler-api_1 | (1 row) swh-scheduler-api_1 | swh-scheduler-api_1 | swh_add_backward_compatible_task_name swh-scheduler-api_1 | --------------------------------------- swh-scheduler-api_1 | swh-scheduler-api_1 | (1 row) swh-scheduler-api_1 | swh-scheduler-api_1 | swh_add_backward_compatible_task_name swh-scheduler-api_1 | --------------------------------------- swh-scheduler-api_1 | swh-scheduler-api_1 | (1 row) swh-scheduler-api_1 | swh-scheduler-api_1 | swh_add_backward_compatible_task_name swh-scheduler-api_1 | --------------------------------------- swh-scheduler-api_1 | swh-scheduler-api_1 | (1 row) swh-scheduler-api_1 | swh-scheduler-api_1 | swh_add_backward_compatible_task_name swh-scheduler-api_1 | --------------------------------------- swh-scheduler-api_1 | swh-scheduler-api_1 | (1 row) swh-scheduler-api_1 | swh-scheduler-api_1 | swh_add_backward_compatible_task_name swh-scheduler-api_1 | --------------------------------------- swh-scheduler-api_1 | swh-scheduler-api_1 | (1 row) swh-scheduler-api_1 | swh-scheduler-api_1 | swh_add_backward_compatible_task_name swh-scheduler-api_1 | --------------------------------------- swh-scheduler-api_1 | swh-scheduler-api_1 | (1 row) swh-scheduler-api_1 | swh-scheduler-api_1 | swh_add_backward_compatible_task_name swh-scheduler-api_1 | --------------------------------------- swh-scheduler-api_1 | swh-scheduler-api_1 | (1 row) swh-scheduler-api_1 | swh-scheduler-api_1 | swh_add_backward_compatible_task_name swh-scheduler-api_1 | --------------------------------------- swh-scheduler-api_1 | swh-scheduler-api_1 | (1 row) swh-scheduler-api_1 | swh-scheduler-api_1 | swh_add_backward_compatible_task_name swh-scheduler-api_1 | --------------------------------------- swh-scheduler-api_1 | swh-scheduler-api_1 | (1 row) swh-scheduler-api_1 | swh-scheduler-api_1 | swh_add_backward_compatible_task_name swh-scheduler-api_1 | --------------------------------------- swh-scheduler-api_1 | swh-scheduler-api_1 | (1 row) swh-scheduler-api_1 | swh-scheduler-api_1 | swh_add_backward_compatible_task_name swh-scheduler-api_1 | --------------------------------------- swh-scheduler-api_1 | swh-scheduler-api_1 | (1 row) swh-scheduler-api_1 | swh-scheduler-api_1 | swh_add_backward_compatible_task_name swh-scheduler-api_1 | --------------------------------------- swh-scheduler-api_1 | swh-scheduler-api_1 | (1 row) swh-scheduler-api_1 | swh-scheduler-api_1 | swh_add_backward_compatible_task_name swh-scheduler-api_1 | --------------------------------------- swh-scheduler-api_1 | swh-scheduler-api_1 | (1 row) swh-scheduler-api_1 | swh-scheduler-api_1 | swh_add_backward_compatible_task_name swh-scheduler-api_1 | --------------------------------------- swh-scheduler-api_1 | swh-scheduler-api_1 | (1 row) swh-scheduler-api_1 | swh-scheduler-api_1 | swh_add_backward_compatible_task_name swh-scheduler-api_1 | --------------------------------------- swh-scheduler-api_1 | swh-scheduler-api_1 | (1 row) swh-scheduler-api_1 | swh-scheduler-api_1 | swh_add_backward_compatible_task_name swh-scheduler-api_1 | --------------------------------------- swh-scheduler-api_1 | swh-scheduler-api_1 | (1 row) swh-scheduler-api_1 | swh-scheduler-api_1 | Loading /srv/softwareheritage/venv/lib/python3.7/site-packages/swh/scheduler/sql/60-swh-indexes.sql swh-scheduler-api_1 | DONE database is swh-scheduler version 12 swh-scheduler-api_1 | Starting the swh-scheduler API server swh-scheduler-api_1 | [2019-06-06 17:24:37 +0000] [1] [DEBUG] Current configuration: swh-scheduler-api_1 | config: None swh-scheduler-api_1 | bind: ['0.0.0.0:5008'] swh-scheduler-api_1 | backlog: 2048 swh-scheduler-api_1 | workers: 1 swh-scheduler-api_1 | worker_class: sync swh-scheduler-api_1 | threads: 1 swh-scheduler-api_1 | worker_connections: 1000 swh-scheduler-api_1 | max_requests: 0 swh-scheduler-api_1 | max_requests_jitter: 0 swh-scheduler-api_1 | timeout: 3600 swh-scheduler-api_1 | graceful_timeout: 30 swh-scheduler-api_1 | keepalive: 2 swh-scheduler-api_1 | limit_request_line: 4094 swh-scheduler-api_1 | limit_request_fields: 100 swh-scheduler-api_1 | limit_request_field_size: 8190 swh-scheduler-api_1 | reload: True swh-scheduler-api_1 | reload_engine: auto swh-scheduler-api_1 | reload_extra_files: [] swh-scheduler-api_1 | spew: False swh-scheduler-api_1 | check_config: False swh-scheduler-api_1 | preload_app: False swh-scheduler-api_1 | sendfile: None swh-scheduler-api_1 | reuse_port: False swh-scheduler-api_1 | chdir: / swh-scheduler-api_1 | daemon: False swh-scheduler-api_1 | raw_env: [] swh-scheduler-api_1 | pidfile: None swh-scheduler-api_1 | worker_tmp_dir: None swh-scheduler-api_1 | user: 1000 swh-scheduler-api_1 | group: 1000 swh-scheduler-api_1 | umask: 0 swh-scheduler-api_1 | initgroups: False swh-scheduler-api_1 | tmp_upload_dir: None swh-scheduler-api_1 | secure_scheme_headers: {'X-FORWARDED-PROTOCOL': 'ssl', 'X-FORWARDED-PROTO': 'https', 'X-FORWARDED-SSL': 'on'} swh-scheduler-api_1 | forwarded_allow_ips: ['127.0.0.1'] swh-scheduler-api_1 | accesslog: None swh-scheduler-api_1 | disable_redirect_access_to_syslog: False swh-scheduler-api_1 | access_log_format: %(h)s %(l)s %(u)s %(t)s "%(r)s" %(s)s %(b)s "%(f)s" "%(a)s" swh-scheduler-api_1 | errorlog: - swh-scheduler-api_1 | loglevel: DEBUG swh-scheduler-api_1 | capture_output: False swh-scheduler-api_1 | logger_class: gunicorn.glogging.Logger swh-scheduler-api_1 | logconfig: None swh-scheduler-api_1 | logconfig_dict: {} swh-scheduler-api_1 | syslog_addr: udp://localhost:514 swh-scheduler-api_1 | syslog: False swh-scheduler-api_1 | syslog_prefix: None swh-scheduler-api_1 | syslog_facility: user swh-scheduler-api_1 | enable_stdio_inheritance: False swh-scheduler-api_1 | statsd_host: None swh-scheduler-api_1 | statsd_prefix: swh-scheduler-api_1 | proc_name: None swh-scheduler-api_1 | default_proc_name: swh.scheduler.api.wsgi swh-scheduler-api_1 | pythonpath: None swh-scheduler-api_1 | paste: None swh-scheduler-api_1 | on_starting: swh-scheduler-api_1 | on_reload: swh-scheduler-api_1 | when_ready: swh-scheduler-api_1 | pre_fork: swh-scheduler-api_1 | post_fork: swh-scheduler-api_1 | post_worker_init: swh-scheduler-api_1 | worker_int: swh-scheduler-api_1 | worker_abort: swh-scheduler-api_1 | pre_exec: swh-scheduler-api_1 | pre_request: swh-scheduler-api_1 | post_request: swh-scheduler-api_1 | child_exit: swh-scheduler-api_1 | worker_exit: swh-scheduler-api_1 | nworkers_changed: swh-scheduler-api_1 | on_exit: swh-scheduler-api_1 | proxy_protocol: False swh-scheduler-api_1 | proxy_allow_ips: ['127.0.0.1'] swh-scheduler-api_1 | keyfile: None swh-scheduler-api_1 | certfile: None swh-scheduler-api_1 | ssl_version: 2 swh-scheduler-api_1 | cert_reqs: 0 swh-scheduler-api_1 | ca_certs: None swh-scheduler-api_1 | suppress_ragged_eofs: True swh-scheduler-api_1 | do_handshake_on_connect: False swh-scheduler-api_1 | ciphers: TLSv1 swh-scheduler-api_1 | raw_paste_global_conf: [] swh-scheduler-api_1 | [2019-06-06 17:24:37 +0000] [1] [INFO] Starting gunicorn 19.9.0 swh-scheduler-api_1 | [2019-06-06 17:24:37 +0000] [1] [DEBUG] Arbiter booted swh-scheduler-api_1 | [2019-06-06 17:24:37 +0000] [1] [INFO] Listening at: http://0.0.0.0:5008 (1) swh-scheduler-api_1 | [2019-06-06 17:24:37 +0000] [1] [INFO] Using worker: sync swh-scheduler-api_1 | [2019-06-06 17:24:38 +0000] [411] [INFO] Booting worker with pid: 411 swh-scheduler-api_1 | [2019-06-06 17:24:38 +0000] [1] [DEBUG] 1 workers swh-scheduler-api_1 | [2019-06-06 17:26:50 +0000] [411] [DEBUG] POST /get_task_types swh-scheduler-api_1 | [2019-06-06 19:22:53 +0000] [411] [DEBUG] POST /get_task_types swh-scheduler-api_1 | [2019-06-06 19:30:51 +0000] [411] [DEBUG] POST /create_tasks swh-scheduler-api_1 | ERROR:root:null value in column "retries_left" violates not-null constraint swh-scheduler-api_1 | DETAIL: Failing row contains (1, load-gnu, {"args": ["autogen", "https://ftp.gnu.org/gnu/autogen/"], "kwarg..., 2019-06-06 19:30:45.566495+00, null, next_run_not_scheduled, recurring, null, null). swh-scheduler-api_1 | CONTEXT: SQL statement "insert into task (type, arguments, next_run, status, current_interval, policy, swh-scheduler-api_1 | retries_left, priority) swh-scheduler-api_1 | select type, arguments, next_run, status, current_interval, policy, swh-scheduler-api_1 | retries_left, priority swh-scheduler-api_1 | from tmp_task t swh-scheduler-api_1 | where not exists(select 1 swh-scheduler-api_1 | from task swh-scheduler-api_1 | where type = t.type and swh-scheduler-api_1 | arguments->'args' = t.arguments->'args' and swh-scheduler-api_1 | arguments->'kwargs' = t.arguments->'kwargs' and swh-scheduler-api_1 | policy = t.policy and swh-scheduler-api_1 | priority is not distinct from t.priority and swh-scheduler-api_1 | status = t.status)" swh-scheduler-api_1 | PL/pgSQL function swh_scheduler_create_tasks_from_temp() line 12 at SQL statement swh-scheduler-api_1 | Traceback (most recent call last): swh-scheduler-api_1 | File "/srv/softwareheritage/venv/lib/python3.7/site-packages/flask/app.py", line 1832, in full_dispatch_request swh-scheduler-api_1 | rv = self.dispatch_request() swh-scheduler-api_1 | File "/srv/softwareheritage/venv/lib/python3.7/site-packages/flask/app.py", line 1818, in dispatch_request swh-scheduler-api_1 | return self.view_functions[rule.endpoint](**req.view_args) swh-scheduler-api_1 | File "", line 2, in create_tasks swh-scheduler-api_1 | File "/srv/softwareheritage/venv/lib/python3.7/site-packages/swh/core/api/negotiation.py", line 143, in _negotiate swh-scheduler-api_1 | return f.negotiator(*args, **kwargs) swh-scheduler-api_1 | File "/srv/softwareheritage/venv/lib/python3.7/site-packages/swh/core/api/negotiation.py", line 78, in __call__ swh-scheduler-api_1 | result = self.func(*args, **kwargs) swh-scheduler-api_1 | File "/srv/softwareheritage/venv/lib/python3.7/site-packages/swh/scheduler/api/server.py", line 86, in create_tasks swh-scheduler-api_1 | return get_sched().create_tasks(**decode_request(request)) swh-scheduler-api_1 | File "/srv/softwareheritage/venv/lib/python3.7/site-packages/swh/core/db/common.py", line 49, in _meth swh-scheduler-api_1 | return meth(self, *args, db=db, cur=cur, **kwargs) swh-scheduler-api_1 | File "/srv/softwareheritage/venv/lib/python3.7/site-packages/swh/scheduler/backend.py", line 161, in create_tasks swh-scheduler-api_1 | cur.execute(query) swh-scheduler-api_1 | File "/srv/softwareheritage/venv/lib/python3.7/site-packages/psycopg2/extras.py", line 243, in execute swh-scheduler-api_1 | return super(RealDictCursor, self).execute(query, vars) swh-scheduler-api_1 | psycopg2.errors.NotNullViolation: null value in column "retries_left" violates not-null constraint swh-scheduler-api_1 | DETAIL: Failing row contains (1, load-gnu, {"args": ["autogen", "https://ftp.gnu.org/gnu/autogen/"], "kwarg..., 2019-06-06 19:30:45.566495+00, null, next_run_not_scheduled, recurring, null, null). swh-scheduler-api_1 | CONTEXT: SQL statement "insert into task (type, arguments, next_run, status, current_interval, policy, swh-scheduler-api_1 | retries_left, priority) swh-scheduler-api_1 | select type, arguments, next_run, status, current_interval, policy, swh-scheduler-api_1 | retries_left, priority swh-scheduler-api_1 | from tmp_task t swh-scheduler-api_1 | where not exists(select 1 swh-scheduler-api_1 | from task swh-scheduler-api_1 | where type = t.type and swh-scheduler-api_1 | arguments->'args' = t.arguments->'args' and swh-scheduler-api_1 | arguments->'kwargs' = t.arguments->'kwargs' and swh-scheduler-api_1 | policy = t.policy and swh-scheduler-api_1 | priority is not distinct from t.priority and swh-scheduler-api_1 | status = t.status)" swh-scheduler-api_1 | PL/pgSQL function swh_scheduler_create_tasks_from_temp() line 12 at SQL statement swh-scheduler-api_1 | swh-scheduler-api_1 | [2019-06-06 19:38:30 +0000] [411] [DEBUG] POST /create_tasks swh-scheduler-api_1 | ERROR:root:null value in column "retries_left" violates not-null constraint swh-scheduler-api_1 | DETAIL: Failing row contains (2, load-gnu, {"args": ["cppi", "https://ftp.gnu.org/gnu/cppi/"], "kwargs": {"..., 2019-06-06 19:38:29.974493+00, null, next_run_not_scheduled, recurring, null, null). swh-scheduler-api_1 | CONTEXT: SQL statement "insert into task (type, arguments, next_run, status, current_interval, policy, swh-scheduler-api_1 | retries_left, priority) swh-scheduler-api_1 | select type, arguments, next_run, status, current_interval, policy, swh-scheduler-api_1 | retries_left, priority swh-scheduler-api_1 | from tmp_task t swh-scheduler-api_1 | where not exists(select 1 swh-scheduler-api_1 | from task swh-scheduler-api_1 | where type = t.type and swh-scheduler-api_1 | arguments->'args' = t.arguments->'args' and swh-scheduler-api_1 | arguments->'kwargs' = t.arguments->'kwargs' and swh-scheduler-api_1 | policy = t.policy and swh-scheduler-api_1 | priority is not distinct from t.priority and swh-scheduler-api_1 | status = t.status)" swh-scheduler-api_1 | PL/pgSQL function swh_scheduler_create_tasks_from_temp() line 12 at SQL statement swh-scheduler-api_1 | Traceback (most recent call last): swh-scheduler-api_1 | File "/srv/softwareheritage/venv/lib/python3.7/site-packages/flask/app.py", line 1832, in full_dispatch_request swh-scheduler-api_1 | rv = self.dispatch_request() swh-scheduler-api_1 | File "/srv/softwareheritage/venv/lib/python3.7/site-packages/flask/app.py", line 1818, in dispatch_request swh-scheduler-api_1 | return self.view_functions[rule.endpoint](**req.view_args) swh-scheduler-api_1 | File "", line 2, in create_tasks swh-scheduler-api_1 | File "/srv/softwareheritage/venv/lib/python3.7/site-packages/swh/core/api/negotiation.py", line 143, in _negotiate swh-scheduler-api_1 | return f.negotiator(*args, **kwargs) swh-scheduler-api_1 | File "/srv/softwareheritage/venv/lib/python3.7/site-packages/swh/core/api/negotiation.py", line 78, in __call__ swh-scheduler-api_1 | result = self.func(*args, **kwargs) swh-scheduler-api_1 | File "/srv/softwareheritage/venv/lib/python3.7/site-packages/swh/scheduler/api/server.py", line 86, in create_tasks swh-scheduler-api_1 | return get_sched().create_tasks(**decode_request(request)) swh-scheduler-api_1 | File "/srv/softwareheritage/venv/lib/python3.7/site-packages/swh/core/db/common.py", line 49, in _meth swh-scheduler-api_1 | return meth(self, *args, db=db, cur=cur, **kwargs) swh-scheduler-api_1 | File "/srv/softwareheritage/venv/lib/python3.7/site-packages/swh/scheduler/backend.py", line 161, in create_tasks swh-scheduler-api_1 | cur.execute(query) swh-scheduler-api_1 | File "/srv/softwareheritage/venv/lib/python3.7/site-packages/psycopg2/extras.py", line 243, in execute swh-scheduler-api_1 | return super(RealDictCursor, self).execute(query, vars) swh-scheduler-api_1 | psycopg2.errors.NotNullViolation: null value in column "retries_left" violates not-null constraint swh-scheduler-api_1 | DETAIL: Failing row contains (2, load-gnu, {"args": ["cppi", "https://ftp.gnu.org/gnu/cppi/"], "kwargs": {"..., 2019-06-06 19:38:29.974493+00, null, next_run_not_scheduled, recurring, null, null). swh-scheduler-api_1 | CONTEXT: SQL statement "insert into task (type, arguments, next_run, status, current_interval, policy, swh-scheduler-api_1 | retries_left, priority) swh-scheduler-api_1 | select type, arguments, next_run, status, current_interval, policy, swh-scheduler-api_1 | retries_left, priority swh-scheduler-api_1 | from tmp_task t swh-scheduler-api_1 | where not exists(select 1 swh-scheduler-api_1 | from task swh-scheduler-api_1 | where type = t.type and swh-scheduler-api_1 | arguments->'args' = t.arguments->'args' and swh-scheduler-api_1 | arguments->'kwargs' = t.arguments->'kwargs' and swh-scheduler-api_1 | policy = t.policy and swh-scheduler-api_1 | priority is not distinct from t.priority and swh-scheduler-api_1 | status = t.status)" swh-scheduler-api_1 | PL/pgSQL function swh_scheduler_create_tasks_from_temp() line 12 at SQL statement swh-scheduler-api_1 | swh-scheduler-api_1 | [2019-06-06 19:39:13 +0000] [411] [DEBUG] GET / swh-scheduler-api_1 | [2019-06-06 19:39:14 +0000] [411] [DEBUG] GET /favicon.ico swh-scheduler-api_1 | ERROR:root:404 Not Found: The requested URL was not found on the server. If you entered the URL manually please check your spelling and try again. swh-scheduler-api_1 | Traceback (most recent call last): swh-scheduler-api_1 | File "/srv/softwareheritage/venv/lib/python3.7/site-packages/flask/app.py", line 1832, in full_dispatch_request swh-scheduler-api_1 | rv = self.dispatch_request() swh-scheduler-api_1 | File "/srv/softwareheritage/venv/lib/python3.7/site-packages/flask/app.py", line 1810, in dispatch_request swh-scheduler-api_1 | self.raise_routing_exception(req) swh-scheduler-api_1 | File "/srv/softwareheritage/venv/lib/python3.7/site-packages/flask/app.py", line 1793, in raise_routing_exception swh-scheduler-api_1 | raise request.routing_exception swh-scheduler-api_1 | File "/srv/softwareheritage/venv/lib/python3.7/site-packages/flask/ctx.py", line 336, in match_request swh-scheduler-api_1 | self.url_adapter.match(return_rule=True) swh-scheduler-api_1 | File "/srv/softwareheritage/venv/lib/python3.7/site-packages/werkzeug/routing.py", line 1786, in match swh-scheduler-api_1 | raise NotFound() swh-scheduler-api_1 | werkzeug.exceptions.NotFound: 404 Not Found: The requested URL was not found on the server. If you entered the URL manually please check your spelling and try again. swh-scheduler-api_1 | [2019-06-06 19:39:24 +0000] [411] [DEBUG] Closing connection. swh-scheduler-api_1 | [2019-06-06 19:40:09 +0000] [411] [DEBUG] POST /create_tasks swh-scheduler-api_1 | ERROR:root:null value in column "retries_left" violates not-null constraint swh-scheduler-api_1 | DETAIL: Failing row contains (3, load-gnu, {"args": ["libcdio", "https://ftp.gnu.org/gnu/libcdio/"], "kwarg..., 2019-06-06 19:40:08.428313+00, null, next_run_not_scheduled, recurring, null, null). swh-scheduler-api_1 | CONTEXT: SQL statement "insert into task (type, arguments, next_run, status, current_interval, policy, swh-scheduler-api_1 | retries_left, priority) swh-scheduler-api_1 | select type, arguments, next_run, status, current_interval, policy, swh-scheduler-api_1 | retries_left, priority swh-scheduler-api_1 | from tmp_task t swh-scheduler-api_1 | where not exists(select 1 swh-scheduler-api_1 | from task swh-scheduler-api_1 | where type = t.type and swh-scheduler-api_1 | arguments->'args' = t.arguments->'args' and swh-scheduler-api_1 | arguments->'kwargs' = t.arguments->'kwargs' and swh-scheduler-api_1 | policy = t.policy and swh-scheduler-api_1 | priority is not distinct from t.priority and swh-scheduler-api_1 | status = t.status)" swh-scheduler-api_1 | PL/pgSQL function swh_scheduler_create_tasks_from_temp() line 12 at SQL statement swh-scheduler-api_1 | Traceback (most recent call last): swh-scheduler-api_1 | File "/srv/softwareheritage/venv/lib/python3.7/site-packages/flask/app.py", line 1832, in full_dispatch_request swh-scheduler-api_1 | rv = self.dispatch_request() swh-scheduler-api_1 | File "/srv/softwareheritage/venv/lib/python3.7/site-packages/flask/app.py", line 1818, in dispatch_request swh-scheduler-api_1 | return self.view_functions[rule.endpoint](**req.view_args) swh-scheduler-api_1 | File "", line 2, in create_tasks swh-scheduler-api_1 | File "/srv/softwareheritage/venv/lib/python3.7/site-packages/swh/core/api/negotiation.py", line 143, in _negotiate swh-scheduler-api_1 | return f.negotiator(*args, **kwargs) swh-scheduler-api_1 | File "/srv/softwareheritage/venv/lib/python3.7/site-packages/swh/core/api/negotiation.py", line 78, in __call__ swh-scheduler-api_1 | result = self.func(*args, **kwargs) swh-scheduler-api_1 | File "/srv/softwareheritage/venv/lib/python3.7/site-packages/swh/scheduler/api/server.py", line 86, in create_tasks swh-scheduler-api_1 | return get_sched().create_tasks(**decode_request(request)) swh-scheduler-api_1 | File "/srv/softwareheritage/venv/lib/python3.7/site-packages/swh/core/db/common.py", line 49, in _meth swh-scheduler-api_1 | return meth(self, *args, db=db, cur=cur, **kwargs) swh-scheduler-api_1 | File "/srv/softwareheritage/venv/lib/python3.7/site-packages/swh/scheduler/backend.py", line 161, in create_tasks swh-scheduler-api_1 | cur.execute(query) swh-scheduler-api_1 | File "/srv/softwareheritage/venv/lib/python3.7/site-packages/psycopg2/extras.py", line 243, in execute swh-scheduler-api_1 | return super(RealDictCursor, self).execute(query, vars) swh-scheduler-api_1 | psycopg2.errors.NotNullViolation: null value in column "retries_left" violates not-null constraint swh-scheduler-api_1 | DETAIL: Failing row contains (3, load-gnu, {"args": ["libcdio", "https://ftp.gnu.org/gnu/libcdio/"], "kwarg..., 2019-06-06 19:40:08.428313+00, null, next_run_not_scheduled, recurring, null, null). swh-scheduler-api_1 | CONTEXT: SQL statement "insert into task (type, arguments, next_run, status, current_interval, policy, swh-scheduler-api_1 | retries_left, priority) swh-scheduler-api_1 | select type, arguments, next_run, status, current_interval, policy, swh-scheduler-api_1 | retries_left, priority swh-scheduler-api_1 | from tmp_task t swh-scheduler-api_1 | where not exists(select 1 swh-scheduler-api_1 | from task swh-scheduler-api_1 | where type = t.type and swh-scheduler-api_1 | arguments->'args' = t.arguments->'args' and swh-scheduler-api_1 | arguments->'kwargs' = t.arguments->'kwargs' and swh-scheduler-api_1 | policy = t.policy and swh-scheduler-api_1 | priority is not distinct from t.priority and swh-scheduler-api_1 | status = t.status)" swh-scheduler-api_1 | PL/pgSQL function swh_scheduler_create_tasks_from_temp() line 12 at SQL statement swh-scheduler-api_1 | swh-scheduler-api_1 | [2019-06-06 20:01:26 +0000] [411] [DEBUG] Closing connection.