[Building Sakai] sakai mysql db down

[Steve Swinsburg]

Hi,

Do you have any logs for what happened? When you say 'because of
sakai_preferences table corruption' - what do you mean?

cheers,
Steve


On Tue, Dec 17, 2013 at 5:05 AM, Sanghyun Jeon <euksa99 at gmail.com> wrote:

> 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
>
> _______________________________________________
> sakai-dev mailing list
> sakai-dev at collab.sakaiproject.org
> http://collab.sakaiproject.org/mailman/listinfo/sakai-dev
>
> TO UNSUBSCRIBE: send email to
> sakai-dev-unsubscribe at collab.sakaiproject.org with a subject of
> "unsubscribe"
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://collab.sakaiproject.org/pipermail/sakai-dev/attachments/20131217/196420fe/attachment.html