[Using Sakai] [sakai-dev] Running out of table space

[Biku Shrestha]

Hi Ismail,

We experienced similar issue last year (DBWrite error and students were unable to login).

We fixed it as follows:


1.       Run mysqldump:

mysqldump -u root -p sakai > /opt/dbbackup/sakaibackup.sql (target location)

This will list all the tables that are corrupt.



2.       Run myisamchk as follows (for each corrupt table):

myisamchk -r  tbl_name



or



myisamchk -r  -q tbl_name

Hope this helps.

Thank you.

Biku

From: sakai-dev at apereo.org<mailto:sakai-dev at apereo.org> [mailto:sakai-dev at apereo.org] On Behalf Of Stephen Marquard
Sent: Tuesday, April 28, 2015 6:37 AM
To: Ismail Naik; sakai-dev at apereo.org<mailto:sakai-dev at apereo.org>
Subject: RE: [sakai-dev] Running out of table space

If you are not concerned about retaining old session information, then you can run:

delete from SAKAI_SESSION WHERE SESSION_ACTIVE IS NULL;

But this is an unusual error, so you may have some other issue like running out of disk space on the mysql server. See https://dev.mysql.com/doc/refman/5.5/en/table-size-limit.html

Regards
Stephen

---
Stephen Marquard, Learning Technologies Co-ordinator,
Centre for Innovation in Learning and Teaching (CILT)
University of Cape Town
http://www.cilt.uct.ac.za
stephen.marquard at uct.ac.za<mailto:stephen.marquard at uct.ac.za>
Phone: +27-21-650-5037 Cell: +27-83-500-5290

From: sakai-dev at apereo.org<mailto:sakai-dev at apereo.org> [mailto:sakai-dev at apereo.org] On Behalf Of Ismail Naik
Sent: 28 April 2015 01:29 PM
To: sakai-dev at apereo.org<mailto:sakai-dev at apereo.org>
Subject: [sakai-dev] Running out of table space

Greetings Team,

We are sakai 2.9.3, and database mysql 5.9 and now we are getting exception sqldb write error and users unable login.

org.sakaiproject.portal.api.PortalHandlerException: java.lang.RuntimeException: SqlService.dbWrite failure
    at org.sakaiproject.portal.charon.handlers.ReLoginHandler.doPost(ReLoginHandler.java:50)
caused by: java.lang.RuntimeException: SqlService.dbWrite failure
    at org.sakaiproject.db.impl.BasicSqlService.dbWrite(BasicSqlService.java:1143)
caused by: java.sql.SQLException: The table 'SAKAI_SESSION' is full
    at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1084)
    at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4232)
    at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4164)

Similar way we are getting some more table says there are full.

Kindly guide us to handle/fix  this at either database level or in sakai.propertis.



Thanks & Regards
Ismail N. - IT Department
Xm Software Solutions Pvt Ltd | SKCL | CENTRAL SQUARE- 1
CIPET Road | Thiru-Vi-Ka  Industrial  Estate| Guindy | Chennai- 600032.
TEL: 044-30464899 | FAX: 044-30464861|
Ext:613
ismail.n at in.uaeexchange.com<mailto:ismail.n at in.uaeexchange.com>



Disclaimer: This communication is intended solely for the use of the individual or entity to whom it is addressed and others authorized to receive it. It may contain confidential or legally privileged information. If you are not the intended recipient, you are hereby notified that any disclosure, copying, distribution, or action taken in reliance upon the information is strictly prohibited and is unlawful. If you have received this communication by error, please notify us immediately by responding to this email before deleting it from your system. UAE Exchange cannot be held responsible for the improper or incomplete transmission of information contained in this communication, or for any delay in its receipt.
Warning: Internet communication cannot be guaranteed to be timely, secure, error-free or virus-free. It is the responsibility of the recipient to ensure that this email and its attachments, if any, are free from viruses. UAE Exchange doesn't accept liability for any damage that may result from viruses transmitted through this email.
Please be informed that as per UAE Exchange Information Security policy, we will never request you to disclose your Account Number, Credit Card Information, User ID, Personal Identification Number (PIN), Telephone Identification Number (TIN), Password or any such information through e-mails or phone.
Any e-mail or written communication received by you, which appears to have been sent from UAE Exchange seeking your personal & confidential information, should not be answered but advised to UAE Exchange at info.sec at uaeexchange.com<mailto:info.sec at uaeexchange.com>.
For further assistance email us at info.sec at uaeexchange.com<mailto:info.sec at uaeexchange.com>.
--
You received this message because you are subscribed to the Google Groups "Sakai Development" group.
To unsubscribe from this group and stop receiving emails from it, send an email to sakai-dev+unsubscribe at apereo.org<mailto:sakai-dev+unsubscribe at apereo.org>.
To post to this group, send email to sakai-dev at apereo.org<mailto:sakai-dev at apereo.org>.
Visit this group at http://groups.google.com/a/apereo.org/group/sakai-dev/.
________________________________
UNIVERSITY OF CAPE TOWN

This e-mail is subject to the UCT ICT policies and e-mail disclaimer published on our website at http://www.uct.ac.za/about/policies/emaildisclaimer/ or obtainable from +27 21 650 9111. This e-mail is intended only for the person(s) to whom it is addressed. If the e-mail has reached you in error, please notify the author. If you are not the intended recipient of the e-mail you may not use, disclose, copy, redirect or print the content. If this e-mail is not related to the business of UCT it is sent by the sender in the sender's individual capacity.
--
You received this message because you are subscribed to the Google Groups "Sakai Development" group.
To unsubscribe from this group and stop receiving emails from it, send an email to sakai-dev+unsubscribe at apereo.org<mailto:sakai-dev+unsubscribe at apereo.org>.
To post to this group, send email to sakai-dev at apereo.org<mailto:sakai-dev at apereo.org>.
Visit this group at http://groups.google.com/a/apereo.org/group/sakai-dev/.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://collab.sakaiproject.org/pipermail/sakai-user/attachments/20150428/105d146f/attachment-0001.html 
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image002.gif
Type: image/gif
Size: 7912 bytes
Desc: image002.gif
Url : http://collab.sakaiproject.org/pipermail/sakai-user/attachments/20150428/105d146f/attachment-0001.gif