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

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

Details

    Description

      2025-02-04  4:00:49 14153 [Warning] Access denied for user 'admin'@'localhost' (using password: YES)
      2025-02-04  4:00:50 14155 [Warning] Access denied for user 'admin'@'localhost' (using password: YES)
      2025-02-04  4:00:50 14157 [Warning] Access denied for user 'admin'@'localhost' (using password: YES)
      2025-02-04  4:00:51 14159 [Warning] Access denied for user 'admin'@'localhost' (using password: YES)
      2025-02-04  4:00:51 14161 [Warning] Access denied for user 'admin'@'localhost' (using password: YES)
      2025-02-04  4:00:52 14163 [Warning] Access denied for user 'admin'@'localhost' (using password: YES)
      2025-02-04  4:00:52 14165 [Warning] Access denied for user 'admin'@'localhost' (using password: YES)
      2025-02-04  4:00:53 14167 [Warning] Access denied for user 'admin'@'localhost' (using password: YES)
      2025-02-04  4:00:54 14169 [Warning] Access denied for user 'admin'@'localhost' (using password: YES)
      2025-02-04  4:00:54 14171 [Warning] Access denied for user 'admin'@'localhost' (using password: YES)
      2025-02-04  4:00:55 14174 [Warning] Access denied for user 'admin'@'localhost' (using password: YES)
      2025-02-04  4:00:55 14176 [Warning] Access denied for user 'admin'@'localhost' (using password: YES)
      2025-02-04  4:00:56 14178 [Warning] Access denied for user 'admin'@'localhost' (using password: YES)
      2025-02-04  4:00:56 14180 [Warning] Access denied for user 'admin'@'localhost' (using password: YES)
      2025-02-04  4:00:57 14182 [Warning] Access denied for user 'admin'@'localhost' (using password: YES)
      2025-02-04  4:00:57 14184 [Warning] Access denied for user 'admin'@'localhost' (using password: YES)
      2025-02-04  4:00:58 14186 [Warning] Access denied for user 'admin'@'localhost' (using password: YES)
      2025-02-04  4:00:59 14188 [Warning] Access denied for user 'admin'@'localhost' (using password: YES)
      2025-02-04  4:00:59 14190 [Warning] Access denied for user 'admin'@'localhost' (using password: YES)
      2025-02-04  4:01:00 14192 [Warning] Access denied for user 'admin'@'localhost' (using password: YES)
      2025-02-04  4:01:00 14194 [Warning] Access denied for user 'admin'@'localhost' (using password: YES)
      2025-02-04  4:01:01 14198 [Warning] Access denied for user 'admin'@'localhost' (using password: YES)
      2025-02-04  4:01:01 14204 [Warning] Access denied for user 'admin'@'localhost' (using password: YES)
      2025-02-04  4:01:02 14209 [Warning] Access denied for user 'admin'@'localhost' (using password: YES)
      2025-02-04  4:01:02 14212 [Warning] Access denied for user 'admin'@'localhost' (using password: YES)
      2025-02-04  4:01:03 14214 [Warning] Access denied for user 'admin'@'localhost' (using password: YES)
      2025-02-04  4:01:03 14216 [Warning] Access denied for user 'admin'@'localhost' (using password: YES)
      2025-02-04  4:01:04 14219 [Warning] Access denied for user 'admin'@'localhost' (using password: YES)
      2025-02-04  4:01:05 14222 [Warning] Access denied for user 'admin'@'localhost' (using password: YES)
      2025-02-04  4:01:05 14224 [Warning] Access denied for user 'admin'@'localhost' (using password: YES)
      2025-02-04  4:01:06 14227 [Warning] Access denied for user 'admin'@'localhost' (using password: YES)
      2025-02-04  4:01:06 14229 [Warning] Access denied for user 'admin'@'localhost' (using password: YES)
      2025-02-04  4:01:07 14231 [Warning] Access denied for user 'admin'@'localhost' (using password: YES)
      2025-02-04  4:01:07 14234 [Warning] Access denied for user 'admin'@'localhost' (using password: YES)
      2025-02-04  4:01:08 14236 [Warning] Access denied for user 'admin'@'localhost' (using password: YES)
      2025-02-04  4:01:08 14238 [Warning] Access denied for user 'admin'@'localhost' (using password: YES)
      2025-02-04  4:01:09 14241 [Warning] Access denied for user 'admin'@'localhost' (using password: YES)
      2025-02-04  4:01:09 14243 [Warning] Access denied for user 'admin'@'localhost' (using password: YES)
      2025-02-04  4:01:10 14245 [Warning] Access denied for user 'admin'@'localhost' (using password: YES)
      2025-02-04  4:01:11 14248 [Warning] Access denied for user 'admin'@'localhost' (using password: YES)
      2025-02-04  4:01:11 14250 [Warning] Access denied for user 'admin'@'localhost' (using password: YES)
      2025-02-04  4:01:12 14253 [Warning] Access denied for user 'admin'@'localhost' (using password: YES)
      2025-02-04  4:01:12 14255 [Warning] Access denied for user 'admin'@'localhost' (using password: YES)
      2025-02-04  4:01:13 14257 [Warning] Access denied for user 'admin'@'localhost' (using password: YES)
      2025-02-04  4:01:13 14260 [Warning] Access denied for user 'admin'@'localhost' (using password: YES)
      2025-02-04  4:01:14 14262 [Warning] Access denied for user 'admin'@'localhost' (using password: YES)
      2025-02-04  4:01:14 14264 [Warning] Access denied for user 'admin'@'localhost' (using password: YES)
      2025-02-04  4:01:15 14267 [Warning] Access denied for user 'admin'@'localhost' (using password: YES)
      2025-02-04  4:01:16 14269 [Warning] Access denied for user 'admin'@'localhost' (using password: YES)
      2025-02-04  4:01:16 14271 [Warning] Access denied for user 'admin'@'localhost' (using password: YES)
      2025-02-04  4:01:17 14274 [Warning] Access denied for user 'admin'@'localhost' (using password: YES)
      2025-02-04  4:01:18 14277 [Warning] Access denied for user 'admin'@'localhost' (using password: YES)
      2025-02-04  4:01:19 14279 [Warning] Access denied for user 'admin'@'localhost' (using password: YES)
      2025-02-04  4:01:20 14282 [Warning] Access denied for user 'admin'@'localhost' (using password: YES)
      2025-02-04  4:01:20 14284 [Warning] Access denied for user 'admin'@'localhost' (using password: YES)
      2025-02-04  4:01:22 14287 [Warning] Access denied for user 'admin'@'localhost' (using password: YES)
      2025-02-04  4:01:23 14290 [Warning] Access denied for user 'admin'@'localhost' (using password: YES)
      2025-02-04  4:01:23 14292 [Warning] Access denied for user 'admin'@'localhost' (using password: YES)
      2025-02-04  4:01:24 14296 [Warning] Access denied for user 'admin'@'localhost' (using password: YES)
      2025-02-04  4:01:25 14298 [Warning] Access denied for user 'admin'@'localhost' (using password: YES)
      2025-02-04  4:01:26 14300 [Warning] Access denied for user 'admin'@'localhost' (using password: YES)
      2025-02-04  4:01:26 14304 [Warning] Access denied for user 'admin'@'localhost' (using password: YES)
      2025-02-04  4:01:27 14307 [Warning] Access denied for user 'admin'@'localhost' (using password: YES)
      2025-02-04  4:01:28 14309 [Warning] Access denied for user 'admin'@'localhost' (using password: YES)
      2025-02-04  4:01:29 14311 [Warning] Access denied for user 'admin'@'localhost' (using password: YES)
      2025-02-04  4:01:29 14314 [Warning] Access denied for user 'admin'@'localhost' (using password: YES)
      2025-02-04  4:01:30 14318 [Warning] Access denied for user 'admin'@'localhost' (using password: YES)
      2025-02-04  4:01:31 14321 [Warning] Access denied for user 'admin'@'localhost' (using password: YES)
      2025-02-04  4:01:32 14323 [Warning] Access denied for user 'admin'@'localhost' (using password: YES)
      2025-02-04  4:01:32 14325 [Warning] Access denied for user 'admin'@'localhost' (using password: YES)
      2025-02-04  4:01:33 14328 [Warning] Access denied for user 'admin'@'localhost' (using password: YES)
      2025-02-04  4:01:34 14331 [Warning] Access denied for user 'admin'@'localhost' (using password: YES)
      2025-02-04  4:01:35 14334 [Warning] Access denied for user 'admin'@'localhost' (using password: YES)
      2025-02-04  4:01:35 14337 [Warning] Access denied for user 'admin'@'localhost' (using password: YES)
      2025-02-04  4:01:36 14339 [Warning] Access denied for user 'admin'@'localhost' (using password: YES)
      2025-02-04  4:01:37 14341 [Warning] Access denied for user 'admin'@'localhost' (using password: YES)
      2025-02-04  4:01:38 14343 [Warning] Access denied for user 'admin'@'localhost' (using password: YES)
      2025-02-04  4:01:38 14345 [Warning] Access denied for user 'admin'@'localhost' (using password: YES)
      2025-02-04  4:01:39 14348 [Warning] Access denied for user 'admin'@'localhost' (using password: YES)
      2025-02-04  4:01:40 14352 [Warning] Access denied for user 'admin'@'localhost' (using password: YES)
      2025-02-04  4:01:41 14354 [Warning] Access denied for user 'admin'@'localhost' (using password: YES)
      2025-02-04  4:01:41 14358 [Warning] Access denied for user 'admin'@'localhost' (using password: YES)
      2025-02-04  4:01:42 14362 [Warning] Access denied for user 'admin'@'localhost' (using password: YES)
      2025-02-04  4:01:43 14368 [Warning] Access denied for user 'admin'@'localhost' (using password: YES)
      2025-02-04  4:01:44 14371 [Warning] Access denied for user 'admin'@'localhost' (using password: YES)
      2025-02-04  4:01:44 14375 [Warning] Access denied for user 'admin'@'localhost' (using password: YES)
      2025-02-04  4:01:45 14379 [Warning] Access denied for user 'admin'@'localhost' (using password: YES)
      2025-02-04  4:01:46 14383 [Warning] Access denied for user 'admin'@'localhost' (using password: YES)
      2025-02-04  4:01:47 14387 [Warning] Access denied for user 'admin'@'localhost' (using password: YES)
      2025-02-04  4:01:47 14393 [Warning] Access denied for user 'admin'@'localhost' (using password: YES)
      2025-02-04  4:01:48 14397 [Warning] Access denied for user 'admin'@'localhost' (using password: YES)
      2025-02-04  4:01:49 14401 [Warning] Access denied for user 'admin'@'localhost' (using password: YES)
      2025-02-04  4:01:49 14405 [Warning] Access denied for user 'admin'@'localhost' (using password: YES)
      2025-02-04  4:01:50 14409 [Warning] Access denied for user 'admin'@'localhost' (using password: YES)
      2025-02-04  4:01:51 14413 [Warning] Access denied for user 'admin'@'localhost' (using password: YES)
      2025-02-04  4:01:52 14417 [Warning] Access denied for user 'admin'@'localhost' (using password: YES)
      2025-02-04  4:01:52 14423 [Warning] Access denied for user 'admin'@'localhost' (using password: YES)
      2025-02-04  4:01:53 14427 [Warning] Access denied for user 'admin'@'localhost' (using password: YES)
      2025-02-04  4:01:54 14431 [Warning] Access denied for user 'admin'@'localhost' (using password: YES)
      2025-02-04  4:01:55 14437 [Warning] Access denied for user 'admin'@'localhost' (using password: YES)
      2025-02-04  4:01:56 14441 [Warning] Access denied for user 'admin'@'localhost' (using password: YES)
      2025-02-04  4:01:56 14444 [Warning] Access denied for user 'admin'@'localhost' (using password: YES)
      2025-02-04  4:01:57 14446 [Warning] Access denied for user 'admin'@'localhost' (using password: YES)
      2025-02-04  4:01:57 14449 [Warning] Access denied for user 'admin'@'localhost' (using password: YES)
      2025-02-04  4:01:58 14451 [Warning] Access denied for user 'admin'@'localhost' (using password: YES)
      2025-02-04  4:01:59 14453 [Warning] Access denied for user 'admin'@'localhost' (using password: YES)
      2025-02-04  4:01:59 14456 [Warning] Access denied for user 'admin'@'localhost' (using password: YES)
      2025-02-04  4:02:00 14458 [Warning] Access denied for user 'admin'@'localhost' (using password: YES)
      2025-02-04  4:02:00 14461 [Warning] Access denied for user 'admin'@'localhost' (using password: YES)
      2025-02-04  4:02:01 14469 [Warning] Access denied for user 'admin'@'localhost' (using password: YES)
      2025-02-04  4:02:01 14471 [Warning] Access denied for user 'admin'@'localhost' (using password: YES)
      2025-02-04  4:02:02 14476 [Warning] Access denied for user 'admin'@'localhost' (using password: YES)
      2025-02-04  4:02:03 14478 [Warning] Access denied for user 'admin'@'localhost' (using password: YES)
      2025-02-04  4:02:03 14480 [Warning] Access denied for user 'admin'@'localhost' (using password: YES)
      2025-02-04  4:02:04 14483 [Warning] Access denied for user 'admin'@'localhost' (using password: YES)
      2025-02-04  6:39:58 21512 [Warning] Aborted connection 21512 to db: 'unconnected' user: 'zbx_monitor' host: 'localhost' (Got an error reading communication packets)
      2025-02-04 13:05:11 49896 [Warning] InnoDB: A long wait (300 seconds) was observed for dict_sys.latch
      2025-02-04 13:05:12 49897 [Warning] InnoDB: A long wait (301 seconds) was observed for dict_sys.latch
      2025-02-04 13:05:14 49899 [Warning] InnoDB: A long wait (303 seconds) was observed for dict_sys.latch
      2025-02-04 13:10:11 49957 [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/
      250204 13:10:11 [ERROR] mysqld got signal 6 ;
      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.11.6-MariaDB-0+deb12u1 source revision: 
      key_buffer_size=134217728
      read_buffer_size=131072
      max_used_connections=131
      max_threads=1002
      thread_count=131
      It is possible that mysqld could use up to 
      key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 2338146 K  bytes of memory
      Hope that's ok; if not, decrease some variables in the equation.
       
      Thread pointer: 0x7f61d4000c68
      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 = 0x7f640dee6c78 thread_stack 0x49000
      /usr/sbin/mariadbd(my_print_stacktrace+0x2e)[0x5624c5d8026e]
      /usr/sbin/mariadbd(handle_fatal_signal+0x2b3)[0x5624c58f0593]
      /lib/x86_64-linux-gnu/libc.so.6(+0x3c050)[0x7f644205b050]
      /lib/x86_64-linux-gnu/libc.so.6(+0x8aebc)[0x7f64420a9ebc]
      /lib/x86_64-linux-gnu/libc.so.6(gsignal+0x12)[0x7f644205afb2]
      /lib/x86_64-linux-gnu/libc.so.6(abort+0xd3)[0x7f6442045472]
      /usr/sbin/mariadbd(+0x6984b5)[0x5624c55544b5]
      /usr/sbin/mariadbd(+0x6a2246)[0x5624c555e246]
      /usr/sbin/mariadbd(+0xe03b3e)[0x5624c5cbfb3e]
      /usr/sbin/mariadbd(+0xd76436)[0x5624c5c32436]
      /usr/sbin/mariadbd(+0xcc23a8)[0x5624c5b7e3a8]
      /usr/sbin/mariadbd(_Z8closefrmP5TABLE+0x119)[0x5624c57990c9]
      /usr/sbin/mariadbd(+0x9bb628)[0x5624c5877628]
      /usr/sbin/mariadbd(_Z12tc_add_tableP3THDP5TABLE+0x18d)[0x5624c58777dd]
      /usr/sbin/mariadbd(_Z10open_tableP3THDP10TABLE_LISTP18Open_table_context+0xb1c)[0x5624c564ba8c]
      /usr/sbin/mariadbd(_Z11open_tablesP3THDRK14DDL_options_stPP10TABLE_LISTPjjP19Prelocking_strategy+0x91a)[0x5624c564eb8a]
      /usr/sbin/mariadbd(_Z30open_normal_and_derived_tablesP3THDP10TABLE_LISTjj+0x4f)[0x5624c564f9af]
      /usr/sbin/mariadbd(_Z31open_tables_only_view_structureP3THDP10TABLE_LISTb+0x4a)[0x5624c564fa4a]
      /usr/sbin/mariadbd(+0x87664c)[0x5624c573264c]
      /usr/sbin/mariadbd(_Z14get_all_tablesP3THDP10TABLE_LISTP4Item+0x999)[0x5624c574a159]
      /usr/sbin/mariadbd(_Z24get_schema_tables_resultP4JOIN23enum_schema_table_state+0x287)[0x5624c574b5c7]
      /usr/sbin/mariadbd(_ZN4JOIN10exec_innerEv+0xa5d)[0x5624c572e5dd]
      /usr/sbin/mariadbd(_ZN4JOIN4execEv+0x37)[0x5624c572ef47]
      /usr/sbin/mariadbd(_Z12mysql_selectP3THDP10TABLE_LISTR4ListI4ItemEPS4_jP8st_orderS9_S7_S9_yP13select_resultP18st_select_lex_unitP13st_select_lex+0x11d)[0x5624c572cfcd]
      /usr/sbin/mariadbd(_Z13handle_selectP3THDP3LEXP13select_resulty+0x13f)[0x5624c572d75f]
      /usr/sbin/mariadbd(+0x7f1080)[0x5624c56ad080]
      /usr/sbin/mariadbd(_Z21mysql_execute_commandP3THDb+0x3db5)[0x5624c56b9845]
      /usr/sbin/mariadbd(_Z11mysql_parseP3THDPcjP12Parser_state+0x1b5)[0x5624c56bad05]
      /usr/sbin/mariadbd(_Z16dispatch_command19enum_server_commandP3THDPcjb+0x1005)[0x5624c56bcc35]
      /usr/sbin/mariadbd(_Z10do_commandP3THDb+0x137)[0x5624c56be247]
      /usr/sbin/mariadbd(_Z24do_handle_one_connectionP7CONNECTb+0x3b7)[0x5624c57d1bf7]
      /usr/sbin/mariadbd(handle_one_connection+0x5d)[0x5624c57d1f8d]
      /usr/sbin/mariadbd(+0xc2f440)[0x5624c5aeb440]
      /lib/x86_64-linux-gnu/libc.so.6(+0x891c4)[0x7f64420a81c4]
      /lib/x86_64-linux-gnu/libc.so.6(+0x10985c)[0x7f644212885c]
       
      Trying to get some variables.
      Some pointers may be invalid and cause the dump to abort.
      Query (0x7f61d4010aa0): SELECT COALESCE(SUM(DATA_LENGTH + INDEX_LENGTH),0) FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_SCHEMA='mysql'
       
      Connection ID (thread ID): 49957
      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,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...
      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        0                    unlimited            bytes     
      Max resident set          unlimited            unlimited            bytes     
      Max processes             128361               128361               processes 
      Max open files            1048576              1048576              files     
      Max locked memory         524288               524288               bytes     
      Max address space         unlimited            unlimited            bytes     
      Max file locks            unlimited            unlimited            locks     
      Max pending signals       128361               128361               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: core
       
      Kernel version: Linux version 6.1.0-30-amd64 (debian-kernel@lists.debian.org) (gcc-12 (Debian 12.2.0-14) 12.2.0, GNU ld (GNU Binutils for Debian) 2.40) #1 SMP PREEMPT_DYNAMIC Debian 6.1.124-1 (2025-01-12)
       
      2025-02-04 13:10:16 0 [Note] Starting MariaDB 10.11.6-MariaDB-0+deb12u1 source revision  as process 404125
      2025-02-04 13:10:16 0 [Note] InnoDB: Compressed tables use zlib 1.2.13
      2025-02-04 13:10:16 0 [Note] InnoDB: Number of transaction pools: 1
      2025-02-04 13:10:16 0 [Note] InnoDB: Using crc32 + pclmulqdq instructions
      2025-02-04 13:10:16 0 [Note] InnoDB: Using liburing
      2025-02-04 13:10:16 0 [Note] InnoDB: Initializing buffer pool, total size = 128.000MiB, chunk size = 2.000MiB
      2025-02-04 13:10:16 0 [Note] InnoDB: Completed initialization of buffer pool
      2025-02-04 13:10:16 0 [Note] InnoDB: File system buffers for log disabled (block size=512 bytes)
      2025-02-04 13:10:16 0 [Note] InnoDB: Starting crash recovery from checkpoint LSN=2815865053877
      2025-02-04 13:10:17 0 [Note] InnoDB: End of log at LSN=2815875653932
      2025-02-04 13:10:17 0 [Note] InnoDB: 1 transaction(s) which must be rolled back or cleaned up in total 684 row operations to undo
      2025-02-04 13:10:17 0 [Note] InnoDB: Trx id counter is 1767178793
      2025-02-04 13:10:17 0 [Note] InnoDB: To recover: 1359 pages
      2025-02-04 13:10:17 0 [Note] InnoDB: 128 rollback segments are active.
      2025-02-04 13:10:17 0 [Note] InnoDB: Starting in background the rollback of recovered transactions
      2025-02-04 13:10:17 0 [Note] InnoDB: Removed temporary tablespace data file: "./ibtmp1"
      2025-02-04 13:10:17 0 [Note] InnoDB: Setting file './ibtmp1' size to 12.000MiB. Physically writing the file full; Please wait ...
      2025-02-04 13:10:17 0 [Note] InnoDB: File './ibtmp1' size is now 12.000MiB.
      2025-02-04 13:10:17 0 [Note] InnoDB: log sequence number 2815875653932; transaction id 1767178794
      2025-02-04 13:10:17 0 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool
      2025-02-04 13:10:17 0 [Note] Plugin 'FEEDBACK' is disabled.
      2025-02-04 13:10:17 0 [Warning] You need to use --log-bin to make --expire-logs-days or --binlog-expire-logs-seconds work.
      2025-02-04 13:10:17 0 [Note] Server socket created on IP: '0.0.0.0'.
      2025-02-04 13:10:17 0 [Note] Server socket created on IP: '::'.
      2025-02-04 13:10:17 0 [Note] /usr/sbin/mariadbd: ready for connections.
      Version: '10.11.6-MariaDB-0+deb12u1'  socket: '/run/mysqld/mysqld.sock'  port: 3306  Debian 12
      2025-02-04 13:10:17 0 [Note] InnoDB: Rolled back recovered transaction 1767178791
      2025-02-04 13:10:17 0 [Note] InnoDB: Rollback of non-prepared transactions completed
      2025-02-04 13:10:17 0 [Note] InnoDB: Buffer pool(s) load completed at 250204 13:10:17
      2025-02-04 13:10:17 4 [ERROR] mariadbd: Table './c1hcww/wp_hcww35126_hmwp_ip_countries' is marked as crashed and should be repaired
      2025-02-04 13:10:17 4 [Warning] Checking table:   './c1hcww/wp_hcww35126_hmwp_ip_countries'
      

      Attachments

        Issue Links

          Activity

            I suspect that this report duplicates MDEV-35886, which is not actually a bug in MariaDB, but one in a Linux kernel patch that was applied by Debian. Can you please check the details in that ticket and report if upgrading or downgrading the kernel would make the problem go away?

            Alternatively, you could start mariadbd with the configuration parameter skip_innodb_use_native_aio, but that could cause a notable performance regression.

            marko Marko Mäkelä added a comment - I suspect that this report duplicates MDEV-35886 , which is not actually a bug in MariaDB, but one in a Linux kernel patch that was applied by Debian. Can you please check the details in that ticket and report if upgrading or downgrading the kernel would make the problem go away? Alternatively, you could start mariadbd with the configuration parameter skip_innodb_use_native_aio , but that could cause a notable performance regression.

            I can confirm that this is a duplicate of MDEV-35886. We had the same error and updating the kernel to 6.1.128 fixed it.

            Beeking Michel Beeking added a comment - I can confirm that this is a duplicate of MDEV-35886 . We had the same error and updating the kernel to 6.1.128 fixed it.

            Beeking, thank you. I’ll still wait for the original reporter nsupport@hcww.com.eg to confirm.

            On a related note, there is a data corruption mystery MDEV-35334 which is not explained yet. I suspect that also it is caused by something outside MariaDB Server. It seems to be more rare than these hangs.

            marko Marko Mäkelä added a comment - Beeking , thank you. I’ll still wait for the original reporter nsupport@hcww.com.eg to confirm. On a related note, there is a data corruption mystery MDEV-35334 which is not explained yet. I suspect that also it is caused by something outside MariaDB Server. It seems to be more rare than these hangs.

            People

              marko Marko Mäkelä
              nsupport@hcww.com.eg khaled osama mohamed ali
              Votes:
              0 Vote for this issue
              Watchers:
              6 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:

                Git Integration

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