Skip to content

use SingleAddressWallet from coreutils #5070

use SingleAddressWallet from coreutils

use SingleAddressWallet from coreutils #5070

Triggered via pull request February 27, 2024 17:03
Status Failure
Total duration 2m 11s
Artifacts

test.yml

on: pull_request
Matrix: test
Fit to window
Zoom out
Zoom in

Annotations

38 errors and 2 warnings
test (ubuntu-latest, 1.22)
59/60 tests failed
Test go.sia.tech/renterd/stores/TestAutopilotStore failed in 0.31s: stores/migrations_utils.go#L18
2024-02-27T17:04:31Z ERROR stores/migrations_utils.go:18 Error 1170 (42000): BLOB/TEXT column 'source' used in key specification without a key length {"elapsed": "282.380ms", "rows": 0, "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 NUL
Test go.sia.tech/renterd/stores/TestAutopilotStore failed in 0.31s: stores/autopilot_test.go#L14
autopilot_test.go:14: failed to create SQLStore failed to perform migrations: failed to migrate: failed to init schema: Error 1170 (42000): BLOB/TEXT column 'source' used in key specification without a key length
Test go.sia.tech/renterd/stores/TestSQLHostDB failed in 0.31s: stores/migrations_utils.go#L18
2024-02-27T17:04:31Z ERROR stores/migrations_utils.go:18 Error 1170 (42000): BLOB/TEXT column 'source' used in key specification without a key length {"elapsed": "287.180ms", "rows": 0, "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 NUL
Test go.sia.tech/renterd/stores/TestSQLHostDB failed in 0.31s: stores/hostdb_test.go#L28
hostdb_test.go:28: failed to create SQLStore failed to perform migrations: failed to migrate: failed to init schema: Error 1170 (42000): BLOB/TEXT column 'source' used in key specification without a key length
Test go.sia.tech/renterd/stores/TestSQLHosts failed in 0.31s: stores/migrations_utils.go#L18
2024-02-27T17:04:31Z ERROR stores/migrations_utils.go:18 Error 1170 (42000): BLOB/TEXT column 'source' used in key specification without a key length {"elapsed": "291.972ms", "rows": 0, "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 NUL
Test go.sia.tech/renterd/stores/TestSQLHosts failed in 0.31s: stores/hostdb_test.go#L131
hostdb_test.go:131: failed to create SQLStore failed to perform migrations: failed to migrate: failed to init schema: Error 1170 (42000): BLOB/TEXT column 'source' used in key specification without a key length
Test go.sia.tech/renterd/stores/TestSearchHosts failed in 0.35s: stores/migrations_utils.go#L18
2024-02-27T17:04:32Z ERROR stores/migrations_utils.go:18 Error 1170 (42000): BLOB/TEXT column 'source' used in key specification without a key length {"elapsed": "305.640ms", "rows": 0, "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 NUL
Test go.sia.tech/renterd/stores/TestSearchHosts failed in 0.35s: stores/hostdb_test.go#L213
hostdb_test.go:213: failed to create SQLStore failed to perform migrations: failed to migrate: failed to init schema: Error 1170 (42000): BLOB/TEXT column 'source' used in key specification without a key length
Test go.sia.tech/renterd/stores/TestRecordScan failed in 0.32s: stores/migrations_utils.go#L18
2024-02-27T17:04:32Z ERROR stores/migrations_utils.go:18 Error 1170 (42000): BLOB/TEXT column 'source' used in key specification without a key length {"elapsed": "297.267ms", "rows": 0, "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 NUL
test (ubuntu-latest, 1.21)
The job was canceled because "ubuntu-latest_1_22" failed.
test (ubuntu-latest, 1.21)
59/60 tests failed
Test go.sia.tech/renterd/stores/TestAutopilotStore failed in 0.43s: stores/migrations_utils.go#L18
2024-02-27T17:04:35Z ERROR stores/migrations_utils.go:18 Error 1170 (42000): BLOB/TEXT column 'source' used in key specification without a key length {"elapsed": "397.135ms", "rows": 0, "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 NUL
Test go.sia.tech/renterd/stores/TestAutopilotStore failed in 0.43s: stores/autopilot_test.go#L14
autopilot_test.go:14: failed to create SQLStore failed to perform migrations: failed to migrate: failed to init schema: Error 1170 (42000): BLOB/TEXT column 'source' used in key specification without a key length
Test go.sia.tech/renterd/stores/TestSQLHostDB failed in 0.42s: stores/migrations_utils.go#L18
2024-02-27T17:04:36Z ERROR stores/migrations_utils.go:18 Error 1170 (42000): BLOB/TEXT column 'source' used in key specification without a key length {"elapsed": "398.752ms", "rows": 0, "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 NUL
Test go.sia.tech/renterd/stores/TestSQLHostDB failed in 0.42s: stores/hostdb_test.go#L28
hostdb_test.go:28: failed to create SQLStore failed to perform migrations: failed to migrate: failed to init schema: Error 1170 (42000): BLOB/TEXT column 'source' used in key specification without a key length
Test go.sia.tech/renterd/stores/TestSQLHosts failed in 0.4s: stores/migrations_utils.go#L18
2024-02-27T17:04:36Z ERROR stores/migrations_utils.go:18 Error 1170 (42000): BLOB/TEXT column 'source' used in key specification without a key length {"elapsed": "370.927ms", "rows": 0, "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 NUL
Test go.sia.tech/renterd/stores/TestSQLHosts failed in 0.4s: stores/hostdb_test.go#L131
hostdb_test.go:131: failed to create SQLStore failed to perform migrations: failed to migrate: failed to init schema: Error 1170 (42000): BLOB/TEXT column 'source' used in key specification without a key length
Test go.sia.tech/renterd/stores/TestSearchHosts failed in 0.43s: stores/migrations_utils.go#L18
2024-02-27T17:04:37Z ERROR stores/migrations_utils.go:18 Error 1170 (42000): BLOB/TEXT column 'source' used in key specification without a key length {"elapsed": "388.987ms", "rows": 0, "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 NUL
Test go.sia.tech/renterd/stores/TestSearchHosts failed in 0.43s: stores/hostdb_test.go#L213
hostdb_test.go:213: failed to create SQLStore failed to perform migrations: failed to migrate: failed to init schema: Error 1170 (42000): BLOB/TEXT column 'source' used in key specification without a key length
Test go.sia.tech/renterd/stores/TestRecordScan failed in 0.44s: stores/migrations_utils.go#L18
2024-02-27T17:04:37Z ERROR stores/migrations_utils.go:18 Error 1170 (42000): BLOB/TEXT column 'source' used in key specification without a key length {"elapsed": "412.582ms", "rows": 0, "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 NUL
test (macos-latest, 1.22)
The job was canceled because "ubuntu-latest_1_22" failed.
test (macos-latest, 1.22)
The operation was canceled.
test (windows-latest, 1.21)
The job was canceled because "ubuntu-latest_1_22" failed.
test (windows-latest, 1.21)
The operation was canceled.
test (windows-latest, 1.22)
The job was canceled because "ubuntu-latest_1_22" failed.
test (windows-latest, 1.22)
The operation was canceled.
test (macos-latest, 1.21)
The job was canceled because "ubuntu-latest_1_22" failed.
test (macos-latest, 1.21)
Cannot open: File exists
test (macos-latest, 1.21)
Cannot open: File exists
test (macos-latest, 1.21)
Cannot open: File exists
test (macos-latest, 1.21)
Cannot open: File exists
test (macos-latest, 1.21)
Cannot open: File exists
test (macos-latest, 1.21)
Cannot open: File exists
test (macos-latest, 1.21)
Cannot open: File exists
test (macos-latest, 1.21)
Cannot open: File exists
test (macos-latest, 1.21)
Cannot open: File exists
test (macos-latest, 1.21)
Cannot open: File exists
test (ubuntu-latest, 1.22)
Node.js 16 actions are deprecated. Please update the following actions to use Node.js 20: actions/checkout@v3, actions/setup-go@v3, golangci/golangci-lint-action@v3, SiaFoundation/action-golang-analysis@HEAD, n8maninger/action-golang-test@v1. For more information see: https://github.blog/changelog/2023-09-22-github-actions-transitioning-from-node-16-to-node-20/.
test (macos-latest, 1.21)
Failed to restore: "/usr/local/bin/gtar" failed with error: The process '/usr/local/bin/gtar' failed with exit code 2