Errors connected to migrations and DATABASE_URL env variable when using a mounted volume

[bartekn]

This has been reported by two different users in a linked issue. We do check if everything runs in integration tests but not with mounted volume:

Hello @leighmcculloch , may we also drive to compile a new docker image of testing tag with the integration fixed, many thanks

the latest horizon seem changed something asking for DATABASE_URL,
so just mounting the binary into old image like below would not work
"/data/stellar/app/horizon-v1.11.0-linux-amd64/horizon:/opt/stellar/horizon/bin/horizon"

it requires crafting DATABASE_URL envvar, after which I still couldn't apply migration automatically/manually

starting horizon...
2020/11/03 05:24:51 There are 44 migrations to apply in the "up" direction.
2020/11/03 05:24:51 The necessary migrations are: [1_initial_schema.sql 2_index_participants_by_toid.sql 3_use_sequence_in_history_accounts.sql 4_add_protocol_version.sql 5_create_trades_table.sql 6_create_assets_table.sql 7_modify_trades_table.sql 8_add_aggregators.sql 8_create_asset_stats_table.sql 9_add_header_xdr.sql 10_add_trades_price.sql 11_add_trades_account_index.sql 12_asset_stats_amount_string.sql 13_trade_offer_ids.sql 14_fix_asset_toml_field.sql 15_ledger_failed_txs.sql 16_ingest_failed_transactions.sql 17_transaction_fee_paid.sql 18_account_for_signers.sql 19_offers.sql 20_account_for_signer_index.sql 21_trades_remove_zero_amount_constraints.sql 22_trust_lines.sql 23_exp_asset_stats.sql 24_accounts.sql 25_expingest_rename_columns.sql 26_exp_history_ledgers.sql 27_exp_history_transactions.sql 28_exp_history_operations.sql 29_exp_history_assets.sql 30_exp_history_trades.sql 31_exp_history_effects.sql 32_drop_exp_history_tables.sql 33_remove_unused.sql 34_fee_bump_transactions.sql 35_drop_participant_id.sql 36_deleted_offers.sql 37_add_tx_set_operation_count_to_ledgers.sql 38_add_constraints.sql 39_claimable_balances.sql 39_history_trades_indices.sql 40_fix_inner_tx_max_fee_constraint.sql 41_add_sponsor_to_state_tables.sql 42_add_num_sponsored_and_num_sponsoring_to_accounts.sql]
2020/11/03 05:24:51 A database migration is required to run this version (v1.11.0) of Horizon. Run "horizon db migrate up" to update your DB. Consult the Changelog (https://github.com/stellar/go/blob/master/services/horizon/CHANGELOG.md) for more information.

root@bstg-xlm-1:/opt/stellar/horizon/bin# ./horizon db migrate up
2020/11/03 05:29:47 pq: relation "offers" already exists handling 19_offers.sql

Originally posted by @jun0tpyrc in stellar/go#3180 (comment)

[tundak]

I did run horizon https://github.com/stellar/go/releases/tag/horizon-v1.11.0 linux amd64, non docker on ubuntu 20.04 when i try db init in my new setup it give the error stellar/go#3180 (comment)

[bartekn]

Fixed in stellar/go#3192 and Horizon 1.11.1.