survey is unhealthy

survey is struggling, nagios is warning about swap usage and systemd units failing.

added Next Survey labels

assigned to @lavamind

added Doing label and removed Next label

It seems we're affected by this regression, tracked upstream at https://bugs.limesurvey.org/view.php?id=19262

We're getting a lot of PostgreSQL resource usage (quite a few processes) with only this query: SELECT * FROM "lime_template_configuration" "t" WHERE template_name='fruity_twentythree' AND sid IS NULL AND gsid IS NULL ORDER BY "t"."template_name" LIMIT 1

When I try this query myself, I don't get any row.

After searching for what was causing the resource usage I've found this when I've opened a survey:

CException Invalid fruity_twentythree template directory

/opt/limesurvey/application/models/Template.php(426)

Looking for a workaround.

Restored database from backups, applied the fix at https://github.com/LimeSurvey/LimeSurvey/pull/3642/files and ran the database upgrade again.

This seems to have done the trick.

changed the severity to High - S2

I looked around our LimeSurvey instance and everything seems good now, closing.

closed

changed the incident status to Resolved by closing the incident

root@bungei:/srv/backups/pg/survey-01# dsa-check-backuppg  
[survey-01, main] CANNOT-PARSE-WAL: survey-01/main.WAL.00000002.history
[survey-01, main] WAL-IS-OLD: latest wal file is too old
[survey-01, main] NOT-EXPIRING-DUE-TO-WARNINGS: have seen warnings, will not expire anything

it doesn't look like postgresql backups have resumed, are you sure everything is alright?

reopened

closed

changed the incident status to Resolved by closing the incident

mentioned in commit wiki-replica@46324531

mentioned in issue #41500 (closed)