I've just upgraded a test lab to the newly committed pgpool-II 3.2.0 and
upgraded postgreSQL databases from 9.1.5 to 9.2.1 with it.
Installing pgpool_regclass was working prior to this upgrade. Now, the
symptom I see is this (lines split for readability):
$ psql -h localhost -p 5433 -U postgres -f pgpool-regclass.sql template1
Password for user postgres:
psql:pgpool-regclass.sql:4: ERROR: could not load library
"/usr/local/lib/postgresql/pgpool-regclass.so": dlopen
(/usr/local/lib/postgresql/pgpool-regclass.so) failed: Cannot load specified
object
The .so resides in that location and is readable:
$ ls -l /usr/local/lib/postgresql/pgpool-regclass.so
-rwxr-xr-x 1 root wheel 7153 Sep 28 18:42
/usr/local/lib/postgresql/pgpool-regclass.so
$ file /usr/local/lib/postgresql/pgpool-regclass.so
/usr/local/lib/postgresql/pgpool-regclass.so: ELF 32-bit LSB shared object,
Intel 80386, version 1, for OpenBSD, dynamically linked, not stripped
Criticality: low. This should remain a single schema.
OpenBSD 5.2-current (GENERIC.MP) #59: Sun Sep 23 09:48:49 EDT 2012
j...@jggimi.homeip.net:/usr/src/sys/arch/i386/compile/GENERIC.MP
cpu0: Intel(R) Core(TM)2 Duo CPU E7200 @ 2.53GHz ("GenuineIntel" 686-class)
2.53 GHz
cpu0:
FPU,V86,DE,PSE,TSC,MSR,PAE,MCE,CX8,APIC,SEP,MTRR,PGE,MCA,CMOV,PAT,PSE36,CFLUSH,DS,ACPI,MMX,FXSR,SSE,SSE2,SS,HTT,TM,PBE,LONG,SSE3,DTES64,MWAIT,DS-CPL,EST,TM2,SSSE3,CX16,xTPR,PDCM,SSE4.1,LAHF
real mem = 2146693120 (2047MB)
avail mem = 2100670464 (2003MB)
mainbus0 at root
bios0 at mainbus0: AT/286+ BIOS, date 02/26/08, BIOS32 rev. 0 @ 0xf0010, SMBIOS
rev. 2.4 @ 0xfb450 (24 entries)
bios0: vendor American Megatrends Inc. version "P1.90" date 02/26/2008
acpi0 at bios0: rev 0
acpi0: sleep states S0 S1 S4 S5
acpi0: tables DSDT FACP APIC MCFG OEMB
acpi0: wakeup devices PCI0(S4) USB1(S4) USB2(S4) USB3(S4) USB4(S4) EHCI(S4)
PS2K(S4) PS2M(S4) UAR1(S4) SLAN(S4) P0PA(S4) SLPB(S4) HDAC(S5)
acpitimer0 at acpi0: 3579545 Hz, 24 bits
acpimadt0 at acpi0 addr 0xfee00000: PC-AT compat
cpu0 at mainbus0: apid 0 (boot processor)
cpu0: apic clock running at 266MHz
cpu1 at mainbus0: apid 1 (application processor)
cpu1: Intel(R) Core(TM)2 Duo CPU E7200 @ 2.53GHz ("GenuineIntel" 686-class)
2.53 GHz
cpu1:
FPU,V86,DE,PSE,TSC,MSR,PAE,MCE,CX8,APIC,SEP,MTRR,PGE,MCA,CMOV,PAT,PSE36,CFLUSH,DS,ACPI,MMX,FXSR,SSE,SSE2,SS,HTT,TM,PBE,LONG,SSE3,DTES64,MWAIT,DS-CPL,EST,TM2,SSSE3,CX16,xTPR,PDCM,SSE4.1,LAHF
ioapic0 at mainbus0: apid 2 pa 0xfec00000, version 3, 24 pins
ioapic1 at mainbus0: apid 3 pa 0xfecc0000, version 3, 24 pins
acpimcfg0 at acpi0 addr 0xe0000000, bus 0-255
acpiprt0 at acpi0: bus 0 (PCI0)
acpiprt1 at acpi0: bus -1 (P0P9)
acpiprt2 at acpi0: bus 3 (P0PA)
acpiprt3 at acpi0: bus 2 (NBPG)
acpiprt4 at acpi0: bus 128 (PCI1)
acpicpu0 at acpi0
acpicpu1 at acpi0
acpibtn0 at acpi0: SLPB
acpibtn1 at acpi0: PWRB
bios0: ROM list: 0xc0000/0xec00
cpu0: Enhanced SpeedStep disabled by BIOS
pci0 at mainbus0 bus 0: configuration mode 1 (bios)
pchb0 at pci0 dev 0 function 0 "VIA PT894 Host" rev 0x00
viaagp0 at pchb0: v3
agp0 at viaagp0: aperture at 0xf8000000, size 0xf000000
pchb1 at pci0 dev 0 function 1 "VIA PT894 Host" rev 0x00
pchb2 at pci0 dev 0 function 2 "VIA PT894 Host" rev 0x00
pchb3 at pci0 dev 0 function 3 "VIA PT890 Host" rev 0x00
pchb4 at pci0 dev 0 function 4 "VIA PT894 Host" rev 0x00
"VIA PT894 IOAPIC" rev 0x00 at pci0 dev 0 function 5 not configured
pchb5 at pci0 dev 0 function 7 "VIA PT894 Host" rev 0x00
ppb0 at pci0 dev 1 function 0 "VIA VT8377 AGP" rev 0x00
pci1 at ppb0 bus 1
vga1 at pci1 dev 0 function 0 "NVIDIA GeForce 7600 GT" rev 0xa2
wsdisplay0 at vga1 mux 1: console (80x25, vt100 emulation)
wsdisplay0: screen 1-5 added (80x25, vt100 emulation)
ppb1 at pci0 dev 2 function 0 vendor "VIA", unknown product 0xa208 rev 0x00:
apic 3 int 3
pci2 at ppb1 bus 2
pciide0 at pci0 dev 15 function 0 "VIA VT8237S SATA" rev 0x00: DMA
pciide0: using apic 2 int 21 for native-PCI interrupt
pciide1 at pci0 dev 15 function 1 "VIA VT82C571 IDE" rev 0x07: DMA, channel 0
configured to compatibility, channel 1 configured to compatibility
wd0 at pciide1 channel 0 drive 0: <ST380011A>
wd0: 16-sector PIO, LBA48, 76319MB, 156301488 sectors
wd1 at pciide1 channel 0 drive 1: <ST3750640A>
wd1: 16-sector PIO, LBA48, 715404MB, 1465149168 sectors
wd0(pciide1:0:0): using PIO mode 4, DMA mode 2
wd1(pciide1:0:1): using PIO mode 4, DMA mode 2
wd2 at pciide1 channel 1 drive 0: <ExcelStor Technology J880>
wd2: 16-sector PIO, LBA48, 78533MB, 160836480 sectors
wd3 at pciide1 channel 1 drive 1: <QUANTUM FIREBALLlct20 40>
wd3: 8-sector PIO, LBA, 38172MB, 78177792 sectors
wd2(pciide1:1:0): using PIO mode 4, DMA mode 2
wd3(pciide1:1:1): using PIO mode 4, DMA mode 2
uhci0 at pci0 dev 16 function 0 "VIA VT83C572 USB" rev 0xb0: apic 2 int 20
uhci1 at pci0 dev 16 function 1 "VIA VT83C572 USB" rev 0xb0: apic 2 int 22
uhci2 at pci0 dev 16 function 2 "VIA VT83C572 USB" rev 0xb0: apic 2 int 21
uhci3 at pci0 dev 16 function 3 "VIA VT83C572 USB" rev 0xb0: apic 2 int 23
ehci0 at pci0 dev 16 function 4 "VIA VT6202 USB" rev 0x90: apic 2 int 21
usb0 at ehci0: USB revision 2.0
uhub0 at usb0 "VIA EHCI root hub" rev 2.00/1.00 addr 1
viapm0 at pci0 dev 17 function 0 "VIA VT8237S ISA" rev 0x00: SMI
iic0 at viapm0
spdmem0 at iic0 addr 0x50: 1GB DDR2 SDRAM non-parity PC2-6400CL5
spdmem1 at iic0 addr 0x52: 1GB DDR2 SDRAM non-parity PC2-6400CL5
pchb6 at pci0 dev 17 function 7 "VIA VT8251 VLINK" rev 0x00
vr0 at pci0 dev 18 function 0 "VIA RhineII-2" rev 0x7c: apic 2 int 23, address
00:19:66:70:d9:d2
ukphy0 at vr0 phy 1: Generic IEEE 802.3u media interface, rev. 10: OUI
0x004063, model 0x0032
pchb7 at pci0 dev 19 function 0 "VIA VT8237A PCI-PCI" rev 0x00
ppb2 at pci0 dev 19 function 1 "VIA VT8237A PCI-PCI" rev 0x00
pci3 at ppb2 bus 3
rl0 at pci3 dev 4 function 0 "Accton MPX 5030/5038" rev 0x10: apic 2 int 17,
address 00:10:b5:89:f8:ba
rlphy0 at rl0 phy 0: RTL internal PHY
dc0 at pci3 dev 5 function 0 "Lite-On PNIC-II" rev 0x25: apic 2 int 18, address
00:a0:cc:e3:42:d6
dcphy0 at dc0 phy 31: internal PHY
usb1 at uhci0: USB revision 1.0
uhub1 at usb1 "VIA UHCI root hub" rev 1.00/1.00 addr 1
usb2 at uhci1: USB revision 1.0
uhub2 at usb2 "VIA UHCI root hub" rev 1.00/1.00 addr 1
usb3 at uhci2: USB revision 1.0
uhub3 at usb3 "VIA UHCI root hub" rev 1.00/1.00 addr 1
usb4 at uhci3: USB revision 1.0
uhub4 at usb4 "VIA UHCI root hub" rev 1.00/1.00 addr 1
isa0 at mainbus0
isadma0 at isa0
com0 at isa0 port 0x3f8/8 irq 4: ns16550a, 16 byte fifo
pckbc0 at isa0 port 0x60/5
pckbd0 at pckbc0 (kbd slot)
pckbc0: using irq 1 for kbd slot
wskbd0 at pckbd0: console keyboard, using wsdisplay0
pcppi0 at isa0 port 0x61
spkr0 at pcppi0
lpt0 at isa0 port 0x378/4 irq 7
wbsio0 at isa0 port 0x2e/2: W83697HF rev 0x12
lm1 at wbsio0 port 0x290/8: W83697HF
npx0 at isa0 port 0xf0/16: reported by CPUID; using exception 16
fdc0 at isa0 port 0x3f0/6 irq 6 drq 2
mtrr: Pentium Pro MTRR support
uhidev0 at uhub2 port 2 configuration 1 interface 0 "vendor 0x062a product
0x0000" rev 1.10/0.00 addr 2
uhidev0: iclass 3/1
ums0 at uhidev0: 3 buttons, Z dir
wsmouse0 at ums0 mux 0
vscsi0 at root
scsibus0 at vscsi0: 256 targets
softraid0 at root
scsibus1 at softraid0: 256 targets
sd0 at scsibus1 targ 1 lun 0: <OPENBSD, SR RAID 1, 005> SCSI2 0/direct fixed
sd0: 35839MB, 512 bytes/sector, 73400016 sectors
root on sd0a (e0835866b9a0c17e.a) swap on sd0b dump on sd0b
