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

Cannot successfully create events

User, date Message
Written by mcf
3 years ago
Category: Running SQL scripts
8 posts since Thu, 15 Dec 11
Steps to reproduce:
1) Right click database
2) Create new > event
3) Enter query in Execution Body
4) Set schedule (run once) in Timing Tab
5) Click Save button

The log shows the following message:

/* Table node "event_name_goes_here" not found in tree. */



I cannot find record of the event anywhere, either in the HeidiSQL hierarchy or using SHOW EVENTS.

Thoughts? Solutions? Please help!
Written by ansgar
3 years ago
4979 posts since Fri, 07 Apr 06
Didn't you receive some error message?
Written by mcf
3 years ago
8 posts since Thu, 15 Dec 11
No error message or dialog box is displayed after I click the Save button. Here is what the log shows:


CREATE EVENT `event_name` ON SCHEDULE AT '2011-12-15 11:01:00' ON COMPLETION NOT PRESERVE ENABLE COMMENT '' DO BEGIN CALL sp1(); CALL sp2(); END;
SHOW TABLE STATUS FROM `db_name`;
SHOW FUNCTION STATUS WHERE `Db`='db_name';
SHOW PROCEDURE STATUS WHERE `Db`='db_name';
SHOW TRIGGERS FROM `db_name`;
SHOW EVENTS FROM `db_name`;
/* Table node "event_name" not found in tree. */



Copy and pasting the create code returns an error dialog box though: SQL Error (1064): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near " at line 8
. This error is not correct, the syntax is by-the-book -- no missing semi-colons, etc.
Written by ansgar
3 years ago
4979 posts since Fri, 07 Apr 06
Hehe, you were kidding yourself: The event was created, but then auto-deleted, due to the "ON COMPLETION NOT PRESERVE" clause. That means the event is deleted by the server automatically after it has finished its (last) execution.
Written by mcf
3 years ago
8 posts since Thu, 15 Dec 11
I am pretty sure the event never ran though. It takes ~40 minutes to run all the queries. I'll try it without that clause though and report back.
Written by mcf
3 years ago
8 posts since Thu, 15 Dec 11
Okay, halfway there... when I unchecked the box it creates the event but it does not run. When I query SHOW EVENTS, it returns a row for the event but status = DISABLED. In the create event window I unchecked "drop event after expiration" but made just the "enabled" radio button was checked under State. What am I missing?
Written by mcf
3 years ago
8 posts since Thu, 15 Dec 11
This may be relevant - I am running this all on a slave server. Some of the MySQL forums mention this issue.
Written by mcf
3 years ago
8 posts since Thu, 15 Dec 11
Anse - any thoughts?
Written by ansgar
3 years ago
4979 posts since Fri, 07 Apr 06
Oh, I cannot reproduce that here. I create an event with
- an unchecked "Drop..." checkbox
- state=enabled
and the event shows up quickly after having clicked "save".

There's a good chance that there is some side effect with your slave server setup.

Which HeidiSQL revision?
Written by mcf
3 years ago
8 posts since Thu, 15 Dec 11
Version 6.0.0.3603
Written by ansgar
3 years ago
4979 posts since Fri, 07 Apr 06
Well this is the 6.0 release. You should upgrade to the latest build. I can't recall some major change in the event editor but I may be missing something within the 400 commits since r3603.
Written by mcf
3 years ago
8 posts since Thu, 15 Dec 11
Updated to the latest release and now receive an error when connecting. Bug report:


date/time : 2011-12-20, 13:38:48, 551ms
computer name : MCF-PC
user name : MCF
registered owner : MCF / Microsoft
operating system : Windows 7 x64 Service Pack 1 build 7601
system language : English
system up time : 9 days 22 hours
program up time : 18 seconds
processors : 2x Intel(R) Core(TM)2 Duo CPU T6600 @ 2.20GHz
physical memory : 890/4061 MB (free/total)
free disk space : (C:) 18.45 GB
display mode : 1920x1080, 32 bit
process id : $2f8c
allocated memory : 53.14 MB
executable : heidisql.exe
exec. date/time : 2011-12-20 13:30
version : 6.0.0.3990
compiled with : Delphi XE
madExcept version : 3.0m beta 1
callstack crc : $db82bfa4, $f5c5e38d, $f5c5e38d
exception number : 1
exception class : EStringListError
exception message : List index out of bounds (2).

main thread ($2a1c):
004a0b30 heidisql.exe Classes TStringList.Get
0072edc3 heidisql.exe dbconnection 1794 +13 TDBConnection.GetAllDatabases
0072ee38 heidisql.exe dbconnection 1805 +1 TMySQLConnection.GetAllDatabases
007cfb7a heidisql.exe Main 2953 +43 TMainForm.InitConnection
0077029f heidisql.exe connections 251 +3 Tconnform.btnOpenClick
004e9227 heidisql.exe Controls TControl.Click
0051fe16 heidisql.exe StdCtrls TCustomButton.Click
00520904 heidisql.exe StdCtrls TCustomButton.CNCommand
004e8cbc heidisql.exe Controls TControl.WndProc
004ed580 heidisql.exe Controls TWinControl.WndProc
0051fae0 heidisql.exe StdCtrls TButtonControl.WndProc
004e88e0 heidisql.exe Controls TControl.Perform
004ed6d3 heidisql.exe Controls DoControlMsg
004ee12f heidisql.exe Controls TWinControl.WMCommand
0056fc98 heidisql.exe Forms TCustomForm.WMCommand
004e8cbc heidisql.exe Controls TControl.WndProc
004ed580 heidisql.exe Controls TWinControl.WndProc
0056cb9c heidisql.exe Forms TCustomForm.WndProc
004ecc20 heidisql.exe Controls TWinControl.MainWndProc
004ab4d8 heidisql.exe Classes StdWndProc
76890d48 USER32.dll CallWindowProcW
00698cfc heidisql.exe helpers 1143 +1 CallOld
00698e44 heidisql.exe helpers 1190 +44 SizeGripWndProc
76890d48 USER32.dll CallWindowProcW
004ed680 heidisql.exe Controls TWinControl.DefaultHandler
004e9678 heidisql.exe Controls TControl.WMLButtonUp
004e8cbc heidisql.exe Controls TControl.WndProc
004ed580 heidisql.exe Controls TWinControl.WndProc
0051fae0 heidisql.exe StdCtrls TButtonControl.WndProc
004ecc20 heidisql.exe Controls TWinControl.MainWndProc
004ab4d8 heidisql.exe Classes StdWndProc
76887885 USER32.dll DispatchMessageW
00575b6b heidisql.exe Forms TApplication.ProcessMessage
00575bae heidisql.exe Forms TApplication.HandleMessage
0057150d heidisql.exe Forms TCustomForm.ShowModal
007cad8c heidisql.exe Main 1746 +109 TMainForm.Startup
007f88b7 heidisql.exe heidisql 66 +15 initialization
75513398 kernel32.dll BaseThreadInitThunk

Written by ansgar
3 years ago
4979 posts since Fri, 07 Apr 06
Should be fixed in r3991 - please update again.
 

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