Opened log file 'C:\work\mysqld_exe_190816_130623_uniqstack.txt' 0:000> !uniqstack Processing 213 threads, please wait . 0 Id: 16fc.e20 Suspend: 0 Teb: 00007ff7`f74ee000 Unfrozen Start: mysqld!mainCRTStartup (00007ff7`f7d00914) Priority: 0 Priority class: 32 Affinity: 7fff # Child-SP RetAddr Call Site 00 0000004f`8535f3b8 00007ffa`9d2e1118 ntdll!NtWaitForSingleObject+0xa 01 0000004f`8535f3c0 00007ffa`9fdc5f4b KERNELBASE!WaitForSingleObjectEx+0x94 02 0000004f`8535f460 00007ffa`9fdc5c2d sechost!ScSendResponseReceiveControls+0x151 03 0000004f`8535f5a0 00007ffa`9fde56b0 sechost!ScDispatcherLoop+0x13b 04 0000004f`8535f6b0 00007ff7`f78e4cbc sechost!StartServiceCtrlDispatcherA+0x54 05 0000004f`8535f6e0 00007ff7`f78ecdc2 mysqld!NTService::Init+0x6c [d:\work\5.5\sql\nt_servc.cc @ 105] 06 0000004f`8535f730 00007ff7`f7d008a4 mysqld!mysqld_main+0x232 [d:\work\5.5\sql\mysqld.cc @ 5244] 07 (Inline Function) --------`-------- mysqld!invoke_main+0x22 [f:\dd\vctools\crt\vcstartup\src\startup\exe_common.inl @ 78] 08 0000004f`8535f9a0 00007ffa`9f7e13f2 mysqld!__scrt_common_main_seh+0x10c [f:\dd\vctools\crt\vcstartup\src\startup\exe_common.inl @ 288] 09 0000004f`8535f9e0 00007ffa`9fe354f4 kernel32!BaseThreadInitThunk+0x22 0a 0000004f`8535fa10 00000000`00000000 ntdll!RtlUserThreadStart+0x34 . 1 Id: 16fc.684 Suspend: 0 Teb: 00007ff7`f74ea000 Unfrozen Start: sechost!ScSvcctrlThreadA (00007ffa`9fdc5aa0) Priority: 0 Priority class: 32 Affinity: 7fff # Child-SP RetAddr Call Site 00 0000004f`85c5fd88 00007ffa`9d2e1118 ntdll!NtWaitForSingleObject+0xa 01 0000004f`85c5fd90 00007ff7`f78e52bc KERNELBASE!WaitForSingleObjectEx+0x94 02 0000004f`85c5fe30 00007ffa`9fdc5ada mysqld!NTService::ServiceMain+0xec [d:\work\5.5\sql\nt_servc.cc @ 263] 03 0000004f`85c5fe70 00007ffa`9f7e13f2 sechost!ScSvcctrlThreadA+0x3a 04 0000004f`85c5fea0 00007ffa`9fe354f4 kernel32!BaseThreadInitThunk+0x22 05 0000004f`85c5fed0 00000000`00000000 ntdll!RtlUserThreadStart+0x34 . 2 Id: 16fc.1710 Suspend: 0 Teb: 00007ff7`f74e8000 Unfrozen Start: mysqld!thread_start (00007ff7`f7d04d50) Priority: 0 Priority class: 32 Affinity: 7fff # Child-SP RetAddr Call Site 00 0000004f`85d5f798 00007ffa`9fe8a222 ntdll!NtWaitForAlertByThreadId+0xa 01 0000004f`85d5f7a0 00007ffa`9d2eb768 ntdll!RtlSleepConditionVariableCS+0xc2 02 0000004f`85d5f810 00007ff7`f7cb93c0 KERNELBASE!SleepConditionVariableCS+0x28 03 0000004f`85d5f840 00007ff7`f78ea019 mysqld!pthread_cond_timedwait+0x30 [d:\work\5.5\mysys\my_wincond.c @ 298] 04 (Inline Function) --------`-------- mysqld!inline_mysql_cond_wait+0x69 [d:\work\5.5\include\mysql\psi\mysql_thread.h @ 986] 05 0000004f`85d5f870 00007ff7`f78ee4e7 mysqld!handle_connections_methods+0x339 [d:\work\5.5\sql\mysqld.cc @ 4572] 06 0000004f`85d5f900 00007ff7`f78ecb22 mysqld!win_main+0x597 [d:\work\5.5\sql\mysqld.cc @ 5048] 07 0000004f`85d5f960 00007ff7`f7d04da0 mysqld!mysql_service+0x32 [d:\work\5.5\sql\mysqld.cc @ 5091] 08 (Inline Function) --------`-------- mysqld!invoke_thread_procedure+0xd [minkernel\crts\ucrt\src\appcrt\startup\thread.cpp @ 82] 09 0000004f`85d5f990 00007ffa`9f7e13f2 mysqld!thread_start+0x50 [minkernel\crts\ucrt\src\appcrt\startup\thread.cpp @ 115] 0a 0000004f`85d5f9c0 00007ffa`9fe354f4 kernel32!BaseThreadInitThunk+0x22 0b 0000004f`85d5f9f0 00000000`00000000 ntdll!RtlUserThreadStart+0x34 . 3 Id: 16fc.1d04 Suspend: 0 Teb: 00007ff7`f74e6000 Unfrozen Start: mysqld!thread_start (00007ff7`f7d04ce8) Priority: 0 Priority class: 32 Affinity: 7fff # Child-SP RetAddr Call Site 00 0000004f`9665fb58 00007ffa`9fe8a222 ntdll!NtWaitForAlertByThreadId+0xa 01 0000004f`9665fb60 00007ffa`9d2eb768 ntdll!RtlSleepConditionVariableCS+0xc2 02 0000004f`9665fbd0 00007ff7`f7cb93c0 KERNELBASE!SleepConditionVariableCS+0x28 03 0000004f`9665fc00 00007ff7`f7b6496b mysqld!pthread_cond_timedwait+0x30 [d:\work\5.5\mysys\my_wincond.c @ 298] 04 (Inline Function) --------`-------- mysqld!inline_mysql_cond_timedwait+0x84 [d:\work\5.5\include\mysql\psi\mysql_thread.h @ 1020] 05 0000004f`9665fc30 00007ff7`f7b2c42c mysqld!my_service_thread_sleep+0x12b [d:\work\5.5\storage\maria\ma_servicethread.c @ 115] 06 0000004f`9665fce0 00007ff7`f7cb8ecb mysqld!ma_checkpoint_background+0x20c [d:\work\5.5\storage\maria\ma_checkpoint.c @ 704] 07 0000004f`9665fd60 00007ff7`f7d04d38 mysqld!pthread_start+0x1b [d:\work\5.5\mysys\my_winthread.c @ 62] 08 (Inline Function) --------`-------- mysqld!invoke_thread_procedure+0xd [minkernel\crts\ucrt\src\appcrt\startup\thread.cpp @ 91] 09 0000004f`9665fd90 00007ffa`9f7e13f2 mysqld!thread_start+0x50 [minkernel\crts\ucrt\src\appcrt\startup\thread.cpp @ 115] 0a 0000004f`9665fdc0 00007ffa`9fe354f4 kernel32!BaseThreadInitThunk+0x22 0b 0000004f`9665fdf0 00000000`00000000 ntdll!RtlUserThreadStart+0x34 . 4 Id: 16fc.ff0 Suspend: 0 Teb: 00007ff7`f74e4000 Unfrozen Start: mysqld!io_handler_thread (00007ff7`f7bf7490) Priority: 0 Priority class: 32 Affinity: 7fff # Child-SP RetAddr Call Site 00 0000004f`9675fba8 00007ffa`9d2e4943 ntdll!NtRemoveIoCompletion+0xa 01 0000004f`9675fbb0 00007ff7`f7be7ea2 KERNELBASE!GetQueuedCompletionStatus+0x3f 02 0000004f`9675fc10 00007ff7`f7bd754f mysqld!os_aio_windows_handle+0x52 [d:\work\5.5\storage\xtradb\os\os0file.c @ 4534] 03 0000004f`9675fc70 00007ff7`f7bf74dc mysqld!fil_aio_wait+0x4f [d:\work\5.5\storage\xtradb\fil\fil0fil.c @ 5720] 04 0000004f`9675fcc0 00007ffa`9f7e13f2 mysqld!io_handler_thread+0x4c [d:\work\5.5\storage\xtradb\srv\srv0start.c @ 497] 05 0000004f`9675fcf0 00007ffa`9fe354f4 kernel32!BaseThreadInitThunk+0x22 06 0000004f`9675fd20 00000000`00000000 ntdll!RtlUserThreadStart+0x34 . 14 Id: 16fc.1b7c Suspend: 0 Teb: 00007ff7`f73ac000 Unfrozen Start: mysqld!srv_lock_timeout_thread (00007ff7`f7beb330) Priority: 0 Priority class: 32 Affinity: 7fff # Child-SP RetAddr Call Site 00 0000005c`6cb1f7f8 00007ffa`9fe8a222 ntdll!NtWaitForAlertByThreadId+0xa 01 0000005c`6cb1f800 00007ffa`9d2eb768 ntdll!RtlSleepConditionVariableCS+0xc2 02 0000005c`6cb1f870 00007ff7`f7c49384 KERNELBASE!SleepConditionVariableCS+0x28 03 0000005c`6cb1f8a0 00007ff7`f7c49b0c mysqld!os_cond_wait_timed+0x24 [d:\work\5.5\storage\xtradb\os\os0sync.c @ 150] 04 0000005c`6cb1f8d0 00007ff7`f7beb3b0 mysqld!os_event_wait_time_low+0x10c [d:\work\5.5\storage\xtradb\os\os0sync.c @ 716] 05 0000005c`6cb1f910 00007ffa`9f7e13f2 mysqld!srv_lock_timeout_thread+0x80 [d:\work\5.5\storage\xtradb\srv\srv0srv.c @ 2835] 06 0000005c`6cb1f970 00007ffa`9fe354f4 kernel32!BaseThreadInitThunk+0x22 07 0000005c`6cb1f9a0 00000000`00000000 ntdll!RtlUserThreadStart+0x34 . 15 Id: 16fc.1be4 Suspend: 0 Teb: 00007ff7`f73aa000 Unfrozen Start: mysqld!srv_error_monitor_thread (00007ff7`f7bea3f0) Priority: 0 Priority class: 32 Affinity: 7fff # Child-SP RetAddr Call Site 00 0000005c`6cc1fb48 00007ffa`9fe8a222 ntdll!NtWaitForAlertByThreadId+0xa 01 0000005c`6cc1fb50 00007ffa`9d2eb768 ntdll!RtlSleepConditionVariableCS+0xc2 02 0000005c`6cc1fbc0 00007ff7`f7c49384 KERNELBASE!SleepConditionVariableCS+0x28 03 0000005c`6cc1fbf0 00007ff7`f7c49b0c mysqld!os_cond_wait_timed+0x24 [d:\work\5.5\storage\xtradb\os\os0sync.c @ 150] 04 0000005c`6cc1fc20 00007ff7`f7bea68a mysqld!os_event_wait_time_low+0x10c [d:\work\5.5\storage\xtradb\os\os0sync.c @ 716] 05 0000005c`6cc1fc60 00007ffa`9f7e13f2 mysqld!srv_error_monitor_thread+0x29a [d:\work\5.5\storage\xtradb\srv\srv0srv.c @ 3047] 06 0000005c`6cc1fcd0 00007ffa`9fe354f4 kernel32!BaseThreadInitThunk+0x22 07 0000005c`6cc1fd00 00000000`00000000 ntdll!RtlUserThreadStart+0x34 . 16 Id: 16fc.1e34 Suspend: 0 Teb: 00007ff7`f73a8000 Unfrozen Start: mysqld!srv_monitor_thread (00007ff7`f7bec470) Priority: 0 Priority class: 32 Affinity: 7fff # Child-SP RetAddr Call Site 00 0000005c`6cd1f718 00007ffa`9fe8a222 ntdll!NtWaitForAlertByThreadId+0xa 01 0000005c`6cd1f720 00007ffa`9d2eb768 ntdll!RtlSleepConditionVariableCS+0xc2 02 0000005c`6cd1f790 00007ff7`f7c49384 KERNELBASE!SleepConditionVariableCS+0x28 03 0000005c`6cd1f7c0 00007ff7`f7c49b0c mysqld!os_cond_wait_timed+0x24 [d:\work\5.5\storage\xtradb\os\os0sync.c @ 150] 04 0000005c`6cd1f7f0 00007ff7`f7bec53a mysqld!os_event_wait_time_low+0x10c [d:\work\5.5\storage\xtradb\os\os0sync.c @ 716] 05 0000005c`6cd1f830 00007ffa`9f7e13f2 mysqld!srv_monitor_thread+0xca [d:\work\5.5\storage\xtradb\srv\srv0srv.c @ 2683] 06 0000005c`6cd1f8a0 00007ffa`9fe354f4 kernel32!BaseThreadInitThunk+0x22 07 0000005c`6cd1f8d0 00000000`00000000 ntdll!RtlUserThreadStart+0x34 . 17 Id: 16fc.1cc0 Suspend: 0 Teb: 00007ff7`f73a6000 Unfrozen Start: mysqld!srv_LRU_dump_restore_thread (00007ff7`f7be9c30) Priority: 0 Priority class: 32 Affinity: 7fff # Child-SP RetAddr Call Site 00 0000005c`6ce1f7c8 00007ffa`9fe8a222 ntdll!NtWaitForAlertByThreadId+0xa 01 0000005c`6ce1f7d0 00007ffa`9d2eb768 ntdll!RtlSleepConditionVariableCS+0xc2 02 0000005c`6ce1f840 00007ff7`f7c49384 KERNELBASE!SleepConditionVariableCS+0x28 03 0000005c`6ce1f870 00007ff7`f7c49b0c mysqld!os_cond_wait_timed+0x24 [d:\work\5.5\storage\xtradb\os\os0sync.c @ 150] 04 0000005c`6ce1f8a0 00007ff7`f7be9cb1 mysqld!os_event_wait_time_low+0x10c [d:\work\5.5\storage\xtradb\os\os0sync.c @ 716] 05 0000005c`6ce1f8e0 00007ffa`9f7e13f2 mysqld!srv_LRU_dump_restore_thread+0x81 [d:\work\5.5\storage\xtradb\srv\srv0srv.c @ 3093] 06 0000005c`6ce1f910 00007ffa`9fe354f4 kernel32!BaseThreadInitThunk+0x22 07 0000005c`6ce1f940 00000000`00000000 ntdll!RtlUserThreadStart+0x34 . 18 Id: 16fc.1f3c Suspend: 0 Teb: 00007ff7`f73a4000 Unfrozen Start: mysqld!srv_master_thread (00007ff7`f7beb570) Priority: 0 Priority class: 32 Affinity: 7fff # Child-SP RetAddr Call Site 00 0000005c`6cf1f2b8 00007ffa`9fe8a222 ntdll!NtWaitForAlertByThreadId+0xa 01 0000005c`6cf1f2c0 00007ffa`9d2eb768 ntdll!RtlSleepConditionVariableCS+0xc2 02 0000005c`6cf1f330 00007ff7`f7c49384 KERNELBASE!SleepConditionVariableCS+0x28 03 0000005c`6cf1f360 00007ff7`f7c49b0c mysqld!os_cond_wait_timed+0x24 [d:\work\5.5\storage\xtradb\os\os0sync.c @ 150] 04 0000005c`6cf1f390 00007ff7`f7beb860 mysqld!os_event_wait_time_low+0x10c [d:\work\5.5\storage\xtradb\os\os0sync.c @ 716] 05 0000005c`6cf1f3d0 00007ffa`9f7e13f2 mysqld!srv_master_thread+0x2f0 [d:\work\5.5\storage\xtradb\srv\srv0srv.c @ 3535] 06 0000005c`6cf1fb60 00007ffa`9fe354f4 kernel32!BaseThreadInitThunk+0x22 07 0000005c`6cf1fb90 00000000`00000000 ntdll!RtlUserThreadStart+0x34 . 19 Id: 16fc.1988 Suspend: 0 Teb: 00007ff7`f73a2000 Unfrozen Start: mysqld!srv_purge_thread (00007ff7`f7bed110) Priority: 0 Priority class: 32 Affinity: 7fff # Child-SP RetAddr Call Site 00 0000005c`6d01f918 00007ffa`9fe8a222 ntdll!NtWaitForAlertByThreadId+0xa 01 0000005c`6d01f920 00007ffa`9d2eb768 ntdll!RtlSleepConditionVariableCS+0xc2 02 0000005c`6d01f990 00007ff7`f7c49384 KERNELBASE!SleepConditionVariableCS+0x28 03 0000005c`6d01f9c0 00007ff7`f7c49b0c mysqld!os_cond_wait_timed+0x24 [d:\work\5.5\storage\xtradb\os\os0sync.c @ 150] 04 0000005c`6d01f9f0 00007ff7`f7bed2f1 mysqld!os_event_wait_time_low+0x10c [d:\work\5.5\storage\xtradb\os\os0sync.c @ 716] 05 0000005c`6d01fa30 00007ffa`9f7e13f2 mysqld!srv_purge_thread+0x1e1 [d:\work\5.5\storage\xtradb\srv\srv0srv.c @ 4237] 06 0000005c`6d01fa70 00007ffa`9fe354f4 kernel32!BaseThreadInitThunk+0x22 07 0000005c`6d01faa0 00000000`00000000 ntdll!RtlUserThreadStart+0x34 . 20 Id: 16fc.10ec Suspend: 0 Teb: 00007ff7`f73a0000 Unfrozen Start: mysqld!thread_start (00007ff7`f7d04ce8) Priority: 0 Priority class: 32 Affinity: 7fff # Child-SP RetAddr Call Site 00 0000005c`6d11f838 00007ffa`9d2e1118 ntdll!NtWaitForSingleObject+0xa 01 0000005c`6d11f840 00007ff7`f78ef19a KERNELBASE!WaitForSingleObjectEx+0x94 02 0000005c`6d11f8e0 00007ff7`f7cb8ecb mysqld!handle_shutdown+0x3a [d:\work\5.5\sql\mysqld.cc @ 3163] 03 0000005c`6d11f950 00007ff7`f7d04d38 mysqld!pthread_start+0x1b [d:\work\5.5\mysys\my_winthread.c @ 62] 04 (Inline Function) --------`-------- mysqld!invoke_thread_procedure+0xd [minkernel\crts\ucrt\src\appcrt\startup\thread.cpp @ 91] 05 0000005c`6d11f980 00007ffa`9f7e13f2 mysqld!thread_start+0x50 [minkernel\crts\ucrt\src\appcrt\startup\thread.cpp @ 115] 06 0000005c`6d11f9b0 00007ffa`9fe354f4 kernel32!BaseThreadInitThunk+0x22 07 0000005c`6d11f9e0 00000000`00000000 ntdll!RtlUserThreadStart+0x34 . 21 Id: 16fc.1b4c Suspend: 0 Teb: 00007ff7`f739e000 Unfrozen Start: mysqld!thread_start (00007ff7`f7d04ce8) Priority: 0 Priority class: 32 Affinity: 7fff # Child-SP RetAddr Call Site 00 0000005c`6d24f188 00007ffa`9c7826eb ntdll!NtWaitForSingleObject+0xa 01 0000005c`6d24f190 00007ffa`9c78aec5 mswsock!SockWaitForSingleObject+0x152 02 0000005c`6d24f210 00007ffa`9de7ffd3 mswsock!WSPSelect+0x79c 03 0000005c`6d24f3b0 00007ff7`f78ea1f8 ws2_32!select+0x1db 04 0000005c`6d24f4a0 00007ff7`f78ef14e mysqld!handle_connections_sockets+0x158 [d:\work\5.5\sql\mysqld.cc @ 5580] 05 0000005c`6d24fa40 00007ff7`f7cb8ecb mysqld!handle_connections_sockets_thread+0xe [d:\work\5.5\sql\mysqld.cc @ 5767] 06 0000005c`6d24fa70 00007ff7`f7d04d38 mysqld!pthread_start+0x1b [d:\work\5.5\mysys\my_winthread.c @ 62] 07 (Inline Function) --------`-------- mysqld!invoke_thread_procedure+0xd [minkernel\crts\ucrt\src\appcrt\startup\thread.cpp @ 91] 08 0000005c`6d24faa0 00007ffa`9f7e13f2 mysqld!thread_start+0x50 [minkernel\crts\ucrt\src\appcrt\startup\thread.cpp @ 115] 09 0000005c`6d24fad0 00007ffa`9fe354f4 kernel32!BaseThreadInitThunk+0x22 0a 0000005c`6d24fb00 00000000`00000000 ntdll!RtlUserThreadStart+0x34 . 22 Id: 16fc.1f38 Suspend: 0 Teb: 00007ff7`f739c000 Unfrozen Start: mysqld!thread_start (00007ff7`f7d04ce8) Priority: 0 Priority class: 32 Affinity: 7fff # Child-SP RetAddr Call Site 00 0000005c`6d34f9a8 00007ffa`9c78ccb4 ntdll!NtWaitForSingleObject+0xa 01 0000005c`6d34f9b0 00007ffa`9c789868 mswsock!SockWaitForSingleObject+0x65 02 0000005c`6d34fa30 00007ffa`9de7f857 mswsock!WSPRecv+0x622 03 0000005c`6d34fb30 00007ff7`f7cfa2c2 ws2_32!recv+0x197 04 0000005c`6d34fbd0 00007ff7`f7935056 mysqld!vio_read+0x72 [d:\work\5.5\vio\viosocket.c @ 83] 05 0000005c`6d34fc10 00007ff7`f7935401 mysqld!my_real_read+0x76 [d:\work\5.5\sql\net_serv.cc @ 840] 06 0000005c`6d34fc50 00007ff7`f7990722 mysqld!my_net_read+0x21 [d:\work\5.5\sql\net_serv.cc @ 1026] 07 0000005c`6d34fca0 00007ff7`f79b9849 mysqld!do_command+0x92 [d:\work\5.5\sql\sql_parse.cc @ 739] 08 0000005c`6d34fcd0 00007ff7`f79baf14 mysqld!do_handle_one_connection+0x139 [d:\work\5.5\sql\sql_connect.cc @ 1268] 09 0000005c`6d34fd00 00007ff7`f7cb8ecb mysqld!handle_one_connection+0x44 [d:\work\5.5\sql\sql_connect.cc @ 1186] 0a 0000005c`6d34fd30 00007ff7`f7d04d38 mysqld!pthread_start+0x1b [d:\work\5.5\mysys\my_winthread.c @ 62] 0b (Inline Function) --------`-------- mysqld!invoke_thread_procedure+0xd [minkernel\crts\ucrt\src\appcrt\startup\thread.cpp @ 91] 0c 0000005c`6d34fd60 00007ffa`9f7e13f2 mysqld!thread_start+0x50 [minkernel\crts\ucrt\src\appcrt\startup\thread.cpp @ 115] 0d 0000005c`6d34fd90 00007ffa`9fe354f4 kernel32!BaseThreadInitThunk+0x22 0e 0000005c`6d34fdc0 00000000`00000000 ntdll!RtlUserThreadStart+0x34 . 24 Id: 16fc.1900 Suspend: 0 Teb: 00007ff7`f7398000 Unfrozen Start: mysqld!thread_start (00007ff7`f7d04ce8) Priority: 0 Priority class: 32 Affinity: 7fff # Child-SP RetAddr Call Site 00 0000005c`6e51d5b8 00007ff7`f7cba650 mysqld!_malloc_base [minkernel\crts\ucrt\src\appcrt\heap\malloc_base.cpp @ 24] 01 0000005c`6e51d5c0 00007ff7`f7cbde15 mysqld!my_malloc+0x30 [d:\work\5.5\mysys\my_malloc.c @ 41] 02 0000005c`6e51d5f0 00007ff7`f7916b70 mysqld!alloc_root+0xa5 [d:\work\5.5\mysys\my_alloc.c @ 222] 03 (Inline Function) --------`-------- mysqld!Item::operator new+0xa [d:\work\5.5\sql\item.h @ 586] 04 0000005c`6e51d620 00007ff7`f7921c28 mysqld!Item_equal::add_const+0xe0 [d:\work\5.5\sql\item_cmpfunc.cc @ 5783] 05 0000005c`6e51d660 00007ff7`f7a0e0d8 mysqld!Item_equal::update_const+0xb8 [d:\work\5.5\sql\item_cmpfunc.cc @ 6028] 06 0000005c`6e51d690 00007ff7`f79fc31d mysqld!update_const_equal_items+0xe8 [d:\work\5.5\sql\sql_select.cc @ 12929] 07 0000005c`6e51d6c0 00007ff7`f79fffa1 mysqld!join_read_const_table+0x16d [d:\work\5.5\sql\sql_select.cc @ 17605] 08 0000005c`6e51d6f0 00007ff7`f7a021ee mysqld!make_join_statistics+0xd51 [d:\work\5.5\sql\sql_select.cc @ 3613] 09 0000005c`6e51d860 00007ff7`f7a016f8 mysqld!JOIN::optimize+0x70e [d:\work\5.5\sql\sql_select.cc @ 1262] 0a 0000005c`6e51d8f0 00007ff7`f79fa5d3 mysqld!mysql_select+0x278 [d:\work\5.5\sql\sql_select.cc @ 3119] 0b 0000005c`6e51d990 00007ff7`f7991336 mysqld!handle_select+0x113 [d:\work\5.5\sql\sql_select.cc @ 311] 0c 0000005c`6e51da30 00007ff7`f799343a mysqld!execute_sqlcom_select+0x286 [d:\work\5.5\sql\sql_parse.cc @ 4678] 0d 0000005c`6e51ded0 00007ff7`f7996f04 mysqld!mysql_execute_command+0x3ba [d:\work\5.5\sql\sql_parse.cc @ 2224] 0e 0000005c`6e51e950 00007ff7`f798fa71 mysqld!mysql_parse+0x104 [d:\work\5.5\sql\sql_parse.cc @ 5928] 0f 0000005c`6e51e9b0 00007ff7`f799078f mysqld!dispatch_command+0x7f1 [d:\work\5.5\sql\sql_parse.cc @ 1068] 10 0000005c`6e51f720 00007ff7`f79b9849 mysqld!do_command+0xff [d:\work\5.5\sql\sql_parse.cc @ 796] 11 0000005c`6e51f750 00007ff7`f79baf14 mysqld!do_handle_one_connection+0x139 [d:\work\5.5\sql\sql_connect.cc @ 1268] 12 0000005c`6e51f780 00007ff7`f7cb8ecb mysqld!handle_one_connection+0x44 [d:\work\5.5\sql\sql_connect.cc @ 1186] 13 0000005c`6e51f7b0 00007ff7`f7d04d38 mysqld!pthread_start+0x1b [d:\work\5.5\mysys\my_winthread.c @ 62] 14 (Inline Function) --------`-------- mysqld!invoke_thread_procedure+0xd [minkernel\crts\ucrt\src\appcrt\startup\thread.cpp @ 91] 15 0000005c`6e51f7e0 00007ffa`9f7e13f2 mysqld!thread_start+0x50 [minkernel\crts\ucrt\src\appcrt\startup\thread.cpp @ 115] 16 0000005c`6e51f810 00007ffa`9fe354f4 kernel32!BaseThreadInitThunk+0x22 17 0000005c`6e51f840 00000000`00000000 ntdll!RtlUserThreadStart+0x34 . 26 Id: 16fc.1178 Suspend: 0 Teb: 00007ff7`f7394000 Unfrozen Start: mysqld!thread_start (00007ff7`f7d04ce8) Priority: 0 Priority class: 32 Affinity: 7fff # Child-SP RetAddr Call Site 00 0000005c`6e71f768 00007ffa`9c7826eb ntdll!NtWaitForSingleObject+0xa 01 0000005c`6e71f770 00007ffa`9c789868 mswsock!SockWaitForSingleObject+0x152 02 0000005c`6e71f7f0 00007ffa`9de7f857 mswsock!WSPRecv+0x622 03 0000005c`6e71f8f0 00007ff7`f7cfa2c2 ws2_32!recv+0x197 04 0000005c`6e71f990 00007ff7`f7935056 mysqld!vio_read+0x72 [d:\work\5.5\vio\viosocket.c @ 83] 05 0000005c`6e71f9d0 00007ff7`f7935401 mysqld!my_real_read+0x76 [d:\work\5.5\sql\net_serv.cc @ 840] 06 0000005c`6e71fa10 00007ff7`f7990722 mysqld!my_net_read+0x21 [d:\work\5.5\sql\net_serv.cc @ 1026] 07 0000005c`6e71fa60 00007ff7`f79b9849 mysqld!do_command+0x92 [d:\work\5.5\sql\sql_parse.cc @ 739] 08 0000005c`6e71fa90 00007ff7`f79baf14 mysqld!do_handle_one_connection+0x139 [d:\work\5.5\sql\sql_connect.cc @ 1268] 09 0000005c`6e71fac0 00007ff7`f7cb8ecb mysqld!handle_one_connection+0x44 [d:\work\5.5\sql\sql_connect.cc @ 1186] 0a 0000005c`6e71faf0 00007ff7`f7d04d38 mysqld!pthread_start+0x1b [d:\work\5.5\mysys\my_winthread.c @ 62] 0b (Inline Function) --------`-------- mysqld!invoke_thread_procedure+0xd [minkernel\crts\ucrt\src\appcrt\startup\thread.cpp @ 91] 0c 0000005c`6e71fb20 00007ffa`9f7e13f2 mysqld!thread_start+0x50 [minkernel\crts\ucrt\src\appcrt\startup\thread.cpp @ 115] 0d 0000005c`6e71fb50 00007ffa`9fe354f4 kernel32!BaseThreadInitThunk+0x22 0e 0000005c`6e71fb80 00000000`00000000 ntdll!RtlUserThreadStart+0x34 . 72 Id: 16fc.27f4 Suspend: 0 Teb: 00007ff7`f733a000 Unfrozen Start: mysqld!thread_start (00007ff7`f7d04ce8) Priority: 0 Priority class: 32 Affinity: 7fff # Child-SP RetAddr Call Site 00 0000005c`90fdf600 00007ff7`f7935401 mysqld!my_real_read+0x102 [d:\work\5.5\sql\net_serv.cc @ 977] 01 0000005c`90fdf640 00007ff7`f7990722 mysqld!my_net_read+0x21 [d:\work\5.5\sql\net_serv.cc @ 1026] 02 0000005c`90fdf690 00007ff7`f79b9849 mysqld!do_command+0x92 [d:\work\5.5\sql\sql_parse.cc @ 739] 03 0000005c`90fdf6c0 00007ff7`f79baf14 mysqld!do_handle_one_connection+0x139 [d:\work\5.5\sql\sql_connect.cc @ 1268] 04 0000005c`90fdf6f0 00007ff7`f7cb8ecb mysqld!handle_one_connection+0x44 [d:\work\5.5\sql\sql_connect.cc @ 1186] 05 0000005c`90fdf720 00007ff7`f7d04d38 mysqld!pthread_start+0x1b [d:\work\5.5\mysys\my_winthread.c @ 62] 06 (Inline Function) --------`-------- mysqld!invoke_thread_procedure+0xd [minkernel\crts\ucrt\src\appcrt\startup\thread.cpp @ 91] 07 0000005c`90fdf750 00007ffa`9f7e13f2 mysqld!thread_start+0x50 [minkernel\crts\ucrt\src\appcrt\startup\thread.cpp @ 115] 08 0000005c`90fdf780 00007ffa`9fe354f4 kernel32!BaseThreadInitThunk+0x22 09 0000005c`90fdf7b0 00000000`00000000 ntdll!RtlUserThreadStart+0x34 .103 Id: 16fc.2cfc Suspend: 0 Teb: 00007ff7`f72fc000 Unfrozen Start: mysqld!thread_start (00007ff7`f7d04ce8) Priority: 0 Priority class: 32 Affinity: 7fff # Child-SP RetAddr Call Site 00 0000005c`92ffd440 00007ffa`9fe50e0d ntdll!RtlpAllocateHeap+0xca4 01 0000005c`92ffd730 00007ff7`f7d1f890 ntdll!RtlAllocateHeap+0x17d 02 0000005c`92ffd840 00007ff7`f7cba650 mysqld!_malloc_base+0x44 [minkernel\crts\ucrt\src\appcrt\heap\malloc_base.cpp @ 34] 03 0000005c`92ffd870 00007ff7`f7af63d5 mysqld!my_malloc+0x30 [d:\work\5.5\mysys\my_malloc.c @ 41] 04 0000005c`92ffd8a0 00007ff7`f7af7fda mysqld!JOIN_CACHE::alloc_buffer+0x1c5 [d:\work\5.5\sql\sql_join_cache.cc @ 942] 05 0000005c`92ffd8f0 00007ff7`f79edaf4 mysqld!JOIN_CACHE::init+0x4a [d:\work\5.5\sql\sql_join_cache.cc @ 1071] 06 0000005c`92ffd920 00007ff7`f79edf44 mysqld!check_join_cache_usage+0x2b4 [d:\work\5.5\sql\sql_select.cc @ 10109] 07 0000005c`92ffd9c0 00007ff7`f79fdabe mysqld!check_join_cache_usage_for_tables+0xf4 [d:\work\5.5\sql\sql_select.cc @ 10273] 08 0000005c`92ffda20 00007ff7`f7a02d5f mysqld!make_join_readinfo+0x15e [d:\work\5.5\sql\sql_select.cc @ 10363] 09 0000005c`92ffda80 00007ff7`f7a4ea1f mysqld!JOIN::optimize+0x127f [d:\work\5.5\sql\sql_select.cc @ 1691] 0a 0000005c`92ffdb10 00007ff7`f7a4dcbf mysqld!st_select_lex_unit::optimize+0x1bf [d:\work\5.5\sql\sql_union.cc @ 627] 0b 0000005c`92ffdb40 00007ff7`f7a4e841 mysqld!st_select_lex_unit::exec+0x9f [d:\work\5.5\sql\sql_union.cc @ 656] 0c 0000005c`92ffdc60 00007ff7`f79fa5ef mysqld!mysql_union+0x31 [d:\work\5.5\sql\sql_union.cc @ 39] 0d 0000005c`92ffdc90 00007ff7`f7991336 mysqld!handle_select+0x12f [d:\work\5.5\sql\sql_select.cc @ 327] 0e 0000005c`92ffdd30 00007ff7`f799343a mysqld!execute_sqlcom_select+0x286 [d:\work\5.5\sql\sql_parse.cc @ 4678] 0f 0000005c`92ffe1d0 00007ff7`f7996f04 mysqld!mysql_execute_command+0x3ba [d:\work\5.5\sql\sql_parse.cc @ 2224] 10 0000005c`92ffec50 00007ff7`f798fa71 mysqld!mysql_parse+0x104 [d:\work\5.5\sql\sql_parse.cc @ 5928] 11 0000005c`92ffecb0 00007ff7`f799078f mysqld!dispatch_command+0x7f1 [d:\work\5.5\sql\sql_parse.cc @ 1068] 12 0000005c`92fffa20 00007ff7`f79b9849 mysqld!do_command+0xff [d:\work\5.5\sql\sql_parse.cc @ 796] 13 0000005c`92fffa50 00007ff7`f79baf14 mysqld!do_handle_one_connection+0x139 [d:\work\5.5\sql\sql_connect.cc @ 1268] 14 0000005c`92fffa80 00007ff7`f7cb8ecb mysqld!handle_one_connection+0x44 [d:\work\5.5\sql\sql_connect.cc @ 1186] 15 0000005c`92fffab0 00007ff7`f7d04d38 mysqld!pthread_start+0x1b [d:\work\5.5\mysys\my_winthread.c @ 62] 16 (Inline Function) --------`-------- mysqld!invoke_thread_procedure+0xd [minkernel\crts\ucrt\src\appcrt\startup\thread.cpp @ 91] 17 0000005c`92fffae0 00007ffa`9f7e13f2 mysqld!thread_start+0x50 [minkernel\crts\ucrt\src\appcrt\startup\thread.cpp @ 115] 18 0000005c`92fffb10 00007ffa`9fe354f4 kernel32!BaseThreadInitThunk+0x22 19 0000005c`92fffb40 00000000`00000000 ntdll!RtlUserThreadStart+0x34 .109 Id: 16fc.2d18 Suspend: 0 Teb: 00007ff7`f72f0000 Unfrozen Start: mysqld!thread_start (00007ff7`f7d04ce8) Priority: 0 Priority class: 32 Affinity: 7fff # Child-SP RetAddr Call Site 00 0000005c`935fd1d8 00007ffa`9fe5de39 ntdll!NtWaitForSingleObject+0xa 01 0000005c`935fd1e0 00007ffa`9fe5b7e4 ntdll!RtlpWaitOnCriticalSection+0xe1 02 0000005c`935fd2b0 00007ffa`9fe532c3 ntdll!RtlpEnterCriticalSectionContended+0xa4 03 0000005c`935fd2f0 00007ffa`9fe50e0d ntdll!RtlpAllocateHeap+0x14e3 04 0000005c`935fd5e0 00007ff7`f7d1f890 ntdll!RtlAllocateHeap+0x17d 05 0000005c`935fd6f0 00007ff7`f7cba650 mysqld!_malloc_base+0x44 [minkernel\crts\ucrt\src\appcrt\heap\malloc_base.cpp @ 34] 06 0000005c`935fd720 00007ff7`f7af63d5 mysqld!my_malloc+0x30 [d:\work\5.5\mysys\my_malloc.c @ 41] 07 0000005c`935fd750 00007ff7`f7af7fda mysqld!JOIN_CACHE::alloc_buffer+0x1c5 [d:\work\5.5\sql\sql_join_cache.cc @ 942] 08 0000005c`935fd7a0 00007ff7`f79edaf4 mysqld!JOIN_CACHE::init+0x4a [d:\work\5.5\sql\sql_join_cache.cc @ 1071] 09 0000005c`935fd7d0 00007ff7`f79edf44 mysqld!check_join_cache_usage+0x2b4 [d:\work\5.5\sql\sql_select.cc @ 10109] 0a 0000005c`935fd870 00007ff7`f79fdabe mysqld!check_join_cache_usage_for_tables+0xf4 [d:\work\5.5\sql\sql_select.cc @ 10273] 0b 0000005c`935fd8d0 00007ff7`f7a02d5f mysqld!make_join_readinfo+0x15e [d:\work\5.5\sql\sql_select.cc @ 10363] 0c 0000005c`935fd930 00007ff7`f7a4ea1f mysqld!JOIN::optimize+0x127f [d:\work\5.5\sql\sql_select.cc @ 1691] 0d 0000005c`935fd9c0 00007ff7`f7a4dcbf mysqld!st_select_lex_unit::optimize+0x1bf [d:\work\5.5\sql\sql_union.cc @ 627] 0e 0000005c`935fd9f0 00007ff7`f7a4e841 mysqld!st_select_lex_unit::exec+0x9f [d:\work\5.5\sql\sql_union.cc @ 656] 0f 0000005c`935fdb10 00007ff7`f79fa5ef mysqld!mysql_union+0x31 [d:\work\5.5\sql\sql_union.cc @ 39] 10 0000005c`935fdb40 00007ff7`f7991336 mysqld!handle_select+0x12f [d:\work\5.5\sql\sql_select.cc @ 327] 11 0000005c`935fdbe0 00007ff7`f799343a mysqld!execute_sqlcom_select+0x286 [d:\work\5.5\sql\sql_parse.cc @ 4678] 12 0000005c`935fe080 00007ff7`f7996f04 mysqld!mysql_execute_command+0x3ba [d:\work\5.5\sql\sql_parse.cc @ 2224] 13 0000005c`935feb00 00007ff7`f798fa71 mysqld!mysql_parse+0x104 [d:\work\5.5\sql\sql_parse.cc @ 5928] 14 0000005c`935feb60 00007ff7`f799078f mysqld!dispatch_command+0x7f1 [d:\work\5.5\sql\sql_parse.cc @ 1068] 15 0000005c`935ff8d0 00007ff7`f79b9849 mysqld!do_command+0xff [d:\work\5.5\sql\sql_parse.cc @ 796] 16 0000005c`935ff900 00007ff7`f79baf14 mysqld!do_handle_one_connection+0x139 [d:\work\5.5\sql\sql_connect.cc @ 1268] 17 0000005c`935ff930 00007ff7`f7cb8ecb mysqld!handle_one_connection+0x44 [d:\work\5.5\sql\sql_connect.cc @ 1186] 18 0000005c`935ff960 00007ff7`f7d04d38 mysqld!pthread_start+0x1b [d:\work\5.5\mysys\my_winthread.c @ 62] 19 (Inline Function) --------`-------- mysqld!invoke_thread_procedure+0xd [minkernel\crts\ucrt\src\appcrt\startup\thread.cpp @ 91] 1a 0000005c`935ff990 00007ffa`9f7e13f2 mysqld!thread_start+0x50 [minkernel\crts\ucrt\src\appcrt\startup\thread.cpp @ 115] 1b 0000005c`935ff9c0 00007ffa`9fe354f4 kernel32!BaseThreadInitThunk+0x22 1c 0000005c`935ff9f0 00000000`00000000 ntdll!RtlUserThreadStart+0x34 .211 Id: 16fc.2950 Suspend: 0 Teb: 00007ff7`f7224000 Unfrozen Start: mysqld!thread_start (00007ff7`f7d04ce8) Priority: 0 Priority class: 32 Affinity: 7fff # Child-SP RetAddr Call Site 00 0000005c`c560d560 00007ff7`f79f8f4b mysqld!create_ref_for_key+0xb9 [d:\work\5.5\sql\sql_select.cc @ 8157] 01 0000005c`c560d650 00007ff7`f7a00845 mysqld!get_best_combination+0x44b [d:\work\5.5\sql\sql_select.cc @ 7947] 02 0000005c`c560d6f0 00007ff7`f7a021ee mysqld!make_join_statistics+0x15f5 [d:\work\5.5\sql\sql_select.cc @ 3871] 03 0000005c`c560d860 00007ff7`f7a016f8 mysqld!JOIN::optimize+0x70e [d:\work\5.5\sql\sql_select.cc @ 1262] 04 0000005c`c560d8f0 00007ff7`f79fa5d3 mysqld!mysql_select+0x278 [d:\work\5.5\sql\sql_select.cc @ 3119] 05 0000005c`c560d990 00007ff7`f7991336 mysqld!handle_select+0x113 [d:\work\5.5\sql\sql_select.cc @ 311] 06 0000005c`c560da30 00007ff7`f799343a mysqld!execute_sqlcom_select+0x286 [d:\work\5.5\sql\sql_parse.cc @ 4678] 07 0000005c`c560ded0 00007ff7`f7996f04 mysqld!mysql_execute_command+0x3ba [d:\work\5.5\sql\sql_parse.cc @ 2224] 08 0000005c`c560e950 00007ff7`f798fa71 mysqld!mysql_parse+0x104 [d:\work\5.5\sql\sql_parse.cc @ 5928] 09 0000005c`c560e9b0 00007ff7`f799078f mysqld!dispatch_command+0x7f1 [d:\work\5.5\sql\sql_parse.cc @ 1068] 0a 0000005c`c560f720 00007ff7`f79b9849 mysqld!do_command+0xff [d:\work\5.5\sql\sql_parse.cc @ 796] 0b 0000005c`c560f750 00007ff7`f79baf14 mysqld!do_handle_one_connection+0x139 [d:\work\5.5\sql\sql_connect.cc @ 1268] 0c 0000005c`c560f780 00007ff7`f7cb8ecb mysqld!handle_one_connection+0x44 [d:\work\5.5\sql\sql_connect.cc @ 1186] 0d 0000005c`c560f7b0 00007ff7`f7d04d38 mysqld!pthread_start+0x1b [d:\work\5.5\mysys\my_winthread.c @ 62] 0e (Inline Function) --------`-------- mysqld!invoke_thread_procedure+0xd [minkernel\crts\ucrt\src\appcrt\startup\thread.cpp @ 91] 0f 0000005c`c560f7e0 00007ffa`9f7e13f2 mysqld!thread_start+0x50 [minkernel\crts\ucrt\src\appcrt\startup\thread.cpp @ 115] 10 0000005c`c560f810 00007ffa`9fe354f4 kernel32!BaseThreadInitThunk+0x22 11 0000005c`c560f840 00000000`00000000 ntdll!RtlUserThreadStart+0x34 .212 Id: 16fc.34b0 Suspend: 0 Teb: 00007ff7`f7222000 Unfrozen Start: mysqld!thread_start (00007ff7`f7d04ce8) Priority: 0 Priority class: 32 Affinity: 7fff # Child-SP RetAddr Call Site 00 0000005c`c778f4e8 00007ffa`9fe8a222 ntdll!NtWaitForAlertByThreadId+0xa 01 0000005c`c778f4f0 00007ffa`9d2eb768 ntdll!RtlSleepConditionVariableCS+0xc2 02 0000005c`c778f560 00007ff7`f7cb93c0 KERNELBASE!SleepConditionVariableCS+0x28 03 0000005c`c778f590 00007ff7`f78e6f42 mysqld!pthread_cond_timedwait+0x30 [d:\work\5.5\mysys\my_wincond.c @ 298] 04 (Inline Function) --------`-------- mysqld!inline_mysql_cond_wait+0x68 [d:\work\5.5\include\mysql\psi\mysql_thread.h @ 986] 05 0000005c`c778f5c0 00007ff7`f78ed13b mysqld!cache_thread+0xf2 [d:\work\5.5\sql\mysqld.cc @ 2474] 06 0000005c`c778f640 00007ff7`f79b98b5 mysqld!one_thread_per_connection_end+0x9b [d:\work\5.5\sql\mysqld.cc @ 2545] 07 0000005c`c778f6c0 00007ff7`f79baf14 mysqld!do_handle_one_connection+0x1a5 [d:\work\5.5\sql\sql_connect.cc @ 1279] 08 0000005c`c778f6f0 00007ff7`f7cb8ecb mysqld!handle_one_connection+0x44 [d:\work\5.5\sql\sql_connect.cc @ 1186] 09 0000005c`c778f720 00007ff7`f7d04d38 mysqld!pthread_start+0x1b [d:\work\5.5\mysys\my_winthread.c @ 62] 0a (Inline Function) --------`-------- mysqld!invoke_thread_procedure+0xd [minkernel\crts\ucrt\src\appcrt\startup\thread.cpp @ 91] 0b 0000005c`c778f750 00007ffa`9f7e13f2 mysqld!thread_start+0x50 [minkernel\crts\ucrt\src\appcrt\startup\thread.cpp @ 115] 0c 0000005c`c778f780 00007ffa`9fe354f4 kernel32!BaseThreadInitThunk+0x22 0d 0000005c`c778f7b0 00000000`00000000 ntdll!RtlUserThreadStart+0x34 Total threads: 213 Duplicate callstacks: 192 (windbg thread #s follow): 5, 6, 7, 8, 9, 10, 11, 12, 13, 23, 25, 27, 28, 29, 30, 31, 32, 33, 34, 35, 36, 37, 38, 39, 40, 41, 42, 43, 44, 45, 46, 47, 48, 49, 50, 51, 52, 53, 54, 55, 56, 57, 58, 59, 60, 61, 62, 63, 64, 65, 66, 67, 68, 69, 70, 71, 73, 74, 75, 76, 77, 78, 79, 80, 81, 82, 83, 84, 85, 86, 87, 88, 89, 90, 91, 92, 93, 94, 95, 96, 97, 98, 99, 100, 101, 102, 104, 105, 106, 107, 108, 110, 111, 112, 113, 114, 115, 116, 117, 118, 119, 120, 121, 122, 123, 124, 125, 126, 127, 128, 129, 130, 131, 132, 133, 134, 135, 136, 137, 138, 139, 140, 141, 142, 143, 144, 145, 146, 147, 148, 149, 150, 151, 152, 153, 154, 155, 156, 157, 158, 159, 160, 161, 162, 163, 164, 165, 166, 167, 168, 169, 170, 171, 172, 173, 174, 175, 176, 177, 178, 179, 180, 181, 182, 183, 184, 185, 186, 187, 188, 189, 190, 191, 192, 193, 194, 195, 196, 197, 198, 199, 200, 201, 202, 203, 204, 205, 206, 207, 208, 209, 210 0:000> .logclose Closing open log file C:\work\mysqld_exe_190816_130623_uniqstack.txt