Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Error in the installation of plugin harvest ckan #527

Open
eya1 opened this issue Apr 8, 2023 · 1 comment
Open

Error in the installation of plugin harvest ckan #527

eya1 opened this issue Apr 8, 2023 · 1 comment

Comments

@eya1
Copy link

eya1 commented Apr 8, 2023

Hello,
I want to install harvest in my c kan and I have followed all the steps of the instaltion but when I run this line , Iget this error

(default) root@lpfc2004:/usr/lib/ckan/default/src/ckanext-harvest# ckan --config=/etc/ckan/default/ckan.ini harvester initdb

2023-04-08 11:25:45,093 INFO  [ckan.cli] Using configuration file /etc/ckan/default/ckan.ini
2023-04-08 11:25:45,094 INFO  [ckan.config.environment] Loading static files from public 
2023-04-08 11:25:45,137 INFO  [ckan.config.environment] Loading templates from /usr/lib/ckan/default/src/ckan/ckan/templates 
2023-04-08 11:25:45,421 INFO  [ckan.config.environment] Loading templates from /usr/lib/ckan/default/src/ckan/ckan/templates 
2023-04-08 11:25:45,432 DEBUG [ckanext.harvest.model] Harvest tables defined in memory 
2023-04-08 11:25:45,443 DEBUG [ckanext.harvest.model] Harvest tables already exist 

Traceback (most recent call last):   File "/usr/lib/ckan/default/bin/ckan", line 11, in <module>
load_entry_point('ckan', 'console_scripts', 'ckan')()   File "/usr/lib/ckan/default/lib/python3.8/site-packages/click/core.py", line 829, in __call__
return self.main(*args, **kwargs)   File "/usr/lib/ckan/default/lib/python3.8/site-packages/click/core.py", line 781, in main
with self.make_context(prog_name, args, **extra) as ctx:   File "/usr/lib/ckan/default/lib/python3.8/site-packages/click/core.py", line 700, in make_context
self.parse_args(ctx, args)   File "/usr/lib/ckan/default/src/ckan/ckan/cli/cli.py", line 116, in parse_args
result = super(ExtendableGroup, self).parse_args(ctx, args)   File "/usr/lib/ckan/default/lib/python3.8/site-packages/click/core.py", line 1212, in parse_args
rest = Command.parse_args(self, ctx, args)   File "/usr/lib/ckan/default/lib/python3.8/site-packages/click/core.py", line 1048, in parse_args
value, args = param.handle_parse_result(ctx, opts, args)   File "/usr/lib/ckan/default/lib/python3.8/site-packages/click/core.py", line 1630, in handle_parse_result
value = invoke_param_callback(self.callback, ctx, self, value)   File "/usr/lib/ckan/default/lib/python3.8/site-packages/click/core.py", line 123, in invoke_param_callback
return callback(ctx, param, value)   File "/usr/lib/ckan/default/src/ckan/ckan/cli/cli.py", line 126, in _init_ckan_config
_add_ctx_object(ctx, value)   File "/usr/lib/ckan/default/src/ckan/ckan/cli/cli.py", line 135, in _add_ctx_object
ctx.obj = CtxObject(path)   File "/usr/lib/ckan/default/src/ckan/ckan/cli/cli.py", line 57, in __init__
self.app = make_app(self.config)   File "/usr/lib/ckan/default/src/ckan/ckan/config/middleware/__init__.py", line 56, in make_app
load_environment(conf)   File "/usr/lib/ckan/default/src/ckan/ckan/config/environment.py", line 123, in load_environment
p.load_all()   File "/usr/lib/ckan/default/src/ckan/ckan/plugins/core.py", line 165, in load_all
load(*plugins)   File "/usr/lib/ckan/default/src/ckan/ckan/plugins/core.py", line 193, in load
plugins_update()   File "/usr/lib/ckan/default/src/ckan/ckan/plugins/core.py", line 153, in plugins_update
environment.update_config()   File "/usr/lib/ckan/default/src/ckan/ckan/config/environment.py", line 309, in update_config
plugin.configure(config)   File "/usr/lib/ckan/default/src/ckanext-harvest/ckanext/harvest/plugin.py", line 279, in configure
model_setup()   File "/usr/lib/ckan/default/src/ckanext-harvest/ckanext/harvest/model/__init__.py", line 95, in setup
index_names = [index['name'] for index in inspector.get_indexes("harvest_object_extra")]   File "/usr/lib/ckan/default/lib/python3.8/site-packages/sqlalchemy/engine/reflection.py", line 494, in get_indexes
return self.dialect.get_indexes(   File "<string>", line 2, in get_indexes   File "/usr/lib/ckan/default/lib/python3.8/site-packages/sqlalchemy/engine/reflection.py", line 56, in cache
ret = fn(self, con, *args, **kw)   File "/usr/lib/ckan/default/lib/python3.8/site-packages/sqlalchemy/dialects/postgresql/base.py", line 3183, in get_indexes
table_oid = self.get_table_oid(   File "<string>", line 2, in get_table_oid   File "/usr/lib/ckan/default/lib/python3.8/site-packages/sqlalchemy/engine/reflection.py", line 56, in cache
ret = fn(self, con, *args, **kw)   File "/usr/lib/ckan/default/lib/python3.8/site-packages/sqlalchemy/dialects/postgresql/base.py", line 2704, in get_table_oid
raise exc.NoSuchTableError(table_name) sqlalchemy.exc.NoSuchTableError: harvest_object_extra .

please any help :) .
Thanks

@amercader
Copy link
Member

Sorry, I can't reproduce this locally. For some reason you ended up with just some of the harvest tables created. Try manually deleting all harvest_* tables in the DB and try again

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

2 participants