Preview with Docker Shows SQLAlchemy Errors, and Server shows "Network Error" #1158
Description
System Information:
Container Host: Ubuntu 20.04.4
Docker Version: 20.10.16
*** Starting uWSGI 2.0.20 (64bit) on [Sat May 28 01:45:54 2022] ***
compiled with version: 10.2.1 20210110 on 27 May 2022 03:50:33
os: Linux-5.4.0-113-generic #127-Ubuntu SMP Wed May 18 14:30:56 UTC 2022
nodename: 53ff05f403fe
machine: x86_64
clock source: unix
pcre jit disabled
detected number of CPU cores: 4
current working directory: /opt/invenio_app_ils/src
detected binary path: /usr/local/bin/uwsgi
your memory page size is 4096 bytes
detected max file descriptor number: 1048576
lock engine: pthread robust mutexes
thunder lock: disabled (you can enable it with --thunder-lock)
uwsgi socket 0 bound to TCP address 0.0.0.0:5000 fd 3
Python version: 3.6.15 (default, Dec 21 2021, 12:03:22) [GCC 10.2.1 20210110]
Python main interpreter initialized at 0x559231461c10
python threads support enabled
your server socket listen backlog is limited to 100 connections
your mercy for graceful operations on workers is 60 seconds
mapped 250128 bytes (244 KB) for 4 cores
*** Operational MODE: preforking+threaded ***
Describe the bug
After following instructions in <Preview - Documentation>, I saw several sqlalchemy errors appeared, all indicating:
...
File "/usr/local/lib/python3.6/site-packages/sqlalchemy/engine/default.py", line 608, in do_execute
cursor.execute(statement, parameters)
sqlalchemy.exc.ProgrammingError: (psycopg2.errors.UndefinedTable) relation "pages_page" does not exist
LINE 2: FROM pages_page
^I ran the command described in the preview documentation to set up the DB:
docker exec -it invenioils_backend_1 /bin/bash
invenio@e34cadf4b303:/opt/invenio_app_ils/src$ ./scripts/setupAnd this lead to the service becoming "responsive" but it still would not allow login.
Question:
Is login not supported in the preview (Docker) environment?
Screenshots:
Additional context
Full Traceback
joestan@stanleyserv02:~$ docker logs invenioils-backend-1
*** Starting uWSGI 2.0.20 (64bit) on [Sat May 28 01:45:54 2022] ***
compiled with version: 10.2.1 20210110 on 27 May 2022 03:50:33
os: Linux-5.4.0-113-generic #127-Ubuntu SMP Wed May 18 14:30:56 UTC 2022
nodename: 53ff05f403fe
machine: x86_64
clock source: unix
pcre jit disabled
detected number of CPU cores: 4
current working directory: /opt/invenio_app_ils/src
detected binary path: /usr/local/bin/uwsgi
your memory page size is 4096 bytes
detected max file descriptor number: 1048576
lock engine: pthread robust mutexes
thunder lock: disabled (you can enable it with --thunder-lock)
uwsgi socket 0 bound to TCP address 0.0.0.0:5000 fd 3
Python version: 3.6.15 (default, Dec 21 2021, 12:03:22) [GCC 10.2.1 20210110]
Python main interpreter initialized at 0x559231461c10
python threads support enabled
your server socket listen backlog is limited to 100 connections
your mercy for graceful operations on workers is 60 seconds
mapped 250128 bytes (244 KB) for 4 cores
*** Operational MODE: preforking+threaded ***
/usr/local/lib/python3.6/site-packages/sqlalchemy_utils/types/encrypted/encrypted_type.py:15: CryptographyDeprecationWarning: Python 3.6 is no longer supported by the Python core team. Therefore, support for it is deprecated in cryptography and will be removed in a future release.
import cryptography
/usr/local/lib/python3.6/site-packages/invenio_rest/ext.py:30: FutureWarning: CSRF validation will be enabled by default in the version 1.3.x
self.init_app(app)
/usr/local/lib/python3.6/site-packages/sqlalchemy/ext/declarative/clsregistry.py:129: SAWarning: This declarative base already contains a class with the same class name and module name as sqlalchemy_continuum.model_builder.RecordMetadataVersion, and will be replaced in the string-lookup table.
% (item.__module__, item.__name__)
/usr/local/lib/python3.6/site-packages/sqlalchemy/ext/declarative/clsregistry.py:129: SAWarning: This declarative base already contains a class with the same class name and module name as sqlalchemy_continuum.model_builder.PageVersion, and will be replaced in the string-lookup table.
% (item.__module__, item.__name__)
/usr/local/lib/python3.6/site-packages/sqlalchemy/ext/declarative/clsregistry.py:129: SAWarning: This declarative base already contains a class with the same class name and module name as sqlalchemy_continuum.model_builder.PageListVersion, and will be replaced in the string-lookup table.
% (item.__module__, item.__name__)
/usr/local/lib/python3.6/site-packages/sqlalchemy/orm/properties.py:249: SAWarning: On mapper mapped class RecordMetadataVersion->records_metadata_version, primary key column 'records_metadata_version.transaction_id' is being combined with distinct primary key column 'records_metadata_version.transaction_id' in attribute 'transaction_id'. Use explicit properties to give each column its own mapped attribute name.
% (self.parent, self.columns[1], self.columns[0], self.key)
/usr/local/lib/python3.6/site-packages/sqlalchemy/orm/properties.py:249: SAWarning: On mapper mapped class PageVersion->pages_page_version, primary key column 'pages_page_version.transaction_id' is being combined with distinct primary key column 'pages_page_version.transaction_id' in attribute 'transaction_id'. Use explicit properties to give each column its own mapped attribute name.
% (self.parent, self.columns[1], self.columns[0], self.key)
/usr/local/lib/python3.6/site-packages/sqlalchemy/orm/properties.py:249: SAWarning: On mapper mapped class PageListVersion->pages_pagelist_version, primary key column 'pages_pagelist_version.transaction_id' is being combined with distinct primary key column 'pages_pagelist_version.transaction_id' in attribute 'transaction_id'. Use explicit properties to give each column its own mapped attribute name.
% (self.parent, self.columns[1], self.columns[0], self.key)
/usr/local/lib/python3.6/site-packages/flask_caching/__init__.py:241: DeprecationWarning: Using the initialization functions in flask_caching.backend is deprecated. Use the a full path to backend classes directly.
category=DeprecationWarning,
/usr/local/lib/python3.6/site-packages/marshmallow/fields.py:184: RemovedInMarshmallow4Warning: The 'missing' argument to fields is deprecated. Use 'load_default' instead.
RemovedInMarshmallow4Warning,
/usr/local/lib/python3.6/site-packages/marshmallow/fields.py:222: RemovedInMarshmallow4Warning: Passing field metadata as keyword arguments is deprecated. Use the explicit `metadata=...` argument instead. Additional metadata: {'load_from': 'partNumber', 'location': 'query'}
RemovedInMarshmallow4Warning,
/usr/local/lib/python3.6/site-packages/marshmallow/fields.py:222: RemovedInMarshmallow4Warning: Passing field metadata as keyword arguments is deprecated. Use the explicit `metadata=...` argument instead. Additional metadata: {'load_from': 'Content-Length', 'location': 'headers'}
RemovedInMarshmallow4Warning,
/usr/local/lib/python3.6/site-packages/marshmallow/fields.py:222: RemovedInMarshmallow4Warning: Passing field metadata as keyword arguments is deprecated. Use the explicit `metadata=...` argument instead. Additional metadata: {'load_from': 'Content-Type', 'location': 'headers'}
RemovedInMarshmallow4Warning,
/usr/local/lib/python3.6/site-packages/marshmallow/fields.py:222: RemovedInMarshmallow4Warning: Passing field metadata as keyword arguments is deprecated. Use the explicit `metadata=...` argument instead. Additional metadata: {'load_from': 'Content-MD5', 'location': 'headers'}
RemovedInMarshmallow4Warning,
/usr/local/lib/python3.6/site-packages/marshmallow/fields.py:222: RemovedInMarshmallow4Warning: Passing field metadata as keyword arguments is deprecated. Use the explicit `metadata=...` argument instead. Additional metadata: {'load_from': '_chunkNumber', 'location': 'form'}
RemovedInMarshmallow4Warning,
/usr/local/lib/python3.6/site-packages/marshmallow/fields.py:222: RemovedInMarshmallow4Warning: Passing field metadata as keyword arguments is deprecated. Use the explicit `metadata=...` argument instead. Additional metadata: {'load_from': '_currentChunkSize', 'location': 'form'}
RemovedInMarshmallow4Warning,
/usr/local/lib/python3.6/site-packages/marshmallow/fields.py:222: RemovedInMarshmallow4Warning: Passing field metadata as keyword arguments is deprecated. Use the explicit `metadata=...` argument instead. Additional metadata: {'load_from': 'file', 'location': 'files'}
RemovedInMarshmallow4Warning,
/usr/local/lib/python3.6/site-packages/marshmallow/fields.py:222: RemovedInMarshmallow4Warning: Passing field metadata as keyword arguments is deprecated. Use the explicit `metadata=...` argument instead. Additional metadata: {'load_from': '_totalSize', 'location': 'form'}
RemovedInMarshmallow4Warning,
/usr/local/lib/python3.6/site-packages/marshmallow/fields.py:222: RemovedInMarshmallow4Warning: Passing field metadata as keyword arguments is deprecated. Use the explicit `metadata=...` argument instead. Additional metadata: {'location': 'query'}
RemovedInMarshmallow4Warning,
/usr/local/lib/python3.6/site-packages/marshmallow/fields.py:222: RemovedInMarshmallow4Warning: Passing field metadata as keyword arguments is deprecated. Use the explicit `metadata=...` argument instead. Additional metadata: {'location': 'query', 'load_from': 'versionId'}
RemovedInMarshmallow4Warning,
/usr/local/lib/python3.6/site-packages/marshmallow/fields.py:222: RemovedInMarshmallow4Warning: Passing field metadata as keyword arguments is deprecated. Use the explicit `metadata=...` argument instead. Additional metadata: {'location': 'query', 'load_from': 'uploadId'}
RemovedInMarshmallow4Warning,
/usr/local/lib/python3.6/site-packages/marshmallow/fields.py:222: RemovedInMarshmallow4Warning: Passing field metadata as keyword arguments is deprecated. Use the explicit `metadata=...` argument instead. Additional metadata: {'locations': ('query', 'json')}
RemovedInMarshmallow4Warning,
/usr/local/lib/python3.6/site-packages/marshmallow/fields.py:222: RemovedInMarshmallow4Warning: Passing field metadata as keyword arguments is deprecated. Use the explicit `metadata=...` argument instead. Additional metadata: {'locations': ('query', 'json'), 'load_from': 'partSize'}
RemovedInMarshmallow4Warning,
WSGI app 0 (mountpoint='') ready in 17 seconds on interpreter 0x559231461c10 pid: 1 (default app)
*** uWSGI is running in multiple interpreter mode ***
spawned uWSGI master process (pid: 1)
spawned uWSGI worker 1 (pid: 10, cores: 2)
spawned uWSGI worker 2 (pid: 12, cores: 2)
*** Stats server enabled on /tmp/stats.socket fd: 11 ***
/usr/local/lib/python3.6/site-packages/invenio_pages/views.py:51: DeprecationWarning: The 'warn' method is deprecated, use 'warning' instead
current_app.logger.warn('Pages were not loaded.')
[2022-05-28 01:46:11,705] WARNING in views: Pages were not loaded.
Traceback (most recent call last):
File "/usr/local/lib/python3.6/site-packages/sqlalchemy/engine/base.py", line 1277, in _execute_context
cursor, statement, parameters, context
File "/usr/local/lib/python3.6/site-packages/sqlalchemy/engine/default.py", line 608, in do_execute
cursor.execute(statement, parameters)
psycopg2.errors.UndefinedTable: relation "pages_page" does not exist
LINE 2: FROM pages_page
^
The above exception was the direct cause of the following exception:
Traceback (most recent call last):
File "/usr/local/lib/python3.6/site-packages/flask/app.py", line 2091, in __call__
[2022-05-28 01:46:11,714] WARNING in views: Pages were not loaded.
Traceback (most recent call last):
File "/usr/local/lib/python3.6/site-packages/sqlalchemy/engine/base.py", line 1277, in _execute_context
cursor, statement, parameters, context
File "/usr/local/lib/python3.6/site-packages/sqlalchemy/engine/default.py", line 608, in do_execute
cursor.execute(statement, parameters)
psycopg2.errors.UndefinedTable: relation "pages_page" does not exist
LINE 2: FROM pages_page
^
The above exception was the direct cause of the following exception:
Traceback (most recent call last):
File "/usr/local/lib/python3.6/site-packages/flask/app.py", line 2091, in __call__
return self.wsgi_app(environ, start_response)
File "/usr/local/lib/python3.6/site-packages/werkzeug/middleware/dispatcher.py", line 78, in __call__
return app(environ, start_response)
File "/usr/local/lib/python3.6/site-packages/flask/app.py", line 2076, in wsgi_app
response = self.handle_exception(e)
File "/usr/local/lib/python3.6/site-packages/flask/app.py", line 2073, in wsgi_app
response = self.full_dispatch_request()
File "/usr/local/lib/python3.6/site-packages/flask/app.py", line 1511, in full_dispatch_request
self.try_trigger_before_first_request_functions()
File "/usr/local/lib/python3.6/site-packages/flask/app.py", line 1563, in try_trigger_before_first_request_functions
self.ensure_sync(func)()
File "/usr/local/lib/python3.6/site-packages/invenio_pages/views.py", line 49, in preload_pages
_add_url_rule([page.url for page in Page.query.all()])
File "/usr/local/lib/python3.6/site-packages/sqlalchemy/orm/query.py", line 3373, in all
return list(self)
File "/usr/local/lib/python3.6/site-packages/sqlalchemy/orm/query.py", line 3535, in __iter__
return self._execute_and_instances(context)
return self.wsgi_app(environ, start_response)
File "/usr/local/lib/python3.6/site-packages/werkzeug/middleware/dispatcher.py", line 78, in __call__
return app(environ, start_response)
File "/usr/local/lib/python3.6/site-packages/flask/app.py", line 2076, in wsgi_app
response = self.handle_exception(e)
File "/usr/local/lib/python3.6/site-packages/flask/app.py", line 2073, in wsgi_app
response = self.full_dispatch_request()
File "/usr/local/lib/python3.6/site-packages/flask/app.py", line 1511, in full_dispatch_request
self.try_trigger_before_first_request_functions()
File "/usr/local/lib/python3.6/site-packages/flask/app.py", line 1563, in try_trigger_before_first_request_functions
self.ensure_sync(func)()
File "/usr/local/lib/python3.6/site-packages/invenio_pages/views.py", line 49, in preload_pages
_add_url_rule([page.url for page in Page.query.all()])
File "/usr/local/lib/python3.6/site-packages/sqlalchemy/orm/query.py", line 3373, in all
return list(self)
File "/usr/local/lib/python3.6/site-packages/sqlalchemy/orm/query.py", line 3535, in __iter__
File "/usr/local/lib/python3.6/site-packages/sqlalchemy/orm/query.py", line 3560, in _execute_and_instances
result = conn.execute(querycontext.statement, self._params)
File "/usr/local/lib/python3.6/site-packages/sqlalchemy/engine/base.py", line 1011, in execute
return meth(self, multiparams, params)
File "/usr/local/lib/python3.6/site-packages/sqlalchemy/sql/elements.py", line 298, in _execute_on_connection
return connection._execute_clauseelement(self, multiparams, params)
File "/usr/local/lib/python3.6/site-packages/sqlalchemy/engine/base.py", line 1130, in _execute_clauseelement
distilled_params,
File "/usr/local/lib/python3.6/site-packages/sqlalchemy/engine/base.py", line 1317, in _execute_context
e, statement, parameters, cursor, context
File "/usr/local/lib/python3.6/site-packages/sqlalchemy/engine/base.py", line 1511, in _handle_dbapi_exception
sqlalchemy_exception, with_traceback=exc_info[2], from_=e
File "/usr/local/lib/python3.6/site-packages/sqlalchemy/util/compat.py", line 182, in raise_
raise exception
File "/usr/local/lib/python3.6/site-packages/sqlalchemy/engine/base.py", line 1277, in _execute_context
return self._execute_and_instances(context)
File "/usr/local/lib/python3.6/site-packages/sqlalchemy/orm/query.py", line 3560, in _execute_and_instances
result = conn.execute(querycontext.statement, self._params)
File "/usr/local/lib/python3.6/site-packages/sqlalchemy/engine/base.py", line 1011, in execute
return meth(self, multiparams, params)
File "/usr/local/lib/python3.6/site-packages/sqlalchemy/sql/elements.py", line 298, in _execute_on_connection
return connection._execute_clauseelement(self, multiparams, params)
File "/usr/local/lib/python3.6/site-packages/sqlalchemy/engine/base.py", line 1130, in _execute_clauseelement
distilled_params,
File "/usr/local/lib/python3.6/site-packages/sqlalchemy/engine/base.py", line 1317, in _execute_context
e, statement, parameters, cursor, context
File "/usr/local/lib/python3.6/site-packages/sqlalchemy/engine/base.py", line 1511, in _handle_dbapi_exception
sqlalchemy_exception, with_traceback=exc_info[2], from_=e
File "/usr/local/lib/python3.6/site-packages/sqlalchemy/util/compat.py", line 182, in raise_
raise exception
File "/usr/local/lib/python3.6/site-packages/sqlalchemy/engine/base.py", line 1277, in _execute_context
cursor, statement, parameters, context
File "/usr/local/lib/python3.6/site-packages/sqlalchemy/engine/default.py", line 608, in do_execute
cursor.execute(statement, parameters)
sqlalchemy.exc.ProgrammingError: (psycopg2.errors.UndefinedTable) relation "pages_page" does not exist
LINE 2: FROM pages_page
^
[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
FROM pages_page]
(Background on this error at: http://sqlalche.me/e/13/f405) cursor, statement, parameters, context
File "/usr/local/lib/python3.6/site-packages/sqlalchemy/engine/default.py", line 608, in do_execute
cursor.execute(statement, parameters)
sqlalchemy.exc.ProgrammingError: (psycopg2.errors.UndefinedTable) relation "pages_page" does not exist
LINE 2: FROM pages_page
^
[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
FROM pages_page]
(Background on this error at: http://sqlalche.me/e/13/f405)
[pid: 10|app: 0|req: 2/1] 172.19.0.10 () {40 vars in 433 bytes} [Sat May 28 01:46:11 2022] HEAD /ping => generated 0 bytes in 122 msecs (HTTP/1.1 500) 0 headers in 0 bytes (0 switches on core 1)
[pid: 10|app: 0|req: 2/2] 172.19.0.10 () {40 vars in 433 bytes} [Sat May 28 01:46:11 2022] HEAD /ping => generated 0 bytes in 134 msecs (HTTP/1.1 500) 0 headers in 0 bytes (0 switches on core 0)
/usr/local/lib/python3.6/site-packages/invenio_pages/views.py:51: DeprecationWarning: The 'warn' method is deprecated, use 'warning' instead
current_app.logger.warn('Pages were not loaded.')
[2022-05-28 01:46:13,799] WARNING in views: Pages were not loaded.
Traceback (most recent call last):
File "/usr/local/lib/python3.6/site-packages/sqlalchemy/engine/base.py", line 1277, in _execute_context
cursor, statement, parameters, context
File "/usr/local/lib/python3.6/site-packages/sqlalchemy/engine/default.py", line 608, in do_execute
cursor.execute(statement, parameters)
psycopg2.errors.UndefinedTable: relation "pages_page" does not exist
LINE 2: FROM pages_page
^
The above exception was the direct cause of the following exception:
Traceback (most recent call last):
File "/usr/local/lib/python3.6/site-packages/flask/app.py", line 2091, in __call__
return self.wsgi_app(environ, start_response)
File "/usr/local/lib/python3.6/site-packages/werkzeug/middleware/dispatcher.py", line 78, in __call__
return app(environ, start_response)
File "/usr/local/lib/python3.6/site-packages/flask/app.py", line 2076, in wsgi_app
response = self.handle_exception(e)
File "/usr/local/lib/python3.6/site-packages/flask/app.py", line 2073, in wsgi_app
response = self.full_dispatch_request()
File "/usr/local/lib/python3.6/site-packages/flask/app.py", line 1511, in full_dispatch_request
self.try_trigger_before_first_request_functions()
File "/usr/local/lib/python3.6/site-packages/flask/app.py", line 1563, in try_trigger_before_first_request_functions
self.ensure_sync(func)()
File "/usr/local/lib/python3.6/site-packages/invenio_pages/views.py", line 49, in preload_pages
_add_url_rule([page.url for page in Page.query.all()])
File "/usr/local/lib/python3.6/site-packages/sqlalchemy/orm/query.py", line 3373, in all
return list(self)
File "/usr/local/lib/python3.6/site-packages/sqlalchemy/orm/query.py", line 3535, in __iter__
return self._execute_and_instances(context)
File "/usr/local/lib/python3.6/site-packages/sqlalchemy/orm/query.py", line 3560, in _execute_and_instances
result = conn.execute(querycontext.statement, self._params)
File "/usr/local/lib/python3.6/site-packages/sqlalchemy/engine/base.py", line 1011, in execute
return meth(self, multiparams, params)
File "/usr/local/lib/python3.6/site-packages/sqlalchemy/sql/elements.py", line 298, in _execute_on_connection
return connection._execute_clauseelement(self, multiparams, params)
File "/usr/local/lib/python3.6/site-packages/sqlalchemy/engine/base.py", line 1130, in _execute_clauseelement
distilled_params,
File "/usr/local/lib/python3.6/site-packages/sqlalchemy/engine/base.py", line 1317, in _execute_context
e, statement, parameters, cursor, context
File "/usr/local/lib/python3.6/site-packages/sqlalchemy/engine/base.py", line 1511, in _handle_dbapi_exception
sqlalchemy_exception, with_traceback=exc_info[2], from_=e
File "/usr/local/lib/python3.6/site-packages/sqlalchemy/util/compat.py", line 182, in raise_
raise exception
File "/usr/local/lib/python3.6/site-packages/sqlalchemy/engine/base.py", line 1277, in _execute_context
cursor, statement, parameters, context
File "/usr/local/lib/python3.6/site-packages/sqlalchemy/engine/default.py", line 608, in do_execute
cursor.execute(statement, parameters)
sqlalchemy.exc.ProgrammingError: (psycopg2.errors.UndefinedTable) relation "pages_page" does not exist
LINE 2: FROM pages_page
^
[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
FROM pages_page]
(Background on this error at: http://sqlalche.me/e/13/f405)
[pid: 12|app: 0|req: 1/3] 172.19.0.10 () {40 vars in 433 bytes} [Sat May 28 01:46:13 2022] HEAD /ping => generated 0 bytes in 76 msecs (HTTP/1.1 500) 0 headers in 0 bytes (0 switches on core 0)
[2022-05-28 01:46:18,841] WARNING in views: Pages were not loaded.
Traceback (most recent call last):
File "/usr/local/lib/python3.6/site-packages/sqlalchemy/engine/base.py", line 1277, in _execute_context
cursor, statement, parameters, context
File "/usr/local/lib/python3.6/site-packages/sqlalchemy/engine/default.py", line 608, in do_execute
cursor.execute(statement, parameters)
psycopg2.errors.UndefinedTable: relation "pages_page" does not exist
LINE 2: FROM pages_page
^
The above exception was the direct cause of the following exception:
Traceback (most recent call last):
File "/usr/local/lib/python3.6/site-packages/flask/app.py", line 2091, in __call__
return self.wsgi_app(environ, start_response)
File "/usr/local/lib/python3.6/site-packages/werkzeug/middleware/dispatcher.py", line 78, in __call__
return app(environ, start_response)
File "/usr/local/lib/python3.6/site-packages/flask/app.py", line 2076, in wsgi_app
response = self.handle_exception(e)
File "/usr/local/lib/python3.6/site-packages/flask/app.py", line 2073, in wsgi_app
response = self.full_dispatch_request()
File "/usr/local/lib/python3.6/site-packages/flask/app.py", line 1511, in full_dispatch_request
self.try_trigger_before_first_request_functions()
File "/usr/local/lib/python3.6/site-packages/flask/app.py", line 1563, in try_trigger_before_first_request_functions
self.ensure_sync(func)()
File "/usr/local/lib/python3.6/site-packages/invenio_pages/views.py", line 49, in preload_pages
_add_url_rule([page.url for page in Page.query.all()])
File "/usr/local/lib/python3.6/site-packages/sqlalchemy/orm/query.py", line 3373, in all
return list(self)
File "/usr/local/lib/python3.6/site-packages/sqlalchemy/orm/query.py", line 3535, in __iter__
return self._execute_and_instances(context)
File "/usr/local/lib/python3.6/site-packages/sqlalchemy/orm/query.py", line 3560, in _execute_and_instances
result = conn.execute(querycontext.statement, self._params)
File "/usr/local/lib/python3.6/site-packages/sqlalchemy/engine/base.py", line 1011, in execute
return meth(self, multiparams, params)
File "/usr/local/lib/python3.6/site-packages/sqlalchemy/sql/elements.py", line 298, in _execute_on_connection
return connection._execute_clauseelement(self, multiparams, params)
File "/usr/local/lib/python3.6/site-packages/sqlalchemy/engine/base.py", line 1130, in _execute_clauseelement
distilled_params,
File "/usr/local/lib/python3.6/site-packages/sqlalchemy/engine/base.py", line 1317, in _execute_context
e, statement, parameters, cursor, context
File "/usr/local/lib/python3.6/site-packages/sqlalchemy/engine/base.py", line 1511, in _handle_dbapi_exception
sqlalchemy_exception, with_traceback=exc_info[2], from_=e
File "/usr/local/lib/python3.6/site-packages/sqlalchemy/util/compat.py", line 182, in raise_
raise exception
File "/usr/local/lib/python3.6/site-packages/sqlalchemy/engine/base.py", line 1277, in _execute_context
cursor, statement, parameters, context
File "/usr/local/lib/python3.6/site-packages/sqlalchemy/engine/default.py", line 608, in do_execute
cursor.execute(statement, parameters)
sqlalchemy.exc.ProgrammingError: (psycopg2.errors.UndefinedTable) relation "pages_page" does not exist
LINE 2: FROM pages_page
^
[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
FROM pages_page]
(Background on this error at: http://sqlalche.me/e/13/f405)
[pid: 12|app: 0|req: 2/4] 172.19.0.10 () {40 vars in 433 bytes} [Sat May 28 01:46:18 2022] HEAD /ping => generated 0 bytes in 18 msecs (HTTP/1.1 500) 0 headers in 0 bytes (0 switches on core 1)
[2022-05-28 01:46:23,877] WARNING in views: Pages were not loaded.
Traceback (most recent call last):
File "/usr/local/lib/python3.6/site-packages/sqlalchemy/engine/base.py", line 1277, in _execute_context
cursor, statement, parameters, context
File "/usr/local/lib/python3.6/site-packages/sqlalchemy/engine/default.py", line 608, in do_execute
cursor.execute(statement, parameters)
psycopg2.errors.UndefinedTable: relation "pages_page" does not exist
LINE 2: FROM pages_page
^
The above exception was the direct cause of the following exception:
Traceback (most recent call last):
File "/usr/local/lib/python3.6/site-packages/flask/app.py", line 2091, in __call__
return self.wsgi_app(environ, start_response)
File "/usr/local/lib/python3.6/site-packages/werkzeug/middleware/dispatcher.py", line 78, in __call__
return app(environ, start_response)
File "/usr/local/lib/python3.6/site-packages/flask/app.py", line 2076, in wsgi_app
response = self.handle_exception(e)
File "/usr/local/lib/python3.6/site-packages/flask/app.py", line 2073, in wsgi_app
response = self.full_dispatch_request()
File "/usr/local/lib/python3.6/site-packages/flask/app.py", line 1511, in full_dispatch_request
self.try_trigger_before_first_request_functions()
File "/usr/local/lib/python3.6/site-packages/flask/app.py", line 1563, in try_trigger_before_first_request_functions
self.ensure_sync(func)()
File "/usr/local/lib/python3.6/site-packages/invenio_pages/views.py", line 49, in preload_pages
_add_url_rule([page.url for page in Page.query.all()])
File "/usr/local/lib/python3.6/site-packages/sqlalchemy/orm/query.py", line 3373, in all
return list(self)
File "/usr/local/lib/python3.6/site-packages/sqlalchemy/orm/query.py", line 3535, in __iter__
return self._execute_and_instances(context)
File "/usr/local/lib/python3.6/site-packages/sqlalchemy/orm/query.py", line 3560, in _execute_and_instances
result = conn.execute(querycontext.statement, self._params)
File "/usr/local/lib/python3.6/site-packages/sqlalchemy/engine/base.py", line 1011, in execute
return meth(self, multiparams, params)
File "/usr/local/lib/python3.6/site-packages/sqlalchemy/sql/elements.py", line 298, in _execute_on_connection
return connection._execute_clauseelement(self, multiparams, params)
File "/usr/local/lib/python3.6/site-packages/sqlalchemy/engine/base.py", line 1130, in _execute_clauseelement
distilled_params,
File "/usr/local/lib/python3.6/site-packages/sqlalchemy/engine/base.py", line 1317, in _execute_context
e, statement, parameters, cursor, context
File "/usr/local/lib/python3.6/site-packages/sqlalchemy/engine/base.py", line 1511, in _handle_dbapi_exception
sqlalchemy_exception, with_traceback=exc_info[2], from_=e
File "/usr/local/lib/python3.6/site-packages/sqlalchemy/util/compat.py", line 182, in raise_
raise exception
File "/usr/local/lib/python3.6/site-packages/sqlalchemy/engine/base.py", line 1277, in _execute_context
cursor, statement, parameters, context
File "/usr/local/lib/python3.6/site-packages/sqlalchemy/engine/default.py", line 608, in do_execute
cursor.execute(statement, parameters)
sqlalchemy.exc.ProgrammingError: (psycopg2.errors.UndefinedTable) relation "pages_page" does not exist
LINE 2: FROM pages_page
^
[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
FROM pages_page]
(Background on this error at: http://sqlalche.me/e/13/f405)
[pid: 10|app: 0|req: 3/5] 172.19.0.10 () {40 vars in 433 bytes} [Sat May 28 01:46:23 2022] HEAD /ping => generated 0 bytes in 19 msecs (HTTP/1.1 500) 0 headers in 0 bytes (0 switches on core 1)
[2022-05-28 01:46:26,265] WARNING in views: Pages were not loaded.
Traceback (most recent call last):
File "/usr/local/lib/python3.6/site-packages/sqlalchemy/engine/base.py", line 1277, in _execute_context
cursor, statement, parameters, context
File "/usr/local/lib/python3.6/site-packages/sqlalchemy/engine/default.py", line 608, in do_execute
cursor.execute(statement, parameters)
psycopg2.errors.UndefinedTable: relation "pages_page" does not exist
LINE 2: FROM pages_page
^
The above exception was the direct cause of the following exception:
Traceback (most recent call last):
File "/usr/local/lib/python3.6/site-packages/flask/app.py", line 2091, in __call__
return self.wsgi_app(environ, start_response)
File "/usr/local/lib/python3.6/site-packages/werkzeug/middleware/dispatcher.py", line 78, in __call__
return app(environ, start_response)
File "/usr/local/lib/python3.6/site-packages/flask/app.py", line 2076, in wsgi_app
response = self.handle_exception(e)
File "/usr/local/lib/python3.6/site-packages/flask/app.py", line 2073, in wsgi_app
response = self.full_dispatch_request()
File "/usr/local/lib/python3.6/site-packages/flask/app.py", line 1511, in full_dispatch_request
self.try_trigger_before_first_request_functions()
File "/usr/local/lib/python3.6/site-packages/flask/app.py", line 1563, in try_trigger_before_first_request_functions
self.ensure_sync(func)()
File "/usr/local/lib/python3.6/site-packages/invenio_pages/views.py", line 49, in preload_pages
_add_url_rule([page.url for page in Page.query.all()])
File "/usr/local/lib/python3.6/site-packages/sqlalchemy/orm/query.py", line 3373, in all
return list(self)
File "/usr/local/lib/python3.6/site-packages/sqlalchemy/orm/query.py", line 3535, in __iter__
return self._execute_and_instances(context)
File "/usr/local/lib/python3.6/site-packages/sqlalchemy/orm/query.py", line 3560, in _execute_and_instances
result = conn.execute(querycontext.statement, self._params)
File "/usr/local/lib/python3.6/site-packages/sqlalchemy/engine/base.py", line 1011, in execute
return meth(self, multiparams, params)
File "/usr/local/lib/python3.6/site-packages/sqlalchemy/sql/elements.py", line 298, in _execute_on_connection
return connection._execute_clauseelement(self, multiparams, params)
File "/usr/local/lib/python3.6/site-packages/sqlalchemy/engine/base.py", line 1130, in _execute_clauseelement
distilled_params,
File "/usr/local/lib/python3.6/site-packages/sqlalchemy/engine/base.py", line 1317, in _execute_context
e, statement, parameters, cursor, context
File "/usr/local/lib/python3.6/site-packages/sqlalchemy/engine/base.py", line 1511, in _handle_dbapi_exception
sqlalchemy_exception, with_traceback=exc_info[2], from_=e
File "/usr/local/lib/python3.6/site-packages/sqlalchemy/util/compat.py", line 182, in raise_
raise exception
File "/usr/local/lib/python3.6/site-packages/sqlalchemy/engine/base.py", line 1277, in _execute_context
cursor, statement, parameters, context
File "/usr/local/lib/python3.6/site-packages/sqlalchemy/engine/default.py", line 608, in do_execute
cursor.execute(statement, parameters)
sqlalchemy.exc.ProgrammingError: (psycopg2.errors.UndefinedTable) relation "pages_page" does not exist
LINE 2: FROM pages_page
^
[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
FROM pages_page]
(Background on this error at: http://sqlalche.me/e/13/f405)
[pid: 10|app: 0|req: 4/6] 172.19.0.10 () {40 vars in 433 bytes} [Sat May 28 01:46:26 2022] HEAD /ping => generated 0 bytes in 18 msecs (HTTP/1.1 500) 0 headers in 0 bytes (0 switches on core 0)
[2022-05-28 01:46:28,906] WARNING in views: Pages were not loaded.
Traceback (most recent call last):
File "/usr/local/lib/python3.6/site-packages/sqlalchemy/engine/base.py", line 1277, in _execute_context
cursor, statement, parameters, context
File "/usr/local/lib/python3.6/site-packages/sqlalchemy/engine/default.py", line 608, in do_execute
cursor.execute(statement, parameters)
psycopg2.errors.UndefinedTable: relation "pages_page" does not exist
LINE 2: FROM pages_page
^
The above exception was the direct cause of the following exception:
Traceback (most recent call last):
File "/usr/local/lib/python3.6/site-packages/flask/app.py", line 2091, in __call__
return self.wsgi_app(environ, start_response)
File "/usr/local/lib/python3.6/site-packages/werkzeug/middleware/dispatcher.py", line 78, in __call__
return app(environ, start_response)
File "/usr/local/lib/python3.6/site-packages/flask/app.py", line 2076, in wsgi_app
response = self.handle_exception(e)
File "/usr/local/lib/python3.6/site-packages/flask/app.py", line 2073, in wsgi_app
response = self.full_dispatch_request()
File "/usr/local/lib/python3.6/site-packages/flask/app.py", line 1511, in full_dispatch_request
self.try_trigger_before_first_request_functions()
File "/usr/local/lib/python3.6/site-packages/flask/app.py", line 1563, in try_trigger_before_first_request_functions
self.ensure_sync(func)()
File "/usr/local/lib/python3.6/site-packages/invenio_pages/views.py", line 49, in preload_pages
_add_url_rule([page.url for page in Page.query.all()])
File "/usr/local/lib/python3.6/site-packages/sqlalchemy/orm/query.py", line 3373, in all
return list(self)
File "/usr/local/lib/python3.6/site-packages/sqlalchemy/orm/query.py", line 3535, in __iter__
return self._execute_and_instances(context)
File "/usr/local/lib/python3.6/site-packages/sqlalchemy/orm/query.py", line 3560, in _execute_and_instances
result = conn.execute(querycontext.statement, self._params)
File "/usr/local/lib/python3.6/site-packages/sqlalchemy/engine/base.py", line 1011, in execute
return meth(self, multiparams, params)
File "/usr/local/lib/python3.6/site-packages/sqlalchemy/sql/elements.py", line 298, in _execute_on_connection
return connection._execute_clauseelement(self, multiparams, params)
File "/usr/local/lib/python3.6/site-packages/sqlalchemy/engine/base.py", line 1130, in _execute_clauseelement
distilled_params,
File "/usr/local/lib/python3.6/site-packages/sqlalchemy/engine/base.py", line 1317, in _execute_context
e, statement, parameters, cursor, context
File "/usr/local/lib/python3.6/site-packages/sqlalchemy/engine/base.py", line 1511, in _handle_dbapi_exception
sqlalchemy_exception, with_traceback=exc_info[2], from_=e
File "/usr/local/lib/python3.6/site-packages/sqlalchemy/util/compat.py", line 182, in raise_
raise exception
File "/usr/local/lib/python3.6/site-packages/sqlalchemy/engine/base.py", line 1277, in _execute_context
cursor, statement, parameters, context
File "/usr/local/lib/python3.6/site-packages/sqlalchemy/engine/default.py", line 608, in do_execute
cursor.execute(statement, parameters)
sqlalchemy.exc.ProgrammingError: (psycopg2.errors.UndefinedTable) relation "pages_page" does not exist
LINE 2: FROM pages_page
^
[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
FROM pages_page]
(Background on this error at: http://sqlalche.me/e/13/f405)
[pid: 10|app: 0|req: 5/7] 172.19.0.10 () {40 vars in 433 bytes} [Sat May 28 01:46:28 2022] HEAD /ping => generated 0 bytes in 17 msecs (HTTP/1.1 500) 0 headers in 0 bytes (0 switches on core 1)
...brutally killing workers...
Error in atexit._run_exitfuncs:
Error in atexit._run_exitfuncs:
Traceback (most recent call last):
Traceback (most recent call last):
File "/usr/local/lib/python3.6/logging/__init__.py", line 1945, in shutdown
File "/usr/local/lib/python3.6/logging/__init__.py", line 1945, in shutdown
h.flush()
File "/usr/local/lib/python3.6/logging/__init__.py", line 977, in flush
if self.stream and hasattr(self.stream, "flush"):
File "/usr/local/lib/python3.6/site-packages/werkzeug/local.py", line 436, in __get__
obj = instance._get_current_object()
File "/usr/local/lib/python3.6/site-packages/werkzeug/local.py", line 565, in _get_current_object
h.flush()
File "/usr/local/lib/python3.6/logging/__init__.py", line 977, in flush
return self.__local() # type: ignore
File "/usr/local/lib/python3.6/site-packages/flask/logging.py", line 23, in wsgi_errors_stream
if self.stream and hasattr(self.stream, "flush"):
File "/usr/local/lib/python3.6/site-packages/werkzeug/local.py", line 436, in __get__
return request.environ["wsgi.errors"] if request else sys.stderr
KeyError: 'wsgi.errors'
obj = instance._get_current_object()
File "/usr/local/lib/python3.6/site-packages/werkzeug/local.py", line 565, in _get_current_object
return self.__local() # type: ignore
File "/usr/local/lib/python3.6/site-packages/flask/logging.py", line 23, in wsgi_errors_stream
return request.environ["wsgi.errors"] if request else sys.stderr
KeyError: 'wsgi.errors'
worker 1 buried after 1 seconds
worker 2 buried after 1 seconds
binary reloading uWSGI...
chdir() to /opt/invenio_app_ils/src
closing all non-uwsgi socket fds > 2 (max_fd = 1048576)...
found fd 3 mapped to socket 0 (0.0.0.0:5000)
running /usr/local/bin/uwsgi
*** Starting uWSGI 2.0.20 (64bit) on [Sat May 28 01:46:35 2022] ***
compiled with version: 10.2.1 20210110 on 27 May 2022 03:50:33
os: Linux-5.4.0-113-generic #127-Ubuntu SMP Wed May 18 14:30:56 UTC 2022
nodename: 53ff05f403fe
machine: x86_64
clock source: unix
pcre jit disabled
detected number of CPU cores: 4
current working directory: /opt/invenio_app_ils/src
detected binary path: /usr/local/bin/uwsgi
your memory page size is 4096 bytes
detected max file descriptor number: 1048576
lock engine: pthread robust mutexes
thunder lock: disabled (you can enable it with --thunder-lock)
uwsgi socket 0 inherited INET address 0.0.0.0:5000 fd 3
Python version: 3.6.15 (default, Dec 21 2021, 12:03:22) [GCC 10.2.1 20210110]
Python main interpreter initialized at 0x55d6bed4cb40
python threads support enabled
your server socket listen backlog is limited to 100 connections
your mercy for graceful operations on workers is 60 seconds
mapped 250128 bytes (244 KB) for 4 cores
*** Operational MODE: preforking+threaded ***
/usr/local/lib/python3.6/site-packages/sqlalchemy_utils/types/encrypted/encrypted_type.py:15: CryptographyDeprecationWarning: Python 3.6 is no longer supported by the Python core team. Therefore, support for it is deprecated in cryptography and will be removed in a future release.
import cryptography
joestan@stanleyserv02:~$ ^C