There was no surprise regarding the number of sessions removed (almost zero),  the site has been released publicly a few months ago. My command was just for testing purpose but I didn't expect it would take some much time with no substantial operations on the db.

In fact, we have a mean of 500 sessions created per day since putting it online. I decided to cut by half and kept the sessions only since September,
I'm not sure if we have an interest of keeping them.

The weird thing is that the command took about 4 mins while parsing the same number of sessions.


Nicolas


On 11/10/2017 04:37, RjOllos wrote:


On Tuesday, October 10, 2017 at 1:49:30 PM UTC-7, Nicolas MARTIN wrote:

    Well finally the system completed the command (almost 8 minutes)

    '

    22:35:40 Trac[tracdb] DEBUG: "FormDBComponent" does not need a
    schema upgrade.

    real    8m25.808s
    user    0m0.850s
    sys    0m0.080s

    '

    The funny thing is that it has removed almost none sessions during
    that time :-/


Approximately how many sessions were removed?

It might be that the datetime format you used is not correct for your host. You can see the valid localized format in the help text:
$trac-admin ../tracenvs/proj-1.0 help session purge

session purge <age>

    Purge anonymous sessions older than the given age or date

    Age may be specified as a relative time like "90 days ago", or as a date in     the "MMM d, y, h:mm:ss a" or "YYYY-MM-DDThh:mm:ss±hh:mm" (ISO 8601) format.


You could use "3 years ago" for the age, to get close to the effect of "01/01/15 00:00:00"

- Ryan
--
You received this message because you are subscribed to the Google Groups "Trac Users" group. To unsubscribe from this group and stop receiving emails from it, send an email to trac-users+unsubscr...@googlegroups.com <mailto:trac-users+unsubscr...@googlegroups.com>. To post to this group, send email to trac-users@googlegroups.com <mailto:trac-users@googlegroups.com>.
Visit this group at https://groups.google.com/group/trac-users.
For more options, visit https://groups.google.com/d/optout.

--
You received this message because you are subscribed to the Google Groups "Trac 
Users" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to trac-users+unsubscr...@googlegroups.com.
To post to this group, send email to trac-users@googlegroups.com.
Visit this group at https://groups.google.com/group/trac-users.
For more options, visit https://groups.google.com/d/optout.

Reply via email to