Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Incomplete
-
10.6.11
-
None
-
OS Name Microsoft Windows Server 2019 Standard
Version 10.0.17763 Build 17763
Other OS Description Not Available
OS Manufacturer Microsoft Corporation
System Manufacturer Gigabyte Technology Co., Ltd.
System Model B560M AORUS PRO AX
System Type x64-based PC
System SKU Default string
Processor 11th Gen Intel(R) Core(TM) i9-11900K @ 3.50GHz, 3504 Mhz, 8 Core(s), 16 Logical Processor(s)
BIOS Version/Date American Megatrends International, LLC. F3, 1/21/2021
SMBIOS Version 3.3
Embedded Controller Version 255.255
BIOS Mode UEFI
BaseBoard Manufacturer Gigabyte Technology Co., Ltd.
BaseBoard Product B560M AORUS PRO AX
BaseBoard Version x.x
Platform Role Desktop
Secure Boot State Off
PCR7 Configuration Not Available
Windows Directory C:\Windows
System Directory C:\Windows\system32
Boot Device \Device\HarddiskVolume1
Locale United States
Hardware Abstraction Layer Version = "10.0.17763.4644"
User Name Not Available
Time Zone Eastern Standard Time
Installed Physical Memory (RAM) 128 GB
Total Physical Memory 128 GB
Available Physical Memory 57.4 GB
Total Virtual Memory 147 GB
Available Virtual Memory 62.9 GB
Page File Space 19.0 GB
Page File C:\pagefile.sys
Kernel DMA Protection Off
Virtualization-based security Running
Virtualization-based security Required Security Properties
Virtualization-based security Available Security Properties Base Virtualization Support, DMA Protection, UEFI Code Readonly, SMM Security Mitigations 1.0, Mode Based Execution Control
Virtualization-based security Services Configured
Virtualization-based security Services Running
Device Encryption Support Not Available
A hypervisor has been detected. Features required for Hyper-V will not be displayed.OS Name Microsoft Windows Server 2019 Standard Version 10.0.17763 Build 17763 Other OS Description Not Available OS Manufacturer Microsoft Corporation System Manufacturer Gigabyte Technology Co., Ltd. System Model B560M AORUS PRO AX System Type x64-based PC System SKU Default string Processor 11th Gen Intel(R) Core(TM) i9-11900K @ 3.50GHz, 3504 Mhz, 8 Core(s), 16 Logical Processor(s) BIOS Version/Date American Megatrends International, LLC. F3, 1/21/2021 SMBIOS Version 3.3 Embedded Controller Version 255.255 BIOS Mode UEFI BaseBoard Manufacturer Gigabyte Technology Co., Ltd. BaseBoard Product B560M AORUS PRO AX BaseBoard Version x.x Platform Role Desktop Secure Boot State Off PCR7 Configuration Not Available Windows Directory C:\Windows System Directory C:\Windows\system32 Boot Device \Device\HarddiskVolume1 Locale United States Hardware Abstraction Layer Version = "10.0.17763.4644" User Name Not Available Time Zone Eastern Standard Time Installed Physical Memory (RAM) 128 GB Total Physical Memory 128 GB Available Physical Memory 57.4 GB Total Virtual Memory 147 GB Available Virtual Memory 62.9 GB Page File Space 19.0 GB Page File C:\pagefile.sys Kernel DMA Protection Off Virtualization-based security Running Virtualization-based security Required Security Properties Virtualization-based security Available Security Properties Base Virtualization Support, DMA Protection, UEFI Code Readonly, SMM Security Mitigations 1.0, Mode Based Execution Control Virtualization-based security Services Configured Virtualization-based security Services Running Device Encryption Support Not Available A hypervisor has been detected. Features required for Hyper-V will not be displayed.
Description
2023-12-07 13:46:03 897806 [ERROR] mysqld.exe: Error writing file 'mysql-bin' (errno: 13 "Permission denied")
2023-12-07 13:46:15 897853 [ERROR] mysqld.exe: Error writing file 'mysql-bin' (errno: 0 "Internal error/check (Not system error)")
2023-12-07 13:46:20 897869 [ERROR] mysqld.exe: Error writing file 'mysql-bin' (errno: 0 "Internal error/check (Not system error)")
2023-12-07 13:46:21 897880 [ERROR] mysqld.exe: Error writing file 'mysql-bin' (errno: 0 "Internal error/check (Not system error)")
2023-12-07 13:46:30 897919 [ERROR] mysqld.exe: Error writing file 'mysql-bin' (errno: 0 "Internal error/check (Not system error)")
2023-12-07 13:46:31 897923 [ERROR] mysqld.exe: Error writing file 'mysql-bin' (errno: 0 "Internal error/check (Not system error)")
2023-12-07 13:46:40 897955 [ERROR] mysqld.exe: Error writing file 'mysql-bin' (errno: 0 "Internal error/check (Not system error)")
2023-12-07 13:46:41 897963 [ERROR] mysqld.exe: Error writing file 'mysql-bin' (errno: 0 "Internal error/check (Not system error)")
2023-12-07 13:46:45 897978 [ERROR] mysqld.exe: Error writing file 'mysql-bin' (errno: 0 "Internal error/check (Not system error)")
2023-12-07 13:46:49 897998 [ERROR] mysqld.exe: Error writing file 'mysql-bin' (errno: 0 "Internal error/check (Not system error)")
2023-12-07 13:46:57 898051 [ERROR] mysqld.exe: Error writing file 'mysql-bin' (errno: 0 "Internal error/check (Not system error)")
2023-12-07 13:47:00 898069 [ERROR] mysqld.exe: Error writing file 'mysql-bin' (errno: 0 "Internal error/check (Not system error)")
2023-12-07 13:47:01 898073 [ERROR] mysqld.exe: Error writing file 'mysql-bin' (errno: 0 "Internal error/check (Not system error)")
2023-12-07 13:47:02 898076 [ERROR] mysqld.exe: Error writing file 'mysql-bin' (errno: 2 "No such file or directory")
2023-12-07 13:47:02 898077 [ERROR] mysqld.exe: Error writing file 'mysql-bin' (errno: 2 "No such file or directory")
2023-12-07 13:47:02 898079 [ERROR] mysqld.exe: Error writing file 'mysql-bin' (errno: 2 "No such file or directory")
2023-12-07 13:47:10 898120 [Warning] InnoDB: Retry attempts for reading partial data failed.
2023-12-07 13:47:10 898120 [ERROR] InnoDB: File (unknown): 'read' returned OS error 0. Cannot continue operation
231207 13:47:10 [ERROR] mysqld got exception 0x80000003 ;
This could be because you hit a bug. It is also possible that this binary
or one of the libraries it was linked against is corrupt, improperly built,
or misconfigured. This error can also be caused by malfunctioning hardware.
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.11-MariaDB-log
key_buffer_size=134217728
read_buffer_size=131072
max_used_connections=42
max_threads=65537
thread_count=5
It is possible that mysqld could use up to
key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 142742890 K bytes of memory
Hope that's ok; if not, decrease some variables in the equation.
Thread pointer: 0x24bc7771038
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...
server.dll!my_parameter_handler()[my_init.c:278]
ucrtbase.dll!raise()
ucrtbase.dll!abort()
server.dll!os_file_handle_error_cond_exit()[os0file.cc:3064]
server.dll!os_file_read_page()[os0file.cc:2950]
server.dll!os_aio()[os0file.cc:3789]
server.dll!fil_space_t::io()[fil0fil.cc:2748]
server.dll!buf_read_page_low()[buf0rea.cc:323]
server.dll!buf_read_page()[buf0rea.cc:457]
server.dll!buf_page_get_low()[buf0buf.cc:2496]
server.dll!btr_cur_search_to_nth_level()[btr0cur.cc:1571]
server.dll!row_ins_sec_index_entry_low()[row0ins.cc:2928]
server.dll!row_ins_sec_index_entry()[row0ins.cc:3231]
server.dll!row_ins_index_entry_step()[row0ins.cc:3450]
server.dll!row_ins()[row0ins.cc:3593]
server.dll!row_ins_step()[row0ins.cc:3734]
server.dll!row_insert_for_mysql()[row0mysql.cc:1312]
server.dll!ha_innobase::write_row()[ha_innodb.cc:7918]
server.dll!handler::ha_write_row()[handler.cc:7559]
server.dll!write_record()[sql_insert.cc:2156]
server.dll!mysql_insert()[sql_insert.cc:1129]
server.dll!mysql_execute_command()[sql_parse.cc:4565]
server.dll!mysql_parse()[sql_parse.cc:8020]
server.dll!dispatch_command()[sql_parse.cc:1898]
server.dll!do_command()[sql_parse.cc:1409]
server.dll!tp_callback()[threadpool_common.cc:245]
KERNEL32.DLL!LCMapStringEx()
ntdll.dll!RtlAddRefActivationContext()
ntdll.dll!RtlAcquireSRWLockExclusive()
KERNEL32.DLL!BaseThreadInitThunk()
ntdll.dll!RtlUserThreadStart()
Trying to get some variables.
Some pointers may be invalid and cause the dump to abort.
Query (0x24bb5f7af20): INSERT INTO `aorbis_dh_qto_child` (`type_of_project`, `sys_Product_Category`, `cust_Style_Type`, `cust_building_tag_level_tag`, `cust_location`, `cust_Frame_Type`, `door_core`, `cust_Quanitity`, `cust_door_mark`, `sys_Door_Type`, `sys_Location_Type`, `sys_Structure`, `sys_Internal_Structure_Core_Type`, `sys_Sound_Transmission_Class`, `sys_Fire_Rating`, `sys_Door_Sub_Type_Leaf_Count_Tupal`, `sys_Door_Width`, `sys_Door_Height`, `sys_Frame_Elevation`, `sys_Frame_Material`, `sys_Frame_Finish`, `dh_included_excluded`, `frame_included_excluded`, `hardware_included_excluded`, `cust_hardware_set_no`, `door_louver`, `door_vision_lite`, `door_panel_style`, `sys_Vision_Lite`, `sys_Louver`, `created`, `updated`, `inserted_by`, `aorbis_hardware_set_no`, `sys_Base_Material`, `sys_Throw_Type`, `sys_Door_Thickness`, `sys_Hands`, `sys_Door_Finish`, `sys_Pre-Hung`, `door_duty`, `sys_Location`, `sys_Project_Type`, `door_face_material`, `door_seams`, `door_edges`, `door_wall_thickness`, `door_moulding`, `door_caping`, `door_gauge`, `door_long_sku`, `door_short_sku`, `doors_price`, `frame_assembly`, `sys_Frame_Casing`, `sys_Frame_Casing_Specified`, `frame_duty`, `frame_type`, `anchor`, `frame_base_anchor`, `frame_profile`, `casing_material`, `casing_finish`, `frame_casing_size`, `frame_gauge`, `frame_long_sku`, `frame_price`, `frame_casing_price`, `frame_without_casing_price`, `frame_with_casing_price`, `frame_linear_inches`, `frame_casing_add_on_price`, `frame_casing_base_price`, `frame_short_sku`, `no_of_anchor`, `old_total_frame_price`, `old_total_door_selling_price`, `applied_allowed_exception_count`, `selected_allowed_exception_ids`, `applied_allowed_exception_ids`, `pco_doors_change_type`, `pco_frame_change_type`, `pco_casing_change_type`, `pco_meta_change`, `actual_door_price`, `actual_frame_price`, `actual_casing_price`, `pco_changes`, `door_pco_changes`, `frame_pco_changes`, `hardware_changes`, `old_frame_price`, `old_doors_price`, `actual_Quanitity`, `parent_dh_id`, `project_id`) VALUES ('Govt. Bldg.', 'Doors', 'F', 'COMMON AREA', 'EMERGENCY ELECTRICAL ROOM', 'HM3', NULL, 1, 'O222A', 'Swing Doors', 'Interior', 'HM Flush-F', 'Steel Stiffened core', 'NO-STC', '90 Min', 'Double', '6\'0\" (Two 3\'0\" Doors)', '7\'0\" (84 Inches)', 'Double Egress Pair M5400', 'Hollow Metal', 'Primer Only', 'included', 'included', 'included', '5A', NULL, NULL, NULL, 'No', 'No', '2023-12-07 13:47:10', '2023-12-07 13:47:10', '180', 'HSW-SA-134-D-FR-01022', 'Hollow Metal', 'Not Applicable', '1-3/4\" (44.45 mm)', 'LHR/LHR Double Egress', 'Primer Only', 'Non Pre-Hung', 'Maximum Duty', 'Room - Utility (Interior)', NULL, 'Galvannealed Steel', 'Seamless/Continuously Welded', 'Standard Bevel', '5 \"', 'None', 'Top & Bottom', '14 Gauge', 'AODO-SWD-INT-HM-HMFL-SSS-STCNO-090M-D-600-700-134-LDE-PM-PHN-MD', 'AODO-WRDBJFKA', '1798.78', 'Full Profile Welded', 'Without Casing', 'Without Casing', 'Maximum Duty', NULL, 'Anchor for Steel Stud Partition', 'Adjustable Base Anchor', '', NULL, '', NULL, '14 Gauge', 'AOFM-HM-INT-090M-M5400-FPW-PM-CSNO-600-700-MD', 1277.64, '0.00', '1277.64', 1277.64, '546', '0.00', '0.00', 'AOFM-92C07MBH', '4 per Jamb', 1277.64, 1650.257, '', '', '', 'no', 'other', 'no', 'yes', '1650.25728', '1277.64', 0, 'yes', 'add', 'add', 'no', '1277.640', '1650.257', 0, 11912416, '193309607')
Connection ID (thread ID): 898120
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
The manual page at https://mariadb.com/kb/en/how-to-produce-a-full-stack-trace-for-mysqld/ contains
information that should help you find out what is causing the crash.
Writing a core file at L:\Aorbis\DB\Live\
Minidump written to L:\Aorbis\DB\Live\mysqld.dmp
2023-12-07 13:47:11 898124 [ERROR] mysqld.exe: Error writing file 'mysql-bin' (errno: 0 "Internal error/check (Not system error)")
2023-12-07 13:47:14 898138 [Note] Start binlog_dump to slave_server(1), pos(mysql-bin.000006, 709156947), using_gtid(0), gtid('')
2023-12-07 13:47:14 888912 [Warning] Aborted connection 888912 to db: 'unconnected' user: 'replication_user' host: 'orion' (A slave with the same server_uuid/server_id as this slave has co)
2023-12-07 13:47:15 898139 [Note] Start binlog_dump to slave_server(253583360), pos(mysql-bin.000006, 709156947), using_gtid(0), gtid('')
2023-12-07 13:47:15 888914 [Warning] Aborted connection 888914 to db: 'unconnected' user: 'replication_user' host: 'orion_dev.rdaep.net' (A slave with the same server_uuid/server_id as this slave has co)
2023-12-07 13:47:15 898140 [Note] Start binlog_dump to slave_server(253583365), pos(mysql-bin.000006, 709156947), using_gtid(0), gtid('')
2023-12-07 13:47:15 886360 [Warning] Aborted connection 886360 to db: 'unconnected' user: 'replication_user' host: 'orion_dev.rdaep.net' (A slave with the same server_uuid/server_id as this slave has co)
2023-12-07 13:47:16 898148 [ERROR] mysqld.exe: Error writing file 'mysql-bin' (errno: 0 "Internal error/check (Not system error)")
2023-12-07 13:47:24 898181 [ERROR] mysqld.exe: Error writing file 'mysql-bin' (errno: 0 "Internal error/check (Not system error)")
2023-12-07 13:47:32 898222 [ERROR] mysqld.exe: Error writing file 'mysql-bin' (errno: 0 "Internal error/check (Not system error)")
2023-12-07 13:47:33 898224 [ERROR] mysqld.exe: Error writing file 'mysql-bin' (errno: 0 "Internal error/check (Not system error)")
Attachments
Issue Links
- relates to
-
MDEV-27593 Crashing on I/O error is unhelpful
- Closed