#Textapp - slow loading

hi, the text app is very, very slow to load at each document opening
or it doesn’t load the document at all !

Do you experience the same situation ?
What could be the problem ?
thanks

//////////////////////

bonjour, l’application TEXT qui sert à ouvrir les fichiers .md dans les dossiers partagés ou les Collectifs, est très, très longue à se charger, et ce à chaque ouverture d’un fichier .md, voire elle ne se charge pas du tout et laisse une page blanche avec le titre, les 3 petits points et la croix pour fermer l’écran de l’app.

avez-vous déjà rencontré la même situation ?
sauriez-vous m’indiquer l’origine du problème ?
(j’ai désactivé de nombreuses app, désactivé/réactivé TEXT, testé plusieurs navigateurs : safari, epic, avec brave le fichier .md ne s’ouvre pas mais se télécharge automatiquement)

==============
htop in shell :
memory 2/8Gig
tasks : 61 ; 111 thr ; 1 running
load average : 0,00 0,00 0,03
uptime 24 days

===============
nextcloud 23.0.5 (error while trying to update to 24.0.1: Create backup Parsing response failed)
VPS 4 cores 8 Gig
ubuntu 20.04.4
php 7.4 php-fpm
nginx 1.21.6
apache2 2.4.53
hestia panel 1.5.15

Can you check the server logfile?

It can as well be helpful to open the web developer toolbox of your browser and check how long it takes to load resources. This way, you can see which resource takes so long to load. Make sure that you don’t have any plugins that block loading of code from Nextcloud (that might be used for the texteditor).

Apart from the Texteditor, the nextcloud interface is fast? It shows pictures etc.?

No external storage?

thanks @tflidd
my log level is at 1
in NC / settings / logging :

  • |Info|no app in context|Deprecated event type for \OCP\Collaboration\Resources::loadAdditionalScripts: null||2022-06-08T19:26:29+0200|
  • |Info|files_lock|[notice] extending existing lock – {“fileLock”:{“id”:37,“uri”:"",“userId”:“text”,“displayName”:"",“fileId”:4384,“token”:“files_lock/f38d1f72-dfd1-4dff-926f-ade3fdf644a1”,“eta”:0,“creation”:1654709090,“type”:1}}||2022-06-08T19:25:06+0200|
  • |Info|no app in context|Symfony\Component\Routing\Exception\RouteNotFoundException: Unable to generate a URL for the named route “tasks.page.index” as such route does not exist.||2022-06-08T19:25:06+0200|
  • |Info|no app in context|Symfony\Component\Routing\Exception\RouteNotFoundException: Unable to generate a URL for the named route “photos.page.index” as such route does not exist.||2022-06-08T19:25:06+0200|
  • |Info|no app in context|Symfony\Component\Routing\Exception\RouteNotFoundException: Unable to generate a URL for the named route “dashboard.dashboard.index” as such route does not exist.||2022-06-08T19:25:06+0200|
  • |Info|no app in context|Symfony\Component\Routing\Exception\RouteNotFoundException: Unable to generate a URL for the named route “calendar.view.index” as such route does not exist.||2022-06-08T19:25:06+0200|
  • |Error|text|OCP\Files\NotFoundException:||2022-06-08T19:25:05+0200|
  • |Info|text|OCP\Files\NotFoundException:||2022-06-08T19:25:03+0200|
  • |Info|text|OCP\Files\NotFoundException:||2022-06-08T19:25:00+0200|
  • |Info|files_lock|[notice] locking file – {“fileLock”:{“id”:0,“uri”:"",“userId”:“text”,“displayName”:null,“fileId”:4384,“token”:“files_lock/f38d1f72-dfd1-4dff-926f-ade3fdf644a1”,“eta”:-1,“creation”:1654709090,“type”:1}}||2022-06-08T19:24:50+0200|
  • |Info|files_lock|[notice] locking file – {“fileLock”:{“id”:0,“uri”:"",“userId”:“text”,“displayName”:null,“fileId”:2887,“token”:“files_lock/7fb512b3-1a68-4f53-90c3-8082b3cf35ab”,“eta”:-1,“creation”:1654709065,“type”:1}}||2022-06-08T19:24:25+0200|
  • |Info|files_lock|[notice] extending existing lock – {“fileLock”:{“id”:35,“uri”:"",“userId”:“text”,“displayName”:"",“fileId”:4384,“token”:“files_lock/001916b4-0b38-424e-9a42-0136980c92bc”,“eta”:0,“creation”:1654708922,“type”:1}}||2022-06-08T19:22:52+0200|
  • |Info|files_lock|[notice] extending existing lock – {“fileLock”:{“id”:34,“uri”:"",“userId”:“text”,“displayName”:"",“fileId”:2887,“token”:“files_lock/bcfe851f-b931-46ae-b3b3-e8bb3abbeb1b”,“eta”:0,“creation”:1654708874,“type”:1}}||2022-06-08T19:22:42+0200|
  • |Info|files_lock|[notice] locking file – {“fileLock”:{“id”:0,“uri”:"",“userId”:“text”,“displayName”:null,“fileId”:4384,“token”:“files_lock/001916b4-0b38-424e-9a42-0136980c92bc”,“eta”:-1,“creation”:1654708922,“type”:1}}||2022-06-08T19:22:02+0200|
  • |Info|files_lock|[notice] locking file – {“fileLock”:{“id”:0,“uri”:"",“userId”:“text”,“displayName”:null,“fileId”:2887,“token”:“files_lock/bcfe851f-b931-46ae-b3b3-e8bb3abbeb1b”,“eta”:-1,“creation”:1654708874,“type”:1}}||2022-06-08T19:21:14+0200|
  • |Info|text|OCP\Files\NotFoundException:||2022-06-08T19:21:14+0200|
  • |Info|text|OCP\Files\NotFoundException:||2022-06-08T19:21:13+0200|
  • |Info|no app in context|Symfony\Component\Routing\Exception\RouteNotFoundException: Unable to generate a URL for the named route “tasks.page.index” as such route does not exist.||2022-06-08T19:21:04+0200|
  • |Info|no app in context|Symfony\Component\Routing\Exception\RouteNotFoundException: Unable to generate a URL for the named route “photos.page.index” as such route does not exist.||2022-06-08T19:21:04+0200|
  • |Info|no app in context|Symfony\Component\Routing\Exception\RouteNotFoundException: Unable to generate a URL for the named route “dashboard.dashboard.index” as such route does not exist.||2022-06-08T19:21:04+0200|
  • |Info|no app in context|Symfony\Component\Routing\Exception\RouteNotFoundException: Unable to generate a URL for the named route “calendar.view.index” as such route does not exist.||2022-06-08T19:21:04+0200|
  • |Info|files_lock|[notice] extending existing lock – {“fileLock”:{“id”:31,“uri”:"",“userId”:“text”,“displayName”:"",“fileId”:4463,“token”:“files_lock/884d6159-b3e3-4dd2-a321-8deecee61871”,“eta”:0,“creation”:1654708020,“type”:1}}||2022-06-08T19:21:03+0200|
  • |Info|files_lock|[notice] extending existing lock – {“fileLock”:{“id”:30,“uri”:"",“userId”:“text”,“displayName”:"",“fileId”:2887,“token”:“files_lock/058f6652-66d7-444e-ad7c-64282b1adfa8”,“eta”:0,“creation”:1654708019,“type”:1}}||2022-06-08T19:20:57+0200|
  • |Info|text|OCP\Files\NotFoundException:||2022-06-08T19:20:57+0200|
  • |Info|files_lock|[notice] extending existing lock – {“fileLock”:{“id”:33,“uri”:"",“userId”:“text”,“displayName”:"",“fileId”:2909,“token”:“files_lock/b50b57ca-a5d3-4c18-9b1c-bd9c6584f327”,“eta”:0,“creation”:1654708048,“type”:1}}||2022-06-08T19:07:34+0200|
  • |Info|files_lock|[notice] locking file – {“fileLock”:{“id”:0,“uri”:"",“userId”:“text”,“displayName”:null,“fileId”:2909,“token”:“files_lock/b50b57ca-a5d3-4c18-9b1c-bd9c6584f327”,“eta”:-1,“creation”:1654708048,“type”:1}}||2022-06-08T19:07:28+0200|
  • |Info|no app in context|OCP\Lock\LockedException: “files/d7c58e5b488f69d9f9e7f908034c1172” is locked||2022-06-08T19:07:28+0200|
  • |Info|files_lock|[notice] locking file – {“fileLock”:{“id”:0,“uri”:"",“userId”:“text”,“displayName”:null,“fileId”:2897,“token”:“files_lock/1b02d5df-5b2c-4853-9967-f5f9c7e6af3e”,“eta”:-1,“creation”:1654708023,“type”:1}}||2022-06-08T19:07:03+0200|
  • |Info|files_lock|[notice] locking file – {“fileLock”:{“id”:0,“uri”:"",“userId”:“text”,“displayName”:null,“fileId”:4463,“token”:“files_lock/884d6159-b3e3-4dd2-a321-8deecee61871”,“eta”:-1,“creation”:1654708020,“type”:1}}||2022-06-08T19:07:00+0200|
  • |Info|files_lock|[notice] locking file – {“fileLock”:{“id”:0,“uri”:"",“userId”:“text”,“displayName”:null,“fileId”:2887,“token”:“files_lock/058f6652-66d7-444e-ad7c-64282b1adfa8”,“eta”:-1,“creation”:1654708019,“type”:1}}||2022-06-08T19:06:59+0200|
  • |Info|files_lock|[notice] extending existing lock – {“fileLock”:{“id”:28,“uri”:"",“userId”:“text”,“displayName”:"",“fileId”:2909,“token”:“files_lock/06df83c6-e590-452a-bd7d-8b246ba76ede”,“eta”:0,“creation”:1654707518,“type”:1}}||2022-06-08T19:06:47+0200|
  • |Info|files_lock|[notice] extending existing lock – {“fileLock”:{“id”:27,“uri”:"",“userId”:“text”,“displayName”:"",“fileId”:4430,“token”:“files_lock/b110e8f8-3bb5-46b5-af02-280750bd438a”,“eta”:0,“creation”:1654707505,“type”:1}}||2022-06-08T19:05:20+0200|
  • |Info|files_lock|[notice] extending existing lock – {“fileLock”:{“id”:29,“uri”:"",“userId”:“text”,“displayName”:"",“fileId”:4432,“token”:“files_lock/bda85f0a-b919-4a1b-bae1-c9d8521c8386”,“eta”:0,“creation”:1654707698,“type”:1}}||2022-06-08T19:04:36+0200|
  • |Info|files_lock|[notice] locking file – {“fileLock”:{“id”:0,“uri”:"",“userId”:“text”,“displayName”:null,“fileId”:4432,“token”:“files_lock/bda85f0a-b919-4a1b-bae1-c9d8521c8386”,“eta”:-1,“creation”:1654707698,“type”:1}}||2022-06-08T19:01:38+0200|
  • |Info|files_lock|[notice] locking file – {“fileLock”:{“id”:0,“uri”:"",“userId”:“text”,“displayName”:null,“fileId”:2909,“token”:“files_lock/06df83c6-e590-452a-bd7d-8b246ba76ede”,“eta”:-1,“creation”:1654707518,“type”:1}}||2022-06-08T18:58:38+0200|
  • |Info|files_lock|[notice] locking file – {“fileLock”:{“id”:0,“uri”:"",“userId”:“text”,“displayName”:null,“fileId”:4430,“token”:“files_lock/b110e8f8-3bb5-46b5-af02-280750bd438a”,“eta”:-1,“creation”:1654707505,“type”:1}}||2022-06-08T18:58:25+0200|
  • |Info|no app in context|OCP\Lock\LockedException: “files/d7c58e5b488f69d9f9e7f908034c1172” is locked||2022-06-08T18:58:16+0200|
  • |Info|files_lock|[notice] extending existing lock – {“fileLock”:{“id”:23,“uri”:"",“userId”:“text”,“displayName”:"",“fileId”:4432,“token”:“files_lock/a2f4f033-59e8-49cd-97ea-4ddc14af86ed”,“eta”:0,“creation”:1654707290,“type”:1}}||2022-06-08T18:58:16+0200|
  • |Info|no app in context|Symfony\Component\Routing\Exception\RouteNotFoundException: Unable to generate a URL for the named route “tasks.page.index” as such route does not exist.||2022-06-08T18:58:10+0200|
  • |Info|no app in context|Symfony\Component\Routing\Exception\RouteNotFoundException: Unable to generate a URL for the named route “photos.page.index” as such route does not exist.||2022-06-08T18:58:10+0200|
  • |Info|no app in context|Symfony\Component\Routing\Exception\RouteNotFoundException: Unable to generate a URL for the named route “dashboard.dashboard.index” as such route does not exist.||2022-06-08T18:58:10+0200|
  • |Info|no app in context|Symfony\Component\Routing\Exception\RouteNotFoundException: Unable to generate a URL for the named route “calendar.view.index” as such route does not exist.||2022-06-08T18:58:10+0200|
  • |Info|files_lock|[notice] extending existing lock – {“fileLock”:{“id”:25,“uri”:"",“userId”:“text”,“displayName”:"",“fileId”:4427,“token”:“files_lock/2e056511-9cc1-4cce-ad23-c63c1b195f47”,“eta”:0,“creation”:1654707398,“type”:1}}||2022-06-08T18:58:10+0200|
  • |Info|files_lock|[notice] locking file – {“fileLock”:{“id”:0,“uri”:"",“userId”:“text”,“displayName”:null,“fileId”:2908,“token”:“files_lock/c7ed48f2-55d5-422b-8dd2-3f4352b49e13”,“eta”:-1,“creation”:1654707423,“type”:1}}||2022-06-08T18:57:03+0200|
  • |Info|files_lock|[notice] locking file – {“fileLock”:{“id”:0,“uri”:"",“userId”:“text”,“displayName”:null,“fileId”:4427,“token”:“files_lock/2e056511-9cc1-4cce-ad23-c63c1b195f47”,“eta”:-1,“creation”:1654707398,“type”:1}}||2022-06-08T18:56:38+0200|
  • |Info|files_lock|[notice] unlocking file – {“fileLock”:{}}||2022-06-08T18:56:32+0200|
  • |Info|files_lock|[notice] unlocking file – {“fileLock”:{}}||2022-06-08T18:56:32+0200|
  • |Info|files_lock|[notice] locking file – {“fileLock”:{“id”:0,“uri”:"",“userId”:“text”,“displayName”:null,“fileId”:2909,“token”:“files_lock/c07fe353-c9ed-4602-9e2f-ad7e8ac77b7b”,“eta”:-1,“creation”:1654707325,“type”:1}}||2022-06-08T18:55:25+0200|
  • |Info|files_lock|[notice] locking file – {“fileLock”:{“id”:0,“uri”:"",“userId”:“text”,“displayName”:null,“fileId”:4432,“token”:“files_lock/a2f4f033-59e8-49cd-97ea-4ddc14af86ed”,“eta”:-1,“creation”:1654707290,“type”:1}}||2022-06-08T18:54:50+0200|
  • |Error|text|OC\DB\Exceptions\DbalException: An exception occurred while executing a query: SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry ‘4430’ for key ‘PRIMARY’|

The storage is local and NC doesn’t seem slow, but we experience regular Error 504
Ray ID: 71838f2a28a10476 • 2022-06-08 18:06:04 UTC

Gateway time-out

In this case we need to reload the page once and it works fine … almost …

Or a pop up saying : Lost connection to signaling server. Try to reload the page manually.

sorry for the long list of logs …

I can see a lot of erros and warnings through 3 different web browsers :

index.js:46 No OC found
getLanguage @ index.js:46
index.es.js:2337 Proxying an event bus of version 2.1.1 with 1.3.0
t @ index.es.js:2337
jquery-migrate.min.js:2 JQMIGRATE: Migrate is installed, version 3.4.0
globals.js:62 Handlebars is deprecated: please ship your own, this will be removed in Nextcloud 20
Tt @ globals.js:62
index.es.js:2337 Proxying an event bus of version 2.1.1 with 1.3.0
t @ index.es.js:2337
3globals.js:62 $ is deprecated: The global jQuery is deprecated. It will be removed in a later versions without another warning. Please ship your own.
Tt @ globals.js:62
2globals.js:62 jQuery is deprecated: The global jQuery is deprecated. It will be removed in a later versions without another warning. Please ship your own.
Tt @ globals.js:62
globals.js:62 Handlebars is deprecated: please ship your own, this will be removed in Nextcloud 20
Tt @ globals.js:62
index.es.js:2337 Proxying an event bus of version 2.1.1 with 1.3.0
t @ index.es.js:2337
globals.js:62 jQuery is deprecated: The global jQuery is deprecated. It will be removed in a later versions without another warning. Please ship your own.
Tt @ globals.js:62
globals.js:62 $ is deprecated: The global jQuery is deprecated. It will be removed in a later versions without another warning. Please ship your own.
Tt @ globals.js:62
2index.es.js:2337 Proxying an event bus of version 2.1.1 with 1.3.0
t @ index.es.js:2337
major.js:2 Proxying an event bus of version 2.1.1 with 1.3.0
t @ major.js:2
index.es.js:2337 Proxying an event bus of version 2.1.1 with 1.3.0
t @ index.es.js:2337
index.es.js:2337 Proxying an event bus of version 2.1.1 with 1.3.0
e @ index.es.js:2337
globals.js:62 jQuery is deprecated: The global jQuery is deprecated. It will be removed in a later versions without another warning. Please ship your own.
Tt @ globals.js:62
globals.js:62 $ is deprecated: The global jQuery is deprecated. It will be removed in a later versions without another warning. Please ship your own.
Tt @ globals.js:62
globals.js:62 Handlebars is deprecated: please ship your own, this will be removed in Nextcloud 20
Tt @ globals.js:62
index.es.js:2337 Proxying an event bus of version 2.1.1 with 1.3.0
t @ index.es.js:2337
globals.js:62 jQuery is deprecated: The global jQuery is deprecated. It will be removed in a later versions without another warning. Please ship your own.

Tt @ globals.js:62
get @ globals.js:93
addAndFetchFileInfo @ merged-index.js?v=66b8b270-27:7164
(anonymous) @ TemplatePicker.vue:218
u @ runtime.js:63
(anonymous) @ runtime.js:294
(anonymous) @ runtime.js:119
H @ TemplatePreview.vue?81db:20
o @ TemplatePreview.vue?81db:20
Promise.then (async)
H @ TemplatePreview.vue?81db:20
o @ TemplatePreview.vue?81db:20
(anonymous) @ TemplatePreview.vue?81db:20
(anonymous) @ TemplatePreview.vue?81db:20
onSubmit @ TemplatePicker.vue:199
(anonymous) @ TemplatePicker.vue:171
u @ runtime.js:63
(anonymous) @ runtime.js:294
(anonymous) @ runtime.js:119
H @ TemplatePreview.vue?81db:20
o @ TemplatePreview.vue?81db:20
Promise.then (async)
H @ TemplatePreview.vue?81db:20
o @ TemplatePreview.vue?81db:20
(anonymous) @ TemplatePreview.vue?81db:20
(anonymous) @ TemplatePreview.vue?81db:20
open @ TemplatePicker.vue:156
actionHandler @ templates.js:113
(anonymous) @ merged-index.js?v=66b8b270-27:11541
dispatch @ jquery.js:5430
f.handle @ jquery.js:5234
trigger @ jquery.js:8719
(anonymous) @ jquery.js:8797
each @ jquery.js:385
each @ jquery.js:207
trigger @ jquery.js:8796
(anonymous) @ jquery-migrate.min.js:2
e. @ jquery-migrate.min.js:2
(anonymous) @ merged-index.js?v=66b8b270-27:11518
dispatch @ jquery.js:5430
f.handle @ jquery.js:5234
globals.js:62 $ is deprecated: The global jQuery is deprecated. It will be removed in a later versions without another warning. Please ship your own.
Tt @ globals.js:62
get @ globals.js:93
getFileInfo @ client.js:636
addAndFetchFileInfo @ merged-index.js?v=66b8b270-27:7184
(anonymous) @ TemplatePicker.vue:218
u @ runtime.js:63
(anonymous) @ runtime.js:294
(anonymous) @ runtime.js:119
H @ TemplatePreview.vue?81db:20
o @ TemplatePreview.vue?81db:20
Promise.then (async)
H @ TemplatePreview.vue?81db:20
o @ TemplatePreview.vue?81db:20
(anonymous) @ TemplatePreview.vue?81db:20
(anonymous) @ TemplatePreview.vue?81db:20
onSubmit @ TemplatePicker.vue:199
(anonymous) @ TemplatePicker.vue:171
u @ runtime.js:63
(anonymous) @ runtime.js:294
(anonymous) @ runtime.js:119
H @ TemplatePreview.vue?81db:20
o @ TemplatePreview.vue?81db:20
Promise.then (async)
H @ TemplatePreview.vue?81db:20
o @ TemplatePreview.vue?81db:20
(anonymous) @ TemplatePreview.vue?81db:20
(anonymous) @ TemplatePreview.vue?81db:20
open @ TemplatePicker.vue:156
actionHandler @ templates.js:113
(anonymous) @ merged-index.js?v=66b8b270-27:11541
dispatch @ jquery.js:5430
f.handle @ jquery.js:5234
trigger @ jquery.js:8719
(anonymous) @ jquery.js:8797
each @ jquery.js:385
each @ jquery.js:207
trigger @ jquery.js:8796
(anonymous) @ jquery-migrate.min.js:2
e. @ jquery-migrate.min.js:2
(anonymous) @ merged-index.js?v=66b8b270-27:11518
dispatch @ jquery.js:5430
f.handle @ jquery.js:5234
globals.js:62 $ is deprecated: The global jQuery is deprecated. It will be removed in a later versions without another warning. Please ship your own.
Tt @ globals.js:62
get @ globals.js:93
_createRow @ merged-index.js?v=66b8b270-27:5672
fileList._createRow @ merged-index.js?v=66b8b270-27:12397
e._createRow @ share.js:86
e._createRow @ filesplugin.js:84
fileList._createRow @ files.js?v=66b8b270-27:48
_renderRow @ merged-index.js?v=66b8b270-27:6014
add @ merged-index.js?v=66b8b270-27:5948
(anonymous) @ merged-index.js?v=66b8b270-27:7190
c @ jquery.js:3766
u @ jquery.js:3834
setTimeout (async)
(anonymous) @ jquery.js:3872
l @ jquery.js:3500
fireWith @ jquery.js:3630
fire @ jquery.js:3638
l @ jquery.js:3500
fireWith @ jquery.js:3630
Deferred.E.each.r. @ jquery.js:3968
(anonymous) @ client.js:653
Promise.then (async)
getFileInfo @ client.js:650
addAndFetchFileInfo @ merged-index.js?v=66b8b270-27:7184
(anonymous) @ TemplatePicker.vue:218

l @ jquery.js:3500
fireWith @ jquery.js:3630
fire @ jquery.js:3638
l @ jquery.js:3500
fireWith @ jquery.js:3630
Deferred.E.each.r. @ jquery.js:3968
(anonymous) @ client.js:653
Promise.then (async)
getFileInfo @ client.js:650
addAndFetchFileInfo @ merged-index.js?v=66b8b270-27:7184
(anonymous) @ TemplatePicker.vue:218

globals.js:62 $ is deprecated: The global jQuery is deprecated. It will be removed in a later versions without another warning. Please ship your own.
Tt @ globals.js:62
get @ globals.js:93
_createRow @ merged-index.js?v=66b8b270-27:5888
fileList._createRow @ merged-index.js?v=66b8b270-27:12397
e._createRow @ share.js:86
e._createRow @ filesplugin.js:84
fileList._createRow @ files.js?v=66b8b270-27:48
_renderRow @ merged-index.js?v=66b8b270-27:6014
add @ merged-index.js?v=66b8b270-27:5948
(anonymous) @ merged-index.js?v=66b8b270-27:7190
c @ jquery.js:3766
u @ jquery.js:3834
setTimeout (async)
(anonymous) @ jquery.js:3872
l @ jquery.js:3500
fireWith @ jquery.js:3630
fire @ jquery.js:3638
l @ jquery.js:3500
fireWith @ jquery.js:3630
Deferred.E.each.r. @ jquery.js:3968
(anonymous) @ client.js:653
Promise.then (async)
getFileInfo @ client.js:650
addAndFetchFileInfo @ merged-index.js?v=66b8b270-27:7184
(anonymous) @ TemplatePicker.vue:218
u @ runtime.js:63
(anonymous) @ runtime.js:294
(anonymous) @ runtime.js:119
H @ TemplatePreview.vue?81db:20
o @ TemplatePreview.vue?81db:20
Promise.then (async)
H @ TemplatePreview.vue?81db:20
o @ TemplatePreview.vue?81db:20
(anonymous) @ TemplatePreview.vue?81db:20
(anonymous) @ TemplatePreview.vue?81db:20
onSubmit @ TemplatePicker.vue:199
(anonymous) @ TemplatePicker.vue:171

Tt @ globals.js:62
get @ globals.js:93
getActions @ merged-index.js?v=66b8b270-27:3121
getDefaultFileAction @ merged-index.js?v=66b8b270-27:3204
display @ merged-index.js?v=66b8b270-27:3448
_renderRow @ merged-index.js?v=66b8b270-27:6039
add @ merged-index.js?v=66b8b270-27:5948
(anonymous) @ merged-index.js?v=66b8b270-27:7190
c @ jquery.js:3766
u @ jquery.js:3834
setTimeout (async)
(anonymous) @ jquery.js:3872
l @ jquery.js:3500
fireWith @ jquery.js:3630
fire @ jquery.js:3638
l @ jquery.js:3500
fireWith @ jquery.js:3630
Deferred.E.each.r. @ jquery.js:3968
(anonymous) @ client.js:653
Promise.then (async)
getFileInfo @ client.js:650
addAndFetchFileInfo @ merged-index.js?v=66b8b270-27:7184
(anonymous) @ TemplatePicker.vue:218
u @ runtime.js:63
(anonymous) @ runtime.js:294
(anonymous) @ runtime.js:119
H @ TemplatePreview.vue?81db:20
o @ TemplatePreview.vue?81db:20
Promise.then (async)
H @ TemplatePreview.vue?81db:20
o @ TemplatePreview.vue?81db:20
(anonymous) @ TemplatePreview.vue?81db:20
(anonymous) @ TemplatePreview.vue?81db:20
onSubmit @ TemplatePicker.vue:199
(anonymous) @ TemplatePicker.vue:171
u @ runtime.js:63
(anonymous) @ runtime.js:294
(anonymous) @ runtime.js:119
H @ TemplatePreview.vue?81db:20
o @ TemplatePreview.vue?81db:20
Promise.then (async)
H @ TemplatePreview.vue?81db:20
o @ TemplatePreview.vue?81db:20
(anonymous) @ TemplatePreview.vue?81db:20
(anonymous) @ TemplatePreview.vue?81db:20
open @ TemplatePicker.vue:156
actionHandler @ templates.js:113
(anonymous) @ merged-index.js?v=66b8b270-27:11541
dispatch @ jquery.js:5430
f.handle @ jquery.js:5234
trigger @ jquery.js:8719
(anonymous) @ jquery.js:8797
each @ jquery.js:385
each @ jquery.js:207
trigger @ jquery.js:8796
(anonymous) @ jquery-migrate.min.js:2
e. @ jquery-migrate.min.js:2
(anonymous) @ merged-index.js?v=66b8b270-27:11518
dispatch @ jquery.js:5430
f.handle @ jquery.js:5234
globals.js:62 $ is deprecated: The global jQuery is deprecated. It will be removed in a later versions without another warning. Please ship your own.
Tt @ globals.js:62
get @ globals.js:93
getActions @ merged-index.js?v=66b8b270-27:3127
getDefaultFileAction @ merged-index.js?v=66b8b270-27:3204
display @ merged-index.js?v=66b8b270-27:3448
_renderRow @ merged-index.js?v=66b8b270-27:6039
add @ merged-index.js?v=66b8b270-27:5948
(anonymous) @ merged-index.js?v=66b8b270-27:7190
c @ jquery.js:3766
u @ jquery.js:3834
setTimeout (async)
(anonymous) @ jquery.js:3872
l @ jquery.js:3500
fireWith @ jquery.js:3630
fire @ jquery.js:3638
l @ jquery.js:3500
fireWith @ jquery.js:3630
Deferred.E.each.r. @ jquery.js:3968
(anonymous) @ client.js:653
Promise.then (async)
getFileInfo @ client.js:650
addAndFetchFileInfo @ merged-index.js?v=66b8b270-27:7184
(anonymous) @ TemplatePicker.vue:218
u @ runtime.js:63
(anonymous) @ runtime.js:294
(anonymous) @ runtime.js:119
H @ TemplatePreview.vue?81db:20
o @ TemplatePreview.vue?81db:20
Promise.then (async)
H @ TemplatePreview.vue?81db:20
o @ TemplatePreview.vue?81db:20
(anonymous) @ TemplatePreview.vue?81db:20
(anonymous) @ TemplatePreview.vue?81db:20
onSubmit @ TemplatePicker.vue:199
(anonymous) @ TemplatePicker.vue:171
u @ runtime.js:63
(anonymous) @ runtime.js:294
(anonymous) @ runtime.js:119
H @ TemplatePreview.vue?81db:20
o @ TemplatePreview.vue?81db:20
Promise.then (async)
H @ TemplatePreview.vue?81db:20
o @ TemplatePreview.vue?81db:20
(anonymous) @ TemplatePreview.vue?81db:20
(anonymous) @ TemplatePreview.vue?81db:20
open @ TemplatePicker.vue:156
actionHandler @ templates.js:113
(anonymous) @ merged-index.js?v=66b8b270-27:11541
dispatch @ jquery.js:5430
f.handle @ jquery.js:5234
trigger @ jquery.js:8719
(anonymous) @ jquery.js:8797
each @ jquery.js:385
each @ jquery.js:207
trigger @ jquery.js:8796
(anonymous) @ jquery-migrate.min.js:2
e. @ jquery-migrate.min.js:2
(anonymous) @ merged-index.js?v=66b8b270-27:11518
dispatch @ jquery.js:5430
f.handle @ jquery.js:5234
globals.js:62 $ is deprecated: The global jQuery is deprecated. It will be removed in a later versions without another warning. Please ship your own.
Tt @ globals.js:62
get @ globals.js:93
display @ merged-index.js?v=66b8b270-27:3460
_renderRow @ merged-index.js?v=66b8b270-27:6039
add @ merged-index.js?v=66b8b270-27:5948
(anonymous) @ merged-index.js?v=66b8b270-27:7190
c @ jquery.js:3766
u @ jquery.js:3834
setTimeout (async)
(anonymous) @ jquery.js:3872
l @ jquery.js:3500
fireWith @ jquery.js:3630
fire @ jquery.js:3638
l @ jquery.js:3500
fireWith @ jquery.js:3630
Deferred.E.each.r. @ jquery.js:3968
(anonymous) @ client.js:653
Promise.then (async)
getFileInfo @ client.js:650
addAndFetchFileInfo @ merged-index.js?v=66b8b270-27:7184
(anonymous) @ TemplatePicker.vue:218
u @ runtime.js:63
(anonymous) @ runtime.js:294
(anonymous) @ runtime.js:119
H @ TemplatePreview.vue?81db:20
o @ TemplatePreview.vue?81db:20
Promise.then (async)
H @ TemplatePreview.vue?81db:20
o @ TemplatePreview.vue?81db:20
(anonymous) @ TemplatePreview.vue?81db:20
(anonymous) @ TemplatePreview.vue?81db:20
onSubmit @ TemplatePicker.vue:199
(anonymous) @ TemplatePicker.vue:171
u @ runtime.js:63
(anonymous) @ runtime.js:294
(anonymous) @ runtime.js:119
H @ TemplatePreview.vue?81db:20
o @ TemplatePreview.vue?81db:20
Promise.then (async)
H @ TemplatePreview.vue?81db:20
o @ TemplatePreview.vue?81db:20
(anonymous) @ TemplatePreview.vue?81db:20
(anonymous) @ TemplatePreview.vue?81db:20
open @ TemplatePicker.vue:156
actionHandler @ templates.js:113
(anonymous) @ merged-index.js?v=66b8b270-27:11541
dispatch @ jquery.js:5430
f.handle @ jquery.js:5234
trigger @ jquery.js:8719
(anonymous) @ jquery.js:8797
each @ jquery.js:385
each @ jquery.js:207
trigger @ jquery.js:8796
(anonymous) @ jquery-migrate.min.js:2
e. @ jquery-migrate.min.js:2
(anonymous) @ merged-index.js?v=66b8b270-27:11518
dispatch @ jquery.js:5430
f.handle @ jquery.js:5234
globals.js:62 $ is deprecated: The global jQuery is deprecated. It will be removed in a later versions without another warning. Please ship your own.
Tt @ globals.js:62
get @ globals.js:93
_makeActionLink @ merged-index.js?v=66b8b270-27:3247
_defaultRenderAction @ merged-index.js?v=66b8b270-27:3234
render @ share.js:252
_renderInlineAction @ merged-index.js?v=66b8b270-27:3313
(anonymous) @ merged-index.js?v=66b8b270-27:3462
each @ jquery.js:391
display @ merged-index.js?v=66b8b270-27:3460
_renderRow @ merged-index.js?v=66b8b270-27:6039
add @ merged-index.js?v=66b8b270-27:5948
(anonymous) @ merged-index.js?v=66b8b270-27:7190
c @ jquery.js:3766
u @ jquery.js:3834
setTimeout (async)
(anonymous) @ jquery.js:3872
l @ jquery.js:3500
fireWith @ jquery.js:3630
fire @ jquery.js:3638
l @ jquery.js:3500
fireWith @ jquery.js:3630
Deferred.E.each.r. @ jquery.js:3968
(anonymous) @ client.js:653
Promise.then (async)
getFileInfo @ client.js:650
addAndFetchFileInfo @ merged-index.js?v=66b8b270-27:7184
(anonymous) @ TemplatePicker.vue:218
u @ runtime.js:63
(anonymous) @ runtime.js:294
(anonymous) @ runtime.js:119
H @ TemplatePreview.vue?81db:20
o @ TemplatePreview.vue?81db:20
Promise.then (async)
H @ TemplatePreview.vue?81db:20
o @ TemplatePreview.vue?81db:20
(anonymous) @ TemplatePreview.vue?81db:20
(anonymous) @ TemplatePreview.vue?81db:20
onSubmit @ TemplatePicker.vue:199
(anonymous) @ TemplatePicker.vue:171
u @ runtime.js:63
(anonymous) @ runtime.js:294
(anonymous) @ runtime.js:119
H @ TemplatePreview.vue?81db:20
o @ TemplatePreview.vue?81db:20
Promise.then (async)
H @ TemplatePreview.vue?81db:20
o @ TemplatePreview.vue?81db:20
(anonymous) @ TemplatePreview.vue?81db:20
(anonymous) @ TemplatePreview.vue?81db:20
open @ TemplatePicker.vue:156
actionHandler @ templates.js:113
(anonymous) @ merged-index.js?v=66b8b270-27:11541
dispatch @ jquery.js:5430
f.handle @ jquery.js:5234
trigger @ jquery.js:8719
(anonymous) @ jquery.js:8797
each @ jquery.js:385
each @ jquery.js:207
trigger @ jquery.js:8796
(anonymous) @ jquery-migrate.min.js:2
e. @ jquery-migrate.min.js:2
(anonymous) @ merged-index.js?v=66b8b270-27:11518
dispatch @ jquery.js:5430
f.handle @ jquery.js:5234
globals.js:62 $ is deprecated: The global jQuery is deprecated. It will be removed in a later versions without another warning. Please ship your own.

_notifyUpdateListeners @ merged-index.js?v=66b8b270-27:2967
action @ merged-index.js?v=66b8b270-27:3026
(anonymous) @ TemplatePicker.vue:225
u @ runtime.js:63
(anonymous) @ runtime.js:294
(anonymous) @ runtime.js:119
H @ TemplatePreview.vue?81db:20
o @ TemplatePreview.vue?81db:20
Promise.then (async)
H @ TemplatePreview.vue?81db:20
o @ TemplatePreview.vue?81db:20
Promise.then (async)
H @ TemplatePreview.vue?81db:20
o @ TemplatePreview.vue?81db:20

globals.js:62 jQuery is deprecated: The global jQuery is deprecated. It will be removed in a later versions without another warning. Please ship your own.
Tt @ globals.js:62
get @ globals.js:93
r @ VM1542:1
(anonymous) @ VM1542:1
globals.js:62 jQuery is deprecated: The global jQuery is deprecated. It will be removed in a later versions without another warning. Please ship your own.
Tt @ globals.js:62
get @ globals.js:93
r @ VM1543:1
(anonymous) @ VM1543:1
globals.js:62 jQuery is deprecated: The global jQuery is deprecated. It will be removed in a later versions without another warning. Please ship your own.
Tt @ globals.js:62
get @ globals.js:93
r @ VM1544:1
(anonymous) @ VM1544:1

It goes on for 10.000 digits like this …

With the file-locking, for online editing and when there are a lot of up- and downloads (and with different devices), the file locking is more efficient and much faster with redis.
https://docs.nextcloud.com/server/stable/admin_manual/configuration_server/caching_configuration.html

For the other app-errors. They look a bit strange and I can’t find many references. Did the update run through completely, the apps were all updated as well. If you go on the app page, there are no updates? And the admin-page, are there some errors?
And your deprecations warning seem bizarre as well, when something is supposed to be removed after NC 20 and you are already past NC23, either they forgot to remove it or you have some old code somewhere.

yes there are errors, i’m trying to fix then … with a slow progression

There are some errors regarding your setup.

  • It was not possible to execute the cron job via CLI. The following technical errors have appeared:

    • Votre répertoire des données n’est pas valide. Assurez-vous que le répertoire de données contient un fichier “.ocdata” à sa racine.
  • Last background job execution ran 4 days ago. Something seems wrong. Check the background job settings :arrow_upper_right:.

  • No memory cache has been configured. To enhance performance, please configure a memcache, if available. Further information can be found in the documentation :arrow_upper_right:.

  • The PHP OPcache module is not properly configured. See the documentation :arrow_upper_right: for more information.

    • The OPcache interned strings buffer is nearly full. To assure that repeating strings can be effectively cached, it is recommended to apply opcache.interned_strings_buffer to your PHP configuration with a value higher than 8.
  • The database is missing some indexes. Due to the fact that adding indexes on big tables could take some time they were not added automatically. By running “occ db:add-missing-indices” those missing indexes could be added manually while the instance keeps running. Once the indexes are added queries to those tables are usually much faster.

    • Missing index “direct_edit_timestamp” in table “oc_direct_edit”.

i did experience upgrade troubles … but i can’t tell which errors these troubles created :confused:
i can’t see any upgrade to perform amongst apps …

this could have happened with an error at upgrade …?

They seem all bad for your problem. Missing indices slow down database queries, with memory cache, it is much faster, and the missing .ocdata file, is your external disk not mounted?

1 Like

thanks
yes there are and i’m trying to understand the functionning of NC to fix them.
I’ve oppened a ticket regarding .ocdata missing, when it’s actually in the right place.
I’ve openned a ticket regarding permissions.
Alos, i’m trying to understand the cron disfunction …

Can you put me on a lead to solve Missing indices please ?
thanks a lot for your help

Remains this:

There are some errors regarding your setup.

  • It was not possible to execute the cron job via CLI. The following technical errors have appeared:

    • Votre répertoire des données n’est pas valide. Assurez-vous que le répertoire de données contient un fichier “.ocdata” à sa racine.
  • Last background job execution ran 5 days ago. Something seems wrong. Check the background job settings :arrow_upper_right:.

  • No memory cache has been configured. To enhance performance, please configure a memcache, if available. Further information can be found in the documentation :arrow_upper_right:.

  • The PHP OPcache module is not properly configured. See the documentation :arrow_upper_right: for more information.

    • The OPcache interned strings buffer is nearly full. To assure that repeating strings can be effectively cached, it is recommended to apply opcache.interned_strings_buffer to your PHP configuration with a value higher than 8.

Please double check the installation guides :arrow_upper_right:, and check for any errors or warnings in the log.

Check the security of your Nextcloud over our security scan :arrow_upper_right:.

i’ve found this:

sudo -u koraprod php occ db:add-missing-columns
sudo -u koraprod php occ db:add-missing-indices
sudo -u koraprod php occ db:add-missing-primary-keys

my ‘data’ folder is next to ‘nextcloud’ folder in my ‘public_html’ root folder
it’s not on an external drive, nothing i would need to mount …
it’s all on a vps
data folder is here, .ocdata is in the data folder
everything is permitted to the http user (644)
textapp is still very slow after the occ command

that’s better : only 2 errors left
but textapp is still slow
and some collectives documents have been deleted :confused:

There are some errors regarding your setup.

  • Last background job execution ran 1 hour ago. Something seems wrong. Check the background job settings :arrow_upper_right:.

  • No memory cache has been configured. To enhance performance, please configure a memcache, if available. Further information can be found in the documentation :arrow_upper_right:.

It is just that your user is not www-data, so for the cronjob in (https://docs.nextcloud.com/server/stable/admin_manual/configuration_server/background_jobs_configuration.html#cron):

sudo -u koraprod crontab -e

thanks a lot
i’ve found the proper settings for hestia (finally)
php -f /home/user-www/web/website.com/public_html/nextcloud/cron.php
:white_check_mark: Last job ran seconds ago :metal:

now i’ve fixed everything in the Overview :white_check_mark: All checks passed
the whole thing works MUCH better now, faster, but …
TextApp is still slow

and I get logs like these

Warning files User cloudadmin still has unscanned files after running background scan, background scan might be stopped prematurely 2022-06-12T01:10:01+0200
Info files_lock OC\HintException: [notice] ConfigService::LOCK_TIMEOUT is not numerical, using default 2022-06-12T01:05:01+0200
Info files_lock [notice] unlocking file – {“fileLock”:{}} 2022-06-12T01:03:02+0200
Info no app in context Deprecated event type for OCP\IDBConnection::CHECK_MISSING_COLUMNS: Symfony\Component\EventDispatcher\GenericEvent is used 2022-06-12T01:01:40+0200
Info no app in context Deprecated event type for OCP\IDBConnection::CHECK_MISSING_INDEXES: Symfony\Component\EventDispatcher\GenericEvent is used 2022-06-12T01:01:40+0200
Info no app in context Deprecated event type for OCP\IDBConnection::CHECK_MISSING_PRIMARY_KEYS: Symfony\Component\EventDispatcher\GenericEvent is used 2022-06-12T01:01:39+0200
Warning files User cloudadmin still has unscanned files after running background scan, background scan might be stopped prematurely 2022-06-12T00:59:02+0200
Info files_lock [notice] locking file – {“fileLock”:{“id”:0,“uri”:"",“userId”:“text”,“displayName”:null,“fileId”:4482,“token”:“files_lock/2870a94a-d228-4c40-9102-d72570ed3ed9”,“eta”:-1,“creation”:1654988175,“type”:1}}

Info no app in context Deprecated event type for OCA\Files::loadAdditionalScripts: Symfony\Component\EventDispatcher\GenericEvent is used

These are my lastest settings in php.ini

memory_limit = 512M
upload_max_filesize = 200M
max_execution_time = 360
post_max_size = 200M
date.timezone = Europe/Paris
opcache.enable=1
opcache.interned_strings_buffer=64
opcache.max_accelerated_files=50000
opcache.memory_consumption=512
opcache.save_comments=1
opcache.revalidate_freq=1
opcache.max_wasted_percentage=15
opcache.validate_timestamps=0
opcache.revalidate_freq=0
opcache.fast_shutdown=1
opcache.fast_shutdown=1
opcache.mmap_base=0x20000000
opcache.file_cache_fallback=1

in next2024/config/config.php
‘memcache.local’ => ‘\OC\Memcache\APCu’,

COULD YOU HELP A STEP FURTHER PLEASE ?
i’ve noticed that textapp is not always slow.
It’s very slow or bugs in the shared files page, but it loads quite normally if i open a . md file in collaboratives !

Ok, great. Can you install redis as filelocking cache? I think for this online-editing apps, they lock the file during changes, and if redis is not used this can create quite some load on your database.

You can disable it as well to see if that influences the speed:

However, keeping it disabled if you want to use it for more people is probably not the best idea.

hi, this table was empty…