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
-
-
- Closed
-
Activity
| Field | Original Value | New Value |
|---|---|---|
| Link |
This issue duplicates |
| Component/s | Storage Engine - InnoDB [ 10129 ] | |
| Labels | hang |
| Assignee | Marko Mäkelä [ marko ] | |
| Status | Open [ 1 ] | Needs Feedback [ 10501 ] |
| 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' |
{noformat}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' |
| Description |
{noformat}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' |
{noformat}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' {noformat} |
| Fix Version/s | 10.11 [ 27614 ] |
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.
| Fix Version/s | N/A [ 14700 ] | |
| Fix Version/s | 10.11 [ 27614 ] | |
| Resolution | Incomplete [ 4 ] | |
| Status | Needs Feedback [ 10501 ] | Closed [ 6 ] |
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.