Difference between revisions of "Geth db inspect"
Jump to navigation
Jump to search
| (15 intermediate revisions by the same user not shown) | |||
| Line 2: | Line 2: | ||
[[geth db]] inspect | [[geth db]] inspect | ||
| − | geth db inspect --datadir /path/to/geth/folder | + | [[geth db inspect --help]] |
| + | [[geth db]] inspect [[--datadir]] /path/to/geth/folder | ||
| + | (It can take up to 1 hour) | ||
| + | |||
| + | [[geth --sepolia]] db inspect --datadir /path/to/geth/folder | ||
| + | |||
| + | .../... | ||
| + | ERROR[10-10|09:40:43.923] [[Database contains unaccounted data]] size=71.05MiB count=1773925 | ||
| + | |||
| + | |||
| + | [[geth db]] inspect | grep snapshot | ||
| + | | Key-Value store | [[Account snapshot]] | 409.64 KiB | 8893 | | ||
| + | | Key-Value store | [[Storage snapshot]] | 0.00 B | 0 | | ||
| + | | Key-Value store | [[Clique snapshots]] | 0.00 B | 0 | | ||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| Line 27: | Line 32: | ||
INFO [10-08|12:11:54.156] Inspecting database count=39,442,000 elapsed=32.020s | INFO [10-08|12:11:54.156] Inspecting database count=39,442,000 elapsed=32.020s | ||
INFO [10-08|12:12:02.161] Inspecting database count=40,476,000 elapsed=40.024s | INFO [10-08|12:12:02.161] Inspecting database count=40,476,000 elapsed=40.024s | ||
| − | + | ||
| − | + | +-----------------------+-------------------------+------------+-------+ | |
| − | + | | DATABASE | CATEGORY | SIZE | ITEMS | | |
| − | +-----------------------+-------------------------+------------+-------+ | + | +-----------------------+-------------------------+------------+-------+ |
| − | | DATABASE | CATEGORY | SIZE | ITEMS | | + | | [[Key-Value store]] | Headers | 576.00 B | 1 | |
| − | +-----------------------+-------------------------+------------+-------+ | + | | Key-Value store | Bodies | 44.00 B | 1 | |
| − | | Key-Value store | Headers | 576.00 B | 1 | | + | | Key-Value store | Receipt lists | 42.00 B | 1 | |
| − | | Key-Value store | Bodies | 44.00 B | 1 | | + | | Key-Value store | Difficulties | 48.00 B | 1 | |
| − | | Key-Value store | Receipt lists | 42.00 B | 1 | | + | | Key-Value store | Block number->hash | 42.00 B | 1 | |
| − | | Key-Value store | Difficulties | 48.00 B | 1 | | + | | Key-Value store | Block hash->number | 41.00 B | 1 | |
| − | | Key-Value store | Block number->hash | 42.00 B | 1 | | + | | Key-Value store | Transaction index | 0.00 B | 0 | |
| − | | Key-Value store | Block hash->number | 41.00 B | 1 | | + | | Key-Value store | Bloombit index | 0.00 B | 0 | |
| − | | Key-Value store | Transaction index | 0.00 B | 0 | | + | | Key-Value store | Contract codes | 0.00 B | 0 | |
| − | | Key-Value store | Bloombit index | 0.00 B | 0 | | + | | Key-Value store | Hash trie nodes | 0.00 B | 0 | |
| − | | Key-Value store | Contract codes | 0.00 B | 0 | | + | | Key-Value store | Path trie state lookups | 82.00 B | 2 | |
| − | | Key-Value store | Hash trie nodes | 0.00 B | 0 | | + | | Key-Value store | Path trie account nodes | 1.47 MiB | 12356 | |
| − | | Key-Value store | Path trie state lookups | 82.00 B | 2 | | + | | Key-Value store | Path trie storage nodes | 0.00 B | 0 | |
| − | | Key-Value store | Path trie account nodes | 1.47 MiB | 12356 | | + | | Key-Value store | Trie preimages | 0.00 B | 0 | |
| − | | Key-Value store | Path trie storage nodes | 0.00 B | 0 | | + | | Key-Value store | [[Account snapshot]] | 409.64 KiB | 8893 | |
| − | | Key-Value store | Trie preimages | 0.00 B | 0 | | + | | Key-Value store | [[Storage snapshot]] | 0.00 B | 0 | |
| − | | Key-Value store | Account snapshot | 409.64 KiB | 8893 | | + | | Key-Value store | Beacon sync headers | 0.00 B | 0 | |
| − | | Key-Value store | Storage snapshot | 0.00 B | 0 | | + | | Key-Value store | [[Clique snapshots]] | 0.00 B | 0 | |
| − | | Key-Value store | Beacon sync headers | 0.00 B | 0 | | + | | Key-Value store | Singleton metadata | 695.19 KiB | 12 | |
| − | | Key-Value store | Clique snapshots | 0.00 B | 0 | | + | | Light client | CHT trie nodes | 0.00 B | 0 | |
| − | | Key-Value store | Singleton metadata | 695.19 KiB | 12 | | + | | Light client | Bloom trie nodes | 0.00 B | 0 | |
| − | | Light client | CHT trie nodes | 0.00 B | 0 | | + | | Ancient store (Chain) | Diffs | 6.00 B | 0 | |
| − | | Light client | Bloom trie nodes | 0.00 B | 0 | | + | | Ancient store (Chain) | Headers | 6.00 B | 0 | |
| − | | Ancient store (Chain) | Diffs | 6.00 B | 0 | | + | | Ancient store (Chain) | Hashes | 6.00 B | 0 | |
| − | | Ancient store (Chain) | Headers | 6.00 B | 0 | | + | | Ancient store (Chain) | Bodies | 6.00 B | 0 | |
| − | | Ancient store (Chain) | Hashes | 6.00 B | 0 | | + | | Ancient store (Chain) | Receipts | 6.00 B | 0 | |
| − | | Ancient store (Chain) | Bodies | 6.00 B | 0 | | + | | Ancient store (State) | History.Meta | 85.00 B | 1 | |
| − | | Ancient store (Chain) | Receipts | 6.00 B | 0 | | + | | Ancient store (State) | Account.Index | 201.05 KiB | 1 | |
| − | | Ancient store (State) | History.Meta | 85.00 B | 1 | | + | | Ancient store (State) | Storage.Index | 13.00 B | 1 | |
| − | | Ancient store (State) | Account.Index | 201.05 KiB | 1 | | + | | Ancient store (State) | Account.Data | 13.00 B | 1 | |
| − | | Ancient store (State) | Storage.Index | 13.00 B | 1 | | + | | Ancient store (State) | Storage.Data | 13.00 B | 1 | |
| − | | Ancient store (State) | Account.Data | 13.00 B | 1 | | + | +-----------------------+-------------------------+------------+-------+ |
| − | | Ancient store (State) | Storage.Data | 13.00 B | 1 | | + | | TOTAL | 2.75 MIB | | |
| − | +-----------------------+-------------------------+------------+-------+ | + | +-----------------------+-------------------------+------------+-------+ |
| − | | TOTAL | 2.75 MIB | | | ||
| − | +-----------------------+-------------------------+------------+-------+ | ||
| − | |||
== Errors == | == Errors == | ||
| Line 77: | Line 79: | ||
failed to [[hex-decode]] 'prefix': hex string without 0x prefix | failed to [[hex-decode]] 'prefix': hex string without 0x prefix | ||
| + | [[geth db inspect --datadir ./]] | ||
| + | INFO [10-10|09:37:48.217] Maximum peer count ETH=50 total=50 | ||
| + | INFO [10-10|09:37:48.221] Set global gas cap cap=50,000,000 | ||
| + | INFO [10-10|09:37:48.221] Initializing the KZG library backend=gokzg | ||
| + | INFO [10-10|09:37:48.233] Defaulting to pebble as the backing database | ||
| + | INFO [10-10|09:37:48.233] Allocated cache and file handles database=~/geth/chaindata/geth/chaindata cache=512.00MiB handles=5120 | ||
| + | Fatal: Could not open database: error opening database at "~/geth/chaindata/geth/chaindata": [[pebble]]: database | ||
| + | "~/geth/chaindata/geth/[[chaindata]]" does not exist | ||
| + | |||
| + | [[ERROR Database contains unaccounted data]] | ||
== See also == | == See also == | ||
Latest revision as of 09:13, 30 October 2024
geth db inspect geth db inspect --help geth db inspect --datadir /path/to/geth/folder (It can take up to 1 hour)
geth --sepolia db inspect --datadir /path/to/geth/folder
.../... ERROR[10-10|09:40:43.923] Database contains unaccounted data size=71.05MiB count=1773925
geth db inspect | grep snapshot | Key-Value store | Account snapshot | 409.64 KiB | 8893 | | Key-Value store | Storage snapshot | 0.00 B | 0 | | Key-Value store | Clique snapshots | 0.00 B | 0 |
Example[edit]
INFO [10-08|12:11:22.012] Maximum peer count ETH=50 total=50 INFO [10-08|12:11:22.016] Set global gas cap cap=50,000,000 INFO [10-08|12:11:22.017] Initializing the KZG library backend=gokzg INFO [10-08|12:11:22.042] Using pebble as the backing database INFO [10-08|12:11:22.042] Allocated cache and file handles database=~/Library/Ethereum/geth/chaindata cache=512.00MiB handles=5120 INFO [10-08|12:11:22.133] Opened ancient database database~/Library/Ethereum/geth/chaindata/ancient/chain readonly=true INFO [10-08|12:11:30.137] Inspecting database count=31,189,000 elapsed=8.000s INFO [10-08|12:11:38.146] Inspecting database count=36,313,000 elapsed=16.010s INFO [10-08|12:11:46.149] Inspecting database count=38,084,000 elapsed=24.012s INFO [10-08|12:11:54.156] Inspecting database count=39,442,000 elapsed=32.020s INFO [10-08|12:12:02.161] Inspecting database count=40,476,000 elapsed=40.024s +-----------------------+-------------------------+------------+-------+ | DATABASE | CATEGORY | SIZE | ITEMS | +-----------------------+-------------------------+------------+-------+ | Key-Value store | Headers | 576.00 B | 1 | | Key-Value store | Bodies | 44.00 B | 1 | | Key-Value store | Receipt lists | 42.00 B | 1 | | Key-Value store | Difficulties | 48.00 B | 1 | | Key-Value store | Block number->hash | 42.00 B | 1 | | Key-Value store | Block hash->number | 41.00 B | 1 | | Key-Value store | Transaction index | 0.00 B | 0 | | Key-Value store | Bloombit index | 0.00 B | 0 | | Key-Value store | Contract codes | 0.00 B | 0 | | Key-Value store | Hash trie nodes | 0.00 B | 0 | | Key-Value store | Path trie state lookups | 82.00 B | 2 | | Key-Value store | Path trie account nodes | 1.47 MiB | 12356 | | Key-Value store | Path trie storage nodes | 0.00 B | 0 | | Key-Value store | Trie preimages | 0.00 B | 0 | | Key-Value store | Account snapshot | 409.64 KiB | 8893 | | Key-Value store | Storage snapshot | 0.00 B | 0 | | Key-Value store | Beacon sync headers | 0.00 B | 0 | | Key-Value store | Clique snapshots | 0.00 B | 0 | | Key-Value store | Singleton metadata | 695.19 KiB | 12 | | Light client | CHT trie nodes | 0.00 B | 0 | | Light client | Bloom trie nodes | 0.00 B | 0 | | Ancient store (Chain) | Diffs | 6.00 B | 0 | | Ancient store (Chain) | Headers | 6.00 B | 0 | | Ancient store (Chain) | Hashes | 6.00 B | 0 | | Ancient store (Chain) | Bodies | 6.00 B | 0 | | Ancient store (Chain) | Receipts | 6.00 B | 0 | | Ancient store (State) | History.Meta | 85.00 B | 1 | | Ancient store (State) | Account.Index | 201.05 KiB | 1 | | Ancient store (State) | Storage.Index | 13.00 B | 1 | | Ancient store (State) | Account.Data | 13.00 B | 1 | | Ancient store (State) | Storage.Data | 13.00 B | 1 | +-----------------------+-------------------------+------------+-------+ | TOTAL | 2.75 MIB | | +-----------------------+-------------------------+------------+-------+
Errors[edit]
geth db inspect INFO [10-08|12:04:40.196] Maximum peer count ETH=50 total=50 Fatal: Failed to create the protocol stack: datadir already used by another process
geth db inspect ./ failed to hex-decode 'prefix': hex string without 0x prefix
geth db inspect --datadir ./ INFO [10-10|09:37:48.217] Maximum peer count ETH=50 total=50 INFO [10-10|09:37:48.221] Set global gas cap cap=50,000,000 INFO [10-10|09:37:48.221] Initializing the KZG library backend=gokzg INFO [10-10|09:37:48.233] Defaulting to pebble as the backing database INFO [10-10|09:37:48.233] Allocated cache and file handles database=~/geth/chaindata/geth/chaindata cache=512.00MiB handles=5120 Fatal: Could not open database: error opening database at "~/geth/chaindata/geth/chaindata": pebble: database "~/geth/chaindata/geth/chaindata" does not exist
ERROR Database contains unaccounted data
See also[edit]
geth db [ inspect | inspect-history | check-state-content | stats | metadata | dumptrie | get | --help ] geth db --datadir, geth --db.engine
Advertising:
