Hi
I have a problem with “Slow get helper” warnings in the logs
Site: https://www.futurenode.dk
Ghost-CLI version: 1.18.1
Ghost version: 4.38.1 (at /var/www/ghost)
Provider: Contabo
I get a lot of these warnings:
NAME: HelperWarning
CODE: SLOW_GET_HELPER
MESSAGE: {{#get}} helper took 291ms to complete
level: normal
ERROR DETAILS:
{"api":"canary.tagsPublic.browse","apiOptions":{"limit":"15","order":"count.posts desc","include":"count.posts","context":{"member":null}},"returnedRows":13}
[2022-03-09 19:32:14] WARN
NAME: HelperWarning
CODE: SLOW_GET_HELPER
MESSAGE: {{#get}} helper took 221ms to complete
level: normal
ERROR DETAILS:
{"api":"canary.tagsPublic.browse","apiOptions":{"limit":"13","order":"count.posts desc","include":"count.posts","filter":"visibility:public","context":{"member":null}},"returnedRows":12}
[2022-03-09 19:32:14] WARN
NAME: HelperWarning
CODE: SLOW_GET_HELPER
MESSAGE: {{#get}} helper took 220ms to complete
level: normal
ERROR DETAILS:
{"api":"canary.authorsPublic.browse","apiOptions":{"limit":"6","order":"count.posts desc","include":"count.posts","context":{"member":null}},"returnedRows":2}
[2022-03-09 19:32:14] WARN
NAME: HelperWarning
CODE: SLOW_GET_HELPER
MESSAGE: {{#get}} helper took 377ms to complete
level: normal
ERROR DETAILS:
{"api":"canary.postsPublic.browse","apiOptions":{"filter":"visibility:public","limit":"1","context":{"member":null}},"returnedRows":1}
[2022-03-09 19:32:14] WARN
NAME: HelperWarning
CODE: SLOW_GET_HELPER
MESSAGE: {{#get}} helper took 380ms to complete
level: normal
ERROR DETAILS:
{"api":"canary.postsPublic.browse","apiOptions":{"limit":"all","filter":"featured:true","context":{"member":null}},"returnedRows":3}
[2022-03-09 19:32:14] WARN
NAME: HelperWarning
CODE: SLOW_GET_HELPER
MESSAGE: {{#get}} helper took 399ms to complete
level: normal
ERROR DETAILS:
{"api":"canary.postsPublic.browse","apiOptions":{"filter":"visibility:members","limit":"1","context":{"member":null}},"returnedRows":1}
[2022-03-09 19:32:14] WARN
NAME: HelperWarning
CODE: SLOW_GET_HELPER
MESSAGE: {{#get}} helper took 400ms to complete
level: normal
ERROR DETAILS:
{"api":"canary.postsPublic.browse","apiOptions":{"limit":"1","context":{"member":null}},"returnedRows":1}
[2022-03-09 19:32:14] WARN
NAME: HelperWarning
CODE: SLOW_GET_HELPER
MESSAGE: {{#get}} helper took 308ms to complete
level: normal
ERROR DETAILS:
{"api":"canary.postsPublic.browse","apiOptions":{"limit":"3","filter":"tag:hash-announcement","context":{"member":null}},"returnedRows":2}
Here is my config:
"url": "https://www.futurenode.dk",
"server": {
"port": 2368,
"host": "127.0.0.1"
},
"database": {
"client": "mysql",
"connection": {
"host": "localhost",
"user": "USER",
"password": "PASSWORD",
"database": "ghost"
}
},
"mail": {
"from": "'FutureNode.dk' <no-reply@futurenode.dk>",
"transport": "SMTP",
"options": {
"service": "Mailgun",
"host": "smtp.eu.mailgun.org",
"port": 465,
"secureConnection": true,
"auth": {
"user": "MAILUSER",
"pass": "MAILPASS"
}
}
},
"logging": {
"transports": [
"file",
"stdout"
]
},
"slowHelper": {
"level": "warn",
"threshold": 2000
},
"process": "systemd",
"paths": {
"contentPath": "/var/www/ghost/content"
}
}
Hope someone can help me out here, so I don’t get these warnings
Regards
Thomas