Page MenuHomePhabricator
Paste P12036

(An Untitled Masterwork)
ActivePublic

Authored by Kormat on Fri, Jul 24, 12:39 PM.
root@zarcillo0:~# /usr/local/bin/pt-heartbeat-wikimedia -D heartbeat --create-table --check
DBD::mysql::db do failed: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right s
yntax to use near 'char(5) DEFAULT NULL -- mediawiki extension
)' at line 9 [for Statement " CREATE TABLE IF NOT EXISTS `heartbeat`.`heartbeat` (
ts varchar(26) NOT NULL,
server_id int unsigned NOT NULL PRIMARY KEY,
file varchar(255) DEFAULT NULL, -- SHOW MASTER STATUS
position bigint unsigned DEFAULT NULL, -- SHOW MASTER STATUS
relay_master_log_file varchar(255) DEFAULT NULL, -- SHOW SLAVE STATUS
exec_master_log_pos bigint unsigned DEFAULT NULL, -- SHOW SLAVE STATUS
shard varchar(10) DEFAULT 'unknown' -- mediawiki extension
datacenter char(5) DEFAULT NULL -- mediawiki extension
);"] at /usr/local/bin/pt-heartbeat-wikimedia line 4907.

Event Timeline

Kormat created this paste.Fri, Jul 24, 12:39 PM
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      |
+----------------------------+------------+----------------------+----------+-----------------------+---------------------+-------+------------+
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]