@@ -24,50 +24,49 @@ export class DatabaseStorage extends Context.Service<
2424 * retained event with a higher sequence, so a client replaying from an older
2525 * cursor still reaches the same state; no replay boundary is published.
2626 */
27- export const layer = Layer . effect (
28- DatabaseStorage ,
29- Effect . gen ( function * ( ) {
30- const sql = yield * SqlClient . SqlClient ;
31- const maintenance = yield * ProjectionMaintenance . ProjectionMaintenanceV2 ;
27+ const make = Effect . gen ( function * ( ) {
28+ const sql = yield * SqlClient . SqlClient ;
29+ const maintenance = yield * ProjectionMaintenance . ProjectionMaintenanceV2 ;
30+
31+ const reclaim = Effect . gen ( function * ( ) {
32+ const mode = yield * sql < { readonly auto_vacuum : number } > `PRAGMA auto_vacuum` ;
33+ if ( mode [ 0 ] ?. auto_vacuum !== 2 ) return ;
34+ // The driver steps a statement without result columns once, and each
35+ // step of incremental_vacuum frees one page. Yield between pages so
36+ // client requests can run.
37+ for ( let page = 0 ; page < RECLAIM_PAGES_PER_PASS ; page ++ ) {
38+ const free = yield * sql < { readonly freelist_count : number } > `PRAGMA freelist_count` ;
39+ if ( ( free [ 0 ] ?. freelist_count ?? 0 ) === 0 ) break ;
40+ yield * sql `PRAGMA incremental_vacuum(1)` ;
41+ yield * Effect . yieldNow ;
42+ }
43+ } ) . pipe (
44+ Effect . catch ( ( cause ) => Effect . logWarning ( "Database space reclamation failed" , { cause } ) ) ,
45+ ) ;
3246
33- const reclaim = Effect . gen ( function * ( ) {
34- const mode = yield * sql < { readonly auto_vacuum : number } > `PRAGMA auto_vacuum` ;
35- if ( mode [ 0 ] ?. auto_vacuum !== 2 ) return ;
36- // The driver steps a statement without result columns once, and each
37- // step of incremental_vacuum frees one page. Yield between pages so
38- // client requests can run.
39- for ( let page = 0 ; page < RECLAIM_PAGES_PER_PASS ; page ++ ) {
40- const free = yield * sql < { readonly freelist_count : number } > `PRAGMA freelist_count` ;
41- if ( ( free [ 0 ] ?. freelist_count ?? 0 ) === 0 ) break ;
42- yield * sql `PRAGMA incremental_vacuum(1)` ;
43- yield * Effect . yieldNow ;
44- }
45- } ) . pipe (
46- Effect . catch ( ( cause ) => Effect . logWarning ( "Database space reclamation failed" , { cause } ) ) ,
47- ) ;
47+ const compact = maintenance . compactEventStore . pipe (
48+ Effect . tap ( ( result ) =>
49+ result . deletedEventCount > 0 || result . deletedReceiptCount > 0
50+ ? Effect . logInfo ( "Compacted orchestration history" , result )
51+ : Effect . void ,
52+ ) ,
53+ Effect . catch ( ( cause ) =>
54+ Effect . logWarning ( "Orchestration history compaction failed" , { cause } ) ,
55+ ) ,
56+ ) ;
4857
49- const compact = maintenance . compactEventStore . pipe (
50- Effect . tap ( ( result ) =>
51- result . deletedEventCount > 0 || result . deletedReceiptCount > 0
52- ? Effect . logInfo ( "Compacted orchestration history" , result )
53- : Effect . void ,
54- ) ,
55- Effect . catch ( ( cause ) =>
56- Effect . logWarning ( "Orchestration history compaction failed" , { cause } ) ,
57- ) ,
58- ) ;
58+ yield * forkParked (
59+ Effect . sleep ( "1 minute" ) . pipe (
60+ Effect . andThen ( compact . pipe ( Effect . repeat ( Schedule . spaced ( "6 hours" ) ) ) ) ,
61+ ) ,
62+ ) ;
63+ yield * forkParked (
64+ Effect . sleep ( "1 minute" ) . pipe (
65+ Effect . andThen ( reclaim . pipe ( Effect . repeat ( Schedule . spaced ( "1 minute" ) ) ) ) ,
66+ ) ,
67+ ) ;
5968
60- yield * forkParked (
61- Effect . sleep ( "1 minute" ) . pipe (
62- Effect . andThen ( compact . pipe ( Effect . repeat ( Schedule . spaced ( "6 hours" ) ) ) ) ,
63- ) ,
64- ) ;
65- yield * forkParked (
66- Effect . sleep ( "1 minute" ) . pipe (
67- Effect . andThen ( reclaim . pipe ( Effect . repeat ( Schedule . spaced ( "1 minute" ) ) ) ) ,
68- ) ,
69- ) ;
69+ return DatabaseStorage . of ( { reclaim } ) ;
70+ } ) ;
7071
71- return DatabaseStorage . of ( { reclaim } ) ;
72- } ) ,
73- ) ;
72+ export const layer = Layer . effect ( DatabaseStorage , make ) ;
0 commit comments