Front page displays errors

Zekovski

Hello !
I'm new to hosting services at home and set my instance some days ago.
I installed it the Debian way on a raspberry 3B+, and data is stored on an external disc.
Since the beginning, the website displays some errors and is a bit clanky, but it was ok. Yesterday I realized that decreasing the number of workers to 2 made the site much more stable. But one hour later it began to display more errors and the data (new albums and recently listened) sometimes doesn't show. Also my phone app doesn't show artists anymore. Maybe because of one of my imports ? I'm not sure it's related to the workers becase everything was fine for a time. Who knows ...

The journalctl log is not much of help for me because I only know how to read it to some extent. Would anyone here take some time to help me ?
Here are my console logs from Firefox (sorry for the dump) ...

GET
https://musique.XXX.fr/library
[HTTP/2 304 Not Modified 138ms]

  [Sat, 03 Feb 2024 10:30:42 GMT]   INFO  /assets/index-53eff6ae.js:34 O="",A=Math.min()  Websocket status: CLOSED index-53eff6ae.js:34:6411
InstallTrigger est obsolète et sera supprimé prochainement. constants.js:50:14
Content-Security-Policy : Les paramètres de la page ont empêché le chargement d’une ressource à inline (« script-src »). utils.js:42:9
Content-Security-Policy : Les paramètres de la page ont empêché le chargement d’une ressource à inline (« script-src »). content-script.js:40:65

[...]

Un AudioContext n’a pas pu démarrer automatiquement. Il doit être créé ou repris après un geste de l’utilisateur sur la page. audio-context-constructor.js:11:37
Un AudioContext n’a pas pu démarrer automatiquement. Il doit être créé ou repris après un geste de l’utilisateur sur la page. 9 audio-listener-factory.js:71:35

[...]

  [Sat, 03 Feb 2024 10:30:42 GMT]   WARN  /assets/index-53eff6ae.js:34 O="",A=Math.min()  Invalid VUE_APP_INSTANCE_URL, falling back to current url TypeError: URL constructor: undefined is not a valid URL.
    <anonymous> instance.ts:131
useLogger.ts:72:6
  [Sat, 03 Feb 2024 10:30:42 GMT]   INFO  /assets/index-53eff6ae.js:34 O="",A=Math.min()  Loading environment: production useLogger.ts:72:6
GET
wss://musique.XXX.fr/api/v1/activity
[HTTP/1.1 101 Switching Protocols 163ms]

GET
https://musique.XXX.fr/assets/fr_FR-4f655f21.js
[HTTP/1.1 200 OK 0ms]

GET
https://musique.XXX.fr/assets/workbox-window.prod.es5-42ea5fe7.js
[HTTP/1.1 200 OK 0ms]

XHRGET
https://musique.XXX.fr/assets/vue-router-dc26212d.js
[HTTP/1.1 200 OK 0ms]

GET
https://musique.XXX.fr/assets/App-9117e02a.js
[HTTP/1.1 200 OK 0ms]

  [Sat, 03 Feb 2024 10:30:43 GMT]   INFO  /assets/index-53eff6ae.js:34 O="",A=Math.min()  Successfully fetched instance settings useLogger.ts:72:6
XHRGET
https://musique.XXX.fr/assets/vue-router-dc26212d.js.map
[HTTP/2 200 OK 0ms]

  [Sat, 03 Feb 2024 10:30:44 GMT]   INFO  /assets/index-53eff6ae.js:34 O="",A=Math.min()  Service worker has been registered. useLogger.ts:72:6
  [Sat, 03 Feb 2024 10:30:43 GMT]   INFO  /assets/index-53eff6ae.js:34 O="",A=Math.min()  Websocket status: CONNECTING useLogger.ts:72:6
  [Sat, 03 Feb 2024 10:30:43 GMT]   INFO  /assets/index-53eff6ae.js:34 O="",A=Math.min()  Everything loaded! useLogger.ts:72:6
  [Sat, 03 Feb 2024 10:30:44 GMT]   INFO  /assets/index-53eff6ae.js:34 O="",A=Math.min()  Websocket status: OPEN useLogger.ts:72:6

[...]

XHRGET
https://musique.XXX.fr/api/v1/users/me/
[HTTP/1.1 200 OK 0ms]

XHRGET
https://musique.XXX.fr/api/v1/channels/?ordering=-creation_date&external=false&page_size=12&include_channels=true
[HTTP/1.1 405 Method Not Allowed 0ms]

XHRGET
https://musique.XXX.fr/assets/App-9117e02a.js
[HTTP/1.1 200 OK 0ms]

XHRGET
https://musique.XXX.fr/api/v1/federation/inbox/?is_read=false&page_size=1
[HTTP/1.1 200 OK 0ms]

XHRGET
https://musique.XXX.fr/assets/App-9117e02a.js.map
[HTTP/2 200 OK 0ms]

  [Sat, 03 Feb 2024 10:30:45 GMT]   INFO  /assets/index-53eff6ae.js:34 O="",A=Math.min()  Successfully fetched user profile useLogger.ts:72:6
XHRGET
https://musique.XXX.fr/api/v1/mutations/?is_approved=null&page_size=1
[HTTP/1.1 200 OK 0ms]

XHRGET
https://musique.XXX.fr/api/v1/manage/moderation/reports/?is_handled=false&page_size=1
[HTTP/1.1 200 OK 0ms]

XHRGET
https://musique.XXX.fr/api/v1/manage/moderation/requests/?status=pending&page_size=1
[HTTP/1.1 200 OK 0ms]

XHRGET
https://musique.XXX.fr/api/v1/federation/follows/library/all/
[HTTP/1.1 200 OK 0ms]

XHRGET
https://musique.XXX.fr/api/v1/subscriptions/all/
[HTTP/1.1 405 Method Not Allowed 0ms]

XHRGET
https://musique.XXX.fr/api/v1/moderation/content-filters/?page_size=100&ordering=-creation_date
[HTTP/1.1 200 OK 0ms]

XHRGET
https://musique.XXX.fr/api/v1/playlists/?scope=me
[HTTP/1.1 200 OK 0ms]

  [Sat, 03 Feb 2024 10:30:46 GMT]  ERROR  /assets/index-53eff6ae.js:34 O="",A=Math.min()  Error while fetching user profile 
Object { stack: "E@https://musique.XXX.fr/assets/axios-3a517bc4.js:1:4747\nBt@https://musique.XXX.fr/assets/axios-3a517bc4.js:3:937\nf@https://musique.XXX.fr/assets/axios-3a517bc4.js:3:4029\nEventHandlerNonNull*vt</<@https://musique.XXX.fr/assets/axios-3a517bc4.js:3:4087\nvt<@https://musique.XXX.fr/assets/axios-3a517bc4.js:3:3202\nce@https://musique.XXX.fr/assets/axios-3a517bc4.js:3:6504\npromise callback*request@https://musique.XXX.fr/assets/axios-3a517bc4.js:3:9941\nk.prototype[t]@https://musique.XXX.fr/assets/axios-3a517bc4.js:3:10381\nfe/<@https://musique.XXX.fr/assets/axios-3a517bc4.js:1:45\nfetchSubscriptions@https://musique.XXX.fr/assets/index-53eff6ae.js:34:12704\ngd/<@https://musique.XXX.fr/assets/index-53eff6ae.js:25:2512\nGe.prototype.dispatch@https://musique.XXX.fr/assets/index-53eff6ae.js:25:10056\nGe/this.dispatch@https://musique.XXX.fr/assets/index-53eff6ae.js:25:9028\npd/o.dispatch<@https://musique.XXX.fr/assets/index-53eff6ae.js:25:1726\nfetchUser@https://musique.XXX.fr/assets/index-53eff6ae.js:34:48890\nasync*gd/<@https://musique.XXX.fr/assets/index-53eff6ae.js:25:2512\nGe.prototype.dispatch@https://musique.XXX.fr/assets/index-53eff6ae.js:25:10056\nGe/this.dispatch@https://musique.XXX.fr/assets/index-53eff6ae.js:25:9028\nsetup@https://musique.XXX.fr/assets/App-9117e02a.js:1:5965\nGe@https://musique.XXX.fr/assets/vue-router-dc26212d.js:1:13923\nBa@https://musique.XXX.fr/assets/vue-router-dc26212d.js:1:66182\nTl@https://musique.XXX.fr/assets/vue-router-dc26212d.js:1:65965\nie@https://musique.XXX.fr/assets/vue-router-dc26212d.js:1:53169\nY@https://musique.XXX.fr/assets/vue-router-dc26212d.js:1:53060\nT@https://musique.XXX.fr/assets/vue-router-dc26212d.js:1:50005\nS@https://musique.XXX.fr/assets/vue-router-dc26212d.js:1:53702\nrun@https://musique.XXX.fr/assets/vue-router-dc26212d.js:1:4485\nU/d.update@https://musique.XXX.fr/assets/vue-router-dc26212d.js:1:54402\nGe@https://musique.XXX.fr/assets/vue-router-dc26212d.js:1:13931\nUi@https://musique.XXX.fr/assets/vue-router-dc26212d.js:1:15615\npromise callback*Di@https://musique.XXX.fr/assets/vue-router-dc26212d.js:1:14892\nCs@https://musique.XXX.fr/assets/vue-router-dc26212d.js:1:14849\nU/d.effect<@https://musique.XXX.fr/assets/vue-router-dc26212d.js:1:54372\nmo@https://musique.XXX.fr/assets/vue-router-dc26212d.js:1:6032\n", message: "Request failed with status code 405", name: "AxiosError", code: "ERR_BAD_REQUEST", config: {…}, request: XMLHttpRequest, response: {…}, backendErrors: (1) […], isHandled: false }
useLogger.ts:72:6
  [Sat, 03 Feb 2024 10:30:46 GMT]   INFO  /assets/index-53eff6ae.js:34 O="",A=Math.min()  Fetched a batch of 0 filters useLogger.ts:72:6
XHRGET
https://musique.XXX.fr/api/v1/artists/?ordering=-creation_date&playable=true
[HTTP/1.1 500 Internal Server Error 0ms]

XHRGET
https://musique.XXX.fr/assets/Home-424b83ad.js
[HTTP/1.1 200 OK 0ms]

XHRGET
https://musique.XXX.fr/api/v1/history/listenings/?scope=all&ordering=-creation_date&page_size=5
[HTTP/1.1 500 Internal Server Error 0ms]

XHRGET
https://musique.XXX.fr/assets/Widget.vue_vue_type_script_setup_true_lang-df7542a3.js
[HTTP/1.1 200 OK 0ms]

XHRGET
https://musique.XXX.fr/assets/Home-424b83ad.js.map
[HTTP/2 200 OK 0ms]

XHRGET
https://musique.XXX.fr/api/v1/favorites/tracks/?scope=all&ordering=-creation_date&page_size=5
[HTTP/1.1 500 Internal Server Error 0ms]

XHRGET
https://musique.XXX.fr/api/v1/playlists/?scope=all&playable=true&ordering=-modification_date&page_size=3
[HTTP/1.1 500 Internal Server Error 0ms]

XHRGET
https://musique.XXX.fr/api/v1/albums/?q=&scope=all&playable=true&ordering=-creation_date&page_size=12
[HTTP/1.1 500 Internal Server Error 0ms]

  [Sat, 03 Feb 2024 10:30:49 GMT]  ERROR  /assets/index-53eff6ae.js:34 O="",A=Math.min()  Unexpected API error 
Object { stack: "E@https://musique.XXX.fr/assets/axios-3a517bc4.js:1:4747\nBt@https://musique.XXX.fr/assets/axios-3a517bc4.js:3:937\nf@https://musique.XXX.fr/assets/axios-3a517bc4.js:3:4029\nEventHandlerNonNull*vt</<@https://musique.XXX.fr/assets/axios-3a517bc4.js:3:4087\nvt<@https://musique.XXX.fr/assets/axios-3a517bc4.js:3:3202\nce@https://musique.XXX.fr/assets/axios-3a517bc4.js:3:6504\npromise callback*request@https://musique.XXX.fr/assets/axios-3a517bc4.js:3:9941\nk.prototype[t]@https://musique.XXX.fr/assets/axios-3a517bc4.js:3:10381\nfe/<@https://musique.XXX.fr/assets/axios-3a517bc4.js:1:45\nsetup/<@https://musique.XXX.fr/assets/Home-424b83ad.js:1:1605\nsetup@https://musique.XXX.fr/assets/Home-424b83ad.js:1:1685\nGe@https://musique.XXX.fr/assets/vue-router-dc26212d.js:1:13923\nBa@https://musique.XXX.fr/assets/vue-router-dc26212d.js:1:66182\nTl@https://musique.XXX.fr/assets/vue-router-dc26212d.js:1:65965\nie@https://musique.XXX.fr/assets/vue-router-dc26212d.js:1:53169\nY@https://musique.XXX.fr/assets/vue-router-dc26212d.js:1:53060\nT@https://musique.XXX.fr/assets/vue-router-dc26212d.js:1:50005\nS@https://musique.XXX.fr/assets/vue-router-dc26212d.js:1:54134\nrun@https://musique.XXX.fr/assets/vue-router-dc26212d.js:1:4485\nU/d.update@https://musique.XXX.fr/assets/vue-router-dc26212d.js:1:54402\nU@https://musique.XXX.fr/assets/vue-router-dc26212d.js:1:54428\nie@https://musique.XXX.fr/assets/vue-router-dc26212d.js:1:53266\nY@https://musique.XXX.fr/assets/vue-router-dc26212d.js:1:53060\nT@https://musique.XXX.fr/assets/vue-router-dc26212d.js:1:50005\nA@https://musique.XXX.fr/assets/vue-router-dc26212d.js:1:51413\nF@https://musique.XXX.fr/assets/vue-router-dc26212d.js:1:50730\nC@https://musique.XXX.fr/assets/vue-router-dc26212d.js:1:50549\nT@https://musique.XXX.fr/assets/vue-router-dc26212d.js:1:49980\nS@https://musique.XXX.fr/assets/vue-router-dc26212d.js:1:54134\nrun@https://musique.XXX.fr/assets/vue-router-dc26212d.js:1:4485\nU/d.update@https://musique.XXX.fr/assets/vue-router-dc26212d.js:1:54402\nU@https://musique.XXX.fr/assets/vue-router-dc26212d.js:1:54428\nie@https://musique.XXX.fr/assets/vue-router-dc26212d.js:1:53266\nY@https://musique.XXX.fr/assets/vue-router-dc26212d.js:1:53060\nT@https://musique.XXX.fr/assets/vue-router-dc26212d.js:1:50005\nIu@https://musique.XXX.fr/assets/vue-router-dc26212d.js:1:19798\n", message: "Request failed with status code 500", name: "AxiosError", code: "ERR_BAD_RESPONSE", config: {…}, request: XMLHttpRequest, response: {…}, backendErrors: (1) […], isHandled: false }
 
Array [ "A server error occurred" ]
useLogger.ts:72:6
XHRGET
https://musique.XXX.fr/api/v1/playlists/?scope=me
[HTTP/1.1 500 Internal Server Error 0ms]

XHRGET
https://musique.XXX.fr/assets/Widget.vue_vue_type_script_setup_true_lang-df7542a3.js.map
[HTTP/2 200 OK 0ms]

XHRGET
https://musique.XXX.fr/api/v1/favorites/tracks/all/?user=1&page_size=50&ordering=-creation_date
[HTTP/1.1 500 Internal Server Error 0ms]

XHRGET
https://musique.XXX.fr/assets/Widget.vue_vue_type_script_setup_true_lang-5d8b300b.js
[HTTP/1.1 200 OK 0ms]

XHRGET
https://musique.XXX.fr/assets/Widget.vue_vue_type_script_setup_true_lang-8a21db3c.js
[HTTP/1.1 200 OK 0ms]

  [Sat, 03 Feb 2024 10:30:49 GMT]  ERROR  /assets/index-53eff6ae.js:34 O="",A=Math.min()  Unexpected API error 
Object { stack: "E@https://musique.XXX.fr/assets/axios-3a517bc4.js:1:4747\nBt@https://musique.XXX.fr/assets/axios-3a517bc4.js:3:937\nf@https://musique.XXX.fr/assets/axios-3a517bc4.js:3:4029\nEventHandlerNonNull*vt</<@https://musique.XXX.fr/assets/axios-3a517bc4.js:3:4087\nvt<@https://musique.XXX.fr/assets/axios-3a517bc4.js:3:3202\nce@https://musique.XXX.fr/assets/axios-3a517bc4.js:3:6504\npromise callback*request@https://musique.XXX.fr/assets/axios-3a517bc4.js:3:9941\nk.prototype[t]@https://musique.XXX.fr/assets/axios-3a517bc4.js:3:10381\nfe/<@https://musique.XXX.fr/assets/axios-3a517bc4.js:1:45\n$@https://musique.XXX.fr/assets/Widget.vue_vue_type_script_setup_true_lang-df7542a3.js:1:1776\nsetup/<@https://musique.XXX.fr/assets/Widget.vue_vue_type_script_setup_true_lang-df7542a3.js:1:1992\nGe@https://musique.XXX.fr/assets/vue-router-dc26212d.js:1:13923\nIe@https://musique.XXX.fr/assets/vue-router-dc26212d.js:1:14003\nB@https://musique.XXX.fr/assets/vue-router-dc26212d.js:1:24707\nLn@https://musique.XXX.fr/assets/vue-router-dc26212d.js:1:24914\npt@https://musique.XXX.fr/assets/vue-router-dc26212d.js:1:23912\nsetup@https://musique.XXX.fr/assets/Widget.vue_vue_type_script_setup_true_lang-df7542a3.js:1:1953\nGe@https://musique.XXX.fr/assets/vue-router-dc26212d.js:1:13923\nBa@https://musique.XXX.fr/assets/vue-router-dc26212d.js:1:66182\nTl@https://musique.XXX.fr/assets/vue-router-dc26212d.js:1:65965\nie@https://musique.XXX.fr/assets/vue-router-dc26212d.js:1:53169\nY@https://musique.XXX.fr/assets/vue-router-dc26212d.js:1:53060\nT@https://musique.XXX.fr/assets/vue-router-dc26212d.js:1:50005\nA@https://musique.XXX.fr/assets/vue-router-dc26212d.js:1:51413\nF@https://musique.XXX.fr/assets/vue-router-dc26212d.js:1:50730\nC@https://musique.XXX.fr/assets/vue-router-dc26212d.js:1:50549\nT@https://musique.XXX.fr/assets/vue-router-dc26212d.js:1:49980\nA@https://musique.XXX.fr/assets/vue-router-dc26212d.js:1:51413\nF@https://musique.XXX.fr/assets/vue-router-dc26212d.js:1:50730\nC@https://musique.XXX.fr/assets/vue-router-dc26212d.js:1:50549\nT@https://musique.XXX.fr/assets/vue-router-dc26212d.js:1:49980\nA@https://musique.XXX.fr/assets/vue-router-dc26212d.js:1:51413\nF@https://musique.XXX.fr/assets/vue-router-dc26212d.js:1:50730\nC@https://musique.XXX.fr/assets/vue-router-dc26212d.js:1:50549\nT@https://musique.XXX.fr/assets/vue-router-dc26212d.js:1:49980\nA@https://musique.XXX.fr/assets/vue-router-dc26212d.js:1:51413\n", message: "Request failed with status code 500", name: "AxiosError", code: "ERR_BAD_RESPONSE", config: {…}, request: XMLHttpRequest, response: {…}, backendErrors: (1) […], isHandled: false }
 
Array [ "A server error occurred" ]
useLogger.ts:72:6
  [Sat, 03 Feb 2024 10:30:50 GMT]  ERROR  /assets/index-53eff6ae.js:34 O="",A=Math.min()  Unexpected API error 
Object { stack: "E@https://musique.XXX.fr/assets/axios-3a517bc4.js:1:4747\nBt@https://musique.XXX.fr/assets/axios-3a517bc4.js:3:937\nf@https://musique.XXX.fr/assets/axios-3a517bc4.js:3:4029\nEventHandlerNonNull*vt</<@https://musique.XXX.fr/assets/axios-3a517bc4.js:3:4087\nvt<@https://musique.XXX.fr/assets/axios-3a517bc4.js:3:3202\nce@https://musique.XXX.fr/assets/axios-3a517bc4.js:3:6504\npromise callback*request@https://musique.XXX.fr/assets/axios-3a517bc4.js:3:9941\nk.prototype[t]@https://musique.XXX.fr/assets/axios-3a517bc4.js:3:10381\nfe/<@https://musique.XXX.fr/assets/axios-3a517bc4.js:1:45\n$@https://musique.XXX.fr/assets/Widget.vue_vue_type_script_setup_true_lang-df7542a3.js:1:1776\nsetup/<@https://musique.XXX.fr/assets/Widget.vue_vue_type_script_setup_true_lang-df7542a3.js:1:1992\nGe@https://musique.XXX.fr/assets/vue-router-dc26212d.js:1:13923\nIe@https://musique.XXX.fr/assets/vue-router-dc26212d.js:1:14003\nB@https://musique.XXX.fr/assets/vue-router-dc26212d.js:1:24707\nLn@https://musique.XXX.fr/assets/vue-router-dc26212d.js:1:24914\npt@https://musique.XXX.fr/assets/vue-router-dc26212d.js:1:23912\nsetup@https://musique.XXX.fr/assets/Widget.vue_vue_type_script_setup_true_lang-df7542a3.js:1:1953\nGe@https://musique.XXX.fr/assets/vue-router-dc26212d.js:1:13923\nBa@https://musique.XXX.fr/assets/vue-router-dc26212d.js:1:66182\nTl@https://musique.XXX.fr/assets/vue-router-dc26212d.js:1:65965\nie@https://musique.XXX.fr/assets/vue-router-dc26212d.js:1:53169\nY@https://musique.XXX.fr/assets/vue-router-dc26212d.js:1:53060\nT@https://musique.XXX.fr/assets/vue-router-dc26212d.js:1:50005\nA@https://musique.XXX.fr/assets/vue-router-dc26212d.js:1:51413\nF@https://musique.XXX.fr/assets/vue-router-dc26212d.js:1:50730\nC@https://musique.XXX.fr/assets/vue-router-dc26212d.js:1:50549\nT@https://musique.XXX.fr/assets/vue-router-dc26212d.js:1:49980\nA@https://musique.XXX.fr/assets/vue-router-dc26212d.js:1:51413\nF@https://musique.XXX.fr/assets/vue-router-dc26212d.js:1:50730\nC@https://musique.XXX.fr/assets/vue-router-dc26212d.js:1:50549\nT@https://musique.XXX.fr/assets/vue-router-dc26212d.js:1:49980\nA@https://musique.XXX.fr/assets/vue-router-dc26212d.js:1:51413\nF@https://musique.XXX.fr/assets/vue-router-dc26212d.js:1:50730\nC@https://musique.XXX.fr/assets/vue-router-dc26212d.js:1:50549\nT@https://musique.XXX.fr/assets/vue-router-dc26212d.js:1:49980\nA@https://musique.XXX.fr/assets/vue-router-dc26212d.js:1:51413\n", message: "Request failed with status code 500", name: "AxiosError", code: "ERR_BAD_RESPONSE", config: {…}, request: XMLHttpRequest, response: {…}, backendErrors: (1) […], isHandled: false }
 
Array [ "A server error occurred" ]
useLogger.ts:72:6
Uncaught (in promise) 
Object { stack: "E@https://musique.XXX.fr/assets/axios-3a517bc4.js:1:4747\nBt@https://musique.XXX.fr/assets/axios-3a517bc4.js:3:937\nf@https://musique.XXX.fr/assets/axios-3a517bc4.js:3:4029\nEventHandlerNonNull*vt</<@https://musique.XXX.fr/assets/axios-3a517bc4.js:3:4087\nvt<@https://musique.XXX.fr/assets/axios-3a517bc4.js:3:3202\nce@https://musique.XXX.fr/assets/axios-3a517bc4.js:3:6504\npromise callback*request@https://musique.XXX.fr/assets/axios-3a517bc4.js:3:9941\nk.prototype[t]@https://musique.XXX.fr/assets/axios-3a517bc4.js:3:10381\nfe/<@https://musique.XXX.fr/assets/axios-3a517bc4.js:1:45\nfetchOwn@https://musique.XXX.fr/assets/index-53eff6ae.js:34:9075\ngd/<@https://musique.XXX.fr/assets/index-53eff6ae.js:25:2512\nGe.prototype.dispatch@https://musique.XXX.fr/assets/index-53eff6ae.js:25:10056\nGe/this.dispatch@https://musique.XXX.fr/assets/index-53eff6ae.js:25:9028\nsetup@https://musique.XXX.fr/assets/PlaylistModal-659b845d.js:1:2647\nGe@https://musique.XXX.fr/assets/vue-router-dc26212d.js:1:13923\nBa@https://musique.XXX.fr/assets/vue-router-dc26212d.js:1:66182\nTl@https://musique.XXX.fr/assets/vue-router-dc26212d.js:1:65965\nie@https://musique.XXX.fr/assets/vue-router-dc26212d.js:1:53169\nY@https://musique.XXX.fr/assets/vue-router-dc26212d.js:1:53060\nT@https://musique.XXX.fr/assets/vue-router-dc26212d.js:1:50005\nS@https://musique.XXX.fr/assets/vue-router-dc26212d.js:1:53702\nrun@https://musique.XXX.fr/assets/vue-router-dc26212d.js:1:4485\nU/d.update@https://musique.XXX.fr/assets/vue-router-dc26212d.js:1:54402\nGe@https://musique.XXX.fr/assets/vue-router-dc26212d.js:1:13931\nUi@https://musique.XXX.fr/assets/vue-router-dc26212d.js:1:15615\npromise callback*Di@https://musique.XXX.fr/assets/vue-router-dc26212d.js:1:14892\nCs@https://musique.XXX.fr/assets/vue-router-dc26212d.js:1:14849\nU/d.effect<@https://musique.XXX.fr/assets/vue-router-dc26212d.js:1:54372\nmo@https://musique.XXX.fr/assets/vue-router-dc26212d.js:1:6032\ntr@https://musique.XXX.fr/assets/vue-router-dc26212d.js:1:5968\nEs@https://musique.XXX.fr/assets/vue-router-dc26212d.js:1:11750\nset value@https://musique.XXX.fr/assets/vue-router-dc26212d.js:1:12203\nsetup/<@https://musique.XXX.fr/assets/vue-router-dc26212d.js:1:30131\npromise callback*setup@https://musique.XXX.fr/assets/vue-router-dc26212d.js:1:30121\nGe@https://musique.XXX.fr/assets/vue-router-dc26212d.js:1:13923\nBa@https://musique.XXX.fr/assets/vue-router-dc26212d.js:1:66182\nTl@https://musique.XXX.fr/assets/vue-router-dc26212d.js:1:65965\nie@https://musique.XXX.fr/assets/vue-router-dc26212d.js:1:53169\nY@https://musique.XXX.fr/assets/vue-router-dc26212d.js:1:53060\nT@https://musique.XXX.fr/assets/vue-router-dc26212d.js:1:50005\nA@https://musique.XXX.fr/assets/vue-router-dc26212d.js:1:51413\nF@https://musique.XXX.fr/assets/vue-router-dc26212d.js:1:50730\nC@https://musique.XXX.fr/assets/vue-router-dc26212d.js:1:50549\nT@https://musique.XXX.fr/assets/vue-router-dc26212d.js:1:49980\nS@https://musique.XXX.fr/assets/vue-router-dc26212d.js:1:54134\nrun@https://musique.XXX.fr/assets/vue-router-dc26212d.js:1:4485\nU/d.update@https://musique.XXX.fr/assets/vue-router-dc26212d.js:1:54402\nU@https://musique.XXX.fr/assets/vue-router-dc26212d.js:1:54428\nie@https://musique.XXX.fr/assets/vue-router-dc26212d.js:1:53266\nY@https://musique.XXX.fr/assets/vue-router-dc26212d.js:1:53060\nT@https://musique.XXX.fr/assets/vue-router-dc26212d.js:1:50005\nS@https://musique.XXX.fr/assets/vue-router-dc26212d.js:1:53702\nrun@https://musique.XXX.fr/assets/vue-router-dc26212d.js:1:4485\nU/d.update@https://musique.XXX.fr/assets/vue-router-dc26212d.js:1:54402\nGe@https://musique.XXX.fr/assets/vue-router-dc26212d.js:1:13931\n", message: "Request failed with status code 500", name: "AxiosError", code: "ERR_BAD_RESPONSE", config: {…}, request: XMLHttpRequest, response: {…}, backendErrors: (1) […], isHandled: false }
vuex.esm-bundler.js:1081:13
XHRGET
https://musique.XXX.fr/assets/Widget.vue_vue_type_script_setup_true_lang-5d8b300b.js.map

  [Sat, 03 Feb 2024 10:30:50 GMT]  ERROR  /assets/index-53eff6ae.js:34 O="",A=Math.min()  Unexpected API error 
Object { stack: "E@https://musique.XXX.fr/assets/axios-3a517bc4.js:1:4747\nBt@https://musique.XXX.fr/assets/axios-3a517bc4.js:3:937\nf@https://musique.XXX.fr/assets/axios-3a517bc4.js:3:4029\nEventHandlerNonNull*vt</<@https://musique.XXX.fr/assets/axios-3a517bc4.js:3:4087\nvt<@https://musique.XXX.fr/assets/axios-3a517bc4.js:3:3202\nce@https://musique.XXX.fr/assets/axios-3a517bc4.js:3:6504\npromise callback*request@https://musique.XXX.fr/assets/axios-3a517bc4.js:3:9941\nk.prototype[t]@https://musique.XXX.fr/assets/axios-3a517bc4.js:3:10381\nfe/<@https://musique.XXX.fr/assets/axios-3a517bc4.js:1:45\nm@https://musique.XXX.fr/assets/Widget.vue_vue_type_script_setup_true_lang-5d8b300b.js:1:846\nsetup/<@https://musique.XXX.fr/assets/Widget.vue_vue_type_script_setup_true_lang-5d8b300b.js:1:983\nGe@https://musique.XXX.fr/assets/vue-router-dc26212d.js:1:13923\nIe@https://musique.XXX.fr/assets/vue-router-dc26212d.js:1:14003\nB@https://musique.XXX.fr/assets/vue-router-dc26212d.js:1:24707\nLn@https://musique.XXX.fr/assets/vue-router-dc26212d.js:1:24914\npt@https://musique.XXX.fr/assets/vue-router-dc26212d.js:1:23912\nsetup@https://musique.XXX.fr/assets/Widget.vue_vue_type_script_setup_true_lang-5d8b300b.js:1:944\nGe@https://musique.XXX.fr/assets/vue-router-dc26212d.js:1:13923\nBa@https://musique.XXX.fr/assets/vue-router-dc26212d.js:1:66182\nTl@https://musique.XXX.fr/assets/vue-router-dc26212d.js:1:65965\nie@https://musique.XXX.fr/assets/vue-router-dc26212d.js:1:53169\nY@https://musique.XXX.fr/assets/vue-router-dc26212d.js:1:53060\nT@https://musique.XXX.fr/assets/vue-router-dc26212d.js:1:50005\nA@https://musique.XXX.fr/assets/vue-router-dc26212d.js:1:51413\nF@https://musique.XXX.fr/assets/vue-router-dc26212d.js:1:50730\nC@https://musique.XXX.fr/assets/vue-router-dc26212d.js:1:50549\nT@https://musique.XXX.fr/assets/vue-router-dc26212d.js:1:49980\nA@https://musique.XXX.fr/assets/vue-router-dc26212d.js:1:51413\nF@https://musique.XXX.fr/assets/vue-router-dc26212d.js:1:50730\nC@https://musique.XXX.fr/assets/vue-router-dc26212d.js:1:50549\nT@https://musique.XXX.fr/assets/vue-router-dc26212d.js:1:49980\nA@https://musique.XXX.fr/assets/vue-router-dc26212d.js:1:51413\nF@https://musique.XXX.fr/assets/vue-router-dc26212d.js:1:50730\nC@https://musique.XXX.fr/assets/vue-router-dc26212d.js:1:50549\nT@https://musique.XXX.fr/assets/vue-router-dc26212d.js:1:49980\nA@https://musique.XXX.fr/assets/vue-router-dc26212d.js:1:51413\n", message: "Request failed with status code 500", name: "AxiosError", code: "ERR_BAD_RESPONSE", config: {…}, request: XMLHttpRequest, response: {…}, backendErrors: (1) […], isHandled: false }
 
Array [ "A server error occurred" ]
useLogger.ts:72:6
XHRGET
https://musique.XXX.fr/assets/Widget.vue_vue_type_script_setup_true_lang-8a21db3c.js.map

  [Sat, 03 Feb 2024 10:30:50 GMT]  ERROR  /assets/index-53eff6ae.js:34 O="",A=Math.min()  Unexpected API error 
Object { stack: "E@https://musique.XXX.fr/assets/axios-3a517bc4.js:1:4747\nBt@https://musique.XXX.fr/assets/axios-3a517bc4.js:3:937\nf@https://musique.XXX.fr/assets/axios-3a517bc4.js:3:4029\nEventHandlerNonNull*vt</<@https://musique.XXX.fr/assets/axios-3a517bc4.js:3:4087\nvt<@https://musique.XXX.fr/assets/axios-3a517bc4.js:3:3202\nce@https://musique.XXX.fr/assets/axios-3a517bc4.js:3:6504\npromise callback*request@https://musique.XXX.fr/assets/axios-3a517bc4.js:3:9941\nk.prototype[t]@https://musique.XXX.fr/assets/axios-3a517bc4.js:3:10381\nfe/<@https://musique.XXX.fr/assets/axios-3a517bc4.js:1:45\nc@https://musique.XXX.fr/assets/Widget.vue_vue_type_script_setup_true_lang-8a21db3c.js:1:913\nsetup/<@https://musique.XXX.fr/assets/Widget.vue_vue_type_script_setup_true_lang-8a21db3c.js:1:1094\nGe@https://musique.XXX.fr/assets/vue-router-dc26212d.js:1:13923\nIe@https://musique.XXX.fr/assets/vue-router-dc26212d.js:1:14003\nB@https://musique.XXX.fr/assets/vue-router-dc26212d.js:1:24707\nLn@https://musique.XXX.fr/assets/vue-router-dc26212d.js:1:24914\npt@https://musique.XXX.fr/assets/vue-router-dc26212d.js:1:23912\nsetup@https://musique.XXX.fr/assets/Widget.vue_vue_type_script_setup_true_lang-8a21db3c.js:1:1055\nGe@https://musique.XXX.fr/assets/vue-router-dc26212d.js:1:13923\nBa@https://musique.XXX.fr/assets/vue-router-dc26212d.js:1:66182\nTl@https://musique.XXX.fr/assets/vue-router-dc26212d.js:1:65965\nie@https://musique.XXX.fr/assets/vue-router-dc26212d.js:1:53169\nY@https://musique.XXX.fr/assets/vue-router-dc26212d.js:1:53060\nT@https://musique.XXX.fr/assets/vue-router-dc26212d.js:1:50005\nA@https://musique.XXX.fr/assets/vue-router-dc26212d.js:1:51413\nF@https://musique.XXX.fr/assets/vue-router-dc26212d.js:1:50730\nC@https://musique.XXX.fr/assets/vue-router-dc26212d.js:1:50549\nT@https://musique.XXX.fr/assets/vue-router-dc26212d.js:1:49980\nA@https://musique.XXX.fr/assets/vue-router-dc26212d.js:1:51413\nF@https://musique.XXX.fr/assets/vue-router-dc26212d.js:1:50730\nC@https://musique.XXX.fr/assets/vue-router-dc26212d.js:1:50549\nT@https://musique.XXX.fr/assets/vue-router-dc26212d.js:1:49980\nA@https://musique.XXX.fr/assets/vue-router-dc26212d.js:1:51413\nF@https://musique.XXX.fr/assets/vue-router-dc26212d.js:1:50730\nC@https://musique.XXX.fr/assets/vue-router-dc26212d.js:1:50549\nT@https://musique.XXX.fr/assets/vue-router-dc26212d.js:1:49980\nA@https://musique.XXX.fr/assets/vue-router-dc26212d.js:1:51413\n", message: "Request failed with status code 500", name: "AxiosError", code: "ERR_BAD_RESPONSE", config: {…}, request: XMLHttpRequest, response: {…}, backendErrors: (1) […], isHandled: false }
 
Array [ "A server error occurred" ]
useLogger.ts:72:6
Error: waitForElement timed out
    timeout moz-extension://7332fcf5-6baf-477c-89c7-6eac2a4ad9f5/content_script/mastodonInject.js:60
    setTimeout handler*waitForElement/< moz-extension://7332fcf5-6baf-477c-89c7-6eac2a4ad9f5/content_script/mastodonInject.js:59
    waitForElement moz-extension://7332fcf5-6baf-477c-89c7-6eac2a4ad9f5/content_script/mastodonInject.js:51
    init moz-extension://7332fcf5-6baf-477c-89c7-6eac2a4ad9f5/content_script/mastodonInject.js:185
    <anonymous> moz-extension://7332fcf5-6baf-477c-89c7-6eac2a4ad9f5/content_script/mastodonInject.js:195

Error: waitForElement timed out
    timeout moz-extension://7332fcf5-6baf-477c-89c7-6eac2a4ad9f5/content_script/misskeyInject.js:53
    setTimeout handler*waitForElement/< moz-extension://7332fcf5-6baf-477c-89c7-6eac2a4ad9f5/content_script/misskeyInject.js:52
    waitForElement moz-extension://7332fcf5-6baf-477c-89c7-6eac2a4ad9f5/content_script/misskeyInject.js:44
    init moz-extension://7332fcf5-6baf-477c-89c7-6eac2a4ad9f5/content_script/misskeyInject.js:136
    <anonymous> moz-extension://7332fcf5-6baf-477c-89c7-6eac2a4ad9f5/content_script/misskeyInject.js:146

Error: waitForElement timed out
    timeout moz-extension://7332fcf5-6baf-477c-89c7-6eac2a4ad9f5/content_script/mastodonInject.js:60
    setTimeout handler*waitForElement/< moz-extension://7332fcf5-6baf-477c-89c7-6eac2a4ad9f5/content_script/mastodonInject.js:59
    waitForElement moz-extension://7332fcf5-6baf-477c-89c7-6eac2a4ad9f5/content_script/mastodonInject.js:51
    init moz-extension://7332fcf5-6baf-477c-89c7-6eac2a4ad9f5/content_script/mastodonInject.js:185
    <anonymous> moz-extension://7332fcf5-6baf-477c-89c7-6eac2a4ad9f5/content_script/mastodonInject.js:195

Error: waitForElement timed out
    timeout moz-extension://7332fcf5-6baf-477c-89c7-6eac2a4ad9f5/content_script/misskeyInject.js:53
    setTimeout handler*waitForElement/< moz-extension://7332fcf5-6baf-477c-89c7-6eac2a4ad9f5/content_script/misskeyInject.js:52
    waitForElement moz-extension://7332fcf5-6baf-477c-89c7-6eac2a4ad9f5/content_script/misskeyInject.js:44
    init moz-extension://7332fcf5-6baf-477c-89c7-6eac2a4ad9f5/content_script/misskeyInject.js:136
    <anonymous> moz-extension://7332fcf5-6baf-477c-89c7-6eac2a4ad9f5/content_script/misskeyInject.js:146

Regarding network logs, I get a 405 on the following GET :
https://musique.XXX.fr/api/v1/channels/?ordering=-creation_date&external=false&page_size=12&include_channels=true https://musique.XXX.fr/api/v1/subscriptions/all/

Then 500 for these :

https://musique.XXX.fr/api/v1/artists/?ordering=-creation_date&playable=true
https://musique.XXX.fr/api/v1/history/listenings/?scope=all&ordering=-creation_date&page_size=5
https://musique.XXX.fr/api/v1/favorites/tracks/?scope=all&ordering=-creation_date&page_size=5
https://musique.XXX.fr/api/v1/playlists/?scope=all&playable=true&ordering=-modification_date&page_size=3
https://musique.XXX.fr/api/v1/albums/?q=&scope=all&playable=true&ordering=-creation_date&page_size=12
https://musique.XXX.fr/api/v1/playlists/?scope=me
https://musique.XXX.fr/api/v1/favorites/tracks/all/?user=1&page_size=50&ordering=-creation_date

gcrk

Hello @Zekovski

All this looks like your instance is simply not answering requests anymore. Can you check the status of the api service using systemctl?

Zekovski

Hello,
Thank you for answering.

Here is what I got ...

raspberryraspberry:~$ systemctl status funkwhale-beat.service 
× funkwhale-beat.service - Funkwhale celery beat process
     Loaded: loaded (/etc/systemd/system/funkwhale-beat.service; disabled; preset: enabled)
     Active: failed (Result: exit-code) since Sun 2024-02-04 13:16:46 CET; 2 days ago
   Duration: 42.674s
    Process: 829 ExecStart=/srv/funkwhale/venv/bin/celery --app funkwhale_api.taskapp beat --loglevel INFO (code=exited, status=1/FAILURE)
   Main PID: 829 (code=exited, status=1/FAILURE)
        CPU: 20.795s

Feb 04 13:16:45 raspberry celery[829]: Configuration ->
Feb 04 13:16:45 raspberry celery[829]:     . broker -> redis://127.0.0.1:6379/0
Feb 04 13:16:45 raspberry celery[829]:     . loader -> celery.loaders.app.AppLoader
Feb 04 13:16:45 raspberry celery[829]:     . scheduler -> celery.beat.PersistentScheduler
Feb 04 13:16:45 raspberry celery[829]:     . db -> celerybeat-schedule
Feb 04 13:16:45 raspberry celery[829]:     . logfile -> [stderr]@%INFO
Feb 04 13:16:45 raspberry celery[829]:     . maxinterval -> 5.00 minutes (300s)
Feb 04 13:16:46 raspberry systemd[1]: funkwhale-beat.service: Main process exited, code=exited, status=1/FAILURE
Feb 04 13:16:46 raspberry systemd[1]: funkwhale-beat.service: Failed with result 'exit-code'.
Feb 04 13:16:46 raspberry systemd[1]: funkwhale-beat.service: Consumed 20.795s CPU time.
raspberryraspberry:~$ systemctl status funkwhale-server.service 
● funkwhale-server.service - Funkwhale application server
     Loaded: loaded (/etc/systemd/system/funkwhale-server.service; disabled; preset: enabled)
     Active: active (running) since Sun 2024-02-04 13:16:06 CET; 2 days ago
   Main PID: 830 (gunicorn)
     Status: "Gunicorn arbiter booted"
      Tasks: 12 (limit: 765)
        CPU: 27min 1.580s
     CGroup: /system.slice/funkwhale-server.service
             ├─830 /srv/funkwhale/venv/bin/python3 /srv/funkwhale/venv/bin/gunicorn config.asgi:application --workers 2 --worker-class uvicorn.workers.UvicornWorker --bind 127.0.0.1:5000
             ├─840 /srv/funkwhale/venv/bin/python3 /srv/funkwhale/venv/bin/gunicorn config.asgi:application --workers 2 --worker-class uvicorn.workers.UvicornWorker --bind 127.0.0.1:5000
             └─842 /srv/funkwhale/venv/bin/python3 /srv/funkwhale/venv/bin/gunicorn config.asgi:application --workers 2 --worker-class uvicorn.workers.UvicornWorker --bind 127.0.0.1:5000

Feb 06 20:13:03 raspberry gunicorn[842]:                  ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
Feb 06 20:13:03 raspberry gunicorn[842]:   File "/srv/funkwhale/venv/lib/python3.11/site-packages/psycopg2/__init__.py", line 122, in connect
Feb 06 20:13:03 raspberry gunicorn[842]:     conn = _connect(dsn, connection_factory=connection_factory, **kwasync)
Feb 06 20:13:03 raspberry gunicorn[842]:            ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
Feb 06 20:13:03 raspberry gunicorn[842]: django.db.utils.OperationalError: connection to server on socket "/var/run/postgresql/.s.PGSQL.5432" failed: FATAL:  the database system is in recovery mode
Feb 06 20:13:06 raspberry gunicorn[842]: [2024-02-06 19:13:06 +0000] [842] [INFO] connection closed
Feb 06 21:44:21 raspberry gunicorn[842]: [2024-02-06 20:44:21 +0000] [842] [INFO] ('5.183.104.47', 0) - "WebSocket /api/v1/activity" [accepted]
Feb 06 21:44:21 raspberry gunicorn[842]: [2024-02-06 20:44:21 +0000] [842] [INFO] connection open
Feb 06 21:44:24 raspberry gunicorn[842]: 2024-02-06 20:44:24,760 django.request WARNING  Method Not Allowed: /api/v1/subscriptions/all/
Feb 06 21:44:53 raspberry gunicorn[842]: [2024-02-06 20:44:53 +0000] [842] [INFO] connection closed

For your information, I followed this page : https://docs.funkwhale.audio/administrator/configuration/optimize.html after installation, and set CELERYD_CONCURRENCY=1. Maybe I should reset it to default to see if it works better.
I also tried --pool solo but it seems deprecated.

gcrk

Zekovski OperationalError: connection to server on socket "/var/run/postgresql/.s.PGSQL.5432" failed: FATAL: the database system is in recovery mode

Thats pretty clear, your database is out of service for some reason. I'd recommend to check its logs and try to solve the issue and restart Funkwhale afterwards.

Zekovski

That's strange because it sometimes works. I would have accused an access delay but OK.
I'll look into it, thank you.
How do I get access to detailed logs from the data base ? Right now I don't know what to correct exactly.

After restarting just now, the server status seems fine. But the beat service still fails, it says logfile is [stderr]@%INFO but I'm sorry, I don't know what it is.

And after displaying the front page I got this :

2024-02-07 10:07:32,744 django.request WARNING  Method Not Allowed: /api/v1/channels/
/srv/funkwhale/venv/lib/python3.11/site-packages/rest_framework/pagination.py:200: UnorderedObjectListWarning: Pagination may yield inconsistent results with an unordered object_list: <class 'funkwhale_api.playlists.models.Playlist'> PlaylistQuerySet.
   paginator = self.django_paginator_class(queryset, page_size)

But I have no channel nor playlist set up in the website or the db.

gcrk

Zekovski To get the database logs, run journalctl -u postgresql.

Zekovski After restarting just now, the server status seems fine. But the beat service still fails, it says logfile is [stderr]@%INFO but I’m sorry, I don’t know what it is.

Me neither, but more context of the message might help 🙂

The log message you sent isn't of any concern, it's just a warning. Please ignore it.

Zekovski

gcrk
OK thank you.

Postgresql journal doesn't show anything out of the ordinary.

Looking at funwhale-server I still get a bunch of these :

Feb 11 21:08:33 raspberry gunicorn[834]: django.db.utils.OperationalError: connection to server on socket "/var/run/postgresql/.s.PGSQL.5432" failed: FATAL:  the database system is not yet accepting connections
Feb 11 21:08:33 raspberry gunicorn[834]: DETAIL:  Consistent recovery state has not been yet reached.

The problem seems related to artists though. As I can't see them from my app, nor from the website apparently. Kinda random idea : Could this be because I have a "Various artists" artist attached to several albums but no track ?

gcrk

Zekovski The log message states quite clearly that postgres is not reachable, this has nothing to do with artists. If the database is not available, Funkwhale is unable to read or write data. It looks like the database got corrupted for some reason, but I cannot tell without having more details or log messages.

Zekovski

That's strange because I can still access my data and listen to my music.

Anyway, here is the result of journalctl -u postgresql :

-- Boot a5397e0236f44ccb968331152327105d --
Feb 04 13:16:03 raspi systemd[1]: Starting postgresql.service - PostgreSQL RDBMS...
Feb 04 13:16:03 raspi systemd[1]: Finished postgresql.service - PostgreSQL RDBMS.
Feb 11 18:14:41 raspi systemd[1]: postgresql.service: Deactivated successfully.
Feb 11 18:14:41 raspi systemd[1]: Stopped postgresql.service - PostgreSQL RDBMS.
-- Boot d31b070826e84cdda586895c8145c552 --
Feb 11 18:14:53 raspi systemd[1]: Starting postgresql.service - PostgreSQL RDBMS...
Feb 11 18:14:53 raspi systemd[1]: Finished postgresql.service - PostgreSQL RDBMS.
Feb 11 21:28:23 raspi systemd[1]: postgresql.service: Deactivated successfully.
Feb 11 21:28:23 raspi systemd[1]: Stopped postgresql.service - PostgreSQL RDBMS.
-- Boot a189b6a44ffe411982219c4f60cdbf7b --
Feb 11 21:28:35 raspi systemd[1]: Starting postgresql.service - PostgreSQL RDBMS...
Feb 11 21:28:35 raspi systemd[1]: Finished postgresql.service - PostgreSQL RDBMS.

And it goes back like this to the start with always the same messages. The status is active (exited).

Sorry if I'm slow thinking, I'm still learning how everything works together.

gcrk

Zekovski I am not a postgres expert, but maybe check /var/log as well? Is postgres also using the external disk to store its data?

Zekovski

No, postgresql is not using the external disk.

I just checked /var/log and indeed found a bunch of these :

2024-02-15 18:55:03.854 CET [743] LOG:  database system is ready to accept connections
2024-02-15 18:55:06.497 CET [743] LOG:  server process (PID 985) was terminated by signal 11: Segmentation fault
2024-02-15 18:55:06.497 CET [743] DETAIL:  Failed process was running: SELECT "music_album"."id", "music_album"."fid", "music_album"."mbid", "music_album"."uuid", "music_album"."from_activity_id", "music_album"."creation_date", "music_album"."body_text", "music_album"."title", "music_album"."artist_id", "music_album"."release_date", "music_album"."release_group_id", "music_album"."attachment_cover_id", "music_album"."type", "music_album"."attributed_to_id", "music_album"."description_id", COUNT("music_track"."id") AS "_tracks_count", (SELECT W0."id" FROM "music_upload" W0 INNER JOIN "music_track" W2 ON (W0."track_id" = W2."id") WHERE (W0."import_status" IN ('finished', 'skipped') AND W0."library_id" IN (SELECT V0."id" FROM "music_library" V0 INNER JOIN "federation_actor" V1 ON (V0."actor_id" = V1."id") WHERE ((V0."actor_id" = 1 AND V0."privacy_level" = 'me') OR (V1."domain_id" = 'musique.chezmwa.fr' AND V0."privacy_level" = 'instance') OR V0."privacy_level" = 'everyone' OR V0."id" IN (SELECT U0."target_id" FROM "federation_libraryfollow" U0 WHERE (U0."actor_id" = 1 AND U0."appr
2024-02-15 18:55:06.497 CET [743] LOG:  terminating any other active server processes
2024-02-15 18:55:06.502 CET [986] funkwhale@funkwhale FATAL:  the database system is in recovery mode
2024-02-15 18:55:06.510 CET [743] LOG:  all server processes terminated; reinitializing
2024-02-15 18:55:06.562 CET [990] LOG:  database system was interrupted; last known up at 2024-02-15 18:55:03 CET
2024-02-15 18:55:06.566 CET [993] funkwhale@funkwhale FATAL:  the database system is in recovery mode
2024-02-15 18:55:06.599 CET [995] funkwhale@funkwhale FATAL:  the database system is in recovery mode
2024-02-15 18:55:06.636 CET [998] funkwhale@funkwhale FATAL:  the database system is in recovery mode
2024-02-15 18:55:06.670 CET [1000] funkwhale@funkwhale FATAL:  the database system is in recovery mode
2024-02-15 18:55:06.675 CET [990] LOG:  database system was not properly shut down; automatic recovery in progress
2024-02-15 18:55:06.687 CET [990] LOG:  invalid record length at 0/F0A23C8: wanted 24, got 0
2024-02-15 18:55:06.687 CET [990] LOG:  redo is not required
2024-02-15 18:55:06.703 CET [1003] funkwhale@funkwhale FATAL:  the database system is not yet accepting connections
2024-02-15 18:55:06.703 CET [1003] funkwhale@funkwhale DETAIL:  Consistent recovery state has not been yet reached.
2024-02-15 18:55:06.721 CET [991] LOG:  checkpoint starting: end-of-recovery immediate wait
2024-02-15 18:55:06.743 CET [1005] funkwhale@funkwhale FATAL:  the database system is not yet accepting connections
2024-02-15 18:55:06.743 CET [1005] funkwhale@funkwhale DETAIL:  Consistent recovery state has not been yet reached.
2024-02-15 18:55:06.767 CET [991] LOG:  checkpoint complete: wrote 2 buffers (0.0%); 0 WAL file(s) added, 0 removed, 0 recycled; write=0.014 s, sync=0.005 s, total=0.052 s; sync files=3, longest=0.002 s, average=0.002 s; distance=0 kB, estimate=0 kB
2024-02-15 18:55:06.785 CET [743] LOG:  database system is ready to accept connections

I remember some SQL, so is there some way to find the issue directly inside the database maybe ?

gcrk

Zekovski I would try to restore the database from backup or contact postgresql community to get support.

Zekovski

OK thank you for your help so far.

I don't have a bakcup yet because it's brand new. Just one thing : Is it normal for this query in the logs to be this long ? Do you know if the logs cut the end or was it faulty in itself ?

gcrk

Zekovski Queries can be quite long since they are optimized for different things and I'd bet it was cut by the logging.