By using AWS re:Post, you agree to the Terms of Use
/Aurora PostgreSQL upgrade 11.13 -> 12.8 failed/

Aurora PostgreSQL upgrade 11.13 -> 12.8 failed

0

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.

asked 5 months ago58 views
2 Answers
0

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.

answered 5 months ago
0

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)

SUPPORT ENGINEER
answered 5 months ago

You are not logged in. Log in to post an answer.

A good answer clearly answers the question and provides constructive feedback and encourages professional growth in the question asker.

Guidelines for Answering Questions