inveniosoftware / inveniosoftware/invenio-cli

Start-Up error: relation "pages_page" does not exist (Postgres, psycopg2)

Open
#363 0 comments 0 reactions 0 assignees View on GitHub
bug
Dominant language
Python
Stars
14
Forks
49
PR merge metrics
No merged PRs in 30d

Description

Package version (if known):

## Describe the bug
When InvenioRDM is started in the containerized version, I have a start-up issues when running the `setup`stage.
Apparently, a Postgres query is called via SQLAlchemy but this query fails, as the table `pages_page` does not exist.

## Steps to Reproduce
1. Run InvenioRDM as containerized application ,e.g. `invenio-cli containers setup`.

## Expected behavior
Successfull start-up of the commands

## Screenshots (if applicable)
Error-Log as below from Docker containers:
```
db_1 | 2024-02-29 15:40:08.247 UTC [73] **ERROR: relation "pages_page" does not exist at character 347**
db_1 | 2024-02-29 15:40:08.247 UTC [73] STATEMENT: SELECT pages_page.created AS pages_page_created, pages_page.updated AS pages_page_updated, pages_page.id AS pages_page_id, pages_page.url AS pages_page_url, pages_page.title AS pages_page_title, pages_page.content AS pages_page_content, pages_page.description AS pages_page_description, pages_page.template_name AS pages_page_template_name
db_1 | FROM pages_page
web-ui_1 | [2024-02-29 15:40:08,247] ERROR in app: Exception on / [GET]
web-ui_1 | Traceback (most recent call last):
web-ui_1 | File "/usr/local/lib64/python3.9/site-packages/sqlalchemy/engine/base.py", line 1910, in _execute_context
web-ui_1 | self.dialect.do_execute(
web-ui_1 | File "/usr/local/lib64/python3.9/site-packages/sqlalchemy/engine/default.py", line 736, in do_execute
web-ui_1 | cursor.execute(statement, parameters)
web-ui_1 | psycopg2.errors.UndefinedTable: relation "pages_page" does not exist
web-ui_1 | LINE 2: FROM pages_page
web-ui_1 | ^
web-ui_1 |
web-ui_1 |
web-ui_1 | The above exception was the direct cause of the following exception:
web-ui_1 |
web-ui_1 | Traceback (most recent call last):
web-ui_1 | File "/usr/local/lib/python3.9/site-packages/flask/app.py", line 2529, in wsgi_app
web-ui_1 | response = self.full_dispatch_request()
web-ui_1 | File "/usr/local/lib/python3.9/site-packages/flask/app.py", line 1815, in full_dispatch_request
web-ui_1 | self.ensure_sync(func)()
web-ui_1 | File "/usr/local/lib/python3.9/site-packages/invenio_pages/views.py", line 30, in register_pages
web-ui_1 | for page in Page.query.all():
web-ui_1 | File "/usr/local/lib64/python3.9/site-packages/sqlalchemy/orm/query.py", line 2773, in all
web-ui_1 | return self._iter().all()
web-ui_1 | File "/usr/local/lib64/python3.9/site-packages/sqlalchemy/orm/query.py", line 2916, in _iter
web-ui_1 | result = self.session.execute(
web-ui_1 | File "/usr/local/lib64/python3.9/site-packages/sqlalchemy/orm/session.py", line 1717, in execute
web-ui_1 | result = conn._execute_20(statement, params or {}, execution_options)
web-ui_1 | File "/usr/local/lib64/python3.9/site-packages/sqlalchemy/engine/base.py", line 1710, in _execute_20
web-ui_1 | return meth(self, args_10style, kwargs_10style, execution_options)
web-ui_1 | File "/usr/local/lib64/python3.9/site-packages/sqlalchemy/sql/elements.py", line 334, in _execute_on_connection
web-ui_1 | return connection._execute_clauseelement(
web-ui_1 | File "/usr/local/lib64/python3.9/site-packages/sqlalchemy/engine/base.py", line 1577, in _execute_clauseelement
web-ui_1 | ret = self._execute_context(
web-ui_1 | File "/usr/local/lib64/python3.9/site-packages/sqlalchemy/engine/base.py", line 1953, in _execute_context
web-ui_1 | self._handle_dbapi_exception(
web-ui_1 | File "/usr/local/lib64/python3.9/site-packages/sqlalchemy/engine/base.py", line 2134, in _handle_dbapi_exception
web-ui_1 | util.raise_(
web-ui_1 | File "/usr/local/lib64/python3.9/site-packages/sqlalchemy/util/compat.py", line 211, in raise_
web-ui_1 | raise exception
web-ui_1 | File "/usr/local/lib64/python3.9/site-packages/sqlalchemy/engine/base.py", line 1910, in _execute_context
web-ui_1 | self.dialect.do_execute(
web-ui_1 | File "/usr/local/lib64/python3.9/site-packages/sqlalchemy/engine/default.py", line 736, in do_execute
web-ui_1 | cursor.execute(statement, parameters)
web-ui_1 | sqlalchemy.exc.ProgrammingError: (psycopg2.errors.UndefinedTable) relation "pages_page" does not exist
web-ui_1 | LINE 2: FROM pages_page
web-ui_1 | ^
web-ui_1 |
web-ui_1 | [SQL: SELECT pages_page.created AS pages_page_created, pages_page.updated AS pages_page_updated, pages_page.id AS pages_page_id, pages_page.url AS pages_page_url, pages_page.title AS pages_page_title, pages_page.content AS pages_page_content, pages_page.description AS pages_page_description, pages_page.template_name AS pages_page_template_name
web-ui_1 | FROM pages_page]
```

## Additional context
Version 1.2.0

Contributor guide

Open the contributing guide

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.