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.
