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
myisamchk -r -q tbl_name
Hope this helps.
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
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
caused by: java.lang.RuntimeException: SqlService.dbWrite failure
caused by: java.sql.SQLException: The table 'SAKAI_SESSION' is full
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|
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.
UNIVERSITY OF CAPE TOWN
sakai-user mailing list
TO UNSUBSCRIBE: send email to [hidden email] with a subject of "unsubscribe"
|Free forum by Nabble||Edit this page|