[rt-users] RT session cleanup - session table size

[Alex Decalli]

Thanks a lot Kevin. Frankly I have been working on this server for like 1
week, this is RT3.8 on Ubuntu 11.04 (terrible, I know), it has no GUI
installed (no problem for me), mysql 5.1 and the administrator has left
almost for 1 year, so no support for long time. The auto logoff was not
set, we are planning to find all the problems, announce downtime (this
server is being used globally) and make changes, I am planning to set the
autologoff too. But now, how can I at least manually clean this session
table? is there any way? (I am new to this RT, so I am really not sure how
it works yet, I am studying it and I know that this data on session table
is really useless for future)


On Mon, Jul 8, 2013 at 5:01 PM, Kevin Falcone <falcone at bestpractical.com>wrote:

> On Sun, Jul 07, 2013 at 02:21:52PM +0200, Alex Decalli wrote:
> >    Hello everybody
> >    I want to cleanup my session table, it is already about 1 Gigabyte! I
> hit:
> >
> >    me at myserver:~$ sudo rt-clean-sessions --debug --older 1M
> >
> >    and it says:
> >
> >    [Sun Jul 7 12:20:26 2013] [warning]: Use of uninitialized value
> $alogoff in multiplication (*)
> >    at /usr/sbin/rt-clean-sessions line 118.
> (/usr/sbin/rt-clean-sessions:118)
> >    [Sun Jul 7 12:20:26 2013] [info]: successfuly deleted 0E0 sessions
> >    (/usr/share/request-tracker3.8/lib/RT/Interface/Web/Session.pm:195)
> >
> >    And my table is still the same size! how does it work? isn't it
> supposed to delete these rows
> >    and reduce the size of table?
>
> What is AutoLogoff set to in your RT_SiteConfig.pm file?
> You can confirm the version RT sees by looking at Tools ->
> Configuration -> Tools -> System Configuration and searching for
> AutoLogoff.  This might explain your weird warning.
>
> As for why nothing is deleted, if you log into your database (which
> database are you using?) you can run
> select min(LastUpdated) from sessions;
> to see what your data looks like.
>
> -kevin
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.bestpractical.com/pipermail/rt-users/attachments/20130708/58e323c3/attachment.htm>