findmissing: Update to MySQL 8.0 MySQL 8.0 supports more operations than MySql 5.7, so let's update to it. To do this, we had to create a new database and copy the contents of the old database to it. Here we just need to update the pointers to the new database. BUG=None TEST=Run helper command Change-Id: Ifa183b273c3a12afe07767999c20d91f47802701 Reviewed-on: https://chromium-review.googlesource.com/c/chromiumos/platform/dev-util/+/2628706 Reviewed-by: Curtis Malainey <cujomalainey@chromium.org> Commit-Queue: Guenter Roeck <groeck@chromium.org> Tested-by: Guenter Roeck <groeck@chromium.org>
diff --git a/contrib/findmissing/config/systemd/cloud-sql-proxy.service b/contrib/findmissing/config/systemd/cloud-sql-proxy.service index b351179..ba74d26 100644 --- a/contrib/findmissing/config/systemd/cloud-sql-proxy.service +++ b/contrib/findmissing/config/systemd/cloud-sql-proxy.service
@@ -8,7 +8,7 @@ User=root Type=simple Environment="HOME=/home/chromeos_patches" -ExecStart=/usr/bin/cloud_sql_proxy -instances=google.com:chromeos-missing-patches:us-central1:linux-patches-sql=tcp:3306 -credential_file=/home/chromeos_patches/secrets/linux_patches_robot_key.json +ExecStart=/usr/bin/cloud_sql_proxy -instances=google.com:chromeos-missing-patches:us-central1:linux-patches-mysql-8=tcp:3306 -credential_file=/home/chromeos_patches/secrets/linux_patches_robot_key.json Restart=on-failure RestartSec=10 KillMode=process
diff --git a/contrib/findmissing/util.py b/contrib/findmissing/util.py index 27d4503..08ad408 100755 --- a/contrib/findmissing/util.py +++ b/contrib/findmissing/util.py
@@ -97,7 +97,7 @@ try: set_gcloud_project_config() sql_instance_cmd = ['gcloud', 'sql', 'instances', 'describe', - 'linux-patches-sql', '--format=value[](connectionName)'] + 'linux-patches-mysql-8', '--format=value[](connectionName)'] sql_instance = subprocess.check_output(sql_instance_cmd, encoding='utf-8').rstrip() cloudsql_cmd = ['cloud_sql_proxy', '-instances=%s=tcp:3306' % sql_instance]