Aurora PostgreSQL upgrade 11.13 - 12.8 failed

Question

Hello!

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-11.13.11.13.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-12.8.12.8.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.

Answer

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.

Answer

Hi,

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

For example:

--> Any extensions need to be upgraded first?
--> Any extensions need to be dropped? (chkpass, tsearch2)

Aurora PostgreSQL upgrade 11.13 -> 12.8 failed

相关内容