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

SegFault when using Distributed Aggregate Functions

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Blocker
    • Resolution: Fixed
    • 5.5.2
    • 6.3.1
    • ExeMgr
    • None
    • Centos 8 Linux 4.18.0-305.7.1.el8_4.x86_64 run inside Hyper-V

    Description

      I run the following query and the connection get closed with error.

      SELECT m.Year, m.Origin, m.Dest, m.PAX, REGR_INTERCEPT(CAST(p.PAX AS double),CAST(p.Year AS double)) INTERCEPT, REGR_SLOPE(CAST(p.PAX AS double),CAST(p.Year AS double)) SLOPE, REGR_R2(CAST(p.PAX AS double),CAST(p.Year AS double)) R2
      FROM MarketYearSize m
      LEFT JOIN MarketYearSize p ON m.Origin = p.Origin AND m.Dest = p.Dest AND m.Year >= p.year AND m.year - 5 <= p.Year
      GROUP BY m.Year, m.Origin, m.Dest, m.PAX;

      When I look at the trace I see the following:

      Date/time: 2021-07-08 19:46:56
      Signal: 11
      /usr/bin/ExeMgr(+0x2c735)[0x5597030e5735]
      /lib64/libpthread.so.0(+0x12b20)[0x7f0cae9c9b20]
      /lib64/librowgroup.so(_ZNK8rowgroup13UserDataStore11getUserDataEj+0x66)[0x7f0cb24d29f6]
      /lib64/librowgroup.so(_ZN8rowgroup14RowAggregation6doUDAFERKNS_3RowElllRm+0x988)[0x7f0cb24bccf8]
      /lib64/librowgroup.so(_ZN8rowgroup16RowAggregationUM11updateEntryERKNS_3RowE+0x16a)[0x7f0cb24b884a]
      /lib64/librowgroup.so(_ZN8rowgroup14RowAggregation12aggregateRowERNS_3RowE+0x25d)[0x7f0cb24bf5bd]
      /lib64/librowgroup.so(_ZN8rowgroup14RowAggregation11addRowGroupEPKNS_8RowGroupERSt6vectorINS_3Row7PointerESaIS6_EE+0xab)[0x7f0cb24b5e6b]
      /lib64/libjoblist.so(_ZN7joblist18TupleAggregateStep26threadedAggregateRowGroupsEj+0x271a)[0x7f0cb34c38fa]
      /lib64/libthreadpool.so(_ZN10threadpool10ThreadPool11beginThreadEv+0x560)[0x7f0cadefe8d0]
      /lib64/libboost_thread.so.1.66.0(+0x155e1)[0x7f0caf8915e1]
      /lib64/libpthread.so.0(+0x814a)[0x7f0cae9bf14a]
      /lib64/libc.so.6(clone+0x43)[0x7f0caced1dc3]

      I also notice that it works if I use less aggregate functions, however the results seems correct only if I use 1 aggregate function. I tried reducing the number of rows but it does not solve the problem.

      Attachments

        Activity

          People

            Unassigned Unassigned
            galetemp Gale Temp
            Votes:
            0 Vote for this issue
            Watchers:
            2 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.