Chinaunix首页 | 论坛 | 博客
  • 博客访问: 240014
  • 博文数量: 29
  • 博客积分: 634
  • 博客等级: 上士
  • 技术积分: 432
  • 用 户 组: 普通用户
  • 注册时间: 2010-10-09 22:24
文章分类

全部博文(29)

文章存档

2012年(8)

2011年(21)

分类: Mysql/postgreSQL

2011-03-24 18:04:03


mysql> show slave status\G;
*************************** 1. row ***************************
               Slave_IO_State: Waiting for master to send event
                  Master_Host: 192.168.1.10                                                              Master_User: backup                                                           Master_Port: 3306
                Connect_Retry: 60
              Master_Log_File: mysql-bin.000011
          Read_Master_Log_Pos: 212642261
               Relay_Log_File: localhost-relay-bin.000006
                Relay_Log_Pos: 341503
        Relay_Master_Log_File: mysql-bin.000011
             Slave_IO_Running: Yes
            Slave_SQL_Running: No
              Replicate_Do_DB:
          Replicate_Ignore_DB:
           Replicate_Do_Table:
       Replicate_Ignore_Table:
      Replicate_Wild_Do_Table:
  Replicate_Wild_Ignore_Table:
                   Last_Errno: 1064
                   Last_Error: Error '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 '\";s:6:\"娆绔\";s:10:\"login_fail\";i:0;}' WHERE sesskey = '548ebf63f5539f9e3' at line 1' on query. Default database: 'purcotton'. Query: 'INSERT INTO `purcotton`.`ecs_stats` ( iprer\";s:6:\"娆绔\";s:10:\"login_fail\";i:0;}' WHERE sesskey = '548ebf63f5539f9e3d81ffed29708d' LIMIT 1
'
                 Skip_Counter: 0
          Exec_Master_Log_Pos: 186790345
              Relay_Log_Space: 45511153
              Until_Condition: None
               Until_Log_File:
                Until_Log_Pos: 0
           Master_SSL_Allowed: No
           Master_SSL_CA_File:
           Master_SSL_CA_Path:
              Master_SSL_Cert:
            Master_SSL_Cipher:
               Master_SSL_Key:
        Seconds_Behind_Master: NULL
Master_SSL_Verify_Server_Cert: No
                Last_IO_Errno: 0
                Last_IO_Error:
               Last_SQL_Errno: 1064
               Last_SQL_Error: Error '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 '\";s:6:\"娆绔\";s:10:\"login_fail\";i:0;}' WHERE sesskey = '548ebf63f5539f9e3' at line 1' on query. Default database: 'purcotton'. Query: 'INSERT INTO `purcotton`.`ecs_stats` ( iprer\";s:6:\"娆绔\";s:10:\"login_fail\";i:0;}' WHERE sesskey = '548ebf63f5539f4e3d81ffed29708d' LIMIT 1
'
1 row in set (0.00 sec)
ERROR:
No query specified
阅读(1618) | 评论(0) | 转发(1) |
给主人留下些什么吧!~~