Good Morning,
Is there an actual problem in the software.  One of my managers is looking at 
load of providers that is causing the timeout.  These messages indicate it is 
something different.
Your input would help us track this down.


Best Regards,

Susan Morrison

Database Analyst

Office of Academic Information Systems(AIS)

6303 Forest Park | Suite BP4.100 | Dallas, TX 75390-9106

Ph. (214)648-4295  
Email:[email protected]<mailto:[email protected]>

___________________

“One Team One Dream”



From: Susan Morrison
Date: Monday, July 20, 2015 at 10:24 AM
To: "[email protected]<mailto:[email protected]>", Wanta M, 
"[email protected]<mailto:[email protected]>"
Subject: RE: Jira ticket/workaround for backgrounded i2b2 queries that never 
return

It’s UTSW.

Best Regards,  Susan Morrison  Ph. (214)648-4295


From: 
[email protected]<mailto:[email protected]> 
[mailto:[email protected]] On Behalf Of Nathan Graham
Sent: Monday, July 20, 2015 9:18 AM
To: 'Wanta Keith M'; [email protected]<mailto:[email protected]>
Subject: RE: Jira ticket/workaround for backgrounded i2b2 queries that never 
return

Keith,

I thought it was Hubert at UNMC, but the GPC Dev Meeting Notes 14 July 
2015<https://docs.google.com/document/d/1DR1MSa752O5yT8lnGvkTiUVwzcZVnYTKVneN1FjxVhQ/edit>
 notes say UTSW – maybe both sites had issues.  Or, maybe I’m just not 
remembering correctly.

--
Nathan

From: Wanta Keith M [mailto:[email protected]]
Sent: Wednesday, July 15, 2015 10:15 AM
To: Nathan Graham; [email protected]<mailto:[email protected]>
Subject: RE: Jira ticket/workaround for backgrounded i2b2 queries that never 
return

Nathan, on the GPC call yesterday, do you recall which organization had this 
issue?  I can suggest the fix to Partners, but it seems like a slightly 
different issue.  I am just following up to confirm.

~Keith

From:[email protected]<mailto:[email protected]>
 [mailto:[email protected]] On Behalf Of Nathan Graham
Sent: Tuesday, July 14, 2015 11:43 AM
To: [email protected]<mailto:[email protected]>
Subject: Jira ticket/workaround for backgrounded i2b2 queries that never return

All,

As per the gpc-dev call today, please see Jira CORE issue 149: JDBC calls to 
interrupted threads throw 
sqlexceptions<https://community.i2b2.org/jira/browse/CORE-149?jql=text%20~%20%22Interrupted%20attempting%20lock%22>
 for work on long-running i2b2 queries that get stuck in a “processing” state 
and never return.  Note that you have to log in to the Jira system in order to 
see the ticket information – otherwise Jira reports “No issues were found to 
match your search”.

Michael Horvath said in the description:
> As a temporary fix, we've commented out the t.interrupt() call without any 
> ill effects.

Specifically, here’s the text from the patch we applied at KUMC:

--- 
./i2b2_1704_orig/edu.harvard.i2b2.crc/src/server/edu/harvard/i2b2/crc/ejb/QueryManagerBeanUtil.java
 2014-11-06 15:48:08.000000000 -0600
+++ 
./i2b2_1704/edu.harvard.i2b2.crc/src/server/edu/harvard/i2b2/crc/ejb/QueryManagerBeanUtil.java
      2015-02-10 08:35:26.000000000 -0600
@@ -231,7 +231,7 @@
                                throw new I2B2Exception("Thread error while 
running CRC job "
                                                , e);
                        } finally {
-                               t.interrupt();
+                               //t.interrupt();
                                //exec = null;
                                t = null;
                        }

________________________________

UT Southwestern


Medical Center



The future of medicine, today.

_______________________________________________
Gpc-dev mailing list
[email protected]
http://listserv.kumc.edu/mailman/listinfo/gpc-dev

Reply via email to