I run pt-table-checksum with all default options, and I get the following 2 errors in the output:
09-11T05:01:52 Error checksumming table dbname.table1: Cannot serialize multiple values with undef/NULL at /usr/bin/pt-table-checksum line 2085.
09-11T05:01:52 Skipping table dbname.table2 because on the master it would be checksummed in one chunk but on these replicas it has too many rows:
94816 rows on server83.net.net
112485 rows on server84.net.net
90855 rows on server86.net.net
The current chunk size limit is 73338 rows (chunk size=36669 * chunk size limit=2.0).
pt-table-checksum goes on to list table1 in the verbose output, but it does not list table2. All other tables are checksummed ok, and pt-table-checksum returns with code 0 (OK)
TS ERRORS DIFFS ROWS CHUNKS SKIPPED TIME TABLE
09-11T05:01:30 0 0 11187 4 0 4.912 dbname.othertable
…other tables
09-11T05:01:52 1 0 0 1 0 0.040 dbname.table1
…more tables
Can anyone clarify what either error is about? I have included below the create table definitions for each table, if that helps:
CREATE TABLE table1 ( user_id int(11) NOT NULL, password varchar(1048) NOT NULL, password_hash varchar(256) NOT NULL, email varchar(100) NOT NULL, first_name varchar(50) DEFAULT NULL, last_name varchar(50) DEFAULT NULL, city varchar(50) DEFAULT NULL, state int(11) DEFAULT NULL, zipcode varchar(20) DEFAULT NULL, country varchar(50) DEFAULT NULL, cable_provider varchar(100) DEFAULT NULL, timezone int(11) DEFAULT NULL, gender varchar(1) DEFAULT NULL, creation_timestamp timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, last_login_timestamp timestamp NOT NULL DEFAULT ‘0000-00-00 00:00:00’, last_update_timestamp timestamp NOT NULL DEFAULT ‘0000-00-00 00:00:00’, stats_update_timestamp timestamp NOT NULL DEFAULT ‘0000-00-00 00:00:00’, acct_status int(11) NOT NULL DEFAULT ‘0’, disabled varchar(1) NOT NULL DEFAULT ‘N’, deleted varchar(1) DEFAULT ‘N’, online_now varchar(1) DEFAULT ‘N’, password_must_change varchar(1) DEFAULT ‘N’, login_count int(1) NOT NULL DEFAULT ‘0’, birth_month varchar(50) DEFAULT NULL, birth_day int(11) DEFAULT NULL, profile_complete int(11) NOT NULL DEFAULT ‘0’, user_type varchar(20) NOT NULL, persona_id int(11) DEFAULT NULL, location varchar(255) DEFAULT NULL, notify_new_upload int(11) DEFAULT NULL, notify_receive_comments int(11) DEFAULT NULL, UNIQUE KEY Unique_UserId_PersonaId (user_id,persona_id), KEY IDX_SU_FIRSTNAME (first_name), KEY IDX_SU_LASTNAME (last_name)) ENGINE=InnoDB DEFAULT CHARSET=latin1CREATE TABLE table2 ( user_persona_id int(11) NOT NULL, user_id int(11) NOT NULL, persona_id int(11) NOT NULL, display_name varchar(50) NOT NULL, about_me_text blob, quote_text varchar(1000) DEFAULT NULL, my_photo varchar(255) DEFAULT NULL, my_clip varchar(255) DEFAULT NULL, clip_thumb_file varchar(255) DEFAULT NULL, my_interests varchar(2000) DEFAULT NULL, creation_timestamp timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, my_favorites blob, my_banners blob, publish_events int(11) DEFAULT ‘1’, show_recent_activity int(11) DEFAULT ‘1’, innapr_counter int(11) DEFAULT NULL, profile_flagged int(11) DEFAULT NULL, status int(11) DEFAULT NULL, last_update_timestamp timestamp NOT NULL DEFAULT ‘0000-00-00 00:00:00’, PRIMARY KEY (user_persona_id), UNIQUE KEY TUC_UP_USERID_PERSONNAID (user_id,persona_id), KEY IDX_SUP_USERID (user_id)) ENGINE=InnoDB DEFAULT CHARSET=latin1