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
pgpXrhG3fKY0H.pgp
Description: PGP signature
