[Building Sakai] sakai mysql db down

[Sanghyun Jeon]

Hello all,

We have a system crash last week because of sakai_preferences table
corruption and we recovered the table successfully but the sakai db shut
down again this morning without reason.

Version: '5.1.69-log'  socket: '/var/lib/mysql/mysql.sock'  port: 3306
 Source distribution
131216  8:42:56 [Note] /usr/libexec/mysqld: Normal shutdown

131216  8:42:56 [Note] Event Scheduler: Purging the queue. 0 events
131216  8:42:59  InnoDB: Starting shutdown...
131216  8:43:23  InnoDB: Shutdown completed; log sequence number 12
4183647936
131216  8:43:23 [Note] /usr/libexec/mysqld: Shutdown complete

131216 08:43:23 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid
ended
131216 08:55:17 mysqld_safe Starting mysqld daemon with databases from
/opt/mysql
131216  8:55:17  InnoDB: Initializing buffer pool, size = 5.9G
131216  8:55:18  InnoDB: Completed initialization of buffer pool
131216  8:55:18  InnoDB: Started; log sequence number 12 4183647936
InnoDB: !!! innodb_force_recovery is set to 4 !!!


We are using Sakai 2.8.x and Tomcat 6 and mysql 5.1.69
I am wondering whether any other school is having the similar problem? I am
also wondering anybody can shed some light on how I can prevent this and we
are currently at final exam period.  Any suggestion or advice will be
greatly appreciated.

S
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://collab.sakaiproject.org/pipermail/sakai-dev/attachments/20131216/05d82e0c/attachment.html