B&R operation failed when trying to run psql command
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
StarlingX |
Fix Released
|
Medium
|
Guilherme Schons |
Bug Description
Brief Description
-----------------
Performed successful patches then attempted B&R procedure. The restore failed to try to run a psql command:
psql: error: could not connect to server: No such file or directory
Is the server running locally and accepting
Checking the log files, it looks like the postgresql cluster is having problems getting the /etc/ssl/
Severity
--------
standard
Steps to Reproduce
------------------
Upload, apply, and install RR patches;
Perform backup operation with ansible-playbook and copy .tgz off-box;
Install the controller again and run the restore ansible playbook.
Expected Behavior
------------------
The restore completes successfully
Actual Behavior
----------------
The restore fails to try to run a psql command.
Reproducibility
---------------
100% reproducible.
System Configuration
-------
Tested on standard and AIO-SX. But probably happens in different environments.
Branch/Pull Time/Commit
-------
Master, 2022-12-18
Last Pass
---------
N/A
Timestamp/Logs
--------------
2022-12-21 20:34:44,669 p=2690 u=sysadmin n=ansible | TASK [restore-
2022-12-21 20:34:44,669 p=2690 u=sysadmin n=ansible | Wednesday 21 December 2022 20:34:44 +0000 (0:00:00.020) 0:34:21.150 ****
2022-12-21 20:34:45,149 p=2690 u=sysadmin n=ansible | fatal: [localhost]: FAILED! => changed=true
cmd: psql -c "update i_host set administrative=
delta: '0:00:00.049671'
end: '2022-12-21 20:34:45.125470'
msg: non-zero return code
rc: 2
start: '2022-12-21 20:34:45.075799'
stderr: |-
psql: error: could not connect to server: No such file or directory
Is the server running locally and accepting
stderr_lines: <omitted>
stdout: ''
stdout_lines: <omitted>
2022-12-21 20:34:45,150 p=2690 u=sysadmin n=ansible | PLAY RECAP
Test Activity
-------------
Developer testing
Workaround
----------
Remove the /etc/ssl/
Changed in starlingx: | |
importance: | Undecided → Medium |
tags: | added: stx.8.0 stx.update |
Changed in starlingx: | |
assignee: | nobody → Guilherme Schons (gdossant) |
Fix proposed to branch: master /review. opendev. org/c/starlingx /ansible- playbooks/ +/872208
Review: https:/