After upgrading controller-1 host fails to swact to controller-1 and then active controller goes back to controller-0
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
StarlingX |
Fix Released
|
Medium
|
Thiago Antonio Miranda |
Bug Description
Brief Description
-----------------
After controller-1 is upgraded controller-0 is unable to swact to controller-1 as active.
Severity
--------
Critical unable to continue upgrade
Steps to Reproduce
------------------
Install StarlingX DX
Reinstall controller-0
Follow the upgrade procedure
Expected Behavior
-----------------
1. Able to swact from controller-0 to controller-1 after controller-1 upgrade.
Actual Behavior
---------------
State what is the actual behavior
Reproducibility
---------------
System Configuration
-------
DC
Last Pass
---------
Timestamp/Logs
--------------
2023-10-
2023-10-
2023-10-
2023-10-
2023-10-
2023-10-
2023-10-
2023-10-
2023-10-
sudo -u postgres /usr/lib/
2023-10-25 21:29:34.582 GMT [1468453] LOG: invalid value for parameter "log_timezone": "UCT"
2023-10-25 21:29:34.582 GMT [1468453] LOG: invalid value for parameter "TimeZone": "UCT"
db=,user= FATAL: configuration file "/etc/postgresq
Test Activity
-------------
Regression
Workaround
----------
sudo vim /etc/postgresql
You system probably has these two parameters set as this:
log_timezone = 'UCT'
timezone = 'UCT'
You have to change to:
log_timezone = 'UTC'
timezone = 'UTC'
Then run:
sudo sm-restart service postgres
Changed in starlingx: | |
status: | New → In Progress |
description: | updated |
Changed in starlingx: | |
importance: | Undecided → Medium |
tags: | added: stx.9.0 stx.config stx.update |
Changed in starlingx: | |
assignee: | nobody → Thiago Antonio Miranda (tamiranda) |
Reviewed: https:/ /review. opendev. org/c/starlingx /stx-puppet/ +/899478 /opendev. org/starlingx/ stx-puppet/ commit/ 5dd9aed8edf0b6c 64ceb8f17168ddf 1d05d3f64f
Committed: https:/
Submitter: "Zuul (22348)"
Branch: master
commit 5dd9aed8edf0b6c 64ceb8f17168ddf 1d05d3f64f
Author: Thiago Miranda <email address hidden>
Date: Fri Oct 27 10:39:17 2023 -0300
Add the configuration of postgresql.conf parameters timezone and log_timezone through puppet
This update adds the timezone and log_timezone to postgresql.conf trough
puppet.
Test Plan:
PASS: Verify after a lock/unlock the postgresql.conf file should have params
timezone and log_timezone equal to platform config timezone param (UTC)
PASS: Verify after a bootstrap the postgresql.conf file should have params
timezone and log_timezone equial to platform config timezone param (UTC)
PASS: Verify after controller-1 is upgraded controller-0 is able to swact
to controller-1 as active
Closes-Bug: 2041696 755f671998d75c7 2f3f8621603
Change-Id: Id328420a33c6aa
Signed-off-by: Thiago Miranda <email address hidden>