2025-05-09 10:56:38 0 [Note] Starting MariaDB 10.11.11-MariaDB-cll-lve source revision e69f8cae1a15e15b9e4f5e0f8497e1f17bdc81a4 server_uid WD4UdzfKM9Tqn0MDG+ehI62sQzA= as process 35531 2025-05-09 10:56:38 0 [Note] InnoDB: Compressed tables use zlib 1.2.11 2025-05-09 10:56:38 0 [Note] InnoDB: Number of transaction pools: 1 2025-05-09 10:56:38 0 [Note] InnoDB: Using crc32 + pclmulqdq instructions 2025-05-09 10:56:38 0 [Note] InnoDB: Using Linux native AIO 2025-05-09 10:56:38 0 [Note] InnoDB: Initializing buffer pool, total size = 32.000GiB, chunk size = 512.000MiB 2025-05-09 10:56:38 0 [Note] InnoDB: Completed initialization of buffer pool 2025-05-09 10:56:38 0 [Note] InnoDB: File system buffers for log disabled (block size=512 bytes) 2025-05-09 10:56:38 0 [Note] InnoDB: End of log at LSN=8538734105718 2025-05-09 10:56:38 0 [Note] InnoDB: 128 rollback segments are active. 2025-05-09 10:56:38 0 [Note] InnoDB: Setting file './ibtmp1' size to 12.000MiB. Physically writing the file full; Please wait ... 2025-05-09 10:56:38 0 [Note] InnoDB: File './ibtmp1' size is now 12.000MiB. 2025-05-09 10:56:38 0 [Note] InnoDB: log sequence number 8538734105718; transaction id 15126416544 2025-05-09 10:56:38 0 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool 2025-05-09 10:56:38 0 [Note] Plugin 'FEEDBACK' is disabled. 2025-05-09 10:56:38 0 [Warning] 'innodb-buffer-pool-instances' was removed. It does nothing now and exists only for compatibility with old my.cnf files. 2025-05-09 10:56:38 0 [Note] Server socket created on IP: '0.0.0.0'. 2025-05-09 10:56:38 0 [Note] Server socket created on IP: '::'. 2025-05-09 10:56:38 0 [Note] /usr/sbin/mariadbd: ready for connections. Version: '10.11.11-MariaDB-cll-lve' socket: '/var/lib/mysql/mysql.sock' port: 3306 MariaDB Server 2025-05-09 10:56:42 0 [Note] InnoDB: Buffer pool(s) load completed at 250509 10:56:42 2025-05-09 10:56:45 104 [Warning] Aborted connection 104 to db: 'ptcfjohr_jtlshop' user: 'ptcfjohr_jtlshop' host: 'localhost' (Got an error reading communication packets) 2025-05-09 10:57:03 462 [ERROR] mariadbd: Table './hraiyycn_wp/wp_options' is marked as crashed and should be repaired 2025-05-09 10:57:03 462 [Warning] Checking table: './hraiyycn_wp/wp_options' 2025-05-09 10:57:06 462 [ERROR] mariadbd: Table './hraiyycn_wp/wp_wfHits' is marked as crashed and should be repaired 2025-05-09 10:57:06 462 [Warning] Checking table: './hraiyycn_wp/wp_wfHits' 250509 10:57:36 [ERROR] /usr/sbin/mariadbd got signal 11 ; Sorry, we probably made a mistake, and this is a bug. Your assistance in bug reporting will enable us to fix this for the next release. To report this bug, see https://mariadb.com/kb/en/reporting-bugs about how to report a bug on https://jira.mariadb.org/. Please include the information from the server start above, to the end of the information below. Server version: 10.11.11-MariaDB-cll-lve source revision: e69f8cae1a15e15b9e4f5e0f8497e1f17bdc81a4 The information page at https://mariadb.com/kb/en/how-to-produce-a-full-stack-trace-for-mariadbd/ contains instructions to obtain a better version of the backtrace below. Following these instructions will help MariaDB developers provide a fix quicker. Attempting backtrace. Include this in the bug report. (note: Retrieving this information may fail) Thread pointer: 0x7fc7cc000c58 stack_bottom = 0x7fd03c066000 thread_stack 0x49000 2025-05-09 10:57:36 0 [Note] /usr/sbin/mariadbd (initiated by: unknown): Normal shutdown /usr/sbin/mariadbd(my_print_stacktrace+0x2e)[0x55f65756663e] /usr/sbin/mariadbd(handle_fatal_signal+0x2fd)[0x55f65704c14d] /lib64/libpthread.so.0(+0x12990)[0x7fd058264990] /usr/sbin/mariadbd(_Z16best_access_pathP4JOINP13st_join_tableyPK8POSITIONjbdPS3_S6_+0x496)[0x55f656e37016] /usr/sbin/mariadbd(+0x87d986)[0x55f656e3a986] /usr/sbin/mariadbd(+0x882852)[0x55f656e3f852] /usr/sbin/mariadbd(+0x883c64)[0x55f656e40c64] /usr/sbin/mariadbd(_Z11choose_planP4JOINy+0x1fd)[0x55f656e4132d] /usr/sbin/mariadbd(_ZN13st_join_table21choose_best_splittingEjyPK8POSITIONPy+0xa5b)[0x55f656fc51cb] /usr/sbin/mariadbd(_Z16best_access_pathP4JOINP13st_join_tableyPK8POSITIONjbdPS3_S6_+0x1a9)[0x55f656e36d29] /usr/sbin/mariadbd(_Z45fix_semijoin_strategies_for_picked_join_orderP4JOIN+0x142b)[0x55f656f601cb] /usr/sbin/mariadbd(_ZN4JOIN20get_best_combinationEv+0x21)[0x55f656e358f1] /usr/sbin/mariadbd(_ZN4JOIN15optimize_stage2Ev+0x15a)[0x55f656e6550a] /usr/sbin/mariadbd(_ZN4JOIN8optimizeEv+0xb5)[0x55f656e69d85] /usr/sbin/mariadbd(+0x7e7d79)[0x55f656da4d79] /usr/sbin/mariadbd(_Z27mysql_handle_single_derivedP3LEXP10TABLE_LISTj+0x99)[0x55f656da45b9] /usr/sbin/mariadbd(_ZN13st_select_lex14handle_derivedEP3LEXj+0x47)[0x55f656dc23d7] /usr/sbin/mariadbd(_ZN4JOIN15optimize_stage2Ev+0x186)[0x55f656e65536] /usr/sbin/mariadbd(_ZN4JOIN14optimize_innerEv+0x15b5)[0x55f656e697a5] /usr/sbin/mariadbd(_ZN4JOIN8optimizeEv+0xa0)[0x55f656e69d70] /usr/sbin/mariadbd(_Z12mysql_selectP3THDP10TABLE_LISTR4ListI4ItemEPS4_jP8st_orderS9_S7_S9_yP13select_resultP18st_select_lex_unitP13st_select_lex+0xce)[0x55f656e69e5e] /usr/sbin/mariadbd(_Z13handle_selectP3THDP3LEXP13select_resulty+0x153)[0x55f656e6a633] /usr/sbin/mariadbd(+0x827c62)[0x55f656de4c62] /usr/sbin/mariadbd(_Z21mysql_execute_commandP3THDb+0x12fd)[0x55f656defedd] /usr/sbin/mariadbd(_Z11mysql_parseP3THDPcjP12Parser_state+0x444)[0x55f656ddf2b2] /usr/sbin/mariadbd(_Z16dispatch_command19enum_server_commandP3THDPcjb+0x13f4)[0x55f656debe63] /usr/sbin/mariadbd(_Z10do_commandP3THDb+0x138)[0x55f656dede3f] /usr/sbin/mariadbd(_Z24do_handle_one_connectionP7CONNECTb+0x3d5)[0x55f656f1b445] /usr/sbin/mariadbd(handle_one_connection+0x5d)[0x55f656f1b79d] /usr/sbin/mariadbd(+0xcae625)[0x55f65726b625] /lib64/libpthread.so.0(+0x81ca)[0x7fd05825a1ca] /lib64/libc.so.6(clone+0x43)[0x7fd0573828d3] Connection ID (thread ID): 1164 Status: KILL_SERVER Query (0x7fc7cc0131f0): SELECT tseo.cSeo, ssMerkmal.kHersteller, ssMerkmal.cName, ssMerkmal.nSortNr, ssMerkmal.cBildPfad, COUNT(*) AS nAnzahl FROM (SELECT thersteller.kHersteller, thersteller.cName, thersteller.nSortNr, thersteller.cBildPfad, tartikel.kArtikel FROM tartikel #JOIN from JTL\Filter\States\BaseCharacteristic::getSQLJoin JOIN (SELECT DISTINCT kArtikel FROM tartikelmerkmal WHERE kMerkmalWert = 81 ) AS tmerkmaljoin ON tmerkmaljoin.kArtikel = tartikel.kArtikel #JOIN1 from JTL\Filter\Items\Search::getSQLJoin JOIN (SELECT tsuchcachetreffer.kArtikel, tsuchcachetreffer.kSuchCache, MIN(tsuchcachetreffer.nSort) AS nSort FROM tsuchcachetreffer JOIN tsuchcache ON tsuchcachetreffer.kSuchCache = tsuchcache.kSuchCache JOIN tsuchanfrage ON tsuchanfrage.cSuche = tsuchcache.cSuche AND tsuchanfrage.kSuchanfrage IN (90) GROUP BY tsuchcachetreffer.kArtikel HAVING COUNT(*) = 1 ) AS jfSuche ON jfSuche.kArtikel = tartikel.kArtikel #join from JTL\Filter\Items\Characteristic::getSQLJoin JOIN tartikelmerkmal ON tartikel.kArtikel = tartikelmerkmal.kArtikel #JOIN from JTL\Filter\States\BaseManufacturer::getOptions JOIN thersteller ON tartikel.kHersteller = thersteller.kHersteller #product visiblity join from getBaseQuery LEFT JOIN tartikelsichtbarkeit ON tartikel.kArtikel = tartikelsichtbarkeit.kArtikel AND tartikelsichtbarkeit.kKundengruppe = 1 WHERE #condition from filter mf tartikelmerkmal.kArtikel IN (SELECT kArtikel FROM tartikelmerkmal WHERE kMerkmalWert IN (535)) #condition from JTL\Filter\Items\Characteristic::getSQLCondition Ducati 1100 Streetfighter V4 S 2020 AND tartikelsichtbarkeit.kArtikel IS NULL AND tartikel.kVaterArtikel = 0 AND (tartikel.cLagerBeachten != 'Y' OR tartikel.fLagerbestand > 0 OR (tartikel.cLagerVariation = 'Y' AND ( SELECT MAX(teigenschaftwert.fLagerbestand) FROM teigenschaft INNER JOIN teigenschaftwert ON teigenschaftwert.kEigenschaft = teigenschaft.kEigenschaft WHERE teigenschaft.kArtikel = tartikel.kArtikel ) > 0 )) #default group by GROUP BY tartikel.kArtikel #limit sql ORDER BY tartikel.nSort, tartikel.cName) AS ssMerkmal LEFT JOIN tseo ON tseo.kKey = ssMerkmal.kHersteller AND tseo.cKey = 'kHersteller' AND tseo.kSprache = 1 GROUP BY ssMerkmal.kHersteller ORDER BY ssMerkmal.nSortNr, ssMerkmal.cName Optimizer switch: index_merge=on,index_merge_union=on,index_merge_sort_union=on,index_merge_intersection=on,index_merge_sort_intersection=off,engine_condition_pushdown=off,index_condition_pushdown=on,derived_merge=on,derived_with_keys=on,firstmatch=on,loosescan=on,materialization=on,in_to_exists=on,semijoin=on,partial_match_rowid_merge=on,partial_match_table_scan=on,subquery_cache=on,mrr=off,mrr_cost_based=off,mrr_sort_keys=off,outer_join_with_cache=on,semijoin_with_cache=on,join_cache_incremental=on,join_cache_hashed=on,join_cache_bka=on,optimize_join_buffer_size=on,table_elimination=on,extended_keys=on,exists_to_in=on,orderby_uses_equalities=on,condition_pushdown_for_derived=on,split_materialized=on,condition_pushdown_for_subquery=on,rowid_filter=on,condition_pushdown_from_having=on,not_null_range_scan=off,hash_join_cardinality=off,cset_narrowing=off Writing a core file... Working directory at /var/lib/mysql Resource Limits (excludes unlimited resources): Limit Soft Limit Hard Limit Units Max stack size 8388608 unlimited bytes Max core file size 0 unlimited bytes Max processes 400532 400532 processes Max open files 32768 32768 files Max locked memory 65536 65536 bytes Max pending signals 400532 400532 signals Max msgqueue size 819200 819200 bytes Max nice priority 0 0 Max realtime priority 0 0 Core pattern: |/usr/lib/systemd/systemd-coredump %P %u %g %s %t %c %h %e Kernel version: Linux version 4.18.0-553.50.1.lve.el8.x86_64 (mockbuild@buildfarm05-new.corp.cloudlinux.com) (gcc version 8.5.0 20210514 (Red Hat 8.5.0-26) (GCC)) #1 SMP Thu Apr 17 19:10:24 UTC 2025