Rendering page fails randomly

[andlinger]

Describe the bug
Saving a page is always indicated as successful. However, it seems that sometimes an error occurs in the background. So the correct content of the page is displayed in the editor. But after closing the editor, the old content is displayed again. If you open the editor again afterwards, the changed content is displayed in the editor.

wiki_1        | Loading configuration from /wiki/config.yml... OK
wiki_1        | 2020-08-18T12:27:13.429Z [JOB] info: Rendering page ID 22...
wiki_1        | 2020-08-18T12:27:13.736Z [JOB] info: Using database driver pg for postgres [ OK ]
wiki_1        | 2020-08-18T12:27:15.009Z [JOB] info: Rendering page ID 22: [ COMPLETED ]
wiki_1        | Loading configuration from /wiki/config.yml... OK
wiki_1        | 2020-08-18T12:27:16.393Z [JOB] info: Rendering page ID 23...
wiki_1        | 2020-08-18T12:27:16.699Z [JOB] info: Using database driver pg for postgres [ OK ]
wiki_1        | 2020-08-18T12:27:18.069Z [JOB] info: Rendering page ID 23: [ COMPLETED ]
wiki_1        | Loading configuration from /wiki/config.yml... OK
wiki_1        | 2020-08-18T12:27:19.389Z [JOB] info: Rendering page ID 24...
wiki_1        | 2020-08-18T12:27:19.729Z [JOB] info: Using database driver pg for postgres [ OK ]
wiki_1        | 2020-08-18T12:27:19.789Z [JOB] error: Rendering page ID 24: [ FAILED ]
wiki_1        | 2020-08-18T12:27:19.789Z [JOB] error: password authentication failed for user "wikijs"
postgresql_1  | LOG:  unexpected EOF on client connection with an open transaction
wiki_1        | Loading configuration from /wiki/config.yml... OK
wiki_1        | 2020-08-18T12:27:20.524Z [JOB] info: Rendering page ID 25...
wiki_1        | 2020-08-18T12:27:20.879Z [JOB] info: Using database driver pg for postgres [ OK ]
wiki_1        | 2020-08-18T12:27:20.899Z [JOB] error: Rendering page ID 25: [ FAILED ]
wiki_1        | 2020-08-18T12:27:20.899Z [JOB] error: password authentication failed for user "wikijs"
wiki_1        | Loading configuration from /wiki/config.yml... OK
wiki_1        | 2020-08-18T12:27:21.466Z [JOB] info: Rendering page ID 26...
wiki_1        | 2020-08-18T12:27:21.795Z [JOB] info: Using database driver pg for postgres [ OK ]
wiki_1        | 2020-08-18T12:27:21.842Z [JOB] error: Rendering page ID 26: [ FAILED ]
wiki_1        | 2020-08-18T12:27:21.842Z [JOB] error: password authentication failed for user "wikijs"
postgresql_1  | LOG:  unexpected EOF on client connection with an open transaction
wiki_1        | Loading configuration from /wiki/config.yml... OK
wiki_1        | 2020-08-18T12:27:22.472Z [JOB] info: Rendering page ID 27...
wiki_1        | 2020-08-18T12:27:22.799Z [JOB] info: Using database driver pg for postgres [ OK ]
wiki_1        | 2020-08-18T12:27:22.821Z [JOB] error: Rendering page ID 27: [ FAILED ]
wiki_1        | 2020-08-18T12:27:22.821Z [JOB] error: password authentication failed for user "wikijs"
wiki_1        | Loading configuration from /wiki/config.yml... OK
wiki_1        | 2020-08-18T12:27:23.413Z [JOB] info: Rendering page ID 28...
wiki_1        | 2020-08-18T12:27:23.723Z [JOB] info: Using database driver pg for postgres [ OK ]
wiki_1        | 2020-08-18T12:27:23.772Z [JOB] error: Rendering page ID 28: [ FAILED ]
wiki_1        | 2020-08-18T12:27:23.772Z [JOB] error: password authentication failed for user "wikijs"
postgresql_1  | LOG:  could not receive data from client: Connection reset by peer
postgresql_1  | LOG:  unexpected EOF on client connection with an open transaction
wiki_1        | Loading configuration from /wiki/config.yml... OK

To Reproduce

1. Edit a page
2. Save the page -> Saving is successful
3. Close page editor.
4. Old page is visible.
5. When editing the page again, the changed content is visible in editor.

Host Info (please complete the following information):

• OS: Docker 19.03.12
• Wiki.js version: 2.4.107
• Database engine: postgres 9.6.19

[NGPixel]

Look at the logs, you have a database connection issue. Make sure your postgres server can accept multiple connections at the same time.

[andlinger]

No. Multiple connections per user are allowed.

SELECT rolname, rolconnlimit FROM pg_roles;
      rolname      | rolconnlimit 
-------------------+--------------
 pg_signal_backend |           -1
 wikijs            |           -1

show max_connections;
 max_connections 
-----------------
 100

[domigi]

Were you able to solve this issue @andlinger?

[domigi]

If anyone is also having similar issues, in my case I missconfigured the docker-compose yml file. I named my db service the same as another db service in the same subnet, which then made the wiki try to connect to the wrong db.
So renaming my db that it has a unique service name resolved it for me :)