Skip to content

Clean local deployments: tables do not appear to exist #980

@sanjayankur31

Description

@sanjayankur31

When creating a clean local deployment, one gets errors of this form:

[workspaces]     ret = self._execute_context(
[workspaces]           ^^^^^^^^^^^^^^^^^^^^^^                                                                                                                                                 
[workspaces]   File "/usr/local/lib/python3.12/site-packages/sqlalchemy/engine/base.py", line 1953, in _execute_context
[workspaces]     self._handle_dbapi_exception(                                                                                                                                                
[workspaces]   File "/usr/local/lib/python3.12/site-packages/sqlalchemy/engine/base.py", line 2134, in _handle_dbapi_exception
[workspaces]     util.raise_(                                                                                                                                                                 
[workspaces]   File "/usr/local/lib/python3.12/site-packages/sqlalchemy/util/compat.py", line 211, in raise_
[workspaces]     raise exception                                                                                                                                                              
[workspaces]   File "/usr/local/lib/python3.12/site-packages/sqlalchemy/engine/base.py", line 1910, in _execute_context
[workspaces]     self.dialect.do_execute(                                                                                                                                                     
[workspaces]   File "/usr/local/lib/python3.12/site-packages/sqlalchemy/engine/default.py", line 736, in do_execute
[workspaces]     cursor.execute(statement, parameters)                                                                                                                                        
[workspaces] sqlalchemy.exc.ProgrammingError: (psycopg2.errors.UndefinedTable) relation "workspace" does not exist
[workspaces] LINE 2: FROM workspace 

and

[workspaces]   File "/usr/local/lib/python3.12/site-packages/sqlalchemy/engine/base.py", line 1953, in _execute_context
[workspaces]     self._handle_dbapi_exception(
[workspaces]   File "/usr/local/lib/python3.12/site-packages/sqlalchemy/engine/base.py", line 2134, in _handle_dbapi_exception
[workspaces]     util.raise_(
[workspaces]   File "/usr/local/lib/python3.12/site-packages/sqlalchemy/util/compat.py", line 211, in raise_
[workspaces]     raise exception
[workspaces]   File "/usr/local/lib/python3.12/site-packages/sqlalchemy/engine/base.py", line 1910, in _execute_context
[workspaces]     self.dialect.do_execute(
[workspaces]   File "/usr/local/lib/python3.12/site-packages/sqlalchemy/engine/default.py", line 736, in do_execute
[workspaces]     cursor.execute(statement, parameters)
[workspaces] sqlalchemy.exc.ProgrammingError: (psycopg2.errors.UndefinedTable) relation "tag" does not exist
[workspaces] LINE 2: FROM tag
[workspaces]              ^
[workspaces]
[workspaces] [SQL: SELECT tag.id AS tag_id, tag.tag AS tag_tag
[workspaces] FROM tag
[workspaces] WHERE tag.tag = %(tag_1)s
[workspaces]  LIMIT %(param_1)s OFFSET %(param_2)s]
[workspaces] [parameters: {'tag_1': 'cerebellum', 'param_1': 20, 'param_2': 0}]

I can't seem to add a repository here because if this error. Are there some extra steps needed to create these?

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Type

    No type

    Projects

    No projects

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions