[pgpool-general: 2320] Re: pgpool-recovery.so ; relocation error; referenced symbol not found

Ethan Shin easonkie2nd at gmail.com
Mon Dec 2 23:06:58 JST 2013


Hi Nozomi,
I have found the cause which is the lower version pg_config came with
Solaris.
Though I have modified the make file to use the V9.1 pg_config but during
make stage it still used the older one.
Now the problem is solved.

Thanks a lot for your help.
Cheers,
E


On Mon, Dec 2, 2013 at 5:33 PM, Nozomi Anzai <anzai at sraoss.co.jp> wrote:

> Hi,
>
> > > I can not find the ld.so.conf under /etc nor ldconfig under /sbin
> > >
> > > I am using Solaris 10 by the way.
> > > Could you please advise?
>
> Sorry, my answer was for CentOS/RHEL, not for Solaris. Could you try with
> "crle" command?
>
> > bash-3.2$ /usr/local/pgsql/bin/psql -f ./pgpool-regclass.sql template1
> > psql:./pgpool-regclass.sql:4: ERROR:  incompatible library
> > "/usr/local/pgsql/lib/pgpool-regclass.so": missing magic block
> > HINT:  Extension libraries are required to use the PG_MODULE_MAGIC macro.
>
> I think this message also means pgpool cannot find PostgreSQL libraries
> and headers in /usr/local/pgsql or use ones in /postgres/9.1-pgdg/ (it is
> wrong now).
> Could you try to install pgpool again like this?
>
> $ ./configure --with-pgsql=/usr/local/pgsql
> $ make
> $ make install
>
> $ cd sql/pgpool-recovery/
> $ make install
> $ /usr/local/pgsql/bin/initdb -D {dirname}
> $ /usr/local/pgsql/bin/pg_ctl start -D {dirname}
> $ /usr/local/pgsql/bin/psql -f ./pgpool-regclass.sql template1
>
> > In the mean time, I have built the Postgres 9.1 with the gcc on the
> Solaris
> > box and when I tried again to insert the extensions(pgpool-regclass.sql
> and
> > pgpool-recovery.sql)
> > The error for pgpool-regclass.sql is differernt.  see below:
> >
> > bash-3.2$ /usr/local/pgsql/bin/psql -f ./pgpool-regclass.sql template1
> > psql:./pgpool-regclass.sql:4: ERROR:  incompatible library
> > "/usr/local/pgsql/lib/pgpool-regclass.so": missing magic block
> > HINT:  Extension libraries are required to use the PG_MODULE_MAGIC macro.
> > bash-3.2$
> >
> > Thanks,
> > Ethan
> >
> > On Fri, Nov 29, 2013 at 6:40 PM, Ethan Shin <easonkie2nd at gmail.com>
> wrote:
> >
> > > Hi Nozomi,
> > > Thanks a lot for picking this up.
> > > I can not find the ld.so.conf under /etc nor ldconfig under /sbin
> > >
> > > I am using Solaris 10 by the way.
> > > Could you please advise?
> > >
> > > Regards,
> > > Ethan
> > >
> > >
> > > On Fri, Nov 29, 2013 at 6:37 PM, Ethan Shin <easonkie2nd at gmail.com>
> wrote:
> > >
> > >> Hi Nozomi,
> > >> Thanks a lot for picking this up.
> > >> I can not find the ld.so.conf under /etc nor ldconfig under /sbin
> > >>
> > >> I am using Solaris 10 by the way.
> > >> Could you please advise?
> > >>
> > >> Regards,
> > >> Ethan
> > >>
> > >>
> > >> On Fri, Nov 29, 2013 at 3:03 PM, Nozomi Anzai <anzai at sraoss.co.jp>
> wrote:
> > >>
> > >>> Hi,
> > >>>
> > >>> Could you try after adding the library path to PostgresQL into
> > >>> ld.so.conf?
> > >>>
> > >>> ex.)
> > >>> # vi /etc/ld.so.conf
> > >>> include ld.so.conf.d/*.conf
> > >>> /postgres/9.1-pgdg/lib
> > >>>
> > >>> # /sbin/ldconfig
> > >>>
> > >>> > Hi Gentlemen,
> > >>> > I am trying to execute the pgpool-recovery.sql but being prompted
> > >>> below could not load lib pgpool-recovery.so error.
> > >>> > Can you please help me to address this?
> > >>> >
> > >>> >
> > >>> >
> > >>> > bash-3.2$ psql -f ./pgpool-recovery.sql template1
> > >>> psql:./pgpool-recovery.sql:4: ERROR:  could not load library
> > >>> "/postgres/9.1-pgdg/lib/pgpool-recovery.so": ld.so.1: postgres:
> fatal:
> > >>> relocation error: file /postgres/9.1-pgdg/lib/pgpool-recovery.so:
> symbol
> > >>> DirectFunctionCall1: referenced symbol not found
> > >>> > psql:./pgpool-recovery.sql:9: ERROR:  could not load library
> > >>> "/postgres/9.1-pgdg/lib/pgpool-recovery.so": ld.so.1: postgres:
> fatal:
> > >>> relocation error: file /postgres/9.1-pgdg/lib/pgpool-recovery.so:
> symbol
> > >>> DirectFunctionCall1: referenced symbol not found
> > >>> > psql:./pgpool-recovery.sql:14: ERROR:  could not load library
> > >>> "/postgres/9.1-pgdg/lib/pgpool-recovery.so": ld.so.1: postgres:
> fatal:
> > >>> relocation error: file /postgres/9.1-pgdg/lib/pgpool-recovery.so:
> symbol
> > >>> DirectFunctionCall1: referenced symbol not found
> > >>> >
> > >>> >
> > >>> > bash-3.2$ ldd -d pgpool-recovery.so
> > >>> >        symbol not found: textout
> (./pgpool-recovery.so)
> > >>> >        symbol not found: textin
>  (./pgpool-recovery.so)
> > >>> >        symbol not found: DataDir
> (./pgpool-recovery.so)
> > >>> >        symbol not found: InterruptPending
> > >>>  (./pgpool-recovery.so)
> > >>> >
> > >>> >
> > >>> > Thanks very much in advance!
> > >>> > Regards,
> > >>> > Ethan
> > >>> > _______________________________________________
> > >>> > pgpool-general mailing list
> > >>> > pgpool-general at pgpool.net
> > >>> > http://www.pgpool.net/mailman/listinfo/pgpool-general
> > >>>
> > >>>
> > >>> --
> > >>> Nozomi Anzai
> > >>> SRA OSS, Inc. Japan
> > >>> _______________________________________________
> > >>> pgpool-general mailing list
> > >>> pgpool-general at pgpool.net
> > >>> http://www.pgpool.net/mailman/listinfo/pgpool-general
> > >>>
> > >>
> > >>
> > >
>
>
> --
> Nozomi Anzai
> SRA OSS, Inc. Japan
> _______________________________________________
> pgpool-general mailing list
> pgpool-general at pgpool.net
> http://www.pgpool.net/mailman/listinfo/pgpool-general
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.sraoss.jp/pipermail/pgpool-general/attachments/20131202/11d4bc3e/attachment.html>


More information about the pgpool-general mailing list