Bug #86287

Recurring 502 on notes.typo3.org

Added by Andri Steiner 6 months ago. Updated 5 months ago.

Status:
In Progress
Priority:
Must have
Assignee:
Target version:
-
Start date:
2018-09-17
Due date:
% Done:

50%


Description

We encounter Etherpad Lite crashes from time to time. Similar issues:

  1. Actions
  1. Tasks
  • validate conversions on local instance
  • convert productive database

Related issues

Duplicated by Server Team - Bug #86007: notes.typo3.org crashes Closed 2018-08-28

History

#1 Updated by Andri Steiner 6 months ago

```
USE etherpad;
ALTER DATABASE etherpad CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin;
ALTER TABLE store ENGINE = MyISAM;
ALTER TABLE store convert to character set utf8mb4 collate utf8mb4_bin;
ALTER TABLE store change `key` `key` varchar(100) character set utf8mb4 collate utf8mb4_bin;
ALTER TABLE store change `value` `value` longtext character set utf8mb4 collate utf8mb4_bin;
```

settings.json
```
"dbSettings" : {
"charset" : "utf8mb4",
}

```

#2 Updated by Andri Steiner 6 months ago

Sep 17 19:26:10 srv188 run.sh[26322]: #033[33m[2018-09-17 19:26:10.205] [WARN] console - #033[39mEtherpad is running in Development mode.  This mode is slower for users and less secure than production mode.  You should set the NODE_ENV environment variable to production by using: export NODE_ENV=production

#3 Updated by Stephan Großberndt 6 months ago

  • Duplicated by Bug #86007: notes.typo3.org crashes added

#4 Updated by Stephan Großberndt 6 months ago

  • Project changed from Server Team to notes.typo3.org

#5 Updated by Michael Stucki 5 months ago

  • % Done changed from 0 to 50

Until this is fixed, we are now running a script which checks the service every minute and restarts it, if needed:

commit 40a238628d9e89ee9949d8e88ea44272e0fec97d
Author: mstucki <mstucki@srv188.typo3.org>
Date:   Tue Oct 23 12:06:35 2018 +0200

    Add script to automatically restart etherpad-lite after a crash

diff --git a/cron.d/custom-restart-etherpad-lite b/cron.d/custom-restart-etherpad-lite
new file mode 100644
index 0000000..a35585d
--- /dev/null
+++ b/cron.d/custom-restart-etherpad-lite
@@ -0,0 +1,3 @@
+# Check if etherpad-lite is still running normal and restart the service if not.
+
+* * * * *    root    curl -I --silent http://localhost:9001/ | head -n 1 | grep -q "HTTP/1.1 200 OK" || ( echo "Restarting etherpad-lite on srv188.typo3.org..."; echo; systemctl status etherpad-lite.service; systemctl restart etherpad-lite.service )
</p>

Also available in: Atom PDF