Getting this error in UI when trying to delete a LiveKit project on cloud.
Unable to delete project: \[internal\] ERROR: restart transaction: TransactionRetryWithProtoRefreshError: TransactionRetryError: retry txn (RETRY_SERIALIZABLE - failed preemptive refresh due to encountered recently written committed value /Table/136/1/"J9aCXx5vNxkToMUZV7apCG"/0 @1784662232.165345707,2): "sql txn" meta={id=2fe5e2f7 key=/Table/154/1/"3XdVaAGE8KgP9t3a4ySpHK"/0 iso=Serializable pri=0.02179118 epo=0 ts=1784662234.533548671,2 min=1784662229.562917864,0 seq=30} lock=true stat=PENDING rts=1784662229.562917864,0 wto=false gul=1784662229.812917864,0 obs={n6@1784662229.629411430,0 n7@1784662232.817195139,0 n9@1784662232.432762624,0 n13@1784662229.657565044,0 n15@1784662229.657474533,0, ...} (SQLSTATE 40001)
`
Trying to reproduce this, I saw this issue when I tried to delete a very old project of mine.
When I retried, the project was successfully deleted.
Trying to reproduce this with a newly created project, I am unable to do so 
.
I wonder:
- Which project ID are you trying to delete?
- Did you retry after you got the UI error the first time?
Project ID: p_5m4op51qmt8
I did retry multiple times earlier and also I just retried again, same error.
FYI, this is not a blocker for us. It’s just that we have too many unused projects within the company and I’m cleaning up.
Thank you, I see this occasionally, but I am still trying to find a reliable reproduction, but I will keep trying. Whenever I was able to occasionally reproduce, it always successfully deleted on the second attempt.
If you first remove the other user from that project, I believe you will be able to delete it. I think I now have a reliable reproduction and have raised with the team.
Thanks for reporting.