search

cerc-io / ipld-eth-state-snapshot

Read-only mirror of https://git.vdb.to/cerc-io/ipld-eth-state-snapshot (Tool for inserting the entire state and storage tries into PG-IPFS)
https://git.vdb.to/cerc-io/ipld-eth-state-snapshot
GNU Affero General Public License v3.0
8 stars 4 forks source link

Test watcher with v3 core services using state snapshot #36

Closed nikugogoi closed 2 years ago

nikugogoi commented 2 years ago
nikugogoi commented 2 years ago

Getting error when using csv snapshot to import data

eden_db=# COPY eth.header_cids FROM '/vulcanize/ipld-eth-state-snapshot/output_dir/eth.header_cids.csv' CSV;
ERROR:  null value in column "node_id" violates not-null constraint
DETAIL:  Failing row contains (83, 0x7fa9a4bcf045815dbb57ca4c8288439d6f1c19d4bdb21accc9b5deecc24505..., 0xa6be0af94b6ba95b422d88d289fd7e74411c3b00ab566e998220d0c81cb8f1..., bagiacgzap6u2jphqiwav3o2xzjgifccdtvxrygouxwzbvtgjwxpozqsfaw6q, 0, null, 0, 0x1630a18c846a3529cc89904e15135c306e1e3f553fc39ab3d7e3fedbc50d6a..., 0x56e81f171bcc55a6ff8345e692c0f86e5b48e01b996cadc001622fb5e363b4..., 0x56e81f171bcc55a6ff8345e692c0f86e5b48e01b996cadc001622fb5e363b4..., 0x1dcc4de8dec75d7aab85b567b6ccd41ad312451b948a7413f0a142fd40d493..., \x00000000000000000000000000000000000000000000000000000000000000..., 1653472760, /blocks/DMQH7KNEXTYELAK5XNL4UTECRBBZ23Y4DHKL3MQ2ZTE3LXXMYJCQLPI, 0, 0x0000000000000000000000000000000000000000).
CONTEXT:  COPY header_cids, line 1: "83,0x7fa9a4bcf045815dbb57ca4c8288439d6f1c19d4bdb21accc9b5deecc24505bd,0xa6be0af94b6ba95b422d88d289fd..."

Fix: The ethereum.nodeID config is required when taking snapshot. Added the config in example.toml

nikugogoi commented 2 years ago

Eth calls and storage calls below snapshot height do not return correct value.

It is not expected to work as discussed.