[MCOL-1269] table_usage procedure output is not consistent Created: 2018-03-14  Updated: 2018-03-14  Resolved: 2018-03-14

Status: Closed
Project: MariaDB ColumnStore
Component/s: MDB Plugin
Affects Version/s: 1.1.2
Fix Version/s: Icebox

Type: Bug Priority: Minor
Reporter: BOBY PETER Assignee: Andrew Hutchings (Inactive)
Resolution: Duplicate Votes: 0
Labels: None
Environment:

REHL 7

getsoftwareinfo Tue Mar 13 13:42:25 2018

Name : mariadb-columnstore-platform
Version : 1.1.2
Release : 1
Architecture: x86_64
Install Date: Wed 29 Nov 2017 11:33:08 AM EST
Group : Applications/Databases
Size : 113942794
License : Copyright (c) 2016 MariaDB Corporation Ab., all rights reserved; redistributable under the terms of the GPL, see the file COPYING for details.
Signature : (none)
Source RPM : mariadb-columnstore-platform-1.1.2-1.src.rpm
Build Date : Thu 16 Nov 2017 10:20:27 AM EST

Attachments: Text File table_usage.sql    
Issue Links:
Duplicate
duplicates MCOL-1084 table_usage() stored procedure show z... Closed

 Description   

While running a table_usage, I found that the total_usage is 0 even if data_disk_usage is in GB. The dictonary is of 0 (null) byte size. Not sure why (or a bug).
---------------------------------------------------------------------------------------

TABLE_SCHEMA TABLE_NAME DATA_DISK_USAGE DICT_DISK_USAGE TOTAL_USAGE

---------------------------------------------------------------------------------------

e4genodebpm eutrancellrelation_source_hourly 2.10 GB 0 Bytes 0 Bytes

---------------------------------------------------------------------------------------
1 row in set (6 min 30.54 sec)

If an "ifnull" is used in the total_usage, the output looks right
columnstore_info.format_filesize(data + ifnull(dict,0)) as TOTAL_USAGE

---------------------------------------------------------------------------------------

TABLE_SCHEMA TABLE_NAME DATA_DISK_USAGE DICT_DISK_USAGE TOTAL_USAGE

---------------------------------------------------------------------------------------

e4genodebpm eutrancellrelation_source_hourly 2.10 GB 0 Bytes 2.10 GB

---------------------------------------------------------------------------------------
1 row in set (10 min 25.25 sec)

Attached is an update of table_usage procedure.

 Comments   
Comment by Andrew Hutchings (Inactive) [ 2018-03-14 ]

Thanks for the report, this is already known and fixed in MCOL-1084 (actually in a very similar way to the one you mentioned). The fix will be released as part of 1.1.4.

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