pg.ddx.io  pljava-dev@postgresql.org mailing list archive  

help / color / mirror / Atom feed
Subject: [Pljava-dev] null pointer exception in pl/java jdbc driver
Date: Fri, 25 May 2012 08:40:36 -0400
Message-ID: <C35FDD5FDF7E584991A6AAF8F1A8425F0226AD57@ltischx01.lti.int> (raw)
References: <C35FDD5FDF7E584991A6AAF8F1A8425F0226AD3A@ltischx01.lti.int>
	<oby4pb.x5oby4pb.wr42.7xr4.gnus@asuka.myrkraverk.com>
	<C35FDD5FDF7E584991A6AAF8F1A8425F0226AD50@ltischx01.lti.int>
	<qqwdkw.x5qqwdkw.sjep.8wmu.gnus@asuka.myrkraverk.com>
	<C35FDD5FDF7E584991A6AAF8F1A8425F0226AD51@ltischx01.lti.int>

the issue has been identified, this summary is to help anyone who comes along with a similar issue
in the future.

the root cause is there was a trigger being fired which should not have been. instead of triggering
after insert, it was triggering after insert or delete, and then attempting to operate on rows which
the retryPush function had just deleted from the table.

i only got an idea of what was going on after i ran the function from psql with these two debug
settings as requested by Johann:


 SET log_min_messages = debug;
 SET client_min_messages = debug;

until i set these and reviewed the output, i had no idea that the unwanted trigger was where
the error actually originated.

richard
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.pgfoundry.org/pipermail/pljava-dev/attachments/20120525/0f655e0d/attachment.html;



view thread (11+ messages)

Message-ID: <C35FDD5FDF7E584991A6AAF8F1A8425F0226AD57@ltischx01.lti.int>
Permalink:  ../C35FDD5FDF7E584991A6AAF8F1A8425F0226AD57@ltischx01.lti.int/
Also on:    postgresql.org/message-id/C35FDD5FDF7E584991A6AAF8F1A8425F0226AD57@ltischx01.lti.int

 · 

reply
Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pljava-dev@postgresql.org
  Subject: Re: [Pljava-dev] null pointer exception in pl/java jdbc driver
  In-Reply-To: <C35FDD5FDF7E584991A6AAF8F1A8425F0226AD57@ltischx01.lti.int>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox