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 <[email protected]>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@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 >
