System hangs
Posted: Mon Jun 14, 2010 10:40 am
Hi Dave,
Thanks for all your efforts on FreeNATS, I came accross it on a recommendation from an Automated Home article about how to convert a print server into a networked sensor. Very nifty.
Anyway I have the system setup up on my ubuntu server 9.10 running on a VIA Epia cn1000. The hard disks is a Samsung mini drive, so not very good perfromance wise however the whole system has also been running my Squeezebox server without any issues for several months.
Since installing FreeNATS, the system no longer seems to make it through the night. When checking the system itself, all the lights are on but it doesn't respoind at all on any level.
After restarting the system and checking syslog, I can see these:
Jun 14 09:35:57 stargate /etc/mysql/debian-start[1500]: Triggering myisam-recover for all MyISAM tables
Jun 14 09:35:58 stargate mysqld[1338]: 100614 9:35:58 [ERROR] /usr/sbin/mysqld: Table './freenats/fnalert' is marked as crashed and should be repaired
Jun 14 09:35:58 stargate mysqld[1338]: 100614 9:35:58 [Warning] Checking table: './freenats/fnalert'
Jun 14 09:35:58 stargate mysqld[1338]: 100614 9:35:58 [ERROR] /usr/sbin/mysqld: Table './freenats/fnalertlog' is marked as crashed and should be repaired
Jun 14 09:35:58 stargate mysqld[1338]: 100614 9:35:58 [Warning] Checking table: './freenats/fnalertlog'
Jun 14 09:35:58 stargate mysqld[1338]: 100614 9:35:58 [ERROR] /usr/sbin/mysqld: Table './freenats/fneval' is marked as crashed and should be repaired
Jun 14 09:35:58 stargate mysqld[1338]: 100614 9:35:58 [Warning] Checking table: './freenats/fneval'
Jun 14 09:35:58 stargate mysqld[1338]: 100614 9:35:58 [ERROR] /usr/sbin/mysqld: Table './freenats/fngroup' is marked as crashed and should be repaired
Jun 14 09:35:58 stargate mysqld[1338]: 100614 9:35:58 [Warning] Checking table: './freenats/fngroup'
Jun 14 09:35:58 stargate mysqld[1338]: 100614 9:35:58 [ERROR] /usr/sbin/mysqld: Table './freenats/fngrouplink' is marked as crashed and should be repaired
Jun 14 09:35:58 stargate mysqld[1338]: 100614 9:35:58 [Warning] Checking table: './freenats/fngrouplink'
Jun 14 09:35:58 stargate mysqld[1338]: 100614 9:35:58 [ERROR] /usr/sbin/mysqld: Table './freenats/fnlocaltest' is marked as crashed and should be repaired
Jun 14 09:35:58 stargate mysqld[1338]: 100614 9:35:58 [Warning] Checking table: './freenats/fnlocaltest'
Jun 14 09:35:58 stargate mysqld[1338]: 100614 9:35:58 [ERROR] /usr/sbin/mysqld: Table './freenats/fnlog' is marked as crashed and should be repaired
Jun 14 09:35:58 stargate mysqld[1338]: 100614 9:35:58 [Warning] Checking table: './freenats/fnlog'
Jun 14 09:35:58 stargate mysqld[1338]: 100614 9:35:58 [ERROR] /usr/sbin/mysqld: Table './freenats/fnnode' is marked as crashed and should be repaired
Jun 14 09:35:58 stargate mysqld[1338]: 100614 9:35:58 [Warning] Checking table: './freenats/fnnode'
Jun 14 09:35:58 stargate mysqld[1338]: 100614 9:35:58 [ERROR] /usr/sbin/mysqld: Table './freenats/fnnstest' is marked as crashed and should be repaired
Jun 14 09:35:58 stargate mysqld[1338]: 100614 9:35:58 [Warning] Checking table: './freenats/fnnstest'
Jun 14 09:35:59 stargate mysqld[1338]: 100614 9:35:59 [ERROR] /usr/sbin/mysqld: Table './freenats/fnrecord' is marked as crashed and should be repaired
Jun 14 09:35:59 stargate mysqld[1338]: 100614 9:35:59 [Warning] Checking table: './freenats/fnrecord'
Jun 14 09:35:59 stargate mysqld[1338]: 100614 9:35:59 [ERROR] /usr/sbin/mysqld: Table './freenats/fnsession' is marked as crashed and should be repaired
Jun 14 09:35:59 stargate mysqld[1338]: 100614 9:35:59 [Warning] Checking table: './freenats/fnsession'
Jun 14 09:35:59 stargate mysqld[1338]: 100614 9:35:59 [ERROR] /usr/sbin/mysqld: Table './freenats/fntestrun' is marked as crashed and should be repaired
Jun 14 09:35:59 stargate mysqld[1338]: 100614 9:35:59 [Warning] Checking table: './freenats/fntestrun'
Jun 14 09:35:59 stargate mysqld[1338]: 100614 9:35:59 [ERROR] /usr/sbin/mysqld: Table './freenats/fnview' is marked as crashed and should be repaired
Jun 14 09:35:59 stargate mysqld[1338]: 100614 9:35:59 [Warning] Checking table: './freenats/fnview'
Jun 14 09:35:59 stargate mysqld[1338]: 100614 9:35:59 [ERROR] /usr/sbin/mysqld: Table './freenats/fnviewitem' is marked as crashed and should be repaired
Jun 14 09:35:59 stargate mysqld[1338]: 100614 9:35:59 [Warning] Checking table: './freenats/fnviewitem'
Jun 14 09:36:58 stargate kernel: [ 168.736080] Clocksource tsc unstable (delta = -100162645 ns)
Jun 14 09:39:02 stargate CRON[1566]: (root) CMD ( [ -x /usr/lib/php5/maxlifetime ] && [ -d /var/lib/php5 ] && find /var/lib/php5/ -type f -cmin +$(/usr/lib/php5/maxlifetime) -print0 | xargs -n 200 -r -0 rm)
Jun 14 10:00:01 stargate CRON[1716]: (root) CMD (/etc/cron.min/freenats-tester)
Jun 14 10:09:01 stargate CRON[1805]: (root) CMD ( [ -x /usr/lib/php5/maxlifetime ] && [ -d /var/lib/php5 ] && find /var/lib/php5/ -type f -cmin +$(/usr/lib/php5/maxlifetime) -print0 | xargs -n 200 -r -0 rm)
Jun 14 10:17:01 stargate CRON[1823]: (root) CMD ( cd / && run-parts --report /etc/cron.hourly)
Not being very experienced with Linux, I need support in trying to find what is causing the system to hang and what do I need to do to repair the database if anything?
Thanks again for the product, very useful, as I start to dig deeper into what it can do, I will provide some ideas as to how it can be improved further.
Cheers
Gary
Thanks for all your efforts on FreeNATS, I came accross it on a recommendation from an Automated Home article about how to convert a print server into a networked sensor. Very nifty.
Anyway I have the system setup up on my ubuntu server 9.10 running on a VIA Epia cn1000. The hard disks is a Samsung mini drive, so not very good perfromance wise however the whole system has also been running my Squeezebox server without any issues for several months.
Since installing FreeNATS, the system no longer seems to make it through the night. When checking the system itself, all the lights are on but it doesn't respoind at all on any level.
After restarting the system and checking syslog, I can see these:
Jun 14 09:35:57 stargate /etc/mysql/debian-start[1500]: Triggering myisam-recover for all MyISAM tables
Jun 14 09:35:58 stargate mysqld[1338]: 100614 9:35:58 [ERROR] /usr/sbin/mysqld: Table './freenats/fnalert' is marked as crashed and should be repaired
Jun 14 09:35:58 stargate mysqld[1338]: 100614 9:35:58 [Warning] Checking table: './freenats/fnalert'
Jun 14 09:35:58 stargate mysqld[1338]: 100614 9:35:58 [ERROR] /usr/sbin/mysqld: Table './freenats/fnalertlog' is marked as crashed and should be repaired
Jun 14 09:35:58 stargate mysqld[1338]: 100614 9:35:58 [Warning] Checking table: './freenats/fnalertlog'
Jun 14 09:35:58 stargate mysqld[1338]: 100614 9:35:58 [ERROR] /usr/sbin/mysqld: Table './freenats/fneval' is marked as crashed and should be repaired
Jun 14 09:35:58 stargate mysqld[1338]: 100614 9:35:58 [Warning] Checking table: './freenats/fneval'
Jun 14 09:35:58 stargate mysqld[1338]: 100614 9:35:58 [ERROR] /usr/sbin/mysqld: Table './freenats/fngroup' is marked as crashed and should be repaired
Jun 14 09:35:58 stargate mysqld[1338]: 100614 9:35:58 [Warning] Checking table: './freenats/fngroup'
Jun 14 09:35:58 stargate mysqld[1338]: 100614 9:35:58 [ERROR] /usr/sbin/mysqld: Table './freenats/fngrouplink' is marked as crashed and should be repaired
Jun 14 09:35:58 stargate mysqld[1338]: 100614 9:35:58 [Warning] Checking table: './freenats/fngrouplink'
Jun 14 09:35:58 stargate mysqld[1338]: 100614 9:35:58 [ERROR] /usr/sbin/mysqld: Table './freenats/fnlocaltest' is marked as crashed and should be repaired
Jun 14 09:35:58 stargate mysqld[1338]: 100614 9:35:58 [Warning] Checking table: './freenats/fnlocaltest'
Jun 14 09:35:58 stargate mysqld[1338]: 100614 9:35:58 [ERROR] /usr/sbin/mysqld: Table './freenats/fnlog' is marked as crashed and should be repaired
Jun 14 09:35:58 stargate mysqld[1338]: 100614 9:35:58 [Warning] Checking table: './freenats/fnlog'
Jun 14 09:35:58 stargate mysqld[1338]: 100614 9:35:58 [ERROR] /usr/sbin/mysqld: Table './freenats/fnnode' is marked as crashed and should be repaired
Jun 14 09:35:58 stargate mysqld[1338]: 100614 9:35:58 [Warning] Checking table: './freenats/fnnode'
Jun 14 09:35:58 stargate mysqld[1338]: 100614 9:35:58 [ERROR] /usr/sbin/mysqld: Table './freenats/fnnstest' is marked as crashed and should be repaired
Jun 14 09:35:58 stargate mysqld[1338]: 100614 9:35:58 [Warning] Checking table: './freenats/fnnstest'
Jun 14 09:35:59 stargate mysqld[1338]: 100614 9:35:59 [ERROR] /usr/sbin/mysqld: Table './freenats/fnrecord' is marked as crashed and should be repaired
Jun 14 09:35:59 stargate mysqld[1338]: 100614 9:35:59 [Warning] Checking table: './freenats/fnrecord'
Jun 14 09:35:59 stargate mysqld[1338]: 100614 9:35:59 [ERROR] /usr/sbin/mysqld: Table './freenats/fnsession' is marked as crashed and should be repaired
Jun 14 09:35:59 stargate mysqld[1338]: 100614 9:35:59 [Warning] Checking table: './freenats/fnsession'
Jun 14 09:35:59 stargate mysqld[1338]: 100614 9:35:59 [ERROR] /usr/sbin/mysqld: Table './freenats/fntestrun' is marked as crashed and should be repaired
Jun 14 09:35:59 stargate mysqld[1338]: 100614 9:35:59 [Warning] Checking table: './freenats/fntestrun'
Jun 14 09:35:59 stargate mysqld[1338]: 100614 9:35:59 [ERROR] /usr/sbin/mysqld: Table './freenats/fnview' is marked as crashed and should be repaired
Jun 14 09:35:59 stargate mysqld[1338]: 100614 9:35:59 [Warning] Checking table: './freenats/fnview'
Jun 14 09:35:59 stargate mysqld[1338]: 100614 9:35:59 [ERROR] /usr/sbin/mysqld: Table './freenats/fnviewitem' is marked as crashed and should be repaired
Jun 14 09:35:59 stargate mysqld[1338]: 100614 9:35:59 [Warning] Checking table: './freenats/fnviewitem'
Jun 14 09:36:58 stargate kernel: [ 168.736080] Clocksource tsc unstable (delta = -100162645 ns)
Jun 14 09:39:02 stargate CRON[1566]: (root) CMD ( [ -x /usr/lib/php5/maxlifetime ] && [ -d /var/lib/php5 ] && find /var/lib/php5/ -type f -cmin +$(/usr/lib/php5/maxlifetime) -print0 | xargs -n 200 -r -0 rm)
Jun 14 10:00:01 stargate CRON[1716]: (root) CMD (/etc/cron.min/freenats-tester)
Jun 14 10:09:01 stargate CRON[1805]: (root) CMD ( [ -x /usr/lib/php5/maxlifetime ] && [ -d /var/lib/php5 ] && find /var/lib/php5/ -type f -cmin +$(/usr/lib/php5/maxlifetime) -print0 | xargs -n 200 -r -0 rm)
Jun 14 10:17:01 stargate CRON[1823]: (root) CMD ( cd / && run-parts --report /etc/cron.hourly)
Not being very experienced with Linux, I need support in trying to find what is causing the system to hang and what do I need to do to repair the database if anything?
Thanks again for the product, very useful, as I start to dig deeper into what it can do, I will provide some ideas as to how it can be improved further.
Cheers
Gary