Code Monkey home page Code Monkey logo

contributed-project-templates's Introduction

Contributed Renku project templates

This repository holds a collection of renkulab project templates developed and contributed by members of the renku community. They typically implement some specific functionality or interface that is beyond what should be included in a default base template, but is interesting for a wider audience.

Contributing

Do you find yourself often making the same changes to the configuration of your renku projects? Do you always need to install a base collection of packages specific to your domain? You may have a good candidate for a template! Feel free to create a template and submit a PR to this repository or open an issue with an idea if you're not quite sure how to do it yourself! We can have a look at your requirements together and figure out how to extract them into a template that can be used by others.

How to add a new template

If you want to contribute a new template, you should take a look at the existing templates and think about what you want your project template to facilitate. Have a look at the template documentation to see how the template should be structured and what kind of special information might be needed (e.g. in the manifest.yaml file).

contributed-project-templates's People

Contributors

champost avatar dependabot[bot] avatar gavin-k-lee avatar geigerj2 avatar liligasser avatar ltalirz avatar pameladelgado avatar panaetius avatar richardjacton avatar rokroskar avatar

Stargazers

 avatar  avatar  avatar  avatar

Watchers

 avatar  avatar  avatar  avatar  avatar

contributed-project-templates's Issues

Renv template does not build a docker image successfully

Step 7/15 : RUN bash .renv_install.sh
 ---> Running in 181ef48e0461
Installing renv
renv.lock file detected
Installing package into ‘/usr/local/lib/R/site-library’
(as ‘lib’ is unspecified)
trying URL 'https://cran.r-project.org/src/contrib/00Archive/renv/renv_0.15.5.tar.gz'
Error in download.file(p, destfile, method, mode = "wb", ...) : 
  cannot open URL 'https://cran.r-project.org/src/contrib/00Archive/renv/renv_0.15.5.tar.gz'
In addition: Warning message:
In download.file(p, destfile, method, mode = "wb", ...) :
  URL 'https://cran.r-project.org/src/contrib/00Archive/renv/renv_0.15.5.tar.gz': status was 'Couldn't resolve host name'
installed renv v0.15.5
Removing intermediate container 181ef48e0461
 ---> a22dc1e7adfe
Step 8/15 : COPY renv.lock /home/rstudio/renv.lock
 ---> f6a734ffc9b9
Step 9/15 : COPY install.R /tmp/
 ---> [385](https://gitlab.dev.renku.ch/tasko.olevski/test-project-30/-/jobs/365489#L385)2af64fa03
Step 10/15 : RUN R -f /tmp/install.R
 ---> Running in dbc974a7b173
R version 4.2.0 (2022-04-22) -- "Vigorous Calisthenics"
Copyright (C) 2022 The R Foundation for Statistical Computing
Platform: x86_64-pc-linux-gnu (64-bit)
R is free software and comes with ABSOLUTELY NO WARRANTY.
You are welcome to redistribute it under certain conditions.
Type 'license()' or 'licence()' for distribution details.
  Natural language support but running in an English locale
R is a collaborative project with many contributors.
Type 'contributors()' for more information and
'citation()' on how to cite R or R packages in publications.
Type 'demo()' for some demos, 'help()' for on-line help, or
'help.start()' for an HTML browser interface to help.
Type 'q()' to quit R.
> # The renv library will be located on the docker image, in the /home/rstudio directory,
> # yet it will use the renv.lock file located in the project's main directory to determine which dependencies to install.
> setwd('/home/rstudio')
> options(renv.consent = TRUE)
> write("options(renv.consent = TRUE)", file="/home/rstudio/.Rprofile", append = TRUE)
> renv::init(force = TRUE)
Error in loadNamespace(x) : there is no package called ‘renv’
Calls: loadNamespace -> withRestarts -> withOneRestart -> doWithOneRestart
Execution halted
The command '/bin/bash -c -o pipefail R -f /tmp/install.R' returned a non-zero code: 1
Cleaning up project directory and file based variables
00:01
ERROR: Job failed: exit code 1

Template version

When using the templates to create a new project on renkulab, the system still uses the version 0.6 of the contributed templates (at least for the desktop one that I tested). The main issue with that is that 0.6 still uses conda for environments while 0.7 uses mamba. As conda has become almost unusable these days, this makes builds fail at the stage of environment solving and for people not very familiar with conda this might be difficult to debug. Could renkulab use the most recent version of the contributed projects?

Create a qGIS template

With the new VNC-enabled images, it would be great to enable qGIS running inside hosted renku sessions.

`verdi archive import` fails for `sqlite_dos` backend on `conda`-based AiiDA installation

Alright, not sure yet where this originates from, but I just realized that importing an archive into the sqlite_dos backend actually fails for a conda-based installation in the AiiDA template. The issue first occured for an archive that had to be migrated on the fly, but the error persists when migrating the archive before.

When creating a python venv and installing AiiDA instead, the issue doesn't occur. In general, I'm becoming quite inclined to change the template to use venv rather than conda anyway. PostgreSQL doesn't work currently either way, so we are using SQLite. As the idea is to explore existing archives from Materials Cloud Archive, rather than running workflows, RabbitMQ is not required either, so there's no reason to use conda instead of venv. As soon as AiiDA v2.6 is released, I'll update the template, using the service-less new verdi presto profile setup command, and with it make sure that this issue here is resolved.

Below are the two tracebacks attached for future reference:

Re-raising here gives:

verdi archive import 'https://archive.materialscloud.org/record/file?filename=acwf-verification_unaries-verification-PBE-v1_results_gpaw.aiida&file_id=b82dadcf-9d5e-4ef8-8a74-3af8711ab1d2&record_id=1770'
Report: downloading archive: https://archive.materialscloud.org/record/file?filename=acwf-verification_unaries-verification-PBE-v1_results_gpaw.aiida&file_id=b82dadcf-9d5e-4ef8-8a74-3af8711ab1d2&record_id=1770
Success: archive downloaded, proceeding with import
Report: starting import: https://archive.materialscloud.org/record/file?filename=acwf-verification_unaries-verification-PBE-v1_results_gpaw.aiida&file_id=b82dadcf-9d5e-4ef8-8a74-3af8711ab1d2&record_id=1770
Report: incompatible version detected for https://archive.materialscloud.org/record/file?filename=acwf-verification_unaries-verification-PBE-v1_results_gpaw.aiida&file_id=b82dadcf-9d5e-4ef8-8a74-3af8711ab1d2&record_id=1770, trying migration
Report: Legacy migrations required from zip format
Report: Extracting data.json ...
Report: Legacy migration pathway: 0.10 -> 0.11 -> 0.12 -> 0.13
Report: legacy '0.13' -> 'main_0000' conversion required                                                                                                                                
Report: Initialising new archive...
Report: Unique repository files written: 13512                                                                                                                                          
Report: Converting DB to SQLite
Report: Performing SQLite migrations:                                                                                                                                                   
Report: - main_0000 -> main_0000a
Report: - main_0000a -> main_0000b
Report: - main_0000b -> main_0001
Report: Finalising the migration ...
Report: proceeding with import of migrated archive
Report: Parameters
-------------------------------  ----------------------
Archive                          migrated_archive.aiida
New Node Extras                  keep
Merge Node Extras (in database)  (k)eep
Merge Node Extras (in archive)   do (n)ot create
Merge Node Extras (in both)      (l)eave existing
Merge Comments                   leave
Computer Authinfos               exclude

Report: Adding 2 new user(s)
Traceback (most recent call last):                                                                                                                                                      
  File "/home/jovyan/work/materials-cloud-archive-aiida-common-workflows-aiida/notebooks/aiida-core/src/aiida/cmdline/commands/cmd_archive.py", line 504, in _import_archive_and_migrate
    _import_archive(archive_path, archive_format=archive_format, **import_kwargs)
  File "/home/jovyan/work/materials-cloud-archive-aiida-common-workflows-aiida/notebooks/aiida-core/src/aiida/tools/archive/imports.py", line 136, in import_archive
    raise IncompatibleStorageSchema(
aiida.common.exceptions.IncompatibleStorageSchema: The archive version '0.10' is not the latest version 'main_0001'

During handling of the above exception, another exception occurred:

Traceback (most recent call last):
  File "/opt/conda/bin/verdi", line 8, in <module>
    sys.exit(verdi())
  File "/opt/conda/lib/python3.10/site-packages/click/core.py", line 1157, in __call__
    return self.main(*args, **kwargs)
  File "/opt/conda/lib/python3.10/site-packages/click/core.py", line 1078, in main
    rv = self.invoke(ctx)
  File "/opt/conda/lib/python3.10/site-packages/click/core.py", line 1688, in invoke
    return _process_result(sub_ctx.command.invoke(sub_ctx))
  File "/opt/conda/lib/python3.10/site-packages/click/core.py", line 1688, in invoke
    return _process_result(sub_ctx.command.invoke(sub_ctx))
  File "/home/jovyan/work/materials-cloud-archive-aiida-common-workflows-aiida/notebooks/aiida-core/src/aiida/cmdline/groups/verdi.py", line 117, in invoke
    return ctx.invoke(self.callback, **ctx.params)
  File "/opt/conda/lib/python3.10/site-packages/click/core.py", line 783, in invoke
    return __callback(*args, **kwargs)
  File "/home/jovyan/work/materials-cloud-archive-aiida-common-workflows-aiida/notebooks/aiida-core/src/aiida/cmdline/utils/decorators.py", line 102, in wrapper
    return wrapped(*args, **kwargs)
  File "/opt/conda/lib/python3.10/site-packages/click/decorators.py", line 33, in new_func
    return f(get_current_context(), *args, **kwargs)
  File "/home/jovyan/work/materials-cloud-archive-aiida-common-workflows-aiida/notebooks/aiida-core/src/aiida/cmdline/commands/cmd_archive.py", line 411, in import_archive
    _import_archive_and_migrate(ctx, archive, web_based, import_kwargs, migration)
  File "/home/jovyan/work/materials-cloud-archive-aiida-common-workflows-aiida/notebooks/aiida-core/src/aiida/cmdline/commands/cmdTracebacks for future reference:_archive.py", line 517, in _import_archive_and_migrate
    _import_archive(archive_path, archive_format=archive_format, **import_kwargs)
  File "/home/jovyan/work/materials-cloud-archive-aiida-common-workflows-aiida/notebooks/aiida-core/src/aiida/tools/archive/imports.py", line 168, in import_archive
    user_ids_archive_backend = _import_users(backend_from, backend, query_params)
  File "/home/jovyan/work/materials-cloud-archive-aiida-common-workflows-aiida/notebooks/aiida-core/src/aiida/tools/archive/imports.py", line 281, in _import_users
    _add_new_entities(
  File "/home/jovyan/work/materials-cloud-archive-aiida-common-workflows-aiida/notebooks/aiida-core/src/aiida/tools/archive/imports.py", line 246, in _add_new_entities
    new_ids = backend_to.bulk_insert(etype, rows)
  File "/home/jovyan/work/materials-cloud-archive-aiida-common-workflows-aiida/notebooks/aiida-core/src/aiida/storage/psql_dos/backend.py", line 337, in bulk_insert
    result = session.execute(insert(mapper).returning(mapper, column('id')), rows).fetchall()
  File "/opt/conda/lib/python3.10/site-packages/sqlalchemy/orm/session.py", line 2232, in execute
    return self._execute_internal(
  File "/opt/conda/lib/python3.10/site-packages/sqlalchemy/orm/session.py", line 2127, in _execute_internal
    result: Result[Any] = compile_state_cls.orm_execute_statement(
  File "/opt/conda/lib/python3.10/site-packages/sqlalchemy/orm/bulk_persistence.py", line 1268, in orm_execute_statement
    result = _bulk_insert(verdi archive import 'https://archive.materialscloud.org/record/file?filename=acwf-verification_unaries-verification-PBE-v1_results_gpaw.aiida&file_id=b82dadcf-9d5e-4ef8-8a74-3af8711ab1d2&record_id=1770'
Report: downloading archive: https://archive.materialscloud.org/record/file?filename=acwf-verification_unaries-verification-PBE-v1_results_gpaw.aiida&file_id=b82dadcf-9d5e-4ef8-8a74-3af8711ab1d2&record_id=1770
Success: archive downloaded, proceeding with import
Report: starting import: https://archive.materialscloud.org/record/file?filename=acwf-verification_unaries-verification-PBE-v1_results_gpaw.aiida&file_id=b82dadcf-9d5e-4ef8-8a74-3af8711ab1d2&record_id=1770
Report: incompatible version detected for https://archive.materialscloud.org/record/file?filename=acwf-verification_unaries-verification-PBE-v1_results_gpaw.aiida&file_id=b82dadcf-9d5e-4ef8-8a74-3af8711ab1d2&record_id=1770, trying migration
Report: Legacy migrations required from zip format
Report: Extracting data.json ...
Report: Legacy migration pathway: 0.10 -> 0.11 -> 0.12 -> 0.13
Report: legacy '0.13' -> 'main_0000' conversion required                                                                                                                                
Report: Initialising new archive...
Report: Unique repository files written: 13512                                                                                                                                          
Report: Converting DB to SQLite
Report: Performing SQLite migrations:                                                                                                                                                   
Report: - main_0000 -> main_0000a
Report: - main_0000a -> main_0000b
Report: - main_0000b -> main_0001
Report: Finalising the migration ...
Report: proceeding with import of migrated archive
Report: Parameters
-------------------------------  ----------------------
Archive                          migrated_archive.aiida
New Node Extras                  keep
Merge Node Extras (in database)  (k)eep
Merge Node Extras (in archive)   do (n)ot create
Merge Node Extras (in both)      (l)eave existing
Merge Comments                   leave
Computer Authinfos               exclude

Report: Adding 2 new user(s)
Traceback (most recent call last):                                                                                                                                                      
  File "/home/jovyan/work/materials-cloud-archive-aiida-common-workflows-aiida/notebooks/aiida-core/src/aiida/cmdline/commands/cmd_archive.py", line 504, in _import_archive_and_migrate
    _import_archive(archive_path, archive_format=archive_format, **import_kwargs)
  File "/home/jovyan/work/materials-cloud-archive-aiida-common-workflows-aiida/notebooks/aiida-core/src/aiida/tools/archive/imports.py", line 136, in import_archive
    raise IncompatibleStorageSchema(
aiida.common.exceptions.IncompatibleStorageSchema: The archive version '0.10' is not the latest version 'main_0001'

During handling of the above exception, another exception occurred:

Traceback (most recent call last):
  File "/opt/conda/bin/verdi", line 8, in <module>
    sys.exit(verdi())
  File "/opt/conda/lib/python3.10/site-packages/click/core.py", line 1157, in __call__
    return self.main(*args, **kwargs)
  File "/opt/conda/lib/python3.10/site-packages/click/core.py", line 1078, in main
    rv = self.invoke(ctx)
  File "/opt/conda/lib/python3.10/site-packages/click/core.py", line 1688, in invoke
    return _process_result(sub_ctx.command.invoke(sub_ctx))
  File "/opt/conda/lib/python3.10/site-packages/click/core.py", line 1688, in invoke
    return _process_result(sub_ctx.command.invoke(sub_ctx))
  File "/home/jovyan/work/materials-cloud-archive-aiida-common-workflows-aiida/notebooks/aiida-core/src/aiida/cmdline/groups/verdi.py", line 117, in invoke
    return ctx.invoke(self.callback, **ctx.params)
  File "/opt/conda/lib/python3.10/site-packages/click/core.py", line 783, in invoke
    return __callback(*args, **kwargs)
  File "/home/jovyan/work/materials-cloud-archive-aiida-common-workflows-aiida/notebooks/aiida-core/src/aiida/cmdline/utils/decorators.py", line 102, in wrapper
    return wrapped(*args, **kwargs)
  File "/opt/conda/lib/python3.10/site-packages/click/decorators.py", line 33, in new_func
    return f(get_current_context(), *args, **kwargs)
  File "/home/jovyan/work/materials-cloud-archive-aiida-common-workflows-aiida/notebooks/aiida-core/src/aiida/cmdline/commands/cmd_archive.py", line 411, in import_archive
    _import_archive_and_migrate(ctx, archive, web_based, import_kwargs, migration)
  File "/home/jovyan/work/materials-cloud-archive-aiida-common-workflows-aiida/notebooks/aiida-core/src/aiida/cmdline/commands/cmd_archive.py", line 517, in _import_archive_and_migrate
    _import_archive(archive_path, archive_format=archive_format, **import_kwargs)
  File "/home/jovyan/work/materials-cloud-archive-aiida-common-workflows-aiida/notebooks/aiida-core/src/aiida/tools/archive/imports.py", line 168, in import_archive
    user_ids_archive_backend = _import_users(backend_from, backend, query_params)
  File "/home/jovyan/work/materials-cloud-archive-aiida-common-workflows-aiida/notebooks/aiida-core/src/aiida/tools/archive/imports.py", line 281, in _import_users
    _add_new_entities(
  File "/home/jovyan/work/materials-cloud-archive-aiida-common-workflows-aiida/notebooks/aiida-core/src/aiida/tools/archive/imports.py", line 246, in _add_new_entities
    new_ids = backend_to.bulk_insert(etype, rows)
  File "/home/jovyan/work/materials-cloud-archive-aiida-common-workflows-aiida/notebooks/aiida-core/src/aiida/storage/psql_dos/backend.py", line 337, in bulk_insert
    result = session.execute(insert(mapper).returning(mapper, column('id')), rows).fetchall()
  File "/opt/conda/lib/python3.10/site-packages/sqlalchemy/orm/session.py", line 2232, in execute
    return self._execute_internal(
  File "/opt/conda/lib/python3.10/site-packages/sqlalchemy/orm/session.py", line 2127, in _execute_internal
    result: Result[Any] = compile_state_cls.orm_execute_statement(
  File "/opt/conda/lib/python3.10/site-packages/sqlalchemy/orm/bulk_persistence.py", line 1268, in orm_execute_statement
    result = _bulk_insert(
  File "/opt/conda/lib/python3.10/site-packages/sqlalchemy/orm/bulk_persistence.py", line 200, in _bulk_insert
    result = persistence._emit_insert_statements(
  File "/opt/conda/lib/python3.10/site-packages/sqlalchemy/orm/persistence.py", line 1133, in _emit_insert_statements
    result = connection.execute(
  File "/opt/conda/lib/python3.10/site-packages/sqlalchemy/engine/base.py", line 1413, in execute
    return meth(
  File "/opt/conda/lib/python3.10/site-packages/sqlalchemy/sql/elements.py", line 483, in _execute_on_connection
    return connection._execute_clauseelement(
  File "/opt/conda/lib/python3.10/site-packages/sqlalchemy/engine/base.py", line 1629, in _execute_clauseelement
    compiled_sql, extracted_params, cache_hit = elem._compile_w_cache(
  File "/opt/conda/lib/python3.10/site-packages/sqlalchemy/sql/elements.py", line 671, in _compile_w_cache
    compiled_sql = self._compiler(
  File "/opt/conda/lib/python3.10/site-packages/sqlalchemy/sql/elements.py", line 288, in _compiler
    return dialect.statement_compiler(dialect, self, **kw)
  File "/opt/conda/lib/python3.10/site-packages/sqlalchemy/sql/compiler.py", line 1426, in __init__
    Compiled.__init__(self, dialect, statement, **kwargs)
  File "/opt/conda/lib/python3.10/site-packages/sqlalchemy/sql/compiler.py", line 867, in __init__
    self.string = self.process(self.statement, **compile_kwargs)
  File "/opt/conda/lib/python3.10/site-packages/sqlalchemy/sql/compiler.py", line 912, in process
    return obj._compiler_dispatch(self, **kwargs)
  File "/opt/conda/lib/python3.10/site-packages/sqlalchemy/sql/annotation.py", line 351, in _compiler_dispatch
    return self.__element.__class__._compiler_dispatch(
  File "/opt/conda/lib/python3.10/site-packages/sqlalchemy/sql/visitors.py", line 143, in _compiler_dispatch
    return meth(self, **kw)  # type: ignore  # noqa: E501
  File "/opt/conda/lib/python3.10/site-packages/sqlalchemy/sql/compiler.py", line 5603, in visit_insert
    compile_state = insert_stmt._compile_state_factory(
  File "/opt/conda/lib/python3.10/site-packages/sqlalchemy/sql/base.py", line 678, in create_for_statement
    return klass.create_for_statement(statement, compiler, **kw)
  File "/opt/conda/lib/python3.10/site-packages/sqlalchemy/orm/bulk_persistence.py", line 1327, in create_for_statement
    self._setup_for_bulk_insert(compiler)
  File "/opt/conda/lib/python3.10/site-packages/sqlalchemy/orm/bulk_persistence.py", line 1380, in _setup_for_bulk_insert
    statement = self._setup_orm_returning(
  File "/opt/conda/lib/python3.10/site-packages/sqlalchemy/orm/bulk_persistence.py", line 536, in _setup_orm_returning
    fsc.setup_dml_returning_compile_state(dml_mapper)
  File "/opt/conda/lib/python3.10/site-packages/sqlalchemy/orm/context.py", line 846, in setup_dml_returning_compile_state
    entity.setup_dml_returning_compile_state(self, adapter)
  File "/opt/conda/lib/python3.10/site-packages/sqlalchemy/orm/context.py", line 2501, in setup_dml_returning_compile_state
    raise NotImplementedError()
NotImplementedError
  File "/opt/conda/lib/python3.10/site-packages/sqlalchemy/orm/bulk_persistence.py", line 200, in _bulk_insert
    result = persistence._emit_insert_statements(
  File "/opt/conda/lib/python3.10/site-packages/sqlalchemy/orm/persistence.py", line 1133, in _emit_insert_statements
    result = connection.execute(
  File "/opt/conda/lib/python3.10/site-packages/sqlalchemy/engine/base.py", line 1413, in execute
    return meth(
  File "/opt/conda/lib/python3.10/site-packages/sqlalchemy/sql/elements.py", line 483, in _execute_on_connection
    return connection._execute_clauseelement(
  File "/opt/conda/lib/python3.10/site-packages/sqlalchemy/engine/base.py", line 1629, in _execute_clauseelement
    compiled_sql, extracted_params, cache_hit = elem._compile_w_cache(
  File "/opt/conda/lib/python3.10/site-packages/sqlalchemy/sql/elements.py", line 671, in _compile_w_cache
    compiled_sql = self._compiler(
  File "/opt/conda/lib/python3.10/site-packages/sqlalchemy/sql/elements.py", line 288, in _compiler
    return dialect.statement_compiler(dialect, self, **kw)
  File "/opt/conda/lib/python3.10/site-packages/sqlalchemy/sql/compiler.py", line 1426, in __init__
    Compiled.__init__(self, dialect, statement, **kwargs)
  File "/opt/conda/lib/python3.10/site-packages/sqlalchemy/sql/compiler.py", line 867, in __init__
    self.string = self.process(self.statement, **compile_kwargs)
  File "/opt/conda/lib/python3.10/site-packages/sqlalchemy/sql/compiler.py", line 912, in process
    return obj._compiler_dispatch(self, **kwargs)
  File "/opt/conda/lib/python3.10/site-packages/sqlalchemy/sql/annotation.py", line 351, in _compiler_dispatch
    return self.__element.__class__._compiler_dispatch(
  File "/opt/conda/lib/python3.10/site-packages/sqlalchemy/sql/visitors.py", line 143, in _compiler_dispatch
    return meth(self, **kw)  # type: ignore  # noqa: E501
  File "/opt/conda/lib/python3.10/site-packages/sqlalchemy/sql/compiler.py", line 5603, in visit_insert
    compile_state = insert_stmt._compile_state_factory(
  File "/opt/conda/lib/python3.10/site-packages/sqlalchemy/sql/base.py", line 678, in create_for_statement
    return klass.create_for_statement(statement, compiler, **kw)
  File "/opt/conda/lib/python3.10/site-packages/sqlalchemy/orm/bulk_persistence.py", line 1327, in create_for_statement
    self._setup_for_bulk_insert(compiler)
  File "/opt/conda/lib/python3.10/site-packages/sqlalchemy/orm/bulk_persistence.py", line 1380, in _setup_for_bulk_insert
    statement = self._setup_orm_returning(
  File "/opt/conda/lib/python3.10/site-packages/sqlalchemy/orm/bulk_persistence.py", line 536, in _setup_orm_returning
    fsc.setup_dml_returning_compile_state(dml_mapper)
  File "/opt/conda/lib/python3.10/site-packages/sqlalchemy/orm/context.py", line 846, in setup_dml_returning_compile_state
    entity.setup_dml_returning_compile_state(self, adapter)
  File "/opt/conda/lib/python3.10/site-packages/sqlalchemy/orm/context.py", line 2501, in setup_dml_returning_compile_state
    raise NotImplementedError()
NotImplementedError

While migrating the archive before and then trying to import, re-raising here gives:

verdi archive import acwf-gpaw-migrated.aiida 
Report: starting import: acwf-gpaw-migrated.aiida
Report: Parameters
-------------------------------  ------------------------
Archive                          acwf-gpaw-migrated.aiida
New Node Extras                  keep
Merge Node Extras (in database)  (k)eep
Merge Node Extras (in archive)   do (n)ot create
Merge Node Extras (in both)      (l)eave existing
Merge Comments                   leave
Computer Authinfos               exclude

Report: Adding 2 new user(s)
Traceback (most recent call last):                                                                                                                                                      
  File "/opt/conda/bin/verdi", line 8, in <module>
    sys.exit(verdi())
  File "/opt/conda/lib/python3.10/site-packages/click/core.py", line 1157, in __call__
    return self.main(*args, **kwargs)
  File "/opt/conda/lib/python3.10/site-packages/click/core.py", line 1078, in main
    rv = self.invoke(ctx)
  File "/opt/conda/lib/python3.10/site-packages/click/core.py", line 1688, in invoke
    return _process_result(sub_ctx.command.invoke(sub_ctx))
  File "/opt/conda/lib/python3.10/site-packages/click/core.py", line 1688, in invoke
    return _process_result(sub_ctx.command.invoke(sub_ctx))
  File "/home/jovyan/work/materials-cloud-archive-aiida-common-workflows-aiida/notebooks/aiida-core/src/aiida/cmdline/groups/verdi.py", line 117, in invoke
    return ctx.invoke(self.callback, **ctx.params)
  File "/opt/conda/lib/python3.10/site-packages/click/core.py", line 783, in invoke
    return __callback(*args, **kwargs)
  File "/home/jovyan/work/materials-cloud-archive-aiida-common-workflows-aiida/notebooks/aiida-core/src/aiida/cmdline/utils/decorators.py", line 102, in wrapper
    return wrapped(*args, **kwargs)
  File "/opt/conda/lib/python3.10/site-packages/click/decorators.py", line 33, in new_func
    return f(get_current_context(), *args, **kwargs)
  File "/home/jovyan/work/materials-cloud-archive-aiida-common-workflows-aiida/notebooks/aiida-core/src/aiida/cmdline/commands/cmd_archive.py", line 411, in import_archive
    _import_archive_and_migrate(ctx, archive, web_based, import_kwargs, migration)
  File "/home/jovyan/work/materials-cloud-archive-aiida-common-workflows-aiida/notebooks/aiida-core/src/aiida/cmdline/commands/cmd_archive.py", line 504, in _import_archive_and_migrate
    _import_archive(archive_path, archive_format=archive_format, **import_kwargs)
  File "/home/jovyan/work/materials-cloud-archive-aiida-common-workflows-aiida/notebooks/aiida-core/src/aiida/tools/archive/imports.py", line 168, in import_archive
    user_ids_archive_backend = _import_users(backend_from, backend, query_params)
  File "/home/jovyan/work/materials-cloud-archive-aiida-common-workflows-aiida/notebooks/aiida-core/src/aiida/tools/archive/imports.py", line 281, in _import_users
    _add_new_entities(
  File "/home/jovyan/work/materials-cloud-archive-aiida-common-workflows-aiida/notebooks/aiida-core/src/aiida/tools/archive/imports.py", line 246, in _add_new_entities
    new_ids = backend_to.bulk_insert(etype, rows)
  File "/home/jovyan/work/materials-cloud-archive-aiida-common-workflows-aiida/notebooks/aiida-core/src/aiida/storage/psql_dos/backend.py", line 337, in bulk_insert
    result = session.execute(insert(mapper).returning(mapper, column('id')), rows).fetchall()
  File "/opt/conda/lib/python3.10/site-packages/sqlalchemy/orm/session.py", line 2232, in execute
    return self._execute_internal(
  File "/opt/conda/lib/python3.10/site-packages/sqlalchemy/orm/session.py", line 2127, in _execute_internal
    result: Result[Any] = compile_state_cls.orm_execute_statement(
  File "/opt/conda/lib/python3.10/site-packages/sqlalchemy/orm/bulk_persistence.py", line 1268, in orm_execute_statement
    result = _bulk_insert(
  File "/opt/conda/lib/python3.10/site-packages/sqlalchemy/orm/bulk_persistence.py", line 200, in _bulk_insert
    result = persistence._emit_insert_statements(
  File "/opt/conda/lib/python3.10/site-packages/sqlalchemy/orm/persistence.py", line 1133, in _emit_insert_statements
    result = connection.execute(
  File "/opt/conda/lib/python3.10/site-packages/sqlalchemy/engine/base.py", line 1413, in execute
    return meth(
  File "/opt/conda/lib/python3.10/site-packages/sqlalchemy/sql/elements.py", line 483, in _execute_on_connection
    return connection._execute_clauseelement(
  File "/opt/conda/lib/python3.10/site-packages/sqlalchemy/engine/base.py", line 1629, in _execute_clauseelement
    compiled_sql, extracted_params, cache_hit = elem._compile_w_cache(
  File "/opt/conda/lib/python3.10/site-packages/sqlalchemy/sql/elements.py", line 671, in _compile_w_cache
    compiled_sql = self._compiler(
  File "/opt/conda/lib/python3.10/site-packages/sqlalchemy/sql/elements.py", line 288, in _compiler
    return dialect.statement_compiler(dialect, self, **kw)
  File "/opt/conda/lib/python3.10/site-packages/sqlalchemy/sql/compiler.py", line 1426, in __init__
    Compiled.__init__(self, dialect, statement, **kwargs)
  File "/opt/conda/lib/python3.10/site-packages/sqlalchemy/sql/compiler.py", line 867, in __init__
    self.string = self.process(self.statement, **compile_kwargs)
  File "/opt/conda/lib/python3.10/site-packages/sqlalchemy/sql/compiler.py", line 912, in process
    return obj._compiler_dispatch(self, **kwargs)
  File "/opt/conda/lib/python3.10/site-packages/sqlalchemy/sql/annotation.py", line 351, in _compiler_dispatch
    return self.__element.__class__._compiler_dispatch(
  File "/opt/conda/lib/python3.10/site-packages/sqlalchemy/sql/visitors.py", line 143, in _compiler_dispatch
    return meth(self, **kw)  # type: ignore  # noqa: E501
  File "/opt/conda/lib/python3.10/site-packages/sqlalchemy/sql/compiler.py", line 5603, in visit_insert
    compile_state = insert_stmt._compile_state_factory(
  File "/opt/conda/lib/python3.10/site-packages/sqlalchemy/sql/base.py", line 678, in create_for_statement
    return klass.create_for_statement(statement, compiler, **kw)
  File "/opt/conda/lib/python3.10/site-packages/sqlalchemy/orm/bulk_persistence.py", line 1327, in create_for_statement
    self._setup_for_bulk_insert(compiler)
  File "/opt/conda/lib/python3.10/site-packages/sqlalchemy/orm/bulk_persistence.py", line 1380, in _setup_for_bulk_insert
    statement = self._setup_orm_returning(
  File "/opt/conda/lib/python3.10/site-packages/sqlalchemy/orm/bulk_persistence.py", line 536, in _setup_orm_returning
    fsc.setup_dml_returning_compile_state(dml_mapper)
  File "/opt/conda/lib/python3.10/site-packages/sqlalchemy/orm/context.py", line 846, in setup_dml_returning_compile_state
    entity.setup_dml_returning_compile_state(self, adapter)
  File "/opt/conda/lib/python3.10/site-packages/sqlalchemy/orm/context.py", line 2501, in setup_dml_returning_compile_state
    raise NotImplementedError()
NotImplementedError

Recommend Projects

  • React photo React

    A declarative, efficient, and flexible JavaScript library for building user interfaces.

  • Vue.js photo Vue.js

    🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.

  • Typescript photo Typescript

    TypeScript is a superset of JavaScript that compiles to clean JavaScript output.

  • TensorFlow photo TensorFlow

    An Open Source Machine Learning Framework for Everyone

  • Django photo Django

    The Web framework for perfectionists with deadlines.

  • D3 photo D3

    Bring data to life with SVG, Canvas and HTML. 📊📈🎉

Recommend Topics

  • javascript

    JavaScript (JS) is a lightweight interpreted programming language with first-class functions.

  • web

    Some thing interesting about web. New door for the world.

  • server

    A server is a program made to process requests and deliver data to clients.

  • Machine learning

    Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.

  • Game

    Some thing interesting about game, make everyone happy.

Recommend Org

  • Facebook photo Facebook

    We are working to build community through open source technology. NB: members must have two-factor auth.

  • Microsoft photo Microsoft

    Open source projects and samples from Microsoft.

  • Google photo Google

    Google ❤️ Open Source for everyone.

  • D3 photo D3

    Data-Driven Documents codes.