Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-13577

slave_parallel_mode=optimistic should not report the mode's specific temporary errors

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed (View Workflow)
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: 10.1, 10.1.22, 10.2, 10.1.25
    • Fix Version/s: 10.1.34, 10.2.16, 10.3.8
    • Component/s: Replication
    • Labels:
      None
    • Environment:
      centos7 x86_64
    • Sprint:
      10.2.14, 10.3.6-1

      Description

      I have server mariadb-10.1.22 with slave_parallel_mode=optimistic and see (bogus?) errors in log:

      2017-08-16  9:34:05 139902864206592 [ERROR] mysqld: Can't find record in 'hr_user_request_log'
      2017-08-16  9:36:03 139902865722112 [ERROR] mysqld: Can't find record in 'sms_log'
      2017-08-16  9:43:11 139902864812800 [ERROR] mysqld: Can't find record in 'sms_log'
      2017-08-17  3:14:05 139902864812800 [ERROR] mysqld: Can't find record in 'sms_log'
      2017-08-17  4:01:17 139902864206592 [ERROR] mysqld: Can't find record in 'sms_log'
      2017-08-17 10:02:02 139902865419008 [ERROR] mysqld: Can't find record in 'sms_log'
      2017-08-17 10:14:06 139902864206592 [ERROR] mysqld: Can't find record in 'reg_user_tracked_stat'
      2017-08-17 11:06:03 139902865419008 [ERROR] mysqld: Can't find record in 'cv_journal'
      

      Replication is not crash and still works.

      CREATE TABLE `sms_log` (
        `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
        `sms_type` enum('','admin_login','admin_vpn','resume_buy','after_registration_reg_user','after_registration_hr','hr_welcome_after_registration','hr_start_after_registration','password_recovery','phone_confirmation','friends_resume','friends_resume_app','invite_reg_user','response_to_a_demo_vacancy_no_read','verification_code','my_resume','link_to_app','hr_basic_500_after_registration','small_town_after_registration','small_region_after_registration','hr_promotional') DEFAULT NULL,
        `receiver_type` enum('hr','reg_user','guest','admin') NOT NULL DEFAULT 'guest',
        `sms_text` mediumtext NOT NULL,
        `date_create` datetime NOT NULL,
        `date_sent` datetime NOT NULL,
        `sms_link_clicked` tinyint(3) NOT NULL DEFAULT '0',
        `sms_source` enum('desktop','admin','api','mobile_app_reg_user','mobile_app_hr','mobile_site_reg_user','mobile_site_hr','cron') DEFAULT NULL,
        `id_town` smallint(5) unsigned NOT NULL DEFAULT '0',
        `mobile_operator` enum('mts','beeline','megafon','tele2','other') NOT NULL DEFAULT 'other',
        `phone` varchar(20) NOT NULL DEFAULT '',
        `id_receiver` int(10) unsigned NOT NULL DEFAULT '0',
        `sms_gate` enum('superjobvip','superjobnew','devinotele') NOT NULL DEFAULT 'superjobnew',
        `sender_type` enum('hr','reg_user','guest','admin') DEFAULT NULL,
        `id_sender` int(10) DEFAULT NULL,
        `id_client` int(10) DEFAULT NULL,
        `last_error` varchar(255) NOT NULL DEFAULT '',
        PRIMARY KEY (`id`),
        KEY `date_create` (`date_create`),
        KEY `date_sent` (`date_sent`),
        KEY `mobile_operator` (`mobile_operator`),
        KEY `id_receiver` (`id_receiver`),
        KEY `id_sender` (`sender_type`,`id_client`,`id_sender`)
      ) ENGINE=InnoDB AUTO_INCREMENT=13685411 DEFAULT CHARSET=utf8
      

      binlog:

      # at 460866962
      #170817  3:14:05 server id 86  end_log_pos 460867000    GTID 0-86-586027225 trans
      /*!100001 SET @@session.gtid_seq_no=586027225*//*!*/;
      BEGIN
      /*!*/;
      # at 460867000
      # at 460867086
      #170817  3:14:05 server id 86  end_log_pos 460867206    Write_rows: table id 25 flags: STMT_END_F
      ### INSERT INTO `site_stat`.`sms_log`
      ### SET
      ###   @1=13676743
      ###   @2=10
      ###   @3=3
      ###   @4='---cleared---'
      ###   @5=2017-08-17 03:14:05
      ###   @6=0000-00-00 00:00:00
      ###   @7=0
      ###   @8=1
      ###   @9=0
      ###   @10=4
      ###   @11='79595959595'
      ###   @12=0
      ###   @13=3
      ###   @14=3
      ###   @15=NULL
      ###   @16=NULL
      ###   @17=''
      # at 460867206
      #170817  3:14:05 server id 86  end_log_pos 460867233    Xid = 678520262
      COMMIT/*!*/;
      # at 460867233
      #170817  3:14:05 server id 86  end_log_pos 460867273    GTID 0-86-586027226 cid=678520266 trans
      /*!100001 SET @@session.gtid_seq_no=586027226*//*!*/;
      BEGIN
      /*!*/;
      # at 460867273
      # at 460867359
      #170817  3:14:05 server id 86  end_log_pos 460867571    Update_rows: table id 25 flags: STMT_END_F
      ### UPDATE `site_stat`.`sms_log`
      ### WHERE
      ###   @1=13676743
      ###   @2=10
      ###   @3=3
      ###   @4='---cleared---'
      ###   @5=2017-08-17 03:14:05
      ###   @6=0000-00-00 00:00:00
      ###   @7=0
      ###   @8=1
      ###   @9=0
      ###   @10=4
      ###   @11='79595959595'
      ###   @12=0
      ###   @13=3
      ###   @14=3
      ###   @15=NULL
      ###   @16=NULL
      ###   @17=''
      ### SET
      ###   @1=13676743
      ###   @2=10
      ###   @3=3
      ###   @4='---cleared---'
      ###   @5=2017-08-17 03:14:05
      ###   @6=2017-08-17 03:14:05
      ###   @7=0
      ###   @8=1
      ###   @9=0
      ###   @10=4
      ###   @11='79595959595'
      ###   @12=0
      ###   @13=3
      ###   @14=3
      ###   @15=NULL
      ###   @16=NULL
      ###   @17=''
      # at 460867571
      #170817  3:14:05 server id 86  end_log_pos 460867598    Xid = 678520266
      COMMIT/*!*/;
      

      MariaDB [(none)]> show variables like 'slave%';
      +-------------------------------+------------+
      | Variable_name                 | Value      |
      +-------------------------------+------------+
      | slave_compressed_protocol     | OFF        |
      | slave_ddl_exec_mode           | IDEMPOTENT |
      | slave_domain_parallel_threads | 0          |
      | slave_exec_mode               | STRICT     |
      | slave_load_tmpdir             | /base/tmp  |
      | slave_max_allowed_packet      | 1073741824 |
      | slave_net_timeout             | 3600       |
      | slave_parallel_max_queued     | 131072     |
      | slave_parallel_mode           | optimistic |
      | slave_parallel_threads        | 4          |
      | slave_run_triggers_for_rbr    | NO         |
      | slave_skip_errors             | OFF        |
      | slave_sql_verify_checksum     | ON         |
      | slave_transaction_retries     | 10         |
      | slave_type_conversions        |            |
      +-------------------------------+------------+
      

        Attachments

          Issue Links

            Activity

              People

              Assignee:
              Elkin Andrei Elkin
              Reporter:
              chernomorets Sergey Chernomorets
              Votes:
              1 Vote for this issue
              Watchers:
              6 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved:

                  Git Integration