I'm trying to set up beaconchain and I get this error
There was an error executing Starlark code An error occurred executing instruction (number 80) at github.com/ethpandaops/ethereum-package/src/full_beaconchain/full_beaconchain_launcher.star[177:14]: exec(service_name="beaconchain-schema-initializer", recipe=ExecRecipe(command=["./misc", "-config", "/app/config/beaconchain-config.yml", "-command", "applyDbSchema"]), description="Applying db schema") Caused by: Exec returned exit code '1' that is not part of the acceptable status codes '[0]', with output: "time="2025-02-02T13:23:10Z" level=info msg="compile time check completed" module=templates\ntime="2025-02-02T13:23:10Z" level=info msg=starting config=/app/config/beaconchain-config.yml version=f75902b\ntime="2025-02-02T13:23:10Z" level=info msg="loaded chain config from node with genesis time 1738502580" module=oauth\ntime="2025-02-02T13:23:10Z" level=info msg="using RedisCacheEndpoint beaconchain-redis:6379 as RedisSessionStoreEndpoint as no dedicated RedisSessionStoreEndpoint was provided"\ntime="2025-02-02T13:23:10Z" level=info msg="did init config" clCurrency=ETH configName=testnet depositChainID=3151908 depositContractAddress=0x4242424242424242424242424242424242424242 depositNetworkID=3151908 elCurrency=ETH genesisTimestamp=1738502580 genesisValidatorsRoot=0xd1ec305b97bf6336571c2348e4a8bf173684b0cdb7e55f7e6554d51f8478b5a3 mainCurrency=ETH\ntime="2025-02-02T13:23:10Z" level=info msg="connecting to postgres database beaconchain-postgres:5432/blockscout as writer with 50/10 max open/idle connections" module=db\ntime="2025-02-02T13:23:10Z" level=info msg="connecting to postgres database beaconchain-postgres:5432/blockscout as writer with 50/10 max open/idle connections" module=db\ntime="2025-02-02T13:23:10Z" level=info msg="initializing erigon client at http://172.16.0.9:8545" module=rpc\ntime="2025-02-02T13:23:10Z" level=info msg="using emulated local bigtable environment, setting BIGTABLE_EMULATOR_HOST env variable to 172.16.0.27:9000" module=db\ntime="2025-02-02T13:23:10Z" level=info msg="connecting to postgres database beaconchain-postgres:5432/blockscout as reader with 50/10 max open/idle connections" module=db\ntime="2025-02-02T13:23:11Z" level=info msg="connecting to postgres database beaconchain-postgres:5432/blockscout as reader with 50/10 max open/idle connections" module=db\ntime="2025-02-02T13:23:11Z" level=info msg="applying db schema"\n2025/02/02 13:23:11 OK 20230330131622_init_database.sql (793.83ms)\n2025/02/02 13:23:12 OK 20230404090710_add_validators_indices.sql (21.25ms)\n2025/02/02 13:23:12 OK 20230411051948_add_sync_committee_index.sql (6.49ms)\n2025/02/02 13:23:12 OK 20230411195211_add_proposer_statistic_columns.sql (4.08ms)\n2025/02/02 13:23:12 OK 20230426113138_alter_graffitiwall_pk.sql (20.04ms)\n2025/02/02 13:23:12 OK 20230602023910_add_withdrawals_recipient_index.sql (12.7ms)\n2025/02/02 13:23:12 OK 20230612084855_add_missing_indices.sql (193.79ms)\n2025/02/02 13:23:12 OK 20230613125801_activationeligibilityepoch_for_validator_queue_deposits.sql (10.88ms)\n2025/02/02 13:23:12 OK 20230614122901_add_ens_tables.sql (17.63ms)\n2025/02/02 13:23:12 OK 20230619180200_add_more_missing_indices.sql (58.61ms)\n2025/02/02 13:23:12 OK 20230626085200_add_validator_stats_status_comulumn.sql (11.08ms)\n2025/02/02 13:23:12 OK 20230628120206_add_index_for_withrawalsindex.sql (7.72ms)\n2025/02/02 13:23:12 OK 20230629144437_add_graffiti_stats_tables.sql (6.62ms)\n2025/02/02 13:23:12 OK 20230629144438_add_graffiti_stats_indices.sql (9.08ms)\n2025/02/02 13:23:12 OK 20230713114300_add_withdrawals_indices.sql (22.93ms)\n2025/02/02 13:23:12 OK 20230719135453_add_total_attestations_and_sync.sql (2.67ms)\n2025/02/02 13:23:12 OK 20230801123436_add_missing_braodacaster_tables.sql (5.35ms)\n2025/02/02 13:23:12 OK 20230814085701_add_validator_stats_total_accumulation_column.sql (3.88ms)\n2025/02/02 13:23:12 OK 20230814124202_add_from_address_to_text_eth1_deposits.sql (16.47ms)\n2025/02/02 13:23:12 OK 20230814224221_fix_performance_xd.sql (2.22ms)\n2025/02/02 13:23:12 OK 20230816124700_add_not_null_constraint_to_cl_proposer_performance_total.sql (1.82ms)\n2025/02/02 13:23:12 OK 20230816124705_remove_constraints_in_validator_performance.sql (18.38ms)\n2025/02/02 13:23:12 OK 20230817133706_remove_invalid_validator_stats.sql (2.82ms)\n2025/02/02 13:23:12 OK 20230828105207_vlidator_performance_column_types.sql (17.51ms)\n2025/02/02 13:23:12 OK 20230828113508_add_chain_head_table.sql (10.74ms)\n2025/02/02 13:23:12 OK 20230828130109_rem_proposer_rewards_statistic_columns.sql (2.91ms)\n2025/02/02 13:23:12 OK 20230830144100_improve_blocks_bls_change_pubkey_text_idx.sql (41.36ms)\n2025/02/02 13:23:12 OK 20230904092500_remove_streakleaderboard_table.sql (20.47ms)\n2025/02/02 13:23:12 OK 20230912091400_remove_chain_head_table.sql (17.41ms)\n2025/02/02 13:23:12 OK 20231004173000_dencun.sql (31.07ms)\n2025/02/02 13:23:12 OK 20231013104500_add_blocks_finalized_column.sql (15.85ms)\n2025/02/02 13:23:12 OK 20231017101000_add_blocks_finalized_index.sql (12.14ms)\n2025/02/02 13:23:12 OK 20231102075500_add_total_withdrawals_stats.sql (1.86ms)\n2025/02/02 13:23:12 OK 20231127132500_add_total_deposits.sql (2.2ms)\n2025/02/02 13:23:12 OK 20231128101000_add_stripe_update_column.sql (1.66ms)\n2025/02/02 13:23:12 OK 20231128164000_add_graffiti_stats_status.sql (3.97ms)\n2025/02/02 13:23:12 OK 20240108133931_app_subscriptions_id.sql (1.32ms)\n2025/02/02 13:23:12 OK 20240125110000_add_apps_subs_view.sql (2.67ms)\n2025/02/02 13:23:12 OK 20240125120000_add_ratelimits.sql (49.89ms)\n2025/02/02 13:23:12 OK 20240311140000_add_users_password_reset_not_allowed.sql (1.59ms)\n2025/02/02 13:23:12 OK 20240410150926_add_msg_sender_eth1_deposits.sql (13.27ms)\n2025/02/02 13:23:12 OK 20240422141500_add_withdrawals_amount_index.sql (4.87ms)\n2025/02/02 13:23:12 OK 20240502161746_execution_rewards.sql (21.31ms)\n2025/02/02 13:23:12 OK 20240527142321_consensus_rewards.sql (9.09ms)\n2025/02/02 13:23:12 OK 20240723105539_add_ratelimit_buckets.sql (20.42ms)\n2025/02/02 13:23:12 OK 20240820111812_add_v2_tables.sql (88.86ms)\n2025/02/02 13:23:12 OK 20240820141500_is_archived.sql (1.28ms)\n2025/02/02 13:23:12 OK 20240822134034_add_address_tags.sql (7.81ms)\n2025/02/02 13:23:12 OK 20241003062452_validator_status_counts.sql (5.19ms)\ntime="2025-02-02T13:23:12Z" level=fatal msg="error applying db schema" error="ERROR 20241120092635_add_validatorindex_slot_index_withdrawals_table.sql: failed to run SQL migration: failed to execute SQL query \"SELECT 'creating idx_blocks_withdrawals_validatorindex_slot';\\nCREATE INDEX CONCURRENTLY IF NOT EXISTS idx_blocks_withdrawals_validatorindex_slot ON blocks_withdrawals (validatorindex, block_slot DESC);\": ERROR: CREATE INDEX CONCURRENTLY cannot run inside a transaction block (SQLSTATE 25001)"\n"
Error encountered running Starlark code.
He asks for my wallet details. Does this affect the solution to my problem?
This is scam! Do not interact with @Agodlashdev or that chat in any way!
It looks like your issue is coming from the beaconcha.in explorer. There is a SQL error during schema initialization..
This is scam! Do not interact with @Agodlashdev or that chat in any way!
It looks like your issue is coming from the beaconcha.in explorer. There is a SQL error during schema initialization..
and how to solve the problem? please answer me, thank you
any inputs on this how to solve ? , Im facing the same error when running my network with my own setup.yaml
this is the file
participants:
- el_type: geth
cl_type: prysm
count: 2
additional_services:
- tx_fuzz
- blockscout
- full_beaconchain_explorer
blockscout_params:
# blockscout docker image to use
# Defaults to blockscout/blockscout:latest
image: "blockscout/blockscout:latest"
# blockscout smart contract verifier image to use
# Defaults to ghcr.io/blockscout/smart-contract-verifier:latest
verif_image: "ghcr.io/blockscout/smart-contract-verifier:latest"
# Frontend image
# Defaults to ghcr.io/blockscout/frontend:latest
frontend_image: "ghcr.io/blockscout/frontend:latest"
This is error im encountering at
Applying db schema
There was an error executing Starlark code
An error occurred executing instruction (number 61) at github.com/ethpandaops/ethereum-package/src/full_beaconchain/full_beaconchain_launcher.star[177:14]:
exec(service_name="beaconchain-schema-initializer", recipe=ExecRecipe(command=["./misc", "-config", "/app/config/beaconchain-config.yml", "-command", "applyDbSchema"]), description="Applying db schema")
Caused by: Exec returned exit code '1' that is not part of the acceptable status codes '[0]', with output:
"time=\"2025-04-11T07:31:38Z\" level=info msg=starting config=/app/config/beaconchain-config.yml version=bb9115a\ntime=\"2025-04-11T07:31:38Z\" level=info msg=\"loaded chain config from node with genesis time 1744356693\" module=oauth\ntime=\"2025-04-11T07:31:38Z\" level=info msg=\"using RedisCacheEndpoint beaconchain-redis:6379 as RedisSessionStoreEndpoint as no dedicated RedisSessionStoreEndpoint was provided\"\ntime=\"2025-04-11T07:31:38Z\" level=info msg=\"did init config\" clCurrency=ETH configName=testnet depositChainID=3151908 depositContractAddress=0x4242424242424242424242424242424242424242 depositNetworkID=3151908 elCurrency=ETH genesisTimestamp=1744356693 genesisValidatorsRoot=0xd1ec305b97bf6336571c2348e4a8bf173684b0cdb7e55f7e6554d51f8478b5a3 mainCurrency=ETH\ntime=\"2025-04-11T07:31:38Z\" level=fatal msg=\"missing config pectraWithdrawalRequestContractAddress, please provide via explorer config\" _file=main.go _function=main.main _line=128\n"
Error encountered running Starlark code.
@barnabasbusa @parithosh any inputs would be greatly appreciated thanks !
This is a big on beaconchain's side not our side. Their image hasn't been updated to be compatible with ethereum package
Thanks for the clarification @barnabasbusa 🙏 ! Is there a version of the ethereum package without the missing config pectraWithdrawalRequestContractAddress that's currently compatible with the existing Beaconchain image? If so, could you kindly point me to it? That would be really helpful. Thanks again!
Same issue with the pectraWithdrawalRequestContractAddress error.