Page MenuHomeSoftware Heritage
Paste P1207

(An Untitled Masterwork)
ActivePublic

Authored by anlambert on Oct 22 2021, 2:59 PM.
(swh) ✔ ~/swh/swh-environment/docker [master|✚ 2⚑ 35]
14:21 $ doco exec swh-scheduler-runner swh scheduler origin grab-next tar 10
lister_id,url,visit_type,extra_loader_arguments,last_update,enabled,first_seen,last_seen
efd50b96-ecb1-47db-bfdf-56f2247769c3,https://cran.r-project.org/package=aaSEA,tar,"{'artifacts': [{'url': 'https://cran.r-project.org/src/contrib/aaSEA_1.1.0.tar.gz', 'version': '1.1.0'}]}",2019-11-09 15:35:46+00:00,True,2021-10-22 12:14:20.515523+00:00,2021-10-22 12:14:20.515523+00:00
efd50b96-ecb1-47db-bfdf-56f2247769c3,https://cran.r-project.org/package=AATtools,tar,"{'artifacts': [{'url': 'https://cran.r-project.org/src/contrib/AATtools_0.0.1.tar.gz', 'version': '0.0.1'}]}",2020-06-09 16:49:30+00:00,True,2021-10-22 12:14:20.515523+00:00,2021-10-22 12:14:20.515523+00:00
efd50b96-ecb1-47db-bfdf-56f2247769c3,https://cran.r-project.org/package=ABACUS,tar,"{'artifacts': [{'url': 'https://cran.r-project.org/src/contrib/ABACUS_1.0.0.tar.gz', 'version': '1.0.0'}]}",2019-09-12 14:16:35+00:00,True,2021-10-22 12:14:20.515523+00:00,2021-10-22 12:14:20.515523+00:00
efd50b96-ecb1-47db-bfdf-56f2247769c3,https://cran.r-project.org/package=abbyyR,tar,"{'artifacts': [{'url': 'https://cran.r-project.org/src/contrib/abbyyR_0.5.5.tar.gz', 'version': '0.5.5'}]}",2019-06-25 01:30:58+00:00,True,2021-10-22 12:14:20.515523+00:00,2021-10-22 12:14:20.515523+00:00
efd50b96-ecb1-47db-bfdf-56f2247769c3,https://cran.r-project.org/package=abc,tar,"{'artifacts': [{'url': 'https://cran.r-project.org/src/contrib/abc_2.1.tar.gz', 'version': '2.1'}]}",2015-05-05 08:35:25+00:00,True,2021-10-22 12:14:20.515523+00:00,2021-10-22 12:14:20.515523+00:00
efd50b96-ecb1-47db-bfdf-56f2247769c3,https://cran.r-project.org/package=abc.data,tar,"{'artifacts': [{'url': 'https://cran.r-project.org/src/contrib/abc.data_1.0.tar.gz', 'version': '1.0'}]}",2015-05-05 09:25:25+00:00,True,2021-10-22 12:14:20.515523+00:00,2021-10-22 12:14:20.515523+00:00
efd50b96-ecb1-47db-bfdf-56f2247769c3,https://cran.r-project.org/package=ABC.RAP,tar,"{'artifacts': [{'url': 'https://cran.r-project.org/src/contrib/ABC.RAP_0.9.0.tar.gz', 'version': '0.9.0'}]}",2016-10-20 01:50:08+00:00,True,2021-10-22 12:14:20.515523+00:00,2021-10-22 12:14:20.515523+00:00
efd50b96-ecb1-47db-bfdf-56f2247769c3,https://cran.r-project.org/package=abcADM,tar,"{'artifacts': [{'url': 'https://cran.r-project.org/src/contrib/abcADM_1.0.tar.gz', 'version': '1.0'}]}",2019-11-08 05:12:43+00:00,True,2021-10-22 12:14:20.515523+00:00,2021-10-22 12:14:20.515523+00:00
efd50b96-ecb1-47db-bfdf-56f2247769c3,https://cran.r-project.org/package=ABCanalysis,tar,"{'artifacts': [{'url': 'https://cran.r-project.org/src/contrib/ABCanalysis_1.2.1.tar.gz', 'version': '1.2.1'}]}",2017-03-13 12:40:55+00:00,True,2021-10-22 12:14:20.515523+00:00,2021-10-22 12:14:20.515523+00:00
efd50b96-ecb1-47db-bfdf-56f2247769c3,https://cran.r-project.org/package=A3,tar,"{'artifacts': [{'url': 'https://cran.r-project.org/src/contrib/A3_1.0.0.tar.gz', 'version': '1.0.0'}]}",2015-08-16 14:17:33+00:00,True,2021-10-22 12:14:20.515523+00:00,2021-10-22 12:14:20.515523+00:00
(swh) ✔ ~/swh/swh-environment/docker [master|✚ 2⚑ 35]
14:21 $ doco exec swh-scheduler-runner swh scheduler origin schedule-next tar 10
Traceback (most recent call last):
File "/srv/softwareheritage/venv/bin/swh", line 8, in <module>
sys.exit(main())
File "/srv/softwareheritage/venv/lib/python3.7/site-packages/swh/core/cli/__init__.py", line 185, in main
return swh(auto_envvar_prefix="SWH")
File "/srv/softwareheritage/venv/lib/python3.7/site-packages/click/core.py", line 829, in __call__
return self.main(*args, **kwargs)
File "/srv/softwareheritage/venv/lib/python3.7/site-packages/click/core.py", line 782, in main
rv = self.invoke(ctx)
File "/srv/softwareheritage/venv/lib/python3.7/site-packages/click/core.py", line 1259, in invoke
return _process_result(sub_ctx.command.invoke(sub_ctx))
File "/srv/softwareheritage/venv/lib/python3.7/site-packages/click/core.py", line 1259, in invoke
return _process_result(sub_ctx.command.invoke(sub_ctx))
File "/srv/softwareheritage/venv/lib/python3.7/site-packages/click/core.py", line 1259, in invoke
return _process_result(sub_ctx.command.invoke(sub_ctx))
File "/srv/softwareheritage/venv/lib/python3.7/site-packages/click/core.py", line 1066, in invoke
return ctx.invoke(self.callback, **ctx.params)
File "/srv/softwareheritage/venv/lib/python3.7/site-packages/click/core.py", line 610, in invoke
return callback(*args, **kwargs)
File "/srv/softwareheritage/venv/lib/python3.7/site-packages/click/decorators.py", line 21, in new_func
return f(get_current_context(), *args, **kwargs)
File "/src/swh-scheduler/swh/scheduler/cli/origin.py", line 137, in schedule_next
for origin in origins
File "/srv/softwareheritage/venv/lib/python3.7/site-packages/swh/core/db/common.py", line 62, in _meth
return meth(self, *args, db=db, cur=cur, **kwargs)
File "/src/swh-scheduler/swh/scheduler/backend.py", line 569, in create_tasks
cur.execute(query)
File "/srv/softwareheritage/venv/lib/python3.7/site-packages/psycopg2/extras.py", line 251, in execute
return super(RealDictCursor, self).execute(query, vars)
psycopg2.errors.ForeignKeyViolation: insert or update on table "task" violates foreign key constraint "task_type_fkey"
DETAIL: Key (type)=(load-tar) is not present in table "task_type".
CONTEXT: SQL statement "insert into task (type, arguments, next_run, status, current_interval, policy,
retries_left, priority)
select type, arguments, next_run, status, current_interval, policy,
retries_left, priority
from tmp_task t
where not exists(select 1
from task
where type = t.type and
md5(arguments::text) = md5(t.arguments::text) and
arguments = t.arguments and
policy = t.policy and
priority is not distinct from t.priority and
status = t.status)"
PL/pgSQL function swh_scheduler_create_tasks_from_temp() line 12 at SQL statement