From: adityapk at gmail.com (aditya Kulkarni)
Date: Wed, 28 Jul 2004 14:45:39 +0530
Subject: [Pljava-dev] can't install pl/java undefined symbol errstart
In-Reply-To: <thhal-07fLiAXmMUNsJpk6+f3cjAk2WAZAoUr@mailblocks.com>
References: <ade10d420407272337607007f4@mail.gmail.com>
	<41075AEB.8030104@mailblocks.com>
	<thhal-07fLiAXmMUNsJpk6+f3cjAk2WAZAoUr@mailblocks.com>
Message-ID: <ade10d4204072802157979f9a@mail.gmail.com>

Oh yes... I was running postgreSQL 7.3.4 instead of 7.4.3

Thanks

On Wed, 28 Jul 2004 09:51:07 +0200, Thomas Hallgren
<thhal at mailblocks.com> wrote:
> 
> 
> aditya Kulkarni wrote:
> 
> >Hi,
> >
> >I was trying to install pl/java on my postgres 7.4.3. I set up all the
> >classpaths and the LD_LIBRARY_PATH and all that and started postgres.
> >Now, when i try to deploy pl/java, i get these errors.
> >
> >java -cp .:pljava.jar:deploy.jar:/prog/software/libs/pg74.214.jdbc3.jar
> >org.postgresql.pljava.deploy.Deployer -reinstall -user akulkarni
> >-database postgresql
> >java.sql.SQLException: ERROR:  Load of file
> >/prog/software/downloads/pljava/libpljava.so failed:
> >/prog/software/downloads/pljava/libpljava.so: undefined symbol:
> >errstart
> >        at org.postgresql.core.QueryExecutor.executeV2(QueryExecutor.java:287)
> >        at org.postgresql.core.QueryExecutor.execute(QueryExecutor.java:104)
> >        at org.postgresql.core.QueryExecutor.execute(QueryExecutor.java:43)
> >        ...
> >
> >What does this mean ? undefined symbol errstart... I tried to google
> >this, but not much help. When i look at the postgres log ( set at
> >min_level = info ), this is what i get...
> >
> >LOG:  database system is ready
> >FATAL: unsupported frontend protocol
> >ERROR:  Language java doesn't exist
> >LOG:  statement: DROP LANGUAGE java CASCADE
> >ERROR:  Load of file /prog/software/downloads/pljava/libpljava.so
> >failed: /prog/software/downloads/pljava/libpljava.so: undefined
> >symbol: errstart
> >LOG:  statement: CREATE FUNCTION sqlj.java_call_handler() RETURNS
> >language_handler AS 'libpljava' LANGUAGE C
> >LOG:  pq_recvbuf: unexpected EOF on client connection
> >
> >
> >Why is it saying unsopported frontend protocol at the start... ?
> >
> >Can you help me here ? Thanks in advance
> >
> >
> My immediate guess is that you try to connect to an older postgresql
> backend. Do you have an older installation running that occupies the
> TCP/IP port perhaps? If so, it would explain both the "unsupported
> frontend protocol" and the "undefined symbol: errstart".
> 
> Regards,
> 
> Thomas Hallgren
> 
> 


-- 
Aditya Kulkarni