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

[Kevin Falcone]

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 --------------
A non-text attachment was scrubbed...
Name: not available
Type: application/pgp-signature
Size: 235 bytes
Desc: not available
URL: <http://lists.bestpractical.com/pipermail/rt-users/attachments/20130708/2b189408/attachment.sig>