<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:m="http://schemas.microsoft.com/office/2004/12/omml" xmlns="http://www.w3.org/TR/REC-html40">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=Windows-1252">
<meta name="Generator" content="Microsoft Word 15 (filtered medium)">
<!--[if !mso]><style>v\:* {behavior:url(#default#VML);}
o\:* {behavior:url(#default#VML);}
w\:* {behavior:url(#default#VML);}
.shape {behavior:url(#default#VML);}
</style><![endif]--><style><!--
/* Font Definitions */
@font-face
{font-family:"Cambria Math";
panose-1:2 4 5 3 5 4 6 3 2 4;}
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0in;
font-size:11.0pt;
font-family:"Calibri",sans-serif;}
p.xmsonormal, li.xmsonormal, div.xmsonormal
{mso-style-name:x_msonormal;
mso-margin-top-alt:auto;
margin-right:0in;
mso-margin-bottom-alt:auto;
margin-left:0in;
font-size:11.0pt;
font-family:"Calibri",sans-serif;}
span.EmailStyle20
{mso-style-type:personal-reply;
font-family:"Calibri",sans-serif;
color:windowtext;}
.MsoChpDefault
{mso-style-type:export-only;
font-size:10.0pt;}
@page WordSection1
{size:8.5in 11.0in;
margin:1.0in 1.0in 1.0in 1.0in;}
div.WordSection1
{page:WordSection1;}
--></style><!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]-->
</head>
<body lang="EN-US" link="#0563C1" vlink="#954F72" style="word-wrap:break-word">
<div class="WordSection1">
<p class="MsoNormal">Peter,<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">Unfortunately that’s an empty set. It seems like the lock_version is constantly changing for this record. I’m not sure why.<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">-Patrick<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<div style="border:none;border-top:solid #B5C4DF 1.0pt;padding:3.0pt 0in 0in 0in">
<p class="MsoNormal" style="margin-bottom:12.0pt"><b><span style="font-size:12.0pt;color:black">From:
</span></b><span style="font-size:12.0pt;color:black">archivesspace_users_group-bounces@lyralists.lyrasis.org <archivesspace_users_group-bounces@lyralists.lyrasis.org> on behalf of Peter Heiner <ph448@cam.ac.uk><br>
<b>Date: </b>Thursday, December 2, 2021 at 12:41 PM<br>
<b>To: </b>Archivesspace Users Group <archivesspace_users_group@lyralists.lyrasis.org><br>
<b>Subject: </b>Re: [Archivesspace_Users_Group] Optimistic locking error<o:p></o:p></span></p>
</div>
<div style="border:solid windowtext 1.0pt;padding:2.0pt 2.0pt 2.0pt 2.0pt;display:inline-block">
<p class="MsoNormal" style="line-height:13.0pt"><b><span style="font-size:12.0pt">***External***</span></b><em><span style="font-size:12.0pt;font-family:"Calibri",sans-serif"> This email originated from outside of the organization. Do not click links or open
attachments unless you recognize the sender and know the content is safe.***</span></em><span style="font-size:12.0pt"><o:p></o:p></span></p>
</div>
<p class="MsoNormal" style="margin-bottom:12.0pt"><o:p> </o:p></p>
<div>
<div>
<p class="MsoNormal">Hi Patrick,<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
<div>
<p class="MsoNormal">What does<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal">SELECT * FROM `user` <span style="color:black;background:white">WHERE ((`id` = 113) AND (`lock_version` = 1271));</span><o:p></o:p></p>
</div>
<div>
<p class="MsoNormal"><span style="color:black;background:white">say?</span><o:p></o:p></p>
</div>
<div>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
<div>
<p class="MsoNormal">p<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
<div class="MsoNormal" align="center" style="text-align:center">
<hr size="0" width="100%" align="center">
</div>
<div id="divRplyFwdMsg">
<p class="MsoNormal"><b><span style="color:black">From:</span></b><span style="color:black"> archivesspace_users_group-bounces@lyralists.lyrasis.org <archivesspace_users_group-bounces@lyralists.lyrasis.org> on behalf of Galligan, Patrick <PGalligan@rockarch.org><br>
<b>Sent:</b> 02 December 2021 16:57<br>
<b>To:</b> Archivesspace Users Group <archivesspace_users_group@lyralists.lyrasis.org><br>
<b>Subject:</b> [Archivesspace_Users_Group] Optimistic locking error</span> <o:p>
</o:p></p>
<div>
<p class="MsoNormal"> <o:p></o:p></p>
</div>
</div>
<div>
<div>
<p class="xmsonormal" style="margin:0in">Hi all,<span style="font-size:12.0pt"><o:p></o:p></span></p>
<p class="xmsonormal" style="margin:0in"> <span style="font-size:12.0pt"><o:p></o:p></span></p>
<p class="xmsonormal" style="margin:0in">I’m trying to diagnose and fix a warning I’m seeing in our AS log files every 12 or 13 seconds:<span style="font-size:12.0pt"><o:p></o:p></span></p>
<p class="xmsonormal" style="margin:0in"> <span style="font-size:12.0pt"><o:p></o:p></span></p>
<p class="xmsonormal" style="margin:0in">Got an optimistic locking error when updating user: Attempt to update object did not result in a single row modification (SQL: UPDATE `user` SET `system_mtime` = '2021-12-02 16:52:37', `user_mtime` = '2021-12-02 16:52:37',
`lock_version` = 1272 WHERE ((`id` = 113) AND (`lock_version` = 1271)) LIMIT 1)<span style="font-size:12.0pt"><o:p></o:p></span></p>
<p class="xmsonormal" style="margin:0in"> <span style="font-size:12.0pt"><o:p></o:p></span></p>
<p class="xmsonormal" style="margin:0in">I can delete the user, but if I remake it with the same username, the warning comes back. If I leave the user open for editing, I get the “This record has been updated by another user. Please refresh the page to access
the latest version,” message in the UI.<span style="font-size:12.0pt"><o:p></o:p></span></p>
<p class="xmsonormal" style="margin:0in"> <span style="font-size:12.0pt"><o:p></o:p></span></p>
<p class="xmsonormal" style="margin:0in">Any idea how to fix this issue? I’d prefer to be able to keep the username the same. I’m not sure why the system thinks there are two different lock versions associated with the record.<span style="font-size:12.0pt"><o:p></o:p></span></p>
<p class="xmsonormal" style="margin:0in"> <span style="font-size:12.0pt"><o:p></o:p></span></p>
<p class="xmsonormal" style="margin:0in">Thanks,<span style="font-size:12.0pt"><o:p></o:p></span></p>
<p class="xmsonormal" style="margin:0in">Patrick Galligan<span style="font-size:12.0pt"><o:p></o:p></span></p>
<p class="xmsonormal" style="margin:0in">Rockefeller Archive Center<span style="font-size:12.0pt"><o:p></o:p></span></p>
</div>
</div>
</div>
</div>
</body>
</html>