Difference between revisions of "Geth db inspect"

From wikieduonline
Jump to navigation Jump to search
 
(22 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
  
 
  .../...
 
  .../...
−
<pre>
+
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 |
−
</pre>
+
| 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 ==
 
== 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]

Retrieved from "https://www.wikieduonline.com/index.php?title=Geth_db_inspect&oldid=353097"

Advertising: