From user-return-54702-archive-asf-public=cust-asf.ponee.io@ofbiz.apache.org Tue Jan 1 19:36:38 2019 Return-Path: X-Original-To: archive-asf-public@cust-asf.ponee.io Delivered-To: archive-asf-public@cust-asf.ponee.io Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by mx-eu-01.ponee.io (Postfix) with SMTP id B22A118067A for ; Tue, 1 Jan 2019 19:36:37 +0100 (CET) Received: (qmail 8919 invoked by uid 500); 1 Jan 2019 18:36:36 -0000 Mailing-List: contact user-help@ofbiz.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: user@ofbiz.apache.org Delivered-To: mailing list user@ofbiz.apache.org Delivered-To: moderator for user@ofbiz.apache.org Received: (qmail 57895 invoked by uid 99); 31 Dec 2018 16:42:28 -0000 X-Virus-Scanned: Debian amavisd-new at spamd1-us-west.apache.org X-Spam-Flag: NO X-Spam-Score: 2.231 X-Spam-Level: ** X-Spam-Status: No, score=2.231 tagged_above=-999 required=6.31 tests=[SPF_FAIL=0.919, SPF_HELO_PASS=-0.001, URI_HEX=1.313] autolearn=disabled Date: Mon, 31 Dec 2018 10:42:25 -0600 (CST) From: ofbiz_hyf To: user@ofbiz.apache.org Message-ID: <1546274545093-0.post@n4.nabble.com> Subject: ofbiz thread finish current business cannot auto destroy cause deadlock MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit Dears: Our web app has a serious problem. When a user finishes the operation, I think its thread is not automatically destroyed. Then query oracle sid, serial# have records(sql: select b.username,b.sid,b.serial#,logon_time from v$locked_object a,v$session b where a.session_id = b.sid order by b.logon_time;), but there is no corresponding SQL statement ( sql_text is empty. sql: select sql_text from v$sql where hash_value in(select sql_hash_value from v$session where sid in (select session_id from v$locked_object)); ). And another user to operate the same record (operated by a user just now) ,but fail, cannot operate. Now, a deadlock occurs( oracle sql_text has record. sql: select sql_text from v$sql where hash_value in (select sql_hash_value from v$session where sid in (select session_id from v$locked_object)) ). Could you tell me how to solve this problem ? Thanks. Environment: Sun JDK 1.6 Oracle 11g ofbiz 9 jdbc driver (ojdbc6-11.2.0.3.jar) -- Sent from: http://ofbiz.135035.n4.nabble.com/OFBiz-User-f135036.html