Crash running a large dump

kalvaro's profile image kalvaro posted 13 years ago in Running SQL scripts Permalink
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.