near / near-indexer-for-explorer

Watch NEAR network and store all the data from NEAR blockchain to PostgreSQL database
https://near-indexers.io/docs/projects/near-indexer-for-explorer
GNU General Public License v3.0
123 stars 56 forks source link

`diesel migration` fails with `Failed with: role "readonly" does not exist` #227

Closed mieubrisse closed 2 years ago

mieubrisse commented 2 years ago

This is the same as #205 , but in a different script

Running migration 2020-12-07-153402_initial_schema

Running migration 2021-01-14-170424_index-receipt-originated-from-transaction-hash

Running migration 2021-01-20-152056_index-transactions-receiver-account-id

Running migration 2021-03-11-123839_index-action-kind-and-status

Running migration 2021-04-22-090505_execution_outcomes_replace_chunk_relation_with_shard_id

Running migration 2021-04-28-154439_denormalize_action_receipt_actions

Running migration 2021-05-06-093622_additional_indexes_for_action_receipt_actions

Running migration 2021-05-07-115559_convert_args_base64_to_args_json

Running migration 2021-05-10-084700_indexer_on_args_field

Running migration 2021-05-27-154211_account_changes_unique_idx

Running migration 2021-06-02-173100_add_migration_state_change_reason_kind

Running migration 2021-06-09-102523_grant_select_on_new_tables

Executing migration script /near/indexer-explorer/migrations/2021-06-09-102523_grant_select_on_new_tables/up.sql

Failed with: role "readonly" does not exist
frol commented 2 years ago

@telezhnaya Was it completely addressed?

mieubrisse commented 2 years ago

Hey all, just wanted to check back up on this - this is blocking us from building a Docker image off the latest NEAR code

khorolets commented 2 years ago

@telezhnaya could you please take a look when you have a spare minute? :)