Hello! Gitter chat support has been cancelled. Please redirect all requests to Discord: discord.gg/gnosischain (Channel #blockscout)
nikitosing on np-fix-token-transfers-order
Add order by for token transfer… (compare)
vbaranov on andogro-patch-1
vbaranov on master
Update README.md Remove unsupp… Merge pull request #5611 from b… (compare)
andogro on andogro-patch-1
Update README.md Remove unsupp… (compare)
nikitosing on np-indexer-handle-502
Add clause for handle_info to h… Leave common clause for :DOWN c… (compare)
vbaranov on np-add-broadcast-for-coin-balance
vbaranov on master
Add broadcasting of coin balance Merge pull request #5588 from b… (compare)
[0x1f9840a85d5af5bf1d1762f925bdaddc4201f984,0xe91d153e0b41518a2ce8dd3d7944fa863463a97d]
at either getAmountsIn or getAmountsOut
I'm doing a containerized deployment. So I can't change files inside the application directory. But I can template in files in other paths or change the command, of course. So there are some things that can't be changed via env vars (e.g. https://github.com/poanetwork/blockscout/blob/master/apps/indexer/lib/indexer/fetcher/coin_balance.ex#L24)
How do I override this value via env var, cmd parameters, or external configuration file?
sed
though :see_no_evil:
Hi! I've been trying all day to have a contract verified, but something is wrong. I used truffle-flattener
and the output works fine on remix (I can interact with the contract), but blockscout keeps saying bytecode didn't match. I also enabled the optimizer with 200 runs.
This is the contract https://blockscout.com/poa/xdai/address/0xEEB618686fb36F6B07b44b763B1A5C4267f0c5d7/contracts
And this is the truffle compilation https://github.com/uprtcl/stairwise-token/blob/main/build/contracts/StaircaseBondingCurve.json
The contract has arrays as constructor parameters, beside this, is a rather simple one.
Any advice on how to find what might be the issue here?
Thanks!!
internal_transactions_indexed_at
field in the table internal_transactions
anymore. Nowadays, status of the internal transactions fetching is checked within pending_block_operations
table.
In explorer it's just a problem with opening address of RandomAura. It takes too long and then crashes explorer.
Execution time which I sen is from here:
explorer=> EXPLAIN ANALYZE VERBOSE SELECT a0."block_number", a0."value", a0."value_fetched_at", a0."inserted_at", a0."updated_at", a0."address_hash", value - coalesce(lag(value, 1) over (order by block_number),
0), b1."timestamp" FROM "address_coin_balances" AS a0 INNER JOIN "blocks" AS b1 ON a0."block_number" = b1."number" WHERE (a0."address_hash" = '\x3000000000000000000000000000000000000001' ) AND (NOT (a0."value" I
S NULL)
QUERY PLAN
Sort (cost=1094309.05..1097928.31 rows=1447704 width=108) (actual time=8734.868..9027.944 rows=1431434 loops=1)
Output: a0.block_number, a0.value, a0.value_fetched_at, a0.inserted_at, a0.updated_at, a0.address_hash, ((a0.value - COALESCE(lag(a0.value, 1) OVER (?), '0'::numeric))), b1."timestamp", a0.block_number
Sort Key: a0.block_number DESC
Sort Method: external merge Disk: 126144kB
-> WindowAgg (cost=748971.23..777925.31 rows=1447704 width=108) (actual time=6402.329..7762.118 rows=1431434 loops=1)
Output: a0.block_number, a0.value, a0.value_fetched_at, a0.inserted_at, a0.updated_at, a0.address_hash, (a0.value - COALESCE(lag(a0.value, 1) OVER (?), '0'::numeric)), b1."timestamp", a0.block_number
-> Sort (cost=748971.23..752590.49 rows=1447704 width=68) (actual time=6402.318..6742.283 rows=1431434 loops=1)
Output: a0.block_number, a0.value, a0.value_fetched_at, a0.inserted_at, a0.updated_at, a0.address_hash, b1."timestamp"
Sort Key: a0.block_number
Sort Method: external merge Disk: 114944kB
-> Hash Join (cost=229070.87..482070.49 rows=1447704 width=68) (actual time=1672.574..5367.562 rows=1431434 loops=1)
Output: a0.block_number, a0.value, a0.value_fetched_at, a0.inserted_at, a0.updated_at, a0.address_hash, b1."timestamp"
Inner Unique: true
Hash Cond: (b1.number = a0.block_number)
-> Seq Scan on public.blocks b1 (cost=0.00..182764.97 rows=4413197 width=16) (actual time=0.098..1199.297 rows=4382999 loops=1)
Output: b1."timestamp", b1.number
-> Hash (cost=195422.57..195422.57 rows=1447704 width=60) (actual time=1671.555..1671.555 rows=1431416 loops=1)
Output: a0.block_number, a0.value, a0.value_fetched_at, a0.inserted_at, a0.updated_at, a0.address_hash
Buckets: 65536 Batches: 64 Memory Usage: 2554kB
-> Bitmap Heap Scan on public.address_coin_balances a0 (cost=73068.27..195422.57 rows=1447704 width=60) (actual time=277.800..1118.153 rows=1431416 loops=1)
Output: a0.block_number, a0.value, a0.value_fetched_at, a0.inserted_at, a0.updated_at, a0.address_hash
Recheck Cond: (a0.address_hash = '\x3000000000000000000000000000000000000001'::bytea)
Rows Removed by Index Recheck: 2073383
Filter: (a0.value IS NOT NULL)
Rows Removed by Filter: 45
Heap Blocks: exact=51290 lossy=33105
-> Bitmap Index Scan on address_coin_balances_address_hash_block_number_index (cost=0.00..72706.34 rows=1447704 width=0) (actual time=257.494..257.494 rows=1444287 loops=1)
Index Cond: (a0.address_hash = '\x3000000000000000000000000000000000000001'::bytea)
Planning time: 0.253 ms
Execut