POA Forum

BlockScout v3.1.0-beta - save DB space from first traces

The release is aimed to reduce costs on hosting of Blockscout. It can significantly reduce the size (up to 500 Gb*) of the DB table public.internal_transactions for Parity Ethereum / Nethermind driven Blockscout by ignoring to store the first trace of tx but still getting error and init code from it. And now Raw trace page before showing the traces gets the first trace from the archive node since Blockscout doesn’t store the first trace any more.

*in case of Etherum Mainnet

Note 1: Ignoring of transactions’ first traces takes place only in case of Parity/Nethermind archive nodes (ETHEREUM_JSONRPC_VARIANT=parity)

Note 2: though, this update prevents to store the 1st trace for new transactions, at the same time it doesn’t remove already existing first traces. In order to remove them after installation anyone can safely run this deletion command on the DB:

DELETE FROM public.internal_transactions WHERE index = 0;

Do it only if you use Parity/Nethermind archive nodes

Features

  • #3013, #3026, #3031 - Raw trace of transaction on-demand

  • #3000 - Get rid of storing of first trace for all types of transactions for Parity variant

  • #2875 - Save contract code from Parity genesis file

  • #2834, #3009, #3014, #3033 - always redirect to checksummed hash

Fixes

  • #3037 - Make buttons color at verification page consistent

  • #3034 - Support stateMutability=view to define reading functions in smart-contracts

  • #3029 - Fix transactions and blocks appearance on the main page

  • #3028 - Decrease polling period value for realtime fetcher

  • #3027 - Rescue for SUPPORTED_CHAINS env var parsing

  • #3025 - Fix splitting of indexer/web components setup

  • #3024 - Fix pool size default value in config

  • #3021, #3022 - Refine dev/test config

  • #3016, #3017 - Fix token instance QR code data

  • #3012 - Speedup token transfers list query

  • #3011 - Revert realtime fetcher small skips feature

  • #3007 - Fix copy UTF8 tx input action

  • #2996 - Fix awesomplete lib loading in Firefox

  • #2993 - Fix path definition for contract verification endpoint

  • #2990 - Fix import of Parity spec file

  • #2989 - Introduce API_PATH env var

  • #2988 - Fix web manifest accessibility

  • #2967 - Fix styles loading for firefox

  • #2950 - Add creationMethod to EthereumJSONRPC.Parity.Trace.Action.entry_to_elixir

  • #2897 - remove duplicate indexes

  • #2883 - Fix long contracts names

Chore

  • #3032 - Remove indexing status alert for Ganache variant

  • #3030 - Remove default websockets URL from config

  • #2995 - Support API_PATH env var in Docker file

Instance Updated
POA :white_check_mark:
POA Sokol :white_check_mark:
xDai :white_check_mark:
Ethereum :white_check_mark:
1 Like