View Issue Details

IDProjectCategoryView StatusLast Update
0005930VALENTINA SERVEREvent Shcedulerpublic2012-08-29 11:58
Reporteryuriy_velichkoAssigned ToIvan Smahin 
PrioritynormalSeverityminorReproducibilityhave not tried
Status resolvedResolutionfixed 
Product Version 
Target VersionFixed in Version5.0 
Summary0005930: Server stops to work correctly after adding or dropping event.
DescriptionTo reproduce - just try to add new event using SQL. For example:

USE master;
CREATE EVENT IF NOT EXISTS "newEvt" FOR DATABASE "vtest" ON SCHEDULE AT TIMESTAMP '01/04/2100 01:01:01' + INTERVAL 1 DAY ON COMPLETION PRESERVE ENABLED COMMENT 'test' DO SELECT 0;

As result server returns message:

Kernel error: 0x60508. Stream EOF reached.

If try to execute some query, for example:

SHOW EVENTS OF vtest;

Server will return message:

Kernel error: 0x6050b. "UNKNOWN" - write error.

If restart the server and try again:

SHOW EVENTS OF vtest;

Server returns a list, that will contain the event, that was added on previous step.
Additional Informationserver build - 5.0 b39
TagsNo tags attached.

Activities

There are no notes attached to this issue.

Issue History

Date Modified Username Field Change
2012-08-29 10:50 yuriy_velichko New Issue
2012-08-29 11:58 Ivan Smahin Status new => resolved
2012-08-29 11:58 Ivan Smahin Fixed in Version => 5.0
2012-08-29 11:58 Ivan Smahin Resolution open => fixed
2012-08-29 11:58 Ivan Smahin Assigned To => Ivan Smahin