Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

CRASH DUMP when query #1510

Closed
mangareader opened this issue Oct 17, 2023 · 10 comments
Closed

CRASH DUMP when query #1510

mangareader opened this issue Oct 17, 2023 · 10 comments
Assignees
@tomatolog
Labels
bug rel::6.3.0 Released in 6.3.0

Comments

@mangareader
Copy link

mangareader commented Oct 17, 2023 •
edited
Loading

Describe the bug
CRASH DUMP when query

To Reproduce
Steps to reproduce the behavior:
query

SELECT dbid, max(lastupdateddate) as maxdate,
      IF(hcustomerid = 0, participantidnumber, hcustomerid) AS customerid
FROM conversationv2
WHERE (customerid > 0) and pageid in ('1645250709107349')
  AND (ismarkdone = 0)
GROUP BY customerid
WITHIN GROUP ORDER BY lastupdateddate DESC
HAVING maxdate < 638322909300000000
ORDER BY maxdate DESC LIMIT 30 OPTION max_matches=1000;

Describe the environment:

Manticore 6.2.12 dc5144d35@230822 (columnar 2.2.4 5aec342@230822) (secondary 2.2.4 5aec342@230822)
Copyright (c) 2001-2016, Andrew Aksyonoff
Copyright (c) 2008-2016, Sphinx Technologies Inc (http://sphinxsearch.com)
Copyright (c) 2017-2023, Manticore Software LTD (https://manticoresearch.com)
  • OS version (uname -a if on a Unix-like system):
Linux manticore 4.18.0-477.27.1.el8_8.x86_64 #1 SMP Wed Sep 20 15:55:39 UTC 2023 x86_64 x86_64 x86_64 GNU/Linux

Messages from log files:
Messages from searchd.log and query.log (if applicable).

------- FATAL: CRASH DUMP -------
[Tue Oct 17 09:10:17.152 2023] [28143]

--- crashed SphinxQL request dump ---
SELECT dbid, max(lastupdateddate) as maxdate,IF(hcustomerid = 0, participantidnumber,
 hcustomerid) AS customerid FROM conversationv2 WHERE (customerid > 0) and pageid
in ('1645250709107349') AND (ismarkdone = 0) GROUP BY customerid WITHIN GROUP ORDER
BY lastupdateddate DESC HAVING maxdate < 638322909300000000 ORDER BY maxdate DESC
LIMIT 30 OPTION max_matches=1000;
--- request dump end ---
--- local index:conversationv2
Manticore 6.2.12 dc5144d35@230822 (columnar 2.2.4 5aec342@230822) (secondary 2.2.4 5aec342@230822)
Handling signal 11
-------------- backtrace begins here ---------------
Program compiled with Clang 15.0.7
Configured with flags: Configured with these definitions: -DDISTR_BUILD=rhel8 -DUSE_SYSLOG=1 -DWITH_GALERA=1 -DWITH_RE2=1 -DWITH_RE2_FORCE_STATIC=1 -DWITH_STEMMER=1 -DWITH_STEMMER_FORCE_STATIC=1 -DWITH_NLJSON=1 -DWITH_UNIALGO=1 -DWITH_ICU=1 -DWITH_ICU_FORCE_STATIC=1 -DWITH_SSL=1 -DWITH_ZLIB=1 -DWITH_ZSTD=1 -DDL_ZSTD=1 -DZSTD_LIB=libzstd.so.1 -DWITH_CURL=1 -DDL_CURL=1 -DCURL_LIB=libcurl.so.4 -DWITH_ODBC=1 -DDL_ODBC=1 -DODBC_LIB=libodbc.so.2 -DWITH_EXPAT=1 -DDL_EXPAT=1 -DEXPAT_LIB=libexpat.so.1 -DWITH_ICONV=1 -DWITH_MYSQL=1 -DDL_MYSQL=1 -DMYSQL_LIB=libmariadb.so.3 -DWITH_POSTGRESQL=1 -DDL_POSTGRESQL=1 -DPOSTGRESQL_LIB=libpq.so.5 -DLOCALDATADIR=/var/lib/manticore -DFULL_SHARE_DIR=/usr/share/manticore
Built on Linux x86_64 (rhel8) (cross-compiled)
Stack bottom = 0x7fe7d80c4170, thread stack size = 0x20000
Trying manual backtrace:
Something wrong with thread stack, manual backtrace may be incorrect (fp=0x1)
Wrong stack limit or frame pointer, manual backtrace failed (fp=0x1, stack=0x7fe7d80c0000, stacksize=0x20000)
Trying system backtrace:
begin of system symbols:
/usr/bin/searchd(_Z12sphBacktraceib+0x22a)[0x56406d27d94a]
/usr/bin/searchd(_ZN11CrashLogger11HandleCrashEi+0x355)[0x56406d0fbd55]
/lib64/libpthread.so.0(+0x12cf0)[0x7feac8840cf0]
/usr/bin/searchd(_ZNK22Filter_RangeColumnar_TIlLb1ELb0ELb1ELb0EE4EvalERK9CSphMatch+0xa)[0x56406dfd513a]
/usr/bin/searchd(_ZN22CSphKBufferGroupSorterI16MatchGeneric1_fn13UniqGrouped_TI21ValueWithGroupCount_tELi0ELb0ELb1EE7FlattenEP9CSphMatch+0x208)[0x56406d361918]
/usr/bin/searchd(_ZN14OneResultset_t14FillFromSorterEP15ISphMatchSorter+0x98)[0x56406d1088e8]
/usr/bin/searchd(_Z18MinimizeAggrResultR12AggrResult_tRK9CSphQuerybRKN3sph9StringSetEP14QueryProfile_cPK18CSphFilterSettingsbb+0x580b)[0x56406d10e63b]
/usr/bin/searchd(_ZN15SearchHandler_c9RunSubsetEii+0x1324)[0x56406d114464]
/usr/bin/searchd(_ZN15SearchHandler_c10RunQueriesEv+0xd4)[0x56406d110124]
/usr/bin/searchd(_Z17HandleMysqlSelectR11RowBuffer_iR15SearchHandler_c+0x14f)[0x56406d13623f]
/usr/bin/searchd(_ZN15ClientSession_c7ExecuteESt4pairIPKciER11RowBuffer_i+0xeb6)[0x56406d145e96]
/usr/bin/searchd(_Z20ProcessSqlQueryBuddySt4pairIPKciERhR21GenericOutputBuffer_c+0x52)[0x56406d0a3372]
/usr/bin/searchd(_Z8SqlServeSt10unique_ptrI16AsyncNetBuffer_cSt14default_deleteIS0_EE+0x106e)[0x56406d088a5e]
/usr/bin/searchd(_Z10MultiServeSt10unique_ptrI16AsyncNetBuffer_cSt14default_deleteIS0_EESt4pairIitE7Proto_e+0x43)[0x56406d084813]
/usr/bin/searchd(+0xde83c2)[0x56406d0853c2]
/usr/bin/searchd(_ZZN7Threads11CoRoutine_c13CreateContextESt8functionIFvvEESt4pairIN5boost7context13stack_contextENS_14StackFlavour_EEEENUlNS6_6detail10transfer_tEE_8__invokeESB_+0x1c)[0x56406e3cbc1c]
/usr/bin/searchd(make_fcontext+0x2f)[0x56406e3ec4af]
Trying boost backtrace:
 0# sphBacktrace(int, bool) in /usr/bin/searchd
 1# CrashLogger::HandleCrash(int) in /usr/bin/searchd
 2# 0x00007FEAC8840CF0 in /lib64/libpthread.so.0
 3# Filter_RangeColumnar_T<long, true, false, true, false>::Eval(CSphMatch const&) const in /usr/bin/searchd
 4# CSphKBufferGroupSorter<MatchGeneric1_fn, UniqGrouped_T<ValueWithGroupCount_t>, 0, false, true>::Flatten(CSphMatch*) in /usr/bin/searchd
 5# OneResultset_t::FillFromSorter(ISphMatchSorter*) in /usr/bin/searchd
 6# MinimizeAggrResult(AggrResult_t&, CSphQuery const&, bool, sph::StringSet const&, QueryProfile_c*, CSphFilterSettings const*, bool, bool) in /usr/bin/searchd
 7# SearchHandler_c::RunSubset(int, int) in /usr/bin/searchd
 8# SearchHandler_c::RunQueries() in /usr/bin/searchd
 9# HandleMysqlSelect(RowBuffer_i&, SearchHandler_c&) in /usr/bin/searchd
10# ClientSession_c::Execute(std::pair<char const*, int>, RowBuffer_i&) in /usr/bin/searchd
11# ProcessSqlQueryBuddy(std::pair<char const*, int>, unsigned char&, GenericOutputBuffer_c&) in /usr/bin/searchd
12# SqlServe(std::unique_ptr<AsyncNetBuffer_c, std::default_delete<AsyncNetBuffer_c> >) in /usr/bin/searchd
13# MultiServe(std::unique_ptr<AsyncNetBuffer_c, std::default_delete<AsyncNetBuffer_c> >, std::pair<int, unsigned short>, Proto_e) in /usr/bin/searchd
14# 0x000056406D0853C2 in /usr/bin/searchd
15# Threads::CoRoutine_c::CreateContext(std::function<void ()>, std::pair<boost::context::stack_context, Threads::StackFlavour_E>)::{lambda(boost::context::detail::transfer_t)#1}::__invoke(boost::context::detail::transfer_t) in /usr/bin/searchd
16# make_fcontext in /usr/bin/searchd

-------------- backtrace ends here ---------------
@tomatolog
Copy link
Contributor

could you check your conversationv2 index with indextool?

then upload it if the check passed well? I'd like to reproduce this crash locally

@mangareader
Copy link
Author 

Manticore 6.2.12 dc5144d35@230822 (columnar 2.2.4 5aec342@230822) (secondary 2.2.4 5aec342@230822)
Copyright (c) 2001-2016, Andrew Aksyonoff
Copyright (c) 2008-2016, Sphinx Technologies Inc (http://sphinxsearch.com)
Copyright (c) 2017-2023, Manticore Software LTD (https://manticoresearch.com)

using config file '/etc/manticoresearch/manticore.conf'...
checking table 'conversationv2'...
WARNING: failed to load RAM chunks, checking only 26 disk chunks
checking schema...
checking disk chunk, extension 3494, 0(26)...
checking schema...
checking dictionary...
checking data...
checking rows...
checking attribute blocks index...
checking columnar storage...
checking kill-list...
checking docstore...
checking dead row map...
checking doc-id lookup...
check passed, 19.0 sec elapsed
checking disk chunk, extension 3540, 1(26)...
checking schema...
checking dictionary...
checking data...
checking rows...
checking attribute blocks index...
checking columnar storage...
checking kill-list...
checking docstore...
checking dead row map...
checking doc-id lookup...
check passed, 38.7 sec elapsed
checking disk chunk, extension 3564, 2(26)...
checking schema...
checking dictionary...
checking data...
checking rows...
checking attribute blocks index...
checking columnar storage...
checking kill-list...
checking docstore...
checking dead row map...
checking doc-id lookup...
check passed, 58.4 sec elapsed
checking disk chunk, extension 3589, 3(26)...
checking schema...
checking dictionary...
checking data...
checking rows...
checking attribute blocks index...
checking columnar storage...
checking kill-list...
checking docstore...
checking dead row map...
checking doc-id lookup...
check passed, 78.5 sec elapsed
checking disk chunk, extension 3616, 4(26)...
checking schema...
checking dictionary...
checking data...
checking rows...
checking attribute blocks index...
checking columnar storage...
checking kill-list...
checking docstore...
checking dead row map...
checking doc-id lookup...
check passed, 98.7 sec elapsed
checking disk chunk, extension 3816, 5(26)...
checking schema...
checking dictionary...
checking data...
checking rows...
checking attribute blocks index...
checking columnar storage...
checking kill-list...
checking docstore...
checking dead row map...
checking doc-id lookup...
check passed, 118.8 sec elapsed
checking disk chunk, extension 3838, 6(26)...
checking schema...
checking dictionary...
checking data...
checking rows...
checking attribute blocks index...
checking columnar storage...
checking kill-list...
checking docstore...
checking dead row map...
checking doc-id lookup...
check passed, 139.7 sec elapsed
checking disk chunk, extension 3860, 7(26)...
checking schema...
checking dictionary...
checking data...
checking rows...
checking attribute blocks index...
checking columnar storage...
checking kill-list...
checking docstore...
checking dead row map...
checking doc-id lookup...
check passed, 160.7 sec elapsed
checking disk chunk, extension 3887, 8(26)...
checking schema...
checking dictionary...
checking data...
checking rows...
checking attribute blocks index...
checking columnar storage...
checking kill-list...
checking docstore...
checking dead row map...
checking doc-id lookup...
check passed, 182.3 sec elapsed
checking disk chunk, extension 3912, 9(26)...
checking schema...
checking dictionary...
checking data...
checking rows...
checking attribute blocks index...
checking columnar storage...
checking kill-list...
checking docstore...
checking dead row map...
checking doc-id lookup...
check passed, 204.1 sec elapsed
checking disk chunk, extension 3944, 10(26)...
checking schema...
checking dictionary...
checking data...
checking rows...
checking attribute blocks index...
checking columnar storage...
checking kill-list...
checking docstore...
checking dead row map...
checking doc-id lookup...
check passed, 226.2 sec elapsed
checking disk chunk, extension 3969, 11(26)...
checking schema...
checking dictionary...
checking data...
checking rows...
checking attribute blocks index...
checking columnar storage...
checking kill-list...
checking docstore...
checking dead row map...
checking doc-id lookup...
check passed, 248.0 sec elapsed
checking disk chunk, extension 4516, 12(26)...
checking schema...
checking dictionary...
checking data...
checking rows...
checking attribute blocks index...
checking columnar storage...
checking kill-list...
checking docstore...
checking dead row map...
checking doc-id lookup...
check passed, 268.0 sec elapsed
checking disk chunk, extension 4538, 13(26)...
checking schema...
checking dictionary...
checking data...
checking rows...
checking attribute blocks index...
checking columnar storage...
checking kill-list...
checking docstore...
checking dead row map...
checking doc-id lookup...
check passed, 289.0 sec elapsed
checking disk chunk, extension 4559, 14(26)...
checking schema...
checking dictionary...
checking data...
checking rows...
checking attribute blocks index...
checking columnar storage...
checking kill-list...
checking docstore...
checking dead row map...
checking doc-id lookup...
check passed, 310.6 sec elapsed
checking disk chunk, extension 4579, 15(26)...
checking schema...
checking dictionary...
checking data...
checking rows...
checking attribute blocks index...
checking columnar storage...
checking kill-list...
checking docstore...
checking dead row map...
checking doc-id lookup...
check passed, 331.9 sec elapsed
checking disk chunk, extension 4598, 16(26)...
checking schema...
checking dictionary...
checking data...
checking rows...
checking attribute blocks index...
checking columnar storage...
checking kill-list...
checking docstore...
checking dead row map...
checking doc-id lookup...
check passed, 352.9 sec elapsed
checking disk chunk, extension 4620, 17(26)...
checking schema...
checking dictionary...
checking data...
checking rows...
checking attribute blocks index...
checking columnar storage...
FAILED,
Header offset out of bounds: -2082922978
checking kill-list...
checking docstore...
checking dead row map...
checking doc-id lookup...
check FAILED, 1 failures reported, 372.5 sec elapsed
checking disk chunk, extension 4643, 18(26)...
checking schema...
checking dictionary...
checking data...
checking rows...
checking attribute blocks index...
checking columnar storage...
FAILED,
Header offset out of bounds: -2142943267
checking kill-list...
checking docstore...
checking dead row map...
checking doc-id lookup...
check FAILED, 2 failures reported, 391.9 sec elapsed
checking disk chunk, extension 4662, 19(26)...
checking schema...
checking dictionary...
checking data...
checking rows...
checking attribute blocks index...
checking columnar storage...
checking kill-list...
checking docstore...
checking dead row map...
checking doc-id lookup...
check FAILED, 2 failures reported, 413.4 sec elapsed
checking disk chunk, extension 4684, 20(26)...
checking schema...
checking dictionary...
checking data...
checking rows...
checking attribute blocks index...
checking columnar storage...
FAILED,
Header offset out of bounds: -2102073895
checking kill-list...
checking docstore...
checking dead row map...
checking doc-id lookup...
check FAILED, 3 failures reported, 433.1 sec elapsed
checking disk chunk, extension 4704, 21(26)...
checking schema...
checking dictionary...
checking data...
checking rows...
checking attribute blocks index...
checking columnar storage...
checking kill-list...
checking docstore...
checking dead row map...
checking doc-id lookup...
check FAILED, 3 failures reported, 454.5 sec elapsed
checking disk chunk, extension 4726, 22(26)...
checking schema...
checking dictionary...
checking data...
checking rows...
checking attribute blocks index...
checking columnar storage...
checking kill-list...
checking docstore...
checking dead row map...
checking doc-id lookup...
check FAILED, 3 failures reported, 476.2 sec elapsed
checking disk chunk, extension 4746, 23(26)...
checking schema...
checking dictionary...
checking data...
checking rows...
checking attribute blocks index...
checking columnar storage...
checking kill-list...
checking docstore...
checking dead row map...
checking doc-id lookup...
check FAILED, 3 failures reported, 498.3 sec elapsed
checking disk chunk, extension 4759, 24(26)...
checking schema...
checking dictionary...
checking data...
checking rows...
checking attribute blocks index...
checking columnar storage...
checking kill-list...
checking docstore...
checking dead row map...
checking doc-id lookup...
check FAILED, 3 failures reported, 520.1 sec elapsed
checking disk chunk, extension 4758, 25(26)...
checking schema...
checking dictionary...
checking data...
checking rows...
checking attribute blocks index...
checking columnar storage...
checking kill-list...
checking docstore...
checking dead row map...
checking doc-id lookup...
check FAILED, 3 failures reported, 520.5 sec elapsed
check FAILED, 3 failures reported, 520.5 sec elapsed

@sanikolaev
Copy link
Collaborator

@mangareader can you please share your table files and config to our write-only S3 storage (https://manual.manticoresearch.com/Reporting_bugs#Uploading-your-data) ?

@sanikolaev sanikolaev added the waiting Waiting for the original poster (in most cases) or something else label Oct 19, 2023
@mangareader
Copy link
Author

@sanikolaev i can not share my table files

searchd {
    listen = 0.0.0.0:9312
    listen = 0.0.0.0:9306:mysql
    listen = 0.0.0.0:9308:http
    log = /var/log/manticore/searchd.log
    query_log = /var/log/manticore/query.log
    pid_file = /run/manticore/searchd.pid
    data_dir = /var/lib/manticore
}

@sanikolaev
Copy link
Collaborator

@mangareader What's the schema of the table? Can you run show create table conversationv2 and select count(*) from conversationv2?

@mangareader
Copy link
Author

mangareader commented Oct 20, 2023 •
edited
Loading

@sanikolaev

--- schema:
CREATE TABLE conversationv2 (
    id bigint,
    snippet text,
    channelid integer,
    type integer,
    status integer,
    unreadmessagecount integer,
    assigneeaccountid bigint,
    participantordercount bigint,
    participantidnumber bigint,
    createdtime bigint,
    updatedtime bigint,
    messagecount bigint,
    remindertime bigint,
    readedtime bigint,
    lastupdateddate bigint,
    orgcontextid bigint,
    hcustomerid bigint,
    iscreated bool,
    isdeleted bool,
    issystemdeleted bool,
    snapshot bool,
    isanswerfrompage bool,
    isstopping bool,
    isunreaded bool,
    isopened bool,
    islive bool,
    issubscribed bool,
    canreply bool,
    ismarkdone bool,
    ismarkspam bool,
    issnooze bool,
    hasmessagescontainphone bool,
    isanswerbypage bool,
    isdeleteconversation bool,
    pageid string attribute,
    socialid string attribute,
    dbid string attribute,
    objectid string attribute,
    participantid string attribute,
    channelandpage string attribute,
    convtags json,
    conversationtags json,
    tags json,
    socialadids json
) min_infix_len='3' engine='columnar'

count(*): 683745951

@sanikolaev
Copy link
Collaborator

Thanks. Can you provide a sample document or a few which I can use to build a table similar to yours?

@mangareader
Copy link
Author

@sanikolaev

[
  {
    "id": 939111922602476327,
    "snippet": "Ella Le ơi Shop đã gửi tin cho bạn bạn kiểm tra tin nhắn nhé",
    "channelid": 1,
    "type": 3,
    "status": 4,
    "unreadmessagecount": 0,
    "assigneeaccountid": 0,
    "participantordercount": 0,
    "participantidnumber": 6374292122644105,
    "createdtime": 637873375590000000,
    "updatedtime": 637873375670000000,
    "messagecount": 1,
    "remindertime": 0,
    "readedtime": 637873375739360000,
    "lastupdateddate": 637873375670000000,
    "orgcontextid": 1000360501,
    "hcustomerid": 1053494073,
    "iscreated": 0,
    "isdeleted": 0,
    "issystemdeleted": 0,
    "snapshot": 1,
    "isanswerfrompage": 1,
    "isstopping": 0,
    "isunreaded": 0,
    "isopened": 0,
    "islive": 0,
    "issubscribed": 0,
    "canreply": 1,
    "ismarkdone": 0,
    "ismarkspam": 0,
    "issnooze": 0,
    "hasmessagescontainphone": 0,
    "isanswerbypage": 1,
    "isdeleteconversation": 0,
    "pageid": "386064158561988",
    "socialid": "1247816965720032_497318382138243",
    "dbid": "6273905d03df988447820bae",
    "objectid": "386064158561988_1247816965720032",
    "participantid": "6374292122644105",
    "channelandpage": "fb-386064158561988",
    "convtags": "{\"data\":null}",
    "conversationtags": null,
    "tags": null,
    "socialadids": "{\"data\":null}"
  },
  {
    "id": 939111922754127419,
    "snippet": "0909 253 128",
    "channelid": 1,
    "type": 2,
    "status": 1,
    "unreadmessagecount": 0,
    "assigneeaccountid": 0,
    "participantordercount": 384,
    "participantidnumber": 3097824493646948,
    "createdtime": 637304827900000000,
    "updatedtime": 638325039600000000,
    "messagecount": 2967,
    "remindertime": 0,
    "readedtime": 638325039672070000,
    "lastupdateddate": 638325039600000000,
    "orgcontextid": 1000360501,
    "hcustomerid": 1079634138,
    "iscreated": 0,
    "isdeleted": 0,
    "issystemdeleted": 0,
    "snapshot": 0,
    "isanswerfrompage": 0,
    "isstopping": 0,
    "isunreaded": 0,
    "isopened": 0,
    "islive": 0,
    "issubscribed": 1,
    "canreply": 1,
    "ismarkdone": 0,
    "ismarkspam": 0,
    "issnooze": 0,
    "hasmessagescontainphone": 1,
    "isanswerbypage": 0,
    "isdeleteconversation": 0,
    "pageid": "386064158561988",
    "socialid": "t_4193887594015272",
    "dbid": "5f100769c71aee2d41bbda26",
    "objectid": "",
    "participantid": "3097824493646948",
    "channelandpage": "fb-386064158561988",
    "convtags": "{\"data\":[\"62382f4203df988447023f43\",\"5dd87a913a66d59b5fb7668e\",\"618e288103df98844755de29\",\"5f30257b19f4d00001afb0c7\",\"5de5d2713a66d59b5fc1b163\",\"60546dd927df230001bfbc22\",\"6165091703df988447bcb224\",\"61c4bbf203df988447ed9452\",\"61967420286646e58f5302ae\",\"619624c456341e9cfe3bd045\",\"61c57d4a03df9884478fb3b6\",\"61373b9303df988447ea6fcc\",\"62466cf603df98844738e86c\",\"619624c156341e9cfe3bd041\",\"6194a6b50f4b1cab5fe8d399\",\"6138e43103df988447977167\",\"6135d581af12678b18c63496\",\"6135d5765e51706fbaf77daf\",\"612fa03f03df988447dd759e\",\"612f9fc603df988447dad243\",\"612f9fc203df988447dabd84\",\"62a7543eb8320bdfedce430f\",\"62a75465b8320bdfedcff2cd\",\"6141af50e053467d178e0776\",\"6168f3f903df988447e55c55\",\"6168f46103df988447eb941b\",\"62dc382ecbc66c9b8a39269c\",\"6196743c03df98844733f6da\",\"62d7abc0cbc66c9b8a42e11a\",\"62cfcb8d30ab67aa351b980a\",\"62cfcb8d30ab67aa351b980c\",\"62c6f86230ab67aa3558d312\",\"62cfcb8d30ab67aa351b9809\",\"62c6fbcb30ab67aa3577a256\",\"62a70ec7b8320bdfedde7959\",\"62a70669b8320bdfed842e63\",\"61962651d836b598bd918df5\",\"61c4bb8f03df988447eceb31\",\"6375db9ecbc66c9b8a840b05\",\"6169099059387fc11ed42299\",\"63919bfdc15b5fc0eb80d74c\"]}",
    "conversationtags": null,
    "tags": null,
    "socialadids": "{\"data\":null}"
  },
  {
    "id": 939111922548035751,
    "snippet": "đ",
    "channelid": 1,
    "type": 3,
    "status": 1,
    "unreadmessagecount": 0,
    "assigneeaccountid": 0,
    "participantordercount": 0,
    "participantidnumber": 3097824493646948,
    "createdtime": 637873635740000000,
    "updatedtime": 637873635740000000,
    "messagecount": 0,
    "remindertime": 0,
    "readedtime": 637873635803580000,
    "lastupdateddate": 637873635740000000,
    "orgcontextid": 1000360501,
    "hcustomerid": 1079634138,
    "iscreated": 0,
    "isdeleted": 0,
    "issystemdeleted": 0,
    "snapshot": 1,
    "isanswerfrompage": 1,
    "isstopping": 0,
    "isunreaded": 0,
    "isopened": 0,
    "islive": 0,
    "issubscribed": 0,
    "canreply": 1,
    "ismarkdone": 1,
    "ismarkspam": 0,
    "issnooze": 0,
    "hasmessagescontainphone": 0,
    "isanswerbypage": 0,
    "isdeleteconversation": 0,
    "pageid": "386064158561988",
    "socialid": "1341985042969890_1348401058994955",
    "dbid": "6273f5fb03df9884474b32d6",
    "objectid": "386064158561988_1341985042969890",
    "participantid": "3097824493646948",
    "channelandpage": "fb-386064158561988",
    "convtags": "{\"data\":[\"62382f4203df988447023f43\"]}",
    "conversationtags": null,
    "tags": null,
    "socialadids": "{\"data\":null}"
  },
  {
    "id": 939103038812502659,
    "snippet": "chào bạn",
    "channelid": 1,
    "type": 3,
    "status": 1,
    "unreadmessagecount": 0,
    "assigneeaccountid": 0,
    "participantordercount": 0,
    "participantidnumber": 2819971314790373,
    "createdtime": 637225409440000000,
    "updatedtime": 637225409440000000,
    "messagecount": 0,
    "remindertime": 0,
    "readedtime": 637413782421700000,
    "lastupdateddate": 637225409440000000,
    "orgcontextid": 0,
    "hcustomerid": 0,
    "iscreated": 0,
    "isdeleted": 0,
    "issystemdeleted": 0,
    "snapshot": 1,
    "isanswerfrompage": 0,
    "isstopping": 0,
    "isunreaded": 0,
    "isopened": 0,
    "islive": 0,
    "issubscribed": 0,
    "canreply": 1,
    "ismarkdone": 0,
    "ismarkspam": 0,
    "issnooze": 0,
    "hasmessagescontainphone": 0,
    "isanswerbypage": 0,
    "isdeleteconversation": 0,
    "pageid": "386064158561988",
    "socialid": "843723479462718_845758185925914",
    "dbid": "5e96d8933a4365f7f927fec3",
    "objectid": "386064158561988_843723479462718",
    "participantid": "2819971314790373",
    "channelandpage": "fb-386064158561988",
    "convtags": "{\"data\":[]}",
    "conversationtags": null,
    "tags": null,
    "socialadids": "{\"data\":null}"
  },
  {
    "id": 939103038699371194,
    "snippet": "A304",
    "channelid": 1,
    "type": 3,
    "status": 1,
    "unreadmessagecount": 0,
    "assigneeaccountid": 0,
    "participantordercount": 0,
    "participantidnumber": 3103361803078791,
    "createdtime": 638303733310000000,
    "updatedtime": 638303733310000000,
    "messagecount": 0,
    "remindertime": 0,
    "readedtime": 0,
    "lastupdateddate": 638303733310000000,
    "orgcontextid": 1000360501,
    "hcustomerid": 1034443057,
    "iscreated": 1,
    "isdeleted": 0,
    "issystemdeleted": 0,
    "snapshot": 0,
    "isanswerfrompage": 0,
    "isstopping": 0,
    "isunreaded": 1,
    "isopened": 0,
    "islive": 1,
    "issubscribed": 0,
    "canreply": 1,
    "ismarkdone": 0,
    "ismarkspam": 0,
    "issnooze": 0,
    "hasmessagescontainphone": 0,
    "isanswerbypage": 0,
    "isdeleteconversation": 0,
    "pageid": "386064158561988",
    "socialid": "2987632974702303_742200094383649",
    "dbid": "65043cda897efc4577d491f0",
    "objectid": "386064158561988_2987632974702303",
    "participantid": "3103361803078791",
    "channelandpage": "fb-386064158561988",
    "convtags": "{\"data\":[]}",
    "conversationtags": null,
    "tags": null,
    "socialadids": "{\"data\":null}"
  },
  {
    "id": 939103038863191835,
    "snippet": "Xin chào Hùng Lương ️",
    "channelid": 1,
    "type": 2,
    "status": 4,
    "unreadmessagecount": 3,
    "assigneeaccountid": 0,
    "participantordercount": 0,
    "participantidnumber": 3133095206786486,
    "createdtime": 637322784470000000,
    "updatedtime": 637357650140000000,
    "messagecount": 11,
    "remindertime": 0,
    "readedtime": 637510607118820000,
    "lastupdateddate": 637357650140000000,
    "orgcontextid": 1000360501,
    "hcustomerid": 0,
    "iscreated": 0,
    "isdeleted": 0,
    "issystemdeleted": 0,
    "snapshot": 1,
    "isanswerfrompage": 1,
    "isstopping": 0,
    "isunreaded": 0,
    "isopened": 0,
    "islive": 0,
    "issubscribed": 1,
    "canreply": 1,
    "ismarkdone": 0,
    "ismarkspam": 0,
    "issnooze": 0,
    "hasmessagescontainphone": 0,
    "isanswerbypage": 1,
    "isdeleteconversation": 0,
    "pageid": "386064158561988",
    "socialid": "t_3297996793618054",
    "dbid": "5f2b6db08cba61fa541a69f5",
    "objectid": "",
    "participantid": "3133095206786486",
    "channelandpage": "fb-386064158561988",
    "convtags": "{\"data\":[\"61373b9303df988447ea6fcc\",\"5f3f70398cba61fa54a2e98f\",\"5f1b93ea277cdf41629505d8\",\"5ecce37abea9a700017cea9f\",\"62a219c1b8320bdfed636825\",\"62a7543eb8320bdfedce430f\",\"62a75465b8320bdfedcff2cd\",\"62dc382ecbc66c9b8a39269c\"]}",
    "conversationtags": null,
    "tags": null,
    "socialadids": "{\"data\":null}"
  },
  {
    "id": 939111922602495926,
    "snippet": "Daily Test áo xấu mà giá chát quá vậy shop",
    "channelid": 1,
    "type": 3,
    "status": 1,
    "unreadmessagecount": 0,
    "assigneeaccountid": 0,
    "participantordercount": 0,
    "participantidnumber": 4912274065518156,
    "createdtime": 637825292320000000,
    "updatedtime": 637825292730000000,
    "messagecount": 2,
    "remindertime": 0,
    "readedtime": 637825637750960000,
    "lastupdateddate": 637825292730000000,
    "orgcontextid": 1000360501,
    "hcustomerid": 0,
    "iscreated": 0,
    "isdeleted": 0,
    "issystemdeleted": 0,
    "snapshot": 1,
    "isanswerfrompage": 0,
    "isstopping": 1,
    "isunreaded": 0,
    "isopened": 0,
    "islive": 0,
    "issubscribed": 0,
    "canreply": 1,
    "ismarkdone": 0,
    "ismarkspam": 0,
    "issnooze": 0,
    "hasmessagescontainphone": 0,
    "isanswerbypage": 0,
    "isdeleteconversation": 0,
    "pageid": "386064158561988",
    "socialid": "1247816965720032_1311440432691018",
    "dbid": "622a31d503df988447cf8fbf",
    "objectid": "386064158561988_1247816965720032",
    "participantid": "4912274065518156",
    "channelandpage": "fb-386064158561988",
    "convtags": "{\"data\":[\"602c8bd8d75ce400012565bc\"]}",
    "conversationtags": null,
    "tags": null,
    "socialadids": "{\"data\":null}"
  },
  {
    "id": 939111571035217818,
    "snippet": "4",
    "channelid": 1,
    "type": 3,
    "status": 1,
    "unreadmessagecount": 0,
    "assigneeaccountid": 0,
    "participantordercount": 0,
    "participantidnumber": 2293292127465736,
    "createdtime": 637342034440000000,
    "updatedtime": 637342034440000000,
    "messagecount": 0,
    "remindertime": 0,
    "readedtime": 637413782421700000,
    "lastupdateddate": 637342034440000000,
    "orgcontextid": 1000360501,
    "hcustomerid": 1025354075,
    "iscreated": 0,
    "isdeleted": 0,
    "issystemdeleted": 0,
    "snapshot": 1,
    "isanswerfrompage": 0,
    "isstopping": 0,
    "isunreaded": 0,
    "isopened": 0,
    "islive": 0,
    "issubscribed": 0,
    "canreply": 1,
    "ismarkdone": 0,
    "ismarkspam": 0,
    "issnooze": 0,
    "hasmessagescontainphone": 0,
    "isanswerbypage": 0,
    "isdeleteconversation": 0,
    "pageid": "386064158561988",
    "socialid": "941454503022948_941454993022899",
    "dbid": "5f48cd378cba61fa54d5e6db",
    "objectid": "386064158561988_941454503022948",
    "participantid": "2293292127465736",
    "channelandpage": "fb-386064158561988",
    "convtags": "{\"data\":null}",
    "conversationtags": null,
    "tags": null,
    "socialadids": "{\"data\":null}"
  },
  {
    "id": 939111571035217820,
    "snippet": "9",
    "channelid": 1,
    "type": 3,
    "status": 1,
    "unreadmessagecount": 0,
    "assigneeaccountid": 0,
    "participantordercount": 0,
    "participantidnumber": 2293292127465736,
    "createdtime": 637342034470000000,
    "updatedtime": 637342034470000000,
    "messagecount": 0,
    "remindertime": 0,
    "readedtime": 637413782421700000,
    "lastupdateddate": 637342034470000000,
    "orgcontextid": 1000360501,
    "hcustomerid": 1025354075,
    "iscreated": 0,
    "isdeleted": 0,
    "issystemdeleted": 0,
    "snapshot": 1,
    "isanswerfrompage": 0,
    "isstopping": 0,
    "isunreaded": 0,
    "isopened": 0,
    "islive": 0,
    "issubscribed": 0,
    "canreply": 1,
    "ismarkdone": 0,
    "ismarkspam": 0,
    "issnooze": 0,
    "hasmessagescontainphone": 0,
    "isanswerbypage": 0,
    "isdeleteconversation": 0,
    "pageid": "386064158561988",
    "socialid": "941454503022948_941455036356228",
    "dbid": "5f48cd3a8cba61fa54d60229",
    "objectid": "386064158561988_941454503022948",
    "participantid": "2293292127465736",
    "channelandpage": "fb-386064158561988",
    "convtags": "{\"data\":null}",
    "conversationtags": null,
    "tags": null,
    "socialadids": "{\"data\":null}"
  },
  {
    "id": 939111571035217835,
    "snippet": "zz",
    "channelid": 1,
    "type": 3,
    "status": 1,
    "unreadmessagecount": 0,
    "assigneeaccountid": 0,
    "participantordercount": 0,
    "participantidnumber": 2293292127465736,
    "createdtime": 637342035430000000,
    "updatedtime": 637342035430000000,
    "messagecount": 0,
    "remindertime": 0,
    "readedtime": 637413782421700000,
    "lastupdateddate": 637342035430000000,
    "orgcontextid": 1000360501,
    "hcustomerid": 1025354075,
    "iscreated": 0,
    "isdeleted": 0,
    "issystemdeleted": 0,
    "snapshot": 1,
    "isanswerfrompage": 0,
    "isstopping": 0,
    "isunreaded": 0,
    "isopened": 0,
    "islive": 0,
    "issubscribed": 0,
    "canreply": 1,
    "ismarkdone": 0,
    "ismarkspam": 0,
    "issnooze": 0,
    "hasmessagescontainphone": 0,
    "isanswerbypage": 0,
    "isdeleteconversation": 0,
    "pageid": "386064158561988",
    "socialid": "898636877304711_941456169689448",
    "dbid": "5f48cd9a8cba61fa54d97436",
    "objectid": "386064158561988_898636877304711",
    "participantid": "2293292127465736",
    "channelandpage": "fb-386064158561988",
    "convtags": "{\"data\":null}",
    "conversationtags": null,
    "tags": null,
    "socialadids": "{\"data\":null}"
  }
]

@tomatolog tomatolog self-assigned this Oct 25, 2023
@tomatolog
Copy link
Contributor

I reproduced the crash on data you provided. I will inform you on fix

@sanikolaev sanikolaev removed the waiting Waiting for the original poster (in most cases) or something else label Oct 25, 2023
tomatolog added a commit that referenced this issue Oct 27, 2023
@tomatolog
fixed crash on aggregate to columnar attribute used in having; added …
c0b3614 
…case to test 430; fixed Github #1510
@tomatolog
Copy link
Contributor

the crash just fixed at c0b3614

@sanikolaev sanikolaev added bug rel::upcoming Upcoming release labels Oct 27, 2023
@sanikolaev sanikolaev added rel::6.3.0 Released in 6.3.0 and removed rel::upcoming Upcoming release labels May 23, 2024
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees

@tomatolog tomatolog

Labels
bug rel::6.3.0 Released in 6.3.0
Projects
None yet
Milestone
No milestone
Development

No branches or pull requests
3 participants
@tomatolog @mangareader @sanikolaev