Lists: | pgsql-hackers |
---|
From: | G u i d o B a r o s i o <gbarosio(at)uolsinectis(dot)com(dot)ar> |
---|---|
To: | pgsql-hackers(at)postgresql(dot)org |
Subject: | PG_exception_stack |
Date: | 2004-09-15 16:04:37 |
Message-ID: | 20040915160437.585696C9D2@honorio.sinectis.com.ar |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Lists: | pgsql-hackers |
Didn't find a solution for this on the lists, and I am not a yet-brand-new-guru, so... I ask :)
What about this?
I've found a box (dual Intel(R) Xeon(TM) CPU 2.80GHz) in which to test the beta2. Trying to cretae proc languages I found this error. I've seen error creating languages on other boxes, but none of them like this one. What makes me a litle bit lazy is the PG_except... msg.
I am trying to do something nasty or just watching something not usual? I've found recent posts related to the BKI and talking about the PG_exception_stack, but none of them seem to handle the createlang situation.
Any hints?
[postgres(at)prdpwgb0208 postgres]$ createlang plpgsql tech_mis
createlang: language installation failed: ERROR: could not load library "/usr/local/pgsql/lib/plpgsql.so": /usr/local/pgsql/lib/plpgsql.so: undefined symbol: PG_exception_stack
[postgres(at)prdpwgb0208 postgres]$ pg_config --configure
'--enable-thread-safety' '--with-perl' '--without-docdir'
[postgres(at)prdpwgb0208 postgres]$ pg_config --version
PostgreSQL 8.0.0beta2
[postgres(at)prdpwgb0208 postgres]$ cd /usr/local/pgsql/lib/
[postgres(at)prdpwgb0208 lib]$ ls -ltrh plpgsql.so
-rwxr-xr-x 1 root root 123k Sep 15 15:41 plpgsql.so
[postgres(at)prdpwgb0208 lib]$uname -a
Linux prdpwgb0208 2.4.22ow1np-ht #8 SMP Mon Oct 13 19:54:55 GMT 2003 i686 unknown
Regards,
Guido
From: | James William Pye <flaw(at)rhid(dot)com> |
---|---|
To: | gbarosio(at)uolsinectis(dot)com(dot)ar |
Cc: | Hackers <pgsql-hackers(at)postgresql(dot)org> |
Subject: | Re: PG_exception_stack |
Date: | 2004-09-15 16:30:07 |
Message-ID: | 1095265807.587.20.camel@localhost |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Lists: | pgsql-hackers |
On Wed, 2004-09-15 at 09:04, G u i d o B a r o s i o wrote:
> [postgres(at)prdpwgb0208 postgres]$ createlang plpgsql tech_mis
> createlang: language installation failed: ERROR: could not load
> library "/usr/local/pgsql/lib/plpgsql.so":
> /usr/local/pgsql/lib/plpgsql.so: undefined symbol: PG_exception_stack
It looks like your build is a bit fubar'd. I don't know why exactly, but
it can't find that symbol, so I'd suggest a gmake distclean, configure,
and gmake all install. (hrm, might also want to make sure that your
installations arent crossing paths somewhere here, if you have multiple
versions installed)
(Note that I just did it with my dev build without trouble)
--
Regards,
James William Pye
From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
---|---|
To: | gbarosio(at)uolsinectis(dot)com(dot)ar |
Cc: | pgsql-hackers(at)postgresql(dot)org |
Subject: | Re: PG_exception_stack |
Date: | 2004-09-15 16:38:59 |
Message-ID: | 4672.1095266339@sss.pgh.pa.us |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Lists: | pgsql-hackers |
G u i d o B a r o s i o <gbarosio(at)uolsinectis(dot)com(dot)ar> writes:
> [postgres(at)prdpwgb0208 postgres]$ createlang plpgsql tech_mis
> createlang: language installation failed: ERROR: could not load library "/usr/local/pgsql/lib/plpgsql.so": /usr/local/pgsql/lib/plpgsql.so: undefined symbol: PG_exception_stack
I think you've got a version mismatch problem --- specifically, it looks
like you are trying to load an 8.0 plpgsql.so into a pre-8.0 backend.
PG_exception_stack is (just by chance no doubt) the first symbol the
newer code tries to reference that's not in the older backend.
regards, tom lane