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

[ERROR] [FATAL] InnoDB: innodb_fatal_semaphore_wait_threshold was exceeded for dict_sys.latch.

    XMLWordPrintable

Details

    • Bug
    • Status: Open (View Workflow)
    • Major
    • Resolution: Unresolved
    • 10.6.19
    • None
    • None
    • windows

    Description

      I've been encountering an issue, This would be for MariaDB 10.6.19, running on Windows Sever 2022.

      I grabbed the lines from the error log:

      2024-10-25 21:41:30 29 [Warning] Aborted connection 29 to db: 'dsdb' user: 'mysql' host: '10.55.107.96' (Got an error reading communication packets)
      2024-10-25 21:41:30 28 [Warning] Aborted connection 28 to db: 'dsdb' user: 'mysql' host: '10.55.107.96' (Got an error reading communication packets)
      2024-10-25 21:51:27 75 [Warning] Aborted connection 75 to db: 'dsdb' user: 'mysql' host: '127.0.0.1' (Got an error reading communication packets)
      2024-10-25 21:51:27 74 [Warning] Aborted connection 74 to db: 'dsdb' user: 'mysql' host: '127.0.0.1' (Got an error reading communication packets)
      2024-10-25 23:16:30 0 [ERROR] [FATAL] InnoDB: innodb_fatal_semaphore_wait_threshold was exceeded for dict_sys.latch. Please refer to https://mariadb.com/kb/en/how-to-produce-a-full-stack-trace-for-mysqld/
      2024-10-25 23:16:35 424 [Warning] Aborted connection 424 to db: 'dsdb' user: 'mysql' host: '10.55.107.96' (Got an error reading communication packets)
      2024-10-25 23:16:35 425 [Warning] Aborted connection 425 to db: 'dsdb' user: 'mysql' host: '10.55.107.96' (Got an error reading communication packets)
      2024-10-25 23:16:35 426 [Warning] Aborted connection 426 to db: 'dsdb' user: 'mysql' host: '10.55.107.96' (Got an error reading communication packets)
      241025 23:16:38 [ERROR] mysqld got exception 0x80000003 ;
      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

      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: 10.6.19-MariaDB-log source revision: 8f020508c87461bbeee551c3001acac56d506ae7
      key_buffer_size=134217728
      read_buffer_size=131072
      max_used_connections=112
      max_threads=65537
      thread_count=111
      It is possible that mysqld could use up to
      key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 1082300045 K bytes of memory
      Hope that's ok; if not, decrease some variables in the equation.

      Thread pointer: 0x27d3c35a5e8
      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...
      2024-10-25 23:16:47 421 [Warning] Aborted connection 421 to db: 'dsdb' user: 'mysql' host: '127.0.0.1' (Got an error reading communication packets)
      2024-10-25 23:17:00 435 [Warning] Aborted connection 435 to db: 'unconnected' user: 'unauthenticated' host: '127.0.0.1' (Got an error reading communication packets)
      2024-10-25 23:17:00 436 [Warning] Aborted connection 436 to db: 'unconnected' user: 'unauthenticated' host: '127.0.0.1' (Got an error reading communication packets)
      2024-10-25 23:17:00 435 [Warning] Aborted connection 435 to db: 'unconnected' user: 'unauthenticated' host: '127.0.0.1' (This connection closed normally without authentication)
      2024-10-25 23:17:00 436 [Warning] Aborted connection 436 to db: 'unconnected' user: 'unauthenticated' host: '127.0.0.1' (This connection closed normally without authentication)
      2024-10-25 23:17:00 440 [Warning] Aborted connection 440 to db: 'unconnected' user: 'unauthenticated' host: '127.0.0.1' (Got an error reading communication packets)
      2024-10-25 23:17:00 438 [Warning] Aborted connection 438 to db: 'unconnected' user: 'unauthenticated' host: '127.0.0.1' (Got an error reading communication packets)
      2024-10-25 23:17:00 439 [Warning] Aborted connection 439 to db: 'unconnected' user: 'unauthenticated' host: '127.0.0.1' (Got an error reading communication packets)
      2024-10-25 23:17:00 438 [Warning] Aborted connection 438 to db: 'unconnected' user: 'unauthenticated' host: '127.0.0.1' (This connection closed normally without authentication)
      2024-10-25 23:17:00 439 [Warning] Aborted connection 439 to db: 'unconnected' user: 'unauthenticated' host: '127.0.0.1' (This connection closed normally without authentication)
      2024-10-25 23:17:00 440 [Warning] Aborted connection 440 to db: 'unconnected' user: 'unauthenticated' host: '127.0.0.1' (This connection closed normally without authentication)
      2024-10-25 23:17:01 437 [Warning] Aborted connection 437 to db: 'unconnected' user: 'unauthenticated' host: '127.0.0.1' (Got an error reading communication packets)
      2024-10-25 23:17:01 437 [Warning] Aborted connection 437 to db: 'unconnected' user: 'unauthenticated' host: '127.0.0.1' (This connection closed normally without authentication)
      server.dll!my_parameter_handler()
      ucrtbase.dll!raise()
      ucrtbase.dll!abort()
      server.dll!json_valid()
      server.dll!json_valid()
      server.dll!json_valid()
      server.dll!json_valid()
      server.dll!json_valid()
      server.dll!json_valid()
      server.dll!json_valid()
      server.dll!json_valid()
      ntdll.dll!TpReleaseWork()
      ntdll.dll!RtlInitializeResource()
      KERNEL32.DLL!BaseThreadInitThunk()
      ntdll.dll!RtlUserThreadStart()

      Trying to get some variables.
      Some pointers may be invalid and cause the dump to abort.
      Query (0x0):
      Connection ID (thread ID): 0
      Status: NOT_KILLED

      Optimizer switch: index_merge=off,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

      The manual page at https://mariadb.com/kb/en/how-to-produce-a-full-stack-trace-for-mariadbd/ contains
      information that should help you find out what is causing the crash.
      Writing a core file at C:\dsdb\dsdb Server\mysql\data
      2024-10-25 23:18:28 444 [Warning] Aborted connection 444 to db: 'unconnected' user: 'unauthenticated' host: '127.0.0.1' (Got an error reading communication packets)Minidump written to C:\dsdb\dsdb Server\mysql\data\mysqld.dmp

      2024-10-25 23:18:28 445 [Warning] Aborted connection 445 to db: 'unconnected' user: 'unauthenticated' host: '127.0.0.1' (Got an error reading communication packets)
      2024-10-25 23:18:28 447 [Warning] Aborted connection 447 to db: 'unconnected' user: 'unauthenticated' host: '127.0.0.1' (Got an error reading communication packets)
      2024-10-25 23:18:28 446 [Warning] Aborted connection 446 to db: 'unconnected' user: 'unauthenticated' host: '127.0.0.1' (Got an error reading communication packets)
      2024-10-25 23:18:31 444 [Warning] Aborted connection 444 to db: 'unconnected' user: 'unauthenticated' host: '127.0.0.1' (This connection closed normally without authentication)
      2024-10-25 23:18:31 445 [Warning] Aborted connection 445 to db: 'unconnected' user: 'unauthenticated' host: '127.0.0.1' (This connection closed normally without authentication)
      2024-10-25 23:18:31 447 [Warning] Aborted connection 447 to db: 'unconnected' user: 'unauthenticated' host: '127.0.0.1' (This connection closed normally without authentication)
      2024-10-25 23:18:31 446 [Warning] Aborted connection 446 to db: 'unconnected' user: 'unauthenticated' host: '127.0.0.1' (This connection closed normally without authentication)
      2024-10-25 23:20:34 0 [Note] Starting MariaDB 10.6.19-MariaDB-log source revision 8f020508c87461bbeee551c3001acac56d506ae7 server_uid 99ZwX1QAX3Ca5JecdMKPCSasGhw= as process 8628
      2024-10-25 23:20:35 0 [Note] mysqld: Aria engine: starting recovery
      recovered pages: 0% 16% 27% 49% 61% 82% 95% 100% (0.1 seconds); tables to flush: 1 0
      (0.1 seconds);

      Attachments

        1. all_threads_stacktrace_and_more.txt
          101 kB
        2. my.ini
          2 kB
        3. mysqld.dmp
          551 kB
        4. screenshot-1.png
          screenshot-1.png
          247 kB

        Activity

          People

            marko Marko Mäkelä
            kennyliao kennyliao
            Votes:
            0 Vote for this issue
            Watchers:
            3 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.