On Tue, Oct 10, 2017 at 12:19 PM, Nicolas MARTIN <[email protected]>
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 [email protected].
To post to this group, send email to [email protected].
Visit this group at https://groups.google.com/group/trac-users.
For more options, visit https://groups.google.com/d/optout.
