[Solved] Postgres.service after pacman -Syu

leizzer · 2017-05-12 18:39:15

Hello,

I can't find an answer to my problem. Probably because I am a little frustrated.
I recently upgraded my system and it felt apart. (eg: taskbar disappeared, wifi stops working half day after the upgrade ) but I'm more concern about Postgres because I need it for work.

I have been trying to run "sudo systemctl start postgres.service" without luck.

➤ sudo systemctl start postgresql.service
[sudo] password for leizzer: 
Job for postgresql.service failed because the control process exited with error code.
See "systemctl status postgresql.service" and "journalctl -xe" for details.

status

➤ systemctl status postgresql.service
● postgresql.service - PostgreSQL database server
   Loaded: loaded (/usr/lib/systemd/system/postgresql.service; enabled; vendor preset: disabled)
   Active: failed (Result: exit-code) since Fri 2017-05-12 15:27:25 -03; 43s ago
  Process: 27336 ExecStart=/usr/bin/pg_ctl -s -D ${PGROOT}/data start -w -t 120 (code=exited, status=127)
  Process: 27328 ExecStartPre=/usr/bin/postgresql-check-db-dir ${PGROOT}/data (code=exited, status=0/SUCCESS)

May 12 15:27:25 arthuria-II systemd[1]: Starting PostgreSQL database server...
May 12 15:27:25 arthuria-II postgres[27336]: /usr/bin/pg_ctl: error while loading shared libraries: libssl.so.1.1: cannot open shared object file: Permission denied
May 12 15:27:25 arthuria-II systemd[1]: postgresql.service: Control process exited, code=exited status=127
May 12 15:27:25 arthuria-II systemd[1]: Failed to start PostgreSQL database server.
May 12 15:27:25 arthuria-II systemd[1]: postgresql.service: Unit entered failed state.
May 12 15:27:25 arthuria-II systemd[1]: postgresql.service: Failed with result 'exit-code'.

journalctl

May 12 15:27:25 arthuria-II org.gnome.Nautilus[3987]: fixme:exec:SHELL_execute flags ignored: 0x00000100
May 12 15:27:25 arthuria-II sudo[27122]:  leizzer : TTY=pts/0 ; PWD=/home/leizzer/; USER=root ; COMMAND=/usr/bin/systemctl start postgresql.service
May 12 15:27:25 arthuria-II sudo[27122]: pam_unix(sudo:session): session opened for user root by (uid=0)
May 12 15:27:25 arthuria-II systemd[1]: Starting PostgreSQL database server...
-- Subject: Unit postgresql.service has begun start-up
-- Defined-By: systemd
-- Support: http://lists.freedesktop.org/mailman/listinfo/systemd-devel
-- 
-- Unit postgresql.service has begun starting up.
May 12 15:27:25 arthuria-II org.gnome.Nautilus[3987]: fixme:exec:SHELL_execute flags ignored: 0x00000100
May 12 15:27:25 arthuria-II postgres[27336]: /usr/bin/pg_ctl: error while loading shared libraries: libssl.so.1.1: cannot open shared object file: Permission denied
May 12 15:27:25 arthuria-II systemd[1]: postgresql.service: Control process exited, code=exited status=127
May 12 15:27:25 arthuria-II systemd[1]: Failed to start PostgreSQL database server.
-- Subject: Unit postgresql.service has failed
-- Defined-By: systemd
-- Support: http://lists.freedesktop.org/mailman/listinfo/systemd-devel
-- 
-- Unit postgresql.service has failed.
-- 
-- The result is failed.
May 12 15:27:25 arthuria-II systemd[1]: postgresql.service: Unit entered failed state.
May 12 15:27:25 arthuria-II systemd[1]: postgresql.service: Failed with result 'exit-code'.
May 12 15:27:25 arthuria-II sudo[27122]: pam_unix(sudo:session): session closed for user root
May 12 15:27:26 arthuria-II org.gnome.Nautilus[3987]: fixme:exec:SHELL_execute flags ignored: 0x00000100

I had the "libcrypto.so.1.1" problem that lot of people had while upgrading (https://bbs.archlinux.org/viewtopic.php?id=225478) . I ended up downloading the package and linking the file. I'm wondering if that is the problem, now I have both in my system (maybe that is the issue with wifi as well)

➤ ls -l /usr/lib/ | ack libssl
-rwxr-xr-x  1 root root   361408 Apr 21 07:21 libssl3.so
lrwxrwxrwx  1 root root       15 May  7 19:32 libssl.so -> libssl.so.1.0.0
-r-xr-xr-x  1 root root   506600 Apr  5 04:12 libssl.so.1.0.0
lrwxrwxrwx  1 root root       44 May 10 12:25 libssl.so.1.1 -> /home/leizzer/packages/usr/lib/libssl.so.1.1

Thank you for your time and all the documentation available

Last edited by leizzer (2017-05-12 19:58:12)

Slithery · 2017-05-12 19:01:45

leizzer wrote:

I had the "libcrypto.so.1.1" problem that lot of people had while upgrading (https://bbs.archlinux.org/viewtopic.php?id=225478) . I ended up downloading the package and linking the file. I'm wondering if that is the problem, now I have both in my system (maybe that is the issue with wifi as well)
➤ ls -l /usr/lib/ | ack libssl
-rwxr-xr-x  1 root root   361408 Apr 21 07:21 libssl3.so
lrwxrwxrwx  1 root root       15 May  7 19:32 libssl.so -> libssl.so.1.0.0
-r-xr-xr-x  1 root root   506600 Apr  5 04:12 libssl.so.1.0.0
lrwxrwxrwx  1 root root       44 May 10 12:25 libssl.so.1.1 -> /home/leizzer/packages/usr/lib/libssl.so.1.1

That's definitely the issue, symlinking libraries like this is always going to cause problems.

Trilby · 2017-05-12 19:07:35

Yes, that's definitely the problem - your systemctl status output clearly confirms that:

May 12 15:27:25 arthuria-II postgres[27336]: /usr/bin/pg_ctl: error while loading shared libraries: libssl.so.1.1: cannot open shared object file: Permission denied

Repent, and symlink no more.

Specifically, remove your symlink and (re)install openssl and openssl-1.0.

leizzer · 2017-05-12 19:29:54

The thing is that if I remove the symlinks libssl.so.1.1 and libcrypto.so.1.1 pacman stops working.

I'm going to see if I can downgrade pacman and remove the symlinks.

Thanks.

loqs · 2017-05-12 19:40:22

Follow these instructions after removing the symlinks to update all packages and stop performing partial updates.
Pacman#pacman_crashes_during_an_upgrade

Slithery · 2017-05-12 19:40:34

Or just remove the symlinks, and follow these instructions to fully update your system.
https://wiki.archlinux.org/index.php/Pa … an_upgrade

Edit - Too slow

Last edited by Slithery (2017-05-12 19:41:02)

leizzer · 2017-05-12 19:57:42

Thank you for all your help and I am sorry for all the times you have to answer about this issue

I know that some of you will want to hit me XD but my solution was:

1. Keep the symlinks to libssl.so.1.1 and libcrypto.so.1.1
2. sudo pacman -S openssl --force

That kept the symlinks alive while pacman needed it and then overwrite the symlinks itself.

Now I can run postgres.service again I was about to try what the wiki says if this didn't help or made it worse. And my ultimate solution was a fresh install.

Thank you all again. This and the wiki is why I like Arch (I'm still new to arch, though)

I'll have to try the WiFi after work.

Last edited by leizzer (2017-05-12 19:59:21)

Trilby · 2017-05-12 20:30:38

That is a good solution. I was going to suggest using force for the single package.

Arch Linux

#1 2017-05-12 18:39:15

[Solved] Postgres.service after pacman -Syu

#2 2017-05-12 19:01:45

Re: [Solved] Postgres.service after pacman -Syu

#3 2017-05-12 19:07:35

Re: [Solved] Postgres.service after pacman -Syu

#4 2017-05-12 19:29:54

Re: [Solved] Postgres.service after pacman -Syu

#5 2017-05-12 19:40:22

Re: [Solved] Postgres.service after pacman -Syu

#6 2017-05-12 19:40:34

Re: [Solved] Postgres.service after pacman -Syu

#7 2017-05-12 19:57:42

Re: [Solved] Postgres.service after pacman -Syu

#8 2017-05-12 20:30:38

Re: [Solved] Postgres.service after pacman -Syu

Board footer