<style>
/* Changing the layout to use less space for mobiles */
@media screen and (max-device-width: 480px), screen and (-webkit-min-device-pixel-ratio: 2) {
#email-body { min-width: 30em !important; }
#email-page { padding: 8px !important; }
#email-banner { padding: 8px 8px 0 8px !important; }
#email-avatar { margin: 1px 8px 8px 0 !important; padding: 0 !important; }
#email-fields { padding: 0 8px 8px 8px !important; }
#email-gutter { width: 0 !important; }
}
</style>
<div id="email-body">
<table id="email-wrap" align="center" border="0" cellpadding="0" cellspacing="0" style="background-color:#f0f0f0;color:#000000;width:100%;">
<tr valign="top">
<td id="email-page" style="padding:16px !important;">
<table align="center" border="0" cellpadding="0" cellspacing="0" style="background-color:#ffffff;border:1px solid #bbbbbb;color:#000000;width:100%;">
<tr valign="top">
<td bgcolor="#3e4c4e" style="background-color:#3e4c4e;color:#ffffff;font-family:Arial,FreeSans,Helvetica,sans-serif;font-size:12px;line-height:1;"><img src="https://www.jboss.org/dms/hibernate/images/jira/jiraheader_hibernate.png" alt="" style="vertical-align:top;" /></td>
</tr><tr valign="top">
<td id="email-banner" style="padding:32px 32px 0 32px;">
<table align="left" border="0" cellpadding="0" cellspacing="0" width="100%" style="width:100%;">
<tr valign="top">
<td style="color:#505050;font-family:Arial,FreeSans,Helvetica,sans-serif;padding:0;">
<img id="email-avatar" src="https://hibernate.onjira.com/secure/useravatar?avatarId=10162" alt="" height="48" width="48" border="0" align="left" style="padding:0;margin: 0 16px 16px 0;" />
<div id="email-action" style="padding: 0 0 8px 0;font-size:12px;line-height:18px;">
<a class="user-hover" rel="dunx" id="email_dunx" href="https://hibernate.onjira.com/secure/ViewProfile.jspa?name=dunx" style="color:#6c797f;">Yoseph Stephen</a>
created <img src="https://hibernate.onjira.com/images/icons/bug.gif" height="16" width="16" border="0" align="absmiddle" alt="Bug"> <a style='color:#6c797f;text-decoration:none;' href='https://hibernate.onjira.com/browse/HHH-7833'>HHH-7833</a>
</div>
<div id="email-summary" style="font-size:16px;line-height:20px;padding:2px 0 16px 0;">
<a style='color:#6c797f;text-decoration:none;' href='https://hibernate.onjira.com/browse/HHH-7833'><strong>Database Lock does not released after update or even after session closed</strong></a>
</div>
</td>
</tr>
</table>
</td>
</tr>
<tr valign="top">
<td id="email-fields" style="padding:0 32px 32px 32px;">
<table border="0" cellpadding="0" cellspacing="0" style="padding:0;text-align:left;width:100%;" width="100%">
<tr valign="top">
<td id="email-gutter" style="width:64px;white-space:nowrap;"></td>
<td>
<table border="0" cellpadding="0" cellspacing="0" width="100%">
<tr valign="top">
<td style="color:#000000;font-family:Arial,FreeSans,Helvetica,sans-serif;font-size:12px;padding:0 10px 10px 0;white-space:nowrap;">
<strong style="font-weight:normal;color:#505050;">Issue Type:</strong>
</td>
<td style="color:#000000;font-family:Arial,FreeSans,Helvetica,sans-serif;font-size:12px;padding:0 0 10px 0;width:100%;">
<img src="https://hibernate.onjira.com/images/icons/bug.gif" height="16" width="16" border="0" align="absmiddle" alt="Bug"> Bug
</td>
</tr> <tr valign="top">
<td style="color:#000000;font-family:Arial,FreeSans,Helvetica,sans-serif;font-size:12px;padding:0 10px 10px 0;white-space:nowrap;">
<strong style="font-weight:normal;color:#505050;">Affects Versions:</strong>
</td>
<td style="color:#000000;font-family:Arial,FreeSans,Helvetica,sans-serif;font-size:12px;padding:0 0 10px 0;width:100%;">
4.1.8 </td>
</tr>
<tr valign="top">
<td style="color:#000000;font-family:Arial,FreeSans,Helvetica,sans-serif;font-size:12px;padding:0 10px 10px 0;white-space:nowrap;">
<strong style="font-weight:normal;color:#505050;">Assignee:</strong>
</td>
<td style="color:#000000;font-family:Arial,FreeSans,Helvetica,sans-serif;font-size:12px;padding:0 0 10px 0;width:100%;">
Unassigned </td>
</tr> <tr valign="top">
<td style="color:#000000;font-family:Arial,FreeSans,Helvetica,sans-serif;font-size:12px;padding:0 10px 10px 0;white-space:nowrap;">
<strong style="font-weight:normal;color:#505050;">Components:</strong>
</td>
<td style="color:#000000;font-family:Arial,FreeSans,Helvetica,sans-serif;font-size:12px;padding:0 0 10px 0;width:100%;">
core </td>
</tr>
<tr valign="top">
<td style="color:#000000;font-family:Arial,FreeSans,Helvetica,sans-serif;font-size:12px;padding:0 10px 10px 0;white-space:nowrap;">
<strong style="font-weight:normal;color:#505050;">Created:</strong>
</td>
<td style="color:#000000;font-family:Arial,FreeSans,Helvetica,sans-serif;font-size:12px;padding:0 0 10px 0;width:100%;">
29/Nov/12 12:08 AM
</td>
</tr> <tr valign="top">
<td style="color:#000000;font-family:Arial,FreeSans,Helvetica,sans-serif;font-size:12px;padding:0 10px 10px 0;white-space:nowrap;">
<strong style="font-weight:normal;color:#505050;">Description:</strong>
</td>
<td style="color:#000000;font-family:Arial,FreeSans,Helvetica,sans-serif;font-size:12px;padding:0 0 10px 0;width:100%;">
<p style='margin-top:0;margin-bottom:10px;'>My application use multi-tenancy (with ehcache) and pessimistic & optimistic locking feature from Hibernate. For the pesimistic locking, the isolation level is set to 2, and optimistic locking is using "opt_lock" table column as version field.</p>
<p style='margin-top:0;margin-bottom:10px;'>When I execute a certain web request, the process should create multiple DB session and should work as the following steps:<br/>
01. - Start Session 1<br/>
02. – SELECT Data by ID<br/>
03. – Start Session 2<br/>
04. — SELECT FOR UPDATE Data by ID<br/>
05. — UPDATE Data by ID<br/>
06. – Close Session 2<br/>
07. – Start Session 3<br/>
08. — SELECT FOR UPDATE Data by ID<br/>
09. — UPDATE Data by ID<br/>
10. – Close Session 3<br/>
11. - Close Session 1</p>
<p style='margin-top:0;margin-bottom:10px;'>The Data by ID is referring to the same table record. The problem is, I always encounter a deadlock at Step 08. It seems the database lock at Step 04 does not released after updating the data (Step 05).</p>
<p style='margin-top:0;margin-bottom:10px;'>Below are the application logs for the described problem above:</p>
<p style='margin-top:0;margin-bottom:10px;'>Step 01:<br/>
-------<br/>
<span class="error">[2012-11-29 11:50:52,696]</span> INFO HibernateSession:53 - Start Session: d81cda<br/>
<span class="error">[2012-11-29 11:50:52,774]</span>DEBUG HibernateSession:161 - Begin Trx: 2e749c</p>
<p style='margin-top:0;margin-bottom:10px;'>Step 02:<br/>
-------<br/>
Hibernate:<br/>
select<br/>
....<br/>
from<br/>
data this_<br/>
inner join<br/>
users user2_<br/>
on this_.owner_id=user2_.id<br/>
where<br/>
this_.id=?<br/>
order by<br/>
this_.create_date asc limit ?</p>
<p style='margin-top:0;margin-bottom:10px;'>Step 03:<br/>
-------<br/>
<span class="error">[2012-11-29 11:50:53,024]</span> INFO HibernateSession:53 - Start Session: 163f47e<br/>
<span class="error">[2012-11-29 11:50:53,024]</span>DEBUG HibernateSession:161 - Begin Trx: 19546ee</p>
<p style='margin-top:0;margin-bottom:10px;'>Step 04:<br/>
-------<br/>
Hibernate:<br/>
select<br/>
id<br/>
from<br/>
data<br/>
where<br/>
id =?<br/>
and opt_lock =? for update</p>
<p style='margin-top:0;margin-bottom:10px;'>Step 05:<br/>
-------<br/>
Hibernate:<br/>
update<br/>
data<br/>
set<br/>
...<br/>
where<br/>
id=?<br/>
and opt_lock=?</p>
<p style='margin-top:0;margin-bottom:10px;'>Step 06:<br/>
-------<br/>
<span class="error">[2012-11-29 11:50:53,040]</span>DEBUG HibernateSession:93 - Commit Trx: 19546ee - 16ms<br/>
<span class="error">[2012-11-29 11:50:53,040]</span>DEBUG HibernateSession:101 - Close Session: 163f47e</p>
<p style='margin-top:0;margin-bottom:10px;'>Step 07:<br/>
-------<br/>
<span class="error">[2012-11-29 11:50:59,383]</span> INFO HibernateSession:53 - Start Session: 112731f<br/>
<span class="error">[2012-11-29 11:50:59,383]</span>DEBUG HibernateSession:161 - Begin Trx: 1aec462</p>
<p style='margin-top:0;margin-bottom:10px;'>Step 08:<br/>
-------<br/>
Hibernate:<br/>
select<br/>
id<br/>
from<br/>
data<br/>
where<br/>
id =?<br/>
and opt_lock =? for update</p>
<p style='margin-top:0;margin-bottom:10px;'>DEADLOCK HAPPENS HERE!!!!! (Application hangs, the record is also cannot be retrieved via pgAdmin)</p>
<p style='margin-top:0;margin-bottom:10px;'>Below are the logs description info:<br/>
"Start Session" -> Call openSession() from SessionFactory, the hex is hashCode for the created session object<br/>
"Close Session" -> Call close() in session object, the hex is hashCode for the created session object<br/>
"Begin Trx" -> Call beginTransaction() in session object, the hex is hascCode for the created transaction object<br/>
"Commit Trx" -> Call commit() in transaction object, the hex is hascCode for the created transaction object</p>
<p style='margin-top:0;margin-bottom:10px;'>This is my environment:</p>
<ul class="alternate" type="square">
<li>Hibernate 4.1.8 Final</li>
<li>Spring 3.1.1</li>
<li>Struts 2.3.7</li>
<li>PostgresSQL 9.1</li>
</ul>
<p style='margin-top:0;margin-bottom:10px;'>Can anyone help me to solve this problem?</p>
<p style='margin-top:0;margin-bottom:10px;'>Thank you.</p>
</td>
</tr>
<tr valign="top">
<td style="color:#000000;font-family:Arial,FreeSans,Helvetica,sans-serif;font-size:12px;padding:0 10px 10px 0;white-space:nowrap;">
<strong style="font-weight:normal;color:#505050;">Environment:</strong>
</td>
<td style="color:#000000;font-family:Arial,FreeSans,Helvetica,sans-serif;font-size:12px;padding:0 0 10px 0;width:100%;">
PostgresSQL 9.1
</td>
</tr>
<tr valign="top">
<td style="color:#000000;font-family:Arial,FreeSans,Helvetica,sans-serif;font-size:12px;padding:0 10px 10px 0;white-space:nowrap;">
<strong style="font-weight:normal;color:#505050;">Project:</strong>
</td>
<td style="color:#000000;font-family:Arial,FreeSans,Helvetica,sans-serif;font-size:12px;padding:0 0 10px 0;width:100%;">
<a style="color:#6c797f;" href="https://hibernate.onjira.com/browse/HHH">Hibernate ORM</a>
</td>
</tr> <tr valign="top">
<td style="color:#000000;font-family:Arial,FreeSans,Helvetica,sans-serif;font-size:12px;padding:0 10px 10px 0;white-space:nowrap;">
<strong style="font-weight:normal;color:#505050;">Labels:</strong>
</td>
<td style="color:#000000;font-family:Arial,FreeSans,Helvetica,sans-serif;font-size:12px;padding:0 0 10px 0;width:100%;">
hibernate
core
</td>
</tr>
<tr valign="top">
<td style="color:#000000;font-family:Arial,FreeSans,Helvetica,sans-serif;font-size:12px;padding:0 10px 10px 0;white-space:nowrap;">
<strong style="font-weight:normal;color:#505050;">Priority:</strong>
</td>
<td style="color:#000000;font-family:Arial,FreeSans,Helvetica,sans-serif;font-size:12px;padding:0 0 10px 0;width:100%;">
<img src="https://hibernate.onjira.com/images/icons/priority_critical.gif" height="16" width="16" border="0" align="absmiddle" alt="Critical"> Critical
</td>
</tr> <tr valign="top">
<td style="color:#000000;font-family:Arial,FreeSans,Helvetica,sans-serif;font-size:12px;padding:0 10px 10px 0;white-space:nowrap;">
<strong style="font-weight:normal;color:#505050;">Reporter:</strong>
</td>
<td style="color:#000000;font-family:Arial,FreeSans,Helvetica,sans-serif;font-size:12px;padding:0 0 10px 0;width:100%;">
<a class="user-hover" rel="dunx" id="email_dunx" href="https://hibernate.onjira.com/secure/ViewProfile.jspa?name=dunx" style="color:#6c797f;">Yoseph Stephen</a>
</td>
</tr>
</table>
</td>
</tr>
</table>
</td>
</tr>
</table>
</td><!-- End #email-page -->
</tr>
<tr valign="top">
<td style="color:#505050;font-family:Arial,FreeSans,Helvetica,sans-serif;font-size:10px;line-height:14px;padding: 0 16px 16px 16px;text-align:center;">
This message is automatically generated by JIRA.<br />
If you think it was sent incorrectly, please contact your JIRA administrators<br />
For more information on JIRA, see: <a style='color:#6c797f;' href='http://www.atlassian.com/software/jira'>http://www.atlassian.com/software/jira</a>
</td>
</tr>
</table><!-- End #email-wrap -->
</div><!-- End #email-body -->