Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-3452

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

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Resolution: Incomplete
    • None
    • None
    • None

    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

      Attachments

        Activity

          People

            Unassigned Unassigned
            ntman NT Man (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            0 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Git Integration

                Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.