Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

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

Open
RoHei opened this issue Feb 29, 2024 · 0 comments
Open
Labels
bug Something isn't working

Comments

@RoHei
Copy link

RoHei commented Feb 29, 2024

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 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

@RoHei RoHei added the bug Something isn't working label Feb 29, 2024
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
bug Something isn't working
Projects
None yet
Development

No branches or pull requests

1 participant