GoogleCloudPlatform / GoogleCloudPlatform/cloudsql-upgrade
Script execution failed with error: 'replicaUpgrade'
- 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
Assessment
This issue has not been assessed yet.