The sessions table tracks logins to the system, and can drastically slow your system down if it gets too large. You can safely truncate it entirely; doing so will disconnect anyone presently logged in but it sounds like you can’t log in at the moment anyway. There is a script (misc/cronjobs/cleanup_database.pl) which has an option to clear the table overnight as a cron job, to keep it from getting too big.
Jane Wagner
Senior Project Manager
LibLime, a division of PTFS
Content Management and Library Solutions
11501 Huff Court
North Bethesda, MD 20895
(301) 654-8088 x 151
From: koha-bounces@lists.katipo.co.nz [mailto:koha-bounces@lists.katipo.co.nz] On Behalf Of ed c
Sent: Friday, January 13, 2012 11:57 AM
To: koha@lists.katipo.co.nz
Subject: [Koha] Sessions table corrupt in Koha 3.0
I am trying to work on a small, older Koha (3.0.2)install that is not longer working. Koha is having issues connecting to the database after a problem with diskspace. While checking the Mysql and log files, I've come across with a problem with the "sessions" table in Koha. a CHECK TABLES on it or a REPAIR just hangs forever. They have backups so I should be able to restore the whole database (or possibly just this table) but before I do, does anyone have any other alternative solutions? What does this table do?
Thanks,
Edward