SQL error during migration

[info] using default value for database `ssl` parameter
[info] using default value for database `password` parameter
[info] connecting to database [hostname: "localhost", port: 5432, ssl: false, username: "air", database: "air_dev"]
[info] Accepting PostgreSQL requests on port 8432
[info] == Running 20201209140829 Air.Repo.Migrations.MaterializeTotalTime.change/0 forward
[info] alter table queries
[info] execute "UPDATE queries SET total_time = (SELECT SUM(CAST(value as int)) FROM jsonb_each(time_spent))"
[info] Application air exited: Air.start(:normal, []) returned an error: shutdown: failed to start child: Air.Repo.Migrator
    ** (EXIT) an exception was raised:
        ** (Postgrex.Error) ERROR 42846 (cannot_coerce) cannot cast type jsonb to integer

    query: UPDATE queries SET total_time = (SELECT SUM(CAST(value as int)) FROM jsonb_each(time_spent))
            (ecto_sql 3.5.3) lib/ecto/adapters/sql.ex:751: Ecto.Adapters.SQL.raise_sql_call_error/1
            (elixir 1.11.1) lib/enum.ex:1399: Enum."-map/2-lists^map/1-0-"/2
            (ecto_sql 3.5.3) lib/ecto/adapters/sql.ex:838: Ecto.Adapters.SQL.execute_ddl/4
            (ecto_sql 3.5.3) lib/ecto/migration/runner.ex:343: Ecto.Migration.Runner.log_and_execute_ddl/3
            (ecto_sql 3.5.3) lib/ecto/migration/runner.ex:117: anonymous fn/6 in Ecto.Migration.Runner.flush/0
            (elixir 1.11.1) lib/enum.ex:2181: Enum."-reduce/3-lists^foldl/2-0-"/3
            (ecto_sql 3.5.3) lib/ecto/migration/runner.ex:116: Ecto.Migration.Runner.flush/0
            (ecto_sql 3.5.3) lib/ecto/migration/runner.ex:280: Ecto.Migration.Runner.perform_operation/3
            (stdlib 3.13.2) timer.erl:166: :timer.tc/1
            (ecto_sql 3.5.3) lib/ecto/migration/runner.ex:25: Ecto.Migration.Runner.run/8
            (ecto_sql 3.5.3) lib/ecto/migrator.ex:349: Ecto.Migrator.attempt/8
            (ecto_sql 3.5.3) lib/ecto/migrator.ex:250: anonymous fn/5 in Ecto.Migrator.do_up/5
            (ecto_sql 3.5.3) lib/ecto/migrator.ex:331: anonymous fn/3 in Ecto.Migrator.run_maybe_in_transaction/6
            (ecto_sql 3.5.3) lib/ecto/adapters/sql.ex:1027: anonymous fn/3 in Ecto.Adapters.SQL.checkout_or_transaction/4
            (db_connection 2.3.0) lib/db_connection.ex:1426: DBConnection.run_transaction/4
            (ecto_sql 3.5.3) lib/ecto/migrator.ex:330: Ecto.Migrator.run_maybe_in_transaction/6
            (elixir 1.11.1) lib/task/supervised.ex:90: Task.Supervised.invoke_mfa/2
            (elixir 1.11.1) lib/task/supervised.ex:35: Task.Supervised.reply/5
            (stdlib 3.13.2) proc_lib.erl:226: :proc_lib.init_p_do_apply/3
Aircloak / aircloak

SQL error during migration #4848
