agora inbox for pljava-dev@postgresql.org
help / color / mirror / Atom feed[Pljava-dev] installing jar file
12+ messages / 0 participants
[nested] [flat]
* [Pljava-dev] installing jar file
@ 2012-05-09 19:27
0 siblings, 1 reply; 12+ messages in thread
From: @ 2012-05-09 19:27 UTC (permalink / raw)
i'm having some trouble getting install_jar to work. the jar file is in /tmp, and it is permitted read to the world. the command i'm using (well, one of several variants) is as follows:
gf=# select sqlj.install_jar( "/tmp/gfs.jar", "gfs.jar", false);
ERROR: column "/tmp/gfs.jar" does not exist
LINE 1: select sqlj.install_jar( "/tmp/gfs.jar", "Vehic...
^
gf=#
any suggestions?
thanks,
richard
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.pgfoundry.org/pipermail/pljava-dev/attachments/20120509/3a815f5d/attachment.html;
^ permalink raw reply [nested|flat] 12+ messages in thread
* [Pljava-dev] installing jar file
@ 2012-05-09 19:30
parent:
0 siblings, 1 reply; 12+ messages in thread
From: @ 2012-05-09 19:30 UTC (permalink / raw)
On 05/09/12 12:27 PM, Welty, Richard wrote:
>
>
> gf=# select sqlj.install_jar( "/tmp/gfs.jar", "gfs.jar", false);
> ERROR: column "/tmp/gfs.jar" does not exist
> LINE 1: select sqlj.install_jar( "/tmp/gfs.jar", "Vehic...
> ^
> gf=#
>
> any suggestions?
in SQL, string literals use ' .... " is for identifiers.
--
john r pierce N 37, W 122
santa cruz ca mid-left coast
^ permalink raw reply [nested|flat] 12+ messages in thread
* [Pljava-dev] installing jar file
@ 2012-05-09 19:37
parent:
0 siblings, 1 reply; 12+ messages in thread
From: @ 2012-05-09 19:37 UTC (permalink / raw)
i knew that, i'm an idiot.
thanks,
richard
-----Original Message-----
From: pljava-dev-bounces at pgfoundry.org on behalf of John R Pierce
Sent: Wed 5/9/2012 3:30 PM
To: pljava-dev at pgfoundry.org
Subject: Re: [Pljava-dev] installing jar file
On 05/09/12 12:27 PM, Welty, Richard wrote:
>
>
> gf=# select sqlj.install_jar( "/tmp/gfs.jar", "gfs.jar", false);
> ERROR: column "/tmp/gfs.jar" does not exist
> LINE 1: select sqlj.install_jar( "/tmp/gfs.jar", "Vehic...
> ^
> gf=#
>
> any suggestions?
in SQL, string literals use ' .... " is for identifiers.
--
john r pierce N 37, W 122
santa cruz ca mid-left coast
_______________________________________________
Pljava-dev mailing list
Pljava-dev at pgfoundry.org
http://pgfoundry.org/mailman/listinfo/pljava-dev
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.pgfoundry.org/pipermail/pljava-dev/attachments/20120509/bfd22bfa/attachment.html;
^ permalink raw reply [nested|flat] 12+ messages in thread
* [Pljava-dev] installing jar file
@ 2012-05-09 20:11
parent:
0 siblings, 3 replies; 12+ messages in thread
From: @ 2012-05-09 20:11 UTC (permalink / raw)
it is now blowing up deep inside, dropping log files in /var/lib/pgsql9 with names like
hs_err_pid9895.log
which describes a SIGSEGV from java.lang.String.hashCode()
called from ClassLoader (called from URLClassLoader).
any suggestions as to what i should go looking at?
thanks,
richard
-----Original Message-----
From: pljava-dev-bounces at pgfoundry.org on behalf of Welty, Richard
Sent: Wed 5/9/2012 3:37 PM
To: John R Pierce; pljava-dev at pgfoundry.org
Subject: Re: [Pljava-dev] installing jar file
i knew that, i'm an idiot.
thanks,
richard
-----Original Message-----
From: pljava-dev-bounces at pgfoundry.org on behalf of John R Pierce
Sent: Wed 5/9/2012 3:30 PM
To: pljava-dev at pgfoundry.org
Subject: Re: [Pljava-dev] installing jar file
On 05/09/12 12:27 PM, Welty, Richard wrote:
>
>
> gf=# select sqlj.install_jar( "/tmp/gfs.jar", "gfs.jar", false);
> ERROR: column "/tmp/gfs.jar" does not exist
> LINE 1: select sqlj.install_jar( "/tmp/gfs.jar", "Vehic...
> ^
> gf=#
>
> any suggestions?
in SQL, string literals use ' .... " is for identifiers.
--
john r pierce N 37, W 122
santa cruz ca mid-left coast
_______________________________________________
Pljava-dev mailing list
Pljava-dev at pgfoundry.org
http://pgfoundry.org/mailman/listinfo/pljava-dev
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.pgfoundry.org/pipermail/pljava-dev/attachments/20120509/326a0b64/attachment.html;
^ permalink raw reply [nested|flat] 12+ messages in thread
* [Pljava-dev] installing jar file
@ 2012-05-09 20:39
parent:
2 siblings, 1 reply; 12+ messages in thread
From: @ 2012-05-09 20:39 UTC (permalink / raw)
"Welty, Richard" <rwelty at ltionline.com> writes:
> it is now blowing up deep inside, dropping log files in
> /var/lib/pgsql9 with names like
>
> hs_err_pid9895.log
Have you tried 'file:///tmp/gfs.jar' ?
--
Johann Oskarsson http://www.2ndquadrant.com/ |[]
PostgreSQL Development, 24x7 Support, Training and Services --+--
|
Blog: http://my.opera.com/myrkraverk/blog/
^ permalink raw reply [nested|flat] 12+ messages in thread
* [Pljava-dev] installing jar file
@ 2012-05-09 21:23
parent:
0 siblings, 1 reply; 12+ messages in thread
From: @ 2012-05-09 21:23 UTC (permalink / raw)
Johann 'Myrkraverk' Oskarsson writes:
>"Welty, Richard" <rwelty at ltionline.com> writes:
>> it is now blowing up deep inside, dropping log files in
>> /var/lib/pgsql9 with names like
>
>> hs_err_pid9895.log
>Have you tried 'file:///tmp/gfs.jar' ?
just did, same result.
richard
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.pgfoundry.org/pipermail/pljava-dev/attachments/20120509/da12bae8/attachment.html;
^ permalink raw reply [nested|flat] 12+ messages in thread
* [Pljava-dev] installing jar file
@ 2012-05-09 22:49
parent:
0 siblings, 1 reply; 12+ messages in thread
From: @ 2012-05-09 22:49 UTC (permalink / raw)
"Welty, Richard" <rwelty at ltionline.com> writes:
> Johann 'Myrkraverk' Oskarsson writes:
>
>>"Welty, Richard" <rwelty at ltionline.com> writes:
>
>>> it is now blowing up deep inside, dropping log files in
>>> /var/lib/pgsql9 with names like
>>
>>> hs_err_pid9895.log
>
>>Have you tried 'file:///tmp/gfs.jar' ?
>
> just did, same result.
Can you SET log_min_messages = 'debug1'; and attach the relevant part of
the log along with the JVM stack trace somewhere for us to see? Or
paste it somewhere.
If you're using psql, SET client_min_messages = 'debug1'; might help.
--
Johann Oskarsson http://www.2ndquadrant.com/ |[]
PostgreSQL Development, 24x7 Support, Training and Services --+--
|
Blog: http://my.opera.com/myrkraverk/blog/
^ permalink raw reply [nested|flat] 12+ messages in thread
* [Pljava-dev] installing jar file
@ 2012-05-10 02:22
parent:
2 siblings, 1 reply; 12+ messages in thread
From: @ 2012-05-10 02:22 UTC (permalink / raw)
Stupid question - is the libjvm version able to handle your class
files? That is, you aren't using a 1.5 jvm with a 1.6 class?
On 05/09/2012 02:11 PM, Welty, Richard wrote:
>
> it is now blowing up deep inside, dropping log files in
> /var/lib/pgsql9 with names like
>
> hs_err_pid9895.log
>
> which describes a SIGSEGV from java.lang.String.hashCode()
> called from ClassLoader (called from URLClassLoader).
> any suggestions as to what i should go looking at?
>
> thanks,
> richard
>
>
> -----Original Message-----
> From: pljava-dev-bounces at pgfoundry.org on behalf of Welty, Richard
> Sent: Wed 5/9/2012 3:37 PM
> To: John R Pierce; pljava-dev at pgfoundry.org
> Subject: Re: [Pljava-dev] installing jar file
>
> i knew that, i'm an idiot.
>
> thanks,
> richard
>
>
> -----Original Message-----
> From: pljava-dev-bounces at pgfoundry.org on behalf of John R Pierce
> Sent: Wed 5/9/2012 3:30 PM
> To: pljava-dev at pgfoundry.org
> Subject: Re: [Pljava-dev] installing jar file
>
> On 05/09/12 12:27 PM, Welty, Richard wrote:
> >
> >
> > gf=# select sqlj.install_jar( "/tmp/gfs.jar", "gfs.jar", false);
> > ERROR: column "/tmp/gfs.jar" does not exist
> > LINE 1: select sqlj.install_jar( "/tmp/gfs.jar", "Vehic...
> > ^
> > gf=#
> >
> > any suggestions?
>
> in SQL, string literals use ' .... " is for identifiers.
>
>
>
> --
> john r pierce N 37, W 122
> santa cruz ca mid-left coast
>
> _______________________________________________
> Pljava-dev mailing list
> Pljava-dev at pgfoundry.org
> http://pgfoundry.org/mailman/listinfo/pljava-dev
>
>
>
> _______________________________________________
> Pljava-dev mailing list
> Pljava-dev at pgfoundry.org
> http://pgfoundry.org/mailman/listinfo/pljava-dev
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.pgfoundry.org/pipermail/pljava-dev/attachments/20120509/1f3be505/attachment.html;
^ permalink raw reply [nested|flat] 12+ messages in thread
* [Pljava-dev] installing jar file
@ 2012-05-10 13:36
parent:
2 siblings, 1 reply; 12+ messages in thread
From: @ 2012-05-10 13:36 UTC (permalink / raw)
John R Pierce [mailto:pierce at hogranch.com] writes:
>totally off the wall, but how large is this postgres server's
<shared_buffers? I had hard crashing core dump type faults on a number
>of systems when shared_buffers was much over 1500MB (I forget the exact
>threshold, but it was under 1600MB). Johan traced this down to inside
>the Snoracle JVM but not any farther
hmm. shared_buffers is 3GB on this server. it seems weird, though, that
large values for shared_buffers would cause the class loader to crash.
on the other hand, i just reduced shared_buffers to 1500MB and now the jar
file appears to load. i guess now i have to make the code work.
by the way, the installation details if anyone needs them to help with this issue:
amazon linux instance (ec2 cloud), postgresql 9.1.3 from the amazon package system,
current release of pl/java from pljava-x86_64-unknown-linux-gnu-pg9.1-1.4.3.tar.gz,
openjdk-1.6.0 from amazon package system.
thanks,
richard
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.pgfoundry.org/pipermail/pljava-dev/attachments/20120510/aaf56e06/attachment.html;
^ permalink raw reply [nested|flat] 12+ messages in thread
* [Pljava-dev] installing jar file
@ 2012-05-10 13:36
parent:
0 siblings, 0 replies; 12+ messages in thread
From: @ 2012-05-10 13:36 UTC (permalink / raw)
Johann 'Myrkraverk' Oskarsson writes:
>Can you SET log_min_messages = 'debug1'; and attach the relevant part of
>the log along with the JVM stack trace somewhere for us to see? Or
>paste it somewhere.
>If you're using psql, SET client_min_messages = 'debug1'; might help.
John's suggestion worked. if you still would like this output, i will
try to make time today or tomorrow (probably tomorrow, i have project
meetings most of today) to put the server back to where it was yesterday
and generate this output for you.
richard
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.pgfoundry.org/pipermail/pljava-dev/attachments/20120510/d7c47df6/attachment.html;
^ permalink raw reply [nested|flat] 12+ messages in thread
* [Pljava-dev] installing jar file
@ 2012-05-10 15:03
parent:
0 siblings, 0 replies; 12+ messages in thread
From: @ 2012-05-10 15:03 UTC (permalink / raw)
Bear Giles wrote:
>Stupid question - is the libjvm version able to handle your class
>files? That is, you aren't using a 1.5 jvm with a 1.6 class?
the jvm installed is 1.6, as is the jvm that i'm using to build the jar.
richard
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.pgfoundry.org/pipermail/pljava-dev/attachments/20120510/a10bd55b/attachment.html;
^ permalink raw reply [nested|flat] 12+ messages in thread
* [Pljava-dev] installing jar file
@ 2012-05-10 18:22
parent:
0 siblings, 0 replies; 12+ messages in thread
From: @ 2012-05-10 18:22 UTC (permalink / raw)
On 05/10/12 6:36 AM, Welty, Richard wrote:
> hmm. shared_buffers is 3GB on this server. it seems weird, though, that
> large values for shared_buffers would cause the class loader to crash.
indeed it does seem weird, but thats exactly what I got hit with. The
threshold I narrowed it down to was, IIRC, somewhere around 1560MB...
above that, ka-rash; below that, run fine. go figger.
>
> on the other hand, i just reduced shared_buffers to 1500MB and now the jar
> file appears to load. i guess now i have to make the code work.
heh. the adventure begins... :)
--
john r pierce N 37, W 122
santa cruz ca mid-left coast
^ permalink raw reply [nested|flat] 12+ messages in thread
end of thread, other threads:[~2012-05-10 18:22 UTC | newest]
Thread overview: 12+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2012-05-09 19:27 [Pljava-dev] installing jar file
2012-05-09 19:30 `
2012-05-09 19:37 `
2012-05-09 20:11 `
2012-05-09 20:39 `
2012-05-09 21:23 `
2012-05-09 22:49 `
2012-05-10 13:36 `
2012-05-10 02:22 `
2012-05-10 15:03 `
2012-05-10 13:36 `
2012-05-10 18:22 `
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox