<html><head></head><body bgcolor="#FFFFFF"><div>A little late of an update, but for the archives, dropping and then recreating the table fixed the problem. </div><div><br></div><div>Edward<br><br>--<div>Edward M. Corrado</div></div><div><br>On Jan 13, 2012, at 12:52, ed c <<a href="mailto:terrapin44@yahoo.com">terrapin44@yahoo.com</a>> wrote:<br><br></div><div></div><blockquote type="cite"><div><div style="color:#000; background-color:#fff; font-family:times new roman, new york, times, serif;font-size:12pt"><div><span>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.<br></span></div><div><br><span></span></div><div><span>Edward</span></div><div><br></div> <div style="font-family: times new roman, new york, times, serif; font-size: 12pt;"> <div style="font-family: times new roman, new york, times, serif; font-size: 12pt;"> <div dir="ltr"> <font face="Arial" size="2"> <hr size="1"> <b><span style="font-weight:bold;">From:</span></b> ed c <<a href="mailto:terrapin44@yahoo.com">terrapin44@yahoo.com</a>><br> <b><span style="font-weight: bold;">To:</span></b> Jared Camins-Esakov <<a href="mailto:jcamins@cpbibliography.com">jcamins@cpbibliography.com</a>> <br><b><span style="font-weight: bold;">Cc:</span></b> "<a href="mailto:koha@lists.katipo.co.nz">koha@lists.katipo.co.nz</a>" <<a href="mailto:koha@lists.katipo.co.nz">koha@lists.katipo.co.nz</a>> <br> <b><span style="font-weight:
bold;">Sent:</span></b> Friday, January 13, 2012 1:16 PM<br> <b><span style="font-weight: bold;">Subject:</span></b> Re: [Koha] Sessions table corrupt in Koha 3.0<br> </font> </div> <br>
<meta http-equiv="x-dns-prefetch-control" content="off"><div id="yiv1882163155"><div><div style="color:#000;background-color:#fff;font-family:times new roman, new york, times, serif;font-size:12pt;"><div><span>Thanks Jared. This is probably my solution, however, I can't seem to drop this table.</span></div><div><br><span></span></div><div><span>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:</span></div><div><br><span></span></div><div><span><br></span></div><div>mysql> show processlist;<br>+----+-----------+-----------+------+---------+------+-------------------+---------------------+<br>| Id | User | Host | db | Command | Time | State |
Info
|<br>+----+-----------+-----------+------+---------+------+-------------------+---------------------+<br>| 7 | kohaadmin | localhost | koha | Query | 31 | Waiting for table | drop table sessions | <br>| 8 | kohaadmin | localhost | koha | Query | 0 | NULL | show processlist | <br>+----+-----------+-----------+------+---------+------+-------------------+---------------------+<br>2 rows in set (0.00 sec)<br><br>mysql> <br></div><div><br></div><div>IS there a way to "force the drop" or unlock the table? I am having no luck searching google.</div><div><br></div><div>Edward<br><span></span></div><div><span><br></span></div><div><br><span></span></div><div><span></span></div><div><br></div> <div style="font-family:times new roman, new york, times, serif;font-size:12pt;"> <div style="font-family:times new roman, new york, times, serif;font-size:12pt;"> <div dir="ltr"> <font face="Arial" size="2"> <hr size="1"> <b><span style="font-weight:bold;">From:</span></b> Jared Camins-Esakov <<a href="mailto:jcamins@cpbibliography.com">jcamins@cpbibliography.com</a>><br> <b><span style="font-weight:bold;">To:</span></b> ed c <<a href="mailto:terrapin44@yahoo.com">terrapin44@yahoo.com</a>> <br><b><span style="font-weight:bold;">Cc:</span></b> "<a href="mailto:koha@lists.katipo.co.nz">koha@lists.katipo.co.nz</a>" <<a href="mailto:koha@lists.katipo.co.nz">koha@lists.katipo.co.nz</a>> <br> <b><span style="font-weight:bold;">Sent:</span></b> Friday, January 13, 2012 12:01 PM<br> <b><span style="font-weight:bold;">Subject:</span></b> Re: [Koha] Sessions table corrupt in Koha 3.0<br> </font> </div> <br>
<div id="yiv1882163155">Edward,<div><br></div><div>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.</div><div><br></div><div>Regards,</div><div>Jared<br>
<div><br><div class="yiv1882163155gmail_quote">2012/1/13 ed c <span dir="ltr"><<a rel="nofollow" ymailto="mailto:terrapin44@yahoo.com" target="_blank" href="mailto:terrapin44@yahoo.com">terrapin44@yahoo.com</a>></span><br><blockquote class="yiv1882163155gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex;">
<div><div style="font-size:12pt;font-family:times new roman, new york, times, serif;"><div>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?</div>
<div><br></div><div>Thanks,<br></div><div><br></div><div>Edward<br></div></div></div><br>_______________________________________________<br>
Koha mailing list <a href="http://koha-community.org">http://koha-community.org</a><br>
<a rel="nofollow" ymailto="mailto:Koha@lists.katipo.co.nz" target="_blank" href="mailto:Koha@lists.katipo.co.nz">Koha@lists.katipo.co.nz</a><br>
<a href="http://lists.katipo.co.nz/mailman/listinfo/koha">http://lists.katipo.co.nz/mailman/listinfo/koha</a><br>
<br></blockquote></div><br><br clear="all"><div><br></div>-- <br>Jared Camins-Esakov<div>Bibliographer, C & P Bibliography Services, LLC</div><div>(phone) +1 (917) 727-3445</div><div>(e-mail) <a rel="nofollow" ymailto="mailto:jcamins@cpbibliography.com" target="_blank" href="mailto:jcamins@cpbibliography.com">jcamins@cpbibliography.com</a></div>
<div>(web) <a href="http://www.cpbibliography.com/">http://www.cpbibliography.com/</a></div><br>
</div></div>
</div><br><br> </div> </div> </div></div></div><meta http-equiv="x-dns-prefetch-control" content="on"><br>_______________________________________________<br>Koha mailing list <a href="http://koha-community.org" target="_blank">http://koha-community.org</a><br><a ymailto="mailto:Koha@lists.katipo.co.nz" href="mailto:Koha@lists.katipo.co.nz">Koha@lists.katipo.co.nz</a><br><a href="http://lists.katipo.co.nz/mailman/listinfo/koha" target="_blank">http://lists.katipo.co.nz/mailman/listinfo/koha</a><br><br><br> </div> </div> </div></div></blockquote></body></html>