Difference between revisions of "Geth db inspect"
Jump to navigation
Jump to search
(23 intermediate revisions by the same user not shown) | |||
Line 1: | Line 1: | ||
{{lc}} | {{lc}} | ||
+ | |||
+ | [[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 | |
− | +-----------------------+-------------------------+------------+-------+ | + | |
− | | DATABASE | CATEGORY | SIZE | ITEMS | | + | |
− | +-----------------------+-------------------------+------------+-------+ | + | [[geth db]] inspect | grep snapshot |
− | | Key-Value store | Headers | 576.00 B | 1 | | + | | Key-Value store | [[Account snapshot]] | 409.64 KiB | 8893 | |
− | | Key-Value store | Bodies | 44.00 B | 1 | | + | | Key-Value store | [[Storage snapshot]] | 0.00 B | 0 | |
− | | Key-Value store | Receipt lists | 42.00 B | 1 | | + | | Key-Value store | [[Clique snapshots]] | 0.00 B | 0 | |
− | | 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 | | + | == Example == |
− | | Key-Value store | Contract codes | 0.00 B | 0 | | + | INFO [10-08|12:11:22.012] Maximum peer count ETH=50 total=50 |
− | | Key-Value store | Hash trie nodes | 0.00 B | 0 | | + | INFO [10-08|12:11:22.016] Set global gas cap cap=50,000,000 |
− | | Key-Value store | Path trie state lookups | 82.00 B | 2 | | + | INFO [10-08|12:11:22.017] Initializing the [[KZG]] library backend=gokzg |
− | | Key-Value store | Path trie account nodes | 1.47 MiB | 12356 | | + | INFO [10-08|12:11:22.042] [[Using pebble as the backing database]] |
− | | Key-Value store | Path trie storage nodes | 0.00 B | 0 | | + | INFO [10-08|12:11:22.042] Allocated cache and file handles database=~/Library/Ethereum/geth/chaindata cache=512.00MiB handles=5120 |
− | | Key-Value store | Trie preimages | 0.00 B | 0 | | + | INFO [10-08|12:11:22.133] Opened [[ancient]] database database~/Library/Ethereum/geth/chaindata/ancient/chain readonly=true |
− | | Key-Value store | Account snapshot | 409.64 KiB | 8893 | | + | INFO [10-08|12:11:30.137] Inspecting database count=31,189,000 elapsed=8.000s |
− | | Key-Value store | Storage snapshot | 0.00 B | 0 | | + | INFO [10-08|12:11:38.146] Inspecting database count=36,313,000 elapsed=16.010s |
− | | Key-Value store | Beacon sync headers | 0.00 B | 0 | | + | INFO [10-08|12:11:46.149] Inspecting database count=38,084,000 elapsed=24.012s |
− | | Key-Value store | Clique snapshots | 0.00 B | 0 | | + | INFO [10-08|12:11:54.156] Inspecting database count=39,442,000 elapsed=32.020s |
− | | Key-Value store | Singleton metadata | 695.19 KiB | 12 | | + | INFO [10-08|12:12:02.161] Inspecting database count=40,476,000 elapsed=40.024s |
− | | 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 | | + | | DATABASE | CATEGORY | SIZE | ITEMS | |
− | | Ancient store (Chain) | Headers | 6.00 B | 0 | | + | +-----------------------+-------------------------+------------+-------+ |
− | | Ancient store (Chain) | Hashes | 6.00 B | 0 | | + | | [[Key-Value store]] | Headers | 576.00 B | 1 | |
− | | Ancient store (Chain) | Bodies | 6.00 B | 0 | | + | | Key-Value store | Bodies | 44.00 B | 1 | |
− | | Ancient store (Chain) | Receipts | 6.00 B | 0 | | + | | Key-Value store | Receipt lists | 42.00 B | 1 | |
− | | Ancient store (State) | History.Meta | 85.00 B | 1 | | + | | Key-Value store | Difficulties | 48.00 B | 1 | |
− | | Ancient store (State) | Account.Index | 201.05 KiB | 1 | | + | | Key-Value store | Block number->hash | 42.00 B | 1 | |
− | | Ancient store (State) | Storage.Index | 13.00 B | 1 | | + | | Key-Value store | Block hash->number | 41.00 B | 1 | |
− | | Ancient store (State) | Account.Data | 13.00 B | 1 | | + | | Key-Value store | Transaction index | 0.00 B | 0 | |
− | | Ancient store (State) | Storage.Data | 13.00 B | 1 | | + | | Key-Value store | Bloombit index | 0.00 B | 0 | |
− | +-----------------------+-------------------------+------------+-------+ | + | | Key-Value store | Contract codes | 0.00 B | 0 | |
− | | TOTAL | 2.75 MIB | | | + | | 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 == | ||
+ | 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 == | ||
+ | * {{geth db}} | ||
− | + | [[Category:Geth]] |
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: