Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-31793

LooseScan join on derived table crashes

    XMLWordPrintable

Details

    • Bug
    • Status: Confirmed (View Workflow)
    • Critical
    • Resolution: Unresolved
    • 11.0(EOL), 11.1(EOL), 11.2, 11.3(EOL), 11.4
    • 11.2, 11.4, 11.6
    • None
    • MariaDB >= 11.0 docker image, Ubuntu 20.04/22.04 / Windows 10 host

    Description

      Some time ago I've noticed that my GitHub workflows that are using MariaDB where randomly failing. It seems to have started with version 11, at least I'm not able to reproduce it with earlier versions.

      The basic gist is in the title, using a subquery with ranking and joins, MariaDB "randomly" segfaults. I wasn't able to reproduce it without either ranking or joins, and the columns of the involved tables seem to affect it too, if I remove any more of them, then it won't crash anymore.

      Note that I say "randomly" because it can happen anywhere from immediately, to requiring 200+ attempts. I understand that these aren't the best prerequisites for recreating the problem, but it is somewhat reliable in that it will eventually crash when you just run the queries often enough.

      Basic logs

      2023-07-28 14:55:27+00:00 [Note] [Entrypoint]: Entrypoint script for MariaDB Server 1:11.2.0+maria~ubu2204 started.
      2023-07-28 14:55:27+00:00 [Note] [Entrypoint]: Switching to dedicated user 'mysql'
      2023-07-28 14:55:27+00:00 [Note] [Entrypoint]: Entrypoint script for MariaDB Server 1:11.2.0+maria~ubu2204 started.
      2023-07-28 14:55:27+00:00 [Note] [Entrypoint]: Initializing database files
      2023-07-28 14:55:27 0 [Warning] mariadbd: io_uring_queue_init() failed with ENOMEM: try larger memory locked limit, ulimit -l, or https://mariadb.com/kb/en/systemd/#configuring-limitmemlock under systemd (262144 bytes required)
      2023-07-28 14:55:27 0 [Warning] InnoDB: liburing disabled: falling back to innodb_use_native_aio=OFF
       
       
      PLEASE REMEMBER TO SET A PASSWORD FOR THE MariaDB root USER !
      To do so, start the server, then issue the following command:
       
      '/usr/bin/mariadb-secure-installation'
       
      which will also give you the option of removing the test
      databases and anonymous user created by default.  This is
      strongly recommended for production servers.
       
      See the MariaDB Knowledgebase at https://mariadb.com/kb
       
      Please report any problems at https://mariadb.org/jira
       
      The latest information about MariaDB is available at https://mariadb.org/.
       
      Consider joining MariaDB's strong and vibrant community:
      https://mariadb.org/get-involved/
       
      2023-07-28 14:55:28+00:00 [Note] [Entrypoint]: Database files initialized
      2023-07-28 14:55:28+00:00 [Note] [Entrypoint]: Starting temporary server
      2023-07-28 14:55:28+00:00 [Note] [Entrypoint]: Waiting for server startup
      2023-07-28 14:55:28 0 [Note] Starting MariaDB 11.2.0-MariaDB-1:11.2.0+maria~ubu2204 source revision e81fa345020ec6a067583db6a7019d6404b26f93 as process 99
      2023-07-28 14:55:28 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
      2023-07-28 14:55:28 0 [Note] InnoDB: Number of transaction pools: 1
      2023-07-28 14:55:28 0 [Note] InnoDB: Using crc32 + pclmulqdq instructions
      2023-07-28 14:55:28 0 [Note] mariadbd: O_TMPFILE is not supported on /tmp (disabling future attempts)
      2023-07-28 14:55:28 0 [Warning] mariadbd: io_uring_queue_init() failed with ENOMEM: try larger memory locked limit, ulimit -l, or https://mariadb.com/kb/en/systemd/#configuring-limitmemlock under systemd (262144 bytes required)
      2023-07-28 14:55:28 0 [Warning] InnoDB: liburing disabled: falling back to innodb_use_native_aio=OFF
      2023-07-28 14:55:28 0 [Note] InnoDB: Initializing buffer pool, total size = 128.000MiB, chunk size = 2.000MiB
      2023-07-28 14:55:28 0 [Note] InnoDB: Completed initialization of buffer pool
      2023-07-28 14:55:28 0 [Note] InnoDB: File system buffers for log disabled (block size=512 bytes)
      2023-07-28 14:55:28 0 [Note] InnoDB: End of log at LSN=46125
      2023-07-28 14:55:28 0 [Note] InnoDB: Opened 3 undo tablespaces
      2023-07-28 14:55:28 0 [Note] InnoDB: 128 rollback segments in 3 undo tablespaces are active.
      2023-07-28 14:55:28 0 [Note] InnoDB: Setting file './ibtmp1' size to 12.000MiB. Physically writing the file full; Please wait ...
      2023-07-28 14:55:28 0 [Note] InnoDB: File './ibtmp1' size is now 12.000MiB.
      2023-07-28 14:55:28 0 [Note] InnoDB: log sequence number 46125; transaction id 14
      2023-07-28 14:55:28 0 [Note] Plugin 'FEEDBACK' is disabled.
      2023-07-28 14:55:28 0 [Note] Plugin 'wsrep-provider' is disabled.
      2023-07-28 14:55:28 0 [Warning] 'user' entry 'root@1ea12db333c8' ignored in --skip-name-resolve mode.
      2023-07-28 14:55:28 0 [Warning] 'proxies_priv' entry '@% root@1ea12db333c8' ignored in --skip-name-resolve mode.
      2023-07-28 14:55:28 0 [Note] mariadbd: Event Scheduler: Loaded 0 events
      2023-07-28 14:55:28 0 [Note] mariadbd: ready for connections.
      Version: '11.2.0-MariaDB-1:11.2.0+maria~ubu2204'  socket: '/run/mysqld/mysqld.sock'  port: 0  mariadb.org binary distribution
      2023-07-28 14:55:29+00:00 [Note] [Entrypoint]: Temporary server started.
      2023-07-28 14:55:30+00:00 [Note] [Entrypoint]: Creating database test
      2023-07-28 14:55:30+00:00 [Note] [Entrypoint]: Securing system users (equivalent to running mysql_secure_installation)
       
      2023-07-28 14:55:30+00:00 [Note] [Entrypoint]: Stopping temporary server
      2023-07-28 14:55:30 0 [Note] mariadbd (initiated by: unknown): Normal shutdown
      2023-07-28 14:55:30 0 [Note] InnoDB: FTS optimize thread exiting.
      2023-07-28 14:55:30 0 [Note] InnoDB: Starting shutdown...
      2023-07-28 14:55:30 0 [Note] InnoDB: Dumping buffer pool(s) to /var/lib/mysql/ib_buffer_pool
      2023-07-28 14:55:30 0 [Note] InnoDB: Buffer pool(s) dump completed at 230728 14:55:30
      2023-07-28 14:55:31 0 [Note] InnoDB: Removed temporary tablespace data file: "./ibtmp1"
      2023-07-28 14:55:31 0 [Note] InnoDB: Shutdown completed; log sequence number 47375; transaction id 15
      2023-07-28 14:55:31 0 [Note] mariadbd: Shutdown complete
       
      2023-07-28 14:55:31+00:00 [Note] [Entrypoint]: Temporary server stopped
       
      2023-07-28 14:55:31+00:00 [Note] [Entrypoint]: MariaDB init process done. Ready for start up.
       
      2023-07-28 14:55:31 0 [Note] Starting MariaDB 11.2.0-MariaDB-1:11.2.0+maria~ubu2204 source revision e81fa345020ec6a067583db6a7019d6404b26f93 as process 1
      2023-07-28 14:55:31 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
      2023-07-28 14:55:31 0 [Note] InnoDB: Number of transaction pools: 1
      2023-07-28 14:55:31 0 [Note] InnoDB: Using crc32 + pclmulqdq instructions
      2023-07-28 14:55:31 0 [Note] mariadbd: O_TMPFILE is not supported on /tmp (disabling future attempts)
      2023-07-28 14:55:31 0 [Warning] mariadbd: io_uring_queue_init() failed with ENOMEM: try larger memory locked limit, ulimit -l, or https://mariadb.com/kb/en/systemd/#configuring-limitmemlock under systemd (262144 bytes required)
      2023-07-28 14:55:31 0 [Warning] InnoDB: liburing disabled: falling back to innodb_use_native_aio=OFF
      2023-07-28 14:55:31 0 [Note] InnoDB: Initializing buffer pool, total size = 128.000MiB, chunk size = 2.000MiB
      2023-07-28 14:55:31 0 [Note] InnoDB: Completed initialization of buffer pool
      2023-07-28 14:55:31 0 [Note] InnoDB: File system buffers for log disabled (block size=512 bytes)
      2023-07-28 14:55:31 0 [Note] InnoDB: End of log at LSN=47375
      2023-07-28 14:55:31 0 [Note] InnoDB: Opened 3 undo tablespaces
      2023-07-28 14:55:31 0 [Note] InnoDB: 128 rollback segments in 3 undo tablespaces are active.
      2023-07-28 14:55:31 0 [Note] InnoDB: Setting file './ibtmp1' size to 12.000MiB. Physically writing the file full; Please wait ...
      2023-07-28 14:55:31 0 [Note] InnoDB: File './ibtmp1' size is now 12.000MiB.
      2023-07-28 14:55:31 0 [Note] InnoDB: log sequence number 47375; transaction id 14
      2023-07-28 14:55:31 0 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool
      2023-07-28 14:55:31 0 [Note] Plugin 'FEEDBACK' is disabled.
      2023-07-28 14:55:31 0 [Note] Plugin 'wsrep-provider' is disabled.
      2023-07-28 14:55:31 0 [Note] InnoDB: Buffer pool(s) load completed at 230728 14:55:31
      2023-07-28 14:55:31 0 [Note] Server socket created on IP: '0.0.0.0'.
      2023-07-28 14:55:31 0 [Note] Server socket created on IP: '::'.
      2023-07-28 14:55:31 0 [Note] mariadbd: Event Scheduler: Loaded 0 events
      2023-07-28 14:55:31 0 [Note] mariadbd: ready for connections.
      Version: '11.2.0-MariaDB-1:11.2.0+maria~ubu2204'  socket: '/run/mysqld/mysqld.sock'  port: 3306  mariadb.org binary distribution
      230728 14:55:41 [ERROR] mysqld got signal 11 ;
      This could be because you hit a bug. It is also possible that this binary
      or one of the libraries it was linked against is corrupt, improperly built,
      or misconfigured. This error can also be caused by malfunctioning hardware.
       
      To report this bug, see https://mariadb.com/kb/en/reporting-bugs
       
      We will try our best to scrape up some info that will hopefully help
      diagnose the problem, but since we have already crashed,
      something is definitely wrong and this may fail.
       
      Server version: 11.2.0-MariaDB-1:11.2.0+maria~ubu2204 source revision: e81fa345020ec6a067583db6a7019d6404b26f93
      key_buffer_size=134217728
      read_buffer_size=131072
      max_used_connections=1
      max_threads=153
      thread_count=1
      It is possible that mysqld could use up to
      key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 468063 K  bytes of memory
      Hope that's ok; if not, decrease some variables in the equation.
       
      Thread pointer: 0x7f4948000c68
      Attempting backtrace. You can use the following information to find out
      where mysqld died. If you see no messages after this, something went
      terribly wrong...
      stack_bottom = 0x7f4994119c38 thread_stack 0x49000
      Printing to addr2line failed
      mariadbd(my_print_stacktrace+0x32)[0x56389d4a5bd2]
      mariadbd(handle_fatal_signal+0x488)[0x56389cf7ee98]
      /lib/x86_64-linux-gnu/libc.so.6(+0x42520)[0x7f49abd45520]
      mariadbd(_Z11copy_fieldsP15TMP_TABLE_PARAM+0x2b)[0x56389cd6b60b]
      mariadbd(+0x8a6b62)[0x56389cd6bb62]
      mariadbd(+0x87ade7)[0x56389cd3fde7]
      mariadbd(_Z10sub_selectP4JOINP13st_join_tableb+0x24b)[0x56389cd5025b]
      mariadbd(+0x87ade7)[0x56389cd3fde7]
      mariadbd(_Z10sub_selectP4JOINP13st_join_tableb+0x24b)[0x56389cd5025b]
      mariadbd(+0x87ade7)[0x56389cd3fde7]
      mariadbd(_Z10sub_selectP4JOINP13st_join_tableb+0x2c4)[0x56389cd502d4]
      mariadbd(_ZN4JOIN10exec_innerEv+0xfd4)[0x56389cd843d4]
      mariadbd(_ZN4JOIN4execEv+0x3f)[0x56389cd8480f]
      mariadbd(_Z12mysql_selectP3THDP10TABLE_LISTR4ListI4ItemEPS4_jP8st_orderS9_S7_S9_yP13select_resultP18st_select_lex_unitP13st_select_lex+0x12c)[0x56389cd8278c]
      mariadbd(_Z13handle_selectP3THDP3LEXP13select_resulty+0x154)[0x56389cd82f84]
      mariadbd(+0x8318f5)[0x56389ccf68f5]
      mariadbd(_Z21mysql_execute_commandP3THDb+0x41ae)[0x56389cd0584e]
      mariadbd(_Z11mysql_parseP3THDPcjP12Parser_state+0x1e7)[0x56389cd06b77]
      mariadbd(_Z16dispatch_command19enum_server_commandP3THDPcjb+0x14bd)[0x56389cd0935d]
      mariadbd(_Z10do_commandP3THDb+0x138)[0x56389cd0b158]
      mariadbd(_Z24do_handle_one_connectionP7CONNECTb+0x3bf)[0x56389ce328cf]
      mariadbd(handle_one_connection+0x5d)[0x56389ce32c1d]
      mariadbd(+0xce5fa6)[0x56389d1aafa6]
      /lib/x86_64-linux-gnu/libc.so.6(+0x94b43)[0x7f49abd97b43]
      /lib/x86_64-linux-gnu/libc.so.6(clone+0x44)[0x7f49abe28bb4]
       
      Trying to get some variables.
      Some pointers may be invalid and cause the dump to abort.
      Query (0x7f4948012fb0): SELECT
          TopComments.id AS TopComments__id,
          TopComments.article_id AS TopComments__article_id,
          TopComments.body AS TopComments__body,
          TopComments.votes AS TopComments__votes,
          TopComments_body_translation.id AS TopComments_body_translation__id,
          TopComments_body_translation.content AS TopComments_body_translation__content
      FROM
          comments TopComments
      INNER JOIN
          comments_i18n TopComments_body_translation ON (
              TopComments_body_translation.model = 'Comments'
              AND TopComments_body_translation.field = 'body'
              AND TopComments_body_translation.locale = 'de_DE'
              AND TopComments.id = TopComments_body_translation.foreign_key
          )
      WHERE (
          TopComments.article_id in (1, 2)
          AND TopComments.id in (
              SELECT
                  __ranked__TopComments.id AS id
              FROM (
                  SELECT
                      TopComments.id AS TopComments__id,
                      TopComments.article_id AS TopComments__article_id,
                      TopComments.body AS TopComments__body,
                      TopComments.votes AS TopComments__votes,
                      TopComments.id AS id,
                      (
                          ROW_NUMBER() OVER (
                              PARTITION BY
                                  TopComments.article_id
                              ORDER BY
                                  TopComments.votes DESC,
                                  TopComments.id ASC
                          )
                      ) AS __row_number,
                      TopComments_body_translation.id AS TopComments_body_translation__id,
                      TopComments_body_translation.content AS TopComments_body_translation__content
                  FROM
                      comments TopComments
                  INNER JOIN
                      comments_i18n TopComments_body_translation ON (
                          TopComments_body_translation.model = 'Comments'
                          AND TopComments_body_translation.field = 'body'
                          AND TopComments_body_translation.locale = 'de_DE'
                          AND TopComments.id = TopComments_body_translation.foreign_key
                      )
                  WHERE
                      TopComments.article_id in (1, 2)
              )
              __ranked__TopComments
              WHERE
                  __ranked__TopComments.__row_number <= 3
          )
      )
      ORDER BY
          TopComments.votes DESC,
          TopComments.id ASC
       
      Connection ID (thread ID): 11
      Status: NOT_KILLED
       
      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,exis
      ts_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=on
       
      The manual page at https://mariadb.com/kb/en/how-to-produce-a-full-stack-trace-for-mysqld/ contains
      information that should help you find out what is causing the crash.
      Writing a core file...
      Working directory at /var/lib/mysql
      Resource Limits:
      Limit                     Soft Limit           Hard Limit           Units
      Max cpu time              unlimited            unlimited            seconds
      Max file size             unlimited            unlimited            bytes
      Max data size             unlimited            unlimited            bytes
      Max stack size            8388608              unlimited            bytes
      Max core file size        unlimited            unlimited            bytes
      Max resident set          unlimited            unlimited            bytes
      Max processes             unlimited            unlimited            processes
      Max open files            1048576              1048576              files
      Max locked memory         65536                65536                bytes
      Max address space         unlimited            unlimited            bytes
      Max file locks            unlimited            unlimited            locks
      Max pending signals       15371                15371                signals
      Max msgqueue size         819200               819200               bytes
      Max nice priority         0                    0
      Max realtime priority     0                    0
      Max realtime timeout      unlimited            unlimited            us
      Core pattern: |/usr/share/apport/apport -p%p -s%s -c%c -d%d -P%P -u%u -g%g -- %E
       
      Kernel version: Linux version 5.4.0-124-generic (buildd@lcy02-amd64-089) (gcc version 9.4.0 (Ubuntu 9.4.0-1ubuntu1~20.04.1)) #140-Ubuntu SMP Thu Aug 4 02:23:37 UTC 2022
      

      Full backtrace (all threads)

       
      Thread 18 (Thread 0x7f9387fff640 (LWP 174) "mariadbd"):
      #0  __futex_abstimed_wait_common64 (private=-1781142552, cancel=true, abstime=0x7f9387ffebf0, op=137, expected=0, futex_word=0x55c895a9cddc) at ./nptl/futex-internal.c:57
              sc_cancel_oldtype = 0
              sc_ret = <optimized out>
              resultvar = <optimized out>
              __arg6 = <optimized out>
              __arg5 = <optimized out>
              __arg4 = <optimized out>
              __arg3 = <optimized out>
              __arg2 = <optimized out>
              __arg1 = <optimized out>
              _a6 = <optimized out>
              _a5 = <optimized out>
              _a4 = <optimized out>
              _a3 = <optimized out>
              _a2 = <optimized out>
              _a1 = <optimized out>
      #1  __futex_abstimed_wait_common (cancel=true, private=-1781142552, abstime=0x7f9387ffebf0, clockid=0, expected=0, futex_word=0x55c895a9cddc) at ./nptl/futex-internal.c:87
              err = <optimized out>
              clockbit = 256
              op = 137
              err = <optimized out>
              clockbit = <optimized out>
              op = <optimized out>
      #2  __GI___futex_abstimed_wait_cancelable64 (futex_word=futex_word@entry=0x55c895a9cddc, expected=expected@entry=0, clockid=clockid@entry=1, abstime=abstime@entry=0x7f9387ffebf0, private=private@entry=0) at ./nptl/futex-internal.c:139
      No locals.
      #3  0x00007f93be0c835d in __pthread_cond_wait_common (abstime=0x7f9387ffebf0, clockid=1, mutex=0x55c895a9ca20, cond=0x55c895a9cdb0) at ./nptl/pthread_cond_wait.c:503
              spin = 0
              buffer = {__routine = 0x7f93be0c77a0 <__condvar_cleanup_waiting>, __arg = 0x7f9387ffeb70, __canceltype = 1, __prev = 0x0}
              cbuffer = {wseq = 125, cond = 0x55c895a9cdb0, mutex = 0x55c895a9ca20, private = 0}
              err = <optimized out>
              g = 1
              flags = <optimized out>
              g1_start = <optimized out>
              maxspin = 0
              signals = <optimized out>
              result = 0
              wseq = 125
              seq = 62
              private = 0
              maxspin = <optimized out>
              err = <optimized out>
              result = <optimized out>
              wseq = <optimized out>
              g = <optimized out>
              seq = <optimized out>
              flags = <optimized out>
              private = <optimized out>
              signals = <optimized out>
              done = <optimized out>
              g1_start = <optimized out>
              spin = <optimized out>
              buffer = <optimized out>
              cbuffer = <optimized out>
              s = <optimized out>
      #4  ___pthread_cond_clockwait64 (abstime=0x7f9387ffebf0, clockid=1, mutex=0x55c895a9ca20, cond=0x55c895a9cdb0) at ./nptl/pthread_cond_wait.c:691
      No locals.
      #5  ___pthread_cond_clockwait64 (cond=0x55c895a9cdb0, mutex=0x55c895a9ca20, clockid=1, abstime=0x7f9387ffebf0) at ./nptl/pthread_cond_wait.c:679
      No locals.
      #6  0x000055c893b8232f in std::__condvar::wait_until (__abs_time=@0x7f9387ffebf0: {tv_sec = 11933, tv_nsec = 460221651}, __clock=1, __m=<optimized out>, this=0x55c895a9cdb0) at /usr/include/c++/11/bits/std_mutex.h:123
      No locals.
      #7  std::condition_variable::__wait_until_impl<std::chrono::duration<long, std::ratio<1l, 1000000000l> > > (__lock=@0x7f9387ffec40: {_M_device = 0x55c895a9ca20, _M_owns = true}, __lock=@0x7f9387ffec40: {_M_device = 0x55c895a9ca20, _M_owns = true}, __atime=<optimized out>, this=0x55c895a9cdb0) at /usr/include/c++/11/condition_variable:201
              __s = <optimized out>
              __ns = <optimized out>
              __ts = {tv_sec = 11933, tv_nsec = 460221651}
      #8  std::condition_variable::wait_until<std::chrono::duration<long, std::ratio<1l, 1000000000l> > > (__atime=<optimized out>, __lock=@0x7f9387ffec40: {_M_device = 0x55c895a9ca20, _M_owns = true}, this=0x55c895a9cdb0) at /usr/include/c++/11/condition_variable:111
      No locals.
      #9  std::condition_variable::wait_for<long, std::ratio<1l, 1000l> > (__rtime=@0x55c895a9ca48: {__r = 60000}, __rtime=@0x55c895a9ca48: {__r = 60000}, __lock=@0x7f9387ffec40: {_M_device = 0x55c895a9ca20, _M_owns = true}, this=0x55c895a9cdb0) at /usr/include/c++/11/condition_variable:163
      No locals.
      #10 tpool::thread_pool_generic::wait_for_tasks (this=this@entry=0x55c895a9c900, lk=@0x7f9387ffec40: {_M_device = 0x55c895a9ca20, _M_owns = true}, thread_data=thread_data@entry=0x55c895a9cdb0) at ./tpool/tpool_generic.cc:480
              __PRETTY_FUNCTION__ = "bool tpool::thread_pool_generic::wait_for_tasks(std::unique_lock<std::mutex>&, tpool::worker_data*)"
      #11 0x000055c893b82b68 in tpool::thread_pool_generic::get_task (this=0x55c895a9c900, thread_var=0x55c895a9cdb0, t=0x7f9387ffec88) at ./tpool/tpool_generic.cc:533
              lk = {_M_device = 0x55c895a9ca20, _M_owns = true}
      #12 0x000055c893b82cd5 in tpool::thread_pool_generic::worker_main (this=0x55c895a9c900, thread_var=0x55c895a9cdb0) at ./tpool/tpool_generic.cc:578
              task = 0x7f93be0c54d8 <__nptl_free_stacks+168>
      #13 0x00007f93be41f2b3 in ?? () from /lib/x86_64-linux-gnu/libstdc++.so.6
      No symbol table info available.
      #14 0x00007f93be0c8b43 in start_thread (arg=<optimized out>) at ./nptl/pthread_create.c:442
              ret = <optimized out>
              pd = <optimized out>
              out = <optimized out>
              unwind_buf = {cancel_jmp_buf = {{jmp_buf = {140271585044528, 1783092640928857216, 140271618618944, 0, 140272525412432, 140271585044880, -1758129329567597440, -1758183593111225216}, mask_was_saved = 0}}, priv = {pad = {0x0, 0x0, 0x0, 0x0}, data = {prev = 0x0, cleanup = 0x0, canceltype = 0}}}
              not_first_call = <optimized out>
      #15 0x00007f93be159bb4 in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:100
      No locals.
       
      Thread 17 (Thread 0x7f93953f4640 (LWP 173) "mariadbd"):
      #0  __futex_abstimed_wait_common64 (private=-1825326035, cancel=true, abstime=0x7f93953f3bf0, op=137, expected=0, futex_word=0x55c895a9ccd8) at ./nptl/futex-internal.c:57
              sc_cancel_oldtype = 0
              sc_ret = <optimized out>
              resultvar = <optimized out>
              __arg6 = <optimized out>
              __arg5 = <optimized out>
              __arg4 = <optimized out>
              __arg3 = <optimized out>
              __arg2 = <optimized out>
              __arg1 = <optimized out>
              _a6 = <optimized out>
              _a5 = <optimized out>
              _a4 = <optimized out>
              _a3 = <optimized out>
              _a2 = <optimized out>
              _a1 = <optimized out>
      #1  __futex_abstimed_wait_common (cancel=true, private=-1825326035, abstime=0x7f93953f3bf0, clockid=0, expected=0, futex_word=0x55c895a9ccd8) at ./nptl/futex-internal.c:87
              err = <optimized out>
              clockbit = 256
              op = 137
              err = <optimized out>
              clockbit = <optimized out>
              op = <optimized out>
      #2  __GI___futex_abstimed_wait_cancelable64 (futex_word=futex_word@entry=0x55c895a9ccd8, expected=expected@entry=0, clockid=clockid@entry=1, abstime=abstime@entry=0x7f93953f3bf0, private=private@entry=0) at ./nptl/futex-internal.c:139
      No locals.
      #3  0x00007f93be0c835d in __pthread_cond_wait_common (abstime=0x7f93953f3bf0, clockid=1, mutex=0x55c895a9ca20, cond=0x55c895a9ccb0) at ./nptl/pthread_cond_wait.c:503
              spin = 0
              buffer = {__routine = 0x7f93be0c77a0 <__condvar_cleanup_waiting>, __arg = 0x7f93953f3b70, __canceltype = 1, __prev = 0x0}
              cbuffer = {wseq = 474, cond = 0x55c895a9ccb0, mutex = 0x55c895a9ca20, private = 0}
              err = <optimized out>
              g = 0
              flags = <optimized out>
              g1_start = <optimized out>
              maxspin = 0
              signals = <optimized out>
              result = 0
              wseq = 474
              seq = 237
              private = 0
              maxspin = <optimized out>
              err = <optimized out>
              result = <optimized out>
              wseq = <optimized out>
              g = <optimized out>
              seq = <optimized out>
              flags = <optimized out>
              private = <optimized out>
              signals = <optimized out>
              done = <optimized out>
              g1_start = <optimized out>
              spin = <optimized out>
              buffer = <optimized out>
              cbuffer = <optimized out>
              s = <optimized out>
      #4  ___pthread_cond_clockwait64 (abstime=0x7f93953f3bf0, clockid=1, mutex=0x55c895a9ca20, cond=0x55c895a9ccb0) at ./nptl/pthread_cond_wait.c:691
      No locals.
      #5  ___pthread_cond_clockwait64 (cond=0x55c895a9ccb0, mutex=0x55c895a9ca20, clockid=1, abstime=0x7f93953f3bf0) at ./nptl/pthread_cond_wait.c:679
      No locals.
      #6  0x000055c893b8232f in std::__condvar::wait_until (__abs_time=@0x7f93953f3bf0: {tv_sec = 11935, tv_nsec = 915261764}, __clock=1, __m=<optimized out>, this=0x55c895a9ccb0) at /usr/include/c++/11/bits/std_mutex.h:123
      No locals.
      #7  std::condition_variable::__wait_until_impl<std::chrono::duration<long, std::ratio<1l, 1000000000l> > > (__lock=@0x7f93953f3c40: {_M_device = 0x55c895a9ca20, _M_owns = true}, __lock=@0x7f93953f3c40: {_M_device = 0x55c895a9ca20, _M_owns = true}, __atime=<optimized out>, this=0x55c895a9ccb0) at /usr/include/c++/11/condition_variable:201
              __s = <optimized out>
              __ns = <optimized out>
              __ts = {tv_sec = 11935, tv_nsec = 915261764}
      #8  std::condition_variable::wait_until<std::chrono::duration<long, std::ratio<1l, 1000000000l> > > (__atime=<optimized out>, __lock=@0x7f93953f3c40: {_M_device = 0x55c895a9ca20, _M_owns = true}, this=0x55c895a9ccb0) at /usr/include/c++/11/condition_variable:111
      No locals.
      #9  std::condition_variable::wait_for<long, std::ratio<1l, 1000l> > (__rtime=@0x55c895a9ca48: {__r = 60000}, __rtime=@0x55c895a9ca48: {__r = 60000}, __lock=@0x7f93953f3c40: {_M_device = 0x55c895a9ca20, _M_owns = true}, this=0x55c895a9ccb0) at /usr/include/c++/11/condition_variable:163
      No locals.
      #10 tpool::thread_pool_generic::wait_for_tasks (this=this@entry=0x55c895a9c900, lk=@0x7f93953f3c40: {_M_device = 0x55c895a9ca20, _M_owns = true}, thread_data=thread_data@entry=0x55c895a9ccb0) at ./tpool/tpool_generic.cc:480
              __PRETTY_FUNCTION__ = "bool tpool::thread_pool_generic::wait_for_tasks(std::unique_lock<std::mutex>&, tpool::worker_data*)"
      #11 0x000055c893b82b68 in tpool::thread_pool_generic::get_task (this=0x55c895a9c900, thread_var=0x55c895a9ccb0, t=0x7f93953f3c88) at ./tpool/tpool_generic.cc:533
              lk = {_M_device = 0x55c895a9ca20, _M_owns = true}
      #12 0x000055c893b82cd5 in tpool::thread_pool_generic::worker_main (this=0x55c895a9c900, thread_var=0x55c895a9ccb0) at ./tpool/tpool_generic.cc:578
              task = 0x55c895d42300
      #13 0x00007f93be41f2b3 in ?? () from /lib/x86_64-linux-gnu/libstdc++.so.6
      No symbol table info available.
      #14 0x00007f93be0c8b43 in start_thread (arg=<optimized out>) at ./nptl/pthread_create.c:442
              ret = <optimized out>
              pd = <optimized out>
              out = <optimized out>
              unwind_buf = {cancel_jmp_buf = {{jmp_buf = {140271585044704, 1783092640928857216, 140271840872000, 0, 140272525412432, 140271585045056, -1758097990801851264, -1758183593111225216}, mask_was_saved = 0}}, priv = {pad = {0x0, 0x0, 0x0, 0x0}, data = {prev = 0x0, cleanup = 0x0, canceltype = 0}}}
              not_first_call = <optimized out>
      #15 0x00007f93be159bb4 in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:100
      No locals.
       
      Thread 16 (Thread 0x7f93bc118640 (LWP 166) "mariadbd"):
      #0  0x000055c8934b460b in copy_fields (param=0x7f93881151c0) at ./sql/sql_select.cc:28407
              ptr = 0x20000
              end = 0x1000000
              it = <optimized out>
              item = <optimized out>
      #1  0x000055c8934b4b62 in end_write (join=0x7f93880e47c8, join_tab=0x7f9388107e08, end_of_records=<optimized out>) at ./sql/sql_select.cc:24972
              table = 0x7f938810a5e0
      #2  0x000055c893488de7 in evaluate_join_record (join=0x7f93880e47c8, join_tab=0x7f9388107990, error=<optimized out>) at ./sql/sql_select.cc:23671
              rc = <optimized out>
              found = <optimized out>
              return_tab = <optimized out>
              shortcut_for_distinct = false
              found_records = 1
              select_cond = <optimized out>
              select_cond_result = <optimized out>
      #3  0x000055c89349925b in sub_select (join=0x7f93880e47c8, join_tab=0x7f9388107990, end_of_records=false) at ./sql/sql_select.cc:23438
              error = <optimized out>
              rc = <optimized out>
              skip_over = <optimized out>
              info = <optimized out>
      #4  0x000055c893488de7 in evaluate_join_record (join=0x7f93880e47c8, join_tab=0x7f9388107518, error=<optimized out>) at ./sql/sql_select.cc:23671
              rc = <optimized out>
              found = <optimized out>
              return_tab = <optimized out>
              shortcut_for_distinct = false
              found_records = 1
              select_cond = <optimized out>
              select_cond_result = <optimized out>
      #5  0x000055c89349925b in sub_select (join=0x7f93880e47c8, join_tab=0x7f9388107518, end_of_records=false) at ./sql/sql_select.cc:23438
              error = <optimized out>
              rc = <optimized out>
              skip_over = <optimized out>
              info = <optimized out>
      #6  0x000055c893488de7 in evaluate_join_record (join=0x7f93880e47c8, join_tab=0x7f93881070a0, error=<optimized out>) at ./sql/sql_select.cc:23671
              rc = <optimized out>
              found = <optimized out>
              return_tab = <optimized out>
              shortcut_for_distinct = false
              found_records = 1
              select_cond = <optimized out>
              select_cond_result = <optimized out>
      #7  0x000055c8934992d4 in sub_select (join=0x7f93880e47c8, join_tab=0x7f93881070a0, end_of_records=false) at ./sql/sql_select.cc:23475
              error = <optimized out>
              rc = <optimized out>
              skip_over = <optimized out>
              info = 0x7f9388107170
      #8  0x000055c8934cd3d4 in do_select (procedure=<optimized out>, join=0x7f93880e47c8) at ./sql/sql_select.cc:22955
              join_tab = <optimized out>
              rc = 0
              error = NESTED_LOOP_OK
              top_level_tables = <optimized out>
              rc = <optimized out>
              error = <optimized out>
              top_level_tables = <optimized out>
              res = <optimized out>
              last_tab = <optimized out>
              state = <optimized out>
              end_select = <optimized out>
              cleared_tables = <optimized out>
              columns_list = <optimized out>
              join_tab = <optimized out>
              sort_tab = <optimized out>
              join_tab = <optimized out>
              const_tables = <optimized out>
      #9  JOIN::exec_inner (this=0x7f93880e47c8) at ./sql/sql_select.cc:4935
              columns_list = <optimized out>
              trace_wrapper = {<Json_writer_struct> = {_vptr.Json_writer_struct = <optimized out>, my_writer = 0x0, context = {writer = <optimized out>}, closed = false}, <No data fields>}
              trace_exec = {<Json_writer_struct> = {_vptr.Json_writer_struct = <optimized out>, my_writer = <optimized out>, context = {writer = <optimized out>}, closed = false}, <No data fields>}
              trace_steps = {<Json_writer_struct> = {_vptr.Json_writer_struct = 0x55c8943b9bf8 <vtable for Json_writer_array+16>, my_writer = 0x0, context = {writer = 0x0}, closed = false}, <No data fields>}
      #10 0x000055c8934cd80f in JOIN::exec (this=this@entry=0x7f93880e47c8) at ./sql/sql_select.cc:4712
              res = <optimized out>
      #11 0x000055c8934cb78c in mysql_select (thd=0x7f9388001128, tables=0x7f93880151b8, fields=<optimized out>, conds=0x7f93880e3988, og_num=2, order=0x7f93880e3c08, group=0x0, having=0x0, proc_param=0x0, select_options=<optimized out>, result=0x7f93880e3f10, unit=0x7f9388005478, select_lex=0x7f9388014268) at ./sql/sql_select.cc:5243
              err = 0
              free_join = true
              exec_error = false
              join = 0x7f93880e47c8
      #12 0x000055c8934cbf84 in handle_select (thd=thd@entry=0x7f9388001128, lex=lex@entry=0x7f9388005398, result=result@entry=0x7f93880e3f10, setup_tables_done_option=setup_tables_done_option@entry=0) at ./sql/sql_select.cc:628
              unit = 0x7f9388005478
              res = <optimized out>
              select_lex = 0x7f9388014268
      #13 0x000055c89343f8f5 in execute_sqlcom_select (thd=0x7f9388001128, all_tables=0x7f93880151b8) at ./sql/sql_parse.cc:6056
              save_protocol = 0x0
              lex = 0x7f9388005398
              result = 0x7f93880e3f10
              res = false
      #14 0x000055c89344e84e in mysql_execute_command (thd=0x7f9388001128, is_called_from_prepared_stmt=<optimized out>) at ./sql/sql_parse.cc:3944
              privileges_requested = <optimized out>
              wsrep_error_label = <optimized out>
              error = <optimized out>
              res = 0
              lex = 0x7f9388005398
              select_lex = <optimized out>
              first_table = 0x7f93880151b8
              all_tables = 0x7f93880151b8
              unit = 0x7f9388005478
              rpl_filter = <optimized out>
              ots = {ctx = 0x7f9388005038, traceable = false}
              orig_binlog_format = BINLOG_FORMAT_MIXED
              orig_current_stmt_binlog_format = BINLOG_FORMAT_STMT
      #15 0x000055c89344fb77 in mysql_parse (thd=0x7f9388001128, rawbuf=<optimized out>, length=<optimized out>, parser_state=<optimized out>) at ./sql/sql_parse.cc:7800
              found_semicolon = <optimized out>
              error = <optimized out>
              lex = 0x7f9388005398
              err = <optimized out>
      #16 0x000055c89345235d in dispatch_command (command=COM_QUERY, thd=0x7f9388001128, packet=<optimized out>, packet_length=<optimized out>, blocking=<optimized out>) at ./sql/sql_parse.cc:1989
              beginning_of_next_stmt = <optimized out>
              length = <optimized out>
              packet_end = 0x7f93880138fd ""
              parser_state = {m_lip = {lookahead_token = -1, lookahead_yylval = 0x0, m_thd = 0x7f9388001128, m_ptr = 0x7f93880138fe "\004", m_tok_start = 0x7f93880138fe "\004", m_tok_end = 0x7f93880138fe "\004", m_end_of_query = 0x7f93880138fd "", m_tok_start_prev = 0x7f93880138fd "", m_buf = 0x7f9388012ff0 "SELECT\n    TopComments.id AS TopComments__id,\n    TopComments.article_id AS TopComments__article_id,\n    TopComments.body AS TopComments__body,\n    TopComments.votes AS TopComments__votes,\n    TopComm"..., m_buf_length = 2317, m_echo = true, m_echo_saved = false, m_cpp_buf = 0x7f9388013958 "SELECT\n    TopComments.id AS TopComments__id,\n    TopComments.article_id AS TopComments__article_id,\n    TopComments.body AS TopComments__body,\n    TopComments.votes AS TopComments__votes,\n    TopComm"..., m_cpp_ptr = 0x7f9388014265 "", m_cpp_tok_start = 0x7f9388014265 "", m_cpp_tok_start_prev = 0x7f9388014265 "", m_cpp_tok_end = 0x7f9388014265 "", m_body_utf8 = 0x0, m_body_utf8_ptr = 0x55c8945fa800 <dbname_cache_init()::buf> "", m_cpp_utf8_processed_ptr = 0x0, next_state = MY_LEX_END, found_semicolon = 0x0, ignore_space = false, stmt_prepare_mode = false, multi_statements = true, yylineno = 59, m_digest = 0x0, in_comment = NO_COMMENT, in_comment_saved = (PRESERVE_COMMENT | DISCARD_COMMENT | unknown: 0x7f90), m_cpp_text_start = 0x7f938801425f "id ASC", m_cpp_text_end = 0x7f9388014261 " ASC", m_underscore_cs = 0x0}, m_yacc = {yacc_yyss = 0x0, yacc_yyvs = 0x0, m_set_signal_info = {m_item = {0x0 <repeats 13 times>}}, m_lock_type = TL_READ_DEFAULT, m_mdl_type = MDL_SHARED_READ}, m_digest_psi = 0x0}
              net = 0x7f93880013e0
              error = false
              do_end_of_statement = true
              drop_more_results = false
              __FUNCTION__ = "dispatch_command"
              res = <optimized out>
      #17 0x000055c893454158 in do_command (thd=0x7f9388001128, blocking=blocking@entry=true) at ./sql/sql_parse.cc:1405
              return_value = <optimized out>
              packet = 0x7f93880087a8 "\002"
              packet_length = <optimized out>
              net = 0x7f93880013e0
              command = COM_QUERY
              __FUNCTION__ = "do_command"
      #18 0x000055c89357b8cf in do_handle_one_connection (connect=<optimized out>, put_in_cache=true) at ./sql/sql_connect.cc:1445
              create_user = true
              thr_create_utime = <optimized out>
              thd = 0x7f9388001128
      #19 0x000055c89357bc1d in handle_one_connection (arg=arg@entry=0x55c895fcf5e8) at ./sql/sql_connect.cc:1347
              connect = 0x55c895fcf5e8
      #20 0x000055c8938f3fa6 in pfs_spawn_thread (arg=0x55c895f78738) at ./storage/perfschema/pfs.cc:2201
              typed_arg = 0x55c895f78738
              user_arg = 0x55c895fcf5e8
              user_start_routine = 0x55c89357bbc0 <handle_one_connection(void*)>
              pfs = <optimized out>
              klass = <optimized out>
      #21 0x00007f93be0c8b43 in start_thread (arg=<optimized out>) at ./nptl/pthread_create.c:442
              ret = <optimized out>
              pd = <optimized out>
              out = <optimized out>
              unwind_buf = {cancel_jmp_buf = {{jmp_buf = {140723031921296, 1783092640928857216, 140272492185152, 2, 140272525412432, 140723031921648, -1758187890909807488, -1758183593111225216}, mask_was_saved = 0}}, priv = {pad = {0x0, 0x0, 0x0, 0x0}, data = {prev = 0x0, cleanup = 0x0, canceltype = 0}}}
              not_first_call = <optimized out>
      #22 0x00007f93be159bb4 in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:100
      No locals.
       
      Thread 15 (Thread 0x7f93bc163640 (LWP 145) "mariadbd"):
      #0  0x00007f93be07721a in __GI___sigtimedwait (set=0x7f93bc162b50, info=0x7f93bc162bd0, timeout=0x0) at ../sysdeps/unix/sysv/linux/sigtimedwait.c:61
              result = <optimized out>
      #1  0x000055c89333b11b in my_sigwait (code=<synthetic pointer>, sig=0x7f93bc162b48, set=0x7f93bc162b50) at ./include/my_pthread.h:195
              siginfo = {si_signo = 135168, si_errno = 0, si_code = 135168, __pad0 = 0, _sifields = {_pad = {10, 0, 41, 58, 1, 0, 0, 0, 0, 0, 124, 119, 110, 92, 2904, 0, -1571530800, 32764, -448, -1, 1744830512, 32659, 586290432, 1668133314, -1779233544, 21960, -448, -1}, _kill = {si_pid = 10, si_uid = 0}, _timer = {si_tid = 10, si_overrun = 0, si_sigval = {sival_int = 41, sival_ptr = 0x3a00000029}}, _rt = {si_pid = 10, si_uid = 0, si_sigval = {sival_int = 41, sival_ptr = 0x3a00000029}}, _sigchld = {si_pid = 10, si_uid = 0, si_status = 41, si_utime = 1, si_stime = 0}, _sigfault = {si_addr = 0xa, si_addr_lsb = 41, _bounds = {_addr_bnd = {_lower = 0x1, _upper = 0x0}, _pkey = 1}}, _sigpoll = {si_band = 10, si_fd = 41}, _sigsys = {_call_addr = 0xa, _syscall = 41, _arch = 58}}}
              siginfo = <optimized out>
      #2  signal_hand (arg=arg@entry=0x0) at ./sql/mysqld.cc:3277
              error = <optimized out>
              origin = <optimized out>
              set = {__val = {548869, 0 <repeats 11 times>, 176093659136, 640, 0, 140272525466965}}
              sig = -1
      #3  0x000055c8938f3fa6 in pfs_spawn_thread (arg=0x55c895f30cf8) at ./storage/perfschema/pfs.cc:2201
              typed_arg = 0x55c895f30cf8
              user_arg = 0x0
              user_start_routine = 0x55c89333afd0 <signal_hand(void*)>
              pfs = <optimized out>
              klass = <optimized out>
      #4  0x00007f93be0c8b43 in start_thread (arg=<optimized out>) at ./nptl/pthread_create.c:442
              ret = <optimized out>
              pd = <optimized out>
              out = <optimized out>
              unwind_buf = {cancel_jmp_buf = {{jmp_buf = {140723031922288, 1783092640928857216, 140272492492352, 2, 140272525412432, 140723031922640, -1758187936543835008, -1758183593111225216}, mask_was_saved = 0}}, priv = {pad = {0x0, 0x0, 0x0, 0x0}, data = {prev = 0x0, cleanup = 0x0, canceltype = 0}}}
              not_first_call = <optimized out>
      #5  0x00007f93be159bb4 in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:100
      No locals.
       
      Thread 13 (Thread 0x7f9385ffb640 (LWP 143) "mariadbd"):
      #0  __futex_abstimed_wait_common64 (private=586290432, cancel=true, abstime=0x7f9385ffabf0, op=137, expected=0, futex_word=0x55c895a9cfd8) at ./nptl/futex-internal.c:57
              sc_cancel_oldtype = 0
              sc_ret = <optimized out>
              resultvar = <optimized out>
              __arg6 = <optimized out>
              __arg5 = <optimized out>
              __arg4 = <optimized out>
              __arg3 = <optimized out>
              __arg2 = <optimized out>
              __arg1 = <optimized out>
              _a6 = <optimized out>
              _a5 = <optimized out>
              _a4 = <optimized out>
              _a3 = <optimized out>
              _a2 = <optimized out>
              _a1 = <optimized out>
      #1  __futex_abstimed_wait_common (cancel=true, private=586290432, abstime=0x7f9385ffabf0, clockid=0, expected=0, futex_word=0x55c895a9cfd8) at ./nptl/futex-internal.c:87
              err = <optimized out>
              clockbit = 256
              op = 137
              err = <optimized out>
              clockbit = <optimized out>
              op = <optimized out>
      #2  __GI___futex_abstimed_wait_cancelable64 (futex_word=futex_word@entry=0x55c895a9cfd8, expected=expected@entry=0, clockid=clockid@entry=1, abstime=abstime@entry=0x7f9385ffabf0, private=private@entry=0) at ./nptl/futex-internal.c:139
      No locals.
      #3  0x00007f93be0c835d in __pthread_cond_wait_common (abstime=0x7f9385ffabf0, clockid=1, mutex=0x55c895a9ca20, cond=0x55c895a9cfb0) at ./nptl/pthread_cond_wait.c:503
              spin = 0
              buffer = {__routine = 0x7f93be0c77a0 <__condvar_cleanup_waiting>, __arg = 0x7f9385ffab70, __canceltype = 1, __prev = 0x0}
              cbuffer = {wseq = 424, cond = 0x55c895a9cfb0, mutex = 0x55c895a9ca20, private = 0}
              err = <optimized out>
              g = 0
              flags = <optimized out>
              g1_start = <optimized out>
              maxspin = 0
              signals = <optimized out>
              result = 0
              wseq = 424
              seq = 212
              private = 0
              maxspin = <optimized out>
              err = <optimized out>
              result = <optimized out>
              wseq = <optimized out>
              g = <optimized out>
              seq = <optimized out>
              flags = <optimized out>
              private = <optimized out>
              signals = <optimized out>
              done = <optimized out>
              g1_start = <optimized out>
              spin = <optimized out>
              buffer = <optimized out>
              cbuffer = <optimized out>
              s = <optimized out>
      #4  ___pthread_cond_clockwait64 (abstime=0x7f9385ffabf0, clockid=1, mutex=0x55c895a9ca20, cond=0x55c895a9cfb0) at ./nptl/pthread_cond_wait.c:691
      No locals.
      #5  ___pthread_cond_clockwait64 (cond=0x55c895a9cfb0, mutex=0x55c895a9ca20, clockid=1, abstime=0x7f9385ffabf0) at ./nptl/pthread_cond_wait.c:679
      No locals.
      #6  0x000055c893b8232f in std::__condvar::wait_until (__abs_time=@0x7f9385ffabf0: {tv_sec = 11935, tv_nsec = 466378050}, __clock=1, __m=<optimized out>, this=0x55c895a9cfb0) at /usr/include/c++/11/bits/std_mutex.h:123
      No locals.
      #7  std::condition_variable::__wait_until_impl<std::chrono::duration<long, std::ratio<1l, 1000000000l> > > (__lock=@0x7f9385ffac40: {_M_device = 0x55c895a9ca20, _M_owns = true}, __lock=@0x7f9385ffac40: {_M_device = 0x55c895a9ca20, _M_owns = true}, __atime=<optimized out>, this=0x55c895a9cfb0) at /usr/include/c++/11/condition_variable:201
              __s = <optimized out>
              __ns = <optimized out>
              __ts = {tv_sec = 11935, tv_nsec = 466378050}
      #8  std::condition_variable::wait_until<std::chrono::duration<long, std::ratio<1l, 1000000000l> > > (__atime=<optimized out>, __lock=@0x7f9385ffac40: {_M_device = 0x55c895a9ca20, _M_owns = true}, this=0x55c895a9cfb0) at /usr/include/c++/11/condition_variable:111
      No locals.
      #9  std::condition_variable::wait_for<long, std::ratio<1l, 1000l> > (__rtime=@0x55c895a9ca48: {__r = 60000}, __rtime=@0x55c895a9ca48: {__r = 60000}, __lock=@0x7f9385ffac40: {_M_device = 0x55c895a9ca20, _M_owns = true}, this=0x55c895a9cfb0) at /usr/include/c++/11/condition_variable:163
      No locals.
      #10 tpool::thread_pool_generic::wait_for_tasks (this=this@entry=0x55c895a9c900, lk=@0x7f9385ffac40: {_M_device = 0x55c895a9ca20, _M_owns = true}, thread_data=thread_data@entry=0x55c895a9cfb0) at ./tpool/tpool_generic.cc:480
              __PRETTY_FUNCTION__ = "bool tpool::thread_pool_generic::wait_for_tasks(std::unique_lock<std::mutex>&, tpool::worker_data*)"
      #11 0x000055c893b82b68 in tpool::thread_pool_generic::get_task (this=0x55c895a9c900, thread_var=0x55c895a9cfb0, t=0x7f9385ffac88) at ./tpool/tpool_generic.cc:533
              lk = {_M_device = 0x55c895a9ca20, _M_owns = true}
      #12 0x000055c893b82cd5 in tpool::thread_pool_generic::worker_main (this=0x55c895a9c900, thread_var=0x55c895a9cfb0) at ./tpool/tpool_generic.cc:578
              task = 0x55c894e85ce0 <purge_worker_task>
      #13 0x00007f93be41f2b3 in ?? () from /lib/x86_64-linux-gnu/libstdc++.so.6
      No symbol table info available.
      #14 0x00007f93be0c8b43 in start_thread (arg=<optimized out>) at ./nptl/pthread_create.c:442
              ret = <optimized out>
              pd = <optimized out>
              out = <optimized out>
              unwind_buf = {cancel_jmp_buf = {{jmp_buf = {140271618615344, 1783092640928857216, 140271585048128, 0, 140272525412432, 140271618615696, -1758133729761592192, -1758183593111225216}, mask_was_saved = 0}}, priv = {pad = {0x0, 0x0, 0x0, 0x0}, data = {prev = 0x0, cleanup = 0x0, canceltype = 0}}}
              not_first_call = <optimized out>
      #15 0x00007f93be159bb4 in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:100
      No locals.
       
      Thread 8 (Thread 0x7f93bc1ae640 (LWP 138) "mariadbd"):
      #0  __futex_abstimed_wait_common64 (private=0, cancel=true, abstime=0x0, op=393, expected=0, futex_word=0x55c8945faf4c <COND_manager+44>) at ./nptl/futex-internal.c:57
              sc_cancel_oldtype = 0
              sc_ret = <optimized out>
              resultvar = <optimized out>
              __arg6 = <optimized out>
              __arg5 = <optimized out>
              __arg4 = <optimized out>
              __arg3 = <optimized out>
              __arg2 = <optimized out>
              __arg1 = <optimized out>
              _a6 = <optimized out>
              _a5 = <optimized out>
              _a4 = <optimized out>
              _a3 = <optimized out>
              _a2 = <optimized out>
              _a1 = <optimized out>
      #1  __futex_abstimed_wait_common (cancel=true, private=0, abstime=0x0, clockid=0, expected=0, futex_word=0x55c8945faf4c <COND_manager+44>) at ./nptl/futex-internal.c:87
              err = <optimized out>
              clockbit = 256
              op = 393
              err = <optimized out>
              clockbit = <optimized out>
              op = <optimized out>
      #2  __GI___futex_abstimed_wait_cancelable64 (futex_word=futex_word@entry=0x55c8945faf4c <COND_manager+44>, expected=expected@entry=0, clockid=clockid@entry=0, abstime=abstime@entry=0x0, private=private@entry=0) at ./nptl/futex-internal.c:139
      No locals.
      #3  0x00007f93be0c7ac1 in __pthread_cond_wait_common (abstime=0x0, clockid=0, mutex=0x55c8945faf60 <LOCK_manager>, cond=0x55c8945faf20 <COND_manager>) at ./nptl/pthread_cond_wait.c:503
              spin = 0
              buffer = {__routine = 0x7f93be0c77a0 <__condvar_cleanup_waiting>, __arg = 0x7f93bc1adbd0, __canceltype = -2147455128, __prev = 0x0}
              cbuffer = {wseq = 3, cond = 0x55c8945faf20 <COND_manager>, mutex = 0x55c8945faf60 <LOCK_manager>, private = 0}
              err = <optimized out>
              g = 1
              flags = <optimized out>
              g1_start = <optimized out>
              maxspin = 0
              signals = <optimized out>
              result = 0
              wseq = 3
              seq = 1
              private = 0
              maxspin = <optimized out>
              err = <optimized out>
              result = <optimized out>
              wseq = <optimized out>
              g = <optimized out>
              seq = <optimized out>
              flags = <optimized out>
              private = <optimized out>
              signals = <optimized out>
              done = <optimized out>
              g1_start = <optimized out>
              spin = <optimized out>
              buffer = <optimized out>
              cbuffer = <optimized out>
              s = <optimized out>
      #4  ___pthread_cond_wait (cond=0x55c8945faf20 <COND_manager>, mutex=0x55c8945faf60 <LOCK_manager>) at ./nptl/pthread_cond_wait.c:627
      No locals.
      #5  0x000055c89343e630 in inline_mysql_cond_wait (that=0x55c8945faf20 <COND_manager>, mutex=0x55c8945faf60 <LOCK_manager>, src_file=0x55c893cd4857 "./sql/sql_manager.cc", src_line=103) at ./include/mysql/psi/mysql_thread.h:1072
      No locals.
      #6  handle_manager (arg=arg@entry=0x0) at ./sql/sql_manager.cc:103
              cb = <optimized out>
              error = 0
              abstime = {tv_sec = 94319991316792, tv_nsec = 0}
              reset_flush_time = true
      #7  0x000055c8938f3fa6 in pfs_spawn_thread (arg=0x55c89593e138) at ./storage/perfschema/pfs.cc:2201
              typed_arg = 0x55c89593e138
              user_arg = 0x0
              user_start_routine = 0x55c89343e580 <handle_manager(void*)>
              pfs = <optimized out>
              klass = <optimized out>
      #8  0x00007f93be0c8b43 in start_thread (arg=<optimized out>) at ./nptl/pthread_create.c:442
              ret = <optimized out>
              pd = <optimized out>
              out = <optimized out>
              unwind_buf = {cancel_jmp_buf = {{jmp_buf = {140723031913456, 1783092640928857216, 140272492799552, 0, 140272525412432, 140723031913808, -1758187834001490816, -1758183593111225216}, mask_was_saved = 0}}, priv = {pad = {0x0, 0x0, 0x0, 0x0}, data = {prev = 0x0, cleanup = 0x0, canceltype = 0}}}
              not_first_call = <optimized out>
      #9  0x00007f93be159bb4 in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:100
      No locals.
       
      Thread 4 (Thread 0x7f939c9ff640 (LWP 134) "mariadbd"):
      #0  __futex_abstimed_wait_common64 (private=0, cancel=true, abstime=0x0, op=393, expected=0, futex_word=0x55c89454afa8 <buf_pool+17192>) at ./nptl/futex-internal.c:57
              sc_cancel_oldtype = 0
              sc_ret = <optimized out>
              resultvar = <optimized out>
              __arg6 = <optimized out>
              __arg5 = <optimized out>
              __arg4 = <optimized out>
              __arg3 = <optimized out>
              __arg2 = <optimized out>
              __arg1 = <optimized out>
              _a6 = <optimized out>
              _a5 = <optimized out>
              _a4 = <optimized out>
              _a3 = <optimized out>
              _a2 = <optimized out>
              _a1 = <optimized out>
      #1  __futex_abstimed_wait_common (cancel=true, private=0, abstime=0x0, clockid=0, expected=0, futex_word=0x55c89454afa8 <buf_pool+17192>) at ./nptl/futex-internal.c:87
              err = <optimized out>
              clockbit = 256
              op = 393
              err = <optimized out>
              clockbit = <optimized out>
              op = <optimized out>
      #2  __GI___futex_abstimed_wait_cancelable64 (futex_word=futex_word@entry=0x55c89454afa8 <buf_pool+17192>, expected=expected@entry=0, clockid=clockid@entry=0, abstime=abstime@entry=0x0, private=private@entry=0) at ./nptl/futex-internal.c:139
      No locals.
      #3  0x00007f93be0c7ac1 in __pthread_cond_wait_common (abstime=0x0, clockid=0, mutex=0x55c89454af00 <buf_pool+17024>, cond=0x55c89454af80 <buf_pool+17152>) at ./nptl/pthread_cond_wait.c:503
              spin = 0
              buffer = {__routine = 0x7f93be0c77a0 <__condvar_cleanup_waiting>, __arg = 0x7f939c9febb0, __canceltype = -1806406528, __prev = 0x0}
              cbuffer = {wseq = 2, cond = 0x55c89454af80 <buf_pool+17152>, mutex = 0x55c89454af00 <buf_pool+17024>, private = 0}
              err = <optimized out>
              g = 0
              flags = <optimized out>
              g1_start = <optimized out>
              maxspin = 0
              signals = <optimized out>
              result = 0
              wseq = 2
              seq = 1
              private = 0
              maxspin = <optimized out>
              err = <optimized out>
              result = <optimized out>
              wseq = <optimized out>
              g = <optimized out>
              seq = <optimized out>
              flags = <optimized out>
              private = <optimized out>
              signals = <optimized out>
              done = <optimized out>
              g1_start = <optimized out>
              spin = <optimized out>
              buffer = <optimized out>
              cbuffer = <optimized out>
              s = <optimized out>
      #4  ___pthread_cond_wait (cond=0x55c89454af80 <buf_pool+17152>, mutex=0x55c89454af00 <buf_pool+17024>) at ./nptl/pthread_cond_wait.c:627
      No locals.
      #5  0x000055c893af5069 in buf_flush_page_cleaner () at ./storage/innobase/buf/buf0flu.cc:2355
              soft_lsn_limit = <optimized out>
              oldest_lsn = <optimized out>
              pct_lwm = <optimized out>
              n_flushed = <optimized out>
              n = <optimized out>
              dirty_blocks = <optimized out>
              dirty_pct = <optimized out>
              last_pages = 0
              abstime = {tv_sec = 1690556399, tv_nsec = 513407000}
              lsn_limit = 0
              last_activity_count = 0
      #6  0x00007f93be41f2b3 in ?? () from /lib/x86_64-linux-gnu/libstdc++.so.6
      No symbol table info available.
      #7  0x00007f93be0c8b43 in start_thread (arg=<optimized out>) at ./nptl/pthread_create.c:442
              ret = <optimized out>
              pd = <optimized out>
              out = <optimized out>
              unwind_buf = {cancel_jmp_buf = {{jmp_buf = {140723031903824, 1783092640928857216, 140271964649024, 12, 140272525412432, 140723031904176, -1758118609329226624, -1758183593111225216}, mask_was_saved = 0}}, priv = {pad = {0x0, 0x0, 0x0, 0x0}, data = {prev = 0x0, cleanup = 0x0, canceltype = 0}}}
              not_first_call = <optimized out>
      #8  0x00007f93be159bb4 in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:100
      No locals.
       
      Thread 3 (Thread 0x7f93a9759640 (LWP 133) "mariadbd"):
      #0  __futex_abstimed_wait_common64 (private=0, cancel=true, abstime=0x7f93a9758c20, op=393, expected=0, futex_word=0x55c894e2ece8 <COND_checkpoint+40>) at ./nptl/futex-internal.c:57
              sc_cancel_oldtype = 0
              sc_ret = <optimized out>
              resultvar = <optimized out>
              __arg6 = <optimized out>
              __arg5 = <optimized out>
              __arg4 = <optimized out>
              __arg3 = <optimized out>
              __arg2 = <optimized out>
              __arg1 = <optimized out>
              _a6 = <optimized out>
              _a5 = <optimized out>
              _a4 = <optimized out>
              _a3 = <optimized out>
              _a2 = <optimized out>
              _a1 = <optimized out>
      #1  __futex_abstimed_wait_common (cancel=true, private=0, abstime=0x7f93a9758c20, clockid=0, expected=0, futex_word=0x55c894e2ece8 <COND_checkpoint+40>) at ./nptl/futex-internal.c:87
              err = <optimized out>
              clockbit = 256
              op = 393
              err = <optimized out>
              clockbit = <optimized out>
              op = <optimized out>
      #2  __GI___futex_abstimed_wait_cancelable64 (futex_word=futex_word@entry=0x55c894e2ece8 <COND_checkpoint+40>, expected=expected@entry=0, clockid=clockid@entry=0, abstime=abstime@entry=0x7f93a9758c20, private=private@entry=0) at ./nptl/futex-internal.c:139
      No locals.
      #3  0x00007f93be0c7f1b in __pthread_cond_wait_common (abstime=0x7f93a9758c20, clockid=0, mutex=0x55c894e2ed00 <LOCK_checkpoint>, cond=0x55c894e2ecc0 <COND_checkpoint>) at ./nptl/pthread_cond_wait.c:503
              spin = 0
              buffer = {__routine = 0x7f93be0c77a0 <__condvar_cleanup_waiting>, __arg = 0x7f93a9758bb0, __canceltype = 0, __prev = 0x0}
              cbuffer = {wseq = 14, cond = 0x55c894e2ecc0 <COND_checkpoint>, mutex = 0x55c894e2ed00 <LOCK_checkpoint>, private = 0}
              err = <optimized out>
              g = 0
              flags = <optimized out>
              g1_start = <optimized out>
              maxspin = 0
              signals = <optimized out>
              result = 0
              wseq = 14
              seq = 7
              private = 0
              maxspin = <optimized out>
              err = <optimized out>
              result = <optimized out>
              wseq = <optimized out>
              g = <optimized out>
              seq = <optimized out>
              flags = <optimized out>
              private = <optimized out>
              signals = <optimized out>
              done = <optimized out>
              g1_start = <optimized out>
              spin = <optimized out>
              buffer = <optimized out>
              cbuffer = <optimized out>
              s = <optimized out>
      #4  ___pthread_cond_timedwait64 (cond=0x55c894e2ecc0 <COND_checkpoint>, mutex=0x55c894e2ed00 <LOCK_checkpoint>, abstime=abstime@entry=0x7f93a9758c20) at ./nptl/pthread_cond_wait.c:652
              flags = <optimized out>
              clockid = 0
      #5  0x000055c893887df2 in inline_mysql_cond_timedwait (src_file=0x55c893e392b0 "./storage/maria/ma_servicethread.c", src_line=115, abstime=0x7f93a9758c20, mutex=<optimized out>, that=<optimized out>) at ./include/mysql/psi/mysql_thread.h:1088
      No locals.
      #6  my_service_thread_sleep (control=control@entry=0x55c894531dc0 <checkpoint_control>, sleep_time=sleep_time@entry=30000000000) at ./storage/maria/ma_servicethread.c:115
              abstime = {tv_sec = 1690556636, tv_nsec = 525930000}
              res = 0 '\000'
      #7  0x000055c89388015e in ma_checkpoint_background (arg=0x1e) at ./storage/maria/ma_checkpoint.c:725
              interval = 30
              sleeps = 210
              sleep_time = 30
              log_horizon_at_last_checkpoint = 4311840914
              pagecache_flushes_at_last_checkpoint = 0
              pages_bunch_size = 0
              filter_param = {up_to_lsn = 4311840870, max_pages = 0}
              dfile = 0x0
              kfile = 0x0
      #8  0x00007f93be0c8b43 in start_thread (arg=<optimized out>) at ./nptl/pthread_create.c:442
              ret = <optimized out>
              pd = <optimized out>
              out = <optimized out>
              unwind_buf = {cancel_jmp_buf = {{jmp_buf = {140723031909424, 1783092640928857216, 140272179975744, 0, 140272525412432, 140723031909776, -1758229437739074432, -1758183593111225216}, mask_was_saved = 0}}, priv = {pad = {0x0, 0x0, 0x0, 0x0}, data = {prev = 0x0, cleanup = 0x0, canceltype = 0}}}
              not_first_call = <optimized out>
      #9  0x00007f93be159bb4 in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:100
      No locals.
       
      Thread 2 (Thread 0x7f93bdb80640 (LWP 132) "mariadbd"):
      #0  __futex_abstimed_wait_common64 (private=0, cancel=true, abstime=0x7f93bdb7fc90, op=393, expected=0, futex_word=0x55c894ebbd8c <COND_timer+44>) at ./nptl/futex-internal.c:57
              sc_cancel_oldtype = 0
              sc_ret = <optimized out>
              resultvar = <optimized out>
              __arg6 = <optimized out>
              __arg5 = <optimized out>
              __arg4 = <optimized out>
              __arg3 = <optimized out>
              __arg2 = <optimized out>
              __arg1 = <optimized out>
              _a6 = <optimized out>
              _a5 = <optimized out>
              _a4 = <optimized out>
              _a3 = <optimized out>
              _a2 = <optimized out>
              _a1 = <optimized out>
      #1  __futex_abstimed_wait_common (cancel=true, private=0, abstime=0x7f93bdb7fc90, clockid=0, expected=0, futex_word=0x55c894ebbd8c <COND_timer+44>) at ./nptl/futex-internal.c:87
              err = <optimized out>
              clockbit = 256
              op = 393
              err = <optimized out>
              clockbit = <optimized out>
              op = <optimized out>
      #2  __GI___futex_abstimed_wait_cancelable64 (futex_word=futex_word@entry=0x55c894ebbd8c <COND_timer+44>, expected=expected@entry=0, clockid=clockid@entry=0, abstime=abstime@entry=0x7f93bdb7fc90, private=private@entry=0) at ./nptl/futex-internal.c:139
      No locals.
      #3  0x00007f93be0c7f1b in __pthread_cond_wait_common (abstime=0x7f93bdb7fc90, clockid=0, mutex=0x55c894ebbda0 <LOCK_timer>, cond=0x55c894ebbd60 <COND_timer>) at ./nptl/pthread_cond_wait.c:503
              spin = 0
              buffer = {__routine = 0x7f93be0c77a0 <__condvar_cleanup_waiting>, __arg = 0x7f93bdb7fc00, __canceltype = -1784034784, __prev = 0x0}
              cbuffer = {wseq = 1755, cond = 0x55c894ebbd60 <COND_timer>, mutex = 0x55c894ebbda0 <LOCK_timer>, private = 0}
              err = <optimized out>
              g = 1
              flags = <optimized out>
              g1_start = <optimized out>
              maxspin = 0
              signals = <optimized out>
              result = 0
              wseq = 1755
              seq = 877
              private = 0
              maxspin = <optimized out>
              err = <optimized out>
              result = <optimized out>
              wseq = <optimized out>
              g = <optimized out>
              seq = <optimized out>
              flags = <optimized out>
              private = <optimized out>
              signals = <optimized out>
              done = <optimized out>
              g1_start = <optimized out>
              spin = <optimized out>
              buffer = <optimized out>
              cbuffer = <optimized out>
              s = <optimized out>
      #4  ___pthread_cond_timedwait64 (cond=cond@entry=0x55c894ebbd60 <COND_timer>, mutex=mutex@entry=0x55c894ebbda0 <LOCK_timer>, abstime=abstime@entry=0x7f93bdb7fc90) at ./nptl/pthread_cond_wait.c:652
              flags = <optimized out>
              clockid = 0
      #5  0x000055c893bf25a7 in inline_mysql_cond_timedwait (that=0x55c894ebbd60 <COND_timer>, mutex=0x55c894ebbda0 <LOCK_timer>, src_file=0x55c893eb1b70 "./mysys/thr_timer.c", src_line=321, abstime=0x7f93bdb7fc90) at ./include/mysql/psi/mysql_thread.h:1088
      No locals.
      #6  timer_handler (arg=<optimized out>) at ./mysys/thr_timer.c:321
              error = <optimized out>
              top_time = 0x55c895a9cb20
              now = <optimized out>
              abstime = {tv_sec = 1690556624, tv_nsec = 774721000}
      #7  0x00007f93be0c8b43 in start_thread (arg=<optimized out>) at ./nptl/pthread_create.c:442
              ret = <optimized out>
              pd = <optimized out>
              out = <optimized out>
              unwind_buf = {cancel_jmp_buf = {{jmp_buf = {140723031913424, 1783092640928857216, 140272519874112, 22, 140272525412432, 140723031913776, -1758187122110661504, -1758183593111225216}, mask_was_saved = 0}}, priv = {pad = {0x0, 0x0, 0x0, 0x0}, data = {prev = 0x0, cleanup = 0x0, canceltype = 0}}}
              not_first_call = <optimized out>
      #8  0x00007f93be159bb4 in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:100
      No locals.
       
      Thread 1 (Thread 0x7f93bdcfd8c0 (LWP 1) "mariadbd"):
      #0  0x00007f93be14cd7f in __GI___poll (fds=0x55c895f4fa48, nfds=3, timeout=-1) at ../sysdeps/unix/sysv/linux/poll.c:29
              sc_ret = -516
              sc_cancel_oldtype = 0
              sc_ret = <optimized out>
      #1  0x000055c8933437c2 in poll (__timeout=-1, __nfds=<optimized out>, __fds=<optimized out>) at /usr/include/x86_64-linux-gnu/bits/poll2.h:39
      No locals.
      #2  handle_connections_sockets () at ./sql/mysqld.cc:6362
              sock = {fd = 24, is_unix_domain_socket = <optimized out>, is_extra_port = <optimized out>, address_family = <optimized out>, m_psi = 0x0}
              error_count = 0
              cAddr = {ss_family = 1, __ss_padding = "\000\000\374\177\000\000\000\000\000\000\000\000\000\000Ї\371\225\310U\000\000\000\025\362\"±mc\340l_\224\310U\000\000\000\025\362\"±mc\000\000\000\000\000\000\000\000\240\332$\276\223\177\000\000$\n̓\310U\000\000O\221\024\276\223\177\000\000\000\000\000\000\000\000\000\000\310l_\224", '\000' <repeats 12 times>, "\353\320\v\276\223\177\000\000\244/\343\223\310U\000", __ss_align = 0}
              retval = <optimized out>
              fds = {array = {buffer = 0x55c895f4fa48 "\026", elements = 3, max_element = 16, alloc_increment = 16, size_of_element = 8, m_psi_key = 0, malloc_flags = 0}}
      #3  0x000055c893344ab5 in mysqld_main (argc=<optimized out>, argv=<optimized out>) at ./sql/mysqld.cc:6064
              please_close_stdin = true
              ho_error = <optimized out>
              new_thread_stack_size = <optimized out>
              user = <optimized out>
      #4  0x00007f93be05dd90 in __libc_start_call_main (main=main@entry=0x55c8932f7130 <main(int, char**)>, argc=argc@entry=1, argv=argv@entry=0x7ffca2545fa8) at ../sysdeps/nptl/libc_start_call_main.h:58
              self = <optimized out>
              result = <optimized out>
              unwind_buf = {cancel_jmp_buf = {{jmp_buf = {0, 1783092640928988288, 140723031924648, 94319951180080, 94319968675608, 140272537841728, -1781290304114164608, -1758183667871155072}, mask_was_saved = 0}}, priv = {pad = {0x0, 0x0, 0x55c8932f7130 <main(int, char**)>, 0x0}, data = {prev = 0x0, cleanup = 0x0, canceltype = -1825607376}}}
              not_first_call = <optimized out>
      #5  0x00007f93be05de40 in __libc_start_main_impl (main=0x55c8932f7130 <main(int, char**)>, argc=1, argv=0x7ffca2545fa8, init=<optimized out>, fini=<optimized out>, rtld_fini=<optimized out>, stack_end=0x7ffca2545f98) at ../csu/libc-start.c:392
      No locals.
      #6  0x000055c893338585 in _start ()
      No symbol table info available.
      Warning: 'set logging off', an alias for the command 'set logging enabled', is deprecated.
      Use 'set logging enabled off'.
      

      How to reproduce

      Image

      Spin up a >= 11.0 docker image (the host OS seems to be irrelevant, I've been able to reproduce it on Ubuntu 20.04 and 22.04 as well as on Windows 10):

      docker run --name=mariadb -e MARIADB_ROOT_PASSWORD=root -e MARIADB_DATABASE=test -p 3306:3306 quay.io/mariadb-foundation/mariadb-debug:11.2
      

      Run SQL

      Save the following SQL in a file (crash-test.sql in this example, also attached for convenience) and import/run it (don't mind the odd duplication in the query, it's from the context of an ORM, where transparently adding group wise limits via ranking is most safely done by duplicating the original query):

      docker exec -i mariadb mariadb -uroot -proot test < crash-test.sql
      

      DROP TABLE IF EXISTS `comments`;
      CREATE TABLE `comments` (
          `id` INTEGER,
          `id2` INTEGER,
          `article_id` INTEGER,
          `article_id2` INTEGER,
          `author_id` INTEGER,
          `votes` INTEGER,
          `body` TEXT,
          `published` BOOLEAN,
          PRIMARY KEY (`id`),
          KEY `comments_article_id` (`article_id`, `article_id2`),
          KEY `comments_top_comments_sort` (`votes`, `id`)
      );
       
      DROP TABLE IF EXISTS `comments_i18n`;
      CREATE TABLE `comments_i18n` (
          `id` INTEGER AUTO_INCREMENT,
          `locale` VARCHAR(255),
          `model` VARCHAR(255),
          `foreign_key` INTEGER,
          `field` VARCHAR(255),
          `content` TEXT,
          PRIMARY KEY (`id`),
          UNIQUE KEY `comments_I18N_LOCALE_FIELD` (`locale`, `model`, `foreign_key`, `field`),
          KEY `comments_I18N_FIELD` (`model`, `foreign_key`, `field`)
      );
       
      INSERT INTO `comments` (`id`, `id2`, `article_id`, `article_id2`, `author_id`, `votes`, `body`, `published`) VALUES
          (1, 2, 1, 2, 1, 1, 'Lorem ipsum dolor sit amet', 1),
          (2, 3, 1, 2, 1, 2, 'Lorem ipsum dolor sit amet', 1),
          (3, 4, 1, 2, 2, 3, 'Lorem ipsum dolor sit amet', 1),
          (4, 5, 1, 2, 2, 4, 'Lorem ipsum dolor sit amet', 0),
          (5, 6, 2, 3, 1, 10, 'Lorem ipsum dolor sit amet', 1),
          (6, 7, 2, 3, 1, 9, 'Lorem ipsum dolor sit amet', 1),
          (7, 8, 2, 3, 2, 8, 'Lorem ipsum dolor sit amet', 1),
          (8, 9, 2, 3, 2, 7, 'Lorem ipsum dolor sit amet', 0);
       
      INSERT INTO `comments_i18n` (`locale`, `model`, `foreign_key`, `field`, `content`) VALUES
          ('de_DE', 'Comments', 1, 'body', 'Franz jagt im komplett verwahrlosten Taxi quer durch Bayern'),
          ('de_DE', 'Comments', 2, 'body', 'Der schnelle braune Fuchs springt über den faulen Hund'),
          ('de_DE', 'Comments', 5, 'body', 'Fix Schwyz! quäkt Jürgen blöd vom Paß'),
          ('de_DE', 'Comments', 6, 'body', 'Quod erat demonstrandum.');
       
      SELECT
          TopComments.id AS TopComments__id,
          TopComments.article_id AS TopComments__article_id,
          TopComments.body AS TopComments__body,
          TopComments.votes AS TopComments__votes,
          TopComments_body_translation.id AS TopComments_body_translation__id,
          TopComments_body_translation.content AS TopComments_body_translation__content
      FROM
          comments TopComments
      INNER JOIN
          comments_i18n TopComments_body_translation ON (
              TopComments_body_translation.model = 'Comments'
              AND TopComments_body_translation.field = 'body'
              AND TopComments_body_translation.locale = 'de_DE'
              AND TopComments.id = TopComments_body_translation.foreign_key
          )
      WHERE (
          TopComments.article_id in (1, 2)
          AND TopComments.id in (
              SELECT
                  __ranked__TopComments.id AS id
              FROM (
                  SELECT
                      TopComments.id AS TopComments__id,
                      TopComments.article_id AS TopComments__article_id,
                      TopComments.body AS TopComments__body,
                      TopComments.votes AS TopComments__votes,
                      TopComments.id AS id,
                      (
                          ROW_NUMBER() OVER (
                              PARTITION BY
                                  TopComments.article_id
                              ORDER BY
                                  TopComments.votes DESC,
                                  TopComments.id ASC
                          )
                      ) AS __row_number,
                      TopComments_body_translation.id AS TopComments_body_translation__id,
                      TopComments_body_translation.content AS TopComments_body_translation__content
                  FROM
                      comments TopComments
                  INNER JOIN
                      comments_i18n TopComments_body_translation ON (
                          TopComments_body_translation.model = 'Comments'
                          AND TopComments_body_translation.field = 'body'
                          AND TopComments_body_translation.locale = 'de_DE'
                          AND TopComments.id = TopComments_body_translation.foreign_key
                      )
                  WHERE
                      TopComments.article_id in (1, 2)
              )
              __ranked__TopComments
              WHERE
                  __ranked__TopComments.__row_number <= 3
          )
      )
      ORDER BY
          TopComments.votes DESC,
          TopComments.id ASC;
       
      DROP TABLE `comments`;
      DROP TABLE `comments_i18n`;
      

      Repeat

      Repeat the import step over and over again until the server eventually crashes. You might be able to reproduce by running only the last select query that triggers the crash, personally however I wasn't, I have to run the whole thing with table creation, so that might be related too. And as mentioned initially, it might happen immediately, it might take many many retries, but eventually it should happen. Run it in a loop if neccesary.

      for (( i = 1; i <= 1000; i ++ ))
      do
          echo "attempt $i"
          docker exec -i mariadb mariadb -uroot -proot test < crash-test.sql
          if [ $? -ne 0 ]; then break; fi
          sleep 0.2
      done
      

      Attachments

        1. crash-test.sql
          4 kB
        2. bad_trace
          33 kB
        3. good_trace
          33 kB

        Issue Links

          Activity

            People

              psergei Sergei Petrunia
              oddtl Oliver
              Votes:
              1 Vote for this issue
              Watchers:
              8 Start watching this issue

              Dates

                Created:
                Updated:

                Git Integration

                  Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.