| User, date |
Message |
Written by kalvaro
1 year ago
Category: Running SQL scripts
440 posts
since Thu, 29 Nov 07
|
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. |