Skip to content

Fix volume migration #441

Fix volume migration

Fix volume migration #441

Triggered via pull request October 4, 2023 04:03
Status Failure
Total duration 7m 10s
Artifacts

main.yml

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

Annotations

15 errors
test (ubuntu-latest, 1.20)
1/92 tests failed
Test go.sia.tech/hostd/persist/sqlite/TestPrune failed in 0.41s: persist/sqlite/logger.go#L130
logger.go:130: 2023-10-04T04:08:40.339Z DEBUG transaction slow exec {"id": "6acd0a10", "attempt": 1, "query": "INSERT INTO host_stats (stat, stat_value, date_created) VALUES ($1, $2, $3) ON CONFLICT (stat, date_created) DO UPDATE SET stat_value=EXCLUDED.stat_value", "elapsed": "5.478378ms", "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.incrementNumericStat\n\t/home/runner/work/hostd/hostd/persist/sqlite/metrics.go:456\ngo.sia.tech/hostd/persist/sqlite.incrementVolumeUsage\n\t/home/runner/work/hostd/hostd/persist/sqlite/sectors.go:176\ngo.sia.tech/hostd/persist/sqlite.(*Store).StoreSector.func1\n\t/home/runner/work/hostd/hostd/persist/sqlite/volumes.go:252\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/persi
Test go.sia.tech/hostd/persist/sqlite/TestPrune failed in 0.41s: persist/sqlite/volumes.go#L208
st/sqlite.(*Store).StoreSector\n\t/home/runner/work/hostd/hostd/persist/sqlite/volumes.go:208\ngo.sia.tech/hostd/persist/sqlite.TestPrune\n\t/home/runner/work/hostd/hostd/persist/sqlite/volumes_test.go:604\ntesting.tRunner\n\t/opt/hostedtoolcache/go/1.20.8/x64/src/testing/testing.go:1576"}
Test go.sia.tech/hostd/persist/sqlite/TestPrune failed in 0.41s: persist/sqlite/logger.go#L130
logger.go:130: 2023-10-04T04:08:40.371Z DEBUG transaction slow query row {"id": "71f5c3d1", "attempt": 1, "query": "SELECT id FROM storage_volumes WHERE available=true AND read_only=false AND total_sectors-used_sectors > 0 ORDER BY used_sectors ASC LIMIT 1;", "elapsed": "4.029083ms", "stack": "go.sia.tech/hostd/persist/sqlite.(*loggedTxn).QueryRow\n\t/home/runner/work/hostd/hostd/persist/sqlite/sql.go:189\ngo.sia.tech/hostd/persist/sqlite.emptyLocation\n\t/home/runner/work/hostd/hostd/persist/sqlite/volumes.go:460\ngo.sia.tech/hostd/persist/sqlite.(*Store).StoreSector.func1\n\t/home/runner/work/hostd/hostd/persist/sqlite/volumes.go:224\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).StoreSector\n\t/home/runner/work/hostd/hostd/persist/sqlite/volumes.go:208\ngo.sia.tech/hostd/persist/sqlite.
Test go.sia.tech/hostd/persist/sqlite/TestPrune failed in 0.41s: persist/sqlite/volumes_test.go#L604
TestPrune\n\t/home/runner/work/hostd/hostd/persist/sqlite/volumes_test.go:604\ntesting.tRunner\n\t/opt/hostedtoolcache/go/1.20.8/x64/src/testing/testing.go:1576"}
Test go.sia.tech/hostd/persist/sqlite/TestPrune failed in 0.41s: persist/sqlite/logger.go#L130
logger.go:130: 2023-10-04T04:08:40.387Z DEBUG transaction.row slow scan {"id": "f2146ed2", "attempt": 1, "elapsed": "4.042184ms", "stack": "go.sia.tech/hostd/persist/sqlite.(*loggedRow).Scan\n\t/home/runner/work/hostd/hostd/persist/sqlite/sql.go:95\ngo.sia.tech/hostd/persist/sqlite.incrementNumericStat\n\t/home/runner/work/hostd/hostd/persist/sqlite/metrics.go:443\ngo.sia.tech/hostd/persist/sqlite.incrementVolumeUsage\n\t/home/runner/work/hostd/hostd/persist/sqlite/sectors.go:176\ngo.sia.tech/hostd/persist/sqlite.(*Store).StoreSector.func1\n\t/home/runner/work/hostd/hostd/persist/sqlite/volumes.go:252\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).StoreSector\n\t/home/runner/work/hostd/hostd/persist/sqlite/volumes.go:208\ngo.sia.tech/hostd/persist/sqlite.TestPrune\n\t/home/runner/work/host
Test go.sia.tech/hostd/persist/sqlite/TestPrune failed in 0.41s: persist/sqlite/volumes_test.go#L604
d/hostd/persist/sqlite/volumes_test.go:604\ntesting.tRunner\n\t/opt/hostedtoolcache/go/1.20.8/x64/src/testing/testing.go:1576"}
Test go.sia.tech/hostd/persist/sqlite/TestPrune failed in 0.41s: persist/sqlite/logger.go#L130
logger.go:130: 2023-10-04T04:08:40.421Z DEBUG transaction slow exec {"id": "53529078", "attempt": 1, "query": "UPDATE volume_sectors SET sector_id=$1 WHERE id=$2", "elapsed": "4.455082ms", "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).StoreSector.func1\n\t/home/runner/work/hostd/hostd/persist/sqlite/volumes.go:242\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).StoreSector\n\t/home/runner/work/hostd/hostd/persist/sqlite/volumes.go:208\ngo.sia.tech/hostd/persist/sqlite.TestPrune\n\t/home/runner/work/hostd/hostd/persist/sqlite/volumes_test.go:604\ntesting.tRunner\n\t/opt/hostedtoolcache/go/1.20.8/x64/src/testing/testing.go:1576"}
Test go.sia.tech/hostd/persist/sqlite/TestPrune failed in 0.41s: persist/sqlite/logger.go#L130
logger.go:130: 2023-10-04T04:08:40.435Z DEBUG transaction.row slow scan {"id": "384a692d", "attempt": 1, "elapsed": "4.050383ms", "stack": "go.sia.tech/hostd/persist/sqlite.(*loggedRow).Scan\n\t/home/runner/work/hostd/hostd/persist/sqlite/sql.go:95\ngo.sia.tech/hostd/persist/sqlite.lockSector\n\t/home/runner/work/hostd/hostd/persist/sqlite/sectors.go:256\ngo.sia.tech/hostd/persist/sqlite.(*Store).StoreSector.func1\n\t/home/runner/work/hostd/hostd/persist/sqlite/volumes.go:215\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).StoreSector\n\t/home/runner/work/hostd/hostd/persist/sqlite/volumes.go:208\ngo.sia.tech/hostd/persist/sqlite.TestPrune\n\t/home/runner/work/hostd/hostd/persist/sqlite/volumes_test.go:604\ntesting.tRunner\n\t/opt/hostedtoolcache/go/1.20.8/x64/src/testing/testing.go:1576"}
Test go.sia.tech/hostd/persist/sqlite/TestPrune failed in 0.41s: persist/sqlite/logger.go#L130
logger.go:130: 2023-10-04T04:08:40.454Z DEBUG transaction.row slow scan {"id": "c432380e", "attempt": 1, "elapsed": "4.023184ms", "stack": "go.sia.tech/hostd/persist/sqlite.(*loggedRow).Scan\n\t/home/runner/work/hostd/hostd/persist/sqlite/sql.go:95\ngo.sia.tech/hostd/persist/sqlite.sectorLocation\n\t/home/runner/work/hostd/hostd/persist/sqlite/volumes.go:436\ngo.sia.tech/hostd/persist/sqlite.(*Store).StoreSector.func1\n\t/home/runner/work/hostd/hostd/persist/sqlite/volumes.go:221\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).StoreSector\n\t/home/runner/work/hostd/hostd/persist/sqlite/volumes.go:208\ngo.sia.tech/hostd/persist/sqlite.TestPrune\n\t/home/runner/work/hostd/hostd/persist/sqlite/volumes_test.go:604\ntesting.tRunner\n\t/opt/hostedtoolcache/go/1.20.8/x64/src/testing/testing.go:1576"}
test (macos-latest, 1.21)
The operation was canceled.
test (macos-latest, 1.20)
The operation was canceled.
test (windows-latest, 1.21)
The operation was canceled.
test (windows-latest, 1.20)
The operation was canceled.
test (ubuntu-latest, 1.21)
The operation was canceled.