<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=Windows-1252">
<style type="text/css" style="display:none;"> P {margin-top:0;margin-bottom:0;} </style>
</head>
<body dir="ltr">
<div style="font-family: Calibri, Arial, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);">
<p dir="auto" style="margin: 0px 0px 16px; font-size: 14px; line-height: 20px; outline: 0px; background: rgb(255, 255, 255); font-family: system-ui, -apple-system, BlinkMacSystemFont, "Segoe UI", Roboto, Oxygen-Sans, Ubuntu, Cantarell, "Helvetica Neue", Arial, sans-serif; color: rgb(47, 57, 65)">
You could just get rid of the aspace_check_job jobs. <span style="font-family: system-ui, -apple-system, BlinkMacSystemFont, "Segoe UI", Roboto, Oxygen-Sans, Ubuntu, Cantarell, "Helvetica Neue", Arial, sans-serif; background-color: rgb(255, 255, 255); display: inline !important">(back
up the DB just in case)</span></p>
<p dir="auto" style="margin: 0px 0px 16px; font-size: 14px; line-height: 20px; outline: 0px; background: rgb(255, 255, 255); font-family: system-ui, -apple-system, BlinkMacSystemFont, "Segoe UI", Roboto, Oxygen-Sans, Ubuntu, Cantarell, "Helvetica Neue", Arial, sans-serif; color: rgb(47, 57, 65)">
select * job where job_blob like '%aspace_check_job%';</p>
<p dir="auto" style="margin: 0px 0px 16px; font-size: 14px; line-height: 20px; outline: 0px; background: rgb(255, 255, 255); font-family: system-ui, -apple-system, BlinkMacSystemFont, "Segoe UI", Roboto, Oxygen-Sans, Ubuntu, Cantarell, "Helvetica Neue", Arial, sans-serif; color: rgb(47, 57, 65)">
<span style="color: rgb(47, 57, 65); font-family: system-ui, -apple-system, BlinkMacSystemFont, "Segoe UI", Roboto, Oxygen-Sans, Ubuntu, Cantarell, "Helvetica Neue", Arial, sans-serif; font-size: 14px;">Then:</span><br>
</p>
<p dir="auto" style="margin: 0px 0px 16px; font-size: 14px; line-height: 20px; outline: 0px; background: rgb(255, 255, 255); font-family: system-ui, -apple-system, BlinkMacSystemFont, "Segoe UI", Roboto, Oxygen-Sans, Ubuntu, Cantarell, "Helvetica Neue", Arial, sans-serif; color: rgb(47, 57, 65)">
delete FROM job where job_blob like '%aspace_check_job%';</p>
<p dir="auto" style="margin: 0px 0px 16px; font-size: 14px; line-height: 20px; outline: 0px; background: rgb(255, 255, 255); font-family: system-ui, -apple-system, BlinkMacSystemFont, "Segoe UI", Roboto, Oxygen-Sans, Ubuntu, Cantarell, "Helvetica Neue", Arial, sans-serif; color: rgb(47, 57, 65)">
</p>
</div>
<div>
<div id="Signature">
<div>
<div id="divtagdefaultwrapper" dir="ltr" style="color:rgb(0,0,0); background-color:rgb(255,255,255)">
</div>
</div>
</div>
</div>
<div id="appendonsend"></div>
<hr style="display:inline-block;width:98%" tabindex="-1">
<div id="divRplyFwdMsg" dir="ltr"><font face="Calibri, sans-serif" style="font-size:11pt" color="#000000"><b>From:</b> 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> Tuesday, August 25, 2020 9:05 AM<br>
<b>To:</b> Archivesspace Users Group <archivesspace_users_group@lyralists.lyrasis.org><br>
<b>Subject:</b> [Archivesspace_Users_Group] Jobs indexing error</font>
<div> </div>
</div>
<style>
<!--
@font-face
{font-family:"Cambria Math"}
@font-face
{font-family:Calibri}
p.x_MsoNormal, li.x_MsoNormal, div.x_MsoNormal
{margin:0in;
font-size:12.0pt;
font-family:"Calibri",sans-serif}
span.x_EmailStyle17
{font-family:"Calibri",sans-serif;
color:windowtext}
.x_MsoChpDefault
{font-size:12.0pt;
font-family:"Calibri",sans-serif}
@page WordSection1
{margin:1.0in 1.0in 1.0in 1.0in}
div.x_WordSection1
{}
-->
</style>
<div lang="EN-US" link="#0563C1" vlink="#954F72">
<div class="x_WordSection1">
<p class="x_MsoNormal"><span style="font-size:11.0pt">Hi all,</span></p>
<p class="x_MsoNormal"><span style="font-size:11.0pt"> </span></p>
<p class="x_MsoNormal"><span style="font-size:11.0pt">Posting here in the off chance someone has run into this before. We’re testing out AS version 2.8, coming from 2.6.0 and running into a weird issue.</span></p>
<p class="x_MsoNormal"><span style="font-size:11.0pt"> </span></p>
<p class="x_MsoNormal"><span style="font-size:11.0pt">Indexing works fine until we get to the job records section of indexing, and then we run into an unhandled exception ultimately stops indexing from finishing, and it just starts up again at resource records
after finishing the jobs.</span></p>
<p class="x_MsoNormal"><span style="font-size:11.0pt"> </span></p>
<p class="x_MsoNormal"><span style="font-size:11.0pt">I’ve attached the relevant section of our log.</span></p>
<p class="x_MsoNormal"><span style="font-size:11.0pt"> </span></p>
<p class="x_MsoNormal"><span style="font-size:11.0pt">Any ideas on how to fix this? I could just delete all of our job records from the table, but that seems like a bad solution to this issue.</span></p>
<p class="x_MsoNormal"><span style="font-size:11.0pt"> </span></p>
<p class="x_MsoNormal"><span style="font-size:11.0pt">Thanks,</span></p>
<p class="x_MsoNormal"><span style="font-size:11.0pt">Patrick Galligan</span></p>
<p class="x_MsoNormal"><span style="font-size:11.0pt">He/Him</span></p>
<p class="x_MsoNormal"><span style="font-size:11.0pt">Digital Archivist</span></p>
<p class="x_MsoNormal"><span style="font-size:11.0pt">Rockefeller Archive Center</span></p>
</div>
</div>
</body>
</html>