upgrade core
#454
Annotations
10 errors
|
host/contracts/logger.go#L130
logger.go:130: 2023-10-10T09:57:43.998Z DEBUG sqlite.transaction slow exec {"id": "2eeb0fc9", "attempt": 1, "query": "/*\n\tWhen changing the schema, a new migration function must be added to\n\tmigrations.go\n*/\n\nCREATE TABLE wallet_utxos (\n\tid BLOB PRIMARY KEY,\n\tamount BLOB NOT NULL,\n\tunlock_hash BLOB NOT NULL\n);\n\nCREATE TABLE wallet_transactions (\n\tid INTEGER PRIMARY KEY,\n\ttransaction_id BLOB NOT NULL,\n\tblock_id BLOB NOT NULL,\n\tinflow BLOB NOT NULL,\n\toutflow BLOB NOT NULL,\n\traw_transaction BLOB NOT NULL, -- binary serialized transaction\n\tsource TEXT NOT NULL,\n\tblock_height INTEGER NOT NULL,\n\tdate_created INTEGER NOT NULL\n);\nCREATE INDEX wallet_transactions_date_created_index ON wallet_transactions(date_created);\nCREATE INDEX wallet_transactions_block_id ON wallet_transactions(block_id);\nCREATE INDEX wallet_transactions_date_created ON wallet_transactions(date_created);\nCREATE INDEX wallet_transactions_block_height_id ON wallet_transactions(block_height DESC, id);\n\nCREATE TABLE stored_sectors (\n\tid INTEGER PRIMARY KEY,\n\tsector_root BLOB UNIQUE NOT NULL,\n\tlast_access_timestamp INTEGER NOT NULL\n);\nCREATE INDEX stored_sectors_sector_root ON stored_sectors(sector_root);\nCREATE INDEX stored_sectors_last_access ON stored_sectors(last_access_timestamp);\n\nCREATE TABLE locked_sectors ( -- should be cleared at startup. currently persisted for simplicity, but may be moved to memory\n\tid INTEGER PRIMARY KEY,\n\tsector_id INTEGER NOT NULL REFERENCES stored_sectors(id)\n);\nCREATE INDEX locked_sectors_sector_id ON locked_sectors(sector_id);\n\nCREATE TABLE storage_volumes (\n\tid INTEGER PRIMARY KEY,\n\tdisk_path TEXT UNIQUE NOT NULL,\n\tused_sectors INTEGER NOT NULL,\n\ttotal_sectors INTEGER NOT NULL,\n\tread_only BOOLEAN NOT NULL,\n\tavailable BOOLEAN NOT NULL DEFAULT false\n);\nCREATE INDEX storage_volumes_id_available_read_only ON storage_volumes(id, available, read_only);\nCREATE INDEX storage_volumes_read_only_available_used_sectors ON storage_volumes(available, read_only, used_sectors);\n\nCREATE TABLE volume_sectors (\n\tid INTEGER PRIMARY KEY,\n\tvolume_id INTEGER NOT NULL REFERENCES storage_volumes (id), -- all sectors will need to be migrated first when deleting a volume\n\tvolume_index INTEGER NOT NULL,\n\tsector_id INTEGER UNIQUE REFERENCES stored_sectors (id),\n\tUNIQUE (volume_id, volume_index)\n);\nCREATE INDEX volume_sectors_volume_id_sector_id_volume_index_compound ON volume_sectors(volume_id, sector_id, volume_index) WHERE sector_id IS NULL;\nCREATE INDEX volume_sectors_volume_id_sector_id ON volume_sectors(volume_id, sector_id);\nCREATE INDEX volume_sectors_volume_id ON volume_sectors(volume_id);\nCREATE INDEX volume_sectors_volume_index ON volume_sectors(volume_index ASC);\nCREATE INDEX volume_sectors_sector_id ON volume_sectors(sector_id);\n\nCREATE TABLE locked_volume_sectors ( -- should be cleared at startup. currently persisted for simplicity, but may be moved to memory\n\tid INTEGER PRIMARY KEY,\n\tvolume_sector_id INTEGER REFERENCES volume_sectors(id) ON DELETE CASCADE\n);\nCREATE INDEX locked_volume_sectors_sector_id ON locked_volume_sectors(volume_sector_id);\n\nCREATE TABLE contract_renters (\n\tid INTEGER PRIMARY KEY,\n\tpublic_key BLOB UNIQUE NOT NULL\n);\n\nCREATE TABLE contracts (\n\tid INTEGER PRIMARY KEY,\n\trenter_id INTEGER NOT NULL REFERENCES contract_renters(id),\n\trenewed_to INTEGER REFERENCES contracts(id) ON DELETE SET NULL,\n\trenewed_from INTEGER REFERENCES contracts(id) ON DELETE SET NULL,\n\tcontract_id BLOB UNIQUE NOT NULL,\n\trevision_number BLOB NOT NULL, -- stored as BLOB to support uint64_max on clearing revisions\n\tformation_txn_set BLOB NOT NULL, -- binary serialized transaction set\n\tlocked_collateral BLOB NOT NULL,\n\trpc_revenue BLOB NOT NULL,\n\tstorage_revenue BLOB NOT NULL,\n\tingress_revenue BLOB NOT NULL,\n\tegress_revenue BLOB NOT NULL,\n\taccount_funding BLOB NOT NULL,\n\tregistry_read BLOB NOT NULL,\n\tregistry_write BLOB NOT NULL,\n\trisked_collateral BLOB NOT NULL,\n\tconfirmed_revision_number BLOB, -- stored as BLOB
|
host/contracts/sql.go#L145
last processed change\n\tcontracts_height INTEGER -- height of the contract manager as of the last processed change\n);\n\n-- initialize the global settings table\nINSERT INTO global_settings (id, db_version) VALUES (0, 0); -- should not be changed\n", "elapsed": "6.892435ms", "stack": "go.sia.tech/hostd/persist/sqlite.(*loggedTxn).Exec\n\t/home/runner/work/hostd/hostd/persist/sqlite/sql.go:145\ngo.sia.tech/hostd/persist/sqlite.(*Store).init.(*Store).initNewDatabase.func1\n\t/home/runner/work/hostd/hostd/persist/sqlite/init.go:23\ngo.sia.tech/hostd/persist/sqlite.doTransaction\n\t/home/runner/work/hostd/hostd/persist/sqlite/store.go:146\ngo.sia.tech/hostd/persist/sqlite.(*Store).transaction\n\t/home/runner/work/hostd/hostd/persist/sqlite/store.go:92\ngo.sia.tech/hostd/persist/sqlite.(*Store).initNewDatabase\n\t/home/runner/work/hostd/hostd/persist/sqlite/init.go:22\ngo.sia.tech/hostd/persist/sqlite.(*Store).init\n\t/home/runner/work/hostd/hostd/persist/sqlite/init.go:79\ngo.sia.tech/hostd/persist/sqlite.Open
|
host/contracts/store.go#L203
Database\n\t/home/runner/work/hostd/hostd/persist/sqlite/store.go:203\ngo.sia.tech/hostd/internal/test.NewWallet\n\t/home/runner/work/hostd/hostd/internal/test/wallet.go:62\ngo.sia.tech/hostd/host/contracts_test.TestCheckIntegrity\n\t/home/runner/work/hostd/hostd/host/contracts/integrity_test.go:76\ntesting.tRunner\n\t/opt/hostedtoolcache/go/1.21.1/x64/src/testing/testing.go:1595"}
|
host/contracts/logger.go#L130
logger.go:130: 2023-10-10T09:57:44.009Z DEBUG sqlite.transaction long transaction {"id": "2eeb0fc9", "attempt": 1, "elapsed": "17.748347ms", "stack": "go.sia.tech/hostd/persist/sqlite.doTransaction.func1\n\t/home/runner/work/hostd/hostd/persist/sqlite/store.go:138\ngo.sia.tech/hostd/persist/sqlite.doTransaction\n\t/home/runner/work/hostd/hostd/persist/sqlite/store.go:151\ngo.sia.tech/hostd/persist/sqlite.(*Store).transaction\n\t/home/runner/work/hostd/hostd/persist/sqlite/store.go:92\ngo.sia.tech/hostd/persist/sqlite.(*Store).initNewDatabase\n\t/home/runner/work/hostd/hostd/persist/sqlite/init.go:22\ngo.sia.tech/hostd/persist/sqlite.(*Store).init\n\t/home/runner/work/hostd/hostd/persist/sqlite/init.go:79\ngo.sia.tech/hostd/persist/sqlite.OpenDatabase\n\t/home/runner/work/hostd/hostd/persist/sqlite/store.go:203\ngo.sia.tech/hostd/internal/test.NewWallet\n\t/home/runner/work/hostd/hostd/internal/test/wallet.go:62\ngo.sia.tech/hostd/host/contracts_test.TestCheckIntegrity\n\t/home/runner/work/hostd/hostd/host
|
host/contracts/integrity_test.go#L76
/contracts/integrity_test.go:76\ntesting.tRunner\n\t/opt/hostedtoolcache/go/1.21.1/x64/src/testing/testing.go:1595", "failed": false}
|
host/contracts/logger.go#L130
logger.go:130: 2023-10-10T09:57:44.011Z DEBUG wallet processing consensus change {"applied": 1, "reverted": 0}
|
host/contracts/logger.go#L130
logger.go:130: 2023-10-10T09:57:44.011Z DEBUG wallet applied consensus change {"changeID": "912cbf85556b72840930ebbd8f736790cd08554c667739e7fc59702fe6c7fc55", "applied": 1, "reverted": 0, "height": 0, "elapsed": "426.108µs", "address": "addr:0a2da76840179288b5ec3209b3f987133c5851439b31e3ccd327b4ba2b3212a0b3fb9e5aab8a"}
|
host/contracts/logger.go#L130
logger.go:130: 2023-10-10T09:57:45.153Z DEBUG wallet processing consensus change {"applied": 1, "reverted": 0}
|
host/contracts/logger.go#L130
logger.go:130: 2023-10-10T09:57:45.154Z DEBUG wallet applied consensus change {"changeID": "4efed60ba73cec91041942c1e869897a4f7b48bc415bb1695b3e688bdd0a5a7e", "applied": 1, "reverted": 0, "height": 1, "elapsed": "1.105822ms", "address": "addr:0a2da76840179288b5ec3209b3f987133c5851439b31e3ccd327b4ba2b3212a0b3fb9e5aab8a"}
|
The logs for this run have expired and are no longer available.
Loading