[Archivesspace_Users_Group] Connection/login dropping

[RENTON Scott]

Hi all

Our uptime has been a bit flaky the last few weeks- what we're finding is that, after a certain amount of service, users are unable to login, and if that's not noticed or acted on, the site generally stops responding some time later. A restart of the application resolves it.

We're running 2.8.1 against MariaDB 5.5-65, and Java 8. I have tried different versions of the mysqlconnector, but this does not seem to make a difference (first noticed on 5.1.39). The MySQL has been tuned to an extent. The VM has 16GB of memory, approximately 10GB of which is apportioned to AS. The MySQL process was restarted last week, and clearing that has still allowed the issue.

It's pretty hard to spot any particular action which causes this. The logging we see once it's happened looks like this:

E, [2021-08-18T06:21:01.548843 #90658] ERROR -- : Thread-28310: Unhandled exception!
E, [2021-08-18T06:21:01.552325 #90658] ERROR -- :

apps.archivesspace.gems.gems.sequel_minus_5_dot_9_dot_0.lib.sequel.model.base.RUBY$method$parent_id$0(/apps/archivesspace/gems/gems/sequel-5.9.0/lib/sequel/model/base.rb:783)
apps.archivesspace.gems.gems.sequel_minus_5_dot_9_dot_0.lib.sequel.model.base.RUBY$method$parent_id$0$__VARARGS__(/apps/archivesspace/gems/gems/sequel-5.9.0/lib/sequel/model/base.rb)
org.jruby.internal.runtime.methods.CompiledIRMethod.call(CompiledIRMethod.java:82)
org.jruby.internal.runtime.methods.MixedModeIRMethod.call(MixedModeIRMethod.java:70)

and will continue to spout "minus_​5_dot_9_dot_0" type errors until we reboot.

I have taken some statistics around the numbers of threads running pre and post bounce. I don't see anything obvious there, and I have left the config.rb value

AppConfig[:db_max_connections] = proc { 20 + (AppConfig[:indexer_thread_count] * 2) }


as it is.

I'm also aware that we have an issue some others have of a proliferation of FATAL errors since merging top/subcontainers (items cannot be found), but I do not know if it is related to this.

However, if anyone recognises this behaviour, and can advise, I'd be grateful to hear about it.

Cheers
Scott




==========

Scott Renton

Digital Library Development & Systems

Floor F East

Argyle House

515219

The University of Edinburgh is a charitable body, registered in Scotland, with registration number SC005336. Is e buidheann carthannais a th’ ann an Oilthigh Dhùn Èideann, clàraichte an Alba, àireamh clàraidh SC005336.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lyralists.lyrasis.org/pipermail/archivesspace_users_group/attachments/20210906/9c80b6bc/attachment.html>