search

sbluhm / uyuni

Source code for Uyuni
https://www.uyuni-project.org/
GNU General Public License v2.0
1 stars 0 forks source link

spacewalk-service start errors out on uyuni-check-database (version 220400.2.1.uyuni2) #130

Closed ChrisN812 closed 5 months ago

ChrisN812 commented 5 months ago

Problem description

Recently upgraded to your development release to test new features. Start up of spacewalk has error:

Jun 06 09:44:19 serverhostname spacewalk-startup-helper[1713]: psql: error: connection to server at "localhost" (127.0.0.1), port 5432 failed: FATAL: the database system is starting up Jun 06 09:44:19 serverhostname spacewalk-startup-helper[1767]: report_db_host = localhost Jun 06 09:44:20 serverhostname spacewalk-startup-helper[1944]: Your database schema already matches the schema package version [susemanager-schema-5.0.7-220400.2.1.uyuni2]. Jun 06 09:44:20 serverhostname spacewalk-startup-helper[1944]: Schema upgrade: [susemanager-schema-5.0.7-220400.2.1.uyuni2] -> [susemanager-schema-5.0.7-220400.2.1.uyuni2] Jun 06 09:44:21 serverhostname spacewalk-startup-helper[2435]: Your database schema already matches the schema package version [uyuni-reportdb-schema-5.0.5-220400.2.1.uyuni2]. Jun 06 09:44:21 serverhostname spacewalk-startup-helper[2435]: Schema upgrade: [uyuni-reportdb-schema-5.0.5-220400.2.1.uyuni2] -> [uyuni-reportdb-schema-5.0.5-220400.2.1.uyuni2] Jun 06 09:44:22 serverhostname systemd[1]: Finished Uyuni check database. Jun 06 10:35:24 serverhostname systemd[1]: uyuni-check-database.service: Deactivated successfully. Jun 06 10:35:24 serverhostname systemd[1]: Stopped Uyuni check database. Jun 06 10:35:24 serverhostname systemd[1]: uyuni-check-database.service: Consumed 1.535s CPU time.

Steps to reproduce

  1. Start with working 24.02 version. Followed upgrade steps to dev release

  3. ...

Uyuni version

]# rpm -qa | grep -i uyuni-server
Uyuni-Server-release-2023.12-230900.210.2.uyuni3.x86_64

Uyuni proxy version (if used)

not installed

Useful logs

No response

Additional information

I know is your dev version. Appreciate your efforts in porting to rhel. Any method to roll back?

sbluhm commented 5 months ago

Hey @ChrisN812 ,

can you please elaborate a bit on these topics:

  1. Which version/repo are you coming from?
  2. Which repo are you using to update?
  3. Which version would you like to roll back to? (I assume no backup?)

From the posted log, it looks OK. Repeated restarts do not show any improvement in position?

I have the following release repos: uyuni-2023.09 uyuni-2023.10 uyuni-2023.12 uyuni-2024.01 uyuni-2024.02

The current dev repos (after 2024.04) are not working anymore due to a Java packaging issue.

ChrisN812 commented 5 months ago

I purged that system and trying a fresh installation. Hitting an issue with file permissions on:

-rw------- 1 root root 8353 Jun 12 14:49 spacewalk.crt

Its being created root:root 600 When postgresql-14 starts it needs to read this certificate and is unable to, setting perms to 644 allows pgsql to start, but the installation was previously halted due to this permission issue on pgsql startup and is invalid.

Closing this ticket with comment of 'Self induced error due to trying to install development version'