GET 24/7 LIVE HELP NOW

Announcement

Announcement Module
Collapse
No announcement yet.

pt-table-checksum error clarification

Page Title Module
Move Remove Collapse
X
Conversation Detail Module
Collapse
  • Filter
  • Time
  • Show
Clear All
new posts

  • pt-table-checksum error clarification

    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

  • #2
    Could you please send us the count output in the master and in all slaves?

    SELECT COUNT(*) FROM table1;

    Martin

    Comment

    Working...
    X