Last active
January 26, 2021 14:48
-
-
Save dlangille/20349b1ecd6c708eb566d6a8b31b7892 to your computer and use it in GitHub Desktop.
could not load library "/usr/local/lib/postgresql/llvmjit.so"
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
freshports.org=# SELECT DISTINCT | |
freshports.org-# PA.category, | |
freshports.org-# PA.name AS port, | |
freshports.org-# coalesce(V.date_modified, V.date_entry, V.date_discovery) AS | |
freshports.org-# date, | |
freshports.org-# V.vid, | |
freshports.org-# to_char(coalesce(V.date_modified, V.date_entry, | |
freshports.org(# V.date_discovery)::date, 'Mon DD') AS date_formatted, | |
freshports.org-# V.date_modified IS NULL AS new, | |
freshports.org-# lower(name) | |
freshports.org-# FROM commit_log_ports_vuxml CLPV, vuxml V, ports_active PA | |
freshports.org-# WHERE CLPV.vuxml_id = V.id | |
freshports.org-# AND CLPV.port_id = PA.id | |
freshports.org-# ORDER BY coalesce(V.date_modified, V.date_entry, V.date_discovery) | |
freshports.org-# desc, lower(name) | |
freshports.org-# LIMIT 15; | |
ERROR: could not load library "/usr/local/lib/postgresql/llvmjit.so": Shared object "libLLVM-9.so" not found, required by "llvmjit.so" | |
freshports.org=# \q |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
[dan@supernews:~] $ ls -l /usr/local/lib/postgresql/llvmjit.so | |
-rwxr-xr-x 1 root wheel 161712 Jan 4 04:41 /usr/local/lib/postgresql/llvmjit.so | |
[dan@supernews:~] $ pkg which /usr/local/lib/postgresql/llvmjit.so | |
/usr/local/lib/postgresql/llvmjit.so was installed by package postgresql12-server-12.5 | |
[dan@supernews:~] $ |
Upgrades today:
Jan 26 13:22:56 supernews pkg[52257]: perl5 upgraded: 5.32.0_1 -> 5.32.1_1
Jan 26 13:22:59 supernews pkg[52257]: pinentry-curses-1.1.1 installed
Jan 26 13:23:00 supernews pkg[52257]: sqlite3 upgraded: 3.34.0,1 -> 3.34.1,1
Jan 26 13:23:02 supernews pkg[52257]: pinentry upgraded: 1.1.0_7 -> 1.1.1
Jan 26 13:23:03 supernews pkg[52257]: p5-IO-Socket-SSL upgraded: 2.068 -> 2.069
Jan 26 13:23:07 supernews pkg[52257]: bind-tools upgraded: 9.16.10 -> 9.16.11
Jan 26 13:23:14 supernews pkg[52257]: freshports-www upgraded: 1.52_1 -> 1.53
Jan 26 13:23:17 supernews pkg[52257]: bind916 upgraded: 9.16.10 -> 9.16.11
Jan 26 14:40:44 supernews pkg[85075]: freshports-www upgraded: 1.53 -> 1.53.1
Going back farther we see:
[dan@supernews:~] $ grep postgresql12-server /var/log/messages.1
Jan 24 20:23:30 supernews pkg[76511]: postgresql12-server upgraded: 12.4 -> 12.5
That was the cause.
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment
Restarted PostgreSQL - problem went away.