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 <[email protected]>
To: Jared Camins-Esakov <[email protected]>
Cc: "[email protected]" <[email protected]>
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 <[email protected]>
To: ed c <[email protected]>
Cc: "[email protected]" <[email protected]>
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 <[email protected]>
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
>[email protected]
>http://lists.katipo.co.nz/mailman/listinfo/koha
>
>
--
Jared Camins-Esakov
Bibliographer, C & P Bibliography Services, LLC
(phone) +1 (917) 727-3445
(e-mail) [email protected]
(web) http://www.cpbibliography.com/
_______________________________________________
Koha mailing list http://koha-community.org
[email protected]
http://lists.katipo.co.nz/mailman/listinfo/koha
_______________________________________________
Koha mailing list http://koha-community.org
[email protected]
http://lists.katipo.co.nz/mailman/listinfo/koha
