[MCOL-1672] ColumnStore in auto-switch operational mode fail to process query with Internal error and aggregation data overflow Created: 2018-08-23  Updated: 2019-07-11  Resolved: 2019-07-11

Status: Closed
Project: MariaDB ColumnStore
Component/s: ExeMgr, PrimProc
Affects Version/s: 1.1.5
Fix Version/s: 1.2.4

Type: Bug Priority: Major
Reporter: Zdravelina Sokolovska (Inactive) Assignee: David Hall (Inactive)
Resolution: Fixed Votes: 0
Labels: None
Environment:

um1-2xpm ; centos7

Issue Links:
Relates
relates to MCOL-2165 Autoswitch broken in some cases in 1.2.2 Closed

 Description   

ColumnStore in auto-switch operational mode fail to process query with Internal error and
aggregation data overflow

operational_mode result
0 pass
1 fail
2 fail

query pass with generic infinidb_vtable_mode = 0 but when set to the auto-switch mode 2 it's returned Internal Error

MariaDB [ffr]> set infinidb_vtable_mode = 2 ;
 
Query OK, 0 rows affected (0.00 sec)
 
 
 
MariaDB [ffr]> show variables like '%infinidb_vtable_mode%';
 
+----------------------+-------+
 
| Variable_name        | Value |
 
+----------------------+-------+
 
| infinidb_vtable_mode | 2     |
 
+----------------------+-------+
 
1 row in set (0.00 sec)
 
 
 
MariaDB [ffr]> select sum(c1) from t1;
 
ERROR 1815 (HY000): Internal error: An unexpected condition within the query caused an internal processing error within InfiniDB. Please check the log files for more details. Additional Information: aggregation data overflow.
 
MariaDB [ffr]>

the same query pass with columnstore generic mode and it would be expected to pass also with auto-switch mode

MariaDB [ffr]> set infinidb_vtable_mode = 0 ;
 
Query OK, 0 rows affected (0.00 sec)
 
 
 
MariaDB [ffr]> select sum(c1) from t1;
 
+----------------------+
 
| sum(c1)              |
 
+----------------------+
 
| 18446744073709551614 |
 
+----------------------+
 
1 row in set (0.07 sec)
 
 
 
MariaDB [ffr]>



 Comments   
Comment by Andrew Hutchings (Inactive) [ 2019-07-10 ]

Overflow might be fixed already

Comment by David Hall (Inactive) [ 2019-07-11 ]

Over flow is fixed:
MariaDB [dhall]> set infinidb_vtable_mode = 1 ;
Query OK, 0 rows affected (0.000 sec)

MariaDB [dhall]> select sum(c1) from t1;
------------

sum(c1)

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

8589934588

------------
1 row in set (0.022 sec)

Based on this and that MCOL-2165 is fixed, I'm closing this MCOL.

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