[Koha] Sessions table corrupt in Koha 3.0

[Edward M Corrado]

A little late of an update, but for the archives, dropping and then recreating the table fixed the problem. 

Edward

--
Edward M. Corrado

On Jan 13, 2012, at 12:52, ed c <terrapin44 at yahoo.com> wrote:

> Okay, I got this part fixed. I managed to drop the table by starting mysql using mysqld_safe. Still need to create the table though, hopefully that will work.
> 
> Edward
> 
> From: ed c <terrapin44 at yahoo.com>
> To: Jared Camins-Esakov <jcamins at cpbibliography.com> 
> Cc: "koha at lists.katipo.co.nz" <koha at lists.katipo.co.nz> 
> Sent: Friday, January 13, 2012 1:16 PM
> Subject: Re: [Koha] Sessions table corrupt in Koha 3.0
> 
> Thanks Jared. This is probably my solution, however, I can't seem to drop this table.
> 
> This is probably a basic mysql question, but how can I force a drop or remove a lock? When I try to drop the table, it just sits there waiting for the table:
> 
> 
> mysql> show processlist;
> +----+-----------+-----------+------+---------+------+-------------------+---------------------+
> | Id | User      | Host      | db   | Command | Time | State             | Info                |
> +----+-----------+-----------+------+---------+------+-------------------+---------------------+
> |  7 | kohaadmin | localhost | koha | Query   |   31 | Waiting for table | drop table sessions | 
> |  8 | kohaadmin | localhost | koha | Query   |    0 | NULL              | show processlist    | 
> +----+-----------+-----------+------+---------+------+-------------------+---------------------+
> 2 rows in set (0.00 sec)
> 
> mysql> 
> 
> IS there a way to "force the drop" or unlock the table? I am having no luck searching google.
> 
> Edward
> 
> 
> 
> From: Jared Camins-Esakov <jcamins at cpbibliography.com>
> To: ed c <terrapin44 at yahoo.com> 
> Cc: "koha at lists.katipo.co.nz" <koha at lists.katipo.co.nz> 
> Sent: Friday, January 13, 2012 12:01 PM
> Subject: Re: [Koha] Sessions table corrupt in Koha 3.0
> 
> Edward,
> 
> Drop the table then recreate it. Your users will have to log in again, but that's it. I'm not sure that will reclaim the disk space, though.
> 
> Regards,
> Jared
> 
> 2012/1/13 ed c <terrapin44 at yahoo.com>
> 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
> 
> _______________________________________________
> Koha mailing list  http://koha-community.org
> Koha at lists.katipo.co.nz
> http://lists.katipo.co.nz/mailman/listinfo/koha
> 
> 
> 
> 
> -- 
> Jared Camins-Esakov
> Bibliographer, C & P Bibliography Services, LLC
> (phone) +1 (917) 727-3445
> (e-mail) jcamins at cpbibliography.com
> (web) http://www.cpbibliography.com/
> 
> 
> 
> 
> _______________________________________________
> Koha mailing list  http://koha-community.org
> Koha at lists.katipo.co.nz
> http://lists.katipo.co.nz/mailman/listinfo/koha
> 
> 
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.katipo.co.nz/pipermail/koha/attachments/20120113/d28fbae2/attachment.html>