[MCOL-2025]  call columnstore_info.total_usage(); returns Error even after mcs is being restarted Created: 2018-12-14  Updated: 2021-02-20  Resolved: 2021-02-20

Status: Closed
Project: MariaDB ColumnStore
Component/s: N/A
Affects Version/s: 1.2.2
Fix Version/s: 5.5.1

Type: Bug Priority: Major
Reporter: Zdravelina Sokolovska (Inactive) Assignee: Unassigned
Resolution: Cannot Reproduce Votes: 0
Labels: 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


Generated at Thu Feb 08 02:33:09 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.