edgedb-cli icon indicating copy to clipboard operation
edgedb-cli copied to clipboard
verified publisher icon edgedb

`TransactionDeadlockError: deadlock detected` `edgedb error: error in one of the migrations`

Open jackfischer opened this issue 2 years ago • 1 comments

Follow up from discord

  • EdgeDB Version: 3.1
  • EdgeDB CLI Version: 3.4.0+4d95a2c
  • OS Version: macos 10.13

Steps to Reproduce:

  1. Migrating a remote instance via edgedb migrate -I instance_name
  2. Fails with the following CLI output,
edgedb error: TransactionDeadlockError: deadlock detected
edgedb error: error in one of the migrations

This was ultimately resolved by retrying. According to @elprans these should be automatically retried.

Noticed there was not a verbose option on edgedb migrate so no additional information to provide there.

jackfischer avatar Jul 19 '23 00:07 jackfischer

Another report here, https://discord.com/channels/841451783728529451/849377751370432573/1162496692822745241

For anybody else looking at this, the issue was that some long running queries were deadlocking with the migration while trying to modify postgres views

jackfischer avatar Oct 18 '23 21:10 jackfischer