The query was not executed due to a failed transaction

[lylejohnson]

Describe the bug
In some environments, when I attempt to apply migrations, they eventually fail with a string of error messages:

Executing migration AddSkyfallDatabaseUser...
Executing migration AddSubjectAreas...
Executing migration AddAncestorsFunction...
Executing migration AddModelSchemas...

Error:
   0: [91mThe query was not executed due to a failed transaction. There was a problem with a datastore transaction: Resource busy:
      The query was not executed due to a failed transaction. There was a problem with a datastore transaction: Resource busy:
      The query was not executed due to a failed transaction. There was a problem with a datastore transaction: Resource busy:
      The query was not executed due to a failed transaction. There was a problem with a datastore transaction: Resource busy:
       ... etc. ...
Location:

   [35msrc/surrealdb.rs[0m:[35m185[0m

  ΓöüΓöüΓöüΓöüΓöüΓöüΓöüΓöüΓöüΓöüΓöüΓöüΓöüΓöüΓöüΓöüΓöüΓöüΓöüΓöüΓöüΓöüΓöüΓöüΓöüΓöüΓöüΓöüΓöüΓöüΓöüΓöüΓöüΓöü BACKTRACE ΓöüΓöüΓöüΓöüΓöüΓöüΓöüΓöüΓöüΓöüΓöüΓöüΓöüΓöüΓöüΓöüΓöüΓöüΓöüΓöüΓöüΓöüΓöüΓöüΓöüΓöüΓöüΓöüΓöüΓöüΓöüΓöüΓöüΓöüΓöü

   1: [91mcolor_eyre::config::EyreHook::into_eyre_hook::{{closure}}[0m[90m::hd58574d69403e4f4[0m
      at [35m<unknown source file>[0m:[35m<unknown line>[0m
   2: [91meyre::capture_handler[0m[90m::h571c3b02f4175dfd[0m
      at [35m<unknown source file>[0m:[35m<unknown line>[0m

   3: [91meyre::error::<impl eyre::Report>::from_adhoc[0m[90m::hf4a395f0cfcce34f[0m

      at [35m<unknown source file>[0m:[35m<unknown line>[0m

   4: [91msurrealdb_migrations::surrealdb::apply_in_transaction::{{closure}}[0m[90m::h692b25d61a008a86[0m

      at [35m<unknown source file>[0m:[35m<unknown line>[0m

   5: [91msurrealdb_migrations::apply::main::{{closure}}[0m[90m::h3333c1f4bd1b6ffb[0m

      at [35m<unknown source file>[0m:[35m<unknown line>[0m

   6: [91msurrealdb_migrations::sub_main::{{closure}}[0m[90m::heb7ce680aed0388c[0m

      at [35m<unknown source file>[0m:[35m<unknown line>[0m

   7: [91mtokio::runtime::park::CachedParkThread::block_on[0m[90m::h88e4d66c0da5fcbb[0m

      at [35m<unknown source file>[0m:[35m<unknown line>[0m

   8: [91mtokio::runtime::context::runtime::enter_runtime[0m[90m::h225af3bf77be9681[0m

      at [35m<unknown source file>[0m:[35m<unknown line>[0m

   9: [91mtokio::runtime::runtime::Runtime::block_on[0m[90m::h20bf5f40db011f58[0m

      at [35m<unknown source file>[0m:[35m<unknown line>[0m

  10: [91msurrealdb_migrations::main[0m[90m::he8d920c489bffe53[0m

      at [35m<unknown source file>[0m:[35m<unknown line>[0m

  11: [32mstd::sys::backtrace::__rust_begin_short_backtrace[0m[90m::hd550d6ef8eba798d[0m

      at [35m<unknown source file>[0m:[35m<unknown line>[0m

  12: [32mstd::rt::lang_start::{{closure}}[0m[90m::h1a879eb8003cddd7[0m

      at [35m<unknown source file>[0m:[35m<unknown line>[0m

  13: [32mstd::rt::lang_start_internal[0m[90m::h93b3b742566fb30c[0m

      at [35m<unknown source file>[0m:[35m<unknown line>[0m

  14: [32mmain[0m[90m<unknown>[0m

      at [35m<unknown source file>[0m:[35m<unknown line>[0m

Run with COLORBT_SHOW_HIDDEN=1 environment variable to disable frame filtering.

time="2025-07-01T14:51:55.353Z" level=info msg="sub-process exited" argo=true error="<nil>"

Error: exit status 1

Expected behavior
I expect the database migrations to be applied without errors.

Information
Please complete the following information and remove the unnecessary ones.

• SurrealDB version: 2.1.2
• surrealdb-migrations version: 2.2.0