coop-cloud/ghost
1
0
Fork 1
Code Issues 3 Pull Requests 2 Projects Releases Wiki Activity

Occasionally getting errors 500 #5

New Issue
Closed
opened 2025-10-17 14:30:59 +00:00 by val · 2 comments
val commented 2025-10-17 14:30:59 +00:00
Owner
Copy Link
Copy Source

Accessing the ghost blog sometimes leads to an error 500, after refreshing the page, it works properly again.

@trave had the idea: "It's like it is losing connection to the db every once and a while and fixes itself in under a minute"

some logs to further investigate it:

> r2025-10-17T14:22:07.554820000Z [2025-10-17 14:22:07] INFO "GET /ghost/api/admin/site" 301 6ms
s2025-10-17T14:22:07.562933000Z [2025-10-17 14:22:07] INFO "GET /ghost/api/admin/site/" 200 5ms
q2025-10-17T14:22:37.592416000Z [2025-10-17 14:22:37] ERROR "GET /full-moon-decade/" 500 47ms
%2025-10-17T14:22:37.600033000Z 
Y2025-10-17T14:22:37.600146000Z An unexpected error occurred, please try again.
 2025-10-17T14:22:37.600237000Z 
�2025-10-17T14:22:37.600318000Z "select `posts`.* from `posts` where (`posts`.`status` = 'published' and `posts`.`type` = 'post') and `posts`.`slug` = 'full-moon-decade' limit 1 - read ECONNRESET"
 2025-10-17T14:22:37.600407000Z 
<2025-10-17T14:22:37.600497000Z Error ID:
R2025-10-17T14:22:37.600590000Z     bb497c40-ab64-11f0-b259-abcabcc852d6
 2025-10-17T14:22:37.600679000Z 
?2025-10-17T14:22:37.600748000Z Error Code: 
>2025-10-17T14:22:37.600841000Z     UNEXPECTED_ERROR
 2025-10-17T14:22:37.600919000Z 
R2025-10-17T14:22:37.600997000Z ----------------------------------------
 2025-10-17T14:22:37.601085000Z 
;2025-10-17T14:22:37.601159000Z Error: read ECONNRESET
�2025-10-17T14:22:37.601236000Z     at prepareError (/var/lib/ghost/versions/5.130.5/node_modules/@tryghost/mw-error-handler/lib/mw-error-handler.js:113:19)
g2025-10-17T14:22:37.601313000Z     at TCP.onStreamRead (node:internal/stream_base_commons:218:20)
%2025-10-17T14:22:37.601393000Z 
r2025-10-17T14:22:37.646509000Z [2025-10-17 14:22:37] INFO "GET /ghost/api/admin/site" 301 1ms
s2025-10-17T14:22:37.649964000Z [2025-10-17 14:22:37] INFO "GET /ghost/api/admin/site/" 200 1ms
2025-10-17T14:22:37.877503000Z [2025-10-17 14:22:37] INFO "GET /public/ghost.min.css?v=50164ab2e7" 200 3ms
i2025-10-17T14:22:39.062810000Z [2025-10-17 14:22:39] INFO "GET /favicon.ico" 200 3ms
`2025-10-17T14:22:58.144369000Z [2025-10-17 14:22:58] ERROR "GET /" 500 25ms
%2025-10-17T14:22:58.144834000Z 
Y2025-10-17T14:22:58.145045000Z An unexpected error occurred, please try again.
 2025-10-17T14:22:58.145219000Z 
�2025-10-17T14:22:58.145385000Z "select count(distinct posts.id) as aggregate from `posts` where (`posts`.`status` = 'published' and `posts`.`type` = 'post') - read ECONNRESET"
 2025-10-17T14:22:58.145570000Z 
<2025-10-17T14:22:58.145703000Z Error ID:
R2025-10-17T14:22:58.145815000Z     c78b4d80-ab64-11f0-b259-abcabcc852d6
 2025-10-17T14:22:58.145947000Z 
?2025-10-17T14:22:58.146096000Z Error Code: 
>2025-10-17T14:22:58.146207000Z     UNEXPECTED_ERROR
 2025-10-17T14:22:58.146349000Z 
R2025-10-17T14:22:58.146519000Z ----------------------------------------
 2025-10-17T14:22:58.146672000Z 
;2025-10-17T14:22:58.146808000Z Error: read ECONNRESET
�2025-10-17T14:22:58.146941000Z     at prepareError (/var/lib/ghost/versions/5.130.5/node_modules/@tryghost/mw-error-handler/lib/mw-error-handler.js:113:19)
g2025-10-17T14:22:58.147089000Z     at TCP.onStreamRead (node:internal/stream_base_commons:218:20)
%2025-10-17T14:22:58.147316000Z 
`2025-10-17T14:23:02.675813000Z [2025-10-17 14:23:02] INFO "GET /" 200 137ms
�2025-10-17T14:23:02.904994000Z [2025-10-17 14:23:02] INFO "GET /assets/fonts/inter-roman.woff2?v=50164ab2e7" 200 11ms
�2025-10-17T14:23:02.906521000Z [2025-10-17 14:23:02] INFO "GET /assets/built/screen.css?v=50164ab2e7" 200 17ms

``
Accessing the ghost blog sometimes leads to an error 500, after refreshing the page, it works properly again. > @trave had the idea: "It's like it is losing connection to the db every once and a while and fixes itself in under a minute" some logs to further investigate it: ``` > r2025-10-17T14:22:07.554820000Z [2025-10-17 14:22:07] INFO "GET /ghost/api/admin/site" 301 6ms s2025-10-17T14:22:07.562933000Z [2025-10-17 14:22:07] INFO "GET /ghost/api/admin/site/" 200 5ms q2025-10-17T14:22:37.592416000Z [2025-10-17 14:22:37] ERROR "GET /full-moon-decade/" 500 47ms %2025-10-17T14:22:37.600033000Z Y2025-10-17T14:22:37.600146000Z An unexpected error occurred, please try again. 2025-10-17T14:22:37.600237000Z �2025-10-17T14:22:37.600318000Z "select `posts`.* from `posts` where (`posts`.`status` = 'published' and `posts`.`type` = 'post') and `posts`.`slug` = 'full-moon-decade' limit 1 - read ECONNRESET" 2025-10-17T14:22:37.600407000Z <2025-10-17T14:22:37.600497000Z Error ID: R2025-10-17T14:22:37.600590000Z bb497c40-ab64-11f0-b259-abcabcc852d6 2025-10-17T14:22:37.600679000Z ?2025-10-17T14:22:37.600748000Z Error Code: >2025-10-17T14:22:37.600841000Z UNEXPECTED_ERROR 2025-10-17T14:22:37.600919000Z R2025-10-17T14:22:37.600997000Z ---------------------------------------- 2025-10-17T14:22:37.601085000Z ;2025-10-17T14:22:37.601159000Z Error: read ECONNRESET �2025-10-17T14:22:37.601236000Z at prepareError (/var/lib/ghost/versions/5.130.5/node_modules/@tryghost/mw-error-handler/lib/mw-error-handler.js:113:19) g2025-10-17T14:22:37.601313000Z at TCP.onStreamRead (node:internal/stream_base_commons:218:20) %2025-10-17T14:22:37.601393000Z r2025-10-17T14:22:37.646509000Z [2025-10-17 14:22:37] INFO "GET /ghost/api/admin/site" 301 1ms s2025-10-17T14:22:37.649964000Z [2025-10-17 14:22:37] INFO "GET /ghost/api/admin/site/" 200 1ms 2025-10-17T14:22:37.877503000Z [2025-10-17 14:22:37] INFO "GET /public/ghost.min.css?v=50164ab2e7" 200 3ms i2025-10-17T14:22:39.062810000Z [2025-10-17 14:22:39] INFO "GET /favicon.ico" 200 3ms `2025-10-17T14:22:58.144369000Z [2025-10-17 14:22:58] ERROR "GET /" 500 25ms %2025-10-17T14:22:58.144834000Z Y2025-10-17T14:22:58.145045000Z An unexpected error occurred, please try again. 2025-10-17T14:22:58.145219000Z �2025-10-17T14:22:58.145385000Z "select count(distinct posts.id) as aggregate from `posts` where (`posts`.`status` = 'published' and `posts`.`type` = 'post') - read ECONNRESET" 2025-10-17T14:22:58.145570000Z <2025-10-17T14:22:58.145703000Z Error ID: R2025-10-17T14:22:58.145815000Z c78b4d80-ab64-11f0-b259-abcabcc852d6 2025-10-17T14:22:58.145947000Z ?2025-10-17T14:22:58.146096000Z Error Code: >2025-10-17T14:22:58.146207000Z UNEXPECTED_ERROR 2025-10-17T14:22:58.146349000Z R2025-10-17T14:22:58.146519000Z ---------------------------------------- 2025-10-17T14:22:58.146672000Z ;2025-10-17T14:22:58.146808000Z Error: read ECONNRESET �2025-10-17T14:22:58.146941000Z at prepareError (/var/lib/ghost/versions/5.130.5/node_modules/@tryghost/mw-error-handler/lib/mw-error-handler.js:113:19) g2025-10-17T14:22:58.147089000Z at TCP.onStreamRead (node:internal/stream_base_commons:218:20) %2025-10-17T14:22:58.147316000Z `2025-10-17T14:23:02.675813000Z [2025-10-17 14:23:02] INFO "GET /" 200 137ms �2025-10-17T14:23:02.904994000Z [2025-10-17 14:23:02] INFO "GET /assets/fonts/inter-roman.woff2?v=50164ab2e7" 200 11ms �2025-10-17T14:23:02.906521000Z [2025-10-17 14:23:02] INFO "GET /assets/built/screen.css?v=50164ab2e7" 200 17ms ``
val commented 2025-10-17 14:33:33 +00:00
Author
Owner
Copy Link
Copy Source

https://forum.ghost.org/t/econnreset-500-inactivity-error-selfhosted-beginner/19933 this could be a hint

they propose to set "pool" of "database" do "min": 0 .. but I'm not sure what exactly that would mean?

https://docs.ghost.org/config#number-of-connections

indicates that there is a minimum of 2 set by default and that this means "Ghost always maintains two active database connections" which would be.. good? if the problem is a loss of connection?

perhaps here? https://forum.ghost.org/t/ghost-run-error-econnreset-104/30505

https://forum.ghost.org/t/econnreset-500-inactivity-error-selfhosted-beginner/19933 this could be a hint they propose to set "pool" of "database" do "min": 0 .. but I'm not sure what exactly that would mean? https://docs.ghost.org/config#number-of-connections indicates that there is a minimum of 2 set by default and that this means "Ghost always maintains two active database connections" which would be.. good? if the problem is a loss of connection? perhaps here? https://forum.ghost.org/t/ghost-run-error-econnreset-104/30505
val commented 2025-10-17 19:23:29 +00:00
Author
Owner
Copy Link
Copy Source

probably fixed it with release of version 1.1.1+6-alpine by setting default pooling of mysql-config of ghost to 0 (default normally is 2 which probably led to seemingly "open" database connections on the side of ghost, but timed out and closed on the side of the database)

probably fixed it with release of version `1.1.1+6-alpine` by setting default pooling of mysql-config of ghost to `0` (default normally is `2` which probably led to seemingly "open" database connections on the side of ghost, but timed out and closed on the side of the database)
❤️ 1
val closed this issue 2025-10-17 19:23:29 +00:00
Sign in to join this conversation.
main
Branches Tags
Labels
No items
No labels
Milestone
No items
No Milestone
Projects
Clear projects
No projects
Assignees
Clear assignees
3wordchant aadil (Aadil Ayub) abra-bot (Abra Bot) ammaratef45 amras (Sarma) Apfelwurm appletalk arjan basebuilder BornDeleuze Brooke carla cas (Cassowary) codegod100 coopcloud cyrnel decentral1se (d1) dede devydave fauno (fauno) flancian Frando iexos jade (Jade Ambrose) javielico (Javielico) jjsfunhouse jmakdah2 (Jackie Makdah) joe-irving (Joe Irving) kawaiipunk (KawaiiPunk) knoflook kolaente lambdabundesverband linnealovespie (April) marlon (marlon) mayel mirsal moosemower moritz nicksellen (Nick Sellen) notplants oxaliq (sorrel) p4u1 pau pharaohgraphy (Andrew 🐦‍🔥❤️‍🔥✴️) PhiNatalie renovate-bot (Comrade Renovate Bot) ripclap rix rscmbbng sef (sef) simon sixsmith (Sixsmith) stevensting tobias trav (Trav Fryer) val (val (he/him)) vaznasty virtualboys wolcen (Chris Thompson) wykwit xynosis yksflip
No Assignees
1 Participants
Notifications
Due Date
No due date set.
Dependencies

No dependencies set.

Reference: coop-cloud/ghost#5