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

SegFault when using Distributed Aggregate Functions

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Open (View Workflow)
    • Priority: Blocker
    • Resolution: Unresolved
    • Affects Version/s: 5.5.2
    • Fix Version/s: 6.3.1
    • Component/s: ExeMgr
    • Labels:
      None
    • Environment:
      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

            Assignee:
            Unassigned Unassigned
            Reporter:
            galetemp Gale Temp
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

              Dates

              Created:
              Updated:

                Git Integration