Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Incomplete
-
10.11.6
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
- duplicates
-
MDEV-35886 MariaDB Server frequently hanging, causing data corruption.
-
- Closed
-
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.