. . . 1> Cannot connect to h=xx.xx.xx.xx,p=...,u=xxxxx No slaves found. See --recursion-method if host servername has slaves. Not checking slave lag because no slaves were found and --check-slave-lag was not specified. Operation, tries, wait: analyze_table, 10, 1 copy_rows, 10, 0.25 create_triggers, 10, 1 drop_triggers, 10, 1 swap_tables, 10, 1 update_foreign_keys, 10, 1 No foreign keys reference `newplatform`.`page_statistics`; ignoring --alter-foreign-keys-method. Altering `newplatform`.`page_statistics`... Creating new table... CREATE TABLE `newplatform`.`_page_statistics_new` ( `id` bigint(20) NOT NULL AUTO_INCREMENT, `date` datetime NOT NULL, `path` varchar(100) NOT NULL, `venue_id` bigint(20) DEFAULT NULL, `session_id` varchar(50) NOT NULL, `client_ip` bigint(20) DEFAULT NULL, PRIMARY KEY (`id`), KEY `FK_page_statistics_venues` (`venue_id`), KEY `page_statistics_path_venue_date_index` (`path`,`venue_id`,`date`), CONSTRAINT `__FK_page_statistics_venues` FOREIGN KEY (`venue_id`) REFERENCES `venues` (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=1095777551 DEFAULT CHARSET=utf8 Created new table newplatform._page_statistics_new OK. Altering new table... ALTER TABLE `newplatform`.`_page_statistics_new` ENGINE=InnoDB Altered `newplatform`.`_page_statistics_new` OK. 2018-12-10T05:30:52 Creating triggers... 2018-12-10T05:30:52 Created triggers OK. 2018-12-10T05:30:52 Copying approximately 159813108 rows... INSERT LOW_PRIORITY IGNORE INTO `newplatform`.`_page_statistics_new` (`id`, `date`, `path`, `venue_id`, `session_id`, `client_ip`) SELECT `id`, `date`, `path`, `venue_id`, `session_id`, `client_ip` FROM `newplatform`.`page_statistics` FORCE INDEX(`PRIMARY`) WHERE ((`id` >= ?)) AND ((`id` <= ?)) LOCK IN SHARE MODE /*pt-online-schema-change 5599 copy nibble*/ SELECT /*!40001 SQL_NO_CACHE */ `id` FROM `newplatform`.`page_statistics` FORCE INDEX(`PRIMARY`) WHERE ((`id` >= ?)) ORDER BY `id` LIMIT ?, 2 /*next chunk boundary*/ Copying `newplatform`.`page_statistics`: 0% 02:08:19 remain Copying `newplatform`.`page_statistics`: 0% 02:06:44 remain Copying `newplatform`.`page_statistics`: 1% 02:05:59 remain Copying `newplatform`.`page_statistics`: 1% 02:04:01 remain Copying `newplatform`.`page_statistics`: 1% 02:04:52 remain Copying `newplatform`.`page_statistics`: 2% 02:04:13 remain Copying `newplatform`.`page_statistics`: 2% 02:03:56 remain Copying `newplatform`.`page_statistics`: 3% 02:03:37 remain Copying `newplatform`.`page_statistics`: 3% 02:03:15 remain Copying `newplatform`.`page_statistics`: 3% 02:03:00 remain Copying `newplatform`.`page_statistics`: 4% 02:02:37 remain Copying `newplatform`.`page_statistics`: 4% 02:02:39 remain Copying `newplatform`.`page_statistics`: 5% 02:02:13 remain Copying `newplatform`.`page_statistics`: 5% 02:01:41 remain Copying `newplatform`.`page_statistics`: 5% 02:00:46 remain Copying `newplatform`.`page_statistics`: 6% 02:00:12 remain Copying `newplatform`.`page_statistics`: 6% 01:59:41 remain Copying `newplatform`.`page_statistics`: 6% 01:59:39 remain Copying `newplatform`.`page_statistics`: 7% 01:58:57 remain Copying `newplatform`.`page_statistics`: 7% 01:58:59 remain Copying `newplatform`.`page_statistics`: 8% 01:58:15 remain Copying `newplatform`.`page_statistics`: 8% 01:57:30 remain Copying `newplatform`.`page_statistics`: 8% 01:56:59 remain Copying `newplatform`.`page_statistics`: 9% 01:56:33 remain Copying `newplatform`.`page_statistics`: 9% 01:56:09 remain Copying `newplatform`.`page_statistics`: 10% 01:55:45 remain Copying `newplatform`.`page_statistics`: 10% 01:55:31 remain Copying `newplatform`.`page_statistics`: 10% 01:55:06 remain Copying `newplatform`.`page_statistics`: 11% 01:54:33 remain Copying `newplatform`.`page_statistics`: 11% 01:54:00 remain Copying `newplatform`.`page_statistics`: 12% 01:53:17 remain Copying `newplatform`.`page_statistics`: 12% 01:52:54 remain Copying `newplatform`.`page_statistics`: 12% 01:52:27 remain Copying `newplatform`.`page_statistics`: 13% 01:52:00 remain Copying `newplatform`.`page_statistics`: 13% 01:51:48 remain Copying `newplatform`.`page_statistics`: 13% 01:51:33 remain Copying `newplatform`.`page_statistics`: 14% 01:51:14 remain Copying `newplatform`.`page_statistics`: 14% 01:50:57 remain Copying `newplatform`.`page_statistics`: 15% 01:50:15 remain Copying `newplatform`.`page_statistics`: 15% 01:49:52 remain Copying `newplatform`.`page_statistics`: 15% 01:49:15 remain Copying `newplatform`.`page_statistics`: 16% 01:48:47 remain Copying `newplatform`.`page_statistics`: 16% 01:48:21 remain Copying `newplatform`.`page_statistics`: 16% 01:47:55 remain Copying `newplatform`.`page_statistics`: 17% 01:47:32 remain Copying `newplatform`.`page_statistics`: 17% 01:47:01 remain Copying `newplatform`.`page_statistics`: 18% 01:46:37 remain Copying `newplatform`.`page_statistics`: 18% 01:46:08 remain Copying `newplatform`.`page_statistics`: 18% 01:45:17 remain Copying `newplatform`.`page_statistics`: 19% 01:44:49 remain Copying `newplatform`.`page_statistics`: 19% 01:44:29 remain Copying `newplatform`.`page_statistics`: 19% 01:44:05 remain Copying `newplatform`.`page_statistics`: 20% 01:43:47 remain Copying `newplatform`.`page_statistics`: 20% 01:43:24 remain Copying `newplatform`.`page_statistics`: 21% 01:43:00 remain Copying `newplatform`.`page_statistics`: 21% 01:42:36 remain Copying `newplatform`.`page_statistics`: 21% 01:42:10 remain Copying `newplatform`.`page_statistics`: 22% 01:41:43 remain Copying `newplatform`.`page_statistics`: 22% 01:41:24 remain Copying `newplatform`.`page_statistics`: 22% 01:40:51 remain Copying `newplatform`.`page_statistics`: 23% 01:40:32 remain Copying `newplatform`.`page_statistics`: 23% 01:40:11 remain Copying `newplatform`.`page_statistics`: 23% 01:39:45 remain Copying `newplatform`.`page_statistics`: 24% 01:39:12 remain Copying `newplatform`.`page_statistics`: 24% 01:38:58 remain Copying `newplatform`.`page_statistics`: 25% 01:38:31 remain Copying `newplatform`.`page_statistics`: 25% 01:38:07 remain Copying `newplatform`.`page_statistics`: 25% 01:37:41 remain Copying `newplatform`.`page_statistics`: 26% 01:37:04 remain Copying `newplatform`.`page_statistics`: 26% 01:36:28 remain Copying `newplatform`.`page_statistics`: 26% 01:36:02 remain Copying `newplatform`.`page_statistics`: 27% 01:35:36 remain Copying `newplatform`.`page_statistics`: 27% 01:35:03 remain Copying `newplatform`.`page_statistics`: 28% 01:34:35 remain Copying `newplatform`.`page_statistics`: 28% 01:34:03 remain Copying `newplatform`.`page_statistics`: 28% 01:33:31 remain Copying `newplatform`.`page_statistics`: 29% 01:33:02 remain Copying `newplatform`.`page_statistics`: 29% 01:32:40 remain Copying `newplatform`.`page_statistics`: 29% 01:32:14 remain Copying `newplatform`.`page_statistics`: 30% 01:31:54 remain Copying `newplatform`.`page_statistics`: 30% 01:31:28 remain Copying `newplatform`.`page_statistics`: 31% 01:30:56 remain Copying `newplatform`.`page_statistics`: 31% 01:30:29 remain Copying `newplatform`.`page_statistics`: 31% 01:30:01 remain Copying `newplatform`.`page_statistics`: 32% 01:29:36 remain Copying `newplatform`.`page_statistics`: 32% 01:29:03 remain Copying `newplatform`.`page_statistics`: 32% 01:28:40 remain Copying `newplatform`.`page_statistics`: 33% 01:28:09 remain Copying `newplatform`.`page_statistics`: 33% 01:27:40 remain Copying `newplatform`.`page_statistics`: 34% 01:27:13 remain Copying `newplatform`.`page_statistics`: 34% 01:26:50 remain Copying `newplatform`.`page_statistics`: 34% 01:26:28 remain Copying `newplatform`.`page_statistics`: 35% 01:26:02 remain Copying `newplatform`.`page_statistics`: 35% 01:25:33 remain Copying `newplatform`.`page_statistics`: 35% 01:25:09 remain Copying `newplatform`.`page_statistics`: 36% 01:24:47 remain Copying `newplatform`.`page_statistics`: 36% 01:24:17 remain Copying `newplatform`.`page_statistics`: 36% 01:23:53 remain Copying `newplatform`.`page_statistics`: 37% 01:23:26 remain Copying `newplatform`.`page_statistics`: 37% 01:23:02 remain Copying `newplatform`.`page_statistics`: 37% 01:22:34 remain Copying `newplatform`.`page_statistics`: 38% 01:22:05 remain Copying `newplatform`.`page_statistics`: 38% 01:21:39 remain Copying `newplatform`.`page_statistics`: 39% 01:21:16 remain Copying `newplatform`.`page_statistics`: 39% 01:20:54 remain Copying `newplatform`.`page_statistics`: 39% 01:20:28 remain Copying `newplatform`.`page_statistics`: 40% 01:20:05 remain Copying `newplatform`.`page_statistics`: 40% 01:19:36 remain Copying `newplatform`.`page_statistics`: 40% 01:19:08 remain Copying `newplatform`.`page_statistics`: 41% 01:18:38 remain Copying `newplatform`.`page_statistics`: 41% 01:18:09 remain Copying `newplatform`.`page_statistics`: 41% 01:17:42 remain Copying `newplatform`.`page_statistics`: 42% 01:17:13 remain Copying `newplatform`.`page_statistics`: 42% 01:16:50 remain Copying `newplatform`.`page_statistics`: 42% 01:16:28 remain Copying `newplatform`.`page_statistics`: 43% 01:16:04 remain Copying `newplatform`.`page_statistics`: 43% 01:15:41 remain Copying `newplatform`.`page_statistics`: 43% 01:15:14 remain Copying `newplatform`.`page_statistics`: 44% 01:14:44 remain Copying `newplatform`.`page_statistics`: 44% 01:14:11 remain Copying `newplatform`.`page_statistics`: 45% 01:13:46 remain Copying `newplatform`.`page_statistics`: 45% 01:13:17 remain Copying `newplatform`.`page_statistics`: 45% 01:12:51 remain Copying `newplatform`.`page_statistics`: 46% 01:12:23 remain Copying `newplatform`.`page_statistics`: 46% 01:11:58 remain Copying `newplatform`.`page_statistics`: 46% 01:11:31 remain Copying `newplatform`.`page_statistics`: 47% 01:11:08 remain Copying `newplatform`.`page_statistics`: 47% 01:10:41 remain Copying `newplatform`.`page_statistics`: 47% 01:10:12 remain Copying `newplatform`.`page_statistics`: 48% 01:09:39 remain Copying `newplatform`.`page_statistics`: 48% 01:09:06 remain Copying `newplatform`.`page_statistics`: 49% 01:08:37 remain Copying `newplatform`.`page_statistics`: 49% 01:08:10 remain Copying `newplatform`.`page_statistics`: 49% 01:07:45 remain Copying `newplatform`.`page_statistics`: 50% 01:07:20 remain Copying `newplatform`.`page_statistics`: 50% 01:06:57 remain Copying `newplatform`.`page_statistics`: 50% 01:06:29 remain Copying `newplatform`.`page_statistics`: 51% 01:06:01 remain Copying `newplatform`.`page_statistics`: 51% 01:05:33 remain Copying `newplatform`.`page_statistics`: 51% 01:05:06 remain Copying `newplatform`.`page_statistics`: 52% 01:04:38 remain Copying `newplatform`.`page_statistics`: 52% 01:04:12 remain Copying `newplatform`.`page_statistics`: 52% 01:03:50 remain Copying `newplatform`.`page_statistics`: 53% 01:03:27 remain Copying `newplatform`.`page_statistics`: 53% 01:03:01 remain Copying `newplatform`.`page_statistics`: 53% 01:02:33 remain Copying `newplatform`.`page_statistics`: 54% 01:02:05 remain Copying `newplatform`.`page_statistics`: 54% 01:01:36 remain Copying `newplatform`.`page_statistics`: 54% 01:01:09 remain Copying `newplatform`.`page_statistics`: 55% 01:00:41 remain Copying `newplatform`.`page_statistics`: 55% 01:00:11 remain Copying `newplatform`.`page_statistics`: 55% 59:44 remain Copying `newplatform`.`page_statistics`: 56% 59:19 remain Copying `newplatform`.`page_statistics`: 56% 58:54 remain Copying `newplatform`.`page_statistics`: 56% 58:28 remain Copying `newplatform`.`page_statistics`: 57% 58:02 remain Copying `newplatform`.`page_statistics`: 57% 57:36 remain Copying `newplatform`.`page_statistics`: 58% 57:07 remain Copying `newplatform`.`page_statistics`: 58% 56:37 remain Copying `newplatform`.`page_statistics`: 58% 56:11 remain Copying `newplatform`.`page_statistics`: 59% 55:47 remain Copying `newplatform`.`page_statistics`: 59% 55:20 remain Copying `newplatform`.`page_statistics`: 59% 54:55 remain Copying `newplatform`.`page_statistics`: 60% 54:30 remain Copying `newplatform`.`page_statistics`: 60% 54:02 remain Copying `newplatform`.`page_statistics`: 60% 53:34 remain Copying `newplatform`.`page_statistics`: 61% 53:10 remain Copying `newplatform`.`page_statistics`: 61% 52:43 remain Copying `newplatform`.`page_statistics`: 61% 52:16 remain Copying `newplatform`.`page_statistics`: 62% 51:49 remain Copying `newplatform`.`page_statistics`: 62% 51:23 remain Copying `newplatform`.`page_statistics`: 62% 50:54 remain Copying `newplatform`.`page_statistics`: 63% 50:27 remain Copying `newplatform`.`page_statistics`: 63% 50:03 remain Copying `newplatform`.`page_statistics`: 63% 49:39 remain Copying `newplatform`.`page_statistics`: 64% 49:11 remain Copying `newplatform`.`page_statistics`: 64% 48:45 remain Copying `newplatform`.`page_statistics`: 64% 48:19 remain Copying `newplatform`.`page_statistics`: 65% 47:52 remain Copying `newplatform`.`page_statistics`: 65% 47:26 remain Copying `newplatform`.`page_statistics`: 65% 46:58 remain Copying `newplatform`.`page_statistics`: 66% 46:32 remain Copying `newplatform`.`page_statistics`: 66% 46:07 remain Copying `newplatform`.`page_statistics`: 66% 45:42 remain Copying `newplatform`.`page_statistics`: 67% 45:17 remain Copying `newplatform`.`page_statistics`: 67% 44:49 remain Copying `newplatform`.`page_statistics`: 67% 44:23 remain Copying `newplatform`.`page_statistics`: 68% 43:55 remain Copying `newplatform`.`page_statistics`: 68% 43:28 remain Copying `newplatform`.`page_statistics`: 68% 43:01 remain Copying `newplatform`.`page_statistics`: 69% 42:34 remain Copying `newplatform`.`page_statistics`: 69% 42:06 remain Copying `newplatform`.`page_statistics`: 69% 41:41 remain Copying `newplatform`.`page_statistics`: 70% 41:16 remain Copying `newplatform`.`page_statistics`: 70% 40:51 remain Copying `newplatform`.`page_statistics`: 70% 40:25 remain Copying `newplatform`.`page_statistics`: 71% 40:00 remain Copying `newplatform`.`page_statistics`: 71% 39:34 remain Copying `newplatform`.`page_statistics`: 71% 39:07 remain Copying `newplatform`.`page_statistics`: 72% 38:39 remain Copying `newplatform`.`page_statistics`: 72% 38:12 remain Copying `newplatform`.`page_statistics`: 72% 37:45 remain Copying `newplatform`.`page_statistics`: 73% 37:20 remain Copying `newplatform`.`page_statistics`: 73% 36:52 remain Copying `newplatform`.`page_statistics`: 73% 36:26 remain Copying `newplatform`.`page_statistics`: 74% 35:59 remain Copying `newplatform`.`page_statistics`: 74% 35:32 remain Copying `newplatform`.`page_statistics`: 74% 35:08 remain Copying `newplatform`.`page_statistics`: 75% 34:41 remain Copying `newplatform`.`page_statistics`: 75% 34:15 remain Copying `newplatform`.`page_statistics`: 75% 33:49 remain Copying `newplatform`.`page_statistics`: 76% 33:25 remain Copying `newplatform`.`page_statistics`: 76% 32:57 remain Copying `newplatform`.`page_statistics`: 76% 32:28 remain Copying `newplatform`.`page_statistics`: 77% 32:04 remain Copying `newplatform`.`page_statistics`: 77% 31:38 remain Copying `newplatform`.`page_statistics`: 77% 31:11 remain Copying `newplatform`.`page_statistics`: 78% 30:44 remain Copying `newplatform`.`page_statistics`: 78% 30:18 remain Copying `newplatform`.`page_statistics`: 78% 29:50 remain Copying `newplatform`.`page_statistics`: 78% 29:24 remain Copying `newplatform`.`page_statistics`: 79% 28:58 remain Copying `newplatform`.`page_statistics`: 79% 28:29 remain Copying `newplatform`.`page_statistics`: 79% 28:02 remain Copying `newplatform`.`page_statistics`: 80% 27:31 remain Copying `newplatform`.`page_statistics`: 80% 27:07 remain Copying `newplatform`.`page_statistics`: 80% 26:39 remain Copying `newplatform`.`page_statistics`: 81% 26:11 remain Copying `newplatform`.`page_statistics`: 81% 25:43 remain Copying `newplatform`.`page_statistics`: 81% 25:15 remain Copying `newplatform`.`page_statistics`: 82% 24:50 remain Copying `newplatform`.`page_statistics`: 82% 24:25 remain Copying `newplatform`.`page_statistics`: 82% 23:57 remain Copying `newplatform`.`page_statistics`: 83% 23:31 remain Copying `newplatform`.`page_statistics`: 83% 23:04 remain Copying `newplatform`.`page_statistics`: 83% 22:38 remain Copying `newplatform`.`page_statistics`: 84% 22:13 remain Copying `newplatform`.`page_statistics`: 84% 21:48 remain Copying `newplatform`.`page_statistics`: 84% 21:23 remain Copying `newplatform`.`page_statistics`: 85% 20:57 remain Copying `newplatform`.`page_statistics`: 85% 20:31 remain Copying `newplatform`.`page_statistics`: 85% 20:08 remain Copying `newplatform`.`page_statistics`: 86% 19:43 remain Copying `newplatform`.`page_statistics`: 86% 19:18 remain Copying `newplatform`.`page_statistics`: 86% 18:51 remain Copying `newplatform`.`page_statistics`: 87% 18:22 remain Copying `newplatform`.`page_statistics`: 87% 17:54 remain Copying `newplatform`.`page_statistics`: 87% 17:28 remain Copying `newplatform`.`page_statistics`: 87% 17:02 remain Copying `newplatform`.`page_statistics`: 88% 16:37 remain Copying `newplatform`.`page_statistics`: 88% 16:12 remain Copying `newplatform`.`page_statistics`: 88% 15:46 remain Copying `newplatform`.`page_statistics`: 89% 15:22 remain Copying `newplatform`.`page_statistics`: 89% 15:00 remain Copying `newplatform`.`page_statistics`: 89% 14:35 remain Copying `newplatform`.`page_statistics`: 90% 14:07 remain Copying `newplatform`.`page_statistics`: 90% 13:43 remain Copying `newplatform`.`page_statistics`: 90% 13:14 remain Copying `newplatform`.`page_statistics`: 91% 12:46 remain Copying `newplatform`.`page_statistics`: 91% 12:17 remain Copying `newplatform`.`page_statistics`: 91% 11:46 remain Copying `newplatform`.`page_statistics`: 92% 11:18 remain Copying `newplatform`.`page_statistics`: 92% 10:48 remain Copying `newplatform`.`page_statistics`: 92% 10:19 remain Copying `newplatform`.`page_statistics`: 93% 09:49 remain Copying `newplatform`.`page_statistics`: 93% 09:19 remain Copying `newplatform`.`page_statistics`: 93% 08:49 remain Copying `newplatform`.`page_statistics`: 94% 08:20 remain Copying `newplatform`.`page_statistics`: 94% 07:47 remain Copying `newplatform`.`page_statistics`: 94% 07:16 remain Copying `newplatform`.`page_statistics`: 95% 06:45 remain Copying `newplatform`.`page_statistics`: 95% 06:13 remain Copying `newplatform`.`page_statistics`: 95% 05:42 remain Copying `newplatform`.`page_statistics`: 96% 05:13 remain Copying `newplatform`.`page_statistics`: 96% 04:45 remain Copying `newplatform`.`page_statistics`: 96% 04:16 remain Copying `newplatform`.`page_statistics`: 97% 03:48 remain Copying `newplatform`.`page_statistics`: 97% 03:18 remain Copying `newplatform`.`page_statistics`: 98% 02:50 remain Copying `newplatform`.`page_statistics`: 98% 02:19 remain Copying `newplatform`.`page_statistics`: 98% 01:48 remain Copying `newplatform`.`page_statistics`: 99% 01:18 remain 2018-12-10T07:52:05 Copied rows OK. 2018-12-10T07:52:05 Analyzing new table... 2018-12-10T07:52:06 Swapping tables... RENAME TABLE `newplatform`.`page_statistics` TO `newplatform`.`_page_statistics_old`, `newplatform`.`_page_statistics_new` TO `newplatform`.`page_statistics` 2018-12-10T07:52:06 Swapped original and new tables OK. 2018-12-10T07:52:06 Dropping old table... DROP TABLE IF EXISTS `newplatform`.`_page_statistics_old` 2018-12-10T07:52:09 Dropped old table `newplatform`.`_page_statistics_old` OK. 2018-12-10T07:52:09 Dropping triggers... DROP TRIGGER IF EXISTS `newplatform`.`pt_osc_newplatform_page_statistics_del` DROP TRIGGER IF EXISTS `newplatform`.`pt_osc_newplatform_page_statistics_upd` DROP TRIGGER IF EXISTS `newplatform`.`pt_osc_newplatform_page_statistics_ins` 2018-12-10T07:52:09 Dropped triggers OK. Successfully altered `newplatform`.`page_statistics`. 1> Cannot connect to h=xx.xx.xx.xx,p=...,u=xxxxx No slaves found. See --recursion-method if host servername has slaves. Not checking slave lag because no slaves were found and --check-slave-lag was not specified. Operation, tries, wait: analyze_table, 10, 1 copy_rows, 10, 0.25 create_triggers, 10, 1 drop_triggers, 10, 1 swap_tables, 10, 1 update_foreign_keys, 10, 1 Child tables: `newplatform`.`activation_codes` (approx. 1 rows) `newplatform`.`branding` (approx. 517 rows) `newplatform`.`campaigns` (approx. 4 rows) `newplatform`.`countries` (approx. 52 rows) `newplatform`.`group_branding` (approx. 698 rows) `newplatform`.`mediaresources` (approx. 1237 rows) `newplatform`.`party_relationships` (approx. 17701 rows) `newplatform`.`party_relationships` (approx. 17701 rows) `newplatform`.`product_offers` (approx. 8030 rows) `newplatform`.`rule_instances` (approx. 1 rows) `newplatform`.`squid_acls` (approx. 8793 rows) `newplatform`.`venue_owners` (approx. 657 rows) `newplatform`.`venues` (approx. 6201 rows) Will use the rebuild_constraints method to update foreign keys. Altering `newplatform`.`parties`... Creating new table... CREATE TABLE `newplatform`.`_parties_new` ( `id` bigint(20) NOT NULL AUTO_INCREMENT, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=34820 DEFAULT CHARSET=utf8 Created new table newplatform._parties_new OK. Altering new table... ALTER TABLE `newplatform`.`_parties_new` ENGINE=InnoDB Altered `newplatform`.`_parties_new` OK. 2018-12-10T07:52:10 Creating triggers... 2018-12-10T07:52:10 Created triggers OK. 2018-12-10T07:52:10 Copying approximately 26256 rows... INSERT LOW_PRIORITY IGNORE INTO `newplatform`.`_parties_new` (`id`) SELECT `id` FROM `newplatform`.`parties` FORCE INDEX(`PRIMARY`) WHERE ((`id` >= ?)) AND ((`id` <= ?)) LOCK IN SHARE MODE /*pt-online-schema-change 19700 copy nibble*/ SELECT /*!40001 SQL_NO_CACHE */ `id` FROM `newplatform`.`parties` FORCE INDEX(`PRIMARY`) WHERE ((`id` >= ?)) ORDER BY `id` LIMIT ?, 2 /*next chunk boundary*/ 2018-12-10T07:52:10 Copied rows OK. 2018-12-10T07:52:10 Analyzing new table... 2018-12-10T07:52:10 Swapping tables... RENAME TABLE `newplatform`.`parties` TO `newplatform`.`_parties_old`, `newplatform`.`_parties_new` TO `newplatform`.`parties` 2018-12-10T07:52:10 Swapped original and new tables OK. 2018-12-10T07:52:10 Rebuilding foreign key constraints... ALTER TABLE `newplatform`.`activation_codes` DROP FOREIGN KEY `FK_activation_codes_parties`, ADD CONSTRAINT `_FK_activation_codes_parties` FOREIGN KEY (`party_id`) REFERENCES `newplatform`.`parties` (`id`) ALTER TABLE `newplatform`.`branding` DROP FOREIGN KEY `_FK_branding_parties`, ADD CONSTRAINT `__FK_branding_parties` FOREIGN KEY (`party_id`) REFERENCES `newplatform`.`parties` (`id`) ALTER TABLE `newplatform`.`campaigns` DROP FOREIGN KEY `_FK_campaigns_parties`, ADD CONSTRAINT `__FK_campaigns_parties` FOREIGN KEY (`party_id`) REFERENCES `newplatform`.`parties` (`id`) ALTER TABLE `newplatform`.`countries` DROP FOREIGN KEY `_FK_countries_parties`, ADD CONSTRAINT `__FK_countries_parties` FOREIGN KEY (`party_id`) REFERENCES `newplatform`.`parties` (`id`) ALTER TABLE `newplatform`.`group_branding` DROP FOREIGN KEY `_FK_group_branding_parties`, ADD CONSTRAINT `__FK_group_branding_parties` FOREIGN KEY (`party_id`) REFERENCES `newplatform`.`parties` (`id`) ALTER TABLE `newplatform`.`mediaresources` DROP FOREIGN KEY `FK_mediaresources_parties`, ADD CONSTRAINT `_FK_mediaresources_parties` FOREIGN KEY (`party_id`) REFERENCES `newplatform`.`parties` (`id`) ALTER TABLE `newplatform`.`party_relationships` DROP FOREIGN KEY `_FK_from_party`, ADD CONSTRAINT `__FK_from_party` FOREIGN KEY (`from_party_id`) REFERENCES `newplatform`.`parties` (`id`), DROP FOREIGN KEY `_FK_to_party`, ADD CONSTRAINT `__FK_to_party` FOREIGN KEY (`to_party_id`) REFERENCES `newplatform`.`parties` (`id`) 2018-12-10T07:52:13 `newplatform`.`party_relationships` has no foreign key constraints referencing `newplatform`.`_parties_old`. ALTER TABLE `newplatform`.`product_offers` DROP FOREIGN KEY `_FK_product_offers_parties`, ADD CONSTRAINT `__FK_product_offers_parties` FOREIGN KEY (`party_id`) REFERENCES `newplatform`.`parties` (`id`) ALTER TABLE `newplatform`.`rule_instances` DROP FOREIGN KEY `_FK_rule_instances_parties`, ADD CONSTRAINT `__FK_rule_instances_parties` FOREIGN KEY (`party_id`) REFERENCES `newplatform`.`parties` (`id`) ALTER TABLE `newplatform`.`squid_acls` DROP FOREIGN KEY `_FK_squid_acls_parties`, ADD CONSTRAINT `__FK_squid_acls_parties` FOREIGN KEY (`party_id`) REFERENCES `newplatform`.`parties` (`id`) ALTER TABLE `newplatform`.`venue_owners` DROP FOREIGN KEY `_FK_venue_owners_parties`, ADD CONSTRAINT `__FK_venue_owners_parties` FOREIGN KEY (`party_id`) REFERENCES `newplatform`.`parties` (`id`) ALTER TABLE `newplatform`.`venues` DROP FOREIGN KEY `_FK_venues_parties`, ADD CONSTRAINT `__FK_venues_parties` FOREIGN KEY (`party_id`) REFERENCES `newplatform`.`parties` (`id`) 2018-12-10T07:52:16 Rebuilt foreign key constraints OK. 2018-12-10T07:52:16 Dropping old table... DROP TABLE IF EXISTS `newplatform`.`_parties_old` 2018-12-10T07:52:16 Dropped old table `newplatform`.`_parties_old` OK. 2018-12-10T07:52:16 Dropping triggers... DROP TRIGGER IF EXISTS `newplatform`.`pt_osc_newplatform_parties_del` DROP TRIGGER IF EXISTS `newplatform`.`pt_osc_newplatform_parties_upd` DROP TRIGGER IF EXISTS `newplatform`.`pt_osc_newplatform_parties_ins` 2018-12-10T07:52:16 Dropped triggers OK. Successfully altered `newplatform`.`parties`. 1> Cannot connect to h=xx.xx.xx.xx,p=...,u=xxxxx No slaves found. See --recursion-method if host servername has slaves. Not checking slave lag because no slaves were found and --check-slave-lag was not specified. Operation, tries, wait: analyze_table, 10, 1 copy_rows, 10, 0.25 create_triggers, 10, 1 drop_triggers, 10, 1 swap_tables, 10, 1 update_foreign_keys, 10, 1 No foreign keys reference `newplatform`.`party_relationships`; ignoring --alter-foreign-keys-method. Altering `newplatform`.`party_relationships`... Creating new table... CREATE TABLE `newplatform`.`_party_relationships_new` ( `id` bigint(20) NOT NULL AUTO_INCREMENT, `type` varchar(50) NOT NULL, `from_party_id` bigint(20) NOT NULL, `to_party_id` bigint(20) NOT NULL, PRIMARY KEY (`id`), KEY `IDX_relationship_type` (`type`), KEY `_FK_from_party` (`from_party_id`), KEY `_FK_to_party` (`to_party_id`), CONSTRAINT `FK_from_party` FOREIGN KEY (`from_party_id`) REFERENCES `parties` (`id`), CONSTRAINT `FK_to_party` FOREIGN KEY (`to_party_id`) REFERENCES `parties` (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=21274 DEFAULT CHARSET=utf8 Created new table newplatform._party_relationships_new OK. Altering new table... ALTER TABLE `newplatform`.`_party_relationships_new` ENGINE=InnoDB Altered `newplatform`.`_party_relationships_new` OK. 2018-12-10T07:52:16 Creating triggers... 2018-12-10T07:52:16 Created triggers OK. 2018-12-10T07:52:16 Copying approximately 17227 rows... INSERT LOW_PRIORITY IGNORE INTO `newplatform`.`_party_relationships_new` (`id`, `type`, `from_party_id`, `to_party_id`) SELECT `id`, `type`, `from_party_id`, `to_party_id` FROM `newplatform`.`party_relationships` FORCE INDEX(`PRIMARY`) WHERE ((`id` >= ?)) AND ((`id` <= ?)) LOCK IN SHARE MODE /*pt-online-schema-change 19720 copy nibble*/ SELECT /*!40001 SQL_NO_CACHE */ `id` FROM `newplatform`.`party_relationships` FORCE INDEX(`PRIMARY`) WHERE ((`id` >= ?)) ORDER BY `id` LIMIT ?, 2 /*next chunk boundary*/ 2018-12-10T07:52:17 Copied rows OK. 2018-12-10T07:52:17 Analyzing new table... 2018-12-10T07:52:17 Swapping tables... RENAME TABLE `newplatform`.`party_relationships` TO `newplatform`.`_party_relationships_old`, `newplatform`.`_party_relationships_new` TO `newplatform`.`party_relationships` 2018-12-10T07:52:17 Swapped original and new tables OK. 2018-12-10T07:52:17 Dropping old table... DROP TABLE IF EXISTS `newplatform`.`_party_relationships_old` 2018-12-10T07:52:17 Dropped old table `newplatform`.`_party_relationships_old` OK. 2018-12-10T07:52:17 Dropping triggers... DROP TRIGGER IF EXISTS `newplatform`.`pt_osc_newplatform_party_relationships_del` DROP TRIGGER IF EXISTS `newplatform`.`pt_osc_newplatform_party_relationships_upd` DROP TRIGGER IF EXISTS `newplatform`.`pt_osc_newplatform_party_relationships_ins` 2018-12-10T07:52:17 Dropped triggers OK. Successfully altered `newplatform`.`party_relationships`. Error setting lock_wait_timeout: DBD::mysql::db do failed: Lost connection to MySQL server during query [for Statement "SET SESSION lock_wait_timeout=60"]. The current value for lock_wait_timeout is 86400. If the variable is read only (not dynamic), specify --set-vars lock_wait_timeout=86400 to avoid this warning, else manually set the variable and restart MySQL. Cannot connect to MySQL: Error getting the current SQL_MODE: DBD::mysql::db selectrow_array failed: MySQL server has gone away [for Statement "SELECT @@SQL_MODE"] at /usr/bin/pt-online-schema-change line 2393. Cannot connect to MySQL: DBI connect('newplatform;host=localhost;mysql_read_default_group=client','jobs_user',...) failed: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (111 "Connection refused") at /usr/bin/pt-online-schema-change line 2345. Cannot connect to MySQL: DBI connect('newplatform;host=localhost;mysql_read_default_group=client','jobs_user',...) failed: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (111 "Connection refused") at /usr/bin/pt-online-schema-change line 2345. Cannot connect to MySQL: DBI connect('newplatform;host=localhost;mysql_read_default_group=client','jobs_user',...) failed: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (111 "Connection refused") at /usr/bin/pt-online-schema-change line 2345. Cannot connect to MySQL: DBI connect('newplatform;host=localhost;mysql_read_default_group=client','jobs_user',...) failed: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (111 "Connection refused") at /usr/bin/pt-online-schema-change line 2345. Cannot connect to MySQL: DBI connect('newplatform;host=localhost;mysql_read_default_group=client','jobs_user',...) failed: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (111 "Connection refused") at /usr/bin/pt-online-schema-change line 2345. Cannot connect to MySQL: DBI connect('newplatform;host=localhost;mysql_read_default_group=client','jobs_user',...) failed: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (111 "Connection refused") at /usr/bin/pt-online-schema-change line 2345. Cannot connect to MySQL: DBI connect('newplatform;host=localhost;mysql_read_default_group=client','jobs_user',...) failed: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (111 "Connection refused") at /usr/bin/pt-online-schema-change line 2345. Cannot connect to MySQL: DBI connect('newplatform;host=localhost;mysql_read_default_group=client','jobs_user',...) failed: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (111 "Connection refused") at /usr/bin/pt-online-schema-change line 2345. Cannot connect to MySQL: DBI connect('newplatform;host=localhost;mysql_read_default_group=client','jobs_user',...) failed: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (111 "Connection refused") at /usr/bin/pt-online-schema-change line 2345. Cannot connect to MySQL: DBI connect('newplatform;host=localhost;mysql_read_default_group=client','jobs_user',...) failed: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (111 "Connection refused") at /usr/bin/pt-online-schema-change line 2345. Cannot connect to MySQL: DBI connect('newplatform;host=localhost;mysql_read_default_group=client','jobs_user',...) failed: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (111 "Connection refused") at /usr/bin/pt-online-schema-change line 2345. Cannot connect to MySQL: DBI connect('newplatform;host=localhost;mysql_read_default_group=client','jobs_user',...) failed: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (111 "Connection refused") at /usr/bin/pt-online-schema-change line 2345. Cannot connect to MySQL: DBI connect('newplatform;host=localhost;mysql_read_default_group=client','jobs_user',...) failed: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (111 "Connection refused") at /usr/bin/pt-online-schema-change line 2345. Cannot connect to MySQL: DBI connect('newplatform;host=localhost;mysql_read_default_group=client','jobs_user',...) failed: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (111 "Connection refused") at /usr/bin/pt-online-schema-change line 2345. Cannot connect to MySQL: DBI connect('newplatform;host=localhost;mysql_read_default_group=client','jobs_user',...) failed: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (111 "Connection refused") at /usr/bin/pt-online-schema-change line 2345. Cannot connect to MySQL: DBI connect('newplatform;host=localhost;mysql_read_default_group=client','jobs_user',...) failed: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (111 "Connection refused") at /usr/bin/pt-online-schema-change line 2345. Cannot connect to MySQL: DBI connect('newplatform;host=localhost;mysql_read_default_group=client','jobs_user',...) failed: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (111 "Connection refused") at /usr/bin/pt-online-schema-change line 2345. Cannot connect to MySQL: DBI connect('newplatform;host=localhost;mysql_read_default_group=client','jobs_user',...) failed: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (111 "Connection refused") at /usr/bin/pt-online-schema-change line 2345. Cannot connect to MySQL: DBI connect('newplatform;host=localhost;mysql_read_default_group=client','jobs_user',...) failed: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (111 "Connection refused") at /usr/bin/pt-online-schema-change line 2345. Cannot connect to MySQL: DBI connect('newplatform;host=localhost;mysql_read_default_group=client','jobs_user',...) failed: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (111 "Connection refused") at /usr/bin/pt-online-schema-change line 2345. Cannot connect to MySQL: DBI connect('newplatform;host=localhost;mysql_read_default_group=client','jobs_user',...) failed: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (111 "Connection refused") at /usr/bin/pt-online-schema-change line 2345. Cannot connect to MySQL: DBI connect('newplatform;host=localhost;mysql_read_default_group=client','jobs_user',...) failed: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (111 "Connection refused") at /usr/bin/pt-online-schema-change line 2345. Cannot connect to MySQL: DBI connect('newplatform;host=localhost;mysql_read_default_group=client','jobs_user',...) failed: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (111 "Connection refused") at /usr/bin/pt-online-schema-change line 2345. Cannot connect to MySQL: DBI connect('newplatform;host=localhost;mysql_read_default_group=client','jobs_user',...) failed: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (111 "Connection refused") at /usr/bin/pt-online-schema-change line 2345. Cannot connect to MySQL: DBI connect('newplatform;host=localhost;mysql_read_default_group=client','jobs_user',...) failed: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (111 "Connection refused") at /usr/bin/pt-online-schema-change line 2345. Cannot connect to MySQL: DBI connect('newplatform;host=localhost;mysql_read_default_group=client','jobs_user',...) failed: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (111 "Connection refused") at /usr/bin/pt-online-schema-change line 2345. Cannot connect to MySQL: DBI connect('newplatform;host=localhost;mysql_read_default_group=client','jobs_user',...) failed: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (111 "Connection refused") at /usr/bin/pt-online-schema-change line 2345. Cannot connect to MySQL: DBI connect('newplatform;host=localhost;mysql_read_default_group=client','jobs_user',...) failed: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (111 "Connection refused") at /usr/bin/pt-online-schema-change line 2345. Cannot connect to MySQL: DBI connect('newplatform;host=localhost;mysql_read_default_group=client','jobs_user',...) failed: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (111 "Connection refused") at /usr/bin/pt-online-schema-change line 2345. Cannot connect to MySQL: DBI connect('newplatform;host=localhost;mysql_read_default_group=client','jobs_user',...) failed: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (111 "Connection refused") at /usr/bin/pt-online-schema-change line 2345.