When InvenioRDM is started in the containerized version, I have a start-up issues when running the setupstage.
Apparently, a Postgres query is called via SQLAlchemy but this query fails, as the table pages_page does not exist.
Steps to Reproduce
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]
Package version (if known):
Describe the bug
When InvenioRDM is started in the containerized version, I have a start-up issues when running the
setupstage. Apparently, a Postgres query is called via SQLAlchemy but this query fails, as the tablepages_pagedoes not exist.Steps to Reproduce
invenio-cli containers setup.Expected behavior
Successfull start-up of the commands
Screenshots (if applicable)
Error-Log as below from Docker containers:
Additional context
Version 1.2.0