/usr/bin/mysqlcheck: Got error: 1064 after today upgrade MariaDB to 5.5.27 version

Bug #1048519 reported by Mikhail Gavrilov
6
This bug affects 1 person
Affects Status Importance Assigned to Milestone
MariaDB
Incomplete
Undecided
Unassigned

Bug Description

# /usr/bin/mysql_upgrade
Phase 1/3: Fixing table and database names
Phase 2/3: Checking and upgrading tables
Processing databases
information_schema
bankdev
bankdev.#audit OK
bankdev.#ext_sys OK
bankdev.#ext_sys_departs OK
bankdev.#module_role OK
bankdev.#modules OK
bankdev.#params OK
bankdev.EHD_disks OK
bankdev.acl OK
bankdev.bonus_calc_types OK
bankdev.bonus_managers OK
bankdev.bonus_prod OK
bankdev.bonus_prod_dep OK
bankdev.bonus_results OK
bankdev.bonus_signs OK
bankdev.dynamc_forms OK
bankdev.dynamc_forms_answers OK
bankdev.dynamc_forms_questions OK
bankdev.dynamic_arms OK
bankdev.error_collector OK
bankdev.func_dirs OK
bankdev.import_twcms OK
bankdev.log OK
bankdev.news OK
bankdev.prod_types OK
bankdev.product_func_dir OK
bankdev.result OK
bankdev.rko_fields_in_forms OK
bankdev.rko_forms_in_groups OK
bankdev.rko_list_fields OK
bankdev.rko_list_forms OK
bankdev.rko_list_groups OK
bankdev.roles OK
bankdev.sales OK
bankdev.sales_tree_p OK
bankdev.spr_answer OK
bankdev.spr_binddict OK
bankdev.spr_binddict_old OK
bankdev.spr_group OK
bankdev.spr_insurance_companies OK
bankdev.spr_question OK
bankdev.spr_testing OK
bankdev.spr_tests OK
bankdev.sprut_activities OK
bankdev.sprut_appl OK
bankdev.sprut_bkis OK
bankdev.sprut_collateral_check OK
bankdev.sprut_collateral_policies OK
bankdev.sprut_collateral_recommendations OK
bankdev.sprut_collateral_to_policy OK
bankdev.sprut_collateral_types OK
bankdev.sprut_collaterals OK
bankdev.sprut_conclusion_new OK
bankdev.sprut_conclusion_old OK
bankdev.sprut_contract OK
bankdev.sprut_prod_test OK
bankdev.sprut_spr_zp OK
bankdev.testing_questions OK
bankdev.tests_user_test OK
bankdev.user_group OK
bankdev.users OK
bankdev.workflow_documents OK
bankdev.workflow_jumps OK
bankdev.workflow_mailing OK
bankdev.workflow_processes OK
bankdev.workflow_processes_questions OK
bankdev.workflow_results OK
bankdev.workflow_results_last OK
bankdev.workflow_roles OK
bankdev.workflow_schemes OK
bankdev.workflow_stages OK
bankdev.workflow_tasks OK
banktest
banktest.#audit OK
banktest.#ext_sys OK
banktest.#ext_sys_departs OK
banktest.#module_role OK
banktest.#modules OK
banktest.#params OK
banktest.EHD_disks OK
banktest.acl OK
banktest.bonus_calc_types OK
banktest.bonus_managers OK
banktest.bonus_prod OK
banktest.bonus_prod_dep OK
banktest.bonus_results OK
banktest.bonus_signs OK
banktest.dynamc_forms OK
banktest.dynamc_forms_answers OK
banktest.dynamc_forms_questions OK
banktest.dynamic_arms OK
banktest.error_collector OK
banktest.func_dirs OK
banktest.import_twcms OK
banktest.log OK
banktest.news OK
banktest.prod_types OK
banktest.product_func_dir OK
banktest.result OK
banktest.rko_fields_in_forms OK
banktest.rko_forms_in_groups OK
banktest.rko_list_fields OK
banktest.rko_list_forms OK
banktest.rko_list_groups OK
banktest.roles OK
banktest.sales OK
banktest.sales_tree_p OK
banktest.spr_answer OK
banktest.spr_binddict OK
banktest.spr_binddict_old OK
banktest.spr_group OK
banktest.spr_insurance_companies OK
banktest.spr_question OK
banktest.spr_testing OK
banktest.spr_tests OK
banktest.sprut_activities OK
banktest.sprut_appl OK
banktest.sprut_bkis OK
banktest.sprut_collateral_check OK
banktest.sprut_collateral_policies OK
banktest.sprut_collateral_recommendations OK
banktest.sprut_collateral_to_policy OK
banktest.sprut_collateral_types OK
banktest.sprut_collaterals OK
banktest.sprut_conclusion_new OK
banktest.sprut_conclusion_old OK
banktest.sprut_contract OK
banktest.sprut_prod_test OK
banktest.sprut_spr_zp OK
banktest.testing_questions OK
banktest.tests_user_test OK
banktest.user_group OK
banktest.users OK
banktest.workflow_documents OK
banktest.workflow_jumps OK
banktest.workflow_mailing OK
banktest.workflow_processes OK
banktest.workflow_processes_questions OK
banktest.workflow_results OK
banktest.workflow_results_last OK
banktest.workflow_roles OK
banktest.workflow_schemes OK
banktest.workflow_stages OK
banktest.workflow_tasks OK
condominium
condominium.#audit OK
condominium.account_his OK
condominium.accounts OK
condominium.acl OK
condominium.buildings OK
condominium.condominiums OK
condominium.contract OK
condominium.contract_his OK
condominium.contract_service_work OK
condominium.contracts_services OK
condominium.counters OK
condominium.counters_his OK
condominium.operations OK
condominium.periods OK
condominium.roles OK
condominium.services OK
condominium.tariffs OK
condominium.transactions OK
condominium.users OK
condominium.users_condominiums OK
ddb
ddb.ddb_ckv OK
ddb.ddb_item OK
ddb.ddb_item_data OK
ddb.ddb_item_nodes OK
ddb.ddb_nodes OK
ddb.ddb_recip OK
ddb.ddb_recip_acl OK
hardfight
hardfight.atom OK
hardfight.atom_conntype OK
hardfight.conntype OK
hardfight.cpu_socket OK
hardfight.hw OK
hardfight.hw_cpu OK
hardfight.hw_monitor OK
hardfight.hw_monitor_elt OK
hardfight.hw_monitor_lcd OK
hardfight.matrix_type OK
hardfight.types OK
hardfight.types_tree OK
hardfight.vendor OK
labs
mysql
mysql.columns_priv OK
mysql.db OK
mysql.event OK
mysql.func OK
mysql.help_category OK
mysql.help_keyword OK
mysql.help_relation OK
mysql.help_topic OK
mysql.host OK
mysql.ndb_binlog_index OK
mysql.plugin OK
mysql.proc OK
mysql.procs_priv OK
mysql.proxies_priv OK
mysql.servers OK
mysql.tables_priv OK
mysql.time_zone OK
mysql.time_zone_leap_second OK
mysql.time_zone_name OK
mysql.time_zone_transition OK
mysql.time_zone_transition_type OK
mysql.user OK
performance_schema
sonic
/usr/bin/mysqlcheck: Got error: 1064: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '.`clients` FOR UPGRADE' at line 1 when executing 'CHECK TABLE ... FOR UPGRADE'
FATAL ERROR: Upgrade failed

Revision history for this message
Elena Stepanova (elenst) wrote :

Hi,

What is the name of the schema which the table `clients` belongs?
Can you see the table file in the file system, and/or see the table while connecting to the server and issuing "SHOW TABLES" for the schema?
Could you please connect to the server, enable general log temporarily, and re-run upgrade, so we could see which particular statement it breaks on?

Thanks.

Elena Stepanova (elenst)
Changed in maria:
status: New → Incomplete
To post a comment you must log in.
This report contains Public information  
Everyone can see this information.

Other bug subscribers

Remote bug watches

Bug watches keep track of this bug in other bug trackers.