pool check crashes - sqlalchemy.exc.ArgumentError: Mapper mapped class NewRecord->site_field_value could not assemble any primary key columns for mapped table 'site_field_value'
after upgrading I tested pool check which a dlz (test-abc-2), where I added a dummy source_type.
It doesn't crash on the UWO datapool, it crashes on the sww datapool (eaw-sdwh4). I cannot check on the whdp due to issue Issue #72 (closed).
foerstch@eaw-sdwh4:~$ pool check test-abc-2
> this is datapool version 2.0.0
> check
- check names and places of changed files at landing zone test-abc-2
- all filenames comply specification.
- copy meta data from productive db
- copy table meta_action_type
- copy table meta_data
- copy table meta_flag
- copy table meta_log_type
- copy table meta_picture
- copy table person
- copy table picture
- copy table project
- copy table site
- copy table site_field
- copy table site_field_value
Traceback (most recent call last):
File "/usr/local/lib/python3.9/site-packages/poolkit/main.py", line 99, in inner
return function(*a, **kw)
File "/usr/local/lib/python3.9/site-packages/poolkit/main.py", line 283, in _check
check(
File "/usr/local/lib/python3.9/site-packages/poolkit/commands/check.py", line 48, in check
return _check(
File "/usr/local/lib/python3.9/site-packages/poolkit/commands/check.py", line 135, in _check
with _setup_test_db(landing_zone, config, verbose, print_ok, print_err) as engine:
File "/usr/local/lib/python3.9/contextlib.py", line 117, in __enter__
return next(self.gen)
File "/usr/local/lib/python3.9/site-packages/poolkit/commands/check.py", line 621, in _setup_test_db
for table_name in copy_db(
File "/usr/local/lib/python3.9/site-packages/poolkit/database.py", line 299, in copy_db
_copy_table(
File "/usr/local/lib/python3.9/site-packages/poolkit/database.py", line 321, in _copy_table
class NewRecord(Base):
File "/usr/local/lib/python3.9/site-packages/sqlalchemy/orm/decl_api.py", line 76, in __init__
_as_declarative(reg, cls, dict_)
File "/usr/local/lib/python3.9/site-packages/sqlalchemy/orm/decl_base.py", line 126, in _as_declarative
return _MapperConfig.setup_mapping(registry, cls, dict_, None, {})
File "/usr/local/lib/python3.9/site-packages/sqlalchemy/orm/decl_base.py", line 183, in setup_mapping
return cfg_cls(registry, cls_, dict_, table, mapper_kw)
File "/usr/local/lib/python3.9/site-packages/sqlalchemy/orm/decl_base.py", line 335, in __init__
self._early_mapping(mapper_kw)
File "/usr/local/lib/python3.9/site-packages/sqlalchemy/orm/decl_base.py", line 215, in _early_mapping
self.map(mapper_kw)
File "/usr/local/lib/python3.9/site-packages/sqlalchemy/orm/decl_base.py", line 1047, in map
mapper_cls(self.cls, self.local_table, **self.mapper_args),
File "<string>", line 2, in __init__
File "/usr/local/lib/python3.9/site-packages/sqlalchemy/util/deprecations.py", line 375, in warned
return fn(*args, **kwargs)
File "/usr/local/lib/python3.9/site-packages/sqlalchemy/orm/mapper.py", line 693, in __init__
self._configure_pks()
File "/usr/local/lib/python3.9/site-packages/sqlalchemy/orm/mapper.py", line 1400, in _configure_pks
raise sa_exc.ArgumentError(
sqlalchemy.exc.ArgumentError: Mapper mapped class NewRecord->site_field_value could not assemble any primary key columns for mapped table 'site_field_value'
set environment variable PDB to start debugger automatically.
Traceback (most recent call last):
File "/usr/local/bin/pool", line 33, in <module>
sys.exit(load_entry_point('datapool', 'console_scripts', 'pool')())
File "/usr/local/lib/python3.9/site-packages/click/core.py", line 1130, in __call__
return self.main(*args, **kwargs)
File "/usr/local/lib/python3.9/site-packages/click/core.py", line 1055, in main
rv = self.invoke(ctx)
File "/usr/local/lib/python3.9/site-packages/click/core.py", line 1657, in invoke
return _process_result(sub_ctx.command.invoke(sub_ctx))
File "/usr/local/lib/python3.9/site-packages/click/core.py", line 1404, in invoke
return ctx.invoke(self.callback, **ctx.params)
File "/usr/local/lib/python3.9/site-packages/click/core.py", line 760, in invoke
return __callback(*args, **kwargs)
File "/usr/local/lib/python3.9/site-packages/poolkit/main.py", line 76, in inner
return function(*a, **kw)
File "/usr/local/lib/python3.9/site-packages/poolkit/main.py", line 114, in inner
raise e
File "/usr/local/lib/python3.9/site-packages/poolkit/main.py", line 99, in inner
return function(*a, **kw)
File "/usr/local/lib/python3.9/site-packages/poolkit/main.py", line 283, in _check
check(
File "/usr/local/lib/python3.9/site-packages/poolkit/commands/check.py", line 48, in check
return _check(
File "/usr/local/lib/python3.9/site-packages/poolkit/commands/check.py", line 135, in _check
with _setup_test_db(landing_zone, config, verbose, print_ok, print_err) as engine:
File "/usr/local/lib/python3.9/contextlib.py", line 117, in __enter__
return next(self.gen)
File "/usr/local/lib/python3.9/site-packages/poolkit/commands/check.py", line 621, in _setup_test_db
for table_name in copy_db(
File "/usr/local/lib/python3.9/site-packages/poolkit/database.py", line 299, in copy_db
_copy_table(
File "/usr/local/lib/python3.9/site-packages/poolkit/database.py", line 321, in _copy_table
class NewRecord(Base):
File "/usr/local/lib/python3.9/site-packages/sqlalchemy/orm/decl_api.py", line 76, in __init__
_as_declarative(reg, cls, dict_)
File "/usr/local/lib/python3.9/site-packages/sqlalchemy/orm/decl_base.py", line 126, in _as_declarative
return _MapperConfig.setup_mapping(registry, cls, dict_, None, {})
File "/usr/local/lib/python3.9/site-packages/sqlalchemy/orm/decl_base.py", line 183, in setup_mapping
return cfg_cls(registry, cls_, dict_, table, mapper_kw)
File "/usr/local/lib/python3.9/site-packages/sqlalchemy/orm/decl_base.py", line 335, in __init__
self._early_mapping(mapper_kw)
File "/usr/local/lib/python3.9/site-packages/sqlalchemy/orm/decl_base.py", line 215, in _early_mapping
self.map(mapper_kw)
File "/usr/local/lib/python3.9/site-packages/sqlalchemy/orm/decl_base.py", line 1047, in map
mapper_cls(self.cls, self.local_table, **self.mapper_args),
File "<string>", line 2, in __init__
File "/usr/local/lib/python3.9/site-packages/sqlalchemy/util/deprecations.py", line 375, in warned
return fn(*args, **kwargs)
File "/usr/local/lib/python3.9/site-packages/sqlalchemy/orm/mapper.py", line 693, in __init__
self._configure_pks()
File "/usr/local/lib/python3.9/site-packages/sqlalchemy/orm/mapper.py", line 1400, in _configure_pks
raise sa_exc.ArgumentError(
sqlalchemy.exc.ArgumentError: Mapper mapped class NewRecord->site_field_value could not assemble any primary key columns for mapped table 'site_field_value'