I decided to deploy my joplin server. Most of the notes were uploaded to the server, but then the download stopped
It seems that some file is not being uploaded to the server. In the logs everything went in cycles.
Here is a piece of logs, such a piece is cyclically repeated
pp_1 | > @joplin/server@2.4.8 start
app_1 | > node dist/app.js
app_1 |
app_1 | 2021-09-25 17:34:58: App: Starting server v2.4.8 (prod) on port 22300 and PID 20...
app_1 | 2021-09-25 17:34:58: App: Running in Docker: true
app_1 | 2021-09-25 17:34:58: App: Public base URL: http://notes.domen.ru:22300
app_1 | 2021-09-25 17:34:58: App: API base URL: http://notes.domen.ru:22300
app_1 | 2021-09-25 17:34:58: App: User content base URL: http://notes.domen.ru:22300
app_1 | 2021-09-25 17:34:58: App: Log dir: /home/joplin/packages/server/logs
app_1 | 2021-09-25 17:34:58: App: DB Config: {
app_1 | client: 'pg',
app_1 | name: 'joplinbase',
app_1 | slowQueryLogEnabled: false,
app_1 | slowQueryLogMinDuration: 10000,
app_1 | user: 'joplin',
app_1 | password: '',
app_1 | port: 5432,
app_1 | host: 'db'
app_1 | }
app_1 | 2021-09-25 17:34:58: App: Trying to connect to database...
app_1 | 2021-09-25 17:34:58: App: Connection check: {
app_1 | latestMigration: { name: '20190913171451_create.js' },
app_1 | isCreated: true,
app_1 | error: null
app_1 | }
app_1 | 2021-09-25 17:35:00: App: Migrating database...
app_1 | 2021-09-25 17:35:00: App: Starting services...
app_1 | 2021-09-25 17:35:00: ShareService: Starting maintenance...
app_1 | 2021-09-25 17:35:00: EmailService: Service will be disabled because mailer config is not set or is explicitly disabled
app_1 | 2021-09-25 17:35:00: App: Call this for testing:curl http://notes.domen.ru:22300/api/ping
app_1 | 2021-09-25 17:35:00: ShareService: Maintenance completed in 118ms
app_1 | 2021-09-25 17:38:33: App: GET /api/items/root:/info.json:/content (74ms)
app_1 | 2021-09-25 17:38:33: App: GET /api/items/root:/locks/:/children (284ms)
app_1 | 2021-09-25 17:38:33: App: GET /api/items/root:/locks/:/children (276ms)
app_1 | 2021-09-25 17:38:33: App: PUT /api/items/root:/locks/sync_desktop_07c0cb13b8dc42db9a0869c5e0d5a615.json:/content (99ms)
app_1 | 2021-09-25 17:38:33: App: GET /api/items/root:/locks/:/children (32ms)
app_1 | 2021-09-25 17:38:33: App: GET /api/items/root:/locks/:/children (33ms)
app_1 | 2021-09-25 17:39:34: App: GET /api/items/root:/locks/:/children (46ms)
app_1 | 2021-09-25 17:39:34: App: GET /api/items/root:/locks/:/children (85ms)
app_1 | 2021-09-25 17:39:34: App: GET /api/items/root:/locks/:/children (96ms)
app_1 | 2021-09-25 17:39:34: App: PUT /api/items/root:/locks/sync_desktop_07c0cb13b8dc42db9a0869c5e0d5a615.json:/content (28ms)
app_1 | 2021-09-25 17:39:58: [error] App: ::ffff:213.248.13.186 Error: insert into "items" ("content", "content_size", "created_time", "id", "mime_type", "name", "updated_time") values ($1, $2, $3, $4, $5, $6, $7) - Connection terminated unexpectedly
app_1 | at Connection. (/home/joplin/packages/server/node_modules/pg/lib/client.js:132:73)
app_1 | 2021-09-25 17:39:58: App: PUT /api/items/root:/.resource/258c4b3b4acf4f76a283a96320097ba0:/content (83045ms)
app_1 | at Object.onceWrapper (node:events:513:28)
app_1 | at Connection.emit (node:events:394:28)
app_1 | at Socket. (/home/joplin/packages/server/node_modules/pg/lib/connection.js:108:12)
app_1 | at Socket.emit (node:events:406:35)
app_1 | at endReadableNT (node:internal/streams/readable:1343:12)
app_1 | at processTicksAndRejections (node:internal/process/task_queues:83:21)
app_1 | Connection Error: Connection ended unexpectedly
app_1 | Connection Error: Connection ended unexpectedly
app_1 | 2021-09-25 17:40:34: App: GET /api/items/root:/locks/:/children (475ms)
app_1 | 2021-09-25 17:40:34: App: GET /api/items/root:/locks/:/children (32ms)
app_1 | 2021-09-25 17:40:34: App: GET /api/items/root:/locks/:/children (48ms)
app_1 | 2021-09-25 17:40:34: App: PUT /api/items/root:/locks/sync_desktop_07c0cb13b8dc42db9a0869c5e0d5a615.json:/content (74ms)
app_1 | 2021-09-25 17:41:07: [error] App: ::ffff:213.248.13.186 Error: insert into "items" ("content", "content_size", "created_time", "id", "mime_type", "name", "updated_time") values ($1, $2, $3, $4, $5, $6, $7) - Connection terminated unexpectedly
app_1 | at Connection. (/home/joplin/packages/server/node_modules/pg/lib/client.js:132:73)
app_1 | at Object.onceWrapper (node:events:513:28)
app_1 | at Connection.emit (node:events:394:28)
app_1 | at Socket. (/home/joplin/packages/server/node_modules/pg/lib/connection.js:108:12)
app_1 | at Socket.emit (node:events:406:35)
app_1 | at endReadableNT (node:internal/streams/readable:1343:12)
app_1 | at processTicksAndRejections (node:internal/process/task_queues:83:21)
app_1 | 2021-09-25 17:41:07: App: PUT /api/items/root:/.resource/258c4b3b4acf4f76a283a96320097ba0:/content (64415ms)
app_1 | Connection Error: Connection ended unexpectedly
app_1 | Connection Error: Connection ended unexpectedly
app_1 | 2021-09-25 17:41:34: App: GET /api/items/root:/locks/:/children (425ms)
app_1 | 2021-09-25 17:41:34: App: GET /api/items/root:/locks/:/children (26ms)
app_1 | 2021-09-25 17:41:34: App: GET /api/items/root:/locks/:/children (41ms)
app_1 | 2021-09-25 17:41:34: App: PUT /api/items/root:/locks/sync_desktop_07c0cb13b8dc42db9a0869c5e0d5a615.json:/content (95ms)
app_1 | 2021-09-25 17:42:11: [error] App: ::ffff:213.248.13.186 Error: insert into "items" ("content", "content_size", "created_time", "id", "mime_type", "name", "updated_time") values ($1, $2, $3, $4, $5, $6, $7) - Connection terminated unexpectedly
app_1 | at Connection. (/home/joplin/packages/server/node_modules/pg/lib/client.js:132:73)
app_1 | at Object.onceWrapper (node:events:513:28)
app_1 | at Connection.emit (node:events:394:28)
app_1 | at Socket. (/home/joplin/packages/server/node_modules/pg/lib/connection.js:108:12)
app_1 | at Socket.emit (node:events:406:35)
app_1 | at endReadableNT (node:internal/streams/readable:1343:12)
app_1 | at processTicksAndRejections (node:internal/process/task_queues:83:21)
app_1 | 2021-09-25 17:42:11: App: PUT /api/items/root:/.resource/258c4b3b4acf4f76a283a96320097ba0:/content (56538ms)
app_1 | Connection Error: Connection ended unexpectedly
app_1 | Connection Error: Connection ended unexpectedly
app_1 | 2021-09-25 17:42:34: App: GET /api/items/root:/locks/:/children (431ms)
app_1 | 2021-09-25 17:42:34: App: GET /api/items/root:/locks/:/children (45ms)
app_1 | 2021-09-25 17:42:34: App: GET /api/items/root:/locks/:/children (45ms)
app_1 | 2021-09-25 17:42:34: App: PUT /api/items/root:/locks/sync_desktop_07c0cb13b8dc42db9a0869c5e0d5a615.json:/content (57ms)
app_1 | Killed
db_1 | 2021-09-25 17:43:38.361 UTC [66] LOG: unexpected EOF on client connection with an open transaction
app_1 |
app_1 | > @joplin/server@2.4.8 start
app_1 | > node dist/app.js
app_1 |
app_1 | 2021-09-25 17:43:52: App: Starting server v2.4.8 (prod) on port 22300 and PID 19...
app_1 | 2021-09-25 17:43:52: App: Running in Docker: true
app_1 | 2021-09-25 17:43:52: App: Public base URL: http://notes.domen.ru:22300
app_1 | 2021-09-25 17:43:52: App: API base URL: http://notes.domen.ru:22300
app_1 | 2021-09-25 17:43:52: App: User content base URL: http://notes.domen.ru:22300
app_1 | 2021-09-25 17:43:52: App: Log dir: /home/joplin/packages/server/logs
app_1 | 2021-09-25 17:43:52: App: DB Config: {
app_1 | client: 'pg',
app_1 | name: 'joplinbase',
app_1 | slowQueryLogEnabled: false,
app_1 | slowQueryLogMinDuration: 10000,
app_1 | user: 'joplin',
app_1 | password: '',
app_1 | port: 5432,
app_1 | host: 'db'
app_1 | }
app_1 | 2021-09-25 17:43:52: App: Trying to connect to database...
app_1 | 2021-09-25 17:43:53: App: Connection check: {
app_1 | latestMigration: { name: '20190913171451_create.js' },
app_1 | isCreated: true,
app_1 | error: null
app_1 | }
app_1 | 2021-09-25 17:43:54: App: Migrating database...
app_1 | 2021-09-25 17:43:54: App: Starting services...
app_1 | 2021-09-25 17:43:54: ShareService: Starting maintenance...
app_1 | 2021-09-25 17:43:54: EmailService: Service will be disabled because mailer config is not set or is explicitly disabled
app_1 | 2021-09-25 17:43:54: App: Call this for testing:curl http://notes.domen.ru:22300/api/ping
app_1 | 2021-09-25 17:43:54: ShareService: Maintenance completed in 107ms
app_1 | 2021-09-25 17:43:57: App: DELETE /api/items/root:/locks/sync_desktop_07c0cb13b8dc42db9a0869c5e0d5a615.json: (113ms)
app_1 | 2021-09-25 17:43:57: App: GET /api/share_users (7ms)
app_1 | 2021-09-25 17:43:58: App: GET /api/shares (1ms)
app_1 | 2021-09-25 17:43:59: App: GET /api/items/root:/locks/:/children (234ms)
app_1 | 2021-09-25 17:43:59: App: PUT /api/items/root:/temp/timeCheck910829.txt:/content (86ms)
app_1 | 2021-09-25 17:43:59: App: GET /api/items/root:/temp/timeCheck910829.txt: (2ms)
app_1 | 2021-09-25 17:43:59: App: DELETE /api/items/root:/temp/timeCheck910829.txt: (32ms)
app_1 | 2021-09-25 17:44:21: App: GET /api/items/root:/info.json:/content (19ms)
app_1 | 2021-09-25 17:44:21: App: GET /api/items/root:/locks/:/children (46ms)
app_1 | 2021-09-25 17:44:21: App: GET /api/items/root:/locks/:/children (60ms)
app_1 | 2021-09-25 17:44:21: App: PUT /api/items/root:/locks/sync_desktop_07c0cb13b8dc42db9a0869c5e0d5a615.json:/content (44ms)
app_1 | 2021-09-25 17:44:22: App: GET /api/items/root:/locks/:/children (28ms)
app_1 | 2021-09-25 17:44:22: App: GET /api/items/root:/locks/:/children (19ms)
app_1 | 2021-09-25 17:45:22: App: GET /api/items/root:/locks/:/children (36ms)
app_1 | 2021-09-25 17:45:22: App: GET /api/items/root:/locks/:/children (22ms)
app_1 | 2021-09-25 17:45:22: App: GET /api/items/root:/locks/:/children (23ms)
app_1 | 2021-09-25 17:45:22: App: PUT /api/items/root:/locks/sync_desktop_07c0cb13b8dc42db9a0869c5e0d5a615.json:/content (25ms)
app_1 | Killed
db_1 | 2021-09-25 17:45:47.248 UTC [68] LOG: unexpected EOF on client connection with an open transaction
joplin-witnout-nginx_app_1 exited with code 137
app_1 |
What should I do?
The server was overloading, but it didn't help