klesh commented on issue #4545:
URL:
https://github.com/apache/incubator-devlake/issues/4545#issuecomment-1467226016
> > @ankgupta99 @iholovin May I ask which approach did you use to deploy and
upgrade? Was it docker-compose or helm?
>
> Because of the DevOps policies at my company, I had to deploy containers
with Terraform and ECS tasks. For the database, I used Aurora MySQL.
>
> It was working before with Aurora Postgres though 🤔
>
> I checked the MySQL logs and discovered the following error corresponding
to backend's requests:
>
> ```
> Aborted connection 87 to db: 'devlake' user: 'root' host: '10.204.0.214'
(Got an error reading communication packets). (sql_connect.cc:845)
> ```
>
> Here is what I used for `aws_rds_cluster`:
>
> ```
> ...
>
> instance_class = "db.r6g.large"
> engine = "aurora-mysql"
> engine_version = "8.0.mysql_aurora.3.03.0"
> ```
>
> And `aws_rds_cluster_parameter_group`:
>
> ```
> ...
>
> family = "aurora-mysql8.0"
>
> parameter {
> name = "character_set_server"
> value = "utf8mb4"
> }
>
> parameter {
> name = "collation_server"
> value = "utf8mb4_bin"
> }
> ```
Since you had already switch to `mysql` from `pg`, I suggest that you can
wipe out the old deployment and redeploy a new one to see if the problem
persists.
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: [email protected]
For queries about this service, please contact Infrastructure at:
[email protected]
