View Single Post
  #1   (View Single Post)  
Old 29th August 2017
ed.n1n2 ed.n1n2 is offline
Port Guard
 
Join Date: Mar 2015
Posts: 30
Default Issue with PostgreSQL 9.6.2 and Perl on OpenBSD 6.1

Hello,

I'm attempting to "upgrade" to 6.1 and I'm having issues with the Perl extensions in PostgreSQL. This is a new machine and OpenBSD 6.1 is working fine otherwise. I've reproduced the error 3 times on different machines now. It happens on every 6.1 we install.

Code:
Util.c: loadable library and perl binaries are mismatched (got handshake key 0xcd80000, needed 0xca80000)
I get this anytime I attempt to use the Perl extensions (plperlu). Trying to "install" them using "CREATE EXTENSION plperlu;" into a database raises the error too.

Not finding a lot on the web. One gentleman thinks it is a handshake function added in Perl 5.24 that scans all the libraries for mismatches.

I've downloaded the src and ports for OpenBSD 6.1, but I've never worked with them. Scanning them for PostgreSQL only finds the port. I can't find PostgreSQL in the src.

I'm not sure if I need to debug PostgreSQL, Perl, or whatever uses Util.c. My thinking was finding whatever line of code that calls this function, deleting it, recompiling it, and then seeing if the mismatch error comes up. I don't think it would.

Any ideas or suggestions to fix this is appreciated.
Reply With Quote