[Koha] Sessions table corrupt in Koha 3.0

[Wagner, Jane]

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

jwagner at liblime.com <jwagner at ptfs.com>



*From:* koha-bounces at lists.katipo.co.nz [mailto:
koha-bounces at lists.katipo.co.nz] *On Behalf Of *ed c
*Sent:* Friday, January 13, 2012 11:57 AM
*To:* koha at 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
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.katipo.co.nz/pipermail/koha/attachments/20120113/05a9df82/attachment-0001.html>