Chinaunix首页 | 论坛 | 博客
  • 博客访问: 104100
  • 博文数量: 87
  • 博客积分: 10
  • 博客等级: 民兵
  • 技术积分: 840
  • 用 户 组: 普通用户
  • 注册时间: 2012-07-18 21:12
文章分类

全部博文(87)

文章存档

2014年(86)

我的朋友

分类: Mysql/postgreSQL

2014-05-23 16:24:49

/usr/bin/pt-query-digest --user=mtop_user --password=password --port=3306 --review h=10.168.101.53,D=mysqlmtop,t=mysql_slow_query_review_2  --history h=10.168.101.53,D=mysqlmtop,t=mysql_slow_query_review_history_2   --no-report --limit=0% /data/mysql/101-56-slow.log


# A software update is available:
#   * Percona Toolkit 2.2.6 has a possible security issue (CVE-2014-2029) upgrade is recommended. The current version for Percona::Toolkit is 2.2.7.


/data/mysql/101-56-slow.log:  79% 00:07 remain
Pipeline process 5 (iteration) caused an error: DBD::mysql::st execute failed: Data too long for column 'sample' at row 1 [for Statement "      INSERT INTO `mysqlmtop`.`mysql_slow_query_review_2`
      (checksum, fingerprint, sample, first_seen, last_seen)
      VALUES(CONV(?, 16, 10), ?, ?, COALESCE(?, NOW()), COALESCE(?, NOW()))
      ON DUPLICATE KEY UPDATE
         first_seen = IF(
            first_seen IS NULL,
            COALESCE(?, NOW()),
            LEAST(first_seen, COALESCE(?, NOW()))),
         last_seen = IF(
            last_seen IS NULL,
            COALESCE(?, NOW()),
            GREATEST(last_seen, COALESCE(?, NOW())))
" with ParamValues: 0='A780096975BFD405', 1='insert into `gaia_user_friend_offer` values(?+)', 2='INSERT INTO `GAIA_USER_FRIEND_OFFER` VALUES (3,1,9),(5,3,9),(293,4,54),(4,5,9),(6,9,3),(320,9,54),(2,10,9),(7,11,3),(16,11,45),(18,11,47),(84,11,50),(53,11,52),(114,11,54),(319,11,57),(236,11,58),(165,11,59),(199,11,61),(155858,11,18672),(155861,11,18676),(156344,11,18727),(156378,11,18739),(156256,11,18741),(21,12,47),(47,12,52),(113,12,54),(233,12,58),(177,12,59),(221,12,61),(291,15,54),(8,17,4),(41,33,47),(65,33,52),(119,33,54),(24,34,47),(67,34,52),(300,34,54),(72,35,47),(302,35,54),(10,36,11),(33,36,47),(61,36,52),(128,36,54),(14,37,45),(13,37,46),(32,37,47),(64,37,52),(117,37,54),(29,38,47),(198,38,48),(82,38,50),(58,38,52),(116,38,54),(168,38,59),(30,39,47),(76,39,50),(49,39,52),(115,39,54),(375,39,57),(237,39,58),(179,39,59),(12,40,11),(34,40,47),(66,40,52),(28,41,47),(197,41,48),(81,41,50),(51,41,52),(112,41,54),(178,41,59),(200,41,61),(11,42,11),(15,42,46),(31,42,47),(56,42,52),(122,42,54),(219,42,59),(26,43,47),(45,43,52),(120,43,54),(374,43,57),(301,43,58),(187,43,59),...', 3='2014-04-24 10:22:21', 4='2014-04-24 10:22:21', 5='2014-04-24 10:22:21', 6='2014-04-24 10:22:21', 7='2014-04-24 10:22:21', 8='2014-04-24 10:22:21'] at /usr/bin/pt-query-digest line 9167.
Will retry pipeline process 4 (iteration) 2 more times.
Pipeline process 5 (iteration) caused an error: DBD::mysql::st execute failed: Data too long for column 'sample' at row 1 [for Statement "      INSERT INTO `mysqlmtop`.`mysql_slow_query_review_2`
      (checksum, fingerprint, sample, first_seen, last_seen)
      VALUES(CONV(?, 16, 10), ?, ?, COALESCE(?, NOW()), COALESCE(?, NOW()))
      ON DUPLICATE KEY UPDATE
         first_seen = IF(
            first_seen IS NULL,
            COALESCE(?, NOW()),
            LEAST(first_seen, COALESCE(?, NOW()))),
         last_seen = IF(
            last_seen IS NULL,
            COALESCE(?, NOW()),
            GREATEST(last_seen, COALESCE(?, NOW())))
" with ParamValues: 0='A780096975BFD405', 1='insert into `gaia_user_friend_offer` values(?+)', 2='INSERT INTO `GAIA_USER_FRIEND_OFFER` VALUES (3,1,9),(5,3,9),(293,4,54),(4,5,9),(6,9,3),(320,9,54),(2,10,9),(7,11,3),(16,11,45),(18,11,47),(84,11,50),(53,11,52),(114,11,54),(319,11,57),(236,11,58),(165,11,59),(199,11,61),(155858,11,18672),(155861,11,18676),(156344,11,18727),(156378,11,18739),(156256,11,18741),(21,12,47),(47,12,52),(113,12,54),(233,12,58),(177,12,59),(221,12,61),(291,15,54),(8,17,4),(41,33,47),(65,33,52),(119,33,54),(24,34,47),(67,34,52),(300,34,54),(72,35,47),(302,35,54),(10,36,11),(33,36,47),(61,36,52),(128,36,54),(14,37,45),(13,37,46),(32,37,47),(64,37,52),(117,37,54),(29,38,47),(198,38,48),(82,38,50),(58,38,52),(116,38,54),(168,38,59),(30,39,47),(76,39,50),(49,39,52),(115,39,54),(375,39,57),(237,39,58),(179,39,59),(12,40,11),(34,40,47),(66,40,52),(28,41,47),(197,41,48),(81,41,50),(51,41,52),(112,41,54),(178,41,59),(200,41,61),(11,42,11),(15,42,46),(31,42,47),(56,42,52),(122,42,54),(219,42,59),(26,43,47),(45,43,52),(120,43,54),(374,43,57),(301,43,58),(187,43,59),...', 3='2014-04-24 10:22:21', 4='2014-04-24 10:22:21', 5='2014-04-24 10:22:21', 6='2014-04-24 10:22:21', 7='2014-04-24 10:22:21', 8='2014-04-24 10:22:21'] at /usr/bin/pt-query-digest line 9167.
Will retry pipeline process 4 (iteration) 1 more time.
The pipeline caused an error: Pipeline process 5 (iteration) caused an error: DBD::mysql::st execute failed: Data too long for column 'sample' at row 1 [for Statement "      INSERT INTO `mysqlmtop`.`mysql_slow_query_review_2`
      (checksum, fingerprint, sample, first_seen, last_seen)
      VALUES(CONV(?, 16, 10), ?, ?, COALESCE(?, NOW()), COALESCE(?, NOW()))
      ON DUPLICATE KEY UPDATE
         first_seen = IF(
            first_seen IS NULL,
            COALESCE(?, NOW()),
            LEAST(first_seen, COALESCE(?, NOW()))),
         last_seen = IF(
            last_seen IS NULL,
            COALESCE(?, NOW()),
            GREATEST(last_seen, COALESCE(?, NOW())))
" with ParamValues: 0='A780096975BFD405', 1='insert into `gaia_user_friend_offer` values(?+)', 2='INSERT INTO `GAIA_USER_FRIEND_OFFER` VALUES (3,1,9),(5,3,9),(293,4,54),(4,5,9),(6,9,3),(320,9,54),(2,10,9),(7,11,3),(16,11,45),(18,11,47),(84,11,50),(53,11,52),(114,11,54),(319,11,57),(236,11,58),(165,11,59),(199,11,61),(155858,11,18672),(155861,11,18676),(156344,11,18727),(156378,11,18739),(156256,11,18741),(21,12,47),(47,12,52),(113,12,54),(233,12,58),(177,12,59),(221,12,61),(291,15,54),(8,17,4),(41,33,47),(65,33,52),(119,33,54),(24,34,47),(67,34,52),(300,34,54),(72,35,47),(302,35,54),(10,36,11),(33,36,47),(61,36,52),(128,36,54),(14,37,45),(13,37,46),(32,37,47),(64,37,52),(117,37,54),(29,38,47),(198,38,48),(82,38,50),(58,38,52),(116,38,54),(168,38,59),(30,39,47),(76,39,50),(49,39,52),(115,39,54),(375,39,57),(237,39,58),(179,39,59),(12,40,11),(34,40,47),(66,40,52),(28,41,47),(197,41,48),(81,41,50),(51,41,52),(112,41,54),(178,41,59),(200,41,61),(11,42,11),(15,42,46),(31,42,47),(56,42,52),(122,42,54),(219,42,59),(26,43,47),(45,43,52),(120,43,54),(374,43,57),(301,43,58),(187,43,59),...', 3='2014-04-24 10:22:21', 4='2014-04-24 10:22:21', 5='2014-04-24 10:22:21', 6='2014-04-24 10:22:21', 7='2014-04-24 10:22:21', 8='2014-04-24 10:22:21'] at /usr/bin/pt-query-digest line 9167.
Terminating pipeline because process 4 (iteration) caused too many errors.
阅读(1220) | 评论(0) | 转发(0) |
给主人留下些什么吧!~~