Vagrant fails to initialize databases in a fresh VM
When pulling the newest source, running vagrant destroy
, vagrant up
and vagrant provision
results in a VM with a non-working Tildes instance:
sqlalchemy.exc.ProgrammingError: (psycopg2.errors.UndefinedTable) relation "groups" does not exist
LINE 2: FROM groups
^
[SQL: SELECT groups.common_topic_tags AS groups_common_topic_tags, groups.group_id AS groups_group_id, groups.path AS groups_path, groups.created_time AS groups_created_time, groups.short_description AS groups_short_description, groups.num_subscriptions AS groups_num_subscriptions, groups.is_admin_posting_only AS groups_is_admin_posting_only, groups.is_user_treated_as_topic_source AS groups_is_user_treated_as_topic_source
FROM groups]
(Background on this error at: http://sqlalche.me/e/f405)
is shown when attempting to navigate to https://localhost:4443/
Full traceback:
Traceback (most recent call last):
File "/opt/venvs/tildes/lib/python3.7/site-packages/pyramid_debugtoolbar/panels/performance.py", line 58, in resource_timer_handler
result = handler(request)
File "/opt/venvs/tildes/lib/python3.7/site-packages/pyramid_tm/__init__.py", line 171, in tm_tween
reraise(*exc_info)
File "/opt/venvs/tildes/lib/python3.7/site-packages/pyramid_tm/compat.py", line 36, in reraise
raise value
File "/opt/venvs/tildes/lib/python3.7/site-packages/pyramid_tm/__init__.py", line 136, in tm_tween
response = handler(request)
File "/opt/venvs/tildes/lib/python3.7/site-packages/pyramid/tweens.py", line 43, in excview_tween
response = _error_handler(request, exc)
File "/opt/venvs/tildes/lib/python3.7/site-packages/pyramid/tweens.py", line 13, in _error_handler
response = request.invoke_exception_view(exc_info)
File "/opt/venvs/tildes/lib/python3.7/site-packages/pyramid/view.py", line 767, in invoke_exception_view
request_iface=request_iface.combined,
File "/opt/venvs/tildes/lib/python3.7/site-packages/pyramid/view.py", line 667, in _call_view
response = view_callable(context, request)
File "/opt/venvs/tildes/lib/python3.7/site-packages/pyramid/viewderivers.py", line 401, in viewresult_to_response
result = view(context, request)
File "/opt/venvs/tildes/lib/python3.7/site-packages/pyramid/tweens.py", line 41, in excview_tween
response = handler(request)
File "/opt/venvs/tildes/lib/python3.7/site-packages/pyramid/router.py", line 148, in handle_request
registry, request, context, context_iface, view_name
File "/opt/venvs/tildes/lib/python3.7/site-packages/pyramid/view.py", line 667, in _call_view
response = view_callable(context, request)
File "/opt/venvs/tildes/lib/python3.7/site-packages/pyramid/viewderivers.py", line 325, in secured_view
return view(context, request)
File "/opt/venvs/tildes/lib/python3.7/site-packages/pyramid/viewderivers.py", line 514, in csrf_view
return view(context, request)
File "/opt/venvs/tildes/lib/python3.7/site-packages/pyramid/viewderivers.py", line 436, in rendered_view
result = view(context, request)
File "/opt/venvs/tildes/lib/python3.7/site-packages/pyramid/viewderivers.py", line 144, in _requestonly_view
response = view(request)
File "/opt/venvs/tildes/lib/python3.7/site-packages/webargs/pyramidparser.py", line 146, in wrapper
return func(obj, *args, **kwargs)
File "/opt/tildes/tildes/views/topic.py", line 117, in get_group_topics
group for group in request.query(Group).all() if group.path != "test"
File "/opt/venvs/tildes/lib/python3.7/site-packages/sqlalchemy/orm/query.py", line 3161, in all
return list(self)
File "/opt/tildes/tildes/models/model_query.py", line 40, in __iter__
results = super().__iter__()
File "/opt/venvs/tildes/lib/python3.7/site-packages/sqlalchemy/orm/query.py", line 3317, in __iter__
return self._execute_and_instances(context)
File "/opt/venvs/tildes/lib/python3.7/site-packages/sqlalchemy/orm/query.py", line 3342, in _execute_and_instances
result = conn.execute(querycontext.statement, self._params)
File "/opt/venvs/tildes/lib/python3.7/site-packages/sqlalchemy/engine/base.py", line 988, in execute
return meth(self, multiparams, params)
File "/opt/venvs/tildes/lib/python3.7/site-packages/sqlalchemy/sql/elements.py", line 287, in _execute_on_connection
return connection._execute_clauseelement(self, multiparams, params)
File "/opt/venvs/tildes/lib/python3.7/site-packages/sqlalchemy/engine/base.py", line 1107, in _execute_clauseelement
distilled_params,
File "/opt/venvs/tildes/lib/python3.7/site-packages/sqlalchemy/engine/base.py", line 1248, in _execute_context
e, statement, parameters, cursor, context
File "/opt/venvs/tildes/lib/python3.7/site-packages/sqlalchemy/engine/base.py", line 1466, in _handle_dbapi_exception
util.raise_from_cause(sqlalchemy_exception, exc_info)
File "/opt/venvs/tildes/lib/python3.7/site-packages/sqlalchemy/util/compat.py", line 383, in raise_from_cause
reraise(type(exception), exception, tb=exc_tb, cause=cause)
File "/opt/venvs/tildes/lib/python3.7/site-packages/sqlalchemy/util/compat.py", line 128, in reraise
raise value.with_traceback(tb)
File "/opt/venvs/tildes/lib/python3.7/site-packages/sqlalchemy/engine/base.py", line 1244, in _execute_context
cursor, statement, parameters, context
File "/opt/venvs/tildes/lib/python3.7/site-packages/sqlalchemy/engine/default.py", line 552, in do_execute
cursor.execute(statement, parameters)
sqlalchemy.exc.ProgrammingError: (psycopg2.errors.UndefinedTable) relation "groups" does not exist
LINE 2: FROM groups
^
[SQL: SELECT groups.common_topic_tags AS groups_common_topic_tags, groups.group_id AS groups_group_id, groups.path AS groups_path, groups.created_time AS groups_created_time, groups.short_description AS groups_short_description, groups.num_subscriptions AS groups_num_subscriptions, groups.is_admin_posting_only AS groups_is_admin_posting_only, groups.is_user_treated_as_topic_source AS groups_is_user_treated_as_topic_source
FROM groups]
(Background on this error at: http://sqlalche.me/e/f405)
Operating System: openSUSE Tumbleweed 20190524-0
Edited by Cassidy Dingenskirchen