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.

Sign up for GitHub

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

Jump to bottom

Update setup.sh to create DB user with a password #113

Open
ykeremy opened this issue Mar 19, 2024 · 7 comments
Open

Update setup.sh to create DB user with a password #113

ykeremy opened this issue Mar 19, 2024 · 7 comments
Labels
bug Something isn't working P1

Comments

@ykeremy
Copy link
Contributor

ykeremy commented Mar 19, 2024 •
edited

I saw a couple of cases on Discord where re-creating the postgresql user with a password solved some issues.

References:
@ryanholtschneider2
Copy link

I am having what sounds like a similar issue -
/var/run/postgresql:5432 - accepting connections
PostgreSQL is already running locally.
psql: error: connection to server on socket "/var/run/postgresql/.s.PGSQL.5432" failed: FATAL: Peer authentication failed for user "skyvern"
createuser: error: connection to server on socket "/var/run/postgresql/.s.PGSQL.5432" failed: FATAL: role "ryan" does not exist
createdb: error: connection to server on socket "/var/run/postgresql/.s.PGSQL.5432" failed: FATAL: role "ryan" does not exist
Database and user created successfully.
Installing playwright dependencies...
Running Alembic upgrade...
Alembic mode: online
Traceback (most recent call last):
File "/home/ryan/.cache/pypoetry/virtualenvs/skyvern-ckmzeAJa-py3.11/lib/python3.11/site-packages/sqlalchemy/engine/base.py", line 145, in init
self._dbapi_connection = engine.raw_connection()
^^^^^^^^^^^^^^^^^^^^^^^
File "/home/ryan/.cache/pypoetry/virtualenvs/skyvern-ckmzeAJa-py3.11/lib/python3.11/site-packages/sqlalchemy/engine/base.py", line 3303, in raw_connection
return self.pool.connect()
^^^^^^^^^^^^^^^^^^^
File "/home/ryan/.cache/pypoetry/virtualenvs/skyvern-ckmzeAJa-py3.11/lib/python3.11/site-packages/sqlalchemy/pool/base.py", line 449, in connect
return _ConnectionFairy._checkout(self)
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "/home/ryan/.cache/pypoetry/virtualenvs/skyvern-ckmzeAJa-py3.11/lib/python3.11/site-packages/sqlalchemy/pool/base.py", line 1263, in _checkout
fairy = _ConnectionRecord.checkout(pool)
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "/home/ryan/.cache/pypoetry/virtualenvs/skyvern-ckmzeAJa-py3.11/lib/python3.11/site-packages/sqlalchemy/pool/base.py", line 712, in checkout
rec = pool._do_get()
^^^^^^^^^^^^^^
File "/home/ryan/.cache/pypoetry/virtualenvs/skyvern-ckmzeAJa-py3.11/lib/python3.11/site-packages/sqlalchemy/pool/impl.py", line 308, in _do_get
return self._create_connection()
^^^^^^^^^^^^^^^^^^^^^^^^^
File "/home/ryan/.cache/pypoetry/virtualenvs/skyvern-ckmzeAJa-py3.11/lib/python3.11/site-packages/sqlalchemy/pool/base.py", line 390, in _create_connection
return _ConnectionRecord(self)
^^^^^^^^^^^^^^^^^^^^^^^
File "/home/ryan/.cache/pypoetry/virtualenvs/skyvern-ckmzeAJa-py3.11/lib/python3.11/site-packages/sqlalchemy/pool/base.py", line 674, in init
self.__connect()
File "/home/ryan/.cache/pypoetry/virtualenvs/skyvern-ckmzeAJa-py3.11/lib/python3.11/site-packages/sqlalchemy/pool/base.py", line 900, in __connect
with util.safe_reraise():
File "/home/ryan/.cache/pypoetry/virtualenvs/skyvern-ckmzeAJa-py3.11/lib/python3.11/site-packages/sqlalchemy/util/langhelpers.py", line 146, in exit
raise exc_value.with_traceback(exc_tb)
File "/home/ryan/.cache/pypoetry/virtualenvs/skyvern-ckmzeAJa-py3.11/lib/python3.11/site-packages/sqlalchemy/pool/base.py", line 896, in __connect
self.dbapi_connection = connection = pool._invoke_creator(self)
^^^^^^^^^^^^^^^^^^^^^^^^^^
File "/home/ryan/.cache/pypoetry/virtualenvs/skyvern-ckmzeAJa-py3.11/lib/python3.11/site-packages/sqlalchemy/engine/create.py", line 643, in connect
return dialect.connect(*cargs, **cparams)
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "/home/ryan/.cache/pypoetry/virtualenvs/skyvern-ckmzeAJa-py3.11/lib/python3.11/site-packages/sqlalchemy/engine/default.py", line 616, in connect
return self.loaded_dbapi.connect(*cargs, **cparams)
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "/home/ryan/.cache/pypoetry/virtualenvs/skyvern-ckmzeAJa-py3.11/lib/python3.11/site-packages/psycopg/connection.py", line 748, in connect
raise last_ex.with_traceback(None)
psycopg.OperationalError: connection failed: fe_sendauth: no password supplied

The above exception was the direct cause of the following exception:

Traceback (most recent call last):
File "/home/ryan/.cache/pypoetry/virtualenvs/skyvern-ckmzeAJa-py3.11/bin/alembic", line 8, in
sys.exit(main())
^^^^^^
File "/home/ryan/.cache/pypoetry/virtualenvs/skyvern-ckmzeAJa-py3.11/lib/python3.11/site-packages/alembic/config.py", line 641, in main
CommandLine(prog=prog).main(argv=argv)
File "/home/ryan/.cache/pypoetry/virtualenvs/skyvern-ckmzeAJa-py3.11/lib/python3.11/site-packages/alembic/config.py", line 631, in main
self.run_cmd(cfg, options)
File "/home/ryan/.cache/pypoetry/virtualenvs/skyvern-ckmzeAJa-py3.11/lib/python3.11/site-packages/alembic/config.py", line 608, in run_cmd
fn(
File "/home/ryan/.cache/pypoetry/virtualenvs/skyvern-ckmzeAJa-py3.11/lib/python3.11/site-packages/alembic/command.py", line 403, in upgrade
script.run_env()
File "/home/ryan/.cache/pypoetry/virtualenvs/skyvern-ckmzeAJa-py3.11/lib/python3.11/site-packages/alembic/script/base.py", line 583, in run_env
util.load_python_file(self.dir, "env.py")
File "/home/ryan/.cache/pypoetry/virtualenvs/skyvern-ckmzeAJa-py3.11/lib/python3.11/site-packages/alembic/util/pyfiles.py", line 95, in load_python_file
module = load_module_py(module_id, path)
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "/home/ryan/.cache/pypoetry/virtualenvs/skyvern-ckmzeAJa-py3.11/lib/python3.11/site-packages/alembic/util/pyfiles.py", line 113, in load_module_py
spec.loader.exec_module(module) # type: ignore
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "", line 940, in exec_module
File "", line 241, in _call_with_frames_removed
File "/media/storage/Code/skyvern/alembic/env.py", line 81, in
run_migrations_online()
File "/media/storage/Code/skyvern/alembic/env.py", line 70, in run_migrations_online
with connectable.connect() as connection:
^^^^^^^^^^^^^^^^^^^^^
File "/home/ryan/.cache/pypoetry/virtualenvs/skyvern-ckmzeAJa-py3.11/lib/python3.11/site-packages/sqlalchemy/engine/base.py", line 3279, in connect
return self._connection_cls(self)
^^^^^^^^^^^^^^^^^^^^^^^^^^
File "/home/ryan/.cache/pypoetry/virtualenvs/skyvern-ckmzeAJa-py3.11/lib/python3.11/site-packages/sqlalchemy/engine/base.py", line 147, in init
Connection._handle_dbapi_exception_noconnection(
File "/home/ryan/.cache/pypoetry/virtualenvs/skyvern-ckmzeAJa-py3.11/lib/python3.11/site-packages/sqlalchemy/engine/base.py", line 2443, in _handle_dbapi_exception_noconnection
raise sqlalchemy_exception.with_traceback(exc_info[2]) from e
File "/home/ryan/.cache/pypoetry/virtualenvs/skyvern-ckmzeAJa-py3.11/lib/python3.11/site-packages/sqlalchemy/engine/base.py", line 145, in init
self._dbapi_connection = engine.raw_connection()
^^^^^^^^^^^^^^^^^^^^^^^
File "/home/ryan/.cache/pypoetry/virtualenvs/skyvern-ckmzeAJa-py3.11/lib/python3.11/site-packages/sqlalchemy/engine/base.py", line 3303, in raw_connection
return self.pool.connect()
^^^^^^^^^^^^^^^^^^^
File "/home/ryan/.cache/pypoetry/virtualenvs/skyvern-ckmzeAJa-py3.11/lib/python3.11/site-packages/sqlalchemy/pool/base.py", line 449, in connect
return _ConnectionFairy._checkout(self)
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "/home/ryan/.cache/pypoetry/virtualenvs/skyvern-ckmzeAJa-py3.11/lib/python3.11/site-packages/sqlalchemy/pool/base.py", line 1263, in _checkout
fairy = _ConnectionRecord.checkout(pool)
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "/home/ryan/.cache/pypoetry/virtualenvs/skyvern-ckmzeAJa-py3.11/lib/python3.11/site-packages/sqlalchemy/pool/base.py", line 712, in checkout
rec = pool._do_get()
^^^^^^^^^^^^^^
File "/home/ryan/.cache/pypoetry/virtualenvs/skyvern-ckmzeAJa-py3.11/lib/python3.11/site-packages/sqlalchemy/pool/impl.py", line 308, in _do_get
return self._create_connection()
^^^^^^^^^^^^^^^^^^^^^^^^^
File "/home/ryan/.cache/pypoetry/virtualenvs/skyvern-ckmzeAJa-py3.11/lib/python3.11/site-packages/sqlalchemy/pool/base.py", line 390, in _create_connection
return _ConnectionRecord(self)
^^^^^^^^^^^^^^^^^^^^^^^
File "/home/ryan/.cache/pypoetry/virtualenvs/skyvern-ckmzeAJa-py3.11/lib/python3.11/site-packages/sqlalchemy/pool/base.py", line 674, in init
self.__connect()
File "/home/ryan/.cache/pypoetry/virtualenvs/skyvern-ckmzeAJa-py3.11/lib/python3.11/site-packages/sqlalchemy/pool/base.py", line 900, in __connect
with util.safe_reraise():
File "/home/ryan/.cache/pypoetry/virtualenvs/skyvern-ckmzeAJa-py3.11/lib/python3.11/site-packages/sqlalchemy/util/langhelpers.py", line 146, in exit
raise exc_value.with_traceback(exc_tb)
File "/home/ryan/.cache/pypoetry/virtualenvs/skyvern-ckmzeAJa-py3.11/lib/python3.11/site-packages/sqlalchemy/pool/base.py", line 896, in __connect
self.dbapi_connection = connection = pool._invoke_creator(self)
^^^^^^^^^^^^^^^^^^^^^^^^^^
File "/home/ryan/.cache/pypoetry/virtualenvs/skyvern-ckmzeAJa-py3.11/lib/python3.11/site-packages/sqlalchemy/engine/create.py", line 643, in connect
return dialect.connect(*cargs, **cparams)
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "/home/ryan/.cache/pypoetry/virtualenvs/skyvern-ckmzeAJa-py3.11/lib/python3.11/site-packages/sqlalchemy/engine/default.py", line 616, in connect
return self.loaded_dbapi.connect(*cargs, **cparams)
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "/home/ryan/.cache/pypoetry/virtualenvs/skyvern-ckmzeAJa-py3.11/lib/python3.11/site-packages/psycopg/connection.py", line 748, in connect
raise last_ex.with_traceback(None)
sqlalchemy.exc.OperationalError: (psycopg.OperationalError) connection failed: fe_sendauth: no password supplied
(Background on this error at: https://sqlalche.me/e/20/e3q8)
Creating organization and API token...
/home/ryan/.cache/pypoetry/virtualenvs/skyvern-ckmzeAJa-py3.11/lib/python3.11/site-packages/pydantic/_internal/fields.py:151: UserWarning: Field "model_max_budget" has conflict with protected namespace "model".

You may be able to resolve this warning by setting model_config['protected_namespaces'] = ().
warnings.warn(
╭─────────────────────────────── Traceback (most recent call last) ────────────────────────────────╮
│ /home/ryan/.cache/pypoetry/virtualenvs/skyvern-ckmzeAJa-py3.11/lib/python3.11/site-packages/sqla │
│ lchemy/engine/base.py:145 in init │
│ │
│ 142 │ │ │
│ 143 │ │ if connection is None: │
│ 144 │ │ │ try: │
│ ❱ 145 │ │ │ │ self._dbapi_connection = engine.raw_connection() │
│ 146 │ │ │ except dialect.loaded_dbapi.Error as err: │
│ 147 │ │ │ │ Connection._handle_dbapi_exception_noconnection( │
│ 148 │ │ │ │ │ err, dialect, engine │
│ │
│ ╭─────────────────────────────────────────── locals ───────────────────────────────────────────╮ │
│ │ _allow_autobegin = True │ │
│ │ _allow_revalidate = True │ │
│ │ _has_events = None │ │
│ │ connection = None │ │
│ │ dialect = <sqlalchemy.dialects.postgresql.psycopg.PGDialect_psycopg object at │ │
│ │ 0x7f9fd0407f10> │ │
│ │ engine = Engine(postgresql+psycopg://skyvern@localhost/skyvern) │ │
│ │ self = <sqlalchemy.engine.base.Connection object at 0x7f9fc8ad3990> │ │
│ ╰──────────────────────────────────────────────────────────────────────────────────────────────╯ │
│ │
│ /home/ryan/.cache/pypoetry/virtualenvs/skyvern-ckmzeAJa-py3.11/lib/python3.11/site-packages/sqla │
│ lchemy/engine/base.py:3303 in raw_connection │
│ │
│ 3300 │ │ │ :ref:dbapi_connections │
│ 3301 │ │ │
│ 3302 │ │ """ │
│ ❱ 3303 │ │ return self.pool.connect() │
│ 3304 │
│ 3305 │
│ 3306 class OptionEngineMixin(log.Identified): │
│ │
│ ╭─────────────────────────── locals ────────────────────────────╮ │
│ │ self = Engine(postgresql+psycopg://skyvern@localhost/skyvern) │ │
│ ╰───────────────────────────────────────────────────────────────╯ │
│ │
│ /home/ryan/.cache/pypoetry/virtualenvs/skyvern-ckmzeAJa-py3.11/lib/python3.11/site-packages/sqla │
│ lchemy/pool/base.py:449 in connect │
│ │
│ 446 │ │ the pool. │
│ 447 │ │ │
│ 448 │ │ """ │
│ ❱ 449 │ │ return _ConnectionFairy._checkout(self) │
│ 450 │ │
│ 451 │ def _return_conn(self, record: ConnectionPoolEntry) -> None: │
│ 452 │ │ """Given a _ConnectionRecord, return it to the :class:_pool.Pool. │
│ │
│ ╭───────────────────────────── locals ─────────────────────────────╮ │
│ │ self = <sqlalchemy.pool.impl.QueuePool object at 0x7f9fc8bd3490> │ │
│ ╰──────────────────────────────────────────────────────────────────╯ │
│ │
│ /home/ryan/.cache/pypoetry/virtualenvs/skyvern-ckmzeAJa-py3.11/lib/python3.11/site-packages/sqla │
│ lchemy/pool/base.py:1263 in _checkout │
│ │
│ 1260 │ │ fairy: Optional[_ConnectionFairy] = None, │
│ 1261 │ ) -> _ConnectionFairy: │
│ 1262 │ │ if not fairy: │
│ ❱ 1263 │ │ │ fairy = _ConnectionRecord.checkout(pool) │
│ 1264 │ │ │ │
│ 1265 │ │ │ if threadconns is not None: │
│ 1266 │ │ │ │ threadconns.current = weakref.ref(fairy) │
│ │
│ ╭──────────────────────────────── locals ─────────────────────────────────╮ │
│ │ cls = <class 'sqlalchemy.pool.base._ConnectionFairy'> │ │
│ │ fairy = None │ │
│ │ pool = <sqlalchemy.pool.impl.QueuePool object at 0x7f9fc8bd3490> │ │
│ │ threadconns = None │ │
│ ╰─────────────────────────────────────────────────────────────────────────╯ │
│ │
│ /home/ryan/.cache/pypoetry/virtualenvs/skyvern-ckmzeAJa-py3.11/lib/python3.11/site-packages/sqla │
│ lchemy/pool/base.py:712 in checkout │
│ │
│ 709 │ │ if TYPE_CHECKING: │
│ 710 │ │ │ rec = cast(_ConnectionRecord, pool._do_get()) │
│ 711 │ │ else: │
│ ❱ 712 │ │ │ rec = pool._do_get() │
│ 713 │ │ │
│ 714 │ │ try: │
│ 715 │ │ │ dbapi_connection = rec.get_connection() │
│ │
│ ╭───────────────────────────── locals ─────────────────────────────╮ │
│ │ cls = <class 'sqlalchemy.pool.base._ConnectionRecord'> │ │
│ │ pool = <sqlalchemy.pool.impl.QueuePool object at 0x7f9fc8bd3490> │ │
│ ╰──────────────────────────────────────────────────────────────────╯ │
│ │
│ /home/ryan/.cache/pypoetry/virtualenvs/skyvern-ckmzeAJa-py3.11/lib/python3.11/site-packages/sqla │
│ lchemy/pool/impl.py:179 in _do_get │
│ │
│ 176 │ │ │ try: │
│ 177 │ │ │ │ return self._create_connection() │
│ 178 │ │ │ except: │
│ ❱ 179 │ │ │ │ with util.safe_reraise(): │
│ 180 │ │ │ │ │ self._dec_overflow() │
│ 181 │ │ │ │ raise │
│ 182 │ │ else: │
│ │
│ ╭───────────────────────────────── locals ─────────────────────────────────╮ │
│ │ self = <sqlalchemy.pool.impl.QueuePool object at 0x7f9fc8bd3490> │ │
│ │ use_overflow = True │ │
│ │ wait = False │ │
│ ╰──────────────────────────────────────────────────────────────────────────╯ │
│ │
│ /home/ryan/.cache/pypoetry/virtualenvs/skyvern-ckmzeAJa-py3.11/lib/python3.11/site-packages/sqla │
│ lchemy/util/langhelpers.py:146 in exit │
│ │
│ 143 │ │ │ exc_type, exc_value, exc_tb = self._exc_info │
│ 144 │ │ │ assert exc_value is not None │
│ 145 │ │ │ self._exc_info = None # remove potential circular references │
│ ❱ 146 │ │ │ raise exc_value.with_traceback(exc_tb) │
│ 147 │ │ else: │
│ 148 │ │ │ self.exc_info = None # remove potential circular references │
│ 149 │ │ │ assert value is not None │
│ │
│ ╭─────────────────────────────────────── locals ───────────────────────────────────────╮ │
│ │ exc_tb = <traceback object at 0x7f9fc8ade300> │ │
│ │ exc_type = <class 'psycopg.OperationalError'> │ │
│ │ exc_value = OperationalError('connection failed: fe_sendauth: no password supplied') │ │
│ │ self = <sqlalchemy.util.langhelpers.safe_reraise object at 0x7f9fc8ac8eb0> │ │
│ │ traceback = None │ │
│ │ type = None │ │
│ │ value = None │ │
│ ╰──────────────────────────────────────────────────────────────────────────────────────╯ │
│ │
│ /home/ryan/.cache/pypoetry/virtualenvs/skyvern-ckmzeAJa-py3.11/lib/python3.11/site-packages/sqla │
│ lchemy/pool/impl.py:177 in _do_get │
│ │
│ 174 │ │ │
│ 175 │ │ if self._inc_overflow(): │
│ 176 │ │ │ try: │
│ ❱ 177 │ │ │ │ return self._create_connection() │
│ 178 │ │ │ except: │
│ 179 │ │ │ │ with util.safe_reraise(): │
│ 180 │ │ │ │ │ self._dec_overflow() │
│ │
│ ╭───────────────────────────────── locals ─────────────────────────────────╮ │
│ │ self = <sqlalchemy.pool.impl.QueuePool object at 0x7f9fc8bd3490> │ │
│ │ use_overflow = True │ │
│ │ wait = False │ │
│ ╰──────────────────────────────────────────────────────────────────────────╯ │
│ │
│ /home/ryan/.cache/pypoetry/virtualenvs/skyvern-ckmzeAJa-py3.11/lib/python3.11/site-packages/sqla │
│ lchemy/pool/base.py:390 in _create_connection │
│ │
│ 387 │ def _create_connection(self) -> ConnectionPoolEntry: │
│ 388 │ │ """Called by subclasses to create a new ConnectionRecord.""" │
│ 389 │ │ │
│ ❱ 390 │ │ return _ConnectionRecord(self) │
│ 391 │ │
│ 392 │ def _invalidate( │
│ 393 │ │ self, │
│ │
│ ╭───────────────────────────── locals ─────────────────────────────╮ │
│ │ self = <sqlalchemy.pool.impl.QueuePool object at 0x7f9fc8bd3490> │ │
│ ╰──────────────────────────────────────────────────────────────────╯ │
│ │
│ /home/ryan/.cache/pypoetry/virtualenvs/skyvern-ckmzeAJa-py3.11/lib/python3.11/site-packages/sqla │
│ lchemy/pool/base.py:674 in init │
│ │
│ 671 │ │ │
│ 672 │ │ self.__pool = pool │
│ 673 │ │ if connect: │
│ ❱ 674 │ │ │ self.__connect() │
│ 675 │ │ self.finalize_callback = deque() │
│ 676 │ │
│ 677 │ dbapi_connection: Optional[DBAPIConnection] │
│ │
│ ╭────────────────────────────────── locals ───────────────────────────────────╮ │
│ │ connect = True │ │
│ │ pool = <sqlalchemy.pool.impl.QueuePool object at 0x7f9fc8bd3490> │ │
│ │ self = <sqlalchemy.pool.base._ConnectionRecord object at 0x7f9fca45fee0> │ │
│ ╰─────────────────────────────────────────────────────────────────────────────╯ │
│ │
│ /home/ryan/.cache/pypoetry/virtualenvs/skyvern-ckmzeAJa-py3.11/lib/python3.11/site-packages/sqla │
│ lchemy/pool/base.py:900 in __connect │
│ │
│ 897 │ │ │ pool.logger.debug("Created new connection %r", connection) │
│ 898 │ │ │ self.fresh = True │
│ 899 │ │ except BaseException as e: │
│ ❱ 900 │ │ │ with util.safe_reraise(): │
│ 901 │ │ │ │ pool.logger.debug("Error on connect(): %s", e) │
│ 902 │ │ else: │
│ 903 │ │ │ # in SQLAlchemy 1.4 the first_connect event is not used by │
│ │
│ ╭───────────────────────────────── locals ─────────────────────────────────╮ │
│ │ pool = <sqlalchemy.pool.impl.QueuePool object at 0x7f9fc8bd3490> │ │
│ │ self = <sqlalchemy.pool.base._ConnectionRecord object at 0x7f9fca45fee0> │ │
│ ╰──────────────────────────────────────────────────────────────────────────╯ │
│ │
│ /home/ryan/.cache/pypoetry/virtualenvs/skyvern-ckmzeAJa-py3.11/lib/python3.11/site-packages/sqla │
│ lchemy/util/langhelpers.py:146 in exit │
│ │
│ 143 │ │ │ exc_type, exc_value, exc_tb = self._exc_info │
│ 144 │ │ │ assert exc_value is not None │
│ 145 │ │ │ self._exc_info = None # remove potential circular references │
│ ❱ 146 │ │ │ raise exc_value.with_traceback(exc_tb) │
│ 147 │ │ else: │
│ 148 │ │ │ self.exc_info = None # remove potential circular references │
│ 149 │ │ │ assert value is not None │
│ │
│ ╭─────────────────────────────────────── locals ───────────────────────────────────────╮ │
│ │ exc_tb = <traceback object at 0x7f9fc8ad3e00> │ │
│ │ exc_type = <class 'psycopg.OperationalError'> │ │
│ │ exc_value = OperationalError('connection failed: fe_sendauth: no password supplied') │ │
│ │ self = <sqlalchemy.util.langhelpers.safe_reraise object at 0x7f9fc8ac8040> │ │
│ │ traceback = None │ │
│ │ type = None │ │
│ │ value = None │ │
│ ╰──────────────────────────────────────────────────────────────────────────────────────╯ │
│ │
│ /home/ryan/.cache/pypoetry/virtualenvs/skyvern-ckmzeAJa-py3.11/lib/python3.11/site-packages/sqla │
│ lchemy/pool/base.py:896 in __connect │
│ │
│ 893 │ │ self.dbapi_connection = None │
│ 894 │ │ try: │
│ 895 │ │ │ self.starttime = time.time() │
│ ❱ 896 │ │ │ self.dbapi_connection = connection = pool._invoke_creator(self) │
│ 897 │ │ │ pool.logger.debug("Created new connection %r", connection) │
│ 898 │ │ │ self.fresh = True │
│ 899 │ │ except BaseException as e: │
│ │
│ ╭───────────────────────────────── locals ─────────────────────────────────╮ │
│ │ pool = <sqlalchemy.pool.impl.QueuePool object at 0x7f9fc8bd3490> │ │
│ │ self = <sqlalchemy.pool.base._ConnectionRecord object at 0x7f9fca45fee0> │ │
│ ╰──────────────────────────────────────────────────────────────────────────╯ │
│ │
│ /home/ryan/.cache/pypoetry/virtualenvs/skyvern-ckmzeAJa-py3.11/lib/python3.11/site-packages/sqla │
│ lchemy/engine/create.py:643 in connect │
│ │
│ 640 │ │ │ │ │ if connection is not None: │
│ 641 │ │ │ │ │ │ return connection │
│ 642 │ │ │ │
│ ❱ 643 │ │ │ return dialect.connect(*cargs, **cparams) │
│ 644 │ │ │
│ 645 │ │ creator = pop_kwarg("creator", connect) │
│ 646 │
│ │
│ ╭─────────────────────────────────────────── locals ───────────────────────────────────────────╮ │
│ │ cargs = [] │ │
│ │ connection_record = <sqlalchemy.pool.base._ConnectionRecord object at 0x7f9fca45fee0> │ │
│ │ cparams = { │ │
│ │ │ 'host': 'localhost', │ │
│ │ │ 'dbname': 'skyvern', │ │
│ │ │ 'user': 'skyvern', │ │
│ │ │ 'context': <psycopg.adapt.AdaptersMap object at 0x7f9fc8bd2fd0> │ │
│ │ } │ │
│ │ dialect = <sqlalchemy.dialects.postgresql.psycopg.PGDialect_psycopg object at │ │
│ │ 0x7f9fd0407f10> │ │
│ ╰──────────────────────────────────────────────────────────────────────────────────────────────╯ │
│ │
│ /home/ryan/.cache/pypoetry/virtualenvs/skyvern-ckmzeAJa-py3.11/lib/python3.11/site-packages/sqla │
│ lchemy/engine/default.py:616 in connect │
│ │
│ 613 │ │
│ 614 │ def connect(self, *cargs, **cparams): │
│ 615 │ │ # inherits the docstring from interfaces.Dialect.connect │
│ ❱ 616 │ │ return self.loaded_dbapi.connect(*cargs, **cparams) │
│ 617 │ │
│ 618 │ def create_connect_args(self, url): │
│ 619 │ │ # inherits the docstring from interfaces.Dialect.create_connect_args │
│ │
│ ╭─────────────────────────────────────────── locals ───────────────────────────────────────────╮ │
│ │ cargs = () │ │
│ │ cparams = { │ │
│ │ │ 'host': 'localhost', │ │
│ │ │ 'dbname': 'skyvern', │ │
│ │ │ 'user': 'skyvern', │ │
│ │ │ 'context': <psycopg.adapt.AdaptersMap object at 0x7f9fc8bd2fd0> │ │
│ │ } │ │
│ │ self = <sqlalchemy.dialects.postgresql.psycopg.PGDialect_psycopg object at │ │
│ │ 0x7f9fd0407f10> │ │
│ ╰──────────────────────────────────────────────────────────────────────────────────────────────╯ │
│ │
│ /home/ryan/.cache/pypoetry/virtualenvs/skyvern-ckmzeAJa-py3.11/lib/python3.11/site-packages/psyc │
│ opg/connection.py:748 in connect │
│ │
│ 745 │ │ │
│ 746 │ │ if not rv: │
│ 747 │ │ │ assert last_ex │
│ ❱ 748 │ │ │ raise last_ex.with_traceback(None) │
│ 749 │ │ │
│ 750 │ │ rv._autocommit = bool(autocommit) │
│ 751 │ │ if row_factory: │
│ │
│ ╭─────────────────────────────────────────── locals ───────────────────────────────────────────╮ │
│ │ attempt = { │ │
│ │ │ 'host': 'localhost', │ │
│ │ │ 'dbname': 'skyvern', │ │
│ │ │ 'user': 'skyvern', │ │
│ │ │ 'hostaddr': '127.0.0.1' │ │
│ │ } │ │
│ │ attempts = [ │ │
│ │ │ { │ │
│ │ │ │ 'host': 'localhost', │ │
│ │ │ │ 'dbname': 'skyvern', │ │
│ │ │ │ 'user': 'skyvern', │ │
│ │ │ │ 'hostaddr': '127.0.0.1' │ │
│ │ │ } │ │
│ │ ] │ │
│ │ autocommit = False │ │
│ │ cls = <class 'psycopg.Connection'> │ │
│ │ conninfo = 'host=localhost dbname=skyvern user=skyvern hostaddr=127.0.0.1' │ │
│ │ context = <psycopg.adapt.AdaptersMap object at 0x7f9fc8bd2fd0> │ │
│ │ cursor_factory = None │ │
│ │ kwargs = {'host': 'localhost', 'dbname': 'skyvern', 'user': 'skyvern'} │ │
│ │ last_ex = OperationalError('connection failed: fe_sendauth: no password supplied') │ │
│ │ params = {'host': 'localhost', 'dbname': 'skyvern', 'user': 'skyvern'} │ │
│ │ prepare_threshold = 5 │ │
│ │ row_factory = None │ │
│ │ rv = None │ │
│ │ timeout = 130 │ │
│ ╰──────────────────────────────────────────────────────────────────────────────────────────────╯ │
╰──────────────────────────────────────────────────────────────────────────────────────────────────╯
OperationalError: connection failed: fe_sendauth: no password supplied

The above exception was the direct cause of the following exception:

╭─────────────────────────────── Traceback (most recent call last) ────────────────────────────────╮
│ /media/storage/Code/skyvern/scripts/create_organization.py:17 in main │
│ │
│ 14 │
│ 15 │
│ 16 def main(org_name: str, webhook_callback_url: Annotated[Optional[str], typer.Argument()] │
│ ❱ 17 │ asyncio.run(create_org(org_name, webhook_callback_url)) │
│ 18 │
│ 19 │
│ 20 if name == "main": │
│ │
│ ╭─────────────────── locals ───────────────────╮ │
│ │ org_name = 'Skyvern-Open-Source' │ │
│ │ webhook_callback_url = None │ │
│ ╰──────────────────────────────────────────────╯ │
│ │
│ /usr/lib/python3.11/asyncio/runners.py:190 in run │
│ │
│ 187 │ │ │ "asyncio.run() cannot be called from a running event loop") │
│ 188 │ │
│ 189 │ with Runner(debug=debug) as runner: │
│ ❱ 190 │ │ return runner.run(main) │
│ 191 │
│ 192 │
│ 193 def _cancel_all_tasks(loop): │
│ │
│ ╭────────────────────────── locals ──────────────────────────╮ │
│ │ debug = None │ │
│ │ main = <coroutine object create_org at 0x7f9fc8be3760> │ │
│ │ runner = <asyncio.runners.Runner object at 0x7f9fc8aaa3d0> │ │
│ ╰────────────────────────────────────────────────────────────╯ │
│ │
│ /usr/lib/python3.11/asyncio/runners.py:118 in run │
│ │
│ 115 │ │ │
│ 116 │ │ self._interrupt_count = 0 │
│ 117 │ │ try: │
│ ❱ 118 │ │ │ return self._loop.run_until_complete(task) │
│ 119 │ │ except exceptions.CancelledError: │
│ 120 │ │ │ if self._interrupt_count > 0: │
│ 121 │ │ │ │ uncancel = getattr(task, "uncancel", None) │
│ │
│ ╭─────────────────────────────────────────── locals ───────────────────────────────────────────╮ │
│ │ context = <_contextvars.Context object at 0x7f9fc8c7cb40> │ │
│ │ coro = <coroutine object create_org at 0x7f9fc8be3760> │ │
│ │ self = <asyncio.runners.Runner object at 0x7f9fc8aaa3d0> │ │
│ │ sigint_handler = functools.partial(<bound method Runner._on_sigint of │ │
│ │ <asyncio.runners.Runner object at 0x7f9fc8aaa3d0>>, main_task=<Task │ │
│ │ finished name='Task-1' coro=<create_org() done, defined at │ │
│ │ /media/storage/Code/skyvern/scripts/create_organization.py:10> │ │
│ │ exception=OperationalError('(psycopg.OperationalError) connection failed: │ │
│ │ fe_sendauth: no password supplied')>) │ │
│ │ task = <Task finished name='Task-1' coro=<create_org() done, defined at │ │
│ │ /media/storage/Code/skyvern/scripts/create_organization.py:10> │ │
│ │ exception=OperationalError('(psycopg.OperationalError) connection failed: │ │
│ │ fe_sendauth: no password supplied')> │ │
│ ╰──────────────────────────────────────────────────────────────────────────────────────────────╯ │
│ │
│ /usr/lib/python3.11/asyncio/base_events.py:654 in run_until_complete │
│ │
│ 651 │ │ if not future.done(): │
│ 652 │ │ │ raise RuntimeError('Event loop stopped before Future completed.') │
│ 653 │ │ │
│ ❱ 654 │ │ return future.result() │
│ 655 │ │
│ 656 │ def stop(self): │
│ 657 │ │ """Stop running the event loop. │
│ │
│ ╭─────────────────────────────────────────── locals ───────────────────────────────────────────╮ │
│ │ future = <Task finished name='Task-1' coro=<create_org() done, defined at │ │
│ │ /media/storage/Code/skyvern/scripts/create_organization.py:10> │ │
│ │ exception=OperationalError('(psycopg.OperationalError) connection failed: │ │
│ │ fe_sendauth: no password supplied')> │ │
│ │ new_task = False │ │
│ │ self = <_UnixSelectorEventLoop running=False closed=True debug=False> │ │
│ ╰──────────────────────────────────────────────────────────────────────────────────────────────╯ │
│ │
│ /media/storage/Code/skyvern/scripts/create_organization.py:11 in create_org │
│ │
│ 8 │
│ 9 │
│ 10 async def create_org(org_name: str, webhook_callback_url: str | None = None) -> None: │
│ ❱ 11 │ organization = await DATABASE.create_organization(org_name, webhook_callback_url) │
│ 12 │ print(f"Created organization: {organization}") │
│ 13 │ await create_org_api_token(organization.organization_id) │
│ 14 │
│ │
│ ╭─────────────────── locals ───────────────────╮ │
│ │ org_name = 'Skyvern-Open-Source' │ │
│ │ webhook_callback_url = None │ │
│ ╰──────────────────────────────────────────────╯ │
│ │
│ /media/storage/Code/skyvern/skyvern/forge/sdk/db/client.py:409 in create_organization │
│ │
│ 406 │ │ │ │ max_steps_per_run=max_steps_per_run, │
│ 407 │ │ │ ) │
│ 408 │ │ │ session.add(org) │
│ ❱ 409 │ │ │ session.commit() │
│ 410 │ │ │ session.refresh(org) │
│ 411 │ │ │
│ 412 │ │ return convert_to_organization(org) │
│ │
│ ╭─────────────────────────────────────────── locals ───────────────────────────────────────────╮ │
│ │ max_steps_per_run = None │ │
│ │ org = <skyvern.forge.sdk.db.models.OrganizationModel object at │ │
│ │ 0x7f9fc8a9dad0> │ │
│ │ organization_name = 'Skyvern-Open-Source' │ │
│ │ self = <skyvern.forge.sdk.db.client.AgentDB object at 0x7f9fd0404710> │ │
│ │ session = <sqlalchemy.orm.session.Session object at 0x7f9fc8a9fb90> │ │
│ │ webhook_callback_url = None │ │
│ ╰──────────────────────────────────────────────────────────────────────────────────────────────╯ │
│ │
│ /home/ryan/.cache/pypoetry/virtualenvs/skyvern-ckmzeAJa-py3.11/lib/python3.11/site-packages/sqla │
│ lchemy/orm/session.py:1972 in commit │
│ │
│ 1969 │ │ if trans is None: │
│ 1970 │ │ │ trans = self._autobegin_t() │
│ 1971 │ │ │
│ ❱ 1972 │ │ trans.commit(_to_root=True) │
│ 1973 │ │
│ 1974 │ def prepare(self) -> None: │
│ 1975 │ │ """Prepare the current transaction in progress for two phase commit. │
│ │
│ ╭─────────────────────────────────── locals ───────────────────────────────────╮ │
│ │ self = <sqlalchemy.orm.session.Session object at 0x7f9fc8a9fb90> │ │
│ │ trans = <sqlalchemy.orm.session.SessionTransaction object at 0x7f9fd153e990> │ │
│ ╰──────────────────────────────────────────────────────────────────────────────╯ │
│ in commit:2 │
│ ╭──────────────────────────────────── locals ─────────────────────────────────────╮ │
│ │ _to_root = True │ │
│ │ self = <sqlalchemy.orm.session.SessionTransaction object at 0x7f9fd153e990> │ │
│ ╰─────────────────────────────────────────────────────────────────────────────────╯ │
│ │
│ /home/ryan/.cache/pypoetry/virtualenvs/skyvern-ckmzeAJa-py3.11/lib/python3.11/site-packages/sqla │
│ lchemy/orm/state_changes.py:139 in _go │
│ │
│ 136 │ │ │ self._current_fn = fn │
│ 137 │ │ │ self._next_state = _StateChangeStates.CHANGE_IN_PROGRESS │
│ 138 │ │ │ try: │
│ ❱ 139 │ │ │ │ ret_value = fn(self, *arg, **kw) │
│ 140 │ │ │ except: │
│ 141 │ │ │ │ raise │
│ 142 │ │ │ else: │
│ │
│ ╭─────────────────────────────────────────── locals ───────────────────────────────────────────╮ │
│ │ arg = () │ │
│ │ current_state = <SessionTransactionState.ACTIVE: 1> │ │
│ │ existing_fn = None │ │
│ │ expect_state = <SessionTransactionState.CLOSED: 5> │ │
│ │ expect_state_change = True │ │
│ │ fn = <function SessionTransaction.commit at 0x7f9fd2a56480> │ │
│ │ has_prerequisite_states = True │ │
│ │ kw = {'_to_root': True} │ │
│ │ moves_to = <SessionTransactionState.CLOSED: 5> │ │
│ │ next_state = <_StateChangeStates.ANY: 1> │ │
│ │ prerequisite_state_collection = ( │ │
│ │ │ <SessionTransactionState.ACTIVE: 1>, │ │
│ │ │ <SessionTransactionState.PREPARED: 2> │ │
│ │ ) │ │
│ │ self = <sqlalchemy.orm.session.SessionTransaction object at │ │
│ │ 0x7f9fd153e990> │ │
│ ╰──────────────────────────────────────────────────────────────────────────────────────────────╯ │
│ │
│ /home/ryan/.cache/pypoetry/virtualenvs/skyvern-ckmzeAJa-py3.11/lib/python3.11/site-packages/sqla │
│ lchemy/orm/session.py:1257 in commit │
│ │
│ 1254 │ def commit(self, _to_root: bool = False) -> None: │
│ 1255 │ │ if self._state is not SessionTransactionState.PREPARED: │
│ 1256 │ │ │ with self._expect_state(SessionTransactionState.PREPARED): │
│ ❱ 1257 │ │ │ │ self._prepare_impl() │
│ 1258 │ │ │
│ 1259 │ │ if self._parent is None or self.nested: │
│ 1260 │ │ │ for conn, trans, should_commit, autoclose in set( │
│ │
│ ╭──────────────────────────────────── locals ─────────────────────────────────────╮ │
│ │ _to_root = True │ │
│ │ self = <sqlalchemy.orm.session.SessionTransaction object at 0x7f9fd153e990> │ │
│ ╰─────────────────────────────────────────────────────────────────────────────────╯ │
│ in _prepare_impl:2 │
│ ╭────────────────────────────────── locals ───────────────────────────────────╮ │
│ │ self = <sqlalchemy.orm.session.SessionTransaction object at 0x7f9fd153e990> │ │
│ ╰─────────────────────────────────────────────────────────────────────────────╯ │
│ │
│ /home/ryan/.cache/pypoetry/virtualenvs/skyvern-ckmzeAJa-py3.11/lib/python3.11/site-packages/sqla │
│ lchemy/orm/state_changes.py:139 in _go │
│ │
│ 136 │ │ │ self._current_fn = fn │
│ 137 │ │ │ self._next_state = _StateChangeStates.CHANGE_IN_PROGRESS │
│ 138 │ │ │ try: │
│ ❱ 139 │ │ │ │ ret_value = fn(self, *arg, **kw) │
│ 140 │ │ │ except: │
│ 141 │ │ │ │ raise │
│ 142 │ │ │ else: │
│ │
│ ╭─────────────────────────────────────────── locals ───────────────────────────────────────────╮ │
│ │ arg = () │ │
│ │ current_state = <SessionTransactionState.ACTIVE: 1> │ │
│ │ existing_fn = <function SessionTransaction.commit at 0x7f9fd2a56480> │ │
│ │ expect_state = <SessionTransactionState.PREPARED: 2> │ │
│ │ expect_state_change = True │ │
│ │ fn = <function SessionTransaction._prepare_impl at │ │
│ │ 0x7f9fd2a562a0> │ │
│ │ has_prerequisite_states = True │ │
│ │ kw = {} │ │
│ │ moves_to = <SessionTransactionState.PREPARED: 2> │ │
│ │ next_state = <SessionTransactionState.PREPARED: 2> │ │
│ │ prerequisite_state_collection = (<SessionTransactionState.ACTIVE: 1>,) │ │
│ │ self = <sqlalchemy.orm.session.SessionTransaction object at │ │
│ │ 0x7f9fd153e990> │ │
│ ╰──────────────────────────────────────────────────────────────────────────────────────────────╯ │
│ │
│ /home/ryan/.cache/pypoetry/virtualenvs/skyvern-ckmzeAJa-py3.11/lib/python3.11/site-packages/sqla │
│ lchemy/orm/session.py:1232 in _prepare_impl │
│ │
│ 1229 │ │ │ for _flush_guard in range(100): │
│ 1230 │ │ │ │ if self.session._is_clean(): │
│ 1231 │ │ │ │ │ break │
│ ❱ 1232 │ │ │ │ self.session.flush() │
│ 1233 │ │ │ else: │
│ 1234 │ │ │ │ raise exc.FlushError( │
│ 1235 │ │ │ │ │ "Over 100 subsequent flushes have occurred within " │
│ │
│ ╭────────────────────────────────────── locals ───────────────────────────────────────╮ │
│ │ _flush_guard = 0 │ │
│ │ self = <sqlalchemy.orm.session.SessionTransaction object at 0x7f9fd153e990> │ │
│ │ stx = <sqlalchemy.orm.session.SessionTransaction object at 0x7f9fd153e990> │ │
│ ╰─────────────────────────────────────────────────────────────────────────────────────╯ │
│ │
│ /home/ryan/.cache/pypoetry/virtualenvs/skyvern-ckmzeAJa-py3.11/lib/python3.11/site-packages/sqla │
│ lchemy/orm/session.py:4296 in flush │
│ │
│ 4293 │ │ │ return │
│ 4294 │ │ try: │
│ 4295 │ │ │ self._flushing = True │
│ ❱ 4296 │ │ │ self._flush(objects) │
│ 4297 │ │ finally: │
│ 4298 │ │ │ self._flushing = False │
│ 4299 │
│ │
│ ╭────────────────────────────── locals ───────────────────────────────╮ │
│ │ objects = None │ │
│ │ self = <sqlalchemy.orm.session.Session object at 0x7f9fc8a9fb90> │ │
│ ╰─────────────────────────────────────────────────────────────────────╯ │
│ │
│ /home/ryan/.cache/pypoetry/virtualenvs/skyvern-ckmzeAJa-py3.11/lib/python3.11/site-packages/sqla │
│ lchemy/orm/session.py:4431 in _flush │
│ │
│ 4428 │ │ │ transaction.commit() │
│ 4429 │ │ │
│ 4430 │ │ except: │
│ ❱ 4431 │ │ │ with util.safe_reraise(): │
│ 4432 │ │ │ │ transaction.rollback(_capture_exception=True) │
│ 4433 │ │
│ 4434 │ def bulk_save_objects( │
│ │
│ ╭────────────────────────────────────────── locals ───────────────────────────────────────────╮ │
│ │ _reg = True │ │
│ │ deleted = set() │ │
│ │ dirty = set() │ │
│ │ flush_context = <sqlalchemy.orm.unitofwork.UOWTransaction object at 0x7f9fc8ad3450> │ │
│ │ is_orphan = False │ │
│ │ is_persistent_orphan = False │ │
│ │ new = {<sqlalchemy.orm.state.InstanceState object at 0x7f9fc8c493d0>} │ │
│ │ objects = None │ │
│ │ objset = None │ │
│ │ proc = set() │ │
│ │ processed = {<sqlalchemy.orm.state.InstanceState object at 0x7f9fc8c493d0>} │ │
│ │ self = <sqlalchemy.orm.session.Session object at 0x7f9fc8a9fb90> │ │
│ │ state = <sqlalchemy.orm.state.InstanceState object at 0x7f9fc8c493d0> │ │
│ │ transaction = <sqlalchemy.orm.session.SessionTransaction object at 0x7f9fc8c67390> │ │
│ ╰─────────────────────────────────────────────────────────────────────────────────────────────╯ │
│ │
│ /home/ryan/.cache/pypoetry/virtualenvs/skyvern-ckmzeAJa-py3.11/lib/python3.11/site-packages/sqla │
│ lchemy/util/langhelpers.py:146 in exit │
│ │
│ 143 │ │ │ exc_type, exc_value, exc_tb = self._exc_info │
│ 144 │ │ │ assert exc_value is not None │
│ 145 │ │ │ self._exc_info = None # remove potential circular references │
│ ❱ 146 │ │ │ raise exc_value.with_traceback(exc_tb) │
│ 147 │ │ else: │
│ 148 │ │ │ self.exc_info = None # remove potential circular references │
│ 149 │ │ │ assert value is not None │
│ │
│ ╭─────────────────────────────────────────── locals ───────────────────────────────────────────╮ │
│ │ exc_tb = <traceback object at 0x7f9fc8adeb80> │ │
│ │ exc_type = <class 'sqlalchemy.exc.OperationalError'> │ │
│ │ exc_value = OperationalError('(psycopg.OperationalError) connection failed: fe_sendauth: no │ │
│ │ password supplied') │ │
│ │ self = <sqlalchemy.util.langhelpers.safe_reraise object at 0x7f9fc8c58f40> │ │
│ │ traceback = None │ │
│ │ type = None │ │
│ │ value = None │ │
│ ╰──────────────────────────────────────────────────────────────────────────────────────────────╯ │
│ │
│ /home/ryan/.cache/pypoetry/virtualenvs/skyvern-ckmzeAJa-py3.11/lib/python3.11/site-packages/sqla │
│ lchemy/orm/session.py:4392 in _flush │
│ │
│ 4389 │ │ try: │
│ 4390 │ │ │ self._warn_on_events = True │
│ 4391 │ │ │ try: │
│ ❱ 4392 │ │ │ │ flush_context.execute() │
│ 4393 │ │ │ finally: │
│ 4394 │ │ │ │ self.warn_on_events = False │
│ 4395 │
│ │
│ ╭────────────────────────────────────────── locals ───────────────────────────────────────────╮ │
│ │ reg = True │ │
│ │ deleted = set() │ │
│ │ dirty = set() │ │
│ │ flush_context = <sqlalchemy.orm.unitofwork.UOWTransaction object at 0x7f9fc8ad3450> │ │
│ │ is_orphan = False │ │
│ │ is_persistent_orphan = False │ │
│ │ new = {<sqlalchemy.orm.state.InstanceState object at 0x7f9fc8c493d0>} │ │
│ │ objects = None │ │
│ │ objset = None │ │
│ │ proc = set() │ │
│ │ processed = {<sqlalchemy.orm.state.InstanceState object at 0x7f9fc8c493d0>} │ │
│ │ self = <sqlalchemy.orm.session.Session object at 0x7f9fc8a9fb90> │ │
│ │ state = <sqlalchemy.orm.state.InstanceState object at 0x7f9fc8c493d0> │ │
│ │ transaction = <sqlalchemy.orm.session.SessionTransaction object at 0x7f9fc8c67390> │ │
│ ╰─────────────────────────────────────────────────────────────────────────────────────────────╯ │
│ │
│ /home/ryan/.cache/pypoetry/virtualenvs/skyvern-ckmzeAJa-py3.11/lib/python3.11/site-packages/sqla │
│ lchemy/orm/unitofwork.py:466 in execute │
│ │
│ 463 │ │ │ │ │ n.execute_aggregate(self, set) │
│ 464 │ │ else: │
│ 465 │ │ │ for rec in topological.sort(self.dependencies, postsort_actions): │
│ ❱ 466 │ │ │ │ rec.execute(self) │
│ 467 │ │
│ 468 │ def finalize_flush_changes(self) -> None: │
│ 469 │ │ """Mark processed objects as clean / deleted after a successful │
│ │
│ ╭──────────────────────────────────────── locals ────────────────────────────────────────╮ │
│ │ postsort_actions = [ │ │
│ │ │ DeleteAll(Mapper[OrganizationModel(organizations)]), │ │
│ │ │ SaveUpdateAll(Mapper[OrganizationModel(organizations)]) │ │
│ │ ] │ │
│ │ rec = SaveUpdateAll(Mapper[OrganizationModel(organizations)]) │ │
│ │ self = <sqlalchemy.orm.unitofwork.UOWTransaction object at 0x7f9fc8ad3450> │ │
│ ╰────────────────────────────────────────────────────────────────────────────────────────╯ │
│ │
│ /home/ryan/.cache/pypoetry/virtualenvs/skyvern-ckmzeAJa-py3.11/lib/python3.11/site-packages/sqla │
│ lchemy/orm/unitofwork.py:642 in execute │
│ │
│ 639 │ │
│ 640 │ @util.preload_module("sqlalchemy.orm.persistence") │
│ 641 │ def execute(self, uow): │
│ ❱ 642 │ │ util.preloaded.orm_persistence.save_obj( │
│ 643 │ │ │ self.mapper, │
│ 644 │ │ │ uow.states_for_mapper_hierarchy(self.mapper, False, False), │
│ 645 │ │ │ uow, │
│ │
│ ╭────────────────────────────────── locals ──────────────────────────────────╮ │
│ │ self = SaveUpdateAll(Mapper[OrganizationModel(organizations)]) │ │
│ │ uow = <sqlalchemy.orm.unitofwork.UOWTransaction object at 0x7f9fc8ad3450> │ │
│ ╰────────────────────────────────────────────────────────────────────────────╯ │
│ │
│ /home/ryan/.cache/pypoetry/virtualenvs/skyvern-ckmzeAJa-py3.11/lib/python3.11/site-packages/sqla │
│ lchemy/orm/persistence.py:60 in save_obj │
│ │
│ 57 │ states_to_update = [] │
│ 58 │ states_to_insert = [] │
│ 59 │ │
│ ❱ 60 │ for ( │
│ 61 │ │ state, │
│ 62 │ │ dict, │
│ 63 │ │ mapper, │
│ │
│ ╭─────────────────────────────────────────── locals ───────────────────────────────────────────╮ │
│ │ base_mapper = <Mapper at 0x7f9fd298bc50; OrganizationModel> │ │
│ │ single = False │ │
│ │ states = <generator object UOWTransaction.states_for_mapper_hierarchy at │ │
│ │ 0x7f9fc8b95c40> │ │
│ │ states_to_insert = [] │ │
│ │ states_to_update = [] │ │
│ │ uowtransaction = <sqlalchemy.orm.unitofwork.UOWTransaction object at 0x7f9fc8ad3450> │ │
│ ╰──────────────────────────────────────────────────────────────────────────────────────────────╯ │
│ │
│ /home/ryan/.cache/pypoetry/virtualenvs/skyvern-ckmzeAJa-py3.11/lib/python3.11/site-packages/sqla │
│ lchemy/orm/persistence.py:223 in organize_states_for_save │
│ │
│ 220 │ │
│ 221 │ """ │
│ 222 │ │
│ ❱ 223 │ for state, dict, mapper, connection in _connections_for_states( │
│ 224 │ │ base_mapper, uowtransaction, states │
│ 225 │ ): │
│ 226 │ │ has_identity = bool(state.key) │
│ │
│ ╭─────────────────────────────────────────── locals ───────────────────────────────────────────╮ │
│ │ base_mapper = <Mapper at 0x7f9fd298bc50; OrganizationModel> │ │
│ │ states = <generator object UOWTransaction.states_for_mapper_hierarchy at │ │
│ │ 0x7f9fc8b95c40> │ │
│ │ uowtransaction = <sqlalchemy.orm.unitofwork.UOWTransaction object at 0x7f9fc8ad3450> │ │
│ ╰──────────────────────────────────────────────────────────────────────────────────────────────╯ │
│ │
│ /home/ryan/.cache/pypoetry/virtualenvs/skyvern-ckmzeAJa-py3.11/lib/python3.11/site-packages/sqla │
│ lchemy/orm/persistence.py:1753 in _connections_for_states │
│ │
│ 1750 │ if uowtransaction.session.connection_callable: │
│ 1751 │ │ connection_callable = uowtransaction.session.connection_callable │
│ 1752 │ else: │
│ ❱ 1753 │ │ connection = uowtransaction.transaction.connection(base_mapper) │
│ 1754 │ │ connection_callable = None │
│ 1755 │ │
│ 1756 │ for state in _sort_states(base_mapper, states): │
│ │
│ ╭─────────────────────────────────────────── locals ───────────────────────────────────────────╮ │
│ │ base_mapper = <Mapper at 0x7f9fd298bc50; OrganizationModel> │ │
│ │ states = <generator object UOWTransaction.states_for_mapper_hierarchy at │ │
│ │ 0x7f9fc8b95c40> │ │
│ │ uowtransaction = <sqlalchemy.orm.unitofwork.UOWTransaction object at 0x7f9fc8ad3450> │ │
│ ╰──────────────────────────────────────────────────────────────────────────────────────────────╯ │
│ in connection:2 │
│ ╭───────────────────────────────────────── locals ─────────────────────────────────────────╮ │
│ │ bindkey = <Mapper at 0x7f9fd298bc50; OrganizationModel> │ │
│ │ execution_options = None │ │
│ │ kwargs = {} │ │
│ │ self = <sqlalchemy.orm.session.SessionTransaction object at 0x7f9fc8c67390> │ │
│ ╰──────────────────────────────────────────────────────────────────────────────────────────╯ │
│ │
│ /home/ryan/.cache/pypoetry/virtualenvs/skyvern-ckmzeAJa-py3.11/lib/python3.11/site-packages/sqla │
│ lchemy/orm/state_changes.py:139 in _go │
│ │
│ 136 │ │ │ self._current_fn = fn │
│ 137 │ │ │ self._next_state = _StateChangeStates.CHANGE_IN_PROGRESS │
│ 138 │ │ │ try: │
│ ❱ 139 │ │ │ │ ret_value = fn(self, *arg, **kw) │
│ 140 │ │ │ except: │
│ 141 │ │ │ │ raise │
│ 142 │ │ │ else: │
│ │
│ ╭─────────────────────────────────────────── locals ───────────────────────────────────────────╮ │
│ │ arg = (<Mapper at 0x7f9fd298bc50; OrganizationModel>,) │ │
│ │ current_state = <SessionTransactionState.ACTIVE: 1> │ │
│ │ existing_fn = None │ │
│ │ expect_state = <SessionTransactionState.ACTIVE: 1> │ │
│ │ expect_state_change = False │ │
│ │ fn = <function SessionTransaction.connection at 0x7f9fd2a559e0> │ │
│ │ has_prerequisite_states = True │ │
│ │ kw = {'execution_options': None} │ │
│ │ moves_to = <_StateChangeStates.NO_CHANGE: 2> │ │
│ │ next_state = <_StateChangeStates.ANY: 1> │ │
│ │ prerequisite_state_collection = (<SessionTransactionState.ACTIVE: 1>,) │ │
│ │ self = <sqlalchemy.orm.session.SessionTransaction object at │ │
│ │ 0x7f9fc8c67390> │ │
│ ╰──────────────────────────────────────────────────────────────────────────────────────────────╯ │
│ │
│ /home/ryan/.cache/pypoetry/virtualenvs/skyvern-ckmzeAJa-py3.11/lib/python3.11/site-packages/sqla │
│ lchemy/orm/session.py:994 in connection │
│ │
│ 991 │ │ **kwargs: Any, │
│ 992 │ ) -> Connection: │
│ 993 │ │ bind = self.session.get_bind(bindkey, **kwargs) │
│ ❱ 994 │ │ return self._connection_for_bind(bind, execution_options) │
│ 995 │ │
│ 996 │ @_StateChange.declare_states( │
│ 997 │ │ (SessionTransactionState.ACTIVE,), _StateChangeStates.NO_CHANGE │
│ │
│ ╭───────────────────────────────────────── locals ─────────────────────────────────────────╮ │
│ │ bind = Engine(postgresql+psycopg://skyvern@localhost/skyvern) │ │
│ │ bindkey = <Mapper at 0x7f9fd298bc50; OrganizationModel> │ │
│ │ execution_options = None │ │
│ │ kwargs = {} │ │
│ │ self = <sqlalchemy.orm.session.SessionTransaction object at 0x7f9fc8c67390> │ │
│ ╰──────────────────────────────────────────────────────────────────────────────────────────╯ │
│ in _connection_for_bind:2 │
│ ╭───────────────────────────────────────── locals ─────────────────────────────────────────╮ │
│ │ bind = Engine(postgresql+psycopg://skyvern@localhost/skyvern) │ │
│ │ execution_options = None │ │
│ │ self = <sqlalchemy.orm.session.SessionTransaction object at 0x7f9fc8c67390> │ │
│ ╰──────────────────────────────────────────────────────────────────────────────────────────╯ │
│ │
│ /home/ryan/.cache/pypoetry/virtualenvs/skyvern-ckmzeAJa-py3.11/lib/python3.11/site-packages/sqla │
│ lchemy/orm/state_changes.py:139 in _go │
│ │
│ 136 │ │ │ self._current_fn = fn │
│ 137 │ │ │ self._next_state = _StateChangeStates.CHANGE_IN_PROGRESS │
│ 138 │ │ │ try: │
│ ❱ 139 │ │ │ │ ret_value = fn(self, *arg, **kw) │
│ 140 │ │ │ except: │
│ 141 │ │ │ │ raise │
│ 142 │ │ │ else: │
│ │
│ ╭─────────────────────────────────────────── locals ───────────────────────────────────────────╮ │
│ │ arg = ( │ │
│ │ │ Engine(postgresql+psycopg://skyvern@localhost/skyvern), │ │
│ │ │ None │ │
│ │ ) │ │
│ │ current_state = <SessionTransactionState.ACTIVE: 1> │ │
│ │ existing_fn = <function SessionTransaction.connection at 0x7f9fd2a559e0> │ │
│ │ expect_state = <SessionTransactionState.ACTIVE: 1> │ │
│ │ expect_state_change = False │ │
│ │ fn = <function SessionTransaction._connection_for_bind at │ │
│ │ 0x7f9fd2a56020> │ │
│ │ has_prerequisite_states = True │ │
│ │ kw = {} │ │
│ │ moves_to = <_StateChangeStates.NO_CHANGE: 2> │ │
│ │ next_state = <_StateChangeStates.CHANGE_IN_PROGRESS: 3> │ │
│ │ prerequisite_state_collection = (<SessionTransactionState.ACTIVE: 1>,) │ │
│ │ self = <sqlalchemy.orm.session.SessionTransaction object at │ │
│ │ 0x7f9fc8c67390> │ │
│ ╰──────────────────────────────────────────────────────────────────────────────────────────────╯ │
│ │
│ /home/ryan/.cache/pypoetry/virtualenvs/skyvern-ckmzeAJa-py3.11/lib/python3.11/site-packages/sqla │
│ lchemy/orm/session.py:1130 in _connection_for_bind │
│ │
│ 1127 │ │ │
│ 1128 │ │ try: │
│ 1129 │ │ │ if self._parent: │
│ ❱ 1130 │ │ │ │ conn = self._parent._connection_for_bind( │
│ 1131 │ │ │ │ │ bind, execution_options │
│ 1132 │ │ │ │ ) │
│ 1133 │ │ │ │ if not self.nested: │
│ │
│ ╭───────────────────────────────────────── locals ─────────────────────────────────────────╮ │
│ │ bind = Engine(postgresql+psycopg://skyvern@localhost/skyvern) │ │
│ │ execution_options = None │ │
│ │ local_connect = False │ │
│ │ self = <sqlalchemy.orm.session.SessionTransaction object at 0x7f9fc8c67390> │ │
│ │ should_commit = True │ │
│ ╰──────────────────────────────────────────────────────────────────────────────────────────╯ │
│ in _connection_for_bind:2 │
│ ╭───────────────────────────────────────── locals ─────────────────────────────────────────╮ │
│ │ bind = Engine(postgresql+psycopg://skyvern@localhost/skyvern) │ │
│ │ execution_options = None │ │
│ │ self = <sqlalchemy.orm.session.SessionTransaction object at 0x7f9fd153e990> │ │
│ ╰──────────────────────────────────────────────────────────────────────────────────────────╯ │
│ │
│ /home/ryan/.cache/pypoetry/virtualenvs/skyvern-ckmzeAJa-py3.11/lib/python3.11/site-packages/sqla │
│ lchemy/orm/state_changes.py:139 in _go │
│ │
│ 136 │ │ │ self._current_fn = fn │
│ 137 │ │ │ self._next_state = _StateChangeStates.CHANGE_IN_PROGRESS │
│ 138 │ │ │ try: │
│ ❱ 139 │ │ │ │ ret_value = fn(self, *arg, **kw) │
│ 140 │ │ │ except: │
│ 141 │ │ │ │ raise │
│ 142 │ │ │ else: │
│ │
│ ╭─────────────────────────────────────────── locals ───────────────────────────────────────────╮ │
│ │ arg = ( │ │
│ │ │ Engine(postgresql+psycopg://skyvern@localhost/skyvern), │ │
│ │ │ None │ │
│ │ ) │ │
│ │ current_state = <SessionTransactionState.ACTIVE: 1> │ │
│ │ existing_fn = <function SessionTransaction._prepare_impl at │ │
│ │ 0x7f9fd2a562a0> │ │
│ │ expect_state = <SessionTransactionState.ACTIVE: 1> │ │
│ │ expect_state_change = False │ │
│ │ fn = <function SessionTransaction._connection_for_bind at │ │
│ │ 0x7f9fd2a56020> │ │
│ │ has_prerequisite_states = True │ │
│ │ kw = {} │ │
│ │ moves_to = <_StateChangeStates.NO_CHANGE: 2> │ │
│ │ next_state = <_StateChangeStates.CHANGE_IN_PROGRESS: 3> │ │
│ │ prerequisite_state_collection = (<SessionTransactionState.ACTIVE: 1>,) │ │
│ │ self = <sqlalchemy.orm.session.SessionTransaction object at │ │
│ │ 0x7f9fd153e990> │ │
│ ╰──────────────────────────────────────────────────────────────────────────────────────────────╯ │
│ │
│ /home/ryan/.cache/pypoetry/virtualenvs/skyvern-ckmzeAJa-py3.11/lib/python3.11/site-packages/sqla │
│ lchemy/orm/session.py:1144 in _connection_for_bind │
│ │
│ 1141 │ │ │ │ │ │ │ "for the given Connection's Engine" │
│ 1142 │ │ │ │ │ │ ) │
│ 1143 │ │ │ │ else: │
│ ❱ 1144 │ │ │ │ │ conn = bind.connect() │
│ 1145 │ │ │ │ │ local_connect = True │
│ 1146 │ │ │ │
│ 1147 │ │ │ try: │
│ │
│ ╭───────────────────────────────────────── locals ─────────────────────────────────────────╮ │
│ │ bind = Engine(postgresql+psycopg://skyvern@localhost/skyvern) │ │
│ │ execution_options = None │ │
│ │ local_connect = False │ │
│ │ self = <sqlalchemy.orm.session.SessionTransaction object at 0x7f9fd153e990> │ │
│ │ should_commit = True │ │
│ ╰──────────────────────────────────────────────────────────────────────────────────────────╯ │
│ │
│ /home/ryan/.cache/pypoetry/virtualenvs/skyvern-ckmzeAJa-py3.11/lib/python3.11/site-packages/sqla │
│ lchemy/engine/base.py:3279 in connect │
│ │
│ 3276 │ │ │
│ 3277 │ │ """ │
│ 3278 │ │ │
│ ❱ 3279 │ │ return self._connection_cls(self) │
│ 3280 │ │
│ 3281 │ def raw_connection(self) -> PoolProxiedConnection: │
│ 3282 │ │ """Return a "raw" DBAPI connection from the connection pool. │
│ │
│ ╭─────────────────────────── locals ────────────────────────────╮ │
│ │ self = Engine(postgresql+psycopg://skyvern@localhost/skyvern) │ │
│ ╰───────────────────────────────────────────────────────────────╯ │
│ │
│ /home/ryan/.cache/pypoetry/virtualenvs/skyvern-ckmzeAJa-py3.11/lib/python3.11/site-packages/sqla │
│ lchemy/engine/base.py:147 in init │
│ │
│ 144 │ │ │ try: │
│ 145 │ │ │ │ self._dbapi_connection = engine.raw_connection() │
│ 146 │ │ │ except dialect.loaded_dbapi.Error as err: │
│ ❱ 147 │ │ │ │ Connection._handle_dbapi_exception_noconnection( │
│ 148 │ │ │ │ │ err, dialect, engine │
│ 149 │ │ │ │ ) │
│ 150 │ │ │ │ raise │
│ │
│ ╭─────────────────────────────────────────── locals ───────────────────────────────────────────╮ │
│ │ _allow_autobegin = True │ │
│ │ _allow_revalidate = True │ │
│ │ _has_events = None │ │
│ │ connection = None │ │
│ │ dialect = <sqlalchemy.dialects.postgresql.psycopg.PGDialect_psycopg object at │ │
│ │ 0x7f9fd0407f10> │ │
│ │ engine = Engine(postgresql+psycopg://skyvern@localhost/skyvern) │ │
│ │ self = <sqlalchemy.engine.base.Connection object at 0x7f9fc8ad3990> │ │
│ ╰──────────────────────────────────────────────────────────────────────────────────────────────╯ │
│ │
│ /home/ryan/.cache/pypoetry/virtualenvs/skyvern-ckmzeAJa-py3.11/lib/python3.11/site-packages/sqla │
│ lchemy/engine/base.py:2443 in _handle_dbapi_exception_noconnection │
│ │
│ 2440 │ │ │ raise newraise.with_traceback(exc_info[2]) from e │
│ 2441 │ │ elif should_wrap: │
│ 2442 │ │ │ assert sqlalchemy_exception is not None │
│ ❱ 2443 │ │ │ raise sqlalchemy_exception.with_traceback(exc_info[2]) from e │
│ 2444 │ │ else: │
│ 2445 │ │ │ assert exc_info[1] is not None │
│ 2446 │ │ │ raise exc_info[1].with_traceback(exc_info[2]) │
│ │
│ ╭─────────────────────────────────────────── locals ───────────────────────────────────────────╮ │
│ │ cls = <class 'sqlalchemy.engine.base.Connection'> │ │
│ │ dialect = <sqlalchemy.dialects.postgresql.psycopg.PGDialect_psycopg │ │
│ │ object at 0x7f9fd0407f10> │ │
│ │ e = OperationalError('connection failed: fe_sendauth: no │ │
│ │ password supplied') │ │
│ │ engine = Engine(postgresql+psycopg://skyvern@localhost/skyvern) │ │
│ │ exc_info = ( │ │
│ │ │ <class 'psycopg.OperationalError'>, │ │
│ │ │ OperationalError('connection failed: fe_sendauth: no │ │
│ │ password supplied'), │ │
│ │ │ <traceback object at 0x7f9fc8ade700> │ │
│ │ ) │ │
│ │ invalidate_pool_on_disconnect = True │ │
│ │ is_disconnect = False │ │
│ │ is_pre_ping = False │ │
│ │ newraise = None │ │
│ │ should_wrap = True │ │
│ │ sqlalchemy_exception = OperationalError('(psycopg.OperationalError) connection │ │
│ │ failed: fe_sendauth: no password supplied') │ │
│ ╰──────────────────────────────────────────────────────────────────────────────────────────────╯ │
│ │
│ /home/ryan/.cache/pypoetry/virtualenvs/skyvern-ckmzeAJa-py3.11/lib/python3.11/site-packages/sqla │
│ lchemy/engine/base.py:145 in init │
│ │
│ 142 │ │ │
│ 143 │ │ if connection is None: │
│ 144 │ │ │ try: │
│ ❱ 145 │ │ │ │ self._dbapi_connection = engine.raw_connection() │
│ 146 │ │ │ except dialect.loaded_dbapi.Error as err: │
│ 147 │ │ │ │ Connection._handle_dbapi_exception_noconnection( │
│ 148 │ │ │ │ │ err, dialect, engine │
│ │
│ ╭─────────────────────────────────────────── locals ───────────────────────────────────────────╮ │
│ │ _allow_autobegin = True │ │
│ │ _allow_revalidate = True │ │
│ │ _has_events = None │ │
│ │ connection = None │ │
│ │ dialect = <sqlalchemy.dialects.postgresql.psycopg.PGDialect_psycopg object at │ │
│ │ 0x7f9fd0407f10> │ │
│ │ engine = Engine(postgresql+psycopg://skyvern@localhost/skyvern) │ │
│ │ self = <sqlalchemy.engine.base.Connection object at 0x7f9fc8ad3990> │ │
│ ╰──────────────────────────────────────────────────────────────────────────────────────────────╯ │
│ │
│ /home/ryan/.cache/pypoetry/virtualenvs/skyvern-ckmzeAJa-py3.11/lib/python3.11/site-packages/sqla │
│ lchemy/engine/base.py:3303 in raw_connection │
│ │
│ 3300 │ │ │ :ref:dbapi_connections │
│ 3301 │ │ │
│ 3302 │ │ """ │
│ ❱ 3303 │ │ return self.pool.connect() │
│ 3304 │
│ 3305 │
│ 3306 class OptionEngineMixin(log.Identified): │
│ │
│ ╭─────────────────────────── locals ────────────────────────────╮ │
│ │ self = Engine(postgresql+psycopg://skyvern@localhost/skyvern) │ │
│ ╰───────────────────────────────────────────────────────────────╯ │
│ │
│ /home/ryan/.cache/pypoetry/virtualenvs/skyvern-ckmzeAJa-py3.11/lib/python3.11/site-packages/sqla │
│ lchemy/pool/base.py:449 in connect │
│ │
│ 446 │ │ the pool. │
│ 447 │ │ │
│ 448 │ │ """ │
│ ❱ 449 │ │ return _ConnectionFairy._checkout(self) │
│ 450 │ │
│ 451 │ def _return_conn(self, record: ConnectionPoolEntry) -> None: │
│ 452 │ │ """Given a _ConnectionRecord, return it to the :class:_pool.Pool. │
│ │
│ ╭───────────────────────────── locals ─────────────────────────────╮ │
│ │ self = <sqlalchemy.pool.impl.QueuePool object at 0x7f9fc8bd3490> │ │
│ ╰──────────────────────────────────────────────────────────────────╯ │
│ │
│ /home/ryan/.cache/pypoetry/virtualenvs/skyvern-ckmzeAJa-py3.11/lib/python3.11/site-packages/sqla │
│ lchemy/pool/base.py:1263 in _checkout │
│ │
│ 1260 │ │ fairy: Optional[_ConnectionFairy] = None, │
│ 1261 │ ) -> _ConnectionFairy: │
│ 1262 │ │ if not fairy: │
│ ❱ 1263 │ │ │ fairy = _ConnectionRecord.checkout(pool) │
│ 1264 │ │ │ │
│ 1265 │ │ │ if threadconns is not None: │
│ 1266 │ │ │ │ threadconns.current = weakref.ref(fairy) │
│ │
│ ╭──────────────────────────────── locals ─────────────────────────────────╮ │
│ │ cls = <class 'sqlalchemy.pool.base._ConnectionFairy'> │ │
│ │ fairy = None │ │
│ │ pool = <sqlalchemy.pool.impl.QueuePool object at 0x7f9fc8bd3490> │ │
│ │ threadconns = None │ │
│ ╰─────────────────────────────────────────────────────────────────────────╯ │
│ │
│ /home/ryan/.cache/pypoetry/virtualenvs/skyvern-ckmzeAJa-py3.11/lib/python3.11/site-packages/sqla │
│ lchemy/pool/base.py:712 in checkout │
│ │
│ 709 │ │ if TYPE_CHECKING: │
│ 710 │ │ │ rec = cast(_ConnectionRecord, pool._do_get()) │
│ 711 │ │ else: │
│ ❱ 712 │ │ │ rec = pool._do_get() │
│ 713 │ │ │
│ 714 │ │ try: │
│ 715 │ │ │ dbapi_connection = rec.get_connection() │
│ │
│ ╭───────────────────────────── locals ─────────────────────────────╮ │
│ │ cls = <class 'sqlalchemy.pool.base._ConnectionRecord'> │ │
│ │ pool = <sqlalchemy.pool.impl.QueuePool object at 0x7f9fc8bd3490> │ │
│ ╰──────────────────────────────────────────────────────────────────╯ │
│ │
│ /home/ryan/.cache/pypoetry/virtualenvs/skyvern-ckmzeAJa-py3.11/lib/python3.11/site-packages/sqla │
│ lchemy/pool/impl.py:179 in _do_get │
│ │
│ 176 │ │ │ try: │
│ 177 │ │ │ │ return self._create_connection() │
│ 178 │ │ │ except: │
│ ❱ 179 │ │ │ │ with util.safe_reraise(): │
│ 180 │ │ │ │ │ self._dec_overflow() │
│ 181 │ │ │ │ raise │
│ 182 │ │ else: │
│ │
│ ╭───────────────────────────────── locals ─────────────────────────────────╮ │
│ │ self = <sqlalchemy.pool.impl.QueuePool object at 0x7f9fc8bd3490> │ │
│ │ use_overflow = True │ │
│ │ wait = False │ │
│ ╰──────────────────────────────────────────────────────────────────────────╯ │
│ │
│ /home/ryan/.cache/pypoetry/virtualenvs/skyvern-ckmzeAJa-py3.11/lib/python3.11/site-packages/sqla │
│ lchemy/util/langhelpers.py:146 in exit │
│ │
│ 143 │ │ │ exc_type, exc_value, exc_tb = self._exc_info │
│ 144 │ │ │ assert exc_value is not None │
│ 145 │ │ │ self._exc_info = None # remove potential circular references │
│ ❱ 146 │ │ │ raise exc_value.with_traceback(exc_tb) │
│ 147 │ │ else: │
│ 148 │ │ │ self.exc_info = None # remove potential circular references │
│ 149 │ │ │ assert value is not None │
│ │
│ ╭─────────────────────────────────────── locals ───────────────────────────────────────╮ │
│ │ exc_tb = <traceback object at 0x7f9fc8ade300> │ │
│ │ exc_type = <class 'psycopg.OperationalError'> │ │
│ │ exc_value = OperationalError('connection failed: fe_sendauth: no password supplied') │ │
│ │ self = <sqlalchemy.util.langhelpers.safe_reraise object at 0x7f9fc8ac8eb0> │ │
│ │ traceback = None │ │
│ │ type = None │ │
│ │ value = None │ │
│ ╰──────────────────────────────────────────────────────────────────────────────────────╯ │
│ │
│ /home/ryan/.cache/pypoetry/virtualenvs/skyvern-ckmzeAJa-py3.11/lib/python3.11/site-packages/sqla │
│ lchemy/pool/impl.py:177 in _do_get │
│ │
│ 174 │ │ │
│ 175 │ │ if self._inc_overflow(): │
│ 176 │ │ │ try: │
│ ❱ 177 │ │ │ │ return self._create_connection() │
│ 178 │ │ │ except: │
│ 179 │ │ │ │ with util.safe_reraise(): │
│ 180 │ │ │ │ │ self._dec_overflow() │
│ │
│ ╭───────────────────────────────── locals ─────────────────────────────────╮ │
│ │ self = <sqlalchemy.pool.impl.QueuePool object at 0x7f9fc8bd3490> │ │
│ │ use_overflow = True │ │
│ │ wait = False │ │
│ ╰──────────────────────────────────────────────────────────────────────────╯ │
│ │
│ /home/ryan/.cache/pypoetry/virtualenvs/skyvern-ckmzeAJa-py3.11/lib/python3.11/site-packages/sqla │
│ lchemy/pool/base.py:390 in _create_connection │
│ │
│ 387 │ def _create_connection(self) -> ConnectionPoolEntry: │
│ 388 │ │ """Called by subclasses to create a new ConnectionRecord.""" │
│ 389 │ │ │
│ ❱ 390 │ │ return _ConnectionRecord(self) │
│ 391 │ │
│ 392 │ def _invalidate( │
│ 393 │ │ self, │
│ │
│ ╭───────────────────────────── locals ─────────────────────────────╮ │
│ │ self = <sqlalchemy.pool.impl.QueuePool object at 0x7f9fc8bd3490> │ │
│ ╰──────────────────────────────────────────────────────────────────╯ │
│ │
│ /home/ryan/.cache/pypoetry/virtualenvs/skyvern-ckmzeAJa-py3.11/lib/python3.11/site-packages/sqla │
│ lchemy/pool/base.py:674 in init │
│ │
│ 671 │ │ │
│ 672 │ │ self.__pool = pool │
│ 673 │ │ if connect: │
│ ❱ 674 │ │ │ self.__connect() │
│ 675 │ │ self.finalize_callback = deque() │
│ 676 │ │
│ 677 │ dbapi_connection: Optional[DBAPIConnection] │
│ │
│ ╭────────────────────────────────── locals ───────────────────────────────────╮ │
│ │ connect = True │ │
│ │ pool = <sqlalchemy.pool.impl.QueuePool object at 0x7f9fc8bd3490> │ │
│ │ self = <sqlalchemy.pool.base._ConnectionRecord object at 0x7f9fca45fee0> │ │
│ ╰─────────────────────────────────────────────────────────────────────────────╯ │
│ │
│ /home/ryan/.cache/pypoetry/virtualenvs/skyvern-ckmzeAJa-py3.11/lib/python3.11/site-packages/sqla │
│ lchemy/pool/base.py:900 in __connect │
│ │
│ 897 │ │ │ pool.logger.debug("Created new connection %r", connection) │
│ 898 │ │ │ self.fresh = True │
│ 899 │ │ except BaseException as e: │
│ ❱ 900 │ │ │ with util.safe_reraise(): │
│ 901 │ │ │ │ pool.logger.debug("Error on connect(): %s", e) │
│ 902 │ │ else: │
│ 903 │ │ │ # in SQLAlchemy 1.4 the first_connect event is not used by │
│ │
│ ╭───────────────────────────────── locals ─────────────────────────────────╮ │
│ │ pool = <sqlalchemy.pool.impl.QueuePool object at 0x7f9fc8bd3490> │ │
│ │ self = <sqlalchemy.pool.base._ConnectionRecord object at 0x7f9fca45fee0> │ │
│ ╰──────────────────────────────────────────────────────────────────────────╯ │
│ │
│ /home/ryan/.cache/pypoetry/virtualenvs/skyvern-ckmzeAJa-py3.11/lib/python3.11/site-packages/sqla │
│ lchemy/util/langhelpers.py:146 in exit │
│ │
│ 143 │ │ │ exc_type, exc_value, exc_tb = self._exc_info │
│ 144 │ │ │ assert exc_value is not None │
│ 145 │ │ │ self._exc_info = None # remove potential circular references │
│ ❱ 146 │ │ │ raise exc_value.with_traceback(exc_tb) │
│ 147 │ │ else: │
│ 148 │ │ │ self.exc_info = None # remove potential circular references │
│ 149 │ │ │ assert value is not None │
│ │
│ ╭─────────────────────────────────────── locals ───────────────────────────────────────╮ │
│ │ exc_tb = <traceback object at 0x7f9fc8ad3e00> │ │
│ │ exc_type = <class 'psycopg.OperationalError'> │ │
│ │ exc_value = OperationalError('connection failed: fe_sendauth: no password supplied') │ │
│ │ self = <sqlalchemy.util.langhelpers.safe_reraise object at 0x7f9fc8ac8040> │ │
│ │ traceback = None │ │
│ │ type = None │ │
│ │ value = None │ │
│ ╰──────────────────────────────────────────────────────────────────────────────────────╯ │
│ │
│ /home/ryan/.cache/pypoetry/virtualenvs/skyvern-ckmzeAJa-py3.11/lib/python3.11/site-packages/sqla │
│ lchemy/pool/base.py:896 in __connect │
│ │
│ 893 │ │ self.dbapi_connection = None │
│ 894 │ │ try: │
│ 895 │ │ │ self.starttime = time.time() │
│ ❱ 896 │ │ │ self.dbapi_connection = connection = pool._invoke_creator(self) │
│ 897 │ │ │ pool.logger.debug("Created new connection %r", connection) │
│ 898 │ │ │ self.fresh = True │
│ 899 │ │ except BaseException as e: │
│ │
│ ╭───────────────────────────────── locals ─────────────────────────────────╮ │
│ │ pool = <sqlalchemy.pool.impl.QueuePool object at 0x7f9fc8bd3490> │ │
│ │ self = <sqlalchemy.pool.base._ConnectionRecord object at 0x7f9fca45fee0> │ │
│ ╰──────────────────────────────────────────────────────────────────────────╯ │
│ │
│ /home/ryan/.cache/pypoetry/virtualenvs/skyvern-ckmzeAJa-py3.11/lib/python3.11/site-packages/sqla │
│ lchemy/engine/create.py:643 in connect │
│ │
│ 640 │ │ │ │ │ if connection is not None: │
│ 641 │ │ │ │ │ │ return connection │
│ 642 │ │ │ │
│ ❱ 643 │ │ │ return dialect.connect(*cargs, **cparams) │
│ 644 │ │ │
│ 645 │ │ creator = pop_kwarg("creator", connect) │
│ 646 │
│ │
│ ╭─────────────────────────────────────────── locals ───────────────────────────────────────────╮ │
│ │ cargs = [] │ │
│ │ connection_record = <sqlalchemy.pool.base._ConnectionRecord object at 0x7f9fca45fee0> │ │
│ │ cparams = { │ │
│ │ │ 'host': 'localhost', │ │
│ │ │ 'dbname': 'skyvern', │ │
│ │ │ 'user': 'skyvern', │ │
│ │ │ 'context': <psycopg.adapt.AdaptersMap object at 0x7f9fc8bd2fd0> │ │
│ │ } │ │
│ │ dialect = <sqlalchemy.dialects.postgresql.psycopg.PGDialect_psycopg object at │ │
│ │ 0x7f9fd0407f10> │ │
│ ╰──────────────────────────────────────────────────────────────────────────────────────────────╯ │
│ │
│ /home/ryan/.cache/pypoetry/virtualenvs/skyvern-ckmzeAJa-py3.11/lib/python3.11/site-packages/sqla │
│ lchemy/engine/default.py:616 in connect │
│ │
│ 613 │ │
│ 614 │ def connect(self, *cargs, **cparams): │
│ 615 │ │ # inherits the docstring from interfaces.Dialect.connect │
│ ❱ 616 │ │ return self.loaded_dbapi.connect(*cargs, **cparams) │
│ 617 │ │
│ 618 │ def create_connect_args(self, url): │
│ 619 │ │ # inherits the docstring from interfaces.Dialect.create_connect_args │
│ │
│ ╭─────────────────────────────────────────── locals ───────────────────────────────────────────╮ │
│ │ cargs = () │ │
│ │ cparams = { │ │
│ │ │ 'host': 'localhost', │ │
│ │ │ 'dbname': 'skyvern', │ │
│ │ │ 'user': 'skyvern', │ │
│ │ │ 'context': <psycopg.adapt.AdaptersMap object at 0x7f9fc8bd2fd0> │ │
│ │ } │ │
│ │ self = <sqlalchemy.dialects.postgresql.psycopg.PGDialect_psycopg object at │ │
│ │ 0x7f9fd0407f10> │ │
│ ╰──────────────────────────────────────────────────────────────────────────────────────────────╯ │
│ │
│ /home/ryan/.cache/pypoetry/virtualenvs/skyvern-ckmzeAJa-py3.11/lib/python3.11/site-packages/psyc │
│ opg/connection.py:748 in connect │
│ │
│ 745 │ │ │
│ 746 │ │ if not rv: │
│ 747 │ │ │ assert last_ex │
│ ❱ 748 │ │ │ raise last_ex.with_traceback(None) │
│ 749 │ │ │
│ 750 │ │ rv._autocommit = bool(autocommit) │
│ 751 │ │ if row_factory: │
│ │
│ ╭─────────────────────────────────────────── locals ───────────────────────────────────────────╮ │
│ │ attempt = { │ │
│ │ │ 'host': 'localhost', │ │
│ │ │ 'dbname': 'skyvern', │ │
│ │ │ 'user': 'skyvern', │ │
│ │ │ 'hostaddr': '127.0.0.1' │ │
│ │ } │ │
│ │ attempts = [ │ │
│ │ │ { │ │
│ │ │ │ 'host': 'localhost', │ │
│ │ │ │ 'dbname': 'skyvern', │ │
│ │ │ │ 'user': 'skyvern', │ │
│ │ │ │ 'hostaddr': '127.0.0.1' │ │
│ │ │ } │ │
│ │ ] │ │
│ │ autocommit = False │ │
│ │ cls = <class 'psycopg.Connection'> │ │
│ │ conninfo = 'host=localhost dbname=skyvern user=skyvern hostaddr=127.0.0.1' │ │
│ │ context = <psycopg.adapt.AdaptersMap object at 0x7f9fc8bd2fd0> │ │
│ │ cursor_factory = None │ │
│ │ kwargs = {'host': 'localhost', 'dbname': 'skyvern', 'user': 'skyvern'} │ │
│ │ last_ex = OperationalError('connection failed: fe_sendauth: no password supplied') │ │
│ │ params = {'host': 'localhost', 'dbname': 'skyvern', 'user': 'skyvern'} │ │
│ │ prepare_threshold = 5 │ │
│ │ row_factory = None │ │
│ │ rv = None │ │
│ │ timeout = 130 │ │
│ ╰──────────────────────────────────────────────────────────────────────────────────────────────╯ │
╰──────────────────────────────────────────────────────────────────────────────────────────────────╯

@ryanholtschneider2
Copy link

For me the issue was postgres was already running. I closed it, reran setup.sh and it worked fine

@suchintan
Copy link
Contributor

@ryanholtschneider2 that's interesting -- we have a check to see if postgres is already running before running commands.
https://github.com/Skyvern-AI/skyvern/blob/main/setup.sh#L179

A few questions:

  1. Did you have it running in Docker? Or as a native instance?
  2. What do you get as output on the pg_ready command?

@ryanholtschneider2
Copy link

ryanholtschneider2 commented Mar 22, 2024 via email

@ykeremy
Copy link
Contributor Author

ykeremy commented Mar 22, 2024

Another similar issue recently shared in our Discord: https://discord.com/channels/1212486326352617534/1214296823066534021/1220547538294411365

I'm going to try and spend some time fixing this over the weekend, it's safe to say that it's a common issue now.

@ykeremy ykeremy added bug Something isn't working P1 labels Mar 26, 2024
@bholagabbar
Copy link

Yeah this issue happens if you already have postgres running ( I had it running in docker with port mapping), stopped my local instance and reran the setup and it worked fine.

@christopher-r-doucet
Copy link

Any movement / work-arounds on this one?

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
Labels
bug Something isn't working P1
Projects
None yet
Milestone
No milestone
Development

No branches or pull requests
5 participants
@suchintan @christopher-r-doucet @bholagabbar @ykeremy @ryanholtschneider2