GoogleCloudPlatform / GoogleCloudPlatform/spanner-migration-tool

Database not found error with default parameters

Open
#793 3 comments 0 reactions 0 assignees View on GitHub
Dominant language
PLpgSQL
Stars
155
Forks
83
Avg merge
3d 7h
Merged PRs (30d)
6

Description

## Expected Behavior
It should work successful.

## Actual Behavior
2024-03-17T16:58:47.045Z fatal cmd/data.go:97 FATAL error {"error": "can't finish database migration for db mysql_2024-03-17_17df-e0a7: can't migrate database: error while validating existing database: target database doesn't exist"}
github.com/GoogleCloudPlatform/spanner-migration-tool/cmd.(*DataCmd).Execute.func1
/tmpfs/src/git/harbourbridge/cmd/data.go:97
github.com/GoogleCloudPlatform/spanner-migration-tool/cmd.(*DataCmd).Execute
/tmpfs/src/git/harbourbridge/cmd/data.go:152
github.com/google/subcommands.(*Commander).Execute
/tmpfs/src/git/harbourbridge/vendor/github.com/google/subcommands/subcommands.go:209
github.com/google/subcommands.Execute
/tmpfs/src/git/harbourbridge/vendor/github.com/google/subcommands/subcommands.go:492
main.main
/tmpfs/src/git/harbourbridge/main.go:58
runtime.main
/tmpfs/src/go/src/runtime/proc.go:250

## Steps to Reproduce the Problem
exported variables:
export GCPProjectID=XXXXX
export SpannerInstanceID=xxx-spanner-instance
export MYSQLHOST=10.132.0.18
export MYSQLUSER=dbuser
export MYSQLDATABASE=xxx
export MYSQLPORT=3306
export MYSQLPWD=xxxxx

1. spanner-migration-tool schema --source=MySQL
1. spanner-migration-tool data --source=MySQL --source-profile="streamingCfg=streaming_cfg.json" --target-profile='project=XXXXX,instance=xxx-spanner-instance' --session=mysql_2024-03-17_524c-7ffe.session.json

## Specifications
Latest gcloud on GCE VM.

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.