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

classic Classic list List threaded Threaded
1 message Options
Biku Shrestha Biku Shrestha
Reply | Threaded
Open this post in threaded view
|

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

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: [hidden email] [[hidden email]] On Behalf Of Stephen Marquard
Sent: Tuesday, April 28, 2015 6:37 AM
To: Ismail Naik; [hidden email]
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
[hidden email]
Phone: +27-21-650-5037 Cell: +27-83-500-5290

 

From: [hidden email] [[hidden email]] On Behalf Of Ismail Naik
Sent: 28 April 2015 01:29 PM
To: [hidden email]
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

[hidden email]

 

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 [hidden email].
For further assistance email us at [hidden email].

--
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 [hidden email].
To post to this group, send email to [hidden email].
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 [hidden email].
To post to this group, send email to [hidden email].
Visit this group at http://groups.google.com/a/apereo.org/group/sakai-dev/.


_______________________________________________
sakai-user mailing list
[hidden email]
http://collab.sakaiproject.org/mailman/listinfo/sakai-user

TO UNSUBSCRIBE: send email to [hidden email] with a subject of "unsubscribe"