<html><body><div style="font-family: arial, helvetica, sans-serif; font-size: 12pt; color: #000000"><div>I have seen the same Mutex error on my test server on Debian 10. In my case it happens somewhat randomly. I applied fix #1 from the following link.</div><div><br data-mce-bogus="1"></div><div> <a href="https://mazer.dev/en/blog/posts/apache2-identifier-removed-couldnt-grab-accept-mutex/">https://mazer.dev/en/blog/posts/apache2-identifier-removed-couldnt-grab-accept-mutex/</a></div><div><br></div><div data-marker="__SIG_PRE__">Bob Wicksall<br>Computer and Network Services Manager<br><br>OWWL Library System<br>2557 State Rt. 21<br>Canandaigua, New York 14424<br><br>Voice: (585) 394-8260 ext. 1110<br>Fax: (585) 394-1935</div><div><br></div><hr id="zwchr" data-marker="__DIVIDER__"><div data-marker="__HEADERS__"><blockquote style="border-left:2px solid #1010FF;margin-left:5px;padding-left:5px;color:#000;font-weight:normal;font-style:normal;text-decoration:none;font-family:Helvetica,Arial,sans-serif;font-size:12pt;"><b>From: </b>"Brian Holda via Evergreen-dev" <evergreen-dev@list.evergreen-ils.org><br><b>To: </b>"Evergreen Development Discussion List" <evergreen-dev@list.evergreen-ils.org>, "Brian Holda" <brian.holda@calvin.edu><br><b>Sent: </b>Monday, October 9, 2023 8:56:19 AM<br><b>Subject: </b>Re: [Evergreen-dev] marc_export - apache crashes<br></blockquote></div><div><style style="display:none">/*<![CDATA[*/P {
margin-top: 0;
margin-bottom: 0;
}
/*]]>*/</style></div><div data-marker="__QUOTED_TEXT__"><blockquote style="border-left:2px solid #1010FF;margin-left:5px;padding-left:5px;color:#000;font-weight:normal;font-style:normal;text-decoration:none;font-family:Helvetica,Arial,sans-serif;font-size:12pt;">
<div style="font-family:'calibri light' , 'helvetica light' , sans-serif;font-size:16pt;color:rgb( 0 , 0 , 0 )" class="elementToProof">
Or maybe a better way to ask this. Have people found a good way to export a large number of marc records within Evergreen? We found the staff client way to do it. And it processes files of 5-10,000 records at a time. But if we want to do 1 million records,
let's say, it's a bit tedious. So then I found the <a href="https://urldefense.proofpoint.com/v2/url?u=https-3A__docs.evergreen-2Dils.org_3.2_-5Fmarc-5Fexport-5Fexporting-5Fbibliographic-5Frecords-5Finto-5Fmarc-5Ffiles.html&d=DwMGaQ&c=4rZ6NPIETe-LE5i2KBR4rw&r=rB3XDC6iCWGkjZtiGXbRHlEfGQP12yvXoVpChsQG6IY&m=PZmft0gaDkWQJ-PsQAmuzLbFyoxYjph24cGK4vqaTEXFnORZ9vEDMUnFRbuzb4np&s=28sCuznEp6eX3W0zi51ryW-NBwTZ0P8RjE4l6oEL_rE&e=" style="margin:0px;background-color:rgb( 255 , 255 , 255 )" target="_blank" rel="nofollow noopener noreferrer">marc_export
script</a>. But that crashed our server doing it with 3,000 records at a time. We have ideas on how to modify the process, and it's not terrible using the staff client way, but I figure this must be a somewhat common task that others have good solutions for?
Anyone willing to share <span id="🙂">🙂?</span></div>
<div style="font-family:'calibri light' , 'helvetica light' , sans-serif;font-size:16pt;color:rgb( 0 , 0 , 0 )" class="elementToProof">
<br>
</div>
<div style="font-family:'calibri light' , 'helvetica light' , sans-serif;font-size:16pt;color:rgb( 0 , 0 , 0 )" class="elementToProof">
Thanks,</div>
<div style="font-family:'calibri light' , 'helvetica light' , sans-serif;font-size:16pt;color:rgb( 0 , 0 , 0 )" class="elementToProof">
Brian</div>
<div class="elementToProof">
<div style="font-family:'calibri light' , 'helvetica light' , sans-serif;font-size:16pt;color:rgb( 0 , 0 , 0 )">
<br>
</div>
<div id="Signature">
<div>
<div class="WordSection1">
<p style="line-height:18pt"><span style="font-size:12pt;font-family:'georgia' , serif;color:rgb( 51 , 51 , 51 )">Brian Holda<br>
Library Technology Manager<br>
Hekman Library<br>
Calvin University<br>
(616) 526-8673</span></p>
<p style="line-height:18pt"><span style="font-size:12pt;font-family:'georgia' , serif;color:rgb( 51 , 51 , 51 )"><a href="https://library.calvin.edu/" target="_blank" rel="nofollow noopener noreferrer"><img border="0" width="245" height="34" src="cid:e83c175b-fa22-41ee-b0e4-dc4102c98d50"></a></span></p>
<p style="line-height:18pt"><span style="font-size:12pt;font-family:'georgia' , serif;color:rgb( 51 , 51 , 51 )"> </span></p>
</div>
</div>
</div>
</div>
<div id="appendonsend"></div>
<hr style="display:inline-block;width:98%">
<div id="divRplyFwdMsg" dir="ltr"><font face="Calibri, sans-serif" style="font-size:11pt" color="#000000"><b>From:</b> Evergreen-dev <evergreen-dev-bounces@list.evergreen-ils.org> on behalf of Brian Holda via Evergreen-dev <evergreen-dev@list.evergreen-ils.org><br>
<b>Sent:</b> Thursday, October 5, 2023 4:25 PM<br>
<b>To:</b> Evergreen Development Discussion List <evergreen-dev@list.evergreen-ils.org><br>
<b>Subject:</b> [Evergreen-dev] marc_export - apache crashes</font>
<div> </div>
</div>
<style style="display:none">/*<![CDATA[*/p {
margin-top: 0;
margin-bottom: 0;
}
/*]]>*/</style>
<div dir="ltr">
<div class="x_elementToProof" style="font-family:'calibri light' , 'helvetica light' , sans-serif;font-size:16pt;color:rgb( 0 , 0 , 0 )">
Hi all, </div>
<div class="x_elementToProof" style="font-family:'calibri light' , 'helvetica light' , sans-serif;font-size:16pt;color:rgb( 0 , 0 , 0 )">
<br>
</div>
<div class="x_elementToProof" style="font-family:'calibri light' , 'helvetica light' , sans-serif;font-size:16pt;color:rgb( 0 , 0 , 0 )">
Not sure if it's user error or something else going on, so wanted to see if any of you all have experience using
<a href="https://urldefense.proofpoint.com/v2/url?u=https-3A__docs.evergreen-2Dils.org_3.2_-5Fmarc-5Fexport-5Fexporting-5Fbibliographic-5Frecords-5Finto-5Fmarc-5Ffiles.html&d=DwMGaQ&c=4rZ6NPIETe-LE5i2KBR4rw&r=rB3XDC6iCWGkjZtiGXbRHlEfGQP12yvXoVpChsQG6IY&m=PZmft0gaDkWQJ-PsQAmuzLbFyoxYjph24cGK4vqaTEXFnORZ9vEDMUnFRbuzb4np&s=28sCuznEp6eX3W0zi51ryW-NBwTZ0P8RjE4l6oEL_rE&e=" target="_blank" rel="nofollow noopener noreferrer">
marc_export script</a> and had similar problems.</div>
<div class="x_elementToProof" style="font-family:'calibri light' , 'helvetica light' , sans-serif;font-size:16pt;color:rgb( 0 , 0 , 0 )">
<br>
</div>
<div class="x_elementToProof" style="font-family:'calibri light' , 'helvetica light' , sans-serif;font-size:16pt;color:rgb( 0 , 0 , 0 )">
In brief:</div>
<div class="x_elementToProof" style="font-size:16pt;color:rgb( 0 , 0 , 0 )">
<ul><li style="font-family:'calibri light' , 'helvetica light' , sans-serif;list-style-type:disc">
Tue, 5pm - I ran the following test (this is for a file of 3,100 records). This took about 30 sec. and successfully created the export file without any noticeable effects on our apache2 server: <br>
<span class="x_ui-provider x_ec x_bls x_bcg x_blt x_blu x_blv x_blw x_blx x_bly x_blz x_bma x_bmb x_bmc x_bmd x_bme x_bmf x_bmg x_bmh x_bmi x_bmj x_bmk x_bml x_bmm x_bmn x_bmo x_bmp x_bmq x_bmr x_bms x_bmt x_bmu x_bmv x_bmw x_bmx x_bmy" dir="ltr"><code class="x_ContentPasted0">cat
/home/opensrf/marc-test.txt | marc_export --reporter -i -c /openils/conf/opensrf_core.xml -x /openils/conf/fm_IDL.xml -f XML --timeout 5 > exported_files.xml</code></span><br>
</li><li class="x_ContentPasted2" style="font-family:'calibri light' , 'helvetica light' , sans-serif;list-style-type:disc">
<div>Wed, 11:40am- I ran what I thought was essentially the same test (for the same file of 3,100 records). This also took about 30 sec. and successfully created the export file. However, 8 min. later apache crashed and had to be restarted. In the error log,
it said <span class="x_ui-provider x_ec x_bls x_bcg x_blt x_blu x_blv x_blw x_blx x_bly x_blz x_bma x_bmb x_bmc x_bmd x_bme x_bmf x_bmg x_bmh x_bmi x_bmj x_bmk x_bml x_bmm x_bmn x_bmo x_bmp x_bmq x_bmr x_bms x_bmt x_bmu x_bmv x_bmw x_bmx x_bmy x_ContentPasted1" dir="ltr">"couldn't
grab the accept mutex" immediately before crashing. Here's the code I ran:<br>
</span></div>
<div>cat /tmp/marc-output/marc1.txt | marc_export --reporter -i -c /openils/conf/opensrf_core.xml -x /openils/conf/fm_IDL.xml -f XML --timeout 5 > /tmp/marc-output/exported-marc1.xml<span class="x_ui-provider x_ec x_bls x_bcg x_blt x_blu x_blv x_blw x_blx x_bly x_blz x_bma x_bmb x_bmc x_bmd x_bme x_bmf x_bmg x_bmh x_bmi x_bmj x_bmk x_bml x_bmm x_bmn x_bmo x_bmp x_bmq x_bmr x_bms x_bmt x_bmu x_bmv x_bmw x_bmx x_bmy x_ContentPasted1" dir="ltr"><br>
</span></div>
</li><li style="font-family:'calibri light' , 'helvetica light' , sans-serif;list-style-type:disc">
<div><span class="x_ui-provider x_ec x_bls x_bcg x_blt x_blu x_blv x_blw x_blx x_bly x_blz x_bma x_bmb x_bmc x_bmd x_bme x_bmf x_bmg x_bmh x_bmi x_bmj x_bmk x_bml x_bmm x_bmn x_bmo x_bmp x_bmq x_bmr x_bms x_bmt x_bmu x_bmv x_bmw x_bmx x_bmy x_ContentPasted1" dir="ltr">Wed,
4pm- I ran essentially the same command <span class="x_ContentPasted4" style="display:inline !important;color:rgb( 0 , 0 , 0 );background-color:rgb( 255 , 255 , 255 )">
(for the same file of 3,100 records)</span>, but without using the <code>tmp</code>​ folder. This time it stalled and after waiting a few minutes we pressed
<code>ctrl</code>​ + <code>c</code>​ which I assumed stopped everything cleanly, as it returned me to the command prompt. However, at 4:50pm apache quit again, with the same "couldn't grab the accept mutex" messages beforehand. Here's the code I ran this time:<br>
</span></div>
<div><span class="x_ui-provider x_ec x_bls x_bcg x_blt x_blu x_blv x_blw x_blx x_bly x_blz x_bma x_bmb x_bmc x_bmd x_bme x_bmf x_bmg x_bmh x_bmi x_bmj x_bmk x_bml x_bmm x_bmn x_bmo x_bmp x_bmq x_bmr x_bms x_bmt x_bmu x_bmv x_bmw x_bmx x_bmy x_ContentPasted1" dir="ltr"><span class="x_ui-provider x_ec x_bls x_bcg x_blt x_blu x_blv x_blw x_blx x_bly x_blz x_bma x_bmb x_bmc x_bmd x_bme x_bmf x_bmg x_bmh x_bmi x_bmj x_bmk x_bml x_bmm x_bmn x_bmo x_bmp x_bmq x_bmr x_bms x_bmt x_bmu x_bmv x_bmw x_bmx x_bmy" dir="ltr"><code class="x_ContentPasted3">cat
/home/opensrf/marc2.txt | marc_export --reporter -i -c /openils/conf/opensrf_core.xml \ -x /openils/conf/fm_IDL.xml -f XML --timeout 5 > /home/opensrf/exported-marc2.xml</code></span></span></div>
</li></ul>
</div>
<div class="x_elementToProof">
<div style="font-family:'calibri light' , 'helvetica light' , sans-serif;font-size:16pt;color:rgb( 0 , 0 , 0 )">
Anyone know what might be happening here?</div>
<div style="font-family:'calibri light' , 'helvetica light' , sans-serif;font-size:16pt;color:rgb( 0 , 0 , 0 )">
<br>
</div>
<div id="x_Signature">
<div>
<div class="x_WordSection1">
<p style="line-height:18pt"><span style="font-size:12pt;font-family:'georgia' , serif;color:rgb( 51 , 51 , 51 )">Brian Holda<br>
Library Technology Manager<br>
Hekman Library<br>
Calvin University<br>
(616) 526-8673</span></p>
<p style="line-height:18pt"><span style="font-size:12pt;font-family:'georgia' , serif;color:rgb( 51 , 51 , 51 )"><a href="https://library.calvin.edu/" target="_blank" rel="nofollow noopener noreferrer"><img border="0" width="245" height="34" src="cid:4e579103-9d9b-445c-a644-73d36151b8e7"></a></span></p>
<p style="line-height:18pt"><span style="font-size:12pt;font-family:'georgia' , serif;color:rgb( 51 , 51 , 51 )"> </span></p>
</div>
</div>
</div>
</div>
</div>
<br>_______________________________________________<br>Evergreen-dev mailing list<br>Evergreen-dev@list.evergreen-ils.org<br>http://list.evergreen-ils.org/cgi-bin/mailman/listinfo/evergreen-dev<br></blockquote></div></div></body></html>