Update setup.sh to create DB user with a password

[skyvern-ai]

Update setup.sh to create DB user with a password

[ryanholtschneider2]

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]

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

[suchintan]

@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]

Native instance. When I ran pg_ready it said something to the effect of the pg was running

…

On Fri, Mar 22, 2024 at 12:03 AM Suchintan ***@***.***> wrote: @ryanholtschneider2 <https://github.com/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? — Reply to this email directly, view it on GitHub <#113 (comment)>, or unsubscribe <https://github.com/notifications/unsubscribe-auth/BCBQYUL7KLEGHD3ROBKN6K3YZOUQ7AVCNFSM6AAAAABE6O5THOVHI2DSMVQWIX3LMV43OSLTON2WKQ3PNVWWK3TUHMZDAMJUGMYTIMJYGM> . You are receiving this because you were mentioned.Message ID: ***@***.***>

[ykeremy]

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.

[bholagabbar]

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]

Any movement / work-arounds on this one?