[MDEV-20648] InnoDB: Failing assertion: !(*node)->being_extended, innodb.log_data_file_size failed in buildbot, assertion `!space->is_stopping()' Created: 2019-09-23  Updated: 2021-06-11  Resolved: 2021-03-04

Status: Closed
Project: MariaDB Server
Component/s: Storage Engine - InnoDB, Tests
Affects Version/s: 10.2, 10.3, 10.4, 10.5
Fix Version/s: 10.2.38, 10.3.29, 10.4.19, 10.5.7

Type: Bug Priority: Major
Reporter: Elena Stepanova Assignee: Thirunarayanan Balathandayuthapani
Resolution: Fixed Votes: 0
Labels: None

Issue Links:
Relates
relates to MDEV-23855 InnoDB log checkpointing causes regre... Closed

 Description   

bb-10.4-release 6b2e4733eb964d8b6413d3ca28fa82c7960d08e8

innodb.log_data_file_size '4k,innodb'    w1 [ fail ]
        Test ended at 2019-09-23 12:21:01
 
CURRENT_TEST: innodb.log_data_file_size
mysqltest: At line 80: query '$drop_tables' failed: 2013: Lost connection to MySQL server during query
 
The result from queries just before the failure was:
SET GLOBAL innodb_file_per_table=0;
CREATE TABLE t(a INT)ENGINE=InnoDB;
SET GLOBAL innodb_file_per_table=1;
CREATE TABLE ibd4(a INT UNIQUE)ENGINE=InnoDB;
CREATE TABLE ibd4f(a INT UNIQUE)ENGINE=InnoDB;
CREATE TABLE ibd5(a INT UNIQUE, b INT UNIQUE)ENGINE=InnoDB;
# Kill the server
DROP TABLE t,ibd4,ibd4f,ibd5;
 
 
Server [mysqld.1 - pid: 12388, winpid: 12388, exit: 65280] failed during test run
Server log from this test:
----------SERVER LOG START-----------
2019-09-23 12:20:55 0 [Note] D:/win32-packages/build/sql//RelWithDebInfo/mysqld.exe (mysqld 10.4.9-MariaDB-log) starting as process 11084 ...
2019-09-23 12:20:55 0 [Note] Plugin 'partition' is disabled.
2019-09-23 12:20:55 0 [Note] Plugin 'SEQUENCE' is disabled.
2019-09-23 12:20:55 0 [Note] InnoDB: innodb_page_size=4096
InnoDB: using atomic writes.
2019-09-23 12:20:55 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2019-09-23 12:20:55 0 [Note] InnoDB: Uses event mutexes
2019-09-23 12:20:55 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2019-09-23 12:20:55 0 [Note] InnoDB: Number of pools: 1
2019-09-23 12:20:55 0 [Note] InnoDB: Using SSE2 crc32 instructions
2019-09-23 12:20:55 0 [Note] InnoDB: Initializing buffer pool, total size = 8M, instances = 1, chunk size = 8M
2019-09-23 12:20:55 0 [Note] InnoDB: Completed initialization of buffer pool
2019-09-23 12:20:55 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2019-09-23 12:20:55 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2019-09-23 12:20:55 0 [Note] InnoDB: Setting file '.\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2019-09-23 12:20:55 0 [Note] InnoDB: File '.\ibtmp1' size is now 12 MB.
2019-09-23 12:20:55 0 [Note] InnoDB: Waiting for purge to start
2019-09-23 12:20:55 0 [Note] InnoDB: 10.4.9 started; log sequence number 361695; transaction id 34
2019-09-23 12:20:55 0 [Note] InnoDB: Loading buffer pool(s) from D:\win32-packages\build\mysql-test\var\1\mysqld.1\data\ib_buffer_pool
2019-09-23 12:20:55 0 [Note] Plugin 'INNODB_SYS_DATAFILES' is disabled.
2019-09-23 12:20:55 0 [Note] Plugin 'INNODB_SYS_TABLESTATS' is disabled.
2019-09-23 12:20:55 0 [Note] Plugin 'INNODB_MUTEXES' is disabled.
2019-09-23 12:20:55 0 [Note] Plugin 'INNODB_CMP' is disabled.
2019-09-23 12:20:55 0 [Note] Plugin 'INNODB_FT_DELETED' is disabled.
2019-09-23 12:20:55 0 [Note] Plugin 'INNODB_CMP_RESET' is disabled.
2019-09-23 12:20:55 0 [Note] Plugin 'INNODB_TABLESPACES_ENCRYPTION' is disabled.
2019-09-23 12:20:55 0 [Note] Plugin 'INNODB_CMPMEM_RESET' is disabled.
2019-09-23 12:20:55 0 [Note] Plugin 'FEEDBACK' is disabled.
2019-09-23 12:20:55 0 [Note] Plugin 'INNODB_FT_INDEX_TABLE' is disabled.
2019-09-23 12:20:55 0 [Note] Plugin 'INNODB_CMP_PER_INDEX_RESET' is disabled.
2019-09-23 12:20:55 0 [Note] Plugin 'user_variables' is disabled.
2019-09-23 12:20:55 0 [Note] Plugin 'INNODB_FT_INDEX_CACHE' is disabled.
2019-09-23 12:20:55 0 [Note] Plugin 'INNODB_FT_BEING_DELETED' is disabled.
2019-09-23 12:20:55 0 [Note] Plugin 'INNODB_FT_DEFAULT_STOPWORD' is disabled.
2019-09-23 12:20:55 0 [Note] Plugin 'INNODB_FT_CONFIG' is disabled.
2019-09-23 12:20:55 0 [Note] Plugin 'INNODB_SYS_TABLESPACES' is disabled.
2019-09-23 12:20:55 0 [Note] Plugin 'INNODB_TABLESPACES_SCRUBBING' is disabled.
2019-09-23 12:20:55 0 [Note] Plugin 'INNODB_SYS_SEMAPHORE_WAITS' is disabled.
2019-09-23 12:20:55 0 [Warning] D:/win32-packages/build/sql//RelWithDebInfo/mysqld.exe: unknown variable 'loose-feedback-debug-startup-interval=20'
2019-09-23 12:20:55 0 [Warning] D:/win32-packages/build/sql//RelWithDebInfo/mysqld.exe: unknown variable 'loose-feedback-debug-first-interval=60'
2019-09-23 12:20:55 0 [Warning] D:/win32-packages/build/sql//RelWithDebInfo/mysqld.exe: unknown variable 'loose-feedback-debug-interval=60'
2019-09-23 12:20:55 0 [Warning] D:/win32-packages/build/sql//RelWithDebInfo/mysqld.exe: unknown option '--loose-pam-debug'
2019-09-23 12:20:55 0 [Warning] D:/win32-packages/build/sql//RelWithDebInfo/mysqld.exe: unknown option '--loose-aria'
2019-09-23 12:20:55 0 [Warning] D:/win32-packages/build/sql//RelWithDebInfo/mysqld.exe: unknown variable 'loose-debug-sync-timeout=300'
2019-09-23 12:20:55 0 [Note] InnoDB: Buffer pool(s) load completed at 190923 12:20:55
2019-09-23 12:20:56 0 [Note] Server socket created on IP: '::'.
2019-09-23 12:20:56 0 [Note] Reading of all Master_info entries succeeded
2019-09-23 12:20:56 0 [Note] Added new Master_info '' to hash table
2019-09-23 12:20:56 0 [Note] D:/win32-packages/build/sql//RelWithDebInfo/mysqld.exe: ready for connections.
Version: '10.4.9-MariaDB-log'  socket: ''  port: 16000  mariadb.org binary distribution
2019-09-23 12:20:57 0 [Note] D:/win32-packages/build/sql//RelWithDebInfo/mysqld.exe (mysqld 10.4.9-MariaDB-log) starting as process 10776 ...
2019-09-23 12:20:57 0 [Note] Plugin 'partition' is disabled.
2019-09-23 12:20:57 0 [Note] Plugin 'SEQUENCE' is disabled.
2019-09-23 12:20:57 0 [Note] InnoDB: innodb_page_size=4096
InnoDB: using atomic writes.
2019-09-23 12:20:57 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2019-09-23 12:20:57 0 [Note] InnoDB: Uses event mutexes
2019-09-23 12:20:57 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2019-09-23 12:20:57 0 [Note] InnoDB: Number of pools: 1
2019-09-23 12:20:57 0 [Note] InnoDB: Using SSE2 crc32 instructions
2019-09-23 12:20:57 0 [Note] InnoDB: Initializing buffer pool, total size = 8M, instances = 1, chunk size = 8M
2019-09-23 12:20:57 0 [Note] InnoDB: Completed initialization of buffer pool
2019-09-23 12:20:57 0 [Note] InnoDB: Starting crash recovery from checkpoint LSN=361695
2019-09-23 12:20:57 0 [Note] InnoDB: Starting final batch to recover 25 pages from redo log.
2019-09-23 12:20:58 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2019-09-23 12:20:58 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
2019-09-23 12:20:58 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2019-09-23 12:20:58 0 [Note] InnoDB: Setting file '.\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2019-09-23 12:20:58 0 [Note] InnoDB: File '.\ibtmp1' size is now 12 MB.
2019-09-23 12:20:58 0 [Note] InnoDB: Waiting for purge to start
2019-09-23 12:20:58 0 [Note] InnoDB: 10.4.9 started; log sequence number 392051; transaction id 44
2019-09-23 12:20:58 0 [Note] InnoDB: Loading buffer pool(s) from D:\win32-packages\build\mysql-test\var\1\mysqld.1\data\ib_buffer_pool
2019-09-23 12:20:58 0 [Note] Plugin 'INNODB_SYS_DATAFILES' is disabled.
2019-09-23 12:20:58 0 [Note] Plugin 'INNODB_SYS_TABLESTATS' is disabled.
2019-09-23 12:20:58 0 [Note] Plugin 'INNODB_MUTEXES' is disabled.
2019-09-23 12:20:58 0 [Note] Plugin 'INNODB_CMP' is disabled.
2019-09-23 12:20:58 0 [Note] Plugin 'INNODB_FT_DELETED' is disabled.
2019-09-23 12:20:58 0 [Note] Plugin 'INNODB_CMP_RESET' is disabled.
2019-09-23 12:20:58 0 [Note] Plugin 'INNODB_TABLESPACES_ENCRYPTION' is disabled.
2019-09-23 12:20:58 0 [Note] Plugin 'INNODB_CMPMEM_RESET' is disabled.
2019-09-23 12:20:58 0 [Note] Plugin 'FEEDBACK' is disabled.
2019-09-23 12:20:58 0 [Note] Plugin 'INNODB_FT_INDEX_TABLE' is disabled.
2019-09-23 12:20:58 0 [Note] Plugin 'INNODB_CMP_PER_INDEX_RESET' is disabled.
2019-09-23 12:20:58 0 [Note] Plugin 'user_variables' is disabled.
2019-09-23 12:20:58 0 [Note] Plugin 'INNODB_FT_INDEX_CACHE' is disabled.
2019-09-23 12:20:58 0 [Note] Plugin 'INNODB_FT_BEING_DELETED' is disabled.
2019-09-23 12:20:58 0 [Note] Plugin 'INNODB_FT_DEFAULT_STOPWORD' is disabled.
2019-09-23 12:20:58 0 [Note] Plugin 'INNODB_FT_CONFIG' is disabled.
2019-09-23 12:20:58 0 [Note] Plugin 'INNODB_SYS_TABLESPACES' is disabled.
2019-09-23 12:20:58 0 [Note] Plugin 'INNODB_TABLESPACES_SCRUBBING' is disabled.
2019-09-23 12:20:58 0 [Note] Plugin 'INNODB_SYS_SEMAPHORE_WAITS' is disabled.
2019-09-23 12:20:58 0 [Warning] D:/win32-packages/build/sql//RelWithDebInfo/mysqld.exe: unknown variable 'loose-feedback-debug-startup-interval=20'
2019-09-23 12:20:58 0 [Warning] D:/win32-packages/build/sql//RelWithDebInfo/mysqld.exe: unknown variable 'loose-feedback-debug-first-interval=60'
2019-09-23 12:20:58 0 [Warning] D:/win32-packages/build/sql//RelWithDebInfo/mysqld.exe: unknown variable 'loose-feedback-debug-interval=60'
2019-09-23 12:20:58 0 [Warning] D:/win32-packages/build/sql//RelWithDebInfo/mysqld.exe: unknown option '--loose-pam-debug'
2019-09-23 12:20:58 0 [Warning] D:/win32-packages/build/sql//RelWithDebInfo/mysqld.exe: unknown option '--loose-aria'
2019-09-23 12:20:58 0 [Warning] D:/win32-packages/build/sql//RelWithDebInfo/mysqld.exe: unknown variable 'loose-debug-sync-timeout=300'
2019-09-23 12:20:58 0 [Note] InnoDB: Buffer pool(s) load completed at 190923 12:20:58
2019-09-23 12:20:58 0 [Note] Server socket created on IP: '::'.
2019-09-23 12:20:58 0 [Note] Reading of all Master_info entries succeeded
2019-09-23 12:20:58 0 [Note] Added new Master_info '' to hash table
2019-09-23 12:20:58 0 [Note] D:/win32-packages/build/sql//RelWithDebInfo/mysqld.exe: ready for connections.
Version: '10.4.9-MariaDB-log'  socket: ''  port: 16000  mariadb.org binary distribution

2019-09-23 12:20:59 0x1a64  InnoDB: Assertion failure in file D:\win32-packages\build\src\storage\innobase\fil\fil0fil.cc line 2263
InnoDB: Failing assertion: !(*node)->being_extended
InnoDB: We intentionally generate a memory trap.
InnoDB: Submit a detailed bug report to https://jira.mariadb.org/
InnoDB: If you get repeated assertion failures or crashes, even
InnoDB: immediately after the mysqld startup, there may be
InnoDB: corruption in the InnoDB tablespace. Please refer to
InnoDB: https://mariadb.com/kb/en/library/innodb-recovery-modes/
InnoDB: about forcing recovery.
190923 12:20:59 [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.4.9-MariaDB-log
key_buffer_size=1048576
read_buffer_size=131072
max_used_connections=1
max_threads=65537
thread_count=7
It is possible that mysqld could use up to 
key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 3633 K  bytes of memory
Hope that's ok; if not, decrease some variables in the equation.
 
Thread pointer: 0x8e35f48
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...
mysqld.exe!my_sigabrt_handler()[my_thr_init.c:484]
ucrtbase.DLL!raise()
ucrtbase.DLL!abort()
mysqld.exe!ut_dbg_assertion_failed()[ut0dbg.cc:60]
mysqld.exe!fil_check_pending_io()[fil0fil.cc:2263]
mysqld.exe!fil_check_pending_operations()[fil0fil.cc:2342]
mysqld.exe!fil_delete_tablespace()[fil0fil.cc:2465]
mysqld.exe!row_drop_table_for_mysql()[row0mysql.cc:3768]
mysqld.exe!ha_innobase::delete_table()[ha_innodb.cc:12934]
mysqld.exe!ha_innobase::delete_table()[ha_innodb.cc:13059]
mysqld.exe!handler::ha_delete_table()[handler.cc:4694]
mysqld.exe!ha_delete_table()[handler.cc:2587]
mysqld.exe!mysql_rm_table_no_locks()[sql_table.cc:2477]
mysqld.exe!mysql_rm_table()[sql_table.cc:2121]
mysqld.exe!mysql_execute_command()[sql_parse.cc:4858]
mysqld.exe!mysql_parse()[sql_parse.cc:7912]
mysqld.exe!dispatch_command()[sql_parse.cc:1840]
mysqld.exe!do_command()[sql_parse.cc:1358]
mysqld.exe!threadpool_process_request()[threadpool_common.cc:366]
mysqld.exe!tp_callback()[threadpool_common.cc:193]
mysqld.exe!work_callback()[threadpool_win.cc:419]
ntdll.dll!RtlDestroyHeap()
ntdll.dll!RtlReleaseActivationContext()
KERNEL32.DLL!BaseThreadInitThunk()
ntdll.dll!RtlInitializeExceptionChain()
ntdll.dll!RtlInitializeExceptionChain()
 
Trying to get some variables.
Some pointers may be invalid and cause the dump to abort.
Query (0x8e42e40): DROP TABLE t,ibd4,ibd4f,ibd5
Connection ID (thread ID): 8
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
 
The manual page at http://dev.mysql.com/doc/mysql/en/crashing.html contains
information that should help you find out what is causing the crash.
Writing a core file at D:\win32-packages\build\mysql-test\var\1\mysqld.1\data\
Minidump written to D:\win32-packages\build\mysql-test\var\1\mysqld.1\data\mysqld.dmp
----------SERVER LOG END-------------
 
 
 - found 'mysqld.dmp' (0/5)
 
Trying 'cdb' to get a backtrace
Output from cdb follows. Faulting thread is printed twice,with and without function parameters
Search for STACK_TEXT to see the stack trace of 
the faulting thread. Callstacks of other threads are printed after it.
 
Microsoft (R) Windows Debugger Version 10.0.16299.15 AMD64
Copyright (c) Microsoft Corporation. All rights reserved.

Loading Dump File [D:\win32-packages\build\mysql-test\var\1\log\innodb.log_data_file_size-4k,innodb\mysqld.1\data\mysqld.dmp]
User Mini Dump File: Only registers, stack and portions of memory are available
 
 
Response                         Time (ms)     Location
OK                                             .
 
Response                         Time (ms)     Location
OK                                             .
Deferred                                       cache*c:\cdb_symbols
Deferred                                       SRV*C:\cdb_symbols*http://msdl.microsoft.com/download/symbols
Symbol search path is: .;cache*c:\cdb_symbols;SRV*C:\cdb_symbols*http://msdl.microsoft.com/download/symbols
Executable search path is: .
Windows 8.1 Version 9600 MP (4 procs) Free x86 compatible
Product: Server, suite: TerminalServer DataCenter SingleUserTS
6.3.9600.17031 (winblue_gdr.140221-1952)
Machine Name:
Debug session time: Mon Sep 23 12:21:00.000 2019 (UTC + 0:00)
System Uptime: not available
Process Uptime: 0 days 0:00:03.000
...........................................
This dump file has a breakpoint exception stored in it.
The stored exception information can be accessed via .ecxr.
eax=00000000 ebx=0dd58250 ecx=00000000 edx=00000000 esi=0dd58208 edi=0dd58218
eip=774dd10c esp=0aa8a794 ebp=0aa8a7a0 iopl=0         nv up ei pl nz na po nc
cs=0023  ss=002b  ds=002b  es=002b  fs=0053  gs=002b             efl=00000202
ntdll!NtGetContextThread:
         ret     8
0:026> cdb: Reading initial command '!sym prompts off; !analyze -v; .ecxr; !for_each_frame dv /t;!uniqstack -p;q'
quiet mode - symbol prompts off
 
Unable to load image C:\Windows\System32\user32.dll, Win32 error 0n2
Unable to load image C:\Windows\System32\KERNELBASE.dll, Win32 error 0n2
GetUrlPageData2 (WinHttp) failed: 12002.
 
DUMP_CLASS: 2
 
DUMP_QUALIFIER: 400
 
CONTEXT:  (.ecxr)
eax=00000000 ebx=00000000 ecx=005e92d0 edx=00000000 esi=00000016 edi=00000008
eip=005e92d0 esp=0aa8bb90 ebp=0aa8bbe4 iopl=0         nv up ei pl nz ac po nc
cs=0023  ss=002b  ds=002b  es=002b  fs=0053  gs=002b             efl=00000212
mysqld!my_sigabrt_handler:
             int     3
Resetting default scope
 
FAULTING_IP: 
mysqld!my_sigabrt_handler+0 [D:\win32-packages\build\src\mysys\my_thr_init.c @ 484]
             int     3
 
EXCEPTION_RECORD:  (.exr -1)
ExceptionAddress: 005e92d0 (mysqld!my_sigabrt_handler)
   ExceptionCode: 80000003 (Break instruction exception)
  ExceptionFlags: 00000000
NumberParameters: 1
   Parameter[0]: 00000000
 
BUGCHECK_STR:  BREAKPOINT
 
DEFAULT_BUCKET_ID:  BREAKPOINT
 
PROCESS_NAME:  mysqld.exe
 
ERROR_CODE: (NTSTATUS) 0x80000003 - {EXCEPTION}  Breakpoint  A breakpoint has been reached.
 
EXCEPTION_CODE: (HRESULT) 0x80000003 (2147483651) - One or more arguments are invalid
 
EXCEPTION_CODE_STR:  80000003
 
EXCEPTION_PARAMETER1:  00000000
 
WATSON_BKT_PROCSTAMP:  5d88b2c6
 
WATSON_BKT_PROCVER:  10.4.9.0
 
WATSON_BKT_MODULE:  mysqld.exe
 
WATSON_BKT_MODSTAMP:  5d88b2c6
 
WATSON_BKT_MODOFFSET:  5992d0
 
WATSON_BKT_MODVER:  10.4.9.0
 
BUILD_VERSION_STRING:  6.3.9600.17031 (winblue_gdr.140221-1952)
 
MODLIST_WITH_TSCHKSUM_HASH:  112a6025cc3e57faad1e1c47beb95e837f4d1a60
 
MODLIST_SHA1_HASH:  4383d95b0f44f156982ded8533b3d5cbadfd15f8
 
DUMP_FLAGS:  0
 
DUMP_TYPE:  2
 
ANALYSIS_SESSION_HOST:  MARIADB-01
 
ANALYSIS_SESSION_TIME:  09-23-2019 12:21:08.0997
 
ANALYSIS_VERSION: 10.0.16299.15 amd64fre
 
THREAD_ATTRIBUTES: 
PROBLEM_CLASSES: 
 
    ID:     [0n309]
    Type:   [@APPLICATION_FAULT_STRING]
    Class:  Primary
    Scope:  DEFAULT_BUCKET_ID (Failure Bucket ID prefix)
            BUCKET_ID
    Name:   Omit
    Data:   Add
            String: [BREAKPOINT]
    PID:    [Unspecified]
    TID:    [Unspecified]
    Frame:  [0]
 
PRIMARY_PROBLEM_CLASS:  BREAKPOINT
 
LAST_CONTROL_TRANSFER:  from 733c790a to 005e92d0
 
STACK_TEXT:  
mysqld!my_sigabrt_handler
ucrtbase!raise
ucrtbase!abort
mysqld!ut_dbg_assertion_failed
mysqld!fil_check_pending_io
mysqld!fil_check_pending_operations
mysqld!fil_delete_tablespace
mysqld!row_drop_table_for_mysql
mysqld!ha_innobase::delete_table
mysqld!ha_innobase::delete_table
mysqld!handler::ha_delete_table
mysqld!ha_delete_table
mysqld!mysql_rm_table_no_locks
mysqld!mysql_rm_table
mysqld!mysql_execute_command
mysqld!mysql_parse
mysqld!dispatch_command
mysqld!do_command
mysqld!threadpool_process_request
mysqld!tp_callback
mysqld!work_callback
ntdll!TppWorkpExecuteCallback
WARNING: Frame IP not in any known module. Following frames may be wrong.
0xaa8f6dc
0xaa8f84c
0xa8bfdb4
0x8d55250
0xa8bfdbc
0x1964708
 
 
THREAD_SHA1_HASH_MOD_FUNC:  1d133a33d4f223ffd9bd8bf1e3cf46809ff5c7fa
 
THREAD_SHA1_HASH_MOD_FUNC_OFFSET:  ff0e38687adae27c63e8bec940579a6a87584fa4
 
THREAD_SHA1_HASH_MOD:  0695df2b480a67544ae2c9c60c45c1c876676295
 
FOLLOWUP_IP: 
mysqld!my_sigabrt_handler+0 [D:\win32-packages\build\src\mysys\my_thr_init.c @ 484]
             int     3
 
FAULT_INSTR_CODE:  ccccc3cc
 
FAULTING_SOURCE_LINE:  D:\win32-packages\build\src\mysys\my_thr_init.c
 
FAULTING_SOURCE_FILE:  D:\win32-packages\build\src\mysys\my_thr_init.c
 
FAULTING_SOURCE_LINE_NUMBER:  484
 
FAULTING_SOURCE_CODE:  
   480: */
   481: 
   482: #if (_MSC_VER >= 1400)
   483: static void my_sigabrt_handler(int sig)
>  484: {
   485:   __debugbreak();
   486: }
   487: #endif /*_MSC_VER >=1400 */
   488: 
   489: static void install_sigabrt_handler(void)
 
 
SYMBOL_STACK_INDEX:  0
 
SYMBOL_NAME:  mysqld!my_sigabrt_handler+0
 
FOLLOWUP_NAME:  MachineOwner
 
MODULE_NAME: mysqld
 
IMAGE_NAME:  mysqld.exe
 
DEBUG_FLR_IMAGE_TIMESTAMP:  5d88b2c6
 
STACK_COMMAND:  ~26s ; .ecxr ; kb
 
BUCKET_ID:  BREAKPOINT_mysqld!my_sigabrt_handler+0
 
FAILURE_EXCEPTION_CODE:  80000003
 
FAILURE_IMAGE_NAME:  mysqld.exe
 
BUCKET_ID_IMAGE_STR:  mysqld.exe
 
FAILURE_MODULE_NAME:  mysqld
 
BUCKET_ID_MODULE_STR:  mysqld
 
FAILURE_FUNCTION_NAME:  my_sigabrt_handler
 
BUCKET_ID_FUNCTION_STR:  my_sigabrt_handler
 
BUCKET_ID_OFFSET:  0
 
BUCKET_ID_MODTIMEDATESTAMP:  5d88b2c6
 
BUCKET_ID_MODCHECKSUM:  d3b6e8
 
BUCKET_ID_MODVER_STR:  10.4.9.0
 
BUCKET_ID_PREFIX_STR:  BREAKPOINT_
 
FAILURE_PROBLEM_CLASS:  BREAKPOINT
 
FAILURE_SYMBOL_NAME:  mysqld.exe!my_sigabrt_handler
 
FAILURE_BUCKET_ID:  BREAKPOINT_80000003_mysqld.exe!my_sigabrt_handler
 
WATSON_STAGEONE_URL:  http://watson.microsoft.com/StageOne/mysqld.exe/10.4.9.0/5d88b2c6/mysqld.exe/10.4.9.0/5d88b2c6/80000003/005992d0.htm?Retriage=1
 
TARGET_TIME:  2019-09-23T12:21:00.000Z
 
OSBUILD:  9600
 
OSSERVICEPACK:  19358
 
SERVICEPACK_NUMBER: 0
 
OS_REVISION: 0
 
SUITE_MASK:  400
 
PRODUCT_TYPE:  3
 
OSPLATFORM_TYPE:  x86
 
OSNAME:  Windows 8.1
 
OSEDITION:  Windows 8.1 Server TerminalServer DataCenter SingleUserTS
 
OS_LOCALE:  
 
USER_LCID:  0
 
OSBUILD_TIMESTAMP:  2019-05-06 02:08:24
 
BUILDDATESTAMP_STR:  140221-1952
 
BUILDLAB_STR:  winblue_gdr
 
BUILDOSVER_STR:  6.3.9600.17031
 
ANALYSIS_SESSION_ELAPSED_TIME:  5f85
 
ANALYSIS_SOURCE:  UM
 
FAILURE_ID_HASH_STRING:  um:breakpoint_80000003_mysqld.exe!my_sigabrt_handler
 
FAILURE_ID_HASH:  {ecc93889-5372-66cf-bb94-554bc2278271}
 
Followup:     MachineOwner
---------
 
eax=00000000 ebx=00000000 ecx=005e92d0 edx=00000000 esi=00000016 edi=00000008
eip=005e92d0 esp=0aa8bb90 ebp=0aa8bbe4 iopl=0         nv up ei pl nz ac po nc
cs=0023  ss=002b  ds=002b  es=002b  fs=0053  gs=002b             efl=00000212
mysqld!my_sigabrt_handler:
             int     3
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
mysqld!my_sigabrt_handler [D:\win32-packages\build\src\mysys\my_thr_init.c @ 484]
int sig = 0n22
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
ucrtbase!raise
Unable to enumerate locals, Win32 error 0n87
Private symbols (symbols.pri) are required for locals.
Type ".hh dbgerr005" for details.
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
ucrtbase!abort
Unable to enumerate locals, Win32 error 0n87
Private symbols (symbols.pri) are required for locals.
Type ".hh dbgerr005" for details.
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
mysqld!ut_dbg_assertion_failed [D:\win32-packages\build\src\storage\innobase\ut\ut0dbg.cc @ 60]
char * expr = <value unavailable>
char * file = <value unavailable>
unsigned int line = <value unavailable>
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
mysqld!fil_check_pending_io [D:\win32-packages\build\src\storage\innobase\fil\fil0fil.cc @ 2263]
fil_operation_t operation = <value unavailable>
struct fil_space_t * space = <value unavailable>
struct fil_node_t ** node = <value unavailable>
unsigned int count = <value unavailable>
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
mysqld!fil_check_pending_operations [D:\win32-packages\build\src\storage\innobase\fil\fil0fil.cc @ 2342]
unsigned int id = 6
fil_operation_t operation = FIL_OPERATION_DELETE (0n0)
struct fil_space_t ** space = 0x0aa8bde0
char ** path = 0x0aa8bde4
struct fil_space_t * sp = 0x043ea4b8
unsigned int count = 0
struct fil_node_t * node = 0x0197b880
struct fil_system_t fil_system = <value unavailable>
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
mysqld!fil_delete_tablespace [D:\win32-packages\build\src\storage\innobase\fil\fil0fil.cc @ 2465]
unsigned int id = 6
bool drop_ahi = false
char * path = 0x00000000 ""
dberr_t err = <value unavailable>
struct fil_space_t * space = 0x00000000
char * cfg_name = <value unavailable>
struct mtr_t mtr = struct mtr_t
struct fil_space_t * s = <value unavailable>
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
mysqld!row_drop_table_for_mysql [D:\win32-packages\build\src\storage\innobase\row\row0mysql.cc @ 3768]
char * name = 0x0aa8cc58 "test/ibd4f"
struct trx_t * trx = 0x07245b48
enum_sql_command sqlcom = SQLCOM_DROP_TABLE (0n9)
bool create_failed = false
bool nonatomic = false
unsigned int * page_nos = <value unavailable>
struct dict_foreign_t * foreign = <value unavailable>
dberr_t err = DB_SUCCESS (0n0)
struct dict_table_t * table = 0x08e78ea0
char * tablename = 0x08e79458 "--- memory read error at address 0x08e79458 ---"
struct pars_info_t * info = <value unavailable>
unsigned int * page_no = <value unavailable>
bool is_temp_name = false
bool locked_dictionary = true
struct mem_block_info_t * heap = 0x08e79420
struct dict_index_t * index = <value unavailable>
char [1024] errstr = char [1024] "???"
bool immune = false
class std::_Tree_const_iterator<std::_Tree_val<std::_Tree_simple_types<dict_foreign_t *> > > it = <value unavailable>
bool ref_ok = <value unavailable>
struct _iobuf * ef = <value unavailable>
char * tmp_name = <value unavailable>
struct dict_index_t * index = <value unavailable>
char * filepath = 0x00000000 ""
struct fil_space_t * space = 0x043ea4b8
struct dict_index_t * index = <value unavailable>
struct dict_index_t * index = <value unavailable>
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
mysqld!ha_innobase::delete_table [D:\win32-packages\build\src\storage\innobase\handler\ha_innodb.cc @ 12934]
class ha_innobase * this = <value unavailable>
char * name = 0x0aa8e300 ".\test\ibd4f"
enum_sql_command sqlcom = SQLCOM_DROP_TABLE (0n9)
dberr_t err = <value unavailable>
struct trx_t * parent_trx = <value unavailable>
char [512] norm_name = char [512] "test/ibd4f"
class std::_Tree_const_iterator<std::_Tree_val<std::_Tree_simple_types<std::pair<dict_table_t * const,trx_mod_table_time_t> > > > iter = class std::_Tree_const_iterator<std::_Tree_val<std::_Tree_simple_types<std::pair<dict_table_t * const,trx_mod_table_time_t> > > >
class THD * thd = 0x08e35f48
struct trx_t * trx = 0x07245b48
unsigned int name_len = <value unavailable>
struct dict_table_t * table_to_drop = 0x00000018
char * is_part = <value unavailable>
char [512] par_case_name = <value unavailable>
struct table_name_t tbl_name = <value unavailable>
unsigned int num_partitions = <value unavailable>
char * is_part = <value unavailable>
char [512] par_case_name = char [512] "???"
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
mysqld!ha_innobase::delete_table [D:\win32-packages\build\src\storage\innobase\handler\ha_innodb.cc @ 13059]
class ha_innobase * this = 0x08e45468
char * name = 0x0aa8e300 ".\test\ibd4f"
enum_sql_command sqlcom = <value unavailable>
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
mysqld!handler::ha_delete_table [D:\win32-packages\build\src\sql\handler.cc @ 4694]
class handler * this = 0x08e45468
char * name = 0x0aa8e300 ".\test\ibd4f"
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
mysqld!ha_delete_table [D:\win32-packages\build\src\sql\handler.cc @ 2587]
class THD * thd = 0x08e35f48
struct handlerton * table_type = 0x05da10f0
char * path = 0x0aa8e300 ".\test\ibd4f"
struct st_mysql_const_lex_string * db = 0x0aa8e044
struct st_mysql_const_lex_string * alias = 0x08e438d4
bool generate_warning = true
struct TABLE dummy_table = struct TABLE
struct TABLE_SHARE dummy_share = struct TABLE_SHARE
class handler * file = 0x08e45468
char [512] tmp_path = char [512] "h???"
int error = <value unavailable>
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
mysqld!mysql_rm_table_no_locks [D:\win32-packages\build\src\sql\sql_table.cc @ 2477]
class THD * thd = 0x08e35f48
struct TABLE_LIST * tables = 0x08e42f00
bool if_exists = false
bool drop_temporary = false
bool drop_view = false
bool drop_sequence = false
bool dont_log_query = false
bool dont_free_locks = false
char [160] wrong_tables_buff = char [160] "???"
bool non_tmp_error = false
char [513] path = char [513] ".\test\ibd4f"
struct st_mysql_const_lex_string alias = struct st_mysql_const_lex_string
bool is_drop_tmp_if_exists_added = false
struct TABLE_LIST * table = 0x08e438c0
class String wrong_tables = class String
unsigned int errors = 0
int non_temp_tables_count = 0n3
bool was_view = false
class String built_query = class String
bool non_trans_tmp_table_deleted = false
int error = 0n1
bool is_sequence = false
bool was_table = false
unsigned int path_length = 0x10
bool trans_tmp_table_deleted = false
class String built_trans_tmp_query = class String
class String built_non_trans_tmp_query = class String
char * object_to_drop = <value unavailable>
char * comment_start = <value unavailable>
unsigned int comment_len = <value unavailable>
bool is_trans = false
struct handlerton * table_type = 0x05da10f0
struct st_mysql_const_lex_string db = struct st_mysql_const_lex_string
bool table_creation_was_logged = true
class String * built_ptr_query = <value unavailable>
int err = <value unavailable>
char [512] buff = char [512] "???"
class String tbl_name = class String
int frm_delete_error = 0n0
char * end = 0x0aa8e30c ""
int trigger_drop_error = <value unavailable>
int error_code = <value unavailable>
struct st_mysql_const_lex_string null_clex_str = <value unavailable>
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
mysqld!mysql_rm_table [D:\win32-packages\build\src\sql\sql_table.cc @ 2121]
class THD * thd = 0x08e35f48
struct TABLE_LIST * tables = 0x08e42f00
bool if_exists = false
bool drop_temporary = false
bool drop_sequence = false
struct TABLE_LIST * table = 0x00000000
class Drop_table_error_handler err_handler = class Drop_table_error_handler
struct st_mysql_const_lex_string table_name = struct st_mysql_const_lex_string
struct st_mysql_const_lex_string db_name = struct st_mysql_const_lex_string
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
mysqld!mysql_execute_command [D:\win32-packages\build\src\sql\sql_parse.cc @ 4858]
class THD * thd = 0x08e35f48
struct TABLE_LIST * all_tables = 0x08e42f00
class st_select_lex_unit * unit = <value unavailable>
bool have_table_map_for_update = false
enum_binlog_format orig_current_stmt_binlog_format = BINLOG_FORMAT_STMT (0n1)
class Opt_trace_start ots = class Opt_trace_start
class Json_writer_object trace_command = class Json_writer_object
class Json_writer_array trace_command_steps = class Json_writer_array
int up_result = <value unavailable>
int res = 0n0
enum_binlog_format orig_binlog_format = BINLOG_FORMAT_MIXED (0n0)
class Rpl_filter * rpl_filter = <value unavailable>
struct LEX * lex = 0x08e38530
class st_select_lex * select_lex = 0x08e38b18
struct TABLE_LIST * first_table = 0x08e42f00
struct TABLE_LIST * table = 0x00000000
unsigned int64 table_map_for_update = 0
unsigned int nr = <value unavailable>
class Query_arena backup = class Query_arena
class set_var_base * var = 0x00000318
struct st_mem_root * mem_root = 0x00000000
class set_var * o = <value unavailable>
bool null_value = true
int64 val = 0n0
bool null_value = true
bool null_value = false
double val = <value unavailable>
char [80] buff = char [80] "???"
class String * val = <value unavailable>
class String tmp = class String
class Item_string * str = 0x00000000
bool commit_failed = <value unavailable>
unsigned long privileges_requested = <value unavailable>
class Item * it = <value unavailable>
class Master_info * mi = <value unavailable>
bool new_master = <value unavailable>
bool master_info_added = <value unavailable>
class Master_info * mi = <value unavailable>
struct HA_CREATE_INFO create_info = <value unavailable>
class Alter_info alter_info = <value unavailable>
class Master_info * mi = <value unavailable>
int load_error = <value unavailable>
class Master_info * mi = <value unavailable>
unsigned int64 updated = <value unavailable>
unsigned int64 found = <value unavailable>
class multi_update * result_obj = <value unavailable>
class select_insert * sel_result = <value unavailable>
struct TABLE_LIST * second_table = <value unavailable>
struct TABLE_LIST * save_table = <value unavailable>
class select_result * sel_result = <value unavailable>
class Protocol * save_protocol = <value unavailable>
bool replaced_protocol = <value unavailable>
struct TABLE_LIST * aux_tables = <value unavailable>
class multi_delete * result = <value unavailable>
int result = <value unavailable>
unsigned int privilege = <value unavailable>
struct st_mysql_const_lex_string * db = <value unavailable>
struct st_mysql_const_lex_string * db = <value unavailable>
char [193] db_name_buff = <value unavailable>
struct st_mysql_const_lex_string db_name = <value unavailable>
struct LEX_USER * user = <value unavailable>
class List_iterator<LEX_USER> user_list = <value unavailable>
bool first_user = <value unavailable>
class Sp_handler * sph = <value unavailable>
unsigned int grants = <value unavailable>
struct LEX_USER * user = <value unavailable>
class List_iterator<LEX_USER> str_list = <value unavailable>
struct LEX_USER * tmp_user = <value unavailable>
int write_to_binlog = <value unavailable>
class Item * it = <value unavailable>
struct LEX_USER * grant_user = <value unavailable>
struct LEX_USER * grant_user = <value unavailable>
bool commit_failed = <value unavailable>
bool tx_release = <value unavailable>
bool tx_chain = <value unavailable>
bool tx_release = <value unavailable>
bool rollback_failed = <value unavailable>
bool tx_chain = <value unavailable>
class Sp_handler * sph = <value unavailable>
int sp_result = <value unavailable>
class Sp_handler * sph = <value unavailable>
int sp_result = <value unavailable>
struct st_udf_func * udf = <value unavailable>
class Sp_handler * sph = <value unavailable>
bool commit_failed = <value unavailable>
bool rollback_failed = <value unavailable>
int error = <value unavailable>
int err_code = <value unavailable>
class Master_info_index * master_info_index = <value unavailable>
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
mysqld!mysql_parse [D:\win32-packages\build\src\sql\sql_parse.cc @ 7912]
class THD * thd = 0x08e35f48
char * rawbuf = 0x08e42e40 "--- memory read error at address 0x08e42e40 ---"
unsigned int length = 0x1c
class Parser_state * parser_state = 0x0aa8eebc
bool is_com_multi = false
bool is_next_command = false
bool err = <value unavailable>
struct LEX * lex = 0x08e38530
char * found_semicolon = <value unavailable>
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
mysqld!dispatch_command [D:\win32-packages\build\src\sql\sql_parse.cc @ 1840]
enum_server_command command = COM_QUERY (0n3)
class THD * thd = 0x08e35f48
char * packet = 0x08e3ae01 "--- memory read error at address 0x08e3ae01 ---"
unsigned int packet_length = 0x1c
bool is_com_multi = false
bool is_next_command = false
bool error = false
struct st_net * net = <value unavailable>
struct st_mysql_const_lex_string tmp = struct st_mysql_const_lex_string
struct charset_info_st * save_character_set_results = <value unavailable>
struct charset_info_st * save_character_set_client = <value unavailable>
struct user_conn * save_user_connect = <value unavailable>
int auth_rc = <value unavailable>
class Security_context save_security_ctx = class Security_context
struct st_mysql_const_lex_string save_db = struct st_mysql_const_lex_string
struct charset_info_st * save_collation_connection = <value unavailable>
char * packet_end = 0x08e42e5c "--- memory read error at address 0x08e42e5c ---"
class Parser_state parser_state = class Parser_state
unsigned long length = <value unavailable>
char * beginning_of_next_stmt = <value unavailable>
char * fields = <value unavailable>
char * packet_end = <value unavailable>
struct TABLE_LIST table_list = struct TABLE_LIST
class MDL_savepoint mdl_savepoint = class MDL_savepoint
unsigned int arg_length = <value unavailable>
struct st_mysql_const_lex_string db = <value unavailable>
char * arg_end = <value unavailable>
struct st_mysql_lex_string table_name = struct st_mysql_lex_string
unsigned int query_length = <value unavailable>
struct st_schema_table * schema_table = <value unavailable>
unsigned short flags = <value unavailable>
unsigned int nlen = <value unavailable>
unsigned int slave_server_id = <value unavailable>
char * name = <value unavailable>
unsigned long pos = <value unavailable>
unsigned int64 options = <value unavailable>
int not_used = 0n0
unsigned long uptime = <value unavailable>
char [250] buff = char [250] "F???"
unsigned int length = <value unavailable>
unsigned int64 queries_per_second1000 = <value unavailable>
struct system_status_var * current_global_status_var = <value unavailable>
unsigned int opt_command = <value unavailable>
unsigned int current_com = <value unavailable>
unsigned int counter = <value unavailable>
char * packet_start = 0x08e35f48 "--- memory read error at address 0x08e35f48 ---"
struct PSI_statement_locker * save_locker = <value unavailable>
unsigned char * readbuff = <value unavailable>
unsigned int next_length_length = <value unavailable>
unsigned int next_subpacket_length = <value unavailable>
struct sql_digest_state * save_digest = <value unavailable>
enum_server_command subcommand = <value unavailable>
unsigned int subpacket_length = <value unavailable>
unsigned int length_length = <value unavailable>
struct charset_info_st * files_charset_info = <value unavailable>
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
mysqld!do_command [D:\win32-packages\build\src\sql\sql_parse.cc @ 1358]
class THD * thd = 0x08e35f48
bool return_value = <value unavailable>
unsigned long packet_length = 0x1d
enum_server_command command = COM_QUERY (0n3)
char * packet = 0x08e3ae00 "--- memory read error at address 0x08e3ae00 ---"
struct st_net * net = 0x08e3607c
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
mysqld!threadpool_process_request [D:\win32-packages\build\src\sql\threadpool_common.cc @ 366]
class THD * thd = 0x08e35f48
int retval = 0n0
struct st_vio * vio = <value unavailable>
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
mysqld!tp_callback [D:\win32-packages\build\src\sql\threadpool_common.cc @ 193]
struct TP_connection * c = 0x08e0abe8
struct Worker_thread_context worker_context = struct Worker_thread_context
class THD * thd = 0x08e35f48
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
(Inline) -------- mysqld!tp_callback [D:\win32-packages\build\src\sql\threadpool_win.cc @ 368]
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
mysqld!work_callback [D:\win32-packages\build\src\sql\threadpool_win.cc @ 419]
struct _TP_CALLBACK_INSTANCE * instance = 0x0aa8f6f8
void * context = 0x08e0abe8
struct _TP_WORK * work = 0x019646a8
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
ntdll!TppWorkpExecuteCallback
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
0xaa8f6dc
Unable to enumerate locals, Win32 error 0n318
Private symbols (symbols.pri) are required for locals.
Type ".hh dbgerr005" for details.
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
0xaa8f84c
Unable to enumerate locals, Win32 error 0n318
Private symbols (symbols.pri) are required for locals.
Type ".hh dbgerr005" for details.
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
0xa8bfdb4
Unable to enumerate locals, Win32 error 0n318
Private symbols (symbols.pri) are required for locals.
Type ".hh dbgerr005" for details.
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
0x8d55250
Unable to enumerate locals, Win32 error 0n318
Private symbols (symbols.pri) are required for locals.
Type ".hh dbgerr005" for details.
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
0xa8bfdbc
Unable to enumerate locals, Win32 error 0n318
Private symbols (symbols.pri) are required for locals.
Type ".hh dbgerr005" for details.
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
0x1964708
Unable to enumerate locals, Win32 error 0n318
Private symbols (symbols.pri) are required for locals.
Type ".hh dbgerr005" for details.
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
mysqld!my_sigabrt_handler [D:\win32-packages\build\src\mysys\my_thr_init.c @ 484]
Processing 27 threads, please wait
 
.  0  Id: 2a18.18c0 Suspend: 0 Teb: ff17d000 Unfrozen
      Priority: 0  Priority class: 32
  
ntdll!NtWaitForMultipleObjects
kernel32!WaitForMultipleObjects
mysqld!handle_connections_win(void) [D:\win32-packages\build\src\sql\handle_connections_win.cc @ 542]
mysqld!win_main(int argc = 0n149, char ** argv = 0x01989db0) [D:\win32-packages\build\src\sql\mysqld.cc @ 5907]
mysqld!mysql_service(void * p = <Value unavailable error>) [D:\win32-packages\build\src\sql\mysqld.cc @ 5970]
mysqld!mysqld_main(int argc = <Value unavailable error>, char ** argv = <Value unavailable error>) [D:\win32-packages\build\src\sql\mysqld.cc @ 6162]
(Inline) -------- mysqld!invoke_main [d:\agent\_work\3\s\src\vctools\crt\vcstartup\src\startup\exe_common.inl @ 78]
mysqld!__scrt_common_main_seh(void) [d:\agent\_work\3\s\src\vctools\crt\vcstartup\src\startup\exe_common.inl @ 288]
kernel32!BaseThreadInitThunk
ntdll!__RtlUserThreadStart
ntdll!_RtlUserThreadStart
 
.  1  Id: 2a18.21ac Suspend: 0 Teb: ff17a000 Unfrozen
      Priority: 0  Priority class: 32
  
ntdll!NtWaitForAlertByThreadId
KERNELBASE!SleepConditionVariableCS
mysqld!pthread_cond_timedwait(struct _RTL_CONDITION_VARIABLE * cond = 0x015614e0, struct _RTL_CRITICAL_SECTION * mutex = 0x015614c4, struct timespec * abstime = 0x0662fb24) [D:\win32-packages\build\src\mysys\my_wincond.c @ 82]
(Inline) -------- mysqld!inline_mysql_cond_timedwait [D:\win32-packages\build\src\include\mysql\psi\mysql_thread.h @ 1204]
mysqld!timer_handler(void * arg = 0x00000000) [D:\win32-packages\build\src\mysys\thr_timer.c @ 293]
mysqld!pfs_spawn_thread(void * arg = 0x0196e0a8) [D:\win32-packages\build\src\storage\perfschema\pfs.cc @ 1862]
mysqld!pthread_start(void * p = 0x0197aec0) [D:\win32-packages\build\src\mysys\my_winthread.c @ 60]
ucrtbase!thread_start<unsigned int 
kernel32!BaseThreadInitThunk
ntdll!__RtlUserThreadStart
ntdll!_RtlUserThreadStart
 
.  2  Id: 2a18.1c4 Suspend: 0 Teb: ff177000 Unfrozen
      Priority: 0  Priority class: 32
  
ntdll!NtWaitForAlertByThreadId
KERNELBASE!SleepConditionVariableCS
mysqld!pthread_cond_timedwait(struct _RTL_CONDITION_VARIABLE * cond = 0x01552a64, struct _RTL_CRITICAL_SECTION * mutex = 0x01552a48, struct timespec * abstime = 0x0723f85c) [D:\win32-packages\build\src\mysys\my_wincond.c @ 82]
(Inline) -------- mysqld!inline_mysql_cond_timedwait [D:\win32-packages\build\src\include\mysql\psi\mysql_thread.h @ 1204]
mysqld!my_service_thread_sleep(struct st_ma_service_thread_control * control = 0x00b3fac4, unsigned int64 sleep_time = 0x00000006`c088e200) [D:\win32-packages\build\src\storage\maria\ma_servicethread.c @ 115]
mysqld!ma_checkpoint_background(void * arg = 0x0000001e) [D:\win32-packages\build\src\storage\maria\ma_checkpoint.c @ 707]
mysqld!pfs_spawn_thread(void * arg = 0x05da0f00) [D:\win32-packages\build\src\storage\perfschema\pfs.cc @ 1862]
mysqld!pthread_start(void * p = 0x0197ad10) [D:\win32-packages\build\src\mysys\my_winthread.c @ 60]
ucrtbase!thread_start<unsigned int 
kernel32!BaseThreadInitThunk
ntdll!__RtlUserThreadStart
ntdll!_RtlUserThreadStart
 
.  3  Id: 2a18.2cbc Suspend: 0 Teb: ff04f000 Unfrozen
      Priority: 0  Priority class: 32
  
ntdll!NtRemoveIoCompletion
mysqld!os_aio_windows_handler(unsigned int segment = <Value unavailable error>, unsigned int pos = 0, struct fil_node_t ** m1 = 0x0838fcec, void ** m2 = 0x0838fce8, class IORequest * type = 0x0838fcd0) [D:\win32-packages\build\src\storage\innobase\os\os0file.cc @ 6385]
mysqld!os_aio_handler(unsigned int segment = 0, struct fil_node_t ** m1 = 0x0838fcec, void ** m2 = 0x0838fce8, class IORequest * request = 0x0838fcd0) [D:\win32-packages\build\src\storage\innobase\os\os0file.cc @ 5557]
mysqld!fil_aio_wait(unsigned int segment = 0) [D:\win32-packages\build\src\storage\innobase\fil\fil0fil.cc @ 4361]
mysqld!io_handler_thread(void * arg = 0x00d4f488) [D:\win32-packages\build\src\storage\innobase\srv\srv0start.cc @ 324]
kernel32!BaseThreadInitThunk
ntdll!__RtlUserThreadStart
ntdll!_RtlUserThreadStart
 
.  9  Id: 2a18.6ec Suspend: 0 Teb: ff03d000 Unfrozen
      Priority: 0  Priority class: 32
  
ntdll!NtWaitForAlertByThreadId
KERNELBASE!SleepConditionVariableCS
(Inline) -------- mysqld!os_event::wait [D:\win32-packages\build\src\storage\innobase\os\os0event.cc @ 151]
mysqld!os_event::wait_low(int64 reset_sig_count = 0n0) [D:\win32-packages\build\src\storage\innobase\os\os0event.cc @ 325]
mysqld!os_event_wait_low(struct os_event * event = 0x05eda478, int64 reset_sig_count = 0n2) [D:\win32-packages\build\src\storage\innobase\os\os0event.cc @ 503]
mysqld!sync_array_wait_event(struct sync_array_t * arr = 0x0197b6a0, struct sync_cell_t ** cell = 0x08b0f67c) [D:\win32-packages\build\src\storage\innobase\sync\sync0arr.cc @ 473]
mysqld!TTASEventMutex<GenericPolicy>::enter(unsigned int max_spins = 0x3c, unsigned int max_delay = 4, char * filename = 0x008262d4 "D:\win32-packages\build\src\storage\innobase\fil\fil0fil.cc", unsigned int line = 0x361) [D:\win32-packages\build\src\storage\innobase\include\ib0mutex.h @ 480]
mysqld!PolicyMutex<TTASEventMutex<GenericPolicy> >::enter(unsigned int n_spins = 0x1e, unsigned int n_delay = 4, char * name = 0x008262d4 "D:\win32-packages\build\src\storage\innobase\fil\fil0fil.cc", unsigned int line = 0x361) [D:\win32-packages\build\src\storage\innobase\include\ib0mutex.h @ 599]
mysqld!fil_space_extend_must_retry(struct fil_space_t * space = 0x043ea4b8, struct fil_node_t * node = 0x0197b880, unsigned int size = 7, bool * success = 0x08b0f7e3) [D:\win32-packages\build\src\storage\innobase\fil\fil0fil.cc @ 867]
mysqld!fil_mutex_enter_and_prepare_for_io(unsigned int space_id = 6) [D:\win32-packages\build\src\storage\innobase\fil\fil0fil.cc @ 974]
mysqld!fil_io(class IORequest * type = 0x08b0f93c, bool sync = false, class page_id_t page_id = class page_id_t, unsigned int zip_size = 0, unsigned int byte_offset = 0, unsigned int len = 0x1000, void * buf = 0x07780000, void * message = 0x0765ac60, bool ignore_missing_space = false) [D:\win32-packages\build\src\storage\innobase\fil\fil0fil.cc @ 4183]
mysqld!buf_dblwr_write_block_to_datafile(class buf_page_t * bpage = 0x0765ac60, bool sync = false) [D:\win32-packages\build\src\storage\innobase\buf\buf0dblwr.cc @ 938]
mysqld!buf_dblwr_flush_buffered_writes(void) [D:\win32-packages\build\src\storage\innobase\buf\buf0dblwr.cc @ 1082]
mysqld!buf_flush_end(struct buf_pool_t * buf_pool = 0x05f2adb8, buf_flush_t flush_type = BUF_FLUSH_LIST (0n1)) [D:\win32-packages\build\src\storage\innobase\buf\buf0flu.cc @ 1932]
mysqld!buf_flush_do_batch(struct buf_pool_t * buf_pool = 0x05f2adb8, buf_flush_t type = BUF_FLUSH_LIST (0n1), unsigned int min_n = 0xc8, unsigned int64 lsn_limit = 0xffffffff`ffffffff, struct flush_counters_t * n = 0x08b0fa20) [D:\win32-packages\build\src\storage\innobase\buf\buf0flu.cc @ 1997]
mysqld!buf_flush_lists(unsigned int min_n = 0xc8, unsigned int64 lsn_limit = 0xffffffff`ffffffff, unsigned int * n_processed = 0x08b0fb3c) [D:\win32-packages\build\src\storage\innobase\buf\buf0flu.cc @ 2097]
mysqld!buf_flush_page_cleaner_coordinator(void * __formal = 0x00000000) [D:\win32-packages\build\src\storage\innobase\buf\buf0flu.cc @ 3255]
kernel32!BaseThreadInitThunk
ntdll!__RtlUserThreadStart
ntdll!_RtlUserThreadStart
 
. 10  Id: 2a18.210c Suspend: 0 Teb: ff037000 Unfrozen
      Priority: 0  Priority class: 32
  
ntdll!NtWaitForAlertByThreadId
KERNELBASE!SleepConditionVariableCS
mysqld!os_event::timed_wait(unsigned long time_in_ms = 0x3e8) [D:\win32-packages\build\src\storage\innobase\os\os0event.cc @ 253]
mysqld!os_event::wait_time_low(unsigned int time_in_usec = <Value unavailable error>, int64 reset_sig_count = 0n0) [D:\win32-packages\build\src\storage\innobase\os\os0event.cc @ 390]
mysqld!os_event_wait_time_low(struct os_event * event = 0x05f7f358, unsigned int time_in_usec = 0xf4240, int64 reset_sig_count = 0n1) [D:\win32-packages\build\src\storage\innobase\os\os0event.cc @ 486]
mysqld!lock_wait_timeout_thread(void * __formal = 0x00000000) [D:\win32-packages\build\src\storage\innobase\lock\lock0wait.cc @ 523]
kernel32!BaseThreadInitThunk
ntdll!__RtlUserThreadStart
ntdll!_RtlUserThreadStart
 
. 11  Id: 2a18.68 Suspend: 0 Teb: ff034000 Unfrozen
      Priority: 0  Priority class: 32
  
ntdll!NtWaitForAlertByThreadId
KERNELBASE!SleepConditionVariableCS
mysqld!os_event::timed_wait(unsigned long time_in_ms = 0x3e8) [D:\win32-packages\build\src\storage\innobase\os\os0event.cc @ 253]
mysqld!os_event::wait_time_low(unsigned int time_in_usec = <Value unavailable error>, int64 reset_sig_count = 0n0) [D:\win32-packages\build\src\storage\innobase\os\os0event.cc @ 390]
mysqld!os_event_wait_time_low(struct os_event * event = 0x05e74948, unsigned int time_in_usec = 0xf4240, int64 reset_sig_count = 0n1) [D:\win32-packages\build\src\storage\innobase\os\os0event.cc @ 486]
mysqld!srv_error_monitor_thread(void * __formal = 0x00000000) [D:\win32-packages\build\src\storage\innobase\srv\srv0srv.cc @ 1846]
kernel32!BaseThreadInitThunk
ntdll!__RtlUserThreadStart
ntdll!_RtlUserThreadStart
 
. 12  Id: 2a18.1128 Suspend: 0 Teb: ff031000 Unfrozen
      Priority: 0  Priority class: 32
  
ntdll!NtWaitForAlertByThreadId
KERNELBASE!SleepConditionVariableCS
mysqld!os_event::timed_wait(unsigned long time_in_ms = 0x1388) [D:\win32-packages\build\src\storage\innobase\os\os0event.cc @ 253]
mysqld!os_event::wait_time_low(unsigned int time_in_usec = <Value unavailable error>, int64 reset_sig_count = 0n0) [D:\win32-packages\build\src\storage\innobase\os\os0event.cc @ 390]
mysqld!os_event_wait_time_low(struct os_event * event = 0x05e74520, unsigned int time_in_usec = 0x4c4b40, int64 reset_sig_count = 0n1) [D:\win32-packages\build\src\storage\innobase\os\os0event.cc @ 486]
mysqld!srv_monitor_thread(void * __formal = 0x00000000) [D:\win32-packages\build\src\storage\innobase\srv\srv0srv.cc @ 1684]
kernel32!BaseThreadInitThunk
ntdll!__RtlUserThreadStart
ntdll!_RtlUserThreadStart
 
. 13  Id: 2a18.568 Suspend: 0 Teb: ff02e000 Unfrozen
      Priority: 0  Priority class: 32
  
ntdll!NtWaitForAlertByThreadId
KERNELBASE!SleepConditionVariableCS
mysqld!os_event::timed_wait(unsigned long time_in_ms = 0x2710) [D:\win32-packages\build\src\storage\innobase\os\os0event.cc @ 253]
mysqld!os_event::wait_time_low(unsigned int time_in_usec = <Value unavailable error>, int64 reset_sig_count = 0n0) [D:\win32-packages\build\src\storage\innobase\os\os0event.cc @ 390]
mysqld!os_event_wait_time_low(struct os_event * event = 0x05f7eec0, unsigned int time_in_usec = 0x989680, int64 reset_sig_count = 0n0) [D:\win32-packages\build\src\storage\innobase\os\os0event.cc @ 486]
mysqld!dict_stats_thread(void * __formal = 0x00000000) [D:\win32-packages\build\src\storage\innobase\dict\dict0stats_bg.cc @ 475]
kernel32!BaseThreadInitThunk
ntdll!__RtlUserThreadStart
ntdll!_RtlUserThreadStart
 
. 14  Id: 2a18.24c4 Suspend: 0 Teb: ff02b000 Unfrozen
      Priority: 0  Priority class: 32
  
ntdll!NtWaitForAlertByThreadId
KERNELBASE!SleepConditionVariableCS
mysqld!os_event::timed_wait(unsigned long time_in_ms = 0x1388) [D:\win32-packages\build\src\storage\innobase\os\os0event.cc @ 253]
mysqld!os_event::wait_time_low(unsigned int time_in_usec = <Value unavailable error>, int64 reset_sig_count = 0n0) [D:\win32-packages\build\src\storage\innobase\os\os0event.cc @ 390]
mysqld!os_event_wait_time_low(struct os_event * event = 0x05f84368, unsigned int time_in_usec = 0x4c4b40, int64 reset_sig_count = 0n1) [D:\win32-packages\build\src\storage\innobase\os\os0event.cc @ 486]
mysqld!ib_wqueue_timedwait(struct ib_wqueue_t * wq = 0x05e706c8, unsigned int wait_in_usecs = 0x4c4b40) [D:\win32-packages\build\src\storage\innobase\ut\ut0wqueue.cc @ 161]
mysqld!fts_optimize_thread(void * arg = 0x05e706c8) [D:\win32-packages\build\src\storage\innobase\fts\fts0opt.cc @ 2864]
kernel32!BaseThreadInitThunk
ntdll!__RtlUserThreadStart
ntdll!_RtlUserThreadStart
 
. 15  Id: 2a18.3254 Suspend: 0 Teb: ff03a000 Unfrozen
      Priority: 0  Priority class: 32
  
ntdll!NtWaitForAlertByThreadId
KERNELBASE!SleepConditionVariableCS
(Inline) -------- mysqld!os_event::wait [D:\win32-packages\build\src\storage\innobase\os\os0event.cc @ 151]
mysqld!os_event::wait_low(int64 reset_sig_count = 0n0) [D:\win32-packages\build\src\storage\innobase\os\os0event.cc @ 325]
mysqld!os_event_wait_low(struct os_event * event = 0x05eda478, int64 reset_sig_count = 0n2) [D:\win32-packages\build\src\storage\innobase\os\os0event.cc @ 503]
mysqld!sync_array_wait_event(struct sync_array_t * arr = 0x0197b6a0, struct sync_cell_t ** cell = 0x0818fb3c) [D:\win32-packages\build\src\storage\innobase\sync\sync0arr.cc @ 473]
mysqld!TTASEventMutex<GenericPolicy>::enter(unsigned int max_spins = 0x3c, unsigned int max_delay = 4, char * filename = 0x008262d4 "D:\win32-packages\build\src\storage\innobase\fil\fil0fil.cc", unsigned int line = 0x391) [D:\win32-packages\build\src\storage\innobase\include\ib0mutex.h @ 480]
(Inline) -------- mysqld!PolicyMutex<TTASEventMutex<GenericPolicy> >::enter [D:\win32-packages\build\src\storage\innobase\include\ib0mutex.h @ 595]
mysqld!fil_mutex_enter_and_prepare_for_io(unsigned int space_id = 0xfffffff0) [D:\win32-packages\build\src\storage\innobase\fil\fil0fil.cc @ 913]
mysqld!fil_io(class IORequest * type = 0x0818fd8c, bool sync = true, class page_id_t page_id = class page_id_t, unsigned int zip_size = 0, unsigned int byte_offset = 0xa00, unsigned int len = 0x200, void * buf = 0x07e50000, void * message = 0x00000000, bool ignore_missing_space = false) [D:\win32-packages\build\src\storage\innobase\fil\fil0fil.cc @ 4183]
mysqld!log_write_buf(unsigned char * buf = 0x07e50000 "--- memory read error at address 0x07e50000 ---", unsigned int len = 0x200, unsigned int64 start_lsn = 0x60400, unsigned int new_data_offset = <Value unavailable error>) [D:\win32-packages\build\src\storage\innobase\log\log0log.cc @ 780]
mysqld!log_write_up_to(unsigned int64 lsn = 0x6051d, bool flush_to_disk = true, bool rotate_key = false) [D:\win32-packages\build\src\storage\innobase\log\log0log.cc @ 1033]
mysqld!log_buffer_sync_in_background(bool flush = true) [D:\win32-packages\build\src\storage\innobase\log\log0log.cc @ 1091]
mysqld!srv_sync_log_buffer_in_background(void) [D:\win32-packages\build\src\storage\innobase\srv\srv0srv.cc @ 1992]
mysqld!srv_master_do_active_tasks(void) [D:\win32-packages\build\src\storage\innobase\srv\srv0srv.cc @ 2152]
mysqld!srv_master_thread(void * arg = 0x00000000) [D:\win32-packages\build\src\storage\innobase\srv\srv0srv.cc @ 2377]
kernel32!BaseThreadInitThunk
ntdll!__RtlUserThreadStart
ntdll!_RtlUserThreadStart
 
. 16  Id: 2a18.cbc Suspend: 0 Teb: ff028000 Unfrozen
      Priority: 0  Priority class: 32
  
ntdll!NtWaitForAlertByThreadId
KERNELBASE!SleepConditionVariableCS
(Inline) -------- mysqld!os_event::wait [D:\win32-packages\build\src\storage\innobase\os\os0event.cc @ 151]
mysqld!os_event::wait_low(int64 reset_sig_count = 0n0) [D:\win32-packages\build\src\storage\innobase\os\os0event.cc @ 325]
mysqld!os_event_wait_low(struct os_event * event = 0x05e749b8, int64 reset_sig_count = 0n4) [D:\win32-packages\build\src\storage\innobase\os\os0event.cc @ 503]
mysqld!srv_resume_thread(struct srv_slot_t * slot = 0x00d2e840, int64 sig_count = 0n4, bool wait = <Value unavailable error>, unsigned int timeout_usec = 0) [D:\win32-packages\build\src\storage\innobase\srv\srv0srv.cc @ 904]
mysqld!srv_purge_coordinator_suspend(struct srv_slot_t * slot = 0x00d2e840, unsigned int rseg_history_len = 0x15) [D:\win32-packages\build\src\storage\innobase\srv\srv0srv.cc @ 2636]
mysqld!srv_purge_coordinator_thread(void * arg = 0x00000000) [D:\win32-packages\build\src\storage\innobase\srv\srv0srv.cc @ 2709]
kernel32!BaseThreadInitThunk
ntdll!__RtlUserThreadStart
ntdll!_RtlUserThreadStart
 
. 17  Id: 2a18.2440 Suspend: 0 Teb: ff025000 Unfrozen
      Priority: 0  Priority class: 32
  
ntdll!NtWaitForAlertByThreadId
KERNELBASE!SleepConditionVariableCS
(Inline) -------- mysqld!os_event::wait [D:\win32-packages\build\src\storage\innobase\os\os0event.cc @ 151]
mysqld!os_event::wait_low(int64 reset_sig_count = 0n0) [D:\win32-packages\build\src\storage\innobase\os\os0event.cc @ 325]
mysqld!os_event_wait_low(struct os_event * event = 0x05e74be8, int64 reset_sig_count = 0n0) [D:\win32-packages\build\src\storage\innobase\os\os0event.cc @ 503]
mysqld!srv_resume_thread(struct srv_slot_t * slot = 0x00d2e8b8, int64 sig_count = 0n0, bool wait = <Value unavailable error>, unsigned int timeout_usec = 0) [D:\win32-packages\build\src\storage\innobase\srv\srv0srv.cc @ 904]
mysqld!srv_worker_thread(void * arg = 0x00000000) [D:\win32-packages\build\src\storage\innobase\srv\srv0srv.cc @ 2503]
mysqld!srv_purge_coordinator_thread
ntdll!__RtlUserThreadStart
ntdll!_RtlUserThreadStart
 
. 20  Id: 2a18.1a7c Suspend: 0 Teb: ff01c000 Unfrozen
      Priority: 0  Priority class: 32
  
ntdll!NtWaitForAlertByThreadId
KERNELBASE!SleepConditionVariableCS
(Inline) -------- mysqld!os_event::wait [D:\win32-packages\build\src\storage\innobase\os\os0event.cc @ 151]
mysqld!os_event::wait_low(int64 reset_sig_count = 0n0) [D:\win32-packages\build\src\storage\innobase\os\os0event.cc @ 325]
mysqld!os_event_wait_low(struct os_event * event = 0x05e74a98, int64 reset_sig_count = 0n0) [D:\win32-packages\build\src\storage\innobase\os\os0event.cc @ 503]
mysqld!buf_dump_thread(void * __formal = 0x00000000) [D:\win32-packages\build\src\storage\innobase\buf\buf0dump.cc @ 833]
kernel32!BaseThreadInitThunk
ntdll!__RtlUserThreadStart
ntdll!_RtlUserThreadStart
 
. 21  Id: 2a18.1b18 Suspend: 0 Teb: ff019000 Unfrozen
      Priority: 0  Priority class: 32
  
ntdll!NtDelayExecution
KERNELBASE!Sleep
mysqld!os_thread_sleep(unsigned int tm = 0xf4240) [D:\win32-packages\build\src\storage\innobase\os\os0thread.cc @ 234]
mysqld!btr_defragment_thread(void * __formal = 0x00000000) [D:\win32-packages\build\src\storage\innobase\btr\btr0defragment.cc @ 699]
kernel32!BaseThreadInitThunk
ntdll!__RtlUserThreadStart
ntdll!_RtlUserThreadStart
 
. 22  Id: 2a18.404 Suspend: 0 Teb: ff016000 Unfrozen
      Priority: 0  Priority class: 32
  
ntdll!NtWaitForAlertByThreadId
KERNELBASE!SleepConditionVariableCS
(Inline) -------- mysqld!os_event::wait [D:\win32-packages\build\src\storage\innobase\os\os0event.cc @ 151]
mysqld!os_event::wait_low(int64 reset_sig_count = 0n0) [D:\win32-packages\build\src\storage\innobase\os\os0event.cc @ 325]
mysqld!os_event_wait_low(struct os_event * event = 0x05e748a0, int64 reset_sig_count = 0n0) [D:\win32-packages\build\src\storage\innobase\os\os0event.cc @ 503]
mysqld!buf_resize_thread(void * __formal = 0x00000000) [D:\win32-packages\build\src\storage\innobase\buf\buf0buf.cc @ 3208]
kernel32!BaseThreadInitThunk
ntdll!__RtlUserThreadStart
ntdll!_RtlUserThreadStart
 
. 23  Id: 2a18.2340 Suspend: 0 Teb: ff013000 Unfrozen
      Priority: 0  Priority class: 32
  
ntdll!NtWaitForAlertByThreadId
KERNELBASE!SleepConditionVariableCS
mysqld!pthread_cond_timedwait(struct _RTL_CONDITION_VARIABLE * cond = 0x0a49fc60, struct _RTL_CRITICAL_SECTION * mutex = 0x0a49fc44, struct timespec * abstime = 0x00000000) [D:\win32-packages\build\src\mysys\my_wincond.c @ 82]
mysqld!pthread_cond_wait(struct _RTL_CONDITION_VARIABLE * cond = 0x0a49fc60, struct _RTL_CRITICAL_SECTION * mutex = 0x0a49fc44) [D:\win32-packages\build\src\mysys\my_wincond.c @ 90]
(Inline) -------- mysqld!inline_mysql_cond_wait [D:\win32-packages\build\src\include\mysql\psi\mysql_thread.h @ 1178]
mysqld!thd_destructor_proxy(void * __formal = 0x00000000) [D:\win32-packages\build\src\storage\innobase\handler\ha_innodb.cc @ 287]
mysqld!pfs_spawn_thread(void * arg = 0x08d5ea70) [D:\win32-packages\build\src\storage\perfschema\pfs.cc @ 1862]
mysqld!pthread_start(void * p = 0x05da26b0) [D:\win32-packages\build\src\mysys\my_winthread.c @ 60]
ucrtbase!thread_start<unsigned int 
kernel32!BaseThreadInitThunk
ntdll!__RtlUserThreadStart
ntdll!_RtlUserThreadStart
 
. 24  Id: 2a18.2d78 Suspend: 0 Teb: ff010000 Unfrozen
      Priority: 0  Priority class: 32
  
ntdll!NtWaitForWorkViaWorkerFactory
kernel32!BaseThreadInitThunk
ntdll!__RtlUserThreadStart
ntdll!_RtlUserThreadStart
 
. 25  Id: 2a18.213c Suspend: 0 Teb: ff00d000 Unfrozen
      Priority: 0  Priority class: 32
  
ntdll!NtWaitForAlertByThreadId
KERNELBASE!SleepConditionVariableCS
mysqld!pthread_cond_timedwait(struct _RTL_CONDITION_VARIABLE * cond = 0x00cf5af0, struct _RTL_CRITICAL_SECTION * mutex = 0x00cf5948, struct timespec * abstime = 0x00000000) [D:\win32-packages\build\src\mysys\my_wincond.c @ 82]
mysqld!pthread_cond_wait(struct _RTL_CONDITION_VARIABLE * cond = 0x00cf5af0, struct _RTL_CRITICAL_SECTION * mutex = 0x00cf5948) [D:\win32-packages\build\src\mysys\my_wincond.c @ 90]
(Inline) -------- mysqld!inline_mysql_cond_wait [D:\win32-packages\build\src\include\mysql\psi\mysql_thread.h @ 1167]
mysqld!handle_slave_background(void * arg = 0x00000000) [D:\win32-packages\build\src\sql\slave.cc @ 519]
mysqld!pfs_spawn_thread(void * arg = 0x08e09860) [D:\win32-packages\build\src\storage\perfschema\pfs.cc @ 1862]
mysqld!pthread_start(void * p = 0x05da2670) [D:\win32-packages\build\src\mysys\my_winthread.c @ 60]
ucrtbase!thread_start<unsigned int 
kernel32!BaseThreadInitThunk
ntdll!__RtlUserThreadStart
ntdll!_RtlUserThreadStart
 
. 26  Id: 2a18.1a64 Suspend: 0 Teb: ff00a000 Unfrozen
      Priority: 0  Priority class: 32
  
ntdll!NtGetContextThread
WARNING: Frame IP not in any known module. Following frames may be wrong.
0xaa8a858
ntdll!_except_handler4
 
Total threads: 27
Duplicate callstacks: 7 (windbg thread #s follow):
4, 5, 6, 7, 8, 18, 19



 Comments   
Comment by Marko Mäkelä [ 2019-09-23 ]

The failed revision is almost identical to 10.4 5a92ccbaea1bb3973e23846a741f5694a1e687bd, with only one more MDEV-20576 assertion commented out, waiting for MDEV-20595 to be fixed.

The merge included a fix of
MDEV-19529 InnoDB hang on DROP FULLTEXT INDEX
which could theoretically affect the reproducibility of this bug.

Comment by Vladislav Vaintroub [ 2019-10-03 ]

http://buildbot.askmonty.org/buildbot/builders/winx64-packages/builds/15441/steps/test/logs/stdio ,same stacktrace.
fil_space_extend_must_retry() is called by another thread

Comment by Marko Mäkelä [ 2019-11-05 ]

It happens on 10.5 as well.

Comment by Daniel Black [ 2020-05-07 ]

not just windows, p9 rhel7 too

0781c91d288e... in 10.5

innodb.log_data_file_size '32k,innodb'   w19 [ fail ]
        Test ended at 2020-05-06 13:11:39
 
CURRENT_TEST: innodb.log_data_file_size
mysqltest: At line 80: query '$drop_tables' failed: 2013: Lost connection to MySQL server during query
 
The result from queries just before the failure was:
SET GLOBAL innodb_file_per_table=0;
CREATE TABLE t(a INT)ENGINE=InnoDB;
SET GLOBAL innodb_file_per_table=1;
CREATE TABLE ibd4(a INT UNIQUE)ENGINE=InnoDB;
CREATE TABLE ibd4f(a INT UNIQUE)ENGINE=InnoDB;
CREATE TABLE ibd5(a INT UNIQUE, b INT UNIQUE)ENGINE=InnoDB;
# Kill the server
DROP TABLE t,ibd4,ibd4f,ibd5;
 
 - found 'core.9245' (0/0)
 
Trying 'dbx' to get a backtrace
 
Trying 'gdb' to get a backtrace from coredump /opt/buildbot-slave/bld-p9-rhel7/build/mysql-test/var/19/log/innodb.log_data_file_size-32k,innodb/mysqld.1/data/core.9245
Core generated by '/opt/buildbot-slave/bld-p9-rhel7/build/sql/mariadbd'
Output from gdb follows. The first stack trace is from the failing thread.
The following stack traces are from all threads (so the failing one is
duplicated).
--------------------------
[New LWP 9815]
[New LWP 9376]
[New LWP 9537]
[New LWP 9534]
[New LWP 9451]
[New LWP 9768]
[New LWP 9360]
[New LWP 10131]
[New LWP 10132]
[New LWP 10133]
[New LWP 9536]
[New LWP 10127]
[New LWP 9245]
[New LWP 10134]
[New LWP 9808]
[New LWP 9531]
[New LWP 9533]
[New LWP 9532]
[New LWP 9535]
[Thread debugging using libthread_db enabled]
Using host libthread_db library "/lib64/libthread_db.so.1".
Core was generated by `/opt/buildbot-slave/bld-p9-rhel7/build/sql/mariadbd --defaults-group-suffix=.1 '.
Program terminated with signal 6, Aborted.
#0  0x00007fffbbd3fe7c in pthread_kill () from /lib64/libpthread.so.0
#0  0x00007fffbbd3fe7c in pthread_kill () from /lib64/libpthread.so.0
#1  0x0000000124bfdc0c in my_write_core (sig=6) at /opt/buildbot-slave/bld-p9-rhel7/build/mysys/stacktrace.c:518
#2  0x0000000123f440e8 in handle_fatal_signal (sig=6) at /opt/buildbot-slave/bld-p9-rhel7/build/sql/signal_handler.cc:329
#3  <signal handler called>
#4  0x00007fffbb49fbf0 in raise () from /lib64/libc.so.6
#5  0x00007fffbb4a1f6c in abort () from /lib64/libc.so.6
#6  0x00000001248e38a0 in ut_dbg_assertion_failed (expr=0x125191cd8 "!(*node)->being_extended", file=0x125190a10 "/opt/buildbot-slave/bld-p9-rhel7/build/storage/innobase/fil/fil0fil.cc", line=2072) at /opt/buildbot-slave/bld-p9-rhel7/build/storage/innobase/ut/ut0dbg.cc:60
#7  0x0000000124a4b6e0 in fil_check_pending_io (operation=FIL_OPERATION_DELETE, space=0x1001f995828, node=0x7fffb4a12ed8, count=0) at /opt/buildbot-slave/bld-p9-rhel7/build/storage/innobase/fil/fil0fil.cc:2072
#8  0x0000000124a4bafc in fil_check_pending_operations (id=6, operation=FIL_OPERATION_DELETE, space=0x7fffb4a12f40, path=0x7fffb4a12f38) at /opt/buildbot-slave/bld-p9-rhel7/build/storage/innobase/fil/fil0fil.cc:2151
#9  0x0000000124a4c198 in fil_delete_tablespace (id=6, if_exists=false) at /opt/buildbot-slave/bld-p9-rhel7/build/storage/innobase/fil/fil0fil.cc:2266
#10 0x00000001247bdb30 in row_drop_table_for_mysql (name=0x7fffb4a140f8 "test/ibd4f", trx=0x7fffb4d02290, sqlcom=SQLCOM_DROP_TABLE, create_failed=false, nonatomic=true) at /opt/buildbot-slave/bld-p9-rhel7/build/storage/innobase/row/row0mysql.cc:3769
#11 0x00000001245a7d88 in ha_innobase::delete_table (this=0x7fff700194f0, name=0x7fffb4a15fe0 "./test/ibd4f", sqlcom=SQLCOM_DROP_TABLE) at /opt/buildbot-slave/bld-p9-rhel7/build/storage/innobase/handler/ha_innodb.cc:13425
#12 0x000000012458b018 in ha_innobase::delete_table (this=0x7fff700194f0, name=0x7fffb4a15fe0 "./test/ibd4f") at /opt/buildbot-slave/bld-p9-rhel7/build/storage/innobase/handler/ha_innodb.cc:13550
#13 0x0000000123f5b408 in handler::ha_delete_table (this=0x7fff700194f0, name=0x7fffb4a15fe0 "./test/ibd4f") at /opt/buildbot-slave/bld-p9-rhel7/build/sql/handler.cc:4866
#14 0x0000000123f5059c in ha_delete_table (thd=0x7fff70000b18, table_type=0x1001f70efe8, path=0x7fffb4a15fe0 "./test/ibd4f", db=0x7fffb4a15c70, alias=0x7fff70016e90, generate_warning=true) at /opt/buildbot-slave/bld-p9-rhel7/build/sql/handler.cc:2705
#15 0x0000000123bfeea0 in mysql_rm_table_no_locks (thd=0x7fff70000b18, tables=0x7fff70016048, if_exists=false, drop_temporary=false, drop_view=false, drop_sequence=false, dont_log_query=false, dont_free_locks=false) at /opt/buildbot-slave/bld-p9-rhel7/build/sql/sql_table.cc:2501
#16 0x0000000123bfdcf0 in mysql_rm_table (thd=0x7fff70000b18, tables=0x7fff70016048, if_exists=false, drop_temporary=false, drop_sequence=false, dont_log_query=false) at /opt/buildbot-slave/bld-p9-rhel7/build/sql/sql_table.cc:2144
#17 0x0000000123adf19c in mysql_execute_command (thd=0x7fff70000b18) at /opt/buildbot-slave/bld-p9-rhel7/build/sql/sql_parse.cc:4890
#18 0x0000000123aea1b8 in mysql_parse (thd=0x7fff70000b18, rawbuf=0x7fff70015f70 "DROP TABLE t,ibd4,ibd4f,ibd5", length=28, parser_state=0x7fffb4a16c00, is_com_multi=false, is_next_command=false) at /opt/buildbot-slave/bld-p9-rhel7/build/sql/sql_parse.cc:7957
#19 0x0000000123ad4184 in dispatch_command (command=COM_QUERY, thd=0x7fff70000b18, packet=0x7fff70008919 "DROP TABLE t,ibd4,ibd4f,ibd5", packet_length=28, is_com_multi=false, is_next_command=false) at /opt/buildbot-slave/bld-p9-rhel7/build/sql/sql_parse.cc:1840
#20 0x0000000123ad2664 in do_command (thd=0x7fff70000b18) at /opt/buildbot-slave/bld-p9-rhel7/build/sql/sql_parse.cc:1359
#21 0x0000000123ce8758 in do_handle_one_connection (connect=0x1001fe7bb58, put_in_cache=true) at /opt/buildbot-slave/bld-p9-rhel7/build/sql/sql_connect.cc:1411
#22 0x0000000123ce8360 in handle_one_connection (arg=0x1001fe7bb58) at /opt/buildbot-slave/bld-p9-rhel7/build/sql/sql_connect.cc:1313
#23 0x000000012443687c in pfs_spawn_thread (arg=0x1001fd92858) at /opt/buildbot-slave/bld-p9-rhel7/build/storage/perfschema/pfs.cc:2201
#24 0x00007fffbbd38b94 in start_thread () from /lib64/libpthread.so.0
#25 0x00007fffbb5885f4 in clone () from /lib64/libc.so.6

Comment by Alice Sherepa [ 2021-03-01 ]

http://buildbot.askmonty.org/buildbot/builders/kvm-asan/builds/5360/steps/mtr_nm/logs/stdio

10.4 a6c6c4f4633e2432a4b75

innodb.log_data_file_size '32k,innodb'   w3 [ fail ]
        Test ended at 2021-02-25 12:24:15
 
CURRENT_TEST: innodb.log_data_file_size
mysqltest: At line 80: query '$drop_tables' failed: 2013: Lost connection to MySQL server during query
 
The result from queries just before the failure was:
SET GLOBAL innodb_file_per_table=0;
CREATE TABLE t(a INT)ENGINE=InnoDB;
SET GLOBAL innodb_file_per_table=1;
CREATE TABLE ibd4(a INT UNIQUE)ENGINE=InnoDB;
CREATE TABLE ibd4f(a INT UNIQUE)ENGINE=InnoDB;
CREATE TABLE ibd5(a INT UNIQUE, b INT UNIQUE)ENGINE=InnoDB;
# Kill the server
DROP TABLE t,ibd4,ibd4f,ibd5;
 
 
Server [mysqld.1 - pid: 140049, winpid: 140049, exit: 256] failed during test run
Server log from this test:
----------SERVER LOG START-----------
2021-02-25 12:24:09 0 [Note] /home/buildbot/buildbot/build/mariadb-10.4.19/sql/mysqld (mysqld 10.4.19-MariaDB-debug-log) starting as process 139994 ...
2021-02-25 12:24:09 0 [Warning] Could not increase number of max_open_files to more than 1024 (request: 32186)
2021-02-25 12:24:09 0 [Warning] Changed limits: max_open_files: 1024  max_connections: 151 (was 151)  table_cache: 421 (was 2000)
2021-02-25 12:24:09 0 [Warning] setrlimit could not change the size of core files to 'infinity';  We may not be able to generate a core file on signals
2021-02-25 12:24:09 0 [Note] Plugin 'partition' is disabled.
2021-02-25 12:24:09 0 [Note] Plugin 'SEQUENCE' is disabled.
2021-02-25 12:24:09 0 [Note] InnoDB: innodb_page_size=32768
2021-02-25 12:24:09 0 [Note] InnoDB: Using Linux native AIO
2021-02-25 12:24:09 0 [Note] InnoDB: !!!!!!!! UNIV_DEBUG switched on !!!!!!!!!
2021-02-25 12:24:09 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2021-02-25 12:24:09 0 [Note] InnoDB: Uses event mutexes
2021-02-25 12:24:09 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2021-02-25 12:24:09 0 [Note] InnoDB: Number of pools: 1
2021-02-25 12:24:09 0 [Note] InnoDB: Using generic crc32 instructions
2021-02-25 12:24:09 0 [Note] mysqld: O_TMPFILE is not supported on /dev/shm/var/tmp/3/mysqld.1 (disabling future attempts)
2021-02-25 12:24:09 0 [Note] InnoDB: Initializing buffer pool, total size = 24M, instances = 1, chunk size = 24M
2021-02-25 12:24:09 0 [Note] InnoDB: Completed initialization of buffer pool
2021-02-25 12:24:09 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority().
2021-02-25 12:24:09 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2021-02-25 12:24:09 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2021-02-25 12:24:09 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2021-02-25 12:24:09 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB.
2021-02-25 12:24:09 0 [Note] InnoDB: 10.4.19 started; log sequence number 67800; transaction id 33
2021-02-25 12:24:09 0 [Note] InnoDB: Loading buffer pool(s) from /dev/shm/var/3/mysqld.1/data/ib_buffer_pool
2021-02-25 12:24:09 0 [Note] Plugin 'INNODB_SYS_DATAFILES' is disabled.
2021-02-25 12:24:09 0 [Note] Plugin 'INNODB_SYS_TABLESTATS' is disabled.
2021-02-25 12:24:09 0 [Note] Plugin 'INNODB_MUTEXES' is disabled.
2021-02-25 12:24:09 0 [Note] Plugin 'INNODB_CMP' is disabled.
2021-02-25 12:24:09 0 [Note] Plugin 'INNODB_FT_DELETED' is disabled.
2021-02-25 12:24:09 0 [Note] Plugin 'INNODB_CMP_RESET' is disabled.
2021-02-25 12:24:09 0 [Note] Plugin 'INNODB_TABLESPACES_ENCRYPTION' is disabled.
2021-02-25 12:24:09 0 [Note] Plugin 'INNODB_CMPMEM_RESET' is disabled.
2021-02-25 12:24:09 0 [Note] Plugin 'FEEDBACK' is disabled.
2021-02-25 12:24:09 0 [Note] Plugin 'INNODB_FT_INDEX_TABLE' is disabled.
2021-02-25 12:24:09 0 [Note] Plugin 'INNODB_CMP_PER_INDEX_RESET' is disabled.
2021-02-25 12:24:09 0 [Note] Plugin 'user_variables' is disabled.
2021-02-25 12:24:09 0 [Note] Plugin 'INNODB_FT_INDEX_CACHE' is disabled.
2021-02-25 12:24:09 0 [Note] Plugin 'INNODB_FT_BEING_DELETED' is disabled.
2021-02-25 12:24:09 0 [Note] Plugin 'INNODB_FT_DEFAULT_STOPWORD' is disabled.
2021-02-25 12:24:09 0 [Note] Plugin 'INNODB_FT_CONFIG' is disabled.
2021-02-25 12:24:09 0 [Note] Plugin 'INNODB_SYS_TABLESPACES' is disabled.
2021-02-25 12:24:09 0 [Note] Plugin 'INNODB_TABLESPACES_SCRUBBING' is disabled.
2021-02-25 12:24:09 0 [Note] Plugin 'INNODB_SYS_SEMAPHORE_WAITS' is disabled.
2021-02-25 12:24:09 0 [Note] Plugin 'unix_socket' is disabled.
2021-02-25 12:24:09 0 [Warning] /home/buildbot/buildbot/build/mariadb-10.4.19/sql/mysqld: unknown option '--loose-pam-debug'
2021-02-25 12:24:09 0 [Warning] /home/buildbot/buildbot/build/mariadb-10.4.19/sql/mysqld: unknown option '--loose-aria'
2021-02-25 12:24:09 0 [Note] InnoDB: Buffer pool(s) load completed at 210225 12:24:09
2021-02-25 12:24:10 0 [Note] Server socket created on IP: '127.0.0.1'.
2021-02-25 12:24:10 0 [Note] Reading of all Master_info entries succeeded
2021-02-25 12:24:10 0 [Note] Added new Master_info '' to hash table
2021-02-25 12:24:10 0 [Note] /home/buildbot/buildbot/build/mariadb-10.4.19/sql/mysqld: ready for connections.
Version: '10.4.19-MariaDB-debug-log'  socket: '/dev/shm/var/tmp/3/mysqld.1.sock'  port: 16060  Source distribution
2021-02-25 12:24:11 0 [Note] /home/buildbot/buildbot/build/mariadb-10.4.19/sql/mysqld (mysqld 10.4.19-MariaDB-debug-log) starting as process 140051 ...
2021-02-25 12:24:11 0 [Warning] Could not increase number of max_open_files to more than 1024 (request: 32186)
2021-02-25 12:24:11 0 [Warning] Changed limits: max_open_files: 1024  max_connections: 151 (was 151)  table_cache: 421 (was 2000)
2021-02-25 12:24:11 0 [Warning] setrlimit could not change the size of core files to 'infinity';  We may not be able to generate a core file on signals
2021-02-25 12:24:11 0 [Note] Plugin 'partition' is disabled.
2021-02-25 12:24:11 0 [Note] Plugin 'SEQUENCE' is disabled.
2021-02-25 12:24:11 0 [Note] InnoDB: innodb_page_size=32768
2021-02-25 12:24:11 0 [Note] InnoDB: Using Linux native AIO
2021-02-25 12:24:11 0 [Note] InnoDB: !!!!!!!! UNIV_DEBUG switched on !!!!!!!!!
2021-02-25 12:24:11 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2021-02-25 12:24:11 0 [Note] InnoDB: Uses event mutexes
2021-02-25 12:24:11 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2021-02-25 12:24:11 0 [Note] InnoDB: Number of pools: 1
2021-02-25 12:24:11 0 [Note] InnoDB: Using generic crc32 instructions
2021-02-25 12:24:11 0 [Note] mysqld: O_TMPFILE is not supported on /dev/shm/var/tmp/3/mysqld.1 (disabling future attempts)
2021-02-25 12:24:11 0 [Note] InnoDB: Initializing buffer pool, total size = 24M, instances = 1, chunk size = 24M
2021-02-25 12:24:11 0 [Note] InnoDB: Completed initialization of buffer pool
2021-02-25 12:24:11 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority().
2021-02-25 12:24:11 0 [Note] InnoDB: Starting crash recovery from checkpoint LSN=67800
2021-02-25 12:24:11 0 [Note] InnoDB: Starting final batch to recover 25 pages from redo log.
2021-02-25 12:24:12 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2021-02-25 12:24:12 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
2021-02-25 12:24:12 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2021-02-25 12:24:12 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2021-02-25 12:24:12 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB.
2021-02-25 12:24:12 0 [Note] InnoDB: 10.4.19 started; log sequence number 74777; transaction id 42
2021-02-25 12:24:12 0 [Note] InnoDB: Loading buffer pool(s) from /dev/shm/var/3/mysqld.1/data/ib_buffer_pool
2021-02-25 12:24:12 0 [Note] Plugin 'INNODB_SYS_DATAFILES' is disabled.
2021-02-25 12:24:12 0 [Note] Plugin 'INNODB_SYS_TABLESTATS' is disabled.
2021-02-25 12:24:12 0 [Note] Plugin 'INNODB_MUTEXES' is disabled.
2021-02-25 12:24:12 0 [Note] Plugin 'INNODB_CMP' is disabled.
2021-02-25 12:24:12 0 [Note] Plugin 'INNODB_FT_DELETED' is disabled.
2021-02-25 12:24:12 0 [Note] Plugin 'INNODB_CMP_RESET' is disabled.
2021-02-25 12:24:12 0 [Note] Plugin 'INNODB_TABLESPACES_ENCRYPTION' is disabled.
2021-02-25 12:24:12 0 [Note] InnoDB: Buffer pool(s) load completed at 210225 12:24:12
2021-02-25 12:24:12 0 [Note] Plugin 'INNODB_CMPMEM_RESET' is disabled.
2021-02-25 12:24:12 0 [Note] Plugin 'FEEDBACK' is disabled.
2021-02-25 12:24:12 0 [Note] Plugin 'INNODB_FT_INDEX_TABLE' is disabled.
2021-02-25 12:24:12 0 [Note] Plugin 'INNODB_CMP_PER_INDEX_RESET' is disabled.
2021-02-25 12:24:12 0 [Note] Plugin 'user_variables' is disabled.
2021-02-25 12:24:12 0 [Note] Plugin 'INNODB_FT_INDEX_CACHE' is disabled.
2021-02-25 12:24:12 0 [Note] Plugin 'INNODB_FT_BEING_DELETED' is disabled.
2021-02-25 12:24:12 0 [Note] Plugin 'INNODB_FT_DEFAULT_STOPWORD' is disabled.
2021-02-25 12:24:12 0 [Note] Plugin 'INNODB_FT_CONFIG' is disabled.
2021-02-25 12:24:12 0 [Note] Plugin 'INNODB_SYS_TABLESPACES' is disabled.
2021-02-25 12:24:12 0 [Note] Plugin 'INNODB_TABLESPACES_SCRUBBING' is disabled.
2021-02-25 12:24:12 0 [Note] Plugin 'INNODB_SYS_SEMAPHORE_WAITS' is disabled.
2021-02-25 12:24:12 0 [Note] Plugin 'unix_socket' is disabled.
2021-02-25 12:24:12 0 [Warning] /home/buildbot/buildbot/build/mariadb-10.4.19/sql/mysqld: unknown option '--loose-pam-debug'
2021-02-25 12:24:12 0 [Warning] /home/buildbot/buildbot/build/mariadb-10.4.19/sql/mysqld: unknown option '--loose-aria'
2021-02-25 12:24:13 0 [Note] Server socket created on IP: '127.0.0.1'.
2021-02-25 12:24:13 0 [Note] Reading of all Master_info entries succeeded
2021-02-25 12:24:13 0 [Note] Added new Master_info '' to hash table
2021-02-25 12:24:13 0 [Note] /home/buildbot/buildbot/build/mariadb-10.4.19/sql/mysqld: ready for connections.
Version: '10.4.19-MariaDB-debug-log'  socket: '/dev/shm/var/tmp/3/mysqld.1.sock'  port: 16060  Source distribution
mysqld: /home/buildbot/buildbot/build/mariadb-10.4.19/storage/innobase/fil/fil0fil.cc:679: void fil_flush_low(fil_space_t*, bool): Assertion `!space->is_stopping()' failed.
210225 12:24:13 [ERROR] mysqld got signal 6 ;
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.4.19-MariaDB-debug-log
key_buffer_size=1048576
read_buffer_size=131072
max_used_connections=1
max_threads=153
thread_count=6
It is possible that mysqld could use up to 
key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 63641 K  bytes of memory
Hope that's ok; if not, decrease some variables in the equation.
 
Thread pointer: 0x0
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 = 0x0 thread_stack 0x5fc00
/lib/x86_64-linux-gnu/libasan.so.5(+0x6cd30)[0x7f483d57cd30]
/home/buildbot/buildbot/build/mariadb-10.4.19/sql/mysqld(my_print_stacktrace+0xec)[0x55c41679f380]
mysys/stacktrace.c:174(my_print_stacktrace)[0x55c4151fe81f]
/lib/x86_64-linux-gnu/libpthread.so.0(+0x153c0)[0x7f483d4873c0]
/lib/x86_64-linux-gnu/libc.so.6(gsignal+0xcb)[0x7f483cec618b]
/lib/x86_64-linux-gnu/libc.so.6(abort+0x12b)[0x7f483cea5859]
/lib/x86_64-linux-gnu/libc.so.6(+0x25729)[0x7f483cea5729]
/lib/x86_64-linux-gnu/libc.so.6(+0x36f36)[0x7f483ceb6f36]
fil/fil0fil.cc:681(fil_flush_low(fil_space_t*, bool))[0x55c415f09d3c]
fil/fil0fil.cc:882(fil_space_extend_must_retry(fil_space_t*, fil_node_t*, unsigned long, bool*))[0x55c415f0b60d]
fil/fil0fil.cc:962(fil_mutex_enter_and_prepare_for_io(unsigned long))[0x55c415f0bec4]
fil/fil0fil.cc:4137(fil_io(IORequest const&, bool, page_id_t, unsigned long, unsigned long, unsigned long, void*, void*, bool))[0x55c415f232eb]
buf/buf0dblwr.cc:915(buf_dblwr_write_block_to_datafile(buf_page_t const*, bool))[0x55c415e05d19]
buf/buf0dblwr.cc:1059(buf_dblwr_flush_buffered_writes())[0x55c415e06c46]
buf/buf0flu.cc:1929(buf_flush_end(buf_pool_t*, buf_flush_t))[0x55c415e1e4ea]
buf/buf0flu.cc:1996(buf_flush_do_batch(buf_pool_t*, buf_flush_t, unsigned long, unsigned long, flush_counters_t*))[0x55c415e1e7e8]
buf/buf0flu.cc:2094(buf_flush_lists(unsigned long, unsigned long, unsigned long*))[0x55c415e1edc0]
buf/buf0flu.cc:3252(buf_flush_page_cleaner_coordinator)[0x55c415e276e8]
/lib/x86_64-linux-gnu/libpthread.so.0(+0x9609)[0x7f483d47b609]
/lib/x86_64-linux-gnu/libc.so.6(clone+0x43)[0x7f483cfa2103]
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...
Working directory at /dev/shm/var/3/mysqld.1/data
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                    0                    bytes     
Max resident set          unlimited            unlimited            bytes     
Max processes             23441                23441                processes 
Max open files            1024                 1024                 files     
Max locked memory         67108864             67108864             bytes     
Max address space         unlimited            unlimited            bytes     
Max file locks            unlimited            unlimited            locks     
Max pending signals       23441                23441                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: |/usr/share/apport/apport %p %s %c %d %P %E
 
----------SERVER LOG END-------------

Comment by Thirunarayanan Balathandayuthapani [ 2021-03-02 ]

The following patch could solve the issue:

diff --git a/storage/innobase/fil/fil0fil.cc b/storage/innobase/fil/fil0fil.cc
index d6277ae13d8..5c7c7e5d7fd 100644
--- a/storage/innobase/fil/fil0fil.cc
+++ b/storage/innobase/fil/fil0fil.cc
@@ -807,6 +807,10 @@ fil_space_extend_must_retry(
                return(true);
        }
 
+       if (space->is_stopping()) {
+               return false;
+       }
+
        node->being_extended = true;
 
        if (!fil_node_prepare_for_io(node, space)) {
@@ -854,6 +858,11 @@ fil_space_extend_must_retry(
 
        ut_a(node->being_extended);
        node->being_extended = false;
+
+       if (space->is_stopping()) {
+               return false;
+       }
+
        ut_a(last_page_no - file_start_page_no >= node->size);
 
        ulint file_size = last_page_no - file_start_page_no;
@@ -928,6 +937,8 @@ fil_mutex_enter_and_prepare_for_io(
                        anything; if the space does not exist, we handle the
                        situation in the function which called this
                        function */
+               } else if (space->is_stopping()) {
+                       return;
                } else {
                        while (fil_system.n_open >= srv_max_n_open_files) {
                                /* Too many files are open */

fil_space_extend_must_retry() code is lacking the check for space->is_stopping().

Comment by Marko Mäkelä [ 2021-03-08 ]

The fix is not applicable to 10.5, because the code had been heavily refactored as part of MDEV-23855. In fact, the latest failure of this kind in 10.5 occurred on 2020-07-09 for 24ed08c3c45825f0c3555389d4931339, which was before MDEV-23855 had been fixed. So, there is reason to believe that MDEV-23855 fixed this issue already in 10.5.7.

Generated at Thu Feb 08 09:01:06 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.