Bug #98793 Mysql Service Stop when database has large number of data and try to truncate
Submitted: 2 Mar 2020 2:01 Modified: 2 Apr 2020 8:50
Reporter: Tobias Tromm Tobias Email Updates:
Status: No Feedback Impact on me:
None 
Category:MySQL Server: Windows Severity:S2 (Serious)
Version:8.0.18 - MySQL Community Server - GPL OS:Windows (Windows Server 2019 17763.973)
Assigned to: CPU Architecture:Any

[2 Mar 2020 2:01] Tobias Tromm Tobias
Description:
Error ID 1000

Nome do aplicativo com falha: mysqld.exe, versão: 8.0.18.0, carimbo de data/hora: 0x5d84cdc7
Nome do módulo com falha: mysqld.exe, versão: 8.0.18.0, carimbo de data/hora: 0x5d84cdc7
Código de exceção: 0x80000003
Deslocamento da falha: 0x0000000000ea6622
ID do processo com falha: 0x1194
Hora de início do aplicativo com falha: 0x01d5df949b493f23
Caminho do aplicativo com falha: C:\Program Files\MySQL\MySQL Server 8.0\bin\mysqld.exe
Caminho do módulo com falha: C:\Program Files\MySQL\MySQL Server 8.0\bin\mysqld.exe
ID do Relatório: 6bffe63a-22d5-4382-89e2-bae0f3cd472e
Nome completo do pacote com falha: 
ID do aplicativo relativo ao pacote com falha: 

Falha no bucket 1781963999876469325, tipo 4
Nome do Evento: APPCRASH
Resposta: Não disponível
ID do CAB: 0

Assinatura do problema:
P1: mysqld.exe
P2: 8.0.18.0
P3: 5d84cdc7
P4: mysqld.exe
P5: 8.0.18.0
P6: 5d84cdc7
P7: 80000003
P8: 0000000000ea6622
P9: 
P10: 

Arquivos anexados:
\\?\C:\ProgramData\Microsoft\Windows\WER\Temp\WERBDA9.tmp.dmp
\\?\C:\ProgramData\Microsoft\Windows\WER\Temp\WERD0A5.tmp.WERInternalMetadata.xml
\\?\C:\ProgramData\Microsoft\Windows\WER\Temp\WERD0A6.tmp.xml
\\?\C:\ProgramData\Microsoft\Windows\WER\Temp\WERD0A4.tmp.csv
\\?\C:\ProgramData\Microsoft\Windows\WER\Temp\WERD0C4.tmp.txt

Esses arquivos talvez estejam disponíveis em:
\\?\C:\ProgramData\Microsoft\Windows\WER\ReportArchive\AppCrash_mysqld.exe_b79fa1f3af21ba72c214fbb9a75756b4bedc42_68f424d0_40eed855

Símbolo da análise: 
Verificando novamente se há uma solução: 0
ID do Relatório: 6bffe63a-22d5-4382-89e2-bae0f3cd472e
Status do Relatório: 268435456
Bucket com hash: 4df34117218700aa68baced10f2bd24dGuid do CAB: 0

Version=1
EventType=APPCRASH
EventTime=132275848067845017
ReportType=2
Consent=1
UploadTime=132275848116739721
ReportStatus=268435456
ReportIdentifier=57eed8f1-a4d1-4398-b062-91d71dbaa303
IntegratorReportIdentifier=6bffe63a-22d5-4382-89e2-bae0f3cd472e
Wow64Host=34404
NsAppName=mysqld.exe
AppSessionGuid=00001194-0000-0023-233f-499b94dfd501
TargetAppId=W:000653c2627e1fd12ae1b11dcc025881e7cb00000904!0000557e28093c61d3fc93a0ca528085ac456c55d9af!mysqld.exe
TargetAppVer=2019//09//20:13:01:59!2e8b8ec!mysqld.exe
BootId=4294967295
TargetAsId=81
IsFatal=1
EtwNonCollectReason=1
Response.BucketId=4df34117218700aa68baced10f2bd24d
Response.BucketTable=4
Response.LegacyBucketId=1781963999876469325
Response.type=4
Sig[0].Name=Nome do Aplicativo
Sig[0].Value=mysqld.exe
Sig[1].Name=Versão do Aplicativo
Sig[1].Value=8.0.18.0
Sig[2].Name=Carimbo de Data//Hora do Aplicativo
Sig[2].Value=5d84cdc7
Sig[3].Name=Nome do Módulo de Falhas
Sig[3].Value=mysqld.exe
Sig[4].Name=Versão do Módulo de Falhas
Sig[4].Value=8.0.18.0
Sig[5].Name=Carimbo de Data//Hora do Módulo de Falhas
Sig[5].Value=5d84cdc7
Sig[6].Name=Código de Exceção
Sig[6].Value=80000003
Sig[7].Name=Deslocamento de Exceção
Sig[7].Value=0000000000ea6622
DynamicSig[1].Name=Versão do sistema operacional
DynamicSig[1].Value=10.0.17763.2.0.0.272.7
DynamicSig[2].Name=Identificação da Localidade
DynamicSig[2].Value=1046
DynamicSig[22].Name=Informações Adicionais 1
DynamicSig[22].Value=9e05
DynamicSig[23].Name=Informações Adicionais 2
DynamicSig[23].Value=9e056b477017c8e4938861b25de519b5
DynamicSig[24].Name=Informações Adicionais 3
DynamicSig[24].Value=3eec
DynamicSig[25].Name=Informações Adicionais 4
DynamicSig[25].Value=3eecd7ddc3a132ee247898210e70bdf9
UI[2]=C:\Program Files\MySQL\MySQL Server 8.0\bin\mysqld.exe
UI[5]=Procurar solução online (recomendado)
UI[6]=Verificar se há uma solução mais tarde (recomendado)
UI[7]=Fechar
UI[8]=mysqld.exe parou de funcionar e foi fechado
UI[9]=Um problema impediu que o aplicativo funcione corretamente. O Windows notificará você caso uma solução seja disponibilizada.
UI[10]=&Fechar
LoadedModule[0]=C:\Program Files\MySQL\MySQL Server 8.0\bin\mysqld.exe
LoadedModule[1]=C:\Windows\SYSTEM32\ntdll.dll
LoadedModule[2]=C:\Windows\System32\KERNEL32.DLL
LoadedModule[3]=C:\Windows\System32\KERNELBASE.dll
LoadedModule[4]=C:\Windows\System32\ADVAPI32.dll
LoadedModule[5]=C:\Windows\System32\msvcrt.dll
LoadedModule[6]=C:\Windows\System32\sechost.dll
LoadedModule[7]=C:\Windows\System32\RPCRT4.dll
LoadedModule[8]=C:\Windows\System32\ucrtbase.dll
LoadedModule[9]=C:\Windows\System32\USER32.dll
LoadedModule[10]=C:\Program Files\MySQL\MySQL Server 8.0\bin\libprotobuf-lite.dll
LoadedModule[11]=C:\Windows\SYSTEM32\Secur32.dll
LoadedModule[12]=C:\Program Files\MySQL\MySQL Server 8.0\bin\libssl-1_1-x64.dll
LoadedModule[13]=C:\Windows\System32\win32u.dll
LoadedModule[14]=C:\Windows\System32\GDI32.dll
LoadedModule[15]=C:\Program Files\MySQL\MySQL Server 8.0\bin\libcrypto-1_1-x64.dll
LoadedModule[16]=C:\Windows\System32\gdi32full.dll
LoadedModule[17]=C:\Windows\SYSTEM32\MSVCP140.dll
LoadedModule[18]=C:\Windows\System32\WS2_32.dll
LoadedModule[19]=C:\Windows\System32\msvcp_win.dll
LoadedModule[20]=C:\Windows\SYSTEM32\dbghelp.dll
LoadedModule[21]=C:\Windows\System32\bcrypt.dll
LoadedModule[22]=C:\Windows\System32\SHELL32.dll
LoadedModule[23]=C:\Windows\SYSTEM32\VCRUNTIME140.dll
LoadedModule[24]=C:\Windows\System32\cfgmgr32.dll
LoadedModule[25]=C:\Windows\System32\shcore.dll
LoadedModule[26]=C:\Windows\System32\combase.dll
LoadedModule[27]=C:\Windows\System32\bcryptPrimitives.dll
LoadedModule[28]=C:\Windows\System32\windows.storage.dll
LoadedModule[29]=C:\Windows\System32\profapi.dll
LoadedModule[30]=C:\Windows\System32\powrprof.dll
LoadedModule[31]=C:\Windows\System32\shlwapi.dll
LoadedModule[32]=C:\Windows\System32\kernel.appcore.dll
LoadedModule[33]=C:\Windows\System32\cryptsp.dll
LoadedModule[34]=C:\Windows\SYSTEM32\SSPICLI.DLL
LoadedModule[35]=C:\Windows\SYSTEM32\dbgcore.DLL
LoadedModule[36]=C:\Windows\system32\napinsp.dll
LoadedModule[37]=C:\Windows\System32\mswsock.dll
LoadedModule[38]=C:\Windows\SYSTEM32\DNSAPI.dll
LoadedModule[39]=C:\Windows\System32\NSI.dll
LoadedModule[40]=C:\Windows\SYSTEM32\IPHLPAPI.DLL
LoadedModule[41]=C:\Windows\System32\winrnr.dll
LoadedModule[42]=C:\Windows\system32\NLAapi.dll
LoadedModule[43]=C:\Windows\system32\wshbth.dll
State[0].Key=Transport.DoneStage1
State[0].Value=1
OsInfo[0].Key=vermaj
OsInfo[0].Value=10
OsInfo[1].Key=vermin
OsInfo[1].Value=0
OsInfo[2].Key=verbld
OsInfo[2].Value=17763
OsInfo[3].Key=ubr
OsInfo[3].Value=973
OsInfo[4].Key=versp
OsInfo[4].Value=0
OsInfo[5].Key=arch
OsInfo[5].Value=9
OsInfo[6].Key=lcid
OsInfo[6].Value=1046
OsInfo[7].Key=geoid
OsInfo[7].Value=32
OsInfo[8].Key=sku
OsInfo[8].Value=7
OsInfo[9].Key=domain
OsInfo[9].Value=0
OsInfo[10].Key=prodsuite
OsInfo[10].Value=272
OsInfo[11].Key=ntprodtype
OsInfo[11].Value=3
OsInfo[12].Key=platid
OsInfo[12].Value=10
OsInfo[13].Key=sr
OsInfo[13].Value=0
OsInfo[14].Key=tmsi
OsInfo[14].Value=337262
OsInfo[15].Key=osinsty
OsInfo[15].Value=2
OsInfo[16].Key=iever
OsInfo[16].Value=11.973.17763.0-11.0.170
OsInfo[17].Key=portos
OsInfo[17].Value=0
OsInfo[18].Key=ram
OsInfo[18].Value=16255
OsInfo[19].Key=svolsz
OsInfo[19].Value=111
OsInfo[20].Key=wimbt
OsInfo[20].Value=0
OsInfo[21].Key=blddt
OsInfo[21].Value=180914
OsInfo[22].Key=bldtm
OsInfo[22].Value=1434
OsInfo[23].Key=bldbrch
OsInfo[23].Value=rs5_release
OsInfo[24].Key=bldchk
OsInfo[24].Value=0
OsInfo[25].Key=wpvermaj
OsInfo[25].Value=0
OsInfo[26].Key=wpvermin
OsInfo[26].Value=0
OsInfo[27].Key=wpbuildmaj
OsInfo[27].Value=0
OsInfo[28].Key=wpbuildmin
OsInfo[28].Value=0
OsInfo[29].Key=osver
OsInfo[29].Value=10.0.17763.973.amd64fre.rs5_release.180914-1434
OsInfo[30].Key=buildflightid
OsInfo[31].Key=edition
OsInfo[31].Value=ServerStandard
OsInfo[32].Key=ring
OsInfo[32].Value=Retail
OsInfo[33].Key=expid
OsInfo[34].Key=containerid
OsInfo[35].Key=containertype
OsInfo[36].Key=edu
OsInfo[36].Value=0
FriendlyEventName=Parou de funcionar
ConsentKey=APPCRASH
AppName=mysqld.exe
AppPath=C:\Program Files\MySQL\MySQL Server 8.0\bin\mysqld.exe
NsPartner=windows
NsGroup=windows8
ApplicationIdentity=D106662B0F9EE191B8E6A83DB65ADBEF
MetadataHash=-1462189115

How to repeat:
Create a table with a lot of data, try to truncate or anything else.
[2 Mar 2020 8:50] MySQL Verification Team
Thank you for the bug report. Please try version 8.0.19. Just with the description you provided isn't enough to repeat it, if you still get the same issue provide the create table statement and the size of the data.
[3 Apr 2020 1:00] Bugs System
No feedback was provided for this bug for over a month, so it is
being suspended automatically. If you are able to provide the
information that was originally requested, please do so and change
the status of the bug back to "Open".