Uploaded image for project: 'MariaDB ColumnStore'
  1. MariaDB ColumnStore
  2. MCOL-3330

mcs post-mysqld-install on upgrade is finished with Warning Failed to load slave replication state from table mysql.gtid_slave_pos: 1146: Table 'mysql.gtid_slave_pos' doesn't exist

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Unresolved
    • 1.2.4
    • Icebox
    • installation
    • None
    • 1IM-1PM ; mcs deployed on CentOS7

    Description

      mcs post-mysqld-install on upgrade is finished with Warning Failed to load slave replication state from table mysql.gtid_slave_pos: 1146: Table 'mysql.gtid_slave_pos' doesn't exist

      upgrade to 1.2.4

      [root@pm1 ~]# /usr/local/mariadb/columnstore/bin/post-mysqld-install
      2019-05-24 14:14:55 6 [Warning] Failed to load slave replication state from table mysql.gtid_slave_pos: 1146: Table 'mysql.gtid_slave_pos' doesn't exist
      
      

      [root@pm1 ~]# ls -lt /usr/local/mariadb/columnstore/mysql/db/mysql/
      total 1248
      -rw------- 1 mysql mysql  98304 May 24 14:14 gtid_slave_pos.ibd
      -rw------- 1 mysql mysql  98304 May 24 14:14 innodb_index_stats.ibd
      -rw------- 1 mysql mysql  98304 May 24 14:14 innodb_table_stats.ibd
      -rw------- 1 mysql mysql 147456 May 24 14:14 transaction_registry.ibd
      -rw------- 1 mysql mysql   3072 May 24 14:14 help_category.MYI
      -rw------- 1 mysql mysql  16384 May 24 14:14 help_keyword.MYI
      -rw------- 1 mysql mysql  19456 May 24 14:14 help_relation.MYI
      -rw------- 1 mysql mysql  20480 May 24 14:14 help_topic.MYI
      -rw------- 1 mysql mysql   4096 May 24 14:14 user.MYI
      -rw------- 1 mysql mysql    376 May 24 14:14 user.MYD
      -rw------- 1 mysql mysql   1266 May 24 14:14 db.MYD
      -rw------- 1 mysql mysql   9216 May 24 14:14 db.MYI
      -rw------- 1 mysql mysql   1132 May 24 14:14 proc.MYD
      -rw------- 1 mysql mysql   4096 May 24 14:14 proc.MYI
      -rw------- 1 mysql mysql   9252 May 24 14:14 help_relation.MYD
      -rw------- 1 mysql mysql  91408 May 24 14:14 help_keyword.MYD
      -rw------- 1 mysql mysql 405476 May 24 14:14 help_topic.MYD
      -rw------- 1 mysql mysql   1092 May 24 14:14 help_category.MYD
      -rw------- 1 mysql mysql   2538 May 24 14:14 proxies_priv.MYD
      -rw------- 1 mysql mysql  10240 May 24 14:14 proxies_priv.MYI
      -rw------- 1 mysql mysql   4096 May 24 14:14 column_stats.MYI
      -rw------- 1 mysql mysql   1024 May 24 14:14 gtid_slave_pos.frm
      -rw------- 1 mysql mysql   1629 May 24 14:14 index_stats.frm
      -rw------- 1 mysql mysql      0 May 24 14:14 index_stats.MYD
      -rw------- 1 mysql mysql   4096 May 24 14:14 index_stats.MYI
      -rw------- 1 mysql mysql   2602 May 24 14:14 column_stats.frm
      -rw------- 1 mysql mysql      0 May 24 14:14 column_stats.MYD
      -rw------- 1 mysql mysql   1374 May 24 14:14 table_stats.frm
      -rw------- 1 mysql mysql      0 May 24 14:14 table_stats.MYD
      -rw------- 1 mysql mysql   2048 May 24 14:14 table_stats.MYI
      -rw------- 1 mysql mysql   2839 May 24 14:14 proxies_priv.frm
      -rw------- 1 mysql mysql   2618 May 24 14:14 transaction_registry.frm
      -rw------- 1 mysql mysql   5404 May 24 14:14 innodb_index_stats.frm
      -rw------- 1 mysql mysql      0 May 24 14:14 event.MYD
      -rw------- 1 mysql mysql   2048 May 24 14:14 event.MYI
      -rw------- 1 mysql mysql   1909 May 24 14:14 innodb_table_stats.frm
      -rw------- 1 mysql mysql   3732 May 24 14:14 event.frm
      -rw------- 1 mysql mysql     35 May 24 14:14 slow_log.CSM
      -rw------- 1 mysql mysql      0 May 24 14:14 slow_log.CSV
      -rw------- 1 mysql mysql   2374 May 24 14:14 slow_log.frm
      -rw------- 1 mysql mysql     35 May 24 14:14 general_log.CSM
      -rw------- 1 mysql mysql      0 May 24 14:14 general_log.CSV
      -rw------- 1 mysql mysql    804 May 24 14:14 general_log.frm
      -rw------- 1 mysql mysql      0 May 24 14:14 procs_priv.MYD
      -rw------- 1 mysql mysql   4096 May 24 14:14 procs_priv.MYI
      -rw------- 1 mysql mysql   3529 May 24 14:14 proc.frm
      -rw------- 1 mysql mysql   2895 May 24 14:14 procs_priv.frm
      -rw------- 1 mysql mysql      0 May 24 14:14 time_zone_leap_second.MYD
      -rw------- 1 mysql mysql   1024 May 24 14:14 time_zone_leap_second.MYI
      -rw------- 1 mysql mysql    971 May 24 14:14 time_zone_leap_second.frm
      -rw------- 1 mysql mysql      0 May 24 14:14 time_zone.MYD
      -rw------- 1 mysql mysql   1024 May 24 14:14 time_zone.MYI
      -rw------- 1 mysql mysql   1013 May 24 14:14 time_zone_transition.frm
      -rw------- 1 mysql mysql      0 May 24 14:14 time_zone_transition.MYD
      -rw------- 1 mysql mysql   1024 May 24 14:14 time_zone_transition.MYI
      -rw------- 1 mysql mysql   1079 May 24 14:14 time_zone_transition_type.frm
      -rw------- 1 mysql mysql      0 May 24 14:14 time_zone_transition_type.MYD
      -rw------- 1 mysql mysql   1024 May 24 14:14 time_zone_transition_type.MYI
      -rw------- 1 mysql mysql    973 May 24 14:14 time_zone.frm
      -rw------- 1 mysql mysql   1146 May 24 14:14 time_zone_name.frm
      -rw------- 1 mysql mysql      0 May 24 14:14 time_zone_name.MYD
      -rw------- 1 mysql mysql   1024 May 24 14:14 time_zone_name.MYI
      -rw------- 1 mysql mysql   1638 May 24 14:14 help_keyword.frm
      -rw------- 1 mysql mysql    970 May 24 14:14 help_relation.frm
      -rw------- 1 mysql mysql   4096 May 24 14:14 columns_priv.MYI
      -rw------- 1 mysql mysql   1706 May 24 14:14 help_category.frm
      -rw------- 1 mysql mysql   1776 May 24 14:14 help_topic.frm
      -rw------- 1 mysql mysql   2110 May 24 14:14 columns_priv.frm
      -rw------- 1 mysql mysql      0 May 24 14:14 columns_priv.MYD
      -rw------- 1 mysql mysql      0 May 24 14:14 tables_priv.MYD
      -rw------- 1 mysql mysql   4096 May 24 14:14 tables_priv.MYI
      -rw------- 1 mysql mysql   2703 May 24 14:14 servers.frm
      -rw------- 1 mysql mysql      0 May 24 14:14 servers.MYD
      -rw------- 1 mysql mysql   1024 May 24 14:14 servers.MYI
      -rw------- 1 mysql mysql   2980 May 24 14:14 tables_priv.frm
      -rw------- 1 mysql mysql      0 May 24 14:14 func.MYD
      -rw------- 1 mysql mysql   1024 May 24 14:14 func.MYI
      -rw------- 1 mysql mysql   1518 May 24 14:14 plugin.frm
      -rw------- 1 mysql mysql      0 May 24 14:14 plugin.MYD
      -rw------- 1 mysql mysql   1024 May 24 14:14 plugin.MYI
      -rw------- 1 mysql mysql   1582 May 24 14:14 func.frm
      -rw------- 1 mysql mysql   1661 May 24 14:14 roles_mapping.frm
      -rw------- 1 mysql mysql      0 May 24 14:14 roles_mapping.MYD
      -rw------- 1 mysql mysql   4096 May 24 14:14 roles_mapping.MYI
      -rw------- 1 mysql mysql   3229 May 24 14:14 user.frm
      -rw------- 1 mysql mysql   1897 May 24 14:14 host.frm
      -rw------- 1 mysql mysql      0 May 24 14:14 host.MYD
      -rw------- 1 mysql mysql   2048 May 24 14:14 host.MYI
      -rw------- 1 mysql mysql   2715 May 24 14:14 db.frm
      [root@pm1 ~]#
      
      

      Attachments

        Activity

          People

            Unassigned Unassigned
            winstone Zdravelina Sokolovska (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

            Dates

              Created:
              Updated:

              Git Integration

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