Jonathan Rollans 

Hey #MastoAdmins, I’ve had this same error show up in my dead jobs for a while and I just can’t figure out why it’s happening:

ActiveRecord::StatementInvalid: PG::UndefinedFile: ERROR: could not load library "/usr/lib/postgresql/15/lib/llvmjit.so": libz3.so.4: cannot open shared object file: No such file or directory

The library file is indeed there and everything seems in order. Any suggestions?

#MastoAdmin

Apr 8, 2023 at 7:05pmWeb
Show threadJonathan Rollans Apr 8, 2023
I have been able to get rid of the issue by disabling jit in postgresql, but that seems counterintuitive and I don’t know what effects that’ll have on the database. #MastoAdmin
Show threadHutchApr 10, 2023
@jrollans
Do you have the file libz3.so.4 also, symlinked from the previous path? It may not be where it expects, or the version it wants. I had a similar error from code compiled on a machine with a different glibc version than the target.