Creating a duplicate database object for the same connection

[maximbashevoy]

After repeatedly running a test with a call to cy.task("dbQuery"... I get warnings:

WARNING: Creating a duplicate database object for the same connection.
    at module.exports (e2e-tests/node_modules/cypress-postgres/cypress/plugins/index.js:21:14)
    at dbQuery (/e2e-tests/cypress/plugins/index.js:24:29)
    at invoke (/Cypress.app/Contents/Resources/app/packages/server/lib/plugins/child/task.js:41:14)

Is it to do with the way dbQuery task is added in plugins? Any advice?

[dhalawa-bread]

I'm facing the same . Is there anyway to fix it ?

[kawadesoni]

const db = pgp(connection);
let response = db.any(query);
pgp.end();
return response;
Above changes needs to be added to the index.js
After reading DB, close the connection before returning.

[KleisKlasKluss]

I'm facing the same issue too.

In my plugins/index.js file I have

const postgres = require('cypress-postgres');

module.exports = (on, config) => {
    on('task', {
        dbQuery: query => postgres(query.query, query.connection),
    });
}

When I run tests using the task dbQuery I get this in terminal:

WARNING: Creating a duplicate database object for the same connection.
    at module.exports (/Users/<username>/<path>/node_modules/cypress-postgres/cypress/plugins/index.js:21:14)
    at dbQuery (/Users/<username>/<path>/tests/cypress/plugins/index.js:39:27)
    at invoke (/Users/<username>/Library/Caches/Cypress/6.9.1/Cypress.app/Contents/Resources/app/packages/server/lib/plugins/child/task.js:47:14)

[nurbashanghai]

I'm facing the same issue too.

In my plugins/index.js file I have

const postgres = require('cypress-postgres');

module.exports = (on, config) => {
    on('task', {
        dbQuery: query => postgres(query.query, query.connection),
    });
}

When I run tests using the task dbQuery I get this in terminal:

WARNING: Creating a duplicate database object for the same connection.
    at module.exports (/Users/<username>/<path>/node_modules/cypress-postgres/cypress/plugins/index.js:21:14)
    at dbQuery (/Users/<username>/<path>/tests/cypress/plugins/index.js:39:27)
    at invoke (/Users/<username>/Library/Caches/Cypress/6.9.1/Cypress.app/Contents/Resources/app/packages/server/lib/plugins/child/task.js:47:14)

hey man! did u manage to solve it? Im facing this issue right now

[KleisKlasKluss]

I'm facing the same issue too.
In my plugins/index.js file I have

const postgres = require('cypress-postgres');

module.exports = (on, config) => {
    on('task', {
        dbQuery: query => postgres(query.query, query.connection),
    });
}

When I run tests using the task dbQuery I get this in terminal:

WARNING: Creating a duplicate database object for the same connection.
    at module.exports (/Users/<username>/<path>/node_modules/cypress-postgres/cypress/plugins/index.js:21:14)
    at dbQuery (/Users/<username>/<path>/tests/cypress/plugins/index.js:39:27)
    at invoke (/Users/<username>/Library/Caches/Cypress/6.9.1/Cypress.app/Contents/Resources/app/packages/server/lib/plugins/child/task.js:47:14)

hey man! did u manage to solve it? Im facing this issue right now

Sorry, I didn't manage to fix it... Please let me know if you find a working solution 😄

[kawadesoni]

Yes i did.. have forked ur proj and raised a PR too

…

On Mon, 1 Nov 2021, 9:53 pm Klas Idar Langø-Larsen, < ***@***.***> wrote: I'm facing the same issue too. In my plugins/index.js file I have const postgres = require('cypress-postgres'); module.exports = (on, config) => { on('task', { dbQuery: query => postgres(query.query, query.connection), }); } When I run tests using the task dbQuery I get this in terminal: WARNING: Creating a duplicate database object for the same connection. at module.exports (/Users/<username>/<path>/node_modules/cypress-postgres/cypress/plugins/index.js:21:14) at dbQuery (/Users/<username>/<path>/tests/cypress/plugins/index.js:39:27) at invoke (/Users/<username>/Library/Caches/Cypress/6.9.1/Cypress.app/Contents/Resources/app/packages/server/lib/plugins/child/task.js:47:14) hey man! did u manage to solve it? Im facing this issue right now Sorry, I didn't manage to fix it... Please let me know if you find a working solution 😄 — You are receiving this because you commented. Reply to this email directly, view it on GitHub <#2 (comment)>, or unsubscribe <https://github.com/notifications/unsubscribe-auth/AG6RBZZNZHTLNV6YDETSTW3UJZWR3ANCNFSM4ROWCPFQ> . Triage notifications on the go with GitHub Mobile for iOS <https://apps.apple.com/app/apple-store/id1477376905?ct=notification-email&mt=8&pt=524675> or Android <https://play.google.com/store/apps/details?id=com.github.android&referrer=utm_campaign%3Dnotification-email%26utm_medium%3Demail%26utm_source%3Dgithub>.

[nurbashanghai]

I'm facing the same issue too.
In my plugins/index.js file I have

const postgres = require('cypress-postgres');

module.exports = (on, config) => {
    on('task', {
        dbQuery: query => postgres(query.query, query.connection),
    });
}

When I run tests using the task dbQuery I get this in terminal:

WARNING: Creating a duplicate database object for the same connection.
    at module.exports (/Users/<username>/<path>/node_modules/cypress-postgres/cypress/plugins/index.js:21:14)
    at dbQuery (/Users/<username>/<path>/tests/cypress/plugins/index.js:39:27)
    at invoke (/Users/<username>/Library/Caches/Cypress/6.9.1/Cypress.app/Contents/Resources/app/packages/server/lib/plugins/child/task.js:47:14)

hey man! did u manage to solve it? Im facing this issue right now

Sorry, I didn't manage to fix it... Please let me know if you find a working solution 😄

const pgp = require('pg-promise')();
const postgressConfig = require(require('path').resolve('cypress.json'));

function dbConnection (query,userDefineConnection)  {
  let connection = postgressConfig.db
  if (userDefineConnection!=undefined){
    connection=userDefineConnection
  }
  const db = pgp(connection);
  return db.any(query).finally(db.$pool.end)
}

// import cppg from 'cypress-postgres';
 module.exports = on => {
   on("task", {
       dbQuery:(query)=> dbConnection(query.query,query.connection)
   });

};

I tried this one, and it works perfect. No warnings or errors. U can use pg-promise directly rather than cypress-postgres, because if u check source code of cypress-posgtres it also uses pg-promise under the hood

[KleisKlasKluss]

Thanks @nurbashanghai - worked like a charm! 🚀 🥳