@@ -202,7 +202,7 @@ func containsAgentLog(daemons []database.WorkspaceAgentLog, output string) bool
202202func TestDeleteOldProvisionerDaemons (t * testing.T ) {
203203t .Parallel ()
204204
205- db ,_ := dbtestutil .NewDB (t )
205+ db ,_ := dbtestutil .NewDB (t , dbtestutil . WithDumpOnFailure () )
206206defaultOrg := dbgen .Organization (t ,db , database.Organization {})
207207logger := slogtest .Make (t ,& slogtest.Options {IgnoreErrors :true })
208208
@@ -214,11 +214,12 @@ func TestDeleteOldProvisionerDaemons(t *testing.T) {
214214// given
215215_ ,err := db .UpsertProvisionerDaemon (ctx , database.UpsertProvisionerDaemonParams {
216216// Provisioner daemon created 14 days ago, and checked in just before 7 days deadline.
217- Name :"external-0" ,
218- Provisioners : []database.ProvisionerType {"echo" },
219- Tags : database.StringMap {provisionersdk .TagScope :provisionersdk .ScopeOrganization },
220- CreatedAt :now .Add (- 14 * 24 * time .Hour ),
221- LastSeenAt : sql.NullTime {Valid :true ,Time :now .Add (- 7 * 24 * time .Hour ).Add (time .Minute )},
217+ Name :"external-0" ,
218+ Provisioners : []database.ProvisionerType {"echo" },
219+ Tags : database.StringMap {provisionersdk .TagScope :provisionersdk .ScopeOrganization },
220+ CreatedAt :now .AddDate (0 ,0 ,- 14 ),
221+ // Note: adding an hour and a minute to account for DST variations
222+ LastSeenAt : sql.NullTime {Valid :true ,Time :now .AddDate (0 ,0 ,- 7 ).Add (61 * time .Minute )},
222223Version :"1.0.0" ,
223224APIVersion :proto .CurrentVersion .String (),
224225OrganizationID :defaultOrg .ID ,
@@ -229,8 +230,8 @@ func TestDeleteOldProvisionerDaemons(t *testing.T) {
229230Name :"external-1" ,
230231Provisioners : []database.ProvisionerType {"echo" },
231232Tags : database.StringMap {provisionersdk .TagScope :provisionersdk .ScopeOrganization },
232- CreatedAt :now .Add ( - 8 * 24 * time . Hour ),
233- LastSeenAt : sql.NullTime {Valid :true ,Time :now .Add ( - 8 * 24 * time . Hour ).Add (time .Hour )},
233+ CreatedAt :now .AddDate ( 0 , 0 , - 8 ),
234+ LastSeenAt : sql.NullTime {Valid :true ,Time :now .AddDate ( 0 , 0 , - 8 ).Add (time .Hour )},
234235Version :"1.0.0" ,
235236APIVersion :proto .CurrentVersion .String (),
236237OrganizationID :defaultOrg .ID ,
@@ -244,7 +245,7 @@ func TestDeleteOldProvisionerDaemons(t *testing.T) {
244245provisionersdk .TagScope :provisionersdk .ScopeUser ,
245246provisionersdk .TagOwner :uuid .NewString (),
246247},
247- CreatedAt :now .Add ( - 9 * 24 * time . Hour ),
248+ CreatedAt :now .AddDate ( 0 , 0 , - 9 ),
248249Version :"1.0.0" ,
249250APIVersion :proto .CurrentVersion .String (),
250251OrganizationID :defaultOrg .ID ,
@@ -258,8 +259,8 @@ func TestDeleteOldProvisionerDaemons(t *testing.T) {
258259provisionersdk .TagScope :provisionersdk .ScopeUser ,
259260provisionersdk .TagOwner :uuid .NewString (),
260261},
261- CreatedAt :now .Add ( - 6 * 24 * time . Hour ),
262- LastSeenAt : sql.NullTime {Valid :true ,Time :now .Add ( - 6 * 24 * time . Hour )},
262+ CreatedAt :now .AddDate ( 0 , 0 , - 6 ),
263+ LastSeenAt : sql.NullTime {Valid :true ,Time :now .AddDate ( 0 , 0 , - 6 )},
263264Version :"1.0.0" ,
264265APIVersion :proto .CurrentVersion .String (),
265266OrganizationID :defaultOrg .ID ,
@@ -276,11 +277,18 @@ func TestDeleteOldProvisionerDaemons(t *testing.T) {
276277if err != nil {
277278return false
278279}
280+
281+ daemonNames := make ([]string ,0 ,len (daemons ))
282+ for _ ,d := range daemons {
283+ daemonNames = append (daemonNames ,d .Name )
284+ }
285+ t .Logf ("found %d daemons: %v" ,len (daemons ),daemonNames )
286+
279287return containsProvisionerDaemon (daemons ,"external-0" )&&
280288! containsProvisionerDaemon (daemons ,"external-1" )&&
281289! containsProvisionerDaemon (daemons ,"alice-provisioner" )&&
282290containsProvisionerDaemon (daemons ,"bob-provisioner" )
283- },testutil .WaitShort ,testutil .IntervalFast )
291+ },testutil .WaitShort ,testutil .IntervalSlow )
284292}
285293
286294func containsProvisionerDaemon (daemons []database.ProvisionerDaemon ,name string )bool {