upgrade core
#460
Annotations
10 errors
|
rhp/v2/logger.go#L130
logger.go:130: 2023-10-11T16:14:41.123Z DEBUG host.sqlite.transaction slow exec {"id": "1ea0f35e", "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
|
rhp/v2/sql.go#L145
f the 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": "5.286071ms", "stack": "go.sia.tech/hostd/persist/sqlite.(*loggedTxn).Exec\n\t/Users/runner/work/hostd/hostd/persist/sqlite/sql.go:145\ngo.sia.tech/hostd/persist/sqlite.(*Store).initNewDatabase.func1\n\t/Users/runner/work/hostd/hostd/persist/sqlite/init.go:23\ngo.sia.tech/hostd/persist/sqlite.doTransaction\n\t/Users/runner/work/hostd/hostd/persist/sqlite/store.go:146\ngo.sia.tech/hostd/persist/sqlite.(*Store).transaction\n\t/Users/runner/work/hostd/hostd/persist/sqlite/store.go:92\ngo.sia.tech/hostd/persist/sqlite.(*Store).initNewDatabase\n\t/Users/runner/work/hostd/hostd/persist/sqlite/init.go:22\ngo.sia.tech/hostd/persist/sqlite.(*Store).init\n\t/Users/runner/work/hostd/hostd/persist/sqlite/init.go:79\ngo.sia.tech/hostd/persist/sqlite.OpenDat
|
rhp/v2/store.go#L203
abase\n\t/Users/runner/work/hostd/hostd/persist/sqlite/store.go:203\ngo.sia.tech/hostd/internal/test.NewHost\n\t/Users/runner/work/hostd/hostd/internal/test/host.go:164\ngo.sia.tech/hostd/internal/test.NewTestingPair\n\t/Users/runner/work/hostd/hostd/internal/test/node.go:131\ngo.sia.tech/hostd/rhp/v2_test.TestUploadDownload\n\t/Users/runner/work/hostd/hostd/rhp/v2/rpc_test.go:44\ntesting.tRunner\n\t/Users/runner/hostedtoolcache/go/1.20.8/x64/src/testing/testing.go:1576"}
|
rhp/v2/logger.go#L130
logger.go:130: 2023-10-11T16:14:41.141Z DEBUG host.sqlite.transaction long transaction {"id": "1ea0f35e", "attempt": 1, "elapsed": "23.396179ms", "stack": "go.sia.tech/hostd/persist/sqlite.doTransaction.func1\n\t/Users/runner/work/hostd/hostd/persist/sqlite/store.go:138\ngo.sia.tech/hostd/persist/sqlite.doTransaction\n\t/Users/runner/work/hostd/hostd/persist/sqlite/store.go:151\ngo.sia.tech/hostd/persist/sqlite.(*Store).transaction\n\t/Users/runner/work/hostd/hostd/persist/sqlite/store.go:92\ngo.sia.tech/hostd/persist/sqlite.(*Store).initNewDatabase\n\t/Users/runner/work/hostd/hostd/persist/sqlite/init.go:22\ngo.sia.tech/hostd/persist/sqlite.(*Store).init\n\t/Users/runner/work/hostd/hostd/persist/sqlite/init.go:79\ngo.sia.tech/hostd/persist/sqlite.OpenDatabase\n\t/Users/runner/work/hostd/hostd/persist/sqlite/store.go:203\ngo.sia.tech/hostd/internal/test.NewHost\n\t/Users/runner/work/hostd/hostd/internal/test/host.go:164\ngo.sia.tech/hostd/internal/test.NewTestingPair\n\t/Users/runner/work/hostd/hostd/inte
|
rhp/v2/node.go#L131
rnal/test/node.go:131\ngo.sia.tech/hostd/rhp/v2_test.TestUploadDownload\n\t/Users/runner/work/hostd/hostd/rhp/v2/rpc_test.go:44\ntesting.tRunner\n\t/Users/runner/hostedtoolcache/go/1.20.8/x64/src/testing/testing.go:1576", "failed": false}
|
rhp/v2/logger.go#L130
logger.go:130: 2023-10-11T16:14:41.143Z DEBUG host.wallet processing consensus change {"applied": 1, "reverted": 0}
|
rhp/v2/logger.go#L130
logger.go:130: 2023-10-11T16:14:41.144Z DEBUG host.wallet applied consensus change {"changeID": "d8745743f409f11eb2bec805be24ae44f35f8a715249df6cdc6f3c3c20be7de1", "applied": 1, "reverted": 0, "height": 0, "elapsed": "441.932µs", "address": "addr:925de8783c681cb9a41ccffefeed4563ed2550f736be98a11aa41396af7953ff7a42a5e3973d"}
|
rhp/v2/logger.go#L130
logger.go:130: 2023-10-11T16:14:49.306Z DEBUG host.contracts.consensusChange consensus change applied {"height": 0, "changeID": "d8745743f409f11eb2bec805be24ae44f35f8a715249df6cdc6f3c3c20be7de1"}
|
rhp/v2/logger.go#L130
logger.go:130: 2023-10-11T16:14:49.859Z DEBUG renter.sqlite.transaction slow exec {"id": "daaf43dd", "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
|
The logs for this run have expired and are no longer available.
Loading