From: thhal at mailblocks.com (Thomas Hallgren)
Date: Wed, 28 Jul 2004 09:51:07 +0200
Subject: [Pljava-dev] can't install pl/java undefined symbol errstart
In-Reply-To: <ade10d420407272337607007f4@mail.gmail.com>
References: <ade10d420407272337607007f4@mail.gmail.com>
	<41075AEB.8030104@mailblocks.com>
	<thhal-07fLiAXmMUNsJpk6+f3cjAk2WAZAoUr@mailblocks.com>
Message-ID: <thhal-07/LiAXuMUNsN40uKltXhE9bZYHnrOc@mailblocks.com>

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