Topic: Mysql freeze system on boot - FIX_PRIVILEGE_TABLES_INTO_MYSQL

[nicolatiana]

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

[nicolatiana]

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

[janet]

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).

[nicolatiana]

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