Event Timeline
Comment Actions
root@zarcillo0:~# mysql -e "select * from heartbeat.heartbeat" +----------------------------+------------+----------------------+----------+-----------------------+---------------------+-------+------------+ | ts | server_id | file | position | relay_master_log_file | exec_master_log_pos | shard | datacenter | +----------------------------+------------+----------------------+----------+-----------------------+---------------------+-------+------------+ | 2020-07-24T12:49:08.000750 | 2886730256 | zarcillo0-bin.000002 | 14521601 | NULL | NULL | s1 | eqiad | +----------------------------+------------+----------------------+----------+-----------------------+---------------------+-------+------------+
Comment Actions
Notice: /Stage[main]/Mariadb::Heartbeat/Exec[pt-heartbeat]/returns: DBD::mysql::st execute failed: Data too long for column 'shard' at row 1 [for Statement "REPLACE INTO `heartbeat`.`heartbeat` (ts, server_id, file, position, relay_master_log_file, exec_master_log_pos, shard, datacenter) VALUES (?, '2886730256', ?, ?, ?, ?, ?, ?)" with ParamValues: 0='2020-07-24T13:09:40.061040', 1='zarcillo0-bin.000002', 2=15159120, 3=undef, 4=undef, 5='db_inventory', 6='eqiad'] at /usr/local/bin/pt-heartbeat-wikimedia line 5127. Error: '/usr/bin/perl /usr/local/bin/pt-heartbeat-wikimedia --defaults-file=/dev/null --user=root --host=localhost -D heartbeat --shard=db_inventory --datacenter=eqiad --update --replace --interval=1 --set-vars="binlog_format=ROW" -S /run/mysqld/mysqld.sock --daemonize --pid /var/run/pt-heartbeat.pid' returned 11 instead of one of [0] Error: /Stage[main]/Mariadb::Heartbeat/Exec[pt-heartbeat]/returns: change from 'notrun' to ['0'] failed: '/usr/bin/perl /usr/local/bin/pt-heartbeat-wikimedia --defaults-file=/dev/null --user=root --host=localhost -D heartbeat --shard=db_inventory --datacenter=eqiad --update --replace --interval=1 --set-vars="binlog_format=ROW" -S /run/mysqld/mysqld.sock --daemonize --pid /var/run/pt-heartbeat.pid' returned 11 instead of one of [0] Info: Stage[main]: Unscheduling all events on Stage[main]