Hi I tried updating my default storage using the api PATCH a

Question

Hi I tried updating my default storage using the api PATCH api blocks id since my connection string expired and this is not yet possible using the cli However I m getting a malformed uuid exception while the query does execute perfectly when I query my postgresql database directly I m using prefect 2 0b5 Full stack trace in thread

Mathijs Carlu · Answer

`INFO 10 244 3 3 46808 PATCH blocks 00F6CA32 62C4 4E61 bCC6 6F2FAE7294B3 HTTP 1 1 500 Internal Server Error` `Encountered exception in request ` `Traceback most recent call last ` `File usr local lib python3 8 site packages sqlalchemy engine base py line 1719 in execute context` `context = constructor ` `File usr local lib python3 8 site packages sqlalchemy engine default py line 1070 in init compiled` `param = ` `File usr local lib python3 8 site packages sqlalchemy engine default py line 1071 in lt listcomp gt ` `processors key compiled params key ` `File usr local lib python3 8 site packages sqlalchemy sql type api py line 1631 in process` `return impl processor process param value dialect ` `File usr local lib python3 8 site packages sqlalchemy dialects postgresql asyncpg py line 257 in process` `value = python UUID value ` `File usr local lib python3 8 uuid py line 171 in init ` `raise ValueError badly formed hexadecimal UUID string ` `ValueError badly formed hexadecimal UUID string` `The above exception was the direct cause of the following exception ` `Traceback most recent call last ` `File usr local lib python3 8 site packages starlette middleware errors py line 162 in call ` `await scope receive send ` `File usr local lib python3 8 site packages starlette exceptions py line 93 in call ` `raise exc` `File usr local lib python3 8 site packages starlette exceptions py line 82 in call ` `await scope receive sender ` `File usr local lib python3 8 site packages fastapi middleware asyncexitstack py line 21 in call ` `raise e` `File usr local lib python3 8 site packages fastapi middleware asyncexitstack py line 18 in call ` `await scope receive send ` `File usr local lib python3 8 site packages starlette routing py line 670 in call ` `await route handle scope receive send ` `File usr local lib python3 8 site packages starlette routing py line 266 in handle` `await scope receive send ` `File usr local lib python3 8 site packages starlette routing py line 65 in app` `response = await func request ` `File usr local lib python3 8 site packages prefect orion utilities server py line 101 in handle response scoped depends` `response = await default handler request ` `File usr local lib python3 8 site packages fastapi routing py line 227 in app` `raw response = await run endpoint function ` `File usr local lib python3 8 site packages fastapi routing py line 160 in run endpoint function` `return await dependant call values ` `File usr local lib python3 8 site packages prefect orion api blocks py line 87 in update block data` `result = await models blocks update block ` `File usr local lib python3 8 site packages prefect orion database dependencies py line 112 in async wrapper` `return await fn args kwargs ` `File usr local lib python3 8 site packages prefect orion models blocks py line 136 in update block` `block = await session get db Block block id ` `File usr local lib python3 8 site packages sqlalchemy ext asyncio session py line 296 in get` `return await greenlet spawn ` `File usr local lib python3 8 site packages sqlalchemy util concurrency py3k py line 115 in greenlet spawn` `result = context switch args kwargs ` `File usr local lib python3 8 site packages sqlalchemy orm session py line 2789 in get` `return self get impl ` `File usr local lib python3 8 site packages sqlalchemy orm session py line 2896 in get impl` `return db load fn ` `File usr local lib python3 8 site packages sqlalchemy orm loading py line 530 in load on pk identity` `session execute ` `File usr local lib python3 8 site packages sqlalchemy orm session py line 1696 in execute` `result = conn execute 20 statement params or execution options ` `File usr local lib python3 8 site packages sqlalchemy engine base py line 1631 in execute 20` `return meth self args 10style kwargs 10style execution options ` `File usr local lib python3 8 site packages sqlalchemy sql elements py line 325 in execute on connection` `return connection execute clauseelement ` `File usr local lib python3 8 site packages sqlalchemy engine base py line 1498 in execute clauseelement` `ret = self execute context ` `File usr local lib python3 8 site packages sqlalchemy engine base py line 1725 in execute context` `self handle dbapi exception ` `File usr local lib python3 8 site packages sqlalchemy engine base py line 2043 in handle dbapi exception` `util raise ` `File usr local lib python3 8 site packages sqlalchemy util compat py line 207 in raise ` `raise exception` `File usr local lib python3 8 site packages sqlalchemy engine base py line 1719 in execute context` `context = constructor ` `File usr local lib python3 8 site packages sqlalchemy engine default py line 1070 in init compiled` `param = ` `File usr local lib python3 8 site packages sqlalchemy engine default py line 1071 in lt listcomp gt ` `processors key compiled params key ` `File usr local lib python3 8 site packages sqlalchemy sql type api py line 1631 in process` `return impl processor process param value dialect ` `File usr local lib python3 8 site packages sqlalchemy dialects postgresql asyncpg py line 257 in process` `value = python UUID value ` `File usr local lib python3 8 uuid py line 171 in init ` `raise ValueError badly formed hexadecimal UUID string ` `sqlalchemy exc StatementError builtins ValueError badly formed hexadecimal UUID string` ` SQL SELECT block id AS block id block created AS block created block updated AS block updated block name AS block name block data AS block data block is default storage block AS block is default storage block block block spec id AS block block spec id block spec 1 id AS block spec 1 id block spec 1 created AS block spec 1 created block spec 1 updated AS block spec 1 updated block spec 1 name AS block spec 1 name block spec 1 version AS block spec 1 version block spec 1 type AS block spec 1 type block spec 1 fields AS block spec 1 fields` `FROM block LEFT OUTER JOIN block spec AS block spec 1 ON block spec 1 id = block block spec id` `WHERE block id = s ` ` parameters pk 1 lt built in function id gt ` `ERROR Exception in ASGI application`

Anna Geller · Answer

I have some good news our engineers made significant progress in that regard and this should be possible quite soon I would recommend waiting a bit more we are aware of the issue and it s on our radar to improve this process with storage blocks