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 of 1 minute.
Nicolas
On 10/10/2017 22:14, Ryan Ollos wrote:
On Tue, Oct 10, 2017 at 12:19 PM, Nicolas MARTIN
<ntm...@locean.upmc.fr <mailto:ntm...@locean.upmc.fr>> wrote:
Hello Trac users
I just tried to clean up a little the amount of anonymous sessions
stored in the database but each attempt seems to be ending up in a
dead end. Have to kill the process after some time without clear
evolution.
After setting the good options to output the log in the console
('[logging] log_type = stderr' Don't even know this tip !), I got
the whole process but the issue remains undetermined to me. Trac
loads its environment with the installed plugins and the last 2
lines are about the default workflow and the database:
'
...
20:55:03 Trac[default_workflow] DEBUG: Workflow actions at
initialization: {u'resolve': {u'operations': [u'set_resolution'],
'name': u'resolve', u'default': 998, 'newstate': u'closed',
'oldstates': [u'assigned', u'new', u'reopened'], u'permissions':
[u'TICKET_MODIFY']}, u'accept': {u'operations':
[u'set_owner_to_self'], 'name': u'accept', u'default': 997,
'newstate': u'assigned', 'oldstates': [u'new', u'reopened'],
u'permissions': [u'TICKET_MODIFY']}, u'leave': {u'operations':
[u'leave_status'], 'name': u'leave', u'default': 1000, 'newstate':
u'*', 'oldstates': [u'assigned', u'new', u'reopened', u'closed'],
'permissions': []}, u'reopen': {u'operations':
[u'del_resolution'], 'name': u'reopen', u'default': 996,
'newstate': u'reopened', 'oldstates': [u'closed'], u'permissions':
[u'TICKET_CREATE']}, u'reassign': {u'operations': [u'set_owner'],
'name': u'reassign', u'default': 999, 'newstate': u'assigned',
'oldstates': [u'assigned', u'new', u'reopened'], u'permissions':
[u'TICKET_MODIFY']}, '_reset': {'operations': ['reset_workflow'],
'name': 'reset', 'default': 0, 'newstate': 'new', 'oldstates': [],
'permissions': []}}
20:55:03 Trac[tracdb] DEBUG: "FormDBComponent" does not need a
schema upgrade.
'
Regards,
Nicolas
Session purge could take a little time to execute if you have many
anonymous sessions, as may occur due to bots with a
publicly-accessible site. How long did you let the command run for?
If you have an SQLite database the command will lock the database and
therefore the site will not be accessible while the command is executing.
If you want to know how many sessions exist you can check using a
command line tool such as sqlite3.
$ sqlite3 ~/trac/db/trac.db
sqlite> SELECT COUNT(*) FROM session;
- 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.
