Re: [Trac] Purge session command stuck in the process

2017-11-16 Thread Jun Omae
On Tue, Nov 7, 2017 at 7:41 PM, Nicolas MARTIN wrote: > Here you are > > $ psql -c "EXPLAIN DELETE FROM session WHERE authenticated=0 AND > last_visit<1504216800;" > QUERY PLAN >

Re: [Trac] Purge session command stuck in the process

2017-11-07 Thread Nicolas MARTIN
Here you are $ psql -c "EXPLAIN DELETE FROM session WHERE authenticated=0 AND last_visit<1504216800;" QUERY PLAN -  Delete on session  (cost=0.00..931.79 rows=1506 width=6)    ->  Seq Scan on

Re: [Trac] Purge session command stuck in the process

2017-11-06 Thread Jun Omae
On Tue, Nov 7, 2017 at 2:52 AM, Nicolas MARTIN wrote: > $ time trac-admin ~/trac/ session purge "09/01/17 00:00:00" > 18:34:31 Trac[env] INFO: environment > startup [Trac 1.0.1] > ... > 18:34:32 Trac[util]

Re: [Trac] Purge session command stuck in the process

2017-11-06 Thread Nicolas MARTIN
Finally I cut by three the number of remaining anonymous sessions (~10 000) in order to get a workable running time, by this I hope to improve the overall behavior of Trac. I set '1 month ago' in trac-admin purge argument and insert the command in the cron. Maybe it won't stay that way in the

Re: [Trac] Purge session command stuck in the process

2017-11-06 Thread Nicolas MARTIN
Back to this thread, I launched a anonymous sessions purge with your recommended options: $ psql -c "SELECT COUNT(*) FROM session;" count --- 32107 $ time trac-admin ~/trac/ session purge "01/01/15 00:00:00" 17:43:22 Trac[env] INFO: environment startup

Re: [Trac] Purge session command stuck in the process

2017-10-11 Thread RjOllos
On Wednesday, October 11, 2017 at 3:33:23 AM UTC-7, Nicolas MARTIN wrote: > > 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 >

Re: [Trac] Purge session command stuck in the process

2017-10-11 Thread Nicolas MARTIN
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

Re: [Trac] Purge session command stuck in the process

2017-10-10 Thread RjOllos
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. > > real8m25.808s > user0m0.850s > sys0m0.080s > >

Re: [Trac] Purge session command stuck in the process

2017-10-10 Thread Nicolas MARTIN
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 :-/ On

Re: [Trac] Purge session command stuck in the process

2017-10-10 Thread Nicolas MARTIN
That's the first time I look into this, there is about ~63 000 sessions in the database (PostgreSQL). For the availability of the platform, it is kind of the right time because we are well out of working hours here. For my first attempts, don't know exactly the time I let but it is a matter