Skip to content
CI

Index instance retention lookups #347

Sign in to view logs

Index instance retention lookups

Index instance retention lookups #347

Triggered via pull request September 16, 2026 14:42
@cardmagiccardmagic
opened #52
fix/indexed-instance-retention
Status Failure
Total duration 1m 0s
Artifacts –

ci.yml

on: pull_request
Matrix: mysql
Matrix: postgresql
quality
40s
quality
floor
26s
floor
browser
52s
browser
redis
31s
redis
publish
0s
publish
Fit to window
Zoom out
Zoom in

Annotations

4 errors
floor
Process completed with exit code 1.
test/instance-retention.test.ts > uses the retention index to find rare expired instances after multiple policies: test/instance-retention.test.ts#L94
AssertionError: expected 'SCAN retention_index_test_instances U…' to contain 'retention_index_test_instances_retent…' - Expected + Received - retention_index_test_instances_retention + SCAN retention_index_test_instances USING INDEX sqlite_autoindex_retention_index_test_instances_1 + CORRELATED SCALAR SUBQUERY 1 + SCAN ready USING COVERING INDEX retention_index_test_ready_poll + CORRELATED SCALAR SUBQUERY 2 + SCAN claimed + CORRELATED SCALAR SUBQUERY 3 + SEARCH reminders USING INDEX retention_index_test_reminders_due (status=?) + CORRELATED SCALAR SUBQUERY 4 + SCAN effects + CORRELATED SCALAR SUBQUERY 5 + SEARCH broadcasts USING COVERING INDEX retention_index_test_broadcasts_instance_revision (instance_id=?) + CORRELATED SCALAR SUBQUERY 6 + SCAN dead ❯ test/instance-retention.test.ts:94:69
quality
Process completed with exit code 1.
test/instance-retention.test.ts > uses the retention index to find rare expired instances after multiple policies: test/instance-retention.test.ts#L94
AssertionError: expected 'SCAN retention_index_test_instances U…' to contain 'retention_index_test_instances_retent…' - Expected + Received - retention_index_test_instances_retention + SCAN retention_index_test_instances USING INDEX sqlite_autoindex_retention_index_test_instances_1 + CORRELATED SCALAR SUBQUERY 1 + SCAN ready USING COVERING INDEX retention_index_test_ready_poll + CORRELATED SCALAR SUBQUERY 2 + SCAN claimed + CORRELATED SCALAR SUBQUERY 3 + SEARCH reminders USING INDEX retention_index_test_reminders_due (status=?) + CORRELATED SCALAR SUBQUERY 4 + SCAN effects + CORRELATED SCALAR SUBQUERY 5 + SEARCH broadcasts USING COVERING INDEX retention_index_test_broadcasts_instance_revision (instance_id=?) + CORRELATED SCALAR SUBQUERY 6 + SCAN dead ❯ test/instance-retention.test.ts:94:69