GoogleCloudPlatform / GoogleCloudPlatform/cloudsql-upgrade

Script execution failed with error: 'replicaUpgrade'

Open
#9 0 comments 2 reactions 0 assignees View on GitHub
Dominant language
No language data
Stars
7
Forks
2
PR merge metrics
No merged PRs in 30d

Description

Hello,
I'm trying to upgrade MySQL 5.7 instance using the tool provided, however I'm facing issues. When I attempt to upgrade the instance I get the following error

```
❯ ./mysql_binary_mac
Matplotlib is building the font cache; this may take a moment.

CloudSQL MySQL version 5.7 to 8.0.31 Upgrade Assessment Report

Open a new session in the terminal and get host by running the following command -
./cloud-sql-proxy ***-svc-project:europe-west2:***-dev

Please provide your Cloud SQL Auth Proxy Host: 127.0.0.1
Please provide your Cloud SQL Auth Proxy Port: 3306

Instance ID: ***-dev
************************************************************
Please provide your SQL Instance PASSWORD: password

Running Assessment ...
Parsing Jinja2 template to HTML...
Converting HTML to PDF...

Assessment finished!
Check out the reports at ./storage/reports

No Conflicting table names in Transactional Data Dictionary

Please check and resolve if any problems detected during assessment
Confirm if all the issues are resolved and good to proceed with upgrade?(yes/no) - yes

Clone skipped for ***-dev
************************************************************

Running Enterprise Upgrade ...

************************************************************
Script execution failed with error: 'replicaUpgrade'
************************************************************

Check out logs -
https://console.cloud.google.com/logs/query;query=resource.type%3D%22cloudsql_database%22%0Aresource.labels.database_id%3D%22***-svc-project:***-dev%22%0Alog_name%3D%22projects%2F***-svc-project%2Flogs%2Fcloudsql.googleapis.com%252Fmysql.err%22

Traceback (most recent call last):
File "start.py", line 417, in
File "start.py", line 173, in upgradeInstance
KeyError: 'replicaUpgrade'

During handling of the above exception, another exception occurred:

Traceback (most recent call last):
File "start.py", line 449, in
NameError: name 'exit' is not defined
[PYI-14588:ERROR] Failed to execute script 'start' due to unhandled exception!
```

config.json
```
{
"projectId": "***-svc-project",
"instanceId": "***-dev",
"user": "***",
"secretId": "",
"password": "",
"machineType": "db-perf-optimized-N-2",
"runAssessment": "yes",
"utilityChecker": "yes",
"cloneSqlInstance": "no",
"enterpriseUpgrade": "yes",
"enterprisePlusUpgrade": "no",
"transactionalDataDictionaryScript": "no",
"databaseFlagScript": "yes",
"grantPermissionsScript": "yes"
}
```

If I select `enterpriseUpgrade: "no"` and execute the tool, assessment report completes without issues. Can you please advise?

Contributor guide

Open the contributing guide

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.