Skip to content

Fix volume migration #439

Fix volume migration

Fix volume migration #439

Triggered via pull request October 4, 2023 03:52
Status Failure
Total duration 7m 22s
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.44s: persist/sqlite/logger.go#L130
logger.go:130: 2023-10-04T03:57:29.553Z DEBUG transaction.statement slow query row {"id": "9b850b58", "attempt": 1, "query": "INSERT INTO locked_volume_sectors (volume_sector_id) VALUES ($1) RETURNING id;", "elapsed": "4.019936ms", "stack": "go.sia.tech/hostd/persist/sqlite.(*loggedStmt).QueryRowContext\n\t/home/runner/work/hostd/hostd/persist/sqlite/sql.go:134\ngo.sia.tech/hostd/persist/sqlite.(*loggedStmt).QueryRow\n\t/home/runner/work/hostd/hostd/persist/sqlite/sql.go:127\ngo.sia.tech/hostd/persist/sqlite.lockLocations\n\t/home/runner/work/hostd/hostd/persist/sqlite/sectors.go:321\ngo.sia.tech/hostd/persist/sqlite.(*Store).StoreSector.func1\n\t/home/runner/work/hostd/hostd/persist/sqlite/volumes.go:233\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
Test go.sia.tech/hostd/persist/sqlite/TestPrune failed in 0.44s: persist/sqlite/volumes.go#L208
/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.44s: persist/sqlite/logger.go#L130
logger.go:130: 2023-10-04T03:57:29.617Z DEBUG transaction.statement slow query row {"id": "bf1e7a00", "attempt": 1, "query": "INSERT INTO locked_volume_sectors (volume_sector_id) VALUES ($1) RETURNING id;", "elapsed": "4.046937ms", "stack": "go.sia.tech/hostd/persist/sqlite.(*loggedStmt).QueryRowContext\n\t/home/runner/work/hostd/hostd/persist/sqlite/sql.go:134\ngo.sia.tech/hostd/persist/sqlite.(*loggedStmt).QueryRow\n\t/home/runner/work/hostd/hostd/persist/sqlite/sql.go:127\ngo.sia.tech/hostd/persist/sqlite.lockLocations\n\t/home/runner/work/hostd/hostd/persist/sqlite/sectors.go:321\ngo.sia.tech/hostd/persist/sqlite.(*Store).StoreSector.func1\n\t/home/runner/work/hostd/hostd/persist/sqlite/volumes.go:233\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
Test go.sia.tech/hostd/persist/sqlite/TestPrune failed in 0.44s: persist/sqlite/volumes.go#L208
/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.44s: persist/sqlite/logger.go#L130
logger.go:130: 2023-10-04T03:57:29.770Z DEBUG slow exec {"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": "7.128664ms", "stack": "go.sia.tech/hostd/persist/sqlite.(*Store).exec\n\t/home/runner/work/hostd/hostd/persist/sqlite/store.go:31\ngo.sia.tech/hostd/persist/sqlite.(*dbTxn).Exec\n\t/home/runner/work/hostd/hostd/persist/sqlite/sql.go:197\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.clearVolumeSector\n\t/home/runner/work/hostd/hostd/persist/sqlite/sectors.go:192\ngo.sia.tech/hostd/persist/sqlite.pruneSectorRef\n\t/home/runner/work/hostd/hostd/persist/sqlite/sectors.go:223\ngo.sia.tech/hostd/persist/sqlite.unlockSector\n\t/home/runner/work/hostd/hostd/persi
Test go.sia.tech/hostd/persist/sqlite/TestPrune failed in 0.44s: persist/sqlite/sectors.go#L296
st/sqlite/sectors.go:296\ngo.sia.tech/hostd/persist/sqlite.TestPrune\n\t/home/runner/work/hostd/hostd/persist/sqlite/volumes_test.go:758\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.44s: persist/sqlite/logger.go#L130
logger.go:130: 2023-10-04T03:57:29.792Z DEBUG transaction.row slow scan {"id": "48c29913", "attempt": 1, "elapsed": "4.032936ms", "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).SectorLocation.func1\n\t/home/runner/work/hostd/hostd/persist/sqlite/sectors.go:106\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).SectorLocation\n\t/home/runner/work/hostd/hostd/persist/sqlite/sectors.go:95\ngo.sia.tech/hostd/persist/sqlite.TestPrune.func3\n\t/home/runner/work/hostd/hostd/persist/sqlite/volumes_test.go:709\ngo.sia.tech/hostd/persist/sqlite.TestPrune\n\t/home/runner/work/hostd/hos
Test go.sia.tech/hostd/persist/sqlite/TestPrune failed in 0.44s: persist/sqlite/volumes_test.go#L762
td/persist/sqlite/volumes_test.go:762\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.44s: persist/sqlite/logger.go#L130
logger.go:130: 2023-10-04T03:57:29.804Z DEBUG transaction slow query row {"id": "ba979d57", "attempt": 1, "query": "SELECT v.id, v.volume_id, v.volume_index, s.sector_root\nFROM volume_sectors v \nINNER JOIN stored_sectors s ON (s.id=v.sector_id)\nWHERE v.sector_id=$1", "elapsed": "5.324648ms", "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.sectorLocation\n\t/home/runner/work/hostd/hostd/persist/sqlite/volumes.go:436\ngo.sia.tech/hostd/persist/sqlite.(*Store).SectorLocation.func1\n\t/home/runner/work/hostd/hostd/persist/sqlite/sectors.go:102\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).SectorLocation\n\t/home/runner/work/hostd/hostd/persist/sqlite/sectors.go:95\ngo.sia.tech/host
test (windows-latest, 1.20)
The operation was canceled.
test (windows-latest, 1.21)
The operation was canceled.
test (ubuntu-latest, 1.21)
The operation was canceled.
test (macos-latest, 1.21)
The operation was canceled.
test (macos-latest, 1.20)
The operation was canceled.