‘RT couldn't store your session….’ MySQL Error

For MySQL, RT (Request Tracker) is the ticket-tracking system that coordinates its tasks. It is also responsible for managing requests among several users. RT stores your MySQL session. But if you are getting errors that RT is not able to accomplish the task, a MySQL table might be corrupt that is preventing RT to store the session. You are recommended to check your database backup status as you might need to restore using it. However, in case backup fails to restore, you can repair it using advanced MySQL Repair solutions.

You might receive the below error message while accessing or using MySQL database:

“RT couldn't store your session.  This may mean that that the directory < > isn't writable or a database table is missing or corrupt.”

Cause

The prime cause of such error messages to occur is MySQL table corruption that should be immediately repaired.

Solution

To correct such issues, you should consider following these steps:

• You should first create a new directory to move MySQL database by performing these steps:

mkdir /extra/var

mkdir /extra/var/lib

mv /var/lib/mysql /extra/var/lib/mysql

ln -sn /extra/var/lib/mysql /var/lib/mysql      

• Restart MySQL database using ‘service mysqld restart’ command
• If the same problem continues, you need to repair the corrupted database table:

• Use CHECK TABLE tablename command or mysqlcheck tool to check the table for corruption errors
• If it reports corruption, you can use REPAIR TABLE tablename command or mysqlcheck tool to repair it
• If the above measures fail, you can delete the damaged table if a valid backup exists.
• In case of backup unavailability or invalid state, you should scan and repair your damaged MySQL components using commercial MySQL Recovery applications.

MySQL Repair software are well-built tools that can make safe and complete repair of your damaged MySQL database and its components. Such software are anchored with rich support to advanced features, interactive interface and read-only design. Thus, you can use them for getting safe and easy MySQL Recovery.

Stellar Phoenix Database Recovery For MySQL is a superior quality MySQL Repair tool that supports both InnoDB (.ibdata, .ibd and .frm) and MyISAM (.myd, .myi and .frm) database storage engines. It is an advanced tool to restore all database objects, such as tables, relations, table schemas, primary key(s) etc. It is compatible with Windows Vista, XP, 2003, and 2000 and can also recover databases installed on Linux platform. It supports MySQL 5.x.