Koozali.org: home of the SME Server
Obsolete Releases => SME Server 8.x => Topic started by: nicolatiana on October 08, 2013, 04:43:41 PM
-
Hi
After a power failure, during subsequent reboot the Sme 8 is freezed (at the present time 7 hours) at FIX_PRIVILEGE_TABLES_INTO_MYSQL.
High disk activity (hdd led is fixed); for a while I've been able to ssh into the server and htop gave 35/40 of system load.
At this moment I can ssh but after password input I can't get the prompt.
I'll give more information (kernel, interesting log records, ecc) when I'll be able to manage the server. The hardware is a Proliant ML110 G6 with 4 gb ram and Kernel PAE, raid 1 with spare over 1 Tb hdd.
Bye
Nicola
-
Now the system is responsive, a bit slow due to raid rebuild but usable. Addendum the system is a 7.51 upgraded to 8 at the beginning of 2013
At first I've done a Mysql check; this is the result:
[root@bagetto log]# mysqlcheck -c -A
horde.horde_alarms
error : Table upgrade required. Please do "REPAIR TABLE `horde_alarms`" to fix it!
horde.horde_cache
error : Table upgrade required. Please do "REPAIR TABLE `horde_cache`" to fix it!
horde.horde_datatree OK
horde.horde_datatree_attributes OK
horde.horde_datatree_seq
error : Table upgrade required. Please do "REPAIR TABLE `horde_datatree_seq`" to fix it!
horde.horde_groups
error : Table upgrade required. Please do "REPAIR TABLE `horde_groups`" to fix it!
horde.horde_groups_members
error : Table upgrade required. Please do "REPAIR TABLE `horde_groups_members`" to fix it!
horde.horde_histories OK
horde.horde_histories_seq
error : Table upgrade required. Please do "REPAIR TABLE `horde_histories_seq`" to fix it!
horde.horde_locks OK
horde.horde_perms
error : Table upgrade required. Please do "REPAIR TABLE `horde_perms`" to fix it!
horde.horde_prefs OK
horde.horde_sessionhandler OK
horde.horde_signups
error : Table upgrade required. Please do "REPAIR TABLE `horde_signups`" to fix it!
horde.horde_syncml_anchors
error : Table upgrade required. Please do "REPAIR TABLE `horde_syncml_anchors`" to fix it!
horde.horde_syncml_map
error : Table upgrade required. Please do "REPAIR TABLE `horde_syncml_map`" to fix it!
horde.horde_tokens OK
horde.horde_users
error : Table upgrade required. Please do "REPAIR TABLE `horde_users`" to fix it!
horde.horde_vfs OK
horde.imp_sentmail
error : Table upgrade required. Please do "REPAIR TABLE `imp_sentmail`" to fix it!
horde.ingo_forwards
error : Table upgrade required. Please do "REPAIR TABLE `ingo_forwards`" to fix it!
horde.ingo_lists
error : Table upgrade required. Please do "REPAIR TABLE `ingo_lists`" to fix it!
horde.ingo_rules
error : Table upgrade required. Please do "REPAIR TABLE `ingo_rules`" to fix it!
horde.ingo_shares OK
horde.ingo_shares_groups OK
horde.ingo_shares_users
error : Table upgrade required. Please do "REPAIR TABLE `ingo_shares_users`" to fix it!
horde.ingo_spam
error : Table upgrade required. Please do "REPAIR TABLE `ingo_spam`" to fix it!
horde.ingo_vacations
error : Table upgrade required. Please do "REPAIR TABLE `ingo_vacations`" to fix it!
horde.kronolith_events
error : Table upgrade required. Please do "REPAIR TABLE `kronolith_events`" to fix it!
horde.kronolith_shares OK
horde.kronolith_shares_groups OK
horde.kronolith_shares_users OK
horde.kronolith_storage
error : Table upgrade required. Please do "REPAIR TABLE `kronolith_storage`" to fix it!
horde.mnemo_memos OK
horde.mnemo_shares
error : Table upgrade required. Please do "REPAIR TABLE `mnemo_shares`" to fix it!
horde.mnemo_shares_groups OK
horde.mnemo_shares_users
error : Table upgrade required. Please do "REPAIR TABLE `mnemo_shares_users`" to fix it!
horde.nag_shares OK
horde.nag_shares_groups OK
horde.nag_shares_users OK
horde.nag_tasks
error : Table upgrade required. Please do "REPAIR TABLE `nag_tasks`" to fix it!
horde.turba_objects
error : Table upgrade required. Please do "REPAIR TABLE `turba_objects`" to fix it!
horde.turba_shares OK
horde.turba_shares_groups OK
horde.turba_shares_users OK
mysql.columns_priv OK
mysql.db OK
mysql.func OK
mysql.help_category
error : Table upgrade required. Please do "REPAIR TABLE `help_category`" to fix it!
mysql.help_keyword
error : Table upgrade required. Please do "REPAIR TABLE `help_keyword`" to fix it!
mysql.help_relation
error : Table upgrade required. Please do "REPAIR TABLE `help_relation`" to fix it!
mysql.help_topic
error : Table upgrade required. Please do "REPAIR TABLE `help_topic`" to fix it!
mysql.host OK
mysql.proc OK
mysql.procs_priv OK
mysql.tables_priv OK
mysql.time_zone
error : Table upgrade required. Please do "REPAIR TABLE `time_zone`" to fix it!
mysql.time_zone_leap_second
error : Table upgrade required. Please do "REPAIR TABLE `time_zone_leap_second`" to fix it!
mysql.time_zone_name
error : Table upgrade required. Please do "REPAIR TABLE `time_zone_name`" to fix it!
mysql.time_zone_transition
error : Table upgrade required. Please do "REPAIR TABLE `time_zone_transition`" to fix it!
mysql.time_zone_transition_type
error : Table upgrade required. Please do "REPAIR TABLE `time_zone_transition_type`" to fix it!
mysql.user OK
sme7admin.afp
error : Table upgrade required. Please do "REPAIR TABLE `afp`" to fix it!
sme7admin.dhcpd
error : Table upgrade required. Please do "REPAIR TABLE `dhcpd`" to fix it!
sme7admin.ftp
error : Table upgrade required. Please do "REPAIR TABLE `ftp`" to fix it!
sme7admin.pppoe
error : Table upgrade required. Please do "REPAIR TABLE `pppoe`" to fix it!
sme7admin.samba
error : Table upgrade required. Please do "REPAIR TABLE `samba`" to fix it!
sme7admin.ssh
error : Table upgrade required. Please do "REPAIR TABLE `ssh`" to fix it!
sme7admin.vpn
error : Table upgrade required. Please do "REPAIR TABLE `vpn`" to fix it!
sme8admin.afp OK
sme8admin.dhcpd OK
sme8admin.ftp OK
sme8admin.pppoe OK
sme8admin.samba
warning : 3 clients are using or haven't closed the table properly
status : OK
sme8admin.ssh
warning : 2 clients are using or haven't closed the table properly
status : OK
sme8admin.vpn OK
sogo.sogo_folder_info OK
sogo.sogo_sessions_folder OK
sogo.sogo_user_profile OK
sogo.sogoadmin001249feac4 OK
sogo.sogoadmin001249feac4_acl OK
sogo.sogoadmin001249feac4_quick OK
sogo.sogoadmin0014ca009b1 OK
sogo.sogoadmin0014ca009b1_acl OK
sogo.sogoadmin0014ca009b1_quick OK
sogo.sogomarco00147b1d2a8
warning : 2 clients are using or haven't closed the table properly
status : OK
sogo.sogomarco00147b1d2a8_acl OK
sogo.sogomarco00147b1d2a8_quick
warning : 2 clients are using or haven't closed the table properly
status : OK
sogo.sogomarco0022757248a
warning : 1 client is using or hasn't closed the table properly
status : OK
sogo.sogomarco0022757248a_acl OK
sogo.sogomarco0022757248a_quick
warning : 1 client is using or hasn't closed the table properly
status : OK
sogo.sogostudio001498a0049 OK
sogo.sogostudio001498a0049_acl OK
sogo.sogostudio001498a0049_quick OK
sogo.sogostudio005415884fb OK
sogo.sogostudio005415884fb_acl OK
sogo.sogostudio005415884fb_quick OK
sogo.sogotnemail003789a7675 OK
sogo.sogotnemail003789a7675_acl OK
sogo.sogotnemail003789a7675_quick OK
sogo.sogotnemail0047d72b91c OK
sogo.sogotnemail0047d72b91c_acl OK
sogo.sogotnemail0047d72b91c_quick OK
squid_log.access_log
warning : 4 clients are using or haven't closed the table properly
status : OK
squid_log.deny_log OK
I'll wait before doing a
mysqlcheck --all-databases --auto-repair
Many errors concern Horde (and related contribs); I uninstalled Horde contribs before 7.51---> 8.00 upgrade according to wiki directions for each contrib.
Maybe tables error are causing the issue ?
Nicola
-
nicolatiana
After a power failure....
What, no UPS configured to shutdown gracefully ?
The cost of your tech support time is already greater than the cost of a UPS (or a new battery).
-
The server was moved from a room to another, some mistake was made reconnecting power cables and the power failure occurred very few hours later before my routine log checks.
I realized it by log files and by phone but the accident had already occurred . . . . :(
Happily no data loss and the server now is once again connected to its Apc BackUps 650.
Any idea if Mysql issue is concerned to the reboot issue ?
Nicola