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

Query - view with sum/truncate/floor() erroring: rowgroup.h@821: assertion '0' failed

    XMLWordPrintable

Details

    • Bug
    • Status: Open (View Workflow)
    • Major
    • Resolution: Unresolved
    • 6.4.7- CS only
    • None
    • ExeMgr
    • None
    • ubuntu22

    Description

      We run mariadb 10.6.16 with cs plugin 6.4.7 and we get error on a query over view:

      Jan 3 12:35:11 dev ExeMgr[578581]: 11.660132 |46|0|0| D 16 CAL0041: Start SQL statement: SELECT ROUND(SUM(bytes*8)/1024/1024/300,2) as Mbps from all_macs_mac1_5min WHERE stamp_inserted='2024-01-03 09:40:00' ORDER BY Mbps DESC LIMIT 5; |<proc>|

      Jan 3 12:35:11 dev Calpont[578581]: 11.757820 |0|0|0| E 00 CAL0000: ./storage/columnstore/columnstore/utils/rowgroup/./rowgroup.h@821: assertion '0' failed
      Jan 3 12:35:11 dev joblist[578581]: 11.758071 |46|0|0| C 05 CAL0000: SubAdapterStep::execute() MCS-2035: An internal error occurred. Check the error log file & contact support.
      Jan 3 12:35:11 dev ExeMgr[578581]: 11.760413 |46|0|0| D 16 CAL0042: End SQL statement

      The same issue is observed with all other functions - ROUND, TRUNCATE, CEIL, FLOOR.
      If we remove them everything is OK.

      No such issue in version 5.6.2.

      Attachments

        Activity

          People

            Unassigned Unassigned
            jrg Jordan G
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

            Dates

              Created:
              Updated:

              Git Integration

                Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.