Opened on 07/14/2015 at 02:15:10 PM
Closed on 08/11/2015 at 01:28:43 PM
#2782 closed defect (fixed)
Establish cron-job to clean up Trac sessions
| Reported by: | matze | Assignee: | matze |
|---|---|---|---|
| Priority: | P2 | Milestone: | |
| Module: | Infrastructure | Keywords: | |
| Cc: | fred | Blocked By: | #2586, #2849 |
| Blocking: | Platform: | Unknown / Cross platform | |
| Ready: | yes | Confidential: | no |
| Tester: | Unknown | Verified working: | no |
| Review URL(s): | |||
Description (last modified by matze)
In order to continuously clean out obsolete session records from Trac (see #2586), the following two SQL query should become executed daily:
DELETE
session,
session_attribute
FROM
session
JOIN
session_attribute ON
session.sid = session_attribute.sid AND
session.authenticated = session_attribute.authenticated
WHERE
session.authenticated = 0 AND
session.last_visit < UNIX_TIMESTAMP(NOW() - INTERVAL 10 DAY)
;
Attachments (0)
Change History (7)
comment:1 Changed on 07/14/2015 at 02:15:30 PM by matze
- Component changed from Unknown to Infrastructure
- Priority changed from Unknown to P2
comment:2 Changed on 07/14/2015 at 02:17:48 PM by matze
- Description modified (diff)
- Summary changed from Establish cron-jobs to clean up Trac sessions to Establish cron-job to clean up Trac sessions
comment:3 Changed on 07/14/2015 at 02:20:03 PM by matze
- Cc fred added; fhd trev removed
comment:4 Changed on 08/03/2015 at 11:55:06 AM by matze
- Blocked By 2849 added
comment:5 Changed on 08/03/2015 at 02:01:00 PM by matze
- Owner set to matze
comment:6 Changed on 08/03/2015 at 02:01:13 PM by matze
- Review URL(s) modified (diff)
- Status changed from new to reviewing
comment:7 Changed on 08/11/2015 at 01:28:43 PM by matze
- Resolution set to fixed
- Status changed from reviewing to closed
Note: See
TracTickets for help on using
tickets.
https://hg.adblockplus.org/infrastructure/rev/3907dff6b187