Re: Can't throw the dreaded 'idle in transaction' - need help!

On Tuesday 23 November 2004 01:03, Temp02 wrote:
> We don't use any Java locking with the application we leave it all
> up to the DB.

Not a single synchronized block of code in your entire application?

Did you try sending a SIGQUIT to your application, as Oliver suggested
in http://archives.postgresql.org/pgsql-jdbc/2004-11/msg00169.php


  | $ cat Main.java
  | public class Main {
  |     public static void main(String[] _) throws InterruptedException {
  |         while (true) {
  |             Thread.sleep(1000);
  |         }
  |     }
  | }
  |
  | $ javac Main.java
  | $ java -cp . Main &
  | [1] 9346
  | $ ps -ef | grep java
  | vadim     9346  7513  3 10:03 pts/0    00:00:00 java -cp . Main


In response to a SIGQUIT, the JRE should dump stack traces for all the
current threads, like so:

  | $ kill -QUIT 9346
  | Full thread dump Java HotSpot(TM) Client VM (1.4.2_05-b04 mixed mode):
  |
  | "Signal Dispatcher" daemon prio=1 tid=0x08095950 nid=0x2482 waiting on condition [0..0]
  |
  | "Finalizer" daemon prio=1 tid=0x08090e90 nid=0x2482 in Object.wait() [4c792000..4c79287c]
  |     at java.lang.Object.wait(Native Method)
  |     - waiting on <0x44590490> (a java.lang.ref.ReferenceQueue$Lock)
  |     at java.lang.ref.ReferenceQueue.remove(ReferenceQueue.java:111)
  |     - locked <0x44590490> (a java.lang.ref.ReferenceQueue$Lock)
  |     at java.lang.ref.ReferenceQueue.remove(ReferenceQueue.java:127)
  |     at java.lang.ref.Finalizer$FinalizerThread.run(Finalizer.java:159)
  |
  | "Reference Handler" daemon prio=1 tid=0x080902e8 nid=0x2482 in Object.wait() [4c711000..4c71187c]
  |     at java.lang.Object.wait(Native Method)
  |     - waiting on <0x44590380> (a java.lang.ref.Reference$Lock)
  |     at java.lang.Object.wait(Object.java:429)
  |     at java.lang.ref.Reference$ReferenceHandler.run(Reference.java:115)
  |     - locked <0x44590380> (a java.lang.ref.Reference$Lock)
  |
  | "main" prio=1 tid=0x0805ab88 nid=0x2482 waiting on condition [bfffd000..bfffd55c]
  |     at java.lang.Thread.sleep(Native Method)
  |     at Main.main(Main.java:4)
  |
  | "VM Thread" prio=1 tid=0x0808f088 nid=0x2482 runnable
  |
  | "VM Periodic Task Thread" prio=1 tid=0x080981a0 nid=0x2482 waiting on condition
  | "Suspend Checker Thread" prio=1 tid=0x08094f98 nid=0x2482 runnable


Except yours will be a lot longer.