[Archivesspace_Users_Group] Containers not being associated with their resources
Mark Cyzyk
mcyzyk at jhu.edu
Wed Mar 3 10:20:44 EST 2021
More:
In our development environment, I configured full error logging. I then
ran one of our queries that is failing, stopped ASpace, then began
scrutiny of archivesspace.out.
Here are my disturbing findings:
E, [2021-03-03T09:47:29.950934 #27625] ERROR -- :
Java::ComMysqlJdbcExceptionsJdbc4::MySQLSyntaxErrorException:
Table 'archivesspaceDevelopment.agent_relationship_associative'
doesn't exist: DESCRIBE `agent_relationship_associative`
E, [2021-03-03T09:47:29.960346 #27625] ERROR -- :
Java::ComMysqlJdbcExceptionsJdbc4::MySQLSyntaxErrorException:
Table 'archivesspaceDevelopment.agent_relationship_associative'
doesn't exist: SELECT * FROM `agent_relationship_associative`
LIMIT 1
E, [2021-03-03T09:47:29.968749 #27625] ERROR -- :
Java::ComMysqlJdbcExceptionsJdbc4::MySQLSyntaxErrorException:
Table 'archivesspaceDevelopment.agent_relationship_associative'
doesn't exist: SELECT * FROM `agent_relationship_associative`
LIMIT 1
E, [2021-03-03T09:47:29.984480 #27625] ERROR -- :
Java::ComMysqlJdbcExceptionsJdbc4::MySQLSyntaxErrorException:
Table 'archivesspaceDevelopment.agent_relationship_earlierlater'
doesn't exist: DESCRIBE `agent_relationship_earlierlater`
E, [2021-03-03T09:47:29.987451 #27625] ERROR -- :
Java::ComMysqlJdbcExceptionsJdbc4::MySQLSyntaxErrorException:
Table 'archivesspaceDevelopment.agent_relationship_earlierlater'
doesn't exist: SELECT * FROM `agent_relationship_earlierlater`
LIMIT 1
E, [2021-03-03T09:47:29.990034 #27625] ERROR -- :
Java::ComMysqlJdbcExceptionsJdbc4::MySQLSyntaxErrorException:
Table 'archivesspaceDevelopment.agent_relationship_earlierlater'
doesn't exist: SELECT * FROM `agent_relationship_earlierlater`
LIMIT 1
E, [2021-03-03T09:47:30.000084 #27625] ERROR -- :
Java::ComMysqlJdbcExceptionsJdbc4::MySQLSyntaxErrorException:
Table 'archivesspaceDevelopment.agent_relationship_parentchild'
doesn't exist: DESCRIBE `agent_relationship_parentchild`
E, [2021-03-03T09:47:30.007362 #27625] ERROR -- :
Java::ComMysqlJdbcExceptionsJdbc4::MySQLSyntaxErrorException:
Table 'archivesspaceDevelopment.agent_relationship_parentchild'
doesn't exist: SELECT * FROM `agent_relationship_parentchild`
LIMIT 1
E, [2021-03-03T09:47:30.011525 #27625] ERROR -- :
Java::ComMysqlJdbcExceptionsJdbc4::MySQLSyntaxErrorException:
Table 'archivesspaceDevelopment.agent_relationship_parentchild'
doesn't exist: SELECT * FROM `agent_relationship_parentchild`
LIMIT 1
E, [2021-03-03T09:47:30.021769 #27625] ERROR -- :
Java::ComMysqlJdbcExceptionsJdbc4::MySQLSyntaxErrorException:
Table
'archivesspaceDevelopment.agent_relationship_subordinatesuperior'
doesn't exist: DESCRIBE `agent_relationship_subordinatesuperior`
E, [2021-03-03T09:47:30.024655 #27625] ERROR -- :
Java::ComMysqlJdbcExceptionsJdbc4::MySQLSyntaxErrorException:
Table
'archivesspaceDevelopment.agent_relationship_subordinatesuperior'
doesn't exist: SELECT * FROM
`agent_relationship_subordinatesuperior` LIMIT 1
E, [2021-03-03T09:47:30.028291 #27625] ERROR -- :
Java::ComMysqlJdbcExceptionsJdbc4::MySQLSyntaxErrorException:
Table
'archivesspaceDevelopment.agent_relationship_subordinatesuperior'
doesn't exist: SELECT * FROM
`agent_relationship_subordinatesuperior` LIMIT 1
E, [2021-03-03T09:47:30.166299 #27625] ERROR -- :
Java::ComMysqlJdbcExceptionsJdbc4::MySQLSyntaxErrorException:
Table 'archivesspaceDevelopment.container_location' doesn't
exist: DESCRIBE `container_location`
E, [2021-03-03T09:47:30.179378 #27625] ERROR -- :
Java::ComMysqlJdbcExceptionsJdbc4::MySQLSyntaxErrorException:
Table 'archivesspaceDevelopment.container_location' doesn't
exist: SELECT * FROM `container_location` LIMIT 1
E, [2021-03-03T09:47:30.181948 #27625] ERROR -- :
Java::ComMysqlJdbcExceptionsJdbc4::MySQLSyntaxErrorException:
Table 'archivesspaceDevelopment.container_location' doesn't
exist: SELECT * FROM `container_location` LIMIT 1
E, [2021-03-03T09:47:30.575599 #27625] ERROR -- :
Java::ComMysqlJdbcExceptionsJdbc4::MySQLSyntaxErrorException:
Table 'archivesspaceDevelopment.note_bibliography' doesn't
exist: DESCRIBE `note_bibliography`
E, [2021-03-03T09:47:30.579327 #27625] ERROR -- :
Java::ComMysqlJdbcExceptionsJdbc4::MySQLSyntaxErrorException:
Table 'archivesspaceDevelopment.note_bibliography' doesn't
exist: SELECT * FROM `note_bibliography` LIMIT 1
E, [2021-03-03T09:47:30.606147 #27625] ERROR -- :
Java::ComMysqlJdbcExceptionsJdbc4::MySQLSyntaxErrorException:
Table 'archivesspaceDevelopment.note_bibliography' doesn't
exist: SELECT * FROM `note_bibliography` LIMIT 1
E, [2021-03-03T09:47:30.635130 #27625] ERROR -- :
Java::ComMysqlJdbcExceptionsJdbc4::MySQLSyntaxErrorException:
Table 'archivesspaceDevelopment.note_digital_object' doesn't
exist: DESCRIBE `note_digital_object`
E, [2021-03-03T09:47:30.638129 #27625] ERROR -- :
Java::ComMysqlJdbcExceptionsJdbc4::MySQLSyntaxErrorException:
Table 'archivesspaceDevelopment.note_digital_object' doesn't
exist: SELECT * FROM `note_digital_object` LIMIT 1
E, [2021-03-03T09:47:30.645140 #27625] ERROR -- :
Java::ComMysqlJdbcExceptionsJdbc4::MySQLSyntaxErrorException:
Table 'archivesspaceDevelopment.note_digital_object' doesn't
exist: SELECT * FROM `note_digital_object` LIMIT 1
E, [2021-03-03T09:47:30.651197 #27625] ERROR -- :
Java::ComMysqlJdbcExceptionsJdbc4::MySQLSyntaxErrorException:
Table 'archivesspaceDevelopment.note_index' doesn't exist:
DESCRIBE `note_index`E, [2021-03-03T09:47:29.960346 #27625]
ERROR -- :
Java::ComMysqlJdbcExceptionsJdbc4::MySQLSyntaxErrorException:
Table 'archivesspaceDevelopment.agent_relationship_associative'
doesn't exist: SELECT * FROM `agent_relationship_associative`
LIMIT 1
I took a look directly in the database and these tables are indeed missing.
At this point, I am stumped. I don't understand why, with these tables
missing, one of our three Repositories would be working just fine -- the
other two, not so much. How could whole tables get deleted from our
ASpace? I'm guessing this happened a couple weeks ago.
Any advice greatly appreciated,
Mark
<><><><><><><><><><><><><><><><><><><><><><><><><><><><><><><><><><>
Mark Cyzyk, M.A., M.L.S.
Library Applications Group
The Sheridan Libraries
The Johns Hopkins University
mcyzyk at jhu.edu
Verba volant, scripta manent.
On 3/1/21 5:18 PM, Mark Cyzyk wrote:
>
> Thanks, Rachel!
>
> I've now completely reindexed everything (a "hard reindex") and still
> no joy.
>
> I am noticing there is no "location.dat" file in our /indexer_pui_state/:
>
> -rw-r--r--. 1 archivesspace archivesspace 11 Mar 1 17:13
> 3_archival_object.dat
> -rw-r--r--. 1 archivesspace archivesspace 11 Mar 1 17:13
> 3_classification.dat
> -rw-r--r--. 1 archivesspace archivesspace 11 Mar 1 17:13
> 3_classification_term.dat
> -rw-r--r--. 1 archivesspace archivesspace 11 Mar 1 17:13
> 3_digital_object_component.dat
> -rw-r--r--. 1 archivesspace archivesspace 11 Mar 1 17:13
> 3_digital_object.dat
> -rw-r--r--. 1 archivesspace archivesspace 11 Mar 1 17:13 3_resource.dat
> -rw-r--r--. 1 archivesspace archivesspace 11 Mar 1 17:13
> 4_archival_object.dat
> -rw-r--r--. 1 archivesspace archivesspace 11 Mar 1 17:13
> 4_classification.dat
> -rw-r--r--. 1 archivesspace archivesspace 11 Mar 1 17:13
> 4_classification_term.dat
> -rw-r--r--. 1 archivesspace archivesspace 11 Mar 1 17:13
> 4_digital_object_component.dat
> -rw-r--r--. 1 archivesspace archivesspace 11 Mar 1 17:13
> 4_digital_object.dat
> -rw-r--r--. 1 archivesspace archivesspace 11 Mar 1 17:13 4_resource.dat
> -rw-r--r--. 1 archivesspace archivesspace 11 Mar 1 17:13
> 5_archival_object.dat
> -rw-r--r--. 1 archivesspace archivesspace 11 Mar 1 17:13
> 5_classification.dat
> -rw-r--r--. 1 archivesspace archivesspace 11 Mar 1 17:13
> 5_classification_term.dat
> -rw-r--r--. 1 archivesspace archivesspace 11 Mar 1 17:13
> 5_digital_object_component.dat
> -rw-r--r--. 1 archivesspace archivesspace 11 Mar 1 17:13
> 5_digital_object.dat
> -rw-r--r--. 1 archivesspace archivesspace 11 Mar 1 17:13 5_resource.dat
> -rw-r--r--. 1 archivesspace archivesspace 11 Mar 1 17:13
> _deletes_deletes.dat
> -rw-r--r--. 1 archivesspace archivesspace 11 Mar 1 17:13
> repositories_repositories.dat
>
> Should there be?
>
> Our two problem repositories here are 4 and 5. The Staff interface
> reports "0" Resources for both. Yet when I run the Resources List
> Report I do indeed get back a report with Resources. Puzzling.
>
> It's like something in the backend DB has become disconnected, but
> just for these two repositories. Not sure how.
>
> If anyone has any suggestions, I would greatly appreciate hearing them!
>
> Mark
>
> <><><><><><><><><><><><><><><><><><><><><><><><><><><><><><><><><><>
> Mark Cyzyk, M.A., M.L.S.
> Library Applications Group
> The Sheridan Libraries
> The Johns Hopkins University
> mcyzyk at jhu.edu
>
> Verba volant, scripta manent.
> On 2/24/21 11:11 AM, Rachel Aileen Searcy wrote:
>> Hi Mark
>>
>> We ran into a similar issue recently, where newly created containers
>> were not being properly associated with the resource record, and
>> updates to locations or barcodes were not showing up in searches or
>> the Manage Top Containers view. We looked at the timestamp files for
>> the indexer, and noticed that there was no location.dat file. We
>> performed a soft re-index
>> <https://github.com/archivesspace/tech-docs/blob/master/administration/indexes.md>,
>> after which our containers, barcodes, and locations resumed behaving
>> as expected. We also have recurring monthly system restarts (which
>> will now include a soft re-index going forward) built into our
>> schedule, which seems to help with maintaining overall performance.
>>
>> I'm not sure if this is exactly what you're experiencing, but I hope
>> it's helpful. Take care,
>> Rachel
>>
>> On Mon, Feb 22, 2021 at 5:45 PM Mark Cyzyk <mcyzyk at jhu.edu
>> <mailto:mcyzyk at jhu.edu>> wrote:
>>
>>
>> Dear ASpace list,
>>
>> From one of our Archivists:
>>
>> > When I create a new container, either manually or by spreadsheet
>> > ingest, the container appears properly in the Instance field of
>> the
>> > record. From the resource, I can open the container record and it
>> > appears to be associated with the resource correctly. However,
>> in the
>> > container management module, when I search for all containers
>> > associated with the collection, the recently created container
>> is not
>> > listed. If I search for the new container's barcode, the container
>> > appears in the search results but with no associated resource.
>> I can
>> > also locate the new containers by searching for unassociated
>> containers.
>>
>> It seems like some linkage is not happening here.
>>
>> More, this is only happening in his Repository, not our other,
>> larger
>> Repository.
>>
>> Has anyone else run into this?
>>
>> Mark
>>
>> --
>> <><><><><><><><><><><><><><><><><><><><><><><><><><><><><><><><><><>
>> Mark Cyzyk, M.A., M.L.S.
>> Library Applications Group
>> The Sheridan Libraries
>> The Johns Hopkins University
>> mcyzyk at jhu.edu <mailto:mcyzyk at jhu.edu>
>>
>> Verba volant, scripta manent.
>>
>> _______________________________________________
>> Archivesspace_Users_Group mailing list
>> Archivesspace_Users_Group at lyralists.lyrasis.org
>> <mailto:Archivesspace_Users_Group at lyralists.lyrasis.org>
>> https://urldefense.proofpoint.com/v2/url?u=http-3A__lyralists.lyrasis.org_mailman_listinfo_archivesspace-5Fusers-5Fgroup&d=DwICAg&c=slrrB7dE8n7gBJbeO0g-IQ&r=WwSkYr7X9POdZNK4180yTjrK5hSljcuCPIN--y1VRZk&m=SmteiGvtNVMomV11nXFZu2vgQ88h7aapUFt6H55qk9o&s=mbxfqYRQtAZn2xsehm9iyXz5ZA-q1Evo07_25hxNzk0&e=
>> <https://urldefense.proofpoint.com/v2/url?u=http-3A__lyralists.lyrasis.org_mailman_listinfo_archivesspace-5Fusers-5Fgroup&d=DwICAg&c=slrrB7dE8n7gBJbeO0g-IQ&r=WwSkYr7X9POdZNK4180yTjrK5hSljcuCPIN--y1VRZk&m=SmteiGvtNVMomV11nXFZu2vgQ88h7aapUFt6H55qk9o&s=mbxfqYRQtAZn2xsehm9iyXz5ZA-q1Evo07_25hxNzk0&e=>
>>
>>
>>
>>
>> --
>> Rachel Searcy
>> Accessioning Archivist, Archival Collections Management
>> New York University Libraries
>> 212.998.2539 | rachel.searcy at nyu.edu <mailto:rachel.searcy at nyu.edu>
>> My pronouns are she/her/hers
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lyralists.lyrasis.org/pipermail/archivesspace_users_group/attachments/20210303/a80a3498/attachment.html>
More information about the Archivesspace_Users_Group
mailing list