Details
-
Bug
-
Status: Open (View Workflow)
-
Major
-
Resolution: Unresolved
-
10.6.19
-
None
-
None
-
windows
Description
I've been encountering an issue, This would be for MariaDB 10.6.19, running on Windows Sever 2022.
I grabbed the lines from the error log:
2024-10-25 21:41:30 29 [Warning] Aborted connection 29 to db: 'dsdb' user: 'mysql' host: '10.55.107.96' (Got an error reading communication packets)
2024-10-25 21:41:30 28 [Warning] Aborted connection 28 to db: 'dsdb' user: 'mysql' host: '10.55.107.96' (Got an error reading communication packets)
2024-10-25 21:51:27 75 [Warning] Aborted connection 75 to db: 'dsdb' user: 'mysql' host: '127.0.0.1' (Got an error reading communication packets)
2024-10-25 21:51:27 74 [Warning] Aborted connection 74 to db: 'dsdb' user: 'mysql' host: '127.0.0.1' (Got an error reading communication packets)
2024-10-25 23:16:30 0 [ERROR] [FATAL] InnoDB: innodb_fatal_semaphore_wait_threshold was exceeded for dict_sys.latch. Please refer to https://mariadb.com/kb/en/how-to-produce-a-full-stack-trace-for-mysqld/
2024-10-25 23:16:35 424 [Warning] Aborted connection 424 to db: 'dsdb' user: 'mysql' host: '10.55.107.96' (Got an error reading communication packets)
2024-10-25 23:16:35 425 [Warning] Aborted connection 425 to db: 'dsdb' user: 'mysql' host: '10.55.107.96' (Got an error reading communication packets)
2024-10-25 23:16:35 426 [Warning] Aborted connection 426 to db: 'dsdb' user: 'mysql' host: '10.55.107.96' (Got an error reading communication packets)
241025 23:16:38 [ERROR] mysqld got exception 0x80000003 ;
Sorry, we probably made a mistake, and this is a bug.
Your assistance in bug reporting will enable us to fix this for the next release.
To report this bug, see https://mariadb.com/kb/en/reporting-bugs
We will try our best to scrape up some info that will hopefully help
diagnose the problem, but since we have already crashed,
something is definitely wrong and this may fail.
Server version: 10.6.19-MariaDB-log source revision: 8f020508c87461bbeee551c3001acac56d506ae7
key_buffer_size=134217728
read_buffer_size=131072
max_used_connections=112
max_threads=65537
thread_count=111
It is possible that mysqld could use up to
key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 1082300045 K bytes of memory
Hope that's ok; if not, decrease some variables in the equation.
Thread pointer: 0x27d3c35a5e8
Attempting backtrace. You can use the following information to find out
where mysqld died. If you see no messages after this, something went
terribly wrong...
2024-10-25 23:16:47 421 [Warning] Aborted connection 421 to db: 'dsdb' user: 'mysql' host: '127.0.0.1' (Got an error reading communication packets)
2024-10-25 23:17:00 435 [Warning] Aborted connection 435 to db: 'unconnected' user: 'unauthenticated' host: '127.0.0.1' (Got an error reading communication packets)
2024-10-25 23:17:00 436 [Warning] Aborted connection 436 to db: 'unconnected' user: 'unauthenticated' host: '127.0.0.1' (Got an error reading communication packets)
2024-10-25 23:17:00 435 [Warning] Aborted connection 435 to db: 'unconnected' user: 'unauthenticated' host: '127.0.0.1' (This connection closed normally without authentication)
2024-10-25 23:17:00 436 [Warning] Aborted connection 436 to db: 'unconnected' user: 'unauthenticated' host: '127.0.0.1' (This connection closed normally without authentication)
2024-10-25 23:17:00 440 [Warning] Aborted connection 440 to db: 'unconnected' user: 'unauthenticated' host: '127.0.0.1' (Got an error reading communication packets)
2024-10-25 23:17:00 438 [Warning] Aborted connection 438 to db: 'unconnected' user: 'unauthenticated' host: '127.0.0.1' (Got an error reading communication packets)
2024-10-25 23:17:00 439 [Warning] Aborted connection 439 to db: 'unconnected' user: 'unauthenticated' host: '127.0.0.1' (Got an error reading communication packets)
2024-10-25 23:17:00 438 [Warning] Aborted connection 438 to db: 'unconnected' user: 'unauthenticated' host: '127.0.0.1' (This connection closed normally without authentication)
2024-10-25 23:17:00 439 [Warning] Aborted connection 439 to db: 'unconnected' user: 'unauthenticated' host: '127.0.0.1' (This connection closed normally without authentication)
2024-10-25 23:17:00 440 [Warning] Aborted connection 440 to db: 'unconnected' user: 'unauthenticated' host: '127.0.0.1' (This connection closed normally without authentication)
2024-10-25 23:17:01 437 [Warning] Aborted connection 437 to db: 'unconnected' user: 'unauthenticated' host: '127.0.0.1' (Got an error reading communication packets)
2024-10-25 23:17:01 437 [Warning] Aborted connection 437 to db: 'unconnected' user: 'unauthenticated' host: '127.0.0.1' (This connection closed normally without authentication)
server.dll!my_parameter_handler()
ucrtbase.dll!raise()
ucrtbase.dll!abort()
server.dll!json_valid()
server.dll!json_valid()
server.dll!json_valid()
server.dll!json_valid()
server.dll!json_valid()
server.dll!json_valid()
server.dll!json_valid()
server.dll!json_valid()
ntdll.dll!TpReleaseWork()
ntdll.dll!RtlInitializeResource()
KERNEL32.DLL!BaseThreadInitThunk()
ntdll.dll!RtlUserThreadStart()
Trying to get some variables.
Some pointers may be invalid and cause the dump to abort.
Query (0x0):
Connection ID (thread ID): 0
Status: NOT_KILLED
Optimizer switch: index_merge=off,index_merge_union=on,index_merge_sort_union=on,index_merge_intersection=on,index_merge_sort_intersection=off,engine_condition_pushdown=off,index_condition_pushdown=on,derived_merge=on,derived_with_keys=on,firstmatch=on,loosescan=on,materialization=on,in_to_exists=on,semijoin=on,partial_match_rowid_merge=on,partial_match_table_scan=on,subquery_cache=on,mrr=off,mrr_cost_based=off,mrr_sort_keys=off,outer_join_with_cache=on,semijoin_with_cache=on,join_cache_incremental=on,join_cache_hashed=on,join_cache_bka=on,optimize_join_buffer_size=on,table_elimination=on,extended_keys=on,exists_to_in=on,orderby_uses_equalities=on,condition_pushdown_for_derived=on,split_materialized=on,condition_pushdown_for_subquery=on,rowid_filter=on,condition_pushdown_from_having=on,not_null_range_scan=off,hash_join_cardinality=off,cset_narrowing=off
The manual page at https://mariadb.com/kb/en/how-to-produce-a-full-stack-trace-for-mariadbd/ contains
information that should help you find out what is causing the crash.
Writing a core file at C:\dsdb\dsdb Server\mysql\data
2024-10-25 23:18:28 444 [Warning] Aborted connection 444 to db: 'unconnected' user: 'unauthenticated' host: '127.0.0.1' (Got an error reading communication packets)Minidump written to C:\dsdb\dsdb Server\mysql\data\mysqld.dmp
2024-10-25 23:18:28 445 [Warning] Aborted connection 445 to db: 'unconnected' user: 'unauthenticated' host: '127.0.0.1' (Got an error reading communication packets)
2024-10-25 23:18:28 447 [Warning] Aborted connection 447 to db: 'unconnected' user: 'unauthenticated' host: '127.0.0.1' (Got an error reading communication packets)
2024-10-25 23:18:28 446 [Warning] Aborted connection 446 to db: 'unconnected' user: 'unauthenticated' host: '127.0.0.1' (Got an error reading communication packets)
2024-10-25 23:18:31 444 [Warning] Aborted connection 444 to db: 'unconnected' user: 'unauthenticated' host: '127.0.0.1' (This connection closed normally without authentication)
2024-10-25 23:18:31 445 [Warning] Aborted connection 445 to db: 'unconnected' user: 'unauthenticated' host: '127.0.0.1' (This connection closed normally without authentication)
2024-10-25 23:18:31 447 [Warning] Aborted connection 447 to db: 'unconnected' user: 'unauthenticated' host: '127.0.0.1' (This connection closed normally without authentication)
2024-10-25 23:18:31 446 [Warning] Aborted connection 446 to db: 'unconnected' user: 'unauthenticated' host: '127.0.0.1' (This connection closed normally without authentication)
2024-10-25 23:20:34 0 [Note] Starting MariaDB 10.6.19-MariaDB-log source revision 8f020508c87461bbeee551c3001acac56d506ae7 server_uid 99ZwX1QAX3Ca5JecdMKPCSasGhw= as process 8628
2024-10-25 23:20:35 0 [Note] mysqld: Aria engine: starting recovery
recovered pages: 0% 16% 27% 49% 61% 82% 95% 100% (0.1 seconds); tables to flush: 1 0
(0.1 seconds);