hi guys,
my database server for vbb recently crashed and i got the following problems... from the mysql log
I took snippets of the log, the rest were repeated. i did a search on this forum and found some links to repair but to no avail.. mainly because my /tmp is only 1GB and my biggest table is about 900MB (postindex, word etc)
While we have restored to our last known best backup, i fear to see this happen again, especially when..
1) We don't know what caused it. MYSQL just couldn't work that fateful morning (server was still working fine, just the service)
2) We can't fix it...
I also come across a fixoptions.php posted on this forum, but it didnt work.. i suppose its because we are still running 3.0.3?
We didn't backup as our forums are pretty huge, and since its working (till now) - we have no intention to fix it
and now that we uploaded it, one big problem we faced are our avatars.. its all distorted!
any idea?
my database server for vbb recently crashed and i got the following problems... from the mysql log
060212 5:25:20 [ERROR] /usr/sbin/mysqld: Disk is full writing '/tmp/STmGlP0P' (Errcode: 28). Waiting for someone to free space... Retry in 60 secs
060212 15:04:06 [Note] /usr/sbin/mysqld: Normal shutdown
060212 15:04:07 [ERROR] /usr/sbin/mysqld: Forcing close of thread 20469029 user: 'root'
060212 15:04:22 [Warning] Warning: Optimize table got errno 28, retrying
060212 15:04:24 [Note] /usr/sbin/mysqld: Shutdown complete
060212 15:04:24 mysqld ended
060212 15:07:30 mysqld started
/usr/sbin/mysqld: ready for connections.
Version: '4.1.12-standard' socket: '/var/lib/mysql/mysql.sock' port: 3306 MySQL Community Edition - Standard (GPL)
060212 16:28:13 [ERROR] /usr/sbin/mysqld: Can't open file: 'postindex.MYI' (errno: 144)
060212 15:04:06 [Note] /usr/sbin/mysqld: Normal shutdown
060212 15:04:07 [ERROR] /usr/sbin/mysqld: Forcing close of thread 20469029 user: 'root'
060212 15:04:22 [Warning] Warning: Optimize table got errno 28, retrying
060212 15:04:24 [Note] /usr/sbin/mysqld: Shutdown complete
060212 15:04:24 mysqld ended
060212 15:07:30 mysqld started
/usr/sbin/mysqld: ready for connections.
Version: '4.1.12-standard' socket: '/var/lib/mysql/mysql.sock' port: 3306 MySQL Community Edition - Standard (GPL)
060212 16:28:13 [ERROR] /usr/sbin/mysqld: Can't open file: 'postindex.MYI' (errno: 144)
I took snippets of the log, the rest were repeated. i did a search on this forum and found some links to repair but to no avail.. mainly because my /tmp is only 1GB and my biggest table is about 900MB (postindex, word etc)
While we have restored to our last known best backup, i fear to see this happen again, especially when..
1) We don't know what caused it. MYSQL just couldn't work that fateful morning (server was still working fine, just the service)
2) We can't fix it...
I also come across a fixoptions.php posted on this forum, but it didnt work.. i suppose its because we are still running 3.0.3?
We didn't backup as our forums are pretty huge, and since its working (till now) - we have no intention to fix it
and now that we uploaded it, one big problem we faced are our avatars.. its all distorted!
any idea?
Comment