SQL Errors

21 views

Skip to first unread message

David Horan

unread,

Sep 2, 2025, 8:35:33 AM (6 days ago) Sep 2

to archivesspac...@lyrasislists.org

Hi,

I have these errors in the logs, checked the group didn't see anything.

E, [2025-09-02T08:26:55.797555 #3288646] ERROR -- : Thread-5932: Error in background job thread 1 (5932): Sequel::DatabaseError Java::JavaSql::SQLException: Not a navigable ResultSet. ["com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(com/mysql/cj/jdbc/exceptions/SQLError.java:130)", "com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(com/mysql/cj/jdbc/exceptions/SQLError.java:98)", "com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(com/mysql/cj/jdbc/exceptions/SQLError.java:90)",

***** CUT THE REST FOR THIS POST *********

Then these are further down in the log

E, [2025-09-02T08:27:29.770263 #3288646] ERROR -- : Thread-6824: #<RuntimeError: {"error":{"db_error":["Database integrity constraint conflict: Java::JavaSql::SQLException: Not a navigable ResultSet."]}}

E, [2025-09-02T08:27:40.371561 #3288646] ERROR -- :

E, [2025-09-02T08:27:40.373794 #3288646] ERROR -- : [c7af4ff1-8697-4eda-ac7f-e0067ef285b1] 400: {"error":{"db_error":["Database integrity constraint conflict: Java::JavaSql::SQLException: Not a navigable ResultSet."]}}

E, [2025-09-02T08:27:43.413818 #3288646] ERROR -- : [b5bc5641-bc23-4e91-9a3c-35f8bfc75e48] 500: <html>

<body><h2>HTTP ERROR 500 Server Error</h2>

The DB server is a separate server and it seems fine.

Thanks

David Horan

Sys Admin

UNCP

David Horan

unread,

Sep 2, 2025, 8:50:02 AM (6 days ago) Sep 2

to archivesspac...@lyrasislists.org

Sorry should have added...

Both servers are: RHEL-9

AS version: 4.1.0

MySQL version: 8.0.41

From: archivesspac...@lyrasislists.org <archivesspac...@lyrasislists.org> on behalf of David Horan <David...@uncp.edu>
Sent: Tuesday, September 2, 2025 8:35 AM
To: archivesspac...@lyrasislists.org <archivesspac...@lyrasislists.org>
Subject: [EXTERNAL][ArchivesSpace Users Group] SQL Errors

CAUTION: External Sender - This email originated from outside of UNCP. Do NOT click on links or open files from senders you do not trust.

--
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/BL0PR01MB509296703899FEFEE2F9AE8F8206A%40BL0PR01MB5092.prod.exchangelabs.com.

Reply all

Reply to author

Forward

0 new messages