error code 1146 > Error 'Table 'tts.t2' doesn't exist' on query. Default database: 'test'. Query: 'i
来源:互联网 发布:jsp点击按钮不执行js 编辑:程序博客网 时间:2024/04/29 12:06
出现这个错误的原因是因为使用了主机使用了同步库use database 却在非同步库插入了一条数据 *.*
> Error 'Table 'tts.t2' doesn't exist' on query. Default database: 'test'. Query: 'insert into tts.t2 values (null)'
1146
解决办法
1 stop slave;
2 set global sql_slave_skip_counter=1;
这样并不会造成数据丢失
3 start slave;
0 0
- error code 1146 > Error 'Table 'tts.t2' doesn't exist' on query. Default database: 'test'. Query: 'i
- Error 'Can't drop database 'just'; database doesn't exist' on query.
- Database ERROR:Table 'snort.acid_ag' doesn't exist
- Hibernate ERROR: Table doesn't exist
- ERROR 1146 (42S02): Table 'mysql.slow_log' doesn't exist
- ERROR 1146 (42S02): Table 'mysql.slow_log' doesn't exist
- ERROR 1146 (42S02): Table 'mysql.slow_log' doesn't exist
- ERROR 1146 (42S02): Table 'voucherdb.fvr_vouchersummary' doesn't exist
- ERROR 1146 (42S02): Table 'performance_schema.session_variables' doesn't exist
- ERROR 1146 (42S02): Table 'eip_fileservice.t_document_file' doesn't exist
- ERROR 1146 (42S02): Table 'eip_fileservice.t_document_file' doesn't exist
- uchome 消息 Error:Table 'ucenter.uc_pms' doesn't exist
- MySQL [ERROR] Table 'mysql.user' doesn't exist
- mysql error:Table 'performance_schema.session_variables' doesn't exist
- 错误代码: 1146 Table 'test.triggers' doesn't exist
- Mysql最后一步安装错误,Error Nr.1146 Table 'mysql.servers' doesn't exist
- mysqldump: Got error: 1146: Table 'performance_schema.cond_instances' doesn't exist when using LOCK
- mysqldump: Got error: 1146: Table 'performance_schema.cond_instances' doesn't exist when using LOCK
- java.lang.NoClassDefFoundError
- unity烘焙后阴影怎么没了
- redis性能调优总结
- 【BeanUtils】自己写的一个BeanUtils-代码方法详解
- View的工作原理
- error code 1146 > Error 'Table 'tts.t2' doesn't exist' on query. Default database: 'test'. Query: 'i
- 【C#MVC】 使用HttpWebRequest访问外部API,并返回json信息 (Access_Key)
- 自定义view 跳转到其他的ViewController
- BeanPropertyRowMapper
- ORACLE 权限,with admin option及小操作
- zookeeper sasl认证问题
- 接口压测之——put方法3
- [002]启动开发者模式
- thread_create 和 thread_resume