Jellyton Posts - Answer Overflow

Jellyton

Explore posts from servers

SIASapphire - Imagine a framework PPrisma

•Created by Jellyton on 4/30/2024 in #help-and-questions

Health Check of Query Engine timed out.

Hello there, I've been using Prisma for a bit now and I decided today to setup Prisma Accelerate. I'm using a mariadb (mysql) server and I've successfully setup accelerate, however, when queries that worked before accelerate are run, they error. Error + Logging:

prisma:client clientVersion 5.13.0 +0ms
prisma:warn In production, we recommend using `prisma generate --no-engine` (See: `prisma generate --help`)
prisma:client Prisma Client call: +459ms
prisma:client prisma.mdt_incidents.findUnique({
  where: {
    id: 13211
  }
}) +1ms
prisma:client Generated request: +0ms
prisma:client {
  "modelName": "mdt_incidents",
  "action": "findUnique",
  "query": {
    "arguments": {
      "where": {
        "id": 13211
      }
    },
    "selection": {
      "$composites": true,
      "$scalars": true
    }
  }
}
 +1ms
 ⨯ PrismaClientKnownRequestError: 
Invalid `prisma.mdt_incidents.findUnique()` invocation:


This request could not be understood by the server: {"type":"UnknownJsonError","body":{"code":"P6008","message":"Accelerate was not able to connect to your database. The underlying error is: Health Check of Query Engine timed out."}} (The request id was: 87c55c720a5eeb77)

prisma:client clientVersion 5.13.0 +0ms
prisma:warn In production, we recommend using `prisma generate --no-engine` (See: `prisma generate --help`)
prisma:client Prisma Client call: +459ms
prisma:client prisma.mdt_incidents.findUnique({
  where: {
    id: 13211
  }
}) +1ms
prisma:client Generated request: +0ms
prisma:client {
  "modelName": "mdt_incidents",
  "action": "findUnique",
  "query": {
    "arguments": {
      "where": {
        "id": 13211
      }
    },
    "selection": {
      "$composites": true,
      "$scalars": true
    }
  }
}
 +1ms
 ⨯ PrismaClientKnownRequestError: 
Invalid `prisma.mdt_incidents.findUnique()` invocation:


This request could not be understood by the server: {"type":"UnknownJsonError","body":{"code":"P6008","message":"Accelerate was not able to connect to your database. The underlying error is: Health Check of Query Engine timed out."}} (The request id was: 87c55c720a5eeb77)

3 replies

SIASapphire - Imagine a framework

•Created by Jellyton on 12/7/2023 in #sapphire-support

Seemingly Random Command Registration Failures

Hello there, I created a basic command, however whenever the bot refreshes, the command registration almost always fails. And this most recent time, the command registered, and then after a refresh, it failed to register again. Error:

2023-12-07 22:42:52 - ERROR - ApplicationCommandRegistries(BulkOverwrite) Failed to overwrite global application commands DiscordAPIError[50035]: Invalid Form Body
2023-12-07 22:42:52 - ERROR - 0.name[STRING_TYPE_REGEX]: String value did not match validation regex.
2023-12-07 22:42:52 - ERROR -     at handleErrors (/home/ubuntu/bots/ef-bot/node_modules/.pnpm/@discordjs+rest@2.2.0/node_modules/@discordjs/rest/dist/index.js:722:13)
2023-12-07 22:42:52 - ERROR -     at process.processTicksAndRejections (node:internal/process/task_queues:95:5)
2023-12-07 22:42:52 - ERROR -     at async SequentialHandler.runRequest (/home/ubuntu/bots/ef-bot/node_modules/.pnpm/@discordjs+rest@2.2.0/node_modules/@discordjs/rest/dist/index.js:1120:23)
2023-12-07 22:42:52 - ERROR -     at async SequentialHandler.queueRequest (/home/ubuntu/bots/ef-bot/node_modules/.pnpm/@discordjs+rest@2.2.0/node_modules/@discordjs/rest/dist/index.js:953:14)
2023-12-07 22:42:52 - ERROR -     at async _REST.request (/home/ubuntu/bots/ef-bot/node_modules/.pnpm/@discordjs+rest@2.2.0/node_modules/@discordjs/rest/dist/index.js:1266:22)
2023-12-07 22:42:52 - ERROR -     at async ApplicationCommandManager.set (/home/ubuntu/bots/ef-bot/node_modules/.pnpm/discord.js@14.14.1/node_modules/discord.js/src/managers/ApplicationCommandManager.js:171:18)
2023-12-07 22:42:52 - ERROR -     at async handleBulkOverwrite (/home/ubuntu/bots/ef-bot/node_modules/.pnpm/@sapphire+framework@4.8.2/node_modules/@sapphire/framework/dist/lib/utils/application-commands/ApplicationCommandRegistries.js:82:20)
2023-12-07 22:42:52 - ERROR -     at async Object.handleRegistryAPICalls (/home/ubuntu/bots/ef-bot/node_modules/.pnpm/@sapphire+framework@4.8.2/node_modules/@sapphire/framework/dist/lib/utils/application-commands/ApplicationCommandRegistries.js:56:5)
2023-12-07 22:42:52 - ERROR -     at async _CoreListener.run (/home/ubuntu/bots/ef-bot/node_modules/.pnpm/@sapphire+framework@4.8.2/node_modules/@sapphire/framework/dist/listeners/CoreReady.js:17:5)
2023-12-07 22:42:52 - ERROR -     at async Object.fromAsync (/home/ubuntu/bots/ef-bot/node_modules/.pnpm/@sapphire+result@2.6.4/node_modules/@sapphire/result/dist/index.js:613:22) {
2023-12-07 22:42:52 - ERROR -   requestBody: [Object],
2023-12-07 22:42:52 - ERROR -   rawError: [Object],
2023-12-07 22:42:52 - ERROR -   code: 50035,
2023-12-07 22:42:52 - ERROR -   status: 400,
2023-12-07 22:42:52 - ERROR -   method: 'PUT',
2023-12-07 22:42:52 - ERROR -   url: 'https://discord.com/api/v10/applications/1021449455628718120/commands'
2023-12-07 22:42:52 - ERROR - }

2023-12-07 22:42:52 - ERROR - ApplicationCommandRegistries(BulkOverwrite) Failed to overwrite global application commands DiscordAPIError[50035]: Invalid Form Body
2023-12-07 22:42:52 - ERROR - 0.name[STRING_TYPE_REGEX]: String value did not match validation regex.
2023-12-07 22:42:52 - ERROR -     at handleErrors (/home/ubuntu/bots/ef-bot/node_modules/.pnpm/@discordjs+rest@2.2.0/node_modules/@discordjs/rest/dist/index.js:722:13)
2023-12-07 22:42:52 - ERROR -     at process.processTicksAndRejections (node:internal/process/task_queues:95:5)
2023-12-07 22:42:52 - ERROR -     at async SequentialHandler.runRequest (/home/ubuntu/bots/ef-bot/node_modules/.pnpm/@discordjs+rest@2.2.0/node_modules/@discordjs/rest/dist/index.js:1120:23)
2023-12-07 22:42:52 - ERROR -     at async SequentialHandler.queueRequest (/home/ubuntu/bots/ef-bot/node_modules/.pnpm/@discordjs+rest@2.2.0/node_modules/@discordjs/rest/dist/index.js:953:14)
2023-12-07 22:42:52 - ERROR -     at async _REST.request (/home/ubuntu/bots/ef-bot/node_modules/.pnpm/@discordjs+rest@2.2.0/node_modules/@discordjs/rest/dist/index.js:1266:22)
2023-12-07 22:42:52 - ERROR -     at async ApplicationCommandManager.set (/home/ubuntu/bots/ef-bot/node_modules/.pnpm/discord.js@14.14.1/node_modules/discord.js/src/managers/ApplicationCommandManager.js:171:18)
2023-12-07 22:42:52 - ERROR -     at async handleBulkOverwrite (/home/ubuntu/bots/ef-bot/node_modules/.pnpm/@sapphire+framework@4.8.2/node_modules/@sapphire/framework/dist/lib/utils/application-commands/ApplicationCommandRegistries.js:82:20)
2023-12-07 22:42:52 - ERROR -     at async Object.handleRegistryAPICalls (/home/ubuntu/bots/ef-bot/node_modules/.pnpm/@sapphire+framework@4.8.2/node_modules/@sapphire/framework/dist/lib/utils/application-commands/ApplicationCommandRegistries.js:56:5)
2023-12-07 22:42:52 - ERROR -     at async _CoreListener.run (/home/ubuntu/bots/ef-bot/node_modules/.pnpm/@sapphire+framework@4.8.2/node_modules/@sapphire/framework/dist/listeners/CoreReady.js:17:5)
2023-12-07 22:42:52 - ERROR -     at async Object.fromAsync (/home/ubuntu/bots/ef-bot/node_modules/.pnpm/@sapphire+result@2.6.4/node_modules/@sapphire/result/dist/index.js:613:22) {
2023-12-07 22:42:52 - ERROR -   requestBody: [Object],
2023-12-07 22:42:52 - ERROR -   rawError: [Object],
2023-12-07 22:42:52 - ERROR -   code: 50035,
2023-12-07 22:42:52 - ERROR -   status: 400,
2023-12-07 22:42:52 - ERROR -   method: 'PUT',
2023-12-07 22:42:52 - ERROR -   url: 'https://discord.com/api/v10/applications/1021449455628718120/commands'
2023-12-07 22:42:52 - ERROR - }

Code:

import { ApplyOptions } from '@sapphire/decorators';
import { Command } from '@sapphire/framework';
import { ApplicationCommandType } from 'discord.js';

@ApplyOptions<Command.Options>({
    description: 'Send the bug report template message to the user.'
})
export class UserCommand extends Command {
    public constructor(context: Command.LoaderContext, options: Command.Options) {
        super(context, { ...options });
    }

    public override registerApplicationCommands(registry: Command.Registry) {
        registry.registerContextMenuCommand((builder) =>
            builder //
                .setName('bugtemplate')
                .setType(ApplicationCommandType.Message)
        );
    }

    // context menu command
    public async contextMenuRun(interaction: Command.ContextMenuCommandInteraction) {
        return await interaction.reply({ content: 'Hello', fetchReply: true });
    }
}

import { ApplyOptions } from '@sapphire/decorators';
import { Command } from '@sapphire/framework';
import { ApplicationCommandType } from 'discord.js';

@ApplyOptions<Command.Options>({
    description: 'Send the bug report template message to the user.'
})
export class UserCommand extends Command {
    public constructor(context: Command.LoaderContext, options: Command.Options) {
        super(context, { ...options });
    }

    public override registerApplicationCommands(registry: Command.Registry) {
        registry.registerContextMenuCommand((builder) =>
            builder //
                .setName('bugtemplate')
                .setType(ApplicationCommandType.Message)
        );
    }

    // context menu command
    public async contextMenuRun(interaction: Command.ContextMenuCommandInteraction) {
        return await interaction.reply({ content: 'Hello', fetchReply: true });
    }
}

7 replies

Gaming

Programming