[rt-users] RT session cleanup - session table size
alexdecalli71 at gmail.com
Mon Jul 8 14:05:32 EDT 2013
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
> > 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.
> > [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.
-------------- next part --------------
An HTML attachment was scrubbed...
More information about the rt-users