execute "ALTER TYPE transaction_actions_protocol ADD VALUE 'aave_v3'"

Open Fluffynorth opened this issue 1 year ago • 0 comments

Description

on postgres v14 erlang is on 25.3 and elixir is on 1.14.x but still getting this error same as everyone else with a new instance and latest blockscout installation /blockscout-backend# mix ecto.migrate warning: Jason.decode!/1 is undefined (module Jason is not available or is yet to be defined) config/config_helper.exs:281: ConfigHelper.parse_json_env_var/2

warning: redefining module ConfigHelper (current version defined in memory) config/config_helper.exs:1

warning: Jason.decode!/1 is undefined (module Jason is not available or is yet to be defined) config/config_helper.exs:281: ConfigHelper.parse_json_env_var/2

warning: redefining module ConfigHelper (current version defined in memory) config/config_helper.exs:1

23:41:33.779 [info] == Running 20230328100414 Explorer.Repo.Migrations.AddTransactionActionTypes.change/0 forward

23:41:33.791 [info] execute "ALTER TYPE transaction_actions_protocol ADD VALUE 'aave_v3'" ** (Postgrex.Error) ERROR 25001 (active_sql_transaction) ALTER TYPE ... ADD cannot run inside a transaction block (ecto_sql 3.11.3) lib/ecto/adapters/sql.ex:1054: Ecto.Adapters.SQL.raise_sql_call_error/1 (elixir 1.14.4) lib/enum.ex:1658: Enum."-map/2-lists^map/1-0-"/2 (ecto_sql 3.11.3) lib/ecto/adapters/sql.ex:1161: Ecto.Adapters.SQL.execute_ddl/4 (ecto_sql 3.11.3) lib/ecto/migration/runner.ex:348: Ecto.Migration.Runner.log_and_execute_ddl/3 (ecto_sql 3.11.3) lib/ecto/migration/runner.ex:117: anonymous fn/6 in Ecto.Migration.Runner.flush/0 (elixir 1.14.4) lib/enum.ex:2468: Enum."-reduce/3-lists^foldl/2-0-"/3 (ecto_sql 3.11.3) lib/ecto/migration/runner.ex:116: Ecto.Migration.Runner.flush/0 (ecto_sql 3.11.3) lib/ecto/migration/runner.ex:311: Ecto.Migration.Runner.perform_operation/3

Type of the installation

Manual from the source code

Type of the JSON RPC archive node

Geth

Type of the chain

Link to the page

localhost

Steps to reproduce

after following the installation guide everything works until mix do ecto.migrate then it gives warning: Jason.decode!/1 is undefined (module Jason is not available or is yet to be defined) config/config_helper.exs:281: ConfigHelper.parse_json_env_var/2

warning: redefining module ConfigHelper (current version defined in memory) config/config_helper.exs:1

warning: Jason.decode!/1 is undefined (module Jason is not available or is yet to be defined) config/config_helper.exs:281: ConfigHelper.parse_json_env_var/2

warning: redefining module ConfigHelper (current version defined in memory) config/config_helper.exs:1

23:41:33.779 [info] == Running 20230328100414 Explorer.Repo.Migrations.AddTransactionActionTypes.change/0 forward

Backend version

Frontend version

none yet

Elixir & Erlang/OTP versions

Elixir 1.14.4 (compiled with Erlang/OTP 25)

Operating system

Ubuntu

Additional information

No response

Aug 21 '24 23:08 Fluffynorth