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

EXTRACT() function returned assertion error

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Minor
    • Resolution: Fixed
    • None
    • 1.0.3
    • ExeMgr
    • None
    • 1.0.2-1, 1.0.2-2, 1.0.3

    Description

      Build tested:

      InfiniDB> getcalpontsoft
      getcalpontsoftwareinfo Mon May 23 19:40:49 2016

      Name : infinidb-platform Relocations: (not relocatable)
      Version : 5.0 Vendor: MariaDB, Inc.
      Release : 0 Build Date: Sun 15 May 2016 07:24:29 PM CDT
      Install Date: Mon 16 May 2016 05:21:51 PM CDT Build Host: srvbuilder

      ColumnStore returns:

      MariaDB [mytest]> select cidx, CDATE, EXTRACT(HOUR_MICROSECOND FROM CDATE) from datatypetestm order by cidx;
      ERROR 1815 (HY000): Internal error: st: 0 TupleBPS::receiveMultiPrimitiveMessages() caught an exception: IDB-2035: An internal error occurred. Check the error log file & contact support.

      MariaDB [mytest]> select cidx, CDATE, EXTRACT(MINUTE_MICROSECOND FROM CDATE) from datatypetestm order by cidx;
      ERROR 1815 (HY000): Internal error: st: 0 TupleBPS::receiveMultiPrimitiveMessages() caught an exception: IDB-2035: An internal error occurred. Check the error log file & contact support.

      err.log

      May 23 19:42:23 columnStore Calpont[33411]: 23.815677 |0|0|0| E 00 CAL0000: batchprimitiveprocessor-jl.cpp@660: assertion 'in.length() > offset' failed
      May 23 19:42:25 columnStore Calpont[33411]: 25.341703 |0|0|0| E 00 CAL0000: batchprimitiveprocessor-jl.cpp@660: assertion 'in.length() > offset' failed

      crit.log

      May 23 19:42:23 columnStore PrimProc[33351]: 23.813868 |0|0|0| C 28 CAL0000: supported: #012
      May 23 19:42:23 columnStore joblist[33411]: 23.815767 |911420|0|0| C 05 CAL0000: st: 0 TupleBPS::receiveMultiPrimitiveMessages() caught an exception: IDB-2035: An internal error occurred. Check the error log file & contact support.#012
      May 23 19:42:25 columnStore PrimProc[33351]: 25.340987 |0|0|0| C 28 CAL0000: upported: #012
      May 23 19:42:25 columnStore joblist[33411]: 25.341828 |911420|0|0| C 05 CAL0000: st: 0 TupleBPS::receiveMultiPrimitiveMessages() caught an exception: IDB-2035: An internal error occurred. Check the error log file & contact support.#012

      MariaDB [tpch1]> select cidx, CDATE, EXTRACT(HOUR_MICROSECOND FROM CDATE) from DataTypeTestm order by cidx;;
      +------+------------+--------------------------------------+
      | cidx | CDATE      | EXTRACT(HOUR_MICROSECOND FROM CDATE) |
      +------+------------+--------------------------------------+
      |    1 | 1997-01-01 |                                    0 |
      |    2 | 1997-01-01 |                                    0 |
      |    3 | 1997-01-02 |                                    0 |
      |    4 | 1997-01-03 |                                    0 |
      |    5 | 1997-01-04 |                                    0 |
      |    6 | 2009-12-28 |                                    0 |
      |    7 | 2009-12-29 |                                    0 |
      |    8 | 2009-12-30 |                                    0 |
      |    9 | 2009-12-31 |                                    0 |
      |   10 | 2009-12-31 |                                    0 |
      |   11 | 2009-12-31 |                                    0 |
      +------+------------+--------------------------------------+
      11 rows in set (0.00 sec)
      

      Attachments

        Issue Links

          Activity

            People

              David.Hall David Hall (Inactive)
              dleeyh Daniel Lee (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              4 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:

                Git Integration

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