Aurora PostgreSQL upgrade 11.13 -> 12.8 failed
Then we try to upgrade 11.13 cluster to 12.8 it fails, in logs I can find only errors like this:
2021-12-08 06:55:26.080 GMT 7934 LOG: background worker "plans update worker" (PID 8004) exited with exit code 1 command: "/rdsdbbin/aurora-18.104.22.168.0.8865.0/bin/pg_ctl" -w -D "/rdsdbdata/db_old" -o "--config_file=/rdsdbdata/config_old/postgresql.conf" -m fast stop >> "pg_upgrade_server.log" 2>&1 waiting for server to shut down....2021-12-08 06:55:31.615 GMT 7934 LOG: received fast shutdown request 2021-12-08 06:55:31.619 GMT 7934 LOG: aborting any active transactions 2021-12-08 06:55:31.622 GMT 7934 LOG: background worker "logical replication launcher" (PID 8005) exited with exit code 1 2021-12-08 06:55:31.623 GMT 8000 LOG: shutting down .............sh: /rdsdbbin/aurora-22.214.171.124.0.5790.0/bin/curl: /apollo/sbin/envroot: bad interpreter: No such file or directory 2021-12-08 06:55:44.671 GMT 7934 FATAL: Can't handle storage runtime process crash 2021-12-08 06:55:44.671 GMT 7934 LOG: database system is shut down done server stopped
Please, help me to solve it.
Hello, I have been checking various sources about this problem, usually it is a low resource problem.
I recommend you create a clone of your database in production, in this clone increase the instance size and launch the upgrate to test if you still have the same problem.
The error shared seems lack some info. Have you noticed something similar to:
"ERROR: could not access file" "ERROR: cache lookup failed for database 1" "FATAL: database "template1" does not exist"
I would recommend share a full picture of the log here. Otherwise, double check the major steps mentioned in https://docs.aws.amazon.com/AmazonRDS/latest/AuroraUserGuide/USER_UpgradeDBInstance.PostgreSQL.html#USER_UpgradeDBInstance.PostgreSQL.MajorVersion
--> Any extensions need to be upgraded first? --> Any extensions need to be dropped? (chkpass, tsearch2)
Upgrade for Amazon Aurora Serverless v1 PostgreSQL-compatible edition 10.x end of support is January 31, 2023asked a month ago
How to debug In-place upgrade of the engine to the new target version 8.0.mysql_aurora.3.01.0 is not supported.asked 3 months ago
RDS Aurora - stop upgrading processAccepted Answerasked a month ago
Aurora PostgreSQL upgrade 11.13 -> 12.8 failedasked 5 months ago
Major Version Upgrades in Aurora Cluster With Replicas - Can it be done in batches ?Accepted Answerasked 3 months ago
Aurora Postgres cluster failed to upgrade from 13.4 to 13.4.2 at maintenance windowasked a month ago
Cannot upgrade RDS PostgreSQL 9.5 to 12.5asked 3 months ago
Major Version Upgrade Aurora PostgreSQL 11asked 2 years ago
Move RDS postgresql database to Aurora ServerlessAccepted Answerasked 3 years ago
EKS Upgrade Failed from 1.13 to 1.14asked 2 years ago