distal-attribute
distal-attribute
distal-attribute
distal-attribute

Crash running a large dump

kalvaro posted 3 years ago in Running SQL scripts
I got this:

date/time : 2012-03-21, 12:53:02, 614ms
computer name : SOFT14
operating system : Windows XP Service Pack 3 build 2600
system language : Spanish
system up time : 5 days
program up time : 54 seconds
processors : 2x Intel(R) Pentium(R) 4 CPU 3.00GHz
physical memory : 285/991 MB (free/total)
free disk space : (C:) 8,89 GB (E:) 5,96 GB
display mode : 1280x1024, 32 bit
process id : $a60
allocated memory : 63,46 MB
executable : heidisql.exe
exec. date/time : 2012-03-21 12:51
version : 7.0.0.4098
compiled with : Delphi XE
madExcept version : 3.0m beta 1
callstack crc : $18ba9f1b, $f2b56cad, $f2b56cad
exception number : 1
exception class : EDatabaseError
exception message : SQL Error (1153): Got a packet bigger than 'max_allowed_packet' bytes.

main thread ($1038):
00710be2 heidisql.exe dbconnection 1267 +26 TMySQLConnection.Query
00799097 heidisql.exe runsqlfile 126 +69 TRunSQLFileForm.FormActivate
0056f4f7 heidisql.exe Forms TCustomForm.Activate
005705b4 heidisql.exe Forms TCustomForm.CMActivate
004e8d18 heidisql.exe Controls TControl.WndProc
004ed5dc heidisql.exe Controls TWinControl.WndProc
0056cbf8 heidisql.exe Forms TCustomForm.WndProc
004e893c heidisql.exe Controls TControl.Perform
004ecc7c heidisql.exe Controls TWinControl.MainWndProc
004ab504 heidisql.exe Classes StdWndProc
7c91e470 ntdll.dll KiUserCallbackDispatcher
7e3a92de USER32.dll SendMessageW
00571554 heidisql.exe Forms TCustomForm.ShowModal
007d377c heidisql.exe Main 3021 +65 TMainForm.RunQueryFiles
007d3290 heidisql.exe Main 2927 +9 TMainForm.actLoadSQLExecute
004aae5f heidisql.exe Classes TBasicAction.Execute
004d7505 heidisql.exe ActnList TContainedAction.Execute
004d82c0 heidisql.exe ActnList TCustomAction.Execute
004aad23 heidisql.exe Classes TBasicActionLink.Execute
00508d68 heidisql.exe Menus TMenuItem.Click
0050a6f3 heidisql.exe Menus DoClick
0050a7df heidisql.exe Menus TMenu.IsShortCut
004ef974 heidisql.exe Controls TWinControl.IsMenuKey
004ef9e9 heidisql.exe Controls TWinControl.CNKeyDown
004e8d18 heidisql.exe Controls TControl.WndProc
004ed5dc heidisql.exe Controls TWinControl.WndProc
005e8b98 heidisql.exe SynEdit 6197 +22 TCustomSynEdit.WndProc
004ecc7c heidisql.exe Controls TWinControl.MainWndProc
004ab504 heidisql.exe Classes StdWndProc
7c91e470 ntdll.dll KiUserCallbackDispatcher
0057598a heidisql.exe Forms TApplication.IsHintMsg



The explanation is quite straightforward: the dump contains very long extended inserts and max_allowed_packet gets exceeded. I suppose there's nothing HeidiSQL can do about it because the user does not even have the SUPER privilege required to increase max_allowed_packet. Whatever, a friendly message is better than a crash :)

Please login to leave a reply, or register at first.