Running 3.5.1 installation fails on restart

[Johnnie Adams]

Hi, folks,

     After yesterday's adventures, I reverted our test installation to its earlier running status.

     Today I started back up by, before doing anything, restarting the archivesspace service. When I did that, I got this message again:

The schema info version should be 175 for ArchivesSpace version v3.5.1.

 However, your schema info version is set at 157

Please ensure your migrations have been run and completed by using the setup-database script.

     I'm puzzled. How can an installation be running happily, then on restart, fail with a bad schema number? I did try running setup-database, and it agrees the schema is bad.

Thanks,

     John A

[Blake Carver]

It's easy to get things crossed up when doing this stuff, happens all the time.

>>The schema info version should be 175 for ArchivesSpace version v3.5.1. However, your schema info version is set at 157

That's ArchivesSpace telling you the MySQL DB you have connected to is older than 3.5.1. Maybe that DB is from a backup that is an older version? That means you should run the update-database script to get those in sync.

This one from yesterday:

>>Java::ComMysqlJdbcExceptionsJdbc4::MySQLSyntaxErrorException: Table 'ark_uniq_check' already

That'll happen when the update database thing is run and failed for some reason. It got things partially upgraded, then stopped, and when you run it again it doesn't know what is going on because it sees something that it knows shouldn't be there based on the schema info it's seeing.

---

From: archivesspac...@lyrasislists.org <archivesspac...@lyrasislists.org> on behalf of Johnnie Adams <jxa...@ualr.edu>
Sent: Tuesday, August 12, 2025 1:16 PM
To: Archivesspace_Users_Group <archivesspac...@lyrasislists.org>
Subject: [ArchivesSpace Users Group] Running 3.5.1 installation fails on restart

 

--
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://groups.google.com/a/lyrasislists.org/d/msgid/Archivesspace_Users_Group/fb7f9bd1-1711-408d-86ec-9bcf66f6e332n%40lyrasislists.org.

[Johnnie Adams]

Hi, Blake,

     There's only one DB this instance can connect to, and it's the one it's running against now. (I reverted again to poke at it some more.) Where would I look in the database to check the schema number?

Thanks,

     John A

To view this discussion visit https://groups.google.com/a/lyrasislists.org/d/msgid/Archivesspace_Users_Group/DM6PR22MB23097C5F894891FE44A544519F2BA%40DM6PR22MB2309.namprd22.prod.outlook.com.

--

John Adams
Senior Linux/Middleware Administrator  | Information Technology Services
+1-501-916-3010 | jxa...@ualr.edu | http://ualr.edu/itservices
UA Little Rock

Reminder:  IT Services will never ask for your password over the phone or in an email. Always be suspicious of requests for personal information that come via email, even from known contacts.  For more information or to report suspicious email, visit IT Security.

[Valerie Addonizio]

You can run SELECT * FROM archivesspace.schema_info;

To view this discussion visit https://groups.google.com/a/lyrasislists.org/d/msgid/Archivesspace_Users_Group/CAGfWJCNxW8goJzPO2hDPVbSY8G6cy_4hBDVa4Fko0KLw6eboJw%40mail.gmail.com.

[Joshua D. Shaw]

How are you getting the db you are running against? Is it a current db dump of your production system or some older dump? Just wondering if your production db has issues which you'd want to correct or if this is limited to the copy(ies) you are working with?

If this is an older dump, then I'd do a new one from production. Alternatively, you could start things up with a blank db to ensure that all of your plugins are working properly and then try and troubleshoot your actual data/db issues.

jds

---

From: 'Valerie Addonizio' via Archivesspace_Users_Group <Archivesspac...@lyrasislists.org>
Sent: Tuesday, August 12, 2025 1:38 PM
To: Johnnie Adams <jxa...@ualr.edu>; Blake Carver <blake....@lyrasis.org>
Cc: Archivesspace_Users_Group <archivesspac...@lyrasislists.org>
Subject: RE: [ArchivesSpace Users Group] Running 3.5.1 installation fails on restart

 

To view this discussion visit https://groups.google.com/a/lyrasislists.org/d/msgid/Archivesspace_Users_Group/SA1PR20MB7247A74FA8C8DF8DADB066D9892BA%40SA1PR20MB7247.namprd20.prod.outlook.com.