Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1ltpFi-0005e0-AF for pgadmin-hackers@arkaria.postgresql.org; Thu, 17 Jun 2021 10:28:02 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1ltpFh-0002pj-8w for pgadmin-hackers@arkaria.postgresql.org; Thu, 17 Jun 2021 10:28:01 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1ltpFg-0002pb-VQ for pgadmin-hackers@lists.postgresql.org; Thu, 17 Jun 2021 10:28:01 +0000 Received: from mail-lf1-x135.google.com ([2a00:1450:4864:20::135]) by makus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.92) (envelope-from ) id 1ltpFe-0001fW-Ey for pgadmin-hackers@postgresql.org; Thu, 17 Jun 2021 10:27:59 +0000 Received: by mail-lf1-x135.google.com with SMTP id p17so9642607lfc.6 for ; Thu, 17 Jun 2021 03:27:58 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=enterprisedb-com.20150623.gappssmtp.com; s=20150623; h=mime-version:from:date:message-id:subject:to; bh=tFq7VdUSyftg63Vl+vRgHPlR0Mi5Oa1eK5P6u0hzZMA=; b=Yy1aEXcwj28YVJD8AqcQY6jf/cce20d0uDbJLWKyYMwPCF96k8I6PoEZhcP370bGXJ unxHj98yR6ZPBsuEgXGHraT2krBohzzzrw8YUoey2dI5CZ0ayMAIer8Ietkg4dRnCjMi JF2Vd3+eohYpHH/kqb2f/qgz2Vg15J7pF+C5OUkR8R+SUKI5OMuX/U7t+oVIH6MH2qya uXrnEfZzGMFO69cQf6FytaMlHkH4hg7JwQSv64C4+2G0aAxtpW/s+au75ILrZgohYvxL cnEGEIW2EqQLjCDLSQmNkF/Rd33tTyWRqCeNrEVVEshT1JCf7pC3Q8Z5uNi34mJz5X9C zJ7A== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20161025; h=x-gm-message-state:mime-version:from:date:message-id:subject:to; bh=tFq7VdUSyftg63Vl+vRgHPlR0Mi5Oa1eK5P6u0hzZMA=; b=ebYBEwYPQcbnGICUO7X6wiyp6mWpDfnOSutHWN464JagirSpmqfkGPd7BP7IkyVwi2 ICrJmdJ569DDA7zxjx/5KoQx3YYS3A+7PJX0kHYY/yO+o3+TkARebvdsXy3m6w/dMMg6 DsmXhGe2Pwg51rf/RjOis1cLFdGdeA0jUJ1ZspJKYQRVGF9FNFP4vwr7w4KfiKDtwe/D utmkpgf40jltMUxAY1BUq88Pw4uG8s1LSXGqKJQBCCiujCr+Wc0dT9Lg9hlSHhn5mdzE KTx6nNUq6feazsT8fmmqG+ndi4QxrhjveYMhD/hTFw07PntLcf/5Uaod+F/oujPOBsB8 pYxw== X-Gm-Message-State: AOAM531XkDd3UAraZftGelYDk+yKR0l4bXy09mHULwU1o+NoZpqDA5sF M7HMCGrqbvrpPxxIm/p0xw5ANdNSXhgYNTRfOPparvn29UMBaBI9xRYZeTyI1OP5lGqZQrit9ya /ZTCmffTmKUbor0GdfB+SchsFlQxPaafWpx309YfKfHCKpPPfxbVyXzeWGjs24S4lVE8AIhkl6G wHR8Pcso8syFqssIdPsEnFhF+eZ7GiOsiyrekFkOKemGwpbFYQdpkgIS4K1LOoCcTaeQ== X-Google-Smtp-Source: ABdhPJzlz+pWd55FPvpgAuHEU9QRd4etINDDdoiQFHlTGz5dP4trTxct7FElFRWn/EweePCBGN3wD1M8qK57X8tfiG4= X-Received: by 2002:ac2:504b:: with SMTP id a11mr3485318lfm.509.1623925676492; Thu, 17 Jun 2021 03:27:56 -0700 (PDT) MIME-Version: 1.0 From: Khushboo Vashi Date: Thu, 17 Jun 2021 15:57:44 +0530 Message-ID: Subject: [pgAdmin4][Patch] - Test cases failure fix To: pgadmin-hackers Content-Type: multipart/mixed; boundary="000000000000177b0a05c4f3a9d2" X-CLOUD-SEC-AV-Info: enterprisedb,google_mail,monitor X-CLOUD-SEC-AV-Sent: true X-Gm-Spam: 0 X-Gm-Phishy: 0 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --000000000000177b0a05c4f3a9d2 Content-Type: multipart/alternative; boundary="000000000000177b0705c4f3a9d0" --000000000000177b0705c4f3a9d0 Content-Type: text/plain; charset="UTF-8" Hi, Please find the attached patch to fix the test cases failure due to below error on PG 9.6. psycopg2.errors.ObjectInUse: database "test_db_1658f" is being accessed by other users DETAIL: There is 1 other session using the database. Thanks, Khushboo --000000000000177b0705c4f3a9d0 Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable
Hi,

Please find the attached patch to f= ix the test cases failure due to below error on PG 9.6.
psycopg2.errors.ObjectInUse: database "test_db_1658f" is =
being accessed by other users
DETAIL:  Ther=
e is 1 other session using the database.
Thanks,
Khushbo= o

--000000000000177b0705c4f3a9d0-- --000000000000177b0a05c4f3a9d2 Content-Type: application/octet-stream; name="api_test_cases_failure_fixes.patch" Content-Disposition: attachment; filename="api_test_cases_failure_fixes.patch" Content-Transfer-Encoding: base64 Content-ID: X-Attachment-Id: f_kq0rbvvq0 ZGlmZiAtLWdpdCBhL3dlYi9wZ2FkbWluL2Jyb3dzZXIvc2VydmVyX2dyb3Vwcy9zZXJ2ZXJzL2Rh dGFiYXNlcy9zY2hlbWFzL3RhYmxlcy9jb25zdHJhaW50cy9jaGVja19jb25zdHJhaW50L19faW5p dF9fLnB5IGIvd2ViL3BnYWRtaW4vYnJvd3Nlci9zZXJ2ZXJfZ3JvdXBzL3NlcnZlcnMvZGF0YWJh c2VzL3NjaGVtYXMvdGFibGVzL2NvbnN0cmFpbnRzL2NoZWNrX2NvbnN0cmFpbnQvX19pbml0X18u cHkKaW5kZXggMjY5MmJjMDI2Li4xNjFiYzllMGUgMTAwNjQ0Ci0tLSBhL3dlYi9wZ2FkbWluL2Jy b3dzZXIvc2VydmVyX2dyb3Vwcy9zZXJ2ZXJzL2RhdGFiYXNlcy9zY2hlbWFzL3RhYmxlcy9jb25z dHJhaW50cy9jaGVja19jb25zdHJhaW50L19faW5pdF9fLnB5CisrKyBiL3dlYi9wZ2FkbWluL2Jy b3dzZXIvc2VydmVyX2dyb3Vwcy9zZXJ2ZXJzL2RhdGFiYXNlcy9zY2hlbWFzL3RhYmxlcy9jb25z dHJhaW50cy9jaGVja19jb25zdHJhaW50L19faW5pdF9fLnB5CkBAIC0yMjgsOCArMjI4LDcgQEAg Y2xhc3MgQ2hlY2tDb25zdHJhaW50VmlldyhQR0NoaWxkTm9kZVZpZXcpOgogICAgICAgICBSZXR1 cm5zOgogCiAgICAgICAgICIiIgotICAgICAgICBTUUwgPSAiRU5EOyIKLSAgICAgICAgc2VsZi5j b25uLmV4ZWN1dGVfc2NhbGFyKFNRTCkKKyAgICAgICAgc2VsZi5jb25uLmV4ZWN1dGVfdm9pZCgi RU5EOyIpCiAKICAgICBAY2hlY2tfcHJlY29uZGl0aW9uCiAgICAgZGVmIGxpc3Qoc2VsZiwgZ2lk LCBzaWQsIGRpZCwgc2NpZCwgdGlkLCBjaWQ9Tm9uZSk6CkBAIC01MzYsOCArNTM1LDkgQEAgY2xh c3MgQ2hlY2tDb25zdHJhaW50VmlldyhQR0NoaWxkTm9kZVZpZXcpOgogICAgICAgICAgICAgaWYg J25hbWUnIG5vdCBpbiBkYXRhIG9yIGRhdGFbJ25hbWUnXSA9PSAiIjoKICAgICAgICAgICAgICAg ICBzcWwgPSAiQkVHSU47IgogICAgICAgICAgICAgICAgICMgU3RhcnQgdHJhbnNhY3Rpb24uCi0g ICAgICAgICAgICAgICAgc3RhdHVzLCByZXMgPSBzZWxmLmNvbm4uZXhlY3V0ZV9zY2FsYXIoc3Fs KQorICAgICAgICAgICAgICAgIHN0YXR1cywgcmVzID0gc2VsZi5jb25uLmV4ZWN1dGVfdm9pZChz cWwpCiAgICAgICAgICAgICAgICAgaWYgbm90IHN0YXR1czoKKyAgICAgICAgICAgICAgICAgICAg c2VsZi5jb25uLmV4ZWN1dGVfdm9pZCgnUk9MTEJBQ0s7JykKICAgICAgICAgICAgICAgICAgICAg c2VsZi5lbmRfdHJhbnNhY3Rpb24oKQogICAgICAgICAgICAgICAgICAgICByZXR1cm4gaW50ZXJu YWxfc2VydmVyX2Vycm9yKGVycm9ybXNnPXJlcykKIApAQCAtNTQ5LDYgKzU0OSw3IEBAIGNsYXNz IENoZWNrQ29uc3RyYWludFZpZXcoUEdDaGlsZE5vZGVWaWV3KToKIAogICAgICAgICAgICAgc3Rh dHVzLCBtc2cgPSBzZWxmLmNvbm4uZXhlY3V0ZV9zY2FsYXIoc3FsKQogICAgICAgICAgICAgaWYg bm90IHN0YXR1czoKKyAgICAgICAgICAgICAgICBzZWxmLmNvbm4uZXhlY3V0ZV92b2lkKCdST0xM QkFDSzsnKQogICAgICAgICAgICAgICAgIHNlbGYuZW5kX3RyYW5zYWN0aW9uKCkKICAgICAgICAg ICAgICAgICByZXR1cm4gaW50ZXJuYWxfc2VydmVyX2Vycm9yKGVycm9ybXNnPW1zZykKIApAQCAt NTYxLDYgKzU2Miw3IEBAIGNsYXNzIENoZWNrQ29uc3RyYWludFZpZXcoUEdDaGlsZE5vZGVWaWV3 KToKIAogICAgICAgICAgICAgICAgIHN0YXR1cywgcmVzID0gc2VsZi5jb25uLmV4ZWN1dGVfZGlj dChzcWwpCiAgICAgICAgICAgICAgICAgaWYgbm90IHN0YXR1czoKKyAgICAgICAgICAgICAgICAg ICAgc2VsZi5jb25uLmV4ZWN1dGVfdm9pZCgnUk9MTEJBQ0s7JykKICAgICAgICAgICAgICAgICAg ICAgc2VsZi5lbmRfdHJhbnNhY3Rpb24oKQogICAgICAgICAgICAgICAgICAgICByZXR1cm4gaW50 ZXJuYWxfc2VydmVyX2Vycm9yKGVycm9ybXNnPXJlcykKIApAQCAtNTc2LDYgKzU3OCw3IEBAIGNs YXNzIENoZWNrQ29uc3RyYWludFZpZXcoUEdDaGlsZE5vZGVWaWV3KToKICAgICAgICAgICAgICAg ICApCiAgICAgICAgICAgICAgICAgc3RhdHVzLCByZXMgPSBzZWxmLmNvbm4uZXhlY3V0ZV9kaWN0 KHNxbCkKICAgICAgICAgICAgICAgICBpZiBub3Qgc3RhdHVzOgorICAgICAgICAgICAgICAgICAg ICBzZWxmLmNvbm4uZXhlY3V0ZV92b2lkKCdST0xMQkFDSzsnKQogICAgICAgICAgICAgICAgICAg ICBzZWxmLmVuZF90cmFuc2FjdGlvbigpCiAgICAgICAgICAgICAgICAgICAgIHJldHVybiBpbnRl cm5hbF9zZXJ2ZXJfZXJyb3IoZXJyb3Jtc2c9cmVzKQogCkBAIC01OTIsNiArNTk1LDcgQEAgY2xh c3MgQ2hlY2tDb25zdHJhaW50VmlldyhQR0NoaWxkTm9kZVZpZXcpOgogICAgICAgICAgICAgKQog CiAgICAgICAgIGV4Y2VwdCBFeGNlcHRpb24gYXMgZToKKyAgICAgICAgICAgIHNlbGYuY29ubi5l eGVjdXRlX3ZvaWQoJ1JPTExCQUNLOycpCiAgICAgICAgICAgICBzZWxmLmVuZF90cmFuc2FjdGlv bigpCiAgICAgICAgICAgICByZXR1cm4gbWFrZV9qc29uX3Jlc3BvbnNlKAogICAgICAgICAgICAg ICAgIHN0YXR1cz00MDAsCmRpZmYgLS1naXQgYS93ZWIvcGdhZG1pbi9icm93c2VyL3NlcnZlcl9n cm91cHMvc2VydmVycy9kYXRhYmFzZXMvc2NoZW1hcy90YWJsZXMvY29uc3RyYWludHMvY2hlY2tf Y29uc3RyYWludC90ZXN0cy9jaGVja19jb25zdHJhaW50X3Rlc3RfZGF0YS5qc29uIGIvd2ViL3Bn YWRtaW4vYnJvd3Nlci9zZXJ2ZXJfZ3JvdXBzL3NlcnZlcnMvZGF0YWJhc2VzL3NjaGVtYXMvdGFi bGVzL2NvbnN0cmFpbnRzL2NoZWNrX2NvbnN0cmFpbnQvdGVzdHMvY2hlY2tfY29uc3RyYWludF90 ZXN0X2RhdGEuanNvbgppbmRleCAyOGRlYmFmMzMuLjVmOGRkN2Y1ZiAxMDA2NDQKLS0tIGEvd2Vi L3BnYWRtaW4vYnJvd3Nlci9zZXJ2ZXJfZ3JvdXBzL3NlcnZlcnMvZGF0YWJhc2VzL3NjaGVtYXMv dGFibGVzL2NvbnN0cmFpbnRzL2NoZWNrX2NvbnN0cmFpbnQvdGVzdHMvY2hlY2tfY29uc3RyYWlu dF90ZXN0X2RhdGEuanNvbgorKysgYi93ZWIvcGdhZG1pbi9icm93c2VyL3NlcnZlcl9ncm91cHMv c2VydmVycy9kYXRhYmFzZXMvc2NoZW1hcy90YWJsZXMvY29uc3RyYWludHMvY2hlY2tfY29uc3Ry YWludC90ZXN0cy9jaGVja19jb25zdHJhaW50X3Rlc3RfZGF0YS5qc29uCkBAIC00NjksNyArNDY5 LDcgQEAKICAgICAgIH0sCiAgICAgICAibW9ja2luZ19yZXF1aXJlZCI6IHRydWUsCiAgICAgICAi bW9ja19kYXRhIjogewotICAgICAgICAiZnVuY3Rpb25fbmFtZSI6ICJwZ2FkbWluLnV0aWxzLmRy aXZlci5wc3ljb3BnMi5jb25uZWN0aW9uLkNvbm5lY3Rpb24uZXhlY3V0ZV9zY2FsYXIiLAorICAg ICAgICAiZnVuY3Rpb25fbmFtZSI6ICJwZ2FkbWluLnV0aWxzLmRyaXZlci5wc3ljb3BnMi5jb25u ZWN0aW9uLkNvbm5lY3Rpb24uZXhlY3V0ZV92b2lkIiwKICAgICAgICAgInJldHVybl92YWx1ZSI6 ICIoRmFsc2UsJ01vY2tlZCBJbnRlcm5hbCBTZXJ2ZXIgRXJyb3InKSIKICAgICAgIH0sCiAgICAg ICAiZXhwZWN0ZWRfZGF0YSI6IHsKQEAgLTU0Nyw3ICs1NDcsNyBAQAogICAgICAgInRlc3RfZGF0 YSI6IHt9LAogICAgICAgIm1vY2tpbmdfcmVxdWlyZWQiOiB0cnVlLAogICAgICAgIm1vY2tfZGF0 YSI6IHsKLSAgICAgICAgImZ1bmN0aW9uX25hbWUiOiAicGdhZG1pbi51dGlscy5kcml2ZXIucHN5 Y29wZzIuY29ubmVjdGlvbi5Db25uZWN0aW9uLmV4ZWN1dGVfc2NhbGFyIiwKKyAgICAgICAgImZ1 bmN0aW9uX25hbWUiOiAicGdhZG1pbi51dGlscy5kcml2ZXIucHN5Y29wZzIuY29ubmVjdGlvbi5D b25uZWN0aW9uLmV4ZWN1dGVfdm9pZCIsCiAgICAgICAgICJyZXR1cm5fdmFsdWUiOiAiKEZhbHNl LCdNb2NrZWQgSW50ZXJuYWwgU2VydmVyIEVycm9yJykiCiAgICAgICB9LAogICAgICAgImV4cGVj dGVkX2RhdGEiOiB7Cg== --000000000000177b0a05c4f3a9d2--