Problem with RT3 database

Hi,

our company is massively using RT since a couple of months and we
figured it would be a good idea to clean it up a little bit.

The problem we seem to have is that every ticket information seems to be
stored in the sessions database.

[rootrt3 rt3]# ls -al
total 2048556
drwx------ 2 mysql mysql 4096 Oct 8 2004 .
drwxr-xr-x 7 mysql mysql 4096 Apr 26 08:03 …
-rw-rw---- 1 mysql mysql 8812 Mar 31 2004 ACL.frm
-rw-rw---- 1 mysql mysql 8920 Mar 31 2004 Attachments.frm
-rw-rw---- 1 mysql mysql 8716 Oct 8 2004
CachedGroupMembers.frm
-rw-rw---- 1 mysql mysql 8868 Mar 31 2004 CustomFields.frm
-rw-rw---- 1 mysql mysql 8824 Mar 31 2004
CustomFieldValues.frm
-rw-rw---- 1 mysql mysql 8612 Mar 31 2004 GroupMembers.frm
-rw-rw---- 1 mysql mysql 8696 Mar 31 2004 Groups.frm
-rw-rw---- 1 mysql mysql 8838 Mar 31 2004 Links.frm
-rw-rw---- 1 mysql mysql 8656 Mar 31 2004 Principals.frm
-rw-rw---- 1 mysql mysql 9006 Mar 31 2004 Queues.frm
-rw-rw---- 1 mysql mysql 8820 Mar 31 2004 ScripActions.frm
-rw-rw---- 1 mysql mysql 8876 Mar 31 2004
ScripConditions.frm
-rw-rw---- 1 mysql mysql 9134 Mar 31 2004 Scrips.frm
-rw-rw---- 1 mysql mysql 8622 Mar 31 2004 sessions.frm
-rw-rw---- 1 mysql mysql 1820345076 May 10 18:55 sessions.MYD
-rw-rw---- 1 mysql mysql 275074048 May 10 18:55 sessions.MYI
-rw-rw---- 1 mysql mysql 8906 Mar 31 2004 Templates.frm
-rw-rw---- 1 mysql mysql 8786 Mar 31 2004
TicketCustomFieldValues.frm
-rw-rw---- 1 mysql mysql 9388 Mar 31 2004 Tickets.frm
-rw-rw---- 1 mysql mysql 8856 Mar 31 2004 Transactions.frm
-rw-rw---- 1 mysql mysql 9744 Mar 31 2004 Users.frm

There seems to be a problem here.
The columns of the sessions table are:

mysql> SHOW COLUMNS FROM sessions;
| Field | Type | Null | Key | Default | Extra |
| id | varchar(32) | | PRI | | |
| a_session | longtext | YES | | NULL | |
| LastUpdated | timestamp(14) | YES | | NULL | |
3 rows in set (0.00 sec)

Any help/clues about what is going on is greatly appreciated.

Regards,
Jean-Francois
Sysadmin, iWeb.ca

Jean-Francois Chevrette wrote:

Hi,

our company is massively using RT since a couple of months and we
figured it would be a good idea to clean it up a little bit.

The problem we seem to have is that every ticket information seems to be
stored in the sessions database.

Have a look at http://wiki.bestpractical.com/index.cgi?CleanupSessions

Scott.