> Build error occurred
Error: Jest worker encountered 1 child process exceptions, exceeding retry limit
    at ChildProcessWorker.initialize (F:\Armani\New folder\armani\node_modules\next\dist\compiled\jest-worker\index.js:1:11580)
    at ChildProcessWorker._onExit (F:\Armani\New folder\armani\node_modules\next\dist\compiled\jest-worker\index.js:1:12545)
    at ChildProcess.emit (node:events:530:35)
    at ChildProcess._handle.onexit (node:internal/child_process:294:12) {
  type: 'WorkerError'
}

import { NextApiRequest } from "next";
import {  promisePool } from "@/lib/db";
import { NextResponse } from "next/server";




export async function GET (req: NextApiRequest){

    try {

        const [rows] = await promisePool.query("SELECT * FROM users");
        // opdrachten contains rows returned by server
        return NextResponse.json(rows);



    } catch (error) {
        console.error('Error fetching challenges:', error);
        return NextResponse.json({error: 'Error fetching challenges:'},{status: 500});


    }
}

import {  promisePool } from "@/lib/db";
import { NextResponse } from "next/server";

export async function GET (req: Request){

    try {

        const [rows] = await promisePool.query("SELECT * FROM users");
        // opdrachten contains rows returned by server
        return NextResponse.json(rows);

    } catch (error) {
        console.error('Error fetching challenges:', error);
        return NextResponse.json({error: 'Error fetching challenges:'},{status: 500});

    }
}

        const [rows] = await promisePool.query("SELECT * FROM users");

import * as mysql2 from 'mysql2';

export const pool = mysql2.createPool({
    host: process.env.DB_HOST,
    user: process.env.DB_USER,
    password: process.env.DB_PASS,
    database: process.env.DB_NAME,
    connectionLimit: 10,
    idleTimeout: 60000,
});

export const promisePool = pool.promise();