[rt-users] Problem with RT3 database

[Jean-Francois Chevrette]

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