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

Error during XID COMMIT: failed to update GTID state in mysql.gtid_slave_pos: 1062: Duplicate entry '0-3913850' for key 'PRIMARY'

Details

    Description

      Last_Errno: 1942
      Last_Error: Error during XID COMMIT: failed to update GTID state in mysql.gtid_slave_pos: 1062: Duplicate entry '0-3913850' for key 'PRIMARY'
      

      variables:

      root@localhost:(none) 10:27:55> show global variables like '%repl%';
      +----------------------------------+-----------+
      | Variable_name                    | Value     |
      +----------------------------------+-----------+
      | innodb_replication_delay         | 0         |
      | replicate_annotate_row_events    | OFF       |
      | replicate_do_db                  |           |
      | replicate_do_table               |           |
      | replicate_events_marked_for_skip | REPLICATE |
      | replicate_ignore_db              |           |
      | replicate_ignore_table           |           |
      | replicate_wild_do_table          |           |
      | replicate_wild_ignore_table      |           |
      | wsrep_mysql_replication_bundle   | 0         |
      | wsrep_replicate_myisam           | OFF       |
      +----------------------------------+-----------+
      11 rows in set (0.00 sec)
      

      root@localhost:(none) 10:27:57> show global variables like '%para%';
      +-------------------------------+--------------+
      | Variable_name                 | Value        |
      +-------------------------------+--------------+
      | slave_domain_parallel_threads | 0            |
      | slave_parallel_max_queued     | 131072       |
      | slave_parallel_mode           | conservative |
      | slave_parallel_threads        | 8            |
      +-------------------------------+--------------+
      4 rows in set (0.00 sec)
      

      root@localhost:(none) 10:28:03> show global variables like '%gtid%';
      +------------------------+-------------------+
      | Variable_name          | Value             |
      +------------------------+-------------------+
      | gtid_binlog_pos        | 0-23603584-215540 |
      | gtid_binlog_state      | 0-23603584-215540 |
      | gtid_current_pos       | 0-23603584-215540 |
      | gtid_domain_id         | 0                 |
      | gtid_ignore_duplicates | OFF               |
      | gtid_slave_pos         | 0-23603584-215540 |
      | gtid_strict_mode       | OFF               |
      | wsrep_gtid_domain_id   | 0                 |
      | wsrep_gtid_mode        | OFF               |
      +------------------------+-------------------+
      9 rows in set (0.00 sec)
      

      root@localhost:(none) 10:37:50> show global variables like '%binlog%';
      +-----------------------------------------+----------------------+
      | Variable_name                           | Value                |
      +-----------------------------------------+----------------------+
      | binlog_annotate_row_events              | OFF                  |
      | binlog_cache_size                       | 2097152              |
      | binlog_checksum                         | NONE                 |
      | binlog_commit_wait_count                | 0                    |
      | binlog_commit_wait_usec                 | 100000               |
      | binlog_direct_non_transactional_updates | OFF                  |
      | binlog_format                           | ROW                  |
      | binlog_optimize_thread_scheduling       | ON                   |
      | binlog_row_image                        | FULL                 |
      | binlog_stmt_cache_size                  | 1048576              |
      | encrypt_binlog                          | OFF                  |
      | gtid_binlog_pos                         | 0-23603584-215945    |
      | gtid_binlog_state                       | 0-23603584-215945    |
      | innodb_api_enable_binlog                | OFF                  |
      | innodb_locks_unsafe_for_binlog          | OFF                  |
      | max_binlog_cache_size                   | 18446744073709547520 |
      | max_binlog_size                         | 1073741824           |
      | max_binlog_stmt_cache_size              | 18446744073709547520 |
      | sync_binlog                             | 1                    |
      | wsrep_forced_binlog_format              | NONE                 |
      +-----------------------------------------+----------------------+
      20 rows in set (0.00 sec)
      

      root@localhost:(none) 10:39:28> show global variables like '%slave%';
      +-------------------------------+-------------------+
      | Variable_name                 | Value             |
      +-------------------------------+-------------------+
      | gtid_slave_pos                | 0-23603584-221689 |
      | init_slave                    |                   |
      | log_slave_updates             | ON                |
      | log_slow_slave_statements     | ON                |
      | slave_compressed_protocol     | OFF               |
      | slave_ddl_exec_mode           | IDEMPOTENT        |
      | slave_domain_parallel_threads | 0                 |
      | slave_exec_mode               | STRICT            |
      | slave_load_tmpdir             | /dev/shm          |
      | slave_max_allowed_packet      | 1073741824        |
      | slave_net_timeout             | 360               |
      | slave_parallel_max_queued     | 131072            |
      | slave_parallel_mode           | conservative      |
      | slave_parallel_threads        | 8                 |
      | slave_run_triggers_for_rbr    | NO                |
      | slave_skip_errors             |                   |
      | slave_sql_verify_checksum     | ON                |
      | slave_transaction_retries     | 10                |
      | slave_type_conversions        |                   |
      | sql_slave_skip_counter        | 0                 |
      | wsrep_restart_slave           | OFF               |
      | wsrep_slave_fk_checks         | ON                |
      | wsrep_slave_uk_checks         | OFF               |
      | wsrep_slave_threads           | 1                 |
      +-------------------------------+-------------------+
      24 rows in set (0.00 sec)
      

      Attachments

        Issue Links

          Activity

            Elkin Andrei Elkin added a comment -

            ruochen, thanks for the report.

            There is a chance that Duplicate entry '0-3913850' was caused by having this gtid transaction (group of repl events) in relaylog (binlog) twice.
            I gather there's just one replication sources - one master, so we can rule out duplication caused by that. Anyway please check out.

            Could you please show both binlog and relaylog events near the failure, say -/+ 100 from 0-3913850 in both directions.
            Next that we need is the master's and slave's error log specifically to see whether there were reconnections and what gtid:s the slave was resuming from.

            I find a bit strange that the error message speaks 0-3913850 while the description shows gtid_slave_pos | 0-23603584-221689. If gtid_slave_pos value was extracted right after the failure on that slave that would mean the binlog/relaylog contains transactions out of gtid seq_no order, which certainly may contribute to the issue.

            So could you please clarify on all these points. Thank you.

            Elkin Andrei Elkin added a comment - ruochen , thanks for the report. There is a chance that Duplicate entry '0-3913850' was caused by having this gtid transaction (group of repl events) in relaylog (binlog) twice. I gather there's just one replication sources - one master, so we can rule out duplication caused by that. Anyway please check out. Could you please show both binlog and relaylog events near the failure, say -/+ 100 from 0-3913850 in both directions. Next that we need is the master's and slave's error log specifically to see whether there were reconnections and what gtid:s the slave was resuming from. I find a bit strange that the error message speaks 0-3913850 while the description shows gtid_slave_pos | 0-23603584-221689 . If gtid_slave_pos value was extracted right after the failure on that slave that would mean the binlog/relaylog contains transactions out of gtid seq_no order, which certainly may contribute to the issue. So could you please clarify on all these points. Thank you.
            ruochen wy added a comment - - edited

            @Andrei Elkin
            Thank you very much.

            Yes,it's just one replication sources.
            According to my observation,the problem occur in weak network like over IDC replacation frequently(but this rarely happens) ,or network throughput overflow,it was repaired by stop slave and then start slave,we will catch detail binlog/relaylog information next time for analysis.

            Please ignore gtid seq_no in variables list,the config setting come from another instance.

            ruochen wy added a comment - - edited @Andrei Elkin Thank you very much. Yes,it's just one replication sources. According to my observation,the problem occur in weak network like over IDC replacation frequently(but this rarely happens) ,or network throughput overflow,it was repaired by stop slave and then start slave,we will catch detail binlog/relaylog information next time for analysis. Please ignore gtid seq_no in variables list,the config setting come from another instance.
            ruochen wy added a comment - - edited

            Yesterday case(20190411):

            1)Slave show slave status info in 20190411.png image file.

            2)Slave error log

            2019-04-11 21:32:40 139825027365632 [ERROR] Slave SQL: Error during XID COMMIT: failed to update GTID state in mysql.gtid_slave_pos: 1062: Duplicate entry '0-153773074' for key 'PRIMARY', Gtid 0-16823342-307546139, Internal MariaDB error code: 1942
            2019-04-11 21:32:40 139825027365632 [ERROR] Slave (additional info): Duplicate entry '0-153773074' for key 'PRIMARY' Error_code: 1062
            2019-04-11 21:32:40 139825027365632 [Warning] Slave: Duplicate entry '0-153773074' for key 'PRIMARY' Error_code: 1062
            2019-04-11 21:32:40 139825027365632 [ERROR] Error running query, slave SQL thread aborted. Fix the problem, and restart the slave SQL thread with "SLAVE START". We stopped at log 'mysql-bin.000159' position 567712572
            2019-04-11 21:32:40 139823896505088 [Note] Error reading relay log event: slave SQL thread was killed
            2019-04-11 21:32:40 139823896505088 [Note] Slave SQL thread exiting, replication stopped in log 'mysql-bin.000159' at position 567712572
            

            3)Master binglog events

            # at 567710582
            #190411 21:32:39 server id 16823342  end_log_pos 567710609      Xid = 4020831567
            COMMIT/*!*/;
            # at 567710609
            #190411 21:32:39 server id 16823342  end_log_pos 567710647      GTID 0-16823342-307546137 trans
            /*!100001 SET @@session.gtid_seq_no=307546137*//*!*/;
            BEGIN
            /*!*/;
            # at 567710647
            #190411 21:32:39 server id 16823342  end_log_pos 567710746      Table_map: `business_job`.`QRTZ_FIRED_TRIGGERS` mapped to number 21
            # at 567710746
            #190411 21:32:39 server id 16823342  end_log_pos 567711181      Update_rows: table id 21 flags: STMT_END_F
            ### UPDATE `business_job`.`QRTZ_FIRED_TRIGGERS`
            ### WHERE
            ###   @1='BRAND-SCHEDULE' /* VARSTRING(360) meta=360 nullable=0 is_null=0 */
            ###   @2='brand-adp-70471-55b755f695-hx74l15547991982031554799219162' /* VARSTRING(285) meta=285 nullable=0 is_null=0 */
            ###   @3='CptOrderStatusJobTrigger' /* VARSTRING(570) meta=570 nullable=0 is_null=0 */
            ###   @4='cpt' /* VARSTRING(570) meta=570 nullable=0 is_null=0 */
            ###   @5='brand-adp-70471-55b755f695-hx74l1554799198203' /* VARSTRING(570) meta=570 nullable=0 is_null=0 */
            ###   @6=1554989557277 /* LONGINT meta=0 nullable=0 is_null=0 */
            ###   @7=1554989560000 /* LONGINT meta=0 nullable=0 is_null=0 */
            ###   @8=5 /* INT meta=0 nullable=0 is_null=0 */
            ###   @9='ACQUIRED' /* VARSTRING(48) meta=48 nullable=0 is_null=0 */
            ###   @10=NULL /* VARSTRING(570) meta=570 nullable=1 is_null=1 */
            ###   @11=NULL /* VARSTRING(570) meta=570 nullable=1 is_null=1 */
            ###   @12='0' /* VARSTRING(3) meta=3 nullable=1 is_null=0 */
            ###   @13='0' /* VARSTRING(3) meta=3 nullable=1 is_null=0 */
            ### SET
            ###   @1='BRAND-SCHEDULE' /* VARSTRING(360) meta=360 nullable=0 is_null=0 */
            ###   @2='brand-adp-70471-55b755f695-hx74l15547991982031554799219162' /* VARSTRING(285) meta=285 nullable=0 is_null=0 */
            ###   @3='CptOrderStatusJobTrigger' /* VARSTRING(570) meta=570 nullable=0 is_null=0 */
            ###   @4='cpt' /* VARSTRING(570) meta=570 nullable=0 is_null=0 */
            ###   @5='brand-adp-70471-55b755f695-hx74l1554799198203' /* VARSTRING(570) meta=570 nullable=0 is_null=0 */
            ###   @6=1554989560001 /* LONGINT meta=0 nullable=0 is_null=0 */
            ###   @7=1554989560000 /* LONGINT meta=0 nullable=0 is_null=0 */
            ###   @8=5 /* INT meta=0 nullable=0 is_null=0 */
            ###   @9='EXECUTING' /* VARSTRING(48) meta=48 nullable=0 is_null=0 */
            ###   @10='CptOrderStatusJob' /* VARSTRING(570) meta=570 nullable=1 is_null=0 */
            ###   @11='cpt' /* VARSTRING(570) meta=570 nullable=1 is_null=0 */
            ###   @12='0' /* VARSTRING(3) meta=3 nullable=1 is_null=0 */
            ###   @13='1' /* VARSTRING(3) meta=3 nullable=1 is_null=0 */
            # at 567711181
            #190411 21:32:39 server id 16823342  end_log_pos 567711276      Table_map: `business_job`.`QRTZ_TRIGGERS` mapped to number 43
            # at 567711276
            #190411 21:32:39 server id 16823342  end_log_pos 567711561      Update_rows: table id 43 flags: STMT_END_F
            ### UPDATE `business_job`.`QRTZ_TRIGGERS`
            ### WHERE
            ###   @1='BRAND-SCHEDULE' /* VARSTRING(360) meta=360 nullable=0 is_null=0 */
            ###   @2='CptOrderStatusJobTrigger' /* VARSTRING(570) meta=570 nullable=0 is_null=0 */
            ###   @3='cpt' /* VARSTRING(570) meta=570 nullable=0 is_null=0 */
            ###   @4='CptOrderStatusJob' /* VARSTRING(570) meta=570 nullable=0 is_null=0 */
            ###   @5='cpt' /* VARSTRING(570) meta=570 nullable=0 is_null=0 */
            ###   @6=NULL /* VARSTRING(750) meta=750 nullable=1 is_null=1 */
            ###   @7=1554989560000 /* LONGINT meta=0 nullable=1 is_null=0 */
            ###   @8=1554989550000 /* LONGINT meta=0 nullable=1 is_null=0 */
            ###   @9=5 /* INT meta=0 nullable=1 is_null=0 */
            ###   @10='ACQUIRED' /* VARSTRING(48) meta=48 nullable=0 is_null=0 */
            ###   @11='CRON' /* VARSTRING(24) meta=24 nullable=0 is_null=0 */
            ###   @12=1554799338000 /* LONGINT meta=0 nullable=0 is_null=0 */
            ###   @13=0 /* LONGINT meta=0 nullable=1 is_null=0 */
            ###   @14=NULL /* VARSTRING(570) meta=570 nullable=1 is_null=1 */
            ###   @15=2 /* SHORTINT meta=0 nullable=1 is_null=0 */
            ###   @16='' /* BLOB/TEXT meta=2 nullable=1 is_null=0 */
            ### SET
            ###   @1='BRAND-SCHEDULE' /* VARSTRING(360) meta=360 nullable=0 is_null=0 */
            ###   @2='CptOrderStatusJobTrigger' /* VARSTRING(570) meta=570 nullable=0 is_null=0 */
            ###   @3='cpt' /* VARSTRING(570) meta=570 nullable=0 is_null=0 */
            ###   @4='CptOrderStatusJob' /* VARSTRING(570) meta=570 nullable=0 is_null=0 */
            ###   @5='cpt' /* VARSTRING(570) meta=570 nullable=0 is_null=0 */
            ###   @6=NULL /* VARSTRING(750) meta=750 nullable=1 is_null=1 */
            ###   @7=1554989570000 /* LONGINT meta=0 nullable=1 is_null=0 */
            ###   @8=1554989560000 /* LONGINT meta=0 nullable=1 is_null=0 */
            ###   @9=5 /* INT meta=0 nullable=1 is_null=0 */
            ###   @10='WAITING' /* VARSTRING(48) meta=48 nullable=0 is_null=0 */
            ###   @11='CRON' /* VARSTRING(24) meta=24 nullable=0 is_null=0 */
            ###   @12=1554799338000 /* LONGINT meta=0 nullable=0 is_null=0 */
            ###   @13=0 /* LONGINT meta=0 nullable=1 is_null=0 */
            ###   @14=NULL /* VARSTRING(570) meta=570 nullable=1 is_null=1 */
            ###   @15=2 /* SHORTINT meta=0 nullable=1 is_null=0 */
            ###   @16='' /* BLOB/TEXT meta=2 nullable=1 is_null=0 */
            # at 567711561
            #190411 21:32:39 server id 16823342  end_log_pos 567711588      Xid = 4020831570
            COMMIT/*!*/;
            # at 567711588
            #190411 21:32:40 server id 16823342  end_log_pos 567711626      GTID 0-16823342-307546138 trans
            /*!100001 SET @@session.gtid_seq_no=307546138*//*!*/;
            BEGIN
            /*!*/;
            # at 567711626
            #190411 21:32:40 server id 16823342  end_log_pos 567711725      Table_map: `business_job`.`QRTZ_FIRED_TRIGGERS` mapped to number 21
            # at 567711725
            #190411 21:32:40 server id 16823342  end_log_pos 567712163      Update_rows: table id 21 flags: STMT_END_F
            ### UPDATE `business_job`.`QRTZ_FIRED_TRIGGERS`
            ### WHERE
            ###   @1='CRM-SCHEDULE' /* VARSTRING(360) meta=360 nullable=0 is_null=0 */
            ###   @2='crm-portal-70806-5b4497f759-jmzcx15548887805081554888807633' /* VARSTRING(285) meta=285 nullable=0 is_null=0 */
            ###   @3='ReWaitOrderTrigger' /* VARSTRING(570) meta=570 nullable=0 is_null=0 */
            ###   @4='crm-order' /* VARSTRING(570) meta=570 nullable=0 is_null=0 */
            ###   @5='crm-portal-70806-5b4497f759-jmzcx1554888780508' /* VARSTRING(570) meta=570 nullable=0 is_null=0 */
            ###   @6=1554989550138 /* LONGINT meta=0 nullable=0 is_null=0 */
            ###   @7=1554989560000 /* LONGINT meta=0 nullable=0 is_null=0 */
            ###   @8=5 /* INT meta=0 nullable=0 is_null=0 */
            ###   @9='ACQUIRED' /* VARSTRING(48) meta=48 nullable=0 is_null=0 */
            ###   @10=NULL /* VARSTRING(570) meta=570 nullable=1 is_null=1 */
            ###   @11=NULL /* VARSTRING(570) meta=570 nullable=1 is_null=1 */
            ###   @12='0' /* VARSTRING(3) meta=3 nullable=1 is_null=0 */
            ###   @13='0' /* VARSTRING(3) meta=3 nullable=1 is_null=0 */
            ### SET
            ###   @1='CRM-SCHEDULE' /* VARSTRING(360) meta=360 nullable=0 is_null=0 */
            ###   @2='crm-portal-70806-5b4497f759-jmzcx15548887805081554888807633' /* VARSTRING(285) meta=285 nullable=0 is_null=0 */
            ###   @3='ReWaitOrderTrigger' /* VARSTRING(570) meta=570 nullable=0 is_null=0 */
            ###   @4='crm-order' /* VARSTRING(570) meta=570 nullable=0 is_null=0 */
            ###   @5='crm-portal-70806-5b4497f759-jmzcx1554888780508' /* VARSTRING(570) meta=570 nullable=0 is_null=0 */
            ###   @6=1554989560002 /* LONGINT meta=0 nullable=0 is_null=0 */
            ###   @7=1554989560000 /* LONGINT meta=0 nullable=0 is_null=0 */
            ###   @8=5 /* INT meta=0 nullable=0 is_null=0 */
            ###   @9='EXECUTING' /* VARSTRING(48) meta=48 nullable=0 is_null=0 */
            ###   @10='ReWaitOrderJob' /* VARSTRING(570) meta=570 nullable=1 is_null=0 */
            ###   @11='crm-order' /* VARSTRING(570) meta=570 nullable=1 is_null=0 */
            ###   @12='0' /* VARSTRING(3) meta=3 nullable=1 is_null=0 */
            ###   @13='1' /* VARSTRING(3) meta=3 nullable=1 is_null=0 */
            # at 567712163
            #190411 21:32:40 server id 16823342  end_log_pos 567712258      Table_map: `business_job`.`QRTZ_TRIGGERS` mapped to number 43
            # at 567712258
            #190411 21:32:40 server id 16823342  end_log_pos 567712545      Update_rows: table id 43 flags: STMT_END_F
            ### UPDATE `business_job`.`QRTZ_TRIGGERS`
            ### WHERE
            ###   @1='CRM-SCHEDULE' /* VARSTRING(360) meta=360 nullable=0 is_null=0 */
            ###   @2='ReWaitOrderTrigger' /* VARSTRING(570) meta=570 nullable=0 is_null=0 */
            ###   @3='crm-order' /* VARSTRING(570) meta=570 nullable=0 is_null=0 */
            ###   @4='ReWaitOrderJob' /* VARSTRING(570) meta=570 nullable=0 is_null=0 */
            ###   @5='crm-order' /* VARSTRING(570) meta=570 nullable=0 is_null=0 */
            ###   @6=NULL /* VARSTRING(750) meta=750 nullable=1 is_null=1 */
            ###   @7=1554989560000 /* LONGINT meta=0 nullable=1 is_null=0 */
            ###   @8=1554989550000 /* LONGINT meta=0 nullable=1 is_null=0 */
            ###   @9=5 /* INT meta=0 nullable=1 is_null=0 */
            ###   @10='ACQUIRED' /* VARSTRING(48) meta=48 nullable=0 is_null=0 */
            ###   @11='CRON' /* VARSTRING(24) meta=24 nullable=0 is_null=0 */
            ###   @12=1554894168000 /* LONGINT meta=0 nullable=0 is_null=0 */
            ###   @13=0 /* LONGINT meta=0 nullable=1 is_null=0 */
            ###   @14=NULL /* VARSTRING(570) meta=570 nullable=1 is_null=1 */
            ###   @15=2 /* SHORTINT meta=0 nullable=1 is_null=0 */
            ###   @16='' /* BLOB/TEXT meta=2 nullable=1 is_null=0 */
            ### SET
            ###   @1='CRM-SCHEDULE' /* VARSTRING(360) meta=360 nullable=0 is_null=0 */
            ###   @2='ReWaitOrderTrigger' /* VARSTRING(570) meta=570 nullable=0 is_null=0 */
            ###   @3='crm-order' /* VARSTRING(570) meta=570 nullable=0 is_null=0 */
            ###   @4='ReWaitOrderJob' /* VARSTRING(570) meta=570 nullable=0 is_null=0 */
            ###   @5='crm-order' /* VARSTRING(570) meta=570 nullable=0 is_null=0 */
            ###   @6=NULL /* VARSTRING(750) meta=750 nullable=1 is_null=1 */
            ###   @7=1554989570000 /* LONGINT meta=0 nullable=1 is_null=0 */
            ###   @8=1554989560000 /* LONGINT meta=0 nullable=1 is_null=0 */
            ###   @9=5 /* INT meta=0 nullable=1 is_null=0 */
            ###   @10='WAITING' /* VARSTRING(48) meta=48 nullable=0 is_null=0 */
            ###   @11='CRON' /* VARSTRING(24) meta=24 nullable=0 is_null=0 */
            ###   @12=1554894168000 /* LONGINT meta=0 nullable=0 is_null=0 */
            ###   @13=0 /* LONGINT meta=0 nullable=1 is_null=0 */
            ###   @14=NULL /* VARSTRING(570) meta=570 nullable=1 is_null=1 */
            ###   @15=2 /* SHORTINT meta=0 nullable=1 is_null=0 */
            ###   @16='' /* BLOB/TEXT meta=2 nullable=1 is_null=0 */
            # at 567712545
            #190411 21:32:40 server id 16823342  end_log_pos 567712572      Xid = 4020831573
            COMMIT/*!*/;
            # at 567712572
            #190411 21:32:40 server id 16823342  end_log_pos 567712610      GTID 0-16823342-307546139 trans
            /*!100001 SET @@session.gtid_seq_no=307546139*//*!*/;
            BEGIN
            /*!*/;
            # at 567712610
            #190411 21:32:39 server id 16823342  end_log_pos 567712705      Table_map: `business_job`.`QRTZ_TRIGGERS` mapped to number 43
            # at 567712705
            #190411 21:32:39 server id 16823342  end_log_pos 567713026      Update_rows: table id 43 flags: STMT_END_F
            ### UPDATE `business_job`.`QRTZ_TRIGGERS`
            ### WHERE
            ###   @1='BRAND-SCHEDULE' /* VARSTRING(360) meta=360 nullable=0 is_null=0 */
            ###   @2='AdoptOrderByCrmJobTrigger' /* VARSTRING(570) meta=570 nullable=0 is_null=0 */
            ###   @3='brand-order' /* VARSTRING(570) meta=570 nullable=0 is_null=0 */
            ###   @4='AdoptOrderByCrmJob' /* VARSTRING(570) meta=570 nullable=0 is_null=0 */
            ###   @5='brand-order' /* VARSTRING(570) meta=570 nullable=0 is_null=0 */
            ###   @6=NULL /* VARSTRING(750) meta=750 nullable=1 is_null=1 */
            ###   @7=1554989560000 /* LONGINT meta=0 nullable=1 is_null=0 */
            ###   @8=1554989550000 /* LONGINT meta=0 nullable=1 is_null=0 */
            ###   @9=5 /* INT meta=0 nullable=1 is_null=0 */
            ###   @10='WAITING' /* VARSTRING(48) meta=48 nullable=0 is_null=0 */
            ###   @11='CRON' /* VARSTRING(24) meta=24 nullable=0 is_null=0 */
            ###   @12=1554799338000 /* LONGINT meta=0 nullable=0 is_null=0 */
            ###   @13=0 /* LONGINT meta=0 nullable=1 is_null=0 */
            ###   @14=NULL /* VARSTRING(570) meta=570 nullable=1 is_null=1 */
            ###   @15=2 /* SHORTINT meta=0 nullable=1 is_null=0 */
            ###   @16='' /* BLOB/TEXT meta=2 nullable=1 is_null=0 */
            ### SET
            ###   @1='BRAND-SCHEDULE' /* VARSTRING(360) meta=360 nullable=0 is_null=0 */
            ###   @2='AdoptOrderByCrmJobTrigger' /* VARSTRING(570) meta=570 nullable=0 is_null=0 */
            ###   @3='brand-order' /* VARSTRING(570) meta=570 nullable=0 is_null=0 */
            ###   @4='AdoptOrderByCrmJob' /* VARSTRING(570) meta=570 nullable=0 is_null=0 */
            ###   @5='brand-order' /* VARSTRING(570) meta=570 nullable=0 is_null=0 */
            ###   @6=NULL /* VARSTRING(750) meta=750 nullable=1 is_null=1 */
            ###   @7=1554989560000 /* LONGINT meta=0 nullable=1 is_null=0 */
            ###   @8=1554989550000 /* LONGINT meta=0 nullable=1 is_null=0 */
            ###   @9=5 /* INT meta=0 nullable=1 is_null=0 */
            ###   @10='ACQUIRED' /* VARSTRING(48) meta=48 nullable=0 is_null=0 */
            ###   @11='CRON' /* VARSTRING(24) meta=24 nullable=0 is_null=0 */
            ###   @12=1554799338000 /* LONGINT meta=0 nullable=0 is_null=0 */
            ###   @13=0 /* LONGINT meta=0 nullable=1 is_null=0 */
            ###   @14=NULL /* VARSTRING(570) meta=570 nullable=1 is_null=1 */
            ###   @15=2 /* SHORTINT meta=0 nullable=1 is_null=0 */
            ###   @16='' /* BLOB/TEXT meta=2 nullable=1 is_null=0 */
            # at 567713026
            #190411 21:32:40 server id 16823342  end_log_pos 567713125      Table_map: `business_job`.`QRTZ_FIRED_TRIGGERS` mapped to number 21
            # at 567713125
            #190411 21:32:40 server id 16823342  end_log_pos 567713353      Write_rows: table id 21 flags: STMT_END_F
            ### INSERT INTO `business_job`.`QRTZ_FIRED_TRIGGERS`
            ### SET
            ###   @1='BRAND-SCHEDULE' /* VARSTRING(360) meta=360 nullable=0 is_null=0 */
            ###   @2='brand-adp-70471-55b755f695-hx74l15547991982031554799219163' /* VARSTRING(285) meta=285 nullable=0 is_null=0 */
            ###   @3='AdoptOrderByCrmJobTrigger' /* VARSTRING(570) meta=570 nullable=0 is_null=0 */
            ###   @4='brand-order' /* VARSTRING(570) meta=570 nullable=0 is_null=0 */
            ###   @5='brand-adp-70471-55b755f695-hx74l1554799198203' /* VARSTRING(570) meta=570 nullable=0 is_null=0 */
            ###   @6=1554989560014 /* LONGINT meta=0 nullable=0 is_null=0 */
            ###   @7=1554989560000 /* LONGINT meta=0 nullable=0 is_null=0 */
            ###   @8=5 /* INT meta=0 nullable=0 is_null=0 */
            ###   @9='ACQUIRED' /* VARSTRING(48) meta=48 nullable=0 is_null=0 */
            ###   @10=NULL /* VARSTRING(570) meta=570 nullable=1 is_null=1 */
            ###   @11=NULL /* VARSTRING(570) meta=570 nullable=1 is_null=1 */
            ###   @12='0' /* VARSTRING(3) meta=3 nullable=1 is_null=0 */
            ###   @13='0' /* VARSTRING(3) meta=3 nullable=1 is_null=0 */
            # at 567713353
            #190411 21:32:40 server id 16823342  end_log_pos 567713380      Xid = 4020831576
            COMMIT/*!*/;
            # at 567713380
            #190411 21:32:40 server id 16823342  end_log_pos 567713420      GTID 0-16823342-307546140 cid=4020831580 trans
            /*!100001 SET @@session.gtid_seq_no=307546140*//*!*/;
            BEGIN
            /*!*/;
            # at 567713420
            #190411 21:32:40 server id 16823342  end_log_pos 567713519      Table_map: `business_job`.`QRTZ_FIRED_TRIGGERS` mapped to number 21
            # at 567713519
            

            4)Slave relaylog events

            # at 567710870
            #190411 21:32:39 server id 16823342  end_log_pos 567710609      Xid = 4020831567
            COMMIT/*!*/;
            # at 567710897
            #190411 21:32:39 server id 16823342  end_log_pos 567710647      GTID 0-16823342-307546137 trans
            /*!100001 SET @@session.gtid_seq_no=307546137*//*!*/;
            BEGIN
            /*!*/;
            # at 567710935
            #190411 21:32:39 server id 16823342  end_log_pos 567710746      Table_map: `business_job`.`QRTZ_FIRED_TRIGGERS` mapped to number 21
            # at 567711034
            #190411 21:32:39 server id 16823342  end_log_pos 567711181      Update_rows: table id 21 flags: STMT_END_F
            ### UPDATE `business_job`.`QRTZ_FIRED_TRIGGERS`
            ### WHERE
            ###   @1='BRAND-SCHEDULE' /* VARSTRING(360) meta=360 nullable=0 is_null=0 */
            ###   @2='brand-adp-70471-55b755f695-hx74l15547991982031554799219162' /* VARSTRING(285) meta=285 nullable=0 is_null=0 */
            ###   @3='CptOrderStatusJobTrigger' /* VARSTRING(570) meta=570 nullable=0 is_null=0 */
            ###   @4='cpt' /* VARSTRING(570) meta=570 nullable=0 is_null=0 */
            ###   @5='brand-adp-70471-55b755f695-hx74l1554799198203' /* VARSTRING(570) meta=570 nullable=0 is_null=0 */
            ###   @6=1554989557277 /* LONGINT meta=0 nullable=0 is_null=0 */
            ###   @7=1554989560000 /* LONGINT meta=0 nullable=0 is_null=0 */
            ###   @8=5 /* INT meta=0 nullable=0 is_null=0 */
            ###   @9='ACQUIRED' /* VARSTRING(48) meta=48 nullable=0 is_null=0 */
            ###   @10=NULL /* VARSTRING(570) meta=570 nullable=1 is_null=1 */
            ###   @11=NULL /* VARSTRING(570) meta=570 nullable=1 is_null=1 */
            ###   @12='0' /* VARSTRING(3) meta=3 nullable=1 is_null=0 */
            ###   @13='0' /* VARSTRING(3) meta=3 nullable=1 is_null=0 */
            ### SET
            ###   @1='BRAND-SCHEDULE' /* VARSTRING(360) meta=360 nullable=0 is_null=0 */
            ###   @2='brand-adp-70471-55b755f695-hx74l15547991982031554799219162' /* VARSTRING(285) meta=285 nullable=0 is_null=0 */
            ###   @3='CptOrderStatusJobTrigger' /* VARSTRING(570) meta=570 nullable=0 is_null=0 */
            ###   @4='cpt' /* VARSTRING(570) meta=570 nullable=0 is_null=0 */
            ###   @5='brand-adp-70471-55b755f695-hx74l1554799198203' /* VARSTRING(570) meta=570 nullable=0 is_null=0 */
            ###   @6=1554989560001 /* LONGINT meta=0 nullable=0 is_null=0 */
            ###   @7=1554989560000 /* LONGINT meta=0 nullable=0 is_null=0 */
            ###   @8=5 /* INT meta=0 nullable=0 is_null=0 */
            ###   @9='EXECUTING' /* VARSTRING(48) meta=48 nullable=0 is_null=0 */
            ###   @10='CptOrderStatusJob' /* VARSTRING(570) meta=570 nullable=1 is_null=0 */
            ###   @11='cpt' /* VARSTRING(570) meta=570 nullable=1 is_null=0 */
            ###   @12='0' /* VARSTRING(3) meta=3 nullable=1 is_null=0 */
            ###   @13='1' /* VARSTRING(3) meta=3 nullable=1 is_null=0 */
            # at 567711469
            #190411 21:32:39 server id 16823342  end_log_pos 567711276      Table_map: `business_job`.`QRTZ_TRIGGERS` mapped to number 43
            # at 567711564
            #190411 21:32:39 server id 16823342  end_log_pos 567711561      Update_rows: table id 43 flags: STMT_END_F
            ### UPDATE `business_job`.`QRTZ_TRIGGERS`
            ### WHERE
            ###   @1='BRAND-SCHEDULE' /* VARSTRING(360) meta=360 nullable=0 is_null=0 */
            ###   @2='CptOrderStatusJobTrigger' /* VARSTRING(570) meta=570 nullable=0 is_null=0 */
            ###   @3='cpt' /* VARSTRING(570) meta=570 nullable=0 is_null=0 */
            ###   @4='CptOrderStatusJob' /* VARSTRING(570) meta=570 nullable=0 is_null=0 */
            ###   @5='cpt' /* VARSTRING(570) meta=570 nullable=0 is_null=0 */
            ###   @6=NULL /* VARSTRING(750) meta=750 nullable=1 is_null=1 */
            ###   @7=1554989560000 /* LONGINT meta=0 nullable=1 is_null=0 */
            ###   @8=1554989550000 /* LONGINT meta=0 nullable=1 is_null=0 */
            ###   @9=5 /* INT meta=0 nullable=1 is_null=0 */
            ###   @10='ACQUIRED' /* VARSTRING(48) meta=48 nullable=0 is_null=0 */
            ###   @11='CRON' /* VARSTRING(24) meta=24 nullable=0 is_null=0 */
            ###   @12=1554799338000 /* LONGINT meta=0 nullable=0 is_null=0 */
            ###   @13=0 /* LONGINT meta=0 nullable=1 is_null=0 */
            ###   @14=NULL /* VARSTRING(570) meta=570 nullable=1 is_null=1 */
            ###   @15=2 /* SHORTINT meta=0 nullable=1 is_null=0 */
            ###   @16='' /* BLOB/TEXT meta=2 nullable=1 is_null=0 */
            ### SET
            ###   @1='BRAND-SCHEDULE' /* VARSTRING(360) meta=360 nullable=0 is_null=0 */
            ###   @2='CptOrderStatusJobTrigger' /* VARSTRING(570) meta=570 nullable=0 is_null=0 */
            ###   @3='cpt' /* VARSTRING(570) meta=570 nullable=0 is_null=0 */
            ###   @4='CptOrderStatusJob' /* VARSTRING(570) meta=570 nullable=0 is_null=0 */
            ###   @5='cpt' /* VARSTRING(570) meta=570 nullable=0 is_null=0 */
            ###   @6=NULL /* VARSTRING(750) meta=750 nullable=1 is_null=1 */
            ###   @7=1554989570000 /* LONGINT meta=0 nullable=1 is_null=0 */
            ###   @8=1554989560000 /* LONGINT meta=0 nullable=1 is_null=0 */
            ###   @9=5 /* INT meta=0 nullable=1 is_null=0 */
            ###   @10='WAITING' /* VARSTRING(48) meta=48 nullable=0 is_null=0 */
            ###   @11='CRON' /* VARSTRING(24) meta=24 nullable=0 is_null=0 */
            ###   @12=1554799338000 /* LONGINT meta=0 nullable=0 is_null=0 */
            ###   @13=0 /* LONGINT meta=0 nullable=1 is_null=0 */
            ###   @14=NULL /* VARSTRING(570) meta=570 nullable=1 is_null=1 */
            ###   @15=2 /* SHORTINT meta=0 nullable=1 is_null=0 */
            ###   @16='' /* BLOB/TEXT meta=2 nullable=1 is_null=0 */
            # at 567711849
            #190411 21:32:39 server id 16823342  end_log_pos 567711588      Xid = 4020831570
            COMMIT/*!*/;
            # at 567711876
            #190411 21:32:40 server id 16823342  end_log_pos 567711626      GTID 0-16823342-307546138 trans
            /*!100001 SET @@session.gtid_seq_no=307546138*//*!*/;
            BEGIN
            /*!*/;
            # at 567711914
            #190411 21:32:40 server id 16823342  end_log_pos 567711725      Table_map: `business_job`.`QRTZ_FIRED_TRIGGERS` mapped to number 21
            # at 567712013
            #190411 21:32:40 server id 16823342  end_log_pos 567712163      Update_rows: table id 21 flags: STMT_END_F
            ### UPDATE `business_job`.`QRTZ_FIRED_TRIGGERS`
            ### WHERE
            ###   @1='CRM-SCHEDULE' /* VARSTRING(360) meta=360 nullable=0 is_null=0 */
            ###   @2='crm-portal-70806-5b4497f759-jmzcx15548887805081554888807633' /* VARSTRING(285) meta=285 nullable=0 is_null=0 */
            ###   @3='ReWaitOrderTrigger' /* VARSTRING(570) meta=570 nullable=0 is_null=0 */
            ###   @4='crm-order' /* VARSTRING(570) meta=570 nullable=0 is_null=0 */
            ###   @5='crm-portal-70806-5b4497f759-jmzcx1554888780508' /* VARSTRING(570) meta=570 nullable=0 is_null=0 */
            ###   @6=1554989550138 /* LONGINT meta=0 nullable=0 is_null=0 */
            ###   @7=1554989560000 /* LONGINT meta=0 nullable=0 is_null=0 */
            ###   @8=5 /* INT meta=0 nullable=0 is_null=0 */
            ###   @9='ACQUIRED' /* VARSTRING(48) meta=48 nullable=0 is_null=0 */
            ###   @10=NULL /* VARSTRING(570) meta=570 nullable=1 is_null=1 */
            ###   @11=NULL /* VARSTRING(570) meta=570 nullable=1 is_null=1 */
            ###   @12='0' /* VARSTRING(3) meta=3 nullable=1 is_null=0 */
            ###   @13='0' /* VARSTRING(3) meta=3 nullable=1 is_null=0 */
            ### SET
            ###   @1='CRM-SCHEDULE' /* VARSTRING(360) meta=360 nullable=0 is_null=0 */
            ###   @2='crm-portal-70806-5b4497f759-jmzcx15548887805081554888807633' /* VARSTRING(285) meta=285 nullable=0 is_null=0 */
            ###   @3='ReWaitOrderTrigger' /* VARSTRING(570) meta=570 nullable=0 is_null=0 */
            ###   @4='crm-order' /* VARSTRING(570) meta=570 nullable=0 is_null=0 */
            ###   @5='crm-portal-70806-5b4497f759-jmzcx1554888780508' /* VARSTRING(570) meta=570 nullable=0 is_null=0 */
            ###   @6=1554989560002 /* LONGINT meta=0 nullable=0 is_null=0 */
            ###   @7=1554989560000 /* LONGINT meta=0 nullable=0 is_null=0 */
            ###   @8=5 /* INT meta=0 nullable=0 is_null=0 */
            ###   @9='EXECUTING' /* VARSTRING(48) meta=48 nullable=0 is_null=0 */
            ###   @10='ReWaitOrderJob' /* VARSTRING(570) meta=570 nullable=1 is_null=0 */
            ###   @11='crm-order' /* VARSTRING(570) meta=570 nullable=1 is_null=0 */
            ###   @12='0' /* VARSTRING(3) meta=3 nullable=1 is_null=0 */
            ###   @13='1' /* VARSTRING(3) meta=3 nullable=1 is_null=0 */
            # at 567712451
            #190411 21:32:40 server id 16823342  end_log_pos 567712258      Table_map: `business_job`.`QRTZ_TRIGGERS` mapped to number 43
            # at 567712546
            #190411 21:32:40 server id 16823342  end_log_pos 567712545      Update_rows: table id 43 flags: STMT_END_F
            ### UPDATE `business_job`.`QRTZ_TRIGGERS`
            ### WHERE
            ###   @1='CRM-SCHEDULE' /* VARSTRING(360) meta=360 nullable=0 is_null=0 */
            ###   @2='ReWaitOrderTrigger' /* VARSTRING(570) meta=570 nullable=0 is_null=0 */
            ###   @3='crm-order' /* VARSTRING(570) meta=570 nullable=0 is_null=0 */
            ###   @4='ReWaitOrderJob' /* VARSTRING(570) meta=570 nullable=0 is_null=0 */
            ###   @5='crm-order' /* VARSTRING(570) meta=570 nullable=0 is_null=0 */
            ###   @6=NULL /* VARSTRING(750) meta=750 nullable=1 is_null=1 */
            ###   @7=1554989560000 /* LONGINT meta=0 nullable=1 is_null=0 */
            ###   @8=1554989550000 /* LONGINT meta=0 nullable=1 is_null=0 */
            ###   @9=5 /* INT meta=0 nullable=1 is_null=0 */
            ###   @10='ACQUIRED' /* VARSTRING(48) meta=48 nullable=0 is_null=0 */
            ###   @11='CRON' /* VARSTRING(24) meta=24 nullable=0 is_null=0 */
            ###   @12=1554894168000 /* LONGINT meta=0 nullable=0 is_null=0 */
            ###   @13=0 /* LONGINT meta=0 nullable=1 is_null=0 */
            ###   @14=NULL /* VARSTRING(570) meta=570 nullable=1 is_null=1 */
            ###   @15=2 /* SHORTINT meta=0 nullable=1 is_null=0 */
            ###   @16='' /* BLOB/TEXT meta=2 nullable=1 is_null=0 */
            ### SET
            ###   @1='CRM-SCHEDULE' /* VARSTRING(360) meta=360 nullable=0 is_null=0 */
            ###   @2='ReWaitOrderTrigger' /* VARSTRING(570) meta=570 nullable=0 is_null=0 */
            ###   @3='crm-order' /* VARSTRING(570) meta=570 nullable=0 is_null=0 */
            ###   @4='ReWaitOrderJob' /* VARSTRING(570) meta=570 nullable=0 is_null=0 */
            ###   @5='crm-order' /* VARSTRING(570) meta=570 nullable=0 is_null=0 */
            ###   @6=NULL /* VARSTRING(750) meta=750 nullable=1 is_null=1 */
            ###   @7=1554989570000 /* LONGINT meta=0 nullable=1 is_null=0 */
            ###   @8=1554989560000 /* LONGINT meta=0 nullable=1 is_null=0 */
            ###   @9=5 /* INT meta=0 nullable=1 is_null=0 */
            ###   @10='WAITING' /* VARSTRING(48) meta=48 nullable=0 is_null=0 */
            ###   @11='CRON' /* VARSTRING(24) meta=24 nullable=0 is_null=0 */
            ###   @12=1554894168000 /* LONGINT meta=0 nullable=0 is_null=0 */
            ###   @13=0 /* LONGINT meta=0 nullable=1 is_null=0 */
            ###   @14=NULL /* VARSTRING(570) meta=570 nullable=1 is_null=1 */
            ###   @15=2 /* SHORTINT meta=0 nullable=1 is_null=0 */
            ###   @16='' /* BLOB/TEXT meta=2 nullable=1 is_null=0 */
            # at 567712833
            #190411 21:32:40 server id 16823342  end_log_pos 567712572      Xid = 4020831573
            COMMIT/*!*/;
            # at 567712860
            #190411 21:32:40 server id 16823342  end_log_pos 567712610      GTID 0-16823342-307546139 trans
            /*!100001 SET @@session.gtid_seq_no=307546139*//*!*/;
            BEGIN
            /*!*/;
            # at 567712898
            #190411 21:32:39 server id 16823342  end_log_pos 567712705      Table_map: `business_job`.`QRTZ_TRIGGERS` mapped to number 43
            # at 567712993
            #190411 21:32:39 server id 16823342  end_log_pos 567713026      Update_rows: table id 43 flags: STMT_END_F
            ### UPDATE `business_job`.`QRTZ_TRIGGERS`
            ### WHERE
            ###   @1='BRAND-SCHEDULE' /* VARSTRING(360) meta=360 nullable=0 is_null=0 */
            ###   @2='AdoptOrderByCrmJobTrigger' /* VARSTRING(570) meta=570 nullable=0 is_null=0 */
            ###   @3='brand-order' /* VARSTRING(570) meta=570 nullable=0 is_null=0 */
            ###   @4='AdoptOrderByCrmJob' /* VARSTRING(570) meta=570 nullable=0 is_null=0 */
            ###   @5='brand-order' /* VARSTRING(570) meta=570 nullable=0 is_null=0 */
            ###   @6=NULL /* VARSTRING(750) meta=750 nullable=1 is_null=1 */
            ###   @7=1554989560000 /* LONGINT meta=0 nullable=1 is_null=0 */
            ###   @8=1554989550000 /* LONGINT meta=0 nullable=1 is_null=0 */
            ###   @9=5 /* INT meta=0 nullable=1 is_null=0 */
            ###   @10='WAITING' /* VARSTRING(48) meta=48 nullable=0 is_null=0 */
            ###   @11='CRON' /* VARSTRING(24) meta=24 nullable=0 is_null=0 */
            ###   @12=1554799338000 /* LONGINT meta=0 nullable=0 is_null=0 */
            ###   @13=0 /* LONGINT meta=0 nullable=1 is_null=0 */
            ###   @14=NULL /* VARSTRING(570) meta=570 nullable=1 is_null=1 */
            ###   @15=2 /* SHORTINT meta=0 nullable=1 is_null=0 */
            ###   @16='' /* BLOB/TEXT meta=2 nullable=1 is_null=0 */
            ### SET
            ###   @1='BRAND-SCHEDULE' /* VARSTRING(360) meta=360 nullable=0 is_null=0 */
            ###   @2='AdoptOrderByCrmJobTrigger' /* VARSTRING(570) meta=570 nullable=0 is_null=0 */
            ###   @3='brand-order' /* VARSTRING(570) meta=570 nullable=0 is_null=0 */
            ###   @4='AdoptOrderByCrmJob' /* VARSTRING(570) meta=570 nullable=0 is_null=0 */
            ###   @5='brand-order' /* VARSTRING(570) meta=570 nullable=0 is_null=0 */
            ###   @6=NULL /* VARSTRING(750) meta=750 nullable=1 is_null=1 */
            ###   @7=1554989560000 /* LONGINT meta=0 nullable=1 is_null=0 */
            ###   @8=1554989550000 /* LONGINT meta=0 nullable=1 is_null=0 */
            ###   @9=5 /* INT meta=0 nullable=1 is_null=0 */
            ###   @10='ACQUIRED' /* VARSTRING(48) meta=48 nullable=0 is_null=0 */
            ###   @11='CRON' /* VARSTRING(24) meta=24 nullable=0 is_null=0 */
            ###   @12=1554799338000 /* LONGINT meta=0 nullable=0 is_null=0 */
            ###   @13=0 /* LONGINT meta=0 nullable=1 is_null=0 */
            ###   @14=NULL /* VARSTRING(570) meta=570 nullable=1 is_null=1 */
            ###   @15=2 /* SHORTINT meta=0 nullable=1 is_null=0 */
            ###   @16='' /* BLOB/TEXT meta=2 nullable=1 is_null=0 */
            # at 567713314
            #190411 21:32:40 server id 16823342  end_log_pos 567713125      Table_map: `business_job`.`QRTZ_FIRED_TRIGGERS` mapped to number 21
            # at 567713413
            #190411 21:32:40 server id 16823342  end_log_pos 567713353      Write_rows: table id 21 flags: STMT_END_F
            ### INSERT INTO `business_job`.`QRTZ_FIRED_TRIGGERS`
            ### SET
            ###   @1='BRAND-SCHEDULE' /* VARSTRING(360) meta=360 nullable=0 is_null=0 */
            ###   @2='brand-adp-70471-55b755f695-hx74l15547991982031554799219163' /* VARSTRING(285) meta=285 nullable=0 is_null=0 */
            ###   @3='AdoptOrderByCrmJobTrigger' /* VARSTRING(570) meta=570 nullable=0 is_null=0 */
            ###   @4='brand-order' /* VARSTRING(570) meta=570 nullable=0 is_null=0 */
            ###   @5='brand-adp-70471-55b755f695-hx74l1554799198203' /* VARSTRING(570) meta=570 nullable=0 is_null=0 */
            ###   @6=1554989560014 /* LONGINT meta=0 nullable=0 is_null=0 */
            ###   @7=1554989560000 /* LONGINT meta=0 nullable=0 is_null=0 */
            ###   @8=5 /* INT meta=0 nullable=0 is_null=0 */
            ###   @9='ACQUIRED' /* VARSTRING(48) meta=48 nullable=0 is_null=0 */
            ###   @10=NULL /* VARSTRING(570) meta=570 nullable=1 is_null=1 */
            ###   @11=NULL /* VARSTRING(570) meta=570 nullable=1 is_null=1 */
            ###   @12='0' /* VARSTRING(3) meta=3 nullable=1 is_null=0 */
            ###   @13='0' /* VARSTRING(3) meta=3 nullable=1 is_null=0 */
            # at 567713641
            #190411 21:32:40 server id 16823342  end_log_pos 567713380      Xid = 4020831576
            COMMIT/*!*/;
            # at 567713668
            #190411 21:32:40 server id 16823342  end_log_pos 567713420      GTID 0-16823342-307546140 cid=4020831580 trans
            /*!100001 SET @@session.gtid_seq_no=307546140*//*!*/;
            BEGIN
            /*!*/;
            # at 567713708
            #190411 21:32:40 server id 16823342  end_log_pos 567713519      Table_map: `business_job`.`QRTZ_FIRED_TRIGGERS` mapped to number 21
            # at 567713807
            

            ruochen wy added a comment - - edited Yesterday case(20190411): 1)Slave show slave status info in 20190411.png image file. 2)Slave error log 2019 - 04 - 11 21 : 32 : 40 139825027365632 [ERROR] Slave SQL: Error during XID COMMIT: failed to update GTID state in mysql.gtid_slave_pos: 1062 : Duplicate entry '0-153773074' for key 'PRIMARY' , Gtid 0 - 16823342 - 307546139 , Internal MariaDB error code: 1942 2019 - 04 - 11 21 : 32 : 40 139825027365632 [ERROR] Slave (additional info): Duplicate entry '0-153773074' for key 'PRIMARY' Error_code: 1062 2019 - 04 - 11 21 : 32 : 40 139825027365632 [Warning] Slave: Duplicate entry '0-153773074' for key 'PRIMARY' Error_code: 1062 2019 - 04 - 11 21 : 32 : 40 139825027365632 [ERROR] Error running query, slave SQL thread aborted. Fix the problem, and restart the slave SQL thread with "SLAVE START" . We stopped at log 'mysql-bin.000159' position 567712572 2019 - 04 - 11 21 : 32 : 40 139823896505088 [Note] Error reading relay log event: slave SQL thread was killed 2019 - 04 - 11 21 : 32 : 40 139823896505088 [Note] Slave SQL thread exiting, replication stopped in log 'mysql-bin.000159' at position 567712572 3)Master binglog events # at 567710582 # 190411 21 : 32 : 39 server id 16823342 end_log_pos 567710609 Xid = 4020831567 COMMIT /*!*/ ; # at 567710609 # 190411 21 : 32 : 39 server id 16823342 end_log_pos 567710647 GTID 0 - 16823342 - 307546137 trans /*!100001 SET @@session.gtid_seq_no=307546137*/ /*!*/ ; BEGIN /*!*/ ; # at 567710647 # 190411 21 : 32 : 39 server id 16823342 end_log_pos 567710746 Table_map: `business_job`.`QRTZ_FIRED_TRIGGERS` mapped to number 21 # at 567710746 # 190411 21 : 32 : 39 server id 16823342 end_log_pos 567711181 Update_rows: table id 21 flags: STMT_END_F ### UPDATE `business_job`.`QRTZ_FIRED_TRIGGERS` ### WHERE ### @1 = 'BRAND-SCHEDULE' /* VARSTRING(360) meta=360 nullable=0 is_null=0 */ ### @2 = 'brand-adp-70471-55b755f695-hx74l15547991982031554799219162' /* VARSTRING(285) meta=285 nullable=0 is_null=0 */ ### @3 = 'CptOrderStatusJobTrigger' /* VARSTRING(570) meta=570 nullable=0 is_null=0 */ ### @4 = 'cpt' /* VARSTRING(570) meta=570 nullable=0 is_null=0 */ ### @5 = 'brand-adp-70471-55b755f695-hx74l1554799198203' /* VARSTRING(570) meta=570 nullable=0 is_null=0 */ ### @6 = 1554989557277 /* LONGINT meta=0 nullable=0 is_null=0 */ ### @7 = 1554989560000 /* LONGINT meta=0 nullable=0 is_null=0 */ ### @8 = 5 /* INT meta=0 nullable=0 is_null=0 */ ### @9 = 'ACQUIRED' /* VARSTRING(48) meta=48 nullable=0 is_null=0 */ ### @10 =NULL /* VARSTRING(570) meta=570 nullable=1 is_null=1 */ ### @11 =NULL /* VARSTRING(570) meta=570 nullable=1 is_null=1 */ ### @12 = '0' /* VARSTRING(3) meta=3 nullable=1 is_null=0 */ ### @13 = '0' /* VARSTRING(3) meta=3 nullable=1 is_null=0 */ ### SET ### @1 = 'BRAND-SCHEDULE' /* VARSTRING(360) meta=360 nullable=0 is_null=0 */ ### @2 = 'brand-adp-70471-55b755f695-hx74l15547991982031554799219162' /* VARSTRING(285) meta=285 nullable=0 is_null=0 */ ### @3 = 'CptOrderStatusJobTrigger' /* VARSTRING(570) meta=570 nullable=0 is_null=0 */ ### @4 = 'cpt' /* VARSTRING(570) meta=570 nullable=0 is_null=0 */ ### @5 = 'brand-adp-70471-55b755f695-hx74l1554799198203' /* VARSTRING(570) meta=570 nullable=0 is_null=0 */ ### @6 = 1554989560001 /* LONGINT meta=0 nullable=0 is_null=0 */ ### @7 = 1554989560000 /* LONGINT meta=0 nullable=0 is_null=0 */ ### @8 = 5 /* INT meta=0 nullable=0 is_null=0 */ ### @9 = 'EXECUTING' /* VARSTRING(48) meta=48 nullable=0 is_null=0 */ ### @10 = 'CptOrderStatusJob' /* VARSTRING(570) meta=570 nullable=1 is_null=0 */ ### @11 = 'cpt' /* VARSTRING(570) meta=570 nullable=1 is_null=0 */ ### @12 = '0' /* VARSTRING(3) meta=3 nullable=1 is_null=0 */ ### @13 = '1' /* VARSTRING(3) meta=3 nullable=1 is_null=0 */ # at 567711181 # 190411 21 : 32 : 39 server id 16823342 end_log_pos 567711276 Table_map: `business_job`.`QRTZ_TRIGGERS` mapped to number 43 # at 567711276 # 190411 21 : 32 : 39 server id 16823342 end_log_pos 567711561 Update_rows: table id 43 flags: STMT_END_F ### UPDATE `business_job`.`QRTZ_TRIGGERS` ### WHERE ### @1 = 'BRAND-SCHEDULE' /* VARSTRING(360) meta=360 nullable=0 is_null=0 */ ### @2 = 'CptOrderStatusJobTrigger' /* VARSTRING(570) meta=570 nullable=0 is_null=0 */ ### @3 = 'cpt' /* VARSTRING(570) meta=570 nullable=0 is_null=0 */ ### @4 = 'CptOrderStatusJob' /* VARSTRING(570) meta=570 nullable=0 is_null=0 */ ### @5 = 'cpt' /* VARSTRING(570) meta=570 nullable=0 is_null=0 */ ### @6 =NULL /* VARSTRING(750) meta=750 nullable=1 is_null=1 */ ### @7 = 1554989560000 /* LONGINT meta=0 nullable=1 is_null=0 */ ### @8 = 1554989550000 /* LONGINT meta=0 nullable=1 is_null=0 */ ### @9 = 5 /* INT meta=0 nullable=1 is_null=0 */ ### @10 = 'ACQUIRED' /* VARSTRING(48) meta=48 nullable=0 is_null=0 */ ### @11 = 'CRON' /* VARSTRING(24) meta=24 nullable=0 is_null=0 */ ### @12 = 1554799338000 /* LONGINT meta=0 nullable=0 is_null=0 */ ### @13 = 0 /* LONGINT meta=0 nullable=1 is_null=0 */ ### @14 =NULL /* VARSTRING(570) meta=570 nullable=1 is_null=1 */ ### @15 = 2 /* SHORTINT meta=0 nullable=1 is_null=0 */ ### @16 = '' /* BLOB/TEXT meta=2 nullable=1 is_null=0 */ ### SET ### @1 = 'BRAND-SCHEDULE' /* VARSTRING(360) meta=360 nullable=0 is_null=0 */ ### @2 = 'CptOrderStatusJobTrigger' /* VARSTRING(570) meta=570 nullable=0 is_null=0 */ ### @3 = 'cpt' /* VARSTRING(570) meta=570 nullable=0 is_null=0 */ ### @4 = 'CptOrderStatusJob' /* VARSTRING(570) meta=570 nullable=0 is_null=0 */ ### @5 = 'cpt' /* VARSTRING(570) meta=570 nullable=0 is_null=0 */ ### @6 =NULL /* VARSTRING(750) meta=750 nullable=1 is_null=1 */ ### @7 = 1554989570000 /* LONGINT meta=0 nullable=1 is_null=0 */ ### @8 = 1554989560000 /* LONGINT meta=0 nullable=1 is_null=0 */ ### @9 = 5 /* INT meta=0 nullable=1 is_null=0 */ ### @10 = 'WAITING' /* VARSTRING(48) meta=48 nullable=0 is_null=0 */ ### @11 = 'CRON' /* VARSTRING(24) meta=24 nullable=0 is_null=0 */ ### @12 = 1554799338000 /* LONGINT meta=0 nullable=0 is_null=0 */ ### @13 = 0 /* LONGINT meta=0 nullable=1 is_null=0 */ ### @14 =NULL /* VARSTRING(570) meta=570 nullable=1 is_null=1 */ ### @15 = 2 /* SHORTINT meta=0 nullable=1 is_null=0 */ ### @16 = '' /* BLOB/TEXT meta=2 nullable=1 is_null=0 */ # at 567711561 # 190411 21 : 32 : 39 server id 16823342 end_log_pos 567711588 Xid = 4020831570 COMMIT /*!*/ ; # at 567711588 # 190411 21 : 32 : 40 server id 16823342 end_log_pos 567711626 GTID 0 - 16823342 - 307546138 trans /*!100001 SET @@session.gtid_seq_no=307546138*/ /*!*/ ; BEGIN /*!*/ ; # at 567711626 # 190411 21 : 32 : 40 server id 16823342 end_log_pos 567711725 Table_map: `business_job`.`QRTZ_FIRED_TRIGGERS` mapped to number 21 # at 567711725 # 190411 21 : 32 : 40 server id 16823342 end_log_pos 567712163 Update_rows: table id 21 flags: STMT_END_F ### UPDATE `business_job`.`QRTZ_FIRED_TRIGGERS` ### WHERE ### @1 = 'CRM-SCHEDULE' /* VARSTRING(360) meta=360 nullable=0 is_null=0 */ ### @2 = 'crm-portal-70806-5b4497f759-jmzcx15548887805081554888807633' /* VARSTRING(285) meta=285 nullable=0 is_null=0 */ ### @3 = 'ReWaitOrderTrigger' /* VARSTRING(570) meta=570 nullable=0 is_null=0 */ ### @4 = 'crm-order' /* VARSTRING(570) meta=570 nullable=0 is_null=0 */ ### @5 = 'crm-portal-70806-5b4497f759-jmzcx1554888780508' /* VARSTRING(570) meta=570 nullable=0 is_null=0 */ ### @6 = 1554989550138 /* LONGINT meta=0 nullable=0 is_null=0 */ ### @7 = 1554989560000 /* LONGINT meta=0 nullable=0 is_null=0 */ ### @8 = 5 /* INT meta=0 nullable=0 is_null=0 */ ### @9 = 'ACQUIRED' /* VARSTRING(48) meta=48 nullable=0 is_null=0 */ ### @10 =NULL /* VARSTRING(570) meta=570 nullable=1 is_null=1 */ ### @11 =NULL /* VARSTRING(570) meta=570 nullable=1 is_null=1 */ ### @12 = '0' /* VARSTRING(3) meta=3 nullable=1 is_null=0 */ ### @13 = '0' /* VARSTRING(3) meta=3 nullable=1 is_null=0 */ ### SET ### @1 = 'CRM-SCHEDULE' /* VARSTRING(360) meta=360 nullable=0 is_null=0 */ ### @2 = 'crm-portal-70806-5b4497f759-jmzcx15548887805081554888807633' /* VARSTRING(285) meta=285 nullable=0 is_null=0 */ ### @3 = 'ReWaitOrderTrigger' /* VARSTRING(570) meta=570 nullable=0 is_null=0 */ ### @4 = 'crm-order' /* VARSTRING(570) meta=570 nullable=0 is_null=0 */ ### @5 = 'crm-portal-70806-5b4497f759-jmzcx1554888780508' /* VARSTRING(570) meta=570 nullable=0 is_null=0 */ ### @6 = 1554989560002 /* LONGINT meta=0 nullable=0 is_null=0 */ ### @7 = 1554989560000 /* LONGINT meta=0 nullable=0 is_null=0 */ ### @8 = 5 /* INT meta=0 nullable=0 is_null=0 */ ### @9 = 'EXECUTING' /* VARSTRING(48) meta=48 nullable=0 is_null=0 */ ### @10 = 'ReWaitOrderJob' /* VARSTRING(570) meta=570 nullable=1 is_null=0 */ ### @11 = 'crm-order' /* VARSTRING(570) meta=570 nullable=1 is_null=0 */ ### @12 = '0' /* VARSTRING(3) meta=3 nullable=1 is_null=0 */ ### @13 = '1' /* VARSTRING(3) meta=3 nullable=1 is_null=0 */ # at 567712163 # 190411 21 : 32 : 40 server id 16823342 end_log_pos 567712258 Table_map: `business_job`.`QRTZ_TRIGGERS` mapped to number 43 # at 567712258 # 190411 21 : 32 : 40 server id 16823342 end_log_pos 567712545 Update_rows: table id 43 flags: STMT_END_F ### UPDATE `business_job`.`QRTZ_TRIGGERS` ### WHERE ### @1 = 'CRM-SCHEDULE' /* VARSTRING(360) meta=360 nullable=0 is_null=0 */ ### @2 = 'ReWaitOrderTrigger' /* VARSTRING(570) meta=570 nullable=0 is_null=0 */ ### @3 = 'crm-order' /* VARSTRING(570) meta=570 nullable=0 is_null=0 */ ### @4 = 'ReWaitOrderJob' /* VARSTRING(570) meta=570 nullable=0 is_null=0 */ ### @5 = 'crm-order' /* VARSTRING(570) meta=570 nullable=0 is_null=0 */ ### @6 =NULL /* VARSTRING(750) meta=750 nullable=1 is_null=1 */ ### @7 = 1554989560000 /* LONGINT meta=0 nullable=1 is_null=0 */ ### @8 = 1554989550000 /* LONGINT meta=0 nullable=1 is_null=0 */ ### @9 = 5 /* INT meta=0 nullable=1 is_null=0 */ ### @10 = 'ACQUIRED' /* VARSTRING(48) meta=48 nullable=0 is_null=0 */ ### @11 = 'CRON' /* VARSTRING(24) meta=24 nullable=0 is_null=0 */ ### @12 = 1554894168000 /* LONGINT meta=0 nullable=0 is_null=0 */ ### @13 = 0 /* LONGINT meta=0 nullable=1 is_null=0 */ ### @14 =NULL /* VARSTRING(570) meta=570 nullable=1 is_null=1 */ ### @15 = 2 /* SHORTINT meta=0 nullable=1 is_null=0 */ ### @16 = '' /* BLOB/TEXT meta=2 nullable=1 is_null=0 */ ### SET ### @1 = 'CRM-SCHEDULE' /* VARSTRING(360) meta=360 nullable=0 is_null=0 */ ### @2 = 'ReWaitOrderTrigger' /* VARSTRING(570) meta=570 nullable=0 is_null=0 */ ### @3 = 'crm-order' /* VARSTRING(570) meta=570 nullable=0 is_null=0 */ ### @4 = 'ReWaitOrderJob' /* VARSTRING(570) meta=570 nullable=0 is_null=0 */ ### @5 = 'crm-order' /* VARSTRING(570) meta=570 nullable=0 is_null=0 */ ### @6 =NULL /* VARSTRING(750) meta=750 nullable=1 is_null=1 */ ### @7 = 1554989570000 /* LONGINT meta=0 nullable=1 is_null=0 */ ### @8 = 1554989560000 /* LONGINT meta=0 nullable=1 is_null=0 */ ### @9 = 5 /* INT meta=0 nullable=1 is_null=0 */ ### @10 = 'WAITING' /* VARSTRING(48) meta=48 nullable=0 is_null=0 */ ### @11 = 'CRON' /* VARSTRING(24) meta=24 nullable=0 is_null=0 */ ### @12 = 1554894168000 /* LONGINT meta=0 nullable=0 is_null=0 */ ### @13 = 0 /* LONGINT meta=0 nullable=1 is_null=0 */ ### @14 =NULL /* VARSTRING(570) meta=570 nullable=1 is_null=1 */ ### @15 = 2 /* SHORTINT meta=0 nullable=1 is_null=0 */ ### @16 = '' /* BLOB/TEXT meta=2 nullable=1 is_null=0 */ # at 567712545 # 190411 21 : 32 : 40 server id 16823342 end_log_pos 567712572 Xid = 4020831573 COMMIT /*!*/ ; # at 567712572 # 190411 21 : 32 : 40 server id 16823342 end_log_pos 567712610 GTID 0 - 16823342 - 307546139 trans /*!100001 SET @@session.gtid_seq_no=307546139*/ /*!*/ ; BEGIN /*!*/ ; # at 567712610 # 190411 21 : 32 : 39 server id 16823342 end_log_pos 567712705 Table_map: `business_job`.`QRTZ_TRIGGERS` mapped to number 43 # at 567712705 # 190411 21 : 32 : 39 server id 16823342 end_log_pos 567713026 Update_rows: table id 43 flags: STMT_END_F ### UPDATE `business_job`.`QRTZ_TRIGGERS` ### WHERE ### @1 = 'BRAND-SCHEDULE' /* VARSTRING(360) meta=360 nullable=0 is_null=0 */ ### @2 = 'AdoptOrderByCrmJobTrigger' /* VARSTRING(570) meta=570 nullable=0 is_null=0 */ ### @3 = 'brand-order' /* VARSTRING(570) meta=570 nullable=0 is_null=0 */ ### @4 = 'AdoptOrderByCrmJob' /* VARSTRING(570) meta=570 nullable=0 is_null=0 */ ### @5 = 'brand-order' /* VARSTRING(570) meta=570 nullable=0 is_null=0 */ ### @6 =NULL /* VARSTRING(750) meta=750 nullable=1 is_null=1 */ ### @7 = 1554989560000 /* LONGINT meta=0 nullable=1 is_null=0 */ ### @8 = 1554989550000 /* LONGINT meta=0 nullable=1 is_null=0 */ ### @9 = 5 /* INT meta=0 nullable=1 is_null=0 */ ### @10 = 'WAITING' /* VARSTRING(48) meta=48 nullable=0 is_null=0 */ ### @11 = 'CRON' /* VARSTRING(24) meta=24 nullable=0 is_null=0 */ ### @12 = 1554799338000 /* LONGINT meta=0 nullable=0 is_null=0 */ ### @13 = 0 /* LONGINT meta=0 nullable=1 is_null=0 */ ### @14 =NULL /* VARSTRING(570) meta=570 nullable=1 is_null=1 */ ### @15 = 2 /* SHORTINT meta=0 nullable=1 is_null=0 */ ### @16 = '' /* BLOB/TEXT meta=2 nullable=1 is_null=0 */ ### SET ### @1 = 'BRAND-SCHEDULE' /* VARSTRING(360) meta=360 nullable=0 is_null=0 */ ### @2 = 'AdoptOrderByCrmJobTrigger' /* VARSTRING(570) meta=570 nullable=0 is_null=0 */ ### @3 = 'brand-order' /* VARSTRING(570) meta=570 nullable=0 is_null=0 */ ### @4 = 'AdoptOrderByCrmJob' /* VARSTRING(570) meta=570 nullable=0 is_null=0 */ ### @5 = 'brand-order' /* VARSTRING(570) meta=570 nullable=0 is_null=0 */ ### @6 =NULL /* VARSTRING(750) meta=750 nullable=1 is_null=1 */ ### @7 = 1554989560000 /* LONGINT meta=0 nullable=1 is_null=0 */ ### @8 = 1554989550000 /* LONGINT meta=0 nullable=1 is_null=0 */ ### @9 = 5 /* INT meta=0 nullable=1 is_null=0 */ ### @10 = 'ACQUIRED' /* VARSTRING(48) meta=48 nullable=0 is_null=0 */ ### @11 = 'CRON' /* VARSTRING(24) meta=24 nullable=0 is_null=0 */ ### @12 = 1554799338000 /* LONGINT meta=0 nullable=0 is_null=0 */ ### @13 = 0 /* LONGINT meta=0 nullable=1 is_null=0 */ ### @14 =NULL /* VARSTRING(570) meta=570 nullable=1 is_null=1 */ ### @15 = 2 /* SHORTINT meta=0 nullable=1 is_null=0 */ ### @16 = '' /* BLOB/TEXT meta=2 nullable=1 is_null=0 */ # at 567713026 # 190411 21 : 32 : 40 server id 16823342 end_log_pos 567713125 Table_map: `business_job`.`QRTZ_FIRED_TRIGGERS` mapped to number 21 # at 567713125 # 190411 21 : 32 : 40 server id 16823342 end_log_pos 567713353 Write_rows: table id 21 flags: STMT_END_F ### INSERT INTO `business_job`.`QRTZ_FIRED_TRIGGERS` ### SET ### @1 = 'BRAND-SCHEDULE' /* VARSTRING(360) meta=360 nullable=0 is_null=0 */ ### @2 = 'brand-adp-70471-55b755f695-hx74l15547991982031554799219163' /* VARSTRING(285) meta=285 nullable=0 is_null=0 */ ### @3 = 'AdoptOrderByCrmJobTrigger' /* VARSTRING(570) meta=570 nullable=0 is_null=0 */ ### @4 = 'brand-order' /* VARSTRING(570) meta=570 nullable=0 is_null=0 */ ### @5 = 'brand-adp-70471-55b755f695-hx74l1554799198203' /* VARSTRING(570) meta=570 nullable=0 is_null=0 */ ### @6 = 1554989560014 /* LONGINT meta=0 nullable=0 is_null=0 */ ### @7 = 1554989560000 /* LONGINT meta=0 nullable=0 is_null=0 */ ### @8 = 5 /* INT meta=0 nullable=0 is_null=0 */ ### @9 = 'ACQUIRED' /* VARSTRING(48) meta=48 nullable=0 is_null=0 */ ### @10 =NULL /* VARSTRING(570) meta=570 nullable=1 is_null=1 */ ### @11 =NULL /* VARSTRING(570) meta=570 nullable=1 is_null=1 */ ### @12 = '0' /* VARSTRING(3) meta=3 nullable=1 is_null=0 */ ### @13 = '0' /* VARSTRING(3) meta=3 nullable=1 is_null=0 */ # at 567713353 # 190411 21 : 32 : 40 server id 16823342 end_log_pos 567713380 Xid = 4020831576 COMMIT /*!*/ ; # at 567713380 # 190411 21 : 32 : 40 server id 16823342 end_log_pos 567713420 GTID 0 - 16823342 - 307546140 cid= 4020831580 trans /*!100001 SET @@session.gtid_seq_no=307546140*/ /*!*/ ; BEGIN /*!*/ ; # at 567713420 # 190411 21 : 32 : 40 server id 16823342 end_log_pos 567713519 Table_map: `business_job`.`QRTZ_FIRED_TRIGGERS` mapped to number 21 # at 567713519 4)Slave relaylog events # at 567710870 # 190411 21 : 32 : 39 server id 16823342 end_log_pos 567710609 Xid = 4020831567 COMMIT /*!*/ ; # at 567710897 # 190411 21 : 32 : 39 server id 16823342 end_log_pos 567710647 GTID 0 - 16823342 - 307546137 trans /*!100001 SET @@session.gtid_seq_no=307546137*/ /*!*/ ; BEGIN /*!*/ ; # at 567710935 # 190411 21 : 32 : 39 server id 16823342 end_log_pos 567710746 Table_map: `business_job`.`QRTZ_FIRED_TRIGGERS` mapped to number 21 # at 567711034 # 190411 21 : 32 : 39 server id 16823342 end_log_pos 567711181 Update_rows: table id 21 flags: STMT_END_F ### UPDATE `business_job`.`QRTZ_FIRED_TRIGGERS` ### WHERE ### @1 = 'BRAND-SCHEDULE' /* VARSTRING(360) meta=360 nullable=0 is_null=0 */ ### @2 = 'brand-adp-70471-55b755f695-hx74l15547991982031554799219162' /* VARSTRING(285) meta=285 nullable=0 is_null=0 */ ### @3 = 'CptOrderStatusJobTrigger' /* VARSTRING(570) meta=570 nullable=0 is_null=0 */ ### @4 = 'cpt' /* VARSTRING(570) meta=570 nullable=0 is_null=0 */ ### @5 = 'brand-adp-70471-55b755f695-hx74l1554799198203' /* VARSTRING(570) meta=570 nullable=0 is_null=0 */ ### @6 = 1554989557277 /* LONGINT meta=0 nullable=0 is_null=0 */ ### @7 = 1554989560000 /* LONGINT meta=0 nullable=0 is_null=0 */ ### @8 = 5 /* INT meta=0 nullable=0 is_null=0 */ ### @9 = 'ACQUIRED' /* VARSTRING(48) meta=48 nullable=0 is_null=0 */ ### @10 =NULL /* VARSTRING(570) meta=570 nullable=1 is_null=1 */ ### @11 =NULL /* VARSTRING(570) meta=570 nullable=1 is_null=1 */ ### @12 = '0' /* VARSTRING(3) meta=3 nullable=1 is_null=0 */ ### @13 = '0' /* VARSTRING(3) meta=3 nullable=1 is_null=0 */ ### SET ### @1 = 'BRAND-SCHEDULE' /* VARSTRING(360) meta=360 nullable=0 is_null=0 */ ### @2 = 'brand-adp-70471-55b755f695-hx74l15547991982031554799219162' /* VARSTRING(285) meta=285 nullable=0 is_null=0 */ ### @3 = 'CptOrderStatusJobTrigger' /* VARSTRING(570) meta=570 nullable=0 is_null=0 */ ### @4 = 'cpt' /* VARSTRING(570) meta=570 nullable=0 is_null=0 */ ### @5 = 'brand-adp-70471-55b755f695-hx74l1554799198203' /* VARSTRING(570) meta=570 nullable=0 is_null=0 */ ### @6 = 1554989560001 /* LONGINT meta=0 nullable=0 is_null=0 */ ### @7 = 1554989560000 /* LONGINT meta=0 nullable=0 is_null=0 */ ### @8 = 5 /* INT meta=0 nullable=0 is_null=0 */ ### @9 = 'EXECUTING' /* VARSTRING(48) meta=48 nullable=0 is_null=0 */ ### @10 = 'CptOrderStatusJob' /* VARSTRING(570) meta=570 nullable=1 is_null=0 */ ### @11 = 'cpt' /* VARSTRING(570) meta=570 nullable=1 is_null=0 */ ### @12 = '0' /* VARSTRING(3) meta=3 nullable=1 is_null=0 */ ### @13 = '1' /* VARSTRING(3) meta=3 nullable=1 is_null=0 */ # at 567711469 # 190411 21 : 32 : 39 server id 16823342 end_log_pos 567711276 Table_map: `business_job`.`QRTZ_TRIGGERS` mapped to number 43 # at 567711564 # 190411 21 : 32 : 39 server id 16823342 end_log_pos 567711561 Update_rows: table id 43 flags: STMT_END_F ### UPDATE `business_job`.`QRTZ_TRIGGERS` ### WHERE ### @1 = 'BRAND-SCHEDULE' /* VARSTRING(360) meta=360 nullable=0 is_null=0 */ ### @2 = 'CptOrderStatusJobTrigger' /* VARSTRING(570) meta=570 nullable=0 is_null=0 */ ### @3 = 'cpt' /* VARSTRING(570) meta=570 nullable=0 is_null=0 */ ### @4 = 'CptOrderStatusJob' /* VARSTRING(570) meta=570 nullable=0 is_null=0 */ ### @5 = 'cpt' /* VARSTRING(570) meta=570 nullable=0 is_null=0 */ ### @6 =NULL /* VARSTRING(750) meta=750 nullable=1 is_null=1 */ ### @7 = 1554989560000 /* LONGINT meta=0 nullable=1 is_null=0 */ ### @8 = 1554989550000 /* LONGINT meta=0 nullable=1 is_null=0 */ ### @9 = 5 /* INT meta=0 nullable=1 is_null=0 */ ### @10 = 'ACQUIRED' /* VARSTRING(48) meta=48 nullable=0 is_null=0 */ ### @11 = 'CRON' /* VARSTRING(24) meta=24 nullable=0 is_null=0 */ ### @12 = 1554799338000 /* LONGINT meta=0 nullable=0 is_null=0 */ ### @13 = 0 /* LONGINT meta=0 nullable=1 is_null=0 */ ### @14 =NULL /* VARSTRING(570) meta=570 nullable=1 is_null=1 */ ### @15 = 2 /* SHORTINT meta=0 nullable=1 is_null=0 */ ### @16 = '' /* BLOB/TEXT meta=2 nullable=1 is_null=0 */ ### SET ### @1 = 'BRAND-SCHEDULE' /* VARSTRING(360) meta=360 nullable=0 is_null=0 */ ### @2 = 'CptOrderStatusJobTrigger' /* VARSTRING(570) meta=570 nullable=0 is_null=0 */ ### @3 = 'cpt' /* VARSTRING(570) meta=570 nullable=0 is_null=0 */ ### @4 = 'CptOrderStatusJob' /* VARSTRING(570) meta=570 nullable=0 is_null=0 */ ### @5 = 'cpt' /* VARSTRING(570) meta=570 nullable=0 is_null=0 */ ### @6 =NULL /* VARSTRING(750) meta=750 nullable=1 is_null=1 */ ### @7 = 1554989570000 /* LONGINT meta=0 nullable=1 is_null=0 */ ### @8 = 1554989560000 /* LONGINT meta=0 nullable=1 is_null=0 */ ### @9 = 5 /* INT meta=0 nullable=1 is_null=0 */ ### @10 = 'WAITING' /* VARSTRING(48) meta=48 nullable=0 is_null=0 */ ### @11 = 'CRON' /* VARSTRING(24) meta=24 nullable=0 is_null=0 */ ### @12 = 1554799338000 /* LONGINT meta=0 nullable=0 is_null=0 */ ### @13 = 0 /* LONGINT meta=0 nullable=1 is_null=0 */ ### @14 =NULL /* VARSTRING(570) meta=570 nullable=1 is_null=1 */ ### @15 = 2 /* SHORTINT meta=0 nullable=1 is_null=0 */ ### @16 = '' /* BLOB/TEXT meta=2 nullable=1 is_null=0 */ # at 567711849 # 190411 21 : 32 : 39 server id 16823342 end_log_pos 567711588 Xid = 4020831570 COMMIT /*!*/ ; # at 567711876 # 190411 21 : 32 : 40 server id 16823342 end_log_pos 567711626 GTID 0 - 16823342 - 307546138 trans /*!100001 SET @@session.gtid_seq_no=307546138*/ /*!*/ ; BEGIN /*!*/ ; # at 567711914 # 190411 21 : 32 : 40 server id 16823342 end_log_pos 567711725 Table_map: `business_job`.`QRTZ_FIRED_TRIGGERS` mapped to number 21 # at 567712013 # 190411 21 : 32 : 40 server id 16823342 end_log_pos 567712163 Update_rows: table id 21 flags: STMT_END_F ### UPDATE `business_job`.`QRTZ_FIRED_TRIGGERS` ### WHERE ### @1 = 'CRM-SCHEDULE' /* VARSTRING(360) meta=360 nullable=0 is_null=0 */ ### @2 = 'crm-portal-70806-5b4497f759-jmzcx15548887805081554888807633' /* VARSTRING(285) meta=285 nullable=0 is_null=0 */ ### @3 = 'ReWaitOrderTrigger' /* VARSTRING(570) meta=570 nullable=0 is_null=0 */ ### @4 = 'crm-order' /* VARSTRING(570) meta=570 nullable=0 is_null=0 */ ### @5 = 'crm-portal-70806-5b4497f759-jmzcx1554888780508' /* VARSTRING(570) meta=570 nullable=0 is_null=0 */ ### @6 = 1554989550138 /* LONGINT meta=0 nullable=0 is_null=0 */ ### @7 = 1554989560000 /* LONGINT meta=0 nullable=0 is_null=0 */ ### @8 = 5 /* INT meta=0 nullable=0 is_null=0 */ ### @9 = 'ACQUIRED' /* VARSTRING(48) meta=48 nullable=0 is_null=0 */ ### @10 =NULL /* VARSTRING(570) meta=570 nullable=1 is_null=1 */ ### @11 =NULL /* VARSTRING(570) meta=570 nullable=1 is_null=1 */ ### @12 = '0' /* VARSTRING(3) meta=3 nullable=1 is_null=0 */ ### @13 = '0' /* VARSTRING(3) meta=3 nullable=1 is_null=0 */ ### SET ### @1 = 'CRM-SCHEDULE' /* VARSTRING(360) meta=360 nullable=0 is_null=0 */ ### @2 = 'crm-portal-70806-5b4497f759-jmzcx15548887805081554888807633' /* VARSTRING(285) meta=285 nullable=0 is_null=0 */ ### @3 = 'ReWaitOrderTrigger' /* VARSTRING(570) meta=570 nullable=0 is_null=0 */ ### @4 = 'crm-order' /* VARSTRING(570) meta=570 nullable=0 is_null=0 */ ### @5 = 'crm-portal-70806-5b4497f759-jmzcx1554888780508' /* VARSTRING(570) meta=570 nullable=0 is_null=0 */ ### @6 = 1554989560002 /* LONGINT meta=0 nullable=0 is_null=0 */ ### @7 = 1554989560000 /* LONGINT meta=0 nullable=0 is_null=0 */ ### @8 = 5 /* INT meta=0 nullable=0 is_null=0 */ ### @9 = 'EXECUTING' /* VARSTRING(48) meta=48 nullable=0 is_null=0 */ ### @10 = 'ReWaitOrderJob' /* VARSTRING(570) meta=570 nullable=1 is_null=0 */ ### @11 = 'crm-order' /* VARSTRING(570) meta=570 nullable=1 is_null=0 */ ### @12 = '0' /* VARSTRING(3) meta=3 nullable=1 is_null=0 */ ### @13 = '1' /* VARSTRING(3) meta=3 nullable=1 is_null=0 */ # at 567712451 # 190411 21 : 32 : 40 server id 16823342 end_log_pos 567712258 Table_map: `business_job`.`QRTZ_TRIGGERS` mapped to number 43 # at 567712546 # 190411 21 : 32 : 40 server id 16823342 end_log_pos 567712545 Update_rows: table id 43 flags: STMT_END_F ### UPDATE `business_job`.`QRTZ_TRIGGERS` ### WHERE ### @1 = 'CRM-SCHEDULE' /* VARSTRING(360) meta=360 nullable=0 is_null=0 */ ### @2 = 'ReWaitOrderTrigger' /* VARSTRING(570) meta=570 nullable=0 is_null=0 */ ### @3 = 'crm-order' /* VARSTRING(570) meta=570 nullable=0 is_null=0 */ ### @4 = 'ReWaitOrderJob' /* VARSTRING(570) meta=570 nullable=0 is_null=0 */ ### @5 = 'crm-order' /* VARSTRING(570) meta=570 nullable=0 is_null=0 */ ### @6 =NULL /* VARSTRING(750) meta=750 nullable=1 is_null=1 */ ### @7 = 1554989560000 /* LONGINT meta=0 nullable=1 is_null=0 */ ### @8 = 1554989550000 /* LONGINT meta=0 nullable=1 is_null=0 */ ### @9 = 5 /* INT meta=0 nullable=1 is_null=0 */ ### @10 = 'ACQUIRED' /* VARSTRING(48) meta=48 nullable=0 is_null=0 */ ### @11 = 'CRON' /* VARSTRING(24) meta=24 nullable=0 is_null=0 */ ### @12 = 1554894168000 /* LONGINT meta=0 nullable=0 is_null=0 */ ### @13 = 0 /* LONGINT meta=0 nullable=1 is_null=0 */ ### @14 =NULL /* VARSTRING(570) meta=570 nullable=1 is_null=1 */ ### @15 = 2 /* SHORTINT meta=0 nullable=1 is_null=0 */ ### @16 = '' /* BLOB/TEXT meta=2 nullable=1 is_null=0 */ ### SET ### @1 = 'CRM-SCHEDULE' /* VARSTRING(360) meta=360 nullable=0 is_null=0 */ ### @2 = 'ReWaitOrderTrigger' /* VARSTRING(570) meta=570 nullable=0 is_null=0 */ ### @3 = 'crm-order' /* VARSTRING(570) meta=570 nullable=0 is_null=0 */ ### @4 = 'ReWaitOrderJob' /* VARSTRING(570) meta=570 nullable=0 is_null=0 */ ### @5 = 'crm-order' /* VARSTRING(570) meta=570 nullable=0 is_null=0 */ ### @6 =NULL /* VARSTRING(750) meta=750 nullable=1 is_null=1 */ ### @7 = 1554989570000 /* LONGINT meta=0 nullable=1 is_null=0 */ ### @8 = 1554989560000 /* LONGINT meta=0 nullable=1 is_null=0 */ ### @9 = 5 /* INT meta=0 nullable=1 is_null=0 */ ### @10 = 'WAITING' /* VARSTRING(48) meta=48 nullable=0 is_null=0 */ ### @11 = 'CRON' /* VARSTRING(24) meta=24 nullable=0 is_null=0 */ ### @12 = 1554894168000 /* LONGINT meta=0 nullable=0 is_null=0 */ ### @13 = 0 /* LONGINT meta=0 nullable=1 is_null=0 */ ### @14 =NULL /* VARSTRING(570) meta=570 nullable=1 is_null=1 */ ### @15 = 2 /* SHORTINT meta=0 nullable=1 is_null=0 */ ### @16 = '' /* BLOB/TEXT meta=2 nullable=1 is_null=0 */ # at 567712833 # 190411 21 : 32 : 40 server id 16823342 end_log_pos 567712572 Xid = 4020831573 COMMIT /*!*/ ; # at 567712860 # 190411 21 : 32 : 40 server id 16823342 end_log_pos 567712610 GTID 0 - 16823342 - 307546139 trans /*!100001 SET @@session.gtid_seq_no=307546139*/ /*!*/ ; BEGIN /*!*/ ; # at 567712898 # 190411 21 : 32 : 39 server id 16823342 end_log_pos 567712705 Table_map: `business_job`.`QRTZ_TRIGGERS` mapped to number 43 # at 567712993 # 190411 21 : 32 : 39 server id 16823342 end_log_pos 567713026 Update_rows: table id 43 flags: STMT_END_F ### UPDATE `business_job`.`QRTZ_TRIGGERS` ### WHERE ### @1 = 'BRAND-SCHEDULE' /* VARSTRING(360) meta=360 nullable=0 is_null=0 */ ### @2 = 'AdoptOrderByCrmJobTrigger' /* VARSTRING(570) meta=570 nullable=0 is_null=0 */ ### @3 = 'brand-order' /* VARSTRING(570) meta=570 nullable=0 is_null=0 */ ### @4 = 'AdoptOrderByCrmJob' /* VARSTRING(570) meta=570 nullable=0 is_null=0 */ ### @5 = 'brand-order' /* VARSTRING(570) meta=570 nullable=0 is_null=0 */ ### @6 =NULL /* VARSTRING(750) meta=750 nullable=1 is_null=1 */ ### @7 = 1554989560000 /* LONGINT meta=0 nullable=1 is_null=0 */ ### @8 = 1554989550000 /* LONGINT meta=0 nullable=1 is_null=0 */ ### @9 = 5 /* INT meta=0 nullable=1 is_null=0 */ ### @10 = 'WAITING' /* VARSTRING(48) meta=48 nullable=0 is_null=0 */ ### @11 = 'CRON' /* VARSTRING(24) meta=24 nullable=0 is_null=0 */ ### @12 = 1554799338000 /* LONGINT meta=0 nullable=0 is_null=0 */ ### @13 = 0 /* LONGINT meta=0 nullable=1 is_null=0 */ ### @14 =NULL /* VARSTRING(570) meta=570 nullable=1 is_null=1 */ ### @15 = 2 /* SHORTINT meta=0 nullable=1 is_null=0 */ ### @16 = '' /* BLOB/TEXT meta=2 nullable=1 is_null=0 */ ### SET ### @1 = 'BRAND-SCHEDULE' /* VARSTRING(360) meta=360 nullable=0 is_null=0 */ ### @2 = 'AdoptOrderByCrmJobTrigger' /* VARSTRING(570) meta=570 nullable=0 is_null=0 */ ### @3 = 'brand-order' /* VARSTRING(570) meta=570 nullable=0 is_null=0 */ ### @4 = 'AdoptOrderByCrmJob' /* VARSTRING(570) meta=570 nullable=0 is_null=0 */ ### @5 = 'brand-order' /* VARSTRING(570) meta=570 nullable=0 is_null=0 */ ### @6 =NULL /* VARSTRING(750) meta=750 nullable=1 is_null=1 */ ### @7 = 1554989560000 /* LONGINT meta=0 nullable=1 is_null=0 */ ### @8 = 1554989550000 /* LONGINT meta=0 nullable=1 is_null=0 */ ### @9 = 5 /* INT meta=0 nullable=1 is_null=0 */ ### @10 = 'ACQUIRED' /* VARSTRING(48) meta=48 nullable=0 is_null=0 */ ### @11 = 'CRON' /* VARSTRING(24) meta=24 nullable=0 is_null=0 */ ### @12 = 1554799338000 /* LONGINT meta=0 nullable=0 is_null=0 */ ### @13 = 0 /* LONGINT meta=0 nullable=1 is_null=0 */ ### @14 =NULL /* VARSTRING(570) meta=570 nullable=1 is_null=1 */ ### @15 = 2 /* SHORTINT meta=0 nullable=1 is_null=0 */ ### @16 = '' /* BLOB/TEXT meta=2 nullable=1 is_null=0 */ # at 567713314 # 190411 21 : 32 : 40 server id 16823342 end_log_pos 567713125 Table_map: `business_job`.`QRTZ_FIRED_TRIGGERS` mapped to number 21 # at 567713413 # 190411 21 : 32 : 40 server id 16823342 end_log_pos 567713353 Write_rows: table id 21 flags: STMT_END_F ### INSERT INTO `business_job`.`QRTZ_FIRED_TRIGGERS` ### SET ### @1 = 'BRAND-SCHEDULE' /* VARSTRING(360) meta=360 nullable=0 is_null=0 */ ### @2 = 'brand-adp-70471-55b755f695-hx74l15547991982031554799219163' /* VARSTRING(285) meta=285 nullable=0 is_null=0 */ ### @3 = 'AdoptOrderByCrmJobTrigger' /* VARSTRING(570) meta=570 nullable=0 is_null=0 */ ### @4 = 'brand-order' /* VARSTRING(570) meta=570 nullable=0 is_null=0 */ ### @5 = 'brand-adp-70471-55b755f695-hx74l1554799198203' /* VARSTRING(570) meta=570 nullable=0 is_null=0 */ ### @6 = 1554989560014 /* LONGINT meta=0 nullable=0 is_null=0 */ ### @7 = 1554989560000 /* LONGINT meta=0 nullable=0 is_null=0 */ ### @8 = 5 /* INT meta=0 nullable=0 is_null=0 */ ### @9 = 'ACQUIRED' /* VARSTRING(48) meta=48 nullable=0 is_null=0 */ ### @10 =NULL /* VARSTRING(570) meta=570 nullable=1 is_null=1 */ ### @11 =NULL /* VARSTRING(570) meta=570 nullable=1 is_null=1 */ ### @12 = '0' /* VARSTRING(3) meta=3 nullable=1 is_null=0 */ ### @13 = '0' /* VARSTRING(3) meta=3 nullable=1 is_null=0 */ # at 567713641 # 190411 21 : 32 : 40 server id 16823342 end_log_pos 567713380 Xid = 4020831576 COMMIT /*!*/ ; # at 567713668 # 190411 21 : 32 : 40 server id 16823342 end_log_pos 567713420 GTID 0 - 16823342 - 307546140 cid= 4020831580 trans /*!100001 SET @@session.gtid_seq_no=307546140*/ /*!*/ ; BEGIN /*!*/ ; # at 567713708 # 190411 21 : 32 : 40 server id 16823342 end_log_pos 567713519 Table_map: `business_job`.`QRTZ_FIRED_TRIGGERS` mapped to number 21 # at 567713807
            Young.chen.2019 Young Chen added a comment -

            hi team,
            Any update?

            Young.chen.2019 Young Chen added a comment - hi team, Any update?
            Elkin Andrei Elkin added a comment -

            ruochen: In the initial report the parallel mode is CONSERVATIVE. What is like that in your latest followup as well?
            I finally got a test case displaying a similar error but it requires OPTIMISTIC mode.

            Young.chen.2019: if you have another setup that leads to the same error, could you please share details, including
            what was the slave parallel mode?

            Elkin Andrei Elkin added a comment - ruochen : In the initial report the parallel mode is CONSERVATIVE . What is like that in your latest followup as well? I finally got a test case displaying a similar error but it requires OPTIMISTIC mode. Young.chen.2019 : if you have another setup that leads to the same error, could you please share details, including what was the slave parallel mode?
            ruochen wy added a comment -


            CONSERVATIVE mode all the time.

            ruochen wy added a comment - CONSERVATIVE mode all the time.
            Elkin Andrei Elkin added a comment -

            ruochen: Thanks to clear it out a bit!

            Let me ask for few details:
            1. SHOW CREATE TABLE mysql.gtid_slave_ps,
            2. the most recent failure instance's

            • The master and slave error log, only relevant to the failure time interval is enough
            • SHOW SLAVE STATUS
            • mysqlbinlog -v for events in the failed binlog, if the binlog file is big, provide with the output
              some range of events. I may specify the range criteria once again after seeing the 1st snippet uploaded.

            Cheers.
            Andrei

            Elkin Andrei Elkin added a comment - ruochen : Thanks to clear it out a bit! Let me ask for few details: 1. SHOW CREATE TABLE mysql.gtid_slave_ps, 2. the most recent failure instance's The master and slave error log, only relevant to the failure time interval is enough SHOW SLAVE STATUS mysqlbinlog -v for events in the failed binlog, if the binlog file is big, provide with the output some range of events. I may specify the range criteria once again after seeing the 1st snippet uploaded. Cheers. Andrei

            People

              Elkin Andrei Elkin
              ruochen wy
              Votes:
              3 Vote for this issue
              Watchers:
              8 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:

                Git Integration

                  Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.