Skip to content

More problems running the Docker preview #1177

@thoni56

Description

@thoni56

Package version (if known): v1.0.0rc1 - 95feace

Describe the bug

  • docker container (backend) hangs in a loop with an error in SQL
  • there is no ./scripts/setup to fill demo data

Steps to Reproduce

  1. Update Python version in docker/backend/Dockerfile to 3.7 as per cryptography does not support 3.6 - docker build fails #1176
  2. Follow instructions on https://invenioils.docs.cern.ch/preview/
  3. See invenio-app-ils-backend-1 repeatedly fail with a traceback (provided below)
  4. After docker exec -it ... trying to run ./script/setup but there is no such script.

Expected behavior

Getting a demo/preview instance started.

Additional context

Traceback:

invenio-app-ils-backend-1   | [pid: 11|app: 0|req: 2881/2952] 172.20.0.10 () {40 vars in 433 bytes} [Sat D
ec 17 14:18:31 2022] HEAD /ping => generated 0 bytes in 11 msecs (HTTP/1.1 500) 0 headers in 0 bytes (0 sw
itches on core 0)
invenio-app-ils-db-1        | 2022-12-17 14:18:33.279 UTC [75] ERROR:  relation "pages_page" does not exis
t at character 347
invenio-app-ils-db-1        | 2022-12-17 14:18:33.279 UTC [75] STATEMENT:  SELECT pages_page.created AS pa
ges_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
invenio-app-ils-backend-1   | [2022-12-17 14:18:33,279] WARNING in views: Pages were not loaded.
invenio-app-ils-db-1        |   FROM pages_page
invenio-app-ils-backend-1   | Traceback (most recent call last):
invenio-app-ils-backend-1   |   File "/usr/local/lib/python3.7/site-packages/sqlalchemy/engine/base.py", l
ine 1277, in _execute_context
invenio-app-ils-backend-1   |     cursor, statement, parameters, context
invenio-app-ils-backend-1   |   File "/usr/local/lib/python3.7/site-packages/sqlalchemy/engine/default.py"
, line 608, in do_execute
invenio-app-ils-backend-1   |     cursor.execute(statement, parameters)
invenio-app-ils-backend-1   | psycopg2.errors.UndefinedTable: relation "pages_page" does not exist
invenio-app-ils-backend-1   | LINE 2: FROM pages_page
invenio-app-ils-backend-1   |              ^
invenio-app-ils-backend-1   |
invenio-app-ils-backend-1   |
invenio-app-ils-backend-1   | The above exception was the direct cause of the following exception:
invenio-app-ils-backend-1   |
invenio-app-ils-backend-1   | Traceback (most recent call last):
invenio-app-ils-backend-1   |   File "/usr/local/lib/python3.7/site-packages/flask/app.py", line 2091, in
__call__
invenio-app-ils-backend-1   |     return self.wsgi_app(environ, start_response)
invenio-app-ils-backend-1   |   File "/usr/local/lib/python3.7/site-packages/werkzeug/middleware/dispatche
r.py", line 78, in __call__
invenio-app-ils-backend-1   |     return app(environ, start_response)
invenio-app-ils-backend-1   |   File "/usr/local/lib/python3.7/site-packages/flask/app.py", line 2076, in
wsgi_app
invenio-app-ils-backend-1   |     response = self.handle_exception(e)
invenio-app-ils-backend-1   |   File "/usr/local/lib/python3.7/site-packages/flask/app.py", line 2073, in
wsgi_app
invenio-app-ils-backend-1   |     response = self.full_dispatch_request()
invenio-app-ils-backend-1   |   File "/usr/local/lib/python3.7/site-packages/flask/app.py", line 1511, in
full_dispatch_request
invenio-app-ils-backend-1   |     self.try_trigger_before_first_request_functions()
invenio-app-ils-backend-1   |   File "/usr/local/lib/python3.7/site-packages/flask/app.py", line 1563, in
try_trigger_before_first_request_functions
invenio-app-ils-backend-1   |     self.ensure_sync(func)()
invenio-app-ils-backend-1   |   File "/usr/local/lib/python3.7/site-packages/invenio_pages/views.py", line
 49, in preload_pages
invenio-app-ils-backend-1   |     _add_url_rule([page.url for page in Page.query.all()])
invenio-app-ils-backend-1   |   File "/usr/local/lib/python3.7/site-packages/sqlalchemy/orm/query.py", lin
e 3373, in all
invenio-app-ils-backend-1   |     return list(self)
invenio-app-ils-backend-1   |   File "/usr/local/lib/python3.7/site-packages/sqlalchemy/orm/query.py", lin
e 3535, in __iter__
invenio-app-ils-backend-1   |     return self._execute_and_instances(context)
invenio-app-ils-backend-1   |   File "/usr/local/lib/python3.7/site-packages/sqlalchemy/orm/query.py", lin
e 3560, in _execute_and_instances
invenio-app-ils-backend-1   |     result = conn.execute(querycontext.statement, self._params)
invenio-app-ils-backend-1   |   File "/usr/local/lib/python3.7/site-packages/sqlalchemy/engine/base.py", l
ine 1011, in execute
invenio-app-ils-backend-1   |     return meth(self, multiparams, params)
invenio-app-ils-backend-1   |   File "/usr/local/lib/python3.7/site-packages/sqlalchemy/sql/elements.py",
line 298, in _execute_on_connection
invenio-app-ils-backend-1   |     return connection._execute_clauseelement(self, multiparams, params)
invenio-app-ils-backend-1   |   File "/usr/local/lib/python3.7/site-packages/sqlalchemy/engine/base.py", l
ine 1130, in _execute_clauseelement
invenio-app-ils-backend-1   |     distilled_params,
invenio-app-ils-backend-1   |   File "/usr/local/lib/python3.7/site-packages/sqlalchemy/engine/base.py", l
ine 1317, in _execute_context
invenio-app-ils-backend-1   |     e, statement, parameters, cursor, context
invenio-app-ils-backend-1   |   File "/usr/local/lib/python3.7/site-packages/sqlalchemy/engine/base.py", l
ine 1511, in _handle_dbapi_exception
invenio-app-ils-backend-1   |     sqlalchemy_exception, with_traceback=exc_info[2], from_=e
invenio-app-ils-backend-1   |   File "/usr/local/lib/python3.7/site-packages/sqlalchemy/util/compat.py", l
ine 182, in raise_
invenio-app-ils-backend-1   |     raise exception
invenio-app-ils-backend-1   |   File "/usr/local/lib/python3.7/site-packages/sqlalchemy/engine/base.py", l
ine 1277, in _execute_context
invenio-app-ils-backend-1   |     cursor, statement, parameters, context
invenio-app-ils-backend-1   |   File "/usr/local/lib/python3.7/site-packages/sqlalchemy/engine/default.py"
, line 608, in do_execute
invenio-app-ils-backend-1   |     cursor.execute(statement, parameters)
invenio-app-ils-backend-1   | sqlalchemy.exc.ProgrammingError: (psycopg2.errors.UndefinedTable) relation "
pages_page" does not exist
invenio-app-ils-frontend-1  | 2022/12/17 14:18:33 [error] 29#29: *5905 upstream prematurely closed connect
ion while reading response header from upstream, client: 172.20.0.10, server: _, request: "HEAD /ping HTTP
/1.1", upstream: "uwsgi://172.20.0.8:5000", host: "localhost"
invenio-app-ils-backend-1   | LINE 2: FROM pages_page
invenio-app-ils-frontend-1  | 172.20.0.10 - - [17/Dec/2022:14:18:33 +0000] "HEAD /ping HTTP/1.1" 502 0 "-"
 "-" "-"
invenio-app-ils-backend-1   |              ^
invenio-app-ils-backend-1   |
invenio-app-ils-backend-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_descript
ion, pages_page.template_name AS pages_page_template_name
invenio-app-ils-backend-1   | FROM pages_page]
invenio-app-ils-backend-1   | (Background on this error at: http://sqlalche.me/e/13/f405)

Metadata

Metadata

Assignees

No one assigned

    Labels

    bugSomething isn't working

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions