35/62 tests failed

2024-02-27T13:45:30Z WARN stores/migrations_utils.go:18 SLOW SQL >= 100ms {"elapsed": "300.890ms", "rows": 1, "sql": "-- dbArchivedContract\nCREATE TABLE `archived_contracts` (\n `id` bigint unsigned NOT NULL AUTO_INCREMENT,\n `created_at` datetime(3) DEFAULT NULL,\n `fcid` varbinary(32) NOT NULL,\n `renewed_from` varbinary(32) DEFAULT NULL,\n `contract_price` longtext,\n `state` tinyint unsigned NOT NULL DEFAULT '0',\n `total_cost` longtext,\n `proof_height` bigint unsigned DEFAULT '0',\n `revision_height` bigint unsigned DEFAULT '0',\n `revision_number` varchar(191) NOT NULL DEFAULT '0',\n `size` bigint unsigned DEFAULT NULL,\n `start_height` bigint unsigned NOT NULL,\n `window_start` bigint unsigned NOT NULL DEFAULT '0',\n `window_end` bigint unsigned NOT NULL DEFAULT '0',\n `upload_spending` longtext,\n `download_spending` longtext,\n `fund_account_spending` longtext,\n `delete_spending` longtext,\n `list_spending` longtext,\n `renewed_to` varbinary(32) DEFAULT NULL,\n `host` varbinary(32) NOT NULL,\n `reason` longtext,\n PRIMARY KEY (`id`),\n UNIQUE KEY `fcid` (`fcid`),\n KEY `idx_archived_contracts_renewed_from` (`renewed_from`),\n KEY `idx_archived_contracts_proof_height` (`proof_height`),\n KEY `idx_archived_contracts_revision_height` (`revision_height`),\n KEY `idx_archived_contracts_start_height` (`start_height`),\n KEY `idx_archived_contracts_host` (`host`),\n KEY `idx_archived_contracts_fc_id` (`fcid`),\n KEY `idx_archived_contracts_state` (`state`),\n KEY `idx_archived_contracts_window_start` (`window_start`),\n KEY `idx_archived_contracts_window_end` (`window_end`),\n KEY `idx_archived_contracts_renewed_to` (`renewed_to`)\n) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;\n\n-- dbAutopilot\nCREATE TABLE `autopilots` (\n `id` bigint unsigned NOT NULL AUTO_INCREMENT,\n `created_at` datetime(3) DEFAULT NULL,\n `identifier` varchar(191) NOT NULL,\n `config` longtext,\n `current_period` bigint unsigned DEFAULT '0',\n PRIMARY KEY (`id`),\n UNIQUE KEY `identifier` (`identifier`)\n) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;\n\n-- dbBucket\nCREATE TABLE `buckets` (\n `id` bigint unsigned NOT NULL AUTO_INCREMENT,\n `created_at` datetime(3) DEFAULT NULL,\n `policy` longtext,\n `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL,\n PRIMARY KEY (`id`),\n UNIQUE KEY `name` (`name`),\n KEY `idx_buckets_name` (`name`)\n) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;\n\n-- dbBufferedSlab\nCREATE TABLE `buffered_slabs` (\n `id` bigint unsigned NOT NULL AUTO_INCREMENT,\n `created_at` datetime(3) DEFAULT NULL,\n `filename` longtext,\n PRIMARY KEY (`id`)\n) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;\n\n-- dbConsensusInfo\nCREATE TABLE `consensus_infos` (\n `id` bigint unsigned NOT NULL AUTO_INCREMENT,\n `created_at` datetime(3) DEFAULT NULL,\n `cc_id` longblob,\n `height` bigint unsigned DEFAULT NULL,\n `block_id` longblob,\n PRIMARY KEY (`id`)\n) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;\n\n-- dbHost\nCREATE TABLE `hosts` (\n `id` bigint unsigned NOT NULL AUTO_INCREMENT,\n `created_at` datetime(3) DEFAULT NULL,\n `public_key` varbinary(32) NOT NULL,\n `settings` longtext,\n `price_table` longtext,\n `price_table_expiry` datetime(3) DEFAULT NULL,\n `total_scans` bigint unsigned DEFAULT NULL,\n `last_scan` bigint DEFAULT NULL,\n `last_scan_success` tinyint(1) DEFAULT NULL,\n `second_to_last_scan_success` tinyint(1) DEFAULT NULL,\n `scanned` tinyint(1) DEFAULT NULL,\n `uptime` bigint DEFAULT NULL,\n `downtime` bigint DEFAULT NULL,\n `recent_downtime` bigint DEFAULT NULL,\n `recent_scan_failures` bigint unsigned DEFAULT NULL,\n `successful_interactions` double DEFAULT NULL,\n `failed_interactions` double DEFAULT NULL,\n `lost_sectors` bigint unsigned DEFAULT NULL,\n `last_announcement` datetime(3) DEFAULT NULL,\n `net_address` varchar(191) DEFAULT NULL,\n PRIMARY KEY (`id`),\n UNI

2024-02-27T13:45:30Z DEBUG stores/hostdb_test.go:37 record not found {"elapsed": "1.328ms", "rows": 0, "sql": "SELECT * FROM `hosts` WHERE `hosts`.`public_key` = '<binary>' LIMIT 1"}

2024-02-27T13:45:30Z ERROR stores/sql.go:472 Error 1292 (22007): Incorrect datetime value: '0000-00-00' for column 'last_announcement' at row 1 {"elapsed": "1.680ms", "rows": 0, "sql": "INSERT INTO `hosts` (`created_at`,`public_key`,`settings`,`price_table`,`price_table_expiry`,`total_scans`,`last_scan`,`last_scan_success`,`second_to_last_scan_success`,`scanned`,`uptime`,`downtime`,`recent_downtime`,`recent_scan_failures`,`successful_interactions`,`failed_interactions`,`lost_sectors`,`last_announcement`,`net_address`) VALUES ('2024-02-27 13:45:30.82','<binary>','{\"acceptingcontracts\":false,\"maxdownloadbatchsize\":0,\"maxduration\":0,\"maxrevisebatchsize\":0,\"netaddress\":\"\",\"remainingstorage\":0,\"sectorsize\":0,\"totalstorage\":0,\"unlockhash\":\"addr:000000000000000000000000000000000000000000000000000000000000000089eb0d6a8a69\",\"windowsize\":0,\"collateral\":\"0\",\"maxcollateral\":\"0\",\"baserpcprice\":\"0\",\"contractprice\":\"0\",\"downloadbandwidthprice\":\"0\",\"sectoraccessprice\":\"0\",\"storageprice\":\"0\",\"uploadbandwidthprice\":\"0\",\"ephemeralaccountexpiry\":0,\"maxephemeralaccountbalance\":\"0\",\"revisionnumber\":0,\"version\":\"\",\"siamuxport\":\"\"}','{\"uid\":\"00000000000000000000000000000000\",\"validity\":0,\"hostblockheight\":0,\"updatepricetablecost\":\"0\",\"accountbalancecost\":\"0\",\"fundaccountcost\":\"0\",\"latestrevisioncost\":\"0\",\"subscriptionmemorycost\":\"0\",\"subscriptionnotificationcost\":\"0\",\"initbasecost\":\"0\",\"memorytimecost\":\"0\",\"downloadbandwidthcost\":\"0\",\"uploadbandwidthcost\":\"0\",\"dropsectorsbasecost\":\"0\",\"dropsectorsunitcost\":\"0\",\"hassectorbasecost\":\"0\",\"readbasecost\":\"0\",\"readlengthcost\":\"0\",\"renewcontractcost\":\"0\",\"revisionbasecost\":\"0\",\"swapsectorcost\":\"0\",\"writebasecost\":\"0\",\"writelengthcost\":\"0\",\"writestorecost\":\"0\",\"txnfeeminrecommended\":\"0\",\"txnfeemaxrecommended\":\"0\",\"contractprice\":\"0\",\"collateralcost\":\"0\",\"maxcollateral\":\"0\",\"maxduration\":0,\"windowsize\":0,\"registryentriesleft\":0,\"registryentriestotal\":0}',NULL,0,0,false,false,false,0,0,0,0,0,0,0,'0000-00-00 00:00:00','') ON DUPLICATE KEY UPDATE `last_announcement`=VALUES(`last_announcement`),`net_address`=VALUES(`net_address`)"}

2024-02-27T13:45:30Z ERROR stores/sql.go:472 Error 1292 (22007): Incorrect datetime value: '0000-00-00' for column 'last_announcement' at row 1 {"elapsed": "1.282ms", "rows": 0, "sql": "INSERT INTO `hosts` (`created_at`,`public_key`,`settings`,`price_table`,`price_table_expiry`,`total_scans`,`last_scan`,`last_scan_success`,`second_to_last_scan_success`,`scanned`,`uptime`,`downtime`,`recent_downtime`,`recent_scan_failures`,`successful_interactions`,`failed_interactions`,`lost_sectors`,`last_announcement`,`net_address`) VALUES ('2024-02-27 13:45:30.873','<binary>','{\"acceptingcontracts\":false,\"maxdownloadbatchsize\":0,\"maxduration\":0,\"maxrevisebatchsize\":0,\"netaddress\":\"\",\"remainingstorage\":0,\"sectorsize\":0,\"totalstorage\":0,\"unlockhash\":\"addr:000000000000000000000000000000000000000000000000000000000000000089eb0d6a8a69\",\"windowsize\":0,\"collateral\":\"0\",\"maxcollateral\":\"0\",\"baserpcprice\":\"0\",\"contractprice\":\"0\",\"downloadbandwidthprice\":\"0\",\"sectoraccessprice\":\"0\",\"storageprice\":\"0\",\"uploadbandwidthprice\":\"0\",\"ephemeralaccountexpiry\":0,\"maxephemeralaccountbalance\":\"0\",\"revisionnumber\":0,\"version\":\"\",\"siamuxport\":\"\"}','{\"uid\":\"00000000000000000000000000000000\",\"validity\":0,\"hostblockheight\":0,\"updatepricetablecost\":\"0\",\"accountbalancecost\":\"0\",\"fundaccountcost\":\"0\",\"latestrevisioncost\":\"0\",\"subscriptionmemorycost\":\"0\",\"subscriptionnotificationcost\":\"0\",\"initbasecost\":\"0\",\"memorytimecost\":\"0\",\"downloadbandwidthcost\":\"0\",\"uploadbandwidthcost\":\"0\",\"dropsectorsbasecost\":\"0\",\"dropsectorsunitcost\":\"0\",\"hassectorbasecost\":\"0\",\"readbasecost\":\"0\",\"readlengthcost\":\"0\",\"renewcontractcost\":\"0\",\"revisionbasecost\":\"0\",\"swapsectorcost\":\"0\",\"writebasecost\":\"0\",\"writelengthcost\":\"0\",\"writestorecost\":\"0\",\"txnfeeminrecommended\":\"0\",\"txnfeemaxrecommended\":\"0\",\"contractprice\":\"0\",\"collateralcost\":\"0\",\"maxcollateral\":\"0\",\"maxduration\":0,\"windowsize\":0,\"registryentriesleft\":0,\"registryentriestotal\":0}',NULL,0,0,false,false,false,0,0,0,0,0,0,0,'0000-00-00 00:00:00','') ON DUPLICATE KEY UPDATE `last_announcement`=VALUES(`last_announcement`),`net_address`=VALUES(`net_address`)"}

2024-02-27T13:45:30Z ERROR stores/sql.go:472 Error 1292 (22007): Incorrect datetime value: '0000-00-00' for column 'last_announcement' at row 1 {"elapsed": "1.279ms", "rows": 0, "sql": "INSERT INTO `hosts` (`created_at`,`public_key`,`settings`,`price_table`,`price_table_expiry`,`total_scans`,`last_scan`,`last_scan_success`,`second_to_last_scan_success`,`scanned`,`uptime`,`downtime`,`recent_downtime`,`recent_scan_failures`,`successful_interactions`,`failed_interactions`,`lost_sectors`,`last_announcement`,`net_address`) VALUES ('2024-02-27 13:45:30.976','<binary>','{\"acceptingcontracts\":false,\"maxdownloadbatchsize\":0,\"maxduration\":0,\"maxrevisebatchsize\":0,\"netaddress\":\"\",\"remainingstorage\":0,\"sectorsize\":0,\"totalstorage\":0,\"unlockhash\":\"addr:000000000000000000000000000000000000000000000000000000000000000089eb0d6a8a69\",\"windowsize\":0,\"collateral\":\"0\",\"maxcollateral\":\"0\",\"baserpcprice\":\"0\",\"contractprice\":\"0\",\"downloadbandwidthprice\":\"0\",\"sectoraccessprice\":\"0\",\"storageprice\":\"0\",\"uploadbandwidthprice\":\"0\",\"ephemeralaccountexpiry\":0,\"maxephemeralaccountbalance\":\"0\",\"revisionnumber\":0,\"version\":\"\",\"siamuxport\":\"\"}','{\"uid\":\"00000000000000000000000000000000\",\"validity\":0,\"hostblockheight\":0,\"updatepricetablecost\":\"0\",\"accountbalancecost\":\"0\",\"fundaccountcost\":\"0\",\"latestrevisioncost\":\"0\",\"subscriptionmemorycost\":\"0\",\"subscriptionnotificationcost\":\"0\",\"initbasecost\":\"0\",\"memorytimecost\":\"0\",\"downloadbandwidthcost\":\"0\",\"uploadbandwidthcost\":\"0\",\"dropsectorsbasecost\":\"0\",\"dropsectorsunitcost\":\"0\",\"hassectorbasecost\":\"0\",\"readbasecost\":\"0\",\"readlengthcost\":\"0\",\"renewcontractcost\":\"0\",\"revisionbasecost\":\"0\",\"swapsectorcost\":\"0\",\"writebasecost\":\"0\",\"writelengthcost\":\"0\",\"writestorecost\":\"0\",\"txnfeeminrecommended\":\"0\",\"txnfeemaxrecommended\":\"0\",\"contractprice\":\"0\",\"collateralcost\":\"0\",\"maxcollateral\":\"0\",\"maxduration\":0,\"windowsize\":0,\"registryentriesleft\":0,\"registryentriestotal\":0}',NULL,0,0,false,false,false,0,0,0,0,0,0,0,'0000-00-00 00:00:00','') ON DUPLICATE KEY UPDATE `last_announcement`=VALUES(`last_announcement`),`net_address`=VALUES(`net_address`)"}

hostdb_test.go:45: retryTransaction failed: Error 1292 (22007): Incorrect datetime value: '0000-00-00' for column 'last_announcement' at row 1; failed to insert 1 announcements; failed to apply updates

2024-02-27T13:45:31Z WARN stores/migrations_utils.go:18 SLOW SQL >= 100ms {"elapsed": "319.992ms", "rows": 1, "sql": "-- dbArchivedContract\nCREATE TABLE `archived_contracts` (\n `id` bigint unsigned NOT NULL AUTO_INCREMENT,\n `created_at` datetime(3) DEFAULT NULL,\n `fcid` varbinary(32) NOT NULL,\n `renewed_from` varbinary(32) DEFAULT NULL,\n `contract_price` longtext,\n `state` tinyint unsigned NOT NULL DEFAULT '0',\n `total_cost` longtext,\n `proof_height` bigint unsigned DEFAULT '0',\n `revision_height` bigint unsigned DEFAULT '0',\n `revision_number` varchar(191) NOT NULL DEFAULT '0',\n `size` bigint unsigned DEFAULT NULL,\n `start_height` bigint unsigned NOT NULL,\n `window_start` bigint unsigned NOT NULL DEFAULT '0',\n `window_end` bigint unsigned NOT NULL DEFAULT '0',\n `upload_spending` longtext,\n `download_spending` longtext,\n `fund_account_spending` longtext,\n `delete_spending` longtext,\n `list_spending` longtext,\n `renewed_to` varbinary(32) DEFAULT NULL,\n `host` varbinary(32) NOT NULL,\n `reason` longtext,\n PRIMARY KEY (`id`),\n UNIQUE KEY `fcid` (`fcid`),\n KEY `idx_archived_contracts_renewed_from` (`renewed_from`),\n KEY `idx_archived_contracts_proof_height` (`proof_height`),\n KEY `idx_archived_contracts_revision_height` (`revision_height`),\n KEY `idx_archived_contracts_start_height` (`start_height`),\n KEY `idx_archived_contracts_host` (`host`),\n KEY `idx_archived_contracts_fc_id` (`fcid`),\n KEY `idx_archived_contracts_state` (`state`),\n KEY `idx_archived_contracts_window_start` (`window_start`),\n KEY `idx_archived_contracts_window_end` (`window_end`),\n KEY `idx_archived_contracts_renewed_to` (`renewed_to`)\n) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;\n\n-- dbAutopilot\nCREATE TABLE `autopilots` (\n `id` bigint unsigned NOT NULL AUTO_INCREMENT,\n `created_at` datetime(3) DEFAULT NULL,\n `identifier` varchar(191) NOT NULL,\n `config` longtext,\n `current_period` bigint unsigned DEFAULT '0',\n PRIMARY KEY (`id`),\n UNIQUE KEY `identifier` (`identifier`)\n) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;\n\n-- dbBucket\nCREATE TABLE `buckets` (\n `id` bigint unsigned NOT NULL AUTO_INCREMENT,\n `created_at` datetime(3) DEFAULT NULL,\n `policy` longtext,\n `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL,\n PRIMARY KEY (`id`),\n UNIQUE KEY `name` (`name`),\n KEY `idx_buckets_name` (`name`)\n) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;\n\n-- dbBufferedSlab\nCREATE TABLE `buffered_slabs` (\n `id` bigint unsigned NOT NULL AUTO_INCREMENT,\n `created_at` datetime(3) DEFAULT NULL,\n `filename` longtext,\n PRIMARY KEY (`id`)\n) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;\n\n-- dbConsensusInfo\nCREATE TABLE `consensus_infos` (\n `id` bigint unsigned NOT NULL AUTO_INCREMENT,\n `created_at` datetime(3) DEFAULT NULL,\n `cc_id` longblob,\n `height` bigint unsigned DEFAULT NULL,\n `block_id` longblob,\n PRIMARY KEY (`id`)\n) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;\n\n-- dbHost\nCREATE TABLE `hosts` (\n `id` bigint unsigned NOT NULL AUTO_INCREMENT,\n `created_at` datetime(3) DEFAULT NULL,\n `public_key` varbinary(32) NOT NULL,\n `settings` longtext,\n `price_table` longtext,\n `price_table_expiry` datetime(3) DEFAULT NULL,\n `total_scans` bigint unsigned DEFAULT NULL,\n `last_scan` bigint DEFAULT NULL,\n `last_scan_success` tinyint(1) DEFAULT NULL,\n `second_to_last_scan_success` tinyint(1) DEFAULT NULL,\n `scanned` tinyint(1) DEFAULT NULL,\n `uptime` bigint DEFAULT NULL,\n `downtime` bigint DEFAULT NULL,\n `recent_downtime` bigint DEFAULT NULL,\n `recent_scan_failures` bigint unsigned DEFAULT NULL,\n `successful_interactions` double DEFAULT NULL,\n `failed_interactions` double DEFAULT NULL,\n `lost_sectors` bigint unsigned DEFAULT NULL,\n `last_announcement` datetime(3) DEFAULT NULL,\n `net_address` varchar(191) DEFAULT NULL,\n PRIMARY KEY (`id`),\n UNI

2024-02-27T13:45:31Z ERROR stores/sql.go:472 Error 1292 (22007): Incorrect datetime value: '0000-00-00' for column 'last_announcement' at row 1 {"elapsed": "1.945ms", "rows": 0, "sql": "INSERT INTO `hosts` (`created_at`,`public_key`,`settings`,`price_table`,`price_table_expiry`,`total_scans`,`last_scan`,`last_scan_success`,`second_to_last_scan_success`,`scanned`,`uptime`,`downtime`,`recent_downtime`,`recent_scan_failures`,`successful_interactions`,`failed_interactions`,`lost_sectors`,`last_announcement`,`net_address`) VALUES ('2024-02-27 13:45:31.663','<binary>','{\"acceptingcontracts\":false,\"maxdownloadbatchsize\":0,\"maxduration\":0,\"maxrevisebatchsize\":0,\"netaddress\":\"\",\"remainingstorage\":0,\"sectorsize\":0,\"totalstorage\":0,\"unlockhash\":\"addr:000000000000000000000000000000000000000000000000000000000000000089eb0d6a8a69\",\"windowsize\":0,\"collateral\":\"0\",\"maxcollateral\":\"0\",\"baserpcprice\":\"0\",\"contractprice\":\"0\",\"downloadbandwidthprice\":\"0\",\"sectoraccessprice\":\"0\",\"storageprice\":\"0\",\"uploadbandwidthprice\":\"0\",\"ephemeralaccountexpiry\":0,\"maxephemeralaccountbalance\":\"0\",\"revisionnumber\":0,\"version\":\"\",\"siamuxport\":\"\"}','{\"uid\":\"00000000000000000000000000000000\",\"validity\":0,\"hostblockheight\":0,\"updatepricetablecost\":\"0\",\"accountbalancecost\":\"0\",\"fundaccountcost\":\"0\",\"latestrevisioncost\":\"0\",\"subscriptionmemorycost\":\"0\",\"subscriptionnotificationcost\":\"0\",\"initbasecost\":\"0\",\"memorytimecost\":\"0\",\"downloadbandwidthcost\":\"0\",\"uploadbandwidthcost\":\"0\",\"dropsectorsbasecost\":\"0\",\"dropsectorsunitcost\":\"0\",\"hassectorbasecost\":\"0\",\"readbasecost\":\"0\",\"readlengthcost\":\"0\",\"renewcontractcost\":\"0\",\"revisionbasecost\":\"0\",\"swapsectorcost\":\"0\",\"writebasecost\":\"0\",\"writelengthcost\":\"0\",\"writestorecost\":\"0\",\"txnfeeminrecommended\":\"0\",\"txnfeemaxrecommended\":\"0\",\"contractprice\":\"0\",\"collateralcost\":\"0\",\"maxcollateral\":\"0\",\"maxduration\":0,\"windowsize\":0,\"registryentriesleft\":0,\"registryentriestotal\":0}',NULL,0,0,false,false,false,0,0,0,0,0,0,0,'0000-00-00 00:00:00','') ON DUPLICATE KEY UPDATE `last_announcement`=VALUES(`last_announcement`),`net_address`=VALUES(`net_address`)"}

2024-02-27T13:45:31Z ERROR stores/sql.go:472 Error 1292 (22007): Incorrect datetime value: '0000-00-00' for column 'last_announcement' at row 1 {"elapsed": "1.297ms", "rows": 0, "sql": "INSERT INTO `hosts` (`created_at`,`public_key`,`settings`,`price_table`,`price_table_expiry`,`total_scans`,`last_scan`,`last_scan_success`,`second_to_last_scan_success`,`scanned`,`uptime`,`downtime`,`recent_downtime`,`recent_scan_failures`,`successful_interactions`,`failed_interactions`,`lost_sectors`,`last_announcement`,`net_address`) VALUES ('2024-02-27 13:45:31.717','<binary>','{\"acceptingcontracts\":false,\"maxdownloadbatchsize\":0,\"maxduration\":0,\"maxrevisebatchsize\":0,\"netaddress\":\"\",\"remainingstorage\":0,\"sectorsize\":0,\"totalstorage\":0,\"unlockhash\":\"addr:000000000000000000000000000000000000000000000000000000000000000089eb0d6a8a69\",\"windowsize\":0,\"collateral\":\"0\",\"maxcollateral\":\"0\",\"baserpcprice\":\"0\",\"contractprice\":\"0\",\"downloadbandwidthprice\":\"0\",\"sectoraccessprice\":\"0\",\"storageprice\":\"0\",\"uploadbandwidthprice\":\"0\",\"ephemeralaccountexpiry\":0,\"maxephemeralaccountbalance\":\"0\",\"revisionnumber\":0,\"version\":\"\",\"siamuxport\":\"\"}','{\"uid\":\"00000000000000000000000000000000\",\"validity\":0,\"hostblockheight\":0,\"updatepricetablecost\":\"0\",\"accountbalancecost\":\"0\",\"fundaccountcost\":\"0\",\"latestrevisioncost\":\"0\",\"subscriptionmemorycost\":\"0\",\"subscriptionnotificationcost\":\"0\",\"initbasecost\":\"0\",\"memorytimecost\":\"0\",\"downloadbandwidthcost\":\"0\",\"uploadbandwidthcost\":\"0\",\"dropsectorsbasecost\":\"0\",\"dropsectorsunitcost\":\"0\",\"hassectorbasecost\":\"0\",\"readbasecost\":\"0\",\"readlengthcost\":\"0\",\"renewcontractcost\":\"0\",\"revisionbasecost\":\"0\",\"swapsectorcost\":\"0\",\"writebasecost\":\"0\",\"writelengthcost\":\"0\",\"writestorecost\":\"0\",\"txnfeeminrecommended\":\"0\",\"txnfeemaxrecommended\":\"0\",\"contractprice\":\"0\",\"collateralcost\":\"0\",\"maxcollateral\":\"0\",\"maxduration\":0,\"windowsize\":0,\"registryentriesleft\":0,\"registryentriestotal\":0}',NULL,0,0,false,false,false,0,0,0,0,0,0,0,'0000-00-00 00:00:00','') ON DUPLICATE KEY UPDATE `last_announcement`=VALUES(`last_announcement`),`net_address`=VALUES(`net_address`)"}