35/62 tests failed

2024-02-27T13:45:37Z WARN stores/migrations_utils.go:18 SLOW SQL >= 100ms {"elapsed": "408.188ms", "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:37Z DEBUG stores/hostdb_test.go:37 record not found {"elapsed": "1.294ms", "rows": 0, "sql": "SELECT * FROM `hosts` WHERE `hosts`.`public_key` = '<binary>' LIMIT 1"}

2024-02-27T13:45:37Z ERROR stores/sql.go:472 Error 1292 (22007): Incorrect datetime value: '0000-00-00' for column 'last_announcement' at row 1 {"elapsed": "1.712ms", "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:37.197','<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:37Z ERROR stores/sql.go:472 Error 1292 (22007): Incorrect datetime value: '0000-00-00' for column 'last_announcement' at row 1 {"elapsed": "1.325ms", "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:37.25','<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:37Z ERROR stores/sql.go:472 Error 1292 (22007): Incorrect datetime value: '0000-00-00' for column 'last_announcement' at row 1 {"elapsed": "1.247ms", "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:37.354','<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:37Z WARN stores/migrations_utils.go:18 SLOW SQL >= 100ms {"elapsed": "371.955ms", "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:38Z WARN stores/migrations_utils.go:18 SLOW SQL >= 100ms {"elapsed": "105.827ms", "rows": 0, "sql": "-- dbContractPruneMetric\nCREATE TABLE `contract_prunes` (\n `id` bigint unsigned NOT NULL AUTO_INCREMENT,\n `created_at` datetime(3) DEFAULT NULL,\n `timestamp` bigint NOT NULL,\n `fcid` varbinary(32) NOT NULL,\n `host` varbinary(32) NOT NULL,\n `host_version` varchar(191) DEFAULT NULL,\n `pruned` bigint NOT NULL,\n `remaining` bigint NOT NULL,\n `duration` bigint NOT NULL,\n PRIMARY KEY (`id`),\n KEY `idx_contract_prunes_timestamp` (`timestamp`),\n KEY `idx_contract_prunes_fc_id` (`fcid`),\n KEY `idx_contract_prunes_host` (`host`),\n KEY `idx_contract_prunes_host_version` (`host_version`),\n KEY `idx_contract_prunes_pruned` (`pruned`),\n KEY `idx_contract_prunes_remaining` (`remaining`),\n KEY `idx_contract_prunes_duration` (`duration`)\n) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;\n\n-- dbContractSetMetric\nCREATE TABLE `contract_sets` (\n `id` bigint unsigned NOT NULL AUTO_INCREMENT,\n `created_at` datetime(3) DEFAULT NULL,\n `timestamp` bigint NOT NULL,\n `name` varchar(191) NOT NULL,\n `contracts` bigint NOT NULL,\n PRIMARY KEY (`id`),\n KEY `idx_contract_sets_timestamp` (`timestamp`),\n KEY `idx_contract_sets_name` (`name`),\n KEY `idx_contract_sets_contracts` (`contracts`)\n) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;\n\n-- dbContractSetChurnMetric\nCREATE TABLE `contract_sets_churn` (\n `id` bigint unsigned NOT NULL AUTO_INCREMENT,\n `created_at` datetime(3) DEFAULT NULL,\n `timestamp` bigint NOT NULL,\n `name` varchar(191) NOT NULL,\n `fc_id` varbinary(32) NOT NULL,\n `direction` varchar(191) NOT NULL,\n `reason` varchar(191) NOT NULL,\n PRIMARY KEY (`id`),\n KEY `idx_contract_sets_churn_timestamp` (`timestamp`),\n KEY `idx_contract_sets_churn_name` (`name`),\n KEY `idx_contract_sets_churn_fc_id` (`fc_id`),\n KEY `idx_contract_sets_churn_direction` (`direction`),\n KEY `idx_contract_sets_churn_reason` (`reason`)\n) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;\n\n-- dbContractMetric\nCREATE TABLE `contracts` (\n `id` bigint unsigned NOT NULL AUTO_INCREMENT,\n `created_at` datetime(3) DEFAULT NULL,\n `timestamp` bigint NOT NULL,\n `fcid` varbinary(32) NOT NULL,\n `host` varbinary(32) NOT NULL,\n `remaining_collateral_lo` bigint NOT NULL,\n `remaining_collateral_hi` bigint NOT NULL,\n `remaining_funds_lo` bigint NOT NULL,\n `remaining_funds_hi` bigint NOT NULL,\n `revision_number` bigint NOT NULL,\n `upload_spending_lo` bigint NOT NULL,\n `upload_spending_hi` bigint NOT NULL,\n `download_spending_lo` bigint NOT NULL,\n `download_spending_hi` bigint NOT NULL,\n `fund_account_spending_lo` bigint NOT NULL,\n `fund_account_spending_hi` bigint NOT NULL,\n `delete_spending_lo` bigint NOT NULL,\n `delete_spending_hi` bigint NOT NULL,\n `list_spending_lo` bigint NOT NULL,\n `list_spending_hi` bigint NOT NULL,\n PRIMARY KEY (`id`),\n KEY `idx_contracts_fc_id` (`fcid`),\n KEY `idx_contracts_host` (`host`),\n KEY `idx_remaining_collateral` (`remaining_collateral_lo`,`remaining_collateral_hi`),\n KEY `idx_contracts_revision_number` (`revision_number`),\n KEY `idx_upload_spending` (`upload_spending_lo`,`upload_spending_hi`),\n KEY `idx_download_spending` (`download_spending_lo`,`download_spending_hi`),\n KEY `idx_fund_account_spending` (`fund_account_spending_lo`,`fund_account_spending_hi`),\n KEY `idx_contracts_timestamp` (`timestamp`),\n KEY `idx_remaining_funds` (`remaining_funds_lo`,`remaining_funds_hi`),\n KEY `idx_delete_spending` (`delete_spending_lo`,`delete_spending_hi`),\n KEY `idx_list_spending` (`list_spending_lo`,`list_spending_hi`)\n) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;\n\n-- dbPerformanceMetric\nCREATE TABLE `performance` (\n `id` bigint unsigned NOT NULL AUTO_INCREMENT,\n `created_at` datetime(3) DEFAULT NULL,\n `timestamp` bigint NOT NULL,\n `action` varchar(191) NOT NULL,\n `host` varbinary(32) NOT NULL,\n `origin

2024-02-27T13:45:38Z ERROR stores/sql.go:472 Error 1292 (22007): Incorrect datetime value: '0000-00-00' for column 'last_announcement' at row 1 {"elapsed": "2.010ms", "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:38.134','<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`)"}