<div dir="ltr"><div class="gmail_default" style=""><div class="gmail_default" style=""><font face="verdana, sans-serif">We implemented Did you mean with all available patches when we upgraded to 3.7 in early January. While the feature works well in the opac and we're not seeing a difference in search performance, we are seeing deadlocks on our postgres logs as described in <a href="https://bugs.launchpad.net/evergreen/+bug/1931737" target="_blank" style="">bug 1931737</a>.</font></div><div class="gmail_default" style=""><font face="verdana, sans-serif"><br></font></div><div class="gmail_default" style=""><font face="verdana, sans-serif">Most days we see zero to ten deadlocks logged, prior to our upgrade, we saw none. Since our upgrade there have been four days where the number has been between 120 and 260. What our staff users see is that saving or overlaying records can fail, and record loads report failures and need to be reprocessed.</font></div><div class="gmail_default" style="font-family:verdana,sans-serif"><br></div><div class="gmail_default" style="font-family:verdana,sans-serif">Hope this is helpful,</div><div class="gmail_default" style="font-family:verdana,sans-serif">Michele</div><div class="gmail_default" style="font-family:verdana,sans-serif"><br></div></div><div><div dir="ltr" class="gmail_signature" data-smartmail="gmail_signature"><div dir="ltr"><div dir="ltr"><div dir="ltr"><div dir="ltr"><div dir="ltr"><div><span style="font-family:verdana,sans-serif">--</span><br></div><div><font face="verdana, sans-serif">Michele M. Morgan, <span style="font-size:12.8px">Technical Support Analyst<br></span></font></div><div><span style="font-size:12.8px"><font face="verdana, sans-serif">North of Boston Library Exchange, Danvers Massachusetts</font></span></div><div><span style="font-size:12.8px"><a href="mailto:mmorgan@noblenet.org" target="_blank"><font face="verdana, sans-serif">mmorgan@noblenet.org</font></a></span></div><div><br></div></div></div></div></div></div></div></div><br></div><br><div class="gmail_quote"><div dir="ltr" class="gmail_attr">On Fri, Feb 18, 2022 at 10:09 AM Jason Stephenson via Evergreen-general <<a href="mailto:evergreen-general@list.evergreen-ils.org">evergreen-general@list.evergreen-ils.org</a>> wrote:<br></div><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex">On 2/18/22 09:58, Elaine Hardy via Evergreen-general wrote:<br>
> I haven't had any issues importing, merging, editing bib records in 3.8. <br>
> Nor have I gotten any reports of problems.<br>
<br>
<br>
I think the issues with importing records are mostly fixed by the patch <br>
for <a href="https://bugs.launchpad.net/evergreen/+bug/1947173" rel="noreferrer" target="_blank">https://bugs.launchpad.net/evergreen/+bug/1947173</a><br>
<br>
It may still be possible to get deadlocks. I have not thoroughly tested <br>
this.<br>
<br>
<br>
> <br>
> <br>
> <br>
> J. Elaine Hardy,PINES and Collaborative Projects Manager<br>
> <br>
> ------------------------------------------------------------------------<br>
> <br>
> Georgia Public Library Service<br>
> <br>
> 2872 Woodcock Blvd., Suite 250 | Atlanta, GA 30341<br>
> <br>
> (404) 235-7128| <a href="mailto:ehardy@georgialibraries.org" target="_blank">ehardy@georgialibraries.org</a> <br>
> <mailto:<a href="mailto:ehardy@georgialibraries.org" target="_blank">ehardy@georgialibraries.org</a>><br>
> <br>
> (404) 548-4241 | Cell<br>
> <br>
> <br>
> <<a href="https://www.facebook.com/georgialibraries" rel="noreferrer" target="_blank">https://www.facebook.com/georgialibraries</a>><<a href="https://www.twitter.com/georgialibs" rel="noreferrer" target="_blank">https://www.twitter.com/georgialibs</a>><<a href="https://www.instagram.com/georgialibraries/" rel="noreferrer" target="_blank">https://www.instagram.com/georgialibraries/</a>><br>
> <br>
> Join our email list <<a href="http://georgialibraries.org/subscription" rel="noreferrer" target="_blank">http://georgialibraries.org/subscription</a>>for <br>
> stories of Georgia libraries making an impact in our communities.<br>
> <br>
> <br>
> It does not do to leave a live dragon out of your calculations, if you <br>
> live near him. /— J.R.R. Tolkien/<br>
> <br>
> <br>
> <br>
> On Fri, Feb 18, 2022 at 9:46 AM Terran McCanna <br>
> <<a href="mailto:tmccanna@georgialibraries.org" target="_blank">tmccanna@georgialibraries.org</a> <mailto:<a href="mailto:tmccanna@georgialibraries.org" target="_blank">tmccanna@georgialibraries.org</a>>> <br>
> wrote:<br>
> <br>
> Hi Jeff - Not that I'm aware of. Flagging Chris and Elaine for more<br>
> info, though.<br>
> <br>
> On Thu, Feb 17, 2022, 6:49 PM Jeff Davis via Evergreen-general<br>
> <<a href="mailto:evergreen-general@list.evergreen-ils.org" target="_blank">evergreen-general@list.evergreen-ils.org</a><br>
> <mailto:<a href="mailto:evergreen-general@list.evergreen-ils.org" target="_blank">evergreen-general@list.evergreen-ils.org</a>>> wrote:<br>
> <br>
> Terran, I'm curious if PINES has had problems with deadlocks when<br>
> working with bib records, as reported in this bug:<br>
> <a href="https://bugs.launchpad.net/evergreen/+bug/1931737" rel="noreferrer" target="_blank">https://bugs.launchpad.net/evergreen/+bug/1931737</a><br>
> <<a href="https://bugs.launchpad.net/evergreen/+bug/1931737" rel="noreferrer" target="_blank">https://bugs.launchpad.net/evergreen/+bug/1931737</a>><br>
> <br>
> We held off on implementing Did You Mean locally due to some<br>
> other bugs<br>
> that have since been resolved, but that one still makes me hesitant.<br>
> -- <br>
> Jeff Davis<br>
> BC Libraries Cooperative<br>
> <br>
> <br>
> On 2022-02-16 6:28 a.m., Terran McCanna via Evergreen-general wrote:<br>
> > We moved from 3.6 to 3.8 with it implemented and have not<br>
> noticed a<br>
> > difference.<br>
> ><br>
> ><br>
> ><br>
> > Terran McCanna, PINES Program Manager<br>
> ><br>
> ><br>
> ------------------------------------------------------------------------<br>
> ><br>
> > Georgia Public Library Service | University System of Georgia<br>
> ><br>
> > 2872 Woodcock Blvd, Suite 250 l Atlanta, GA 30341<br>
> ><br>
> > (404) 235-7138| <a href="mailto:tmccanna@georgialibraries.org" target="_blank">tmccanna@georgialibraries.org</a><br>
> <mailto:<a href="mailto:tmccanna@georgialibraries.org" target="_blank">tmccanna@georgialibraries.org</a>><br>
> > <mailto:<a href="mailto:tmccanna@georgialibraries.org" target="_blank">tmccanna@georgialibraries.org</a><br>
> <mailto:<a href="mailto:tmccanna@georgialibraries.org" target="_blank">tmccanna@georgialibraries.org</a>>><br>
> ><br>
> > <a href="http://help.georgialibraries.org" rel="noreferrer" target="_blank">http://help.georgialibraries.org</a><br>
> <<a href="http://help.georgialibraries.org" rel="noreferrer" target="_blank">http://help.georgialibraries.org</a>><br>
> <<a href="http://help.georgialibraries.org" rel="noreferrer" target="_blank">http://help.georgialibraries.org</a><br>
> <<a href="http://help.georgialibraries.org" rel="noreferrer" target="_blank">http://help.georgialibraries.org</a>>> |<br>
> > <a href="mailto:help@georgialibraries.org" target="_blank">help@georgialibraries.org</a> <mailto:<a href="mailto:help@georgialibraries.org" target="_blank">help@georgialibraries.org</a>><br>
> <mailto:<a href="mailto:help@georgialibraries.org" target="_blank">help@georgialibraries.org</a><br>
> <mailto:<a href="mailto:help@georgialibraries.org" target="_blank">help@georgialibraries.org</a>>><br>
> ><br>
> ><br>
> > <<a href="https://www.facebook.com/georgialibraries" rel="noreferrer" target="_blank">https://www.facebook.com/georgialibraries</a><br>
> <<a href="https://www.facebook.com/georgialibraries" rel="noreferrer" target="_blank">https://www.facebook.com/georgialibraries</a>>><<a href="https://www.twitter.com/georgialibs" rel="noreferrer" target="_blank">https://www.twitter.com/georgialibs</a><br>
> <<a href="https://www.twitter.com/georgialibs" rel="noreferrer" target="_blank">https://www.twitter.com/georgialibs</a>>><<a href="https://www.instagram.com/georgialibraries/" rel="noreferrer" target="_blank">https://www.instagram.com/georgialibraries/</a><br>
> <<a href="https://www.instagram.com/georgialibraries/" rel="noreferrer" target="_blank">https://www.instagram.com/georgialibraries/</a>>><<a href="https://www.twitter.com/georgialibs" rel="noreferrer" target="_blank">https://www.twitter.com/georgialibs</a><br>
> <<a href="https://www.twitter.com/georgialibs" rel="noreferrer" target="_blank">https://www.twitter.com/georgialibs</a>>><br>
> ><br>
> > Join our email list <<a href="http://georgialibraries.org" rel="noreferrer" target="_blank">http://georgialibraries.org</a><br>
> <<a href="http://georgialibraries.org" rel="noreferrer" target="_blank">http://georgialibraries.org</a>>>for stories of Georgia<br>
> > libraries making an impact in our communities.<br>
> ><br>
> ><br>
> ><br>
> ><br>
> > On Wed, Feb 16, 2022 at 8:56 AM Joan Kranich via<br>
> Evergreen-general<br>
> > <<a href="mailto:evergreen-general@list.evergreen-ils.org" target="_blank">evergreen-general@list.evergreen-ils.org</a><br>
> <mailto:<a href="mailto:evergreen-general@list.evergreen-ils.org" target="_blank">evergreen-general@list.evergreen-ils.org</a>><br>
> > <mailto:<a href="mailto:evergreen-general@list.evergreen-ils.org" target="_blank">evergreen-general@list.evergreen-ils.org</a><br>
> <mailto:<a href="mailto:evergreen-general@list.evergreen-ils.org" target="_blank">evergreen-general@list.evergreen-ils.org</a>>>> wrote:<br>
> ><br>
> > Hello,<br>
> ><br>
> > We are making plans to upgrade to release 3.7. If you have<br>
> > implemented Did You Mean, have you found it has affected<br>
> performance<br>
> > or response time?<br>
> ><br>
> > Thank you.<br>
> > Joan<br>
> ><br>
> > --<br>
> ><br>
> ><br>
> ><br>
> > Joan Kranich | Library Applications Manager<br>
> ><br>
> > CW MARS<br>
> ><br>
> > <a href="mailto:jkranich@cwmars.org" target="_blank">jkranich@cwmars.org</a> <mailto:<a href="mailto:jkranich@cwmars.org" target="_blank">jkranich@cwmars.org</a>><br>
> <mailto:<a href="mailto:jkranich@cwmars.org" target="_blank">jkranich@cwmars.org</a> <mailto:<a href="mailto:jkranich@cwmars.org" target="_blank">jkranich@cwmars.org</a>>><br>
> ><br>
> > 508-755-3323 x321 or x1 <tel:(508)%20755-3323><br>
> ><br>
> > <a href="http://www.cwmars.org" rel="noreferrer" target="_blank">http://www.cwmars.org</a> <<a href="http://www.cwmars.org" rel="noreferrer" target="_blank">http://www.cwmars.org</a>><br>
> <<a href="http://www.cwmars.org/" rel="noreferrer" target="_blank">http://www.cwmars.org/</a> <<a href="http://www.cwmars.org/" rel="noreferrer" target="_blank">http://www.cwmars.org/</a>>><br>
> ><br>
> > Pronouns <<a href="https://www.mypronouns.org/what-and-why" rel="noreferrer" target="_blank">https://www.mypronouns.org/what-and-why</a><br>
> <<a href="https://www.mypronouns.org/what-and-why" rel="noreferrer" target="_blank">https://www.mypronouns.org/what-and-why</a>>>: she, her, hers<br>
> ><br>
> ><br>
> ><br>
> > _______________________________________________<br>
> > Evergreen-general mailing list<br>
> > <a href="mailto:Evergreen-general@list.evergreen-ils.org" target="_blank">Evergreen-general@list.evergreen-ils.org</a><br>
> <mailto:<a href="mailto:Evergreen-general@list.evergreen-ils.org" target="_blank">Evergreen-general@list.evergreen-ils.org</a>><br>
> > <mailto:<a href="mailto:Evergreen-general@list.evergreen-ils.org" target="_blank">Evergreen-general@list.evergreen-ils.org</a><br>
> <mailto:<a href="mailto:Evergreen-general@list.evergreen-ils.org" target="_blank">Evergreen-general@list.evergreen-ils.org</a>>><br>
> ><br>
> <a href="http://list.evergreen-ils.org/cgi-bin/mailman/listinfo/evergreen-general" rel="noreferrer" target="_blank">http://list.evergreen-ils.org/cgi-bin/mailman/listinfo/evergreen-general</a><br>
> <<a href="http://list.evergreen-ils.org/cgi-bin/mailman/listinfo/evergreen-general" rel="noreferrer" target="_blank">http://list.evergreen-ils.org/cgi-bin/mailman/listinfo/evergreen-general</a>><br>
> > <br>
> <<a href="http://list.evergreen-ils.org/cgi-bin/mailman/listinfo/evergreen-general" rel="noreferrer" target="_blank">http://list.evergreen-ils.org/cgi-bin/mailman/listinfo/evergreen-general</a> <<a href="http://list.evergreen-ils.org/cgi-bin/mailman/listinfo/evergreen-general" rel="noreferrer" target="_blank">http://list.evergreen-ils.org/cgi-bin/mailman/listinfo/evergreen-general</a>>><br>
> ><br>
> ><br>
> > _______________________________________________<br>
> > Evergreen-general mailing list<br>
> > <a href="mailto:Evergreen-general@list.evergreen-ils.org" target="_blank">Evergreen-general@list.evergreen-ils.org</a><br>
> <mailto:<a href="mailto:Evergreen-general@list.evergreen-ils.org" target="_blank">Evergreen-general@list.evergreen-ils.org</a>><br>
> ><br>
> <a href="http://list.evergreen-ils.org/cgi-bin/mailman/listinfo/evergreen-general" rel="noreferrer" target="_blank">http://list.evergreen-ils.org/cgi-bin/mailman/listinfo/evergreen-general</a><br>
> <<a href="http://list.evergreen-ils.org/cgi-bin/mailman/listinfo/evergreen-general" rel="noreferrer" target="_blank">http://list.evergreen-ils.org/cgi-bin/mailman/listinfo/evergreen-general</a>><br>
> _______________________________________________<br>
> Evergreen-general mailing list<br>
> <a href="mailto:Evergreen-general@list.evergreen-ils.org" target="_blank">Evergreen-general@list.evergreen-ils.org</a><br>
> <mailto:<a href="mailto:Evergreen-general@list.evergreen-ils.org" target="_blank">Evergreen-general@list.evergreen-ils.org</a>><br>
> <a href="http://list.evergreen-ils.org/cgi-bin/mailman/listinfo/evergreen-general" rel="noreferrer" target="_blank">http://list.evergreen-ils.org/cgi-bin/mailman/listinfo/evergreen-general</a><br>
> <<a href="http://list.evergreen-ils.org/cgi-bin/mailman/listinfo/evergreen-general" rel="noreferrer" target="_blank">http://list.evergreen-ils.org/cgi-bin/mailman/listinfo/evergreen-general</a>><br>
> <br>
> <br>
> _______________________________________________<br>
> Evergreen-general mailing list<br>
> <a href="mailto:Evergreen-general@list.evergreen-ils.org" target="_blank">Evergreen-general@list.evergreen-ils.org</a><br>
> <a href="http://list.evergreen-ils.org/cgi-bin/mailman/listinfo/evergreen-general" rel="noreferrer" target="_blank">http://list.evergreen-ils.org/cgi-bin/mailman/listinfo/evergreen-general</a><br>
_______________________________________________<br>
Evergreen-general mailing list<br>
<a href="mailto:Evergreen-general@list.evergreen-ils.org" target="_blank">Evergreen-general@list.evergreen-ils.org</a><br>
<a href="http://list.evergreen-ils.org/cgi-bin/mailman/listinfo/evergreen-general" rel="noreferrer" target="_blank">http://list.evergreen-ils.org/cgi-bin/mailman/listinfo/evergreen-general</a><br>
</blockquote></div>