• MySQL事件的先后


    今天闲聊之时 提及MySQL事件的执行,发现一些自己之前没有注意的细节

    如果在执行事件过程中,如果insert的存储过程发生意外 会如何

    USE iot2;
    CREATE TABLE aaaa (timeline TIMESTAMP);
    CREATE TABLE aaab (timeline TIMESTAMP);
    
    
    

     

    CREATE EVENT e_test_insert ON SCHEDULE EVERY 1 SECOND DO call ck1() ;

    存储过程为

    DELIMITER $$ 
    USE `iot2`$$
    DROP PROCEDURE IF EXISTS `ck1`$$
    CREATE PROCEDURE `ck1`()
     BEGIN
       INSERT INTO iot2.aaaa VALUES (CURRENT_TIMESTAMP);
       INSERT INTO iot2.aaab VALUES (CURRENT_TIMESTAMP); 
     END $$
    DELIMITER ;

    此时 删除aaaa 发现事务不在执行 错误日志中的提示为

    2015-12-27 15:32:04 3451 [ERROR] Event Scheduler: [root@localhost][iot2.e_test_insert] Table 'iot2.aaaa' doesn't exist
    2015-12-27 15:32:04 3451 [Note] Event Scheduler: [root@localhost].[iot2.e_test_insert] event execution failed.
    2015-12-27 15:32:05 3451 [ERROR] Event Scheduler: [root@localhost][iot2.e_test_insert] Table 'iot2.aaaa' doesn't exist
    2015-12-27 15:32:05 3451 [Note] Event Scheduler: [root@localhost].[iot2.e_test_insert] event execution failed.
    2015-12-27 15:32:06 3451 [ERROR] Event Scheduler: [root@localhost][iot2.e_test_insert] Table 'iot2.aaaa' doesn't exist
    2015-12-27 15:32:06 3451 [Note] Event Scheduler: [root@localhost].[iot2.e_test_insert] event execution failed.
    2015-12-27 15:32:07 3451 [ERROR] Event Scheduler: [root@localhost][iot2.e_test_insert] Table 'iot2.aaaa' doesn't exist
    2015-12-27 15:32:07 3451 [Note] Event Scheduler: [root@localhost].[iot2.e_test_insert] event execution failed.
    2015-12-27 15:32:08 3451 [ERROR] Event Scheduler: [root@localhost][iot2.e_test_insert] Table 'iot2.aaaa' doesn't exist
    2015-12-27 15:32:08 3451 [Note] Event Scheduler: [root@localhost].[iot2.e_test_insert] event execution failed.
    2015-12-27 15:32:09 3451 [ERROR] Event Scheduler: [root@localhost][iot2.e_test_insert] Table 'iot2.aaaa' doesn't exist
    2015-12-27 15:32:09 3451 [Note] Event Scheduler: [root@localhost].[iot2.e_test_insert] event execution failed.

    可以发现 事件失败。。。

  • 相关阅读:
    找出有序数组中绝对值最小的数
    warning:deprecated conversion from string constant to 'char *' 解决方案
    Wordnet 与 Hownet 比较
    心灵鸡汤
    冒泡排序
    .NET加密配置文件connectionStrings节点
    C#基础知识之方法重载总结
    [C#]工具类—FTP上传下载
    C#基础知识-对象初始化顺序
    自定义Dictionary支持线程安全
  • 原文地址:https://www.cnblogs.com/olinux/p/5133502.html
Copyright © 2020-2023  润新知