[debian-mysql] Bug#479697: mysql-server-5.0: corrupt table check reports wrong info

[Hristo Hristov]

Hello,

I have the same problem. It is very annoying. I found that this e-mail
is generated in /usr/share/mysql/debian-start.inc.sh. On line 19 the
executed command is:
LC_ALL=C /usr/bin/mysql --defaults-file=/etc/mysql/debian.cnf -N -b -e
'select concat("select count(*) from ",TABLE_SCHEMA, ".", TABLE_NAME)
from information_schema.TABLES where ENGINE="MyISAM"'

which produces this result:
+-------------------------------------------------------------------------+
|                         select count(*) from information_schema.COLUMNS | 
|                        select count(*) from information_schema.ROUTINES | 
|                        select count(*) from information_schema.TRIGGERS | 
|                           select count(*) from information_schema.VIEWS | 
|                           select count(*) from evoucher.evoucher_alarms | 
|                  select count(*) from evoucher.evoucher_application_log | 
|                           select count(*) from evoucher.evoucher_config | 
|           select count(*) from evoucher.evoucher_daily_reports_by_agent | 
|     select count(*) from evoucher.evoucher_daily_reports_by_distributor | 
|                select count(*) from evoucher.evoucher_extention_periods | 
|          select count(*) from evoucher.evoucher_promotions_distributors | 
|                 select count(*) from evoucher.evoucher_promotions_rules | 
|             select count(*) from evoucher.evoucher_provisioning_history | 
|                 select count(*) from evoucher.evoucher_recharge_bonuses | 
|              select count(*) from evoucher.evoucher_recharge_extentions | 
|            select count(*) from evoucher.evoucher_recharge_transactions | 
|    select count(*) from evoucher.evoucher_recharge_transactions_history | 
|               select count(*) from evoucher.evoucher_rejected_dialogues | 
|                        select count(*) from evoucher.evoucher_retailers | 
|                select count(*) from evoucher.evoucher_retailers_history | 
|                  select count(*) from evoucher.evoucher_stat_epay_trans | 
|            select count(*) from evoucher.evoucher_stat_failedtrans_temp | 
|                        select count(*) from evoucher.evoucher_stat_last | 
|              select count(*) from evoucher.evoucher_stat_recharge_trans | 
|                  select count(*) from evoucher.evoucher_stat_trans_temp | 
|              select count(*) from evoucher.evoucher_stat_transfer_trans | 
|              select count(*) from evoucher.evoucher_transactions_datecs | 
|           select count(*) from evoucher.evoucher_transactions_for_bonus | 
|            select count(*) from evoucher.evoucher_transfer_transactions | 
|                   select count(*) from evoucher.evoucher_volume_bonuses | 
|                 select count(*) from evoucher.evoucher_volume_discounts | 
|                       select count(*) from evoucher.evoucher_web_access | 
|                     select count(*) from evoucher.evoucher_web_sessions | 
|                         select count(*) from evoucher.evoucher_web_vars | 
|                                 select count(*) from mysql.columns_priv | 
|                                           select count(*) from mysql.db | 
|                                         select count(*) from mysql.func | 
|                                select count(*) from mysql.help_category | 
|                                 select count(*) from mysql.help_keyword | 
|                                select count(*) from mysql.help_relation | 
|                                   select count(*) from mysql.help_topic | 
|                                         select count(*) from mysql.host | 
|                                         select count(*) from mysql.proc | 
|                                   select count(*) from mysql.procs_priv | 
|                                  select count(*) from mysql.tables_priv | 
|                                    select count(*) from mysql.time_zone | 
|                        select count(*) from mysql.time_zone_leap_second | 
|                               select count(*) from mysql.time_zone_name | 
|                         select count(*) from mysql.time_zone_transition | 
|                    select count(*) from mysql.time_zone_transition_type | 
|                                         select count(*) from mysql.user | 
|                       select count(*) from ocmaintenance.alarms_history | 
|                         select count(*) from ocmaintenance.mnt_accounts | 
|                      select count(*) from ocmaintenance.mnt_permissions | 
|                        select count(*) from ocmaintenance.mnt_resources | 
|                     select count(*) from ocmaintenance.mnt_web_sessions | 
|                         select count(*) from ocmaintenance.mnt_web_vars | 
|                          select count(*) from ocmaintenance.node_alarms | 
|               select count(*) from ocuserprofiles.userprofiles_profiles | 
|                  select count(*) from ocuserprofiles.userprofiles_users | 
|                   select count(*) from ocussdbrowser.ussdbrowser_alarms | 
|                 select count(*) from ocussdbrowser.ussdbrowser_alarms_1 | 
|                 select count(*) from ocussdbrowser.ussdbrowser_alarms_2 | 
|               select count(*) from ocussdbrowser.ussdbrowser_cdr_fields | 
|              select count(*) from ocussdbrowser.ussdbrowser_cdr_formats | 
|                select count(*) from ocussdbrowser.ussdbrowser_cdr_types | 
|                   select count(*) from ocussdbrowser.ussdbrowser_config | 
|               select count(*) from ocussdbrowser.ussdbrowser_connectors | 
|       select count(*) from ocussdbrowser.ussdbrowser_connectors_db_urls | 
|     select count(*) from ocussdbrowser.ussdbrowser_connectors_http_urls | 
|      select count(*) from ocussdbrowser.ussdbrowser_connectors_sessions | 
|     select count(*) from ocussdbrowser.ussdbrowser_connectors_smpp_urls | 
|     select count(*) from ocussdbrowser.ussdbrowser_connectors_soap_urls | 
| select count(*) from ocussdbrowser.ussdbrowser_connectors_subconnectors | 
|      select count(*) from ocussdbrowser.ussdbrowser_connectors_ucp_urls | 
|                select count(*) from ocussdbrowser.ussdbrowser_dialogues | 
|        select count(*) from ocussdbrowser.ussdbrowser_dialogues_history | 
|                select count(*) from ocussdbrowser.ussdbrowser_languages | 
|     select count(*) from ocussdbrowser.ussdbrowser_menu_profile_columns | 
|                    select count(*) from ocussdbrowser.ussdbrowser_menus | 
|          select count(*) from ocussdbrowser.ussdbrowser_menus_constants | 
|  select count(*) from ocussdbrowser.ussdbrowser_menus_constants_strings | 
|          select count(*) from ocussdbrowser.ussdbrowser_menus_languages | 
|              select count(*) from ocussdbrowser.ussdbrowser_menus_texts | 
|            select count(*) from ocussdbrowser.ussdbrowser_messages_appl | 
|          select count(*) from ocussdbrowser.ussdbrowser_messages_mobile | 
|              select count(*) from ocussdbrowser.ussdbrowser_mi_srcaddrs | 
|                    select count(*) from ocussdbrowser.ussdbrowser_nodes | 
|        select count(*) from ocussdbrowser.ussdbrowser_nodes_assign_vars | 
|           select count(*) from ocussdbrowser.ussdbrowser_nodes_branches | 
|           select count(*) from ocussdbrowser.ussdbrowser_profile_tables | 
|   select count(*) from ocussdbrowser.ussdbrowser_profile_tables_columns | 
|                select count(*) from ocussdbrowser.ussdbrowser_providers | 
|    select count(*) from ocussdbrowser.ussdbrowser_providers_to_services | 
|               select count(*) from ocussdbrowser.ussdbrowser_smpp_users | 
|      select count(*) from ocussdbrowser.ussdbrowser_smpp_users_sessions | 
|           select count(*) from ocussdbrowser.ussdbrowser_stat_dialogues | 
|      select count(*) from ocussdbrowser.ussdbrowser_stat_dialogues_temp | 
|                 select count(*) from ocussdbrowser.ussdbrowser_stat_ids | 
|                select count(*) from ocussdbrowser.ussdbrowser_stat_lock | 
|            select count(*) from ocussdbrowser.ussdbrowser_stat_messages | 
|       select count(*) from ocussdbrowser.ussdbrowser_stat_messages_temp | 
|       select count(*) from ocussdbrowser.ussdbrowser_stats_by_connector | 
|              select count(*) from ocussdbrowser.ussdbrowser_stats_by_sc | 
|               select count(*) from ocussdbrowser.ussdbrowser_web_access | 
|             select count(*) from ocussdbrowser.ussdbrowser_web_sessions | 
|                 select count(*) from ocussdbrowser.ussdbrowser_web_vars | 
|                    select count(*) from ocussdbrowser.ussdweb_dialogues | 
|                     select count(*) from ocussdbrowser.ussdweb_messages | 
|                           select count(*) from test.broadcast_campaigns | 
|                                 select count(*) from test.cmp19_history | 
|                               select count(*) from test.operative_table | 
+-------------------------------------------------------------------------+

I don't know what is the expected behaviour. Let me know if you need any other 
information.

Best regards,
Hristo