Skip to content

bug: Failed to Write in MySQL Error 1071 (42000) #13486

@bbernays

Description

@bbernays

Is there an existing issue for this?

  • I have searched the existing issues

Current Behavior

Run a sync and get the following error:

ERR exiting with error error="failed to sync v3 source aws: write client returned error (insert): plugin returned error: failed to write: Error 1071 (42000): Specified key was too long; max key length is 3072 bytes" module=cli

Reported on discord here: https://discord.com/channels/872925471417962546/1146540225997320272

Expected Behavior

No error

CloudQuery (redacted) config

mysql.yml:

kind: destination
spec:
  name:     "mysql"
  registry: "github"
  path:     "cloudquery/mysql"
  version:  "v3.0.4"
  spec:
    connection_string: "user:password@host/cloudquery"

aws.yml:

kind: source
spec:
  name: "aws"
  path: "cloudquery/aws"
  version: "v22.8.2"
  tables: ["*"]
  destinations: ["mysql"]
`

cloudquery version:
$ cloudquery  --version
cloudquery version 3.16.1


### Steps To Reproduce

AWS_PROFILE=some-profile cloudquery sync ./cloudquery-config/



### CloudQuery (redacted) logs

none

### CloudQuery version

3.16.1

### Additional Context

_No response_

### Pull request (optional)

- [ ] I can submit a pull request

Metadata

Metadata

Assignees

Labels

No labels
No labels

Type

No type

Projects

No projects

Milestone

No milestone

Relationships

None yet

Development

No branches or pull requests

Issue actions