Details
-
Bug
-
Status: Closed (View Workflow)
-
Critical
-
Resolution: Incomplete
-
10.6.22
-
None
-
OS Name Microsoft Windows Server 2019 Datacenter
Version 10.0.17763 Build 17763
Other OS Description Not Available
OS Manufacturer Microsoft Corporation
System Name myserver
System Manufacturer Microsoft Corporation
System Model Virtual Machine
System Type x64-based PC
System SKU Unsupported
Processor AMD EPYC 7763 64-Core Processor, 2445 Mhz, 2 Core(s), 4 Logical Processor(s)
BIOS Version/Date American Megatrends Inc. 090008, 07/12/2018
SMBIOS Version 2.3
BIOS Mode Legacy
BaseBoard Manufacturer Microsoft Corporation
BaseBoard Product Virtual Machine
BaseBoard Version 7.0
Platform Role Desktop
OS Name Microsoft Windows Server 2019 Datacenter Version 10.0.17763 Build 17763 Other OS Description Not Available OS Manufacturer Microsoft Corporation System Name myserver System Manufacturer Microsoft Corporation System Model Virtual Machine System Type x64-based PC System SKU Unsupported Processor AMD EPYC 7763 64-Core Processor, 2445 Mhz, 2 Core(s), 4 Logical Processor(s) BIOS Version/Date American Megatrends Inc. 090008, 07/12/2018 SMBIOS Version 2.3 BIOS Mode Legacy BaseBoard Manufacturer Microsoft Corporation BaseBoard Product Virtual Machine BaseBoard Version 7.0 Platform Role Desktop
Description
Crashed under Windows with error 0xc0000005 with the following error in the error log. This same query (with different parameters) works most of the time though and is normally performed thousands of times per day without this problem. Normally, those updates are performed in a transaction with many such updates at once.
2025-07-28 10:01:03 793088 [Warning] Access denied for user 'someuser'@'localhost' (using password: YES)
|
[ERROR] C:\Program Files\MariaDB 10.6\bin\mysqld.exe got exception 0xc0000005 ;
|
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 about how to report
|
a bug on https://jira.mariadb.org/.
|
|
|
Please include the information from the server start above, to the end of the
|
information below.
|
|
|
Server version: 10.6.22-MariaDB source revision: 19644f6821d59ecca0f9b1f44fadb3b887061965
|
|
|
The information page at https://mariadb.com/kb/en/how-to-produce-a-full-stack-trace-for-mariadbd/
|
contains instructions to obtain a better version of the backtrace below.
|
Following these instructions will help MariaDB developers provide a fix quicker.
|
|
|
Attempting backtrace. Include this in the bug report.
|
(note: Retrieving this information may fail)
|
|
|
Thread pointer: 0x1ede71088d8
|
server.dll!memcmp()[memcmp.asm:158]
|
server.dll!find_dup_table()[sql_base.cc:1181]
|
server.dll!find_table()[sql_base.cc:1346]
|
server.dll!unique_table()[sql_base.cc:1294]
|
server.dll!mysql_update()[sql_update.cc:533]
|
server.dll!mysql_execute_command()[sql_parse.cc:4477]
|
server.dll!Prepared_statement::execute()[sql_prepare.cc:5274]
|
server.dll!Prepared_statement::execute_loop()[sql_prepare.cc:4680]
|
server.dll!mysql_stmt_execute_common()[sql_prepare.cc:3595]
|
server.dll!mysqld_stmt_execute()[sql_prepare.cc:3369]
|
server.dll!dispatch_command()[sql_parse.cc:1840]
|
server.dll!do_command()[sql_parse.cc:1421]
|
server.dll!tp_callback()[threadpool_common.cc:252]
|
KERNEL32.DLL!LCMapStringEx()
|
ntdll.dll!RtlAddRefActivationContext()
|
ntdll.dll!RtlAcquireSRWLockExclusive()
|
KERNEL32.DLL!BaseThreadInitThunk()
|
ntdll.dll!RtlUserThreadStart()
|
|
|
Connection ID (thread ID): 799460
|
Status: NOT_KILLED
|
Query (0x1edf07b78a8): UPDATE my_table
|
SET ordernum = ?
|
WHERE e_uid = ?
|
AND w_uid = ?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_ha
|
shed=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
|
|
|
|
|
Writing a core file at F:\Xampp\mysql\data
|
2025-07-28 11:32:26 0 [Note] Starting MariaDB 10.6.22-MariaDB source revision 19644f6821d59ecca0f9b1f44fadb3b887061965 server_uid WfY9LkhW1PdA2ifHpvO1tcuK8uQ= as process 13408
|
2025-07-28 11:32:26 0 [Note] mysqld.exe: Aria engine: starting recovery
|
recovered pages: 0% 10% 20% 30% 40% 50% 60% 70% 80% 90% 100% (0.0 seconds); tables to flush: 2 1 0
|
(0.1 seconds);
|
2025-07-28 11:32:26 0 [Note] mysqld.exe: Aria engine: recovery done
|
2025-07-28 11:32:26 0 [Note] InnoDB: Compressed tables use zlib 1.3.1
|
2025-07-28 11:32:26 0 [Note] InnoDB: Number of pools: 1
|
2025-07-28 11:32:26 0 [Note] InnoDB: Using crc32 + pclmulqdq instructions
|
2025-07-28 11:32:26 0 [Note] InnoDB: Initializing buffer pool, total size = 15032385536, chunk size = 134217728
|
2025-07-28 11:32:26 0 [Note] InnoDB: Completed initialization of buffer pool
|
2025-07-28 11:32:26 0 [Note] InnoDB: Starting crash recovery from checkpoint LSN=407609114432,407609114432
|
2025-07-28 11:32:38 0 [Note] InnoDB: 1 transaction(s) which must be rolled back or cleaned up in total 2 row operations to undo
|
2025-07-28 11:32:38 0 [Note] InnoDB: Trx id counter is 139310165
|
2025-07-28 11:32:38 0 [Note] InnoDB: To recover: 76649 pages
|
2025-07-28 11:32:43 0 [Note] InnoDB: 128 rollback segments are active.
|
2025-07-28 11:32:43 0 [Note] InnoDB: Starting in background the rollback of recovered transactions
|
2025-07-28 11:32:43 0 [Note] InnoDB: Rolled back recovered transaction 139310110
|
2025-07-28 11:32:43 0 [Note] InnoDB: Rollback of non-prepared transactions completed
|
2025-07-28 11:32:43 0 [Note] InnoDB: Removed temporary tablespace data file: "F:/Xampp/mysql/data/ibtmp1"
|
2025-07-28 11:32:43 0 [Note] InnoDB: Creating shared tablespace for temporary tables
|
2025-07-28 11:32:43 0 [Note] InnoDB: Setting file 'F:/Xampp/mysql/data/ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
|
2025-07-28 11:32:43 0 [Note] InnoDB: File 'F:/Xampp/mysql/data/ibtmp1' size is now 12 MB.
|
2025-07-28 11:32:43 0 [Note] InnoDB: 10.6.22 started; log sequence number 408653821268; transaction id 139310167
|
2025-07-28 11:32:43 0 [Note] Plugin 'FEEDBACK' is disabled.
|
2025-07-28 11:32:43 0 [Note] InnoDB: Loading buffer pool(s) from F:\Xampp\mysql\data\ib_buffer_pool
|
2025-07-28 11:32:43 0 [Note] Server socket created on IP: '::'.
|
2025-07-28 11:32:43 0 [Note] Server socket created on IP: '0.0.0.0'.
|
2025-07-28 11:32:43 1 [Note] Event Scheduler: scheduler thread started with id 1
|
2025-07-28 11:32:43 0 [Note] C:\Program Files\MariaDB 10.6\bin\mysqld.exe: ready for connections.
|
Version: '10.6.22-MariaDB' socket: '' port: 3306 mariadb.org binary distribution
|
2025-07-28 11:32:53 0 [Note] InnoDB: Buffer pool(s) load completed at 250728 11:32:53
|
|