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 <terrapi...@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 <terrapi...@yahoo.com> > To: Jared Camins-Esakov <jcam...@cpbibliography.com> > Cc: "koha@lists.katipo.co.nz" <koha@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 <jcam...@cpbibliography.com> > To: ed c <terrapi...@yahoo.com> > Cc: "koha@lists.katipo.co.nz" <koha@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 <terrapi...@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@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) jcam...@cpbibliography.com > (web) http://www.cpbibliography.com/ > > > > > _______________________________________________ > Koha mailing list http://koha-community.org > Koha@lists.katipo.co.nz > http://lists.katipo.co.nz/mailman/listinfo/koha > >
_______________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
