markus makela added a comment - 2025-03-21 06:28 This appears to be a watchdog timeout and the only thread that's active is this one. Thread 162 (Thread 0x7f93cf7ae700 (LWP 2020893)): #0 0x00007f9526298ed7 in __strncasecmp_l_avx () from /lib64/libc.so.6 #1 0x00007f9520095d50 in _ZN7maxbase10sv_case_eqESt17basic_string_viewIcSt11char_traitsIcEES3_ (rhs=..., lhs=...) at /home/timofey_turenko_mariadb_com/MaxScale/maxutils/maxbase/include/maxbase/string.hh:105 #2 _ZN12PpSqliteInfo14MatchFieldNameIN8maxscale6Parser9FieldInfoEEclERKS3_ (t=..., this=0x7f93cf7a99e0) at /home/timofey_turenko_mariadb_com/MaxScale/server/modules/parser_plugin/pp_sqlite/pp_sqlite.cc:574 #3 _ZN9__gnu_cxx5__ops10_Iter_predIN12PpSqliteInfo14MatchFieldNameIN8maxscale6Parser9FieldInfoEEEEclINS_17__normal_iteratorIPS6_St6vectorIS6_SaIS6_EEEEEEbT_ (__it=..., this=0x7f93cf7a99e0) at /usr/include/c++/8/bits/predefined_ops.h:283 #4 _ZSt9__find_ifIN9__gnu_cxx17__normal_iteratorIPN8maxscale6Parser9FieldInfoESt6vectorIS4_SaIS4_EEEENS0_5__ops10_Iter_predIN12PpSqliteInfo14MatchFieldNameIS4_EEEEET_SG_SG_T0_St26random_access_iterator_tag.constprop.101 (__first=..., __last=..., __pred=...) at /usr/include/c++/8/bits/stl_algo.h:120 #5 0x00007f952012c085 in std::__find_if<__gnu_cxx::__normal_iterator<maxscale::Parser::FieldInfo*, std::vector<maxscale::Parser::FieldInfo, std::allocator<maxscale::Parser::FieldInfo> > >, __gnu_cxx::__ops::_Iter_pred<PpSqliteInfo::MatchFieldName<maxscale::Parser::FieldInfo> > > (__pred=..., __last=..., __first=...) at /usr/include/c++/8/bits/stl_algo.h:159 #6 std::find_if<__gnu_cxx::__normal_iterator<maxscale::Parser::FieldInfo*, std::vector<maxscale::Parser::FieldInfo, std::allocator<maxscale::Parser::FieldInfo> > >, PpSqliteInfo::MatchFieldName<maxscale::Parser::FieldInfo> > (__pred=..., __last=..., __first=...) at /usr/include/c++/8/bits/stl_algo.h:3930 #7 PpSqliteInfo::update_function_fields (fields=..., zColumn=<optimized out>, zTable=<optimized out>, zDatabase=<optimized out>, pAliases=<optimized out>, this=<optimized out>) at /home/timofey_turenko_mariadb_com/MaxScale/server/modules/parser_plugin/pp_sqlite/pp_sqlite.cc:1432 #8 PpSqliteInfo::update_function_fields (fields=..., pExclude=0x7f949c0278d8, pExpr=<optimized out>, pAliases=0x7f93cf7a9d90, this=0x7f949c02c130) at /home/timofey_turenko_mariadb_com/MaxScale/server/modules/parser_plugin/pp_sqlite/pp_sqlite.cc:1471 #9 PpSqliteInfo::update_function_fields (pEList=<optimized out>, pEList=<optimized out>, fields=..., pExclude=<optimized out>, pAliases=<optimized out>, this=<optimized out>) at /home/timofey_turenko_mariadb_com/MaxScale/server/modules/parser_plugin/pp_sqlite/pp_sqlite.cc:1485 #10 PpSqliteInfo::update_function_info (this=this@entry=0x7f949c02c130, pAliases=pAliases@entry=0x7f93cf7a9d90, zName=<optimized out>, zName@entry=0x7f952013d659 "in", pExpr=pExpr@entry=0x0, pEList=<optimized out>, pExclude=pExclude@entry=0x7f949c0278d8) at /home/timofey_turenko_mariadb_com/MaxScale/server/modules/parser_plugin/pp_sqlite/pp_sqlite.cc:1548 #11 0x00007f952012da7e in PpSqliteInfo::update_function_info (pExclude=0x7f949c0278d8, pEList=<optimized out>, name=0x7f952013d659 "in", pAliases=0x7f93cf7a9d90, this=0x7f949c02c130) at /home/timofey_turenko_mariadb_com/MaxScale/server/modules/parser_plugin/pp_sqlite/pp_sqlite.cc:1577 #12 PpSqliteInfo::update_field_infos (this=<optimized out>, pAliases=<optimized out>, context=<optimized out>, prev_token=<optimized out>, pExpr=<optimized out>, pos=<optimized out>, pExclude=<optimized out>, ignore_assignment=<optimized out>, this=<optimized out>, prev_token=<optimized out>, pos=<optimized out>, pAliases=<optimized out>, context=<optimized out>, pExpr=<optimized out>, pExclude=<optimized out>, ignore_assignment=<optimized out>) at /home/timofey_turenko_mariadb_com/MaxScale/server/modules/parser_plugin/pp_sqlite/pp_sqlite.cc:1086 #13 0x00007f952012e3c6 in PpSqliteInfo::update_field_infos_from_select (this=0x7f949c02c130, aliases=..., context=0, pSelect=0x7f949d3ac148, pExclude=0x0, compound_approach=PpSqliteInfo::ANALYZE_COMPOUND_SELECTS, ignore_assignment=false) at /home/timofey_turenko_mariadb_com/MaxScale/server/modules/parser_plugin/pp_sqlite/pp_sqlite.cc:1295 #14 0x00007f952009b4e2 in _ZN12PpSqliteInfo29maxscaleCollectInfoFromSelectEP5ParseP6Selecti (pParse=<optimized out>, sub_select=0, pSelect=0x7f949d3ac148, this=0x7f949c02c130) at /home/timofey_turenko_mariadb_com/MaxScale/server/modules/parser_plugin/pp_sqlite/pp_sqlite.cc:2091 #15 _ZN12PpSqliteInfo17mxs_sqlite3SelectEP5ParseP6SelectP10SelectDest (pDest=<optimized out>, p=0x7f949d3ac148, pParse=<optimized out>, this=0x7f949c02c130) at /home/timofey_turenko_mariadb_com/MaxScale/server/modules/parser_plugin/pp_sqlite/pp_sqlite.cc:1963 #16 mxs_sqlite3Select.constprop.43 (pParse=<optimized out>, p=0x7f949d3ac148, pDest=<optimized out>) at /home/timofey_turenko_mariadb_com/MaxScale/server/modules/parser_plugin/pp_sqlite/pp_sqlite.cc:4349 #17 0x00007f95200aad9c in yy_reduce (yyruleno=182, yypParser=0x7f949c06cd08) at /home/timofey_turenko_mariadb_com/_build/sqlite-bld-3110100/sqlite3.c:132579 #18 sqlite3Parser (yyp=<optimized out>, yymajor=1, yyminor=..., pParse=<optimized out>) at /home/timofey_turenko_mariadb_com/_build/sqlite-bld-3110100/sqlite3.c:3818 #19 0x00007f95200b455b in sqlite3RunParser (pParse=0x7f949c017158, zSql=0x7f949c1600e8 "SET STATEMENT max_statement_time=30000, SQL_SELECT_LIMIT=200 FOR select username as ModelNickName, id as modelId, m.country \r\nfrom sa_production.members m \r\n-- limit 100\r\nwhere username in (\"\", \"Sazer"..., pzErrMsg=0x7f93cf7a9fe8) at /home/timofey_turenko_mariadb_com/_build/sqlite-bld-3110100/sqlite3.c:136349 #20 0x00007f95200cd9da in sqlite3Prepare (db=db@entry=0x7f949c019058, zSql=zSql@entry=0x7f949c886f35 "SET STATEMENT max_statement_time=30000, SQL_SELECT_LIMIT=200 FOR select username as ModelNickName, id as modelId, m.country \r\nfrom sa_production.members m \r\n-- limit 100\r\nwhere username in (\"\", \"Sazer"..., nBytes=nBytes@entry=2267438, saveSqlFlag=saveSqlFlag@entry=0, pReprepare=pReprepare@entry=0x0, ppStmt=ppStmt@entry=0x7f93cf7aa0c8, pzTail=0x7f93cf7aa0c0) at /home/timofey_turenko_mariadb_com/_build/sqlite-bld-3110100/sqlite3.c:110463 #21 0x00007f95200d1e99 in sqlite3LockAndPrepare (pzTail=0x7f93cf7aa0c0, ppStmt=0x7f93cf7aa0c8, pOld=0x0, saveSqlFlag=0, nBytes=2267438, zSql=0x7f949c886f35 "SET STATEMENT max_statement_time=30000, SQL_SELECT_LIMIT=200 FOR select username as ModelNickName, id as modelId, m.country \r\nfrom sa_production.members m \r\n-- limit 100\r\nwhere username in (\"\", \"Sazer"..., db=0x7f949c019058) at /home/timofey_turenko_mariadb_com/_build/sqlite-bld-3110100/sqlite3.c:110562 #22 sqlite3LockAndPrepare (db=<optimized out>, zSql=<optimized out>, nBytes=<optimized out>, saveSqlFlag=<optimized out>, pOld=<optimized out>, ppStmt=<optimized out>, pzTail=<optimized out>, db=<optimized out>, zSql=<optimized out>, nBytes=<optimized out>, saveSqlFlag=<optimized out>, pOld=<optimized out>, ppStmt=<optimized out>, pzTail=<optimized out>) at /home/timofey_turenko_mariadb_com/_build/sqlite-bld-3110100/sqlite3.c:45006 #23 0x00007f95200d2677 in sqlite3_prepare (db=<optimized out>, zSql=<optimized out>, nBytes=<optimized out>, ppStmt=<optimized out>, pzTail=<optimized out>) at /home/timofey_turenko_mariadb_com/_build/sqlite-bld-3110100/sqlite3.c:110626 #24 0x00007f9520129dfb in parse_query_string (query=query@entry=0x7f949c886f35 "SET STATEMENT max_statement_time=30000, SQL_SELECT_LIMIT=200 FOR select username as ModelNickName, id as modelId, m.country \r\nfrom sa_production.members m \r\n-- limit 100\r\nwhere username in (\"\", \"Sazer"..., len=len@entry=2267438, suppress_logging=suppress_logging@entry=false) at /home/timofey_turenko_mariadb_com/MaxScale/server/modules/parser_plugin/pp_sqlite/pp_sqlite.cc:3699 #25 0x00007f952012a11a in parse_query (collect=<optimized out>, query=..., helper=...) at /home/timofey_turenko_mariadb_com/MaxScale/server/modules/parser_plugin/pp_sqlite/pp_sqlite.cc:3880 #26 ensure_query_is_parsed (helper=..., query=<optimized out>, collect=<optimized out>) at /home/timofey_turenko_mariadb_com/MaxScale/server/modules/parser_plugin/pp_sqlite/pp_sqlite.cc:3687 #27 0x00007f9520113d65 in (anonymous namespace)::parse (this=<optimized out>, stmt=..., collect=<optimized out>) at /home/timofey_turenko_mariadb_com/MaxScale/server/modules/parser_plugin/pp_sqlite/pp_sqlite.cc:5248 #28 0x00007f952a2745dc in maxscale::CachingParser::parse (this=<optimized out>, stmt=..., collect=<optimized out>) at /usr/include/c++/8/bits/unique_ptr.h:345 #29 0x00007f952104d3f4 in MaskingFilterSession::check_textual_query (this=0x7f949c110690, packet=...) at /home/timofey_turenko_mariadb_com/MaxScale/include/maxscale/filter.hh:186 #30 0x00007f952104e5ee in MaskingFilterSession::routeQuery (packet=..., this=0x7f949c110690) at /home/timofey_turenko_mariadb_com/MaxScale/server/modules/filter/masking/maskingfiltersession.cc:291 #31 MaskingFilterSession::routeQuery (this=<optimized out>, packet=..., this=<optimized out>, packet=...) at /home/timofey_turenko_mariadb_com/MaxScale/server/modules/filter/masking/maskingfiltersession.cc:274 #32 0x00007f952a193678 in ServiceEndpoint::routeQuery (this=0x7f949c14a250, buffer=...) at /home/timofey_turenko_mariadb_com/MaxScale/server/core/service.cc:1653 #33 0x00007f952a1862d9 in Session::routeQuery (this=0x7f949c0bed10, buffer=...) at /home/timofey_turenko_mariadb_com/MaxScale/server/core/session.cc:1485 #34 0x00007f952a149e02 in MariaDBClientConnection::route_statement (this=0x7f949c0c28c0, buffer=...) at /home/timofey_turenko_mariadb_com/MaxScale/server/modules/protocol/MariaDB/mariadb_client.cc:1472 #35 0x00007f952a151c85 in MariaDBClientConnection::process_normal_packet (this=0x7f949c0c28c0, buffer=...) at /home/timofey_turenko_mariadb_com/MaxScale/server/modules/protocol/MariaDB/mariadb_client.cc:2885 #36 0x00007f952a1523bb in MariaDBClientConnection::process_normal_read (this=0x7f949c0c28c0) at /home/timofey_turenko_mariadb_com/MaxScale/server/modules/protocol/MariaDB/mariadb_client.cc:1576 #37 0x00007f952a152408 in MariaDBClientConnection::ready_for_reading (this=0x7f949c0c28c0, event_dcb=<optimized out>) at /home/timofey_turenko_mariadb_com/MaxScale/server/modules/protocol/MariaDB/mariadb_client.cc:1715 #38 0x00007f952a22aad1 in DCB::process_events (this=0x7f949c0ef280, events=<optimized out>) at /home/timofey_turenko_mariadb_com/MaxScale/server/core/dcb.cc:1329 #39 0x00007f952a22acb1 in DCB::event_handler (this=0x7f949c0ef280, events=<optimized out>) at /home/timofey_turenko_mariadb_com/MaxScale/server/core/dcb.cc:1378 #40 0x00007f952a10bfd3 in maxbase::Worker::deliver_events (this=<optimized out>, pPollable=<optimized out>, events=<optimized out>, context=<optimized out>) at /home/timofey_turenko_mariadb_com/MaxScale/maxutils/maxbase/src/worker.cc:1082 #41 0x00007f952a10f6e8 in maxbase::Worker::poll_waitevents (this=<optimized out>) at /home/timofey_turenko_mariadb_com/MaxScale/maxutils/maxbase/src/worker.cc:1191 #42 0x00007f952a10fcbd in maxbase::Worker::run (this=<optimized out>, pSem=<optimized out>) at /home/timofey_turenko_mariadb_com/MaxScale/maxutils/maxbase/src/worker.cc:871 #43 0x00007f9527814b23 in execute_native_thread_routine () from /lib64/libstdc++.so.6 #44 0x00007f95286221ca in start_thread () from /lib64/libpthread.so.0 #45 0x00007f9526208e73 in clone () from /lib64/libc.so.6

Johan Wikman added a comment - 2025-03-21 08:27 dabbler Could provide the MaxScale configuration file? Please ensure to remove all sensitive information.

Yurii added a comment - 2025-03-21 09:12 Yes. In attach maxscale.cnf