rpl_failed_optimize.result
上传用户:romrleung
上传日期:2022-05-23
资源大小:18897k
文件大小:1k
源码类别:
MySQL数据库
开发平台:
Visual C++
- stop slave;
- drop table if exists t1,t2,t3,t4,t5,t6,t7,t8,t9;
- reset master;
- reset slave;
- drop table if exists t1,t2,t3,t4,t5,t6,t7,t8,t9;
- start slave;
- CREATE TABLE t1 ( a int ) ENGINE=InnoDB;
- BEGIN;
- INSERT INTO t1 VALUES (1);
- OPTIMIZE TABLE t1;
- Table Op Msg_type Msg_text
- test.t1 optimize error Lock wait timeout exceeded; try restarting transaction
- test.t1 optimize status Operation failed
- OPTIMIZE TABLE non_existing;
- Table Op Msg_type Msg_text
- test.non_existing optimize error Table 'test.non_existing' doesn't exist