search

ckan / ckanext-harvest

Remote harvesting extension for CKAN
130 stars 203 forks source link

Error in the installation of plugin harvest ckan #527

Open eya1 opened 1 year ago

eya1 commented 1 year ago

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 commented 1 year ago

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