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

call columnstore_info.total_usage(); returns Error even after mcs is being restarted

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Cannot Reproduce
    • 1.2.2
    • 5.5.1
    • N/A
    • None

    Description

      call columnstore_info.total_usage(); returns Error even after mcs is being restarted

      call columnstore_info.total_usage(); was issued from remote site.
      Before getting results connection was interrupted.
      Afterwards call columnstore_info.total_usage(); returns Error even if it's executed locally or after
      mcs was being restarted

      MariaDB [(none)]> call columnstore_info.total_usage();
      ERROR 1317 (70100): Query execution was interrupted
      
      

      [root@localhost ~]# mcsadmin restart
      restartsystem   Fri Dec 14 17:15:42 2018
                 Do you want to proceed: (y or n) [n]: y
       
         System being restarted now ...
         Successful restart of System
       
      
      

      MariaDB [(none)]> show processlist ;
      +----+-------------+-----------+------+---------+------+--------------------------+------------------+----------+
      | Id | User        | Host      | db   | Command | Time | State                    | Info             | Progress |
      +----+-------------+-----------+------+---------+------+--------------------------+------------------+----------+
      |  3 | system user |           | NULL | Daemon  | NULL | InnoDB purge worker      | NULL             |    0.000 |
      |  1 | system user |           | NULL | Daemon  | NULL | InnoDB purge coordinator | NULL             |    0.000 |
      |  2 | system user |           | NULL | Daemon  | NULL | InnoDB purge worker      | NULL             |    0.000 |
      |  4 | system user |           | NULL | Daemon  | NULL | InnoDB purge worker      | NULL             |    0.000 |
      |  5 | system user |           | NULL | Daemon  | NULL | InnoDB shutdown handler  | NULL             |    0.000 |
      | 11 | root        | localhost | NULL | Query   |    0 | Init                     | show processlist |    0.000 |
      +----+-------------+-----------+------+---------+------+--------------------------+------------------+----------+
      6 rows in set (0.000 sec)
      
      

      MariaDB [(none)]> call columnstore_info.total_usage();
      ERROR 1317 (70100): Query execution was interrupted
      
      

      Attachments

        Activity

          People

            Unassigned Unassigned
            winstone Zdravelina Sokolovska (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            1 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.