Skip to content

Increase default batch size #324

Increase default batch size

Increase default batch size #324

Triggered via pull request August 1, 2023 14:42
Status Failure
Total duration 6m 43s
Artifacts

main.yml

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

Annotations

12 errors
test (macos-latest, 1.20)
1/59 tests failed
Test go.sia.tech/hostd/rhp/v3/TestWebSockets failed in 0.06s: rhp/v3/logger.go#L130
logger.go:130: 2023-08-01T14:48:57.792Z DEBUG host.sqlite.transaction slow exec {"query": "/*\n\tWhen changing the schema, the version must be incremented at the bottom of\n\tthis file and a migration added to migrations.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 shoul
Test go.sia.tech/hostd/rhp/v3/TestWebSockets failed in 0.06s: rhp/v3/sql.go#L144
n\nCREATE TABLE global_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\nINSERT INTO global_settings (id, db_version) VALUES (0, 10); -- version must be updated when the schema changes", "elapsed": "5.128291ms", "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:36\ngo.sia.tech/hostd/persist
Test go.sia.tech/hostd/rhp/v3/TestWebSockets failed in 0.06s: rhp/v3/store.go#L96
/sqlite.(*Store).transaction.func1\n\t/Users/runner/work/hostd/hostd/persist/sqlite/store.go:96\ngo.sia.tech/hostd/persist/sqlite.(*Store).transaction\n\t/Users/runner/work/hostd/hostd/persist/sqlite/store.go:116\ngo.sia.tech/hostd/persist/sqlite.(*Store).init\n\t/Users/runner/work/hostd/hostd/persist/sqlite/init.go:31\ngo.sia.tech/hostd/persist/sqlite.OpenDatabase\n\t/Users/runner/work/hostd/hostd/persist/sqlite/store.go:157\ngo.sia.tech/hostd/internal/test.NewHost\n\t/Users/runner/work/hostd/hostd/internal/test/host.go:156\ngo.sia.tech/hostd/internal/test.NewTestingPair\n\t/Users/runner/work/hostd/hostd/internal/test/node.go:203\ngo.sia.tech/hostd/rhp/v3_test.TestWebSockets\n\t/Users/runner/work/hostd/hostd/rhp/v3/websocket_test.go:16\ntesting.tRunner\n\t/Users/runner/hostedtoolcache/go/1.20.5/x64/src/testing/testing.go:1576"}
Test go.sia.tech/hostd/rhp/v3/TestWebSockets failed in 0.06s: rhp/v3/logger.go#L130
logger.go:130: 2023-08-01T14:48:57.797Z DEBUG host.wallet processing consensus change {"applied": 1, "reverted": 0}
Test go.sia.tech/hostd/rhp/v3/TestWebSockets failed in 0.06s: rhp/v3/logger.go#L130
logger.go:130: 2023-08-01T14:48:57.799Z DEBUG host.wallet applied consensus change {"changeID": "61bd1d9fe888d0212530bbd46bec4d59a268267fae3da48980e038f283d9170f", "applied": 1, "reverted": 0, "height": 0, "elapsed": "1.904489ms", "address": "addr:bbdff2c4a48945e5043f6c7e45476f26b5e03d98165db6f04b4c9a1aaf562b8ac2f479181e71"}
Test go.sia.tech/hostd/rhp/v3/TestWebSockets failed in 0.06s: rhp/v3/logger.go#L130
logger.go:130: 2023-08-01T14:48:57.799Z ERROR host.storage.initialize failed to initialize volume {"volumeID": 1, "maxSectors": 64, "error": "failed to expand volume metadata: failed to begin transaction: failed to grow volume: database is locked"}
Test go.sia.tech/hostd/rhp/v3/TestWebSockets failed in 0.06s: rhp/v3/websocket_test.go#L18
websocket_test.go:18: failed to create host: failed to add storage volume: failed to expand volume metadata: failed to begin transaction: failed to grow volume: database is locked
test (windows-latest, 1.19)
The operation was canceled.
test (windows-latest, 1.20)
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.