mysql first_seen_mysqlmtop slow query 监控配置是报错信息

/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.

阅读(1441) | 评论(0) | 转发(0) |