J’ai mis les slow log à 1seconde tu me diras si c’est pas pertinent
ça s’active à des selects que voici :
2026-03-02 09:51:57.247 CET [3764159] peertube@peertube_prod LOG: duration: 5057.927 ms statement: SELECT "video".*, "VideoChannel"."id" AS "VideoChannel.id", "VideoChannel"."name" AS "VideoChannel.name", "VideoChannel"."description" AS "VideoChannel.description", "VideoChannel"."accountId" AS "VideoChannel.accountId", "VideoChannel->Actor"."id" AS "VideoChannel.Actor.id", "VideoChannel->Actor"."preferredUsername" AS "VideoChannel.Actor.preferredUsername", "VideoChannel->Actor"."url" AS "VideoChannel.Actor.url", "VideoChannel->Actor"."serverId" AS "VideoChannel.Actor.serverId", "VideoChannel->Actor"."accountId" AS "VideoChannel.Actor.accountId", "VideoChannel->Actor"."videoChannelId" AS "VideoChannel.Actor.videoChannelId", "VideoChannel->Actor->Avatars"."id" AS "VideoChannel.Actor.Avatars.id", "VideoChannel->Actor->Avatars"."width" AS "VideoChannel.Actor.Avatars.width", "VideoChannel->Actor->Avatars"."filename" AS "VideoChannel.Actor.Avatars.filename", "VideoChannel->Actor->Avatars"."type" AS "VideoChannel.Actor.Avatars.type", "VideoChannel->Actor->Avatars"."fileUrl" AS "VideoChannel.Actor.Avatars.fileUrl", "VideoChannel->Actor->Avatars"."onDisk" AS "VideoChannel.Actor.Avatars.onDisk", "VideoChannel->Actor->Avatars"."createdAt" AS "VideoChannel.Actor.Avatars.createdAt", "VideoChannel->Actor->Avatars"."updatedAt" AS "VideoChannel.Actor.Avatars.updatedAt", "VideoChannel->Actor->Server"."id" AS "VideoChannel.Actor.Server.id", "VideoChannel->Actor->Server"."host" AS "VideoChannel.Actor.Server.host", "VideoChannel->Account"."id" AS "VideoChannel.Account.id", "VideoChannel->Account"."name" AS "VideoChannel.Account.name", "VideoChannel->Account->Actor"."id" AS "VideoChannel.Account.Actor.id", "VideoChannel->Account->Actor"."preferredUsername" AS "VideoChannel.Account.Actor.preferredUsername", "VideoChannel->Account->Actor"."url" AS "VideoChannel.Account.Actor.url", "VideoChannel->Account->Actor"."serverId" AS "VideoChannel.Account.Actor.serverId", "VideoChannel->Account->Actor"."accountId" AS "VideoChannel.Account.Actor.accountId", "VideoChannel->Account->Actor"."videoChannelId" AS "VideoChannel.Account.Actor.videoChannelId", "VideoChannel->Account->Actor->Avatars"."id" AS "VideoChannel.Account.Actor.Avatars.id", "VideoChannel->Account->Actor->Avatars"."width" AS "VideoChannel.Account.Actor.Avatars.width", "VideoChannel->Account->Actor->Avatars"."filename" AS "VideoChannel.Account.Actor.Avatars.filename", "VideoChannel->Account->Actor->Avatars"."type" AS "VideoChannel.Account.Actor.Avatars.type", "VideoChannel->Account->Actor->Avatars"."fileUrl" AS "VideoChannel.Account.Actor.Avatars.fileUrl", "VideoChannel->Account->Actor->Avatars"."onDisk" AS "VideoChannel.Account.Actor.Avatars.onDisk", "VideoChannel->Account->Actor->Avatars"."createdAt" AS "VideoChannel.Account.Actor.Avatars.createdAt", "VideoChannel->Account->Actor->Avatars"."updatedAt" AS "VideoChannel.Account.Actor.Avatars.updatedAt", "VideoChannel->Account->Actor->Server"."id" AS "VideoChannel.Account.Actor.Server.id", "VideoChannel->Account->Actor->Server"."host" AS "VideoChannel.Account.Actor.Server.host", "Thumbnails"."id" AS "Thumbnails.id", "Thumbnails"."type" AS "Thumbnails.type", "Thumbnails"."filename" AS "Thumbnails.filename", "userVideoHistory"."id" AS "userVideoHistory.id", "userVideoHistory"."currentTime" AS "userVideoHistory.currentTime" FROM (SELECT "video"."id", 0 as similarity FROM "video" INNER JOIN "videoChannel" ON "videoChannel"."id" = "video"."channelId" INNER JOIN "account" ON "account"."id" = "videoChannel"."accountId" INNER JOIN "actor" "accountActor" ON "account"."id" = "accountActor"."accountId" WHERE "video"."id" NOT IN (SELECT "videoBlacklist"."videoId" FROM "videoBlacklist") AND NOT EXISTS ( SELECT 1 FROM "accountBlocklist" WHERE "accountBlocklist"."accountId" IN ('1', '18') AND "accountBlocklist"."targetAccountId" = "account"."id" )AND NOT EXISTS ( SELECT 1 FROM "serverBlocklist" WHERE "serverBlocklist"."accountId" IN ('1', '18') AND "serverBlocklist"."targetServerId" = "accountActor"."serverId") AND ("video"."state" = 1 OR ("video"."state" = 2 AND "video"."waitTranscoding" IS false)) AND "videoChannel"."id" = 14 AND ("video"."privacy" = 1 OR "video"."privacy" = 4) AND "vifZ6qeWWQXvk0m3s8ow==\""
2026-03-02 09:51:39.174 CET [3763636] peertube@peertube_prod LOG: duration: 5480.711 ms statement: SELECT "video".*, "VideoChannel"."id" AS "VideoChannel.id", "VideoChannel"."name" AS "VideoChannel.name", "VideoChannel"."description" AS "VideoChannel.description", "VideoChannel"."accountId" AS "VideoChannel.accountId", "VideoChannel->Actor"."id" AS "VideoChannel.Actor.id", "VideoChannel->Actor"."preferredUsername" AS "VideoChannel.Actor.preferredUsername", "VideoChannel->Actor"."url" AS "VideoChannel.Actor.url", "VideoChannel->Actor"."serverId" AS "VideoChannel.Actor.serverId", "VideoChannel->Actor"."accountId" AS "VideoChannel.Actor.accountId", "VideoChannel->Actor"."videoChannelId" AS "VideoChannel.Actor.videoChannelId", "VideoChannel->Actor->Avatars"."id" AS "VideoChannel.Actor.Avatars.id", "VideoChannel->Actor->Avatars"."width" AS "VideoChannel.Actor.Avatars.width", "VideoChannel->Actor->Avatars"."filename" AS "VideoChannel.Actor.Avatars.filename", "VideoChannel->Actor->Avatars"."type" AS "VideoChannel.Actor.Avatars.type", "VideoChannel->Actor->Avatars"."fileUrl" AS "VideoChannel.Actor.Avatars.fileUrl", "VideoChannel->Actor->Avatars"."onDisk" AS "VideoChannel.Actor.Avatars.onDisk", "VideoChannel->Actor->Avatars"."createdAt" AS "VideoChannel.Actor.Avatars.createdAt", "VideoChannel->Actor->Avatars"."updatedAt" AS "VideoChannel.Actor.Avatars.updatedAt", "VideoChannel->Actor->Server"."id" AS "VideoChannel.Actor.Server.id", "VideoChannel->Actor->Server"."host" AS "VideoChannel.Actor.Server.host", "VideoChannel->Account"."id" AS "VideoChannel.Account.id", "VideoChannel->Account"."name" AS "VideoChannel.Account.name", "VideoChannel->Account->Actor"."id" AS "VideoChannel.Account.Actor.id", "VideoChannel->Account->Actor"."preferredUsername" AS "VideoChannel.Account.Actor.preferredUsername", "VideoChannel->Account->Actor"."url" AS "VideoChannel.Account.Actor.url", "VideoChannel->Account->Actor"."serverId" AS "VideoChannel.Account.Actor.serverId", "VideoChannel->Account->Actor"."accountId" AS "VideoChannel.Account.Actor.accountId", "VideoChannel->Account->Actor"."videoChannelId" AS "VideoChannel.Account.Actor.videoChannelId", "VideoChannel->Account->Actor->Avatars"."id" AS "VideoChannel.Account.Actor.Avatars.id", "VideoChannel->Account->Actor->Avatars"."width" AS "VideoChannel.Account.Actor.Avatars.width", "VideoChannel->Account->Actor->Avatars"."filename" AS "VideoChannel.Account.Actor.Avatars.filename", "VideoChannel->Account->Actor->Avatars"."type" AS "VideoChannel.Account.Actor.Avatars.type", "VideoChannel->Account->Actor->Avatars"."fileUrl" AS "VideoChannel.Account.Actor.Avatars.fileUrl", "VideoChannel->Account->Actor->Avatars"."onDisk" AS "VideoChannel.Account.Actor.Avatars.onDisk", "VideoChannel->Account->Actor->Avatars"."createdAt" AS "VideoChannel.Account.Actor.Avatars.createdAt", "VideoChannel->Account->Actor->Avatars"."updatedAt" AS "VideoChannel.Account.Actor.Avatars.updatedAt", "VideoChannel->Account->Actor->Server"."id" AS "VideoChannel.Account.Actor.Server.id", "VideoChannel->Account->Actor->Server"."host" AS "VideoChannel.Account.Actor.Server.host", "Thumbnails"."id" AS "Thumbnails.id", "Thumbnails"."type" AS "Thumbnails.type", "Thumbnails"."filename" AS "Thumbnails.filename", "userVideoHistory"."id" AS "userVideoHistory.id", "userVideoHistory"."currentTime" AS "userVideoHistory.currentTime", "VideoLive"."id" AS "VideoLive.id", "VideoLive"."streamKey" AS "VideoLive.streamKey", "VideoLive"."saveReplay" AS "VideoLive.saveReplay", "VideoLive"."permanentLive" AS "VideoLive.permanentLive", "VideoLive"."latencyMode" AS "VideoLive.latencyMode", "VideoLive"."videoId" AS "VideoLive.videoId", "VideoLive"."replaySettingId" AS "VideoLive.replaySettingId", "VideoLive"."createdAt" AS "VideoLive.createdAt", "VideoLive"."updatedAt" AS "VideoLive.updatedAt", "VideoLive->VideoLiveSchedules"."id" AS "VideoLive.VideoLiveSchedules.id", "VideoLive->VideoLiveSchedules"."startAt" AS "VideoLive.VideoLiveSchedules.startAt", "VideoLive->VideoLiveSchedules"."createdAt" AS "VideoLive.VideoLiveSchedules.createdAt", "VideoLive->VideoLiveSchedules"."updatedAt" AS "VideoLive.VideoLiveSchedules.updatedAt" FROM (SELECT "video"."id", 0 as similarity FROM "video" INNER JOIN "videoChannel" ON "videoChannel"."id" = "video"."channelId" INNER JOIN "account" ON "account"."id" = "videoChannel"."accountId" INNER JOIN "actor" "accountActor" ON "account"."id" = "accountActor"."accountId" LEFT JOIN "videoLive" ON "video"."id" = "videoLive"."videoId" LEFT JOIN "videoLiveSchedule" ON "videoLiveSchedule"."liveVideoId" = "videoLive"."id" WHERE "video"."id" NOT IN (SELECT "videoBlacklist"."videoId" FROM "videoBlacklist") AND NOT EXISTS ( SELECT 1 FROM "accountBlocklist" WHERE "accountBlocklist"."accountId" IN ('1', '18') AND "accountBlocklist"."targetAccountId" = "account"."id" )AND NOT EXISTS ( SELECT 1 FROM "serverBlocklist" WHERE "serverBlocklist"."accountId" IN ('1', '18') AND "serverBlocklist"."targetServerId" = "accountActor"."serverId") AND ("video"."state" = 1 OR ("video"."state" = 2 AND "video"."waitTranscoding" IS false) OR ("video"."state" = 4 AND "videoLiveSchedule"."startAt" > NOW())) AND "videoChannel"."id" = 10 AND ("video"."privacy" = 1 OR "video"."privacy" = 4) AND "video"."nsfw" IS FALSE ORDER BY "video"."publishedAt" DESC, "video"."id" ASC LIMIT 25 OFFSET 25) AS "tmp" INNER JOIN "video" ON "tmp"."id" = "video"."id" INNER JOIN "videoChannel" AS "VideoChannel" ON "video"."channelId" = "VideoChannel"."id" INNER JOIN "actor" AS "VideoChannel->Actor" ON "VideoChannel"."id" = "VideoChannel->Actor"."videoChannelId" LEFT OUTER JOIN "server" AS "VideoChannel->Actor->Server" ON "VideoChannel->Actor"."serverId" = "VideoChannel->Actor->Server"."id" LEFT OUTER JOIN "actorImage" AS "VideoChannel->Actor->Avatars" ON "VideoChannel->Actor"."id" = "VideoChannel->Actor->Avatars"."actorId" AND "VideoChannel->Actor->Avatars"."type" = 1 INNER JOIN "account" AS "VideoChannel->Account" ON "VideoChannel"."accountId" = "VideoChannel->Account"."id" INNER JOIN "actor" AS "VideoChannel->Account->Actor" ON "VideoChannel->Account"."id" = "VideoChannel->Account->Actor"."accountId" LEFT OUTER JOIN "server" AS "VideoChannel->Account->Actor->Server" ON "VideoChannel->Account->Actor"."serverId" = "VideoChannel->Account->Actor->Server"."id" LEFT OUTER JOIN "actorImage" AS "VideoChannel->Account->Actor->Avatars" ON "VideoChannel->Account->Actor"."id" = "VideoChannel->Account->Actor->Avatars"."actorId" AND "VideoChannel->Account->Actor->Avatars"."type" = 1 LEFT OUTER JOIN "thumbnail" AS "Thumbnails" ON "video"."id" = "Thumbnails"."videoId" LEFT OUTER JOIN "userVideoHistory" ON "video"."id" = "userVideoHistory"."videoId" AND "userVideoHistory"."userId" = 3 LEFT OUTER JOIN "videoLive" AS "VideoLive" ON "video"."id" = "VideoLive"."videoId" LEFT OUTER JOIN "videoLiveSchedule" AS "VideoLive->VideoLiveSchedules" ON "VideoLive->VideoLiveSchedules"."liveVideoId" = "VideoLive"."id" ORDER BY "video"."publishedAt" DESC, "video"."id" ASC
Ya cette erreur dans les logs (que j’avais pas vu jvais aller voir sur github si ya des soucis similaires)
Mar 02 09:53:07 grp-service-01 peertube[3632906]: [tube.grap.coop:443] 2026-03-02 09:53:07.243 info: Cannot authenticate. {
Mar 02 09:53:07 grp-service-01 peertube[3632906]: "err": {
Mar 02 09:53:07 grp-service-01 peertube[3632906]: "stack": "invalid_token: Invalid token: access token is invalid\n at AuthenticateHandler.getAccessToken (/var/www/peertube/versions/peertube-v8.0.2/node_modules/.pnpm/@node-oauth+oauth2-server@5.2.1/node_modules/@node-oauth/oauth2-server/lib/handlers/authenticate-handler.js:203:13)\n at process.processTicksAndRejections (node:internal/process/task_queues:95:5)\n at async AuthenticateHandler.handle (/var/www/peertube/versions/peertube-v8.0.2/node_modules/.pnpm/@node-oauth+oauth2-server@5.2.1/node_modules/@node-oauth/oauth2-server/lib/handlers/authenticate-handler.js:70:21)",
Mar 02 09:53:07 grp-service-01 peertube[3632906]: "message": "Invalid token: access token is invalid",
Mar 02 09:53:07 grp-service-01 peertube[3632906]: "statusCode": 401,
Mar 02 09:53:07 grp-service-01 peertube[3632906]: "status": 401,
Mar 02 09:53:07 grp-service-01 peertube[3632906]: "code": 401,
Mar 02 09:53:07 grp-service-01 peertube[3632906]: "name": "invalid_token"
Mar 02 09:53:07 grp-service-01 peertube[3632906]: }
Mar 02 09:53:07 grp-service-01 peertube[3632906]: }
et des erreurs liées au fediverse ?
Mar 02 09:57:03 grp-service-01 peertube[3632906]: [tube.grap.coop:443] 2026-03-02 09:57:03.665 info: Cannot fetch remote actor count https://mastodon.social/ap/users/115705017780116558/following. {
Mar 02 09:57:03 grp-service-01 peertube[3632906]: "err": {
Mar 02 09:57:03 grp-service-01 peertube[3632906]: "stack": "HTTPError: Request failed with status code 410 (Gone): GET https://mastodon.social/ap/users/115705017780116558/following\n at Request.<anonymous> (file:///var/www/peertube/versions/peertube-v8.0.2/node_modules/.pnpm/got@14.6.3/node_modules/got/dist/source/as-promise/index.js:98:42)\n at Object.onceWrapper (node:events:639:26)\n at Request.emit (node:events:536:35)\n at Request._onResponseBase (file:///var/www/peertube/versions/peertube-v8.0.2/node_modules/.pnpm/got@14.6.3/node_modules/got/dist/source/core/index.js:781:22)\n at process.processTicksAndRejections (node:internal/process/task_queues:95:5)\n at async Request._onResponse (file:///var/www/peertube/versions/peertube-v8.0.2/node_modules/.pnpm/got@14.6.3/node_modules/got/dist/source/core/index.js:831:13)",
Mar 02 09:57:03 grp-service-01 peertube[3632906]: "message": "Request failed with status code 410 (Gone): GET https://mastodon.social/ap/users/115705017780116558/following",
Mar 02 09:57:03 grp-service-01 peertube[3632906]: "name": "HTTPError",
Mar 02 09:57:03 grp-service-01 peertube[3632906]: "responseBody": {
Mar 02 09:57:03 grp-service-01 peertube[3632906]: "error": "Gone"
Mar 02 09:57:03 grp-service-01 peertube[3632906]: },
Mar 02 09:57:03 grp-service-01 peertube[3632906]: "responseHeaders": {
Mar 02 09:57:03 grp-service-01 peertube[3632906]: "connection": "close",
Mar 02 09:57:03 grp-service-01 peertube[3632906]: "content-length": "16",
Mar 02 09:57:03 grp-service-01 peertube[3632906]: "x-robots-tag": "noindex, nofollow",
Mar 02 09:57:03 grp-service-01 peertube[3632906]: "referrer-policy": "strict-origin-when-cross-origin",
Mar 02 09:57:03 grp-service-01 peertube[3632906]: "x-origin-robots-tag": "noindex, nofollow",
Mar 02 09:57:03 grp-service-01 peertube[3632906]: "server": "Mastodon",
Mar 02 09:57:03 grp-service-01 peertube[3632906]: "x-xss-protection": "0",
Mar 02 09:57:03 grp-service-01 peertube[3632906]: "x-runtime": "0.023826",
Mar 02 09:57:03 grp-service-01 peertube[3632906]: "content-type": "application/json; charset=utf-8",
Mar 02 09:57:03 grp-service-01 peertube[3632906]: "content-security-policy": "base-uri 'none'; default-src 'none'; frame-ancestors 'none'; font-src 'self' https://mastodon.social; img-src 'self' data: blob: https://mastodon.social https://files.mastodon.social; media-src 'self' data: https://mastodon.social https://files.mastodon.social; manifest-src 'self' https://mastodon.social; form-action 'none'; child-src 'self' blob: https://mastodon.social; worker-src 'self' blob: https://mastodon.social; connect-src 'self' data: blob: https://mastodon.social https://files.mastodon.social wss://streaming.mastodon.social; script-src 'self' https://mastodon.social 'wasm-unsafe-eval'; frame-src 'self' https:; style-src 'self' https://mastodon.social 'nonce-wkddZOvpe1LE1K5g7sLGrw=='",
Mar 02 09:57:03 grp-service-01 peertube[3632906]: "x-frame-options": "DENY",
Mar 02 09:57:03 grp-service-01 peertube[3632906]: "x-content-type-options": "nosniff",
Mar 02 09:57:03 grp-service-01 peertube[3632906]: "cache-control": "max-age=180, public",
Mar 02 09:57:03 grp-service-01 peertube[3632906]: "x-request-id": "154ee1b5-0671-4676-9e3e-65b5090e97a5",
Mar 02 09:57:03 grp-service-01 peertube[3632906]: "via": "1.1 varnish, 1.1 varnish",
Mar 02 09:57:03 grp-service-01 peertube[3632906]: "accept-ranges": "bytes",
Mar 02 09:57:03 grp-service-01 peertube[3632906]: "date": "Mon, 02 Mar 2026 08:57:03 GMT",
Mar 02 09:57:03 grp-service-01 peertube[3632906]: "age": "56",
Mar 02 09:57:03 grp-service-01 peertube[3632906]: "x-served-by": "cache-fra-eddf8230104-FRA, cache-fra-eddf8230127-FRA, cache-par-lfpg1960076-PAR",
Mar 02 09:57:03 grp-service-01 peertube[3632906]: "x-cache": "MISS, HIT, HIT",
Mar 02 09:57:03 grp-service-01 peertube[3632906]: "x-cache-hits": "0, 6, 1",
Mar 02 09:57:03 grp-service-01 peertube[3632906]: "x-timer": "S1772441824.661416,VS0,VE1",
Mar 02 09:57:03 grp-service-01 peertube[3632906]: "vary": "Accept, Accept-Language, Cookie",
Mar 02 09:57:03 grp-service-01 peertube[3632906]: "strict-transport-security": "max-age=31557600",
Mar 02 09:57:03 grp-service-01 peertube[3632906]: "alt-svc": "h3=\":443\";ma=86400,h3-29=\":443\";ma=86400,h3-27=\":443\";ma=86400"
Mar 02 09:57:03 grp-service-01 peertube[3632906]: },
Mar 02 09:57:03 grp-service-01 peertube[3632906]: "statusCode": 410,
Mar 02 09:57:03 grp-service-01 peertube[3632906]: "requestHeaders": {
Mar 02 09:57:03 grp-service-01 peertube[3632906]: "user-agent": "PeerTube/8.0.2 (+https://tube.grap.coop)",
Mar 02 09:57:03 grp-service-01 peertube[3632906]: "date": "Mon, 02 Mar 2026 08:57:03 GMT",
Mar 02 09:57:03 grp-service-01 peertube[3632906]: "accept": "application/activity+json, application/ld+json",
Mar 02 09:57:03 grp-service-01 peertube[3632906]: "accept-encoding": "gzip, deflate, br",
Mar 02 09:57:03 grp-service-01 peertube[3632906]: "host": "mastodon.social",
Mar 02 09:57:03 grp-service-01 peertube[3632906]: "signature": "keyId=\"https://tube.grap.coop/accounts/peertube#main-key\",algorithm=\"rsa-sha256\",headers=\"(request-target) host date\",signature=\"STictGVny4TmVluL7dNjd7nY4b/bXmG/7yPyGOuljmki7sTTkEJssdXspawCVrIZ3AiRJOPy/1nXpFb6y4uxD6gBvjYslIgKl7LF8YExG2vawk8gUj3zRlNZ8UbLTUdPd2Al0pFmKdO2gud3OTwpOED7A2n9YxcrgzaiWVxILE/gJ4AKq4jJeBF5qCwK4SANFxd8Y4oCO2nUsUKSOBNY5Ksq0/XzUzXXFNc/GsS0iXkF+OQBOYOuCwdiDsSPrzG3jiYU7U6Rh9B5o6kyG2zyeCfsEUdkRF8Ya5ieGNtJJZgZCG6HOX8lJwNaeQRtQX697PuvTcrjyyKICy2JdkJszA==\""
Mar 02 09:57:03 grp-service-01 peertube[3632906]: },
Mar 02 09:57:03 grp-service-01 peertube[3632906]: "requestUrl": "https://mastodon.social/ap/users/115705017780116558/following",
Mar 02 09:57:03 grp-service-01 peertube[3632906]: "requestMethod": "GET"
Mar 02 09:57:03 grp-service-01 peertube[3632906]: }
Mar 02 09:57:03 grp-service-01 peertube[3632906]: }