By using AWS re:Post, you agree to the Terms of Use
AWS re:Postre:Post
/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.

Topics
Database
Tags
Aurora PostgreSQL
Aleksei Manannikov
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.

Damianenko Max Zeballos Torres
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
Kevin_Z
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

Relevant questions