Details
-
Bug
-
Status: Closed (View Workflow)
-
Blocker
-
Resolution: Fixed
-
5.5.2
-
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.