Joplin not responding - db: Could not connect

[ethanxrosen]

Hi All,

Joplin on my server hasn't responding the last week or so. So far I've tried app reboot, reconfigure, and a server reboot. It looks like the app has been looping through this error in the logs:

Apr 08 11:19:02 2023-04-08 18:19:02: App: Starting server v2.10.11 (prod) on port 3000 and PID 35...
Apr 08 11:19:02 2023-04-08 18:19:02: App: NTP time offset: -35ms
Apr 08 11:19:02 2023-04-08 18:19:02: App: Running in Docker: true
Apr 08 11:19:02 2023-04-08 18:19:02: App: Public base URL: ___________________
Apr 08 11:19:02 2023-04-08 18:19:02: App: API base URL: _______________
Apr 08 11:19:02 2023-04-08 18:19:02: App: User content base URL: _____________
Apr 08 11:19:02 2023-04-08 18:19:02: App: Log dir: /app/code/packages/server/logs
Apr 08 11:19:02 2023-04-08 18:19:02: App: DB Config: {
Apr 08 11:19:02 client: 'pg',
Apr 08 11:19:02 name: '_____________________',
Apr 08 11:19:02 slowQueryLogEnabled: false,
Apr 08 11:19:02 slowQueryLogMinDuration: 1000,
Apr 08 11:19:02 autoMigration: true,
Apr 08 11:19:02 user: '__________________',
Apr 08 11:19:02 password: '********',
Apr 08 11:19:02 port: 5432,
Apr 08 11:19:02 host: 'postgresql'
Apr 08 11:19:02 }
Apr 08 11:19:02 2023-04-08 18:19:02: App: Mailer Config: {
Apr 08 11:19:02 enabled: true,
Apr 08 11:19:02 host: 'mail',
Apr 08 11:19:02 port: 2525,
Apr 08 11:19:02 security: 'none',
Apr 08 11:19:02 authUser: '____________________________',
Apr 08 11:19:02 authPassword: '********',
Apr 08 11:19:02 noReplyName: 'Joplin',
Apr 08 11:19:02 noReplyEmail: '___________________'
Apr 08 11:19:02 }
Apr 08 11:19:02 2023-04-08 18:19:02: App: Content driver: { type: 1 }
Apr 08 11:19:02 2023-04-08 18:19:02: App: Content driver (fallback): null
Apr 08 11:19:02 2023-04-08 18:19:02: App: Trying to connect to database...
Apr 08 11:19:02 2023-04-08 18:19:02: db: Could not connect. Will try again. Cannot read properties of undefined (reading 'name')
Apr 08 11:19:03 2023-04-08 18:19:03: db: Could not connect. Will try again. Cannot read properties of undefined (reading 'name')
Apr 08 11:19:04 2023-04-08 18:19:04: db: Could not connect. Will try again. Cannot read properties of undefined (reading 'name')
Apr 08 11:19:05 2023-04-08 18:19:05: db: Could not connect. Will try again. Cannot read properties of undefined (reading 'name')
Apr 08 11:19:06 2023-04-08 18:19:06: db: Could not connect. Will try again. Cannot read properties of undefined (reading 'name')
Apr 08 11:19:07 2023-04-08 18:19:07: db: Could not connect. Will try again. Cannot read properties of undefined (reading 'name')
Apr 08 11:19:08 2023-04-08 18:19:08: db: Could not connect. Will try again. Cannot read properties of undefined (reading 'name')
Apr 08 11:19:09 2023-04-08 18:19:09: db: Could not connect. Will try again. Cannot read properties of undefined (reading 'name')
Apr 08 11:19:10 2023-04-08 18:19:10: db: Could not connect. Will try again. Cannot read properties of undefined (reading 'name')
Apr 08 11:19:11 2023-04-08 18:19:11: db: Could not connect. Will try again. Cannot read properties of undefined (reading 'name')
Apr 08 11:19:12 2023-04-08 18:19:12: db: Could not connect. Will try again. Cannot read properties of undefined (reading 'name')
Apr 08 11:19:13 2023-04-08 18:19:13: db: Could not connect. Will try again. Cannot read properties of undefined (reading 'name')
Apr 08 11:19:14 2023-04-08 18:19:14: db: Could not connect. Will try again. Cannot read properties of undefined (reading 'name')
Apr 08 11:19:15 2023-04-08 18:19:15: db: Could not connect. Will try again. Cannot read properties of undefined (reading 'name')
Apr 08 11:19:16 2023-04-08 18:19:16: db: Could not connect. Will try again. Cannot read properties of undefined (reading 'name')
Apr 08 11:19:17 2023-04-08 18:19:17: db: Could not connect. Will try again. Cannot read properties of undefined (reading 'name')
Apr 08 11:19:18 2023-04-08 18:19:18: db: Could not connect. Will try again. Cannot read properties of undefined (reading 'name')
Apr 08 11:19:19 2023-04-08 18:19:19: db: Could not connect. Will try again. Cannot read properties of undefined (reading 'name')
Apr 08 11:19:20 2023-04-08 18:19:20: db: Could not connect. Will try again. Cannot read properties of undefined (reading 'name')
Apr 08 11:19:21 2023-04-08 18:19:21: db: Could not connect. Will try again. Cannot read properties of undefined (reading 'name')
Apr 08 11:19:22 2023-04-08 18:19:22: db: Could not connect. Will try again. Cannot read properties of undefined (reading 'name')
Apr 08 11:19:23 2023-04-08 18:19:23: db: Could not connect. Will try again. Cannot read properties of undefined (reading 'name')
Apr 08 11:19:24 2023-04-08 18:19:24: db: Could not connect. Will try again. Cannot read properties of undefined (reading 'name')
Apr 08 11:19:25 2023-04-08 18:19:25: db: Could not connect. Will try again. Cannot read properties of undefined (reading 'name')
Apr 08 11:19:26 2023-04-08 18:19:26: db: Could not connect. Will try again. Cannot read properties of undefined (reading 'name')
Apr 08 11:19:27 2023-04-08 18:19:27: db: Could not connect. Will try again. Cannot read properties of undefined (reading 'name')
Apr 08 11:19:28 2023-04-08 18:19:28: db: Could not connect. Will try again. Cannot read properties of undefined (reading 'name')
Apr 08 11:19:29 2023-04-08 18:19:29: db: Could not connect. Will try again. Cannot read properties of undefined (reading 'name')
Healtheck error: Error: connect ECONNREFUSED 172.18.18.23:30002023-04-08T18:19:30.000Z 2023-04-08 18:19:30: db: Could not connect. Will try again. Cannot read properties of undefined (reading 'name')
Apr 08 11:19:31 2023-04-08 18:19:31: db: Could not connect. Will try again. Cannot read properties of undefined (reading 'name')
Apr 08 11:19:32 2023-04-08 18:19:32: db: Could not connect. Will try again. Cannot read properties of undefined (reading 'name')
Apr 08 11:19:32 2023-04-08 18:19:32: [error] db: Timeout trying to connect to database: TypeError: Cannot read properties of undefined (reading 'name')
Apr 08 11:19:32 at /app/code/packages/server/src/db.ts:411:25
Apr 08 11:19:32 at Generator.next (<anonymous>)
Apr 08 11:19:32 at fulfilled (/app/code/packages/server/dist/db.js:5:58)
Apr 08 11:19:32 at processTicksAndRejections (node:internal/process/task_queues:95:5)
Apr 08 11:19:32 Error: Timeout trying to connect to database. Last error was: Cannot read properties of undefined (reading 'name')
Apr 08 11:19:32 at /app/code/packages/server/src/db.ts:118:10
Apr 08 11:19:32 at Generator.next (<anonymous>)
Apr 08 11:19:32 at fulfilled (/app/code/packages/server/dist/db.js:5:58)
Apr 08 11:19:32 at processTicksAndRejections (node:internal/process/task_queues:95:5)

Does anyone have advice on how to get it working again?

[robi]

@ethanxrosen did you check your services from the UI?

Are all green?

[girish]

@ethanxrosen which version of Cloudron are you on?

[ethanxrosen]

@robi yep all services are showing up green and my other apps are generally working fine

@girish 7.4.0. It was actually near the time of the update (~apr 2) joplin started behaving weirdly, not sure if these could be related

[ethanxrosen]

@girish, are there any other logs / info that would be helpful or things I could try on my end?

[girish]

@ethanxrosen is this a new install? does a new install of joplin work? It seems that the env file is missing or corrupt or empty. Can you check using the File manager the contents of /app/data/config ?

[ethanxrosen]

@girish this was an old install, and it looks like a new install works OK

there's one extra line in the new config vs old:

# add custom configuration here. be sure to restart the app if you edit this file
# https://github.com/laurent22/joplin/blob/dev/packages/server/src/env.ts

SIGNUP_ENABLED=0
TERMS_ENABLED=0
MAX_TIME_DRIFT=100 <--- wasn't in old install

I tried copying it over to see what it would do but the app still seems unresponsive. When i try cloning from backup the same error appears. Is there a way to repair / restore the env file?

[girish]

@ethanxrosen can you update to 7.4.1 and check if the restore works? Otherwise, can you reach out on support@cloudron.io ? I can't quite make out what the problem is.