You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
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]
Additional context
Version 1.2.0
The text was updated successfully, but these errors were encountered:
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
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
The text was updated successfully, but these errors were encountered: