[MDEV-3452] LP:1048519 - /usr/bin/mysqlcheck: Got error: 1064 after today upgrade MariaDB to 5.5.27 version Created: 2012-09-10  Updated: 2012-10-04  Resolved: 2012-10-04

Status: Closed
Project: MariaDB Server
Component/s: None
Affects Version/s: None
Fix Version/s: None

Type: Bug
Reporter: NT Man (Inactive) Assignee: Unassigned
Resolution: Incomplete Votes: 0
Labels: Launchpad

Attachments: XML File LPexportBug1048519.xml    

 Description   
  1. /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

 Comments   
Comment by Elena Stepanova [ 2012-09-10 ]

Re: /usr/bin/mysqlcheck: Got error: 1064 after today upgrade MariaDB to 5.5.27 version
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.

Comment by Rasmus Johansson (Inactive) [ 2012-09-18 ]

Launchpad bug id: 1048519

Generated at Thu Feb 08 06:48:44 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.