chef-server icon indicating copy to clipboard operation
chef-server copied to clipboard

ERROR: relation "keys" does not exist

Open pacotejeda opened this issue 4 years ago • 4 comments

fter run chef-server-ctl reconfigure I have this error, Any idea? * ruby_block[bootstrap-chef-server-data] action run ================================================================================ Error executing action run on resource 'ruby_block[bootstrap-chef-server-data]' ================================================================================ PG::UndefinedTable ------------------ ERROR: relation "keys" does not exist LINE 1: INSERT INTO keys (id, key_name, public_key, key_version, cre...

chef-stacktrace.txt

pacotejeda avatar May 18 '21 20:05 pacotejeda

@pacotejeda Can you please give details on the system you're running this on, the version of Infra Serve, and if this was an upgrade from a previous version?

tas50 avatar May 18 '21 20:05 tas50

Thanks for your help Its a fresh new installation and I have tried to versiones with same error: chef-server-core-12.19.31-1.el7.x86_64.rpm and chef-server-core-13.0.16-1.el7.x86_64.rpm
The thing is that I have done this same installation under Centos 8 without problems

cat /etc/redhat-release

Red Hat Enterprise Linux release 8.2 (Ootpa)

pacotejeda avatar May 18 '21 20:05 pacotejeda

Hi,

Hope you solved this since then, if not:

That happened to me. it looks like in some cases, if an error occurs during install (in my case, libnsl was missing, which probably is what happened to you), chef fails to graciously install in later attempts. I forcefully reinstalled chef and deleted all generated files to restart the install from scratch:

dnf erase -y chef-server-core
rm -rf /var/opt/opscode # Ensure that no subfolder belongs to a different package with `rpm -q --what-provides` before running this 
dnf install -y chef-server-core

CGForeau avatar Jun 14 '21 15:06 CGForeau

We have observed some errors relates to libnsl in our pipelines when we install a build built on older versions of the operating systems on newer ones.

Please let us know if you still see this issue with the latest Chef Infra Server releases.

PrajaktaPurohit avatar May 24 '22 14:05 PrajaktaPurohit