Problem with first connection to database

Hi i created cront task app in js and i use prisma in in to save some data and log to database, and i have problem with first connection to database,

i set my app to retry tast so i know that when i run same task second time it works fine without error...

i added to my connection string

?schema=public&connect_timeout=30&pool_timeout=30&socket_timeout=30

and on app first run i added

const { prisma, initializePrisma } = require("./constants/prisma");
const { ErrorType } = require("./constants/enums");
const dbLogger = require("./utils/dbLogger");

async function startServer() {
  try {
    await initializePrisma();

const { prisma, initializePrisma } = require("./constants/prisma");
const { ErrorType } = require("./constants/enums");
const dbLogger = require("./utils/dbLogger");

async function startServer() {
  try {
    await initializePrisma();

and this is my prisma.js

const { PrismaClient } = require('@prisma/client');

const prisma = new PrismaClient();

async function initializePrisma() {
    await prisma.$connect();
}

module.exports = { prisma, initializePrisma };

const { PrismaClient } = require('@prisma/client');

const prisma = new PrismaClient();

async function initializePrisma() {
    await prisma.$connect();
}

module.exports = { prisma, initializePrisma };

Solution

    if (updatedProductsData.length !== 0) {
      for (let product of updatedProductsData) {
        promises.push(
          prisma.Product.updateMany({
// some code
            },
          })
        );
      }
    }

    if (updatedProductsData.length !== 0) {
      for (let product of updatedProductsData) {
        promises.push(
          prisma.Product.updateMany({
// some code
            },
          })
        );
      }
    }

Jump to solution

Prisma•2y ago•

30 replies

Borcio

Problem with first connection to database

const { prisma, initializePrisma } = require("./constants/prisma");
const { ErrorType } = require("./constants/enums");
const dbLogger = require("./utils/dbLogger");

async function startServer() {
  try {
    await initializePrisma();

const { prisma, initializePrisma } = require("./constants/prisma");
const { ErrorType } = require("./constants/enums");
const dbLogger = require("./utils/dbLogger");

async function startServer() {
  try {
    await initializePrisma();

and this is my prisma.js

const { PrismaClient } = require('@prisma/client');

const prisma = new PrismaClient();

async function initializePrisma() {
    await prisma.$connect();
}

module.exports = { prisma, initializePrisma };

const { PrismaClient } = require('@prisma/client');

const prisma = new PrismaClient();

async function initializePrisma() {
    await prisma.$connect();
}

module.exports = { prisma, initializePrisma };

Solution

    if (updatedProductsData.length !== 0) {
      for (let product of updatedProductsData) {
        promises.push(
          prisma.Product.updateMany({
// some code
            },
          })
        );
      }
    }

    if (updatedProductsData.length !== 0) {
      for (let product of updatedProductsData) {
        promises.push(
          prisma.Product.updateMany({
// some code
            },
          })
        );
      }
    }

Jump to solution

Problem with first connection to database

Similar Threads

Problem with first connection to database

Similar Threads

Similar Threads

Similar Threads