Skip to content

Merge pull request #145 from SiaFoundation/alex/ui #353

Merge pull request #145 from SiaFoundation/alex/ui

Merge pull request #145 from SiaFoundation/alex/ui #353

Triggered via push August 10, 2023 18:54
Status Failure
Total duration 6m 33s
Artifacts

main.yml

on: push
Matrix: test
Fit to window
Zoom out
Zoom in

Annotations

14 errors
test (macos-latest, 1.20)
3/70 tests failed
Test go.sia.tech/hostd/persist/sqlite/TestTransactionRetry/transaction_retry failed in 2.35s: persist/sqlite/store_test.go#L57
store_test.go:57: transaction failed: transaction failed: database is locked
Test go.sia.tech/hostd/persist/sqlite/TestTransactionRetry failed in 2.37s: persist/sqlite/logger.go#L130
logger.go:130: 2023-08-10T18:59:34.877Z DEBUG transaction slow exec {"id": "e58d3d24", "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 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_read_only_available ON storage_volumes(read_only, available);\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);\n-- careful with these indices, the empty sector query is fragile and relies on\n-- the volume_index indice for performance.\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\trisked_collateral BLOB NOT NULL,\n\tconfirmed_revision_number BLOB, -- stored as BLOB to support uint64_max on clearing revisions\n\thost_sig BLOB NOT NULL,\n\trenter_sig BLOB NOT NULL,\n\traw_revision BLOB NOT NULL, -- binary serialized contract revision\n\tformation_confirmed BOOLEAN NOT NULL, -- true if the contract has been confirmed on the blockchain\n\tresolution_height INTEGER, -- null if the storage proof/resolution has not been confirmed on the blockchain, otherwise the height of the block containing the storage proof/resolution\n\tnegotiation_height INTEGER NOT NULL, -- determines if the formation txn should be rebroadcast or if the contract should be deleted\n\twindow
Test go.sia.tech/hostd/persist/sqlite/TestTransactionRetry failed in 2.37s: persist/sqlite/sql.go#L144
_settings (\n\tid INTEGER PRIMARY KEY NOT NULL DEFAULT 0 CHECK (id = 0), -- enforce a single row\n\tdb_version INTEGER NOT NULL, -- used for migrations\n\thost_key BLOB,\n\twallet_hash BLOB, -- used to prevent wallet seed changes\n\twallet_last_processed_change BLOB, -- last processed consensus change for the wallet\n\tcontracts_last_processed_change BLOB, -- last processed consensus change for the contract manager\n\twallet_height INTEGER, -- height of the wallet as of 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.899288ms", "stack": "go.sia.tech/hostd/persist/sqlite.(*loggedTxn).Exec\n\t/Users/runner/work/hostd/hostd/persist/sqlite/sql.go:144\ngo.sia.tech/hostd/persist/sqlite.(*Store).init.func1\n\t/Users/runner/work/hostd/hostd/persist/sqlite/init.go:29\ngo.sia.tech/hostd/persist/sqlit
Test go.sia.tech/hostd/persist/sqlite/TestTransactionRetry failed in 2.37s: persist/sqlite/store.go#L148
e.doTransaction\n\t/Users/runner/work/hostd/hostd/persist/sqlite/store.go:148\ngo.sia.tech/hostd/persist/sqlite.(*Store).transaction\n\t/Users/runner/work/hostd/hostd/persist/sqlite/store.go:93\ngo.sia.tech/hostd/persist/sqlite.(*Store).init\n\t/Users/runner/work/hostd/hostd/persist/sqlite/init.go:24\ngo.sia.tech/hostd/persist/sqlite.OpenDatabase\n\t/Users/runner/work/hostd/hostd/persist/sqlite/store.go:167\ngo.sia.tech/hostd/persist/sqlite.TestTransactionRetry\n\t/Users/runner/work/hostd/hostd/persist/sqlite/store_test.go:15\ntesting.tRunner\n\t/Users/runner/hostedtoolcache/go/1.20.7/x64/src/testing/testing.go:1576"}
Test go.sia.tech/hostd/persist/sqlite/TestTransactionRetry failed in 2.37s: persist/sqlite/logger.go#L130
logger.go:130: 2023-08-10T18:59:34.881Z DEBUG transaction long transaction {"id": "e58d3d24", "attempt": 1, "elapsed": "12.424728ms", "stack": "go.sia.tech/hostd/persist/sqlite.doTransaction.func1\n\t/Users/runner/work/hostd/hostd/persist/sqlite/store.go:140\ngo.sia.tech/hostd/persist/sqlite.doTransaction\n\t/Users/runner/work/hostd/hostd/persist/sqlite/store.go:153\ngo.sia.tech/hostd/persist/sqlite.(*Store).transaction\n\t/Users/runner/work/hostd/hostd/persist/sqlite/store.go:93\ngo.sia.tech/hostd/persist/sqlite.(*Store).init\n\t/Users/runner/work/hostd/hostd/persist/sqlite/init.go:24\ngo.sia.tech/hostd/persist/sqlite.OpenDatabase\n\t/Users/runner/work/hostd/hostd/persist/sqlite/store.go:167\ngo.sia.tech/hostd/persist/sqlite.TestTransactionRetry\n\t/Users/runner/work/hostd/hostd/persist/sqlite/store_test.go:15\ntesting.tRunner\n\t/Users/runner/hostedtoolcache/go/1.20.7/x64/src/testing/testing.go:1576", "failed": false}
Test go.sia.tech/hostd/persist/sqlite/TestTransactionRetry failed in 2.37s: persist/sqlite/logger.go#L130
logger.go:130: 2023-08-10T18:59:34.917Z DEBUG transaction slow exec {"id": "efbdef0b", "attempt": 1, "query": "UPDATE global_settings SET host_key=?", "elapsed": "34.055013ms", "stack": "go.sia.tech/hostd/persist/sqlite.(*loggedTxn).Exec\n\t/Users/runner/work/hostd/hostd/persist/sqlite/sql.go:144\ngo.sia.tech/hostd/persist/sqlite.TestTransactionRetry.func2.2\n\t/Users/runner/work/hostd/hostd/persist/sqlite/store_test.go:50\ngo.sia.tech/hostd/persist/sqlite.doTransaction\n\t/Users/runner/work/hostd/hostd/persist/sqlite/store.go:148\ngo.sia.tech/hostd/persist/sqlite.(*Store).transaction\n\t/Users/runner/work/hostd/hostd/persist/sqlite/store.go:93\ngo.sia.tech/hostd/persist/sqlite.TestTransactionRetry.func2\n\t/Users/runner/work/hostd/hostd/persist/sqlite/store_test.go:49\ntesting.tRunner\n\t/Users/runner/hostedtoolcache/go/1.20.7/x64/src/testing/testing.go:1576"}
Test go.sia.tech/hostd/persist/sqlite/TestTransactionRetry failed in 2.37s: persist/sqlite/logger.go#L130
logger.go:130: 2023-08-10T18:59:34.917Z DEBUG transaction long transaction {"id": "efbdef0b", "attempt": 1, "elapsed": "35.317077ms", "stack": "go.sia.tech/hostd/persist/sqlite.doTransaction.func1\n\t/Users/runner/work/hostd/hostd/persist/sqlite/store.go:140\ngo.sia.tech/hostd/persist/sqlite.doTransaction\n\t/Users/runner/work/hostd/hostd/persist/sqlite/store.go:149\ngo.sia.tech/hostd/persist/sqlite.(*Store).transaction\n\t/Users/runner/work/hostd/hostd/persist/sqlite/store.go:93\ngo.sia.tech/hostd/persist/sqlite.TestTransactionRetry.func2\n\t/Users/runner/work/hostd/hostd/persist/sqlite/store_test.go:49\ntesting.tRunner\n\t/Users/runner/hostedtoolcache/go/1.20.7/x64/src/testing/testing.go:1576", "failed": true}
Test go.sia.tech/hostd/persist/sqlite/TestTransactionRetry failed in 2.37s: persist/sqlite/logger.go#L130
logger.go:130: 2023-08-10T18:59:34.917Z DEBUG transaction database locked {"id": "efbdef0b", "attempt": 1, "elapsed": "35.608565ms", "totalElapsed": "35.609096ms", "stack": "go.sia.tech/hostd/persist/sqlite.(*Store).transaction\n\t/Users/runner/work/hostd/hostd/persist/sqlite/store.go:104\ngo.sia.tech/hostd/persist/sqlite.TestTransactionRetry.func2\n\t/Users/runner/work/hostd/hostd/persist/sqlite/store_test.go:49\ntesting.tRunner\n\t/Users/runner/hostedtoolcache/go/1.20.7/x64/src/testing/testing.go:1576"}
test (windows-latest, 1.20)
The operation was canceled.
test (windows-latest, 1.19)
The operation was canceled.
test (macos-latest, 1.19)
The job was canceled because "macos-latest_1_20" failed.
test (macos-latest, 1.19)
The operation was canceled.