NocoDB: deployment crash, migration failure, current transaction is aborted

Migration from 0108002 to 0111005 failed ────────────────────────────────────┐│                                                                              ││   Error                                                                      ││   -----                                                                      ││   error: create index "nc_goya___nc_m2m_rv6ot3evwh_table2_id_index" on       ││   "nc_goya___nc_m2m_rv6ot3evwh" ("table2_id") - current transaction is       ││   aborted, commands ignored until end of transaction block                   ││   at Parser.parseErrorMessage                                                ││   (/usr/src/app/node_modules/pg-protocol/dist/parser.js:287:98)              ││   at Parser.handlePacket                                                     ││   (/usr/src/app/node_modules/pg-protocol/dist/parser.js:126:29)              ││   at Parser.parse                                                            ││   (/usr/src/app/node_modules/pg-protocol/dist/parser.js:39:38)               ││   at Socket.<anonymous>                                                      ││   (/usr/src/app/node_modules/pg-protocol/dist/index.js:11:42)                ││   at Socket.emit (node:events:517:28)                                        ││   at Socket.emit (node:domain:489:12)                                        ││   at addChunk (node:internal/streams/readable:335:12)                        ││   at readableAddChunk (node:internal/streams/readable:308:9)                 ││   at Readable.push (node:internal/streams/readable:245:10)                   ││   at TCP.onStreamRead (node:internal/stream_based

Migration from 0108002 to 0111005 failed ────────────────────────────────────┐│                                                                              ││   Error                                                                      ││   -----                                                                      ││   error: create index "nc_goya___nc_m2m_rv6ot3evwh_table2_id_index" on       ││   "nc_goya___nc_m2m_rv6ot3evwh" ("table2_id") - current transaction is       ││   aborted, commands ignored until end of transaction block                   ││   at Parser.parseErrorMessage                                                ││   (/usr/src/app/node_modules/pg-protocol/dist/parser.js:287:98)              ││   at Parser.handlePacket                                                     ││   (/usr/src/app/node_modules/pg-protocol/dist/parser.js:126:29)              ││   at Parser.parse                                                            ││   (/usr/src/app/node_modules/pg-protocol/dist/parser.js:39:38)               ││   at Socket.<anonymous>                                                      ││   (/usr/src/app/node_modules/pg-protocol/dist/index.js:11:42)                ││   at Socket.emit (node:events:517:28)                                        ││   at Socket.emit (node:domain:489:12)                                        ││   at addChunk (node:internal/streams/readable:335:12)                        ││   at readableAddChunk (node:internal/streams/readable:308:9)                 ││   at Readable.push (node:internal/streams/readable:245:10)                   ││   at TCP.onStreamRead (node:internal/stream_based

==== Validating environment variables ====
[ OK ] PLUGIN_URL correctly set
[ OK ] NEW_URL correctly set
==== Checking if NEW_URL is empty ====
psql: error: connection to server at "roundhouse.proxy.rlwy.net" (35.212.138.205), port 45695 failed: server closed the connection unexpectedly
This probably means the server terminated abnormally
before or while processing the request.
An error occurred. Exiting...

==== Validating environment variables ====
[ OK ] PLUGIN_URL correctly set
[ OK ] NEW_URL correctly set
==== Checking if NEW_URL is empty ====
psql: error: connection to server at "roundhouse.proxy.rlwy.net" (35.212.138.205), port 45695 failed: server closed the connection unexpectedly
This probably means the server terminated abnormally
before or while processing the request.
An error occurred. Exiting...

[Nest] 10  - 01/12/2024, 3:22:50 AM   ERROR [ExceptionHandler] create index "nc_goya___nc_m2m_rv6ot3evwh_table2_id_index" on "nc_goya___nc_m2m_rv6ot3evwh" ("table2_id") - current transaction is aborted, commands ignored until end of transaction block

error: create index "nc_goya___nc_m2m_rv6ot3evwh_table2_id_index" on "nc_goya___nc_m2m_rv6ot3evwh" ("table2_id") - current transaction is aborted, commands ignored until end of transaction block

[Nest] 10  - 01/12/2024, 3:22:50 AM   ERROR [ExceptionHandler] create index "nc_goya___nc_m2m_rv6ot3evwh_table2_id_index" on "nc_goya___nc_m2m_rv6ot3evwh" ("table2_id") - current transaction is aborted, commands ignored until end of transaction block

error: create index "nc_goya___nc_m2m_rv6ot3evwh_table2_id_index" on "nc_goya___nc_m2m_rv6ot3evwh" ("table2_id") - current transaction is aborted, commands ignored until end of transaction block

SELECT
      f.attname AS cn,
      i.relname as key_name,
      ix.indnatts, ix.indkey, f.attnum as seq_in_index,
      pg_catalog.format_type(f.atttypid,f.atttypmod) AS type,
      f.attnotnull as rqd,
      p.contype as cst,
      p.conname as cstn,
      CASE
          WHEN i.oid<>0 THEN true
          ELSE false
      END AS is_index,
      CASE
          WHEN p.contype = 'p' THEN true
          ELSE false
      END AS primarykey,
      CASE
          WHEN p.contype = 'u' THEN 0
      WHEN p.contype = 'p' THEN 0
          ELSE 1
      END AS non_unique_original,
      CASE
          WHEN p.contype = 'p' THEN true
          ELSE false
      END AS primarykey,
      CASE
          WHEN p.contype = 'u' THEN 0
      WHEN p.contype = 'p' THEN 0
          ELSE 1
      END AS non_unique,
      CASE
          WHEN f.atthasdef = 't' THEN pg_get_expr(d.adbin, d.adrelid)
      END AS default  FROM pg_attribute f
      JOIN pg_class c ON c.oid = f.attrelid
      JOIN pg_type t ON t.oid = f.atttypid
      LEFT JOIN pg_attrdef d ON d.adrelid = c.oid AND d.adnum = f.attnum
      LEFT JOIN pg_namespace n ON n.oid = c.relnamespace
      LEFT JOIN pg_constraint p ON p.conrelid = c.oid AND f.attnum = ANY (p.conkey)
      LEFT JOIN pg_class AS g ON p.confrelid = g.oid
      LEFT JOIN pg_index AS ix ON f.attnum = ANY(ix.indkey) and c.oid = f.attrelid and c.oid = ix.indrelid
      LEFT JOIN pg_class AS i ON ix.indexrelid = i.oid
      WHERE
        c.relkind = 'r'::char
      AND n.nspname = '__schema_name__'
      and i.oid<>0
      AND f.attnum > 0
      ORDER BY i.relname, f.attnum;

SELECT
      f.attname AS cn,
      i.relname as key_name,
      ix.indnatts, ix.indkey, f.attnum as seq_in_index,
      pg_catalog.format_type(f.atttypid,f.atttypmod) AS type,
      f.attnotnull as rqd,
      p.contype as cst,
      p.conname as cstn,
      CASE
          WHEN i.oid<>0 THEN true
          ELSE false
      END AS is_index,
      CASE
          WHEN p.contype = 'p' THEN true
          ELSE false
      END AS primarykey,
      CASE
          WHEN p.contype = 'u' THEN 0
      WHEN p.contype = 'p' THEN 0
          ELSE 1
      END AS non_unique_original,
      CASE
          WHEN p.contype = 'p' THEN true
          ELSE false
      END AS primarykey,
      CASE
          WHEN p.contype = 'u' THEN 0
      WHEN p.contype = 'p' THEN 0
          ELSE 1
      END AS non_unique,
      CASE
          WHEN f.atthasdef = 't' THEN pg_get_expr(d.adbin, d.adrelid)
      END AS default  FROM pg_attribute f
      JOIN pg_class c ON c.oid = f.attrelid
      JOIN pg_type t ON t.oid = f.atttypid
      LEFT JOIN pg_attrdef d ON d.adrelid = c.oid AND d.adnum = f.attnum
      LEFT JOIN pg_namespace n ON n.oid = c.relnamespace
      LEFT JOIN pg_constraint p ON p.conrelid = c.oid AND f.attnum = ANY (p.conkey)
      LEFT JOIN pg_class AS g ON p.confrelid = g.oid
      LEFT JOIN pg_index AS ix ON f.attnum = ANY(ix.indkey) and c.oid = f.attrelid and c.oid = ix.indrelid
      LEFT JOIN pg_class AS i ON ix.indexrelid = i.oid
      WHERE
        c.relkind = 'r'::char
      AND n.nspname = '__schema_name__'
      and i.oid<>0
      AND f.attnum > 0
      ORDER BY i.relname, f.attnum;

select schema_name
from information_schema.schemata;

select schema_name
from information_schema.schemata;

select nspname
from pg_catalog.pg_namespace;

select nspname
from pg_catalog.pg_namespace;