# at 21660 #170306 12:16:08 server id 12 end_log_pos 21702 CRC32 0x512e960d GTID 100-12-2262255373 trans /*!100001 SET @@session.gtid_seq_no=2262255373*//*!*/; BEGIN /*!*/; # at 21702 # at 21961 #170306 12:16:08 server id 12 end_log_pos 21961 CRC32 0xfdb5e98d Annotate_rows: #Q> /* web2.debtpaypro.com:29324 */ UPDATE `contacts_messages` SET `message` = 's3' WHERE message != 's3' AND id >= 11568400 AND id < 11568500 AND id IN (SELECT id FROM contacts_messages_upload_status WHERE id >= 11568400 AND id < 11568500) #170306 12:16:08 server id 12 end_log_pos 22052 CRC32 0xd1a55464 Table_map: `prod_debtpaypro`.`contacts_messages` mapped to number 298079 # at 22052 # at 38414 # at 54798 # at 71177 # at 87561 # at 103954 # at 120344 # at 124722 # at 141122 # at 157516 # at 162271 # at 178644 # at 195055 # at 211441 # at 227819 # at 244215 # at 260606 # at 276992 # at 293377 # at 309739 # at 326127 # at 342515 # at 358914 # at 375326 # at 391714 # at 408123 # at 424520 # at 440919 # at 457313 # at 473708 # at 490072 # at 506478 # at 522877 # at 539250 #170306 12:16:08 server id 12 end_log_pos 38414 CRC32 0xe12d6597 Update_rows: table id 298079 #170306 12:16:08 server id 12 end_log_pos 54798 CRC32 0x2a8a9083 Update_rows: table id 298079 #170306 12:16:08 server id 12 end_log_pos 71177 CRC32 0x3cb4db8f Update_rows: table id 298079 #170306 12:16:08 server id 12 end_log_pos 87561 CRC32 0xfa51abde Update_rows: table id 298079 #170306 12:16:08 server id 12 end_log_pos 103954 CRC32 0xc0c9213f Update_rows: table id 298079 #170306 12:16:08 server id 12 end_log_pos 120344 CRC32 0x22145e1d Update_rows: table id 298079 #170306 12:16:08 server id 12 end_log_pos 124722 CRC32 0xd500d0f0 Update_rows: table id 298079 #170306 12:16:08 server id 12 end_log_pos 141122 CRC32 0xd272efcf Update_rows: table id 298079 #170306 12:16:08 server id 12 end_log_pos 157516 CRC32 0x041eedfc Update_rows: table id 298079 #170306 12:16:08 server id 12 end_log_pos 162271 CRC32 0x3fd875bb Update_rows: table id 298079 #170306 12:16:08 server id 12 end_log_pos 178644 CRC32 0x72013e57 Update_rows: table id 298079 #170306 12:16:08 server id 12 end_log_pos 195055 CRC32 0xd1b7106a Update_rows: table id 298079 #170306 12:16:08 server id 12 end_log_pos 211441 CRC32 0x0564d83b Update_rows: table id 298079 #170306 12:16:08 server id 12 end_log_pos 227819 CRC32 0x1b70005b Update_rows: table id 298079 #170306 12:16:08 server id 12 end_log_pos 244215 CRC32 0x250c70ac Update_rows: table id 298079 #170306 12:16:08 server id 12 end_log_pos 260606 CRC32 0x0b00eb57 Update_rows: table id 298079 #170306 12:16:08 server id 12 end_log_pos 276992 CRC32 0x990078e6 Update_rows: table id 298079 #170306 12:16:08 server id 12 end_log_pos 293377 CRC32 0xcf95196d Update_rows: table id 298079 #170306 12:16:08 server id 12 end_log_pos 309739 CRC32 0xe6c9f6ef Update_rows: table id 298079 #170306 12:16:08 server id 12 end_log_pos 326127 CRC32 0x9f0e373f Update_rows: table id 298079 #170306 12:16:08 server id 12 end_log_pos 342515 CRC32 0x5a463845 Update_rows: table id 298079 #170306 12:16:08 server id 12 end_log_pos 358914 CRC32 0xa4869d06 Update_rows: table id 298079 #170306 12:16:08 server id 12 end_log_pos 375326 CRC32 0x8159047f Update_rows: table id 298079 #170306 12:16:08 server id 12 end_log_pos 391714 CRC32 0xbb56d4ed Update_rows: table id 298079 #170306 12:16:08 server id 12 end_log_pos 408123 CRC32 0x82723705 Update_rows: table id 298079 #170306 12:16:08 server id 12 end_log_pos 424520 CRC32 0x463cdcc2 Update_rows: table id 298079 #170306 12:16:08 server id 12 end_log_pos 440919 CRC32 0xa739ff43 Update_rows: table id 298079 #170306 12:16:08 server id 12 end_log_pos 457313 CRC32 0xac8d76c4 Update_rows: table id 298079 #170306 12:16:08 server id 12 end_log_pos 473708 CRC32 0x856de31e Update_rows: table id 298079 #170306 12:16:08 server id 12 end_log_pos 490072 CRC32 0x7d3d69fb Update_rows: table id 298079 #170306 12:16:08 server id 12 end_log_pos 506478 CRC32 0x4e2a6066 Update_rows: table id 298079 #170306 12:16:08 server id 12 end_log_pos 522877 CRC32 0x954a5b68 Update_rows: table id 298079 #170306 12:16:08 server id 12 end_log_pos 539250 CRC32 0x7c951d53 Update_rows: table id 298079 #170306 12:16:08 server id 12 end_log_pos 555640 CRC32 0x6dadca81 Update_rows: table id 298079 flags: STMT_END_F ### UPDATE `prod_debtpaypro`.`contacts_messages` ### WHERE ### @1=11568400 /* INT meta=0 nullable=0 is_null=0 */ ### @8='...' /* BLOB/TEXT meta=2 nullable=0 is_null=0 */ ### SET ### @8='s3' /* BLOB/TEXT meta=2 nullable=0 is_null=0 */ ### UPDATE `prod_debtpaypro`.`contacts_messages` ### WHERE ### @1=11568403 /* INT meta=0 nullable=0 is_null=0 */ ### @8='...' /* BLOB/TEXT meta=2 nullable=0 is_null=0 */ ### SET ### @8='s3' /* BLOB/TEXT meta=2 nullable=0 is_null=0 */ ### UPDATE `prod_debtpaypro`.`contacts_messages` ### WHERE ### @1=11568406 /* INT meta=0 nullable=0 is_null=0 */ ### @8='...' /* BLOB/TEXT meta=2 nullable=0 is_null=0 */ ### SET ### @8='s3' /* BLOB/TEXT meta=2 nullable=0 is_null=0 */ ### UPDATE `prod_debtpaypro`.`contacts_messages` ### WHERE ### @1=11568409 /* INT meta=0 nullable=0 is_null=0 */ ### @8='...' /* BLOB/TEXT meta=2 nullable=0 is_null=0 */ ### SET ### @8='s3' /* BLOB/TEXT meta=2 nullable=0 is_null=0 */ ### UPDATE `prod_debtpaypro`.`contacts_messages` ### WHERE ### @1=11568412 /* INT meta=0 nullable=0 is_null=0 */ ### @8='...' /* BLOB/TEXT meta=2 nullable=0 is_null=0 */ ### SET ### @8='s3' /* BLOB/TEXT meta=2 nullable=0 is_null=0 */ ### UPDATE `prod_debtpaypro`.`contacts_messages` ### WHERE ### @1=11568415 /* INT meta=0 nullable=0 is_null=0 */ ### @8='...' /* BLOB/TEXT meta=2 nullable=0 is_null=0 */ ### SET ### @8='s3' /* BLOB/TEXT meta=2 nullable=0 is_null=0 */ ### UPDATE `prod_debtpaypro`.`contacts_messages` ### WHERE ### @1=11568418 /* INT meta=0 nullable=0 is_null=0 */ ### @8='

...

' /* BLOB/TEXT meta=2 nullable=0 is_null=0 */ ### SET ### @8='s3' /* BLOB/TEXT meta=2 nullable=0 is_null=0 */ ### UPDATE `prod_debtpaypro`.`contacts_messages` ### WHERE ### @1=11568421 /* INT meta=0 nullable=0 is_null=0 */ ### @8='...' /* BLOB/TEXT meta=2 nullable=0 is_null=0 */ ### SET ### @8='s3' /* BLOB/TEXT meta=2 nullable=0 is_null=0 */ ### UPDATE `prod_debtpaypro`.`contacts_messages` ### WHERE ### @1=11568424 /* INT meta=0 nullable=0 is_null=0 */ ### @8='...' /* BLOB/TEXT meta=2 nullable=0 is_null=0 */ ### SET ### @8='s3' /* BLOB/TEXT meta=2 nullable=0 is_null=0 */ ### UPDATE `prod_debtpaypro`.`contacts_messages` ### WHERE ### @1=11568427 /* INT meta=0 nullable=0 is_null=0 */ ### @8='

...

' /* BLOB/TEXT meta=2 nullable=0 is_null=0 */ ### SET ### @8='s3' /* BLOB/TEXT meta=2 nullable=0 is_null=0 */ ### UPDATE `prod_debtpaypro`.`contacts_messages` ### WHERE ### @1=11568430 /* INT meta=0 nullable=0 is_null=0 */ ### @8='...' /* BLOB/TEXT meta=2 nullable=0 is_null=0 */ ### SET ### @8='s3' /* BLOB/TEXT meta=2 nullable=0 is_null=0 */ ### UPDATE `prod_debtpaypro`.`contacts_messages` ### WHERE ### @1=11568433 /* INT meta=0 nullable=0 is_null=0 */ ### @8='...' /* BLOB/TEXT meta=2 nullable=0 is_null=0 */ ### SET ### @8='s3' /* BLOB/TEXT meta=2 nullable=0 is_null=0 */ ### UPDATE `prod_debtpaypro`.`contacts_messages` ### WHERE ### @1=11568436 /* INT meta=0 nullable=0 is_null=0 */ ### @8='...' /* BLOB/TEXT meta=2 nullable=0 is_null=0 */ ### SET ### @8='s3' /* BLOB/TEXT meta=2 nullable=0 is_null=0 */ ### UPDATE `prod_debtpaypro`.`contacts_messages` ### WHERE ### @1=11568439 /* INT meta=0 nullable=0 is_null=0 */ ### @8='...' /* BLOB/TEXT meta=2 nullable=0 is_null=0 */ ### SET ### @8='s3' /* BLOB/TEXT meta=2 nullable=0 is_null=0 */ ### UPDATE `prod_debtpaypro`.`contacts_messages` ### WHERE ### @1=11568442 /* INT meta=0 nullable=0 is_null=0 */ ### @8='...' /* BLOB/TEXT meta=2 nullable=0 is_null=0 */ ### SET ### @8='s3' /* BLOB/TEXT meta=2 nullable=0 is_null=0 */ ### UPDATE `prod_debtpaypro`.`contacts_messages` ### WHERE ### @1=11568445 /* INT meta=0 nullable=0 is_null=0 */ ### @8='...' /* BLOB/TEXT meta=2 nullable=0 is_null=0 */ ### SET ### @8='s3' /* BLOB/TEXT meta=2 nullable=0 is_null=0 */ ### UPDATE `prod_debtpaypro`.`contacts_messages` ### WHERE ### @1=11568448 /* INT meta=0 nullable=0 is_null=0 */ ### @8='...' /* BLOB/TEXT meta=2 nullable=0 is_null=0 */ ### SET ### @8='s3' /* BLOB/TEXT meta=2 nullable=0 is_null=0 */ ### UPDATE `prod_debtpaypro`.`contacts_messages` ### WHERE ### @1=11568451 /* INT meta=0 nullable=0 is_null=0 */ ### @8='...' /* BLOB/TEXT meta=2 nullable=0 is_null=0 */ ### SET ### @8='s3' /* BLOB/TEXT meta=2 nullable=0 is_null=0 */ ### UPDATE `prod_debtpaypro`.`contacts_messages` ### WHERE ### @1=11568454 /* INT meta=0 nullable=0 is_null=0 */ ### @8='...' /* BLOB/TEXT meta=2 nullable=0 is_null=0 */ ### SET ### @8='s3' /* BLOB/TEXT meta=2 nullable=0 is_null=0 */ ### UPDATE `prod_debtpaypro`.`contacts_messages` ### WHERE ### @1=11568457 /* INT meta=0 nullable=0 is_null=0 */ ### @8='...' /* BLOB/TEXT meta=2 nullable=0 is_null=0 */ ### SET ### @8='s3' /* BLOB/TEXT meta=2 nullable=0 is_null=0 */ ### UPDATE `prod_debtpaypro`.`contacts_messages` ### WHERE ### @1=11568460 /* INT meta=0 nullable=0 is_null=0 */ ### @8='...' /* BLOB/TEXT meta=2 nullable=0 is_null=0 */ ### SET ### @8='s3' /* BLOB/TEXT meta=2 nullable=0 is_null=0 */ ### UPDATE `prod_debtpaypro`.`contacts_messages` ### WHERE ### @1=11568463 /* INT meta=0 nullable=0 is_null=0 */ ### @8='...' /* BLOB/TEXT meta=2 nullable=0 is_null=0 */ ### SET ### @8='s3' /* BLOB/TEXT meta=2 nullable=0 is_null=0 */ ### UPDATE `prod_debtpaypro`.`contacts_messages` ### WHERE ### @1=11568466 /* INT meta=0 nullable=0 is_null=0 */ ### @8='...' /* BLOB/TEXT meta=2 nullable=0 is_null=0 */ ### SET ### @8='s3' /* BLOB/TEXT meta=2 nullable=0 is_null=0 */ ### UPDATE `prod_debtpaypro`.`contacts_messages` ### WHERE ### @1=11568469 /* INT meta=0 nullable=0 is_null=0 */ ### @8='...' /* BLOB/TEXT meta=2 nullable=0 is_null=0 */ ### SET ### @8='s3' /* BLOB/TEXT meta=2 nullable=0 is_null=0 */ ### UPDATE `prod_debtpaypro`.`contacts_messages` ### WHERE ### @1=11568472 /* INT meta=0 nullable=0 is_null=0 */ ### @8='...' /* BLOB/TEXT meta=2 nullable=0 is_null=0 */ ### SET ### @8='s3' /* BLOB/TEXT meta=2 nullable=0 is_null=0 */ ### UPDATE `prod_debtpaypro`.`contacts_messages` ### WHERE ### @1=11568475 /* INT meta=0 nullable=0 is_null=0 */ ### @8='...' /* BLOB/TEXT meta=2 nullable=0 is_null=0 */ ### SET ### @8='s3' /* BLOB/TEXT meta=2 nullable=0 is_null=0 */ ### UPDATE `prod_debtpaypro`.`contacts_messages` ### WHERE ### @1=11568478 /* INT meta=0 nullable=0 is_null=0 */ ### @8='...' /* BLOB/TEXT meta=2 nullable=0 is_null=0 */ ### SET ### @8='s3' /* BLOB/TEXT meta=2 nullable=0 is_null=0 */ ### UPDATE `prod_debtpaypro`.`contacts_messages` ### WHERE ### @1=11568481 /* INT meta=0 nullable=0 is_null=0 */ ### @8='...' /* BLOB/TEXT meta=2 nullable=0 is_null=0 */ ### SET ### @8='s3' /* BLOB/TEXT meta=2 nullable=0 is_null=0 */ ### UPDATE `prod_debtpaypro`.`contacts_messages` ### WHERE ### @1=11568484 /* INT meta=0 nullable=0 is_null=0 */ ### @8='...' /* BLOB/TEXT meta=2 nullable=0 is_null=0 */ ### SET ### @8='s3' /* BLOB/TEXT meta=2 nullable=0 is_null=0 */ ### UPDATE `prod_debtpaypro`.`contacts_messages` ### WHERE ### @1=11568487 /* INT meta=0 nullable=0 is_null=0 */ ### @8='...' /* BLOB/TEXT meta=2 nullable=0 is_null=0 */ ### SET ### @8='s3' /* BLOB/TEXT meta=2 nullable=0 is_null=0 */ ### UPDATE `prod_debtpaypro`.`contacts_messages` ### WHERE ### @1=11568490 /* INT meta=0 nullable=0 is_null=0 */ ### @8='...' /* BLOB/TEXT meta=2 nullable=0 is_null=0 */ ### SET ### @8='s3' /* BLOB/TEXT meta=2 nullable=0 is_null=0 */ ### UPDATE `prod_debtpaypro`.`contacts_messages` ### WHERE ### @1=11568493 /* INT meta=0 nullable=0 is_null=0 */ ### @8='...' /* BLOB/TEXT meta=2 nullable=0 is_null=0 */ ### SET ### @8='s3' /* BLOB/TEXT meta=2 nullable=0 is_null=0 */ ### UPDATE `prod_debtpaypro`.`contacts_messages` ### WHERE ### @1=11568496 /* INT meta=0 nullable=0 is_null=0 */ ### @8='...' /* BLOB/TEXT meta=2 nullable=0 is_null=0 */ ### SET ### @8='s3' /* BLOB/TEXT meta=2 nullable=0 is_null=0 */ ### UPDATE `prod_debtpaypro`.`contacts_messages` ### WHERE ### @1=11568499 /* INT meta=0 nullable=0 is_null=0 */ ### @8='...' /* BLOB/TEXT meta=2 nullable=0 is_null=0 */ ### SET ### @8='s3' /* BLOB/TEXT meta=2 nullable=0 is_null=0 */ # at 555640 #170306 12:16:08 server id 12 end_log_pos 555671 CRC32 0x89a94295 Xid = 2256102397 COMMIT/*!*/;