Upgrade from ArchivesSpace v3.3.1 to v3.5.1 displays Accession Date as one day less

109 views
Skip to first unread message

Keith Rye

unread,
May 21, 2025, 3:13:25 PM5/21/25
to Archivesspac...@lyrasislists.org
I recently migrated an ArchivesSpace v3.3.1 instance from CentOS to Ubuntu 22.04 and then upgraded it to v3.5.1. As best I could tell the migration and upgrade were successful but there is one oddity that I see that I can't figure out.

The Accession Date for an item created today looks correct in the MariaDB table but displays as the previous day in the web interface. The "Created by" date/times show correctly.

Accession Date 2025-05-18
Created by ltgadmintest 2025-05-19 15:28:24 -0500 | Last Modified by ltgadmintest 2025-05-19 15:28:24 -0500 | URI: /repositories/2/accessions/10045

MariaDB [archivesspace]> select id, identifier, title, accession_date, create_time, system_mtime FRO
M accession where title LIKE 'Rye Test item%';
+-------+----------------------------+------------------+----------------+---------------------+---------------------+
| id | identifier | title | accession_date | create_time | system_mtime |
+-------+----------------------------+------------------+----------------+---------------------+---------------------+
| 10045 | ["UA2025","100",null,null] | Rye Test Item #1 | 2025-05-19 | 2025-05-19 20:28:24 | 2025-05-19 20:28:24 |
+-------+----------------------------+------------------+----------------+---------------------+---------------------+
1 row in set (0.096 sec)

The ArchivesSpace v3.3.1 instance had a db_url with serverTimezone=America/Chicago.
The ArchivesSpace v3.5.1 instance has a db_url with serverTimezone=UTC which is part of the fix to solve the Daylight Saving Time issue.

If I set serverTimezone back to 'America/Chicago' ArchivesSpace complains with "The serverTimezone parameter must be set to UTC in AppConfig[:db_url]". I can remove the serverTimezone from the db_url but the issue still presents itself.

I see that the SOLR java instance specifies -Duser.timezone=UTC.
The ArchivesSpace java instance does not specify a timezone.
A test java program that calls TimeZone.getDefault() shows America/Chicago when run on the host.

I'm running openjdk version "1.8.0_442".

I reviewed the mailing list and didn't see anything related posted.

Have others seen this and is there something I can configure to change this behavior?

Thanks,
Keith

Keith Rye

unread,
May 23, 2025, 1:04:57 PM5/23/25
to Archivesspac...@lyrasislists.org, Keith Rye
I resolved this issue by adding "-Duser.timezone=UTC" to the startup_cmd in /opt/archivesspace/current/archivesspace.sh. Individual records displayed the correct "Accession Date" immediately but I needed to do a complete re-index to get the "Accession Date" list on the Accessions page to match up.

Keith

________________________________________
From: 'Keith Rye' via Archivesspace_Users_Group <Archivesspac...@lyrasislists.org>
Sent: Wednesday, May 21, 2025 2:13 PM
To: Archivesspac...@lyrasislists.org
Subject: [ArchivesSpace Users Group] Upgrade from ArchivesSpace v3.3.1 to v3.5.1 displays Accession Date as one day less

Thanks,
Keith

--
You received this message because you are subscribed to the Google Groups "Archivesspace_Users_Group" group.
To unsubscribe from this group and stop receiving emails from it, send an email to Archivesspace_User...@lyrasislists.org.
To view this discussion visit https://urldefense.com/v3/__https://groups.google.com/a/lyrasislists.org/d/msgid/Archivesspace_Users_Group/SA1PR06MB8197CCE84A7AF0FFCB87EE8C959EA*40SA1PR06MB8197.namprd06.prod.outlook.com__;JQ!!Mak6IKo!K079iXM7CTh-ZEYPv0cX9Kd1C4ykJjE0CsEMDakphUUz9zLqGhnRQ38QRqOsAecPYe8C3-SINBkTf4aUup5m_1sQC6zbvK8$ .

Thimios Dimopulos

unread,
May 26, 2025, 5:51:42 AM5/26/25
to Archivesspac...@lyrasislists.org, Keith Rye
FYI: I have created a Jira ticket to work on streamlining the timezone configuration / documentation: https://archivesspace.atlassian.net/browse/ANW-2404
From: 'Keith Rye' via Archivesspace_Users_Group <Archivesspac...@lyrasislists.org>
Sent: Friday, May 23, 2025 8:04 PM
To: Archivesspac...@lyrasislists.org <Archivesspac...@lyrasislists.org>; Keith Rye <keit...@wisc.edu>
Subject: [ArchivesSpace Users Group] Re: Upgrade from ArchivesSpace v3.3.1 to v3.5.1 displays Accession Date as one day less
 


--
You received this message because you are subscribed to the Google Groups "Archivesspace_Users_Group" group.
To unsubscribe from this group and stop receiving emails from it, send an email to Archivesspace_User...@lyrasislists.org.
Reply all
Reply to author
Forward
0 new messages