Error during egress request

We are on Scale plan and we noticed the below error when requesting for egress

Room URL - Sign in | LiveKit Cloud

Error:

ERROR: restart transaction: TransactionRetryWithProtoRefreshError: TransactionAbortedError(ABORT_REASON_TIMESTAMP_CACHE_REJECTED): \"sql txn\" meta={id=f9c34c69 key=/Table/146/17/\"EG_nNaGPdmCjpaY\"/0 iso=Serializable pri=0.04252568 epo=0 ts=1774301157.544957196,2 min=1774301156.983865918,0 seq=6} lock=true stat=PENDING rts=1774301157.544957196,2 wto=false gul=1774301157.233865918,0 obs={n13@1774301156.983865918,0 n25@1774301157.000285374,0 n26@1774301157.000008090,0 n27@1774301157.000204047,0} (SQLSTATE 40001), status=500)

Traceback:

Traceback (most recent call last):\n  File \"/egress.py\", line 183, in audio_egress\n    res = await livekit_api.egress.start_room_composite_egress(req)\n          ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^\n  File \"/usr/local/lib/python3.11/site-packages/livekit/api/egress_service.py\", line 41, in start_room_composite_egress\n    return await self._client.request(\n           ^^^^^^^^^^^^^^^^^^^^^^^^^^^\n  File \"/usr/local/lib/python3.11/site-packages/livekit/api/twirp_client.py\", line 129, in request\n    raise TwirpError(\nlivekit.api.twirp_client.TwirpError: TwirpError(code=unknown, message=ERROR: restart transaction: TransactionRetryWithProtoRefreshError: TransactionAbortedError(ABORT_REASON_TIMESTAMP_CACHE_REJECTED): \"sql txn\" meta={id=f9c34c69 key=/Table/146/17/\"EG_nNaGPdmCjpaY\"/0 iso=Serializable pri=0.04252568 epo=0 ts=1774301157.544957196,2 min=1774301156.983865918,0 seq=6} lock=true stat=PENDING rts=1774301157.544957196,2 wto=false gul=1774301157.233865918,0 obs={n13@1774301156.983865918,0 n25@1774301157.000285374,0 n26@1774301157.000008090,0 n27@1774301157.000204047,0} (SQLSTATE 40001), status=500)\n",

Hey @Zaheer_Abbas,

Thanks for reporting the issue. It’s a bug on LiveKit side affecting relatively small number of requests - caused by a dependency update - team is already working on fixing it. I will let you know once the fix is deployed.

Best,

Milos

1 Like

Thanks for the response Milos

Hello @Milos_Pesic - we observed the error again today just now.

{"error": "TwirpError(code=unknown, message=ERROR: restart transaction: TransactionRetryWithProtoRefreshError: TransactionRetryError: retry txn (RETRY_ASYNC_WRITE_FAILURE - missing intent on: /Table/146/15/\"p_3tqm7ro6kbs\"/NULL/\"EG_P7xvC7nyefnB\"/0): \"sql txn\" meta={id=bd7380fe key=/Table/146/17/\"EG_P7xvC7nyefnB\"/0 iso=Serializable pri=0.03149984 epo=0 ts=1774958664.969506317,2 min=1774958664.368834661,0 seq=6} lock=true stat=PENDING rts=1774958664.969506317,2 wto=false gul=1774958664.618834661,0 obs={n7@1774958664.371400871,0 n13@1774958664.368834661,0 n15@1774958664.477099777,0 n25@1774958664.371319154,0 n26@1774958664.371183401,0} (SQLSTATE 40001), status=500)", "traceback": "Traceback (most recent call last):\n  File \"/service/egress.py\", line 183, in audio_egress\n    res = await livekit_api.egress.start_room_composite_egress(req)\n          ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^\n  File \"/usr/local/lib/python3.11/site-packages/livekit/api/egress_service.py\", line 41, in start_room_composite_egress\n    return await self._client.request(\n           ^^^^^^^^^^^^^^^^^^^^^^^^^^^\n  File \"/usr/local/lib/python3.11/site-packages/livekit/api/twirp_client.py\", line 129, in request\n    raise TwirpError(\nlivekit.api.twirp_client.TwirpError: TwirpError(code=unknown, message=ERROR: restart transaction: TransactionRetryWithProtoRefreshError: TransactionRetryError: retry txn (RETRY_ASYNC_WRITE_FAILURE - missing intent on: /Table/146/15/\"p_3tqm7ro6kbs\"/NULL/\"EG_P7xvC7nyefnB\"/0): \"sql txn\" meta={id=bd7380fe key=/Table/146/17/\"EG_P7xvC7nyefnB\"/0 iso=Serializable pri=0.03149984 epo=0 ts=1774958664.969506317,2 min=1774958664.368834661,0 seq=6} lock=true stat=PENDING rts=1774958664.969506317,2 wto=false gul=1774958664.618834661,0 obs={n7@1774958664.371400871,0 n13@1774958664.368834661,0 n15@1774958664.477099777,0 n25@1774958664.371319154,0 n26@1774958664.371183401,0} (SQLSTATE 40001), status=500)\n", "timestamp": "2026-03-31T12:04:24.730878+00:00"}

Hey @Zaheer_Abbas - the issue has been fixed, it’s pending release - will let you know once it’s out. Thanks for reporting!

2 Likes

@Milos_Pesic - We still see the error :disappointed_face:

Room ID - RM_NWt3KHU5jMAd

{"levelname": "INFO","event": "Error in starting original audio egress", "message": "", "error": "TwirpError(code=unknown, message=ERROR: restart transaction: TransactionRetryWithProtoRefreshError: TransactionAbortedError(ABORT_REASON_TIMESTAMP_CACHE_REJECTED): \"sql txn\" meta={id=c3007e94 key=/Table/146/17/\"EG_s3ZbWyq59F97\"/0 iso=Serializable pri=0.02974239 epo=0 ts=1776095238.055396910,2 min=1776095237.502378257,0 seq=6} lock=true stat=PENDING rts=1776095238.055396910,2 wto=false gul=1776095237.752378257,0 obs={n7@1776095237.502378257,0 n15@1776095237.518231471,0 n26@1776095237.518124429,0} (SQLSTATE 40001), status=500)", "traceback": "Traceback (most recent call last):\n  File \"/home/app/agent-orchestrator/agent_orchestrator/service/egress.py\", line 183, in audio_egress\n    res = await livekit_api.egress.start_room_composite_egress(req)\n          ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^\n  File \"/usr/local/lib/python3.11/site-packages/livekit/api/egress_service.py\", line 41, in start_room_composite_egress\n    return await self._client.request(\n           ^^^^^^^^^^^^^^^^^^^^^^^^^^^\n  File \"/usr/local/lib/python3.11/site-packages/livekit/api/twirp_client.py\", line 129, in request\n    raise TwirpError(\nlivekit.api.twirp_client.TwirpError: TwirpError(code=unknown, message=ERROR: restart transaction: TransactionRetryWithProtoRefreshError: TransactionAbortedError(ABORT_REASON_TIMESTAMP_CACHE_REJECTED): \"sql txn\" meta={id=c3007e94 key=/Table/146/17/\"EG_s3ZbWyq59F97\"/0 iso=Serializable pri=0.02974239 epo=0 ts=1776095238.055396910,2 min=1776095237.502378257,0 seq=6} lock=true stat=PENDING rts=1776095238.055396910,2 wto=false gul=1776095237.752378257,0 obs={n7@1776095237.502378257,0 n15@1776095237.518231471,0 n26@1776095237.518124429,0} (SQLSTATE 40001), status=500)\n", "timestamp": "2026-04-13T15:47:17.866740+00:00"}