[MCOL-3752] IDB-2035 when I try to run query Created: 2020-02-03  Updated: 2023-10-25  Resolved: 2023-10-25

Status: Closed
Project: MariaDB ColumnStore
Component/s: PrimProc
Affects Version/s: 1.2.5
Fix Version/s: Icebox

Type: Bug Priority: Major
Reporter: Carlos Campos Assignee: Unassigned
Resolution: Won't Do Votes: 0
Labels: None
Environment:

vmware / centos 7


 Description   

When I try to run the following query addind one more "where" field I got an error:

Original query:

MariaDB [chargify_tickets]> select date(`timestamp`), organization_id, bw_chunk, count(0) from flow_tickets where date(`timestamp`) = '2020-01-31' group by 1, 2, 3;
-----------------------------------------------------------------------+

date(`timestamp`) organization_id bw_chunk count(0)

-----------------------------------------------------------------------+

2020-01-31 7a21fc9f-3901-426f-9ed7-88329aaf5df2 120 5
2020-01-31 cdf062ef-0d3a-4736-b45c-722ac1161fa2 120 22
2020-01-31 8c614250-efe3-44ae-84c2-06046aa4cbfa 78 7

...

Adding one more (valid) condition:

MariaDB [chargify_tickets]> select date(`timestamp`), organization_id, bw_chunk, count(0) from flow_tickets where date(`timestamp`) = '2020-01-31' AND organization_id='7a21fc9f-3901-426f-9ed7-88329aaf5df2' group by 1, 2, 3;
ERROR 1815 (HY000): Internal error: IDB-2035: An internal error occurred. Check the error log file & contact support.

Logs:

Feb 3 08:17:40 infra-sp2-mcs-pm01 Calpont[12060]: 40.320949 |0|0|0| E 00 CAL0000: /data/buildbot/bb-worker/centos7/mariadb-columnstore-engine/primitives/primproc/dictstep.cpp@393: assertion 'pt[primMsg->NVALS].offsetIndex != 0' failed
Feb 3 08:17:40 infra-sp2-mcs-pm01 PrimProc[12060]: 40.321016 |0|0|0| W 28 CAL0000: IDB-2035: An internal error occurred. Check the error log file & contact support.
Generated at Thu Feb 08 02:45:10 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.